lidongdong
2023-11-21 147259d14e568a8780ccf9fad2a65e04a4bfdd35
增加  用户社区积分排名2
2个文件已修改
7 ■■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/NewStriveAppApi.java 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActIntegralUserDOMapper.xml 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/NewStriveAppApi.java
@@ -781,8 +781,6 @@
    }
    @ApiOperation(value = "获取社区积分排名")
    @GetMapping("/getIntegralUserRank")
    public R  getIntegralUserRank()
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActIntegralUserDOMapper.xml
@@ -43,6 +43,8 @@
        ORDER BY amount DESC
    </select>
<!--    WHERE-->
<!--    caiu.community_id = #{communityId}-->
    <select id="getIntegralUserRank" resultType="com.panzhihua.common.model.vos.community.integral.IntegralUserRankVO">
        SELECT
            *
@@ -59,8 +61,7 @@
                    FROM
                    com_act_integral_user as caiu
                    left join sys_user as su on su.user_id = caiu.user_id
                    WHERE
                    caiu.community_id = #{communityId}
                    ORDER BY
                    caiu.integral_sum DESC,su.create_at asc
                    ) AS t1,