php - 当我尝试 CakePHP 方式时，Cakephp 2.8.x 查询访问冲突。正常查询有效

Question

我创建了一个查询，但现在我需要将其重构为 CakePHP 标准。只是我似乎无法让它工作。

这是我的工作查询:

 $query = $this->Transfer->query( "SELECT DISTINCT emailaddresses.emailaddress
                  FROM transfers 
                  JOIN emailaddresses 
                  ON (emailaddresses.transfer_id = transfers.transfer_id AND emailaddresses.type <> 'SENDER' AND emailaddresses.received_state = 'DELIVERED')
                  WHERE transfers.created_user_id = $created_user_id " );

这个查询正在工作，但是当我尝试 Cakeify 时，我的表电子邮件地址的访问被拒绝。这是 CakePHP 查询:

                $query = $this->Transfer->find('all', array(
                'fields' => 'DISTINCT Emailaddress.emailaddress ',
                'conditions' => array(
                    'transfers.created_user_id' => $created_user_id
                ),
                'joins' => array(
                    array(
                        'table' => 'Emailaddress.emailaddress',
                        'type' => 'INNER',
                        'conditions' => array(
                                'Emailaddress.transfer_id' => 'Transfer.transfer_id',
                                'Emailaddress.type' => 'SENDER',
                                'Emailaddress.received_state' => 'DELIVERED'

                        )
                    )
                )
            ));

我需要更改什么才能使此查询符合 Cake 标准？

Answer 1

您的查询如下:

$query = $this->Transfer->find('all', array(
    //'fields' => 'DISTINCT Emailaddress.emailaddress ',
    'fields' => array('DISTINCT Emailaddress.emailaddress '),
    'conditions' => array(
        //'transfers.created_user_id' => $created_user_id
        'Transfer.created_user_id' => $created_user_id
    ),
    'joins' => array(
        array(
            //'table' => 'Emailaddress.emailaddress',
            'table' => 'emailaddresses',
            'alias' => 'Emailaddress', // add alias
            'type' => 'INNER',
            'conditions' => array(
                    'Emailaddress.transfer_id' => 'Transfer.transfer_id',
                    //'Emailaddress.type' => 'SENDER',
                    'Emailaddress.type <>' => 'SENDER',
                    'Emailaddress.received_state' => 'DELIVERED'

            )
        )
    )
));

了解更多:

• http://book.cakephp.org/2.0/en/models/retrieving-your-data.html#find
• http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#joining-tables