php链表Mongodb查询？

Question

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的执行语法？

Answer 1

$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