/** * 顾客联系方式列表 */ 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); } } }