From: Ivan Kohler Date: Thu, 27 Apr 2017 18:47:04 +0000 (-0700) Subject: don't allow three character substring searches, RT#75012 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=e0a759bb54e95c8b3502b33c3ac691e58de0641b don't allow three character substring searches, RT#75012 --- diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index ef106b560..5c21a8e12 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -359,7 +359,7 @@ sub smart_search { #substring my @company_hashrefs = (); - if ( length($value) >= 3 ) { + if ( length($value) >= 4 ) { @company_hashrefs = ( { 'company' => { op=>'ILIKE', value=>"%$value%" }, }, { 'ship_company' => { op=>'ILIKE', value=>"%$value%" }, }, @@ -375,7 +375,7 @@ sub smart_search { }, ); - } elsif ( length($value) >= 3 ) { + } elsif ( length($value) >= 4 ) { @hashrefs = ( { 'first' => { op=>'ILIKE', value=>"%$value%" }, }, @@ -396,7 +396,7 @@ sub smart_search { } - if ( $conf->exists('address1-search') && length($value) >= 3 ) { + if ( $conf->exists('address1-search') && length($value) >= 4 ) { push @cust_main, qsearch( { table => 'cust_main', @@ -444,7 +444,8 @@ sub smart_search { 'contact.first' => $first }, # %fuzopts ); - } + } + foreach my $field ( 'first', 'last', 'company', 'ship_company' ) { push @cust_main, FS::cust_main::Search->fuzzy_search( { $field => $value },