Filter result Pagination not working in yii2 gridview

Question

im using Pjax gridview,After I search the results,when I click pagination ,the results changed to default results page not search result. and my search function is like

public function search($params)
{
    $query = UserLogs::find();
    $dataProvider = new ActiveDataProvider([
        'query' => $query,'pagination'=> ['defaultPageSize' => PAGE_SIZE],
        'sort' => [
            'defaultOrder' => [
                'user_log_id' => SORT_DESC,
            ]
        ],
    ]);

    $this->load($params);

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

    $query->joinWith('user');

    // grid filtering conditions
    $query->andFilterWhere([
        'user_log_id' => $this->user_log_id,
        //'user_id' => $this->user_id,
        'user_logs.user_type_id' => $this->user_type_id,
        'login_time' => $this->login_time,
        'logout_time' => $this->logout_time,
    ]);

    $query->andFilterWhere(['like', 'login_ip', $this->login_ip])
          ->andFilterWhere(['like', 'juser.firstname', $this->user_id]);             

    return $dataProvider;
}

Edit#1: my grid view file is :

<?php Pjax::begin(['clientOptions' => ['method' => 'POST']]);?>
                <?= GridView::widget([
                    'dataProvider' => $dataProvider,
                    'filterModel' => $searchModel,
                    'columns' => [
                        ['class' => 'yii\grid\SerialColumn'],

                       .....                                         

                        ['class' => 'yii\grid\ActionColumn','template' => '{view}'],
                    ],
                ]); ?>
                <?php Pjax::end();?>

No.if I search something then result come correctly.if I click pagination of that search result then its goes to default grid view results — Jackhad, Jun 09 '16 at 09:30
No Js errors found.Normally my grid results are 13 pages,After filter its 3 pages,If I click page number 2 in that search results ,pagination again 13 pages :( — Jackhad, Jun 09 '16 at 10:01
Try add this ` ['method' => 'POST', 'timeout' => 7000]]);?>` — Vitaly, Jun 09 '16 at 10:11
add `$query->joinWith('user')` before `$this->load($params)` — uiTeam324, Jun 09 '16 at 12:04
@Jackhad try this `\yii\widgets\Pjax::begin([ 'id' => 'log-grid', 'timeout' => 10000]); `. Working for me — uiTeam324, Jun 10 '16 at 10:31
Not works @SRana ...Seems I may be wrong somewhere.So copied my controller, model and view code here http://pastebin.com/ytnrMFYD — Jackhad, Jun 10 '16 at 11:28

score 4 · Answer 1 · answered Jan 28 '17 at 02:23

4

Change your POST to GET, this should make the pagination work along with any of your other filters.

answered Jan 28 '17 at 02:23

Subbu

95
4

Thanks for the solution. – Mannya Jan 27 '21 at 08:34

score 0 · Answer 2 · answered Jul 28 '20 at 05:25

I have solved this problem by "self join".

In your model file write this code for self join.


public function getUserLogs()
{
    return $this->hasOne(UserLogs::className(), ['user_id' => 'user_id', 'user_log_id' => 'user_log_id']);
}

In your search function write this code



public function search($params)
{
    $query = UserLogs::find();
    $query->joinWith('user_logs as u_l');
    $dataProvider = new ActiveDataProvider([
        'query' => $query,'pagination'=> ['defaultPageSize' => PAGE_SIZE],
        'sort' => [
            'defaultOrder' => [
                'user_log_id' => SORT_DESC,
            ]
        ],
    ]);

    $this->load($params);

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

    $query->joinWith('user');

    // grid filtering conditions
    $query->andFilterWhere([
        'u_l.user_log_id' => $this->user_log_id,
        'u_l.user_id' => $this->user_id,
        'u_l.user_type_id' => $this->user_type_id,
        'u_l.login_time' => $this->login_time,
        'u_l.logout_time' => $this->logout_time,
    ]);

    $query->andFilterWhere(['like', 'u_l.login_ip', $this->login_ip])
          ->andFilterWhere(['like', 'user.firstname', $this->user_id]);             

    return $dataProvider;
}

Filter result Pagination not working in yii2 gridview

2 Answers2