|
Lines 1831-1836
sub _Findgroupreserve {
Link Here
|
| 1831 |
AND itemnumber = ? |
1831 |
AND itemnumber = ? |
| 1832 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1832 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
| 1833 |
AND suspend = 0 |
1833 |
AND suspend = 0 |
|
|
1834 |
ORDER BY priority |
| 1834 |
/; |
1835 |
/; |
| 1835 |
my $sth = $dbh->prepare($item_level_target_query); |
1836 |
my $sth = $dbh->prepare($item_level_target_query); |
| 1836 |
$sth->execute($itemnumber, $lookahead||0); |
1837 |
$sth->execute($itemnumber, $lookahead||0); |
|
Lines 1863-1868
sub _Findgroupreserve {
Link Here
|
| 1863 |
AND hold_fill_targets.itemnumber = ? |
1864 |
AND hold_fill_targets.itemnumber = ? |
| 1864 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1865 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
| 1865 |
AND suspend = 0 |
1866 |
AND suspend = 0 |
|
|
1867 |
ORDER BY priority |
| 1866 |
/; |
1868 |
/; |
| 1867 |
$sth = $dbh->prepare($title_level_target_query); |
1869 |
$sth = $dbh->prepare($title_level_target_query); |
| 1868 |
$sth->execute($itemnumber, $lookahead||0); |
1870 |
$sth->execute($itemnumber, $lookahead||0); |
|
Lines 1896-1901
sub _Findgroupreserve {
Link Here
|
| 1896 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1898 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
| 1897 |
AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1899 |
AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
| 1898 |
AND suspend = 0 |
1900 |
AND suspend = 0 |
|
|
1901 |
ORDER BY priority |
| 1899 |
/; |
1902 |
/; |
| 1900 |
$sth = $dbh->prepare($query); |
1903 |
$sth = $dbh->prepare($query); |
| 1901 |
$sth->execute( $biblio, $bibitem, $itemnumber, $lookahead||0); |
1904 |
$sth->execute( $biblio, $bibitem, $itemnumber, $lookahead||0); |
| 1902 |
- |
|
|