X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FCron%2Fnotify.pm;h=0603e6bc43774f4ebe73945b3dd054634b99d738;hb=96f045fb93dc522c012cddcbba2ded3b2a30db35;hp=622f15f6b4e658ccdf229fa3945262db75edf34c;hpb=9509e5bfb7f9331303153cac24d7bfecbe2ea9f1;p=freeside.git diff --git a/FS/FS/Cron/notify.pm b/FS/FS/Cron/notify.pm index 622f15f6b..0603e6bc4 100644 --- a/FS/FS/Cron/notify.pm +++ b/FS/FS/Cron/notify.pm @@ -30,7 +30,7 @@ sub notify_flat_delay { 0 < ( select count(*) from part_pkg where cust_pkg.pkgpart = part_pkg.pkgpart and part_pkg.plan = 'flat_delayed' - and 0 < ( select count (*) from part_pkg_option + and 0 < ( select count(*) from part_pkg_option where part_pkg.pkgpart = part_pkg_option.pkgpart and part_pkg_option.optionname = 'recur_notify' and part_pkg_option.optionvalue > 0 @@ -42,11 +42,15 @@ sub notify_flat_delay { or cust_pkg.expire > $time + cast(part_pkg_option.optionvalue as integer) * 86400 -/* and ( cust_pkg.adjourn is null - or cust_pkg.adjourn > $time --- Should notify suspended ones + cast(part_pkg_option.optionvalue as integer) - * 86400 -*/ +END + +#/* and ( cust_pkg.adjourn is null +# or cust_pkg.adjourn > $time +#-- Should notify suspended ones + cast(part_pkg_option.optionvalue as integer) +# * 86400 +#*/ + + $where_pkg .= <<"END"; ) ) )