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
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = User::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['updated_at' => SORT_DESC]]]);
if (!($this->load($params) && $this->validate())) {
$query->andWhere('status!=:status', [':status' => User::STATUS_DELETED]);
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 (strlen($this->status) === 0) {
$query->andWhere('status!=:status', [':status' => User::STATUS_DELETED]);
}
if (count($this->getRoles())) {
$auth = Yii::$app->authManager;
$query->leftJoin($auth->assignmentTable . ' roles', 'roles.user_id=id');
$query->andWhere(['roles.item_name' => $this->getRoles()]);
}
return $dataProvider;
}
