Attachment #100115 for bug #20936

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




$DBversion = 'XXX'; # will be replaced by the RM
if( CheckVersion( $DBversion ) ) {
    # you can use $dbh here like:
    $dbh->do(qq{
        INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
        ('OPACHoldsHistory','1','','If ON, enables display of Patron Holds History in OPAC','YesNo')
    });

    # 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 20936 - Add OPACHoldsHistory preferences)\n";
}

Lines 386-391 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
386	('OpacHiddenItemsExceptions','',NULL,'List of borrower categories, separated by \|, that can see items otherwise hidden by OpacHiddenItems','Textarea'),	386	('OpacHiddenItemsExceptions','',NULL,'List of borrower categories, separated by \|, that can see items otherwise hidden by OpacHiddenItems','Textarea'),
387	('OpacHighlightedWords','1','','If Set, then queried words are higlighted in OPAC','YesNo'),	387	('OpacHighlightedWords','1','','If Set, then queried words are higlighted in OPAC','YesNo'),
388	('OPACHoldingsDefaultSortField','first_column','first_column\|homebranch\|holdingbranch','Default sort field for the holdings table at the OPAC','choice'),	388	('OPACHoldingsDefaultSortField','first_column','first_column\|homebranch\|holdingbranch','Default sort field for the holdings table at the OPAC','choice'),
		389	('OPACHoldsHistory','1','','If ON, enables display of Patron Holds History in OPAC','YesNo'),
389	('OPACHoldsIfAvailableAtPickup','1','','Allow to pickup up holds at libraries where the item is available','YesNo'),	390	('OPACHoldsIfAvailableAtPickup','1','','Allow to pickup up holds at libraries where the item is available','YesNo'),
390	('OPACHoldsIfAvailableAtPickupExceptions','','','List the patron categories not affected by OPACHoldsIfAvailableAtPickup if off','Free'),	391	('OPACHoldsIfAvailableAtPickupExceptions','','','List the patron categories not affected by OPACHoldsIfAvailableAtPickup if off','Free'),
391	('OpacHoldNotes','0','','Show hold notes on OPAC','YesNo'),	392	('OpacHoldNotes','0','','Show hold notes on OPAC','YesNo'),

Lines 708-713 OPAC: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-1 / +6 lines)
708	yes: Allow	708	yes: Allow
709	no: "Don't allow"	709	no: "Don't allow"
710	- patrons to see what books they have checked out in the past.	710	- patrons to see what books they have checked out in the past.
		711	-
		712	- pref: OPACHoldsHistory
		713	choices:
		714	yes: Allow
		715	no: "Don't allow"
		716	- patrons to see what books they have place holds in the past.
711	-	717	-
712	- pref: EnableOpacSearchHistory	718	- pref: EnableOpacSearchHistory
713	default: 0	719	default: 0
714	-

Return to bug 20936

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug-20936.perl (+17 lines)
	1	$DBversion = 'XXX'; # will be replaced by the RM
	2	if( CheckVersion( $DBversion ) ) {
	3	# you can use $dbh here like:
	4	$dbh->do(qq{
	5	INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
	6	('OPACHoldsHistory','1','','If ON, enables display of Patron Holds History in OPAC','YesNo')
	7	});
	8
	9	# or perform some test and warn
	10	# if( !column_exists( 'biblio', 'biblionumber' ) ) {
	11	# warn "There is something wrong";
	12	# }
	13
	14	# Always end with this (adjust the bug info)
	15	SetVersion( $DBversion );
	16	print "Upgrade to $DBversion done (Bug 20936 - Add OPACHoldsHistory preferences)\n";
	17	}