|
Lines 1819-1824
sub _Findgroupreserve {
Link Here
|
| 1819 |
AND itemnumber = ? |
1819 |
AND itemnumber = ? |
| 1820 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1820 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
| 1821 |
AND suspend = 0 |
1821 |
AND suspend = 0 |
|
|
1822 |
ORDER BY priority |
| 1822 |
/; |
1823 |
/; |
| 1823 |
my $sth = $dbh->prepare($item_level_target_query); |
1824 |
my $sth = $dbh->prepare($item_level_target_query); |
| 1824 |
$sth->execute($itemnumber, $lookahead||0); |
1825 |
$sth->execute($itemnumber, $lookahead||0); |
|
Lines 1850-1855
sub _Findgroupreserve {
Link Here
|
| 1850 |
AND hold_fill_targets.itemnumber = ? |
1851 |
AND hold_fill_targets.itemnumber = ? |
| 1851 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1852 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
| 1852 |
AND suspend = 0 |
1853 |
AND suspend = 0 |
|
|
1854 |
ORDER BY priority |
| 1853 |
/; |
1855 |
/; |
| 1854 |
$sth = $dbh->prepare($title_level_target_query); |
1856 |
$sth = $dbh->prepare($title_level_target_query); |
| 1855 |
$sth->execute($itemnumber, $lookahead||0); |
1857 |
$sth->execute($itemnumber, $lookahead||0); |
|
Lines 1882-1887
sub _Findgroupreserve {
Link Here
|
| 1882 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1884 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
| 1883 |
AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1885 |
AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
| 1884 |
AND suspend = 0 |
1886 |
AND suspend = 0 |
|
|
1887 |
ORDER BY priority |
| 1885 |
/; |
1888 |
/; |
| 1886 |
$sth = $dbh->prepare($query); |
1889 |
$sth = $dbh->prepare($query); |
| 1887 |
$sth->execute( $biblio, $bibitem, $itemnumber, $lookahead||0); |
1890 |
$sth->execute( $biblio, $bibitem, $itemnumber, $lookahead||0); |
| 1888 |
- |
|
|