diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java index 1dbe2a0..929a82e 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java @@ -1,15 +1,23 @@ package com.casic.missiles.modular.system.controller; +import cn.hutool.core.lang.Assert; +import cn.hutool.core.util.ObjectUtil; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.base.controller.ExportController; import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.model.exception.enums.CoreExceptionEnum; import com.casic.missiles.model.response.ResponseData; +import com.casic.missiles.modular.system.dto.JudgmentRequest; +import com.casic.missiles.modular.system.exception.BusinessException; import com.casic.missiles.modular.system.model.Judgment; +import com.casic.missiles.modular.system.service.ICmdBodyRoamService; import com.casic.missiles.modular.system.service.IJudgmentService; -import com.casic.missiles.modular.system.ssl.LinkTestUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; +import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; @@ -31,6 +39,8 @@ @Resource private IJudgmentService judgmentService; + @Autowired + private ICmdBodyRoamService cmdBodyRoamService; /** @@ -38,8 +48,12 @@ */ @RequestMapping(value = "/list") @ResponseBody - public Object list(String condition) { - return ResponseData.success(judgmentService.list(null)); + public Object list(@RequestBody JudgmentRequest judgmentRequest, BindingResult bindingResult) { + Assert.isFalse(bindingResult.hasErrors(), () -> { + throw new BusinessException(CoreExceptionEnum.REQUEST_NULL.getCode(), bindingResult.getFieldError().getDefaultMessage()); + }); + List judgmentList = judgmentService.getListByTime(judgmentRequest); + return ResponseData.success(judgmentList); } /** @@ -60,8 +74,17 @@ @RequestMapping(value = "/add") @ResponseBody public Object add(@RequestBody Judgment judgment) { - judgmentService.save(judgment); - return ResponseData.success(); + + if(ObjectUtil.isNotEmpty(judgment.getTitle1List())){ + judgment.setFirstTitle(JSON.toJSONString(judgment.getTitle1List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle2List())){ + judgment.setSecondTitle(JSON.toJSONString(judgment.getTitle2List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle3List())){ + judgment.setThirdTitle(JSON.toJSONString(judgment.getTitle3List(), true)); + } + return ResponseData.success(judgmentService.save(judgment)); } /** @@ -134,7 +157,7 @@ @ResponseBody public Object testUrl(String url) throws Exception { - LinkTestUtil.testUrl(url); + cmdBodyRoamService.getMapList("",""); return true; } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java index 1dbe2a0..929a82e 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java @@ -1,15 +1,23 @@ package com.casic.missiles.modular.system.controller; +import cn.hutool.core.lang.Assert; +import cn.hutool.core.util.ObjectUtil; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.base.controller.ExportController; import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.model.exception.enums.CoreExceptionEnum; import com.casic.missiles.model.response.ResponseData; +import com.casic.missiles.modular.system.dto.JudgmentRequest; +import com.casic.missiles.modular.system.exception.BusinessException; import com.casic.missiles.modular.system.model.Judgment; +import com.casic.missiles.modular.system.service.ICmdBodyRoamService; import com.casic.missiles.modular.system.service.IJudgmentService; -import com.casic.missiles.modular.system.ssl.LinkTestUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; +import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; @@ -31,6 +39,8 @@ @Resource private IJudgmentService judgmentService; + @Autowired + private ICmdBodyRoamService cmdBodyRoamService; /** @@ -38,8 +48,12 @@ */ @RequestMapping(value = "/list") @ResponseBody - public Object list(String condition) { - return ResponseData.success(judgmentService.list(null)); + public Object list(@RequestBody JudgmentRequest judgmentRequest, BindingResult bindingResult) { + Assert.isFalse(bindingResult.hasErrors(), () -> { + throw new BusinessException(CoreExceptionEnum.REQUEST_NULL.getCode(), bindingResult.getFieldError().getDefaultMessage()); + }); + List judgmentList = judgmentService.getListByTime(judgmentRequest); + return ResponseData.success(judgmentList); } /** @@ -60,8 +74,17 @@ @RequestMapping(value = "/add") @ResponseBody public Object add(@RequestBody Judgment judgment) { - judgmentService.save(judgment); - return ResponseData.success(); + + if(ObjectUtil.isNotEmpty(judgment.getTitle1List())){ + judgment.setFirstTitle(JSON.toJSONString(judgment.getTitle1List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle2List())){ + judgment.setSecondTitle(JSON.toJSONString(judgment.getTitle2List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle3List())){ + judgment.setThirdTitle(JSON.toJSONString(judgment.getTitle3List(), true)); + } + return ResponseData.success(judgmentService.save(judgment)); } /** @@ -134,7 +157,7 @@ @ResponseBody public Object testUrl(String url) throws Exception { - LinkTestUtil.testUrl(url); + cmdBodyRoamService.getMapList("",""); return true; } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java index cea6720..fa21c57 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java @@ -56,7 +56,33 @@ @RequestMapping(value = "/list") @ResponseBody public Object list(@RequestBody HashMap map) { - return ResponseData.success(summaryService.getSummaryList(map)); + + + List summaryList = (List) summaryService.getSummaryList(map); + summaryList.forEach(summary -> { + if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setCommonRequestList(list); + } + if (ObjectUtil.isNotEmpty(summary.getSpreadResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getSpreadResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setSpreadResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getForeignResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getForeignResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setForeignResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getDiscoveryResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getDiscoveryResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setDiscoveryResultList(list); + } + }); + + return ResponseData.success(summaryList); } /** @@ -128,11 +154,8 @@ */ @RequestMapping(value = "/detail") @ResponseBody - public Object detail(@RequestBody IdDTO idDTO) { - Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { - throw new BusinessException(BusinessExceptionEnum.ID_NULL); - }); - Summary summary = summaryService.getById(idDTO.getId()); + public Object detail(Long id) { + Summary summary = summaryService.getById(id); if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java index 1dbe2a0..929a82e 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java @@ -1,15 +1,23 @@ package com.casic.missiles.modular.system.controller; +import cn.hutool.core.lang.Assert; +import cn.hutool.core.util.ObjectUtil; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.base.controller.ExportController; import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.model.exception.enums.CoreExceptionEnum; import com.casic.missiles.model.response.ResponseData; +import com.casic.missiles.modular.system.dto.JudgmentRequest; +import com.casic.missiles.modular.system.exception.BusinessException; import com.casic.missiles.modular.system.model.Judgment; +import com.casic.missiles.modular.system.service.ICmdBodyRoamService; import com.casic.missiles.modular.system.service.IJudgmentService; -import com.casic.missiles.modular.system.ssl.LinkTestUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; +import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; @@ -31,6 +39,8 @@ @Resource private IJudgmentService judgmentService; + @Autowired + private ICmdBodyRoamService cmdBodyRoamService; /** @@ -38,8 +48,12 @@ */ @RequestMapping(value = "/list") @ResponseBody - public Object list(String condition) { - return ResponseData.success(judgmentService.list(null)); + public Object list(@RequestBody JudgmentRequest judgmentRequest, BindingResult bindingResult) { + Assert.isFalse(bindingResult.hasErrors(), () -> { + throw new BusinessException(CoreExceptionEnum.REQUEST_NULL.getCode(), bindingResult.getFieldError().getDefaultMessage()); + }); + List judgmentList = judgmentService.getListByTime(judgmentRequest); + return ResponseData.success(judgmentList); } /** @@ -60,8 +74,17 @@ @RequestMapping(value = "/add") @ResponseBody public Object add(@RequestBody Judgment judgment) { - judgmentService.save(judgment); - return ResponseData.success(); + + if(ObjectUtil.isNotEmpty(judgment.getTitle1List())){ + judgment.setFirstTitle(JSON.toJSONString(judgment.getTitle1List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle2List())){ + judgment.setSecondTitle(JSON.toJSONString(judgment.getTitle2List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle3List())){ + judgment.setThirdTitle(JSON.toJSONString(judgment.getTitle3List(), true)); + } + return ResponseData.success(judgmentService.save(judgment)); } /** @@ -134,7 +157,7 @@ @ResponseBody public Object testUrl(String url) throws Exception { - LinkTestUtil.testUrl(url); + cmdBodyRoamService.getMapList("",""); return true; } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java index cea6720..fa21c57 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java @@ -56,7 +56,33 @@ @RequestMapping(value = "/list") @ResponseBody public Object list(@RequestBody HashMap map) { - return ResponseData.success(summaryService.getSummaryList(map)); + + + List summaryList = (List) summaryService.getSummaryList(map); + summaryList.forEach(summary -> { + if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setCommonRequestList(list); + } + if (ObjectUtil.isNotEmpty(summary.getSpreadResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getSpreadResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setSpreadResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getForeignResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getForeignResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setForeignResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getDiscoveryResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getDiscoveryResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setDiscoveryResultList(list); + } + }); + + return ResponseData.success(summaryList); } /** @@ -128,11 +154,8 @@ */ @RequestMapping(value = "/detail") @ResponseBody - public Object detail(@RequestBody IdDTO idDTO) { - Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { - throw new BusinessException(BusinessExceptionEnum.ID_NULL); - }); - Summary summary = summaryService.getById(idDTO.getId()); + public Object detail(Long id) { + Summary summary = summaryService.getById(id); if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java index 63f7949..7d8c481 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java @@ -1,7 +1,11 @@ package com.casic.missiles.modular.system.dao; -import com.casic.missiles.modular.system.model.CmdBodyRoam; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.casic.missiles.modular.system.dto.TagResponse; +import com.casic.missiles.modular.system.model.CmdBodyRoam; +import org.apache.ibatis.annotations.Param; + +import java.util.List; /** *

@@ -13,4 +17,6 @@ */ public interface CmdBodyRoamMapper extends BaseMapper { + List getMapList(@Param("begTime") String begTime, @Param("endTime") String endTime); + } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java index 1dbe2a0..929a82e 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java @@ -1,15 +1,23 @@ package com.casic.missiles.modular.system.controller; +import cn.hutool.core.lang.Assert; +import cn.hutool.core.util.ObjectUtil; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.base.controller.ExportController; import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.model.exception.enums.CoreExceptionEnum; import com.casic.missiles.model.response.ResponseData; +import com.casic.missiles.modular.system.dto.JudgmentRequest; +import com.casic.missiles.modular.system.exception.BusinessException; import com.casic.missiles.modular.system.model.Judgment; +import com.casic.missiles.modular.system.service.ICmdBodyRoamService; import com.casic.missiles.modular.system.service.IJudgmentService; -import com.casic.missiles.modular.system.ssl.LinkTestUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; +import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; @@ -31,6 +39,8 @@ @Resource private IJudgmentService judgmentService; + @Autowired + private ICmdBodyRoamService cmdBodyRoamService; /** @@ -38,8 +48,12 @@ */ @RequestMapping(value = "/list") @ResponseBody - public Object list(String condition) { - return ResponseData.success(judgmentService.list(null)); + public Object list(@RequestBody JudgmentRequest judgmentRequest, BindingResult bindingResult) { + Assert.isFalse(bindingResult.hasErrors(), () -> { + throw new BusinessException(CoreExceptionEnum.REQUEST_NULL.getCode(), bindingResult.getFieldError().getDefaultMessage()); + }); + List judgmentList = judgmentService.getListByTime(judgmentRequest); + return ResponseData.success(judgmentList); } /** @@ -60,8 +74,17 @@ @RequestMapping(value = "/add") @ResponseBody public Object add(@RequestBody Judgment judgment) { - judgmentService.save(judgment); - return ResponseData.success(); + + if(ObjectUtil.isNotEmpty(judgment.getTitle1List())){ + judgment.setFirstTitle(JSON.toJSONString(judgment.getTitle1List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle2List())){ + judgment.setSecondTitle(JSON.toJSONString(judgment.getTitle2List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle3List())){ + judgment.setThirdTitle(JSON.toJSONString(judgment.getTitle3List(), true)); + } + return ResponseData.success(judgmentService.save(judgment)); } /** @@ -134,7 +157,7 @@ @ResponseBody public Object testUrl(String url) throws Exception { - LinkTestUtil.testUrl(url); + cmdBodyRoamService.getMapList("",""); return true; } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java index cea6720..fa21c57 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java @@ -56,7 +56,33 @@ @RequestMapping(value = "/list") @ResponseBody public Object list(@RequestBody HashMap map) { - return ResponseData.success(summaryService.getSummaryList(map)); + + + List

summaryList = (List) summaryService.getSummaryList(map); + summaryList.forEach(summary -> { + if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setCommonRequestList(list); + } + if (ObjectUtil.isNotEmpty(summary.getSpreadResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getSpreadResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setSpreadResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getForeignResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getForeignResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setForeignResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getDiscoveryResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getDiscoveryResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setDiscoveryResultList(list); + } + }); + + return ResponseData.success(summaryList); } /** @@ -128,11 +154,8 @@ */ @RequestMapping(value = "/detail") @ResponseBody - public Object detail(@RequestBody IdDTO idDTO) { - Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { - throw new BusinessException(BusinessExceptionEnum.ID_NULL); - }); - Summary summary = summaryService.getById(idDTO.getId()); + public Object detail(Long id) { + Summary summary = summaryService.getById(id); if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java index 63f7949..7d8c481 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java @@ -1,7 +1,11 @@ package com.casic.missiles.modular.system.dao; -import com.casic.missiles.modular.system.model.CmdBodyRoam; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.casic.missiles.modular.system.dto.TagResponse; +import com.casic.missiles.modular.system.model.CmdBodyRoam; +import org.apache.ibatis.annotations.Param; + +import java.util.List; /** *

@@ -13,4 +17,6 @@ */ public interface CmdBodyRoamMapper extends BaseMapper { + List getMapList(@Param("begTime") String begTime, @Param("endTime") String endTime); + } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml index 20d8b56..9fe0e36 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml @@ -4,20 +4,42 @@ - - - - - - - - - + + + + + + + + + - roam_id AS roamId, body_id AS bodyId, roam_operation AS roamOperation, prev_operation AS prevOperation, roam_time AS roamTime, roam_desc AS roamDesc, opinion_one AS opinionOne, opinion_two AS opinionTwo, roam_ident AS roamIdent + roam_id + AS roamId, body_id AS bodyId, roam_operation AS roamOperation, prev_operation AS prevOperation, roam_time AS roamTime, roam_desc AS roamDesc, opinion_one AS opinionOne, opinion_two AS opinionTwo, roam_ident AS roamIdent + + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java index 1dbe2a0..929a82e 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java @@ -1,15 +1,23 @@ package com.casic.missiles.modular.system.controller; +import cn.hutool.core.lang.Assert; +import cn.hutool.core.util.ObjectUtil; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.base.controller.ExportController; import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.model.exception.enums.CoreExceptionEnum; import com.casic.missiles.model.response.ResponseData; +import com.casic.missiles.modular.system.dto.JudgmentRequest; +import com.casic.missiles.modular.system.exception.BusinessException; import com.casic.missiles.modular.system.model.Judgment; +import com.casic.missiles.modular.system.service.ICmdBodyRoamService; import com.casic.missiles.modular.system.service.IJudgmentService; -import com.casic.missiles.modular.system.ssl.LinkTestUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; +import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; @@ -31,6 +39,8 @@ @Resource private IJudgmentService judgmentService; + @Autowired + private ICmdBodyRoamService cmdBodyRoamService; /** @@ -38,8 +48,12 @@ */ @RequestMapping(value = "/list") @ResponseBody - public Object list(String condition) { - return ResponseData.success(judgmentService.list(null)); + public Object list(@RequestBody JudgmentRequest judgmentRequest, BindingResult bindingResult) { + Assert.isFalse(bindingResult.hasErrors(), () -> { + throw new BusinessException(CoreExceptionEnum.REQUEST_NULL.getCode(), bindingResult.getFieldError().getDefaultMessage()); + }); + List judgmentList = judgmentService.getListByTime(judgmentRequest); + return ResponseData.success(judgmentList); } /** @@ -60,8 +74,17 @@ @RequestMapping(value = "/add") @ResponseBody public Object add(@RequestBody Judgment judgment) { - judgmentService.save(judgment); - return ResponseData.success(); + + if(ObjectUtil.isNotEmpty(judgment.getTitle1List())){ + judgment.setFirstTitle(JSON.toJSONString(judgment.getTitle1List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle2List())){ + judgment.setSecondTitle(JSON.toJSONString(judgment.getTitle2List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle3List())){ + judgment.setThirdTitle(JSON.toJSONString(judgment.getTitle3List(), true)); + } + return ResponseData.success(judgmentService.save(judgment)); } /** @@ -134,7 +157,7 @@ @ResponseBody public Object testUrl(String url) throws Exception { - LinkTestUtil.testUrl(url); + cmdBodyRoamService.getMapList("",""); return true; } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java index cea6720..fa21c57 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java @@ -56,7 +56,33 @@ @RequestMapping(value = "/list") @ResponseBody public Object list(@RequestBody HashMap map) { - return ResponseData.success(summaryService.getSummaryList(map)); + + + List

summaryList = (List) summaryService.getSummaryList(map); + summaryList.forEach(summary -> { + if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setCommonRequestList(list); + } + if (ObjectUtil.isNotEmpty(summary.getSpreadResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getSpreadResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setSpreadResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getForeignResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getForeignResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setForeignResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getDiscoveryResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getDiscoveryResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setDiscoveryResultList(list); + } + }); + + return ResponseData.success(summaryList); } /** @@ -128,11 +154,8 @@ */ @RequestMapping(value = "/detail") @ResponseBody - public Object detail(@RequestBody IdDTO idDTO) { - Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { - throw new BusinessException(BusinessExceptionEnum.ID_NULL); - }); - Summary summary = summaryService.getById(idDTO.getId()); + public Object detail(Long id) { + Summary summary = summaryService.getById(id); if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java index 63f7949..7d8c481 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java @@ -1,7 +1,11 @@ package com.casic.missiles.modular.system.dao; -import com.casic.missiles.modular.system.model.CmdBodyRoam; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.casic.missiles.modular.system.dto.TagResponse; +import com.casic.missiles.modular.system.model.CmdBodyRoam; +import org.apache.ibatis.annotations.Param; + +import java.util.List; /** *

@@ -13,4 +17,6 @@ */ public interface CmdBodyRoamMapper extends BaseMapper { + List getMapList(@Param("begTime") String begTime, @Param("endTime") String endTime); + } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml index 20d8b56..9fe0e36 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml @@ -4,20 +4,42 @@ - - - - - - - - - + + + + + + + + + - roam_id AS roamId, body_id AS bodyId, roam_operation AS roamOperation, prev_operation AS prevOperation, roam_time AS roamTime, roam_desc AS roamDesc, opinion_one AS opinionOne, opinion_two AS opinionTwo, roam_ident AS roamIdent + roam_id + AS roamId, body_id AS bodyId, roam_operation AS roamOperation, prev_operation AS prevOperation, roam_time AS roamTime, roam_desc AS roamDesc, opinion_one AS opinionOne, opinion_two AS opinionTwo, roam_ident AS roamIdent + + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java index 1dbe2a0..929a82e 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/JudgmentController.java @@ -1,15 +1,23 @@ package com.casic.missiles.modular.system.controller; +import cn.hutool.core.lang.Assert; +import cn.hutool.core.util.ObjectUtil; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.casic.missiles.core.base.controller.ExportController; import com.casic.missiles.core.page.PageFactory; +import com.casic.missiles.model.exception.enums.CoreExceptionEnum; import com.casic.missiles.model.response.ResponseData; +import com.casic.missiles.modular.system.dto.JudgmentRequest; +import com.casic.missiles.modular.system.exception.BusinessException; import com.casic.missiles.modular.system.model.Judgment; +import com.casic.missiles.modular.system.service.ICmdBodyRoamService; import com.casic.missiles.modular.system.service.IJudgmentService; -import com.casic.missiles.modular.system.ssl.LinkTestUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; +import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; @@ -31,6 +39,8 @@ @Resource private IJudgmentService judgmentService; + @Autowired + private ICmdBodyRoamService cmdBodyRoamService; /** @@ -38,8 +48,12 @@ */ @RequestMapping(value = "/list") @ResponseBody - public Object list(String condition) { - return ResponseData.success(judgmentService.list(null)); + public Object list(@RequestBody JudgmentRequest judgmentRequest, BindingResult bindingResult) { + Assert.isFalse(bindingResult.hasErrors(), () -> { + throw new BusinessException(CoreExceptionEnum.REQUEST_NULL.getCode(), bindingResult.getFieldError().getDefaultMessage()); + }); + List judgmentList = judgmentService.getListByTime(judgmentRequest); + return ResponseData.success(judgmentList); } /** @@ -60,8 +74,17 @@ @RequestMapping(value = "/add") @ResponseBody public Object add(@RequestBody Judgment judgment) { - judgmentService.save(judgment); - return ResponseData.success(); + + if(ObjectUtil.isNotEmpty(judgment.getTitle1List())){ + judgment.setFirstTitle(JSON.toJSONString(judgment.getTitle1List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle2List())){ + judgment.setSecondTitle(JSON.toJSONString(judgment.getTitle2List(), true)); + } + if(ObjectUtil.isNotEmpty(judgment.getTitle3List())){ + judgment.setThirdTitle(JSON.toJSONString(judgment.getTitle3List(), true)); + } + return ResponseData.success(judgmentService.save(judgment)); } /** @@ -134,7 +157,7 @@ @ResponseBody public Object testUrl(String url) throws Exception { - LinkTestUtil.testUrl(url); + cmdBodyRoamService.getMapList("",""); return true; } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java index cea6720..fa21c57 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/controller/SummaryController.java @@ -56,7 +56,33 @@ @RequestMapping(value = "/list") @ResponseBody public Object list(@RequestBody HashMap map) { - return ResponseData.success(summaryService.getSummaryList(map)); + + + List

summaryList = (List) summaryService.getSummaryList(map); + summaryList.forEach(summary -> { + if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setCommonRequestList(list); + } + if (ObjectUtil.isNotEmpty(summary.getSpreadResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getSpreadResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setSpreadResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getForeignResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getForeignResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setForeignResultList(list); + } + if (ObjectUtil.isNotEmpty(summary.getDiscoveryResult())) { + JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getDiscoveryResult()); + List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); + summary.setDiscoveryResultList(list); + } + }); + + return ResponseData.success(summaryList); } /** @@ -128,11 +154,8 @@ */ @RequestMapping(value = "/detail") @ResponseBody - public Object detail(@RequestBody IdDTO idDTO) { - Assert.isFalse(Objects.isNull(idDTO.getId()), () -> { - throw new BusinessException(BusinessExceptionEnum.ID_NULL); - }); - Summary summary = summaryService.getById(idDTO.getId()); + public Object detail(Long id) { + Summary summary = summaryService.getById(id); if (ObjectUtil.isNotEmpty(summary.getPlateResult())) { JSONArray jsonArray = (JSONArray) JSONArray.parse(summary.getPlateResult()); List list = JSONObject.parseArray(jsonArray.toJSONString(), CommonRequest.class); diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java index 63f7949..7d8c481 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/CmdBodyRoamMapper.java @@ -1,7 +1,11 @@ package com.casic.missiles.modular.system.dao; -import com.casic.missiles.modular.system.model.CmdBodyRoam; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.casic.missiles.modular.system.dto.TagResponse; +import com.casic.missiles.modular.system.model.CmdBodyRoam; +import org.apache.ibatis.annotations.Param; + +import java.util.List; /** *

@@ -13,4 +17,6 @@ */ public interface CmdBodyRoamMapper extends BaseMapper { + List getMapList(@Param("begTime") String begTime, @Param("endTime") String endTime); + } diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml index 20d8b56..9fe0e36 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/CmdBodyRoamMapper.xml @@ -4,20 +4,42 @@ - - - - - - - - - + + + + + + + + + - roam_id AS roamId, body_id AS bodyId, roam_operation AS roamOperation, prev_operation AS prevOperation, roam_time AS roamTime, roam_desc AS roamDesc, opinion_one AS opinionOne, opinion_two AS opinionTwo, roam_ident AS roamIdent + roam_id + AS roamId, body_id AS bodyId, roam_operation AS roamOperation, prev_operation AS prevOperation, roam_time AS roamTime, roam_desc AS roamDesc, opinion_one AS opinionOne, opinion_two AS opinionTwo, roam_ident AS roamIdent + + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult + SELECT cci.`body_id` AS bodyId, + cci.`controls_classify` AS classify, + cci.`tag_id` AS tagId + FROM cmd_controls_info cci + WHERE cci.body_id IN + (SELECT cbr.`body_id` + FROM cmd_body_roam cbr + WHERE 1 = 1 + + AND cbr.roam_time = ]]> #{begTime} + + + AND cbr.roam_time #{endTime} + + ) + AND (cci.`controls_classify` LIKE '2%' OR cci.`controls_classify` LIKE '6%' OR + cci.`controls_classify` LIKE '7%') + + diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml index 9ea4c84..75b58df 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/JudgmentMapper.xml @@ -8,7 +8,7 @@ - + @@ -17,7 +17,7 @@ - ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, TITLE_COUNT AS titleCount, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description + ID AS id, JUDGMENT_TOTAL AS judgmentTotal, FIRST_TITLE AS firstTitle, SECOND_TITLE AS secondTitle, THIRD_TITLE AS thirdTitle, START_TIME AS startTime, END_TIME AS endTime, CREATE_TIME AS createTime, DESCRIPTION AS description diff --git a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml index c2c7690..bffddd8 100644 --- a/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml +++ b/casic-server/src/main/java/com/casic/missiles/modular/system/dao/mapping/SummaryMapper.xml @@ -25,7 +25,7 @@ ID AS id,SPECIAL_NAME AS specialName,BRIEF AS brief, DISCOVERY_TOTAL AS discoveryTotal, DISCOVERY_PUBLIC AS discoveryPublic, DISCOVERY_SECRET AS discoverySecret, DISCOVERY_ABORD AS discoveryAbord, FOREIGN_TOTAL AS foreignTotal, FOREIGN_PROCESSED AS foreignProcessed, FOREIGN_ADD AS foreignAdd, PROCESS_TOTAL AS processTotal, PROCESS_BROWSE AS processBrowse, PROCESS_GREAT AS processGreat, CREATE_TIME AS createTime, - DESCRIPTION AS description,PLATE_RESULT AS plateResult + DESCRIPTION AS description,PLATE_RESULT AS plateResult,DISCOVERY_RESULT AS discoveryResult,FOREIGN_RESULT AS foreignResult,SPREAD_RESULT AS spreadResult