diff options
| author | ivan <ivan> | 2011-03-30 19:49:09 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2011-03-30 19:49:09 +0000 |
| commit | a1cde9ea31bf9f019ecf706efb158c2baa11efa7 (patch) | |
| tree | bfcc311d82cafa927bf5e779e245b6020fd88f2d | |
| parent | d173c0ab4d47eea5fc0d76b9f8d94b7dc6a44cfb (diff) | |
fix package balance conditions, RT#11834
| -rw-r--r-- | FS/FS/cust_bill.pm | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/FS/FS/cust_bill.pm b/FS/FS/cust_bill.pm index 9f27a74ba..dd8fab231 100644 --- a/FS/FS/cust_bill.pm +++ b/FS/FS/cust_bill.pm @@ -683,9 +683,8 @@ sub cust_bill_pay_pkg { 'table' => 'cust_bill_pay_pkg', 'addl_from' => ' LEFT JOIN cust_bill_pay USING ( billpaynum ) '. ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', - 'hashref' => { 'invnum' => $self->invnum, - 'pkgnum' => $pkgnum, - }, + 'extra_sql' => ' WHERE invnum = '. $self->invnum. + " AND pkgnum = $pkgnum", }); } @@ -728,9 +727,8 @@ sub cust_credit_bill_pkg { 'table' => 'cust_credit_bill_pkg', 'addl_from' => ' LEFT JOIN cust_credit_bill USING ( creditbillnum ) '. ' LEFT JOIN cust_bill_pkg USING ( billpkgnum ) ', - 'hashref' => { 'invnum' => $self->invnum, - 'pkgnum' => $pkgnum, - }, + 'extra_sql' => ' WHERE invnum = '. $self->invnum. + " AND pkgnum = $pkgnum", }); } |