From: Christopher Burger Date: Tue, 26 Sep 2017 17:43:31 +0000 (-0400) Subject: RT# 77532 - fixed search to use phone type from database X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=482bcebb8d76081175201e444232b1408ea88e77 RT# 77532 - fixed search to use phone type from database --- diff --git a/httemplate/search/contact.html b/httemplate/search/contact.html index 1f7385866..2121527a5 100644 --- a/httemplate/search/contact.html +++ b/httemplate/search/contact.html @@ -46,22 +46,25 @@ my $DEBUG = 0; my $work_phone_sub = sub { my $contact = shift; + my $phone_type = qsearchs('phone_type', { 'typename' => 'Work' }); #can't because contactnum is in the wrong field - my @contact_workphone = qsearch('contact_phone', { 'contactnum' => $contact->contact_contactnum, 'phonetypenum' => '1' } ); + my @contact_workphone = qsearch('contact_phone', { 'contactnum' => $contact->contact_contactnum, 'phonetypenum' => $phone_type->phonetypenum } ); join(', ', map $_->phonenum, @contact_workphone); }; my $mobile_phone_sub = sub { my $contact = shift; + my $phone_type = qsearchs('phone_type', { 'typename' => 'Mobile' }); #can't because contactnum is in the wrong field - my @contact_mobilephone = qsearch('contact_phone', { 'contactnum' => $contact->contact_contactnum, 'phonetypenum' => '3' } ); + my @contact_mobilephone = qsearch('contact_phone', { 'contactnum' => $contact->contact_contactnum, 'phonetypenum' => $phone_type->phonetypenum } ); join(', ', map $_->phonenum, @contact_mobilephone); }; my $home_phone_sub = sub { my $contact = shift; + my $phone_type = qsearchs('phone_type', { 'typename' => 'Home' }); #can't because contactnum is in the wrong field - my @contact_homephone = qsearch('contact_phone', { 'contactnum' => $contact->contact_contactnum, 'phonetypenum' => '2' } ); + my @contact_homephone = qsearch('contact_phone', { 'contactnum' => $contact->contact_contactnum, 'phonetypenum' => $phone_type->phonetypenum } ); join(', ', map $_->phonenum, @contact_homephone); };