Lines 277-283
sub GetReservesFromBiblionumber {
Link Here
|
277 |
FROM reserves |
277 |
FROM reserves |
278 |
WHERE biblionumber = ? "; |
278 |
WHERE biblionumber = ? "; |
279 |
unless ( $all_dates ) { |
279 |
unless ( $all_dates ) { |
280 |
$query .= "AND reservedate <= CURRENT_DATE()"; |
280 |
$query .= "AND reservedate <= CAST(now() AS date)"; |
281 |
} |
281 |
} |
282 |
$query .= "ORDER BY priority"; |
282 |
$query .= "ORDER BY priority"; |
283 |
my $sth = $dbh->prepare($query); |
283 |
my $sth = $dbh->prepare($query); |
Lines 343-349
sub GetReservesFromItemnumber {
Link Here
|
343 |
WHERE itemnumber=? |
343 |
WHERE itemnumber=? |
344 |
"; |
344 |
"; |
345 |
unless ( $all_dates ) { |
345 |
unless ( $all_dates ) { |
346 |
$query .= " AND reservedate <= CURRENT_DATE()"; |
346 |
$query .= " AND reservedate <= CAST(now() AS date)"; |
347 |
} |
347 |
} |
348 |
my $sth_res = $dbh->prepare($query); |
348 |
my $sth_res = $dbh->prepare($query); |
349 |
$sth_res->execute($itemnumber); |
349 |
$sth_res->execute($itemnumber); |
Lines 897-903
sub CancelExpiredReserves {
Link Here
|
897 |
# Cancel reserves that have passed their expiration date. |
897 |
# Cancel reserves that have passed their expiration date. |
898 |
my $dbh = C4::Context->dbh; |
898 |
my $dbh = C4::Context->dbh; |
899 |
my $sth = $dbh->prepare( " |
899 |
my $sth = $dbh->prepare( " |
900 |
SELECT * FROM reserves WHERE DATE(expirationdate) < DATE( CURDATE() ) |
900 |
SELECT * FROM reserves WHERE DATE(expirationdate) < CAST(now() AS date) |
901 |
AND expirationdate IS NOT NULL |
901 |
AND expirationdate IS NOT NULL |
902 |
AND found IS NULL |
902 |
AND found IS NULL |
903 |
" ); |
903 |
" ); |
Lines 1768-1774
sub _Findgroupreserve {
Link Here
|
1768 |
AND priority > 0 |
1768 |
AND priority > 0 |
1769 |
AND item_level_request = 1 |
1769 |
AND item_level_request = 1 |
1770 |
AND itemnumber = ? |
1770 |
AND itemnumber = ? |
1771 |
AND reservedate <= CURRENT_DATE() |
1771 |
AND reservedate <= CAST(now() AS date) |
1772 |
AND suspend = 0 |
1772 |
AND suspend = 0 |
1773 |
/; |
1773 |
/; |
1774 |
my $sth = $dbh->prepare($item_level_target_query); |
1774 |
my $sth = $dbh->prepare($item_level_target_query); |
Lines 1799-1805
sub _Findgroupreserve {
Link Here
|
1799 |
AND priority > 0 |
1799 |
AND priority > 0 |
1800 |
AND item_level_request = 0 |
1800 |
AND item_level_request = 0 |
1801 |
AND hold_fill_targets.itemnumber = ? |
1801 |
AND hold_fill_targets.itemnumber = ? |
1802 |
AND reservedate <= CURRENT_DATE() |
1802 |
AND reservedate <= CAST(now() as date) |
1803 |
AND suspend = 0 |
1803 |
AND suspend = 0 |
1804 |
/; |
1804 |
/; |
1805 |
$sth = $dbh->prepare($title_level_target_query); |
1805 |
$sth = $dbh->prepare($title_level_target_query); |
Lines 1831-1837
sub _Findgroupreserve {
Link Here
|
1831 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1831 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1832 |
OR reserves.constrainttype='a' ) |
1832 |
OR reserves.constrainttype='a' ) |
1833 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1833 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1834 |
AND reserves.reservedate <= CURRENT_DATE() |
1834 |
AND reserves.reservedate <= CAST(now() AS date) |
1835 |
AND suspend = 0 |
1835 |
AND suspend = 0 |
1836 |
/; |
1836 |
/; |
1837 |
$sth = $dbh->prepare($query); |
1837 |
$sth = $dbh->prepare($query); |