Lines 268-274
sub GetReservesFromBiblionumber {
Link Here
|
268 |
FROM reserves |
268 |
FROM reserves |
269 |
WHERE biblionumber = ? "; |
269 |
WHERE biblionumber = ? "; |
270 |
unless ( $all_dates ) { |
270 |
unless ( $all_dates ) { |
271 |
$query .= "AND reservedate <= CURRENT_DATE()"; |
271 |
$query .= "AND reservedate <= CAST(now() AS date)"; |
272 |
} |
272 |
} |
273 |
$query .= "ORDER BY priority"; |
273 |
$query .= "ORDER BY priority"; |
274 |
my $sth = $dbh->prepare($query); |
274 |
my $sth = $dbh->prepare($query); |
Lines 334-340
sub GetReservesFromItemnumber {
Link Here
|
334 |
WHERE itemnumber=? |
334 |
WHERE itemnumber=? |
335 |
"; |
335 |
"; |
336 |
unless ( $all_dates ) { |
336 |
unless ( $all_dates ) { |
337 |
$query .= " AND reservedate <= CURRENT_DATE()"; |
337 |
$query .= " AND reservedate <= CAST(now() AS date)"; |
338 |
} |
338 |
} |
339 |
my $sth_res = $dbh->prepare($query); |
339 |
my $sth_res = $dbh->prepare($query); |
340 |
$sth_res->execute($itemnumber); |
340 |
$sth_res->execute($itemnumber); |
Lines 864-870
sub CancelExpiredReserves {
Link Here
|
864 |
# Cancel reserves that have passed their expiration date. |
864 |
# Cancel reserves that have passed their expiration date. |
865 |
my $dbh = C4::Context->dbh; |
865 |
my $dbh = C4::Context->dbh; |
866 |
my $sth = $dbh->prepare( " |
866 |
my $sth = $dbh->prepare( " |
867 |
SELECT * FROM reserves WHERE DATE(expirationdate) < DATE( CURDATE() ) |
867 |
SELECT * FROM reserves WHERE DATE(expirationdate) < CAST(now() AS date) |
868 |
AND expirationdate IS NOT NULL |
868 |
AND expirationdate IS NOT NULL |
869 |
AND found IS NULL |
869 |
AND found IS NULL |
870 |
" ); |
870 |
" ); |
Lines 1615-1621
sub _Findgroupreserve {
Link Here
|
1615 |
AND priority > 0 |
1615 |
AND priority > 0 |
1616 |
AND item_level_request = 1 |
1616 |
AND item_level_request = 1 |
1617 |
AND itemnumber = ? |
1617 |
AND itemnumber = ? |
1618 |
AND reservedate <= CURRENT_DATE() |
1618 |
AND reservedate <= CAST(now() AS date) |
1619 |
/; |
1619 |
/; |
1620 |
my $sth = $dbh->prepare($item_level_target_query); |
1620 |
my $sth = $dbh->prepare($item_level_target_query); |
1621 |
$sth->execute($itemnumber); |
1621 |
$sth->execute($itemnumber); |
Lines 1645-1651
sub _Findgroupreserve {
Link Here
|
1645 |
AND priority > 0 |
1645 |
AND priority > 0 |
1646 |
AND item_level_request = 0 |
1646 |
AND item_level_request = 0 |
1647 |
AND hold_fill_targets.itemnumber = ? |
1647 |
AND hold_fill_targets.itemnumber = ? |
1648 |
AND reservedate <= CURRENT_DATE() |
1648 |
AND reservedate <= CAST(now() AS date) |
1649 |
/; |
1649 |
/; |
1650 |
$sth = $dbh->prepare($title_level_target_query); |
1650 |
$sth = $dbh->prepare($title_level_target_query); |
1651 |
$sth->execute($itemnumber); |
1651 |
$sth->execute($itemnumber); |
Lines 1676-1682
sub _Findgroupreserve {
Link Here
|
1676 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1676 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1677 |
OR reserves.constrainttype='a' ) |
1677 |
OR reserves.constrainttype='a' ) |
1678 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1678 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1679 |
AND reserves.reservedate <= CURRENT_DATE() |
1679 |
AND reserves.reservedate <= CAST(now() AS date) |
1680 |
/; |
1680 |
/; |
1681 |
$sth = $dbh->prepare($query); |
1681 |
$sth = $dbh->prepare($query); |
1682 |
$sth->execute( $biblio, $bibitem, $itemnumber ); |
1682 |
$sth->execute( $biblio, $bibitem, $itemnumber ); |