From: ivan <ivan>
Date: Fri, 5 Aug 2011 03:27:16 +0000 (+0000)
Subject: fix billday condition without a delay option causing the event to never run, RT#13915
X-Git-Tag: freeside_2_1_3~46
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=b7d483c833537c23e031a222f72cc48edf15f349

fix billday condition without a delay option causing the event to never run, RT#13915
---

diff --git a/FS/FS/part_event/Condition.pm b/FS/FS/part_event/Condition.pm
index efe0d3cf3..b62440750 100644
--- a/FS/FS/part_event/Condition.pm
+++ b/FS/FS/part_event/Condition.pm
@@ -469,7 +469,10 @@ sub condition_sql_option_integer {
 
   my $integer = ($driver_name =~ /^mysql/) ? 'UNSIGNED INTEGER' : 'INTEGER';
 
-  'CAST('. $class->condition_sql_option($option). " AS $integer )";
+  'CAST(
+         COALESCE('. $class->condition_sql_option($option).
+                " ,'0') ".
+       " AS $integer )";
 }
 
 =head1 NEW CONDITION CLASSES