projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT# 76968 - Created new interactive map to select census tract
[freeside.git]
/
httemplate
/
search
/
cust_tax_exempt.cgi
diff --git
a/httemplate/search/cust_tax_exempt.cgi
b/httemplate/search/cust_tax_exempt.cgi
index
551b75d
..
91b2001
100644
(file)
--- a/
httemplate/search/cust_tax_exempt.cgi
+++ b/
httemplate/search/cust_tax_exempt.cgi
@@
-1,4
+1,4
@@
-<
% include( 'elements/search.html'
,
+<
& elements/search.html
,
'title' => 'Legacy tax exemptions',
'name' => 'legacy tax exemptions',
'query' => $query,
'title' => 'Legacy tax exemptions',
'name' => 'legacy tax exemptions',
'query' => $query,
@@
-7,12
+7,16
@@
'header' => [
'#',
'Month',
'header' => [
'#',
'Month',
+ 'Inserted',
'Amount',
FS::UI::Web::cust_header(),
],
'fields' => [
'Amount',
FS::UI::Web::cust_header(),
],
'fields' => [
- 'exempt
pkg
num',
+ 'exemptnum',
sub { $_[0]->month. '/'. $_[0]->year; },
sub { $_[0]->month. '/'. $_[0]->year; },
+ sub { my $h = $_[0]->h_search('insert');
+ $h ? time2str('%L/%d/%Y', $h->history_date ) : ''
+ },
sub { $money_char. $_[0]->amount; },
\&FS::UI::Web::cust_fields,
sub { $money_char. $_[0]->amount; },
\&FS::UI::Web::cust_fields,
@@
-21,31
+25,32
@@
'',
'',
'',
'',
'',
'',
+ '',
( map { $_ ne 'Cust. Status' ? $clink : '' }
FS::UI::Web::cust_header()
),
],
( map { $_ ne 'Cust. Status' ? $clink : '' }
FS::UI::Web::cust_header()
),
],
- 'align' => 'rrr'.FS::UI::Web::cust_aligns(),
+ 'align' => 'rrr
r
'.FS::UI::Web::cust_aligns(),
'color' => [
'',
'',
'',
'color' => [
'',
'',
'',
+ '',
FS::UI::Web::cust_colors(),
],
'style' => [
'',
'',
'',
FS::UI::Web::cust_colors(),
],
'style' => [
'',
'',
'',
+ '',
FS::UI::Web::cust_styles(),
],
FS::UI::Web::cust_styles(),
],
- )
-
%
>
+
+
&
>
<%init>
<%init>
-my $join_cust = "
- LEFT JOIN cust_main USING ( custnum )
-";
+my $join_cust = FS::UI::Web::join_cust_main('cust_tax_exempt');
die "access denied"
unless $FS::CurrentUser::CurrentUser->access_right('View customer tax exemptions');
die "access denied"
unless $FS::CurrentUser::CurrentUser->access_right('View customer tax exemptions');
@@
-56,7
+61,6
@@
my @where = ();
#if ( $beginning || $ending ) {
# push @where, "_date >= $beginning",
# "_date <= $ending";
#if ( $beginning || $ending ) {
# push @where, "_date >= $beginning",
# "_date <= $ending";
-# #"payby != 'COMP';
#}
if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) {
#}
if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) {
@@
-67,6
+71,13
@@
if ( $cgi->param('custnum') =~ /^(\d+)$/ ) {
push @where, "cust_main.custnum = $1";
}
push @where, "cust_main.custnum = $1";
}
+#prospect active inactive suspended cancelled
+if ( grep { $cgi->param('status') eq $_ } FS::cust_main->statuses() ) {
+ my $method = $cgi->param('status'). '_sql';
+ #push @where, $class->$method();
+ push @where, FS::cust_main->$method();
+}
+
if ( $cgi->param('out') ) {
push @where, "
if ( $cgi->param('out') ) {
push @where, "