From e0a759bb54e95c8b3502b33c3ac691e58de0641b Mon Sep 17 00:00:00 2001 From: Ivan Kohler Date: Thu, 27 Apr 2017 11:47:04 -0700 Subject: [PATCH] don't allow three character substring searches, RT#75012 --- FS/FS/cust_main/Search.pm | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) 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 }, -- 2.11.0