projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
calculate owed as subquery here too
[freeside.git]
/
httemplate
/
search
/
cust_bill.cgi
diff --git
a/httemplate/search/cust_bill.cgi
b/httemplate/search/cust_bill.cgi
index
f4ead70
..
d2a3573
100755
(executable)
--- a/
httemplate/search/cust_bill.cgi
+++ b/
httemplate/search/cust_bill.cgi
@@
-79,9
+79,7
@@
if ( $cgi->keywords ) {
@cust_bill = qsearch(
'cust_bill',
{},
- 'cust_bill.*,
- charged - coalesce(sum(cust_bill_pay.amount),0)
- - coalesce(sum(cust_credit_bill.amount),0) as owed',
+ "cust_bill.*, $owed as owed"
"$extra_sql $orderby $limit"
);
} else {