my ($biblionumber) = shift or return (0, []);
my ($all_dates) = shift;
my ($itemnumber) = shift;
- warn "ITEMNUMBER: $itemnumber";
my $dbh = C4::Context->dbh;
# Find the desired items in the reserves
WHERE biblionumber = ? ";
push( @params, $biblionumber );
unless ( $all_dates ) {
- $query .= " AND reservedate <= CURRENT_DATE() ";
+ $query .= " AND reservedate <= CAST(NOW() AS DATE) ";
}
if ( $itemnumber ) {
$query .= " AND ( itemnumber IS NULL OR itemnumber = ? )";