modules/Campaigns/GenerateWebToLeadForm.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM Community Edition is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   6  *
   7  * This program is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU Affero General Public License version 3 as published by the
   9  * Free Software Foundation with the addition of the following permission added
  10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13  *
  14  * This program is distributed in the hope that it will be useful, but WITHOUT
  15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  17  * details.
  18  *
  19  * You should have received a copy of the GNU Affero General Public License along with
  20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22  * 02110-1301 USA.
  23  *
  24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26  *
  27  * The interactive user interfaces in modified source and object code versions
  28  * of this program must display Appropriate Legal Notices, as required under
  29  * Section 5 of the GNU Affero General Public License version 3.
  30  *
  31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  32  * these Appropriate Legal Notices must retain the display of the "Powered by
  33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34  * technical reasons, the Appropriate Legal Notices must display the words
  35  * "Powered by SugarCRM".
  36  ********************************************************************************/
  37
  38 /*********************************************************************************
  39
  40  * Description:  TODO: To be written.
  41  * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc.
  42  * All Rights Reserved.
  43  * Contributor(s): ______________________________________..
  44  ********************************************************************************/
  45 require_once('include/formbase.php');
  46
  47
  48
  49
  50 require_once('include/utils/db_utils.php');
  51
  52
  53
  54
  55 global $app_list_strings, $app_strings,$mod_strings;
  56
  57 $site_url = $sugar_config['site_url'];
  58 $web_form_header = $mod_strings['LBL_LEAD_DEFAULT_HEADER'];
  59 $web_form_description = $mod_strings['LBL_DESCRIPTION_TEXT_LEAD_FORM'];
  60 $web_form_submit_label = $mod_strings['LBL_DEFAULT_LEAD_SUBMIT'];
  61 $web_form_required_fileds_msg = $mod_strings['LBL_PROVIDE_WEB_TO_LEAD_FORM_FIELDS'];
  62 $web_required_symbol = $app_strings['LBL_REQUIRED_SYMBOL'];
  63 $web_not_valid_email_address = $mod_strings['LBL_NOT_VALID_EMAIL_ADDRESS'];
  64 $web_post_url = $site_url.'/index.php?entryPoint=WebToLeadCapture';
  65 $web_redirect_url = '';
  66 $web_notify_campaign = '';
  67 $web_assigned_user = '';
  68 $web_team_user = '';
  69 $web_form_footer = '';
  70 $regex = "/^\w+(['\.\-\+]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,})+\$/";
  71 //_ppd($web_required_symbol);
  72 if(!empty($_REQUEST['web_header'])){
  73     $web_form_header= $_REQUEST['web_header'];
  74 }
  75 if(!empty($_REQUEST['web_description'])){
  76     $web_form_description= $_REQUEST['web_description'];
  77 }
  78 if(!empty($_REQUEST['web_submit'])){
  79     $web_form_submit_label=to_html($_REQUEST['web_submit']);
  80 }
  81 if(!empty($_REQUEST['post_url'])){
  82     $web_post_url= $_REQUEST['post_url'];
  83 }
  84 if(!empty($_REQUEST['redirect_url']) && $_REQUEST['redirect_url'] !="http://"){
  85     $web_redirect_url= $_REQUEST['redirect_url'];
  86 }
  87 if(!empty($_REQUEST['notify_campaign'])){
  88     $web_notify_campaign = $_REQUEST['notify_campaign'];
  89 }
  90 if(!empty($_REQUEST['web_footer'])){
  91     $web_form_footer= $_REQUEST['web_footer'];
  92 }
  93 if(!empty($_REQUEST['campaign_id'])){
  94     $web_form_campaign= $_REQUEST['campaign_id'];
  95 }
  96 if(!empty($_REQUEST['assigned_user_id'])){
  97     $web_assigned_user = $_REQUEST['assigned_user_id'];
  98 }
  99
 100
 101  $lead = new Lead();
 102  $fieldsMetaData = new FieldsMetaData();
 103  $xtpl=new XTemplate ('modules/Campaigns/WebToLeadForm.html');
 104  $xtpl->assign("MOD", $mod_strings);
 105  $xtpl->assign("APP", $app_strings);
 106  $Web_To_Lead_Form_html = '';
 107  $Web_To_Lead_Form_html .='<link rel="stylesheet" type="text/css" media="all" href="' . getJSPath(SugarThemeRegistry::current()->getCSSURL('calendar-win2k-cold-1.css')) . '">';
 108  $Web_To_Lead_Form_html .= "<script type=\"text/javascript\" src='" . getJSPath($site_url.'/include/javascript/sugar_grp1.js') . "'></script>";
 109  $Web_To_Lead_Form_html .= '<script type="text/javascript" src="' . getJSPath($site_url.'/include/javascript/calendar.js') . '"></script>';
 110  $Web_To_Lead_Form_html .="<form action='$web_post_url' name='WebToLeadForm' method='POST' id='WebToLeadForm'>";
 111  $Web_To_Lead_Form_html .= "<table width='100%' style='border-top: 1px solid;
 112 border-bottom: 1px solid;
 113 padding: 10px 6px 12px 10px;
 114 background-color: rgb(233, 243, 255);
 115 font-size: 12px;
 116 background-repeat: repeat-x;
 117 background-position: center top;'>";
 118
 119 $Web_To_Lead_Form_html .= "<tr align='center' style='color: rgb(0, 105, 225); font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 18px; font-weight: bold; margin-bottom: 0px; margin-top: 0px;'><TD COLSPAN='4'><b><h2>$web_form_header</h2></b></TD></tr>";
 120 $Web_To_Lead_Form_html .= "<tr align='center' style='color: rgb(0, 105, 225); font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 2px; font-weight: normal; margin-bottom: 0px; margin-top: 0px;'><TD COLSPAN='4'>&nbsp</TD></tr>";
 121 $Web_To_Lead_Form_html .= "<tr align='left' style='color: rgb(0, 105, 225); font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 12px; font-weight: normal; margin-bottom: 0px; margin-top: 0px;'><TD COLSPAN='4'>$web_form_description</TD></tr>";
 122 $Web_To_Lead_Form_html .= "<tr align='center' style='color: rgb(0, 105, 225); font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 8px; font-weight: normal; margin-bottom: 0px; margin-top: 0px;'><TD COLSPAN='4'>&nbsp</TD></tr>";
 123
 124  //$Web_To_Lead_Form_html .= "\n<p>\n";
 125
 126 if(!empty($_REQUEST['colsFirst']) && !empty($_REQUEST['colsSecond'])){
 127  if(count($_REQUEST['colsFirst']) < count($_REQUEST['colsSecond'])){
 128    $columns= count($_REQUEST['colsSecond']);
 129  }
 130  if(count($_REQUEST['colsFirst']) > count($_REQUEST['colsSecond']) || count($_REQUEST['colsFirst']) == count($_REQUEST['colsSecond'])){
 131    $columns= count($_REQUEST['colsFirst']);
 132  }
 133 }
 134 else if(!empty($_REQUEST['colsFirst'])){
 135  $columns= count($_REQUEST['colsFirst']);
 136 }
 137 else if(!empty($_REQUEST['colsSecond'])){
 138  $columns= count($_REQUEST['colsSecond']);
 139 }
 140
 141
 142 $required_fields = array();
 143 $bool_fields = array();
 144 for($i= 0; $i<$columns;$i++){
 145     $colsFirstField = '';
 146     $colsSecondField = '';
 147
 148     if(!empty($_REQUEST['colsFirst'][$i])){
 149         $colsFirstField = $_REQUEST['colsFirst'][$i];
 150         //_pp($_REQUEST['colsFirst']);
 151      }
 152     if(!empty($_REQUEST['colsSecond'][$i])){
 153         $colsSecondField = $_REQUEST['colsSecond'][$i];
 154         //_pp($_REQUEST['colsSecond']);
 155      }
 156
 157     if(isset($lead->field_defs[$colsFirstField]) && $lead->field_defs[$colsFirstField] != null)
 158     {
 159          $field_vname = preg_replace('/:$/','',translate($lead->field_defs[$colsFirstField]['vname'],'Leads'));
 160          $field_name  = $colsFirstField;
 161          $field_label = $field_vname .": ";
 162          if(isset($lead->field_defs[$colsFirstField]['custom_type']) && $lead->field_defs[$colsFirstField]['custom_type'] != null){
 163             $field_type= $lead->field_defs[$colsFirstField]['custom_type'];
 164          }
 165          else{
 166             $field_type= $lead->field_defs[$colsFirstField]['type'];
 167          }
 168          $field_required = '';
 169          if(isset($lead->field_defs[$colsFirstField]['required']) && $lead->field_defs[$colsFirstField]['required'] != null
 170              && $lead->field_defs[$colsFirstField]['required'] != 0)
 171           {
 172             $field_required = $lead->field_defs[$colsFirstField]['required'];
 173             if (! in_array($lead->field_defs[$colsFirstField]['name'], $required_fields)){
 174               array_push($required_fields,$lead->field_defs[$colsFirstField]['name']);
 175              }
 176           }
 177           if($lead->field_defs[$colsFirstField]['name']=='last_name'){
 178             if (! in_array($lead->field_defs[$colsFirstField]['name'], $required_fields)){
 179               array_push($required_fields,$lead->field_defs[$colsFirstField]['name']);
 180             }
 181           }
 182          if($field_type=='multienum' || $field_type=='enum' || $field_type=='radioenum')  $field_options= $lead->field_defs[$colsFirstField]['options'];
 183     }
 184     //preg_replace('/:$/','',translate($field_def['vname'],'Leads')
 185     if(isset($lead->field_defs[$colsSecondField]) && $lead->field_defs[$colsSecondField] != null)
 186     {
 187          $field1_vname= preg_replace('/:$/','',translate($lead->field_defs[$colsSecondField]['vname'],'Leads'));
 188          $field1_name= $colsSecondField;
 189          $field1_label = $field1_vname .": ";
 190          if(isset($lead->field_defs[$colsSecondField]['custom_type']) && $lead->field_defs[$colsSecondField]['custom_type'] != null){
 191             $field1_type= $lead->field_defs[$colsSecondField]['custom_type'];
 192          }
 193          else{
 194             $field1_type= $lead->field_defs[$colsSecondField]['type'];
 195          }
 196          $field1_required = '';
 197          if(isset($lead->field_defs[$colsSecondField]['required']) && $lead->field_defs[$colsSecondField]['required'] != null
 198              && $lead->field_defs[$colsSecondField]['required'] != 0){
 199           $field1_required = $lead->field_defs[$colsSecondField]['required'];
 200            if (! in_array($lead->field_defs[$colsSecondField]['name'], $required_fields)){
 201               array_push($required_fields,$lead->field_defs[$colsSecondField]['name']);
 202             }
 203          }
 204          if($lead->field_defs[$colsSecondField]['name']=='last_name'){
 205             if (! in_array($lead->field_defs[$colsSecondField]['name'], $required_fields)){
 206               array_push($required_fields,$lead->field_defs[$colsSecondField]['name']);
 207             }
 208          }
 209          if($field1_type=='multienum' || $field1_type=='enum' || $field1_type=='radioenum')  $field1_options= $lead->field_defs[$colsSecondField]['options'];
 210     }
 211
 212      $Web_To_Lead_Form_html .= "<tr>";
 213
 214     if(isset($lead->field_defs[$colsFirstField]) && $lead->field_defs[$colsFirstField] != null){
 215         if($field_type=='multienum' || $field_type=='enum' || $field_type=='radioenum'){
 216           $lead_options = '';
 217           if(!empty($lead->$field_name)){
 218             $lead_options= get_select_options_with_id($app_list_strings[$field_options], unencodeMultienum($lead->$field_name));
 219           }
 220           else{
 221             $lead_options= get_select_options_with_id($app_list_strings[$field_options], '');
 222           }
 223           if($field_required){
 224                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 225             }
 226          else{
 227                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'></td>";
 228              }
 229           if(isset($lead->field_defs[$colsFirstField]['isMultiSelect']) && $lead->field_defs[$colsFirstField]['isMultiSelect'] ==1){
 230             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><select id='{$field_name}' multiple='true' name='{$field_name}' tabindex='1'>$lead_options</select></span sugar='slot'></td>";
 231           }elseif(ifRadioButton($lead->field_defs[$colsFirstField]['name'])){
 232             $Web_To_Lead_Form_html .="<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'>";
 233             foreach($app_list_strings[$field_options] as $field_option_key => $field_option){
 234                 if($field_option != null){
 235                         if(!empty($lead->$field_name) && in_array($field_option_key,unencodeMultienum($lead->$field_name))){
 236                                 $Web_To_Lead_Form_html .="<input id='$colsFirstField"."_$field_option_key' checked name='$colsFirstField' value='$field_option_key' type='radio'>";
 237                         } else{
 238                                 $Web_To_Lead_Form_html .="<input id='$colsFirstField"."_$field_option_key' name='$colsFirstField' value='$field_option_key' type='radio'>";
 239                         }
 240                         $Web_To_Lead_Form_html .="<span ='document.getElementById('".$lead->field_defs[$colsFirstField]."_$field_option_key').checked =true style='cursor:default'; onmousedown='return false;'>$field_option</span><br>";
 241                 }
 242             }
 243             $Web_To_Lead_Form_html .="</span sugar='slot'></td>";
 244           }else{
 245             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><select id=$field_name name=$field_name tabindex='1'>$lead_options</select></span sugar='slot'></td>";
 246           }
 247          }
 248          if($field_type=='bool'){
 249           if($field_required){
 250                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 251           }
 252           else{
 253                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'></td>";
 254           }
 255           $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input type='checkbox' id=$field_name name=$field_name></span sugar='slot'></td>";
 256           if (! in_array($lead->field_defs[$colsFirstField]['name'], $bool_fields)){
 257               array_push($bool_fields,$lead->field_defs[$colsFirstField]['name']);
 258              }
 259          }
 260          if($field_type=='date') {
 261
 262           global $timedate;
 263           $cal_dateformat = $timedate->get_cal_date_format();
 264               $LBL_ENTER_DATE = translate('LBL_ENTER_DATE', 'Charts');
 265           if($field_required){
 266                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 267           }
 268           else{
 269                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'></td>";
 270           }
 271                         $Web_To_Lead_Form_html .= "
 272                                 <td width='35%' style='font-size: 12px; font-weight: normal;'>
 273                                 <script type='text/javascript'>
 274                                         update{$field_name}Value = function() {
 275                                                 var format = '{$cal_dateformat}';
 276                                                 var month = document.getElementById('{$field_name}_month').value;
 277                                                 var day = document.getElementById('{$field_name}_day').value;
 278                                                 var year = document.getElementById('{$field_name}_year').value;
 279                                                 var val = format.replace('%m', month).replace('%d', day).replace('%Y', year);
 280                                                 if (!parseInt(month) > 0 || !parseInt(year) > 0 || !parseInt(year) > 0)
 281                                                         val = '';
 282                                                 document.getElementById('{$field_name}').value = val;
 283                                         }
 284                                 </script>
 285                                 <span sugar='slot'><input type='hidden' id='{$field_name}' name='{$field_name}'/>";
 286                 $order = explode("%", $cal_dateformat);
 287                 foreach($order as $part)
 288                 {
 289                         if (!isset($part[0]))
 290                                 continue;
 291                         if (strToUpper($part[0]) == "M" )
 292                                 $Web_To_Lead_Form_html .= translate("LBL_MONTH") . ":<input class=\"text\"
 293                                         name=\"{$field_name}_month\" size='2' maxlength='2' id='{$field_name}_month' value=''
 294                                         onblur=\"update{$field_name}Value()\">";
 295                                 else if (strToUpper($part[0]) == "D" )
 296                                         $Web_To_Lead_Form_html .=  translate("LBL_DAY") . ":<input class=\"text\"
 297                                         name=\"{$field_name}_day\" size='2' maxlength='2' id='{$field_name}_day' value=''
 298                                         onblur=\"update{$field_name}Value()\">";
 299                                 else if (strToUpper($part[0]) == "Y" )
 300                                         $Web_To_Lead_Form_html .= translate("LBL_YEAR") . ":<input class=\"text\"
 301                                         name=\"{$field_name}_year\" size='4' maxlength='4' id='{$field_name}_year' value=''
 302                                         onblur=\"update{$field_name}Value()\">";
 303                 }
 304                 $Web_To_Lead_Form_html .= "</span></td>";
 305              } // if
 306          if( $field_type=='varchar' ||  $field_type=='name'
 307           ||  $field_type=='phone' || $field_type=='currency' || $field_type=='url' || $field_type=='int'){
 308            if($field_name=='last_name' ||   $field_required){
 309                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 310               }
 311             else{
 312                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'></td>";
 313              }
 314            $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input id=$field_name name=$field_name type='text'></span sugar='slot'></td>";
 315             }
 316           if ( $field_type == 'text' ) {
 317                $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'></td>";
 318                            $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span id='ta_replace' sugar='slot'><input id=$field_name name=$field_name type='text'></span sugar='slot'></td>";
 319            }
 320            if($field_type=='relate' &&  $field_name=='account_name'){
 321                     $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'></td>";
 322                     $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input id=$field_name name=$field_name type='text'></span sugar='slot'></td>";
 323            }
 324           if($field_type=='email'){
 325             if($field_required){
 326                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 327               }
 328            else{
 329                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field_label</span sugar='slot'></td>";
 330              }
 331             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input id=$field_name name=$field_name type='text' onchange='validateEmailAdd();'></span sugar='slot'></td>";
 332            }
 333        }
 334       else{
 335             $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>&nbsp</span sugar='slot'></td>";
 336             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'>&nbsp</span sugar='slot'></td>";
 337         }
 338
 339      if(isset($lead->field_defs[$colsSecondField]) && $lead->field_defs[$colsSecondField] != null){
 340          if($field1_type=='multienum' || $field1_type=='enum' || $field1_type=='radioenum'){
 341           $lead1_options = '';
 342           if(!empty($lead->$field1_name)){
 343             $lead1_options= get_select_options_with_id($app_list_strings[$field1_options], unencodeMultienum($lead->$field1_name));
 344           }
 345           else{
 346             $lead1_options= get_select_options_with_id($app_list_strings[$field1_options], '');
 347           }
 348             if($field1_required){
 349                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 350             }
 351             else{
 352                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'></td>";
 353              }
 354             if(isset($lead->field_defs[$colsSecondField]['isMultiSelect']) && $lead->field_defs[$colsSecondField]['isMultiSelect'] ==1){
 355                 $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><select id='{$field1_name}' name='{$field1_name}' multiple='true' tabindex='1'>$lead1_options</select></span sugar='slot'></td>";
 356             }elseif(ifRadioButton($lead->field_defs[$colsSecondField]['name'])){
 357                 $Web_To_Lead_Form_html .="<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'>";
 358                 foreach($app_list_strings[$field1_options] as $field_option_key => $field_option){
 359                     if($field_option != null){
 360                         if(!empty($lead->$field1_name) && in_array($field_option_key,unencodeMultienum($lead->$field1_name))){
 361                                 $Web_To_Lead_Form_html .="<input id='$colsSecondField"."_$field_option_key' checked name='$colsSecondField' value='$field_option_key' type='radio'>";
 362                         }else{
 363                                 $Web_To_Lead_Form_html .="<input id='$colsSecondField"."_$field_option_key' name='$colsSecondField' value='$field_option_key' type='radio'>";
 364                             }
 365                             $Web_To_Lead_Form_html .="<span ='document.getElementById('".$lead->field_defs[$colsSecondField]."_$field_option_key').checked =true style='cursor:default'; onmousedown='return false;'>$field_option</span><br>";
 366                     }
 367                 }
 368                 $Web_To_Lead_Form_html .="</span sugar='slot'></td>";
 369             }else{
 370                 $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><select id=$field1_name name=$field1_name tabindex='1'>$lead1_options</select></span sugar='slot'></td>";
 371             }
 372          }
 373          if($field1_type=='bool'){
 374           if($field1_required){
 375             $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 376           }
 377           else{
 378             $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'></td>";
 379           }
 380             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input id=$field1_name name=$field1_name type='checkbox'></span sugar='slot'></td>";
 381             if (! in_array($lead->field_defs[$colsSecondField]['name'], $bool_fields)){
 382               array_push($bool_fields,$lead->field_defs[$colsSecondField]['name']);
 383              }
 384          }
 385          if($field1_type=='date') {
 386                 global $timedate;
 387                         $cal_dateformat = $timedate->get_cal_date_format();
 388                 $LBL_ENTER_DATE = translate('LBL_ENTER_DATE', 'Charts');
 389           if($field1_required){
 390                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 391           }
 392           else{
 393                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'></td>";
 394           }
 395                         $Web_To_Lead_Form_html .= "
 396                                 <td width='35%' style='font-size: 12px; font-weight: normal;'>
 397                                 <script type='text/javascript'>
 398                                         update{$field1_name}Value = function() {
 399                                                 var format = '{$cal_dateformat}';
 400                                                 var month = document.getElementById('{$field1_name}_month').value;
 401                                                 var day = document.getElementById('{$field1_name}_day').value;
 402                                                 var year = document.getElementById('{$field1_name}_year').value;
 403                                                 var val = format.replace('%m', month).replace('%d', day).replace('%Y', year);
 404                                                 if (!parseInt(month) > 0 || !parseInt(year) > 0 || !parseInt(year) > 0)
 405                                                         val = '';
 406                                                 document.getElementById('{$field1_name}').value = val;
 407                                         }
 408                                 </script>
 409                                 <span sugar='slot'><input type='hidden' id='{$field1_name}' name='{$field1_name}'/>";
 410                 $order = explode("%", $cal_dateformat);
 411                 foreach($order as $part)
 412                 {
 413                         if (!isset($part[0]))
 414                                 continue;
 415                         if (strToUpper($part[0]) == "M" )
 416                                 $Web_To_Lead_Form_html .= translate("LBL_MONTH") . ":<input class=\"text\"
 417                                         name=\"{$field1_name}_month\" size='2' maxlength='2' id='{$field1_name}_month' value=''
 418                                         onblur=\"update{$field1_name}Value()\">";
 419                                 else if (strToUpper($part[0]) == "D" )
 420                                         $Web_To_Lead_Form_html .=  translate("LBL_DAY") . ":<input class=\"text\"
 421                                         name=\"{$field1_name}_day\" size='2' maxlength='2' id='{$field1_name}_day' value=''
 422                                         onblur=\"update{$field1_name}Value()\">";
 423                                 else if (strToUpper($part[0]) == "Y" )
 424                                         $Web_To_Lead_Form_html .= translate("LBL_YEAR") . ":<input class=\"text\"
 425                                         name=\"{$field1_name}_year\" size='4' maxlength='4' id='{$field1_name}_year' value=''
 426                                         onblur=\"update{$field1_name}Value()\">";
 427                 }
 428                 $Web_To_Lead_Form_html .= "</span></td>";
 429          } // if
 430          if( $field1_type=='varchar' ||  $field1_type=='name'
 431           ||  $field1_type=='phone' || $field1_type=='currency' || $field1_type=='url' || $field1_type=='int'){
 432             if($field1_name=='last_name' ||  $field1_required){
 433                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 434               }
 435             else{
 436                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'></td>";
 437              }
 438             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input id=$field1_name name=$field1_name type='text'></span sugar='slot'></td>";
 439            }
 440            if ( $field1_type == 'text' ) {
 441                $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'></td>";
 442                                 $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span id='ta_replace' sugar='slot'><input id=$field1_name name=$field1_name type='text'></span sugar='slot'></td>";
 443            }
 444            if($field1_type=='relate' &&  $field1_name=='account_name'){
 445                     $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'></td>";
 446                     $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input id=$field1_name name=$field1_name type='text'></span sugar='slot'></td>";
 447            }
 448            if($field1_type=='email'){
 449                 if($field1_required){
 450                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'><span class='required' style='color: rgb(255, 0, 0);'>$web_required_symbol</span></td>";
 451               }
 452             else{
 453                 $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>$field1_label</span sugar='slot'></td>";
 454              }
 455             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'><input id=$field1_name name=$field1_name type='text' onchange='validateEmailAdd();'></span sugar='slot'></td>";
 456            }
 457       }
 458       else{
 459             $Web_To_Lead_Form_html .= "<td width='15%' style='text-align: left; font-size: 12px; font-weight: normal;'><span sugar='slot'>&nbsp</span sugar='slot'></td>";
 460             $Web_To_Lead_Form_html .= "<td width='35%' style='font-size: 12px; font-weight: normal;'><span sugar='slot'>&nbsp</span sugar='slot'></td>";
 461        }
 462        $Web_To_Lead_Form_html .= "</tr>";
 463 }
 464
 465 $Web_To_Lead_Form_html .= "<tr align='center' style='color: rgb(0, 105, 225); font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 18px; font-weight: bold; margin-bottom: 0px; margin-top: 0px;'><TD COLSPAN='4'>&nbsp</TD></tr>";
 466
 467 if(!empty($web_form_footer)){
 468     $Web_To_Lead_Form_html .= "<tr align='center' style='color: rgb(0, 105, 225); font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 18px; font-weight: bold; margin-bottom: 0px; margin-top: 0px;'><TD COLSPAN='4'>&nbsp</TD></tr>";
 469     $Web_To_Lead_Form_html .= "<tr align='left' style='color: rgb(0, 105, 225); font-family: Arial,Verdana,Helvetica,sans-serif; font-size: 12px; font-weight: normal; margin-bottom: 0px; margin-top: 0px;'><TD COLSPAN='4'>$web_form_footer</TD></tr>";
 470 }
 471
 472 $Web_To_Lead_Form_html .= "<tr align='center'><td colspan='10'><input type='button' onclick='submit_form();' class='button' name='Submit' value='$web_form_submit_label'/></td></tr>";
 473
 474 if(!empty($web_form_campaign)){
 475    $Web_To_Lead_Form_html .= "<tr><td style='display: none'><input type='hidden' id='campaign_id' name='campaign_id' value='$web_form_campaign'></td></tr>";
 476 }
 477 if(!empty($web_redirect_url)){
 478     $Web_To_Lead_Form_html .= "<tr><td style='display: none'><input type='hidden' id='redirect_url' name='redirect_url' value='$web_redirect_url'></td></tr>";
 479 }
 480 if(!empty($web_assigned_user)){
 481     $Web_To_Lead_Form_html .= "<tr><td style='display: none'><input type='hidden' id='assigned_user_id' name='assigned_user_id' value='$web_assigned_user'></td></tr>";
 482 }
 483 $req_fields='';
 484 if(isset($required_fields) && $required_fields != null ){
 485     foreach($required_fields as $req){
 486         $req_fields=$req_fields.$req.';';
 487     }
 488 }
 489 $boolean_fields='';
 490 if(isset($bool_fields) && $bool_fields != null ){
 491     foreach($bool_fields as $boo){
 492         $boolean_fields=$boolean_fields.$boo.';';
 493     }
 494 }
 495 if(!empty($req_fields)){
 496     $Web_To_Lead_Form_html .= "<tr><td style='display: none'><input type='hidden' id='req_id' name='req_id' value='$req_fields'></td></tr>";
 497 }
 498 if(!empty($boolean_fields)){
 499     $Web_To_Lead_Form_html .= "<tr><td style='display: none'><input type='hidden' id='bool_id' name='bool_id' value='$boolean_fields'></td></tr>";
 500 }
 501
 502
 503 $Web_To_Lead_Form_html .= "</table >";
 504 $Web_To_Lead_Form_html .="</form>";
 505
 506 $Web_To_Lead_Form_html .="<script type='text/javascript'>
 507  function submit_form(){
 508         if(typeof(validateCaptchaAndSubmit)!='undefined'){
 509                 validateCaptchaAndSubmit();
 510         }else{
 511                 check_webtolead_fields();
 512         }
 513  }
 514  function check_webtolead_fields(){
 515      if(document.getElementById('bool_id') != null){
 516         var reqs=document.getElementById('bool_id').value;
 517         bools = reqs.substring(0,reqs.lastIndexOf(';'));
 518         var bool_fields = new Array();
 519         var bool_fields = bools.split(';');
 520         nbr_fields = bool_fields.length;
 521         for(var i=0;i<nbr_fields;i++){
 522           if(document.getElementById(bool_fields[i]).value == 'on'){
 523              document.getElementById(bool_fields[i]).value = 1;
 524           }
 525           else{
 526              document.getElementById(bool_fields[i]).value = 0;
 527           }
 528         }
 529       }
 530     if(document.getElementById('req_id') != null){
 531         var reqs=document.getElementById('req_id').value;
 532         reqs = reqs.substring(0,reqs.lastIndexOf(';'));
 533         var req_fields = new Array();
 534         var req_fields = reqs.split(';');
 535         nbr_fields = req_fields.length;
 536         var req = true;
 537         for(var i=0;i<nbr_fields;i++){
 538           if(document.getElementById(req_fields[i]).value.length <=0 || document.getElementById(req_fields[i]).value==0){
 539            req = false;
 540            break;
 541           }
 542         }
 543         if(req){
 544             document.WebToLeadForm.submit();
 545             return true;
 546         }
 547         else{
 548           alert('$web_form_required_fileds_msg');
 549           return false;
 550          }
 551         return false
 552    }
 553    else{
 554     document.WebToLeadForm.submit();
 555    }
 556 }
 557 function validateEmailAdd(){
 558         if(document.getElementById('webtolead_email1').value.length >0) {
 559                 if(document.getElementById('webtolead_email1').value.match($regex) == null){
 560                   alert('$web_not_valid_email_address');
 561                 }
 562         }
 563         if(document.getElementById('webtolead_email2').value.length >0) {
 564                 if(document.getElementById('webtolead_email2').value.match($regex) == null){
 565                   alert('$web_not_valid_email_address');
 566                 }
 567         }
 568 }
 569 </script>";
 570
 571 if(isset($Web_To_Lead_Form_html)) $xtpl->assign("BODY", $Web_To_Lead_Form_html); else $xtpl->assign("BODY", "");
 572 if(isset($Web_To_Lead_Form_html)) $xtpl->assign("BODY_HTML", $Web_To_Lead_Form_html); else $xtpl->assign("BODY_HTML", "");
 573
 574
 575 require_once('include/SugarTinyMCE.php');
 576 $tiny = new SugarTinyMCE();
 577 $tiny->defaultConfig['height']=400;
 578 $tiny->defaultConfig['apply_source_formatting']=true;
 579 $tiny->defaultConfig['cleanup']=false;
 580 $ed = $tiny->getInstance('body_html');
 581 $xtpl->assign("tiny", $ed);
 582
 583 $xtpl->parse("main.textarea");
 584
 585 $xtpl->assign("INSERT_VARIABLE_ONCLICK", "insert_variable_html(document.EditView.variable_text.value)");
 586 $xtpl->parse("main.variable_button");
 587
 588
 589
 590
 591 $xtpl->parse("main");
 592 $xtpl->out("main");
 593
 594 function ifRadioButton($customFieldName){
 595     $custRow = null;
 596     $query="select id,type from fields_meta_data where deleted = 0 and name = '$customFieldName'";
 597     $result=$GLOBALS['db']->query($query);
 598     $row = $GLOBALS['db']->fetchByAssoc($result);
 599     if($row != null && $row['type'] == 'radioenum'){
 600         return $custRow = $row;
 601     }
 602     return $custRow;
 603 }
 604
 605 ?>