饼PHP的使用条件及在分页中的订购

Question

我正在尝试使用分页器助手的条件和按饼排序的PHP分页函数

这是我正在使用的代码

$this->set('equipment', $this->Paginator->paginate('Equipment',array('conditions' => array('Equipment.equipment_type_id' => 19), 'order' => array('Equipment.problem_count', 'Equipment.barcode DESC'))));

但它给了我这个错误

错误: SQLSTATE42S22:未找到列：'where子句‘中的1054个未知列“条件”

SQL查询:选择Equipment.id、Equipment.equipment_type_id、Equipment.barcode、Equipment.problem_count、Equipment.description、Equipment、created、Equipment.modified、EquipmentType.id、EquipmentType.name、d19.created，EquipmentType.modified ON unlibike.equipment AS Equipment LEFT .equipment_types AS EquipmentType ON (Equipment.equipment_type_id = EquipmentType.id)，其中条件= (19)和d33在(‘Equipment.Probt_count’，'Equipment.barcode DESC')中限制为20

通过查看生成的SQL查询，它看起来像是Cake将“条件”和“Order”解释为一列。

有谁可以帮我？

Answer 1

按分页器顺序排列的参数：：分页

* @param Model|string $object Model to paginate (e.g: model instance, or 'Model', or 'Model.InnerModel')
* @param string|array $scope Additional find conditions to use while paginating
* @param array $whitelist List of allowed fields for ordering. This allows you to prevent ordering
 *   on non-indexed, or undesirable columns. See PaginatorComponent::validateSort() for additional details
 *   on how the whitelisting and sort field validation works.

paginate

例子：

$this->Paginator->settings = array(
        'order'=>array('yourfields');
);

$this->Pagniator->paginate('Equipment', $conditionsArray ) ;