From d4f9df58cf2ba98b83b90bf0739a44bac8611abf Mon Sep 17 00:00:00 2001 From: Jeremy Davis Date: Tue, 2 Jul 2013 15:20:50 -0400 Subject: [PATCH] #23171 Fix contract age condition --- FS/FS/part_event/Condition/pkg_age.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 )'; -- 2.11.0