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; }