我有两个型号用户&角色
@H_403_25@
你只需要使用这个:
这里“Roles hasMany Users”和“Users areTo Roles”
问题:
我有列firstname,lastname,roles的用户列表.每个&每列都有排序,但角色排序不起作用.
角色表包含角色名称的“名称”字段.
我在下面提到了链接,但它对我不起作用.
Pagination Sort in Cakephp 3.x
UsersController:
public function index() { $this->paginate = [ 'contain' => ['Roles'],'conditions' => [ 'Users.user_type <>' => 1 ] ]; $this->set('users',$this->paginate($this->Users)); $this->set('_serialize',['users']); }
index.ctp
<tr> <th><?PHP echo $this->Paginator->sort('firstname',__('First Name')) ?></th> <th><?PHP echo $this->Paginator->sort('lastname',__('Last Name')) ?></th> <th><?PHP echo $this->Paginator->sort('email',__('Email Address')) ?></th> <th><?PHP echo $this->Paginator->sort('Roles.name',__('Role Associated')) ?></th> <th><?PHP echo $this->Paginator->sort('status',__('status')) ?></th> <th class="actions"><?PHP echo __('action') ?></th> </tr>
让我知道你有任何解决方案.
$this->paginate = [ 'sortWhitelist'=>['Roles.name'] ];