Revision a0a10e44
Von Jan Büren vor etwa 2 Jahren 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(aba.dunning_email, ''), NULLIF(aba.email,''),
|
|
| 460 |
NULLIF(c.dunning_email, ''),
|
|
| 459 |
COALESCE (NULLIF(aba.dunning_mail, ''), NULLIF(aba.email,''), |
|
| 460 |
NULLIF(c.dunning_mail, ''), |
|
| 461 | 461 |
NULLIF(c.invoice_mail, ''), c.email) AS recipient, c.name, |
| 462 | 462 |
(SELECT login from employee where id = ar.employee_id) as invoice_employee_login |
| 463 | 463 |
FROM dunning d |
Auch abrufbar als: Unified diff
Abweichender Mahnungsempfänger per Mail, Typo in SQL