Lines 90-96
my $sql = '
Link Here
|
90 |
items.itype, |
90 |
items.itype, |
91 |
biblioitems.itemtype, |
91 |
biblioitems.itemtype, |
92 |
|
92 |
|
93 |
items.ccode, |
93 |
items.ccode AS collection, |
94 |
|
94 |
|
95 |
borrowernumber, |
95 |
borrowernumber, |
96 |
surname, |
96 |
surname, |
Lines 156-161
while ( my $c = $sth->fetchrow_hashref() ) {
Link Here
|
156 |
my $av = Koha::AuthorisedValues->search({ category => 'LOC', authorised_value => $c->{location} }); |
156 |
my $av = Koha::AuthorisedValues->search({ category => 'LOC', authorised_value => $c->{location} }); |
157 |
$location = $av->count ? $av->next->lib : ''; |
157 |
$location = $av->count ? $av->next->lib : ''; |
158 |
} |
158 |
} |
|
|
159 |
my $collection; |
160 |
if ( $c->{collection} ) { |
161 |
my $av = Koha::AuthorisedValues->search({ category => 'CCODE', authorised_value => $c->{collection} }); |
162 |
$collection = $av->count ? $av->next->lib : ''; |
163 |
} |
159 |
my $lost; |
164 |
my $lost; |
160 |
if ( $c->{itemlost} ) { |
165 |
if ( $c->{itemlost} ) { |
161 |
my $av = Koha::AuthorisedValues->search({ category => 'LOST', authorised_value => $c->{itemlost} }); |
166 |
my $av = Koha::AuthorisedValues->search({ category => 'LOST', authorised_value => $c->{itemlost} }); |
Lines 173-179
while ( my $c = $sth->fetchrow_hashref() ) {
Link Here
|
173 |
barcode => $c->{barcode}, |
178 |
barcode => $c->{barcode}, |
174 |
itemtype => $item_level_itypes ? $c->{itype} : $c->{itemtype}, |
179 |
itemtype => $item_level_itypes ? $c->{itype} : $c->{itemtype}, |
175 |
itemtype_description => $itemtype ? $itemtype->translated_description : q{}, |
180 |
itemtype_description => $itemtype ? $itemtype->translated_description : q{}, |
176 |
ccode => $c->{ccode}, |
181 |
collection => $collection, |
177 |
location => $location, |
182 |
location => $location, |
178 |
homebranch => $c->{homebranch}, |
183 |
homebranch => $c->{homebranch}, |
179 |
itemnotes => $c->{itemnotes}, |
184 |
itemnotes => $c->{itemnotes}, |
180 |
- |
|
|