} elseif ($action == "update") {
$is_search = cw_query_first_cell("SELECT avail FROM {$tables['newslists']} WHERE list_id = '{$list_id}'");
// if list was manual, but now is search
if (!$is_search && $type_list_control == 1) {
// delete subscribers
db_query("DELETE FROM {$tables['newslist_subscription']} WHERE list_id='{$list_id}'");
$vertical_response_data['subscribers'][$list_id] = array();
// if list was search, but now is manual
} elseif ($is_search && $type_list_control == 0) {
$vertical_response_data['subscribers'][$list_id] = array();
}
// change parameters
cw_array2update('newslists', array('avail' => $type_list_control, 'salesman_customer_id' => $saved_search), "list_id = '{$list_id}'");
} elseif ($action == "delete" && is_array($to_delete)) {
foreach ($to_delete as $email => $flag) {
$result = cw_vertical_response_delete_subcriber($list_id, $email);
if ($result) {
db_query("DELETE FROM {$tables['newslist_subscription']} WHERE list_id='{$list_id}' AND email='{$email}'");
}
}
$top_message['content'] = cw_get_langvar_by_name("msg_adm_news_subscribers_del");
} elseif ($action == "export" && !empty($to_delete)) {
header("Content-type: application/force-download");
header("Content-disposition: attachment; filename=subscribers.txt");
$subscribers = cw_query("\n\t\t\tSELECT * FROM {$tables['newslist_subscription']}\n\t\t\tWHERE list_id='{$list_id}' AND email IN ('" . implode("','", array_keys($to_delete)) . "')\n ");
if (is_array($subscribers)) {
foreach ($subscribers as $value) {
echo $value['email'] . "\n";
}
}
exit;
/**
* Update emails for saved_search list by cron
*/
function cw_vertical_response_emails_update()
{
global $tables;
$lists = cw_query("\r\n\t\tSELECT list_id, salesman_customer_id FROM {$tables['newslists']}\r\n\t\tWHERE avail = 1 AND show_as_news = 2 AND salesman_customer_id <> 0\r\n\t");
if ($lists) {
foreach ($lists as $list) {
$list_id = $list['list_id'];
db_query("DELETE FROM {$tables['newslist_subscription']} WHERE list_id = '{$list_id}'");
// search subscribers
$saved_search = $list['salesman_customer_id'];
// salesman_customer_id is saved search id
$sql_query = cw_query_first_cell("\r\n\t\t\t\tSELECT sql_query FROM {$tables['saved_search']} WHERE ss_id = '{$saved_search}'\r\n\t\t\t");
$exist_cw = array();
// emails from saved_search
if ($sql_query) {
$results = cw_query($sql_query);
if ($results) {
$data = array();
foreach ($results as $result) {
$count = cw_query_first_cell("\r\n\t\t\t\t\t\t\tSELECT COUNT(*) FROM {$tables['newslist_subscription']}\r\n\t\t\t\t\t\t\tWHERE list_id='{$list_id}' AND email='" . $result['email'] . "'\r\n\t\t\t\t\t\t");
if ($count < 1) {
$exist_cw[] = $result['email'];
$data['list_id'] = $list_id;
$data['email'] = addslashes($result['email']);
$data['since_date'] = cw_core_get_time();
cw_array2insert('newslist_subscription', $data);
}
}
}
}
// synchronize emails
// get emails from vr
$exist_vr = array();
$subscribers = cw_vertical_response_get_subscribers($list_id);
if ($subscribers) {
foreach ($subscribers as $subscriber) {
$exist_vr[] = $subscriber['email'];
}
}
// need add
$need_add = array_diff($exist_cw, $exist_vr);
if ($need_add) {
foreach ($need_add as $email) {
cw_vertical_response_add_subcriber($list_id, $email);
}
}
// need delete
$need_delete = array_diff($exist_vr, $exist_cw);
if ($need_delete) {
foreach ($need_delete as $email) {
cw_vertical_response_delete_subcriber($list_id, $email);
}
}
}
}
}
