public static function assign_agent($first_name, $last_name, $email, $mobile, $message)
{
$error_message = array();
global $database;
$valid = true;
if (empty($first_name) || empty($last_name) || empty($email) || empty($mobile) || empty($message)) {
$error_message[] = "All field are required";
$valid = false;
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
//validate email
$error_message[] = "Invalid email format";
$valid = false;
}
if ($valid) {
// if all fields are filled and email is valid
$agent_id = self::available_agent();
if (is_null($agent_id)) {
$error_message[] = "No agent are currently available, please try again later";
} else {
$lead = new Leads();
$lead->agent_id = $agent_id;
$lead->first_name = $database->escape_value($first_name);
$lead->last_name = $database->escape_value($last_name);
$lead->email = $database->escape_value($email);
$lead->mobile = $database->escape_value($mobile);
$lead->message = $database->escape_value($message);
$lead->created = strftime("%Y-%m-%d %H:%M:%S", time());
$lead->modified = strftime("%Y-%m-%d %H:%M:%S", time());
if ($lead->save()) {
//saved email both lead and agent
if (self::send_email($lead)) {
//nothing happen
} else {
$error_message[] = "Notification emails are failed to send out. Please contact us ";
}
} else {
$error_message[] = "There was an error that prevented the lead from being saved.";
}
}
}
return $error_message;
}
function AddLead($user_name, $first_name, $last_name, $email_address, $account_name, $salutation, $title, $phone_mobile, $reports_to, $primary_address_street, $website, $primary_address_city, $primary_address_state, $primary_address_postalcode, $primary_address_country, $alt_address_city, $alt_address_street, $alt_address_state, $alt_address_postalcode, $alt_address_country, $office_phone = "", $home_phone = "", $fax = "", $department = "", $password, $description = "")
{
if (authentication($user_name, $password)) {
global $adb;
global $current_user;
require_once 'modules/Users/Users.php';
require_once 'modules/Leads/Leads.php';
$seed_user = new Users();
$user_id = $seed_user->retrieve_user_id($user_name);
$current_user = $seed_user;
$current_user->retrieve_entity_info($user_id, "Users");
checkFileAccessForInclusion('user_privileges/user_privileges_' . $current_user->id . '.php');
require 'user_privileges/user_privileges_' . $current_user->id . '.php';
checkFileAccessForInclusion('user_privileges/sharing_privileges_' . $current_user->id . '.php');
require 'user_privileges/sharing_privileges_' . $current_user->id . '.php';
if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
$sql1 = "select fieldname,columnname from vtiger_field where tabid=7 and block <> 14 and vtiger_field.presence in (0,2)";
$params1 = array();
} else {
$profileList = getCurrentUserProfileList();
$sql1 = "select fieldname,columnname from vtiger_field inner join vtiger_profile2field on vtiger_profile2field.fieldid=vtiger_field.fieldid inner join vtiger_def_org_field on vtiger_def_org_field.fieldid=vtiger_field.fieldid where vtiger_field.tabid=7 and vtiger_field.block <> 14 and vtiger_field.displaytype in (1,2,4) and vtiger_profile2field.visible=0 and vtiger_def_org_field.visible=0 and vtiger_field.presence in (0,2)";
$params1 = array();
if (count($profileList) > 0) {
$sql1 .= " and vtiger_profile2field.profileid in (" . generateQuestionMarks($profileList) . ")";
array_push($params1, $profileList);
}
}
$result1 = $adb->pquery($sql1, $params1);
for ($i = 0; $i < $adb->num_rows($result1); $i++) {
$permitted_lists[] = $adb->query_result($result1, $i, 'fieldname');
}
$Lead = new Leads();
$Lead->column_fields[firstname] = in_array('firstname', $permitted_lists) ? $first_name : "";
$Lead->column_fields[lastname] = in_array('lastname', $permitted_lists) ? $last_name : "";
$Lead->column_fields[company] = in_array('company', $permitted_lists) ? $account_name : "";
$Lead->column_fields[email] = in_array('email', $permitted_lists) ? $email_address : "";
$Lead->column_fields[title] = in_array('title', $permitted_lists) ? $title : "";
$Lead->column_fields[designation] = in_array('designation', $permitted_lists) ? $department : "";
$Lead->column_fields[phone] = in_array('phone', $permitted_lists) ? $office_phone : "";
$Lead->column_fields[homephone] = in_array('homephone', $permitted_lists) ? $home_phone : "";
$Lead->column_fields[website] = in_array('website', $permitted_lists) ? $website : "";
$Lead->column_fields[fax] = in_array('fax', $permitted_lists) ? $fax : "";
$Lead->column_fields[mobile] = in_array('mobile', $permitted_lists) ? $phone_mobile : "";
$Lead->column_fields[mailingstreet] = in_array('mailingstreet', $permitted_lists) ? $primary_address_street : "";
$Lead->column_fields[mailingcity] = in_array('mailingcity', $permitted_lists) ? $primary_address_city : "";
$Lead->column_fields[mailingstate] = in_array('mailingstate', $permitted_lists) ? $primary_address_state : "";
$Lead->column_fields[mailingzip] = in_array('mailingzip', $permitted_lists) ? $primary_address_postalcode : "";
$Lead->column_fields[workCountry] = in_array('mailingcountry', $permitted_lists) ? $workCountry : "";
$Lead->column_fields[lane] = in_array('lane', $permitted_lists) ? $alt_address_street : "";
$Lead->column_fields[city] = in_array('city', $permitted_lists) ? $alt_address_city : "";
$Lead->column_fields[state] = in_array('state', $permitted_lists) ? $alt_address_state : "";
$Lead->column_fields[code] = in_array('code', $permitted_lists) ? $alt_address_postalcode : "";
$Lead->column_fields[country] = in_array('country', $permitted_lists) ? $alt_address_country : "";
$Lead->column_fields[assigned_user_id] = in_array('assigned_user_id', $permitted_lists) ? $user_id : "";
$Lead->column_fields[description] = "";
// $log->fatal($Lead->column_fields);
$Lead->save("Leads");
$Lead = $Lead;
return $Lead->id;
}
}
$value = trim($_REQUEST[$fieldname]);
}
$log->info("the value is " . $value);
$focus->column_fields[$fieldname] = $value;
}
}
if (isset($_REQUEST['annualrevenue'])) {
$value = convertToDollar($_REQUEST['annualrevenue'], $rate);
$focus->column_fields['annualrevenue'] = $value;
}
if ($_REQUEST['assigntype'] == 'U') {
$focus->column_fields['assigned_user_id'] = $_REQUEST['assigned_user_id'];
} elseif ($_REQUEST['assigntype'] == 'T') {
$focus->column_fields['assigned_user_id'] = $_REQUEST['assigned_group_id'];
}
$focus->save("Leads");
$return_id = $focus->id;
$log->info("the return id is " . $return_id);
$parenttab = getParentTab();
if (isset($_REQUEST['return_module']) && $_REQUEST['return_module'] != "") {
$return_module = vtlib_purify($_REQUEST['return_module']);
} else {
$return_module = "Leads";
}
if (isset($_REQUEST['return_action']) && $_REQUEST['return_action'] != "") {
$return_action = vtlib_purify($_REQUEST['return_action']);
} else {
$return_action = "DetailView";
}
if (isset($_REQUEST['return_id']) && $_REQUEST['return_id'] != "") {
$return_id = vtlib_purify($_REQUEST['return_id']);
function create_lead_from_webform($username, $sessionid, $lastname, $email, $phone, $company, $country, $description, $firstname)
{
global $log;
global $adb;
global $current_user;
if (!validateSession($username, $sessionid)) {
return null;
}
require_once "modules/Users/Users.php";
$seed_user = new Users();
$user_id = $seed_user->retrieve_user_id($username);
$current_user = $seed_user;
$current_user->retrieve_entity_info($user_id, 'Users');
$adb->println("Create New Lead from Web Form - Starts");
require_once "modules/Leads/Leads.php";
$focus = new Leads();
if (isPermitted("Leads", "EditView") == "yes") {
$focus->column_fields['lastname'] = $lastname;
$focus->column_fields['firstname'] = $firstname;
$focus->column_fields['email'] = $email;
$focus->column_fields['phone'] = $phone;
$focus->column_fields['company'] = $company;
$focus->column_fields['country'] = $country;
$focus->column_fields['description'] = $description;
$focus->column_fields['assigned_user_id'] = $user_id;
$focus->save("Leads");
$adb->println("Create New Lead from Web Form - Ends");
if ($focus->id != '') {
return "Thank you for your interest. Information has been successfully added as Lead.";
} else {
return "Lead creation failed. Try again";
}
} else {
return $accessDenied;
}
}
$lead->column_fields["lane"] = $street_address_array[$key];
$key = array_rand($city_array);
$lead->column_fields["city"] = $city_array[$key];
$lead->column_fields["state"] = "CA";
$lead->column_fields["code"] = '99999';
$lead->column_fields["country"] = 'USA';
$key = array_rand($comboFieldArray['leadsource_dom']);
$lead->column_fields["leadsource"] = $comboFieldArray['leadsource_dom'][$key];
$key = array_rand($comboFieldArray['lead_status_dom']);
$lead->column_fields["leadstatus"] = $comboFieldArray['lead_status_dom'][$key];
$key = array_rand($comboFieldArray['rating_dom']);
$lead->column_fields["rating"] = $comboFieldArray['rating_dom'][$key];
$titles = array("President", "VP Operations", "VP Sales", "Director Operations", "Director Sales", "Mgr Operations", "IT Developer", "");
$key = array_rand($titles);
$lead->column_fields["designation"] = $titles[$key];
$lead->save("Leads");
}
//Populating Vendor Data
for ($i = 0; $i < 10; $i++) {
$vendor = new Vendors();
$vendor->column_fields["vendorname"] = ucfirst(strtolower($first_name_array[$i]));
$vendor->column_fields["phone"] = create_phone_number();
$vendor->column_fields["email"] = strtolower($vendor->column_fields["vendorname"]) . "@company.com";
$website = str_replace($whitespace, "", strtolower(ucfirst(strtolower($company_name_array[$i]))));
$vendor->column_fields["website"] = "www." . $website . ".com";
$vendor->column_fields["assigned_user_id"] = $assigned_user_id;
// Fill in a bogus address
$vendor->column_fields["street"] = $street_address_array[rand(0, $street_address_count - 1)];
$key = array_rand($city_array);
$vendor->column_fields["city"] = $city_array[$key];
$vendor->column_fields["state"] = "CA";
