ServerSide with paging

[alladas]

Hello @ZAYEC77,
Hello All,

How to get serverSide work with paging?
Trying it with the basic example seems not working.
Got 10 displayed out of 2000+ without any pagination.
Just like in this screenshot.

In advance thanks.

[ZAYEC77]

Hello, thanks for issue.
@alladas an you provider code that you use?

[alladas]

Hello @ZAYEC77,
Thanks for your answer.
Here is what I have tried. It is a basic setting. Just for testing according to your instructions.
`=== Model ===
public static function find()
{
return new ModelQuery(get_called_class());
}

=== ModelController ===
public function actions() {
return [
'datatables' => [
'class' => DataTableAction::className(),
'query' => Model::find (),
]
];
}

=== index ===

true, 'processing' => true, 'language' => [ 'lengthMenu' => Yii::t('common', 'Showing').' _MENU_ '.Yii::t('common', 'records per page'), 'searchPlaceholder'=>Yii::t('common', 'Search'),'class'=>'input-group input-group-sm', 'paginate' => [ 'first' => Yii::t('common', 'First'), 'previous' => Yii::t('common', 'Previous'), 'next' => Yii::t('common', 'Next'), 'last' => Yii::t('common', 'Last'), ], 'info' => Yii::t('common', 'Showing').' _START_ '.Yii::t('common', 'to').' _END_ '.Yii::t('common', 'of').' _TOTAL_ '.Yii::t('common', 'entries'), 'processing' => ''.Yii::t('common', 'Loading...').'' ], 'ajax' => Url::to(['controller/datatables']), 'columns' => [ [ 'data' => 'model_id', 'title' => Yii::t('backend', 'Id'), ], [ 'data' => 'parent_id', 'title' => Yii::t('backend', 'Parent'), ], 'title', 'description', [ 'data' => 'start', 'title' => Yii::t('backend', 'From') ], [ 'data' => 'end', 'title' => Yii::t('backend', 'Thru') ], ], ]); ?>

`

[alladas]

Hello @ZAYEC77,
After some minor changes in DataTableAction server side is working for me.
Pagination, Search and sort seems now ok.
Posted my changes here: https://github.com/alladas/yii2-datatables/commit/56dd35c230082fbf181be3c24bcfde944c6831ca
First PR?
Thanks.

[ZAYEC77]

Hello, please make pull request if all works fine.

[alladas]

Thanks @ZAYEC77 ,
Ok, I will do that after more tests.
May I have one trivial question data formatting?
Is it possible to use Yii formatter?
I really appreciate your reactivity.

[ZAYEC77]

@alladas I think it would be implemented by afterAction method in your application (I'm not sure, but think that it can help you to format response data).
It's not very common case for adding to package.
If you implement this, you can add example to README.

[ZAYEC77]

@alladas also you can use event afterAction and modify result value.

[alladas]

Yes I tested yesterday with afterFind it worked.
But then, the column get sorted as string.
That is why I wonder if there is a another way .
Also using afterFind leads to many changes since I was already using yii formatter on these fields.

[fjqtp]

Hi All,

pagination still doesn't work for me, all records are shown in table. I noticed that it's fixed when I rearrange 67 and 68-70 lines in DataTableAction.php (sorry not familiar with git to post changes like alladas did, it's about cloning $filterquery AFTER setting offset and limit).

Can you please check if it helps?

[alladas]

Hi @fjqtp ,
Maybe I can help but I am not sure to understand well:

pagination still doesn't work for me, all records are shown in table

May you post a screenshot?

[fjqtp]

Please check screenshot. All 32 entries are shown though it says "1 to 10". When I go to 2 page, it shows exactly the same entries here.

[ZAYEC77]

@fjqtp Hello, do you use dev version?

[fjqtp]

@ZAYEC77 yes.

[Setitch]

I have the same problem, after reading the file and the solution from alladas@56dd35c i can assure that this solution works. Also this solution two month old, so project owner - commit it, or i dont see any reason for using any further version of your package.