| | |
| | | @ApiModelProperty(value = "创建结束时间", hidden = false, example = "2021-05-02 18:05:50") |
| | | private Date createAtEnd; |
| | | |
| | | @ApiModelProperty(value = "社区ID", hidden = false, example = "") |
| | | private Long communityId; |
| | | } |
| | |
| | | String uuid= UUID.randomUUID().toString().replace("-",""); |
| | | //String name=uuid+".xlsx"; |
| | | |
| | | pageEldersAuthDTO.setCommunityId(getCommunityId()); |
| | | R r = communityService.eldersAuthQuery(pageEldersAuthDTO); |
| | | if (R.isOk(r)) { |
| | | List<ExcelElderAuthDTO> excelElderAuthDTO = JSONArray.parseArray(JSONArray.toJSONString(r.getData()),ExcelElderAuthDTO.class); |
| | |
| | | " LEFT JOIN com_act ac ON u.community_id = ac.community_id\n" + |
| | | " <where> " + |
| | | |
| | | "<if test='pageEldersAuthDTO.communityId != null'>" + |
| | | " ac.id = #{pageEldersAuthDTO.communityId} " + |
| | | " </if> " + |
| | | |
| | | "<if test='pageEldersAuthDTO.ids != null and pageEldersAuthDTO.ids.length>0 '>" + |
| | | " AND ea.id in " + |
| | | "<foreach collection='pageEldersAuthDTO.ids' item='id' index='index' open='(' close=')' separator=',' >\n" + |