From a1744d0bf7f0ad8ac861d672cffd7c710dac4e7e Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期五, 11 四月 2025 14:17:36 +0800 Subject: [PATCH] 获取未绑定轮灌组的取水口 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrIntakeMapper.java | 83 +++++++++++++++++++++++++++++++++++++++-- 1 files changed, 78 insertions(+), 5 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrIntakeMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrIntakeMapper.java index 4d85be0..35a5b41 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrIntakeMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrIntakeMapper.java @@ -2,8 +2,7 @@ import com.dy.pipIrrGlobal.pojoPr.PrIntake; -import com.dy.pipIrrGlobal.voPr.VoIntake; -import com.dy.pipIrrGlobal.voPr.VoOnLineIntake; +import com.dy.pipIrrGlobal.voPr.*; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -24,13 +23,13 @@ * @param id primary key * @return object by primary key */ - PrIntake selectByPrimaryKey(Long id); + VoAllIntake selectByPrimaryKey(Long id); /** * 寰楀埌鍏ㄩ儴瀹炰綋 * @return 鍏ㄩ儴瀹炰綋 * */ - List<PrIntake> selectAll(); + List<VoAllIntake> selectAll(); /** * 閫昏緫鍒犻櫎 @@ -94,6 +93,13 @@ /** * 鏍规嵁鏉慖d鑾峰彇鍏ㄩ儴鍦板潃 + * @param intakeId 鏉慖d + * @return intakeName 鍙栨按鍙g紪鍙� + */ + String getNameById(@Param("intakeId") Long intakeId); + + /** + * 鏍规嵁鏉慖d鑾峰彇鍏ㄩ儴鍦板潃 * @param villageId 鏉慖d * @return address 鍏ㄩ儴浜旂骇鍦板潃 */ @@ -127,9 +133,76 @@ //List<VoOnLineIntake> getOnLineIntakes(@Param("onLineMap") String onLineMap, @Param("isOnLine") Boolean isOnLine); List<VoOnLineIntake> getOnLineIntakes(Map<?, ?> params); + + /** + * 鑾峰彇鍙栨按鍙f暟閲忥紙鍦ㄧ嚎鎴栦笉鍦ㄧ嚎锛� + * @param params + * @return + */ + Long selectIntakesCountForOnLine(Map<?, ?> params); + + /** + * 鑾峰彇鍙栨按鍙e垪琛ㄥ湪绾挎垨涓嶅湪绾匡級 + * @param params + * @return + */ + List<VoOnLineIntake> selectIntakesForOnLine(Map<?, ?> params); + + + + /** + * 鏍规嵁鍙栨按鍙g紪鍙疯幏鍙栧彇姘村彛瀵硅薄 + * @param params + * @return + */ + VoOnLineIntake getIntakeByName(Map<?, ?> params); + + /** * 鏍规嵁鎿嶄綔鍛樿幏鍙栧父鐢ㄥ彇姘村彛 * @return */ - List<VoOnLineIntake> getUsedIntakes(@Param("onLineMap") String onLineMap, @Param("operator") Long operator); + List<VoOnLineIntake> getUsedIntakes(@Param("onLineMap") String onLineMap, @Param("operatorId") Long operatorId); + + /** + * 鍙栨按鍙e悕绉版崲鍙栨按鍙D锛屾壂鐮佸紑闃�浣跨敤 + * @param intakeName + * @return + */ + Long getIntakeIdByName(String intakeName); + + /** + * 鍙栨按鍙e悕绉版崲鍙栨按鍙D锛岄獙璇佹槸鍚﹂噸澶嶅悕绉颁娇鐢� + * @param intakeName + * @return + */ + List<Long> getIntakeIdsByName(String intakeName); + + /** + * 鍙栨按鍙e悕绉版崲鍙栨按鍙D锛岄獙璇佹槸鍚﹂噸澶嶅悕绉颁娇鐢� + * @param id + * @param intakeName + * @return + */ + List<Long> getIntakeIdByNameExcludeId(@Param("id")Long id, @Param("intakeName")String intakeName); + + + /** + * app淇敼鍙栨按鍙g粡绾害 + * @param record + * @return + */ + int updateByPrimaryKeySelective1(IntakeUpdateLngLat record); + + /** + * 鑾峰彇鏈粦瀹氬埌杞亴缁勭殑鍙栨按鍙e垪琛� + * @return + */ + List<VoIntakeSimple> getFreeIntakes(Map<?, ?> params); + + /** + * 鑾峰彇鏈粦瀹氳櫄鎷熷崱鐨勫彇姘村彛鍒楄〃锛岀粰鍙栨按鍙g粦铏氭嫙鍗′娇鐢� + * @return + */ + List<VoIntakeSimple> getNotLinkVcIntakes(); } -- Gitblit v1.8.0