|
Lines 247-252
if ($noreport) {
Link Here
|
| 247 |
borrowers.cardnumber, |
247 |
borrowers.cardnumber, |
| 248 |
borrowers.borrowernumber, |
248 |
borrowers.borrowernumber, |
| 249 |
borrowers.branchcode, |
249 |
borrowers.branchcode, |
|
|
250 |
borrowers.categorycode, |
| 251 |
categories.category_type, |
| 250 |
issues.itemnumber, |
252 |
issues.itemnumber, |
| 251 |
issues.issuedate, |
253 |
issues.issuedate, |
| 252 |
items.datelastborrowed, |
254 |
items.datelastborrowed, |
|
Lines 269-274
if ($noreport) {
Link Here
|
| 269 |
return_claims.id AS return_claim_id |
271 |
return_claims.id AS return_claim_id |
| 270 |
FROM issues |
272 |
FROM issues |
| 271 |
LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) |
273 |
LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) |
|
|
274 |
LEFT JOIN categories ON (categories.categorycode = borrowers.categorycode ) |
| 272 |
LEFT JOIN items ON (issues.itemnumber=items.itemnumber) |
275 |
LEFT JOIN items ON (issues.itemnumber=items.itemnumber) |
| 273 |
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) |
276 |
LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) |
| 274 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
277 |
LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) |
|
Lines 349-355
if ($noreport) {
Link Here
|
| 349 |
} |
352 |
} |
| 350 |
|
353 |
|
| 351 |
push @overduedata, { |
354 |
push @overduedata, { |
| 352 |
patron => Koha::Patrons->find( $data->{borrowernumber} ), |
355 |
borrower => { |
|
|
356 |
branchcode => $data->{branchcode}, |
| 357 |
borrowernumber => $data->{borrowernumber}, |
| 358 |
categorycode => $data->{categorycode}, |
| 359 |
category_type => $data->{category_type}, |
| 360 |
surname => $data->{surname}, |
| 361 |
othernames => $data->{othernames}, |
| 362 |
firstname => $data->{firstname}, |
| 363 |
preferred_name => $data->{preferred_name}, |
| 364 |
middle_name => $data->{middle_name}, |
| 365 |
cardnumber => $data->{cardnumber}, |
| 366 |
title => $data->{title} |
| 367 |
}, |
| 353 |
duedate => $data->{date_due}, |
368 |
duedate => $data->{date_due}, |
| 354 |
borrowernumber => $data->{borrowernumber}, |
369 |
borrowernumber => $data->{borrowernumber}, |
| 355 |
cardnumber => $data->{cardnumber}, |
370 |
cardnumber => $data->{cardnumber}, |