Lines 296-302
sub GetReservesFromBiblionumber {
Link Here
|
296 |
FROM reserves |
296 |
FROM reserves |
297 |
WHERE biblionumber = ? "; |
297 |
WHERE biblionumber = ? "; |
298 |
unless ( $all_dates ) { |
298 |
unless ( $all_dates ) { |
299 |
$query .= "AND reservedate <= CURRENT_DATE()"; |
299 |
$query .= "AND reservedate <= CAST(now() AS date)"; |
300 |
} |
300 |
} |
301 |
$query .= "ORDER BY priority"; |
301 |
$query .= "ORDER BY priority"; |
302 |
my $sth = $dbh->prepare($query); |
302 |
my $sth = $dbh->prepare($query); |
Lines 362-368
sub GetReservesFromItemnumber {
Link Here
|
362 |
WHERE itemnumber=? |
362 |
WHERE itemnumber=? |
363 |
"; |
363 |
"; |
364 |
unless ( $all_dates ) { |
364 |
unless ( $all_dates ) { |
365 |
$query .= " AND reservedate <= CURRENT_DATE()"; |
365 |
$query .= " AND reservedate <= CAST(now() AS date)"; |
366 |
} |
366 |
} |
367 |
my $sth_res = $dbh->prepare($query); |
367 |
my $sth_res = $dbh->prepare($query); |
368 |
$sth_res->execute($itemnumber); |
368 |
$sth_res->execute($itemnumber); |
Lines 920-926
sub CancelExpiredReserves {
Link Here
|
920 |
# Cancel reserves that have passed their expiration date. |
920 |
# Cancel reserves that have passed their expiration date. |
921 |
my $dbh = C4::Context->dbh; |
921 |
my $dbh = C4::Context->dbh; |
922 |
my $sth = $dbh->prepare( " |
922 |
my $sth = $dbh->prepare( " |
923 |
SELECT * FROM reserves WHERE DATE(expirationdate) < DATE( CURDATE() ) |
923 |
SELECT * FROM reserves WHERE DATE(expirationdate) < CAST(now() AS date) |
924 |
AND expirationdate IS NOT NULL |
924 |
AND expirationdate IS NOT NULL |
925 |
AND found IS NULL |
925 |
AND found IS NULL |
926 |
" ); |
926 |
" ); |
Lines 1733-1739
sub _Findgroupreserve {
Link Here
|
1733 |
AND priority > 0 |
1733 |
AND priority > 0 |
1734 |
AND item_level_request = 1 |
1734 |
AND item_level_request = 1 |
1735 |
AND itemnumber = ? |
1735 |
AND itemnumber = ? |
1736 |
AND reservedate <= CURRENT_DATE() |
1736 |
AND reservedate <= CAST(now() AS date) |
1737 |
AND suspend = 0 |
1737 |
AND suspend = 0 |
1738 |
/; |
1738 |
/; |
1739 |
my $sth = $dbh->prepare($item_level_target_query); |
1739 |
my $sth = $dbh->prepare($item_level_target_query); |
Lines 1764-1770
sub _Findgroupreserve {
Link Here
|
1764 |
AND priority > 0 |
1764 |
AND priority > 0 |
1765 |
AND item_level_request = 0 |
1765 |
AND item_level_request = 0 |
1766 |
AND hold_fill_targets.itemnumber = ? |
1766 |
AND hold_fill_targets.itemnumber = ? |
1767 |
AND reservedate <= CURRENT_DATE() |
1767 |
AND reservedate <= CAST(now() as date) |
1768 |
AND suspend = 0 |
1768 |
AND suspend = 0 |
1769 |
/; |
1769 |
/; |
1770 |
$sth = $dbh->prepare($title_level_target_query); |
1770 |
$sth = $dbh->prepare($title_level_target_query); |
Lines 1796-1802
sub _Findgroupreserve {
Link Here
|
1796 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1796 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1797 |
OR reserves.constrainttype='a' ) |
1797 |
OR reserves.constrainttype='a' ) |
1798 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1798 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1799 |
AND reserves.reservedate <= CURRENT_DATE() |
1799 |
AND reserves.reservedate <= CAST(now() AS date) |
1800 |
AND suspend = 0 |
1800 |
AND suspend = 0 |
1801 |
/; |
1801 |
/; |
1802 |
$sth = $dbh->prepare($query); |
1802 |
$sth = $dbh->prepare($query); |