Revision b96c67e5
Von Moritz Bunkus vor mehr als 10 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 83 | 83 |
$query = |
| 84 | 84 |
qq|SELECT o.id, o.ordnumber, o.transdate, o.reqdate, | . |
| 85 | 85 |
qq| o.amount, ct.${vc}number, ct.name, o.netamount, o.${vc}_id, o.globalproject_id, | .
|
| 86 |
qq| o.closed, o.delivered, o.quonumber, o.shippingpoint, o.shipvia, | . |
|
| 86 |
qq| o.closed, o.delivered, o.quonumber, o.cusordnumber, o.shippingpoint, o.shipvia, | .
|
|
| 87 | 87 |
qq| o.transaction_description, | . |
| 88 | 88 |
qq| o.marge_total, o.marge_percent, | . |
| 89 | 89 |
qq| ex.$rate AS exchangerate, | . |
| ... | ... | |
| 175 | 175 |
push(@values, '%' . $form->{$ordnumber} . '%');
|
| 176 | 176 |
} |
| 177 | 177 |
|
| 178 |
if ($form->{cusordnumber}) {
|
|
| 179 |
$query .= qq| AND o.cusordnumber ILIKE ?|; |
|
| 180 |
push(@values, '%' . $form->{cusordnumber} . '%');
|
|
| 181 |
} |
|
| 182 |
|
|
| 178 | 183 |
if($form->{transdatefrom}) {
|
| 179 | 184 |
$query .= qq| AND o.transdate >= ?|; |
| 180 | 185 |
push(@values, conv_date($form->{transdatefrom}));
|
| ... | ... | |
| 222 | 227 |
"reqdate" => "o.reqdate", |
| 223 | 228 |
"id" => "o.id", |
| 224 | 229 |
"ordnumber" => "o.ordnumber", |
| 230 |
"cusordnumber" => "o.cusordnumber", |
|
| 225 | 231 |
"quonumber" => "o.quonumber", |
| 226 | 232 |
"name" => "ct.name", |
| 227 | 233 |
"employee" => "e.name", |
Auch abrufbar als: Unified diff
Berichte OE: Bestellnummer des Kunden anzeigen/danach filtern