Revision 2868feee
Von Moritz Bunkus vor etwa 16 Jahren hinzugefügt
| SL/IR.pm | ||
|---|---|---|
| 866 | 866 |
} |
| 867 | 867 |
my $query = |
| 868 | 868 |
qq|SELECT |
| 869 |
v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes, |
|
| 869 |
v.id AS vendor_id, v.name AS vendor, v.creditlimit, v.terms, v.notes AS intnotes,
|
|
| 870 | 870 |
v.email, v.cc, v.bcc, v.language_id, v.payment_id, |
| 871 | 871 |
v.street, v.zipcode, v.city, v.country, v.taxzone_id, |
| 872 | 872 |
$duedate + COALESCE(pt.terms_netto, 0) AS duedate, |
| SL/IS.pm | ||
|---|---|---|
| 1526 | 1526 |
# get customer |
| 1527 | 1527 |
$query = |
| 1528 | 1528 |
qq|SELECT |
| 1529 |
c.name AS customer, c.discount, c.creditlimit, c.terms, |
|
| 1529 |
c.id AS customer_id, c.name AS customer, c.discount, c.creditlimit, c.terms,
|
|
| 1530 | 1530 |
c.email, c.cc, c.bcc, c.language_id, c.payment_id, |
| 1531 | 1531 |
c.street, c.zipcode, c.city, c.country, |
| 1532 | 1532 |
c.notes AS intnotes, c.klass as customer_klass, c.taxzone_id, c.salesman_id, |
Auch abrufbar als: Unified diff
Beim Anlegen des allerersten Beleges eines Typs dafür sorgen, dass vendor_id bzw. customer_id auch gesetzt werden. Andernfalls funktionieren Dinge wie Ansprechpartner-Drop-Down-Boxen nicht, oder es erscheinen später SQL-Fehler.