diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-02-25 21:52:31 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-02-25 21:52:31 -0800 |
| commit | 0393defb3dee145a4bedee761de25cfd1ac503e0 (patch) | |
| tree | 29fa75a35691ef28c9d9d19e414929fd66facda9 | |
| parent | 45d35d5739d05e602bc317739485693e0e9ff0b5 (diff) | |
fix agent selection on sales commission report, RT#27818
| -rw-r--r-- | httemplate/search/sales_commission.html | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/httemplate/search/sales_commission.html b/httemplate/search/sales_commission.html index e74f3792e..57b6cdcd5 100644 --- a/httemplate/search/sales_commission.html +++ b/httemplate/search/sales_commission.html @@ -33,7 +33,12 @@ my $date_format = $conf->config('date_format') || '%m/%d/%Y'; my %query = ( 'table' => 'sales' ); my $count_query = "SELECT COUNT(*) FROM sales"; -my $salesnum; +if ( $cgi->param('agentnum') =~ /^(\d+)$/ ) { + $query{hashref}->{agentnum} = $1; + $count_query .= " WHERE agentnum = $1"; +} + +my $salesnum = ''; if ( $cgi->param('salesnum') =~ /^(\d+)$/ ) { $salesnum = $1; } else { |