FeedbackCompanySearch.php 1.41 KB
<?php

    namespace common\models;

    use Yii;
    use yii\data\ActiveDataProvider;

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

        /**
         * @inheritdoc
         */
        public function rules()
        {
            return [
                [
                    [
                        'name',
                        'date_add',
                        'phone',
                        'status',
                    ],
                    'safe',
                ],
            ];
        }

        public function search($params)
        {
            $query = FeedbackCompany::find();

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

            $dataProvider = new ActiveDataProvider([
                'query' => $query,
            ]);

            $this->load($params);

            if(!$this->validate()) {
                return $dataProvider;
            }

            $query->andFilterWhere([
                'like',
                'LOWER(name)',
                mb_strtolower($this->name),
            ])
                  ->andFilterWhere([
                      'like',
                      'LOWER(phone)',
                      mb_strtolower($this->phone),
                  ]);

            return $dataProvider;

        }
    }