Attachment 102593 Details for Bug 25037 – Bug 25037: Add authorised value for checkout types

[patch] Bug 25037: Add authorised value for checkout types

Bug-25037-Add-authorised-value-for-checkout-types.patch (text/plain), 2.52 KB, created by Lari Taskula on 2020-04-08 18:45:56 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lari Taskula

Created: 2020-04-08 18:45:56 UTC

Size: 2.52 KB

patch

obsolete

>From 0a5e1adefe0302e49bf541d65f4c2951ef7dd64a Mon Sep 17 00:00:00 2001
>From: Lari Taskula <lari.taskula@hypernova.fi>
>Date: Wed, 1 Apr 2020 14:29:43 +0000
>Subject: [PATCH] Bug 25037: Add authorised value for checkout types
>
>This commit adds an authorised value category "CHECKOUT_TYPE" and
>an authorised value "OS" (on-site) and "C" (normal checkout).
>
>To test:
>1. perl installer/data/mysql/updatedatabase.pl
>
>Sponsored-by: The National Library of Finland
>---
> .../bug_25037_1_add_auth_values.perl          | 21 +++++++++++++++++++
> .../data/mysql/mandatory/auth_val_cat.sql     |  4 ++++
> 2 files changed, 25 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_25037_1_add_auth_values.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_25037_1_add_auth_values.perl b/installer/data/mysql/atomicupdate/bug_25037_1_add_auth_values.perl
>new file mode 100644
>index 0000000000..24780325a9
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_25037_1_add_auth_values.perl
>@@ -0,0 +1,21 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    # Add authorised value category "CHECKOUT_TYPE"
>+    $dbh->do( q|
>+        INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('CHECKOUT_TYPE');
>+    | );
>+
>+    # Add authorised value "OS" under "CHECKOUT_TYPE" category
>+    $dbh->do( q|
>+        INSERT IGNORE INTO authorised_values(category, authorised_value, lib, lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout');
>+    | );
>+    # Add authorised value "C" under "CHECKOUT_TYPE" category
>+    $dbh->do( q|
>+        INSERT IGNORE INTO authorised_values(category, authorised_value, lib, lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout');
>+    | );
>+
>+    # Always end with this (adjust the bug info)
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 25037 - Add authorised value for checkout types )\n";
>+}
>diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql
>index cca989c9df..2e8775929e 100644
>--- a/installer/data/mysql/mandatory/auth_val_cat.sql
>+++ b/installer/data/mysql/mandatory/auth_val_cat.sql
>@@ -65,3 +65,7 @@ INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
> -- For Claims returned
> INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
>     ('RETURN_CLAIM_RESOLUTION');
>+
>+-- For Circulation types
>+INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
>+    ('CHECKOUT_TYPE');
>-- 
>2.17.1

Actions: View | Diff | Splinter Review

Attachments on bug 25037: 102259 | 102260 | 102261 | 102262 | 102263 | 102264 | 102265 | 102266 | 102267 | 102268 | 102269 | 102272 | 102413 | 102414 | 102415 | 102416 | 102417 | 102418 | 102419 | 102420 | 102421 | 102422 | 102423 | 102424 | 102586 | 102587 | 102588 | 102589 | 102590 | 102591 | 102592 | 102593 | 102594 | 102595 | 102596 | 102597 | 102598 | 102599 | 102655 | 102656 | 102657 | 102658 | 102659 | 102660 | 102661 | 102662 | 102663 | 102664 | 102665 | 102666 | 102675 | 102676 | 104267 | 104268 | 105638 | 105780 | 105781 | 105782 | 105783 | 105784