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";