|
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 |
- |
|
|