Lines 1890-1895
sub _Findgroupreserve {
Link Here
|
1890 |
AND itemnumber = ? |
1890 |
AND itemnumber = ? |
1891 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1891 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1892 |
AND suspend = 0 |
1892 |
AND suspend = 0 |
|
|
1893 |
ORDER BY priority |
1893 |
/; |
1894 |
/; |
1894 |
my $sth = $dbh->prepare($item_level_target_query); |
1895 |
my $sth = $dbh->prepare($item_level_target_query); |
1895 |
$sth->execute($itemnumber, $lookahead||0); |
1896 |
$sth->execute($itemnumber, $lookahead||0); |
Lines 1922-1927
sub _Findgroupreserve {
Link Here
|
1922 |
AND hold_fill_targets.itemnumber = ? |
1923 |
AND hold_fill_targets.itemnumber = ? |
1923 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1924 |
AND reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1924 |
AND suspend = 0 |
1925 |
AND suspend = 0 |
|
|
1926 |
ORDER BY priority |
1925 |
/; |
1927 |
/; |
1926 |
$sth = $dbh->prepare($title_level_target_query); |
1928 |
$sth = $dbh->prepare($title_level_target_query); |
1927 |
$sth->execute($itemnumber, $lookahead||0); |
1929 |
$sth->execute($itemnumber, $lookahead||0); |
Lines 1955-1960
sub _Findgroupreserve {
Link Here
|
1955 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1957 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = ?) |
1956 |
AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1958 |
AND reserves.reservedate <= DATE_ADD(NOW(),INTERVAL ? DAY) |
1957 |
AND suspend = 0 |
1959 |
AND suspend = 0 |
|
|
1960 |
ORDER BY priority |
1958 |
/; |
1961 |
/; |
1959 |
$sth = $dbh->prepare($query); |
1962 |
$sth = $dbh->prepare($query); |
1960 |
$sth->execute( $biblio, $bibitem, $itemnumber, $lookahead||0); |
1963 |
$sth->execute( $biblio, $bibitem, $itemnumber, $lookahead||0); |
1961 |
- |
|
|