From 0393defb3dee145a4bedee761de25cfd1ac503e0 Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Tue, 25 Feb 2014 21:52:31 -0800
Subject: [PATCH] fix agent selection on sales commission report, RT#27818

---
 httemplate/search/sales_commission.html | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

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 {
-- 
2.11.0