Revision 2ff471a7
Von Moritz Bunkus vor fast 18 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 447 | 447 |
delivery_customer_id = $form->{delivery_customer_id},
|
| 448 | 448 |
globalproject_id = | . conv_i($form->{"globalproject_id"}, 'NULL') . qq|,
|
| 449 | 449 |
employee_id = $form->{employee_id},
|
| 450 |
salesman_id = | . conv_i($form->{salesman_id}, 'NULL') . qq|,
|
|
| 450 | 451 |
cp_id = | . conv_i($form->{cp_id}, 'NULL') . qq|
|
| 451 | 452 |
WHERE id = $form->{id}|;
|
| 452 | 453 |
$dbh->do($query) || $form->dberror($query); |
| ... | ... | |
| 677 | 678 |
# it will be killed out and then has to be fetched from the item scope query further down |
| 678 | 679 |
$query = qq|SELECT o.cp_id, o.ordnumber, o.transdate, o.reqdate, |
| 679 | 680 |
o.taxincluded, o.shippingpoint, o.shipvia, o.notes, o.intnotes, |
| 680 |
o.curr AS currency, e.name AS employee, o.employee_id, |
|
| 681 |
o.curr AS currency, e.name AS employee, o.employee_id, o.salesman_id,
|
|
| 681 | 682 |
o.$form->{vc}_id, cv.name AS $form->{vc}, o.amount AS invtotal,
|
| 682 | 683 |
o.closed, o.reqdate, o.quonumber, o.department_id, o.cusordnumber, |
| 683 | 684 |
d.description AS department, o.payment_id, o.language_id, o.taxzone_id, |
Auch abrufbar als: Unified diff
Speichern und Anzeigen eines Verkäufers bei Verkaufsmasken.