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
|
package FS::otaker_Mixin;
use strict;
use Carp qw( croak ); #confess );
use FS::Record qw( qsearch qsearchs );
use FS::access_user;
use FS::UID qw( dbh );
sub otaker {
my $self = shift;
if ( scalar(@_) ) { #set
my $otaker = shift;
my $access_user = qsearchs('access_user', { 'username' => $otaker } );
if ( !$access_user && $otaker =~ /^(.+), (.+)$/ ) { #same as below..
my($lastname, $firstname) = ($1, $2);
$otaker = lc($firstname.$lastname);
$otaker =~ s/ //g;
$access_user = qsearchs('access_user', { 'first' => $firstname,
'last' => $lastname } )
|| qsearchs('access_user', { 'username' => $otaker } );
}
croak "can't set otaker: $otaker not found!" unless $access_user; #confess?
$self->usernum( $access_user->usernum );
$otaker; #not sure return is used anywhere, but just in case
} else { #get
if ( $self->usernum ) {
$self->access_user->username;
} elsif ( length($self->get('otaker')) ) {
$self->get('otaker');
} else {
'';
}
}
}
sub access_user {
my $self = shift;
qsearchs('access_user', { 'usernum' => $self->usernum } );
}
sub _upgrade_otaker {
my $class = shift;
my $table = $class->table;
my $limit = ( $table eq 'cust_attachment' ? 10 : 1000 );
while ( 1 ) {
my @records = qsearch({
'table' => $table,
'hashref' => {},
'extra_sql' => "WHERE otaker IS NOT NULL LIMIT $limit",
});
last unless @records;
foreach my $record (@records) {
eval { $record->otaker($record->otaker) };
if ( $@ ) {
my $username = $record->otaker;
my($lastname, $firstname) = ( 'User', 'Legacy' );
if ( $username =~ /^(.+), (.+)$/ ) {
($lastname, $firstname) = ($1, $2);
$username = lc($firstname.$lastname);
$username =~ s/ //g;
}
my $access_user = new FS::access_user {
'username' => $username,
'_password' => 'CHANGEME',
'first' => $firstname,
'last' => $lastname,
'disabled' => 'Y',
};
my $error = $access_user->insert;
die $error if $error;
$record->otaker($record->otaker);
}
$record->set('otaker', '');
my $error = $record->replace;
die $error if $error;
}
if ( $table eq 'cust_attachment' ) {
warn " committing (cust_attachment) \n";
dbh->commit or die dbh->errstr;
}
}
}
1;
|