/** * Finds user by [[username]] * * @return User|null */ public function getUser() { if ($this->_user === false) { //$this->_user = User::findByUsername($this->username); $this->_user = User::find()->where("email = :email", [':email' => $this->email])->one(); } return $this->_user; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = User::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); $this->load($params); if (!$this->validate()) { $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['>=', 'created_at', $this->date_from ? strtotime($this->date_from . ' 00:00:00') : null])->andFilterWhere(['<=', 'created_at', $this->date_to ? strtotime($this->date_to . ' 23:59:59') : null]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = User::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'role' => $this->role, 'added' => $this->added]); $query->andFilterWhere(['like', 'fname', $this->fname])->andFilterWhere(['like', 'lname', $this->lname])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'pswd', $this->pswd]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = User::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['>=', 'created_at', $this->date_from ? strtotime(date('Y-m-d 00:00:00', strtotime($this->date_from))) : null])->andFilterWhere(['<=', 'created_at', $this->date_to ? strtotime(date('Y-m-d 23:59:59', strtotime($this->date_to))) : null]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = User::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'status' => $this->status]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'auth_key', $this->auth_key])->andFilterWhere(['like', 'email_confirm_token', $this->email_confirm_token])->andFilterWhere(['like', 'password_hash', $this->password_hash])->andFilterWhere(['like', 'password_reset_token', $this->password_reset_token])->andFilterWhere(['like', 'email', $this->email]); return $dataProvider; }
public function search($params) { $query = User::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => SORT_DESC]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'email', $this->email]); return $dataProvider; }
/** * 用户列表 * * @return string */ public function actionList() { $model = new User(); $dataProvider = new ActiveDataProvider(['query' => $model->find(), 'pagination' => ['pagesize' => 2]]); return $this->render('list', ['model' => $model, 'dataProvider' => $dataProvider]); }
public function searchAdministrators($params) { $query = User::find()->where(['role' => 1]); $dataProvider = $this->search($params, $query); return $dataProvider; }
/** * 配置用户权限组 * * @return string */ public function actionAssign_ment_edit() { $model = new Auth_assignment(); if (\Yii::$app->request->isGet) { $user_id = \Yii::$app->request->get('user_id'); if (!$user_id || !User::find($user_id)) { jump_error(t_arr('app', ['data', 'does not', 'exists'], '', '!')); } //角色列表 $assignMents = $model->getAssignmentByUserid($user_id); $assignMentSelectArray = []; if (is_array($assignMents) && count($assignMents)) { foreach ($assignMents as $_key => $_value) { $assignMentSelectArray[] = $_key; } } //所有角色{} $allRolesArray = $model->getAllRoles2SelectArray(); //用户信息 $user = User::findOne($user_id); return $this->render('assign_ment_edit', ['model' => $model, 'user' => $user, 'assignMentSelectArray' => $assignMentSelectArray, 'allRolesArray' => $allRolesArray]); } else { if (\Yii::$app->request->isPost) { $rs = $model->assign_user_create(\Yii::$app->request->post()); if ($rs) { jump_success(t_arr('app', ['update', 'success'], '', '!')); } else { jump_error(t_arr('app', ['update', 'fail'], '', '!')); } } } }
public function actionIndex() { $seasons = Season::find()->orderBy('time_update DESC')->limit(15)->all(); $users = User::find()->orderBy('id DESC')->limit(10)->all(); return $this->render('index', ['seasons' => $seasons, 'users' => $users]); }