|
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; |