Attachment #35335 for bug #13528

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

Lines 1569-1574 sub buildQuery { Link Here

(-)a/C4/Search.pm (+7 lines)
1569	$remove_stopwords	1569	$remove_stopwords
1570	) = ( 0, 0, 0, 0, 0 );	1570	) = ( 0, 0, 0, 0, 0 );
1571		1571
		1572	if ( $index eq 'nb' ) {
		1573	if ( C4::Context->preference("SearchWithISBNVariations") ) {
		1574	my @isbns = C4::Koha::GetVariationsOfISBN( $operand );
		1575	$operands[$i] = $operand = '(nb=' . join(' OR nb=', @isbns) . ')';
		1576	$indexes[$i] = $index = '';
		1577	}
		1578	}
1572	}	1579	}
1573		1580
1574	if(not $index){	1581	if(not $index){

Lines 367-372 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here

(-)a/installer/data/mysql/sysprefs.sql (+1 lines)
367	('SCOUserCSS','',NULL,'Add CSS to be included in the SCO module in an embedded <style> tag.','free'),	367	('SCOUserCSS','',NULL,'Add CSS to be included in the SCO module in an embedded <style> tag.','free'),
368	('SCOUserJS','',NULL,'Define custom javascript for inclusion in the SCO module','free'),	368	('SCOUserJS','',NULL,'Define custom javascript for inclusion in the SCO module','free'),
369	('SearchMyLibraryFirst','0',NULL,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'),	369	('SearchMyLibraryFirst','0',NULL,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in','YesNo'),
		370	('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo'),
370	('SelfCheckHelpMessage','','70\|10','Enter HTML to include under the basic Web-based Self Checkout instructions on the Help page','Textarea'),	371	('SelfCheckHelpMessage','','70\|10','Enter HTML to include under the basic Web-based Self Checkout instructions on the Help page','Textarea'),
371	('SelfCheckReceiptPrompt','1','NULL','If ON, print receipt dialog pops up when self checkout is finished','YesNo'),	372	('SelfCheckReceiptPrompt','1','NULL','If ON, print receipt dialog pops up when self checkout is finished','YesNo'),
372	('SelfCheckTimeout','120','','Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),	373	('SelfCheckTimeout','120','','Define the number of seconds before the Web-based Self Checkout times out a patron','Integer'),




    SetVersion ($DBversion);
}

$DBversion = "3.19.00.XXX";
if ( CheckVersion($DBversion) ) {
    $dbh->do(q|
        INSERT INTO systempreferences ( variable, value, options, explanation, type ) VALUES
        ('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo')
    |);
    print "Upgrade to $DBversion done (Bug 13528 - Add the SearchWithISBNVariations syspref)\n";
    SetVersion ($DBversion);
}

=head1 FUNCTIONS

=head2 TableExists($table)

Lines 214-216 Searching: Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/searching.pref (-1 / +7 lines)
214	- Use the following text as separator for UNIMARC authors facets	214	- Use the following text as separator for UNIMARC authors facets
215	- pref: UNIMARCAuthorsFacetsSeparator	215	- pref: UNIMARCAuthorsFacetsSeparator
216	class: short	216	class: short
217	-	217	-
		218	- When searching on the ISBN index,
		219	- pref: SearchWithISBNVariations
		220	choices:
		221	yes: "search"
		222	no: "don't search"
		223	- on all variations of the ISBN. Note that this preference has no effect if UseQueryParser is on.

Return to bug 13528

Lines 9669-9674 if ( CheckVersion($DBversion) ) { Link Here

(-)a/installer/data/mysql/updatedatabase.pl (+10 lines)
9669	SetVersion ($DBversion);	9669	SetVersion ($DBversion);
9670	}	9670	}
9671		9671
		9672	$DBversion = "3.19.00.XXX";
		9673	if ( CheckVersion($DBversion) ) {
		9674	$dbh->do(q\|
		9675	INSERT INTO systempreferences ( variable, value, options, explanation, type ) VALUES
		9676	('SearchWithISBNVariations','0',NULL,'If enabled, search on all variations of the ISBN','YesNo')
		9677	\|);
		9678	print "Upgrade to $DBversion done (Bug 13528 - Add the SearchWithISBNVariations syspref)\n";
		9679	SetVersion ($DBversion);
		9680	}
		9681
9672	=head1 FUNCTIONS	9682	=head1 FUNCTIONS
9673		9683
9674	=head2 TableExists($table)	9684	=head2 TableExists($table)