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

(-)a/Koha/Holds.pm (-1 / +4 lines)
Lines 121-127 sub get_items_that_can_fill { Link Here
121
    push @bibs_or_items, 'me.biblionumber' => { in => \@biblionumbers } if @biblionumbers;
121
    push @bibs_or_items, 'me.biblionumber' => { in => \@biblionumbers } if @biblionumbers;
122
122
123
    my @branchtransfers = Koha::Item::Transfers->search(
123
    my @branchtransfers = Koha::Item::Transfers->search(
124
        { datearrived => undef },
124
        {
125
            datearrived => undef,
126
            datecancelled => undef,
127
        },
125
        {
128
        {
126
            columns  => ['itemnumber'],
129
            columns  => ['itemnumber'],
127
            collapse => 1,
130
            collapse => 1,
(-)a/circ/pendingreserves.pl (-2 / +2 lines)
Lines 161-167 my %where = ( Link Here
161
    'itembib.itemlost' => 0,
161
    'itembib.itemlost' => 0,
162
    'itembib.withdrawn' => 0,
162
    'itembib.withdrawn' => 0,
163
    'itembib.notforloan' => 0,
163
    'itembib.notforloan' => 0,
164
    'itembib.itemnumber' => { -not_in => \'SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL' }
164
    'itembib.itemnumber' => { -not_in => \'SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL AND datecancelled IS NULL' }
165
);
165
);
166
166
167
# date boundaries
167
# date boundaries
Lines 190-195 my $holds = Koha::Holds->search( Link Here
190
    { %where },
190
    { %where },
191
    { join => 'itembib', distinct => 1, columns => qw[me.biblionumber] }
191
    { join => 'itembib', distinct => 1, columns => qw[me.biblionumber] }
192
);
192
);
193
193
my @biblionumbers = $holds->get_column('biblionumber');
194
my @biblionumbers = $holds->get_column('biblionumber');
194
195
195
my $all_items;
196
my $all_items;
196
- 

Return to bug 30447