projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
recommend HTML::Mason
[freeside.git]
/
httemplate
/
search
/
cust_bill.html
diff --git
a/httemplate/search/cust_bill.html
b/httemplate/search/cust_bill.html
index
f65b082
..
3ae624a
100755
(executable)
--- a/
httemplate/search/cust_bill.html
+++ b/
httemplate/search/cust_bill.html
@@
-41,7
+41,7
@@
} else {
$cgi->param('invnum') =~ /^\s*(FS-)?(\d+)\s*$/;
} else {
$cgi->param('invnum') =~ /^\s*(FS-)?(\d+)\s*$/;
- $count_query =
'SELECT 1'
;
+ $count_query =
"SELECT COUNT(*) FROM cust_bill WHERE invnum = $2"
;
$sql_query = {
'table' => 'cust_bill',
'hashref' => { 'invnum' => $2 },
$sql_query = {
'table' => 'cust_bill',
'hashref' => { 'invnum' => $2 },
@@
-50,7
+50,13
@@
}
my $link = [ "${p}view/cust_bill.cgi?", 'invnum', ];
}
my $link = [ "${p}view/cust_bill.cgi?", 'invnum', ];
- my $clink = [ "${p}view/cust_main.cgi?", 'custnum' ];
+ my $clink = sub {
+ my $cust_bill = shift;
+ my $cust_main = $cust_bill->cust_main;
+ $cust_main
+ ? [ "${p}view/cust_main.cgi?", 'custnum' ]
+ : '';
+ };
%>
<%= include( 'elements/search.html',
%>
<%= include( 'elements/search.html',