Revision 4aa9760e
Von G. Richardson vor mehr als 5 Jahren hinzugefügt
| SL/DN.pm | ||
|---|---|---|
| 534 | 534 |
push(@values, like($form->{customer}));
|
| 535 | 535 |
} |
| 536 | 536 |
|
| 537 |
if ($form->{department_id}) {
|
|
| 538 |
$where .= qq| AND (a.department_id = ?)|; |
|
| 539 |
push(@values, $form->{department_id});
|
|
| 540 |
} |
|
| 541 |
|
|
| 537 | 542 |
my %columns = ( |
| 538 | 543 |
"ordnumber" => "a.ordnumber", |
| 539 | 544 |
"invnumber" => "a.invnumber", |
| ... | ... | |
| 573 | 578 |
ct.name AS customername, a.customer_id, a.duedate, |
| 574 | 579 |
a.amount - a.paid AS open_amount, |
| 575 | 580 |
a.direct_debit, |
| 581 |
dep.description as departmentname, |
|
| 576 | 582 |
|
| 577 | 583 |
cfg.dunning_description, cfg.dunning_level, |
| 578 | 584 |
|
| ... | ... | |
| 590 | 596 |
FROM ar a |
| 591 | 597 |
|
| 592 | 598 |
LEFT JOIN customer ct ON (a.customer_id = ct.id) |
| 599 |
LEFT JOIN department dep ON (a.department_id = dep.id) |
|
| 593 | 600 |
LEFT JOIN dunning_config cfg ON (a.dunning_config_id = cfg.id) |
| 594 | 601 |
LEFT JOIN dunning_config nextcfg ON |
| 595 | 602 |
(nextcfg.id = |
Auch abrufbar als: Unified diff
Mahnungen erzeugen - nach Abteilung filtern und anzeigen