Lines 116-121
my $strsth =
Link Here
|
116 |
ORDER BY items.itemnumber SEPARATOR '|') as l_location, |
116 |
ORDER BY items.itemnumber SEPARATOR '|') as l_location, |
117 |
GROUP_CONCAT(DISTINCT items.itype |
117 |
GROUP_CONCAT(DISTINCT items.itype |
118 |
ORDER BY items.itemnumber SEPARATOR '|') as l_itype, |
118 |
ORDER BY items.itemnumber SEPARATOR '|') as l_itype, |
|
|
119 |
GROUP_CONCAT(DISTINCT items.ccode |
120 |
ORDER BY items.ccode SEPARATOR '|') as l_ccode, |
119 |
|
121 |
|
120 |
reserves.found, |
122 |
reserves.found, |
121 |
biblio.title, |
123 |
biblio.title, |
Lines 173-178
while ( my $data = $sth->fetchrow_hashref ) {
Link Here
|
173 |
itemcallnumber => $data->{itemcallnumber}, |
175 |
itemcallnumber => $data->{itemcallnumber}, |
174 |
location => [split('\|', $data->{l_location})], |
176 |
location => [split('\|', $data->{l_location})], |
175 |
itype => [split('\|', $data->{l_itype})], |
177 |
itype => [split('\|', $data->{l_itype})], |
|
|
178 |
ccode => [split('\|', $data->{l_ccode})], |
176 |
reservecount => $data->{reservecount}, |
179 |
reservecount => $data->{reservecount}, |
177 |
itemcount => $data->{itemcount}, |
180 |
itemcount => $data->{itemcount}, |
178 |
copies_to_buy => sprintf( "%d", $copies_to_buy ), |
181 |
copies_to_buy => sprintf( "%d", $copies_to_buy ), |