function get_search_condition($where)
{
global $h;
$condition[] = $where;
$sid = MooGetGPC('sid', 'integer', 'G');
if ($sid) {
$condition[] = " m.sid={$sid}";
}
if (!empty($_GET['search_date'])) {
if ($_GET['search_type'] == 1) {
$field = 'm.regdate';
} else {
$field = 'b.allotdate';
}
$search_date = strtotime(MooGetGPC('search_date', 'string', 'G'));
$search_date2 = $search_date + 60 * 60 * 24;
$condition[] = " {$field}>='{$search_date}' AND {$field}<='{$search_date2}'";
}
if (!empty($_GET['uid'])) {
$uid = trim(MooGetGPC('uid', 'integer', 'G'));
$condition[] = " m.uid='{$uid}'";
}
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
if ($h == 'give_up') {
if (in_array($GLOBALS['groupid'], $GLOBALS['admin_aftersales'])) {
//售后能看到放弃会员列表
}
} else {
$condition[] = " m.sid IN({$GLOBALS['adminid']})";
}
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} elseif ($h == 'give_up') {
if (in_array($GLOBALS['groupid'], $GLOBALS['admin_aftersales'])) {
//售后能看到放弃会员列表
} else {
$condition[] = " m.sid IN({$myservice_idlist})";
}
} else {
$condition[] = " m.sid IN({$myservice_idlist})";
}
if ($GLOBALS['adminid'] == 23 && $h == 'high_member') {
//针对售后组长（王海红）显示过期的
$condition[] = "m.endtime < " . time();
}
$result = implode(' AND ', $condition);
/*
*如果是销售客服，返回WHERE ma.effect_grade=7 AND m.sid IN(62)
*如果是组长，返回WHERE ma.effect_grade=7 AND m.sid IN(16,22,26,30,31,39,51,62,66,69,74,82,86,88,162,211,213,216,222,229)
*如果是$myservice_idlist == 'all'，返回的是 WHERE ma.effect_grade=7
*/
// echo $result;die;
return $result;
}
function active_rightbottom_message()
{
$type = MooGetGPC('type', 'string');
$sql_where = ' WHERE 1=1 ';
//note 显示全部
if (isset($_GET['type']) == 'all') {
$sql_where .= "";
//note 显示已处理过的
} else {
if ((isset($_GET['type']) ? $_GET['type'] : '') == 'dealed') {
$sql_where .= " AND dealstate = '1'";
//note 显示未处理过的
} else {
$sql_where .= " AND dealstate = '0'";
}
}
//分页
$page_per = 20;
$page = max(1, MooGetGPC('page', 'integer', 'G'));
$limit = 20;
$offset = ($page - 1) * $limit;
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$sql_where .= " AND sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$sql_where .= " AND sid IN({$myservice_idlist})";
}
if (isset($_GET['id'])) {
$id = MooGetGPC('id', 'integer', 'G');
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_remark SET status=1 WHERE id='{$id}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
salert('操作成功', 'index.php?action=other_rightbottom&h=message');
}
$total = getcount('admin_remark', $sql_where);
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_remark {$sql_where} ORDER BY id DESC LIMIT {$offset},{$limit}";
$remark_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
//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";
echo $currenturl; */
$currenturl = "index.php?action=other_rightbottom&h=message&type={$type}";
//note 跳转到某一页
$page_num = ceil($total / $limit);
$page_links = multipage($total, $page_per, $page, $currenturl);
//note 调用模板
require adminTemplate('other_rightbottom_message');
}
function ajax_delmyuser()
{
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
// error_log($myservice_idlist);
$uid = MooGetGPC('uid', 'integer', 'G');
$deldesc = trim(MooGetGPC('deldesc', 'string', 'G'));
$deldesc = iconv("GBK", "UTF-8", $deldesc);
if (empty($uid) || empty($deldesc)) {
echo 'no uid or desc';
exit;
}
if ($myservice_idlist != 'all') {
$myservice_idlist = explode(',', $myservice_idlist);
}
// error_log(print_r($_GET,true));
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}members_search WHERE uid='{$uid}'";
$sid = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
if ($sid['sid'] == $GLOBALS['adminid'] || $myservice_idlist == 'all' || in_array($sid['sid'], $myservice_idlist)) {
//删除会员转到某个客服名下
if (file_exists("data/del_to_user.txt")) {
$file_kefuid = fopen("data/del_to_user.txt", 'r');
$del_to_sid = fread($file_kefuid, 11);
fclose($file_kefuid);
}
$sql = "UPDATE {$GLOBALS['dbTablePre']}members_search SET sid='{$del_to_sid}',is_well_user=0 WHERE uid='{$uid}' ";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
searchApi('members_man members_women')->updateAttr(array('sid', 'is_well_user'), array($uid => array((int) $del_to_sid, 0)));
//if(MOOPHP_ALLOW_FASTDB) {MooFastdbUpdate('members','uid',$uid);}
//对应的维护会员总数减1
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_user SET member_count=member_count-1 WHERE uid='{$sid['sid']}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
$sql = "UPDATE {$GLOBALS['dbTablePre']}admin_user SET member_count=member_count+1 WHERE uid='{$del_to_sid}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//后台扩展表标记为删除状态
$sql = "UPDATE {$GLOBALS['dbTablePre']}member_admininfo SET is_delete=1,old_sid='{$sid['sid']}' WHERE uid='{$uid}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//写入到后台扩展表小记中
$time = time();
$deldesc = '[删除原因]:' . $deldesc;
$sql = "INSERT INTO {$GLOBALS['dbTablePre']}member_backinfo SET mid='{$GLOBALS['adminid']}',manager='{$GLOBALS['username']}',uid='{$uid}',effect_grade='10',comment='{$deldesc}',dateline='{$time}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
//删除会员写表记录
$sql = "INSERT INTO {$GLOBALS['dbTablePre']}admin_deluser SET sid='{$GLOBALS['adminid']}',username='******'username']}',uid='{$uid}',dateline='{$time}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
if (MOOPHP_ALLOW_FASTDB) {
$value['sid'] = 52;
$value['is_well_user'] = 0;
MooFastdbUpdate('members_search', 'uid', $uid, $value);
}
//写日志
serverlog(3, $GLOBALS['dbTablePre'] . 'members_search', "{$GLOBALS['username']}客服将自己的会员{$uid}删除放弃", $GLOBALS['adminid'], $uid);
echo 'ok';
}
}
/**
* 检查普通客服修改用户资料
* @author:fanglin
*/
function check_memberinfo_list()
{
//所管理的客服id列表
$sql_where = '';
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$sql_where = " AND sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$sql_where = " AND sid IN({$myservice_idlist})";
}
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_editmembersinfo_sql WHERE status=0 {$sql_where} ORDER BY id DESC";
$list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
require adminTemplate("check_memberinfo_list");
}
function other_member_allot_record_group()
{
$groupid = MooGetGPC('groupid', 'integer', 'G');
$sid = MooGetGPC('sid', 'integer', 'G');
if ($sid) {
other_member_allot_record_user();
return;
}
if ($groupid) {
$sql = "SELECT manage_list FROM {$GLOBALS['dbTablePre']}admin_manage where id={$groupid}";
$sid_arr = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sid_list = $sid_arr['manage_list'];
} else {
$sid_list = get_myservice_idlist();
}
if (!empty($sid_list)) {
$condition[] = "type=2 and uid in (" . $sid_list . ")";
}
$type = MooGetGPC('type', 'string', 'P');
$keyword = MooGetGPC('keyword', 'string', 'P');
if (!empty($_REQUEST['allot_time1'])) {
$allot_time1 = MooGetGPC('allot_time1', 'string');
$allodate1 = strtotime($allot_time1);
$allodate1 = strtotime(date("Y-m-d 00:00:00", $allodate1));
$condition[] = " dateline>='{$allodate1}'";
} else {
$allodate1 = strtotime(date("Y-m-d 00:00:00")) - 86400;
$condition[] = " dateline>='{$allodate1}'";
}
if (!empty($_REQUEST['allot_time2'])) {
$allot_time2 = MooGetGPC('allot_time2', 'string');
$allodate2 = strtotime($allot_time2);
$allodate2 = strtotime(date("Y-m-d 23:59:59", $allodate2));
$condition[] = " dateline<='{$allodate2}'";
} else {
$allodate2 = strtotime(date("Y-m-d 23:59:59")) - 86400;
$condition[] = " dateline<='{$allodate2}'";
}
$sql_where = 'WHERE ' . implode(' AND ', $condition);
$sql = "SELECT uid,username,member_count,sum(allot_member) AS allot_member FROM {$GLOBALS['dbTablePre']}admin_telcount {$sql_where} group by uid ";
$ret = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
require_once adminTemplate('other_member_allot_record_group');
}
function bind_list()
{
$bindArr = array(0 => '未联系', 1 => '<span style="color:#0FF">已绑定</span>', 2 => '<span style="color:#F00">绑定过期</span>');
$page = max(1, MooGetGPC('page', 'integer', 'G'));
$pagesize = 16;
$start = ($page - 1) * $pagesize;
$choose = '';
$uid = '';
if (isset($_GET['choose'])) {
$choose = $_GET['choose'];
}
if (isset($_GET['uid'])) {
$uid = (int) $_GET['uid'];
}
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
$sql_where = '';
if (empty($myservice_idlist)) {
$sql_where = " WHERE ms.sid = {$GLOBALS['adminid']} ";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$sql_where = " WHERE ms.sid IN({$myservice_idlist})";
}
if ($uid) {
$str = empty($sql_where) ? ' WHERE' : ' AND';
$sql_where .= $str . " mb." . $choose . "='{$uid}'";
}
$sql = "SELECT COUNT(1) c FROM {$GLOBALS['dbTablePre']}members_bind mb \n\t\tLEFT JOIN {$GLOBALS['dbTablePre']}members_search ms ON mb.a_uid = ms.uid \n\t\t{$sql_where} ";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT mb.* \n\t\t\t\tFROM {$GLOBALS['dbTablePre']}members_bind mb \n\t\t\t\tLEFT JOIN {$GLOBALS['dbTablePre']}members_search ms ON mb.a_uid = ms.uid \n\t\t\t\t{$sql_where} \n\t\t\t\tORDER BY bind,id desc \n\t\t\t\tLIMIT {$start},{$pagesize}";
$bindrs = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
$currenturl = 'index.php?action=active_bind&h=list';
$pages = multipage($total['c'], $pagesize, $page, $currenturl);
require adminTemplate('active_bind_list');
}
function active_commission_list()
{
error_reporting(0);
//note 分页处理
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 5;
$offset = ($page - 1) * $limit;
//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})";
}
$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 处理搜索会员聊天
if (isset($_GET['action']) && $_GET['action'] == 'active_commission') {
$choose = MooGetGPC('members_choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
if (!empty($choose) && !empty($keyword)) {
$condition[] = " {$choose} = '{$keyword}'";
}
}
//note 处理搜索会员聊天
if ($_GET['action'] == 'active_commission') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
if (!empty($choose) && !empty($keyword)) {
$condition[] = " {$choose} = '{$keyword}'";
}
}
$sql_where = '';
if (!empty($condition)) {
$sql_where = 'WHERE ' . implode(' AND ', $condition);
}
//note 查询语句
$sql = "select count(distinct other_contact_you) as num from {$GLOBALS['dbTablePre']}service_contact left join {$GLOBALS['dbTablePre']}members_search as m ON other_contact_you=m.uid {$sql_where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$sql = "select distinct other_contact_you from {$GLOBALS['dbTablePre']}service_contact left join {$GLOBALS['dbTablePre']}members_search as m ON other_contact_you=m.uid {$sql_where} ORDER BY sendtime DESC LIMIT {$offset},{$limit}";
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
$other_contact_you_list = '';
if ($user_arr) {
foreach ($user_arr as $v) {
$other_contact_you_list .= $v['other_contact_you'] . ',';
}
}
$other_contact_you_list = rtrim($other_contact_you_list, ',');
//var_dump(!empty($other_contact_you_list));exit;
if (!empty($other_contact_you_list)) {
$sql = "select uid,nickname,gender,birthyear from {$GLOBALS['dbTablePre']}members_search where uid in ({$other_contact_you_list}) order by field(uid,{$other_contact_you_list})";
$temp1 = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
foreach ($temp1 as $k => $v) {
$user_arr[$k]['nickname'] = $v['nickname'];
$user_arr[$k]['gender'] = $v['gender'];
$user_arr[$k]['birthyear'] = $v['birthyear'];
}
$sql = "select mid,dealstate,other_contact_you,you_contact_other,stat,sendtime from {$GLOBALS['dbTablePre']}service_contact where other_contact_you in ({$other_contact_you_list}) order by sendtime desc";
$temp1 = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
$temp2 = array();
foreach ($temp1 as $v) {
if (!isset($temp2[$v['other_contact_you']])) {
foreach ($user_arr as $u_k => $u_v) {
if ($u_v['other_contact_you'] == $v['other_contact_you']) {
$user_arr[$u_k]['sendtime'] = $v['sendtime'];
$user_arr[$u_k]['mid'] = $v['mid'];
$user_arr[$u_k]['dealstate'] = $v['dealstate'];
}
}
}
$temp2[$v['other_contact_you']]['you_contact_you_list'][] = $v['you_contact_other'];
$temp2[$v['other_contact_you']]['state_list'][] = $v['stat'];
$temp2[$v['other_contact_you']]['sendtime_list'][] = $v['sendtime'];
}
//note 得到发送委托会员基本信息
foreach ($user_arr as $k => $v) {
//得到接受委托会员基本信息
$contact_id_list = $temp2[$v['other_contact_you']]['you_contact_you_list'];
$sendtime_id_list = $temp2[$v['other_contact_you']]['sendtime_list'];
$state_id_list = $temp2[$v['other_contact_you']]['state_list'];
if (empty($contact_id_list)) {
continue;
}
$user_info2 = array();
$sql = "select uid,nickname,gender,birthyear from {$GLOBALS['dbTablePre']}members_search where uid in (" . implode(',', $contact_id_list) . ")";
$user_info2 = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
foreach ($user_info2 as $kk => $vv) {
$user_arr[$k]['contact_list'][$kk]['uid'] = $vv['uid'];
$user_arr[$k]['contact_list'][$kk]['nickname'] = $vv['nickname'];
$user_arr[$k]['contact_list'][$kk]['gender'] = $vv['gender'];
$user_arr[$k]['contact_list'][$kk]['birthyear'] = date("Y", time()) - $vv['birthyear'];
$user_arr[$k]['contact_list'][$kk]['sendtime'] = date("Y-m-d H:i:s", $sendtime_id_list[$kk]);
$user_arr[$k]['contact_list'][$kk]['state'] = $state_id_list[$kk];
}
}
}
//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'] . 'members_search', "{$GLOBALS['username']}操作会员委托", $GLOBALS['adminid']);
require adminTemplate('active_commission_list');
}
function active_websms_list()
{
$type = MooGetGPC('type', 'string');
$sql_where = "";
//note 显示全部
if (isset($_GET['type']) && $_GET['type'] == 'all') {
$sql_where = "";
//note 显示已处理过的
} else {
if (isset($_GET['type']) && $_GET['type'] == 'dealed') {
$sql_where .= " AND s.dealstate = '1'";
//note 显示未处理过的
} else {
$sql_where .= " AND s.dealstate = '0'";
}
}
//note 系统发给会员的信息不显示
$sql_where .= " AND s.s_fromid != '0'";
//note 处理搜索会员聊天
if (isset($_GET['action']) && $_GET['action'] == 'active_websms') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
//$where = '';
if (!empty($choose) && !empty($keyword)) {
if ($choose == 's_content' || $choose == 's_title') {
$sql_where .= " AND {$choose} like '%{$keyword}%'";
} else {
$sql_where .= " AND {$choose} = '{$keyword}'";
}
}
}
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 5;
$offset = ($page - 1) * $limit;
//note 所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$sql_where = " AND m.sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$sql_where = " AND m.sid IN({$myservice_idlist})";
}
$sql = "SELECT count(m.uid) as c FROM {$GLOBALS['dbTablePre']}services s \n\tLEFT JOIN {$GLOBALS['dbTablePre']}members_search m ON s.s_fromid = m.uid \n\tWHERE s.s_cid!='3' {$sql_where}";
$total_count = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
/*$sql = "SELECT m.uid FROM {$GLOBALS['dbTablePre']}services s
LEFT JOIN {$GLOBALS['dbTablePre']}members m ON s.s_fromid = m.uid
WHERE s.s_cid!='50' {$sql_where}";
$total_count=$GLOBALS['_MooClass']['MooMySQL']->getOne($sql);*/
// echo $sql.'<br />';
//$total = count($total_count['uid']);
$total = $total_count['c'];
$sql = "SELECT s.*,m.nickname FROM {$GLOBALS['dbTablePre']}services s \n\t\t\tLEFT JOIN {$GLOBALS['dbTablePre']}members_search m ON s.s_fromid = m.uid \n\t\t\tWHERE s.s_cid!='3' {$sql_where} ORDER BY s.s_id DESC LIMIT {$offset},{$limit}";
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
// echo $sql.'<br />';
//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, $limit, $page, $currenturl);
//note 跳转到某一页
$page_num = ceil($total / $limit);
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'servies', "{$GLOBALS['username']}查看站内短信列表", $GLOBALS['adminid']);
require adminTemplate('active_websms_list');
}
function vipuser_getvip_group()
{
$groupid = MooGetGPC('groupid', 'integer', 'G');
if ($groupid) {
$sql = "SELECT manage_list FROM {$GLOBALS['dbTablePre']}admin_manage where id={$groupid}";
$sid_arr = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$sid_list = $sid_arr['manage_list'];
} else {
$sid_list = get_myservice_idlist();
}
$pay_service = MooGetGPC('pay_service', 'integer', 'G');
$count = array();
$where = $note = '';
if (!empty($_GET['start_time']) || !empty($_GET['end_time'])) {
$start_time = strtotime(trim(MooGetGPC('start_time', 'string', 'G')));
$end_time = strtotime(trim(MooGetGPC('end_time', 'string', 'G'))) + 86400;
if ($start_time) {
$where .= " AND `apply_time` > {$start_time} ";
}
if ($end_time) {
if ($start_time && $end_time <= $start_time) {
$end_time = $start_time + 86400;
$note = '由于结束时间不能小于开始时间，系统自动将结束时间更改为：' . date('Y-m-d', $end_time);
}
$where .= " AND `apply_time` <= {$end_time} ";
}
}
if (isset($_GET['pay_service'])) {
$where .= " AND pay_service={$pay_service}";
}
if (!empty($sid_list)) {
$where .= " AND apply_sid in (" . $sid_list . ")";
}
//总体
$sql = "SELECT COUNT(*) AS c,SUM(`pay_money`) AS qian,`pay_service` FROM {$GLOBALS['dbTablePre']}payment_new WHERE `status` IN(1,3) {$where} GROUP BY `pay_service`";
$totalCount = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
//每个客服
$sql = "SELECT sum(`pay_money`) AS total,COUNT(*) AS num ,`apply_sid` FROM {$GLOBALS['dbTablePre']}payment_new WHERE `status` IN(1,3) {$where} GROUP BY `apply_sid`";
$everyCount = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
require adminTemplate('vipuser_summary_group');
}
/**
* 安徽卫视周日我最大 活动
* 2011-07-02
*/
function ahtvtj()
{
global $_MooClass;
$adminid = $GLOBALS['adminid'];
$dbpre = $GLOBALS['dbTablePre'];
$page_per = 15;
$channel = MooGetGPC('channel', 'integer', 'G');
$startdate = MooGetGPC('startdate', 'string', 'G');
$enddate = MooGetGPC('enddate', 'string', 'G');
$choose = MooGetGPC('choose', 'string', 'G');
$keyword = trim(MooGetGPC('keyword', 'string', 'G'));
$notsite = MooGetGPC('notsite', 'string', 'G');
$attenduser = MooGetGPC('attenduser', 'string', 'G');
// $channel_names = array(1 => '周日我最大', 2 => '幸福来敲门', 3 => '相亲齐上阵', 4 => '七夕活动');
$channels = $_MooClass['MooMySQL']->getAll("select id, title from {$dbpre}activity");
foreach ($channels as $v) {
if ($v['id'] == 0) {
continue;
}
$channel_names[$v['id']] = $v['title'];
}
$condition = array();
if ($notsite) {
$condition[] = "a.uid=0";
}
if ($attenduser) {
$condition[] = "a.isattend=1";
}
// else $condition[] = "a.isattend=0";
if ($channel >= 1) {
$condition[] = "a.channel=" . $channel;
}
if (!empty($startdate)) {
$condition[] = "a.regtime>='" . $startdate . "'";
}
if (!empty($enddate)) {
$condition[] = "a.regtime<='" . $enddate . "'";
}
if (!empty($choose) && $keyword !== '') {
if ($choose == 'username') {
$condition[] = "a.{$choose} like '%{$keyword}%'";
} else {
$condition[] = "a.{$choose}='{$keyword}'";
}
}
$select = "select a.id, a.uid, a.username, a.gender, a.birthday, a.province, a.city, a.mobile, a.regtime, a.channel, a.isattend";
$from = "from {$dbpre}ahtv_reguser a left join {$dbpre}members_search b on a.uid=b.uid";
$sql_condition = implode(' and ', $condition);
if (!$sql_condition) {
$sql_condition = 'true';
}
//得到所属客服下的会员
$myservice_idlist = get_myservice_idlist();
$myservice_idlist = empty($myservice_idlist) ? 'all' : $myservice_idlist;
//计算总记录数
//note 所管理的用户列表
if (empty($myservice_idlist)) {
$sql = "select count(id) as count {$from} where {$sql_condition} and b.sid={$adminid} order by id";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
$sql = "select count(id) as count from {$dbpre}ahtv_reguser a where {$sql_condition} order by id";
} else {
$sql = "select count(id) as count {$from} where {$sql_condition} and b.sid in ({$myservice_idlist}) order by id";
}
$a = $_MooClass['MooMySQL']->getOne($sql);
$total = $a['count'];
$currenturl = "index.php?action=financial_ahtv_reguser&h=list&channel={$channel}&startdate={$startdate}&enddate={$enddate}&choose={$choose}&keyword={$keyword}¬site={$notsite}&attenduser={$attenduser}";
$page_num = ceil($total / $page_per);
$page = max(1, min(MooGetGPC('page', 'integer'), $page_num));
$offset = ($page - 1) * $page_per;
$pages = multipage($total, $page_per, $page, $currenturl);
$limit = "limit {$offset}, {$page_per}";
//详细记录查询
if (empty($myservice_idlist)) {
$sql = $select . " " . $from . " where b.sid={$adminid} and {$sql_condition} {$limit}";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
$sql = $select . " from {$dbpre}ahtv_reguser a where {$sql_condition} {$limit}";
} else {
$sql = $select . " " . $from . " where b.sid in ({$myservice_idlist}) and {$sql_condition} {$limit}";
}
$reguser = $_MooClass['MooMySQL']->getAll($sql);
foreach ($reguser as &$value) {
$birthday_arr = explode('-', $value['birthday']);
$birthday = $birthday_arr[0] . '年';
if (!empty($birthday_arr[1])) {
$birthday .= $birthday_arr[1] . '月';
}
$value['birthday'] = $birthday;
}
require_once adminTemplate('financial_ahtv_reguser');
}
function get_kefulist()
{
$sql_where = '';
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$sql_where = " WHERE uid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
$sql_where = " where uid>1";
} else {
$sql_where = " WHERE uid IN({$myservice_idlist})";
}
$sql = "SELECT * FROM {$GLOBALS['dbTablePre']}admin_user {$sql_where} ORDER BY uid ASC";
$result = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
// if(in_array($GLOBALS['groupid'],$GLOBALS['admin_service_team'])) print_r($result);
return $result;
}
function check_feedback()
{
global $adminid, $kefu_arr, $groupid;
$sid = $GLOBALS['adminid'];
$type = MooGetGPC('type', 'string') == '' ? 'list' : MooGetGPC('type', 'string');
$usersid = MooGetGPC('usersid', 'string', 'G');
//makui
$lei = "意见反馈";
$id = MooGetGPC('id', 'integer');
$gid = MooGetGPC('gid', 'integer');
$uid = MooGetGPC('uid', 'integer');
// 系统
$checkArr = array(1 => '已回复', 0 => '未回复');
$serArr = array(1 => '网站功能', 2 => '红娘服务');
$attArr = array(0 => '其他', 1 => '表扬', 2 => '批评', 3 => '建议');
$fraction_arr = array(1 => '非常不满意', 2 => '不满意', 3 => '一般', 4 => '满意', 5 => '非常满意');
switch ($type) {
case 'list':
$pass = MooGetGPC('pass', 'integer', 'G');
//note 获得当前url
$currenturl = "index.php?action=check&h=feedback";
$currenturl2 = preg_replace("/(&page=\\d+)/", "", $currenturl);
$currenturl2 = preg_replace("/(&pass=\\d+)/", "", $currenturl2) . "&pass={$pass}";
$currenturl2 = preg_replace("/(&usersid=\\d+)/", '', $currenturl2);
$page = get_page();
$prepage = 20;
$start = ($page - 1) * $prepage;
if (isset($_GET['usersid']) && MooGetGPC('usersid', 'string', 'G') == 0) {
salert("无所属客服");
}
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$sql_where = " WHERE m.sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
if (isset($_GET['usersid'])) {
$sql_where = "where m.sid='{$usersid}'";
}
//查看某一客服的会员
} else {
$sql_where = " WHERE m.sid IN({$myservice_idlist})";
if (isset($_GET['usersid'])) {
$sql_where .= " AND m.sid='{$usersid}'";
}
//查看某一客服的会员
}
if (empty($sql_where)) {
$sql_where .= " WHERE g.syscheck='{$pass}'";
} else {
$sql_where .= " AND g.syscheck='{$pass}'";
}
$s_stat1 = MooGetGPC('s_stat1', 'integer');
$s_stat2 = MooGetGPC('s_stat2', 'integer');
if ($s_stat1 > 0 || $s_stat2 > 0) {
if ($s_stat1 > 0) {
$s_stat1 -= 1;
$sql_where .= " and g.stat1={$s_stat1} ";
}
if ($s_stat2 > 0) {
$sql_where .= $and . " and g.stat2={$s_stat2} ";
}
}
$sql = "SELECT count(1) as c FROM {$GLOBALS['dbTablePre']}service_getadvice g\n\t \t\tLEFT JOIN {$GLOBALS['dbTablePre']}members m ON g.uid=m.uid\n\t \t\t{$sql_where}";
$total_re = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$total = $total_re['c'];
//serverlog(1,$dbTablePre."service_getadvice","查询意见反馈",$GLOBALS['adminid']);
$sql = "SELECT g.gid,g.uid,g.stat1,g.stat2,g.content,g.submitdate,g.syscheck,m.sid, g.fraction FROM {$GLOBALS['dbTablePre']}service_getadvice g\n\t \t\t\tLEFT JOIN {$GLOBALS['dbTablePre']}members m ON g.uid=m.uid\n\t \t\t\t{$sql_where}\n\t \t\tORDER BY g.gid DESC LIMIT {$start},{$prepage}";
$advice = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
require adminTemplate("check_advice_list");
break;
case 'show':
$showadvice = $GLOBALS['_MooClass']['MooMySQL']->getOne("SELECT s.*, m.sid FROM {$GLOBALS['dbTablePre']}service_getadvice s left join {$GLOBALS['dbTablePre']}members m on s.uid=m.uid WHERE s.`gid`='{$gid}'");
//serverlog(1,$dbTablePre."service_getadvice","查看意见反馈",$GLOBALS['adminid']);
require adminTemplate("check_show");
break;
case 'submit':
$content = MooGetGPC('content', 'string');
$is_pass = MooGetGPC('pass', 'string');
$is_onpass = MooGetGPC('nopass', 'string');
if ($is_onpass) {
if ($gid == '' || $uid == '') {
salert('参数错误');
}
$GLOBALS['_MooClass']['MooMySQL']->query("DELETE FROM {$GLOBALS['dbTablePre']}service_getadvice WHERE `gid`='{$gid}'");
salert('删除成功！', 'index.php?action=check&h=feedback');
} elseif ($is_pass) {
if ($gid == '' || $content == '' || $uid == '') {
salert('参数错误');
}
$GLOBALS['_MooClass']['MooMySQL']->query("UPDATE {$GLOBALS['dbTablePre']}service_getadvice SET `syscheck`=1 WHERE `gid`='{$gid}'");
sendusermessage($uid, $content, "回复意见反馈");
serverlog(1, $dbTablePre . "service_getadvice", $GLOBALS['username'] . "回复意见反馈" . $gid, $GLOBALS['adminid']);
salert('回复此信息成功', 'index.php?action=check&h=feedback');
}
//echo "<script>window.history.go(-2);</script>";
break;
}
}
function myuser_remark()
{
$sid = $groupid = '';
$condition = array();
$manage_list = $link = '';
//提交删除
if (isset($_POST['submit']) ? $_POST['submit'] : '') {
$id = $_POST['changesid'];
foreach ($id as $v) {
$sql = "delete from {$GLOBALS['dbTablePre']}member_effectgrade where id='{$v}'";
$GLOBALS['_MooClass']['MooMySQL']->query($sql);
}
}
//客服访问权限
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$condition[] = " sid IN({$GLOBALS['adminid']}) ";
} elseif ($myservice_idlist == 'all') {
//if(isset($_GET['usersid'])){$condition .=" g.sid='$usersid'";}
//all为客服主管能查看所有的
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user", 0, 0, 0, true);
} else {
$condition[] = " sid IN({$myservice_idlist}) ";
// if(isset($_GET['usersid'])){$condition .=" g.sid='$usersid'";}
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user where uid in ({$myservice_idlist}) ", 0, 0, 0, true);
}
$sid = MooGetGPC('sid', 'integer', 'G');
$groupid = MooGetGPC('groupid', 'string', 'G');
if ($groupid) {
$group = get_group_type($groupid);
$manage_list = $group[0]['manage_list'];
$condition[] = " sid IN({$manage_list})";
} elseif ($groupid && $sid) {
$condition[] = " sid='{$sid}'";
}
$group_list = get_group_type();
if ($manage_list) {
$manage_arr = explode(',', $manage_list);
foreach ($manage_arr as $value) {
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getOne("select uid,username from web_admin_user where uid={$value}", true);
$manage_uid = $adminUser['uid'];
$manage_username = $adminUser['username'];
$manage[] = array("uid" => $manage_uid, "username" => $manage_username);
}
}
//选择条件
$sid = trim(MooGetGPC('sid', 'string', 'G'));
if (!empty($sid)) {
unset($condition);
$condition[] = " sid ={$sid} ";
}
// print_r($condition);
/*$startTime=MooGetGPC('startTime','string','G');
if(!empty($startTime)){
$starttimestamp=strtotime($startTime);
$condition[] = " dateline>='{$starttimestamp}'";
}*/
$endTime = MooGetGPC('endTime', 'string', 'G');
if (!empty($endTime)) {
$endtimestamp = strtotime($endTime . "+1 day");
$condition[] = " dateline<'{$endtimestamp}'";
}
$where = " where 1 ";
if (!empty($condition)) {
$condition_sql = implode(' and ', $condition);
$where .= " and {$condition_sql}";
} else {
$where .= "";
}
$sql = "SELECT count(id) AS c FROM {$GLOBALS['dbTablePre']}member_effectgrade {$where} ";
$remark_total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$total = $remark_total['c'];
$limit = 6;
$page = intval(MooGetGPC('page', 'integer', 'G'));
if ($page <= 0) {
$page = 1;
}
$page_total = max(1, ceil($total / $limit));
$page = min($page, $page_total);
$offset = ($page - 1) * $limit;
$sql = "SELECT id,sid,gid,remark,dateline FROM {$GLOBALS['dbTablePre']}member_effectgrade {$where} order by dateline desc LIMIT {$offset},{$limit}";
$remark_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
if (!empty($sid)) {
$title = "查看客服{$sid}的评语";
} else {
$title = '客服盘库评语';
}
$currenturl = "index.php?action=myuser&h=remark&sid={$sid}&groupid={$groupid}";
$page_links = multipage($total, $limit, $page, $currenturl);
if (in_array($GLOBALS['groupid'], $GLOBALS['admin_service_arr'])) {
$isAdmin = 1;
}
require_once adminTemplate('myuser_remark');
}
function get_search_condition($where = '')
{
$condition[] = $where;
$keyword = trim(MooGetGPC('keyword', 'string', 'G'));
$choose = MooGetGPC('choose', 'string', 'G');
$gender = MooGetGPC('gender', 'integer', 'G');
$province = MooGetGPC('province', 'integer', 'G');
$islock = MooGetGPC('islock', 'integer', 'G');
$age_start = MooGetGPC('age_start', 'integer', 'G');
$age_end = MooGetGPC('age_end', 'integer', 'G');
$effect_grade = MooGetGPC('effect_grade', 'G');
$regdate = MooGetGPC('regdate', 'string', 'G');
$endTime = MooGetGPC('end', 'string', 'G');
$startTime = MooGetGPC('start', 'string', 'G');
$isControl = MooGetGPC('isControl', 'string', 'G');
$isForcast = MooGetGPC('isForcast', 'string', 'G');
$cf = MooGetGPC('cf', 'string', 'G');
//可控预测的会员操作
$uidControlArr = array();
if ($isControl == 'yes') {
if (empty($cf)) {
$sql = "select uid from web_member_isControl where dateline>={$startTime} and dateline<{$endTime} and sid={$keyword} and flag=1";
} else {
$sql = "select uid from web_member_isControl where sid={$keyword} and flag=1";
}
$uidControlArr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
$uidlist = "";
$comma = "";
foreach ($uidControlArr as $v) {
$uidlist .= $comma . $v['uid'];
$comma = ",";
}
$condition[] = " m.uid in ({$uidlist})";
}
//可控预测的会员操作
$uidForcastArr = array();
if ($isForcast == 'yes') {
if (empty($cf)) {
$sql = "select uid from web_member_isControl where dateline>={$startTime} and dateline<{$endTime} and sid={$keyword} and isforcast=1";
} else {
$sql = "select uid from web_member_isControl where sid={$keyword} and isforcast=1";
}
$uidForcastArr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
$uidlist = "";
$comma = "";
foreach ($uidForcastArr as $v) {
$uidlist .= $comma . $v['uid'];
$comma = ",";
}
$condition[] = " m.uid in ({$uidlist})";
}
if (!empty($choose) && !empty($keyword)) {
if ($choose == 'username' || $choose == 'nickname') {
$condition[] = " m.{$choose} like '%{$keyword}%'";
} else {
$condition[] = " m.{$choose} = '{$keyword}'";
}
}
if ($gender == 2 || $gender == 1) {
if ($gender == 1) {
$condition[] = " m.gender='1'";
} else {
$condition[] = " m.gender='0'";
}
} elseif ($gender == 3) {
$condition[] = "m.gender>=0 and m.gender<=1 ";
}
if (!empty($province)) {
if ($province == '10101201' || $province == '10101002') {
$condition[] = " m.city='{$province}'";
} else {
$condition[] = " m.province='{$province}'";
}
}
if (!empty($islock)) {
if ($islock == 1) {
$condition[] = " m.is_lock='1'";
} else {
$condition[] = " m.is_lock='0'";
}
}
if ($age_start || $age_end) {
$age_start = $age_start ? $age_start : 0;
$age_end = $age_end ? $age_end : 100;
$age1 = min($age_start, $age_end);
$age2 = max($age_start, $age_end);
$age1 = date('Y') - $age1;
$age2 = date('Y') - $age2;
$condition[] = " m.birthyear >= {$age2}";
$condition[] = " m.birthyear <= {$age1}";
}
//当前在线1,2为一天，3为一周内，4为一周外
if (isset($_GET['online'])) {
$online = MooGetGPC('online', 'string', 'G');
switch ($online) {
case 1:
$time = time() - 100;
$condition[] = " ma.real_lastvisit>={$time}";
break;
case 2:
$time = time() - 24 * 3600;
$condition[] = " ma.real_lastvisit>={$time}";
break;
case 3:
$time1 = time() - 7 * 24 * 3600;
$time2 = time() - 24 * 3600;
$condition[] = " ma.real_lastvisit >= {$time1}";
$condition[] = " ma.real_lastvisit <= {$time2}";
break;
case 4:
$time = time() - 7 * 24 * 3600;
$condition[] = " ma.real_lastvisit <= {$time}";
break;
}
}
//所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$condition[] = " m.sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$condition[] = " m.sid IN({$myservice_idlist})";
}
//分类
if (!empty($effect_grade)) {
$condition[] = " ma.effect_grade ={$effect_grade}";
}
//分类 起始日期结束日期
if (empty($isControl) && empty($isForcast)) {
if ($endTime) {
$condition[] = " ma.dateline<'{$endTime}'";
}
}
if (empty($isControl) && empty($isForcast)) {
if ($startTime) {
$condition[] = " ma.dateline>'{$startTime}'";
}
}
//注册时间
if ($regdate) {
$regstamp = strtotime('+1 day', strtotime($regdate));
$regstampstart = strtotime('-9 day', strtotime($regdate));
$condition[] = " m.regdate>='{$regstampstart}' and m.regdate<='{$regstamp}'";
}
$result = implode(' AND ', $condition);
return $result;
}
function financial_member_grade_count()
{
global $_MooClass, $dbTablePre, $userid, $pagesize, $grade;
$page = max(1, MooGetGPC('page', 'integer', 'G'));
$limit = 20;
$offset = ($page - 1) * $limit;
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$condition[] = " sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$condition[] = " sid IN({$myservice_idlist})";
}
if ($_POST['start_time'] || $_POST['end_time']) {
$start_time = strtotime(trim(MooGetGPC('start_time', 'string', 'P')));
$end_time = strtotime(trim(MooGetGPC('end_time', 'string', 'P'))) + 86400;
if ($start_time) {
$condition[] = " dateline > {$start_time} ";
}
if ($end_time) {
if ($start_time && $end_time <= $start_time) {
$end_time = $start_time + 86400;
//结束时间小于开始时间，默认搜索一天
}
$condition[] = " dateline <= {$end_time} ";
}
}
if ($condition) {
$result = "where " . implode(' AND ', $condition);
}
$sql = "SELECT uid,sid,dateline,states FROM {$dbTablePre}change_grade {$result} order by dateline desc limit {$offset},{$limit}";
$total = getcount('change_grade', $result);
$currenturl = "index.php?action=financial&h=member_grade_count";
$pages = multipage($total, $limit, $page, $currenturl);
$con_info = $_MooClass['MooMySQL']->getAll($sql);
foreach ($con_info as $v) {
}
//print_r($con_info);
require adminTemplate('financial_member_grade_count');
}
function active_leer_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_leer') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
if (!empty($choose) && !empty($keyword)) {
$condition[] .= " {$choose} = '{$keyword}'";
}
}
$sql_where = '';
if (!empty($condition)) {
$sql_where = 'WHERE ' . implode(' AND ', $condition);
}
//note 查询语句
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}service_leer l LEFT JOIN {$GLOBALS['dbTablePre']}members_search m ON l.senduid=m.uid {$sql_where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT l.*,m.nickname as send_nickname, m.gender as send_gender FROM {$GLOBALS['dbTablePre']}service_leer l LEFT JOIN {$GLOBALS['dbTablePre']}members_search m ON l.senduid=m.uid {$sql_where} ORDER BY l.lid 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_search WHERE uid = '{$v[senduid]}'";
// $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_search WHERE uid = '{$v[receiveuid]}'";
// $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['receiveuid'],$receiveuids)){
$receiveuids[] = $v['receiveuid'];
}
}
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['receiveuid'], $receiveuids)) !== false){
isset($receive_user[$keys]['nickname']) && $user_arr[$k]['receive_nickname'] = $receive_user[$keys]['nickname'];
isset($receive_user[$keys]['gender']) && $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_leer', "{$GLOBALS['username']}查看秋波列表", $GLOBALS['adminid']);
require adminTemplate('active_leer_list');
}
function active_email_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[] = " a.dealstate = '1'";
//note 显示未处理过的
} else {
$condition[] = " a.dealstate = '0'";
}
}
//note 所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$condition[] = " a.sid IN({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
} else {
$condition[] = " a.sid IN({$myservice_idlist})";
}
//note 处理
if (isset($_GET['action']) && $_GET['action'] == 'active_email') {
$choose = MooGetGPC('choose', 'string');
$keyword = MooGetGPC('keyword', 'string');
if (!empty($choose) && !empty($keyword)) {
$condition[] = " {$choose} like '{$keyword}" . "%'";
}
}
// var_dump($condition);
$sql_where = '';
if (!empty($condition)) {
$sql_where = ' and ' . implode(' AND ', $condition);
}
//note 查询语句
//$sql = "SELECT COUNT(a.id) num FROM {$GLOBALS['dbTablePre']}admin_remark a ,{$GLOBALS['dbTablePre']}members_search m where a.title like '%会员给给你发消息了，请速查看。%' and SUBSTRING_INDEX(a.title,'会',1)=m.uid $sql_where";
//$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT COUNT(a.id) num FROM {$GLOBALS['dbTablePre']}admin_remark a where a.title like '%给您发消息了，请速查看。' {$sql_where}";
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$sql = "SELECT a.id as id,a.sid as sid,a.title as title,a.content as content,a.dateline as dateline ,a.dealstate as dealstate FROM {$GLOBALS['dbTablePre']}admin_remark a where (a.title like '%给您发消息了，请速查看。') {$sql_where} ORDER BY a.`dateline` DESC LIMIT {$offset},{$limit}";
//$sql = "SELECT a.id as id,a.sid as sid,a.title as title,a.content as content,a.dateline as dateline ,a.dealstate as dealstate,m.uid as uid,m.nickname as nickname FROM {$GLOBALS['dbTablePre']}admin_remark a , {$GLOBALS['dbTablePre']}members_search m where (a.title like '%给你发消息了，请速查看。%') and m.uid=SUBSTRING_INDEX(a.title,'会',1) $sql_where ORDER BY a.`dateline` DESC LIMIT {$offset},{$limit}";
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
//chuzx 获取客服用户名
$sids = array();
//保存sid
foreach ($user_arr as $k => $v) {
if (in_array($v['sid'], $sids)) {
continue;
}
$sids[] = $v['sid'];
}
if (!empty($sids)) {
$sql = "SELECT username FROM {$GLOBALS['dbTablePre']}admin_user WHERE uid IN (" . implode(',', $sids) . ")";
$names = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
/* $sql = "select uid,username from web_members_search";
$members=$GLOBALS['_MooClass']['MooMySQL']->getAll($sql); */
foreach ($user_arr as $k => $v) {
if (($keys = array_search($v['sid'], $sids)) !== false) {
$user_arr[$k]['username'] = $names[$keys]['username'];
}
if (preg_match("/\\d{5,9}/", $v['title'], $matches)) {
$user_arr[$k]['uid'] = $matches[0];
}
}
}
//end chuzx
//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";
echo $currenturl; */
$currenturl2 = $currenturl = "index.php?action=active_email&h=list&type={$type}&choose={$choose}&keyword={$keyword}";
$pages = multipage($total['num'], $limit, $page, $currenturl);
//note 跳转到某一页
$page_num = ceil($total['num'] / $limit);
require adminTemplate('active_email_list');
}
/**
* 登陆系统后组长，客服显示自己范围内的用户， 主管显示全部
* @param string $where 查询条件 组合语句
* @param string $keyword 查询条件
*/
function active_commission_loginlist($where, $keyword)
{
$member_arr = array();
//note 所管理的客服id列表
$myservice_idlist = get_myservice_idlist();
//note 所管理的用户列表
if (empty($myservice_idlist)) {
$sql = "select uid FROM {$GLOBALS['dbTablePre']}members_search WHERE sid IN ({$GLOBALS['adminid']})";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
$sql = "select uid FROM {$GLOBALS['dbTablePre']}members_search limit 100";
} else {
$sql = "select uid FROM {$GLOBALS['dbTablePre']}members_search WHERE sid IN ({$myservice_idlist})";
}
$members = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
foreach ($members as $v) {
$member_arr[] = $v['uid'];
}
$member_list = implode(",", $member_arr);
//note 组装sql语句
if (empty($member_list)) {
$where .= " AND other_contact_you IN (null)";
} else {
$where .= " AND other_contact_you IN ({$member_list})";
}
//note 返回客服查看用户范围
$return_arr = array();
$return_arr['where'] = $where;
$return_arr['members'] = $member_arr;
return $return_arr;
}
function check_voice()
{
$uid = MooGetGPC('uid', 'integer', 'P');
$usersid = MooGetGPC('usersid', 'string');
$pass = MooGetGPC('pass', 'integer');
if (empty($pass)) {
$sql_where = 'where b.toshoot_voice_check=1';
} else {
$sql_where = 'where b.toshoot_voice_check=2';
}
if (!empty($uid)) {
$sql_where .= " and b.uid='{$uid}'";
}
$myservice_idlist = get_myservice_idlist();
if (empty($myservice_idlist)) {
$sql_where .= " and a.sid ={$GLOBALS['adminid']}";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
if ($_REQUEST['usersid'] != "-1") {
$sql_where .= isset($_REQUEST['usersid']) ? " and a.sid='{$usersid}' " : '';
}
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user");
} else {
if ($_REQUEST['usersid'] != "-1") {
$sql_where .= ' and a.sid' . (isset($_REQUEST['usersid']) ? "={$usersid} " : " IN({$myservice_idlist}) ");
}
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user where uid in (" . $myservice_idlist . ")");
}
$sql = "select count(*) as c from {$GLOBALS['dbTablePre']}certification b left join {$GLOBALS['dbTablePre']}members_search a on a.uid=b.uid {$sql_where}";
$count = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
//分页
$page_per = 20;
$page = get_page();
$limit = 20;
$total = $count['c'];
$offset = ($page - 1) * $limit;
$myurl = explode('|', getUrl());
$myurl[1] = $myurl[1] . (isset($_REQUEST['usersid']) ? '&usersid=' . $usersid : '');
$page_links = multipage($total, $page_per, $page, $myurl[1]);
$sql = "select a.uid,a.nickname,a.gender,a.birthyear,a.sid,c.lastvisit,b.toshoot_voice_check,b.toshoot_voice_time from {$GLOBALS['dbTablePre']}certification b left join {$GLOBALS['dbTablePre']}members_search a on a.uid=b.uid left join {$GLOBALS['dbTablePre']}members_login as c on c.uid=b.uid {$sql_where} limit {$offset},20";
$check_voice = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
require_once adminTemplate('check_voice');
}
function active_uplink_list()
{
$condition = array();
$type = MooGetGPC('type', 'string', "G");
//if(isset($_GET['xx']) && !empty($_GET['xx'])) {
$choose = MooGetGPC('choose', 'string', "G");
$keyword = MooGetGPC('keyword', 'string', "G");
$startdate = MooGetGPC('startdate', 'string', "G");
$enddate = MooGetGPC('enddate', 'string', "G");
$starttime = strtotime($startdate);
$endtime = strtotime($enddate);
if (!empty($starttime)) {
$condition[] = "reptime>" . $starttime;
}
if (!empty($endtime)) {
$condition[] = "reptime<" . $endtime;
}
if (!empty($choose)) {
if (!empty($startdate) && !empty($enddate)) {
if (!empty($keyword)) {
$condition[] = $choose . "= " . $keyword;
}
}
}
//}
//note分页处理
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 15;
$offset = ($page - 1) * $limit;
//得到所属客服下的会员
$myservice_idlist = get_myservice_idlist();
$myservice_idlist = empty($myservice_idlist) ? 'all' : $myservice_idlist;
//计算总记录数
//note 所管理的用户列表
$adminid = $GLOBALS['adminid'];
if (empty($myservice_idlist)) {
$condition[] = "sid={$adminid}";
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
} else {
$condition[] = " sid in ({$myservice_idlist})";
}
$where = implode(" and ", $condition);
if (!empty($where)) {
$where = " where " . $where;
}
if (!empty($where)) {
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}uplinkcontent " . $where;
$sql_detail = "SELECT * FROM {$GLOBALS['dbTablePre']}uplinkcontent " . $where . " order by reptime desc LIMIT {$offset},{$limit}";
} else {
$sql = "SELECT COUNT(*) num FROM {$GLOBALS['dbTablePre']}uplinkcontent {$where}";
$sql_detail = "SELECT * FROM {$GLOBALS['dbTablePre']}uplinkcontent {$where} order by reptime desc LIMIT {$offset},{$limit}";
}
$total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql);
$user_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql_detail);
$currenturl = "index.php?action=active_uplink&h=list&choose={$choose}&keyword={$keyword}&startdate={$startdate}&enddate={$enddate}";
$currenturl = $currenturl . "&type={$type}";
$pages = multipage($total['num'], $limit, $page, $currenturl);
//note 跳转到某一页
$page_num = ceil($total['num'] / $limit);
//note 插入日志
serverlog(1, $GLOBALS['dbTablePre'] . 'servies', "{$GLOBALS['username']}查看会员上行列表", $GLOBALS['adminid']);
//note 载入模块
require adminTemplate('active_uplink_list');
}
/**
* 输出所有备注,后台右下角提醒
* @author:fanglin
* 可对组，所有客服，某个id客服提醒
*/
function ajax_remark()
{
$result = '';
$sid = MooGetGPC('sid', 'integer', 'G');
$type = MooGetGPC('type', 'string', 'G');
$time = time();
$myservice_idlist = get_myservice_idlist();
if ($type == 'timeover') {
//最近备注
if (empty($myservice_idlist) || $myservice_idlist === $GLOBALS['adminid']) {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE\n\t\t\t\t`status`='0' AND `awoketime`>='{$time}' AND (`sid`='{$GLOBALS['adminid']}') ORDER BY `awoketime` ASC limit 30";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1')
} elseif ($myservice_idlist == 'all') {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE\n\t\t\t\t`status`='0' AND `awoketime`>='{$time}' AND (`sid`='{$GLOBALS['adminid']}') ORDER BY `awoketime` ASC limit 30";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1')
} else {
if (!in_array($GLOBALS['groupid'], $GLOBALS['admin_userinfo_check']) && !in_array($GLOBALS['groupid'], $GLOBALS['admin_service_team'])) {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE\n\t\t\t\t`status`='0' AND `awoketime`>='{$time}' AND (`sid` in ({$myservice_idlist})) ORDER BY `awoketime` ASC limit 30";
//OR groupid='{$GLOBALS['groupid']}' OR groupid='-1')
} else {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE\n\t\t\t\t`status`='0' AND `awoketime`>='{$time}' AND (`sid`='{$GLOBALS['adminid']}') ORDER BY `awoketime` ASC limit 30";
//OR groupid='{$GLOBALS['groupid']}' OR groupid='-1')
}
}
$remark = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
} elseif ($type == 'notime') {
//备注
if (empty($myservice_idlist)) {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE \n\t\t\t\t `status`='0' AND `awoketime`='' AND flag>0 and (`sid`='{$GLOBALS['adminid']}') ORDER BY id desc limit 10";
//OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
} elseif ($myservice_idlist == 'all') {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE \n\t\t\t\t `status`='0' AND `awoketime`='' AND flag>0 and (`sid`='{$GLOBALS['adminid']}') \tORDER BY id desc limit 10";
//OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
} else {
if (!in_array($GLOBALS['groupid'], $GLOBALS['admin_userinfo_check']) && !in_array($GLOBALS['groupid'], $GLOBALS['admin_service_team'])) {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE \n\t\t\t\t`status`='0' AND `awoketime`='' AND flag>0 and (`sid` in ({$myservice_idlist})) ORDER BY id desc limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1')
} else {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE \n\t\t\t\t `status`='0' AND `awoketime`='' AND flag>0 and (`sid`='{$GLOBALS['adminid']}') ORDER BY id desc limit 10";
//OR groupid='{$GLOBALS['groupid']}' OR groupid='-1')
}
}
$remark = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
} elseif ($type == 'all') {
//所有备注
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE \n\t\t\t\t(`sid`='{$GLOBALS['adminid']}') AND status=0 ORDER BY id desc limit 50";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
$remark = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
}
$six_minute = time() - 300;
$sql = "select s_fromid from {$GLOBALS['dbTablePre']}service_chat where s_uid='{$GLOBALS['adminid']}' and s_status=0 and s_time>'{$six_minute}' GROUP BY s_fromid";
$chatmsg = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
//=============回电总数单独统计====================
if (empty($myservice_idlist) || $myservice_idlist === $GLOBALS['adminid']) {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE\n\t\t\t\t\t(`sid`='{$GLOBALS['adminid']}') AND `status`='0' AND `awoketime`>='{$time}' limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1' ORDER BY `awoketime` ASC";
} elseif ($myservice_idlist == 'all') {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE (`sid`='{$GLOBALS['adminid']}') AND `status`='0' AND `awoketime`>='{$time}' limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1' ORDER BY `awoketime` ASC";
} else {
if (!in_array($GLOBALS['groupid'], $GLOBALS['admin_userinfo_check']) && !in_array($GLOBALS['groupid'], $GLOBALS['admin_service_team'])) {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE\n\t\t\t\t\t`status`='0' AND `awoketime`>='{$time}' and (`sid` in ({$myservice_idlist})) limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1' ORDER BY `awoketime` ASC";
} else {
$sql = "SELECT id,sid,groupid,title,content,status,awoketime,dateline,dealstate,send_id,flag FROM {$GLOBALS['dbTablePre']}admin_remark WHERE\n\t\t\t\t\t(`sid`='{$GLOBALS['adminid']}') AND `status`='0' AND `awoketime`>='{$time}' limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
}
}
$remark_timeover = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
if (empty($myservice_idlist) || $myservice_idlist === $GLOBALS['adminid']) {
$sql = "SELECT id FROM {$GLOBALS['dbTablePre']}admin_remark WHERE (`sid`='{$GLOBALS['adminid']}') and flag>0 AND `status`='0' AND `awoketime`='' \tORDER BY id desc limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
} elseif ($myservice_idlist == 'all') {
$sql = "SELECT id FROM {$GLOBALS['dbTablePre']}admin_remark WHERE (`sid`='{$GLOBALS['adminid']}') and flag>0 AND `status`='0' AND `awoketime`='' ORDER BY id desc limit 10";
//OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
} else {
if (!in_array($GLOBALS['groupid'], $GLOBALS['admin_userinfo_check']) && !in_array($GLOBALS['groupid'], $GLOBALS['admin_service_team'])) {
$sql = "SELECT id FROM {$GLOBALS['dbTablePre']}admin_remark WHERE `status`='0' AND `awoketime`='' and flag>0 AND \n\t\t\t\t(`sid` in ({$myservice_idlist})) ORDER BY id desc limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
} else {
$sql = "SELECT id FROM {$GLOBALS['dbTablePre']}admin_remark WHERE (`sid`='{$GLOBALS['adminid']}') and flag>0 AND `status`='0' AND `awoketime`='' \tORDER BY id desc limit 10";
// OR groupid='{$GLOBALS['groupid']}' OR groupid='-1'
}
}
$remark_notime = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
if (count($remark_timeover) == 0 && empty($chatmsg) && count($remark_notime) == 0) {
echo 0;
exit;
}
if (!empty($chatmsg)) {
$result .= "<ul class=\"bgon\">";
foreach ($chatmsg as $msg) {
$result .= "<li><a href='index.php?n=chat&chatorid=" . $msg['s_fromid'] . "' target='_brank' onclick=\"javascript:\$(this).empty()\">客服ID:" . $msg['s_fromid'] . "发给你在线消息</a></li>";
}
$result .= "</ul>";
}
if (empty($remark)) {
$result .= "<p>您有<a href='#'>0条备注</a></p>";
} else {
$result .= "<ul class=\"remark\">";
foreach ($remark as $key => $arr) {
if ($arr['status'] == 0) {
$result .= "<li class=\"title state-{$arr['id']}\" onclick=\"showcontent(" . $key . ");\"><a href=\"javascript:deal(" . $arr['id'] . ")\" id=\"state-" . $arr['id'] . "\" style=\"float:right;\">未解决</a>";
} else {
$result .= "<li class=\"title\" onclick=\"showcontent(" . $key . ");\"><a href=\"javascript:aworke()\" style=\"float:right;\">已解决</a>";
}
if ($arr['title'] == '会员付款') {
$result .= $key + 1 . ".<span style='color:#ff0000;font-weight:bold;'>" . $arr['sid'] . ":" . MooCutstr($arr['title'], 20, "…") . "</span></li>";
} else {
$result .= $key + 1 . "." . $arr['sid'] . ":" . MooCutstr($arr['title'], 20, "…") . "</li>";
}
$result .= "<li class=\"content state-{$arr['id']}\" id=\"content-" . $key . "\">" . $arr['content'] . "</li>";
}
$result .= "</ul>";
}
/*if($type!='notime'){
$count=count($remark);
}elseif($type=='notime'){
$count=0;
}*/
$result .= "|最近备注(" . count($remark_timeover) . ")";
$result .= "|备注回电(" . count($remark_notime) . ")";
/*if ($type=='timeover'){
$result .= "|最近备注(".count($remark).")";
}elseif ($type=='notime'){
$result .= "|备注回电(".count($remark).")";
}*/
echo $result;
exit;
}
function allmember_fooquery()
{
$page_per = 10;
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 10;
$offset = ($page - 1) * $limit;
//得到所属客服下的
$myservice_idlist = get_myservice_idlist();
$listGroup = explode(',', $myservice_idlist);
//如果组长 ，列出成员表
//echo $myservice_idlist.'and'.$GLOBALS['adminid'];
$admin_userinfo_check = $GLOBALS['admin_userinfo_check'][0];
$sql = "select uid,username from web_admin_user where groupid = {$admin_userinfo_check}";
$name = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
//if(MooGetGPC('Dealsubmit','string','P')){
$deal = MooGetGPC('channel', 'integer', 'R');
$send_id = MooGetGPC('send_id', 'integer', 'R');
$sid = MooGetGPC('sid', 'integer', 'R');
$starttime = MooGetGPC('startdate', 'string', 'R');
$endtime = MooGetGPC('enddate', 'string', 'R');
$start_time = strtotime($starttime);
$end_time = strtotime($endtime + '+1 day');
$channel = MooGetGPC('channel', 'string', 'R');
//}
$isPost = MooGetGPC('Dealsubmit', 'string', 'P');
$page = MooGetGPC('page', 'string', 'R');
$total = 0;
$remark = array();
if (empty($myservice_idlist)) {
if ($isPost || $page) {
if ($send_id == 0) {
$where = " and status = '{$deal}' and dateline>='{$start_time}' and dateline<='{$end_time}'";
} else {
$where = " and status = '{$deal}' and dateline>='{$start_time}' and dateline<='{$end_time}' and send_id = '{$send_id}'";
}
$sql = "select count(id) as total from web_admin_remark where flag>0 {$where} and sid in ({$GLOBALS['adminid']})";
$num = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$total = $num['total'];
$sql = "select id,sid,title,content,dateline,status,flag from web_admin_remark where flag>0 {$where} and sid in ({$GLOBALS['adminid']}) limit {$offset},{$limit} ";
$remark = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
}
} elseif ($myservice_idlist == 'all') {
//all为客服主管能查看所有的
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user", 0, 0, 0, true);
if ($isPost || $page) {
if ($send_id == 0) {
$where = "and status = '{$deal}' and dateline>='{$start_time}' and dateline<='{$end_time}'";
} else {
$where = "and status = '{$deal}' and dateline>='{$start_time}' and dateline<='{$end_time}' and send_id = '{$send_id}'";
}
if ($sid > 0) {
$where = "and status = '{$deal}' and dateline>='{$start_time}' and dateline<='{$end_time}' and sid = '{$sid}'";
}
$sql = "select count(id) as num_1 from web_admin_remark where flag=1 {$where}";
$num_1 = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$sql = "select count(id) as num_2 from web_admin_remark where flag=2 {$where}";
$num_2 = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$sql = "select count(id) as num_3 from web_admin_remark where flag=3 {$where}";
$num_3 = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$total = $num_1['num_1'] + $num_2['num_2'] + $num_3['num_3'];
$sql = "select id,sid,title,content,dateline,status,flag from web_admin_remark where flag>0 {$where} limit {$offset},{$limit}";
$remark = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
}
} else {
//组长以上权限
$adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user where uid in ({$myservice_idlist})", 0, 0, 0, true);
if ($isPost || $page) {
if ($sid == 0) {
$where = "and status = '{$deal}' and dateline>='{$start_time}' and dateline<='{$end_time}' and sid in ({$myservice_idlist})";
} else {
$where = "and status = '{$deal}' and dateline>='{$start_time}' and dateline<='{$end_time}' and sid = '{$sid}'";
}
$sql = "select count(id) as num_1 from web_admin_remark where flag=1 {$where} ";
$num_1 = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$sql = "select count(id) as num_2 from web_admin_remark where flag=2 {$where} ";
$num_2 = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$sql = "select count(id) as num_3 from web_admin_remark where flag=3 {$where} ";
$num_3 = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true);
$total = $num_1['num_1'] + $num_2['num_2'] + $num_3['num_3'];
$sql = "select id,sid,title,content,dateline,status,flag from web_admin_remark where flag>0 {$where} limit {$offset},{$limit}";
$remark = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true);
}
}
$currenturl = "index.php?action=allmember&h=fooquery&startdate={$starttime}&enddate={$endtime}&channel={$channel}&send_id={$send_id}";
$pages = multipage($total, $page_per, $page, $currenturl);
$page_num = ceil($total / $limit);
$title = '400回电查询';
require_once adminTemplate('allmember_fooquery');
}
/**
* 红娘币奖赏查询
* @param integer $my
*/
function reward_log($my = 0)
{
global $str_;
$sid_user = "******";
$mange_list = array();
$page_per = 15;
$page = max(1, MooGetGPC('page', 'integer'));
$limit = 15;
$offset = ($page - 1) * $limit;
$start = MooGetGPC('start', 'string', 'G');
$end = MooGetGPC('end', 'string', 'G');
$uid = MooGetGPC('sid', 'integer', 'G');
$groupid = MooGetGPC('groupid', 'string', 'G');
if ($uid != "") {
$sql_s = "SELECT *FROM {$GLOBALS['dbTablePre']}admin_user WHERE uid=" . $uid;
$sid_u = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql_s);
$sid_user = $sid_u[0]['username'];
}
$where = $data = $ref = array();
$total = 0;
if ($groupid) {
//$mange_list=array();
$sql_ = "SELECT *FROM {$GLOBALS['dbTablePre']}admin_manage where id=" . $groupid;
//这个查询出用户的manage_list
$mange_list = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql_);
$man_id = $mange_list['manage_list'];
//查询到这组的id
$sql_user = "******" . $man_id . ")";
//这个查询用户的id名字
$mang_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql_user);
$group = get_group_type($groupid);
$where[] = "uid in (" . $man_id . ")";
$ref[] = 'groupid=' . $groupid;
}
$group_list = get_group_type();
$ins = rtrim($str_, ",");
if (!empty($start) || !empty($end)) {
if (!empty($start)) {
$ref[] = 'start=' . $start;
}
if (!empty($end)) {
$ref[] = 'end=' . $end;
}
if (!empty($start) && !empty($end)) {
$where[] = '`time` BETWEEN ' . strtotime($start) . ' AND ' . strtotime($end);
} else {
$time = empty($start) ? $end : $start;
$where[] = '`time` BETWEEN ' . strtotime($time) . ' AND ' . strtotime($time . ' 23:59:59');
}
}
if (!empty($uid)) {
$where[] = '`uid`=' . $uid;
$ref[] = 'sid=' . $uid;
}
$wheres = empty($where) ? '' : 'where ' . implode(' and ', $where);
$total = getcount('reward_log', $wheres);
$sql = 'SELECT `id`,`uid`,`adminid`,`amount`,`time`,`type` ,`rewardid` FROM `' . $GLOBALS['dbTablePre'] . 'reward_log` ' . $wheres . ' LIMIT ' . $offset . ',' . $limit;
$data = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql);
$myservice = get_myservice_idlist();
$myservices = $myservice == 'all' ? $GLOBALS['kefu_arr'] : explode(',', $myservice);
$currenturl = "index.php?action=matchmaker&h=" . $GLOBALS['h'] . (empty($ref) ? '' : '&' . implode('&', $ref)) . "&groupid=" . $groupid;
$pages = multipage($total, $limit, $page, $currenturl);
$page_num = ceil($total / $limit);
require_once adminTemplate('matchmaker_reward_log_list');
}
