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 myuser_high_member() { $page_per = 20; $page = get_page(); $limit = 20; $offset = ($page - 1) * $limit; $where = get_search_condition(''); $allow_order = array('uid' => 'ID', 'birthyear' => '年龄', 'salary' => '收入', 'allotdate' => '分配时间', 'lastvisit' => '最后登陆时间', 'login_meb' => '登录次数', 'regdate' => '注册时间', 'last_login_time' => '最后登录时间', 'next_contact_time' => '下次联系时间', 'real_lastvisit' => '在线状态'); $update_arr['birthyear'] = 1; $query_builder = get_query_builder($where, $allow_order, '', '', 'lastvisit', 'desc', $update_arr); $where = $query_builder['where']; $sql_sort = $query_builder['sort']; $sort_arr = $query_builder['sort_arr']; $rsort_arr = $query_builder['rsort_arr']; $sql_where = " WHERE s_cid in (20, 30)"; $where = $sql_where . $where; $total = get_myuser_count($where); $member_list = get_myuser_list($where, $sql_sort, "LIMIT {$offset},{$limit}"); //来源 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 "<pre>"; // print_r($member_list);die; //当前在线会员 //$online_member_total = get_online_member_total($sql_where);old $online_member_total = MooUserIsOnlineNum(); //note 获取分页链接 $currenturl = "index.php?action=myuser&h=high_member"; $page_links = multipage($total, $page_per, $page, $currenturl); $title = "新分客户列表"; include_once adminTemplate('myuser_members_list'); }