@@ -, +, @@ value x in days_in_advance). --- .../borrowers-force-messaging-defaults.pl | 20 +++----------------- 1 file changed, 3 insertions(+), 17 deletions(-) --- a/misc/maintenance/borrowers-force-messaging-defaults.pl +++ a/misc/maintenance/borrowers-force-messaging-defaults.pl @@ -39,7 +39,7 @@ sub usage { sub force_borrower_messaging_defaults { - my ($doit, $truncate, $since, $actives, $no_overwrite) = @_; + my ($doit, $since, $actives, $no_overwrite) = @_; $since = '0000-00-00' if (!$since); print "Since: $since\n"; @@ -47,13 +47,6 @@ sub force_borrower_messaging_defaults { my $dbh = C4::Context->dbh; $dbh->{AutoCommit} = 0; - if ( $doit && $truncate ) { - $dbh->do(q|SET FOREIGN_KEY_CHECKS = 0|); - $dbh->do(q|TRUNCATE borrower_message_transport_preferences|); - $dbh->do(q|TRUNCATE borrower_message_preferences|); - $dbh->do(q|SET FOREIGN_KEY_CHECKS = 1|); - } - my $sql = "SELECT borrowernumber, categorycode FROM borrowers bo WHERE dateenrolled >= ?"; if ($actives) { $sql .= " AND dateexpiry > NOW()" @@ -75,10 +68,9 @@ sub force_borrower_messaging_defaults { } -my ( $doit, $truncate, $since, $help, $actives, $no_overwrite ); +my ( $doit, $since, $help, $actives, $no_overwrite ); my $result = GetOptions( 'doit' => \$doit, - 'truncate' => \$truncate, 'since:s' => \$since, 'actives' => \$actives, 'no_overwrite' => \$no_overwrite, @@ -87,7 +79,7 @@ my $result = GetOptions( usage() if $help; -force_borrower_messaging_defaults( $doit, $truncate, $since, $actives, $no_overwrite ); +force_borrower_messaging_defaults( $doit, $since, $actives, $no_overwrite ); =head1 NAME @@ -98,7 +90,6 @@ force-borrower-messaging-defaults force-borrower-messaging-defaults force-borrower-messaging-defaults --help force-borrower-messaging-defaults --doit - force-borrower-messaging-defaults --doit --truncate force-borrower-messaging-defaults --doit --actives =head1 DESCRIPTION @@ -123,11 +114,6 @@ Prints this help Actually update the borrowers. -=item B<--truncate> - -Truncate all borrowers transport preferences before (re-)creating them. It -affects borrower_message_preferences table. - =item B<--actives> Will only update active borrowers (borrowers who didn't pass their expiration date). --