springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/partybuilding/PagePartyOrganizationVO.java
@@ -59,4 +59,7 @@ private Date endTime; @ApiModelProperty(value = "特长类别") private String specialtyName; @ApiModelProperty("归属区") private String belongTo; } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/ComPbCheckUnitApi.java
@@ -1,5 +1,6 @@ package com.panzhihua.community_backstage.api; import cn.hutool.core.util.ArrayUtil; import com.alibaba.excel.EasyExcel; import com.alibaba.excel.ExcelWriter; import com.alibaba.excel.write.metadata.WriteSheet; @@ -75,6 +76,10 @@ @PostMapping("/page") public R queryByPage(@RequestBody PageComPbCheckUnitDto comPbCheckUnit) { //comPbCheckUnit.setCommunityId(this.getCommunityId()); String[] area={"东区","仁和区","米易县","盐边县"}; if(ArrayUtil.contains(area,this.getLoginUserInfo().getName())){ comPbCheckUnit.setBelongTo(this.getLoginUserInfo().getName()); } return this.comPbCheckUnitService.queryByPage(comPbCheckUnit); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/CommunityPartyBuildingApi.java
@@ -11,6 +11,7 @@ import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import cn.hutool.core.util.ArrayUtil; import com.panzhihua.common.listen.ComPbCheckUnitExcelListen; import com.panzhihua.common.listen.ComPbMemberRoleExcelListen; import com.panzhihua.common.model.dtos.partybuilding.ComDataStatisticsOrgDto; @@ -282,6 +283,10 @@ @PostMapping("pagepartyorganization") public R pagePartyOrganization(@RequestBody PagePartyOrganizationVO pagePartyOrganizationVO) { //pagePartyOrganizationVO.setCommunityId(this.getCommunityId()); String[] area={"东区","仁和区","米易县","盐边县"}; if(ArrayUtil.contains(area,this.getLoginUserInfo().getName())){ pagePartyOrganizationVO.setBelongTo(this.getLoginUserInfo().getName()); } return partyBuildingService.pagePartyOrganization(pagePartyOrganizationVO); } @ApiOperation(value = "党员时长信息导出", response = PartyBuildingMemberVO.class) springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberMapper.xml
@@ -104,6 +104,9 @@ <if test="dto.specialtyName != null and dto.specialtyName !=''"> and m.specialty_name like concat('%',#{dto.specialtyName},'%') </if> <if test="dto.belongTo !=null and dto.belongTo !=''"> and cpcu.belong_to = #{dto.belongTo} </if> </where> order by m.create_at desc </select>