Combined Sort Pagination

Including "SortableFieldsBuilder" functionality and Paginator defaulting.

Try Combined Sort

Array
(
)

No sorting applied

Implementation

// Controller - Using SortableFieldsBuilder (CakePHP 5.3)
$this->paginate = [
    'sortableFields' => function ($builder) {
        return $builder
            ->add('title')          // Allows: title-asc, title-desc
            // Lock price to ascending only (for demo purposes)
            ->add('price', SortField::asc('price', locked: true))
            ->add('stock')          // Allows: stock-asc, stock-desc
            ->add('created')        // Allows: created-asc, created-desc
            ->add('modified', SortField::desc('modified'))  // Defaults to DESC
            // Custom multi-column sort: expensive items first (DESC only, locked)
            ->add('expensive', SortField::desc('price', locked: true), SortField::desc('created', locked: true))
            // Custom multi-column sort: availability (price + stock, not locked, can toggle)
            ->add('availability', 'price', 'stock');
    },
    'limit' => 10,
    'maxLimit' => 10,       // Enforce maximum limit
];

// Key Features Demonstrated:
// - Combined sort format: field-direction (e.g., title-asc)
// - Locked direction: price always sorts ASC, expensive always sorts DESC
// - Default direction: modified defaults to DESC (most recent first)
// - Multi-column custom sort (locked): 'expensive' sorts by price DESC, then created DESC
// - Multi-column custom sort (unlocked): 'availability' sorts by price, then stock (toggleable)
// - Pagination limit enforcement via maxLimit