use strict;
use warnings;
-use C4::Items qw/ CartToShelf /;
+use Koha::Script -cron;
+use C4::Items qw( CartToShelf );
+use C4::Log qw( cronlogaction );
-BEGIN {
-
- # find Koha's Perl modules
- # test carefully before changing this
- use FindBin;
- eval { require "$FindBin::Bin/../kohalib.pl" };
-}
use C4::Context;
-use Getopt::Long;
+use Getopt::Long qw( GetOptions );
my $hours = 0;
die "ERROR: No --hours (-h) option defined";
}
+cronlogaction();
+
my $query = "SELECT itemnumber FROM items WHERE location = 'CART' AND TIMESTAMPDIFF(HOUR, items.timestamp, NOW() ) > ?";
my $sth = C4::Context->dbh->prepare($query);
$sth->execute($hours);