From 056fbf3abd274572d5ad9820bd2eb8cbc46ca234 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Fr=C3=A9d=C3=A9ric=20Demians?= Date: Tue, 28 Oct 2014 18:58:20 +0100 Subject: [PATCH] Bug 13155 Course reserves doesn't display reserved items on OPAC On OPAC, opac-course-details.pl page, when a specific course reserves is selected, all its items are displayed in a table with several columns: titel, item type, location, etc. Nothing is displayed in those columns, except the item status. TEST PLAN: - If you haven't already a course reserves, create one: - Enable course reserves with syspref UseCourseReserves - Create a course reserves - Add an item to your course reserves - On OPAC, click on Course Reserves, then select a course - The item table is empty - Apply the patch, refresh the OPAC page: item table contains info --- C4/Biblio.pm | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/C4/Biblio.pm b/C4/Biblio.pm index 03e7cc4..3a93e90 100644 --- a/C4/Biblio.pm +++ b/C4/Biblio.pm @@ -896,8 +896,9 @@ sub GetBiblioFromItemNumber { "SELECT items.*, biblio.*, biblioitems.*, itemtypes.notforloan as notforloan_per_itemtype FROM items LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber - LEFT JOIN itemtypes ON itemtypes.itemtype = " . C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype' . " - WHERE items.itemnumber = ?" + LEFT JOIN itemtypes ON itemtypes.itemtype = " . + (C4::Context->preference('item-level_itypes') ? 'items.itype' : 'biblioitems.itemtype') . + " WHERE items.itemnumber = ?" ); $sth->execute($itemnumber); } else { -- 2.1.2