projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
6a22335
)
calculate owed as subquery here too
author
ivan
<ivan>
Sun, 7 Jul 2002 13:30:02 +0000
(13:30 +0000)
committer
ivan
<ivan>
Sun, 7 Jul 2002 13:30:02 +0000
(13:30 +0000)
httemplate/search/cust_bill.cgi
patch
|
blob
|
history
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 {