@@ -, +, @@
---
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 |
+ Home library |
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},
--