public function down() { if ($user = User::find()->where(['username' => 'admin'])->one()) { /** @var $user User */ $user->delete(); echo 'User "' . $user->username . '" deleted.'; } }
/** * Creates data provider instance with search query applied * @param array $params * @param bool $trashed * @return ActiveDataProvider */ public function search($params, $trashed = false) { $query = User::find(); if ($trashed) { $query->trashed(); } else { $query->published(); } $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['updated_at' => SORT_DESC]]]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'deleted_at' => $this->deleted_at, 'last_visit_at' => $this->last_visit_at]); $query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'password_hash', $this->password_hash])->andFilterWhere(['like', 'password_reset_token', $this->password_reset_token])->andFilterWhere(['like', 'auth_key', $this->auth_key]); if (count($this->getRoles())) { /** @var \yii\rbac\DbManager $auth */ $auth = Yii::$app->authManager; $query->leftJoin($auth->assignmentTable . ' roles', 'roles.user_id=id'); $query->andWhere(['roles.item_name' => $this->getRoles()]); } return $dataProvider; }
/** * @return \yii\web\Response * @throws ForbiddenHttpException * @throws \Exception */ public function actionBulkRestore() { $data = Yii::$app->request->getBodyParam('data', []); $models = User::find()->trashed()->andWhere(['id' => $data])->all(); foreach ($models as $model) { $model->untrash(); } return $this->redirect(ArrayHelper::getValue(Yii::$app->request, 'referrer', ['index'])); }