Revision 7d2ab55b
Von Jan Büren vor fast 3 Jahren hinzugefügt
| SL/AR.pm | ||
|---|---|---|
| 575 | 575 |
$where .= " AND a.department_id = ?"; |
| 576 | 576 |
push(@values, $form->{department_id});
|
| 577 | 577 |
} |
| 578 |
foreach my $column (qw(invnumber ordnumber cusordnumber notes transaction_description)) {
|
|
| 578 |
foreach my $column (qw(invnumber ordnumber cusordnumber notes transaction_description shipvia shippingpoint)) {
|
|
| 579 | 579 |
if ($form->{$column}) {
|
| 580 | 580 |
$where .= " AND a.$column ILIKE ?"; |
| 581 | 581 |
push(@values, like($form->{$column}));
|
| bin/mozilla/ar.pl | ||
|---|---|---|
| 1036 | 1036 |
|
| 1037 | 1037 |
my @hidden_variables = map { "l_${_}" } @columns;
|
| 1038 | 1038 |
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id transdatefrom transdateto duedatefrom duedateto |
| 1039 |
employee_id salesman_id business_id parts_partnumber parts_description department_id show_marked_as_closed show_not_mailed); |
|
| 1039 |
employee_id salesman_id business_id parts_partnumber parts_description department_id show_marked_as_closed show_not_mailed |
|
| 1040 |
shippingpoint shipvia); |
|
| 1040 | 1041 |
push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables;
|
| 1041 | 1042 |
|
| 1042 | 1043 |
$href = $params{want_binary_pdf} ? '' : build_std_url('action=ar_transactions', grep { $form->{$_} } @hidden_variables);
|
| ... | ... | |
| 1159 | 1160 |
if ($form->{closed}) {
|
| 1160 | 1161 |
push @options, $locale->text('Closed');
|
| 1161 | 1162 |
} |
| 1163 |
if ($form->{shipvia}) {
|
|
| 1164 |
push @options, $locale->text('Ship via') . " : $form->{shipvia}";
|
|
| 1165 |
} |
|
| 1166 |
if ($form->{shippingpoint}) {
|
|
| 1167 |
push @options, $locale->text('Shipping Point') . " : $form->{shippingpoint}";
|
|
| 1168 |
} |
|
| 1169 |
|
|
| 1162 | 1170 |
|
| 1163 | 1171 |
$form->{ALL_PRINTERS} = SL::DB::Manager::Printer->get_all_sorted;
|
| 1164 | 1172 |
|
| templates/webpages/ar/search.html | ||
|---|---|---|
| 54 | 54 |
<th align="right">[% 'Part Number' | $T8 %]</th> |
| 55 | 55 |
<td>[% L.input_tag("parts_partnumber", "", style=style) %]</td>
|
| 56 | 56 |
</tr> |
| 57 |
<tr> |
|
| 58 |
<th align=right nowrap>[% 'Shipping Point' | $T8 %]</th> |
|
| 59 |
<td>[% L.input_tag("shippingpoint", "", style=style) %]</td>
|
|
| 60 |
<th align="right">[% 'Ship via' | $T8 %]</th> |
|
| 61 |
<td>[% L.input_tag("shipvia", "", style=style) %]</td>
|
|
| 62 |
</tr> |
|
| 57 | 63 |
<tr> |
| 58 | 64 |
<th align="right">[% 'Project Number' | $T8 %]</th> |
| 59 | 65 |
<td>[% P.project.picker("project_id", project_id, active="both", valid="both", style=style) %]</td>
|
Auch abrufbar als: Unified diff
Rechnungssuche: Filter für Ship via und Shipping Point