Administrator / test_3

  <?php
  

      namespace common\models;

      use Yii;
      use yii\base\Model;
      use yii\data\ActiveDataProvider;
      use common\models\Vacancy;

      /**

       * VacancySearch represents the model behind the search form about `common\models\Vacancy`.

       */

      class VacancySearch extends Vacancy

      {

          /**
           * @inheritdoc
           */
          public function rules()
          {
              return [
                  [
                      [
                          'vacancy_id',
                          'user_add_id',
                          'view_count',
                      ],
                      'integer',
                  ],
                  [
                      [
                          'name',
                          'link',
                          'date_add',
                          'user_name',
                          'city',
                          'description',
                      ],
                      'safe',
                  ],
              ];
          }

          /**
           * @inheritdoc
           */
          public function scenarios()
          {
              // bypass scenarios() implementation in the parent class
              return Model::scenarios();
          }

          /**
           * Creates data provider instance with search query applied
           *
           * @param array $params
           *
           * @return ActiveDataProvider
           */
          public function search($params)
          {
              $query = Vacancy::find();

              // add conditions that should always apply here

              $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->andWhere([ 'user_id' => \Yii::$app->user->getId() ]);

              // grid filtering conditions
              $query->andFilterWhere([
                  'vacancy_id' => $this->vacancy_id,
                  'date_add' => $this->date_add,
                  'user_add_id' => $this->user_add_id,
                  'view_count' => $this->view_count,
              ]);
  
              $query->andFilterWhere([
                  'like',
                  'name',
                  $this->name,
              ])
                    ->andFilterWhere([
                        'like',
                        'link',
                        $this->link,
                    ])
                    ->andFilterWhere([
                        'like',
                        'user_name',
                        $this->user_name,
                    ])
                    ->andFilterWhere([
                        'like',
                        'city',
                        $this->city,
                    ])
                    ->andFilterWhere([
                        'like',
                        'description',
                        $this->description,
                    ]);
  
              return $dataProvider;
          }

      }