CakePHP pagination sort (by multiple criteria) issue

Question

I am currently trying to perform pagination using CakePHP's pagination helper.

I have a series of "Listing" rows that are returned and paginated as expected. When the user clicks on the column headings however, I'd like the sort() method to be forced to prioritise certain listings (i.e. priority listings, those with ['Listing']['priority_flag'] = 1) first. However, when the user clicks on the column header, the browser url is set to

www.mysite.com/listing/index/page:1/sort:description/direction:asc

Hence, it is only sorting by description (as the user clicked on the column header for 'description'), ignoring anything to do with priority_flag.

All help appreciated!

gaioshin

Answer 1

I did this by writing an override paginate() function on the appropriate model. For the parameters, look carefully at the structure of the url you have pasted (you can modify it to suit your own ends, but then you would need to deviate from the pagination helper).

It's not difficult to do, but will require some thought. Look at the core to see how it works.

Answer 2

Take a look here.