只查找连接条件匹配的父节点


Find only parents where join-condition matches

我有两个相关的模型。现在我需要从UserField上的连接条件匹配的Field-Model中检索数据:

我有UserField的ID,想要得到它的相关字段(-data):对应的sql如下所示:

SELECT Field.* 
FROM fields AS Field 
  JOIN user_fields AS UserField 
    ON UserField.field_id = Field.id 
WHERE UserField.id = 3;

我想用蛋糕模型逻辑来写这个。

模型:

class Field extends AppModel {
     public $hasMany = array(
          'UserField' => array(
               'className' => 'UserField',
               'foreignKey' => 'field_id'
          )
     );
}
class UserField extends AppModel {
     public $belongsTo = array(
          'Field' => array(
               'className' => 'Field'
          )
     );
}

:

$this->Field->hasMany['UserField']['conditions'] = array('UserField.id' => 3);
$this->Field->find('all');

查询的Result都是Fields,而UserField只在条件匹配的地方设置。我需要将结果限制为只匹配大小写:

array(
    (int) 0 => array(
        'Field' => array(
            'id' => (int) 1
        ),
        'UserField' => array()
    ),
    (int) 1 => array(
        'Field' => array(
            'id' => (int) 2
        ),
        'UserField' => array()
    ),
    (int) 2 => array(
        'Field' => array(
            'id' => (int) 3
        ),
        'UserField' => array(
            'id' => (int) 3
        )
    )
)

我的期望

array(
    (int) 2 => array(
        'Field' => array(
            'id' => (int) 3
        ),
        'UserField' => array(
            'id' => (int) 3
        )
    )
)

UserField是可选的,我只想检索字段数据

我相信你想做这样的事情:

$rows = $this->Field->find('all', array(
    'conditions' => array(
        'UserField.id' => 3
    )
);