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/daoSe/SeClientMapper.java | 57 +++++++++++++++++++++++++-------------------------------- 1 files changed, 25 insertions(+), 32 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java index 44e1e11..67e5da8 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java @@ -3,8 +3,8 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoSe.SeClient; import com.dy.pipIrrGlobal.voSe.VoClient; -import com.dy.pipIrrGlobal.voSe.VoOperate; -import com.dy.pipIrrGlobal.voSe.VoStatistics; +import com.dy.pipIrrGlobal.voSe.VoClientWechat; +import com.dy.pipIrrGlobal.voSt.VoCardUsage; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -47,6 +47,13 @@ Long getAreaCodeByNum(@Param("clientNum") String clientNum); /** + * 鏍规嵁鍐滄埛缂栧彿鑾峰彇5绾ц鏀垮尯鍒掍覆areaCode锛岃ˉ鍗¤繃绋嬩腑寮�鏂板崱浣跨敤 + * @param clientId + * @return + */ + Long getAreaCodeById(@Param("clientId") Long clientId); + + /** * 鏍规嵁鍐滄埛缂栧彿鑾峰彇鍐滄埛ID * @param clientNum * @return @@ -54,11 +61,18 @@ Long getClientIdByNum(@Param("clientNum") String clientNum); /** + * 鏍规嵁鐢佃瘽鍙风爜鑾峰彇鍐滄埛ID + * @param phoneNumber + * @return + */ + Long getClientIdByPhone(String phoneNumber); + + /** * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鍐滄埛璁板綍鏁� * @param params * @return */ - Long getRecordCount(Map<?, ?> params); + List<VoClient> getRecordCount(Map<?, ?> params); /** * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鍐滄埛鏁版嵁 @@ -94,44 +108,23 @@ List<Map<String, Object>> getWaterTypes(); /** - * 鏍规嵁鎸囧畾鏉′欢鑾峰彇璐按姹囨�诲拰璐崱姹囨�� - * @param params 缁熻鏉′欢 - * @return 璐按閲戦銆佽喘鍗¢噾棰� + * 鑾峰彇鍐滄埛鍩烘湰淇℃伅锛屽皬绋嬪簭棣栭〉浣跨敤 + * @param sessionId + * @return */ - Map getSums(Map<?, ?> params); + VoClientWechat getSimpleClientInfo(@Param("sessionId") Long sessionId, @Param("openId") String openId); /** - * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鎿嶄綔璁板綍鏁� - * @param params 鏌ヨ鏉′欢 - * @return 绗﹀悎鏉′欢鐨勮褰曟暟 - */ - Long getOperateRecordCount(Map<?, ?> params); - - /** - * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鎿嶄綔璁板綍 - * @param params 鏌ヨ鏉′欢 - * @return 绗﹀悎鏉′欢鐨勪氦鏄撹褰� - */ - List<VoOperate> getOperates(Map<?, ?> params); - - /** - * 鏍规嵁鎸囧畾鏉′欢鑾峰彇浜ゆ槗绗旀暟姹囨�诲拰浜ゆ槗閲戦姹囨�� + * 鑾峰彇鎸囧畾鏃堕棿娈靛啘鎴凤細鍏呭�煎悎璁°�佹秷璐瑰悎璁°�佷綑棰� * @param params * @return */ - Map getStatisticSums(Map<?, ?> params); + Long getClientUsagesCount(Map<String, Object> params); /** - * 鏍规嵁鎸囧畾鏉′欢鑾峰彇姹囨�昏褰曟暟 + * 鑾峰彇鎸囧畾鏃堕棿娈靛啘鎴凤細鍏呭�煎悎璁°�佹秷璐瑰悎璁°�佷綑棰� * @param params * @return */ - Long getStatisticRecordCount(Map<?, ?> params); - - /** - * 鏍规嵁鎸囧畾鏉′欢鑾峰彇缁熻璁板綍 - * @param params - * @return - */ - List<VoStatistics> getStatistics(Map<?, ?> params); + List<VoCardUsage> getClientUsages(Map<String, Object> params); } \ No newline at end of file -- Gitblit v1.8.0