首頁猿問 php鏈表Mongodb查詢？

php鏈表Mongodb查詢？

PHP

牛魔王的故事 2019-03-07 23:33:19

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的執(zhí)行語法？

查看完整描述

1 回答

紫衣仙女

TA貢獻(xiàn)1839條經(jīng)驗(yàn) 獲得超15個(gè)贊

$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

反對回復(fù) 2019-03-18