public function dark_house() {
if ($_POST) {
} else{
$store_id = $_SESSION["admin"]["store_id"];
// 参加搜索功效
$get = I("get.");
$member_type = $get["pub"];
$name = $get["name"];
if ($member_type) {
if ($member_type == 1) {
$map["limit_time_end"] = array("neq", 0);
} elseif ($member_type == 2) {
$map["limit_time_end"] = array("eq", 0);
}
}
if ($name) {
$map["truename|login_account"] = array("like", "%".$name."%");
}
$this->assign("search", $name);
$this->assign("v", $member_type);
$map["store_id"] = array("eq", $store_id);
$map["is_disabled"] = array("eq", 1);
$map["is_member"] = array("eq", 1);
$count = M("member")->where($map)->count(); // 获得总记载的条数,进行分页
$page = $this->getpage($count,20); // 实例化分页类,传入总条数和每页的列数
$show = $page->show(); // 分页显示输出
$list = M("member")->where($map)->field("member_id, login_account, truename, sex, limit_time_end")->limit($page->firstRow.",".$page->listRows)->select();
foreach ($list as $k => $v) {
if ($v["limit_time_end"] == 0) {
$list[$k]["operation"] = "处分";
$list[$k]["punishment"] = "punishment";
$list[$k]["limit_time_end"] = "不处分";
} else {
$list[$k]["operation"] = "消除";
$list[$k]["punishment"] = "relieve";
$list[$k]["limit_time_end"] = date("Y-m-d",$v["limit_time_end"]);
$list[$k]["disabled"] = "disabled";
}
// 统计会员的旷课次数
$member_id = $list[$k]["member_id"];
$cmap["store_id"] = $store_id;
$cmap["member_id"] = $member_id;
$cmap["is_sign"] = 0;
$countC = M("reservation")->where($cmap)->count();
//echo M("reservation")->getLastSql();exit;
$list[$k]["count"] = $countC;
}
$this->assign("list",$list);// 赋值数据集
$this->assign("page",$show);// 赋值分页输出
$this->display(); // 输出模板
}
}
// 分页样式
public function getpage($count, $pagesize = 10) {
$p = new \Think\Page($count, $pagesize);
$p->setConfig("header", "<li class="rows">共<b>%TOTAL_ROW%</b>条记载 第<b>%NOW_PAGE%</b>页/共<b>%TOTAL_PAGE%</b>页</li>");
$p->setConfig("prev", "上一页");
$p->setConfig("next", "下一页");
$p->setConfig("last", "末页");
$p->setConfig("first", "首页");
$p->setConfig("theme", "%FIRST%%UP_PAGE%%LINK_PAGE%%DOWN_PAGE%%END%%HEADER%");
$p->lastSuffix = false;//最后一页不显示为总页数
return $p;
}public function dark_house() {
if ($_POST)