How to sort multiple fields using paginator in CakePHP

Sometimes multiple fields need to be sorted during page turning. However, by default, the paginator sort method of CakePHP can only sort one field.

Sometimes multiple fields need to be sorted during page turning.

However, by default, the paginator sort method of CakePHP can only sort one field.

There are two solutions:

1. append a virtual field to the model:

Http://book.cakephp.org/1.3/view/1608/Virtual-fields

2. Merge the parameters of the default sort method.

Http://www.amityadav.name/cakephp-pagination-sorting-on-2-columns/

In addition, if it is count data, it is said that you can also use the following method:

Http://book.cakephp.org/1.3/view/1033/counterCache-Cache-your-count

Other references:

Http://stackoverflow.com/questions/6018233/cakephp-pagination-sort-by-calculated-field-count