diff options
| author | Jeremy Davis <jeremyd@freeside.biz> | 2013-07-02 15:20:50 -0400 |
|---|---|---|
| committer | Jeremy Davis <jeremyd@freeside.biz> | 2013-07-02 15:20:50 -0400 |
| commit | d4f9df58cf2ba98b83b90bf0739a44bac8611abf (patch) | |
| tree | 70b4be5f2b0d2df752dd60d8bb17dd015b820291 | |
| parent | 3564f619654c5cbf22fc2acbe7eff0c08308e859 (diff) | |
#23171 Fix contract age condition
| -rw-r--r-- | FS/FS/part_event/Condition/pkg_age.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/part_event/Condition/pkg_age.pm b/FS/FS/part_event/Condition/pkg_age.pm index 24a73e22f..de5897097 100644 --- a/FS/FS/part_event/Condition/pkg_age.pm +++ b/FS/FS/part_event/Condition/pkg_age.pm @@ -57,7 +57,7 @@ sub condition_sql { my $field = $class->condition_sql_option('field'); #amazingly, this is actually faster my $sql = '( CASE'; - foreach( qw(setup last_bill bill adjourn susp expire cancel) ) { + foreach( qw(setup last_bill bill adjourn susp expire cancel contract_end) ) { $sql .= " WHEN $field = '$_' THEN (cust_pkg.$_ IS NOT NULL AND cust_pkg.$_ <= $age)"; } $sql .= ' END )'; |