public function _befor_add()
{
$list = orgcateTree($pid = 0, $level = 0, $type = 0);
$this->assign('list', $list);
$demo = M("user");
$list = $demo->table(C('DB_PREFIX') . "authgroup a")->where("a.status='1'")->field("a.id as RuleGroupID,a.title as RuleGroupName,'' as selected")->order("a.Sort asc")->select();
//var_dump($demo->getLastSql());
$this->assign('ruleslist', $list);
}
public function user()
{
$info = M('user');
if (isset($_REQUEST['orderField'])) {
$order = $_REQUEST['orderField'];
}
if ($order == '') {
$order = $info->getPk();
}
if (isset($_REQUEST['orderDirection'])) {
$sort = $_REQUEST['orderDirection'];
}
if ($sort == '') {
$sort = $asc ? 'asc' : 'desc';
}
if (isset($_REQUEST['pageCurrent'])) {
$pageCurrent = $_REQUEST['pageCurrent'];
}
if ($pageCurrent == '') {
$pageCurrent = 1;
}
$key = I('keys');
if ($key) {
$where['username'] = array('like', '%' . $key . '%');
$where['truename'] = array('like', '%' . $key . '%');
$where['depname'] = array('like', '%' . $key . '%');
$where['posname'] = array('like', '%' . $key . '%');
$where['_logic'] = 'or';
}
if (IS_POST && isset($_REQUEST['filter']) && $_REQUEST['filter'] != '') {
$map['depname'] = array('EQ', I('filter'));
$where['_complex'] = $map;
}
$numPerPage = 10;
cookie('_currentUrl_', __SELF__);
$list = $info->where($where)->order("`" . $order . "` " . $sort)->limit($numPerPage)->page($pageCurrent . ',' . $numPerPage . '')->select();
$this->assign('list', $list);
$count = $info->where($where)->count();
$this->assign('totalCount', $count);
$this->assign('currentPage', !empty($_GET['pageNum']) ? $_GET['pageNum'] : 1);
$this->assign('numPerPage', $numPerPage);
$filters = orgcateTree($pid = 0, $level = 0, $type = 0);
$this->assign('filters', $filters);
$this->display();
}
public function _befor_edit()
{
$list = orgcateTree($pid = 0, $level = 0, $type = 0);
$this->assign('type', I('get.type'));
$this->assign('list', $list);
}
function orgcateTree($pid = 0, $level = 0, $type = 0)
{
$cate = M('authgroup');
$array = array();
$tmp = $cate->where(array('pid' => $pid, 'type' => $type))->order("sort")->select();
if (is_array($tmp)) {
foreach ($tmp as $v) {
$v['level'] = $level;
//$v['pid']>0;
$array[count($array)] = $v;
$sub = orgcateTree($v['id'], $level + 1, $type);
if (is_array($sub)) {
$array = array_merge($array, $sub);
}
}
}
return $array;
}
