分页排序在Cakephp 3.x [英] Pagination Sort in Cakephp 3.x

问题描述

在cakephp 3.xi不能在查找中分页命令

In cakephp 3.x i can't do paginate order in a find

这是我的控制器：

//AgentsController.php
public function show()
{
    $agents = $this->Agents->find()
    $this->set('agents', $this->paginate($agents));
}

这里是我的一部分

//show.ctp
<!-- ....... -->
<table class="table table-striped">
   <thead>
      <tr>
        <th>
            <?php echo $this->Paginator->sort('full_name', 'Nome', array('escape' => false)); ?>
        </th>
        <th>
            <?php echo $this->Paginator->sort('username', 'Email', array('escape' => false)); ?>
        </th>
        <th>
            <?php echo $this->Paginator->sort('regions', 'Regioni', array('escape' => false)); ?>
        </th>
      </tr>
   </thead>
<!-- ....... -->

哪里错了？

推荐答案

Paginator将阻止任何通过在您使用的查询的主表中不存在的列进行排序的尝试。在这种情况下，您有2个选项。第一个选项是更改排序链接以告诉蛋糕该列属于相关的表：

The Paginator will block any attempt of sorting by a column that does not exist in the primary table of the query you are using. In this case you have 2 options. The first option is changing the sort links to tell cake that the column belongs to a related table:

<?php echo $this->Paginator->sort('Users.full_name', 'Nome'); ?>

或者你可以在组件中告诉它允许按给定的列进行排序： p>

Or you can tell it in the component that sorting by a given set of columns is allowed:

$this->paginate = ['sortWhitelist' => ['full_name', 'username']]

这篇关于分页排序在Cakephp 3.x的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！