Lines 133-139
sub GetHoldsQueueItems {
Link Here
|
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 |
/; |
153 |
/; |
147 |
if ($branchlimit) { |
154 |
if ($branchlimit) { |
148 |
$query .=" WHERE tmp_holdsqueue.holdingbranch = ?"; |
155 |
$query .=" WHERE tmp_holdsqueue.holdingbranch = ?"; |
Lines 159-164
sub GetHoldsQueueItems {
Link Here
|
159 |
} |
166 |
} |
160 |
delete $row->{itemtype}; |
167 |
delete $row->{itemtype}; |
161 |
|
168 |
|
|
|
169 |
$row->{borrower} = { |
170 |
borrowernumber => $row->{borrowernumber}, |
171 |
cardnumber => $row->{cardnumber}, |
172 |
firstname => $row->{firstname}, |
173 |
othernames => $row->{othernames}, |
174 |
surname => $row->{surname}, |
175 |
title => $row->{borrower_title}, |
176 |
}; |
177 |
|
162 |
push @$items, $row; |
178 |
push @$items, $row; |
163 |
} |
179 |
} |
164 |
return $items; |
180 |
return $items; |