Revision 8862bb1e
Von Bernd Bleßmann vor fast 10 Jahren hinzugefügt
| SL/Controller/CustomerVendor.pm | ||
|---|---|---|
| 637 | 637 |
} |
| 638 | 638 |
|
| 639 | 639 |
my $arap = $self->is_vendor ? 'ap' : 'ar'; |
| 640 |
my $num_args = 2;
|
|
| 640 |
my $num_args = 3;
|
|
| 641 | 641 |
|
| 642 | 642 |
my $cv = $self->is_vendor ? 'vendor' : 'customer'; |
| 643 | 643 |
|
| ... | ... | |
| 652 | 652 |
SELECT a.id |
| 653 | 653 |
FROM oe a |
| 654 | 654 |
JOIN '. $cv .' ct ON (a.'. $cv .'_id = ct.id) |
| 655 |
WHERE ct.id = ? |
|
| 656 |
|
|
| 657 |
UNION |
|
| 658 |
|
|
| 659 |
SELECT a.id |
|
| 660 |
FROM delivery_orders a |
|
| 661 |
JOIN '. $cv .' ct ON (a.'. $cv .'_id = ct.id) |
|
| 655 | 662 |
WHERE ct.id = ?'; |
| 656 | 663 |
|
| 657 | 664 |
|
Auch abrufbar als: Unified diff
Kunden/Lieferanten sind nicht verwaist, wenn es Lieferscheine gibt.