1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
package FS::Cron::notify;
use strict;
use vars qw( @ISA @EXPORT_OK $DEBUG );
use Exporter;
use FS::UID qw( dbh );
use FS::Record qw(qsearch);
use FS::cust_main;
use FS::cust_pkg;
@ISA = qw( Exporter );
@EXPORT_OK = qw ( notify_flat_delay );
$DEBUG = 0;
sub notify_flat_delay {
my %opt = @_;
my $oldAutoCommit = $FS::UID::AutoCommit;
$DEBUG = 1 if $opt{'v'};
#we're at now now (and later).
my($time) = $^T;
# select * from cust_pkg where
my $where_pkg = <<"END";
where ( cancel is null or cancel = 0 )
and ( bill > 0 )
and
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
where part_pkg.pkgpart = part_pkg_option.pkgpart
and part_pkg_option.optionname = 'recur_notify'
and part_pkg_option.optionvalue > 0
and 0 <= $time
+ cast(part_pkg_option.optionvalue as integer)
* 86400
- cust_pkg.bill
and ( cust_pkg.expire is null
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
*/
)
)
)
and
0 = ( select count(*) from cust_pkg_option
where cust_pkg.pkgnum = cust_pkg_option.pkgnum
and cust_pkg_option.optionname = 'impending_recur_notification_sent'
and cust_pkg_option.optionvalue = 1
)
END
if ($opt{a}) {
$where_pkg .= <<END;
and 0 < ( select count(*) from cust_main
where cust_pkg.custnum = cust_main.custnum
and cust_main.agentnum = $opt{a}
)
END
}
my @cust_pkg;
if ( @ARGV ) {
$where_pkg .= "and ( " . join( "OR ", map { "custnum = $_" } @ARGV) . " )";
}
my $orderby = "order by custnum, bill";
my $extra_sql = "$where_pkg $orderby";
@cust_pkg = qsearch('cust_pkg', {}, '', $extra_sql );
my @packages = ();
my @recurdates = ();
my @cust_pkgs = ();
while ( scalar(@cust_pkg) ) {
my $cust_main = $cust_pkg[0]->cust_main;
my $custnum = $cust_pkg[0]->custnum;
warn "working on $custnum" if $DEBUG;
while (scalar(@cust_pkg)){
last if ($cust_pkg[0]->custnum != $custnum);
warn "storing information on " . $cust_pkg[0]->pkgnum if $DEBUG;
push @packages, $cust_pkg[0]->part_pkg->pkg;
push @recurdates, $cust_pkg[0]->bill;
push @cust_pkgs, $cust_pkg[0];
shift @cust_pkg;
}
my $error =
$cust_main->notify( 'impending_recur_template',
'extra_fields' => { 'packages' => \@packages,
'recurdates' => \@recurdates,
'package' => $packages[0],
'recurdate' => $recurdates[0],
},
);
warn "Error notifying, custnum ". $cust_main->custnum. ": $error" if $error;
unless ($error) {
local $SIG{HUP} = 'IGNORE';
local $SIG{INT} = 'IGNORE';
local $SIG{QUIT} = 'IGNORE';
local $SIG{TERM} = 'IGNORE';
local $SIG{TSTP} = 'IGNORE';
my $oldAutoCommit = $FS::UID::AutoCommit;
local $FS::UID::AutoCommit = 0;
my $dbh = dbh;
for (@cust_pkgs) {
my %options = ($_->options, 'impending_recur_notification_sent' => 1 );
$error = $_->replace( $_, options => \%options );
if ($error){
$dbh->rollback or die $dbh->errstr if $oldAutoCommit;
die "Error updating package options for customer". $cust_main->custnum.
": $error" if $error;
}
}
$dbh->commit or die $dbh->errstr if $oldAutoCommit;
}
@packages = ();
@recurdates = ();
@cust_pkgs = ();
}
dbh->commit or die dbh->errstr if $oldAutoCommit;
}
1;
|