blob: f186e195f78099ac2c3cddfd6ba03144c916c752 (
plain)
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
|
#!/usr/bin/perl
use FS::Misc::Getopt;
use FS::part_event;
use FS::cust_event;
use FS::Record 'dbdef';
use FS::Cursor;
getopts('e:x');
my $eventpart = $opt{e};
my $part_event = FS::part_event->by_key($opt{e})
or die "usage: initialize-event -e <eventpart> <username>\n";
my $eventtable = $part_event->eventtable;
my $pkey = dbdef->table($eventtable)->primary_key;
my $from = " LEFT JOIN (SELECT DISTINCT tablenum AS $pkey FROM cust_event
WHERE eventpart = $eventpart) AS done USING ($pkey)",
my $where = " WHERE done.$pkey IS NULL";
my $count = FS::Record->scalar_sql("SELECT COUNT(*) FROM $eventtable $from $where");
print "Event ".$part_event->event."\n".
"Will initialize on $count $eventtable records.\n";
if (!$opt{x}) {
print "Run with -x to make changes.\n";
exit;
}
print "Disabling event.\n";
$part_event->disabled('Y');
my $error = $part_event->replace;
die $error if $error;
my $cursor = FS::Cursor->new({
table => $eventtable,
addl_from => $from,
extra_sql => $where,
});
my $user = $FS::CurrentUser::CurrentUser->username;
my $statustext = "Manually by $user";
while (my $record = $cursor->fetch) {
my $cust_event = FS::cust_event->new({
status => 'initial',
eventpart => $eventpart,
tablenum => $record->get($pkey),
_date => $^T,
statustext => $statustext,
});
$error = $cust_event->insert;
if ($error) {
print "$eventtable #".$record->get($pkey).": $error\n" if $error;
} else {
$count--;
}
}
print "$count unprocessed records.";
if ($count == 0) {
print "Re-enabling event.\n";
$part_event->disabled('');
$error = $part_event->replace;
die $error if $error;
} else {
print "Event is still disabled.\n";
}
print "Finished.\n";
|