Revision 451843cf
Von Sven Schöling vor etwa 15 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 811 | 811 |
lastcost => ' ', |
| 812 | 812 |
factor => 'pfac.', |
| 813 | 813 |
'SUM(ioi.qty)' => ' ', |
| 814 |
description => 'p.', |
|
| 814 | 815 |
); |
| 815 | 816 |
|
| 816 | 817 |
my %renamed_columns = ( |
| ... | ... | |
| 818 | 819 |
'SUM(ioi.qty)' => 'soldtotal', |
| 819 | 820 |
); |
| 820 | 821 |
|
| 821 |
my %joins_needed; |
|
| 822 |
|
|
| 823 | 822 |
if (($form->{searchitems} eq 'assembly') && $form->{l_lastcost}) {
|
| 824 | 823 |
@simple_l_switches = grep { $_ ne 'lastcost' } @simple_l_switches;
|
| 825 | 824 |
} |
| ... | ... | |
| 830 | 829 |
my @where_tokens = qw(1=1); |
| 831 | 830 |
my @group_tokens = (); |
| 832 | 831 |
my @bind_vars = (); |
| 832 |
my %joins_needed = (); |
|
| 833 | 833 |
|
| 834 | 834 |
# special case transdate |
| 835 | 835 |
if (grep { $form->{$_} } qw(transdatefrom transdateto)) {
|
| ... | ... | |
| 842 | 842 |
} |
| 843 | 843 |
} |
| 844 | 844 |
|
| 845 |
my %simple_filter_table_prefix = ( |
|
| 846 |
description => 'p.', |
|
| 847 |
); |
|
| 848 |
|
|
| 849 | 845 |
foreach (@simple_filters, @makemodel_filters, @invoice_oi_filters) {
|
| 850 | 846 |
next unless $form->{$_};
|
| 851 | 847 |
$form->{"l_$_"} = '1'; # show the column
|
| 852 |
push @where_tokens, "$simple_filter_table_prefix{$_}$_ ILIKE ?";
|
|
| 848 |
push @where_tokens, "$table_prefix{$_}$_ ILIKE ?";
|
|
| 853 | 849 |
push @bind_vars, "%$form->{$_}%";
|
| 854 | 850 |
} |
| 855 | 851 |
|
Auch abrufbar als: Unified diff
Löschen von RecordLinks