Attachment #80330 for bug #15494

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




$DBversion = 'XXX';  # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    # you can use $dbh here like:
    # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" );

    $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')" );

    # or perform some test and warn
    # if( !column_exists( 'biblio', 'biblionumber' ) ) {
    #    warn "There is something wrong";
    # }

    # Always end with this (adjust the bug info)
    SetVersion( $DBversion );
    print "Upgrade to $DBversion done (Bug 15494 - Block renewals by arbitrary item values)\n";
}

Lines 248-253 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
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'),




                  yes: Block
                  no: Allow
            - his/her auto renewals.
        -
            - pref: ItemsDeniedRenewal
              type: textarea
              class: code
            - Define custom rules to deny specific items from renewal.
            - "<br />Can name any field in the items table followed by a colon then a space then"
            - "a bracketed list of values separated by commas."
            - "e.g."
            - "<br />ccode: [NEWFIC,NULL,DVD]"
            - "<br />itype: [NEWBK,\"\"]"
            - "<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."
    Checkin Policy:
        -
            - pref: HoldsAutoFill
- 

Return to bug 15494

Lines 476-481 Circulation: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/circulation.pref (-1 / +11 lines)
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	-

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_15494.perl (+16 lines)
	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	}