From b397edee2be2dfcc3f28eeac50298b4de26b1afa Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期五, 13 十二月 2024 16:53:45 +0800 Subject: [PATCH] 取水口日取水量表中,出现一些大数,明显不正确,发析系统日志,发现一些阀控器会上报一些累计流量为0的数据,且无规律,推测是其不能从水表读取到累计流量时会上报0值。如果间歇上报0值,间歇上报一些非0值,非0值减去0值,就会出现大数,一天中出现几次那么会大数进行累加,数值将更大。为此变更算法,规避这种情况,但也会丢失一些流量值。 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerTrampMapper.java | 39 +++++++++++++++++++++++++++++++++++++-- 1 files changed, 37 insertions(+), 2 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerTrampMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerTrampMapper.java index 9e86073..b27dfd9 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerTrampMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoPr/PrControllerTrampMapper.java @@ -3,15 +3,17 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoPr.PrControllerTramp; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Param; import java.util.List; +import java.util.Map; /** * @Author liurunyu * @Date 2024/1/15 15:27 * @LastEditTime 2024/1/15 15:27 * @Description - */ + */ @Mapper public interface PrControllerTrampMapper extends BaseMapper<PrControllerTramp> { /** @@ -20,6 +22,12 @@ * @return deleteCount */ int deleteByPrimaryKey(Long id); + + /** + * 娓呯┖娴佹氮鎺у埗鍣ㄨ〃 + * @return + */ + int emptyTrampController(); /** * insert record to table @@ -47,7 +55,7 @@ * @param rutAddr 鎺у埗鍣ㄥ湴鍧� * @return object by 鎺у埗鍣ㄥ湴鍧� */ - List<PrControllerTramp> selectPrControllerTrampByRtuAddr(String rutAddr); + List<PrControllerTramp> getPrControllerTrampByRtuAddr(String rutAddr); /** * update record selective @@ -62,4 +70,31 @@ * @return update count */ int updateByPrimaryKey(PrControllerTramp record); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨祦娴帶鍒跺櫒鍦板潃 + * @param controllerId 娴佹氮鎺у埗鍣ㄧ紪鍙� + * @return 璁板綍鏁伴噺 + */ + //String getTrampRtuAddr(@Param("controllerId") Long controllerId); + + /** + * 鏍规嵁鎺у埗鍣ㄧ紪鍙疯幏鍙栨祦娴帶鍒跺櫒淇℃伅 + * @param controllerId + * @return + */ + PrControllerTramp getTrampControllerInfo(@Param("controllerId") Long controllerId); + + /** + * 鏉′欢鏌ヨ娴佹氮鎺у埗鍣ㄤ俊鎭� + * @param + * @return + */ + List<PrControllerTramp> getTrampControllers(Map<?, ?> params); + /** + * 鏉′欢鏌ヨ娴佹氮鎺у埗鍣ㄦ暟閲� + * @param + * @return recordCount + */ + Long getTrampControllersCount(Map<?, ?> params); } \ No newline at end of file -- Gitblit v1.8.0