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