diff options
| author | Jeremy Davis <jeremyd@freeside.biz> | 2013-07-02 15:46:54 -0400 |
|---|---|---|
| committer | Jeremy Davis <jeremyd@freeside.biz> | 2013-07-02 15:46:54 -0400 |
| commit | d412ac8b029ecf0dc3cb6d62d5a7afa91cfba740 (patch) | |
| tree | 5fe7361dde51a5d06d2ba32c9e8d87c2288e4ac7 | |
| parent | ac3b5a577bcd664425b21c51ded61008e2fe8494 (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 )'; |