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

(-)a/installer/data/mysql/atomicupdate/bug_15494.perl (+16 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    # you can use $dbh here like:
4
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );
5
6
    $dbh->do( "INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES ('ItemsDeniedRenewal','','','This syspref allows to define custom rules for denying renewal of specific items.','Textarea')" );
7
8
    # or perform some test and warn
9
    # if( !column_exists( 'biblio', 'biblionumber' ) ) {
10
    #    warn "There is something wrong";
11
    # }
12
13
    # Always end with this (adjust the bug info)
14
    SetVersion( $DBversion );
15
    print "Upgrade to $DBversion done (Bug 15494 - Block renewals by arbitrary item values)\n";
16
}
(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
Lines 248-253 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
248
('itemBarcodeFallbackSearch','',NULL,'If set, uses scanned item barcodes as a catalogue search if not found as barcodes','YesNo'),
248
('itemBarcodeFallbackSearch','',NULL,'If set, uses scanned item barcodes as a catalogue search if not found as barcodes','YesNo'),
249
('itemBarcodeInputFilter','','whitespace|T-prefix|cuecat|libsuite8|EAN13','If set, allows specification of a item barcode input filter','Choice'),
249
('itemBarcodeInputFilter','','whitespace|T-prefix|cuecat|libsuite8|EAN13','If set, allows specification of a item barcode input filter','Choice'),
250
('itemcallnumber','082ab',NULL,'The MARC field/subfield that is used to calculate the itemcallnumber (Dewey would be 082ab or 092ab; LOC would be 050ab or 090ab) could be 852hi from an item record','free'),
250
('itemcallnumber','082ab',NULL,'The MARC field/subfield that is used to calculate the itemcallnumber (Dewey would be 082ab or 092ab; LOC would be 050ab or 090ab) could be 852hi from an item record','free'),
251
('ItemsDeniedRenewal','','','This syspref allows to define custom rules for denying renewal of specific items.','Textarea'),
251
('KohaAdminEmailAddress','root@localhost','','Define the email address where patron modification requests are sent','free'),
252
('KohaAdminEmailAddress','root@localhost','','Define the email address where patron modification requests are sent','free'),
252
('KohaManualBaseURL','https://koha-community.org/manual/','','Where is the Koha manual/documentation located?','Free'),
253
('KohaManualBaseURL','https://koha-community.org/manual/','','Where is the Koha manual/documentation located?','Free'),
253
('KohaManualLanguage','en','en|ar|cs|de|es|fr|it|pt_BR|tr|zh_TW','What is the language of the online manual you want to use?','Choice'),
254
('KohaManualLanguage','en','en|ar|cs|de|es|fr|it|pt_BR|tr|zh_TW','What is the language of the online manual you want to use?','Choice'),
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +11 lines)
Lines 476-481 Circulation: Link Here
476
                  yes: Block
476
                  yes: Block
477
                  no: Allow
477
                  no: Allow
478
            - his/her auto renewals.
478
            - his/her auto renewals.
479
        -
480
            - pref: ItemsDeniedRenewal
481
              type: textarea
482
              class: code
483
            - Define custom rules to deny specific items from renewal.
484
            - "<br />Can name any field in the items table followed by a colon then a space then"
485
            - "a bracketed list of values separated by commas."
486
            - "e.g."
487
            - "<br />ccode: [NEWFIC,NULL,DVD]"
488
            - "<br />itype: [NEWBK,\"\"]"
489
            - "<br /> Note: the word 'NULL' can be used to block renewal on undefined fields, while an empty string \"\" will block on an empty (but defined) field."
479
    Checkin Policy:
490
    Checkin Policy:
480
        -
491
        -
481
            - pref: HoldsAutoFill
492
            - pref: HoldsAutoFill
482
- 

Return to bug 15494