diff options
author | Ivan Kohler <ivan@freeside.biz> | 2014-05-28 00:09:05 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2014-05-28 00:09:05 -0700 |
commit | 0eee55572b0f8d841f7d1a863d92211d3a6d9e31 (patch) | |
tree | a3262e8a96316d9fee7b4b2e6a4d6d695c0b6b31 /FS | |
parent | eafc26d312b2d7d392f117b946d63a19166bda63 (diff) |
fix credit limit query for older DBD::Pg, RT#27267
Diffstat (limited to 'FS')
-rw-r--r-- | FS/FS/cust_main/Credit_Limit.pm | 11 |
1 files changed, 4 insertions, 7 deletions
diff --git a/FS/FS/cust_main/Credit_Limit.pm b/FS/FS/cust_main/Credit_Limit.pm index 238d8852f..4b2fbdfe4 100644 --- a/FS/FS/cust_main/Credit_Limit.pm +++ b/FS/FS/cust_main/Credit_Limit.pm @@ -42,13 +42,10 @@ sub check_credit_limit { #false laziness w/svc_phone->sum_cdrs / psearch_cdrs my $sum = qsearchs( { - 'select' => 'SUM(rated_price) AS rated_price', - 'table' => 'cdr', - 'hashref' => { 'status' => 'rated', - 'svcnum' => { op => 'IN', - value => '('. join(',',@svcnum). ')', - }, - }, + 'select' => 'SUM(rated_price) AS rated_price', + 'table' => 'cdr', + 'hashref' => { 'status' => 'rated', }, + 'extra_sql' => ' AND svcnum IN ('. join(',',@svcnum). ') ', } ); return '' unless $sum->rated_price > $credit_limit; |