| | |
| | | "join com_mng_struct_build_type t on b.type_id=t.id\n" + |
| | | " <where>" + |
| | | "<if test='comMngStructOtherBuildVO.name != null and comMngStructOtherBuildVO.name.trim() != ""'>" + |
| | | "b.name like concat(#{comMngStructOtherBuildVO.name},'%') "+ |
| | | " and b.name like concat(#{comMngStructOtherBuildVO.name},'%') "+ |
| | | " </if> " + |
| | | "<if test='comMngStructOtherBuildVO.communityId != null'>" + |
| | | " and b.community_id = #{comMngStructOtherBuildVO.communityId} "+ |
| | | " </if> " + |
| | | " </where>" + |
| | | " order by b.create_at desc" + |
| | |
| | | AND grid_id = #{statisticsDTO.gridId} |
| | | </if> |
| | | <if test='statisticsDTO.startTime != null and statisticsDTO.startTime != ""'> |
| | | AND create_at <![CDATA[ >= ]]> #{statisticsDTO.startTime} |
| | | AND submit_date <![CDATA[ >= ]]> #{statisticsDTO.startTime} |
| | | </if> |
| | | <if test='statisticsDTO.endTime != null and statisticsDTO.endTime != ""'> |
| | | AND create_at <![CDATA[ <= ]]> #{statisticsDTO.endTime} |
| | | AND submit_date <![CDATA[ <= ]]> #{statisticsDTO.endTime} |
| | | </if> |
| | | ) AS eventZFTotal, |
| | | ( |
| | |
| | | String orgName = partyBuildingMemberExcelVO.getOrgName(); |
| | | List<PartyOrganizationVO> collect = partyOrganizationVOArrayList.stream().filter(partyOrganizationVO -> orgName.equals(partyOrganizationVO.getName())).collect(Collectors.toList()); |
| | | if (ObjectUtils.isEmpty(collect)) { |
| | | throw new PartyBuildingMemberException("导入失败,组织不存在"+partyBuildingMemberExcelVO.getOrgName()); |
| | | throw new PartyBuildingMemberException("导入失败,组织不存在"+partyBuildingMemberExcelVO.getOrgName() + ",请先在“党支部管理”中添加该党支部"); |
| | | }else{ |
| | | PartyOrganizationVO partyOrganizationVO = collect.get(0); |
| | | comPbMemberDO.setOrgId(partyOrganizationVO.getId()); |