Revision 1c77d03f
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/Controller/CustomerVendorTurnover.pm | ||
|---|---|---|
|
use SL::DB::AccTransaction;
|
||
|
use SL::DB::Invoice;
|
||
|
use SL::DB::Order;
|
||
|
use SL::DB::Order::TypeData qw(:types);
|
||
|
use SL::DB::EmailJournal;
|
||
|
use SL::DB::Letter;
|
||
|
use SL::DB;
|
||
| ... | ... | |
|
$orders = SL::DB::Manager::Order->get_all(
|
||
|
query => [
|
||
|
customer_id => $cv,
|
||
|
quotation => ($type eq 'quotation' ? 'T' : 'F')
|
||
|
record_type => ($type eq 'quotation' ? SALES_QUOTATION_TYPE() : SALES_ORDER_TYPE())
|
||
|
],
|
||
|
sort_by => 'transdate DESC',
|
||
|
);
|
||
| ... | ... | |
|
$orders = SL::DB::Manager::Order->get_all(
|
||
|
query => [
|
||
|
vendor_id => $cv,
|
||
|
quotation => ($type eq 'quotation' ? 'T' : 'F')
|
||
|
record_type => ($type eq 'quotation' ? REQUEST_QUOTATION_TYPE() : PURCHASE_ORDER_TYPE())
|
||
|
],
|
||
|
sort_by => 'transdate DESC',
|
||
|
);
|
||
| ... | ... | |
|
$query = <<SQL;
|
||
|
WITH
|
||
|
oe_emails_customer
|
||
|
AS (SELECT rc.to_id, rc.from_id, oe.quotation, oe.quonumber, oe.ordnumber, c.id
|
||
|
AS (SELECT rc.to_id, rc.from_id, oe.record_type, oe.quonumber, oe.ordnumber, c.id
|
||
|
FROM record_links rc
|
||
|
LEFT JOIN oe oe ON rc.from_id = oe.id
|
||
|
LEFT JOIN customer c ON oe.customer_id = c.id
|
||
| ... | ... | |
|
|
||
|
SELECT ej.*,
|
||
|
CASE
|
||
|
oec.quotation WHEN 'F' THEN 'Sales Order'
|
||
|
ELSE 'Quotation'
|
||
|
oec.record_type WHEN 'sales_order' THEN 'Sales Order'
|
||
|
ELSE 'Quotation'
|
||
|
END AS type,
|
||
|
CASE
|
||
|
oec.quotation WHEN 'F' THEN oec.ordnumber
|
||
|
ELSE oec.quonumber
|
||
|
oec.record_type WHEN 'sales_order' THEN oec.ordnumber
|
||
|
ELSE oec.quonumber
|
||
|
END AS recordnumber,
|
||
|
oec.id AS record_id
|
||
|
FROM email_journal ej
|
||
| ... | ... | |
|
$query = <<SQL;
|
||
|
WITH
|
||
|
oe_emails_vendor
|
||
|
AS (SELECT rc.to_id, rc.from_id, oe.quotation, oe.quonumber, oe.ordnumber, c.id
|
||
|
AS (SELECT rc.to_id, rc.from_id, oe.record_type, oe.quonumber, oe.ordnumber, c.id
|
||
|
FROM record_links rc
|
||
|
LEFT JOIN oe oe ON rc.from_id = oe.id
|
||
|
LEFT JOIN vendor c ON oe.vendor_id = c.id
|
||
| ... | ... | |
|
|
||
|
SELECT ej.*,
|
||
|
CASE
|
||
|
oec.quotation WHEN 'F' THEN 'Purchase Order'
|
||
|
ELSE 'Request quotation'
|
||
|
oec.record_type WHEN 'purchase_order' THEN 'Purchase Order'
|
||
|
ELSE 'Request quotation'
|
||
|
END AS type,
|
||
|
CASE
|
||
|
oec.quotation WHEN 'F' THEN oec.ordnumber
|
||
|
ELSE oec.quonumber
|
||
|
oec.record_type WHEN 'purchase_order' THEN oec.ordnumber
|
||
|
ELSE oec.quonumber
|
||
|
END AS recordnumber,
|
||
|
oec.id AS record_id
|
||
|
FROM email_journal ej
|
||
Auch abrufbar als: Unified diff
Angebotsflag/Intakeflag aus Datenbankzugriffen entfernt