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'); }
//未分配 $consultant = intval($_GET['consultant']); if ($consultant == "0") { $wheresql .= " AND m.consultant=0"; } elseif ($consultant == "1") { $wheresql .= " AND m.consultant != 0"; } } } $joinsql = " LEFT JOIN " . table('company_profile') . " as c ON m.uid=c.uid "; $total_sql = "SELECT COUNT(*) AS num FROM " . table('members') . " as m " . $joinsql . $wheresql; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $member = get_member_list($offset, $perpage, $joinsql . $wheresql . $oederbysql); $smarty->assign('pageheader', "企业会员"); $smarty->assign('member', $member); $smarty->assign('page', $page->show(3)); $smarty->display('company/admin_company_user_list.htm'); } elseif ($act == 'delete_user') { check_token(); check_permissions($_SESSION['admin_purview'], "com_user_del"); $tuid = !empty($_REQUEST['tuid']) ? $_REQUEST['tuid'] : adminmsg("你没有选择会员!", 1); if ($_POST['delete']) { if (!empty($_POST['delete_user'])) { !delete_company_user($tuid) ? adminmsg("删除会员失败!", 0) : ""; } if (!empty($_POST['delete_company'])) { !del_company($tuid) ? adminmsg("删除企业资料失败!", 0) : ""; }
function sphinx_search($filters, $limits, $sorts) { if (isset($filters['uid'])) { return array('total' => 0); } if ($limits[0] + $limits[1] >= 1000) { return array('total' => 0); } $allow_sorts = array('uid', 'birthyear', 'images_ischeck', 'regdate', 'sid', 'is_lock'); $sort = ''; if (!empty($sorts)) { $sort = str_replace('order by ', '', $sorts); $sort_arr = explode(' ', trim($sort)); if (!in_array($sort_arr[0], $allow_sorts)) { return array('total' => 0); } $sort = str_replace('uid', '@id', $sort); } $filter = array(); $index = !isset($filters['gender']) || $filters['gender'] == 3 ? 'members_women members_man' : ($filters['gender'] == 1 ? 'members_women' : 'members_man'); unset($filters['gender']); foreach ($filters as $key => $value) { if (strpos($key, 'in') && strpos($key, '(')) { list($key, $value) = explode('in', $key); $key = trim($key); $value = str_replace(',', '|', str_replace(array('(', ')'), '', $value)); $filter[] = array($key, $value); } else { $filter[] = array($key, $value); } } //过滤记忆uid if (isset($_GET['h']) && isset($_GET['action'])) { $remember_adminid = in_array($GLOBALS['groupid'], $GLOBALS['admin_service_arr']) ? '0' : $GLOBALS['adminid']; $uids = sphinx_remember_uids($_GET['action'] . '_' . $_GET['h'] . '_' . $remember_adminid); if (!empty($uids)) { $filter[] = array('@id', implode('|', $uids), true); } } //exit; $sp = searchApi($index); $sp->setQueryType(true); $sp->getResultOfReset($filter, $limits, $sort); $total = $sp->getRs('total_found'); $member_list = array(); if ($total > 0 && ($uids = $sp->getIds())) { $where = 'where m.uid in (' . implode(',', $uids) . ')'; $member_list = get_member_list($where, $sorts); } return array('total' => $total, 'member_list' => $member_list); }