Revision d331a3d7
Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt
| SL/DO.pm | ||
|---|---|---|
| 348 | 348 |
shippingpoint = ?, shipvia = ?, notes = ?, intnotes = ?, closed = ?, |
| 349 | 349 |
delivered = ?, department_id = ?, language_id = ?, shipto_id = ?, |
| 350 | 350 |
globalproject_id = ?, employee_id = ?, salesman_id = ?, cp_id = ?, transaction_description = ?, |
| 351 |
is_sales = ?, taxzone_id = ?, taxincluded = ?, terms = ?, curr = ?
|
|
| 351 |
is_sales = ?, taxzone_id = ?, taxincluded = ?, terms = ?, curr = (SELECT id FROM currencies WHERE curr = ?)
|
|
| 352 | 352 |
WHERE id = ?|; |
| 353 | 353 |
|
| 354 | 354 |
@values = ($form->{donumber}, $form->{ordnumber},
|
| ... | ... | |
| 616 | 616 |
d.description AS department, dord.language_id, |
| 617 | 617 |
dord.shipto_id, |
| 618 | 618 |
dord.globalproject_id, dord.delivered, dord.transaction_description, |
| 619 |
dord.taxzone_id, dord.taxincluded, dord.terms, dord.curr AS currency
|
|
| 619 |
dord.taxzone_id, dord.taxincluded, dord.terms, (SELECT cu.curr FROM currencies cu WHERE cu.id=dord.curr) AS currency
|
|
| 620 | 620 |
FROM delivery_orders dord |
| 621 | 621 |
JOIN ${vc} cv ON (dord.${vc}_id = cv.id)
|
| 622 | 622 |
LEFT JOIN employee e ON (dord.employee_id = e.id) |
| ... | ... | |
| 638 | 638 |
} |
| 639 | 639 |
$sth->finish(); |
| 640 | 640 |
|
| 641 |
# remove any trailing whitespace |
|
| 642 |
$form->{currency} =~ s/\s*$//;
|
|
| 643 |
|
|
| 644 | 641 |
$form->{donumber_array} =~ s/\s*$//g;
|
| 645 | 642 |
|
| 646 | 643 |
$form->{saved_donumber} = $form->{donumber};
|
Auch abrufbar als: Unified diff
Nutzung der Tabelle currencies
Dieser Commmit passt den Code an, um die Tabelle currencies zu nutzen.