From e1c650a8ab5d8a3700f38075b9308ed087156a84 Mon Sep 17 00:00:00 2001 From: Laura Escamilla 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 @@ Home library Holding library Shelving location + Checked out on Barcode Call number Item type @@ -120,6 +121,7 @@ [% Branches.GetName( overdueloo.homebranchcode ) | html %] [% Branches.GetName( overdueloo.holdingbranchcode ) | html %] [% AuthorisedValues.GetDescriptionByKohaField( kohafield => 'items.location', authorised_value => overdueloo.location ) | html %] + [% overdueloo.datelastborrowed | $KohaDates %] [% overdueloo.barcode | html %] [% overdueloo.itemcallnumber | html %] [% ItemTypes.GetDescription( overdueloo.itemtype ) | html %] -- 2.30.2