public function user()
{
import("ORG.Util.Page");
$user = D('UserRelation')->relation(true)->order('unum')->select();
$user = user_manyone($user, $_GET['sid']);
$count = count($user);
$page = new Page($count, 12);
$limit = $page->firstRow . ',' . $page->listRows;
$user = D('UserRelation')->relation(true)->order('unum')->limit($limit)->select();
$user = user_manyone($user, $_GET['sid']);
$this->user = $user;
$this->sid = $_GET['sid'];
$this->page = $page->show();
$this->display();
}
public function searchuser()
{
$searchcondition = I('searchcondition', '');
$searchcontent = I('searchcontent', '');
if (!empty($searchcondition) && !empty($searchcontent)) {
import('ORG.Util.Page');
//查询条件的处理
//处理性别
if ($searchcondition == "umale") {
if ($searchcontent == "男") {
$searchcontent = 1;
} else {
$searchcontent = 0;
}
}
//处理状态
if ($searchcondition == "ustatus") {
if ($searchcontent == "开启") {
$searchcontent = 1;
} else {
$searchcontent = 0;
}
}
//处理user表查询
if ($searchcondition == "unum" || $searchcondition == "uname" || $searchcondition == "uphone" || $searchcondition == "ustatus" || $searchcondition == "umale") {
$condition[$searchcondition] = array('like', '%' . $searchcontent . '%');
$count = D('UserRelation')->where($condition)->count();
$page = new Page($count, 12);
$limit = $page->firstRow . ',' . $page->listRows;
$user = D('UserRelation')->relation(true)->where($condition)->order('unum')->limit($limit)->order('unum desc')->select();
$user = user_manyone($user);
$this->page = $page->show();
$this->user = $user;
$this->roles = M('role')->select();
//列出角色表
$this->shops = M('shop')->select();
$this->display('index');
} else {
//处理role与shop
$user = D('UserRelation')->relation(true)->select();
$user = user_manyone($user);
if ($searchcondition == "role") {
for ($m = 0, $i = 0; $i < count($user); $i++) {
if ($user[$i]['roleremark'] == $searchcontent) {
$role[$m] = $user[$i];
$m++;
}
}
$count = $m;
$page = new Page($m, 12);
$limit = $page->firstRow . ',' . $page->listRows;
$this->page = $page->show();
$this->user = $role;
$this->roles = M('role')->select();
//列出角色表
$this->shops = M('shop')->select();
$this->display('index');
} elseif ($searchcondition == "shop") {
for ($n = 0, $j = 0; $j < count($user); $j++) {
if ($user[$j]['shopsname'] == $searchcontent) {
$shop[$n] = $user[$j];
$n++;
}
}
$count = $n;
$page = new Page($n, 12);
$limit = $page->firstRow . ',' . $page->listRows;
$this->page = $page->show();
$this->user = $shop;
$this->roles = M('role')->select();
//列出角色表
$this->shops = M('shop')->select();
$this->display('index');
}
}
}
}
