在CakePHP 3中的关联模型上查找条件
在CakePHP 3中的关联模型上查找条件
提问于 2016-09-18 21:24:07
我有两张桌子orders和sub_orders。它们的关联性是
$orders->hasMany('SubOrders', [
'foreignKey' => 'order_id'
]);这两个表在orders和sub_orders中分别有invoice_no和sub_invoice列。
我必须从包含相关sub_orders的orders表中查找记录，其中$trackingId将匹配Orders.invoice_no或SubOrders.sub_invoice
$findOrder = $this->Orders->find('all', [
'conditions' => [
'OR' => [
'Orders.invoice_no' => $trackingId,
'SubOrders.sub_invoice' => $trackingId
]
],
'contain' => [
'SubOrders'
]
]);但这会产生错误
Column not found: 1054 Unknown column 'SubOrders.sub_invoice' in 'where clause'回答 1
Stack Overflow用户
回答已采纳
发布于 2016-09-18 23:24:50
尝试像这样执行查询：
$findOrder = $this->Orders->find()
->where(['Orders.invoice_no' => $trackingId])
->contain(['SubOrders' => function ($q) use ($trackingId) {
return $q
->where(['SubOrders.sub_invoice' => $trackingId]);
}
]);页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/39558115
复制相关文章
相似问题