diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2017-03-06 09:25:12 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2017-04-27 11:48:04 -0700 |
| commit | 2c04f1df05a1b14d9539bbae97275c1d3a0995e2 (patch) | |
| tree | 67594f003acf662a3617d7d00c9efe4eaea69210 | |
| parent | a023312fbe3f64d119852581a295945b11ef4575 (diff) | |
don't allow two character substring searches, RT#75012
| -rw-r--r-- | FS/FS/cust_main/Search.pm | 17 |
1 files changed, 10 insertions, 7 deletions
diff --git a/FS/FS/cust_main/Search.pm b/FS/FS/cust_main/Search.pm index 677a3e5c7..ef106b560 100644 --- a/FS/FS/cust_main/Search.pm +++ b/FS/FS/cust_main/Search.pm @@ -358,13 +358,15 @@ sub smart_search { #substring - my @company_hashrefs = ( - { 'company' => { op=>'ILIKE', value=>"%$value%" }, }, - { 'ship_company' => { op=>'ILIKE', value=>"%$value%" }, }, - ); + my @company_hashrefs = (); + if ( length($value) >= 3 ) { + @company_hashrefs = ( + { 'company' => { op=>'ILIKE', value=>"%$value%" }, }, + { 'ship_company' => { op=>'ILIKE', value=>"%$value%" }, }, + ); + } my @hashrefs = (); - if ( $first && $last ) { @hashrefs = ( @@ -373,12 +375,13 @@ sub smart_search { }, ); - } else { + } elsif ( length($value) >= 3 ) { @hashrefs = ( { 'first' => { op=>'ILIKE', value=>"%$value%" }, }, { 'last' => { op=>'ILIKE', value=>"%$value%" }, }, ); + } foreach my $hashref ( @company_hashrefs, @hashrefs ) { @@ -393,7 +396,7 @@ sub smart_search { } - if ( $conf->exists('address1-search') ) { + if ( $conf->exists('address1-search') && length($value) >= 3 ) { push @cust_main, qsearch( { table => 'cust_main', |