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