Update for this thread - in Version 4.0.1 the line has moved to the function getPackagePricing and constructed in a slightly different way:
Before:
private function getPackagePricing($package_id)
{
$fields = ['package_pricing.id', 'package_pricing.pricing_id', 'package_pricing.package_id', 'pricings.term',
'pricings.period', 'pricings.price', 'pricings.setup_fee',
'pricings.cancel_fee', 'pricings.currency'];
return $this->Record->select($fields)->from('package_pricing')->
innerJoin('pricings', 'pricings.id', '=', 'package_pricing.pricing_id', false)->
where('package_pricing.package_id', '=', $package_id)->
order(['period' => 'ASC', 'term' => 'ASC'])->fetchAll();
}
After:
private function getPackagePricing($package_id)
{
$fields = ['package_pricing.id', 'package_pricing.pricing_id', 'package_pricing.package_id', 'pricings.term',
'pricings.period', 'pricings.price', 'pricings.setup_fee',
'pricings.cancel_fee', 'pricings.currency'];
return $this->Record->select($fields)->from('package_pricing')->
innerJoin('pricings', 'pricings.id', '=', 'package_pricing.pricing_id', false)->
where('package_pricing.package_id', '=', $package_id)->
order(['period' => 'DESC', 'term' => 'DESC'])->fetchAll();
}
So change the Order clause to DESC instead of ASC (y)