• YII2 gridview filter?

    @DoNetSSS Автор вопроса
    Извините за мой код ведь я только учусь.
    Вот как надо было сделать.

    Контролер
    public function actionIndex($nav = null)
        {
            $departments = Departments::getAll();
            $searchModel = new Payments();
            $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
            return $this->render('index', [
                'departments' => $departments,
                'dataProvider' => $dataProvider,
                'searchModel' => $searchModel,
            ]);
        }


    Модель
    class Payments extends ActiveRecord
    {
        public $nameDepartments;
        public $nameExpenses;
    
        public function rules()
        {
            return [
                [['nameDepartments', 'nameExpenses', 'type', 'price', 'date', 'name'], 'safe'],
            ];
        }
    
        public function search($params, $where = null)
        {
            $query = Payments::find()->leftJoin(Expenses::tableName(), 'expenses.id = payments.idexpense')->leftJoin(Departments::tableName(), 'expenses.iddepartment = departments.id')->where($where);
            $dataProvider = new ActiveDataProvider([
                'query' => $query,
                'pagination' => [
                    'pagesize' => 20,
                ],
                'sort' => [
                    'attributes' => ['name', 'type', 'price', 'date',
                        'nameDepartments' => [
                            'asc' => ['departments.name' => SORT_ASC],
                            'desc' => ['departments.name' => SORT_DESC],
                        ],
                        'nameExpenses' => [
                            'asc' => ['expenses.name' => SORT_ASC],
                            'desc' => ['expenses.name' => SORT_DESC],
                        ],
                    ],
                ],
            ]);
    
            $this->load($params);
    
            if (!$this->validate()) {
                return $dataProvider;
            }
    
            $query->andFilterWhere([
                'id' => $this->id,
                'type' => $this->type,
                'price' => $this->price,
                'date' => $this->date,
            ]);
    
            $query->andFilterWhere(['like', 'payments.name', $this->name]);
            $query->andFilterWhere(['like', 'departments.name', $this->nameDepartments]);
            $query->andFilterWhere(['like', 'expenses.name', $this->nameExpenses]);
    
            return $dataProvider;
        }
    
        public function attributeLabels()
        {
            return array(
                'date' => 'Дата',
                'type' => 'Тип',
                'name' => 'Опис',
                'price' => 'Ціна',
                'nameDepartments' => 'Відділ',
                'nameExpenses' => 'Рахунок',
            );
        }
    
        public function getExpenses()
        {
            return $this->hasOne(Expenses::className(), ['id' => 'idexpense']);
        }
    
        public function getDepartments()
        {
            return $this->hasOne(Departments::className(), ['id' => 'iddepartment'])
                ->viaTable(Expenses::tableName(), ['id' => 'idexpense']);
        }
    
        public static function addPayments($input, $id)
        {
            $data = new Payments();
            $data->idexpense = $id;
            $data->name = $input['name'];
            $data->date = time();
            $data->type = $input['type'];
            $data->price = $input['price'];
            $data->save();
        }
    }


    Вюшка
    <?= GridView::widget([
                            'dataProvider' => $dataProvider,
                            'filterModel' => $searchModel,
                            'columns' => [
                                [
                                    'attribute'=>'date',
                                    'format' => 'date',
                                    'content'=>function($data){
                                        return date('Y-m-j G:i', $data['date']);
                                    },
                                ],
                                [
                                    'attribute'=>'nameDepartments',
                                    'format' => 'text',
                                    'content'=>function($data){
                                        return $data['departments']['name'];
                                    }
                                ],
                                [
                                    'attribute'=>'nameExpenses',
                                    'format' => 'text',
                                    'content'=>function($data){
                                        return $data['expenses']['name'];
                                    }
                                ],
                                [
                                    'attribute'=>'type',
                                    'format' => 'text',
                                    'content'=>function($data){
                                        return $data['type'] == 0 ? "Надходження" : "Видатки";
                                    }
                                ],
                                'name',
                                'price',
                            ],
                            'layout' => '{items}<div class="text-center">{pager}</div>',
                        ]); ?>
    Ответ написан
    Комментировать