Revision 1c77d03f
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
| SL/CT.pm | ||
|---|---|---|
|
qq|LEFT JOIN employee e ON (ct.salesman_id = e.id) | .
|
||
|
qq|LEFT JOIN payment_terms pt ON (ct.payment_id = pt.id) | .
|
||
|
$pg_join .
|
||
|
qq|WHERE $where AND (o.quotation = '0')|;
|
||
|
qq|WHERE $where AND ((o.record_type = 'sales_order') OR (o.record_type = 'purcharse_order'))|;
|
||
|
}
|
||
|
|
||
|
if ( $form->{l_quonumber} ) {
|
||
| ... | ... | |
|
qq|LEFT JOIN employee e ON (ct.salesman_id = e.id) | .
|
||
|
qq|LEFT JOIN payment_terms pt ON (ct.payment_id = pt.id) | .
|
||
|
$pg_join .
|
||
|
qq|WHERE $where AND (o.quotation = '1')|;
|
||
|
qq|WHERE $where AND ((o.record_type = 'sales_quotation') OR (o.record_type = 'request_quotation'))|;
|
||
|
}
|
||
|
}
|
||
|
|
||
Auch abrufbar als: Unified diff
Angebotsflag/Intakeflag aus Datenbankzugriffen entfernt