Attachment #124688 for bug #28831

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




use Modern::Perl;

return {
    bug_number => "28831",
    description => "Add system preferences OPACResultsUnavailableGroupingBy",
    up => sub {
        my ($args) = @_;
        my ($dbh, $out) = @$args{qw(dbh out)};
        $dbh->do(q|
            INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES
                ('OPACResultsUnavailableGroupingBy','branch','branch|substatus','Group OPAC XSLT results by branch or substatus','Choice'),
        |);
    },
}

Lines 458-463 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/mandatory/sysprefs.sql (+1 lines)
458	('OpacResetPassword','0','','Shows the ''Forgot your password?'' link in the OPAC','YesNo'),	458	('OpacResetPassword','0','','Shows the ''Forgot your password?'' link in the OPAC','YesNo'),
459	('OPACResultsLibrary', 'homebranch', 'homebranch\|holdingbranch', 'Defines whether the OPAC displays the holding or home branch in search results when using XSLT', 'Choice'),	459	('OPACResultsLibrary', 'homebranch', 'homebranch\|holdingbranch', 'Defines whether the OPAC displays the holding or home branch in search results when using XSLT', 'Choice'),
460	('OPACResultsSidebar','','70\|10','Define HTML to be included on the search results page, underneath the facets sidebar','Textarea'),	460	('OPACResultsSidebar','','70\|10','Define HTML to be included on the search results page, underneath the facets sidebar','Textarea'),
		461	('OPACResultsUnavailableGroupingBy','branch','branch\|substatus','Group OPAC XSLT results by branch or substatus','Choice'),
461	('OPACSearchForTitleIn','<a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a>\n<a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a>\n<a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&title={TITLE}&st=xl&ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a>\n<a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a>','70\|10','Enter the HTML that will appear in the \'Search for this title in\' box on the detail page in the OPAC. Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable \'More Searches\' menu.','Textarea'),	462	('OPACSearchForTitleIn','<a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a>\n<a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a>\n<a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&title={TITLE}&st=xl&ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a>\n<a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a>','70\|10','Enter the HTML that will appear in the \'Search for this title in\' box on the detail page in the OPAC. Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable \'More Searches\' menu.','Textarea'),
462	('OpacSeparateHoldings','0',NULL,'Separate current branch holdings from other holdings (OPAC)','YesNo'),	463	('OpacSeparateHoldings','0',NULL,'Separate current branch holdings from other holdings (OPAC)','YesNo'),
463	('OpacSeparateHoldingsBranch','homebranch','homebranch\|holdingbranch','Branch used to separate holdings (OPAC)','Choice'),	464	('OpacSeparateHoldingsBranch','homebranch','homebranch\|holdingbranch','Branch used to separate holdings (OPAC)','Choice'),

Lines 348-354 OPAC: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/opac.pref (-2 / +7 lines)
348	- pref: OPACResultsMaxItems	348	- pref: OPACResultsMaxItems
349	- (available) individual items on the OPAC XSLT search results, and show no more than	349	- (available) individual items on the OPAC XSLT search results, and show no more than
350	- pref: OPACResultsMaxItemsUnavailable	350	- pref: OPACResultsMaxItemsUnavailable
351	- "'really unavailable' individual items in categories like Checked out, Damaged, On Hold, etc."	351	- "(unavailable) individual items for categories like Checked out, Damaged, On Hold, but only when you group them by branch.<br>"
		352	- Group unavailable items by
		353	- pref: OPACResultsUnavailableGroupingBy
		354	choices:
		355	branch: "branch"
		356	substatus: "substatus"
		357	- ". (NOTE: For large consortia we recommend to group unavailable items by substatus, listing item counts only.)"
352		358
353	Features:	359	Features:
354	-	360	-
355	-

Return to bug 28831

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_28831.pl (+14 lines)
	1	use Modern::Perl;
	2
	3	return {
	4	bug_number => "28831",
	5	description => "Add system preferences OPACResultsUnavailableGroupingBy",
	6	up => sub {
	7	my ($args) = @_;
	8	my ($dbh, $out) = @$args{qw(dbh out)};
	9	$dbh->do(q\|
	10	INSERT IGNORE INTO systempreferences (variable, value, options, explanation, type) VALUES
	11	('OPACResultsUnavailableGroupingBy','branch','branch\|substatus','Group OPAC XSLT results by branch or substatus','Choice'),
	12	\|);
	13	},
	14	}