Revision b4e8cd54
Von Moritz Bunkus vor fast 18 Jahren hinzugefügt
SL/IR.pm | ||
---|---|---|
1002 | 1002 |
my $query = qq|SELECT v.name AS vendor, v.creditlimit, v.terms, |
1003 | 1003 |
v.email, v.cc, v.bcc, v.language_id, v.payment_id, |
1004 | 1004 |
v.street, v.zipcode, v.city, v.country, v.taxzone_id, |
1005 |
$duedate + v.terms AS duedate |
|
1005 |
$duedate + v.terms AS duedate, |
|
1006 |
b.description AS business |
|
1006 | 1007 |
FROM vendor v |
1008 |
LEFT JOIN business b ON b.id = v.business_id |
|
1007 | 1009 |
WHERE v.id = $form->{vendor_id}|; |
1008 | 1010 |
my $sth = $dbh->prepare($query); |
1009 | 1011 |
$sth->execute || $form->dberror($query); |
Auch abrufbar als: Unified diff
Beim Auslesen der Lieferantendaten auch den Lieferantentyp holen.