Lines 97-103
if ( $run_report ) {
Link Here
|
97 |
"SELECT min(reservedate) as l_reservedate, |
97 |
"SELECT min(reservedate) as l_reservedate, |
98 |
reserves.borrowernumber as borrowernumber, |
98 |
reserves.borrowernumber as borrowernumber, |
99 |
GROUP_CONCAT(DISTINCT items.holdingbranch |
99 |
GROUP_CONCAT(DISTINCT items.holdingbranch |
100 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_holdingbranch, |
100 |
ORDER BY items.itemnumber SEPARATOR '|') l_holdingbranch, |
101 |
reserves.biblionumber, |
101 |
reserves.biblionumber, |
102 |
reserves.branchcode, |
102 |
reserves.branchcode, |
103 |
GROUP_CONCAT(DISTINCT reserves.branchcode |
103 |
GROUP_CONCAT(DISTINCT reserves.branchcode |
Lines 106-112
if ( $run_report ) {
Link Here
|
106 |
GROUP_CONCAT(DISTINCT items.itype |
106 |
GROUP_CONCAT(DISTINCT items.itype |
107 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itype, |
107 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itype, |
108 |
GROUP_CONCAT(DISTINCT items.location |
108 |
GROUP_CONCAT(DISTINCT items.location |
109 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_location, |
109 |
ORDER BY items.itemnumber SEPARATOR '|') l_location, |
110 |
GROUP_CONCAT(DISTINCT items.itemcallnumber |
110 |
GROUP_CONCAT(DISTINCT items.itemcallnumber |
111 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itemcallnumber, |
111 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itemcallnumber, |
112 |
GROUP_CONCAT(DISTINCT items.enumchron |
112 |
GROUP_CONCAT(DISTINCT items.enumchron |
Lines 167-173
if ( $run_report ) {
Link Here
|
167 |
biblionumber => $data->{biblionumber}, |
167 |
biblionumber => $data->{biblionumber}, |
168 |
statusw => ( $data->{found} eq "W" ), |
168 |
statusw => ( $data->{found} eq "W" ), |
169 |
statusf => ( $data->{found} eq "F" ), |
169 |
statusf => ( $data->{found} eq "F" ), |
170 |
holdingbranch => $data->{l_holdingbranch}, |
170 |
holdingbranches => [split('\|', $data->{l_holdingbranch})],, |
171 |
branch => $data->{l_branch}, |
171 |
branch => $data->{l_branch}, |
172 |
itemcallnumber => $data->{l_itemcallnumber}, |
172 |
itemcallnumber => $data->{l_itemcallnumber}, |
173 |
enumchron => $data->{l_enumchron}, |
173 |
enumchron => $data->{l_enumchron}, |
Lines 178-184
if ( $run_report ) {
Link Here
|
178 |
rcount => $data->{rcount}, |
178 |
rcount => $data->{rcount}, |
179 |
pullcount => $data->{icount} <= $data->{rcount} ? $data->{icount} : $data->{rcount}, |
179 |
pullcount => $data->{icount} <= $data->{rcount} ? $data->{icount} : $data->{rcount}, |
180 |
itype => $data->{l_itype}, |
180 |
itype => $data->{l_itype}, |
181 |
location => $data->{l_location}, |
181 |
locations => [split('\|', $data->{l_location})], |
182 |
} |
182 |
} |
183 |
); |
183 |
); |
184 |
} |
184 |
} |