Sane default pagination order baked by default

[dereuromark]

Description

I had to do this a lot manually over the years
We should probably adapt this as a sane default of sorts:
dereuromark/cakephp-setup@f22cda0

The idea is that once there is a field like created, the pagination would sort DESC on this.
As it is usually not useful to scroll to the last page here to see the latest updates coming into this table.
I never had to NOT use this so far.

The generated code above the actions would be e.g.

class BanksController extends AppController
{
    /**
     * @var array<string, mixed>
     */
    protected array $paginate = [
        'order' => [
            'Banks.created' => 'DESC',
        ],
    ];

[ADmad]

While having a good default order is nice always using the created column isn't. I add the created/modified column to almost all tables but there are cases where alphabetical sorting on the display field is preferred.

Also I handle the default ordering at the model level using the Orderly plugin.

[dereuromark]

So you say we shouldnt bake this in by default?

[ADmad]

No we shouldn't. It would be fine as an option for the controller command, for e.g. --paginate-order created.

[dereuromark]

That sounds like a useful addition via param or config :)
If anyone wants to add it, based on my work in my plugin.