Revision 2ff471a7
Von Moritz Bunkus vor fast 18 Jahren hinzugefügt
| SL/IS.pm | ||
|---|---|---|
| 1050 | 1050 |
delivery_customer_id = $form->{delivery_customer_id},
|
| 1051 | 1051 |
delivery_vendor_id = $form->{delivery_vendor_id},
|
| 1052 | 1052 |
employee_id = $form->{employee_id},
|
| 1053 |
salesman_id = | . conv_i($form->{salesman_id}, 'NULL') . qq|,
|
|
| 1053 | 1054 |
storno = '$form->{storno}',
|
| 1054 | 1055 |
globalproject_id = | . conv_i($form->{"globalproject_id"}, 'NULL') . qq|,
|
| 1055 | 1056 |
cp_id = | . conv_i($form->{"cp_id"}, 'NULL') . qq|
|
| ... | ... | |
| 1482 | 1483 |
a.transdate AS invdate, a.deliverydate, a.paid, a.storno, a.gldate, |
| 1483 | 1484 |
a.shippingpoint, a.shipvia, a.terms, a.notes, a.intnotes, a.taxzone_id, |
| 1484 | 1485 |
a.duedate, a.taxincluded, a.curr AS currency, a.shipto_id, a.cp_id, |
| 1485 |
a.employee_id, e.name AS employee, a.payment_id, a.language_id, a.delivery_customer_id, a.delivery_vendor_id, a.type |
|
| 1486 |
a.employee_id, e.name AS employee, a.salesman_id, a.payment_id, a.language_id, a.delivery_customer_id, a.delivery_vendor_id, a.type
|
|
| 1486 | 1487 |
FROM ar a |
| 1487 | 1488 |
LEFT JOIN employee e ON (e.id = a.employee_id) |
| 1488 | 1489 |
WHERE a.id = $form->{id}|;
|
| ... | ... | |
| 1685 | 1686 |
c.email, c.cc, c.bcc, c.language_id, c.payment_id AS customer_payment_id, |
| 1686 | 1687 |
c.street, c.zipcode, c.city, c.country, |
| 1687 | 1688 |
$duedate + COALESCE(pt.terms_netto, 0) AS duedate, c.notes AS intnotes, |
| 1688 |
b.discount AS tradediscount, b.description AS business, c.klass as customer_klass, c.taxzone_id |
|
| 1689 |
b.discount AS tradediscount, b.description AS business, c.klass as customer_klass, c.taxzone_id, |
|
| 1690 |
c.salesman_id |
|
| 1689 | 1691 |
FROM customer c |
| 1690 | 1692 |
LEFT JOIN business b ON (b.id = c.business_id) |
| 1691 | 1693 |
LEFT JOIN payment_terms pt ON c.payment_id = pt.id |
Auch abrufbar als: Unified diff
Speichern und Anzeigen eines Verkäufers bei Verkaufsmasken.