From a1744d0bf7f0ad8ac861d672cffd7c710dac4e7e Mon Sep 17 00:00:00 2001
From: zhubaomin <zhubaomin>
Date: 星期五, 11 四月 2025 14:17:36 +0800
Subject: [PATCH] 获取未绑定轮灌组的取水口
---
pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/intake/IntakeCtrl.java | 96 +++++++++++++++++++++++++++++++++---------------
1 files changed, 66 insertions(+), 30 deletions(-)
diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/intake/IntakeCtrl.java b/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/intake/IntakeCtrl.java
index 44694c6..399d528 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/intake/IntakeCtrl.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-project/src/main/java/com/dy/pipIrrProject/intake/IntakeCtrl.java
@@ -1,17 +1,17 @@
package com.dy.pipIrrProject.intake;
import com.alibaba.excel.EasyExcel;
-import com.alibaba.excel.support.ExcelTypeEnum;
import com.dy.common.aop.SsoAop;
import com.dy.common.webUtil.BaseResponse;
import com.dy.common.webUtil.BaseResponseUtils;
import com.dy.common.webUtil.QueryResultVo;
import com.dy.common.webUtil.ResultCodeMsg;
+import com.dy.pipIrrGlobal.excel.CellWriteHandler;
+import com.dy.pipIrrGlobal.excel.ExcelUtil;
import com.dy.pipIrrGlobal.pojoPr.PrIntake;
-import com.dy.pipIrrGlobal.voPr.VoIntake;
-import com.dy.pipIrrGlobal.voPr.VoOnLineIntake;
+import com.dy.pipIrrGlobal.voPr.*;
import com.dy.pipIrrGlobal.voSe.VoActiveCard;
-import com.dy.pipIrrProject.intake.qo.OnLineIntakesQO;
+import com.dy.pipIrrProject.intake.qo.QoIntake;
import com.dy.pipIrrProject.result.ProjectResultCode;
import com.taobao.api.ApiException;
import io.swagger.v3.oas.annotations.Operation;
@@ -35,6 +35,7 @@
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
+import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
import java.util.*;
@@ -74,9 +75,9 @@
})
@GetMapping(path = "all")
@SsoAop()
- public BaseResponse<QueryResultVo<List<PrIntake>>> all() {
+ public BaseResponse<QueryResultVo<List<VoAllIntake>>> all() {
try {
- QueryResultVo<List<PrIntake>> res = this.intakeSv.selectAll();
+ QueryResultVo<List<VoAllIntake>> res = this.intakeSv.selectAll();
if (res == null) {
return BaseResponseUtils.buildErrorMsg(ProjectResultCode.NO_INTAKES.getMessage());
} else {
@@ -102,9 +103,9 @@
schema = @Schema(implementation = PrIntake.class))}
)
})
- @GetMapping(path = "one/{id}")
+ @GetMapping(path = "one")
@SsoAop()
- public BaseResponse<PrIntake> one(@PathVariable("id") Long id) {
+ public BaseResponse<VoAllIntake> one(@RequestParam("id") Long id) {
if (this.intakeSv.selectById(id) == null) {
return BaseResponseUtils.buildErrorMsg(ProjectResultCode.NO_INTAKES.getMessage());
} else {
@@ -125,11 +126,7 @@
@SsoAop()
public BaseResponse<QueryResultVo<List<VoIntake>>> getIntakes(QueryVo vo) {
try {
- QueryResultVo<List<VoIntake>> res = intakeSv.getIntakes(vo);
- if (res == null) {
- return BaseResponseUtils.buildErrorMsg(ProjectResultCode.NO_INTAKES.getMessage());
- }
- return BaseResponseUtils.buildSuccess(res);
+ return BaseResponseUtils.buildSuccess(intakeSv.getIntakes(vo));
} catch (Exception e) {
log.error("鑾峰彇鍙栨按鍙ｈ褰曞紓甯�", e);
return BaseResponseUtils.buildException(e.getMessage());
@@ -207,6 +204,33 @@
}
/**
+ * app淇敼鍙栨按鍙ｇ粡绾害
+ * @param po
+ * @param bindingResult
+ * @return
+ */
+ @PostMapping(path = "updateIntakeLngLat", consumes = MediaType.APPLICATION_JSON_VALUE)
+ @SsoAop()
+ public BaseResponse<Boolean> updateIntakeLngLat(@RequestBody @Parameter(description = "form琛ㄥ崟json鏁版嵁", required = true) @Valid IntakeUpdateLngLat po, @Parameter(hidden = true) BindingResult bindingResult) {
+ if (bindingResult != null && bindingResult.hasErrors()) {
+ return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
+ }
+ int count;
+ po.setOperateDt(new Date());
+ try {
+ count = this.intakeSv.updateIntakeLngLat(po);
+ } catch (Exception e) {
+ log.error("淇濆瓨鍙栨按鍙ｇ粡绾害寮傚父", e);
+ return BaseResponseUtils.buildException(e.getMessage());
+ }
+ if (count <= 0) {
+ return BaseResponseUtils.buildErrorMsg(ProjectResultCode.UPDATE_INTAKE.getMessage());
+ } else {
+ return BaseResponseUtils.buildSuccess(true);
+ }
+ }
+
+ /**
* 鍒犻櫎鍙栨按鍙�
*
* @param map 鍙栨按鍙D
@@ -240,8 +264,6 @@
log.error("淇濆瓨鍒嗘按鍙ｅ紓甯�", e);
return BaseResponseUtils.buildException(e.getMessage());
}
-
-
}
/**
@@ -252,16 +274,15 @@
*/
@SneakyThrows(IOException.class)
@GetMapping(value = "exportIntakes")
+ @SsoAop()
public void exportIntakes(HttpServletResponse response, QueryVo vo) {
- setExcelRespProp(response, "鍙栨按鍙ｅ垪琛�");
- //List<VoDivide> memberList = LocalJsonUtil.getListFromJson("json/members.json", VoDivide.class);
- List<VoIntake> memberList = intakeSv.exportIntakes(vo);
+ List<VoIntake> intakeList = intakeSv.exportIntakes(vo);
- EasyExcel.write(response.getOutputStream())
- .head(VoIntake.class)
- .excelType(ExcelTypeEnum.XLSX)
- .sheet("鍙栨按鍙ｅ垪琛�")
- .doWrite(memberList);
+ ExcelUtil.setExcelRespProp(response, "鍙栨按鍙ｅ垪琛�" + LocalDate.now());
+ EasyExcel.write(response.getOutputStream(), VoIntake.class)
+ .registerWriteHandler(new CellWriteHandler("鍙栨按鍙ｅ垪琛�"))
+ .sheet("鍙栨按鍙�")
+ .doWrite(intakeList);
}
/**
@@ -291,14 +312,13 @@
}
/**
+ * 姝ゅ姛鑳藉凡缍撶Щ妞嶅埌remote妯″鐨凪onitroCtrl涓�
* 鑾峰彇鍙栨按鍙ｅ垪琛紙鍦ㄧ嚎鍜屼笉鍦ㄧ嚎锛�
- *
* @param qo
* @return
- */
- @GetMapping(path = "all_intakes")
- @SsoAop()
- public BaseResponse<QueryResultVo<List<VoOnLineIntake>>> getAllIntakes(OnLineIntakesQO qo) {
+ @GetMapping(path = "all_intakes")
+ @SsoAop()
+ public BaseResponse<QueryResultVo<List<VoOnLineIntake>>> getAllIntakes(OnLineIntakesQO qo) {
try {
QueryResultVo<List<VoOnLineIntake>> res = intakeSv.selectOnLineIntakes(qo);
return BaseResponseUtils.buildSuccess(res);
@@ -306,8 +326,8 @@
log.error("鏌ヨ鍙栨按鍙ｅ紓甯�", e);
return BaseResponseUtils.buildException(e.getMessage());
}
- }
-
+ }
+ */
/**
* 鏍规嵁鎿嶄綔鍛樿幏鍙栧父鐢ㄥ彇姘村彛锛堝湪绾垮拰涓嶅湪绾匡級
*
@@ -325,4 +345,20 @@
return BaseResponseUtils.buildException(e.getMessage());
}
}
+
+ /**
+ * 鑾峰彇鏈粦瀹氬埌杞亴缁勭殑鍙栨按鍙ｅ垪琛�
+ * @return
+ */
+ @GetMapping(path = "getFreeIntakes")
+ @SsoAop()
+ public BaseResponse<List<VoIntakeSimple>> getFreeIntakes(QoIntake qo) {
+ try {
+ List<VoIntakeSimple> res = intakeSv.getFreeIntakes(qo);
+ return BaseResponseUtils.buildSuccess(res);
+ } catch (Exception e) {
+ log.error("鏌ヨ鍙栨按鍙ｅ紓甯�", e);
+ return BaseResponseUtils.buildException(e.getMessage());
+ }
+ }
}
--
Gitblit v1.8.0