Revision 044d18ff
Von Jan Büren vor fast 14 Jahren hinzugefügt
SL/AR.pm | ||
---|---|---|
446 | 446 |
$where .= " AND c.name ILIKE ?"; |
447 | 447 |
push(@values, $form->like($form->{customer})); |
448 | 448 |
} |
449 |
if ($form->{business_id}) { |
|
450 |
my $business_id = $form->{business_id}; |
|
451 |
$where .= " AND c.business_id = ?"; |
|
452 |
push(@values, $business_id); |
|
453 |
} |
|
449 | 454 |
if ($form->{department_id}) { |
450 | 455 |
my $department_id = $form->{department_id}; |
451 | 456 |
$where .= " AND a.department_id = ?"; |
bin/mozilla/ar.pl | ||
---|---|---|
1275 | 1275 |
$form->{title} = $locale->text('AR Transactions'); |
1276 | 1276 |
$form->{jsscript} = 1; |
1277 | 1277 |
|
1278 |
$form->get_lists("projects" => { "key" => "ALL_PROJECTS", "all" => 1 }, |
|
1279 |
"departments" => "ALL_DEPARTMENTS", |
|
1280 |
"customers" => "ALL_VC"); |
|
1278 |
# Auch in Rechnungsübersicht nach Kundentyp filtern - jan |
|
1279 |
$form->get_lists("projects" => { "key" => "ALL_PROJECTS", "all" => 1 }, |
|
1280 |
"departments" => "ALL_DEPARTMENTS", |
|
1281 |
"customers" => "ALL_VC", |
|
1282 |
"business_types" => "ALL_BUSINESS_TYPES"); |
|
1283 |
$form->{SHOW_BUSINESS_TYPES} = scalar @{ $form->{ALL_BUSINESS_TYPES} } > 0; |
|
1281 | 1284 |
|
1282 | 1285 |
# constants and subs for template |
1283 | 1286 |
$form->{jsscript} = 1; |
templates/webpages/ar/search.html | ||
---|---|---|
3 | 3 |
|
4 | 4 |
<form method=post name="search" action=[% script %]> |
5 | 5 |
|
6 |
<table width=100%> |
|
6 |
<table width=100% border="0">
|
|
7 | 7 |
<tr><th class=listtop>[% title %]</th></tr> |
8 | 8 |
<tr height="5"></tr> |
9 | 9 |
<tr> |
... | ... | |
72 | 72 |
-%] |
73 | 73 |
</td> |
74 | 74 |
</tr> |
75 |
[% IF SHOW_BUSINESS_TYPES %] |
|
76 |
<tr> |
|
77 |
<th align="right" nowrap>[% 'Customer type' | $T8 %]</th> |
|
78 |
<td colspan="3"> |
|
79 |
[%- INCLUDE 'generic/multibox.html' |
|
80 |
name = 'business_id', |
|
81 |
style = "width: 250px", |
|
82 |
DATA = ALL_BUSINESS_TYPES, |
|
83 |
id_key = 'id', |
|
84 |
label_key = 'description', |
|
85 |
limit = vclimit, |
|
86 |
show_empty = 1, |
|
87 |
allow_textbox = 0, |
|
88 |
-%] |
|
89 |
|
|
90 |
</select> |
|
91 |
</td> |
|
92 |
</tr> |
|
93 |
[% END %] |
|
75 | 94 |
<tr> |
76 | 95 |
<th align=right nowrap>[% 'From' | $T8 %]</th> |
77 | 96 |
<td> |
Auch abrufbar als: Unified diff
Filterkriterium Kundentyp (business_id) für Rechnungsübersicht hinzugefügt.