From c8b2311124fd5785b90d2fb4bd9ae0078aa13055 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 03 一月 2025 11:26:08 +0800
Subject: [PATCH] 1、查询农户年月的各日用水信息; 2、修改文档名称为《管系统系统增加一个客户的方法》; 3、增加一个文档《洒泉职业技术学院设备配置》。

---
 pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/issue/IssueSv.java |  123 ++++++++++++++++++++++++++++++++++++++++
 1 files changed, 121 insertions(+), 2 deletions(-)

diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/issue/IssueSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/issue/IssueSv.java
index 44b313d..3354a6f 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/issue/IssueSv.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/issue/IssueSv.java
@@ -1,10 +1,23 @@
 package com.dy.pipIrrWechat.issue;
 
+import com.alibaba.fastjson2.JSON;
+import com.alibaba.fastjson2.JSONArray;
+import com.dy.common.webUtil.QueryResultVo;
 import com.dy.pipIrrGlobal.daoSe.SeIssueReportMapper;
+import com.dy.pipIrrGlobal.daoSe.SeReportReplyMapper;
 import com.dy.pipIrrGlobal.pojoSe.SeIssueReport;
+import com.dy.pipIrrGlobal.pojoSe.SeReportReply;
+import com.dy.pipIrrGlobal.voSe.VoIssueReport;
+import com.dy.pipIrrGlobal.voSe.VoIssueReportReply;
+import com.dy.pipIrrGlobal.voSe.VoIssueReport_temp;
+import com.dy.pipIrrWechat.issue.qo.QoIssueReport;
 import lombok.extern.slf4j.Slf4j;
+import org.apache.dubbo.common.utils.PojoUtils;
+import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
+
+import java.util.*;
 
 /**
  * @author ZhuBaoMin
@@ -19,13 +32,119 @@
     @Autowired
     private SeIssueReportMapper seIssueReportMapper;
 
+    @Autowired
+    private SeReportReplyMapper seReportReplyMapper;
+
     /**
-     * 娣诲姞闂涓婃姤淇℃伅
+     * 娣诲姞鐢ㄦ埛闂涓婃姤
      * @param po
      * @return
      */
-    public Long insertIssueReport(SeIssueReport po) {
+    public String addIssueReport(SeIssueReport po) {
+        po.setReportTime(new Date());
+        po.setState((byte)1);
         seIssueReportMapper.insert(po);
+        Long issueReportId = po.getId();
+        if(issueReportId == null) {
+            return "鍐滄埛闂涓婃姤澶辫触";
+        }
+
+        return "success";
+    }
+
+    /**
+     * 淇敼鍐滄埛闂涓婃姤鐘舵�侊紝鍥炲鍙婂垹闄ゆ椂浣跨敤
+     * @param po
+     * @return
+     */
+    public Integer updateIssueReport(SeIssueReport po) {
+        return seIssueReportMapper.updateByPrimaryKeySelective(po);
+    }
+
+    /**
+     * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鍐滄埛闂涓婃姤
+     * @param queryVo
+     * @return
+     */
+    public QueryResultVo<List<VoIssueReport>> getIssueReports(QoIssueReport queryVo) {
+        //瀹屽杽鏌ヨ鍏呭�艰褰曠殑璧锋鏃堕棿
+        String timeStart = queryVo.getTimeStart();
+        String timeStop = queryVo.getTimeStop();
+        if (timeStart != null) {
+            timeStart = timeStart + " 00:00:00";
+            queryVo.setTimeStart(timeStart);
+        }
+        if (timeStop != null) {
+            timeStop = timeStop + " 23:59:59";
+            queryVo.setTimeStop(timeStop);
+        }
+
+        Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo);
+
+        Long itemTotal = seIssueReportMapper.getIssueReportsCount(params);
+        QueryResultVo<List<VoIssueReport>> rsVo = new QueryResultVo<>();
+
+        rsVo.pageSize = queryVo.pageSize;
+        rsVo.pageCurr = queryVo.pageCurr;
+
+        rsVo.calculateAndSet(itemTotal, params);
+
+        List<VoIssueReport_temp> list_temp = seIssueReportMapper.getIssueReports(params);
+        List<VoIssueReport> list = new ArrayList<>();
+        for (int i = 0; i < list_temp.size(); i++) {
+            VoIssueReport_temp report_temp = list_temp.get(i);
+            VoIssueReport report = new VoIssueReport();
+            BeanUtils.copyProperties(report_temp, report);
+
+            JSONArray images_array = Optional.ofNullable(JSON.parseArray(report_temp.getImages())).orElse(new JSONArray());
+            JSONArray audios_array = Optional.ofNullable(JSON.parseArray(report_temp.getAudios())).orElse(new JSONArray());
+            JSONArray videos_array = Optional.ofNullable(JSON.parseArray(report_temp.getVideos())).orElse(new JSONArray());
+            report.setImages(images_array);
+            report.setAudios(audios_array);
+            report.setVideos(videos_array);
+            list.add(report);
+        }
+
+        rsVo.obj = list;
+        return rsVo;
+    }
+
+    /**
+     * 鏍规嵁涓婃姤ID鍙婂啘鎴稩D鑾峰彇鏈垹闄ょ殑涓婃姤锛屽垹闄や笂鎶ュ垽鏂娇鐢�
+     * @param issueReportId
+     * @param clientId
+     * @return
+     */
+    public SeIssueReport getReport(Long issueReportId, Long clientId) {
+        return seIssueReportMapper.getReport(issueReportId, clientId);
+    }
+
+    /**
+     * 鍒犻櫎鍐滄埛闂涓婃姤
+     * @param issueReportId
+     * @return
+     */
+    public Integer deleteIssueReport(Long issueReportId) {
+        return seIssueReportMapper.deleteIssueReport(issueReportId);
+    }
+
+    /**
+     * 娣诲姞鍐滄埛闂涓婃姤鍥炲
+     * @param po
+     * @return
+     */
+    public Long insertReportReply(SeReportReply po) {
+        seReportReplyMapper.insert(po);
         return po.getId();
     }
+
+    /**
+     * 鏍规嵁闂涓婃姤ID鑾峰彇涓婃姤鍥炲淇℃伅
+     * @param reportId
+     * @return
+     */
+    public VoIssueReportReply getReportReplyByReportId(Long reportId) {
+        return seReportReplyMapper.getReportReplyByReportId(reportId);
+    }
+
 }

--
Gitblit v1.8.0