<?php
require_once 'config.php';
require_once 'sample-data/category.php';
require 'login_model.php';
//require_once 'header.php'
?>
<?php
loginTime();
?>
<head>
<meta charset="UTF-8">
<title>Web Shop App</title>
</head>
<body>
<h1>
Login
</h1>
<?php
if (isset($_POST['login'])) {
$loginState = login();
if ($loginState) {
echo "Login successful";
header("location:index.php");
exit;
} else {
echo "Login failed";
}
}
?>
public function index()
{
$uid = session('user.id');
getMsgStatu($uid);
$post = I('post.');
$order = "user.last_login_time desc";
//排序方式
if (!empty($post['search'])) {
//搜索
$search = '%' . $post['search'] . "%";
//搜索条件1
$where['user.username|founder.intro'] = array('like', $search);
//搜索条件2
$count = M()->table('user user,user_founder founder')->where("user.id = founder.uid")->where($where)->count();
// 查询满足要求的总记录数
$page = PAGE($count);
// 实例化分页类 传入总记录数和每页显示的记录数
$show = $page->show();
// 分页显示输出
$data = M()->table('user user,user_founder founder')->where("user.id = founder.uid")->where($where)->limit($page->firstRow . ',' . $page->listRows)->order($order)->select();
for ($i = 0; $i != count($data); $i++) {
//改变搜索结果颜色
$data[$i]['intro'] = str_replace($post['search'], "<span style='color:red'>{$post['search']}</span>", $data[$i]['intro']);
}
//dump($data);
} elseif (!empty($post['type'])) {
//筛选
$where = array();
if ($post['type'] !== "不限") {
$where['founder.type'] = $post['type'];
}
if ($post['province'] !== "不限") {
$where['user.province'] = $post['province'];
}
if ($post['city'] !== "不限") {
$where['user.city'] = $post['city'];
}
if ($post['agegroup'] !== "不限") {
$date = ageGroupReverse($post['agegroup']);
$where['birthday_time'] = array("between", "{$date['start']},{$date['end']}");
}
$count = M()->table('user user,user_founder founder')->where("user.id = founder.uid")->where($where)->count();
$page = PAGE($count);
// 实例化分页类 传入总记录数和每页显示的记录数
$show = $page->show();
// 分页显示输出
$data = M()->table('user user,user_founder founder')->where("user.id = founder.uid")->where($where)->order($order)->limit($page->firstRow . ',' . $page->listRows)->select();
//dump($data);
} else {
//全部
$count = M()->table('user user,user_founder founder')->where("user.id = founder.uid")->order($order)->count();
$page = PAGE($count);
// 实例化分页类 传入总记录数和每页显示的记录数
$show = $page->show();
// 分页显示输出
$data = M()->table('user user,user_founder founder')->where("user.id = founder.uid")->order($order)->limit($page->firstRow . ',' . $page->listRows)->select();
//dump($data);
}
for ($i = 0; $i != count($data); $i++) {
$data[$i]['agegroup'] = ageGroup($data[$i]['birthday_time']);
//年龄转换
$data[$i]['reg_time'] = regTime($data[$i]['reg_time']);
//注册时间转换
$data[$i]['last_login_time'] = loginTime($data[$i]['last_login_time']);
//登录时间转换
if (strlen($data[$i]['username']) >= 12) {
// 用户名判断截取
$data[$i]['username'] = substr($data[$i]['username'], 0, 10) . '..';
}
}
$this->assign('founder', $data);
$this->assign('page', $show);
// 赋值分页输出
$this->display();
}
