Lines 168-173
if ($enddate_iso) {
Link Here
|
168 |
push @query_params, $enddate_iso; |
168 |
push @query_params, $enddate_iso; |
169 |
} |
169 |
} |
170 |
|
170 |
|
|
|
171 |
my $item_type = C4::Context->preference('item-level_itypes') ? "items.itype" : "biblioitems.itemtype"; |
172 |
|
171 |
my $strsth = |
173 |
my $strsth = |
172 |
"SELECT min(reservedate) as l_reservedate, |
174 |
"SELECT min(reservedate) as l_reservedate, |
173 |
reserves.reserve_id, |
175 |
reserves.reserve_id, |
Lines 180-187
my $strsth =
Link Here
|
180 |
reserves.itemnumber, |
182 |
reserves.itemnumber, |
181 |
items.holdingbranch, |
183 |
items.holdingbranch, |
182 |
items.homebranch, |
184 |
items.homebranch, |
183 |
GROUP_CONCAT(DISTINCT items.itype |
185 |
GROUP_CONCAT(DISTINCT $item_type |
184 |
ORDER BY items.itemnumber SEPARATOR '|') l_itype, |
186 |
ORDER BY items.itemnumber SEPARATOR '|') l_item_type, |
185 |
GROUP_CONCAT(DISTINCT items.location |
187 |
GROUP_CONCAT(DISTINCT items.location |
186 |
ORDER BY items.itemnumber SEPARATOR '|') l_location, |
188 |
ORDER BY items.itemnumber SEPARATOR '|') l_location, |
187 |
GROUP_CONCAT(DISTINCT items.itemcallnumber |
189 |
GROUP_CONCAT(DISTINCT items.itemcallnumber |
Lines 199-204
my $strsth =
Link Here
|
199 |
FROM reserves |
201 |
FROM reserves |
200 |
LEFT JOIN items ON items.biblionumber=reserves.biblionumber |
202 |
LEFT JOIN items ON items.biblionumber=reserves.biblionumber |
201 |
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber |
203 |
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber |
|
|
204 |
LEFT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber |
202 |
LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber |
205 |
LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber |
203 |
LEFT JOIN issues ON items.itemnumber=issues.itemnumber |
206 |
LEFT JOIN issues ON items.itemnumber=issues.itemnumber |
204 |
LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber |
207 |
LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber |
Lines 249-255
while ( my $data = $sth->fetchrow_hashref ) {
Link Here
|
249 |
count => $data->{icount}, |
252 |
count => $data->{icount}, |
250 |
rcount => $data->{rcount}, |
253 |
rcount => $data->{rcount}, |
251 |
pullcount => $data->{icount} <= $data->{rcount} ? $data->{icount} : $data->{rcount}, |
254 |
pullcount => $data->{icount} <= $data->{rcount} ? $data->{icount} : $data->{rcount}, |
252 |
itypes => [split('\|', $data->{l_itype})], |
255 |
itemTypes => [split('\|', $data->{l_item_type})], |
253 |
locations => [split('\|', $data->{l_location})], |
256 |
locations => [split('\|', $data->{l_location})], |
254 |
reserve_id => $data->{reserve_id}, |
257 |
reserve_id => $data->{reserve_id}, |
255 |
holdingbranch => $data->{holdingbranch}, |
258 |
holdingbranch => $data->{holdingbranch}, |