diff options
author | mark <mark> | 2010-05-20 01:33:08 +0000 |
---|---|---|
committer | mark <mark> | 2010-05-20 01:33:08 +0000 |
commit | 08b36523ebbf6e2995878f26bfac988f32f7a218 (patch) | |
tree | a9352c8bed56d918a89ebff37a33fb0a6acb8431 /FS/FS/cust_refund.pm | |
parent | 07c8992ccbb2d179939af013e9c90774a093f820 (diff) |
RT#7266: aging report "as of" date now limits applied payments
Diffstat (limited to 'FS/FS/cust_refund.pm')
-rw-r--r-- | FS/FS/cust_refund.pm | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/FS/FS/cust_refund.pm b/FS/FS/cust_refund.pm index e7c5a82..6d08c86 100644 --- a/FS/FS/cust_refund.pm +++ b/FS/FS/cust_refund.pm @@ -343,17 +343,23 @@ Returns an SQL fragment to retreive the unapplied amount. =cut sub unapplied_sql { - #my $class = shift; + my ($class, $start, $end) = shift; + my $credit_start = $start ? "AND cust_credit_refund._date <= $start" : ''; + my $credit_end = $end ? "AND cust_credit_refund._date > $end" : ''; + my $pay_start = $start ? "AND cust_pay_refund._date <= $start" : ''; + my $pay_end = $end ? "AND cust_pay_refund._date > $end" : ''; "refund - COALESCE( ( SELECT SUM(amount) FROM cust_credit_refund - WHERE cust_refund.refundnum = cust_credit_refund.refundnum ) + WHERE cust_refund.refundnum = cust_credit_refund.refundnum + $credit_start $credit_end ) ,0 ) - COALESCE( ( SELECT SUM(amount) FROM cust_pay_refund - WHERE cust_refund.refundnum = cust_pay_refund.refundnum ) + WHERE cust_refund.refundnum = cust_pay_refund.refundnum + $pay_start $pay_end ) ,0 ) "; |