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