projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
ah, no, its count (*) vs count(*), wow
[freeside.git]
/
FS
/
FS
/
Cron
/
notify.pm
diff --git
a/FS/FS/Cron/notify.pm
b/FS/FS/Cron/notify.pm
index
3710650
..
0603e6b
100644
(file)
--- 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'
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
where part_pkg.pkgpart = part_pkg_option.pkgpart
and part_pkg_option.optionname = 'recur_notify'
and part_pkg_option.optionvalue > 0
@@
-42,6
+42,15
@@
sub notify_flat_delay {
or cust_pkg.expire > $time
+ cast(part_pkg_option.optionvalue as integer)
* 86400
or cust_pkg.expire > $time
+ 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";
)
)
)
)
)
)