From: ivan Date: Tue, 20 Jan 2009 20:11:05 +0000 (+0000) Subject: whew, hopefully that will actually fix agent-specific invoices migrated from 1.7... X-Git-Tag: root_of_webpay_support~120 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=dbd5ae96e06cb6dfdbeed7e019b519c6c71cf7c5 whew, hopefully that will actually fix agent-specific invoices migrated from 1.7->1.9, RT#4645 --- diff --git a/FS/FS/cust_main.pm b/FS/FS/cust_main.pm index 77e08fe1c..e6c808408 100644 --- a/FS/FS/cust_main.pm +++ b/FS/FS/cust_main.pm @@ -7075,7 +7075,7 @@ sub _agent_plandata { " AND peo_agentnum.optionname = 'agentnum' ". " AND ( agentnum IS NULL OR agentnum = $agentnum ) ". " ORDER BY - CASE WHEN peo_cust_bill_age.optionname != 'cust_bill_age' + CASE WHEN part_event_condition_option.optionname IS NULL THEN -1 ELSE ". FS::part_event::Condition->age2seconds_sql('part_event_condition_option.optionvalue'). " END