Revision 43b9f08f
Von Bernd Bleßmann vor etwa 2 Jahren hinzugefügt
SL/AP.pm | ||
---|---|---|
658 | 658 |
$where .= " AND a.duedate <= ?"; |
659 | 659 |
push(@values, trim($form->{duedateto})); |
660 | 660 |
} |
661 |
if ($form->{datepaidfrom}) { |
|
662 |
$where .= " AND a.datepaid >= ?"; |
|
663 |
push(@values, trim($form->{datepaidfrom})); |
|
664 |
} |
|
665 |
if ($form->{datepaidto}) { |
|
666 |
$where .= " AND a.datepaid <= ?"; |
|
667 |
push(@values, trim($form->{datepaidto})); |
|
668 |
} |
|
661 | 669 |
if ($form->{open} || $form->{closed}) { |
662 | 670 |
unless ($form->{open} && $form->{closed}) { |
663 | 671 |
$where .= " AND a.amount <> a.paid" if ($form->{open}); |
SL/AR.pm | ||
---|---|---|
611 | 611 |
$where .= " AND a.duedate <= ?"; |
612 | 612 |
push(@values, trim($form->{duedateto})); |
613 | 613 |
} |
614 |
if ($form->{datepaidfrom}) { |
|
615 |
$where .= " AND a.datepaid >= ?"; |
|
616 |
push(@values, trim($form->{datepaidfrom})); |
|
617 |
} |
|
618 |
if ($form->{datepaidto}) { |
|
619 |
$where .= " AND a.datepaid <= ?"; |
|
620 |
push(@values, trim($form->{datepaidto})); |
|
621 |
} |
|
614 | 622 |
if ($form->{open} || $form->{closed}) { |
615 | 623 |
unless ($form->{open} && $form->{closed}) { |
616 | 624 |
$where .= " AND a.amount <> a.paid" if ($form->{open}); |
bin/mozilla/ap.pl | ||
---|---|---|
1049 | 1049 |
|
1050 | 1050 |
my @hidden_variables = map { "l_${_}" } @columns; |
1051 | 1051 |
push @hidden_variables, "l_subtotal", qw(open closed vendor invnumber ordnumber transaction_description notes project_id |
1052 |
transdatefrom transdateto duedatefrom duedateto |
|
1052 |
transdatefrom transdateto duedatefrom duedateto datepaidfrom datepaidto
|
|
1053 | 1053 |
parts_partnumber parts_description department_id taxzone_id); |
1054 | 1054 |
|
1055 | 1055 |
my $href = build_std_url('action=ap_transactions', grep { $form->{$_} } @hidden_variables); |
... | ... | |
1119 | 1119 |
push @options, $locale->text('Part Number') . " : $form->{parts_partnumber}" if $form->{parts_partnumber}; |
1120 | 1120 |
push @options, $locale->text('From') . " " . $locale->date(\%myconfig, $form->{transdatefrom}, 1) if ($form->{transdatefrom}); |
1121 | 1121 |
push @options, $locale->text('Bis') . " " . $locale->date(\%myconfig, $form->{transdateto}, 1) if ($form->{transdateto}); |
1122 |
push @options, $locale->text('Due Date') . " " . $locale->text('from') . " " . $locale->date(\%myconfig, $form->{duedatefrom}, 1) if ($form->{duedatefrom}); |
|
1123 |
push @options, $locale->text('Due Date') . " " . $locale->text('to') . " " . $locale->date(\%myconfig, $form->{duedateto}, 1) if ($form->{duedateto}); |
|
1122 |
push @options, $locale->text('Due Date') . " " . $locale->text('from') . " " . $locale->date(\%myconfig, $form->{duedatefrom}, 1) if ($form->{duedatefrom}); |
|
1123 |
push @options, $locale->text('Due Date') . " " . $locale->text('to') . " " . $locale->date(\%myconfig, $form->{duedateto}, 1) if ($form->{duedateto}); |
|
1124 |
push @options, $locale->text('Date Paid') . " " . $locale->text('from') . " " . $locale->date(\%myconfig, $form->{datepaidfrom}, 1) if ($form->{datepaidfrom}); |
|
1125 |
push @options, $locale->text('Date Paid') . " " . $locale->text('to') . " " . $locale->date(\%myconfig, $form->{datepaidto}, 1) if ($form->{datepaidto}); |
|
1124 | 1126 |
push @options, $locale->text('Open') if ($form->{open}); |
1125 | 1127 |
push @options, $locale->text('Closed') if ($form->{closed}); |
1126 | 1128 |
|
bin/mozilla/ar.pl | ||
---|---|---|
1038 | 1038 |
push @columns, map { "cvar_$_->{name}" } @ct_includeable_custom_variables; |
1039 | 1039 |
|
1040 | 1040 |
my @hidden_variables = map { "l_${_}" } @columns; |
1041 |
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id transdatefrom transdateto duedatefrom duedateto |
|
1041 |
push @hidden_variables, "l_subtotal", qw(open closed customer invnumber ordnumber cusordnumber transaction_description notes project_id |
|
1042 |
transdatefrom transdateto duedatefrom duedateto datepaidfrom datepaidto |
|
1042 | 1043 |
employee_id salesman_id business_id parts_partnumber parts_description department_id show_marked_as_closed show_not_mailed |
1043 | 1044 |
shippingpoint shipvia taxzone_id); |
1044 | 1045 |
push @hidden_variables, map { "cvar_$_->{name}" } @ct_searchable_custom_variables; |
... | ... | |
1156 | 1157 |
if ($form->{duedateto}) { |
1157 | 1158 |
push @options, $locale->text('Due Date') . " " . $locale->text('to') . " " . $locale->date(\%myconfig, $form->{duedateto}, 1); |
1158 | 1159 |
} |
1160 |
if ($form->{datepaidfrom}) { |
|
1161 |
push @options, $locale->text('Date Paid') . " " . $locale->text('from') . " " . $locale->date(\%myconfig, $form->{datepaidfrom}, 1); |
|
1162 |
} |
|
1163 |
if ($form->{datepaidto}) { |
|
1164 |
push @options, $locale->text('Date Paid') . " " . $locale->text('to') . " " . $locale->date(\%myconfig, $form->{datepaidto}, 1); |
|
1165 |
} |
|
1159 | 1166 |
if ($form->{open}) { |
1160 | 1167 |
push @options, $locale->text('Open'); |
1161 | 1168 |
} |
templates/webpages/ap/search.html | ||
---|---|---|
65 | 65 |
[% L.date_tag('duedateto') %] |
66 | 66 |
</td> |
67 | 67 |
</tr> |
68 |
<tr> |
|
69 |
<th align=right nowrap>[% 'Date Paid' | $T8 %]</th> |
|
70 |
<td> |
|
71 |
[% L.date_tag('datepaidfrom') %] |
|
72 |
[% 'Bis' | $T8 %] |
|
73 |
[% L.date_tag('datepaidto') %] |
|
74 |
</td> |
|
75 |
</tr> |
|
68 | 76 |
</table> |
69 | 77 |
</td> |
70 | 78 |
</tr> |
templates/webpages/ar/search.html | ||
---|---|---|
101 | 101 |
[% L.date_tag('duedateto') %] |
102 | 102 |
</td> |
103 | 103 |
</tr> |
104 |
<tr> |
|
105 |
<th align=right nowrap>[% 'Date Paid' | $T8 %]</th> |
|
106 |
<td> |
|
107 |
[% L.date_tag('datepaidfrom') %] |
|
108 |
[% 'Bis' | $T8 %] |
|
109 |
[% L.date_tag('datepaidto') %] |
|
110 |
</td> |
|
111 |
</tr> |
|
104 | 112 |
|
105 | 113 |
[%- IF CT_CUSTOM_VARIABLES.size %] |
106 | 114 |
<tr> |
Auch abrufbar als: Unified diff
VK/EK-Rechnung -> Suche. Filter nach Zahlungsdatum