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