白蚁监测数据状态修改

aix

2024-08-26 a157983c9e8b93ca7f8eebd574f0e4bf8c5d2bcb

白蚁监测数据状态修改

 skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/entity/WaterDataTermites.java

New file
@@ -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;

}

 skjcmanager/skjcmanager-service-api/skjcmanager-sm-api/src/main/java/cn/gistack/sm/sjztods/vo/WaterDataTermitesVO.java

New file
@@ -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;

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/controller/WaterDataTermitesController.java

New file
@@ -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()));
    }

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.java

New file
@@ -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);

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/mapper/WaterDataTermitesMapper.xml

New file
@@ -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" &gt;= #{startTime} and "ob_date" &lt;= #{endTime}
    </update>

</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/IWaterDataTermitesService.java

New file
@@ -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);

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/WaterDataTermitesServiceImpl.java

New file
@@ -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;
    }
}