join in cakephp 2.x


join in cakephp 2.x

如何在cakepp中实现此查询?我无法从"用户"表中获取信息。

    SELECT * FROM Manufacture LEFT JOIN Order ON Manufacture.order_id = Order.id
LEFT JOIN User ON Order.user_id = User.id;

制造商:id order_id

订单:id user_id

用户:id name

class Manufacture extends AppModel {
    public $belongsTo = array(
        'Order' => array(
            'className' => 'Order',
            'foreignKey' => 'order_id'
        )
    );
}
class Order extends AppModel {
    public $belongsTo = array(
        'User' => array(
            'className' => 'User',
            'foreignKey' => 'user_id'
        ));
}
class User extends AppModel {
}

控制器内:

$this->Paginator->settings = array( 'limit' => 15 ); 
$this->set('entities', $this->Paginator->paginate('Manufacture'));

阅读官方文档的联接部分。它附带了一些例子。

当你读到这篇文章,仍然有问题时,请告诉我们。