View | Details | Raw Unified | Return to bug 8419
Collapse All | Expand All

(-)a/circ/pendingreserves.pl (+1 lines)
Lines 142-147 if ( $run_report ) { Link Here
142
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
142
    AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
143
    AND issues.itemnumber IS NULL
143
    AND issues.itemnumber IS NULL
144
    AND reserves.priority <> 0 
144
    AND reserves.priority <> 0 
145
    AND reserves.suspend = 0
145
    AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0
146
    AND notforloan = 0 AND damaged = 0 AND itemlost = 0 AND wthdrawn = 0
146
    ";
147
    ";
147
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
148
    # GROUP BY reserves.biblionumber allows only items that are not checked out, else multiples occur when 
(-)a/misc/cronjobs/holds/build_holds_queue.pl (-2 / +4 lines)
Lines 82-88 sub GetBibsWithPendingHoldRequests { Link Here
82
                     FROM reserves
82
                     FROM reserves
83
                     WHERE found IS NULL
83
                     WHERE found IS NULL
84
                     AND priority > 0
84
                     AND priority > 0
85
                     AND reservedate <= CURRENT_DATE()";
85
                     AND reservedate <= CURRENT_DATE()
86
                     AND suspend = 0
87
                     ";
86
    my $sth = $dbh->prepare($bib_query);
88
    my $sth = $dbh->prepare($bib_query);
87
89
88
    $sth->execute();
90
    $sth->execute();
Lines 125-130 sub GetPendingHoldRequestsForBib { Link Here
125
                         AND found IS NULL
127
                         AND found IS NULL
126
                         AND priority > 0
128
                         AND priority > 0
127
                         AND reservedate <= CURRENT_DATE()
129
                         AND reservedate <= CURRENT_DATE()
130
                         AND suspend = 0
128
                         ORDER BY priority";
131
                         ORDER BY priority";
129
    my $sth = $dbh->prepare($request_query);
132
    my $sth = $dbh->prepare($request_query);
130
    $sth->execute($biblionumber);
133
    $sth->execute($biblionumber);
131
- 

Return to bug 8419