MongoDB 按积分进行排名

最新推荐文章于 2024-07-07 11:41:27 发布

laiyongq

最新推荐文章于 2024-07-07 11:41:27 发布

阅读量510

点赞数

文章标签： mongodb

本文链接：https://blog.csdn.net/qq_27354909/article/details/129812796

版权

方案一、同分不同排名

db.getCollection("userCreditHourChangeRecord").aggregate([
    {
        $match: {
            "userNo":{
                $ne: null
            }
        }
    },
    {
        $group: {
            "_id": "$userNo",
            "userNo": {
                $first: "$userNo"
            },
            "total": {
                $sum: "$realChangeScore"
            }
        }
    },
    {
        $sort: {
            "total": - 1
        }
    },
    {
        $group: {
            "_id": null,
            "items": {
                "$push": "$$ROOT"
            }
        }
    },
    {
        $unwind: {
            path: "$items",
            includeArrayIndex: "rank"
        }
    },
    {
        $project: {
            "_id": 0,
            "userNo": "$items.userNo",
            "total": "$items.total",
            "rank": {
                $add: ["$rank", 1]
            }
        }
    }
])

结果：
在这里插入图片描述

方案二、同分同排名，排名连续

db.getCollection("userCreditHourChangeRecord").aggregate([
    {
        $match: {
            "userNo": {
                $ne: null
            }
        }
    },
    {
        $group: {
            "_id": "$userNo",
            "userNo": {
                $first: "$userNo"
            },
            "total": {
                $sum: "$realChangeScore"
            }
        }
    },
    {
        $group: {
            "_id": "$total",
            "total": {
                $first: "$total"
            },
            "userNos": {
                $push: "$userNo"
            }
        }
    },
    {
        $sort: {
            "total": - 1
        }
    },
    {
        $group: {
            "_id": null,
            "items": {
                "$push": "$$ROOT"
            }
        }
    },
    {
        $unwind: {
            path: "$items",
            includeArrayIndex: "rank"
        }
    },
    {
        $project: {
            "_id": 0,
            "userNos": "$items.userNos",
            "total": "$items.total",
            "rank": {
                $add: ["$rank", 1]
            }
        }
    },
    // 按用户编号拆分
    {
        $unwind: {
            path: "$userNos"
        }
    }
])