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