<?php

    namespace common\models;

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

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

        /**
         * @inheritdoc
         */
        public function rules()
        {
            return [
                [
                    [
                        'project_id',
                        'project_pid',
                        'user_add_id',
                        'payment_variant',
                        'deadline',
                        'contractual',
                    ],
                    'integer',
                ],
                [
                    [
                        'name',
                        'link',
                        'date_add',
                        'date_end',
                        'budget',
                        'city',
                        'street',
                        'house',
                        'description',
                        'file',
                        'specializationString',
                    ],
                    'safe',
                ],
                [
                    [ 'view_count' ],
                    'number',
                ],
            ];
        }

        /**
         * @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 = Project::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;
            }

            $query2 = [ ];
            if(!empty( $this->specializationString )) {
                $query2 = Project::find()
                                 ->select([ 'project.project_id' ], 'DISTINCT')
                                 ->joinWith([ 'specializations' ])
                                 ->where([
                                     'like',
                                     'specialization_name',
                                     $this->specializationString,
                                 ])
                                 ->asArray()
                                 ->column();
            }

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

            // grid filtering conditions
            $query->andFilterWhere([
                'project_id'      => $this->project_id,
                'project_pid'     => $this->project_pid,
                'date_add'        => $this->date_add,
                'date_end'        => $this->date_end,
                'user_add_id'     => $this->user_add_id,
                'view_count'      => $this->view_count,
                'payment_variant' => $this->payment_variant,
                'deadline'        => $this->deadline,
                'contractual'     => $this->contractual,
            ]);

            $query->andFilterWhere(
                [
                    'project_id' => $query2,
                ]
            );

            $query->andFilterWhere([
                'like',
                'name',
                $this->name,
            ])
                  ->andFilterWhere([
                      'like',
                      'link',
                      $this->link,
                  ])
                  ->andFilterWhere([
                      'like',
                      'budget',
                      $this->budget,
                  ])
                  ->andFilterWhere([
                      'like',
                      'city',
                      $this->city,
                  ])
                  ->andFilterWhere([
                      'like',
                      'street',
                      $this->street,
                  ])
                  ->andFilterWhere([
                      'like',
                      'house',
                      $this->house,
                  ])
                  ->andFilterWhere([
                      'like',
                      'description',
                      $this->description,
                  ])
                  ->andFilterWhere([
                      'like',
                      'file',
                      $this->file,
                  ]);

            return $dataProvider;
        }
    }