如何使用post计算字段对Cakephp查询进行排序并将其传递给分页？

echo $this->Form->create(null, ['url' => ['action' => 'index']]);
echo $this->Form->select('sort_field', ['field1' => 'Field 1', 'field2' => 'Field 2']);
echo $this->Form->select('sort_direction', ['asc' => 'Ascending', 'desc' => 'Descending']);
echo $this->Form->submit('Sort');
echo $this->Form->end();

public function index() {
    $sortField = $this->request->getData('sort_field');
    $sortDirection = $this->request->getData('sort_direction');

    $query = $this->YourModel->find();

    if (!empty($sortField) && !empty($sortDirection)) {
        $query->order([$sortField => $sortDirection]);
    }

    // 其他查询条件和分页逻辑

    $this->set('data', $this->paginate($query));
}

foreach ($data as $item) {
    // 显示数据
}