Bugzilla – Attachment 53550 Details for
Bug 15975
Add Home Library Column to Checkouts
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15975 - Add Owning Library Column to Checkouts
Bug-15975---Add-Owning-Library-Column-to-Checkouts.patch (text/plain), 4.04 KB, created by
Nick Clemens (kidclamp)
on 2016-07-21 02:35:53 UTC
(
hide
)
Description:
Bug 15975 - Add Owning Library Column to Checkouts
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2016-07-21 02:35:53 UTC
Size:
4.04 KB
patch
obsolete
>From 16089523a146c2eb87931bc6e5997b035849324d Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >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 'Owning library' column >3 - Apply patch >4 - Note there IS an 'Owning 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/) >--- > 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 @@ > <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> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 15975
:
53399
|
53550
|
53551
|
53566
|
53580
|
55583
|
55655
|
55656