|
Lines 165-172
Returns a count and a list of overdueitems for a given borrowernumber
Link Here
|
| 165 |
|
165 |
|
| 166 |
sub checkoverdues { |
166 |
sub checkoverdues { |
| 167 |
my $borrowernumber = shift or return; |
167 |
my $borrowernumber = shift or return; |
|
|
168 |
# don't select biblioitems.marc or biblioitems.marcxml... too slow on large systems |
| 168 |
my $sth = C4::Context->dbh->prepare( |
169 |
my $sth = C4::Context->dbh->prepare( |
| 169 |
"SELECT * FROM issues |
170 |
"SELECT biblio.*, items.*, issues.*, |
|
|
171 |
biblioitems.volume, |
| 172 |
bibliotiems.number, |
| 173 |
biblioitems.itemtype, |
| 174 |
biblioitems.isbn, |
| 175 |
biblioitems.issn, |
| 176 |
biblioitems.publicationyear, |
| 177 |
biblioitems.publishercode, |
| 178 |
biblioitems.volumedate, |
| 179 |
biblioitems.volumedesc, |
| 180 |
biblioitems.collectiontitle, |
| 181 |
biblioitems.collectionissn, |
| 182 |
biblioitems.collectionvolume, |
| 183 |
biblioitems.editionstatement, |
| 184 |
biblioitems.editionresponsibility, |
| 185 |
biblioitems.illus, |
| 186 |
biblioitems.pages, |
| 187 |
biblioitems.notes, |
| 188 |
biblioitems.size, |
| 189 |
biblioitems.place, |
| 190 |
biblioitems.lccn, |
| 191 |
biblioitems.url, |
| 192 |
biblioitems.cn_source, |
| 193 |
biblioitems.cn_class, |
| 194 |
biblioitems.cn_item, |
| 195 |
biblioitems.cn_suffix, |
| 196 |
biblioitems.cn_sort, |
| 197 |
biblioitems.totalissues |
| 198 |
FROM issues |
| 170 |
LEFT JOIN items ON issues.itemnumber = items.itemnumber |
199 |
LEFT JOIN items ON issues.itemnumber = items.itemnumber |
| 171 |
LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber |
200 |
LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber |
| 172 |
LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber |
201 |
LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber |
| 173 |
- |
|
|