Attachment #125377 for bug #28966

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

Lines 133-139 sub GetHoldsQueueItems { Link Here

(-)a/C4/HoldsQueue.pm (-1 / +17 lines)
133	my $dbh = C4::Context->dbh;	133	my $dbh = C4::Context->dbh;
134		134
135	my @bind_params = ();	135	my @bind_params = ();
136	my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location,	136	my $query = q/SELECT borrowers.surname,
		137	borrowers.othernames,
		138	borrowers.firstname,
		139	borrowers.cardnumber,
		140	borrowers.borrowernumber,
		141	borrowers.title AS borrower_title,
		142	tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, biblioitems.itemtype, items.location,
137	items.enumchron, items.cn_sort, biblioitems.publishercode,	143	items.enumchron, items.cn_sort, biblioitems.publishercode,
138	biblio.copyrightdate, biblio.subtitle, biblio.medium,	144	biblio.copyrightdate, biblio.subtitle, biblio.medium,
139	biblio.part_number, biblio.part_name,	145	biblio.part_number, biblio.part_name,
Lines 143-148 sub GetHoldsQueueItems { Link Here
143	JOIN biblio USING (biblionumber)	149	JOIN biblio USING (biblionumber)
144	LEFT JOIN biblioitems USING (biblionumber)	150	LEFT JOIN biblioitems USING (biblionumber)
145	LEFT JOIN items USING ( itemnumber)	151	LEFT JOIN items USING ( itemnumber)
		152	LEFT JOIN borrowers USING (borrowernumber)
146	WHERE 1=1	153	WHERE 1=1
147	/;	154	/;
148	if ($params->{branchlimit}) {	155	if ($params->{branchlimit}) {
Lines 172-177 sub GetHoldsQueueItems { Link Here
172	}	179	}
173	delete $row->{itemtype};	180	delete $row->{itemtype};
174		181
		182	$row->{borrower} = {
		183	borrowernumber => $row->{borrowernumber},
		184	cardnumber => $row->{cardnumber},
		185	firstname => $row->{firstname},
		186	othernames => $row->{othernames},
		187	surname => $row->{surname},
		188	title => $row->{borrower_title},
		189	};
		190
175	push @$items, $row;	191	push @$items, $row;
176	}	192	}
177	return $items;	193	return $items;

Lines 54-62 if ( $run_report ) { Link Here

(-)a/circ/view_holdsqueue.pl (-3 / +1 lines)
54	ccodeslimit => $ccodeslimit,	54	ccodeslimit => $ccodeslimit,
55	locationslimit => $locationslimit	55	locationslimit => $locationslimit
56	});	56	});
57	for my $item ( @$items ) {	57
58	$item->{patron} = Koha::Patrons->find( $item->{borrowernumber} );
59	}
60	$template->param(	58	$template->param(
61	branchlimit => $branchlimit,	59	branchlimit => $branchlimit,
62	itemtypeslimit => $itemtypeslimit,	60	itemtypeslimit => $itemtypeslimit,

Lines 187-193 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt (-2 / +1 lines)
187	</td>	187	</td>
188	<td class="hq-patron">	188	<td class="hq-patron">
189	<p>	189	<p>
190	[% INCLUDE 'patron-title.inc' invert_name=1 patron=itemsloo.patron hide_patron_infos_if_needed=1 link_to="circulation_reserves" %]	190	[% INCLUDE 'patron-title.inc' invert_name=1 borrower=itemsloo.borrower hide_patron_infos_if_needed=0 link_to="circulation_reserves" %]
191	</p>	191	</p>
192	[% UNLESS Koha.Preference('HidePatronName') %]	192	[% UNLESS Koha.Preference('HidePatronName') %]
193	<p>[% itemsloo.patron.phone \| html %]</p>	193	<p>[% itemsloo.patron.phone \| html %]</p>
194	-

Return to bug 28966