<th scope="col">Title</th>
<th scope="col">Item type</th>
<th scope="col">Location</th>
+ <th scope="col">Home library</th>
<th scope="col">Checked out on</th>
<th scope="col">Checked out from</th>
<th scope="col">Call no</th>
},
{ "mDataProp": "itemtype_description" },
{ "mDataProp": "location" },
+ { "mDataProp": "homebranch" },
{ "mDataProp": "issuedate_formatted" },
{ "mDataProp": "branchname" },
{ "mDataProp": "itemcallnumber" },
itemnumber,
barcode,
+ branches2.branchname AS homebranch,
itemnotes,
itemnotes_nonpublic,
itemcallnumber,
replacementprice,
issues.branchcode,
- branchname,
+ branches.branchname,
items.itype,
biblioitems.itemtype,
LEFT JOIN biblioitems USING ( biblionumber )
LEFT JOIN borrowers USING ( borrowernumber )
LEFT JOIN branches ON ( issues.branchcode = branches.branchcode )
+ LEFT JOIN branches branches2 ON ( items.homebranch = branches2.branchcode )
WHERE borrowernumber
';
itemtype => $item_level_itypes ? $c->{itype} : $c->{itemtype},
itemtype_description => $itemtype->{translated_description},
location => $c->{location} ? GetAuthorisedValueByCode( 'LOC', $c->{location} ) : q{},
+ homebranch => $c->{homebranch},
itemnotes => $c->{itemnotes},
itemnotes_nonpublic => $c->{itemnotes_nonpublic},
branchcode => $c->{branchcode},