Lines 109-122
sub Getoverdues {
Link Here
|
109 |
my $statement; |
109 |
my $statement; |
110 |
if ( C4::Context->preference('item-level_itypes') ) { |
110 |
if ( C4::Context->preference('item-level_itypes') ) { |
111 |
$statement = " |
111 |
$statement = " |
112 |
SELECT issues.*, items.itype as itemtype, items.homebranch, items.barcode |
112 |
SELECT issues.*, items.itype as itemtype, items.homebranch, items.barcode, items.itemlost |
113 |
FROM issues |
113 |
FROM issues |
114 |
LEFT JOIN items USING (itemnumber) |
114 |
LEFT JOIN items USING (itemnumber) |
115 |
WHERE date_due < NOW() |
115 |
WHERE date_due < NOW() |
116 |
"; |
116 |
"; |
117 |
} else { |
117 |
} else { |
118 |
$statement = " |
118 |
$statement = " |
119 |
SELECT issues.*, biblioitems.itemtype, items.itype, items.homebranch, items.barcode |
119 |
SELECT issues.*, biblioitems.itemtype, items.itype, items.homebranch, items.barcode, items.itemlost |
120 |
FROM issues |
120 |
FROM issues |
121 |
LEFT JOIN items USING (itemnumber) |
121 |
LEFT JOIN items USING (itemnumber) |
122 |
LEFT JOIN biblioitems USING (biblioitemnumber) |
122 |
LEFT JOIN biblioitems USING (biblioitemnumber) |