Lines 256-267
if ($noreport) {
Link Here
|
256 |
biblio.biblionumber, |
256 |
biblio.biblionumber, |
257 |
borrowers.branchcode, |
257 |
borrowers.branchcode, |
258 |
items.itemcallnumber, |
258 |
items.itemcallnumber, |
259 |
items.replacementprice |
259 |
items.replacementprice, |
|
|
260 |
serial.serialseq |
260 |
FROM issues |
261 |
FROM issues |
261 |
LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) |
262 |
LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) |
262 |
LEFT JOIN items ON (issues.itemnumber=items.itemnumber) |
263 |
LEFT JOIN items ON (issues.itemnumber=items.itemnumber) |
263 |
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) |
264 |
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) |
264 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
265 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
|
|
266 |
LEFT JOIN serialitems ON (serialitems.itemnumber = items.itemnumber) |
267 |
LEFT JOIN serial ON (serial.serialid = serialitems.serialid) |
265 |
WHERE 1=1 "; # placeholder, since it is possible that none of the additional |
268 |
WHERE 1=1 "; # placeholder, since it is possible that none of the additional |
266 |
# conditions will be selected by user |
269 |
# conditions will be selected by user |
267 |
$strsth.=" AND date_due < '" . $todaysdate . "' " unless ($showall); |
270 |
$strsth.=" AND date_due < '" . $todaysdate . "' " unless ($showall); |
Lines 334-339
if ($noreport) {
Link Here
|
334 |
branchcode => $data->{branchcode}, |
337 |
branchcode => $data->{branchcode}, |
335 |
itemcallnumber => $data->{itemcallnumber}, |
338 |
itemcallnumber => $data->{itemcallnumber}, |
336 |
replacementprice => $data->{replacementprice}, |
339 |
replacementprice => $data->{replacementprice}, |
|
|
340 |
serialseq => $data->{serialseq}, |
337 |
patron_attr_value_loop => \@patron_attr_value_loop, |
341 |
patron_attr_value_loop => \@patron_attr_value_loop, |
338 |
}; |
342 |
}; |
339 |
} |
343 |
} |