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']));
}
