这篇博客详细介绍了如何使用 MongoDB 进行复杂的查询和聚合操作。内容包括使用 $sortMap 对商品数据进行排序，通过 $lookup 实现表关联，以及利用 $match、$project、$unwind、$skip 和 $limit 进行数据筛选、投影、展开、跳过和限制。文章深入探讨了 MongoDB 的聚合管道操作，展示了在购物平台中获取活动商品列表的具体实现步骤。
紫衣仙女
$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
扫一扫
2614
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
