Attachment 121929 Details for Bug 12446 – Bug 12446: Add canbeguarantee value to patron categories sample data

[patch] Bug 12446: Add canbeguarantee value to patron categories sample data

Bug-12446-Add-canbeguarantee-value-to-patron-categ.patch (text/plain), 6.76 KB, created by Salman Ali on 2021-06-14 19:15:32 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Salman Ali

Created: 2021-06-14 19:15:32 UTC

Size: 6.76 KB

patch

obsolete

>From a074847a013db02a39b9e1ad91aa170bdbc90e6f Mon Sep 17 00:00:00 2001
>From: Maryse Simard <maryse.simard@inlibro.com>
>Date: Thu, 12 Nov 2020 16:01:35 -0500
>Subject: [PATCH] Bug 12446: Add canbeguarantee value to patron categories
> sample data
>
>This patch changes sample data so patron categories of type 'C' or
>'P' can be guarantees by default.
>---
> .../mysql/en/optional/patron_categories.yml   |  5 ++++
> .../fr-FR/2-Optionel/patron_categories.sql    | 18 ++++++-------
> .../nb-NO/2-Valgfritt/patron_categories.sql   | 26 +++++++++----------
> 3 files changed, 27 insertions(+), 22 deletions(-)
>
>diff --git a/installer/data/mysql/en/optional/patron_categories.yml b/installer/data/mysql/en/optional/patron_categories.yml
>index e5a02d1084..3d8d72696f 100644
>--- a/installer/data/mysql/en/optional/patron_categories.yml
>+++ b/installer/data/mysql/en/optional/patron_categories.yml
>@@ -99,6 +99,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'C'
>+          canbeguarantee: 1
> 
>         - categorycode: 'J'
>           description: 'Juvenile'
>@@ -112,6 +113,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'C'
>+          canbeguarantee: 1
> 
>         - categorycode: 'YA'
>           description: 'Young Adult'
>@@ -125,6 +127,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'C'
>+          canbeguarantee: 1
> 
>         #  Professionals
>         - categorycode: 'T'
>@@ -139,6 +142,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'P'
>+          canbeguarantee: 1
> 
>         - categorycode: 'B'
>           description: 'Board'
>@@ -152,6 +156,7 @@ tables:
>           issuelimit: ~
>           reservefee: '0.000000'
>           category_type: 'P'
>+          canbeguarantee: 1
> 
>         #  Institutional
>         - categorycode: 'IL'
>diff --git a/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql b/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql
>index 22ddcd99f8..47902271aa 100644
>--- a/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql
>+++ b/installer/data/mysql/fr-FR/2-Optionel/patron_categories.sql
>@@ -1,15 +1,15 @@
> SET NAMES utf8;
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES 
>-('ADULT','Adulte',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('ETUD','Etudiant',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
>+('ADULT','Adulte',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('ETUD','Etudiant',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
> 
>-('ENF','Enfant',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('ADO','Adolescent',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>+('ENF','Enfant',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('ADO','Adolescent',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
> 
>-('PROF','Professeur',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>-('PERS','Personnel bibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>+('PROF','Professeur',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
>+('PERS','Personnel bibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
> 
>-('PEB','PrÃªt Entre BibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>+('PEB','PrÃªt Entre BibliothÃ¨que',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
> ('PMI','PMI',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('BDP','BibliothÃ¨que DÃ©partementale',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I');
>+('BDP','BibliothÃ¨que DÃ©partementale',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0);
> 
>diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql
>index 456eed81f4..0d7c233779 100644
>--- a/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql
>+++ b/installer/data/mysql/nb-NO/2-Valgfritt/patron_categories.sql
>@@ -19,26 +19,26 @@
> -- You should have received a copy of the GNU General Public License
> -- along with Koha; if not, see <http://www.gnu.org/licenses>.
> 
>-INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`) VALUES 
>+INSERT INTO `categories` (`categorycode`, `description`, `enrolmentperiod`, `upperagelimit`, `dateofbirthrequired`, `finetype`, `bulk`, `enrolmentfee`, `overduenoticerequired`, `issuelimit`, `reservefee`, `category_type`, `canbeguarantee`) VALUES
> 
> -- Adult Patrons
>-('PT','LÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>-('HB','HjemmelÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A'),
>+('PT','LÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('ST','Student',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
>+('HB','HjemmelÃ¥ner',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','A',0),
> 
> -- Children
>-('K','Barn',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('J','Ungdom',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>-('YA','Ung voksen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C'),
>+('K','Barn',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('J','Ungdom',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
>+('YA','Ung voksen',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','C',1),
> 
> -- Professionals
>-('T','LÃ¦rer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P'),
>-('B','Styremedlem',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P'),
>+('T','LÃ¦rer',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','P',1),
>+('B','Styremedlem',99,17,5,NULL,NULL,'0.000000',1,NULL,'0.000000','P',1),
> 
> -- Institutional
>-('IL','FjernlÃ¥n',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('SC','Skole',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>-('L','Bibliotek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I'),
>+('IL','FjernlÃ¥n',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('SC','Skole',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
>+('L','Bibliotek',99,999,18,NULL,NULL,'0.000000',1,NULL,'0.000000','I',0),
> 
> -- Staff
>-('S','Bibliotekansatt',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S');
>+('S','Bibliotekansatt',99,999,18,NULL,NULL,'0.000000',0,NULL,'0.000000','S',0);
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 12446: 29278 | 36176 | 39744 | 42469 | 42470 | 42535 | 46277 | 46278 | 46327 | 46328 | 46345 | 46486 | 49793 | 50953 | 53534 | 53535 | 53536 | 53913 | 60929 | 60930 | 60934 | 63148 | 63149 | 63214 | 64793 | 64794 | 64828 | 72295 | 72883 | 77766 | 77767 | 77768 | 79343 | 79344 | 79345 | 79347 | 79348 | 85069 | 88364 | 88365 | 88366 | 88367 | 90389 | 90390 | 90391 | 90392 | 90470 | 90471 | 90472 | 90473 | 93388 | 93389 | 93390 | 93391 | 93392 | 93393 | 93394 | 95411 | 95853 | 95854 | 95855 | 95856 | 95857 | 95858 | 95859 | 95860 | 106753 | 106754 | 106755 | 106756 | 106757 | 107611 | 111052 | 111053 | 111317 | 111318 | 112102 | 112160 | 112161 | 112162 | 112163 | 113583 | 121925 | 121926 | 121927 | 121928 | 121929 | 122084 | 122085 | 122086 | 122087 | 122088 | 122089 | 122090 | 122091 | 122184 | 122185 | 122186 | 122187 | 130398 | 130399 | 130400 | 130401 | 130402 | 131965 | 131966 | 131967 | 131968 | 131969 | 133691 | 133952 | 133953 | 133954 | 133955 | 133956 | 133957 | 134930 | 134931 | 134932 | 134933 | 134934 | 134935 | 134936 | 135506 | 135507 | 135508 | 135509 | 135510 | 135511 | 135512 | 135519 | 135520 | 135521 | 135522 | 135523 | 135544 | 135545 | 142401 | 142408 | 142431 | 142432 | 142433 | 142434 | 142435 | 142436 | 142437 | 142438 | 142439