'header' => [
'#',
'Month',
+ 'Inserted',
'Amount',
- 'Date',
FS::UI::Web::cust_header(),
],
'fields' => [
- 'exemptpkgnum',
+ 'exemptnum',
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; },
- sub { time2str('%b %d %Y', shift->_date ) },
-
\&FS::UI::Web::cust_fields,
],
'links' => [
'',
'',
'',
-
'',
( map { $_ ne 'Cust. Status' ? $clink : '' }
FS::UI::Web::cust_header()
),
],
- 'align' => 'rrrlrc'.FS::UI::Web::cust_aligns(), # 'rlrrrc',
+ 'align' => 'rrrr'.FS::UI::Web::cust_aligns(),
'color' => [
'',
'',
my @where = ();
-my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi);
-if ( $beginning || $ending ) {
- push @where, "_date >= $beginning",
- "_date <= $ending";
- #"payby != 'COMP';
-}
+#my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi);
+#if ( $beginning || $ending ) {
+# push @where, "_date >= $beginning",
+# "_date <= $ending";
+# #"payby != 'COMP';
+#}
if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) {
push @where, "agentnum = $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, "