X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fsearch%2Fcust_main.html;h=693996ed5f1cec491ce4a93175082aea39b51489;hb=e168ca3db2702bd9a540316cd9bd840238dd19ce;hp=a2ecd047c4cdb81f8b21038e4dc34db819569239;hpb=3e200e9a6316815514fe1b5d2e04364ef2e34b63;p=freeside.git diff --git a/httemplate/search/cust_main.html b/httemplate/search/cust_main.html index a2ecd047c..693996ed5 100755 --- a/httemplate/search/cust_main.html +++ b/httemplate/search/cust_main.html @@ -1,6 +1,7 @@ -<% include( 'elements/search.html', - 'title' => 'Customer Search Results', - 'name' => 'customers', +<& elements/search.html, + 'title' => emt('Customer Search Results'), + 'menubar' => $menubar, + 'name' => emt('customers'), 'query' => $sql_query, 'count_query' => $count_query, 'header' => [ FS::UI::Web::cust_header( @@ -28,13 +29,7 @@ ), map '', @extra_fields ], - ) -%> -<%once> - -my $link = [ "${p}view/cust_main.cgi?", 'custnum' ]; - - +&> <%init> die "access denied" @@ -47,15 +42,21 @@ my %search_hash = (); #$search_hash{'query'} = $cgi->keywords; #scalars -for my $param (qw( agentnum status cancelled_pkgs cust_fields flattened_pkgs)) { +my @scalars = qw ( + 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 ) { $search_hash{$param} = scalar( $cgi->param($param) ) if $cgi->param($param); } #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) ]; } ### @@ -66,10 +67,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') ]; } @@ -84,9 +85,28 @@ $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'}) }; +my $link = [ "${p}view/cust_main.cgi?", 'custnum' ]; + +### +# email links +### + +my $menubar = []; + +if ( $FS::CurrentUser::CurrentUser->access_right('Bulk send customer notices') ) { + + my $uri = new URI; + $uri->query_form( \%search_hash ); + my $query = $uri->query; + + push @$menubar, emt('Email a notice to these customers') => + "${p}misc/email-customers.html?table=cust_main&$query", + +} +