管道基础大数据平台系统开发-【后端】-Server
xing
2023-02-22 be370f5d432d8a9e2ae1354bb4e1ac4881ab15fa
20230221@xingjs@提交官网一张图相关内容接口
已修改2个文件
146 ■■■■■ 文件已修改
src/main/java/com/lf/server/mapper/show/OneMapMapper.java 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/service/show/OneMapService.java 145 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/mapper/show/OneMapMapper.java
@@ -88,6 +88,7 @@
    /**
     * 统计项目参观
     *
     * @param mpipelineEntity mpipeline实体
     * @return {@link List}<{@link String}>
     */
    public List<String> countProjectTour(MpipelineEntity mpipelineEntity);
src/main/java/com/lf/server/service/show/OneMapService.java
@@ -20,6 +20,23 @@
    OneMapMapper aMapOfPipelineMapper;
    /**
     * 测量
     */
    private static String measurement = "测量(ESV)";
    /**
     * 调查
     */
    private static String toInvestigate = "勘察(EGE)";
    /**
     * 地灾
     */
    private static String disaster = "地灾(EGD)";
    /**
     * 地下结构洞库
     */
    private static String undergroundStructure = "洞库(EGD)";
    /**
     * 项目类别conut
     */
    @Override
@@ -135,102 +152,62 @@
        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;