} 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 },
}
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',