| | |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | @ApiOperation(value = "获取社区积分排名") |
| | | @GetMapping("/getIntegralUserRank") |
| | | public R getIntegralUserRank() |
| | |
| | | ORDER BY amount DESC |
| | | </select> |
| | | |
| | | <!-- WHERE--> |
| | | <!-- caiu.community_id = #{communityId}--> |
| | | <select id="getIntegralUserRank" resultType="com.panzhihua.common.model.vos.community.integral.IntegralUserRankVO"> |
| | | SELECT |
| | | * |
| | |
| | | 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, |