From: ivan Date: Sat, 18 Feb 2012 04:32:53 +0000 (+0000) Subject: fix per-user commission reports to filter packages they didn't order, RT#15634 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=f8e71b44a39cf7b4d8185c57a46045636e7cc2a4 fix per-user commission reports to filter packages they didn't order, RT#15634 --- diff --git a/httemplate/search/part_pkg.html b/httemplate/search/part_pkg.html index 8a4419857..2c9bdee1c 100644 --- a/httemplate/search/part_pkg.html +++ b/httemplate/search/part_pkg.html @@ -215,6 +215,6 @@ my $order_by = join(', ', @order_by); #my $count_query = "SELECT COUNT(*) FROM ( SELECT 1 FROM part_pkg $addl_from $extra_sql ) AS num"; #mysql? my $count_query = "SELECT COUNT(*) FROM ( SELECT DISTINCT part_pkg.pkgpart FROM part_pkg $addl_from $extra_sql ) AS num"; -warn $count_query; +#warn $count_query;