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

(-)a/C4/Overdues.pm (-3 / +2 lines)
Lines 90-103 sub Getoverdues { Link Here
90
    my $statement;
90
    my $statement;
91
    if ( C4::Context->preference('item-level_itypes') ) {
91
    if ( C4::Context->preference('item-level_itypes') ) {
92
        $statement = "
92
        $statement = "
93
   SELECT issues.*, items.itype as itemtype, items.homebranch, items.barcode, items.itemlost, items.replacementprice
93
   SELECT issues.*, items.itype as itemtype, items.homebranch, items.barcode, items.itemlost, items.replacementprice, items.biblionumber
94
     FROM issues 
94
     FROM issues 
95
LEFT JOIN items       USING (itemnumber)
95
LEFT JOIN items       USING (itemnumber)
96
    WHERE date_due < NOW()
96
    WHERE date_due < NOW()
97
";
97
";
98
    } else {
98
    } else {
99
        $statement = "
99
        $statement = "
100
   SELECT issues.*, biblioitems.itemtype, items.itype, items.homebranch, items.barcode, items.itemlost, replacementprice
100
   SELECT issues.*, biblioitems.itemtype, items.itype, items.homebranch, items.barcode, items.itemlost, replacementprice, items.biblionumber
101
     FROM issues 
101
     FROM issues 
102
LEFT JOIN items       USING (itemnumber)
102
LEFT JOIN items       USING (itemnumber)
103
LEFT JOIN biblioitems USING (biblioitemnumber)
103
LEFT JOIN biblioitems USING (biblioitemnumber)
104
- 

Return to bug 19532