@@ -, +, @@ Coeur d'Alene Public Library (http://www.cdalibrary.org/) --- admin/columns_settings.yml | 4 ++++ koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc | 1 + koha-tmpl/intranet-tmpl/prog/js/checkouts.js | 1 + svc/checkouts | 5 ++++- 4 files changed, 10 insertions(+), 1 deletion(-) --- a/admin/columns_settings.yml +++ a/admin/columns_settings.yml @@ -210,6 +210,8 @@ modules: - columnname: location - + columnname: homebranch + - columnname: checkout_on - columnname: checkout_from @@ -293,6 +295,8 @@ modules: - columnname: location - + columnname: homebranch + - columnname: checkout_on - columnname: checkout_from --- a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc +++ a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc @@ -17,6 +17,7 @@ Title Item type Location + Owning branch Checked out on Checked out from Call no --- a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js +++ a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js @@ -272,6 +272,7 @@ $(document).ready(function() { }, { "mDataProp": "itemtype_description" }, { "mDataProp": "location" }, + { "mDataProp": "homebranch" }, { "mDataProp": "issuedate_formatted" }, { "mDataProp": "branchname" }, { "mDataProp": "itemcallnumber" }, --- a/svc/checkouts +++ a/svc/checkouts @@ -78,13 +78,14 @@ my $sql = ' itemnumber, barcode, + branches2.branchname AS homebranch, itemnotes, itemnotes_nonpublic, itemcallnumber, replacementprice, issues.branchcode, - branchname, + branches.branchname, items.itype, biblioitems.itemtype, @@ -105,6 +106,7 @@ my $sql = ' 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 '; @@ -154,6 +156,7 @@ while ( my $c = $sth->fetchrow_hashref() ) { 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}, --