function api_add_address_to_newsletter($return_type, $user, $params)
{
global $config;
if (!give_acl($user, 0, "CN")) {
audit_db($user, $config["REMOTE_ADDR"], "ACL Violation", "Trying to access newsletter management");
exit;
}
$values['id_newsletter'] = $params[0];
$values['name'] = $params[1];
$values['email'] = $params[2];
$values['status'] = 0;
$values['datetime'] = print_mysql_timestamp();
$values['validated'] = 0;
$check_id_newsletter = get_db_value("id", "tnewsletter", "id", $values['id_newsletter']);
$result = 0;
if (!empty($check_id_newsletter)) {
$result = process_sql_insert('tnewsletter_address', $values);
}
switch ($return_type) {
case "xml":
echo xml_node($result);
break;
case "csv":
echo $result;
break;
}
return;
}
/**
* Create a lead
* @param $return_type xml or csv
* @param $user user who call function
* @param $params array (fullname, company, email, country, estimated_sale, progress, phone, mobile, position, managed_by, owner, language)
* @return unknown_type
*/
function api_create_lead($return_type, $user, $params)
{
global $config;
include_once $config['homedir'] . '/include/functions_tags.php';
$config['id_user'] = $user;
$fullname = trim($params[0]);
$company = trim($params[1]);
$email = trim($params[2]);
$country = trim($params[3]);
$estimated_sale = trim($params[4]);
$progress = trim($params[5]);
$phone = trim($params[6]);
$mobile = trim($params[7]);
$position = trim($params[8]);
$owner = trim($params[9]);
$language = trim($params[10]);
$comments = trim($params[11]);
$id_category = trim($params[12]);
$id_company = trim($params[13]);
$id_campaign = trim($params[14]);
$tags_token = trim($params[15]);
$tags_names_str = trim($params[16]);
$tag_names = array();
if (!empty($tags_token) && !empty($tags_names_str)) {
$tag_names = explode($tags_token, $tags_names_str);
}
// Search if any current lead with the same email already exists
$duped_id = get_db_value('id', 'tlead', 'email', $email);
// Duped
if ($duped_id != "") {
$duped = 1;
} else {
$duped = 0;
}
// Invalid lead information, abort
if ($fullname == "" or $email == "") {
$result = 0;
} else {
if ($duped == 1) {
$fullname = $fullname . " (DUPED LEAD!)";
$comments = $comments . " (DUPED LEAD!)";
}
$sql = sprintf('INSERT INTO tlead
(fullname, company, email, country, estimated_sale, progress, phone, mobile, position, owner, id_language, description, id_category, id_company, creation, modification, id_campaign)
VALUES ("%s", "%s", "%s", "%s", "%s", %d, "%s", "%s", "%s", "%s", "%s", "%s", %d, %d, "%s", "%s", %d)', $fullname, $company, $email, $country, $estimated_sale, $progress, $phone, $mobile, $position, $owner, $language, $comments, $id_category, $id_company, date('Y-m-d H:i:s'), date('Y-m-d H:i:s'), $id_campaign);
$new_id = process_sql($sql, 'insert_id');
if ($new_id !== false) {
// Assign tags to the leads
if (!empty($tag_names)) {
@create_lead_tag_with_names($new_id, $tag_names, true);
}
$datetime = date("Y-m-d H:i:s");
$sql = sprintf('INSERT INTO tlead_history (id_lead, id_user, timestamp, description) VALUES (%d, "%s", "%s", "%s")', $new_id, "API", $datetime, "Created lead via API");
process_sql($sql);
$result = 1;
} else {
$result = 0;
}
}
switch ($return_type) {
case "xml":
echo xml_node($result);
break;
case "csv":
echo $result;
break;
}
}
