From 80ca6abff38cf5520fcd0825d9d46582d3063f2d Mon Sep 17 00:00:00 2001 From: songhuangfeng123 <shf18767906695@163.com> Date: 星期一, 22 八月 2022 15:39:37 +0800 Subject: [PATCH] 事故案例 --- incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoDetailDO.java | 52 +++ incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentCaseInfoRepository.java | 27 + incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCaseDetailRespDTO.java | 50 +++ incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/AccidentCaseQuery.java | 14 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentCaseDBQuery.java | 14 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentReportCountDBQuery.java | 2 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/AccidentCaseService.java | 25 + incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentReportInfoRepository.java | 4 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfo.java | 103 ++++++ incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentReportInfoService.java | 4 goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/model/dto/resp/TargetMngDto.java | 11 goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/entity/TargetMng.java | 82 ++-- incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCasePageRespDTO.java | 40 ++ incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentReportInfoServiceImpl.java | 4 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoPageDO.java | 42 ++ incident-manage/incident-manage-service/src/main/resources/config/mapper/incidentManage/AccidentCaseInfoMapper.xml | 86 +++++ incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/enums/AccidentResultCodes.java | 4 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/req/AccidentCaseReqDTO.java | 49 +++ incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCountServiceImpl.java | 4 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCaseServiceImpl.java | 143 ++++++++ goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java | 8 incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/controller/AccidentCaseController.java | 68 ++++ incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentCaseInfoService.java | 25 + incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentCaseInfoServiceImpl.java | 47 ++ 24 files changed, 850 insertions(+), 58 deletions(-) diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java index 68f0a8b..3c455c1 100644 --- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java +++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/controller/TargetMngController.java @@ -73,7 +73,7 @@ PageUtils.checkCheck(pageQuery); return this.targetMngService.queryAll(pageQuery); } - + /** * 通过主键查询单条数据 @@ -95,7 +95,7 @@ @PostMapping(value = "/addOrUpdate") public ResultVO update(@RequestBody TargetMng targetMng) { - if( !StringUtils.hasText(targetMng.getQName()) || !StringUtils.hasText(targetMng.getIndexNum()) + if( !StringUtils.hasText(targetMng.getqName()) || !StringUtils.hasText(targetMng.getIndexNum()) || !StringUtils.hasText(targetMng.getYear()) || !StringUtils.hasText(targetMng.getValue()) || targetMng.getTargetType() == null){ return new ResultVO<>(ResultCodes.CLIENT_PARAM_ILLEGAL,"缺少必填字段"); @@ -237,7 +237,7 @@ public static void main(String[] args) { TargetMng mng = new TargetMng(); - mng.setQName("12"); + mng.setqName("12"); mng.setIndexNum("3"); mng.setYear("2021"); mng.setValue("312"); @@ -249,4 +249,4 @@ System.out.println(JSONObject.toJSONString(mng)); } -} \ No newline at end of file +} diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/entity/TargetMng.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/entity/TargetMng.java index f703c92..28ca4da 100644 --- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/entity/TargetMng.java +++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/entity/TargetMng.java @@ -1,23 +1,24 @@ package com.gkhy.safePlatform.targetDuty.entity; import java.sql.Timestamp; + +import com.fasterxml.jackson.annotation.JsonFormat; import com.gkhy.safePlatform.targetDuty.entity.BaseDomain; import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.baomidou.mybatisplus.annotation.IdType; -import com.fasterxml.jackson.annotation.JsonFormat; /** * 目标指标(TargetMng)表实体类 * * @author xurui - * @since 2022-08-22 10:14:22 + * @since 2022-07-20 11:49:22 */ @SuppressWarnings("serial") @TableName("target_mng") public class TargetMng extends BaseDomain { - - + + @TableId(type = IdType.AUTO) private Long id; public Long getId() { @@ -28,19 +29,20 @@ this.id = id; } - //安全目标指标 - private String qName; - - public String getQName() { + //安全目标指标 + private String qName; + + public String getqName() { return qName; } - public void setQName(String qName) { + public void setqName(String qName) { this.qName = qName; } - //目标指标编号 - private String indexNum; - + + //目标指标编号 + private String indexNum; + public String getIndexNum() { return indexNum; } @@ -48,9 +50,9 @@ public void setIndexNum(String indexNum) { this.indexNum = indexNum; } - //年度 - private String year; - + //年度 + private String year; + public String getYear() { return year; } @@ -58,9 +60,9 @@ public void setYear(String year) { this.year = year; } - //指标值 - private String value; - + //指标值 + private String value; + public String getValue() { return value; } @@ -68,9 +70,9 @@ public void setValue(String value) { this.value = value; } - //指标级别 1:公司级 2:部门分厂级 3:工段班组级 - private Integer level; - + //指标级别 1:公司级 2:部门分厂级 3:工段班组级 + private Integer level; + public Integer getLevel() { return level; } @@ -78,10 +80,10 @@ public void setLevel(Integer level) { this.level = level; } - //完成期限 - @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") - private Timestamp completeDate; - + //完成期限 + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") + private Timestamp completeDate; + public Timestamp getCompleteDate() { return completeDate; } @@ -89,9 +91,9 @@ public void setCompleteDate(Timestamp completeDate) { this.completeDate = completeDate; } - //备注信息 - private String memo; - + //备注信息 + private String memo; + public String getMemo() { return memo; } @@ -99,9 +101,9 @@ public void setMemo(String memo) { this.memo = memo; } - //指标类型 1:年指标 2:月指标 3:半年 4:季度 - private Integer targetType; - + //指标类型 1:年指标 2:月指标 + private Integer targetType; + public Integer getTargetType() { return targetType; } @@ -109,9 +111,9 @@ public void setTargetType(Integer targetType) { this.targetType = targetType; } - //分解状态 1:已分解 2:未分解 - private Integer divideStatus; - + //分解状态 1:已分解 2:未分解 + private Integer divideStatus; + public Integer getDivideStatus() { return divideStatus; } @@ -119,15 +121,5 @@ public void setDivideStatus(Integer divideStatus) { this.divideStatus = divideStatus; } - //目标制定部门 - private Long makerDepartmentId; - - public Long getMakerDepartmentId() { - return makerDepartmentId; - } - public void setMakerDepartmentId(Long makerDepartmentId) { - this.makerDepartmentId = makerDepartmentId; - } - -} \ No newline at end of file +} diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/model/dto/resp/TargetMngDto.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/model/dto/resp/TargetMngDto.java index a6cf9d4..9f172e8 100644 --- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/model/dto/resp/TargetMngDto.java +++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/model/dto/resp/TargetMngDto.java @@ -163,4 +163,15 @@ public void setMakerDepartmentName(String makerDepartmentName) { this.makerDepartmentName = makerDepartmentName; } + + //1:大于 2:等于 3:小于 + private Integer valueSign; + + public Integer getValueSign() { + return valueSign; + } + + public void setValueSign(Integer valueSign) { + this.valueSign = valueSign; + } } \ No newline at end of file diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/controller/AccidentCaseController.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/controller/AccidentCaseController.java new file mode 100644 index 0000000..2b3d2a7 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/controller/AccidentCaseController.java @@ -0,0 +1,68 @@ +package com.gkhy.safePlatform.incidentManage.controller; + +import com.gkhy.safePlatform.commons.co.ContextCacheUser; +import com.gkhy.safePlatform.commons.query.PageQuery; +import com.gkhy.safePlatform.commons.utils.PageUtils; +import com.gkhy.safePlatform.commons.vo.ResultVO; +import com.gkhy.safePlatform.incidentManage.model.dto.req.AccidentCaseReqDTO; +import com.gkhy.safePlatform.incidentManage.model.dto.resp.AccidentCaseDetailRespDTO; +import com.gkhy.safePlatform.incidentManage.model.dto.resp.AccidentCasePageRespDTO; +import com.gkhy.safePlatform.incidentManage.query.AccidentCaseQuery; +import com.gkhy.safePlatform.incidentManage.service.AccidentCaseService; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.security.core.Authentication; +import org.springframework.web.bind.annotation.*; + +import java.util.List; + +@RestController +@RequestMapping("/accidentCase") +public class AccidentCaseController { + + @Autowired + private AccidentCaseService accidentCaseService; + + /** + * 事故报告列表 + */ + @RequestMapping(value = "/page/list" ,method = RequestMethod.POST) + private ResultVO<List<AccidentCasePageRespDTO>> list (@RequestBody PageQuery<AccidentCaseQuery> pageQuery){ + PageUtils.checkCheck(pageQuery); + return accidentCaseService.selectAccidentCaseList(pageQuery); + } + + /** + * 事故报告新增 + */ + @RequestMapping(value = "/add",method = RequestMethod.POST) + public ResultVO addAccidentCase(Authentication authentication, @RequestBody AccidentCaseReqDTO AccidentCaseReqDTO) { + ContextCacheUser currentUser = (ContextCacheUser) authentication.getPrincipal(); + return accidentCaseService.addAccidentCase(currentUser.getUid(), AccidentCaseReqDTO); + } + + /** + * 事故报告详情 + */ + @RequestMapping(value = "/info/{id}",method = RequestMethod.GET) + public ResultVO<AccidentCaseDetailRespDTO> getAccidentCaseById(@PathVariable("id")Long id){ + return accidentCaseService.getAccidentCaseById(id); + } + + /** + * 事故报告修改 + */ + @RequestMapping(value = "/update",method = RequestMethod.POST) + public ResultVO updateAccidentCase(Authentication authentication, @RequestBody AccidentCaseReqDTO AccidentCaseReqDTO) { + ContextCacheUser currentUser = (ContextCacheUser) authentication.getPrincipal(); + return accidentCaseService.updateAccidentCase(currentUser.getUid(), AccidentCaseReqDTO); + } + + /** + * 事故报告删除/批量删除 + */ + @RequestMapping(value = "/batchDelete",method = RequestMethod.POST) + public ResultVO batchDeleteAccidentCase(@RequestBody Long[] ids){ + return accidentCaseService.batchDeleteAccidentCase(ids); + } + +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfo.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfo.java new file mode 100644 index 0000000..287e40c --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfo.java @@ -0,0 +1,103 @@ +package com.gkhy.safePlatform.incidentManage.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; + +import java.util.Date; +import java.util.List; + +@TableName("accident_case") +public class AccidentCaseInfo { + + @TableId(type = IdType.AUTO) + private Long id; + + private Boolean delFlag; + + private Date gmtCreate; + + private Date gmtModitify; + + private Long createUid; + + private Long updateUid; + + private String caseTitle; + + private String caseContent; + + private Date caseTime; + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public Boolean getDelFlag() { + return delFlag; + } + + public void setDelFlag(Boolean delFlag) { + this.delFlag = delFlag; + } + + public Date getGmtCreate() { + return gmtCreate; + } + + public void setGmtCreate(Date gmtCreate) { + this.gmtCreate = gmtCreate; + } + + public Date getGmtModitify() { + return gmtModitify; + } + + public void setGmtModitify(Date gmtModitify) { + this.gmtModitify = gmtModitify; + } + + public Long getCreateUid() { + return createUid; + } + + public void setCreateUid(Long createUid) { + this.createUid = createUid; + } + + public Long getUpdateUid() { + return updateUid; + } + + public void setUpdateUid(Long updateUid) { + this.updateUid = updateUid; + } + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } + + public String getCaseContent() { + return caseContent; + } + + public void setCaseContent(String caseContent) { + this.caseContent = caseContent; + } + + public Date getCaseTime() { + return caseTime; + } + + public void setCaseTime(Date caseTime) { + this.caseTime = caseTime; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoDetailDO.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoDetailDO.java new file mode 100644 index 0000000..fe8dbe0 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoDetailDO.java @@ -0,0 +1,52 @@ +package com.gkhy.safePlatform.incidentManage.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; + +import java.util.Date; + +@TableName("accident_case") +public class AccidentCaseInfoDetailDO { + + @TableId(type = IdType.AUTO) + private Long id; + + private String caseTitle; + + private String caseContent; + + private Date caseTime; + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } + + public String getCaseContent() { + return caseContent; + } + + public void setCaseContent(String caseContent) { + this.caseContent = caseContent; + } + + public Date getCaseTime() { + return caseTime; + } + + public void setCaseTime(Date caseTime) { + this.caseTime = caseTime; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoPageDO.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoPageDO.java new file mode 100644 index 0000000..ee60561 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/entity/AccidentCaseInfoPageDO.java @@ -0,0 +1,42 @@ +package com.gkhy.safePlatform.incidentManage.entity; + +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; + +import java.util.Date; + +@TableName("accident_case") +public class AccidentCaseInfoPageDO { + + @TableId(type = IdType.AUTO) + private Long id; + + private String caseTitle; + + private Date caseTime; + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } + + public Date getCaseTime() { + return caseTime; + } + + public void setCaseTime(Date caseTime) { + this.caseTime = caseTime; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/enums/AccidentResultCodes.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/enums/AccidentResultCodes.java index 2bb04d7..6ff39ca 100644 --- a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/enums/AccidentResultCodes.java +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/enums/AccidentResultCodes.java @@ -40,6 +40,10 @@ WORK_INJURY_DECLARATION_TYPE_NULL("W1006", "工伤类型不可为空"), WORK_INJURY_DECLARATION_Date_NULL("W1006", "申报日期不可为空"), + CASE_NULL("C1001", "事故案例不可为空"), + CASE_NOT_EXIST("C1002", "事故案例不存在"), + CASE_TITLE_NULL("C1003", "事故案例标题不可为空"), + CASE_CONTENT_NULL("C1004", "事故案例内容不可为空"), ERROR("A3000", "未知错误"); diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/req/AccidentCaseReqDTO.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/req/AccidentCaseReqDTO.java new file mode 100644 index 0000000..41d0597 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/req/AccidentCaseReqDTO.java @@ -0,0 +1,49 @@ +package com.gkhy.safePlatform.incidentManage.model.dto.req; + +import com.fasterxml.jackson.annotation.JsonFormat; + +import java.util.Date; + +public class AccidentCaseReqDTO { + + private Long id; + + private String caseTitle; + + private String caseContent; + + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + private Date caseTime; + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } + + public String getCaseContent() { + return caseContent; + } + + public void setCaseContent(String caseContent) { + this.caseContent = caseContent; + } + + public Date getCaseTime() { + return caseTime; + } + + public void setCaseTime(Date caseTime) { + this.caseTime = caseTime; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCaseDetailRespDTO.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCaseDetailRespDTO.java new file mode 100644 index 0000000..6b30f76 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCaseDetailRespDTO.java @@ -0,0 +1,50 @@ +package com.gkhy.safePlatform.incidentManage.model.dto.resp; + + +import com.fasterxml.jackson.annotation.JsonFormat; + +import java.util.Date; + +public class AccidentCaseDetailRespDTO { + + private Long id; + + private String caseTitle; + + private String caseContent; + + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + private Date caseTime; + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } + + public String getCaseContent() { + return caseContent; + } + + public void setCaseContent(String caseContent) { + this.caseContent = caseContent; + } + + public Date getCaseTime() { + return caseTime; + } + + public void setCaseTime(Date caseTime) { + this.caseTime = caseTime; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCasePageRespDTO.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCasePageRespDTO.java new file mode 100644 index 0000000..61b5fac --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/model/dto/resp/AccidentCasePageRespDTO.java @@ -0,0 +1,40 @@ +package com.gkhy.safePlatform.incidentManage.model.dto.resp; + + +import com.fasterxml.jackson.annotation.JsonFormat; + +import java.util.Date; + +public class AccidentCasePageRespDTO { + + private Long id; + + private String caseTitle; + + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + private Date caseTime; + + public Long getId() { + return id; + } + + public void setId(Long id) { + this.id = id; + } + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } + + public Date getCaseTime() { + return caseTime; + } + + public void setCaseTime(Date caseTime) { + this.caseTime = caseTime; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/AccidentCaseQuery.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/AccidentCaseQuery.java new file mode 100644 index 0000000..c974da4 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/AccidentCaseQuery.java @@ -0,0 +1,14 @@ +package com.gkhy.safePlatform.incidentManage.query; + +public class AccidentCaseQuery { + + private String caseTitle; + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentCaseDBQuery.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentCaseDBQuery.java new file mode 100644 index 0000000..fa6f836 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentCaseDBQuery.java @@ -0,0 +1,14 @@ +package com.gkhy.safePlatform.incidentManage.query.db; + +public class AccidentCaseDBQuery { + + private String caseTitle; + + public String getCaseTitle() { + return caseTitle; + } + + public void setCaseTitle(String caseTitle) { + this.caseTitle = caseTitle; + } +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentReportRPCDBQuery.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentReportCountDBQuery.java similarity index 93% rename from incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentReportRPCDBQuery.java rename to incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentReportCountDBQuery.java index 81928c2..ff00982 100644 --- a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentReportRPCDBQuery.java +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/query/db/AccidentReportCountDBQuery.java @@ -1,6 +1,6 @@ package com.gkhy.safePlatform.incidentManage.query.db; -public class AccidentReportRPCDBQuery { +public class AccidentReportCountDBQuery { private String level; diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentCaseInfoRepository.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentCaseInfoRepository.java new file mode 100644 index 0000000..5af8cda --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentCaseInfoRepository.java @@ -0,0 +1,27 @@ +package com.gkhy.safePlatform.incidentManage.repository; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfo; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoDetailDO; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoPageDO; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentCaseDBQuery; +import org.apache.ibatis.annotations.Param; +import org.springframework.stereotype.Repository; + +import java.util.List; + +@Repository +public interface AccidentCaseInfoRepository extends BaseMapper<AccidentCaseInfo> { + + List<AccidentCaseInfoPageDO> selectAccidentCaseList(Page<AccidentCaseInfoPageDO> page, @Param("query") AccidentCaseDBQuery accidentCaseDBQuery); + + void addAccidentCase(AccidentCaseInfo accidentCaseInfo); + + AccidentCaseInfoDetailDO selectAccidentCaseById(@Param("id") Long id); + + void updateAccidentCase(AccidentCaseInfo accidentCaseInfo); + + void deleteAccidentCaseById(@Param("id") Long id); + +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentReportInfoRepository.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentReportInfoRepository.java index b584a02..4990ae1 100644 --- a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentReportInfoRepository.java +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/repository/AccidentReportInfoRepository.java @@ -7,7 +7,7 @@ import com.gkhy.safePlatform.incidentManage.entity.AccidentReportInfoDetailDO; import com.gkhy.safePlatform.incidentManage.entity.AccidentReportInfoPageDO; import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportDBQuery; -import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportRPCDBQuery; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportCountDBQuery; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; @@ -26,5 +26,5 @@ void deleteAccidentReportById(@Param("id") Long id); - List<AccidentReportCount> selectByTimeAndType(@Param("query")AccidentReportRPCDBQuery dbQuery); + List<AccidentReportCount> selectByTimeAndType(@Param("query") AccidentReportCountDBQuery dbQuery); } diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/AccidentCaseService.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/AccidentCaseService.java new file mode 100644 index 0000000..42d00c9 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/AccidentCaseService.java @@ -0,0 +1,25 @@ +package com.gkhy.safePlatform.incidentManage.service; + +import com.gkhy.safePlatform.commons.query.PageQuery; +import com.gkhy.safePlatform.commons.vo.ResultVO; +import com.gkhy.safePlatform.commons.vo.SearchResultVO; +import com.gkhy.safePlatform.incidentManage.model.dto.req.AccidentCaseReqDTO; +import com.gkhy.safePlatform.incidentManage.model.dto.resp.AccidentCaseDetailRespDTO; +import com.gkhy.safePlatform.incidentManage.model.dto.resp.AccidentCasePageRespDTO; +import com.gkhy.safePlatform.incidentManage.query.AccidentCaseQuery; + +import java.util.List; + +public interface AccidentCaseService { + + SearchResultVO<List<AccidentCasePageRespDTO>> selectAccidentCaseList(PageQuery<AccidentCaseQuery> query); + + ResultVO addAccidentCase(Long valueOf, AccidentCaseReqDTO AccidentCaseReqDTO); + + ResultVO<AccidentCaseDetailRespDTO> getAccidentCaseById(Long id); + + ResultVO updateAccidentCase(Long uid, AccidentCaseReqDTO AccidentCaseReqDTO); + + ResultVO batchDeleteAccidentCase(Long[] ids); + +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentCaseInfoService.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentCaseInfoService.java new file mode 100644 index 0000000..38c4db0 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentCaseInfoService.java @@ -0,0 +1,25 @@ +package com.gkhy.safePlatform.incidentManage.service.baseService; + +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.baomidou.mybatisplus.extension.service.IService; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfo; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoDetailDO; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoPageDO; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentCaseDBQuery; + +import java.util.List; + + +public interface AccidentCaseInfoService extends IService<AccidentCaseInfo> { + + List<AccidentCaseInfoPageDO> selectAccidentCaseList(Page<AccidentCaseInfoPageDO> page, AccidentCaseDBQuery AccidentCaseDBQuery); + + void addAccidentCase(AccidentCaseInfo AccidentCaseInfo); + + AccidentCaseInfoDetailDO selectAccidentCaseById(Long id); + + void updateAccidentCase(AccidentCaseInfo AccidentCaseInfo); + + void deleteAccidentCaseById(Long teamId); + +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentReportInfoService.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentReportInfoService.java index cd7a270..6abc9a1 100644 --- a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentReportInfoService.java +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/AccidentReportInfoService.java @@ -7,7 +7,7 @@ import com.gkhy.safePlatform.incidentManage.entity.AccidentReportInfoDetailDO; import com.gkhy.safePlatform.incidentManage.entity.AccidentReportInfoPageDO; import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportDBQuery; -import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportRPCDBQuery; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportCountDBQuery; import java.util.List; @@ -24,6 +24,6 @@ void deleteAccidentReportById(Long teamId); - List<AccidentReportCount> selectByTimeAndType(AccidentReportRPCDBQuery dbQuery); + List<AccidentReportCount> selectByTimeAndType(AccidentReportCountDBQuery dbQuery); } diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentCaseInfoServiceImpl.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentCaseInfoServiceImpl.java new file mode 100644 index 0000000..bd4f537 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentCaseInfoServiceImpl.java @@ -0,0 +1,47 @@ +package com.gkhy.safePlatform.incidentManage.service.baseService.impl; + +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfo; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoDetailDO; +import com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoPageDO; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentCaseDBQuery; +import com.gkhy.safePlatform.incidentManage.repository.AccidentCaseInfoRepository; +import com.gkhy.safePlatform.incidentManage.service.baseService.AccidentCaseInfoService; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; + +import java.util.List; + +@Service("accidentCaseInfoService") +public class AccidentCaseInfoServiceImpl extends ServiceImpl<AccidentCaseInfoRepository, AccidentCaseInfo> implements AccidentCaseInfoService { + + @Autowired + private AccidentCaseInfoRepository accidentCaseInfoRepository; + + @Override + public List<AccidentCaseInfoPageDO> selectAccidentCaseList(Page<AccidentCaseInfoPageDO> page, AccidentCaseDBQuery AccidentCaseDBQuery) { + return accidentCaseInfoRepository.selectAccidentCaseList(page,AccidentCaseDBQuery); + } + + @Override + public void addAccidentCase(AccidentCaseInfo AccidentCaseInfo) { + accidentCaseInfoRepository.addAccidentCase(AccidentCaseInfo); + } + + @Override + public AccidentCaseInfoDetailDO selectAccidentCaseById(Long id) { + return accidentCaseInfoRepository.selectAccidentCaseById(id); + } + + @Override + public void updateAccidentCase(AccidentCaseInfo AccidentCaseInfo) { + accidentCaseInfoRepository.updateAccidentCase(AccidentCaseInfo); + } + + @Override + public void deleteAccidentCaseById(Long teamId) { + accidentCaseInfoRepository.deleteAccidentCaseById(teamId); + } + +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentReportInfoServiceImpl.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentReportInfoServiceImpl.java index 02c760d..b251e44 100644 --- a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentReportInfoServiceImpl.java +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/baseService/impl/AccidentReportInfoServiceImpl.java @@ -7,7 +7,7 @@ import com.gkhy.safePlatform.incidentManage.entity.AccidentReportInfoDetailDO; import com.gkhy.safePlatform.incidentManage.entity.AccidentReportInfoPageDO; import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportDBQuery; -import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportRPCDBQuery; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportCountDBQuery; import com.gkhy.safePlatform.incidentManage.repository.AccidentReportInfoRepository; import com.gkhy.safePlatform.incidentManage.service.baseService.AccidentReportInfoService; import org.springframework.beans.factory.annotation.Autowired; @@ -47,7 +47,7 @@ } @Override - public List<AccidentReportCount> selectByTimeAndType(AccidentReportRPCDBQuery dbQuery) { + public List<AccidentReportCount> selectByTimeAndType(AccidentReportCountDBQuery dbQuery) { return accidentReportInfoRepository.selectByTimeAndType(dbQuery); } diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCaseServiceImpl.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCaseServiceImpl.java new file mode 100644 index 0000000..7f87919 --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCaseServiceImpl.java @@ -0,0 +1,143 @@ +package com.gkhy.safePlatform.incidentManage.service.impl; + +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.gkhy.safePlatform.commons.enums.ResultCodes; +import com.gkhy.safePlatform.commons.query.PageQuery; +import com.gkhy.safePlatform.commons.utils.BeanCopyUtils; +import com.gkhy.safePlatform.commons.utils.StringUtils; +import com.gkhy.safePlatform.commons.vo.ResultVO; +import com.gkhy.safePlatform.commons.vo.SearchResultVO; +import com.gkhy.safePlatform.incidentManage.entity.*; +import com.gkhy.safePlatform.incidentManage.enums.AccidentResultCodes; +import com.gkhy.safePlatform.incidentManage.exception.AccidentException; +import com.gkhy.safePlatform.incidentManage.model.dto.req.AccidentCaseReqDTO; +import com.gkhy.safePlatform.incidentManage.model.dto.resp.AccidentCaseDetailRespDTO; +import com.gkhy.safePlatform.incidentManage.model.dto.resp.AccidentCasePageRespDTO; +import com.gkhy.safePlatform.incidentManage.query.AccidentCaseQuery; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentCaseDBQuery; +import com.gkhy.safePlatform.incidentManage.service.AccidentCaseService; +import com.gkhy.safePlatform.incidentManage.service.baseService.AccidentCaseInfoService; +import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; + +import java.util.*; + +@Service("accidentCaseService") +public class AccidentCaseServiceImpl implements AccidentCaseService { + + @Autowired + private AccidentCaseInfoService accidentCaseInfoService; + + + @Override + public SearchResultVO<List<AccidentCasePageRespDTO>> selectAccidentCaseList(PageQuery<AccidentCaseQuery> query) { + Long pageIndex = query.getPageIndex(); + Long pageSize = query.getPageSize(); + Page<AccidentCaseInfoPageDO> page = new Page<>(pageIndex, pageSize); + + AccidentCaseDBQuery accidentCaseDBQuery = new AccidentCaseDBQuery(); + if (query.getSearchParams() != null) { + BeanUtils.copyProperties(query.getSearchParams(), accidentCaseDBQuery); + } + + List<AccidentCaseInfoPageDO> accidentCaseInfoPageDOList = accidentCaseInfoService.selectAccidentCaseList(page, accidentCaseDBQuery); + List<AccidentCasePageRespDTO> respList = BeanCopyUtils.copyBeanList(accidentCaseInfoPageDOList, AccidentCasePageRespDTO.class); + + return new SearchResultVO<>( + true, + pageIndex, + pageSize, page.getPages(), + page.getTotal(), + respList, + ResultCodes.OK + ); + } + + @Override + public ResultVO addAccidentCase(Long uid, AccidentCaseReqDTO accidentCaseReqDTO) { + //必填项验证 + checkRequired(accidentCaseReqDTO); + + Date nowDate = new Date(); + //1.新增事故案例 + AccidentCaseInfo accidentCaseInfo = new AccidentCaseInfo(); + BeanUtils.copyProperties(accidentCaseReqDTO, accidentCaseInfo); + accidentCaseInfo.setDelFlag(false); + accidentCaseInfo.setCreateUid(uid); + accidentCaseInfo.setGmtCreate(nowDate); + accidentCaseInfoService.addAccidentCase(accidentCaseInfo); + return new ResultVO(ResultCodes.OK); + } + + @Override + public ResultVO<AccidentCaseDetailRespDTO> getAccidentCaseById(Long id) { + AccidentCaseDetailRespDTO AccidentCaseDetailRespDTO = new AccidentCaseDetailRespDTO(); + //查询是否存在 + AccidentCaseInfoDetailDO AccidentCaseInfoDetailDO = accidentCaseInfoService.selectAccidentCaseById(id); + if (AccidentCaseInfoDetailDO == null) { + throw new AccidentException(AccidentResultCodes.CASE_NOT_EXIST); + } else { + BeanUtils.copyProperties(AccidentCaseInfoDetailDO, AccidentCaseDetailRespDTO); + + return new ResultVO<>(ResultCodes.OK, AccidentCaseDetailRespDTO); + } + } + + @Override + public ResultVO updateAccidentCase(Long uid, AccidentCaseReqDTO accidentCaseReqDTO) { + Date nowDate = new Date(); + //查询是否存在 + AccidentCaseInfoDetailDO AccidentCaseInfoDetailDO = accidentCaseInfoService.selectAccidentCaseById(accidentCaseReqDTO.getId()); + if (AccidentCaseInfoDetailDO == null) { + throw new AccidentException(AccidentResultCodes.CASE_NOT_EXIST); + } else { + AccidentCaseInfo accidentCaseInfo = new AccidentCaseInfo(); + BeanUtils.copyProperties(accidentCaseReqDTO, accidentCaseInfo); + accidentCaseInfo.setUpdateUid(uid); + accidentCaseInfo.setGmtModitify(nowDate); + accidentCaseInfoService.updateAccidentCase(accidentCaseInfo); + + return new ResultVO(ResultCodes.OK); + } + } + + @Override + public ResultVO batchDeleteAccidentCase(Long[] ids) { + if (ids == null || ids.length==0){ + throw new AccidentException(AccidentResultCodes.CASE_NULL); + } else { + for (Long id : ids){ + deleteAccidentCase(id); + } + return new ResultVO(ResultCodes.OK); + } + } + + private void deleteAccidentCase(Long id) { + //查询是否存在 + AccidentCaseInfoDetailDO AccidentCaseInfoDetailDO = accidentCaseInfoService.selectAccidentCaseById(id); + if (AccidentCaseInfoDetailDO == null) { + throw new AccidentException(AccidentResultCodes.CASE_NOT_EXIST); + } else { + accidentCaseInfoService.deleteAccidentCaseById(id); + } + } + + /** + * 验证必填项 + * + * @return + */ + private void checkRequired(AccidentCaseReqDTO AccidentCaseReqDTO) { + // 事故案例标题 + if (AccidentCaseReqDTO.getCaseTitle() == null) { + throw new AccidentException(AccidentResultCodes.CASE_TITLE_NULL); + } + // 事故案例内容 + if (StringUtils.isBlank(AccidentCaseReqDTO.getCaseContent())) { + throw new AccidentException(AccidentResultCodes.CASE_CONTENT_NULL); + } + } + +} diff --git a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCountServiceImpl.java b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCountServiceImpl.java index bcadd55..e68f8bd 100644 --- a/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCountServiceImpl.java +++ b/incident-manage/incident-manage-service/src/main/java/com/gkhy/safePlatform/incidentManage/service/impl/AccidentCountServiceImpl.java @@ -6,7 +6,7 @@ import com.gkhy.safePlatform.incidentManage.entity.*; import com.gkhy.safePlatform.incidentManage.model.dto.resp.*; import com.gkhy.safePlatform.incidentManage.query.AccidentReportCountQuery; -import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportRPCDBQuery; +import com.gkhy.safePlatform.incidentManage.query.db.AccidentReportCountDBQuery; import com.gkhy.safePlatform.incidentManage.service.AccidentCountService; import com.gkhy.safePlatform.incidentManage.service.baseService.AccidentReportInfoService; import com.gkhy.safePlatform.incidentManage.utils.TimeUtils; @@ -26,7 +26,7 @@ public ResultVO<List<AccidentReportCountRespDTO>> countAccidentReport(AccidentReportCountQuery query) { List<AccidentReportCount> list = new ArrayList<>(); - AccidentReportRPCDBQuery dbQuery = new AccidentReportRPCDBQuery(); + AccidentReportCountDBQuery dbQuery = new AccidentReportCountDBQuery(); if (query.getType() == 1) { // 月 int year = query.getYear(); diff --git a/incident-manage/incident-manage-service/src/main/resources/config/mapper/incidentManage/AccidentCaseInfoMapper.xml b/incident-manage/incident-manage-service/src/main/resources/config/mapper/incidentManage/AccidentCaseInfoMapper.xml new file mode 100644 index 0000000..3e6d2ea --- /dev/null +++ b/incident-manage/incident-manage-service/src/main/resources/config/mapper/incidentManage/AccidentCaseInfoMapper.xml @@ -0,0 +1,86 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper + PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" + "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> + +<mapper namespace="com.gkhy.safePlatform.incidentManage.repository.AccidentCaseInfoRepository"> + + <resultMap type="com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoPageDO" id="AccidentCaseInfoPageDOResult"> + <id column="id" property="id" jdbcType="BIGINT"/> + <result column="case_title" property="caseTitle"/> + <result column="case_time" property="caseTime"/> + </resultMap> + + <select id="selectAccidentCaseList" resultMap="AccidentCaseInfoPageDOResult"> + SELECT + id,case_title,case_time + FROM + accident_case + WHERE + del_flag = 0 + <if test="query.caseTitle != null and query.caseTitle != ''">and case_title = #{query.caseTitle}</if> + </select> + + <insert id="addAccidentCase" parameterType="com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfo" + keyProperty="id" useGeneratedKeys="true"> + insert into accident_Case + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="id != null ">id,</if> + <if test="delFlag != null ">del_flag,</if> + <if test="gmtCreate != null ">gmt_create,</if> + <if test="gmtModitify != null ">gmt_moditify,</if> + <if test="createUid != null ">create_uid,</if> + <if test="updateUid != null ">update_uid,</if> + + <if test="caseTitle != null and caseTitle != ''">case_title,</if> + <if test="caseContent != null and caseContent != ''">case_content,</if> + <if test="caseTime != null ">case_time,</if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="id != null ">#{id},</if> + <if test="delFlag != null ">#{delFlag},</if> + <if test="gmtCreate != null ">#{gmtCreate},</if> + <if test="gmtModitify != null ">#{gmtModitify},</if> + <if test="createUid != null ">#{createUid},</if> + <if test="updateUid != null ">#{updateUid},</if> + + <if test="caseTitle != null and caseTitle != ''">#{caseTitle},</if> + <if test="caseContent != null and caseContent != ''">#{caseContent},</if> + <if test="caseTime != null ">#{caseTime},</if> + </trim> + </insert> + + + <resultMap type="com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfoDetailDO" id="AccidentCaseInfoDetailDOResult"> + <id column="id" property="id" jdbcType="BIGINT"/> + <result column="case_title" property="caseTitle"/> + <result column="case_time" property="caseTime"/> + <result column="case_content" property="caseContent"/> + </resultMap> + + <select id="selectAccidentCaseById" resultMap="AccidentCaseInfoDetailDOResult"> + SELECT + id,case_title,case_time,case_content + FROM + accident_case + WHERE del_flag = 0 and id = #{id} + </select> + + <update id="updateAccidentCase" parameterType="com.gkhy.safePlatform.incidentManage.entity.AccidentCaseInfo"> + update accident_Case + <trim prefix="SET" suffixOverrides=","> + <if test="gmtModitify != null ">gmt_moditify = #{gmtModitify},</if> + <if test="updateUid != null ">update_uid = #{updateUid},</if> + + <if test="caseTitle != null and caseTitle != ''">case_title = #{caseTitle},</if> + <if test="caseContent != null and caseContent != ''">case_content = #{caseContent},</if> + <if test="caseTime != null ">case_time = #{caseTime},</if> + </trim> + where id = #{id} + </update> + + <update id="deleteAccidentCaseById"> + update accident_Case set del_flag = 1 where id = #{id} + </update> + +</mapper> -- Gitblit v1.9.2