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