- my $sth = $dbh->prepare(
- "Select * from issues where date_due < now() and returndate is
- NULL order by borrowernumber "
- );
+ my $sth = (C4::context->preference('item-level_itypes')) ?
+ $dbh->prepare(
+ "SELECT issues.*,items.itype as itemtype FROM issues
+ LEFT JOIN items USING (itemnumber)
+ WHERE date_due < now()
+ AND returndate IS NULL ORDER BY borrowernumber " )
+ :
+ $dbh->prepare(
+ "SELECT issues.*,biblioitems.itemtype,items.itype FROM issues
+ LEFT JOIN items USING (itemnumber)
+ LEFT JOIN biblioitems USING (biblioitemnumber)
+ WHERE date_due < now()
+ AND returndate IS
+ NULL ORDER BY borrowernumber " );