Revision d93709bd
Von Bernd Bleßmann vor etwa 9 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 67 | 67 |
my $query = |
| 68 | 68 |
qq|SELECT dord.id, dord.donumber, dord.ordnumber, dord.cusordnumber, |
| 69 | 69 |
dord.transdate, dord.reqdate, |
| 70 |
ct.${vc}number, ct.name, dord.${vc}_id, dord.globalproject_id,
|
|
| 70 |
ct.${vc}number, ct.name, ct.business_id,
|
|
| 71 |
dord.${vc}_id, dord.globalproject_id,
|
|
| 71 | 72 |
dord.closed, dord.delivered, dord.shippingpoint, dord.shipvia, |
| 72 | 73 |
dord.transaction_description, dord.itime::DATE AS insertdate, |
| 73 | 74 |
pr.projectnumber AS globalprojectnumber, |
| ... | ... | |
| 98 | 99 |
push @values, conv_i($form->{project_id}), conv_i($form->{project_id});
|
| 99 | 100 |
} |
| 100 | 101 |
|
| 102 |
if ($form->{"business_id"}) {
|
|
| 103 |
push @where, qq|ct.business_id = ?|; |
|
| 104 |
push @values, conv_i($form->{"business_id"});
|
|
| 105 |
} |
|
| 106 |
|
|
| 101 | 107 |
if ($form->{"${vc}_id"}) {
|
| 102 | 108 |
push @where, qq|dord.${vc}_id = ?|;
|
| 103 | 109 |
push @values, $form->{"${vc}_id"};
|
Auch abrufbar als: Unified diff
Filtern nach Kunden-/Lieferantentyp bei Lieferschein-Berichten.
Conflicts: