Bugzilla – Attachment 95960 Details for
Bug 24151
Add a pseudonymization process for patrons and transactions
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24151: Add sysprefs
Bug-24151-Add-sysprefs.patch (text/plain), 5.52 KB, created by
Jonathan Druart
on 2019-12-03 18:11:11 UTC
(
hide
)
Description:
Bug 24151: Add sysprefs
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2019-12-03 18:11:11 UTC
Size:
5.52 KB
patch
obsolete
>From 11e3c80438e2db0940dedf1d091bbe3aa7333aad Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 22 Nov 2019 15:38:34 +0100 >Subject: [PATCH] Bug 24151: Add sysprefs > >3 new sysprefs: > * Pseudonymization > * PseudonymizationPatronFields > * PseudonymizationTransactionFields > >Sponsored-by: Association KohaLa - https://koha-fr.org/ >--- > installer/data/mysql/atomicupdate/bug_XXXXX.perl | 13 +++++++++ > installer/data/mysql/sysprefs.sql | 3 ++ > .../prog/en/modules/admin/preferences/patrons.pref | 33 ++++++++++++++++++++++ > 3 files changed, 49 insertions(+) > >diff --git a/installer/data/mysql/atomicupdate/bug_XXXXX.perl b/installer/data/mysql/atomicupdate/bug_XXXXX.perl >index 0704ce0af9..1a9118f9fe 100644 >--- a/installer/data/mysql/atomicupdate/bug_XXXXX.perl >+++ b/installer/data/mysql/atomicupdate/bug_XXXXX.perl >@@ -40,6 +40,19 @@ if( CheckVersion( $DBversion ) ) { > |); > } > >+ $dbh->do(q| >+ INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) >+ VALUES ('Pseudonymization','1',NULL,'If enabled patrons and transactions will be copied in a separate table for statistics purpose','YesNo') >+ |); >+ $dbh->do(q| >+ INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) >+ ('PseudonymizationPatronFields','','title,city,state,zipcode,country,branchcode,categorycode,dateenrolled,sex,sort1,sort2','Patron fields to copy to the anonymized_borrowers table','multiple'), >+ |); >+ $dbh->do(q| >+ INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) >+ ('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the anonymized_transactions table','multiple'), >+ |); >+ > # Always end with this (adjust the bug info) > SetVersion( $DBversion ); > print "Upgrade to $DBversion done (Bug XXXXX - description)\n"; >diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql >index 9fc3d5821e..984d35ed8d 100644 >--- a/installer/data/mysql/sysprefs.sql >+++ b/installer/data/mysql/sysprefs.sql >@@ -503,6 +503,9 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` > ('PrivacyPolicyURL','',NULL,'This URL is used in messages about GDPR consents.', 'Free'), > ('ProcessingFeeNote', '', NULL, 'Set the text to be recorded in the column note, table accountlines when the processing fee (defined in item type) is applied', 'textarea'), > ('ProtectSuperlibrarianPrivileges','1',NULL,'If enabled, non-superlibrarians cannot set superlibrarian privileges','YesNo'), >+('Pseudonymization','1',NULL,'If enabled patrons and transactions will be copied in a separate table for statistics purpose','YesNo'), >+('PseudonymizationPatronFields','','title,city,state,zipcode,country,branchcode,categorycode,dateenrolled,sex,sort1,sort2','Patron fields to copy to the anonymized_borrowers table','multiple'), >+('PseudonymizationTransactionFields','','datetime,branchcode,transaction_type,itemnumber,itemtype,holdingbranch,location,itemcallnumber,ccode','Transaction fields to copy to the anonymized_transactions table','multiple'), > ('PurgeSuggestionsOlderThan', '', NULL, 'If this script is called without the days parameter', 'Integer'), > ('QueryAutoTruncate','1',NULL,'If ON, query truncation is enabled by default','YesNo'), > ('QueryFuzzy','1',NULL,'If ON, enables fuzzy option for searches','YesNo'), >diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref >index 14f1ef910c..0f8c8f8b28 100644 >--- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref >+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref >@@ -257,3 +257,36 @@ Patrons: > - days and remove anonymized patron accounts after > - pref: PatronRemovalDelay > - "days.<br>IMPORTANT: No action is performed when these delays are empty (no text). But a zero value ('0') is interpreted as no delay (do it now)! The actions are performed by the cleanup database cron job." >+ - >+ - pref: Pseudonymization >+ choices: >+ yes: Enable >+ no: Disable >+ - "pseudonymization to comply with GDPR for personal information." >+ - "Patrons and transactions will be copied to a separate table for statistics purpose." >+ - "<br/>Use the following fields for patrons:" >+ - pref: PseudonymizationPatronFields >+ multiple: >+ title: "Patron's title" >+ city: "City" >+ state: "State" >+ zipcode: "Zipcode" >+ country: "Country" >+ branchcode: "Patron's library" >+ categorycode: "Patron's category" >+ dateenrolled: "Date the patron was added to Koha" >+ sex: "Patron's gender" >+ sort1: "Sort1" >+ sort2: "Sort2" >+ - "<br/> And the following fields for the transactions:" >+ - pref: PseudonymizationTransactionFields >+ multiple: >+ datetime: "Date and time of the transaction" >+ branchcode: "Library where the transaction occurred" >+ transaction_type: "Transaction type" >+ itemnumber: "Itemnumber" >+ itemtype: "Item type" >+ holdingbranch: "Holding branch" >+ location: "Location" >+ itemcallnumber: "Item's callnumber" >+ ccode: "Collection code" >-- >2.11.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 24151
:
95959
|
95960
|
95961
|
95962
|
95963
|
95964
|
95965
|
95966
|
95967
|
95968
|
95969
|
95970
|
95971
|
95972
|
95973
|
95974
|
95975
|
95976
|
97240
|
97241
|
97242
|
97243
|
97244
|
97245
|
97246
|
97247
|
97248
|
97249
|
97250
|
97251
|
97252
|
101034
|
101035
|
101036
|
101037
|
101038
|
101039
|
101040
|
101041
|
101042
|
101043
|
101044
|
101045
|
101046
|
101047
|
101048
|
101049
|
105801
|
105802
|
105803
|
105804
|
105805
|
105806
|
105807
|
105808
|
105809
|
105810
|
105811
|
105812
|
105813
|
105814
|
105815
|
105816
|
106032
|
106033
|
106034
|
106035
|
106036
|
106037
|
106038
|
106039
|
106040
|
106041
|
106042
|
106043
|
106044
|
106045
|
106046
|
106047
|
106048
|
106049
|
106195
|
106255
|
107127
|
107225