/**
* 顾客联系方式列表
*/
function get_contact_list($user_id)
{
$sql_select = 'SELECT contact_id,contact_name,contact_value,is_default,add_time,access FROM ' . $GLOBALS['ecs']->table('user_contact') . " WHERE user_id={$user_id} AND is_del=0";
$result = $GLOBALS['db']->getAll($sql_select);
$contact_list = array();
foreach ($result as $val) {
if ($val['add_time']) {
$val['add_time'] = date('Y-m-d H:i:s', $val['add_time']);
}
if (!admin_priv('all', '', false)) {
if (!in_array($_SESSION['role_id'], array(13, 33)) || !in_array($_SESSION['admin_id'], array(4, 497, 467, 554, 330, 277))) {
if (in_array($val['contact_name'], array('tel', 'mobile'))) {
$val['contact_value'] = hideContact($val['contact_value']);
}
}
}
$contact_list[$val['contact_name']][] = $val;
}
return $contact_list;
}
function save_miss_call($miss_call_list)
{
foreach ($miss_call_list as $v) {
$issue_time = strtotime($v['activation']);
$sql = 'SELECT weight FROM ' . $GLOBALS['ecs']->table('public_notice') . " WHERE issue_time={$issue_time} AND notice_type=3";
$count = $GLOBALS['db']->getOne($sql);
if (!$count) {
$sql = 'select u.user_name,u.user_id FROM ' . $GLOBALS['ecs']->table('users') . ' u LEFT JOIN ' . $GLOBALS['ecs']->table('user_contact') . ' c ON u.user_id=c.user_id' . " WHERE u.mobile_phone={$v['calla']} OR u.home_phone={$v['calla']} OR c.contact_value={$v['calla']}";
$user_info = $GLOBALS['db']->getRow($sql);
if ($user_info) {
$v['calla'] = hideContact($v['calla']);
$user_info = "{$user_info['user_id']} | {$user_info['user_name']} |";
} else {
$user_info = '未知 |';
}
$content = "{$user_info} 主叫 {$v['calla']} ---- 分机 {$v['callb']}";
$sql_insert = 'INSERT INTO ' . $GLOBALS['ecs']->table('public_notice') . '(content,weight,notice_type,title,issue_time,role_id,admin_id,status)VALUES(' . "'{$content}',{$v['id']},3,'未接来电',{$issue_time},{$_SESSION['role_id']},{$_SESSION['admin_id']},0)";
$GLOBALS['db']->query($sql_insert);
}
}
}
