diff options
Diffstat (limited to 'httemplate')
| -rwxr-xr-x | httemplate/search/cust_credit.html | 4 | ||||
| -rwxr-xr-x | httemplate/search/cust_pay.cgi | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/httemplate/search/cust_credit.html b/httemplate/search/cust_credit.html index a3f88cc21..85128bca2 100755 --- a/httemplate/search/cust_credit.html +++ b/httemplate/search/cust_credit.html @@ -41,14 +41,14 @@ : ''; my $count_query = 'SELECT COUNT(*), SUM(amount) '. - 'FROM cust_credit JOIN cust_main USING ( custnum ) '. + 'FROM cust_credit LEFT JOIN cust_main USING ( custnum ) '. $where; my $sql_query = { 'table' => 'cust_credit', 'hashref' => {}, 'extra_sql' => $where, - 'addl_from' => 'JOIN cust_main USING ( custnum )', + 'addl_from' => 'LEFT JOIN cust_main USING ( custnum )', }; my $clink = [ "${p}view/cust_main.cgi?", 'custnum' ]; diff --git a/httemplate/search/cust_pay.cgi b/httemplate/search/cust_pay.cgi index 42b3c01bc..64fe1f93a 100755 --- a/httemplate/search/cust_pay.cgi +++ b/httemplate/search/cust_pay.cgi @@ -68,7 +68,7 @@ my $hsearch = join(' AND ', map { "$_ = '$search{$_}'" } keys %search ); $count_query = "SELECT COUNT(*), SUM(paid) ". - "FROM cust_pay JOIN cust_main USING ( custnum )". + "FROM cust_pay LEFT JOIN cust_main USING ( custnum )". ( $hsearch ? " WHERE $hsearch " : '' ). $search; @@ -77,7 +77,7 @@ 'table' => 'cust_pay', 'hashref' => \%search, 'extra_sql' => "$search ORDER BY _date", - 'addl_from' => 'JOIN cust_main USING ( custnum )', + 'addl_from' => 'LEFT JOIN cust_main USING ( custnum )', }; } else { |