jqGrid: Custom-Filtering

[ThaDafinser]

From @creifferscheid on June 30, 2014 9:15

Hey,
thanks for the great bundle, but I got stuck with a small bug?!

We want to use the jqGrid multipleSearch - function:

multipleSearch:true,
multipleGroup:true

But it doesn't work because the POST is different to a normal search-operation.
This is a piece of POST Data using the multipleSearch-filtering

isSearch: true
filters:{"groupOp":"AND","rules":[{"field":"title","op":"cn","data":"ff"}]}
searchField:
searchString:
searchOper:

And for the simple Search

isSearch:true
title:fff

I think there's an error in the Renderer?

Copied from original issue: ThaDafinser/ZfcDatagrid#123

[ThaDafinser]

From @webdevilopers on June 30, 2014 9:37

I think not all jqGrid options are yet implemented. You can create a custom template and add the options there see issue #106 :

$grid->getRenderer()->setTemplate('indexgrid');
return $grid;

There is a custom template I added for the groupingView option in PR #118 .

Hope this helps!

[ThaDafinser]

From @hikaru-shindo on June 30, 2014 9:48

The problem seems not to be the layout but that the filters are not applied because the POST structure of jqGrid is different. I think one would need to change the renderer class a bit to get the advanced filters from the POST.

[ThaDafinser]

From @webdevilopers on June 30, 2014 9:55

I think so too. Maybe here are some other issues concerning this topic:

• cellAttributes fix for #107, individual layout template fix for #106 ThaDafinser/ZfcDatagrid#112
• Adding postData to / changing URL in jqGrid ThaDafinser/ZfcDatagrid#117
• jqgrid paging breaks when using groupingView due to additional sortByColumns on POST request ThaDafinser/ZfcDatagrid#108
• Add multiple cellattr on column when using jqGrid ThaDafinser/ZfcDatagrid#107
• rowList support for jqgrid renderer ThaDafinser/ZfcDatagrid#102 with @hikaru-shindo involved

[ThaDafinser]

From @creifferscheid on June 30, 2014 16:56

I guess the problem is in the jqGrid renderer getFilters() function. There is no uniqueId for the columns posted.

if ($request->getPost($column->getUniqueId()) != '') {
...
}

Maybe @ThaDafinser can verify this?

[ThaDafinser]

This is currently not supported.
See filtering for this renderer, you could adjust it there for groupSearch
https://github.com/ThaDafinser/ZfcDatagrid/blob/master/src/ZfcDatagrid/Renderer/JqGrid/Renderer.php#L101-L140

BUT
All datasources are currently only using AND operator:
https://github.com/ThaDafinser/ZfcDatagrid/blob/master/src/ZfcDatagrid/DataSource/Doctrine2/Filter.php#L133-L137

So this would be a bigger refactoring