From a157983c9e8b93ca7f8eebd574f0e4bf8c5d2bcb Mon Sep 17 00:00:00 2001
From: aix <vip_xiaobin810@163.com>
Date: Mon, 26 Aug 2024 14:47:24 +0800
Subject: [PATCH] 白蚁监测数据状态修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/WaterDataTermitesServiceImpl.java | 19 ++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/controller/WaterDataTermitesController.java | 47 +++++++++++++++
skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/entity/WaterDataTermites.java | 28 +++++++++
skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/vo/WaterDataTermitesVO.java | 12 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.xml | 10 +++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/IWaterDataTermitesService.java | 16 +++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.java | 14 ++++
7 files changed, 146 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/entity/WaterDataTermites.java b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/entity/WaterDataTermites.java
new file mode 100644
index 0000000..6298bef
--- /dev/null
+++ b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/entity/WaterDataTermites.java
@@ -0,0 +1,28 @@
+package cn.gistack.sm.sjztods.entity;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+@Data
+@TableName("\"water_data_termites\"")
+@ApiModel(value = "白蚁监测数据表", description = "白蚁监测数据表")
+public class WaterDataTermites {
+
+ /**
+ * 白蚁蚁情状态
+ */
+ @ApiModelProperty(value = "白蚁蚁情状态 白蚁蚁情状态,有白蚁入侵为1")
+ @TableField("\"status\"")
+ private Integer status;
+
+ /**
+ * 设备id
+ */
+ @ApiModelProperty(value = "设备id")
+ @TableField("\"device_id\"")
+ private Integer deviceId;
+
+}
diff --git a/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/vo/WaterDataTermitesVO.java b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/vo/WaterDataTermitesVO.java
new file mode 100644
index 0000000..7cc8668
--- /dev/null
+++ b/skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/vo/WaterDataTermitesVO.java
@@ -0,0 +1,12 @@
+package cn.gistack.sm.sjztods.vo;
+
+import cn.gistack.sm.sjztods.entity.WaterDataTermites;
+import lombok.Data;
+
+@Data
+public class WaterDataTermitesVO extends WaterDataTermites {
+
+ private String startTime;
+ private String endTime;
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/controller/WaterDataTermitesController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/controller/WaterDataTermitesController.java
new file mode 100644
index 0000000..5cb3cc6
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/controller/WaterDataTermitesController.java
@@ -0,0 +1,47 @@
+package cn.gistack.sm.sjztods.controller;
+
+import cn.gistack.sm.sjztods.entity.SkxsQkTj;
+import cn.gistack.sm.sjztods.entity.WaterDataTermites;
+import cn.gistack.sm.sjztods.service.IWaterDataTermitesService;
+import cn.gistack.sm.sjztods.vo.WaterDataTermitesVO;
+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.springblade.core.tool.utils.StringUtil;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+@Slf4j
+@Api(tags = "白蚁监测数据表")
+@RestController
+@RequestMapping("/sjztods/waterDataTermites")
+@AllArgsConstructor
+public class WaterDataTermitesController {
+
+ private final IWaterDataTermitesService waterDataTermitesService;
+
+ /**
+ * 修改状态
+ * @param waterDataTermites
+ * @return
+ */
+ @ApiOperation(value = "修改状态", notes = "修改状态")
+ @PostMapping(value = "/updateStatus")
+ public R updateStatus(@RequestBody WaterDataTermitesVO waterDataTermites) {
+ if (StringUtil.isAllBlank(waterDataTermites.getStartTime(),
+ waterDataTermites.getEndTime()) ||
+ null == waterDataTermites.getStatus() ||
+ null == waterDataTermites.getDeviceId()) {
+ return R.fail("非法参数");
+ }
+ return R.status(waterDataTermitesService.updateWaterDataTermites(waterDataTermites.getStartTime(),
+ waterDataTermites.getEndTime(),
+ waterDataTermites.getStatus().toString(),
+ waterDataTermites.getDeviceId().toString()));
+ }
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.java
new file mode 100644
index 0000000..a84d6d7
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.java
@@ -0,0 +1,14 @@
+package cn.gistack.sm.sjztods.mapper;
+
+import cn.gistack.sm.sjztods.entity.WaterDataTermites;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Param;
+
+public interface WaterDataTermitesMapper extends BaseMapper<WaterDataTermites> {
+
+ int updateWaterDataTermites(@Param("startTime") String startTime,
+ @Param("endTime") String endTime,
+ @Param("status") String status,
+ @Param("deviceId") String deviceId);
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.xml
new file mode 100644
index 0000000..ccb84da
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.xml
@@ -0,0 +1,10 @@
+<?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.sjztods.mapper.WaterDataTermitesMapper">
+
+ <update id="updateWaterDataTermites">
+ update SJZT_ODS."water_data_termites" set "status" = #{status}
+ WHERE "device_id" = #{deviceId} and "ob_date" >= #{startTime} and "ob_date" <= #{endTime}
+ </update>
+
+</mapper>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/IWaterDataTermitesService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/IWaterDataTermitesService.java
new file mode 100644
index 0000000..da8c7f7
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/IWaterDataTermitesService.java
@@ -0,0 +1,16 @@
+package cn.gistack.sm.sjztods.service;
+
+import cn.gistack.sm.sjztods.entity.WaterDataTermites;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * 白蚁监测数据
+ */
+public interface IWaterDataTermitesService extends IService<WaterDataTermites> {
+
+ boolean updateWaterDataTermites(String startTime,
+ String endTime,
+ String status,
+ String deviceId);
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/WaterDataTermitesServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/WaterDataTermitesServiceImpl.java
new file mode 100644
index 0000000..3410b7b
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/WaterDataTermitesServiceImpl.java
@@ -0,0 +1,19 @@
+package cn.gistack.sm.sjztods.service.impl;
+
+import cn.gistack.sm.sjztods.entity.WaterDataTermites;
+import cn.gistack.sm.sjztods.mapper.WaterDataTermitesMapper;
+import cn.gistack.sm.sjztods.service.IWaterDataTermitesService;
+import com.baomidou.dynamic.datasource.annotation.DS;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+
+@Service
+@DS("ztznwh")
+public class WaterDataTermitesServiceImpl extends ServiceImpl<WaterDataTermitesMapper, WaterDataTermites> implements IWaterDataTermitesService {
+
+
+ @Override
+ public boolean updateWaterDataTermites(String startTime, String endTime, String status, String deviceId) {
+ return baseMapper.updateWaterDataTermites(startTime, endTime, status, deviceId) > 0;
+ }
+}
--
Gitblit v1.9.3