コード例 #1
0
 /**
  * 列表
  *
  * @param string $sort 排序
  * @param int $page 页面
  * @param int $limit 每页记录数
  * @return array
  */
 public function actionList($sort = '', $page = 1, $limit = 20)
 {
     $group_id = \Yii::$app->request->get('group_id');
     $name = \Yii::$app->request->get('name');
     $is_system = \Yii::$app->request->get('is_system');
     $note = \Yii::$app->request->get('note');
     $status = \Yii::$app->request->get('status');
     $limit = intval($limit);
     $order = ExtHelpers::getOrder($sort, ['group_id', 'name', 'note', 'status'], [], 'group_id DESC');
     $condition = '1';
     $params = [];
     if ($group_id) {
         $condition .= ' and group_id=:group_id';
         $params[':group_id'] = $group_id;
     }
     if ($name) {
         $condition .= ' and name like :name';
         $params[':name'] = '%' . $name . '%';
     }
     if (is_numeric($is_system)) {
         $condition .= ' and is_system=:is_system';
         $params[':is_system'] = $is_system;
     }
     if ($note) {
         $condition .= ' and note like :note';
         $params[':note'] = '%' . $note . '%';
     }
     if (is_numeric($status)) {
         $condition .= ' and status=:status';
         $params[':status'] = $status;
     }
     $data = DpAdminGroup::getListByCondition($condition, $params, $order, $page, $limit);
     return ['total' => $data['pagination']['totalCount'], 'list' => $data['list']];
 }
コード例 #2
0
 /**
  * 列表
  *
  * @param string $sort 排序
  * @return array
  */
 public function actionList($sort = '')
 {
     $order = ExtHelpers::getOrder($sort, ['url_id', 'route', 'method', 'host', 'enable_rule', 'note', 'status'], [], 'url_id DESC');
     $list = [];
     $searchModel = new DpAdminMenuUrlSearch();
     $dataProvider = $searchModel->search(\Yii::$app->request->get(), '');
     $dataProvider->query->orderBy($order);
     $dataProvider->getPagination()->pageSizeParam = 'limit';
     foreach ($dataProvider->getModels() as $itemModel) {
         /* @var $itemModel \wsl\rbac\models\DpAdminMenuUrl */
         $list[] = $itemModel->getAttributes();
     }
     return ['total' => $dataProvider->getTotalCount(), 'list' => $list];
 }
コード例 #3
0
 /**
  * 列表
  *
  * @param string $sort 排序
  * @param int $page 页面
  * @param int $limit 每页记录数
  * @return array
  */
 public function actionList($sort = '', $page = 1, $limit = 20)
 {
     $link_id = \Yii::$app->request->get('link_id');
     $menu_id = \Yii::$app->request->get('menu_id');
     $url_id = \Yii::$app->request->get('url_id');
     $status = \Yii::$app->request->post('status');
     $limit = intval($limit);
     $order = ExtHelpers::getOrder($sort, ['link_id', 'url_id'], [], 'link_id DESC');
     $condition = '1';
     $params = [];
     $tabName = DpAdminMenuUrlRelation::tableName();
     $order = join(',', array_map(function ($value) use($tabName) {
         return $tabName . '.' . $value;
     }, explode(',', $order)));
     if ($link_id) {
         $condition .= ' and ' . $tabName . '.link_id=:link_id';
         $params[':link_id'] = $link_id;
     }
     if ($menu_id) {
         $condition .= ' and ' . $tabName . '.menu_id=:menu_id';
         $params[':menu_id'] = $menu_id;
     }
     if ($url_id) {
         $condition .= ' and ' . $tabName . '.url_id=:url_id';
         $params[':url_id'] = $url_id;
     }
     if (is_numeric($status)) {
         $condition .= ' and ' . $tabName . '.status=:status';
         $params[':status'] = $status;
     }
     $data = DpAdminMenuUrlRelation::getListByCondition($condition, $params, $order, $page, $limit);
     if ($data['list']) {
         foreach ($data['list'] as &$item) {
             foreach ($item['menuUrl'] as $k => $v) {
                 $item['url.' . $k] = $v;
             }
             unset($item['menuUrl']);
         }
     }
     return ['total' => $data['pagination']['totalCount'], 'list' => $data['list']];
 }
