diff options
| -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 )'; |