| | |
| | | |
| | | /** |
| | | * 党员积分前3 |
| | | * @param communityId |
| | | * @param pageBigScreenStatisticPartyOrg |
| | | * @return |
| | | */ |
| | | @GetMapping("/bigscreen/party/partyActivityTop") |
| | | R partyActivityTop(@RequestParam("communityId")Long communityId); |
| | | @PostMapping("/bigscreen/party/partyActivityTop") |
| | | R partyActivityTop(@RequestBody PageBigScreenStatisticPartyOrg pageBigScreenStatisticPartyOrg); |
| | | |
| | | /** |
| | | * 社区服务大屏数据分析接口 |
| | |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "党员积分前3", response = BigScreenActivityTop.class) |
| | | @GetMapping("/partyActivityTop") |
| | | public R partyActivityTop(){ |
| | | return communityService.partyActivityTop(this.getCommunityId()); |
| | | @PostMapping("/partyActivityTop") |
| | | public R partyActivityTop(@RequestBody PageBigScreenStatisticPartyOrg pageBigScreenStatisticPartyOrg){ |
| | | pageBigScreenStatisticPartyOrg.setCommunityId(this.getCommunityId()); |
| | | return communityService.partyActivityTop(pageBigScreenStatisticPartyOrg); |
| | | } |
| | | } |
| | |
| | | |
| | | /** |
| | | * 党员积分前3 |
| | | * @param communityId |
| | | * @param pageBigScreenStatisticPartyOrg |
| | | * @return |
| | | */ |
| | | @GetMapping("/partyActivityTop") |
| | | public R partyActivityTop(@RequestParam("communityId")Long communityId){ |
| | | return bigScreenService.partyActivityTop(communityId); |
| | | @PostMapping("/partyActivityTop") |
| | | public R partyActivityTop(@RequestBody PageBigScreenStatisticPartyOrg pageBigScreenStatisticPartyOrg){ |
| | | return bigScreenService.partyActivityTop(pageBigScreenStatisticPartyOrg); |
| | | } |
| | | } |
| | |
| | | * @param communityId |
| | | * @return |
| | | */ |
| | | List<BigScreenActivityTop> selectActivityTop(@Param("communityId") Long communityId); |
| | | IPage<BigScreenActivityTop> selectActivityTop(Page page,@Param("communityId") Long communityId); |
| | | |
| | | /** |
| | | * 服务数据查询 |
| | |
| | | |
| | | /** |
| | | *查询党员积分前3 |
| | | * @param communityId |
| | | * @param pageBigScreenStatisticPartyOrg |
| | | * @return |
| | | */ |
| | | R partyActivityTop(Long communityId); |
| | | R partyActivityTop(PageBigScreenStatisticPartyOrg pageBigScreenStatisticPartyOrg); |
| | | |
| | | /** |
| | | * 服务数据 |
| | |
| | | } |
| | | |
| | | @Override |
| | | public R partyActivityTop(Long communityId) { |
| | | return R.ok(this.comPbMemberDAO.selectActivityTop(communityId)); |
| | | public R partyActivityTop(PageBigScreenStatisticPartyOrg pageBigScreenStatisticPartyOrg) { |
| | | return R.ok(this.comPbMemberDAO.selectActivityTop(new Page(pageBigScreenStatisticPartyOrg.getPageNum(),pageBigScreenStatisticPartyOrg.getPageSize()),pageBigScreenStatisticPartyOrg.getCommunityId())); |
| | | } |
| | | |
| | | @Override |
| | |
| | | </select> |
| | | |
| | | <select id="selectActivityTop" resultType="com.panzhihua.common.model.vos.community.bigscreen.BigScreenActivityTop"> |
| | | select t.name,t.photo_path as url,t1.name as orgName,t2.integral_available_party as score from com_pb_member t LEFT JOIN com_pb_org t1 on t.org_id= t1.id LEFT JOIN com_act_integral_user t2 on t.user_id = t2.user_id where t.community_id =#{communityId} and t2.status = 1 order by integral_available_party desc limit 100 |
| | | select t.name,t.photo_path as url,t1.name as orgName,t2.integral_available_party as score from com_pb_member t LEFT JOIN com_pb_org t1 on t.org_id= t1.id LEFT JOIN com_act_integral_user t2 on t.user_id = t2.user_id where t.community_id =#{communityId} and t2.status = 1 order by integral_available_party desc |
| | | </select> |
| | | |
| | | <select id="bigScreenServiceData" resultType="com.panzhihua.common.model.vos.community.bigscreen.BigScreenServiceData"> |