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
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";
)
)
)