cakephp - 如何在 cakephp 连接数组中写入顺序和限制

Question

我在 cakephp 中加入如下:

$emp = $this->EmployeePersonal ->find(
          'all',
          array(
              'fields' => array('EmployeePersonal.*', 'PermanentDist.name','PresentDist.name','EmployeePosting.*','Designation.name','Department.name','Office.name' ),
              'conditions' => $condition,
              'order' => array('Designation.id'),
              'recursive' => -1,
              'joins' => array(
                          array(
                                   .................
                                   .................
                           ),

                   array(
                      'table' => 'employee_postings',
                      'alias' => 'EmployeePosting',
                      'type' => 'LEFT',
                      'order' => 'EmployeePosting.posting_from DESC',
                      'limit' => 1,
                      'conditions' => array(
                          'EmployeePosting.employee_personal_id = EmployeePersonal.id',
                      )
                  ),
              )
          )
);

但是线条

'order' => 'EmployeePosting.posting_from DESC',
'limit' => 1,

不工作!这意味着虽然我期望获得最新的 posting_from 值，但我得到了所有值!我哪里做错了？我想我把 order limit 写错了地方。

Answer 1

要获取最新的 posting_from，您必须使用 'group_by' => 'employee_personal_id' 而不是 'limit' => '1'和 'order' => 'EmployeePosting.posting_from DESC' 将在同一个数组中保持不变。