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