Attachment 135244 Details for Bug 24239 – Bug 24239: Add column illrequests.date_due

[patch] Bug 24239: Add column illrequests.date_due

Bug-24239-Add-column-illrequestsdatedue.patch (text/plain), 3.19 KB, created by Katrin Fischer on 2022-05-20 12:49:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2022-05-20 12:49:31 UTC

Size: 3.19 KB

patch

obsolete

>From 763d705eec60bc7dddb1437ad734a5c067173203 Mon Sep 17 00:00:00 2001
>From: Lari Taskula <lari.taskula@hypernova.fi>
>Date: Wed, 9 Feb 2022 23:06:37 +0000
>Subject: [PATCH] Bug 24239: Add column illrequests.date_due
>
>Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
>---
> Koha/Schema/Result/Illrequest.pm                  | 14 ++++++++++++++
> .../bug_24239-add_date_due_to_illrequests.pl      | 15 +++++++++++++++
> installer/data/mysql/kohastructure.sql            |  1 +
> 3 files changed, 30 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl
>
>diff --git a/Koha/Schema/Result/Illrequest.pm b/Koha/Schema/Result/Illrequest.pm
>index 16e7d9e6ed..ecc75eb797 100644
>--- a/Koha/Schema/Result/Illrequest.pm
>+++ b/Koha/Schema/Result/Illrequest.pm
>@@ -47,6 +47,14 @@ Patron associated with request
> 
> Potential bib linked to request
> 
>+=head2 date_due
>+
>+  data_type: 'datetime'
>+  datetime_undef_if_invalid: 1
>+  is_nullable: 1
>+
>+Custom date due specified by backend, leave NULL for default date_due calculation
>+
> =head2 branchcode
> 
>   data_type: 'varchar'
>@@ -180,6 +188,12 @@ __PACKAGE__->add_columns(
>   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
>   "biblio_id",
>   { data_type => "integer", is_nullable => 1 },
>+  "date_due",
>+  {
>+    data_type => "datetime",
>+    datetime_undef_if_invalid => 1,
>+    is_nullable => 1,
>+  },
>   "branchcode",
>   { data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },
>   "status",
>diff --git a/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl b/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl
>new file mode 100755
>index 0000000000..a8eb9beda1
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24239-add_date_due_to_illrequests.pl
>@@ -0,0 +1,15 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "24239",
>+    description => "Add date_due to illrequests",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+        # Do you stuffs here
>+        $dbh->do(q{
>+            ALTER TABLE `illrequests`
>+            ADD `date_due` datetime DEFAULT NULL AFTER `biblio_id`
>+        });
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 852d448804..d18e4fb5be 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2790,6 +2790,7 @@ CREATE TABLE `illrequests` (
>   `illrequest_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ILL request number',
>   `borrowernumber` int(11) DEFAULT NULL COMMENT 'Patron associated with request',
>   `biblio_id` int(11) DEFAULT NULL COMMENT 'Potential bib linked to request',
>+  `date_due` datetime DEFAULT NULL COMMENT 'Custom date due specified by backend, leave NULL for default date_due calculation',
>   `branchcode` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The branch associated with the request',
>   `status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current Koha status of request',
>   `status_alias` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Foreign key to relevant authorised_values.authorised_value',
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 24239: 96246 | 106409 | 130056 | 130057 | 130414 | 130415 | 130416 | 133475 | 133476 | 133477 | 135244 | 135245 | 135246 | 135943 | 135944 | 135945 | 136458 | 136459 | 136460 | 136461 | 136462 | 136463