@@ -, +, @@ --- .../data/mysql/atomicupdate/bug-20936.perl | 17 +++++++++++++++++ installer/data/mysql/sysprefs.sql | 1 + .../prog/en/modules/admin/preferences/opac.pref | 6 ++++++ 3 files changed, 24 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug-20936.perl --- a/installer/data/mysql/atomicupdate/bug-20936.perl +++ a/installer/data/mysql/atomicupdate/bug-20936.perl @@ -0,0 +1,17 @@ +$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"; +} --- a/installer/data/mysql/sysprefs.sql +++ a/installer/data/mysql/sysprefs.sql @@ -386,6 +386,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('OpacHiddenItemsExceptions','',NULL,'List of borrower categories, separated by |, that can see items otherwise hidden by OpacHiddenItems','Textarea'), ('OpacHighlightedWords','1','','If Set, then queried words are higlighted in OPAC','YesNo'), ('OPACHoldingsDefaultSortField','first_column','first_column|homebranch|holdingbranch','Default sort field for the holdings table at the OPAC','choice'), +('OPACHoldsHistory','1','','If ON, enables display of Patron Holds History in OPAC','YesNo'), ('OPACHoldsIfAvailableAtPickup','1','','Allow to pickup up holds at libraries where the item is available','YesNo'), ('OPACHoldsIfAvailableAtPickupExceptions','','','List the patron categories not affected by OPACHoldsIfAvailableAtPickup if off','Free'), ('OpacHoldNotes','0','','Show hold notes on OPAC','YesNo'), --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref @@ -708,6 +708,12 @@ OPAC: yes: Allow no: "Don't allow" - patrons to see what books they have checked out in the past. + - + - pref: OPACHoldsHistory + choices: + yes: Allow + no: "Don't allow" + - patrons to see what books they have place holds in the past. - - pref: EnableOpacSearchHistory default: 0 --