Bugzilla – Attachment 173321 Details for
Bug 38222
Let staff pick a cancellation reason when canceling a booking
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 38222: (QA follow-up) Add av category update
Bug-38222-QA-follow-up-Add-av-category-update.patch (text/plain), 1.90 KB, created by
Martin Renvoize (ashimema)
on 2024-10-25 07:28:49 UTC
(
hide
)
Description:
Bug 38222: (QA follow-up) Add av category update
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2024-10-25 07:28:49 UTC
Size:
1.90 KB
patch
obsolete
>From bad7b1b0ae7049263f8a3b4667d1cd0af78daf2d Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Fri, 25 Oct 2024 08:19:08 +0100 >Subject: [PATCH] Bug 38222: (QA follow-up) Add av category update > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > .../data/mysql/atomicupdate/bug_38222.pl | 20 +++++++++++++++++++ > .../data/mysql/mandatory/auth_val_cat.sql | 5 +++++ > 2 files changed, 25 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_38222.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_38222.pl b/installer/data/mysql/atomicupdate/bug_38222.pl >new file mode 100644 >index 00000000000..f85bf463202 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_38222.pl >@@ -0,0 +1,20 @@ >+use Modern::Perl; >+use Koha::Installer::Output qw(say_warning say_failure say_success say_info); >+ >+return { >+ bug_number => "38222", >+ description => "Add cancellation reasons to bookings", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ $dbh->do( >+ q{ >+ INSERT IGNORE INTO authorised_value_categories (category_name, is_system) >+ VALUES >+ ('BOOKING_CANCELLATION', 1) >+ } >+ ); >+ say_success( $out, "Added BOOKING_CANCELLATION AV category" ); >+ }, >+}; >diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql >index be8ef55bff5..c1428e4a3c8 100644 >--- a/installer/data/mysql/mandatory/auth_val_cat.sql >+++ b/installer/data/mysql/mandatory/auth_val_cat.sql >@@ -101,3 +101,8 @@ INSERT IGNORE INTO authorised_value_categories (category_name, is_system) > VALUES > ('TICKET_STATUS', 1), > ('TICKET_RESOLUTION', 1); >+ >+-- For bookings >+INSERT IGNORE INTO authorised_value_categories (category_name, is_system) >+VALUES >+ ('BOOKING_CANCELLATION', 1); >-- >2.47.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 38222
:
173230
|
173231
|
173232
|
173233
|
173264
|
173265
|
173277
|
173278
|
173281
|
173282
|
173312
|
173313
|
173314
|
173315
|
173316
|
173317
|
173318
|
173319
|
173320
| 173321 |
173322
|
173323
|
173336
|
173337
|
173338
|
173339