Bugzilla – Attachment 165770 Details for
Bug 35628
Add optional statuses to catalog concerns
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 35628: Add status to tickets
Bug-35628-Add-status-to-tickets.patch (text/plain), 5.14 KB, created by
Martin Renvoize (ashimema)
on 2024-04-29 17:32:28 UTC
(
hide
)
Description:
Bug 35628: Add status to tickets
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2024-04-29 17:32:28 UTC
Size:
5.14 KB
patch
obsolete
>From 7a3a28d4316024ab2747d5a8c84fda2f96d324a8 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 21 Dec 2023 15:57:41 +0000 >Subject: [PATCH] Bug 35628: Add status to tickets > >This patch adds a new TICKET_STATUS authorized value category as well as >adding the new 'status' field to both 'tickets' and 'ticket_updates' >tables. > >Signed-off-by: Esther Melander <esther@bywatersolutions.com> >Signed-off-by: Ray Delahunty <lib-systems@arts.ac.uk> >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > .../data/mysql/atomicupdate/bug_35628.pl | 34 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 2 ++ > .../data/mysql/mandatory/auth_val_cat.sql | 5 +++ > .../en/modules/admin/authorised_values.tt | 2 ++ > 4 files changed, 43 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_35628.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_35628.pl b/installer/data/mysql/atomicupdate/bug_35628.pl >new file mode 100755 >index 00000000000..e1014582e19 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_35628.pl >@@ -0,0 +1,34 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "35626", >+ description => "Add statuses to catalog concerns", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ unless ( column_exists( 'tickets', 'status' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE tickets ADD COLUMN status varchar(80) DEFAULT NULL COMMENT 'current status of the ticket' AFTER body >+ } >+ ); >+ >+ say $out "Added column 'tickets.status'"; >+ } >+ unless ( column_exists( 'ticket_updates', 'status' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE ticket_updates ADD COLUMN status varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update' AFTER message >+ } >+ ); >+ >+ say $out "Added column 'ticket_updates.status'"; >+ } >+ $dbh->do( >+ q{ >+ INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES ('TICKET_STATUS', 1); >+ } >+ ); >+ say $out "Added TICKET_STATUS authorised value category"; >+ }, >+}; >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index cfcce6f6658..002dbb1cd4d 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -6309,6 +6309,7 @@ CREATE TABLE `ticket_updates` ( > `public` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'boolean flag to denote whether this update is public', > `date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this update was logged', > `message` text NOT NULL COMMENT 'update message content', >+ `status` varchar(80) DEFAULT NULL COMMENT 'status of ticket at this update', > PRIMARY KEY (`id`), > KEY `ticket_updates_ibfk_1` (`ticket_id`), > KEY `ticket_updates_ibfk_2` (`user_id`), >@@ -6331,6 +6332,7 @@ CREATE TABLE `tickets` ( > `reported_date` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date and time this ticket was reported', > `title` text NOT NULL COMMENT 'ticket title', > `body` text NOT NULL COMMENT 'ticket details', >+ `status` varchar(80) DEFAULT NULL COMMENT 'current status of the ticket', > `resolver_id` int(11) DEFAULT NULL COMMENT 'id of the user who resolved the ticket', > `resolved_date` datetime DEFAULT NULL COMMENT 'date and time this ticket was resolved', > `biblio_id` int(11) DEFAULT NULL COMMENT 'id of biblio linked', >diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql >index 375ba87caf8..a867be43da7 100644 >--- a/installer/data/mysql/mandatory/auth_val_cat.sql >+++ b/installer/data/mysql/mandatory/auth_val_cat.sql >@@ -95,3 +95,8 @@ VALUES > ('ERM_DATABASE_REPORTS_METRICS', 1), > ('ERM_TITLE_REPORTS_METRICS', 1), > ('ERM_ITEM_REPORTS_METRICS', 1); >+ >+-- For ticket statuses >+INSERT IGNORE INTO authorised_value_categories (category_name, is_system) >+VALUES >+ ('TICKET_STATUS', 1); >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt >index 11ccab61a5a..c93408efd17 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/authorised_values.tt >@@ -515,6 +515,8 @@ > <p>A list of additional custom status values for suggestions that can be used in addition to the default values.</p> > [% CASE 'TERM' %] > <p>Terms to be used in Course Reserves module. Enter terms that will show in the drop down menu when setting up a Course reserve. (For example: Spring, Summer, Winter, Fall).</p> >+ [% CASE 'TICKET_STATUS' %] >+ <p>A list of custom status values for tickets that can be used in addition to the default values of "New" and "Resolved".</p> > [% CASE 'UPLOAD' %] > <p>Categories to be assigned to file uploads. Without a category an upload is considered temporary and may be removed during automated cleanup.</p> > [% CASE 'VENDOR_TYPE' %] >-- >2.44.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 35628
:
160255
|
160256
|
160257
|
160258
|
160259
|
160268
|
160269
|
160270
|
160271
|
160272
|
160273
|
160274
|
160286
|
160287
|
160288
|
160289
|
160290
|
160308
|
160309
|
160310
|
160311
|
160312
|
160313
|
160314
|
160315
|
160316
|
160317
|
160318
|
160319
|
160320
|
160329
|
160330
|
160331
|
160332
|
160333
|
160334
|
160335
|
160364
|
162500
|
164912
|
164913
|
164914
|
164915
|
164916
|
164917
|
164918
|
165551
|
165552
|
165553
|
165554
|
165555
|
165556
|
165557
|
165560
|
165561
|
165562
|
165563
|
165564
|
165599
|
165600
|
165601
|
165602
|
165603
|
165604
|
165605
|
165606
|
165607
|
165608
|
165622
|
165623
|
165624
|
165625
|
165626
|
165627
|
165628
|
165629
|
165630
|
165631
| 165770 |
165771
|
165772
|
165773
|
165774
|
165775
|
165776
|
165777
|
165778
|
165779