diff options
| author | levinse <levinse> | 2011-05-08 20:09:07 +0000 |
|---|---|---|
| committer | levinse <levinse> | 2011-05-08 20:09:07 +0000 |
| commit | 038df36a543789c14adce6bc0838dd257c26ab79 (patch) | |
| tree | 469d1a82c33ece033213e3b1aae0b8c498377bdd | |
| parent | 19085e42d41f36f9ec70ff143bebe293fdcac350 (diff) | |
implement condition_sql for FS::part_event::Condition::cust_bill_hasnt_noauto, RT12714
| -rw-r--r-- | FS/FS/Schema.pm | 4 | ||||
| -rw-r--r-- | FS/FS/part_event/Condition/cust_bill_hasnt_noauto.pm | 1 |
2 files changed, 2 insertions, 3 deletions
diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm index 59799c7d1..2eb8d37ff 100644 --- a/FS/FS/Schema.pm +++ b/FS/FS/Schema.pm @@ -1347,7 +1347,7 @@ sub tables_hashref { [ 'usernum' ], [ 'agent_pkgid' ], ['order_date'], [ 'start_date' ], ['setup'], ['bill'], ['last_bill'], ['susp'], ['adjourn'], ['cancel'], - ['expire'], ['contract_end'], ['change_date'], + ['expire'], ['contract_end'], ['change_date'], ['no_auto'], ], }, @@ -1526,7 +1526,7 @@ sub tables_hashref { 'primary_key' => 'pkgpart', 'unique' => [], 'index' => [ [ 'promo_code' ], [ 'disabled' ], [ 'classnum' ], - [ 'agentnum' ], + [ 'agentnum' ], ['no_auto'], ], }, diff --git a/FS/FS/part_event/Condition/cust_bill_hasnt_noauto.pm b/FS/FS/part_event/Condition/cust_bill_hasnt_noauto.pm index bb0f3d04a..027625569 100644 --- a/FS/FS/part_event/Condition/cust_bill_hasnt_noauto.pm +++ b/FS/FS/part_event/Condition/cust_bill_hasnt_noauto.pm @@ -29,7 +29,6 @@ sub condition_sql { # XXX: can be made faster with optimizations? # -remove some/all sub-selects? # -remove the two main separate selects? - # -add indices on cust_pkg.no_auto and part_pkg.no_auto and others? "0 = (select count(1) from cust_pkg where cust_pkg.no_auto = 'Y' and cust_pkg.pkgnum in |