function active_chat_list()
{
//note 处理搜索会员聊天
if ($_GET['action'] == 'active_chat') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
$where = '';
if (!empty($choose) && !empty($keyword)) {
if ($choose == 's_content') {
$where = " WHERE {$choose} like '%{$keyword}%'";
} else {
$where = " WHERE {$choose} = '{$keyword}'";
}
}
}
//note 登陆系统后客服显示自己范围内的， 主管显示全部
$return_arr = active_chat_loginlist($where, $keyword);
$where = $return_arr['where'];
$member_arr = $return_arr['members'];
//note 分页处理
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 15;
$offset = ($page - 1) * $limit;
//note 查询语句
if ($where != '1') {
//note 只查询属于该客服下的用户
//note 数据库查询
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}service_chat {$where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}service_chat {$where} ORDER BY s_id DESC LIMIT {$offset},{$limit}";
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
}
//note 搜索分页处理
if (!empty($choose) && !empty($keyword)) {
$currenturl = "index.php?action=active_chat&h=list&choose={$choose}&keyword=" . urlencode($keyword);
} else {
$currenturl = "index.php?action=active_chat&h=list";
}
$pages = multipage($total['num'], $limit, $page, $currenturl);
//note 跳转到某一页
$page_num = ceil($total['num'] / $limit);
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'service_chat', "{$GLOBALS['username']}查看聊天记录列表", $GLOBALS['adminid']);
//note 调用模板
require adminTemplate('active_chat_list');
}
function active_chat_list()
{
//note 分页处理
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 5;
$offset = ($page - 1) * $limit;
$type = MooGetGPC('type', 'string');
//note 显示全部
if (isset($_GET['type']) && $_GET['type'] == 'all') {
//note 显示已处理过的
} else {
if (isset($_GET['type']) && $_GET['type'] == 'dealed') {
$condition[] = " dealstate = '1'";
//note 显示未处理过的
} else {
$condition[] = " dealstate = '0'";
}
}
//note 所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$condition[] = " m.sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
} else {
$condition[] = " m.sid IN({$myservice_idlist})";
}
//note 处理搜索会员聊天
if (isset($_GET['action']) && $_GET['action'] == 'active_chat') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
if (!empty($choose) && !empty($keyword)) {
if ($choose == 's_content') {
$condition[] = " {$choose} like '%{$keyword}%'";
} else {
$condition[] = " {$choose} = '{$keyword}'";
}
}
}
$sql_where = '';
if (!empty($condition)) {
$sql_where = 'WHERE ' . implode(' AND ', $condition);
}
//note 查询语句
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}service_chat s LEFT JOIN {$GLOBALS['dbTablePre']}members_search m ON s.s_uid=m.uid {$sql_where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT s.*,m.sid,m.nickname as receive_nickname, m.gender as receive_gender FROM {$GLOBALS['dbTablePre']}service_chat s LEFT JOIN {$GLOBALS['dbTablePre']}members_search m ON s.s_uid=m.uid {$sql_where} ORDER BY s.s_id DESC LIMIT {$offset},{$limit}";
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
// foreach($user_arr as $k => $v) {
// //note 查询出发送用户的昵称，性别
// $sql = "SELECT nickname,gender FROM {$GLOBALS['dbTablePre']}members WHERE uid = '{$v[s_fromid]}'";
// $send_user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
// $user_arr[$k]['send_nickname'] = $send_user['nickname'];
// $user_arr[$k]['send_gender'] = $send_user['gender'];
//
// //note 查询出接受用户的昵称，性别
// $sql = "SELECT nickname,gender FROM {$GLOBALS['dbTablePre']}members WHERE uid = '{$v[s_uid]}'";
// $receive_user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
// $user_arr[$k]['receive_nickname'] = $receive_user['nickname'];
// $user_arr[$k]['receive_gender'] = $receive_user['gender'];
// }
//start
$receiveuids = array();
foreach ($user_arr as $k => $v) {
if (!in_array($v['s_fromid'], $receiveuids)) {
$receiveuids[] = $v['s_fromid'];
}
}
if (!empty($receiveuids)) {
sort($receiveuids);
$sql = "SELECT nickname,gender FROM {$GLOBALS['dbTablePre']}members_search WHERE uid IN(" . implode(',', $receiveuids) . ")";
$receive_user = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
foreach ($user_arr as $k => $v) {
if (($keys = array_search($v['s_fromid'], $receiveuids)) !== false) {
isset($receive_user[$keys]['nickname']) && ($user_arr[$k]['send_nickname'] = $receive_user[$keys]['nickname']);
isset($receive_user[$keys]['gender']) && ($user_arr[$k]['send_gender'] = $receive_user[$keys]['gender']);
}
}
}
//end
//note 获得当前的url 去除多余的参数
$currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
$currenturl = preg_replace("/www./", "", $currenturl);
$currenturl = preg_replace("/(&page=\\d+)/", "", $currenturl);
$currenturl = preg_replace("/(&type=undealed)/", "", $currenturl);
$currenturl = preg_replace("/(&type=dealed)/", "", $currenturl);
$currenturl = preg_replace("/(&type=all)/", "", $currenturl);
$currenturl2 = $currenturl;
$currenturl = $currenturl . "&type={$type}";
$pages = multipage($total['num'], $limit, $page, $currenturl);
//note 跳转到某一页
$page_num = ceil($total['num'] / $limit);
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'service_chat', "{$GLOBALS['username']}查看聊天记录列表", $GLOBALS['adminid']);
//note 调用模板
require adminTemplate('active_chat_list');
exit;
exit;
/////////////////////////////////////
$where = ' WHERE 1=1 ';
$type = MooGetGPC('type', 'string');
//note 显示全部
if ($_GET['type'] == 'all') {
$where .= "";
//note 显示已处理过的
} else {
if ($_GET['type'] == 'dealed') {
$where .= " AND dealstate = '1'";
//note 显示未处理过的
} else {
$where .= " AND dealstate = '0'";
}
}
//note 处理搜索会员聊天
if ($_GET['action'] == 'active_chat') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
if (!empty($choose) && !empty($keyword)) {
if ($choose == 's_content') {
$where .= " AND {$choose} like '%{$keyword}%'";
} else {
$where .= " AND {$choose} = '{$keyword}'";
}
}
}
//note 登陆系统后客服显示自己范围内的， 主管显示全部
$return_arr = active_chat_loginlist($where, $keyword);
$where = $return_arr['where'];
$member_arr = $return_arr['members'];
//note 分页处理
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 15;
$offset = ($page - 1) * $limit;
//note 查询语句
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}service_chat {$where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}service_chat {$where} ORDER BY s_id DESC LIMIT {$offset},{$limit}";
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
// foreach($user_arr as $k => $v) {
// //note 查询出发送用户的昵称，性别
// $sql = "SELECT nickname,gender FROM {$GLOBALS['dbTablePre']}members WHERE uid = '{$v[s_fromid]}'";
// $send_user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
// $user_arr[$k]['send_nickname'] = $send_user['nickname'];
// $user_arr[$k]['send_gender'] = $send_user['gender'];
//
// //note 查询出接受用户的昵称，性别
// $sql = "SELECT nickname,gender FROM {$GLOBALS['dbTablePre']}members WHERE uid = '{$v[s_uid]}'";
// $receive_user = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
// $user_arr[$k]['receive_nickname'] = $receive_user['nickname'];
// $user_arr[$k]['receive_gender'] = $receive_user['gender'];
// }
//start
$senduids = array();
$receiveuids = array();
foreach ($user_arr as $k => $v) {
if (!in_array($v['s_fromid'], $senduids)) {
$senduids[] = $v['s_fromid'];
}
if (!in_array($v['s_uid'], $receiveuids)) {
$receiveuids[] = $v['s_uid'];
}
}
if (!empty($senduids)) {
$sql = "SELECT nickname,gender FROM {$GLOBALS['dbTablePre']}members_search WHERE uid IN(" . implode(',', $senduids) . ")";
$send_user = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
foreach ($user_arr as $k => $v) {
if (($keys = array_search($v['s_fromid'], $senduids)) !== false) {
$user_arr[$k]['send_nickname'] = $send_user[$keys]['nickname'];
$user_arr[$k]['send_gender'] = $send_user[$keys]['gender'];
}
}
}
if (!empty($receiveuids)) {
$sql = "SELECT nickname,gender FROM {$GLOBALS['dbTablePre']}members_search WHERE uid IN(" . implode(',', $receiveuids) . ")";
$receive_user = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
foreach ($user_arr as $k => $v) {
if (($keys = array_search($v['s_uid'], $receiveuids)) !== false) {
$user_arr[$k]['receive_nickname'] = $receive_user[$keys]['nickname'];
$user_arr[$k]['receive_gender'] = $receive_user[$keys]['gender'];
}
}
}
//end
//note 获得当前的url 去除多余的参数
$currenturl = 'http://' . $_SERVER['SERVER_NAME'] . ':' . $_SERVER["SERVER_PORT"] . $_SERVER["REQUEST_URI"];
$currenturl = preg_replace("/(&page=\\d+)/", "", $currenturl);
$currenturl = preg_replace("/(&type=undealed)/", "", $currenturl);
$currenturl = preg_replace("/(&type=dealed)/", "", $currenturl);
$currenturl = preg_replace("/(&type=all)/", "", $currenturl);
$currenturl2 = $currenturl;
$currenturl = $currenturl . "&type={$type}";
$pages = multipage($total['num'], $limit, $page, $currenturl);
//note 跳转到某一页
$page_num = ceil($total['num'] / $limit);
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'service_chat', "{$GLOBALS['username']}查看聊天记录列表", $GLOBALS['adminid']);
//note 调用模板
require adminTemplate('active_chat_list');
}
