View | Details | Raw Unified | Return to bug 6801
Collapse All | Expand All

(-)a/C4/Overdues.pm (-2 / +30 lines)
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
- 

Return to bug 6801