Lines 78-90
my $sql = '
Link Here
|
78 |
|
78 |
|
79 |
itemnumber, |
79 |
itemnumber, |
80 |
barcode, |
80 |
barcode, |
|
|
81 |
branches2.branchname AS homebranch, |
81 |
itemnotes, |
82 |
itemnotes, |
82 |
itemnotes_nonpublic, |
83 |
itemnotes_nonpublic, |
83 |
itemcallnumber, |
84 |
itemcallnumber, |
84 |
replacementprice, |
85 |
replacementprice, |
85 |
|
86 |
|
86 |
issues.branchcode, |
87 |
issues.branchcode, |
87 |
branchname, |
88 |
branches.branchname, |
88 |
|
89 |
|
89 |
items.itype, |
90 |
items.itype, |
90 |
biblioitems.itemtype, |
91 |
biblioitems.itemtype, |
Lines 105-110
my $sql = '
Link Here
|
105 |
LEFT JOIN biblioitems USING ( biblionumber ) |
106 |
LEFT JOIN biblioitems USING ( biblionumber ) |
106 |
LEFT JOIN borrowers USING ( borrowernumber ) |
107 |
LEFT JOIN borrowers USING ( borrowernumber ) |
107 |
LEFT JOIN branches ON ( issues.branchcode = branches.branchcode ) |
108 |
LEFT JOIN branches ON ( issues.branchcode = branches.branchcode ) |
|
|
109 |
LEFT JOIN branches branches2 ON ( items.homebranch = branches2.branchcode ) |
108 |
WHERE borrowernumber |
110 |
WHERE borrowernumber |
109 |
'; |
111 |
'; |
110 |
|
112 |
|
Lines 154-159
while ( my $c = $sth->fetchrow_hashref() ) {
Link Here
|
154 |
itemtype => $item_level_itypes ? $c->{itype} : $c->{itemtype}, |
156 |
itemtype => $item_level_itypes ? $c->{itype} : $c->{itemtype}, |
155 |
itemtype_description => $itemtype->{translated_description}, |
157 |
itemtype_description => $itemtype->{translated_description}, |
156 |
location => $c->{location} ? GetAuthorisedValueByCode( 'LOC', $c->{location} ) : q{}, |
158 |
location => $c->{location} ? GetAuthorisedValueByCode( 'LOC', $c->{location} ) : q{}, |
|
|
159 |
homebranch => $c->{homebranch}, |
157 |
itemnotes => $c->{itemnotes}, |
160 |
itemnotes => $c->{itemnotes}, |
158 |
itemnotes_nonpublic => $c->{itemnotes_nonpublic}, |
161 |
itemnotes_nonpublic => $c->{itemnotes_nonpublic}, |
159 |
branchcode => $c->{branchcode}, |
162 |
branchcode => $c->{branchcode}, |
160 |
- |
|
|