diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-06-24 00:32:59 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-06-24 00:32:59 -0700 |
| commit | b3f4989d724bc64c0e753fa4fa83fe2196d9476f (patch) | |
| tree | c8ae1423d386aeee5f1b3f44aaf5b91cc0cd8a0d /FS/FS/cust_main/Credit_Limit.pm | |
| parent | ee05571f35f357d3558c9f6e8d23799fb69c0cbf (diff) | |
fix credit limits, RT#27267
Diffstat (limited to 'FS/FS/cust_main/Credit_Limit.pm')
| -rw-r--r-- | FS/FS/cust_main/Credit_Limit.pm | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/FS/FS/cust_main/Credit_Limit.pm b/FS/FS/cust_main/Credit_Limit.pm index a6beb22..8a2caa4 100644 --- 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', - '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; |