Revision be776964
Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt
SL/DN.pm | ||
---|---|---|
228 | 228 |
-- duedate: |
229 | 229 |
(SELECT duedate FROM dunning WHERE dunning_id = ? LIMIT 1), |
230 | 230 |
'f', -- invoice |
231 |
?, -- curr
|
|
231 |
(SELECT id FROM currencies WHERE curr = ?), -- curr
|
|
232 | 232 |
?, -- notes |
233 | 233 |
-- employee_id: |
234 | 234 |
(SELECT id FROM employee WHERE login = ?) |
... | ... | |
761 | 761 |
ar.transdate, ar.duedate, ar.customer_id, |
762 | 762 |
ar.invnumber, ar.ordnumber, ar.cp_id, |
763 | 763 |
ar.amount, ar.netamount, ar.paid, |
764 |
ar.curr,
|
|
764 |
(SELECT cu.curr FROM currencies cu WHERE cu.id=ar.curr) AS curr,
|
|
765 | 765 |
ar.amount - ar.paid AS open_amount, |
766 | 766 |
ar.amount - ar.paid + da.fee + da.interest AS linetotal |
767 | 767 |
|
Auch abrufbar als: Unified diff
Nutzung der Tabelle currencies
Dieser Commmit passt den Code an, um die Tabelle currencies zu nutzen.