| | |
| | | OneMapMapper aMapOfPipelineMapper; |
| | | |
| | | /** |
| | | * 测量 |
| | | */ |
| | | private static String measurement = "测量(ESV)"; |
| | | /** |
| | | * 调查 |
| | | */ |
| | | private static String toInvestigate = "勘察(EGE)"; |
| | | /** |
| | | * 地灾 |
| | | */ |
| | | private static String disaster = "地灾(EGD)"; |
| | | /** |
| | | * 地下结构洞库 |
| | | */ |
| | | private static String undergroundStructure = "洞库(EGD)"; |
| | | |
| | | /** |
| | | * 项目类别conut |
| | | */ |
| | | @Override |
| | |
| | | return aMapOfPipelineMapper.selectProjectTour(); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 统计项目类型 |
| | | * 选择项目类型 |
| | | * |
| | | * @return {@link List}<{@link String}> |
| | | * @return {@link List}<{@link OneMapEntity}> |
| | | */ |
| | | @Override |
| | | public List<OneMapEntity> selectProjectType1() { |
| | | |
| | | |
| | | List<OneMapEntity> resList = new ArrayList<>(); |
| | | |
| | | List<OneMapEntity> resInfo = aMapOfPipelineMapper.selectProjectType1(); |
| | | for (OneMapEntity oneMapEntity : resInfo) { |
| | | if (oneMapEntity.getValue().equals("测量(ESV)")) { |
| | | String valueStr = oneMapEntity.getKey(); |
| | | System.out.println("测量(ESV)== valueStr == " + valueStr); |
| | | String endSql = null; |
| | | String sqlQur = ""; |
| | | if (valueStr.length() > 0) { |
| | | String[] arrStr = valueStr.split(","); |
| | | StringBuilder one = new StringBuilder(); |
| | | if (arrStr.length > 0) { |
| | | System.out.println("arrStr = " + arrStr.length); |
| | | } |
| | | for (String s : arrStr) { |
| | | sqlQur = "\'" + s + "%\' " + "or dircode like"; |
| | | one.append(sqlQur); |
| | | } |
| | | endSql = " where dircode like " + one.substring(0, one.toString().length() - 15); |
| | | System.out.println("endSql = " + endSql); |
| | | } |
| | | resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql)); |
| | | |
| | | } else if (oneMapEntity.getValue().equals("勘察(EGE)")) { |
| | | String valueStr = oneMapEntity.getKey(); |
| | | System.out.println("勘察(EGE)== valueStr == " + valueStr); |
| | | String endSql1 = null; |
| | | String sqlQur = ""; |
| | | if (valueStr.length() > 0) { |
| | | String[] arrStr1 = valueStr.split(","); |
| | | StringBuilder one = new StringBuilder(); |
| | | if (arrStr1.length > 0) { |
| | | System.out.println("arrStr = " + arrStr1.length); |
| | | } |
| | | for (String s : arrStr1) { |
| | | sqlQur = "\'" + s + "%\' " + "or dircode like"; |
| | | one.append(sqlQur); |
| | | } |
| | | endSql1 = " where dircode like " + one.substring(0, one.toString().length() - 15); |
| | | System.out.println("endSql1 = " + endSql1); |
| | | } |
| | | resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql1)); |
| | | |
| | | } else if (oneMapEntity.getValue().equals("地灾(EGD)")) { |
| | | String valueStr = oneMapEntity.getKey(); |
| | | System.out.println("地灾(EGD)== valueStr == " + valueStr); |
| | | String endSql2 = null; |
| | | String sqlQur = ""; |
| | | if (valueStr.length() > 0) { |
| | | String[] arrStr2 = valueStr.split(","); |
| | | StringBuilder one = new StringBuilder(); |
| | | if (arrStr2.length > 0) { |
| | | System.out.println("arrStr = " + arrStr2.length); |
| | | } |
| | | for (int j = 0; j < arrStr2.length; j++) { |
| | | sqlQur = "\'" + arrStr2[j] + "%\' " + "or dircode like"; |
| | | one.append(sqlQur); |
| | | } |
| | | endSql2 = " where dircode like " + one.substring(0, one.toString().length() - 15); |
| | | System.out.println("endSql2 = " + endSql2); |
| | | } |
| | | resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql2)); |
| | | |
| | | } else if (oneMapEntity.getValue().equals("洞库(EGD)")) { |
| | | String valueStr = oneMapEntity.getKey(); |
| | | System.out.println("洞库(EGD)== valueStr == " + valueStr); |
| | | String endSql3 = null; |
| | | String sqlQur = ""; |
| | | if (valueStr.length() > 0) { |
| | | String[] arrStr3 = valueStr.split(","); |
| | | StringBuilder one = new StringBuilder(); |
| | | if (arrStr3.length > 0) { |
| | | System.out.println("arrStr = " + arrStr3.length); |
| | | } |
| | | for (int j = 0; j < arrStr3.length; j++) { |
| | | sqlQur = "\'" + arrStr3[j] + "%\' " + "or dircode like"; |
| | | one.append(sqlQur); |
| | | } |
| | | endSql3 = " where dircode like " + one.substring(0, one.toString().length() - 15); |
| | | System.out.println("endSql3 = " + endSql3); |
| | | } |
| | | resList.addAll(aMapOfPipelineMapper.selectProjectTypeOne(endSql3)); |
| | | if (measurement.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } else if (toInvestigate.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } else if (disaster.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } else if (undergroundStructure.equals(oneMapEntity.getValue())) { |
| | | resList.addAll(queryDirectory(oneMapEntity)); |
| | | } |
| | | } |
| | | return resList; |
| | | } |
| | | |
| | | /** |
| | | * 查询目录 |
| | | * |
| | | * @return {@link List}<{@link OneMapEntity}> |
| | | */ |
| | | public List<OneMapEntity> queryDirectory(OneMapEntity oneMapEntity) { |
| | | String valueStr = oneMapEntity.getKey(); |
| | | System.out.println(oneMapEntity.getValue() + " == value == " + valueStr); |
| | | String endSql = null; |
| | | String sqlQur = ""; |
| | | if (valueStr.length() > 0) { |
| | | String[] arrStr = valueStr.split(","); |
| | | StringBuilder one = new StringBuilder(); |
| | | if (arrStr.length > 0) { |
| | | System.out.println("arrStr = " + arrStr.length); |
| | | } |
| | | for (String s : arrStr) { |
| | | sqlQur = "\'" + s + "%\' " + "or dircode like"; |
| | | one.append(sqlQur); |
| | | } |
| | | endSql = " where dircode like " + one.substring(0, one.toString().length() - 15); |
| | | System.out.println("endSql = " + endSql); |
| | | } |
| | | return aMapOfPipelineMapper.selectProjectTypeOne(endSql); |
| | | } |
| | | |
| | | /** |
| | | * 选择项目类型一 |
| | | * |
| | | * @param sqlQur sql《 |
| | | * @return {@link List}<{@link OneMapEntity}> |
| | | */ |
| | | @Override |
| | | public List<OneMapEntity> selectProjectTypeOne(String sqlQur) { |
| | | return null; |