如何在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'));
阅读官方文档的联接部分。它附带了一些例子。
当你读到这篇文章,仍然有问题时,请告诉我们。