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 } )
- or croak "can't set otaker: $otaker not found!"; #confess?
+ 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
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 1000',
+ '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' => $record->otaker,
+ 'username' => $username,
'_password' => 'CHANGEME',
- 'first' => 'Legacy',
- 'last' => 'User',
+ 'first' => $firstname,
+ 'last' => $lastname,
'disabled' => 'Y',
};
my $error = $access_user->insert;
my $error = $record->replace;
die $error if $error;
}
+
+ if ( $table eq 'cust_attachment' ) {
+ warn " committing (cust_attachment) \n";
+ dbh->commit or die dbh->errstr;
+ }
}