Revision 88e16972
Von Sven Schöling vor mehr als 15 Jahren hinzugefügt
| SL/CT.pm | ||
|---|---|---|
| 923 | 923 |
} |
| 924 | 924 |
my $query = |
| 925 | 925 |
qq|SELECT s.shiptoname, i.qty, | . |
| 926 |
qq| ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | .
|
|
| 927 |
qq| i.description, i.unit, i.sellprice | . |
|
| 926 |
qq| ${arap}.id, ${arap}.transdate, ${arap}.invnumber, ${arap}.ordnumber, | .
|
|
| 927 |
qq| i.description, i.unit, i.sellprice, | . |
|
| 928 |
qq| oe.id AS oe_id | . |
|
| 928 | 929 |
qq|FROM $arap | . |
| 929 | 930 |
qq|LEFT JOIN shipto s ON | . |
| 930 | 931 |
($arap eq "ar" |
| ... | ... | |
| 932 | 933 |
: qq|(ap.id = s.trans_id) |) . |
| 933 | 934 |
qq|LEFT JOIN invoice i ON (${arap}.id = i.trans_id) | .
|
| 934 | 935 |
qq|LEFT join parts p ON (p.id = i.parts_id) | . |
| 936 |
qq|LEFT JOIN oe ON (oe.ordnumber = ${arap}.ordnumber AND NOT ${arap}.ordnumber = '') | .
|
|
| 935 | 937 |
$where . |
| 936 | 938 |
qq|ORDER BY ${arap}.transdate DESC LIMIT 15|;
|
| 937 | 939 |
|
Auch abrufbar als: Unified diff
Kunden->Lieferanten Dialog mit Links versehen.