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