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);
}
