From: Ivan Kohler <ivan@freeside.biz>
Date: Tue, 3 Feb 2015 06:10:44 +0000 (-0800)
Subject: fix prospect contact search
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=475ae93877f1d834941f7b9adcc35ee84c5c22fa

fix prospect contact search
---

diff --git a/httemplate/search/contact.html b/httemplate/search/contact.html
index 193349369..650307824 100644
--- a/httemplate/search/contact.html
+++ b/httemplate/search/contact.html
@@ -34,18 +34,19 @@ if ( $cgi->param('selfservice_access') eq 'Y' ) {
 my $extra_sql = '';
 if ( $cgi->param('link') ) {
 
-  my $coalesce = ', COALESCE( cust_main.company,';
   my $as       = ') AS prospect_or_customer';
 
   if ( $cgi->param('link') eq 'cust_main' ) {
     push @header, 'Customer';
-    $select .= "$coalesce cust_main.first||' '||cust_main.last $as";
+    $select .=
+      ", COALESCE( cust_main.company, cust_main.first||' '||cust_main.last $as";
     $addl_from = ' LEFT JOIN cust_main USING ( custnum )';
     $extra_sql = ' custnum IS NOT NULL ';
     $company_link  = [ $p.'view/cust_main.cgi?', 'custnum' ];
   } elsif ( $cgi->param('link') eq 'prospect_main' ) {
     push @header, 'Prospect';
-    $select .= "$coalesce contact.first||'  '||contact.last $as";
+    $select .=
+     ", COALESCE( prospect_main.company, contact.first||'  '||contact.last $as";
     $addl_from = ' LEFT JOIN prospect_main USING ( prospectnum )';
     $extra_sql = ' prospectnum IS NOT NULL ';
     $company_link  = [ $p.'view/prospect_main.html?', 'prospectnum' ];