From f379188e8ba1388c4735de69defd794c3d96bcf6 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 17 Jan 2010 02:34:32 +0000 Subject: [PATCH] strip non-digits and 1- when searching for phone numbers, RT#7000 --- FS/FS/svc_phone.pm | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/FS/FS/svc_phone.pm b/FS/FS/svc_phone.pm index 11a5a0ee0..88582d393 100644 --- a/FS/FS/svc_phone.pm +++ b/FS/FS/svc_phone.pm @@ -120,6 +120,22 @@ Class method which returns an SQL fragment to search for the given string. sub search_sql { my( $class, $string ) = @_; + + if ( $conf->exists('svc_phone-allow_alpha_phonenum') ) { + $string =~ s/\W//g; + } else { + $string =~ s/\D//g; + } + + my $conf = new FS::Conf; + my $ccode = ( $conf->exists('default_phone_countrycode') + && $conf->config('default_phone_countrycode') + ) + ? $conf->config('default_phone_countrycode') + : '1'; + + $string =~ s/^$ccode//; + $class->search_sql_field('phonenum', $string ); } -- 2.11.0