X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_main.html;h=04ecf894a9aa940adf68ad95bdfb29173779a065;hb=636dd1f25af52d35efe7a323a5765ff5adeadf83;hp=f098fd3a62c41a6f34957834f60c20f008416671;hpb=55f003404af6a2416571138356d11c5ad3755e58;p=freeside.git diff --git a/httemplate/search/cust_main.html b/httemplate/search/cust_main.html index f098fd3a6..04ecf894a 100755 --- a/httemplate/search/cust_main.html +++ b/httemplate/search/cust_main.html @@ -44,8 +44,10 @@ my %search_hash = (); #scalars my @scalars = qw ( - agentnum status cancelled_pkgs cust_fields flattened_pkgs custbatch - no_censustract + agentnum status address paydate_year paydate_month invoice_terms + no_censustract with_geocode custbatch usernum + cancelled_pkgs + cust_fields flattened_pkgs ); for my $param ( @scalars ) { @@ -54,9 +56,8 @@ for my $param ( @scalars ) { } #lists -for my $param (qw( payby )) { - $search_hash{$param} = [ $cgi->param($param) ] - if $cgi->param($param); +for my $param (qw( classnum payby tagnum )) { + $search_hash{$param} = [ $cgi->param($param) ]; } ### @@ -67,10 +68,10 @@ foreach my $field (qw( signupdate )) { my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi, $field); - next if $beginning == 0 && $ending == 4294967295; + next if $beginning == 0 && $ending == 4294967295 && !defined($cgi->param('signuphour')); #or $disable{$cgi->param('status')}->{$field}; - $search_hash{$field} = [ $beginning, $ending ]; + $search_hash{$field} = [ $beginning, $ending, $cgi->param('signuphour') ]; } @@ -85,7 +86,7 @@ $search_hash{'current_balance'} = # etc ### -my $sql_query = FS::cust_main->search_sql(\%search_hash); +my $sql_query = FS::cust_main::Search->search(\%search_hash); my $count_query = delete($sql_query->{'count_query'}); my @extra_headers = @{ delete($sql_query->{'extra_headers'}) }; my @extra_fields = @{ delete($sql_query->{'extra_fields'}) }; @@ -105,7 +106,7 @@ if ( $FS::CurrentUser::CurrentUser->access_right('Bulk send customer notices') ) my $query = $uri->query; push @$menubar, 'Email a notice to these customers' => - "${p}misc/email-customers.html?$query", + "${p}misc/email-customers.html?table=cust_main&$query", }