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