/**
* default action 'index'
* @param Request $request
* @param Response $response
*/
public function index(Request $request, Response $response)
{
$search = array();
$search['time_type'] = 0;
$search['stime'] = '';
$search['etime'] = '';
$search['username'] = '';
$search['nickname'] = '';
$search['uid'] = '';
$search['has_coin'] = 0;
$search['disabled_user'] = 0;
$search['sort'] = 'uid_desc';
//排序字段,example:coin_asc,coin_desc
//不更新查询条件
if (empty($_POST)) {
if (isset($_SESSION['query']['member_list'])) {
$search = $_SESSION['query']['member_list'];
} else {
$_SESSION['query']['member_list'] = $search;
}
} else {
//更新查询条件
$search['time_type'] = empty($_POST['time_type']) ? 0 : intval($_POST['time_type']);
$search['stime'] = empty($_POST['stime']) ? '' : addslashes(trim($_POST['stime']));
$search['etime'] = empty($_POST['etime']) ? '' : addslashes(trim($_POST['etime']));
$search['username'] = empty($_POST['username']) ? '' : addslashes(trim($_POST['username']));
$search['nickname'] = empty($_POST['nickname']) ? '' : addslashes(trim($_POST['nickname']));
$search['uid'] = empty($_POST['uid']) ? '' : addslashes(trim($_POST['uid']));
$search['has_coin'] = isset($_POST['has_coin']) ? intval($_POST['has_coin']) : 0;
$search['disabled_user'] = isset($_POST['disabled_user']) ? intval($_POST['disabled_user']) : 0;
$search['sort'] = empty($_POST['sort']) ? 'uid_desc' : addslashes(trim($_POST['sort']));
$_SESSION['query']['member_list'] = $search;
}
$where = "";
if ($search['username'] != '') {
$where .= " and username='******'username'] . "'";
}
if ($search['nickname'] != '') {
$where .= " and nickname='" . $search['nickname'] . "'";
}
if ($search['uid'] != '') {
$where .= " and uid='" . $search['uid'] . "'";
}
if ($search['time_type'] == 1) {
//注册时间
if ($search['stime'] != '') {
$where .= " and regtime>=" . strtotime($search['stime']);
}
if ($search['etime'] != '') {
$where .= " and regtime<=" . strtotime($search['etime']);
}
}
if ($search['time_type'] == 2) {
//登录时间
if ($search['stime'] != '') {
$where .= " and lasttime>=" . strtotime($search['stime']);
}
if ($search['etime'] != '') {
$where .= " and lasttime<=" . strtotime($search['etime']);
}
}
//用户是否有平台币
if ($search['has_coin'] > 0) {
$where .= " AND coin!=0 ";
}
//已封停用户
if ($search['disabled_user'] > 0) {
$where .= " AND state=0 ";
}
//排序
$sort_where = "";
if ($search['sort'] != '') {
$sort = explode('_', $search['sort']);
if (count($sort) == 2) {
switch ($sort[0]) {
case 'coin':
$sort_field = 'coin ';
break;
case 'score':
$sort_field = 'score';
break;
default:
$sort_field = 'uid';
}
switch ($sort[1]) {
case 'asc':
$sort_sequ = ' ASC ';
break;
default:
$sort_sequ = ' DESC ';
break;
}
$sort_where = ' ' . $sort_field . $sort_sequ;
}
}
$members = Member_Model::getMembersByWhere($where, $sort_where);
$v = new PageView('mod_member_index');
$v->assign('nav', $this->_nav)->assign('nav_second', 'member');
$v->assign('members', $members)->assign('search', $search);
$response->send($v);
}
