|
Lines 123-129
if ( $run_report ) {
Link Here
|
| 123 |
biblio.author, |
123 |
biblio.author, |
| 124 |
count(DISTINCT items.itemnumber) as icount, |
124 |
count(DISTINCT items.itemnumber) as icount, |
| 125 |
count(DISTINCT reserves.borrowernumber) as rcount, |
125 |
count(DISTINCT reserves.borrowernumber) as rcount, |
| 126 |
CONCAT_WS(' ', borrowers.firstname, borrowers.surname) as l_patron |
126 |
borrowers.firstname, |
|
|
127 |
borrowers.surname |
| 127 |
FROM reserves |
128 |
FROM reserves |
| 128 |
LEFT JOIN items ON items.biblionumber=reserves.biblionumber |
129 |
LEFT JOIN items ON items.biblionumber=reserves.biblionumber |
| 129 |
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber |
130 |
LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber |
|
Lines 164-170
if ( $run_report ) {
Link Here
|
| 164 |
{ |
165 |
{ |
| 165 |
reservedate => $data->{l_reservedate}, |
166 |
reservedate => $data->{l_reservedate}, |
| 166 |
priority => $data->{priority}, |
167 |
priority => $data->{priority}, |
| 167 |
name => $data->{l_patron}, |
168 |
firstname => $data->{firstname} || '', |
|
|
169 |
surname => $data->{surname}, |
| 168 |
title => $data->{title}, |
170 |
title => $data->{title}, |
| 169 |
subtitle => $data->{subtitle}, |
171 |
subtitle => $data->{subtitle}, |
| 170 |
author => $data->{author}, |
172 |
author => $data->{author}, |