blob: 0be6b43f41daeecbf4bf523c3d3292e1e68c603c (
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
69
70
71
72
73
74
75
76
77
78
79
80
81
|
#!/usr/bin/perl
use FS::UID qw(adminsuidsetup dbh);
use FS::Record qw(qsearch);
use Getopt::Std;
use vars qw($opt_t);
use FS::sales;
use FS::agent;
use FS::access_group;
use FS::access_groupagent;
use FS::cust_main;
# -t passes through the typenum in agent_type
getopts('t:');
adminsuidsetup shift or die &usage;
$FS::UID::AutoCommit = 0;
my @sales = qsearch('sales', {'disabled'=>''});
foreach my $sales (@sales) {
my $agent = new FS::agent {
'agent' => $sales->salesperson,
'agent_custnum' => $sales->sales_custnum,
'typenum' => $opt_t,
};
my $error = $agent->insert;
if ( $error ) {
dbh->rollback or die dbh->errstr;
die $error;
}
my $access_group = new FS::access_group {
'groupname' => $agent->agent,
};
$error = $access_group->insert;
if ( $error ) {
dbh->rollback or die dbh->errstr;
die $error;
}
my $access_groupagent = new FS::access_groupagent {
'groupnum' => $access_group->groupnum,
'agentnum' => $agent->agentnum,
};
$error = $access_groupagent->insert;
if ( $error ) {
dbh->rollback or die dbh->errstr;
die $error;
}
foreach my $cust_main (qsearch('cust_main', {'salesnum'=>$sales->salesnum})) {
$cust_main->salesnum('');
$cust_main->agentnum($agent->agentnum);
$error = $cust_main->replace;
if ( $error ) {
dbh->rollback or die dbh->errstr;
die $error;
}
}
$sales->disabled('');
$error = $sales->replace;
if ( $error ) {
dbh->rollback or die dbh->errstr;
die $error;
}
}
dbh->commit or die dbh->errstr;
1;
sub usage {
die "Usage:\n\n sales2agent username\n";
}
|
