public function member_loginlog(Request $request, Response $response)
{
$search = array();
$search['stime'] = '';
$search['etime'] = '';
$search['username'] = '';
$search['uid'] = '';
$search['sort'] = 'id_desc';
//排序字段,example:coin_asc,coin_desc
//不更新查询条件
if (empty($_POST)) {
if (isset($_SESSION['query']['loginlog'])) {
$search = $_SESSION['query']['loginlog'];
} else {
$_SESSION['query']['loginlog'] = $search;
}
} else {
//更新查询条件
$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['uid'] = empty($_POST['uid']) ? '' : addslashes(trim($_POST['uid']));
$search['sort'] = empty($_POST['sort']) ? 'id_desc' : addslashes(trim($_POST['sort']));
$_SESSION['query']['loginlog'] = $search;
}
$where = "";
if ($search['username'] != '') {
$where .= " and username='******'username'] . "'";
}
if ($search['uid'] != '') {
$where .= " and uid='" . $search['uid'] . "'";
}
if ($search['stime'] != '') {
$where .= " and login_time>=" . strtotime($search['stime']);
}
if ($search['etime'] != '') {
$where .= " and login_time<=" . strtotime($search['etime']);
}
//排序
$sort_where = "";
if ($search['sort'] != '') {
$sort = explode('_', $search['sort']);
if (count($sort) == 2) {
switch ($sort[0]) {
case 'uid':
$sort_field = 'uid ';
break;
case 'time':
$sort_field = 'login_time';
break;
default:
$sort_field = 'log_id';
}
switch ($sort[1]) {
case 'asc':
$sort_sequ = ' ASC ';
break;
default:
$sort_sequ = ' DESC ';
break;
}
$sort_where = ' ' . $sort_field . $sort_sequ;
}
}
$log = Member_Model::getMemberLoginLog($where, $sort_where);
$v = new PageView('mod_member_loginlog');
$v->assign('nav', $this->_nav)->assign('nav_second', 'loginlog');
$v->assign('log', $log)->assign('search', $search);
$response->send($v);
}
