D
D
DoNetSSS2015-11-05 13:21:49
Yii
DoNetSSS, 2015-11-05 13:21:49

yii2 gridview filter?

How to make a filter?
Controller

public function actionIndex($nav = null)
    {
        $departments = Departments::getAll();
        $searchModel = new Payments();
        if ($nav == 'out') {
            $dataProvider = $searchModel->search(['type' => 1]);
        } else if ($nav == 'in') {
            $dataProvider = $searchModel->search(['type' => 0]);
        } else {
            $dataProvider = $searchModel->search([]);
        }
        return $this->render('index', [
            'departments' => $departments,
            'dataProvider' => $dataProvider,
            'searchModel' => $searchModel,
        ]);
    }

Model
class Payments extends ActiveRecord
{
    public static function tableName()
    {
        return '{{%payments}}';
    }
    public function rules()
    {
        return [
            [['idexpense', 'type', 'name', 'price', 'date'], 'required'],
            [['idexpense', 'type', 'price', 'date'], 'integer'],
            [['name'], 'string', 'max' => 255]
        ];
    }
    public function search($params)
    {
        $query = Payments::find()->leftJoin(Expenses::tableName(), 'expenses.id = payments.idexpense')->leftJoin(Departments::tableName(), 'expenses.iddepartment = departments.id')->where($params);
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'pagesize' => 50,    //Alternate method of disabling paging
            ],
            'sort' => [
                'attributes' => [
                    'name' => [
                        'asc' => ['name' => SORT_ASC,],
                        'desc' => ['name' => SORT_DESC,],
                    ],
                    'type' => [
                        'asc' => ['type' => SORT_ASC,],
                        'desc' => ['type' => SORT_DESC,],
                    ],
                    'price' => [
                        'asc' => ['price' => SORT_ASC,],
                        'desc' => ['price' => SORT_DESC,],
                    ],
                    'departments.name' => [
                        'asc' => ['departments.name' => SORT_ASC,],
                        'desc' => ['departments.name' => SORT_DESC,],
                    ],
                    'expenses.name' => [
                        'asc' => ['expenses.name' => SORT_ASC,],
                        'desc' => ['expenses.name' => SORT_DESC,],
                    ],
                    'date' => [
                        'asc' => ['date' => SORT_ASC,],
                        'desc' => ['date' => SORT_DESC,],
                    ],
                ],
            ],
        ]);

        return $dataProvider;
    }

    public function attributeLabels()
    {
        return array(
            'date' => 'Дата',
            'type' => 'Тип',
            'name' => 'Опис',
            'price' => 'Ціна',
            'departments.name' => 'Відділ',
            'expenses.name' => 'Рахунок',
        );
    }

    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();
    }
}

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

Answer the question

In order to leave comments, you need to log in

[[+comments_count]] answer(s)
D
DoNetSSS, 2015-11-05
@DoNetSSS

Sorry for my code, I'm just learning.
Here's how it should have been done.
Controller

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,
        ]);
    }

Model
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();
    }
}

Vyushka
<?= 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>',
                    ]); ?>

L
labunskyi, 2020-09-23
@labunskyi

Here's how to do it right: https://iportal.com.ua/widzhet-dlya-dannyh-yii2-gr... Step by step instructions.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question