Attachment 164523 Details for Bug 36547 – Bug 36547: Added checked out column to Overdue table

[patch] Bug 36547: Added checked out column to Overdue table

Bug-36547-Added-checked-out-column-to-Overdue-tabl.patch (text/plain), 4.09 KB, created by Laura Escamilla on 2024-04-08 21:06:10 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Laura Escamilla

Created: 2024-04-08 21:06:10 UTC

Size: 4.09 KB

patch

obsolete

>From e1c650a8ab5d8a3700f38075b9308ed087156a84 Mon Sep 17 00:00:00 2001
>From: Laura Escamilla <laura.escamilla@bywatersolutions.com>
>Date: Mon, 8 Apr 2024 21:03:13 +0000
>Subject: [PATCH] Bug 36547: Added checked out column to Overdue table
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>To test:
>1. Make sure you have some overdue checkouts in your installation.
>2. Go to Circulation > Overdues
>3. Verify the âChecked out onâ column is visible by default, but can be hidden using the column settings
>4. Verify that the export to CSV via the link on top of the table and includes the âChecked out onâ field.
>5. Sign off and have an incredible day :D
>---
> admin/columns_settings.yml                              | 2 ++
> circ/overdue.pl                                         | 4 +++-
> koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt | 2 ++
> 3 files changed, 7 insertions(+), 1 deletion(-)
>
>diff --git a/admin/columns_settings.yml b/admin/columns_settings.yml
>index 39b70fe5f4..a95d227a29 100644
>--- a/admin/columns_settings.yml
>+++ b/admin/columns_settings.yml
>@@ -1864,6 +1864,8 @@ modules:
>               is_hidden: 1
>             -
>               columnname: shelving_location
>+            -
>+              columnname: datelastborrowed
>             -
>               columnname: barcode
>             -
>diff --git a/circ/overdue.pl b/circ/overdue.pl
>index e2bb848d42..429b0c1e4e 100755
>--- a/circ/overdue.pl
>+++ b/circ/overdue.pl
>@@ -241,6 +241,7 @@ if ($noreport) {
>         borrowers.branchcode,
>         issues.itemnumber,
>         issues.issuedate,
>+        items.datelastborrowed,
>         items.barcode,
>         items.homebranch,
>         items.holdingbranch,
>@@ -336,6 +337,7 @@ if ($noreport) {
>             email                  => $data->{email},
>             branchcode             => $data->{branchcode},
>             barcode                => $data->{barcode},
>+            datelastborrowed       => $data->{datelastborrowed},
>             itemnum                => $data->{itemnumber},
>             issuedate              => $data->{issuedate},
>             biblionumber           => $data->{biblionumber},
>@@ -400,7 +402,7 @@ sub build_csv {
>     # build header ...
>     my @keys =
>       qw ( duedate title author borrowertitle firstname surname phone barcode email address address2 zipcode city country
>-      branchcode itemcallnumber biblionumber borrowernumber itemnum issuedate replacementprice itemnotes_nonpublic streetnumber streettype);
>+      branchcode datelastissued itemcallnumber biblionumber borrowernumber itemnum issuedate replacementprice itemnotes_nonpublic streetnumber streettype);
>     my $csv = Text::CSV_XS->new();
>     $csv->combine(@keys);
>     push @lines, $csv->string();
>diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt
>index 76c56bea10..e96932818b 100644
>--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt
>+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt
>@@ -92,6 +92,7 @@
>           <th>Home library</th>
>           <th>Holding library</th>
>           <th>Shelving location</th>
>+          <th>Checked out on</th>
>           <th>Barcode</th>
>           <th>Call number</th>
>           <th>Item type</th>
>@@ -120,6 +121,7 @@
>             <td>[% Branches.GetName( overdueloo.homebranchcode ) | html %]</td>
>             <td>[% Branches.GetName( overdueloo.holdingbranchcode ) | html %]</td>
>             <td>[% AuthorisedValues.GetDescriptionByKohaField( kohafield => 'items.location', authorised_value => overdueloo.location ) | html %]</td>
>+            <td data-order="[% overdueloo.datelastborrowed | html %]"><span class='overdue'>[% overdueloo.datelastborrowed | $KohaDates %]</span></td>
>           <td><a href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[% overdueloo.biblionumber | uri %]&amp;itemnumber=[% overdueloo.itemnum | uri %]#item[% overdueloo.itemnum | uri %]">[% overdueloo.barcode | html %]</a></td>
>           <td>[% overdueloo.itemcallnumber | html %]</td>
>             <td>[% ItemTypes.GetDescription( overdueloo.itemtype ) | html %]</td>
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 36547: 164523 | 164553 | 169198 | 169199