Lines 274-280
sub GetReservesFromBiblionumber {
Link Here
|
274 |
FROM reserves |
274 |
FROM reserves |
275 |
WHERE biblionumber = ? "; |
275 |
WHERE biblionumber = ? "; |
276 |
unless ( $all_dates ) { |
276 |
unless ( $all_dates ) { |
277 |
$query .= "AND reservedate <= CURRENT_DATE()"; |
277 |
$query .= "AND reservedate <= CAST(now() AS date)"; |
278 |
} |
278 |
} |
279 |
$query .= "ORDER BY priority"; |
279 |
$query .= "ORDER BY priority"; |
280 |
my $sth = $dbh->prepare($query); |
280 |
my $sth = $dbh->prepare($query); |
Lines 340-346
sub GetReservesFromItemnumber {
Link Here
|
340 |
WHERE itemnumber=? |
340 |
WHERE itemnumber=? |
341 |
"; |
341 |
"; |
342 |
unless ( $all_dates ) { |
342 |
unless ( $all_dates ) { |
343 |
$query .= " AND reservedate <= CURRENT_DATE()"; |
343 |
$query .= " AND reservedate <= CAST(now() AS date)"; |
344 |
} |
344 |
} |
345 |
my $sth_res = $dbh->prepare($query); |
345 |
my $sth_res = $dbh->prepare($query); |
346 |
$sth_res->execute($itemnumber); |
346 |
$sth_res->execute($itemnumber); |
Lines 870-876
sub CancelExpiredReserves {
Link Here
|
870 |
# Cancel reserves that have passed their expiration date. |
870 |
# Cancel reserves that have passed their expiration date. |
871 |
my $dbh = C4::Context->dbh; |
871 |
my $dbh = C4::Context->dbh; |
872 |
my $sth = $dbh->prepare( " |
872 |
my $sth = $dbh->prepare( " |
873 |
SELECT * FROM reserves WHERE DATE(expirationdate) < DATE( CURDATE() ) |
873 |
SELECT * FROM reserves WHERE DATE(expirationdate) < CAST(now() AS date) |
874 |
AND expirationdate IS NOT NULL |
874 |
AND expirationdate IS NOT NULL |
875 |
AND found IS NULL |
875 |
AND found IS NULL |
876 |
" ); |
876 |
" ); |
Lines 1734-1740
sub _Findgroupreserve {
Link Here
|
1734 |
AND priority > 0 |
1734 |
AND priority > 0 |
1735 |
AND item_level_request = 1 |
1735 |
AND item_level_request = 1 |
1736 |
AND itemnumber = ? |
1736 |
AND itemnumber = ? |
1737 |
AND reservedate <= CURRENT_DATE() |
1737 |
AND reservedate <= CAST(now() AS date) |
1738 |
AND suspend = 0 |
1738 |
AND suspend = 0 |
1739 |
/; |
1739 |
/; |
1740 |
my $sth = $dbh->prepare($item_level_target_query); |
1740 |
my $sth = $dbh->prepare($item_level_target_query); |
Lines 1765-1771
sub _Findgroupreserve {
Link Here
|
1765 |
AND priority > 0 |
1765 |
AND priority > 0 |
1766 |
AND item_level_request = 0 |
1766 |
AND item_level_request = 0 |
1767 |
AND hold_fill_targets.itemnumber = ? |
1767 |
AND hold_fill_targets.itemnumber = ? |
1768 |
AND reservedate <= CURRENT_DATE() |
1768 |
AND reservedate <= CAST(now() as date) |
1769 |
AND suspend = 0 |
1769 |
AND suspend = 0 |
1770 |
/; |
1770 |
/; |
1771 |
$sth = $dbh->prepare($title_level_target_query); |
1771 |
$sth = $dbh->prepare($title_level_target_query); |
Lines 1797-1803
sub _Findgroupreserve {
Link Here
|
1797 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1797 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1798 |
OR reserves.constrainttype='a' ) |
1798 |
OR reserves.constrainttype='a' ) |
1799 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1799 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1800 |
AND reserves.reservedate <= CURRENT_DATE() |
1800 |
AND reserves.reservedate <= CAST(now() AS date) |
1801 |
AND suspend = 0 |
1801 |
AND suspend = 0 |
1802 |
/; |
1802 |
/; |
1803 |
$sth = $dbh->prepare($query); |
1803 |
$sth = $dbh->prepare($query); |