From c081e4f2d10ded85f3b76745f4e642531159c77d Mon Sep 17 00:00:00 2001 From: Administrator <zhubaomin> Date: 星期二, 06 八月 2024 11:12:07 +0800 Subject: [PATCH] 2024-08-06 朱宝民 获取指定时间段内开阀次数低于指定值的农户 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseValveLastMapper.java | 78 ++++++++++++++++++++++++++++++++++++--- 1 files changed, 72 insertions(+), 6 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseValveLastMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseValveLastMapper.java index b750ae4..0a8722f 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseValveLastMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseValveLastMapper.java @@ -2,34 +2,100 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseValveLast; +import com.dy.pipIrrGlobal.voRm.VoOpenCloseValve; import org.apache.ibatis.annotations.Mapper; +import java.util.List; +import java.util.Map; + /** - * @author ZhuBaoMin - * @date 2024-06-17 11:28 - * @LastEditTime 2024-06-17 11:28 + * @Author: liurunyu + * @Date: 2024/7/1 15:29 * @Description */ - @Mapper public interface RmOpenCloseValveLastMapper extends BaseMapper<RmOpenCloseValveLast> { + /** + * delete by primary key + * + * @param id primaryKey + * @return deleteCount + */ int deleteByPrimaryKey(Long id); + /** + * insert record to table + * + * @param record the record + * @return insert count + */ int insert(RmOpenCloseValveLast record); + /** + * insert record to table selective + * + * @param record the record + * @return insert count + */ int insertSelective(RmOpenCloseValveLast record); + /** + * select by primary key + * + * @param id primary key + * @return object by primary key + */ RmOpenCloseValveLast selectByPrimaryKey(Long id); + /** + * update record selective + * + * @param record the updated record + * @return update count + */ int updateByPrimaryKeySelective(RmOpenCloseValveLast record); + /** + * update record + * + * @param record the updated record + * @return update count + */ int updateByPrimaryKey(RmOpenCloseValveLast record); /** * select by rtuAddr * - * @param rtuAddr rtuAddr + * @param intakeId intakeId * @return object by rtuAddr */ - //List<RmOpenCloseValveLast> selectByRtuAddr(String rtuAddr); + List<RmOpenCloseValveLast> selectByIntakeId(Long intakeId); + + /** + * 鏍规嵁鎸囧畾鏉′欢鑾峰彇寮�鍏抽榾鎶ユ渶鏂拌褰曟暟閲� + * @param params + * @return + */ + Long getOpenCloseValveReportsCount_last(Map<?, ?> params); + + /** + * 鏍规嵁鎸囧畾鏉′欢鑾峰彇寮�鍏抽榾鎶ユ渶鏂拌褰� + * @param params + * @return + */ + List<VoOpenCloseValve> getOpenCloseValveReports_last(Map<?, ?> params); + + /** + * 鏍规嵁寮�闃�绫诲瀷鑾峰彇鎿嶄綔娆℃暟 + * @param params + * @return + */ + Integer getCountByOpenType(Map<?, ?> params); + + /** + * 鏍规嵁鍏抽榾绫诲瀷鑾峰彇鎿嶄綔娆℃暟 + * @param params + * @return + */ + Integer getCountByCloseType(Map<?, ?> params); } \ No newline at end of file -- Gitblit v1.8.0