From 203223860baa19deb6860eb2ba3181910d662980 Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期四, 17 四月 2025 14:22:59 +0800 Subject: [PATCH] 1. 轮灌组被终止时灌溉时长为实际数值。2. 计划历史表按照创建时间倒排序。3. 发布计划时判断是否同项目下未完成计划,是否其他项目下使用了本计划的轮灌组且计划未完成。4. 根据计划ID获取计划最新状态。 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java | 97 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 97 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java new file mode 100644 index 0000000..7b1a76b --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerMapper.java @@ -0,0 +1,97 @@ +package com.dy.pipIrrGlobal.daoPr; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.dy.pipIrrGlobal.pojoPr.PrController; +import com.dy.pipIrrGlobal.voPr.VoController; +import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; + +import java.util.List; +import java.util.Map; + +/** + * @author ZhuBaoMin + * @date 2024-01-15 16:51 + * @LastEditTime 2024-01-15 16:51 + * @Description + */ + +@Mapper +public interface PrControllerMapper extends BaseMapper<PrController> { + int deleteByPrimaryKey(Long id); + + int insert(PrController record); + + int insertSelective(PrController record); + + PrController selectByPrimaryKey(Long id); + + int updateByPrimaryKeySelective(PrController record); + + int updateByPrimaryKey(PrController record); + + /** + * 鏍规嵁鎸囧畾鑾峰彇鎺у埗鍣ㄨ褰曟暟 + * @param params + * @return + */ + Long getRecordCount(Map<?, ?> params); + + /** + * 鏍规嵁鎸囧畾鑾峰彇鎺у埗鍣ㄨ褰� + * @param params + * @return + */ + List<VoController> getControllers(Map<?, ?> params); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨帶鍒跺櫒鍒楄〃 + * @param rtuAddr + * @return + */ + List<Map<String, Object>> getControllersByAddr(@Param("rtuAddr") String rtuAddr); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨帶鍒跺櫒鍒楄〃 + * @param rtuAddr + * @return + */ + List<PrController> getControllersByRtuAddrAndIntakeNotNull(@Param("rtuAddr") String rtuAddr); + + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙烽�昏緫鍒犻櫎鎺у埗 + * @param controllerId + * @return + */ + Integer deleteControllerById(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨湭鍒犻櫎鐨勬帶鍒跺櫒鏁伴噺 + * @param controllerId + * @return + */ + Integer getRecordCountOfController(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栧凡缁戝畾璁板綍鏁� + * @param controllerId + * @return + */ + Integer getBindedCount(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙峰垹闄ゅ彇姘村彛缂栧彿 + * @param controllerId + * @return + */ + Integer deleteIntakeId(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鍙栨按鍙D鎴栭榾鎺у櫒鍦板潃鑾峰彇闃�鎺у櫒瀵硅薄 + * @param intakeId + * @param rtuAddr + * @return + */ + PrController getRtu(@Param("intakeId") Long intakeId, @Param("rtuAddr") String rtuAddr); +} \ No newline at end of file -- Gitblit v1.8.0