'Converted' OR status IS NULL) AND ";
//Use the first and last name from the $_POST to filter. If only last name supplied use that
if(isset($_POST[$prefix.'first_name']) && strlen($_POST[$prefix.'first_name']) != 0 && isset($_POST[$prefix.'last_name']) && strlen($_POST[$prefix.'last_name']) != 0) {
$query .= " (first_name='". $_POST[$prefix.'first_name'] . "' AND last_name = '". $_POST[$prefix.'last_name'] ."')";
} else {
$query .= " last_name = '". $_POST[$prefix.'last_name'] ."'";
}
return $query;
}
function getWideFormBody($prefix, $mod='', $formname=''){
if(!ACLController::checkAccess('Leads', 'edit', true)){
return '';
}
global $mod_strings;
$temp_strings = $mod_strings;
if(!empty($mod)){
global $current_language;
$mod_strings = return_module_language($current_language, $mod);
}
global $app_strings;
global $current_user;
global $app_list_strings;
$primary_address_country_options = get_select_options_with_id($app_list_strings['countries_dom'], '');
$lbl_required_symbol = $app_strings['LBL_REQUIRED_SYMBOL'];
$lbl_first_name = $mod_strings['LBL_FIRST_NAME'];
$lbl_last_name = $mod_strings['LBL_LAST_NAME'];
$lbl_phone = $mod_strings['LBL_OFFICE_PHONE'];
$lbl_address = $mod_strings['LBL_PRIMARY_ADDRESS'];
$user_id = $current_user->id;
$lbl_email_address = $mod_strings['LBL_EMAIL_ADDRESS'];
$form = <<
EOQ;
$javascript = new javascript();
$javascript->setFormName($formname);
$javascript->setSugarBean(new Lead());
$javascript->addField('email1','false',$prefix);
$javascript->addField('email2','false',$prefix);
$javascript->addRequiredFields($prefix);
$form .=$javascript->getScript();
$mod_strings = $temp_strings;
return $form;
}
function getFormBody($prefix, $mod='', $formname=''){
if(!ACLController::checkAccess('Leads', 'edit', true)){
return '';
}
global $mod_strings;
$temp_strings = $mod_strings;
if(!empty($mod)){
global $current_language;
$mod_strings = return_module_language($current_language, $mod);
}
global $app_strings;
global $current_user;
$lbl_required_symbol = $app_strings['LBL_REQUIRED_SYMBOL'];
$lbl_first_name = $mod_strings['LBL_FIRST_NAME'];
$lbl_last_name = $mod_strings['LBL_LAST_NAME'];
$lbl_phone = $mod_strings['LBL_PHONE'];
$user_id = $current_user->id;
$lbl_email_address = $mod_strings['LBL_EMAIL_ADDRESS'];
$form = <<
$lbl_first_name
$lbl_last_name $lbl_required_symbol
$lbl_phone
$lbl_email_address
EOQ;
$javascript = new javascript();
$javascript->setFormName($formname);
$javascript->setSugarBean(new Lead());
$javascript->addField('email1','false',$prefix);
$javascript->addField('email2','false',$prefix);
$javascript->addRequiredFields($prefix);
$form .=$javascript->getScript();
$mod_strings = $temp_strings;
return $form;
}
function getForm($prefix, $mod='Leads'){
if(!ACLController::checkAccess('Leads', 'edit', true)){
return '';
}
if(!empty($mod)){
global $current_language;
$mod_strings = return_module_language($current_language, $mod);
}else global $mod_strings;
global $app_strings;
$lbl_save_button_title = $app_strings['LBL_SAVE_BUTTON_TITLE'];
$lbl_save_button_key = $app_strings['LBL_SAVE_BUTTON_KEY'];
$lbl_save_button_label = $app_strings['LBL_SAVE_BUTTON_LABEL'];
$the_form = get_left_form_header($mod_strings['LBL_NEW_FORM_TITLE']);
$the_form .= <<
EOQ;
$the_form .= $this->getFormBody($prefix, $mod, "${prefix}LeadSave");
$the_form .= <<
EOQ;
$the_form .= get_left_form_footer();
$the_form .= get_validate_record_js();
return $the_form;
}
function handleSave($prefix,$redirect=true, $useRequired=false, $do_save=true, $exist_lead=null){
require_once('modules/Campaigns/utils.php');
require_once('include/formbase.php');
if(empty($exist_lead)) {
$focus = new Lead();
}
else {
$focus = $exist_lead;
}
if($useRequired && !checkRequired($prefix, array_keys($focus->required_fields))){
return null;
}
$focus = populateFromPost($prefix, $focus);
if(!$focus->ACLAccess('Save')){
ACLController::displayNoAccess(true);
sugar_cleanup(true);
}
//Check for duplicate Leads
if (empty($_POST['record']) && empty($_POST['dup_checked']))
{
$duplicateLeads = $this->checkForDuplicates($prefix);
if(isset($duplicateLeads))
{
//Set the redirect location to call the ShowDuplicates action. This will map to view.showduplicates.php
$location='module=Leads&action=ShowDuplicates';
$get = '';
if(isset($_POST['inbound_email_id']) && !empty($_POST['inbound_email_id'])) {
$get .= '&inbound_email_id='.$_POST['inbound_email_id'];
}
if(isset($_POST['relate_to']) && !empty($_POST['relate_to'])) {
$get .= '&Leadsrelate_to='.$_POST['relate_to'];
}
if(isset($_POST['relate_id']) && !empty($_POST['relate_id'])) {
$get .= '&Leadsrelate_id='.$_POST['relate_id'];
}
//add all of the post fields to redirect get string
foreach ($focus->column_fields as $field)
{
if (!empty($focus->$field) && !is_object($focus->$field))
{
$get .= "&Leads$field=".urlencode($focus->$field);
}
}
foreach ($focus->additional_column_fields as $field)
{
if (!empty($focus->$field))
{
$get .= "&Leads$field=".urlencode($focus->$field);
}
}
if($focus->hasCustomFields()) {
foreach($focus->field_defs as $name=>$field) {
if (!empty($field['source']) && $field['source'] == 'custom_fields')
{
$get .= "&Leads$name=".urlencode($focus->$name);
}
}
}
$emailAddress = new SugarEmailAddress();
$get .= $emailAddress->getFormBaseURL($focus);
//create list of suspected duplicate lead ids in redirect get string
$i=0;
foreach ($duplicateLeads as $lead)
{
$get .= "&duplicate[$i]=".$lead['id'];
$i++;
}
//add return_module, return_action, and return_id to redirect get string
$get .= "&return_module=";
if(!empty($_POST['return_module']))
{
$get .= $_POST['return_module'];
} else {
$get .= "Leads";
}
$get .= "&return_action=";
if(!empty($_POST['return_action'])) $get .= $_POST['return_action'];
if(!empty($_POST['return_id'])) $get .= "&return_id=".$_POST['return_id'];
if(!empty($_POST['popup'])) $get .= '&popup='.$_POST['popup'];
if(!empty($_POST['create'])) $get .= '&create='.$_POST['create'];
// for InboundEmail flow
if(!empty($_POST['start'])) $get .= '&start='.$_POST['start'];
$_SESSION['SHOW_DUPLICATES'] = $get;
if (!empty($_POST['is_ajax_call']) && $_POST['is_ajax_call'] == '1')
{
ob_clean();
$json = getJSONobj();
echo $json->encode(array('status' => 'dupe', 'get' => $location));
} else if(!empty($_REQUEST['ajax_load'])) {
echo "";
} else {
if(!empty($_POST['to_pdf']))
{
$location .= '&to_pdf='.$_POST['to_pdf'];
}
header("Location: index.php?$location");
}
return null;
}
}
if (!isset($_POST[$prefix.'email_opt_out'])) $focus->email_opt_out = 0;
if (!isset($_POST[$prefix.'do_not_call'])) $focus->do_not_call = 0;
if($do_save) {
if(!empty($GLOBALS['check_notify'])) {
$focus->save($GLOBALS['check_notify']);
}
else {
$focus->save(FALSE);
}
}
$return_id = $focus->id;
if (isset($_POST[$prefix.'prospect_id']) && !empty($_POST[$prefix.'prospect_id'])) {
$prospect=new Prospect();
$prospect->retrieve($_POST[$prefix.'prospect_id']);
$prospect->lead_id=$focus->id;
// Set to keep email in target
$prospect->in_workflow = true;
$prospect->save();
//if prospect id exists, make sure we are coming from prospect detail
if(strtolower($_POST['return_module']) =='prospects' && strtolower($_POST['return_action']) == 'detailview'){
//create campaing_log entry
if(isset($focus->campaign_id) && $focus->campaign_id != null){
campaign_log_lead_entry($focus->campaign_id,$prospect, $focus,'lead');
}
}
}
///////////////////////////////////////////////////////////////////////////////
//// INBOUND EMAIL HANDLING
///////////////////////////////////////////////////////////////////////////////
if(isset($_REQUEST['inbound_email_id']) && !empty($_REQUEST['inbound_email_id'])) {
if(!isset($current_user)) {
global $current_user;
}
// fake this case like it's already saved.
$email = new Email();
$email->retrieve($_REQUEST['inbound_email_id']);
$email->parent_type = 'Leads';
$email->parent_id = $focus->id;
$email->assigned_user_id = $current_user->id;
$email->status = 'read';
$email->save();
$email->load_relationship('leads');
$email->leads->add($focus->id);
header("Location: index.php?&module=Emails&action=EditView&type=out&inbound_email_id=".$_REQUEST['inbound_email_id']."&parent_id=".$email->parent_id."&parent_type=".$email->parent_type.'&start='.$_REQUEST['start']);
exit();
}
//// END INBOUND EMAIL HANDLING
///////////////////////////////////////////////////////////////////////////////
$GLOBALS['log']->debug("Saved record with id of ".$return_id);
if($redirect){
handleRedirect($return_id, 'Leads');
}else{
return $focus;
}
}
}
?>