Revision 52c9a08d
Von Philip Reetz vor etwa 17 Jahren hinzugefügt
| SL/CT.pm | ||
|---|---|---|
| 638 | 638 |
qq|LEFT JOIN business b ON (ct.business_id = b.id) | . |
| 639 | 639 |
qq|WHERE $where|; |
| 640 | 640 |
|
| 641 |
my @saved_values = @values; |
|
| 641 | 642 |
# redo for invoices, orders and quotations |
| 642 | 643 |
if ($form->{l_invnumber} || $form->{l_ordnumber} || $form->{l_quonumber}) {
|
| 643 | 644 |
my ($ar, $union, $module); |
| ... | ... | |
| 661 | 662 |
} |
| 662 | 663 |
|
| 663 | 664 |
if ( $form->{l_ordnumber} ) {
|
| 665 |
if ($union eq "UNION") {
|
|
| 666 |
push(@values, @saved_values); |
|
| 667 |
} |
|
| 664 | 668 |
$query .= |
| 665 | 669 |
qq| $union | . |
| 666 | 670 |
qq|SELECT ct.*, b.description AS business,| . |
| ... | ... | |
| 675 | 679 |
} |
| 676 | 680 |
|
| 677 | 681 |
if ( $form->{l_quonumber} ) {
|
| 682 |
if ($union eq "UNION") {
|
|
| 683 |
push(@values, @saved_values); |
|
| 684 |
} |
|
| 678 | 685 |
$query .= |
| 679 | 686 |
qq| $union | . |
| 680 | 687 |
qq|SELECT ct.*, b.description AS business, | . |
Auch abrufbar als: Unified diff
Wenn bei Kundenberichten Rechnungen etc ausgewaehlt waren, wurden nicht genug Variablen ins
Query gesteckt