我有以下代码:
// company_ids is an array of mongo IDs
// company_id is an array (with only 1 element) of mongo ID
foreach($company_ids as $company_id){
$results = Archive::where("billing.company._id", 'all', array($company_id))->get();
...
这是Log::info(print_r($company_ids, true))
[2016-10-22 02:41:27] production.INFO: Array
(
[0] => 57515764b91a8c4d008b45d1
[1] => 57515764b91a8c4d008b45d6
[2] => 57515764b91a8c4d008b45db
[3] => 57515764b91a8c4d008b45e0
...
)
如何使用company_ids
直接查询Archive
收集,而不需要foreach
循环?
@Robbie答案的小更新。不需要使用MongoIds
的数组,只需使用字符串数组就可以了。我只使用larvel -jenessenger
$company_ids = [
'57515764b91a8c4d008b45d1',
'57515764b91a8c4d008b45d6',
'57515764b91a8c4d008b45db',
'57515764b91a8c4d008b45e0'
]
$results = Archive::whereIn('billing.company._id', $company_ids)->get();
根据库的自述文件:
$results = Archive::whereIn('billing.company._id', $company_ids)->get();
(我不清楚数组$company_ids是什么,但我认为它需要是和MongoID数组:但这也取决于你正在使用的底层库,Mongo或MongoDB,因为两者都由库支持)
$company_ids = [
new mongoID('57515764b91a8c4d008b45d1'),
new mongoID('57515764b91a8c4d008b45d6'),
new mongoID('57515764b91a8c4d008b45db'),
new mongoID('57515764b91a8c4d008b45e0'),
]