Revision f5ab8350
Von Moritz Bunkus vor mehr als 17 Jahren hinzugefügt
| SL/DN.pm | ||
|---|---|---|
| 211 | 211 |
qq|SELECT |
| 212 | 212 |
cfg.interest_rate, cfg.template AS formname, |
| 213 | 213 |
cfg.email_subject, cfg.email_body, cfg.email_attachment, |
| 214 |
(SELECT fee
|
|
| 214 |
(SELECT SUM(fee)
|
|
| 215 | 215 |
FROM dunning |
| 216 |
WHERE dunning_id = ? |
|
| 217 |
LIMIT 1) |
|
| 216 |
WHERE dunning_id = ?) |
|
| 218 | 217 |
AS fee, |
| 219 | 218 |
(SELECT SUM(interest) |
| 220 | 219 |
FROM dunning |
| ... | ... | |
| 640 | 639 |
qq|SELECT |
| 641 | 640 |
cfg.interest_rate, cfg.template AS formname, |
| 642 | 641 |
cfg.email_subject, cfg.email_body, cfg.email_attachment, |
| 643 |
d.fee, d.transdate AS dunning_date, |
|
| 642 |
d.transdate AS dunning_date, |
|
| 643 |
(SELECT SUM(fee) |
|
| 644 |
FROM dunning |
|
| 645 |
WHERE dunning_id = ?) |
|
| 646 |
AS fee, |
|
| 644 | 647 |
(SELECT SUM(interest) |
| 645 | 648 |
FROM dunning |
| 646 | 649 |
WHERE dunning_id = ?) |
| ... | ... | |
| 656 | 659 |
LEFT JOIN dunning_config cfg ON (d.dunning_config_id = cfg.id) |
| 657 | 660 |
WHERE d.dunning_id = ? |
| 658 | 661 |
LIMIT 1|; |
| 659 |
$ref = selectfirst_hashref_query($form, $dbh, $query, $dunning_id, $dunning_id, $dunning_id); |
|
| 662 |
$ref = selectfirst_hashref_query($form, $dbh, $query, $dunning_id, $dunning_id, $dunning_id, $dunning_id);
|
|
| 660 | 663 |
map { $form->{$_} = $ref->{$_} } keys %{ $ref };
|
| 661 | 664 |
|
| 662 | 665 |
$form->{interest_rate} = $form->format_amount($myconfig, $ref->{interest_rate} * 100);
|
Auch abrufbar als: Unified diff
Die ausgewiesenen Mahngebühren gelten pro Rechnung, nicht pro erzeugter Mahnung, auch wenn Rechnungen in einer Mahnung zusammengefasst werden.