projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (from parent 1:
807477c
)
fix credit limits, RT#27267
author
Ivan Kohler
<ivan@freeside.biz>
Tue, 24 Jun 2014 07:33:01 +0000
(
00:33
-0700)
committer
Ivan Kohler
<ivan@freeside.biz>
Tue, 24 Jun 2014 07:33:01 +0000
(
00:33
-0700)
FS/FS/cust_main/Credit_Limit.pm
patch
|
blob
|
history
diff --git
a/FS/FS/cust_main/Credit_Limit.pm
b/FS/FS/cust_main/Credit_Limit.pm
index
a6beb22
..
8a2caa4
100644
(file)
--- a/
FS/FS/cust_main/Credit_Limit.pm
+++ b/
FS/FS/cust_main/Credit_Limit.pm
@@
-44,8
+44,9
@@
sub check_credit_limit {
my $sum = qsearchs( {
'select' => 'SUM(rated_price) AS rated_price',
'table' => 'cdr',
my $sum = qsearchs( {
'select' => 'SUM(rated_price) AS rated_price',
'table' => 'cdr',
- 'hashref' => { 'freesidestatus' => 'rated', },
- 'extra_sql' => ' AND svcnum IN ('. join(',',@svcnum). ') ',
+ #'hashref' => { 'freesidestatus' => 'rated', },
+ 'extra_sql' => " WHERE freesidestatus = 'rated' ".
+ ' AND svcnum IN ('. join(',',@svcnum). ') ',
} );
return '' unless $sum->rated_price > $credit_limit;
} );
return '' unless $sum->rated_price > $credit_limit;