Attachment 133520 Details for Bug 29092 – Bug 29092: Add timestamp to account-fines table column settings

[patch] Bug 29092: Add timestamp to account-fines table column settings

0001-Bug-29092-Add-timestamp-to-account-fines-table-colum.patch (text/plain), 2.33 KB, created by Emmi Takkinen on 2022-04-21 06:29:19 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Emmi Takkinen

Created: 2022-04-21 06:29:19 UTC

Size: 2.33 KB

patch

obsolete

>From 466f3983f64d6d2148cff042c1de73817d3c0a6a Mon Sep 17 00:00:00 2001
>From: Emmi Takkinen <emmi.takkinen@koha-suomi.fi>
>Date: Thu, 21 Apr 2022 09:27:17 +0300
>Subject: [PATCH] Bug 29092: Add timestamp to account-fines table column
> settings
>
>Table settings for the account_fines table (in the Patrons
>section, the "Transactions" table in a patron account) are
>missing a checkbox for the "Updated On" column. Because
>of this, one cannot hide the Updated On column and any
>other values one sets here get applied to the wrong
>columns.
>
>This patch adds timestamp to account-fines column settings.
>To test:
>
>1) Navigate to columns settings page and modify
>account-fines tables column.
>=> Note that if you hide e.g. account_type column, column
>credit_number is hidden on patrons account page
>2) Apply patch and update database.
>=> Account-fines column settings has now a option to hide
>timestamp.
>=> Correct columns should now be hidden.
>
>Sponsored-by: Koha-Suomi Oy
>---
> admin/columns_settings.yml                     |  2 ++
> installer/data/mysql/atomicupdate/bug_29092.pl | 14 ++++++++++++++
> 2 files changed, 16 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_29092.pl
>
>diff --git a/admin/columns_settings.yml b/admin/columns_settings.yml
>index 1a91d8c6f5..08eb703b78 100644
>--- a/admin/columns_settings.yml
>+++ b/admin/columns_settings.yml
>@@ -735,6 +735,8 @@ modules:
>         columns:
>             -
>               columnname: date
>+            -
>+              columnname: timestamp
>             -
>               columnname: credit_number
>               is_hidden: 1
>diff --git a/installer/data/mysql/atomicupdate/bug_29092.pl b/installer/data/mysql/atomicupdate/bug_29092.pl
>new file mode 100755
>index 0000000000..797271ce6b
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_29092.pl
>@@ -0,0 +1,14 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "29092",
>+    description => "Add timestamp to account-fines table column settings",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+        # Do you stuffs here
>+        $dbh->do(q{INSERT IGNORE INTO columns_settings (module, page, tablename, columnname, cannot_be_toggled, is_hidden) VALUES ("members", "fines", "account-fines", "timestamp", 0, 0)});
>+        # Print useful stuff here
>+        say $out "Update is going well so far";
>+    },
>+};
>-- 
>2.25.1
>

Actions: View | Diff | Splinter Review

Attachments on bug 29092: 133520 | 133670 | 133750