<?php

    namespace common\models;

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

    /**
     * PortfolioSearch represents the model behind the search form about `common\models\Portfolio`.
     */
    class PortfolioSearch extends Portfolio
    {

        /**
         * @inheritdoc
         */
        public function rules()
        {
            return [
                [
                    [
                        'portfolio_id',
                        'user_add_id',
                        'view_count',
                        'gallery_id',
                    ],
                    'integer',
                ],
                [
                    [
                        'name',
                        'link',
                        'date_add',
                        'city',
                        'street',
                        'house',
                        'description',
                        'cover',
                        'specializationString',
                    ],
                    '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 = Portfolio::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->joinWith('specializations');

            $query->andWhere([ 'user_id' => \Yii::$app->user->getId() ]);

            // grid filtering conditions
            $query->andFilterWhere([
                'portfolio_id' => $this->portfolio_id,
                'date_add'     => $this->date_add,
                'user_add_id'  => $this->user_add_id,
                'view_count'   => $this->view_count,
                'gallery_id'   => $this->gallery_id,
            ]);

            $query->andFilterWhere([
                'like',
                'name',
                $this->name,
            ])
                  ->andFilterWhere([
                      'like',
                      'link',
                      $this->link,
                  ])
                  ->andFilterWhere([
                      'like',
                      'city',
                      $this->city,
                  ])
                  ->andFilterWhere([
                      'like',
                      'street',
                      $this->street,
                  ])
                  ->andFilterWhere([
                      'like',
                      'house',
                      $this->house,
                  ])
                  ->andFilterWhere([
                      'like',
                      'description',
                      $this->description,
                  ])
                  ->andFilterWhere([
                      'like',
                      'cover',
                      $this->cover,
                  ])
                  ->andFilterWhere([
                      'like',
                      'specialization.specialization_name',
                      $this->specializationString,
                  ]);

            return $dataProvider;
        }
    }