Revision fac049a0
Von Bernd Bleßmann vor etwa 11 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 87 | 87 |
qq| ex.$rate AS exchangerate, | . |
| 88 | 88 |
qq| pr.projectnumber AS globalprojectnumber, | . |
| 89 | 89 |
qq| e.name AS employee, s.name AS salesman, | . |
| 90 |
qq| ct.${vc}number AS vcnumber, ct.country, ct.ustid | .
|
|
| 90 |
qq| ct.${vc}number AS vcnumber, ct.country, ct.ustid, ct.business_id | .
|
|
| 91 | 91 |
$periodic_invoices_columns . |
| 92 | 92 |
qq|FROM oe o | . |
| 93 | 93 |
qq|JOIN $vc ct ON (o.${vc}_id = ct.id) | .
|
| ... | ... | |
| 126 | 126 |
push @values, "%" . $form->{"projectnumber"} . "%", "%" . $form->{"projectnumber"} . "%" ;
|
| 127 | 127 |
} |
| 128 | 128 |
|
| 129 |
if ($form->{"business_id"}) {
|
|
| 130 |
$query .= " AND ct.business_id = ?"; |
|
| 131 |
push(@values, $form->{"business_id"});
|
|
| 132 |
} |
|
| 133 |
|
|
| 129 | 134 |
if ($form->{"${vc}_id"}) {
|
| 130 | 135 |
$query .= " AND o.${vc}_id = ?";
|
| 131 | 136 |
push(@values, $form->{"${vc}_id"});
|
Auch abrufbar als: Unified diff
Filtern nach Kunden-/Lieferantentyp bei Angeboten u. Aufträgen