コード例 #4
0
 /**
  * 列表
  *
  * @param string $sort 排序
  * @param int $page 页码
  * @param int $limit 每页记录数
  * @return array
  */
 public function actionList($sort = '', $page = 1, $limit = 20)
 {
     $user_id = \Yii::$app->request->get('user_id');
     $username = \Yii::$app->request->get('username');
     $nickname = \Yii::$app->request->get('nickname');
     $group_ids = array_filter((array) \Yii::$app->request->get('group_ids'));
     $is_group_access = \Yii::$app->request->get('is_group_access');
     $is_user_access = \Yii::$app->request->get('is_user_access');
     $is_system = \Yii::$app->request->get('is_system');
     $note = \Yii::$app->request->get('note');
     $status = \Yii::$app->request->get('status');
     $limit = intval($limit);
     $order = ExtHelpers::getOrder($sort, ['user_id', 'username', 'nickname', 'is_system', 'note', 'status'], [], 'user_id DESC');
     $condition = '1';
     $params = [];
     if ($user_id) {
         $condition .= ' and user_id=:user_id';
         $params[':user_id'] = $user_id;
     }
     if ($username) {
         $condition .= ' and username=:username';
         $params[':username'] = $username;
     }
     if (is_numeric($is_group_access)) {
         $condition .= ' and is_group_access=:is_group_access';
         $params[':is_group_access'] = $is_group_access;
     }
     if (is_numeric($is_user_access)) {
         $condition .= ' and is_user_access=:is_user_access';
         $params[':is_user_access'] = $is_user_access;
     }
     if (is_numeric($is_system)) {
         $condition .= ' and is_system=:is_system';
         $params[':is_system'] = $is_system;
     }
     if ($note) {
         $condition .= ' and note like :note';
         $params[':note'] = '%' . $note . '%';
     }
     if ($nickname) {
         $condition .= ' and nickname like :nickname';
         $params[':nickname'] = '%' . $nickname . '%';
     }
     if ($group_ids && is_array($group_ids)) {
         $group_ids = array_filter($group_ids, function ($value) {
             return is_numeric($value);
         });
         $condition .= ' and group_ids in (' . join(',', $group_ids) . ')';
     }
     if (is_numeric($status)) {
         $condition .= ' and status=:status';
         $params[':status'] = $status;
     }
     $condition .= ' and user_id!=1';
     $data = DpAdminUser::getListByCondition($condition, $params, $order, $page, $limit);
     $list = [];
     if ($data['list']) {
         foreach ($data['list'] as $item) {
             $groupIds = StringHelper::explode($item['group_ids'], ',', true, true);
             asort($groupIds);
             $groupNames = [];
             foreach ($groupIds as $groupId) {
                 $group = DpAdminGroup::getByGroupId($groupId);
                 if ($group) {
                     $groupNames[] = $group['name'];
                 }
             }
             $list[] = ['user_id' => $item['user_id'], 'username' => $item['username'], 'nickname' => $item['nickname'], 'group_ids' => join(',', $groupIds), 'group_names' => join(',', $groupNames), 'is_group_access' => $item['is_group_access'], 'is_user_access' => $item['is_user_access'], 'is_system' => $item['is_system'], 'note' => $item['note'], 'status' => $item['status']];
         }
     }
     return ['total' => $data['pagination']['totalCount'], 'list' => $list];
 }
コード例 #5
0
 /**
  * 所有列表
  *
  * @param string $sort 排序
  * @return array
  */
 public function actionAll($sort = '')
 {
     $order = ExtHelpers::getOrder($sort, ['menu_id', 'parent_id', 'text', 'title', 'url', 'view_package', 'expanded', 'closable', 'is_folder', 'is_open_url', 'is_open_target', 'is_every_open', 'is_hide', 'display_order', 'note', 'status'], [], 'menu_id DESC');
     $list = DpAdminMenu::find()->orderBy($order)->all();
     return ['total' => count($list), 'list' => $list];
 }