Revision be776964
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.