projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
cb17f80
)
fix 477 report part V, RT#18503
author
Ivan Kohler
<ivan@freeside.biz>
Sun, 15 Jul 2012 04:11:02 +0000
(21:11 -0700)
committer
Ivan Kohler
<ivan@freeside.biz>
Sun, 15 Jul 2012 04:11:02 +0000
(21:11 -0700)
httemplate/search/477partV.html
patch
|
blob
|
history
diff --git
a/httemplate/search/477partV.html
b/httemplate/search/477partV.html
index
55ebc0b
..
0987fea
100755
(executable)
--- 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');
$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]+//;
my $count_query = delete($sql_query->{'count_query'});
$count_query =~ s/COUNT\(\*\)/count(DISTINCT substr(zip,1,5))/;
$count_query =~ s/ORDER BY [.\w]+//;