From aa295dc3191a4a426a4a1c3b52dba65b09b34278 Mon Sep 17 00:00:00 2001
From: zrj <646384940@qq.com>
Date: Wed, 05 Jun 2024 14:39:27 +0800
Subject: [PATCH] 新增海康设备水尺监测功能

---
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/controller/HkStaffGaugeMonController.java    |  114 ++++++++++++
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.java            |   21 ++
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/impl/HkStaffGaugeMonServiceImpl.java |   91 ++++++++++
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/vo/HkStaffGaugeMonVO.java                    |   48 +++++
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkStaffGaugeMon.java                  |  144 ++++++++++++++++
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/HkStaffGaugeMonService.java          |   36 ++++
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/constant/HkConstant.java                     |    4 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml             |   49 +++++
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkEvent.java                          |    2 
 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/util/GetCameraUtils.java                     |   20 ++
 10 files changed, 528 insertions(+), 1 deletions(-)

diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/constant/HkConstant.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/constant/HkConstant.java
index b8baf08..ac28e86 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/constant/HkConstant.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/constant/HkConstant.java
@@ -163,6 +163,10 @@
 	 */
 	public static final String regionNodesByParamsURLs = "/api/irds/v2/region/nodesByParams";
 
+	/**
+	 * 查询水尺监测信息
+	 */
+	public static final String waterGaugeURLs = "/api/v1/waterGauge/list";
 
 
 
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/controller/HkStaffGaugeMonController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/controller/HkStaffGaugeMonController.java
new file mode 100644
index 0000000..49114a9
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/controller/HkStaffGaugeMonController.java
@@ -0,0 +1,114 @@
+package cn.gistack.sm.hk.controller;
+
+
+import cn.gistack.sm.hk.entity.HkStaffGaugeMon;
+import cn.gistack.sm.hk.service.HkStaffGaugeMonService;
+import cn.gistack.sm.hk.vo.HkStaffGaugeMonVO;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
+import org.springblade.core.mp.support.Condition;
+import org.springblade.core.mp.support.Query;
+import org.springblade.core.tool.api.R;
+import org.springframework.web.bind.annotation.*;
+
+/**
+ * @author zhongrj
+ * @Description: 水尺监测
+ * @date 2024-06-05
+ */
+@Slf4j
+@Api(tags = "水尺监测")
+@RestController
+@RequestMapping("/hk/hkStaffGaugeMon")
+@AllArgsConstructor
+public class HkStaffGaugeMonController {
+
+	private final HkStaffGaugeMonService hkStaffGaugeMonService;
+
+	/**
+	 * 分页列表查询
+	 *
+	 * @param hkStaffGaugeMon
+	 * @return
+	 */
+	@ApiOperation(value="水尺监测-分页列表查询", notes="水尺监测-分页列表查询")
+	@GetMapping(value = "/list")
+	public R queryPageList(HkStaffGaugeMon hkStaffGaugeMon, Query query) {
+		IPage<HkStaffGaugeMon> pageList = hkStaffGaugeMonService.page(Condition.getPage(query), Condition.getQueryWrapper(hkStaffGaugeMon));
+		return R.data(pageList);
+	}
+
+	/**
+	 * 自定义分页列表查询
+	 * @param query
+	 * @param hkStaffGaugeMon
+	 * @return
+	 */
+	@ApiOperation(value="水尺监测-自定义分页列表查询", notes="水尺监测-自定义分页列表查询")
+	@GetMapping(value = "/page")
+	public R selectAlarmPage(HkStaffGaugeMonVO hkStaffGaugeMon, Query query) {
+		return R.data(hkStaffGaugeMonService.selectHkStaffGaugeMonPage(Condition.getPage(query),hkStaffGaugeMon));
+	}
+
+	/**
+	 * 添加
+	 *
+	 * @param hkStaffGaugeMon
+	 * @return
+	 */
+	@ApiOperation(value="水尺监测-添加", notes="水尺监测-添加")
+	@PostMapping(value = "/add")
+	public R add(@RequestBody HkStaffGaugeMon hkStaffGaugeMon) {
+		return R.data(hkStaffGaugeMonService.save(hkStaffGaugeMon));
+	}
+
+	/**
+	 * 编辑
+	 *
+	 * @param hkStaffGaugeMon
+	 * @return
+	 */
+	@ApiOperation(value="水尺监测-编辑", notes="水尺监测-编辑")
+	@RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
+	public R edit(@RequestBody HkStaffGaugeMon hkStaffGaugeMon) {
+		return R.data(hkStaffGaugeMonService.updateById(hkStaffGaugeMon));
+	}
+
+	/**
+	 * 通过id查询
+	 *
+	 * @param id
+	 * @return
+	 */
+	@ApiOperation(value="水尺监测-通过id查询", notes="水尺监测-通过id查询")
+	@GetMapping(value = "/queryById")
+	public R queryById(@RequestParam(name="id",required=true) String id) {
+		HkStaffGaugeMon hkStaffGaugeMon = hkStaffGaugeMonService.getById(id);
+		return R.data(hkStaffGaugeMon);
+	}
+
+	/**
+	 * 定时读取
+	 * @return
+	 */
+	@GetMapping(value = "/insert")
+	public void insert() {
+		// 保存数据
+		hkStaffGaugeMonService.saveHkStaffGaugeMonInfo();
+	}
+
+	/**
+	 * 定时读取
+	 * @return
+	 */
+	@PostMapping(value = "/test")
+	public void insert(@RequestBody String data) {
+		// 保存数据
+		hkStaffGaugeMonService.saveHkStaffGaugeMonInfo(data);
+	}
+
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkEvent.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkEvent.java
index bf6872c..e82963a 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkEvent.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkEvent.java
@@ -19,7 +19,7 @@
  */
 @Data
 @TableName(value = "sm_hk_event")
-@ApiModel(value = "sm_hk_event对象", description = "考核方案")
+@ApiModel(value = "sm_hk_event对象", description = "海康视频事件")
 public class HkEvent implements Serializable {
 
 	/**
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkStaffGaugeMon.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkStaffGaugeMon.java
new file mode 100644
index 0000000..e6fefe5
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/entity/HkStaffGaugeMon.java
@@ -0,0 +1,144 @@
+package cn.gistack.sm.hk.entity;
+
+import com.baomidou.mybatisplus.annotation.*;
+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;
+
+/**
+ * 海康水尺监测
+ *
+ * @author zhongrj
+ * @date 2024-06-05
+ */
+@Data
+@TableName(value = "sm_hk_staff_gauge_mon")
+@ApiModel(value = "sm_hk_staff_gauge_mon对象", description = "水尺监测")
+public class HkStaffGaugeMon implements Serializable {
+
+	/**
+	 * 主键id
+	 */
+	@TableId(value = "id")
+	private String id;
+
+	/**
+	 * 水尺名称
+	 */
+	@ApiModelProperty(value = "水尺名称")
+	private String waterGaugeName;
+
+	/**
+	 * 水尺编号
+	 */
+	@ApiModelProperty(value = "水尺编号")
+	private String waterGaugeCode;
+
+	/**
+	 * 设备编号
+	 */
+	@ApiModelProperty(value = "设备编号")
+	private String cameraIndexCode;
+
+	/**
+	 * 设备名称
+	 */
+	@ApiModelProperty(value = "设备名称")
+	private String cameraName;
+
+	/**
+	 * 监测位置
+	 */
+	@ApiModelProperty(value = "监测位置")
+	private String location;
+
+	/**
+	 * 原始的比对的图片
+	 */
+	@ApiModelProperty(value = "原始的比对的图片")
+	private String markPic;
+
+	/**
+	 * 虚拟水尺的坐标
+	 */
+	private String markData;
+
+	/**
+	 * 当前虚拟水尺图片
+	 */
+	@ApiModelProperty(value = "当前虚拟水尺图片")
+	private String currentPic;
+
+	/**
+	 * 水位高度
+	 */
+	@ApiModelProperty(value = "水位高度")
+	private Double alarmHeight;
+
+	/**
+	 * 备注1
+	 */
+	@ApiModelProperty(value = "备注1")
+	private String remark1;
+
+	/**
+	 * 备注2
+	 */
+	@ApiModelProperty(value = "备注2")
+	private String remark2;
+
+	/**
+	 * 备注3
+	 */
+	@ApiModelProperty(value = "备注3")
+	private String remark3;
+	/**
+	 * 备注4
+	 */
+	@ApiModelProperty(value = "备注4")
+	private String remark4;
+	/**
+	 * 备注5
+	 */
+	@ApiModelProperty(value = "备注5")
+	private String remark5;
+
+	/**
+	 * 设置更新时间
+	 */
+	@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
+	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+	@ApiModelProperty(value = "设置更新时间")
+	private Date configUpdateTime;
+
+	/**
+	 * 创建时间
+	 */
+	@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
+	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+	@ApiModelProperty(value = "创建时间")
+	@TableField(value = "create_time",fill = FieldFill.INSERT)
+	private Date createTime;
+
+	/**
+	 * 数据分析上报时间
+	 */
+	@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
+	@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
+	@ApiModelProperty(value = "数据分析上报时间")
+	@TableField(value = "update_time")
+	private Date updateTime;
+
+	/**
+	 * 删除状态
+	 */
+	@ApiModelProperty(value = "删除状态")
+	private Integer deleteStatus;
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.java
new file mode 100644
index 0000000..c1d1522
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.java
@@ -0,0 +1,21 @@
+package cn.gistack.sm.hk.mapper;
+
+import cn.gistack.sm.hk.entity.HkStaffGaugeMon;
+import cn.gistack.sm.hk.vo.HkStaffGaugeMonVO;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+public interface HkStaffGaugeMonMapper extends BaseMapper<HkStaffGaugeMon> {
+
+	/**
+	 * 自定义分页列表查询
+	 * @param page
+	 * @param hkStaffGaugeMon
+	 * @return
+	 */
+	List<HkStaffGaugeMonVO> selectHkStaffGaugeMonPage(@Param("page") IPage<HkStaffGaugeMonVO> page,
+													  @Param("hkStaffGaugeMon")  HkStaffGaugeMonVO hkStaffGaugeMon);
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml
new file mode 100644
index 0000000..d8e1763
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/mapper/HkStaffGaugeMonMapper.xml
@@ -0,0 +1,49 @@
+<?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.hk.mapper.HkStaffGaugeMonMapper">
+
+    <!--自定义分页列表查询-->
+    <select id="selectHkStaffGaugeMonPage" resultType="cn.gistack.sm.hk.vo.HkStaffGaugeMonVO">
+        select
+        shsgm.*,
+        awb."res_guid" as resGuid,
+        a."name" as resName,
+        case when b."ad_grad" = 4 THEN b."ad_name"
+        ELSE NULL END AS townName,
+        case when b."ad_grad" = 3 THEN b."ad_name"
+        when c."ad_grad" = 3 THEN C."ad_name"
+        END AS countyName,
+        case when b."ad_grad" = 2 THEN b."ad_name"
+        when c."ad_grad" = 2 THEN c."ad_name"
+        ELSE d."ad_name" END AS cityName
+        from YWXT.sm_hk_staff_gauge_mon shsgm
+        left join (
+            select "res_guid","video_guid" from SJZT_MD."att_wmst_base"
+            union all
+            select "regionindexcode" as "res_guid","gbindexcode" as "video_guid" from SJZT_ODS."haik_gb_wmst_base"
+        )
+        awb on awb."video_guid" = shsgm.camera_index_code
+        left join SJZT_MD."att_res_base" a on a."guid" = awb."res_guid"
+        left join SJZT_MD."att_ad_base" b on b."guid" = a."interior_ad_guid"
+        LEFT JOIN SJZT_MD."att_ad_base" c ON b."p_ad_code" = c."guid"
+        LEFT JOIN SJZT_MD."att_ad_base" d ON c."p_ad_code" = d."guid"
+        where 1 =1
+        <if test="hkStaffGaugeMon.cameraName!=null and hkStaffGaugeMon.cameraName!=''">
+            and shsgm.camera_name like concat('%',#{hkStaffGaugeMon.cameraName},'%')
+        </if>
+        <if test="hkStaffGaugeMon.resName!=null and hkStaffGaugeMon.resName!=''">
+            and a."name" like concat('%',#{hkStaffGaugeMon.resName},'%')
+        </if>
+        <if test="hkStaffGaugeMon.startTime !=null and hkStaffGaugeMon.startTime !=''">
+            AND DATE_FORMAT(shsgm.update_time,'%Y-%m-%d') &gt;= #{hkStaffGaugeMon.startTime}
+        </if>
+        <if test="hkStaffGaugeMon.endTime !=null and hkStaffGaugeMon.endTime !=''">
+            AND DATE_FORMAT(shsgm.update_time,'%Y-%m-%d') &lt;= #{hkStaffGaugeMon.endTime}
+        </if>
+        <if test="hkStaffGaugeMon.adCode != null and hkStaffGaugeMon.adCode !='' and hkStaffGaugeMon.adCode !='420000000000'">
+            AND (b."ad_code" = #{hkStaffGaugeMon.adCode} or c."ad_code" =#{hkStaffGaugeMon.adCode} or d."ad_code" = #{hkStaffGaugeMon.adCode})
+        </if>
+        order by shsgm.id desc,shsgm.update_time desc
+    </select>
+
+</mapper>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/HkStaffGaugeMonService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/HkStaffGaugeMonService.java
new file mode 100644
index 0000000..f37788b
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/HkStaffGaugeMonService.java
@@ -0,0 +1,36 @@
+package cn.gistack.sm.hk.service;
+
+
+import cn.gistack.sm.hk.entity.HkStaffGaugeMon;
+import cn.gistack.sm.hk.vo.HkStaffGaugeMonVO;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * 水尺监测服务接口层
+ * @author zhongrj
+ * @date 2024-06-05
+ */
+public interface HkStaffGaugeMonService extends IService<HkStaffGaugeMon> {
+
+	/**
+	 * 自定义分页列表查询
+	 * @param page
+	 * @param hkStaffGaugeMon
+	 * @return
+	 */
+	IPage<HkStaffGaugeMonVO> selectHkStaffGaugeMonPage(IPage<HkStaffGaugeMonVO> page, HkStaffGaugeMonVO hkStaffGaugeMon);
+
+	/**
+	 * 保存数据
+	 * @return
+	 */
+	void saveHkStaffGaugeMonInfo();
+
+	/**
+	 * 保存数据
+	 * @param data
+	 * @return
+	 */
+	void saveHkStaffGaugeMonInfo(String data);
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/impl/HkStaffGaugeMonServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/impl/HkStaffGaugeMonServiceImpl.java
new file mode 100644
index 0000000..0cd2086
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/service/impl/HkStaffGaugeMonServiceImpl.java
@@ -0,0 +1,91 @@
+package cn.gistack.sm.hk.service.impl;
+
+import cn.gistack.sm.hk.entity.HkEvent;
+import cn.gistack.sm.hk.entity.HkStaffGaugeMon;
+import cn.gistack.sm.hk.mapper.HkStaffGaugeMonMapper;
+import cn.gistack.sm.hk.service.HkStaffGaugeMonService;
+import cn.gistack.sm.hk.util.GetCameraUtils;
+import cn.gistack.sm.hk.vo.HkStaffGaugeMonVO;
+import com.alibaba.fastjson.JSONArray;
+import com.alibaba.fastjson.JSONObject;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.stereotype.Service;
+
+import java.util.Date;
+import java.util.Map;
+
+import static cn.gistack.sm.hk.constant.HkConstant.waterGaugeURLs;
+
+/**
+ * 水尺监测服务接口实现层
+ * @author zhongrj
+ * @date 2024-06-05
+ */
+@Service
+@Slf4j
+public class HkStaffGaugeMonServiceImpl extends ServiceImpl<HkStaffGaugeMonMapper, HkStaffGaugeMon> implements HkStaffGaugeMonService {
+
+	/**
+	 * 自定义分页列表查询
+	 * @param page
+	 * @param hkStaffGaugeMon
+	 * @return
+	 */
+	@Override
+	public IPage<HkStaffGaugeMonVO> selectHkStaffGaugeMonPage(IPage<HkStaffGaugeMonVO> page, HkStaffGaugeMonVO hkStaffGaugeMon) {
+		return page.setRecords(baseMapper.selectHkStaffGaugeMonPage(page,hkStaffGaugeMon));
+	}
+
+	/**
+	 * 保存数据
+	 * @return
+	 */
+	@Override
+	public void saveHkStaffGaugeMonInfo() {
+		// 解析json
+		String result = GetCameraUtils.getStaffGaugeMon(3, waterGaugeURLs);
+		// 保存
+		saveHkStaffGaugeMonInfo(result);
+	}
+
+	/**
+	 * 保存数据
+	 * @param result
+	 * @return
+	 */
+	@Override
+	public void saveHkStaffGaugeMonInfo(String result) {
+		// 解析json
+		log.info("水尺监测信息:" + result);
+		JSONObject jsonObject = JSONObject.parseObject(result);
+		JSONArray jsonArray = jsonObject.getJSONArray("data");
+		if (null!= jsonArray && jsonArray.size()>0) {
+			for (int i = 0; i < jsonArray.size(); i++) {
+				HkStaffGaugeMon hkStaffGaugeMon = new HkStaffGaugeMon();
+				hkStaffGaugeMon.setId(jsonArray.getJSONObject(i).getString("id"));
+				hkStaffGaugeMon.setWaterGaugeName(jsonArray.getJSONObject(i).getString("waterGaugeName"));
+				hkStaffGaugeMon.setWaterGaugeCode(jsonArray.getJSONObject(i).getString("waterGaugeCode"));
+				hkStaffGaugeMon.setCameraIndexCode(jsonArray.getJSONObject(i).getString("cameraIndexCode"));
+				hkStaffGaugeMon.setCameraName(jsonArray.getJSONObject(i).getString("cameraName"));
+				hkStaffGaugeMon.setLocation(jsonArray.getJSONObject(i).getString("location"));
+				hkStaffGaugeMon.setMarkPic(jsonArray.getJSONObject(i).getString("markPic"));
+				hkStaffGaugeMon.setMarkData(jsonArray.getJSONObject(i).getString("markData"));
+				hkStaffGaugeMon.setCreateTime(jsonArray.getJSONObject(i).getDate("createTime"));
+				hkStaffGaugeMon.setConfigUpdateTime(jsonArray.getJSONObject(i).getDate("configUpdateTime"));
+				hkStaffGaugeMon.setUpdateTime(jsonArray.getJSONObject(i).getDate("updateTime"));
+				hkStaffGaugeMon.setDeleteStatus(jsonArray.getJSONObject(i).getInteger("deleteStatus"));
+				hkStaffGaugeMon.setCurrentPic(jsonArray.getJSONObject(i).getString("currentPic"));
+				hkStaffGaugeMon.setAlarmHeight(jsonArray.getJSONObject(i).getDouble("alarmHeight"));
+				hkStaffGaugeMon.setRemark1(jsonArray.getJSONObject(i).getString("remark1"));
+				hkStaffGaugeMon.setRemark2(jsonArray.getJSONObject(i).getString("remark2"));
+				hkStaffGaugeMon.setRemark3(jsonArray.getJSONObject(i).getString("remark3"));
+				hkStaffGaugeMon.setRemark4(jsonArray.getJSONObject(i).getString("remark4"));
+				hkStaffGaugeMon.setRemark5(jsonArray.getJSONObject(i).getString("remark5"));
+				// 保存
+				save(hkStaffGaugeMon);
+			}
+		}
+	}
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/util/GetCameraUtils.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/util/GetCameraUtils.java
index d2d286a..f128cd9 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/util/GetCameraUtils.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/util/GetCameraUtils.java
@@ -370,6 +370,26 @@
 		return common(null==eventVO.getType()?1:eventVO.getType(),url, body);
 	}
 
+	/**
+	 * 调用水尺检测信息
+	 * @param type
+	 * @param url
+	 * @return
+	 */
+	public static String getStaffGaugeMon(Integer type, String url) {
+		/**
+		 * 组装请求参数
+		 */
+		JSONObject jsonBody = new JSONObject();
+		String body = jsonBody.toJSONString();
+
+		/**
+		 * 调用接口并返回数据
+		 * post请求application/json类型参数;
+		 */
+		return common(null==type?1:type,url, body);
+	}
+
 //	public static void main(String[] args) {
 //
 //		String previewURL = GetCameraPreviewURL(1, HkConstant.previewURLs,
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/vo/HkStaffGaugeMonVO.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/vo/HkStaffGaugeMonVO.java
new file mode 100644
index 0000000..3d7ceb9
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/hk/vo/HkStaffGaugeMonVO.java
@@ -0,0 +1,48 @@
+package cn.gistack.sm.hk.vo;
+
+import cn.gistack.sm.hk.entity.HkStaffGaugeMon;
+import lombok.Data;
+import java.io.Serializable;
+
+@Data
+public class HkStaffGaugeMonVO extends HkStaffGaugeMon implements Serializable {
+
+	/**
+	 * 开始时间
+	 */
+	private String startTime;
+
+	/**
+	 * 结束时间
+	 */
+	private String endTime;
+	/**
+	 * 水库编号
+	 */
+	private String resGuid;
+
+	/**
+	 * 水库名称
+	 */
+	private String resName;
+
+	/**
+	 * 市州名称
+	 */
+	private String cityName;
+
+	/**
+	 * 区县
+	 */
+	private String countyName;
+
+	/**
+	 * 乡镇
+	 */
+	private String townName;
+
+	/**
+	 * 区域编号
+	 */
+	private String adCode;
+}

--
Gitblit v1.9.3