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

(-)a/C4/Reserves.pm (-2 / +10 lines)
Lines 768-776 sub CheckReserves { Link Here
768
           items.itemnumber
768
           items.itemnumber
769
    FROM   items
769
    FROM   items
770
    LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber
770
    LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber
771
    LEFT JOIN itemtypes   ON biblioitems.itemtype   = itemtypes.itemtype
772
    ";
771
    ";
773
772
773
      #ejb2011 - logic is wrong here - if itemlevel itypes then should join on itype not biblio item.type
774
    if (C4::Context->preference('item-level_itypes')) {
775
        $select .= " LEFT JOIN itemtypes  ON items.itype  = 
776
itemtypes.itemtype";
777
      } else {
778
        $select .= " LEFT JOIN itemtypes  ON biblioitems.itype  = 
779
itemtypes.itemtype";
780
      }
781
     }
782
774
    if ($item) {
783
    if ($item) {
775
        $sth = $dbh->prepare("$select WHERE itemnumber = ?");
784
        $sth = $dbh->prepare("$select WHERE itemnumber = ?");
776
        $sth->execute($item);
785
        $sth->execute($item);
777
-

Return to bug 6551