Attachment #27257 for bug #12079

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




               reserves.priority            AS priority,
               reserves.timestamp           AS timestamp,
               biblioitems.biblioitemnumber AS biblioitemnumber,
               reserves.itemnumber          AS itemnumber,
               reserves.reserve_id          AS reserve_id
        FROM reserves
        JOIN biblioitems USING (biblionumber)
        JOIN hold_fill_targets USING (biblionumber, borrowernumber)

               reserves.priority                   AS priority,
               reserves.timestamp                  AS timestamp,
               reserveconstraints.biblioitemnumber AS biblioitemnumber,
               reserves.itemnumber                 AS itemnumber,
               reserves.reserve_id                 AS reserve_id
        FROM reserves
          LEFT JOIN reserveconstraints ON reserves.biblionumber = reserveconstraints.biblionumber
        WHERE reserves.biblionumber = ?

Lines 2-8 Link Here

(-)a/t/db_dependent/Reserves.t (-2 / +4 lines)
2		2
3	use Modern::Perl;	3	use Modern::Perl;
4		4
5	use Test::More tests => 34;	5	use Test::More tests => 35;
		6
6	use MARC::Record;	7	use MARC::Record;
7	use DateTime::Duration;	8	use DateTime::Duration;
8		9
Lines 102-107 my ($status, $reserve, $all_reserves) = CheckReserves($itemnumber, $barcode); Link Here
102		103
103	is($status, "Reserved", "CheckReserves Test 1");	104	is($status, "Reserved", "CheckReserves Test 1");
104		105
		106	ok(exists($reserve->{reserve_id}), 'CheckReserves() include reserve_id in its response');
		107
105	($status, $reserve, $all_reserves) = CheckReserves($itemnumber);	108	($status, $reserve, $all_reserves) = CheckReserves($itemnumber);
106	is($status, "Reserved", "CheckReserves Test 2");	109	is($status, "Reserved", "CheckReserves Test 2");
107		110
108	-

Return to bug 12079

Lines 1819-1825 sub _Findgroupreserve { Link Here

(-)a/C4/Reserves.pm (-2 / +4 lines)
1819	reserves.priority AS priority,	1819	reserves.priority AS priority,
1820	reserves.timestamp AS timestamp,	1820	reserves.timestamp AS timestamp,
1821	biblioitems.biblioitemnumber AS biblioitemnumber,	1821	biblioitems.biblioitemnumber AS biblioitemnumber,
1822	reserves.itemnumber AS itemnumber	1822	reserves.itemnumber AS itemnumber,
		1823	reserves.reserve_id AS reserve_id
1823	FROM reserves	1824	FROM reserves
1824	JOIN biblioitems USING (biblionumber)	1825	JOIN biblioitems USING (biblionumber)
1825	JOIN hold_fill_targets USING (biblionumber, borrowernumber)	1826	JOIN hold_fill_targets USING (biblionumber, borrowernumber)
Lines 1850-1856 sub _Findgroupreserve { Link Here
1850	reserves.priority AS priority,	1851	reserves.priority AS priority,
1851	reserves.timestamp AS timestamp,	1852	reserves.timestamp AS timestamp,
1852	reserveconstraints.biblioitemnumber AS biblioitemnumber,	1853	reserveconstraints.biblioitemnumber AS biblioitemnumber,
1853	reserves.itemnumber AS itemnumber	1854	reserves.itemnumber AS itemnumber,
		1855	reserves.reserve_id AS reserve_id
1854	FROM reserves	1856	FROM reserves
1855	LEFT JOIN reserveconstraints ON reserves.biblionumber = reserveconstraints.biblionumber	1857	LEFT JOIN reserveconstraints ON reserves.biblionumber = reserveconstraints.biblionumber
1856	WHERE reserves.biblionumber = ?	1858	WHERE reserves.biblionumber = ?