diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java index 7ff0de0..5e38071 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java @@ -32,7 +32,7 @@ /** * 第三方燃气列表 */ - @RequestMapping("/gasdector/listPage") + @RequestMapping("/gasdector/listpage") public Object getGasDectorListPage(String keyWords, String endTime, String beginTime, String deptid) { Page page = PageFactory.defaultPage(); DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java index 7ff0de0..5e38071 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/controller/ThirdPartyController.java @@ -32,7 +32,7 @@ /** * 第三方燃气列表 */ - @RequestMapping("/gasdector/listPage") + @RequestMapping("/gasdector/listpage") public Object getGasDectorListPage(String keyWords, String endTime, String beginTime, String deptid) { Page page = PageFactory.defaultPage(); DataScope dataScope = permissionService.getAuthService().getLoginUserDataScope(); diff --git a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/ThirdPartyDataMapper.xml b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/ThirdPartyDataMapper.xml index ac960ad..416c4bf 100644 --- a/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/ThirdPartyDataMapper.xml +++ b/casic-data-analysis/src/main/java/com/casic/missiles/modular/system/dao/mapping/ThirdPartyDataMapper.xml @@ -55,30 +55,29 @@ INNER JOIN bus_device_well bdw ON bd.ID=bdw.DEVICE_ID INNER JOIN bus_well_info bwi ON bdw.WELL_ID=bwi.ID WHERE bd.DEVCODE=dgd.DEVCODE - - - and bwi.DEPTID = #{deptid} - - - and dgd.LOGTIME = ]]> - - - - - - and dgd.LOGTIME - - - - - - and (bd.DEVCODE like - - OR bwi.wellCode LIKE - - ) - - + + + and bwi.DEPTID = #{deptid} + + + and dgd.LOGTIME = ]]> + + + + + + and dgd.LOGTIME + + + + + + and (bd.DEVCODE like + + OR bwi.wellCode LIKE + + ) + ORDER BY dgd.LOGTIME DESC @@ -98,30 +97,28 @@ INNER JOIN bus_device_well bdw ON bd.ID=bdw.DEVICE_ID INNER JOIN bus_well_info bwi ON bdw.WELL_ID=bwi.ID WHERE bd.DEVCODE=dp.DEVCODE - - - and bwi.DEPTID = #{deptid} - - - and dp.LOGTIME = ]]> - - - - - - and dp.LOGTIME - - - - - - and (bd.DEVCODE like - - OR bwi.wellCode LIKE - - ) - - + + and bwi.DEPTID = #{deptid} + + + and dp.LOGTIME = ]]> + + + + + + and dp.LOGTIME + + + + + + and (bd.DEVCODE like + + OR bwi.wellCode LIKE + + ) + ORDER BY dp.LOGTIME DESC