View | Details | Raw Unified | Return to bug 21336
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_21336b.perl (+12 lines)
Line 0 Link Here
1 
$DBversion = 'XXX';  # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do( q|
4 
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` )
5 
VALUES
6 
('UnsubscribeReflectionDelay','',NULL,'Delay for locking unsubscribers', 'Integer'),
7 
('PatronAnonymizeDelay','',NULL,'Delay for anonymizing patrons', 'Integer'),
8 
('PatronRemovalDelay','',NULL,'Delay for removing anonymized patrons', 'Integer')
9 
    |);
10 
    SetVersion( $DBversion );
11 
    print "Upgrade to $DBversion done (Bug 21336 - Add preferences)\n";
12 
}
(-)a/installer/data/mysql/sysprefs.sql (+3 lines)
Lines 444-450 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
444 
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
 444 
('OverdueNoticeCalendar',0,NULL,'Take the calendar into consideration when generating overdue notices','YesNo'),
445 
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
 445 
('OverduesBlockCirc','noblock','noblock|confirmation|block','When checking out an item should overdues block checkout, generate a confirmation dialogue, or allow checkout','Choice'),
446 
('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'),
 446 
('OverduesBlockRenewing','allow','allow|blockitem|block','If any of patron checked out documents is late, should renewal be allowed, blocked only on overdue items or blocked on whatever checked out document','Choice'),
447 
('PatronAnonymizeDelay','',NULL,'Delay for anonymizing patrons', 'Integer'),
447 
('patronimages','0',NULL,'Enable patron images for the Staff Client','YesNo'),
 448 
('patronimages','0',NULL,'Enable patron images for the Staff Client','YesNo'),
449 
('PatronRemovalDelay','',NULL,'Delay for removing anonymized patrons', 'Integer'),
448 
('PatronSelfModificationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when a patron is editing their information via the OPAC.','free'),
 450 
('PatronSelfModificationBorrowerUnwantedField','',NULL,'Name the fields you don\'t want to display when a patron is editing their information via the OPAC.','free'),
449 
('PatronSelfRegistration','0',NULL,'If enabled, patrons will be able to register themselves via the OPAC.','YesNo'),
 451 
('PatronSelfRegistration','0',NULL,'If enabled, patrons will be able to register themselves via the OPAC.','YesNo'),
450 
('PatronSelfRegistrationAdditionalInstructions','','','A free text field to display additional instructions to newly self registered patrons.','free'),
 452 
('PatronSelfRegistrationAdditionalInstructions','','','A free text field to display additional instructions to newly self registered patrons.','free'),
Lines 606-611 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
606 
('UNIMARCField100Language','fre',NULL,'UNIMARC field 100 default language','short'),
 608 
('UNIMARCField100Language','fre',NULL,'UNIMARC field 100 default language','short'),
607 
('UpdateItemWhenLostFromHoldList','',NULL,'This is a list of values to update an item when it is marked as lost from the holds to pull screen','Free'),
 609 
('UpdateItemWhenLostFromHoldList','',NULL,'This is a list of values to update an item when it is marked as lost from the holds to pull screen','Free'),
608 
('UniqueItemFields','barcode','','Space-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table','Free'),
 610 
('UniqueItemFields','barcode','','Space-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table','Free'),
611 
('UnsubscribeReflectionDelay','',NULL,'Delay for locking unsubscribers', 'Integer'),
609 
('UpdateNotForLoanStatusOnCheckin', '', 'NULL', 'This is a list of value pairs. When an item is checked in, if the not for loan value on the left matches the items not for loan value it will be updated to the right-hand value. E.g. ''-1: 0'' will cause an item that was set to ''Ordered'' to now be available for loan. Each pair of values should be on a separate line.', 'Free'),
 612 
('UpdateNotForLoanStatusOnCheckin', '', 'NULL', 'This is a list of value pairs. When an item is checked in, if the not for loan value on the left matches the items not for loan value it will be updated to the right-hand value. E.g. ''-1: 0'' will cause an item that was set to ''Ordered'' to now be available for loan. Each pair of values should be on a separate line.', 'Free'),
610 
('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
 613 
('UpdateTotalIssuesOnCirc','0',NULL,'Whether to update the totalissues field in the biblio on each circ.','YesNo'),
611 
('UploadPurgeTemporaryFilesDays','',NULL,'If not empty, number of days used when automatically deleting temporary uploads','integer'),
 614 
('UploadPurgeTemporaryFilesDays','',NULL,'If not empty, number of days used when automatically deleting temporary uploads','integer'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/patrons.pref (-1 / +8 lines)
Lines 241-243 Patrons: Link Here
241 
               Enforced: 'Enforced'
 241 
               Enforced: 'Enforced'
242 
               Permissive: 'Permissive'
 242 
               Permissive: 'Permissive'
243 
         - "GDPR is the EU General Data Protection Regulation. When you enforce, patrons need to give consent before using the OPAC. If you set to permissive, Koha will warn but not enforce."
 243 
         - "GDPR is the EU General Data Protection Regulation. When you enforce, patrons need to give consent before using the OPAC. If you set to permissive, Koha will warn but not enforce."
244 
-
244 
     -
245 
         - Lock/expire patrons that submitted an unsubscribe request (refused consent) after
246 
         - pref: UnsubscribeReflectionDelay
247 
         - days, anonymize locked/expired accounts after
248 
         - pref: PatronAnonymizeDelay
249 
         - days and remove anonymized patron accounts after
250 
         - pref: PatronRemovalDelay
251 
         - 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.

Return to bug 21336