X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fotaker_Mixin.pm;h=8d9c8824f54b4b96bc3e95c082f868496a4ee9c7;hp=ca170186be0c1e11d53d8b59d8920b5924fe87c3;hb=90393980e5f2859ee1e186fa461f48f5129e803e;hpb=d073f37f96c2cf88ca42c87a1972ecbbd5f5478e diff --git a/FS/FS/otaker_Mixin.pm b/FS/FS/otaker_Mixin.pm index ca170186b..8d9c8824f 100644 --- a/FS/FS/otaker_Mixin.pm +++ b/FS/FS/otaker_Mixin.pm @@ -11,8 +11,12 @@ sub otaker { my $otaker = shift; my $access_user = qsearchs('access_user', { 'username' => $otaker } ); if ( !$access_user && $otaker =~ /^(.+), (.+)$/ ) { #same as below.. - $otaker = lc($2.$1); - $access_user = qsearchs('access_user', { 'username' => $otaker } ); + 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 ); @@ -37,11 +41,13 @@ 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 1000', + 'extra_sql' => "WHERE otaker IS NOT NULL LIMIT $limit", }); last unless @records; @@ -49,14 +55,17 @@ sub _upgrade_otaker { eval { $record->otaker($record->otaker) }; if ( $@ ) { my $username = $record->otaker; + my($lastname, $firstname) = ( 'User', 'Legacy' ); if ( $username =~ /^(.+), (.+)$/ ) { - $username = lc($2.$1); + ($lastname, $firstname) = ($1, $2); + $username = lc($firstname.$lastname); + $username =~ s/ //g; } my $access_user = new FS::access_user { 'username' => $username, '_password' => 'CHANGEME', - 'first' => 'Legacy', - 'last' => 'User', + 'first' => $firstname, + 'last' => $lastname, 'disabled' => 'Y', }; my $error = $access_user->insert;