function allmember_class() { global $allow_order, $rsort, $grade; $get = MooGetGPC('clear', 'integer', 'G'); $total = 0; $page_links = ''; $sort_arr = $member_list = array(); $currenturl = "index.php?action=allmember&h=class"; $currenturl1 = "index.php?action=allmember&h=class&clear=1"; //$condition = array(); //$condition['uid']=$condition['username']=$condition['nickname']=$condition['telphone']=$condition['sid'] = ''; $sql_where = 'where 1'; //获得参数 /* $effect_grade=MooGetGPC('effect_grade','integer','G'); $isControl=MooGetGPC('isControl','string','G'); $isForcast=MooGetGPC('isForcast','string','G'); $keyword=MooGetGPC('keyword','string','G'); $endTime=MooGetGPC('end','string','G'); $startTime=MooGetGPC('start','string','G'); */ //获取查询条件及语句 $where = get_search_condition(''); //if(!empty($keyword)) $where = $where." AND m.sid = $keyword"; $query_builder = get_query_builder($where, $allow_order, '', '', 'regdate', 'desc', $rsort); $where = $sql_where . $query_builder['where']; $sql_sort = $query_builder['sort']; $sort_arr = $query_builder['sort_arr']; $rsort_arr = $query_builder['rsort_arr']; $kefu_list = get_kefulist(); //分类会员 if ($get == 1) { $page_per = 20; $page = get_page(); $limit = 20; $total = get_allmember_count($where); $page_total = max(1, ceil($total / $limit)); $page = min($page, $page_total); $offset = ($page - 1) * $limit; //$offset = 0;//enky add $member_list = get_member_list($where, $sql_sort, "limit {$offset},{$page_per}"); //来源 if ($member_list) { foreach ($member_list as $key => $user) { if (preg_match_all("/(wf=\\w+)&?|(st=\\w+)&?/i", $user['source'], $matches)) { $member_list[$key]['source'] = $matches[1][0] . "<br />" . $matches[2][1]; } } } // echo $url = "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']; $currenturl = "index.php?action=allmember&h=class"; //$currenturl1 = "index.php?action=allmember&h=class&clear=1"; $currenturl1 = "index.php?action=allmember&h=class&clear=1&effect_grade={$effect_grade}&keyword={$keyword}&end={$endTime}&start={$startTime}"; $page_links = multipage($total, $page_per, $page, $currenturl1); $age_arr = array(); for ($i = 18; $i < 100; $i++) { $age_arr[] = $i; } //获取本次查询条件 $condition = get_condition($where); } $title = '分类会员列表'; require_once adminTemplate('allmember_general'); }
function other_complaint_box() { global $_MooClass, $dbTablePre, $_MooCookie, $areaid_arr, $foreground, $background, $accept_arr, $status_arr, $kefu_arr, $adminid, $groupname; $type = MooGetGPC('type', 'string', 'G'); $type = $type ? $type : 'list'; $allow_type = array('list', 'show', 'submit', 'del'); if (!in_array($type, $allow_type)) { salert('没有该操作', 'index.php?action=other&h=complaint_box'); } switch ($type) { case 'list': $page = get_page(); $starttime = MooGetGPC('starttime', 'string', 'G'); $endtime = MooGetGPC('endtime', 'string', 'G'); $uid = MooGetGPC('uid', 'integer', 'G'); $condition = array('module' => MooGetGPC('module', 'integer', 'G'), 'areaid' => MooGetGPC('areaid', 'integer', 'G'), 'status' => MooGetGPC('status', 'integer', 'G'), 'accept' => MooGetGPC('accept', 'integer', 'G')); //意见 $sql = "select * from {$dbTablePre}complaint_box "; //意见数量 $sql_count = "select count(1) as count from {$dbTablePre}complaint_box "; $sql_where = ""; $n = 0; $field = MooGetGPC('field', 'string', 'G'); $value = MooGetGPC('value', 'string', 'G'); //提交者查询 $where = array(); if ($field == 'uid' && $value) { foreach ($kefu_arr as $key => $val) { if ($value == $val) { $isuid = $key; break; } } $where[] = "uid = '{$isuid}'"; } //意见ID查询 if ($field == 'cid' && $value) { $where[] = "cid = '{$value}'"; } //模块及处理结果 foreach ($condition as $key => $val) { if (isset($_GET[$key]) && $val >= 0) { $where[] = "`{$key}` = '{$val}'"; } } //时间条件 if ($starttime) { $starttime = strtotime($starttime); $where[] = "submittime >= '{$starttime}'"; $n++; } if ($endtime) { $endtime = strtotime($endtime); $where[] = "submittime <= '{$endtime}'"; } $sql_where = implode(' and ', $where); //所有排序方式 $allow_order = array('submittime' => '提交时间', 'replaytime' => '回复时间', 'areaid' => '反馈区域', 'status' => '处理结果', 'accept' => '是否采纳', 'cid' => '意见ID'); //获取查询条件,及排序方式 $query_builder = get_query_builder($sql_where, $allow_order, 'accept', 0, 'submittime', 'desc', array(), 1); $sql_where = 'where ' . $query_builder['where']; $sql_order = $query_builder['sort']; $sort_arr = $query_builder['sort_arr']; $rsort_arr = $query_builder['rsort_arr']; //获取意见数量 $total = $_MooClass['MooMySQL']->getOne($sql_count . $sql_where); $total = $total['count']; //分页显示 $limit = 15; $offset = ($page - 1) * $limit; $sql_where .= "{$sql_order} limit {$offset}, {$limit}"; $complaint = array(); $complaint = $_MooClass['MooMySQL']->getAll($sql . $sql_where); //echo $sql.$sql_where; $currenturl = "index.php?" . $_SERVER['QUERY_STRING']; include_once adminTemplate('other_complaint_list'); break; case 'show': $cid = MooGetGPC('cid', 'integer', 'G'); if ($cid) { $sql = "select * from {$dbTablePre}complaint_box where cid = '{$cid}'"; $complaint = $_MooClass['MooMySQL']->getOne($sql); $lei = '查看意见反馈'; } else { $lei = '意见反馈提交'; } include_once adminTemplate('check_show'); break; case 'submit': //提交 $cid = MooGetGPC('cid', 'integer', 'P'); $replay = MooGetGPC('replay', 'string', 'P'); $accept = MooGetGPC('accept', 'integer', 'P'); $status = MooGetGPC('status', 'integer', 'P'); $module = MooGetGPC('module', 'integer', 'P'); $uid = MooGetGPC('uid', 'integer', 'P'); $areaid = MooGetGPC('areaid', 'ingeter', 'P'); $content = MooGetGPC('content', 'string', 'P'); $complaint = MooGetGPC('complaint', 'string', 'P'); if ($cid) { if ($complaint == '回复') { $time = time(); $sql = "update {$dbTablePre}complaint_box set `replay` = '{$replay}', `accept` = '{$accept}', `status` = '{$status}', replaytime = '{$time}' where cid = {$cid}"; $_MooClass['MooMySQL']->query($sql); salert("回复成功", "index.php?action=other&h=complaint_box&type=list"); } else { if ($adminid == $uid) { $timetype = 'submittime'; } else { $timetype = 'replaytime'; } $sql = "update {$dbTablePre}complaint_box set content = '{$content}', `replay` = '{$replay}', `accept` = '{$accept}', `status` = '{$status}', {$timetype} = '{$time}' where cid = {$cid}"; $_MooClass['MooMySQL']->query($sql); salert("修改成功", "index.php?action=other&h=complaint_box&type=show&cid={$cid}"); } } else { $time = time(); $sql = "insert into {$dbTablePre}complaint_box(uid, areaid, `module`, content, submittime) values('{$adminid}', '{$areaid}', '{$module}', '{$content}', '{$time}')"; $_MooClass['MooMySQL']->query($sql); $cid = $_MooClass['MooMySQL']->insertId(); salert("发表成功", "index.php?action=other&h=complaint_box&type=list"); } break; case 'del': $cid = MooGetGPC('cid', 'integer', 'G'); $sql = "delete from {$dbTablePre}complaint_box where cid = '{$cid}'"; $_MooClass['MooMySQL']->query($sql); salert("删除成功", "index.php?action=other&h=complaint_box&type=list"); break; } }
function check_image() { global $_MooClass, $dbTablePre, $allow_order, $rsort; $sid = $GLOBALS['adminid']; $type = MooGetGPC('type', 'string', 'R') == '' ? 'list' : MooGetGPC('type', 'string', 'R'); $lei = "会员相册图片审核"; $uid = MooGetGPC('uid', 'integer', 'R'); $usersid = MooGetGPC('usersid', 'string', 'R'); //makui $id = MooGetGPC('id', 'integer', 'R'); $checkArr = array(1 => '审核通过', 0 => '未审核'); switch ($type) { //相册列表 case 'list': //note 获得当前url $pass = MooGetGPC('pass', 'integer', 'R'); $page = get_page(); $prepage = 20; $start = ($page - 1) * $prepage; $sql_where = ''; $usersid = MooGetGPC('usersid', 'string', 'R'); if ($usersid === null) { $usersid = -1; } else { $usersid = intval($usersid); } $myservice_idlist = get_myservice_idlist(); if (empty($myservice_idlist) || $myservice_idlist === $GLOBALS['adminid']) { $sql_where = " AND b.sid ={$GLOBALS['adminid']}"; //$sql_where = " AND b.sid IN({$GLOBALS['adminid']})"; } elseif ($myservice_idlist == 'all') { //all为客服主管能查看所有的 $adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user", 0, 0, 0, true); //if(isset($_GET['usersid'])){$sql_where=" AND b.sid='$usersid'";} if ($usersid >= 0) { $sql_where = " AND b.sid='{$usersid}'"; $start = 0; //重新选择客服,刷新 } } else { $adminUser = $GLOBALS['_MooClass']['MooMySQL']->getAll("select uid,username from web_admin_user where uid in ({$myservice_idlist}) ", 0, 0, 0, true); $sql_where = " AND b.sid IN({$myservice_idlist}) "; //if(isset($_GET['usersid'])){$sql_where .=" AND b.sid='$usersid'";} if ($usersid >= 0) { $sql_where .= " AND b.sid='{$usersid}'"; $start = 0; //重新选择客服,刷新 } } $currenturl = "index.php?action=check&h=image&pass={$pass}"; //$currenturl2 = preg_replace("/(&page=\d+)/","",$currenturl); $currenturl2 = preg_replace("/(&pass=\\d+)/", "", $currenturl) . "&pass={$pass}"; $currenturl2 = preg_replace("/(&sid=\\d+)/", '', $currenturl2); if (!empty($uid)) { $sql_where = ''; $start = 0; $sql_where .= " AND b.uid=" . $uid; $usersid = -1; } else { $sql_where .= " AND a.syscheck=" . $pass; } if ($usersid >= 0) { $currenturl2 = $currenturl2 . "&usersid={$usersid}"; } //排序 $query_builder = get_query_builder($sql_where, $allow_order, '', '', 'pic_date', 'asc', $rsort); $sort_arr = $query_builder['sort_arr']; $rsort_arr = $query_builder['rsort_arr']; $sql_sort = $query_builder['sort']; $order = MooGetGPC('order', 'string', 'R'); $method = MooGetGPC('method', 'string', 'R'); if (!empty($order) && !empty($method)) { $sql_sort = "order by {$order} {$method} "; $currenturl2 .= "&order={$order}&method={$method}"; } $sql_sort = str_replace("pic_date", "a.pic_date", $sql_sort); $sql_sort = str_replace("uid", "a.uid", $sql_sort); $currentur = $currenturl2; if (strpos($sql_where, 'b.') === false) { $sql_count = "SELECT count(1) as c FROM {$GLOBALS['dbTablePre']}pic AS a WHERE 1 {$sql_where}"; $sql = "SELECT a.imgid FROM {$GLOBALS['dbTablePre']}pic AS a left join {$GLOBALS['dbTablePre']}members_login AS d on d.uid=a.uid WHERE 1 {$sql_where} LIMIT {$start},{$prepage} "; //ORDER BY d.lastvisit DESC } else { $sql_count = "SELECT count(1) as c FROM {$GLOBALS['dbTablePre']}pic AS a left JOIN {$GLOBALS['dbTablePre']}members_search AS b on a.uid=b.uid WHERE 1 {$sql_where}"; $sql = "SELECT a.imgid FROM {$GLOBALS['dbTablePre']}pic AS a left JOIN {$GLOBALS['dbTablePre']}members_search AS b on a.uid=b.uid left join {$GLOBALS['dbTablePre']}members_login AS d on d.uid=b.uid WHERE 1 {$sql_where} LIMIT {$start},{$prepage} "; //ORDER BY d.lastvisit ASC } $total_count = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql_count, true); $total = $total_count['c']; $list_imgid = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true); $list = array(); if (!empty($list_imgid)) { $imgids = array(); foreach ($list_imgid as $img) { $imgids[] = $img['imgid']; } $sql = "SELECT a.uid,a.imgid as id,a.syscheck AS syscheck,b.nickname,b.birthyear,b.sid as sid,b.gender,c.allotdate,d.lastvisit FROM {$GLOBALS['dbTablePre']}pic AS a left JOIN {$GLOBALS['dbTablePre']}members_search AS b on a.uid=b.uid left join {$GLOBALS['dbTablePre']}members_base AS c on c.uid=b.uid left join {$GLOBALS['dbTablePre']}members_login AS d on d.uid=c.uid WHERE a.imgid in (" . implode(',', $imgids) . ") {$sql_sort}"; $list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true); //获取图片的上传日期 foreach ($list as $key => $val) { $uidpic = $val['id']; $sql = "select pic_date from web_pic where imgid='{$uidpic}'"; $resultpic = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql); if (!empty($resultpic)) { $picdate = date('Y-m-d', strtotime($resultpic['pic_date'])); $list[$key]['pic_date'] = $picdate; } else { $list[$key]['pic_date'] = null; } } } require adminTemplate("check_list"); break; //会员相册查看222 //会员相册查看222 case 'show': $pass = MooGetGPC('pass', 'integer', 'G'); $usersid = MooGetGPC('usersid', 'integer', 'R'); $page = MooGetGPC('page', 'integer', 'G'); //获取待审核列表 if (!$images) { $images = $GLOBALS['_MooClass']['MooMySQL']->getAll("SELECT a.*,b.birthyear,b.gender,c.mainimg FROM {$GLOBALS['dbTablePre']}pic as a join {$GLOBALS['dbTablePre']}members_search as b on a.uid=b.uid left join {$GLOBALS['dbTablePre']}members_base as c on b.uid=c.uid WHERE a.uid='{$uid}' and a.syscheck={$pass}"); } //取出待审核照片 $image = count($images) > 0 ? $images[0] : array(); $id = isset($image['imgid']) ? $image['imgid'] : ''; //==========页面返回url=====取值================================ $url = "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $url = preg_replace("/www./", "", $url); $url = preg_replace("/show/", "list", $url); //返回列表页 $url = preg_replace("/&uid=\\d+/", "", $url); serverlog(1, $dbTablePre . "pic", $GLOBALS['username'] . "查询会员相册", $GLOBALS['adminid']); require adminTemplate("check_show"); break; //审核 //审核 case 'submit': $is_pass = MooGetGPC('pass', 'string'); $is_onpass = MooGetGPC('nopass', 'string'); $uid = MooGetGPC('uid', 'integer', 'P'); if ($is_onpass) { $imagesname = MooGetGPC('imagesname', 'string'); $pic_date = MooGetGPC('pic_date', 'string'); $imagessrc1 = "../data/upload/images/photo/" . $pic_date . "/orgin/" . $imagesname; $GLOBALS['_MooClass']['MooMySQL']->query("DELETE FROM {$GLOBALS['dbTablePre']}pic WHERE `imgid`='{$id}'"); if (file_exists(".." . thumbImgPath("1", $pic_date, $imagesname))) { unlink(".." . thumbImgPath("1", $pic_date, $imagesname)); } if (file_exists(".." . thumbImgPath("2", $pic_date, $imagesname))) { unlink("../" . thumbImgPath("2", $pic_date, $imagesname)); } if (file_exists(".." . thumbImgPath("3", $pic_date, $imagesname))) { unlink(".." . thumbImgPath("3", $pic_date, $imagesname)); } if (file_exists($imagessrc1)) { unlink($imagessrc1); } serverlog(2, $dbTablePre . "pic", $GLOBALS['username'] . "未通过用户的图片" . $id, $GLOBALS['adminid'], $uid); sendusermessage($uid, "您的图片不符合图片要求,已被红娘删除,请您按要求进行操作", "图片审核"); //salert('审核图片删除成功'); $alert = '审核图片删除成功'; } elseif ($is_pass) { //用户相册图片总数加1 $sql = "SELECT COUNT(*) AS num FROM {$GLOBALS['dbTablePre']}pic WHERE syscheck=1 and isimage='0' and uid='{$uid}'"; $pic_count = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql); $pc = $pic_count['num'] + 1; $sql = "update {$GLOBALS['dbTablePre']}members_search set pic_num='{$pc}' where uid='{$uid}'"; $GLOBALS['_MooClass']['MooMySQL']->query($sql); searchApi('members_man members_women')->updateAttr(array('pic_num'), array($uid => array((int) $pc))); if (MOOPHP_ALLOW_FASTDB) { $value['pic_num'] = $pc; MooFastdbUpdate('members_search', 'uid', $uid, $value); } $GLOBALS['_MooClass']['MooMySQL']->query("UPDATE {$GLOBALS['dbTablePre']}pic SET `syscheck`=1 WHERE `imgid`='{$id}'"); serverlog(3, $dbTablePre . "pic", $GLOBALS['username'] . "通过用户的图片" . $id, $GLOBALS['adminid'], $uid); sendusermessage($uid, "您的图片已经过红娘的审核,您还可以继续上传您的照片", "图片审核"); //salert('审核图片成功'); $alert = '审核图片成功'; } //enky add if (!$images) { $images = $GLOBALS['_MooClass']['MooMySQL']->getAll("SELECT a.*,b.birthyear,b.gender,c.mainimg FROM {$GLOBALS['dbTablePre']}pic as a join {$GLOBALS['dbTablePre']}members_search as b on a.uid=b.uid left join {$GLOBALS['dbTablePre']}members_base as c on b.uid=c.uid WHERE a.uid='{$uid}' and a.syscheck=0"); } $image = count($images) > 0 ? $images[0] : array(); $id = isset($image['imgid']) ? $image['imgid'] : ''; //enky add end if ($images) { $url = 'index.php?action=check&h=image&type=show&id=' . $image['imgid'] . "&usersid={$usersid}" . "&uid={$uid}"; } else { /* $url = "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']; $url=preg_replace("/www./","",$url); $url=preg_replace("/submit/", "list", $url); $url=preg_replace("/&uid=\d+/", "", $url); //$url=preg_replace("/&usersid=\d+/", "", $url); $url .="&pass=0"; */ $url = "index.php?action=check&h=image&type=list&usersid={$usersid}&pass=0"; } $imgkey = $images ? 1 : 0; setcookie('images', $imgkey); salert($alert, $url); break; } }
function site_recommend_diamond_district() { //允许的排序方式 $allow_order = array('s.gender' => '性别', 's.birthyear' => '年龄', 'd.mainimg' => '形象照', 's.images_ischeck' => '形象照是否审核', 's.bgtime' => '升级开始时间', 's.endtime' => '升级结束时间'); $rsort = ''; $page_per = 10; $page = intval(max(1, MooGetGPC('page', 'integer'))); $limit = 10; $offset = ($page - 1) * $limit; //url get 取变量值 $province = MooGetGPC('workprovince', 'integer', 'G'); $city = MooGetGPC('workcity', 'integer', 'G'); $startdate = MooGetGPC('startdate', 'string', 'G'); $enddate = MooGetGPC('enddate', 'string', 'G'); $uid = MooGetGPC('uid', 'integer', 'G'); $isindex = MooGetGPC('isindex', 'integer', 'G'); //如果直接提交表单查询 if ($_POST) { $province = MooGetGPC('workprovince', 'integer', 'P'); $city = MooGetGPC('workcity', 'integer', 'P'); $startdate = MooGetGPC('startdate', 'string', 'P'); $enddate = MooGetGPC('enddate', 'string', 'P'); $uid = MooGetGPC('uid', 'integer', 'P'); $isindex = MooGetGPC('isindex', 'integer', 'P'); } //note 修正广东省深圳和广州的区域查询 if (in_array($province, array(10101201, 10101002))) { $city = $province; $province = 10101000; } //修正直辖市查询 if (in_array($province, array('10102000', '10103000', '10104000', '10105000'))) { $city = '0'; } $sql_where = ''; $where = $whereturl = array(); if (!empty($startdate)) { $where[] = 's.bgtime>=' . strtotime($startdate); $whereturl[] = 'startdate=' . $startdate; } if (!empty($enddate)) { $where[] = 's.endtime<=' . strtotime($enddate); $whereturl[] = 'enddate=' . $enddate; } if (!empty($province)) { $where[] = 's.province=' . $province; $whereturl[] = 'workprovince=' . $province; } if (!empty($city)) { $where[] = 's.city=' . $city; $whereturl[] = 'workcity=' . $city; } if (!empty($isindex)) { $where[] = 'd.isindex=1'; $whereturl[] = 'isindex=1'; } if (!empty($uid)) { $where[] = 'uid=' . $uid; } $sql_where = empty($where) ? '' : 'where ' . implode(' and ', $where); //条件组合 $query_builder = get_query_builder($sql_where, $allow_order, '', '', '', '', $rsort); $sql_sort = $query_builder['sort']; $sort_arr = $query_builder['sort_arr']; $rsort_arr = $query_builder['rsort_arr']; $sort = MooGetGPC('sql_sort', 'string', 'G'); if (!empty($sort)) { $sql_sort = $sort; } $currenturl = 'index.php?action=site_recommend_diamond&h=district&' . implode('&', $whereturl) . "&sql_sort={$sql_sort}"; /* $sort=MooGetGPC('sql_sort','string','G'); if(!empty($sort)){ $currenturl='index.php?action=site_recommend_diamond&h=district&'.implode('&', $whereturl)."&sql_sort={$sql_sort}"; } */ $sql = "SELECT COUNT(d.uid) AS COUNT FROM web_diamond_recommend as d left join web_members_search as s on d.uid=s.uid {$sql_where}"; $result = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true); $total = $result['COUNT']; $sql = "select d.uid,d.username,d.nickname,s.gender,d.mainimg,s.images_ischeck,s.birthyear,s.bgtime,s.endtime,s.province,s.city,d.isindex,d.sort from web_diamond_recommend as d left join web_members_search as s on d.uid=s.uid {$sql_where} {$sql_sort} LIMIT {$offset},{$limit} "; $list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql, 0, 0, 0, true); $comment = array(); foreach ($list as $key => $value) { $value['bgtime'] = date('Y-m-d', $value['bgtime']); $value['endtime'] = date('Y-m-d', $value['endtime']); $value['k'] = $key + 1; $comment[] = $value; } $pages = multipage($total, $page_per, $page, $currenturl); $page_num = ceil($total / $limit); require_once adminTemplate('site_recommend_diamond_district'); }
function myuser_goonlist() { //global $allow_order, $rsort; $where = $link = ''; //允许的排序方式 $allow_order = array('uid' => 'ID', 'birthyear' => '年龄', 'effect_grade' => '类', 'images_ischeck' => '照片', 'salary' => '收入', 'allotdate' => '分配时间', 'regdate' => '注册时间', 'next_contact_time' => '下次联系时间', 'usertype' => '会员类型', 'login_meb' => '登陆次数', 'sid' => '工号/客服', 'is_lock' => '是否锁定'); //需要修正的排序 $rsort = array('birthyear' => 1); $condition = ''; //提交删除 if (isset($_POST['submit'])) { $id = $_POST['changesid']; foreach ($id as $uid) { $sql = "delete from {$GLOBALS['dbTablePre']}member_goon where uid='{$uid}'"; $GLOBALS['_MooClass']['MooMySQL']->query($sql); } } $userid = $_GET['usersid']; //客服访问权限 $myservice_idlist = get_myservice_idlist(); if (empty($myservice_idlist)) { $condition .= " m.sid IN({$GLOBALS['adminid']}) "; } elseif ($myservice_idlist == 'all') { if (isset($userid)) { $condition .= " g.uid={$userid}"; } //all为客服主管能查看所有的 } else { $condition .= " m.sid IN({$myservice_idlist}) "; if (isset($userid)) { $condition .= " g.uid={$userid}"; } } //选择条件 $keyword = trim(MooGetGPC('keyword', 'string', 'G')); $choose = MooGetGPC('choose', 'string', 'G'); if ($condition) { if (!empty($choose) && !empty($keyword)) { $condition = " and m.{$choose} ='{$keyword}'"; } } else { if (!empty($choose) && !empty($keyword)) { $condition = " m.{$choose} ='{$keyword}'"; } } if ($condition) { $where = " where {$condition}"; } //条件组合 $query_builder = get_query_builder($where, $allow_order, '', '', '', '', $rsort); $sql_sort = $query_builder['sort']; $sort_arr = $query_builder['sort_arr']; $rsort_arr = $query_builder['rsort_arr']; $sql = "SELECT count(id) AS c FROM {$GLOBALS['dbTablePre']}member_goon g \n LEFT JOIN {$GLOBALS['dbTablePre']}members_search m\n ON g.uid=m.uid\n {$where} "; $members_total = $GLOBALS['_MooClass']['MooMySQL']->getOne($sql, true); $total = $members_total['c']; $page_per = 12; $limit = 12; if (isset($_GET['page_per'])) { $page_per = intval(MooGetGPC('page_per', 'integer', 'G')); $limit = $page_per; $link = "&page_per={$page_per}"; } $page = get_page(); $page_total = max(1, ceil($total / $limit)); $page = min($page, $page_total); $offset = ($page - 1) * $limit; $sql_get_goonids = "SELECT g.uid,g.effect_grade as effect_grade,g.next_contact_time as next_contact_time \n \t\tFROM {$GLOBALS['dbTablePre']}member_goon g \n LEFT JOIN {$GLOBALS['dbTablePre']}members_search m on g.uid=m.uid\n LEFT JOIN {$GLOBALS['dbTablePre']}members_base as b ON g.uid=b.uid\n {$where} {$sql_sort} LIMIT {$offset},{$limit}"; /* $sql_get_goonids= "SELECT uid,effect_grade,next_contact_time FROM {$GLOBALS['dbTablePre']}member_goon g $where {$sql_sort} LIMIT {$offset},{$limit} "; */ $goonid_res_arr = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql_get_goonids, 0, 0, 0, true); if ($goonid_res_arr) { $save_goon_id = array(); for ($i = 0; $i < 12; $i++) { if ($goonid_res_arr[$i]['uid'] != null) { $save_goon_id[] = $goonid_res_arr[$i]['uid']; } } $goonids_str = implode(',', $save_goon_id); $sql_get_sb = "select * from {$GLOBALS['dbTablePre']}members_search s\n\t left join {$GLOBALS['dbTablePre']}members_base b on s.uid=b.uid \n\t where s.uid in (" . $goonids_str . ")"; $sb_res = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql_get_sb, 0, 0, 0, true); //merge $count_goonres = count($goonid_res_arr); $merge_all_arr = array(); for ($i = 0; $i < $count_goonres; $i++) { if (!empty($sb_res[$i])) { $merge_all_arr[] = array_merge($goonid_res_arr[$i], $sb_res[$i]); } } $member_list = $merge_all_arr; } /*else{ return true; }*/ //$member_list = $GLOBALS['_MooClass']['MooMySQL']->getAll($sql); $page_links = $currenturl = null; $currenturl = "index.php?action=myuser&h=goon_list" . $link . "&keyword={$keyword}&choose={$choose}"; if (!empty($member_list)) { $page_links = multipage($total, $page_per, $page, $currenturl); } //add end $title = '重点跟进的会员'; require_once adminTemplate('myuser_goonlist'); }