From 0653439a512097919fceb114df9e476befa19dae Mon Sep 17 00:00:00 2001
From: aix <vip_xiaobin810@163.com>
Date: Fri, 28 Jun 2024 16:11:04 +0800
Subject: [PATCH] 提防危害等级评定
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbDykeUnitDangerServiceImpl.java | 30 +++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.java | 26 ++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/ITbDykeUnitDangerService.java | 19 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbDykeUnitDangerController.java | 49 ++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.xml | 17 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/TbDykeUnitDangerVO.java | 20 +++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/TbDykeUnitDanger.java | 61 +++++++++++++++
7 files changed, 222 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbDykeUnitDangerController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbDykeUnitDangerController.java
new file mode 100644
index 0000000..d2fe9d7
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/controller/TbDykeUnitDangerController.java
@@ -0,0 +1,49 @@
+package cn.gistack.sm.sjztmd.controller;
+
+import cn.gistack.sm.sjztmd.entity.TbDykeUnitDanger;
+import cn.gistack.sm.sjztmd.service.ITbDykeUnitDangerService;
+import cn.gistack.sm.sjztmd.vo.TbDykeUnitDangerVO;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
+import org.springblade.core.tool.api.R;
+import org.springframework.web.bind.annotation.*;
+import springfox.documentation.annotations.ApiIgnore;
+
+import java.util.List;
+
+
+/**
+ * @Author AIX
+ * @Date 2024/6/28 14:12
+ * @Version 1.0
+ */
+@Slf4j
+@Api(tags = "堤防危害等级评定")
+@RestController
+@RequestMapping("/sjztmd/tbDykeUnitDanger")
+@AllArgsConstructor
+public class TbDykeUnitDangerController {
+
+ private ITbDykeUnitDangerService tbDykeUnitDangerService;
+
+ @ApiOperation(value = "堤防危害等级评定-添加或者修改", notes = "堤防危害等级评定-添加或者修改")
+ @GetMapping(value = "/listDykeUnitDanger")
+ public R listDykeUnitDanger(@ApiIgnore TbDykeUnitDangerVO vo) {
+ return R.data(tbDykeUnitDangerService.listDykeUnitDanger(vo));
+ }
+
+ @ApiOperation(value = "堤防危害等级评定-添加或者修改", notes = "堤防危害等级评定-添加或者修改")
+ @PostMapping(value = "/submit")
+ public R submit(@RequestBody TbDykeUnitDanger tbDykeUnitDanger) {
+ return R.data(tbDykeUnitDangerService.saveOrUpdate(tbDykeUnitDanger));
+ }
+
+ @ApiOperation(value = "堤防危害等级评定-批量添加或者修改", notes = "堤防危害等级评定-添加或者修改")
+ @PostMapping(value = "/submitBatch")
+ public R submit(@RequestBody List<TbDykeUnitDanger> tbDykeUnitDangers) {
+ return R.data(tbDykeUnitDangerService.saveOrUpdateBatch(tbDykeUnitDangers));
+ }
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/TbDykeUnitDanger.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/TbDykeUnitDanger.java
new file mode 100644
index 0000000..a0b6e4d
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/entity/TbDykeUnitDanger.java
@@ -0,0 +1,61 @@
+package cn.gistack.sm.sjztmd.entity;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import com.fasterxml.jackson.databind.annotation.JsonSerialize;
+import com.fasterxml.jackson.databind.ser.std.ToStringSerializer;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.io.Serializable;
+import java.util.Date;
+
+/**
+ * @PROJECT_NAME: skjcmanager
+ * @DESCRIPTION: 提防危害等级
+ * @USER: aix
+ * @DATE: 2024/6/28 11:02
+ */
+@Data
+@TableName(value = "\"tb_dyke_unit_danger\"", autoResultMap = true)
+@ApiModel(value = "提防危害等级", description = "提防危害等级")
+public class TbDykeUnitDanger implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 主键
+ */
+ @JsonSerialize(using = ToStringSerializer.class)
+ @ApiModelProperty(value = "主键")
+ @TableId(value = "\"id\"", type = IdType.ASSIGN_ID)
+ private String id;
+
+ /**
+ * 提防id
+ */
+ @ApiModelProperty(value = "提防id")
+ @TableField("\"dyke_id\"")
+ private String dykeId;
+
+ /**
+ * 单元
+ */
+ @ApiModelProperty(value = "单元")
+ @TableField(value = "\"unit\"")
+ private String unit;
+
+ /**
+ * 危害等级
+ */
+ @ApiModelProperty(value = "危害等级")
+ @TableField(value = "\"danger_level\"")
+ private Integer dangerLevel;
+
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.java
new file mode 100644
index 0000000..b4dc2aa
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.java
@@ -0,0 +1,26 @@
+package cn.gistack.sm.sjztmd.mapper;
+
+import cn.gistack.sm.sjztmd.entity.TbDykeUnitDanger;
+import cn.gistack.sm.sjztmd.statisticsVO.StatisticsBar;
+import cn.gistack.sm.sjztmd.statisticsVO.StatisticsParams;
+import cn.gistack.sm.sjztmd.vo.TbDykeUnitDangerVO;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+/**
+ * @Author AIX
+ * @Date 2024/6/28 14:05
+ * @Version 1.0
+ */
+public interface ITbDykeUnitDangerMapper extends BaseMapper<TbDykeUnitDanger> {
+
+ /**
+ * 获取提防单元危害等级评定列表
+ * @param dykeUnitDangerVO
+ * @return
+ */
+ List<TbDykeUnitDangerVO> listDykeUnitDanger(@Param("params") TbDykeUnitDangerVO dykeUnitDangerVO);
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.xml
new file mode 100644
index 0000000..9a33137
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/ITbDykeUnitDangerMapper.xml
@@ -0,0 +1,17 @@
+<?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="cn.gistack.sm.sjztmd.mapper.ITbDykeUnitDangerMapper">
+
+ <select id="listDykeUnitDanger" resultType="cn.gistack.sm.sjztmd.vo.TbDykeUnitDangerVO">
+ select tdi.*,ifnull(tdud."danger_level",0) dangerLevel,tdud."id" from (
+ select "dyke_guid" dykeGuid,"unit",count(*) dangerNum,wm_concat(distinct "signs_of_termite_activity") hdjxs from sjzt_md."tb_dyke_investigation"
+ where "hazard_rating" = '有危害'
+ <if test="params.dykeGuid != null and params.dykeGuid != ''">
+ and "dyke_guid" = #{params.dykeGuid}
+ </if>
+ group by "dyke_guid","unit"
+ ) tdi
+ left join sjzt_md."tb_dyke_unit_danger" tdud on (tdi.dykeGuid = tdud."dyke_id" and tdi."unit" = tdud."unit")
+ </select>
+
+</mapper>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/ITbDykeUnitDangerService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/ITbDykeUnitDangerService.java
new file mode 100644
index 0000000..0274915
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/ITbDykeUnitDangerService.java
@@ -0,0 +1,19 @@
+package cn.gistack.sm.sjztmd.service;
+
+import cn.gistack.sm.sjztmd.entity.TbDykeUnitDanger;
+import cn.gistack.sm.sjztmd.vo.TbDykeUnitDangerVO;
+import com.baomidou.mybatisplus.extension.service.IService;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+/**
+ * @Author AIX
+ * @Date 2024/6/28 14:02
+ * @Version 1.0
+ */
+public interface ITbDykeUnitDangerService extends IService<TbDykeUnitDanger> {
+
+ List<TbDykeUnitDangerVO> listDykeUnitDanger(@Param("params") TbDykeUnitDangerVO dykeUnitDangerVO);
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbDykeUnitDangerServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbDykeUnitDangerServiceImpl.java
new file mode 100644
index 0000000..2256d6e
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/TbDykeUnitDangerServiceImpl.java
@@ -0,0 +1,30 @@
+package cn.gistack.sm.sjztmd.service.impl;
+
+
+import cn.gistack.sm.sjztmd.entity.TbDykeUnitDanger;
+import cn.gistack.sm.sjztmd.mapper.ITbDykeUnitDangerMapper;
+import cn.gistack.sm.sjztmd.service.ITbDykeUnitDangerService;
+import cn.gistack.sm.sjztmd.vo.TbDykeUnitDangerVO;
+import com.baomidou.dynamic.datasource.annotation.DS;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
+
+/**
+ * @Author AIX
+ * @Date 2024/6/28 14:04
+ * @Version 1.0
+ */
+@Service
+@DS("zt")
+@Transactional(rollbackFor = Exception.class)
+public class TbDykeUnitDangerServiceImpl extends ServiceImpl<ITbDykeUnitDangerMapper, TbDykeUnitDanger> implements ITbDykeUnitDangerService {
+
+ @Override
+ public List<TbDykeUnitDangerVO> listDykeUnitDanger(TbDykeUnitDangerVO dykeUnitDangerVO) {
+ return baseMapper.listDykeUnitDanger(dykeUnitDangerVO);
+ }
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/TbDykeUnitDangerVO.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/TbDykeUnitDangerVO.java
new file mode 100644
index 0000000..038acfa
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/vo/TbDykeUnitDangerVO.java
@@ -0,0 +1,20 @@
+package cn.gistack.sm.sjztmd.vo;
+
+import lombok.Data;
+
+/**
+ * @Author AIX
+ * @Date 2024/6/28 15:07
+ * @Version 1.0
+ */
+@Data
+public class TbDykeUnitDangerVO {
+
+ private String dykeGuid;//提防id
+ private String unit;//提防单元
+ private String dangerNum;//危害处数
+ private String hdjxs;//活动迹象
+ private String id;//危害等级评定id
+ private Integer dangerLevel;//危害等级评定
+
+}
--
Gitblit v1.9.3