Lines 134-146
if ( $run_report ) {
Link Here
|
134 |
GROUP_CONCAT(DISTINCT reserves.branchcode |
134 |
GROUP_CONCAT(DISTINCT reserves.branchcode |
135 |
ORDER BY items.itemnumber SEPARATOR ', ') l_branch, |
135 |
ORDER BY items.itemnumber SEPARATOR ', ') l_branch, |
136 |
items.holdingbranch as branch, |
136 |
items.holdingbranch as branch, |
137 |
items.itemcallnumber, |
|
|
138 |
GROUP_CONCAT(DISTINCT items.itype |
137 |
GROUP_CONCAT(DISTINCT items.itype |
139 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itype, |
138 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itype, |
140 |
GROUP_CONCAT(DISTINCT items.location |
139 |
GROUP_CONCAT(DISTINCT items.location |
141 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_location, |
140 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_location, |
142 |
GROUP_CONCAT(DISTINCT items.itemcallnumber |
141 |
GROUP_CONCAT(DISTINCT items.itemcallnumber |
143 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itemcallnumber, |
142 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_itemcallnumber, |
|
|
143 |
GROUP_CONCAT(DISTINCT items.enumchron |
144 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_enumchron, |
145 |
GROUP_CONCAT(DISTINCT items.copynumber |
146 |
ORDER BY items.itemnumber SEPARATOR '<br/>') l_copynumber, |
144 |
items.itemnumber, |
147 |
items.itemnumber, |
145 |
notes, |
148 |
notes, |
146 |
notificationdate, |
149 |
notificationdate, |
Lines 159-164
if ( $run_report ) {
Link Here
|
159 |
WHERE |
162 |
WHERE |
160 |
reserves.found IS NULL |
163 |
reserves.found IS NULL |
161 |
$sqldatewhere |
164 |
$sqldatewhere |
|
|
165 |
AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) |
162 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) |
166 |
AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) |
163 |
AND issues.itemnumber IS NULL |
167 |
AND issues.itemnumber IS NULL |
164 |
AND reserves.priority <> 0 |
168 |
AND reserves.priority <> 0 |
Lines 200-205
if ( $run_report ) {
Link Here
|
200 |
holdingbranch => $data->{l_holdingbranch}, |
204 |
holdingbranch => $data->{l_holdingbranch}, |
201 |
branch => $data->{l_branch}, |
205 |
branch => $data->{l_branch}, |
202 |
itemcallnumber => $data->{l_itemcallnumber}, |
206 |
itemcallnumber => $data->{l_itemcallnumber}, |
|
|
207 |
enumchron => $data->{l_enumchron}, |
208 |
copyno => $data->{l_copynumber}, |
203 |
notes => $data->{notes}, |
209 |
notes => $data->{notes}, |
204 |
notificationdate => $data->{notificationdate}, |
210 |
notificationdate => $data->{notificationdate}, |
205 |
reminderdate => $data->{reminderdate}, |
211 |
reminderdate => $data->{reminderdate}, |