diff options
| author | ivan <ivan> | 2009-04-25 17:02:59 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-04-25 17:02:59 +0000 |
| commit | c5b1888828acf880864aaba351e07f1c767ad841 (patch) | |
| tree | df57311a8cdd681ef7ee0ef66c874372c4897e2f | |
| parent | 713614726f774e7bf0de34a2a95c513f2e1cc558 (diff) | |
well. that never returned any results at all. reverting. RT#4412
| -rw-r--r-- | FS/FS/Cron/bill.pm | 45 |
1 files changed, 22 insertions, 23 deletions
diff --git a/FS/FS/Cron/bill.pm b/FS/FS/Cron/bill.pm index e699d3966..f06fc1532 100644 --- a/FS/FS/Cron/bill.pm +++ b/FS/FS/Cron/bill.pm @@ -64,30 +64,29 @@ END # or my $where_bill_event = <<"END"; 0 < ( select count(*) from cust_bill - - LEFT JOIN cust_bill_pay USING ( invnum ) - LEFT JOIN cust_credit_bill USING ( invnum ) - LEFT JOIN part_bill_event ON ( - cust_main.payby = part_bill_event.payby - AND ( disabled IS NULL or disabled = '' ) - AND seconds <= $time - cust_bill._date - ) - LEFT JOIN cust_bill_event ON ( - part_bill_event.eventpart = cust_bill_event.eventpart - AND cust_bill_event.invnum = cust_bill_event.invnum - AND status = 'done' - ) - where cust_main.custnum = cust_bill.custnum - - GROUP BY cust_bill.invnum, cust_bill.charged - HAVING - 0 < charged - - coalesce( sum(cust_bill_pay.amount) ,0 ) - - coalesce( sum(cust_credit_bill.amount), 0 ) - AND - 0 < COUNT( cust_bill_event.eventnum IS NULL ) - + and 0 < charged + - coalesce( + ( select sum(amount) from cust_bill_pay + where cust_bill.invnum = cust_bill_pay.invnum ) + ,0 + ) + - coalesce( + ( select sum(amount) from cust_credit_bill + where cust_bill.invnum = cust_credit_bill.invnum ) + ,0 + ) + and 0 < ( select count(*) from part_bill_event + where payby = cust_main.payby + and ( disabled is null or disabled = '' ) + and seconds <= $time - cust_bill._date + and 0 = ( select count(*) from cust_bill_event + where cust_bill.invnum = cust_bill_event.invnum + and part_bill_event.eventpart = cust_bill_event.eventpart + and status = 'done' + ) + + ) ) END |