% push @select, FS::TicketSystem->sql_num_customer_tickets. " as tickets";
% push @addl_headers, 'Tickets';
% push @addl_cols, 'tickets';
+% } elsif ( $query eq 'uspsunvalid' ) {
+% $search{'country'} = 'US';
+% $sortby=\*custnum_sort;
+% $orderby = "ORDER BY custnum";
% } else {
% die "unknown browse field $query";
% }
% $addl_qual .= ( $addl_qual ? ' AND ' : '' ).
% $FS::CurrentUser::CurrentUser->agentnums_sql;
%
+% if ( $cgi->param('browse') && $cgi->param('browse') eq 'uspsunvalid' ) {
+% $addl_qual .= ' AND ( length(zip) < 9 OR upper(address1) != address1 OR upper(city) != city ) ';
+% }
+%
% if ( $addl_qual ) {
% $qual .= ' AND ' if $qual;
% $qual .= $addl_qual;
% if ( $cgi->param('search_cust') ) {
% $sortby = \*company_sort;
% $orderby = "ORDER BY LOWER(company || ' ' || last || ' ' || first )";
-% push @cust_main, smart_search( 'search' => $cgi->param('search_cust') );
+% push @cust_main, smart_search( 'search' => $cgi->param('search_cust'),
+% 'no_fuzzy_on_exact' => 1, #pref?
+% );
% }
%
% @cust_main = grep { $_->ncancelled_pkgs || ! $_->all_pkgs } @cust_main
% $cgi->param('offset', 0);
% print qq!( <a href="!. $cgi->self_url. qq!">hide!;
% }
-% print ' cancelled customers</a> )';
+% print ' canceled customers</a> )';
% }
%
% if ( $cgi->param('referral_custnum') ) {
% }
%
% if ( $last_type{'Fuzzy'} || $last_type{'All'} ) {
-% push @cust_main, FS::cust_main->fuzzy_search( { 'last' => $last } );
+% push @cust_main, FS::cust_main::Search->fuzzy_search( { 'last' => $last } );
% }
%
% #if ($last_type{'Sound-alike'}) {
% }
%
% if ( $company_type{'Fuzzy'} || $company_type{'All'} ) {
-% push @cust_main, FS::cust_main->fuzzy_search( { 'company' => $company } );
+% push @cust_main, FS::cust_main::Search->fuzzy_search( { 'company' => $company } );
% }
%
% if ($company_type{'Sound-alike'}) {