Revision 08b6f2bf
Von Jan Büren vor mehr als 1 Jahr hinzugefügt
| SL/DN.pm | ||
|---|---|---|
| 456 | 456 |
my $query = |
| 457 | 457 |
qq|SELECT |
| 458 | 458 |
dcfg.email_body, dcfg.email_subject, dcfg.email_attachment, |
| 459 |
COALESCE (NULLIF(c.invoice_mail, ''), c.email) AS recipient, c.name, |
|
| 459 |
COALESCE (NULLIF(aba.dunning_email, ''), NULLIF(aba.email,''), |
|
| 460 |
NULLIF(c.dunning_email, ''), |
|
| 461 |
NULLIF(c.invoice_mail, ''), c.email) AS recipient, c.name, |
|
| 460 | 462 |
(SELECT login from employee where id = ar.employee_id) as invoice_employee_login |
| 461 | 463 |
FROM dunning d |
| 462 | 464 |
LEFT JOIN dunning_config dcfg ON (d.dunning_config_id = dcfg.id) |
Auch abrufbar als: Unified diff
Zahlungserinnerung abweichende E-Mail-Adressen für Standard- oder abw. RA