| | |
| | | for (LargeKeyGridUserImport largeKeyGridUserImport : largeKeyGridUserImports) { |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getGridInfo())){ |
| | | result.append("第"+i+"行:[", "网格"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getCommunityName())){ |
| | | result.append("第"+i+"行:[", "小区名称"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getBuildingInfo())){ |
| | | result.append("第"+i+"行:[", "楼栋信息"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getUnitNumber())){ |
| | | result.append("第"+i+"行:[", "单元号"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getHouseNumber())){ |
| | | result.append("第"+i+"行:[", "门牌号"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getUserName())){ |
| | | result.append("第"+i+"行:[", "姓名"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getUserSexStr())){ |
| | | result.append("第"+i+"行:[", "性别"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getIdCard())){ |
| | | result.append("第"+i+"行:[", "身份证号"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (largeKeyGridUserImport.getIdCard().matches("^$|(^[1-9]\\\\d{7}((0\\\\d)|(1[0-2]))(([0-2]\\\\d)|3[0-1])\\\\d{3}$)|(^[1-9]\\\\d{5}[1-9]\\\\d{3}((0\\\\d)|(1[0-2]))(([0-2]\\\\d)|3[0-1])((\\\\d{4})|\\\\d{3}[Xx])$)")){ |
| | | if (!largeKeyGridUserImport.getIdCard().matches("^$|(^[1-9]\\d{7}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])\\d{3}$)|(^[1-9]\\d{5}[1-9]\\d{3}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])((\\d{4})|\\d{3}[Xx])$)")){ |
| | | result.append("第"+i+"行:[", "身份证号"+"]格式不正确"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getContactNumber())){ |
| | | result.append("第"+i+"行:[", "联系电话"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (largeKeyGridUserImport.getContactNumber().matches("^1[3-9]\\\\d{9}$")){ |
| | | if (!largeKeyGridUserImport.getContactNumber().matches("^$|^1[3-9]\\d{9}$")){ |
| | | result.append("第"+i+"行:[", "联系电话"+"]格式不正确"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getTypeName())){ |
| | | result.append("第"+i+"行:[", "类型名称"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | TLargeKeyGridUser largeKeyGridUser = new TLargeKeyGridUser(); |
| | |
| | | break; |
| | | default: |
| | | result.append("第"+i+"行:[", "性别"+"]格式错误"); |
| | | i++; |
| | | continue; |
| | | } |
| | | |
| | |
| | | .last("LIMIT 1")); |
| | | if(Objects.isNull(largeKeyPersonnelType)){ |
| | | result.append("第"+i+"行:[", "类型名称"+"]不存在"); |
| | | i++; |
| | | continue; |
| | | } |
| | | largeKeyGridUser.setTypeId(largeKeyPersonnelType.getId()); |
| | |
| | | for (LargeKeyGridUserImport largeKeyGridUserImport : largeKeyGridUserImports) { |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getGridInfo())){ |
| | | result.append("第"+i+"行:[", "网格"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getCommunityName())){ |
| | | result.append("第"+i+"行:[", "小区名称"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getBuildingInfo())){ |
| | | result.append("第"+i+"行:[", "楼栋信息"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getUnitNumber())){ |
| | | result.append("第"+i+"行:[", "单元号"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getHouseNumber())){ |
| | | result.append("第"+i+"行:[", "门牌号"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getUserName())){ |
| | | result.append("第"+i+"行:[", "姓名"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getUserSexStr())){ |
| | | result.append("第"+i+"行:[", "性别"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getIdCard())){ |
| | | result.append("第"+i+"行:[", "身份证号"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (largeKeyGridUserImport.getIdCard().matches("^$|(^[1-9]\\\\d{7}((0\\\\d)|(1[0-2]))(([0-2]\\\\d)|3[0-1])\\\\d{3}$)|(^[1-9]\\\\d{5}[1-9]\\\\d{3}((0\\\\d)|(1[0-2]))(([0-2]\\\\d)|3[0-1])((\\\\d{4})|\\\\d{3}[Xx])$)")){ |
| | | if (!largeKeyGridUserImport.getIdCard().matches("^$|(^[1-9]\\d{7}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])\\d{3}$)|(^[1-9]\\d{5}[1-9]\\d{3}((0\\d)|(1[0-2]))(([0|1|2]\\d)|3[0-1])((\\d{4})|\\d{3}[Xx])$)")){ |
| | | result.append("第"+i+"行:[", "身份证号"+"]格式不正确"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (!StringUtils.hasLength(largeKeyGridUserImport.getContactNumber())){ |
| | | result.append("第"+i+"行:[", "联系电话"+"]不能为空"); |
| | | i++; |
| | | continue; |
| | | } |
| | | if (largeKeyGridUserImport.getContactNumber().matches("^1[3-9]\\\\d{9}$")){ |
| | | if (!largeKeyGridUserImport.getContactNumber().matches("^$|^1[3-9]\\d{9}$")){ |
| | | result.append("第"+i+"行:[", "联系电话"+"]格式不正确"); |
| | | i++; |
| | | continue; |
| | | } |
| | | TLargeKeyGridUser largeKeyGridUser = new TLargeKeyGridUser(); |
| | |
| | | break; |
| | | default: |
| | | result.append("第"+i+"行:[", "性别"+"]格式错误"); |
| | | i++; |
| | | continue; |
| | | } |
| | | |
| | |
| | | .last("LIMIT 1")); |
| | | if(Objects.isNull(largeKeyPersonnelType)){ |
| | | result.append("第"+i+"行:[", "类型名称"+"]不存在"); |
| | | i++; |
| | | continue; |
| | | } |
| | | largeKeyGridUser.setTypeId(largeKeyPersonnelType.getId()); |