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 ( !$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 } );
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;
if ( $username =~ /^(.+), (.+)$/ ) {
($lastname, $firstname) = ($1, $2);
$username = lc($firstname.$lastname);
+ $username =~ s/ //g;
}
my $access_user = new FS::access_user {
'username' => $username,
my $error = $record->replace;
die $error if $error;
}
+
+ if ( $table eq 'cust_attachment' ) {
+ warn " committing (cust_attachment) \n";
+ dbh->commit or die dbh->errstr;
+ }
}