|
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); |