Attachment 77559 Details for Bug 19719 – Bug 19719: Add new column for collection in the patron checkouts data tables

[patch] Bug 19719: Add new column for collection in the patron checkouts data tables

Bug-19719-Add-new-column-for-collection-in-the-pat.patch (text/plain), 5.07 KB, created by Julian Maurice on 2018-08-08 10:47:37 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Julian Maurice

Created: 2018-08-08 10:47:37 UTC

Size: 5.07 KB

patch

obsolete

>From 68cc5a0d9bf75ae72b904165e78c88ba7956a47a Mon Sep 17 00:00:00 2001
>From: Jesse Maseto <jesse@bywatersolutions.com>
>Date: Fri, 2 Mar 2018 13:11:44 +0000
>Subject: [PATCH] Bug 19719: Add new column for collection in the patron
> checkouts data tables
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>This makes the collection visible in the checkouts table
>on the details and issues tab in the patron account in staff.
>
>TEST:
>
>1. Check out a few items to patron.
>2. View check outs on patron account in staff client.
>3. Collection code is not present.
>
>4. Apply patch
>
>5. Notice that not Collection code is visible while viewing check outs.
>
>Signed-off-by: Severine QUEUNE <severine.queune@bulac.fr>
>Signed-off by: Maksim Sen <maksim.sen@inlibro.com>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>
>Signed-off-by: SÃ©verine QUEUNE <severine.queune@bulac.fr>
>Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
>---
> admin/columns_settings.yml                                   | 4 ++++
> koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc | 1 +
> koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt  | 1 +
> koha-tmpl/intranet-tmpl/prog/js/checkouts.js                 | 2 ++
> svc/checkouts                                                | 3 +++
> 5 files changed, 11 insertions(+)
>
>diff --git a/admin/columns_settings.yml b/admin/columns_settings.yml
>index 6f7022db6b..cec35f35de 100644
>--- a/admin/columns_settings.yml
>+++ b/admin/columns_settings.yml
>@@ -251,6 +251,8 @@ modules:
>           columnname: title
>         -
>           columnname: item_type
>+        -
>+          columnname: collection_code
>         -
>           columnname: location
>         -
>@@ -406,6 +408,8 @@ modules:
>           columnname: title
>         -
>           columnname: item_type
>+        -
>+          columnname: collection_code
>         -
>           columnname: location
>         -
>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 b34089d3c7..aa38cc8531 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc
>+++ b/koha-tmpl/intranet-tmpl/prog/en/includes/checkouts-table.inc
>@@ -16,6 +16,7 @@
>                         <th scope="col">Due date</th>
>                         <th scope="col">Title</th>
>                         <th scope="col">Item type</th>
>+                        <th scope="col">Collection code</th>
>                         <th scope="col">Location</th>
>                         <th scope="col">Home library</th>
>                         <th scope="col">Checked out on</th>
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt
>index a6e6ba00fa..84e72c7ba9 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/circulation.tt
>@@ -851,6 +851,7 @@ No patron matched <span class="ex">[% message | html %]</span>
>                     <th scope="col">Due date</th>
>                     <th scope="col">Title</th>
>                     <th scope="col">Item type</th>
>+                    <th scope="col">Collection code</th>
>                     <th scope="col">Location</th>
>                     <th scope="col">Checked out on</th>
>                     <th scope="col">Checked out from</th>
>diff --git a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js b/koha-tmpl/intranet-tmpl/prog/js/checkouts.js
>index d6cd4b8fb4..c97c988166 100644
>--- a/koha-tmpl/intranet-tmpl/prog/js/checkouts.js
>+++ b/koha-tmpl/intranet-tmpl/prog/js/checkouts.js
>@@ -291,6 +291,7 @@ $(document).ready(function() {
>                     "sType": "anti-the"
>                 },
>                 { "mDataProp": "itemtype_description" },
>+                { "mDataProp": "ccode" },
>                 { "mDataProp": "location" },
>                 { "mDataProp": "homebranch" },
>                 { "mDataProp": "issuedate_formatted" },
>@@ -607,6 +608,7 @@ $(document).ready(function() {
>                         "sType": "anti-the"
>                     },
>                     { "mDataProp": "itemtype" },
>+                    { "mDataProp": "ccode" },
>                     { "mDataProp": "location" },
>                     { "mDataProp": "issuedate_formatted" },
>                     { "mDataProp": "branchname" },
>diff --git a/svc/checkouts b/svc/checkouts
>index fefadeeeea..d1fb8d34f9 100755
>--- a/svc/checkouts
>+++ b/svc/checkouts
>@@ -90,6 +90,8 @@ my $sql = '
>         items.itype,
>         biblioitems.itemtype,
> 
>+        items.ccode,
>+
>         borrowernumber,
>         surname,
>         firstname,
>@@ -171,6 +173,7 @@ while ( my $c = $sth->fetchrow_hashref() ) {
>         barcode              => $c->{barcode},
>         itemtype             => $item_level_itypes ? $c->{itype} : $c->{itemtype},
>         itemtype_description => $itemtype ? $itemtype->translated_description : q{},
>+        ccode                => $c->{ccode},
>         location             => $location,
>         homebranch           => $c->{homebranch},
>         itemnotes            => $c->{itemnotes},
>-- 
>2.17.1

Actions: View | Diff | Splinter Review

Attachments on bug 19719: 72773 | 72829 | 73510 | 73511 | 74538 | 74539 | 76199 | 77559 | 77560 | 77561