|
Lines 268-274
sub GetReservesFromBiblionumber {
Link Here
|
| 268 |
FROM reserves |
268 |
FROM reserves |
| 269 |
WHERE biblionumber = ? "; |
269 |
WHERE biblionumber = ? "; |
| 270 |
unless ( $all_dates ) { |
270 |
unless ( $all_dates ) { |
| 271 |
$query .= "AND reservedate <= CURRENT_DATE()"; |
271 |
$query .= "AND reservedate <= CAST(now() AS date)"; |
| 272 |
} |
272 |
} |
| 273 |
$query .= "ORDER BY priority"; |
273 |
$query .= "ORDER BY priority"; |
| 274 |
my $sth = $dbh->prepare($query); |
274 |
my $sth = $dbh->prepare($query); |
|
Lines 334-340
sub GetReservesFromItemnumber {
Link Here
|
| 334 |
WHERE itemnumber=? |
334 |
WHERE itemnumber=? |
| 335 |
"; |
335 |
"; |
| 336 |
unless ( $all_dates ) { |
336 |
unless ( $all_dates ) { |
| 337 |
$query .= " AND reservedate <= CURRENT_DATE()"; |
337 |
$query .= " AND reservedate <= CAST(now() AS date)"; |
| 338 |
} |
338 |
} |
| 339 |
my $sth_res = $dbh->prepare($query); |
339 |
my $sth_res = $dbh->prepare($query); |
| 340 |
$sth_res->execute($itemnumber); |
340 |
$sth_res->execute($itemnumber); |
|
Lines 864-870
sub CancelExpiredReserves {
Link Here
|
| 864 |
# Cancel reserves that have passed their expiration date. |
864 |
# Cancel reserves that have passed their expiration date. |
| 865 |
my $dbh = C4::Context->dbh; |
865 |
my $dbh = C4::Context->dbh; |
| 866 |
my $sth = $dbh->prepare( " |
866 |
my $sth = $dbh->prepare( " |
| 867 |
SELECT * FROM reserves WHERE DATE(expirationdate) < DATE( CURDATE() ) |
867 |
SELECT * FROM reserves WHERE DATE(expirationdate) < CAST(now() AS date) |
| 868 |
AND expirationdate IS NOT NULL |
868 |
AND expirationdate IS NOT NULL |
| 869 |
AND found IS NULL |
869 |
AND found IS NULL |
| 870 |
" ); |
870 |
" ); |
|
Lines 1615-1621
sub _Findgroupreserve {
Link Here
|
| 1615 |
AND priority > 0 |
1615 |
AND priority > 0 |
| 1616 |
AND item_level_request = 1 |
1616 |
AND item_level_request = 1 |
| 1617 |
AND itemnumber = ? |
1617 |
AND itemnumber = ? |
| 1618 |
AND reservedate <= CURRENT_DATE() |
1618 |
AND reservedate <= CAST(now() AS date) |
| 1619 |
/; |
1619 |
/; |
| 1620 |
my $sth = $dbh->prepare($item_level_target_query); |
1620 |
my $sth = $dbh->prepare($item_level_target_query); |
| 1621 |
$sth->execute($itemnumber); |
1621 |
$sth->execute($itemnumber); |
|
Lines 1645-1651
sub _Findgroupreserve {
Link Here
|
| 1645 |
AND priority > 0 |
1645 |
AND priority > 0 |
| 1646 |
AND item_level_request = 0 |
1646 |
AND item_level_request = 0 |
| 1647 |
AND hold_fill_targets.itemnumber = ? |
1647 |
AND hold_fill_targets.itemnumber = ? |
| 1648 |
AND reservedate <= CURRENT_DATE() |
1648 |
AND reservedate <= CAST(now() AS date) |
| 1649 |
/; |
1649 |
/; |
| 1650 |
$sth = $dbh->prepare($title_level_target_query); |
1650 |
$sth = $dbh->prepare($title_level_target_query); |
| 1651 |
$sth->execute($itemnumber); |
1651 |
$sth->execute($itemnumber); |
|
Lines 1676-1682
sub _Findgroupreserve {
Link Here
|
| 1676 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
1676 |
AND reserves.reservedate = reserveconstraints.reservedate ) |
| 1677 |
OR reserves.constrainttype='a' ) |
1677 |
OR reserves.constrainttype='a' ) |
| 1678 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1678 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
| 1679 |
AND reserves.reservedate <= CURRENT_DATE() |
1679 |
AND reserves.reservedate <= CAST(now() AS date) |
| 1680 |
/; |
1680 |
/; |
| 1681 |
$sth = $dbh->prepare($query); |
1681 |
$sth = $dbh->prepare($query); |
| 1682 |
$sth->execute( $biblio, $bibitem, $itemnumber ); |
1682 |
$sth->execute( $biblio, $bibitem, $itemnumber ); |