db.categoryGoods.aggregate([{$match:{categoryId:2841}}
,{$lookup:{from:"goods",localField:"goodsId",foreignField:"_id",as:"goods"}}
,{$project:{_id:0,goods:1}}
,{$unwind:"$goods"}
,{$match:{"goods.volume":{$lte:100}}}
,{$sort:{"goods.volume":-1,"goods._id":1}}
,{$skip:2}
,{$limit:5}
])
昨天整了一天，沒整出來，有沒有php mongodb大神，幫忙把上面的mongodb命令翻譯成php的執行語法？
1 回答
紫衣仙女
TA貢獻1839條經驗 獲得超15個贊
$sortMap = [
['position' => 1, 'goods._id' => 1],
['goods.volume' => -1, 'goods._id' => 1],
['goods.payPrice' => -1, 'goods._id' => 1],
['goods.payPrice' => 1, 'goods._id' => 1],
['goods.commissionRate' => -1, 'goods._id' => 1],
['goods.createTime' => -1, 'goods._id' => 1],
];
if ($activeId <= 0 || !in_array($sortType, array_keys($sortMap))) {
return $res;
}
$mongo = MongodbService::getInstance();
$sort = $sortMap[$sortType];
$offset = ($page -1) * $pageSize;
$pipe = [
['$match' => ['activeId' => intval($activeId)]],
['$lookup' => ['from' => 'goods', 'localField'=> 'goodsId', 'foreignField'=>'_id', 'as'=>'goods']],
['$project' => ['_id' => 0, 'goods' => 1, 'position' => 1]],
['$unwind' => '$goods'],
['$sort' => $sort],
['$skip' => $offset],
['$limit' => intval($pageSize)]
];
$info = $mongo->selectDatabase('shopping')->selectCollection('activeGoods')->aggregate($pipe);
foreach ($info as $value) {
array_push($res['list'], $this->formatGoodsList($value["goods"]));
}mongodb鏈表查詢 mongodb-$lookup
- 1 回答
- 0 關注
- 377 瀏覽
添加回答
舉報
0/150
提交
取消