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
|
#!/usr/bin/perl
use strict;
use vars qw( $opt_s $opt_e $opt_r $opt_u $opt_c );
use Getopt::Std;
use Date::Parse qw(str2time);
use Date::Format;
use FS::UID qw(adminsuidsetup dbh);
use FS::Record qw(qsearch qsearchs);
use FS::cust_pkg;
use FS::h_cust_pkg;
getopts('s:e:ruc');
my $user = shift or &usage;
adminsuidsetup $user;
my $sdate = $opt_s ? str2time($opt_s) : 0;
my $edate = $opt_e ? str2time($opt_e) + 86399 #not strictly correct on time zone boundary days, but good enough for this purpose
: 2147397248;
my $oldAutoCommit = $FS::UID::AutoCommit;
local $FS::UID::AutoCommit = 0;
my $dbh = dbh;
#my $fuzz = 2;
my $changed = 0;
foreach my $cust_pkg (
qsearch({ table => 'cust_pkg',
hashref => {
setup => '',
},
})
) {
my $h_cust_pkg =
qsearchs({ table => 'h_cust_pkg',
hashref => {
pkgnum => $cust_pkg->pkgnum,
setup => { op=>'!=', value=>'' },
($opt_u ? ('susp' => { op=>'!=', value=>'' })
: ()
),
($opt_c ? ('cancel' => { op=>'!=', value=>'' })
: ()
),
},
extra_sql => " AND history_action IN ('insert','replace_old')".
' AND history_date >= ? AND history_date <= ? ',
extra_param => [ [$sdate,'int'], [$edate,'int'] ],
order_by => 'ORDER BY history_date DESC LIMIT 1',
})
or next;
$changed++;
#if ( $opt_r ) {
#print "restoring setup for pkgnum ". $cust_pkg->pkgnum.
# " (custnum ". $cust_pkg->custnum.
# ") to ". time2str('%D', $h_cust_pkg->setup). "\n";
print $cust_pkg->pkgnum. ','.
time2str('%D', $h_cust_pkg->setup). ','.
$cust_pkg->custnum. ','.
'"'. $cust_pkg->cust_main->name. '"'. "\n";
#}
#don't actually do it yet ...
#$cust_pkg->set('setup', $h_cust_pkg->setup);
#my $error = $cust_pkg->replace;
##die $error if $error;
#warn "error changing pkgnum ". $cust_pkg->pkgnum.': '. $error."\n";
}
if ( $opt_r ) {
$dbh->rollback or die $dbh->errstr; #if $oldAutoCommit;
} else {
$dbh->commit or die $dbh->errstr; #if $oldAutoCommit;
}
print "changed $changed packages\n";
sub usage {
die "usage: cust_pkg-restore_setup [ -s history_start ] [ -e history_end ] [-r ] employee_username\n";
}
=head1 NAME
cust_pkg-restore_setup
=head1 SYNOPSIS
cust_pkg-restore_setup -d date -u history_username [ -r ] employee_username
=head1 DESCRIPTION
Command-line tool to restore removed setup dates.
-s: Start date of time period to restore changes from
-e: End date of time period to restore changes from
-u: sUspended packages only
-c: Cancelled packages only
-r: dRy run
employee_username
=head1 BUGS
=head1 SEE ALSO
L<FS::part_pkg>
=cut
1;
|
