From: Ivan Kohler <ivan@freeside.biz>
Date: Sun, 15 Jul 2012 04:11:02 +0000 (-0700)
Subject: fix 477 report part V, RT#18503
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=1ad6427250c2a45d450bb5045e0dc4907c53b450

fix 477 report part V, RT#18503
---

diff --git a/httemplate/search/477partV.html b/httemplate/search/477partV.html
index 55ebc0be2..0987fea44 100755
--- a/httemplate/search/477partV.html
+++ b/httemplate/search/477partV.html
@@ -34,9 +34,11 @@ $search_hash{'classnum'} = [ $cgi->param('classnum') ];
 $search_hash{report_option} = $cgi->param('partv_report_option')
   if $cgi->param('partv_report_option');
 
-my $sql_query = FS::cust_pkg->search( { %search_hash, 'fcc_line' => 1 });
-$sql_query->{select} = 'DISTINCT substr(zip,1,5) as zip';
-$sql_query->{order_by} = 'ORDER BY substr(zip,1,5)';
+my $sql_query = FS::cust_pkg->search( { %search_hash,
+                                        'fcc_line'    => 1,
+                                        'select_zip5' => 1,
+                                      }
+                                    );
 my $count_query = delete($sql_query->{'count_query'});
 $count_query =~ s/COUNT\(\*\)/count(DISTINCT substr(zip,1,5))/;
 $count_query =~ s/ORDER BY [.\w]+//;