}
##
- # do the same for user
+ # parse sales person
+ ##
+
+ if ( $params->{'salesnum'} =~ /^(\d+)$/ ) {
+ push @where, ($1 > 0 ) ? "cust_main.salesnum = $1"
+ : 'cust_main.salesnum IS NULL';
+ }
+
+ ##
+ # parse usernum
##
if ( $params->{'usernum'} =~ /^(\d+)$/ and $1 ) {
}
##
+ # parse customer sales person
+ ##
+
+ if ( $params->{'cust_main_salesnum'} =~ /^(\d+)$/ ) {
+ push @where, ($1 > 0) ? "cust_main.salesnum = $1"
+ : 'cust_main.salesnum IS NULL';
+ }
+
+
+ ##
+ # parse sales person
+ ##
+
+ if ( $params->{'salesnum'} =~ /^(\d+)$/ ) {
+ push @where, ($1 > 0) ? "cust_pkg.salesnum = $1"
+ : 'cust_pkg.salesnum IS NULL';
+ }
+
+ ##
# parse custnum
##
#scalars
my @scalars = qw (
- agentnum status address zip paydate_year paydate_month invoice_terms
+ agentnum salesnum status address zip paydate_year paydate_month invoice_terms
no_censustract with_geocode with_email POST no_POST
custbatch usernum
cancelled_pkgs
for my $param ( @scalars ) {
$search_hash{$param} = scalar( $cgi->param($param) )
- if $cgi->param($param);
+ if length($cgi->param($param));
}
#lists
$search_hash{'query'} = $cgi->keywords;
#scalars
-for (qw( agentnum custnum magic status custom cust_fields pkgbatch )) {
- $search_hash{$_} = $cgi->param($_) if $cgi->param($_);
+for (qw( agentnum cust_main_salesnum salesnum custnum magic status custom
+ cust_fields pkgbatch
+ ))
+{
+ $search_hash{$_} = $cgi->param($_) if length($cgi->param($_));
}
#arrays
'disable_empty' => 0,
&>
+ <& /elements/tr-select-sales.html,
+ 'curr_value' => scalar($cgi->param('salesnum')),
+ 'pre_options' => [ '' => 'all',
+ 0 => '(none)', ],
+ 'disable_empty' => 1,
+ &>
+
<& /elements/tr-select-cust_main-status.html,
'label' => emt('Status'),
&>
'disable_empty' => 0,
)
%>
+
+ <& /elements/tr-select-sales.html,
+ 'label' => 'Customer sales person',
+ 'element_name' => 'cust_main_salesnum',
+ 'id' => 'cust_main_salesnum',
+ 'curr_value' => scalar($cgi->param('cust_main_salesnum')),
+ 'pre_options' => [ '' => 'all',
+ 0 => '(none)', ],
+ 'disable_empty' => 1,
+ &>
+
% }
+ <& /elements/tr-select-sales.html,
+ 'label' => 'Package sales person',
+ 'curr_value' => scalar($cgi->param('salesnum')),
+ 'pre_options' => [ '' => 'all',
+ 0 => '(none)', ],
+ 'disable_empty' => 1,
+ &>
+
<% include( '/elements/tr-select-cust_pkg-status.html',
'onchange' => 'status_changed(this);',
)