From bfc2a312b40f0219cea352238bdbda289c0df341 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Thu, 14 Jul 2016 10:40:51 -0400 Subject: [PATCH] Bug 15975 - Add Owning Library Column to Checkouts To test: 1 - Checkout some items to a patron 2 - Note there is no 'Home library' column 3 - Apply patch 4 - Note there IS an 'Home library' column 5 - Use the columns configuration and ensure you can hide/display column at will Sponsored by: Coeur d'Alene Public Library (http://www.cdalibrary.org/) Works as expected (after clearing browser cache). Commit message amended (as of comment #7) Signed-off-by: Marc --- 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(-) diff --git a/admin/columns_settings.yml b/admin/columns_settings.yml index e2c3113..7ef4d35 100644 --- a/admin/columns_settings.yml +++ b/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 diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc index 53ef182..78d3989 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc +++ b/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc @@ -17,6 +17,7 @@ Title Item type Location + Home library Checked out on Checked out from Call no diff --git a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js b/koha-tmpl/intranet-tmpl/prog/js/checkouts.js index bf419d7..335608a 100644 --- a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js +++ b/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" }, diff --git a/svc/checkouts b/svc/checkouts index e613126..95bda2c 100755 --- a/svc/checkouts +++ b/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}, -- 2.1.4