From 0087f04462b9521f9098fa54438904e1ccffd04c Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期六, 19 十月 2024 11:52:31 +0800 Subject: [PATCH] 2024-10-19 朱宝民 优化获取未关阀记录接口,增加强制隐藏未关阀记录接口 --- pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/command/CommandSv.java | 113 ++++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 92 insertions(+), 21 deletions(-) diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/command/CommandSv.java b/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/command/CommandSv.java index beb671d..289bacb 100644 --- a/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/command/CommandSv.java +++ b/pipIrr-platform/pipIrr-web/pipIrr-web-wechat/src/main/java/com/dy/pipIrrWechat/command/CommandSv.java @@ -3,6 +3,7 @@ import com.alibaba.fastjson2.JSON; import com.alibaba.fastjson2.JSONArray; import com.alibaba.fastjson2.JSONObject; +import com.dy.common.multiDataSource.DataSourceContext; import com.dy.common.mw.protocol.Command; import com.dy.common.webUtil.QueryResultVo; import com.dy.pipIrrGlobal.command.ComSupport; @@ -10,13 +11,20 @@ import com.dy.pipIrrGlobal.daoPr.PrIntakeVcMapper; import com.dy.pipIrrGlobal.daoPr.PrWaterPriceMapper; import com.dy.pipIrrGlobal.daoRm.RmCommandHistoryMapper; +import com.dy.pipIrrGlobal.daoRm.RmIrrigateProfileMapper; +import com.dy.pipIrrGlobal.daoRm.RmOpenCloseValveLastMapper; +import com.dy.pipIrrGlobal.daoSe.SeClientCardMapper; import com.dy.pipIrrGlobal.daoSe.SeVirtualCardMapper; import com.dy.pipIrrGlobal.pojoRm.RmCommandHistory; +import com.dy.pipIrrGlobal.pojoSe.SeClientCard; import com.dy.pipIrrGlobal.voPr.VoOnLineIntake; +import com.dy.pipIrrGlobal.voRm.VoIrrigaterProfile; import com.dy.pipIrrGlobal.voRm.VoUnclosedValve; import com.dy.pipIrrGlobal.voSe.VoVirtualCard; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.core.env.Environment; import org.springframework.stereotype.Service; import java.util.ArrayList; @@ -40,7 +48,30 @@ private final PrIntakeMapper prIntakeMapper; private final PrWaterPriceMapper prWaterPriceMapper; private final PrIntakeVcMapper prIntakeVcMapper; + private final SeClientCardMapper seClientCardMapper; + private final RmIrrigateProfileMapper rmIrrigateProfileMapper; + private RmOpenCloseValveLastMapper rmOpenCloseValveLastMapper; + /** + * pro_mw锛氬睘鎬� + * tag浠庢帶鍒跺櫒涓幏鍙� + * key_mw锛歶rl鐨刱ey + */ + private Environment env = null; + private String pro_mw = "mw"; + private String key_mw = "comSendUrl"; + @Autowired + public CommandSv(RmCommandHistoryMapper rmCommandHistoryMapper,RmOpenCloseValveLastMapper rmOpenCloseValveLastMapper, SeVirtualCardMapper seVirtualCardMapper, PrIntakeMapper prIntakeMapper, PrWaterPriceMapper prWaterPriceMapper, PrIntakeVcMapper prIntakeVcMapper, SeClientCardMapper seClientCardMapper, RmIrrigateProfileMapper rmIrrigateProfileMapper, Environment env) { + this.rmCommandHistoryMapper = rmCommandHistoryMapper; + this.rmOpenCloseValveLastMapper = rmOpenCloseValveLastMapper; + this.seVirtualCardMapper = seVirtualCardMapper; + this.prIntakeMapper = prIntakeMapper; + this.prWaterPriceMapper = prWaterPriceMapper; + this.prIntakeVcMapper = prIntakeVcMapper; + this.seClientCardMapper = seClientCardMapper; + this.rmIrrigateProfileMapper = rmIrrigateProfileMapper; + this.env = env; + } /** * 铏氭嫙鍗D鎹㈣櫄鎷熷崱瀵硅薄 * @param vcId @@ -59,25 +90,6 @@ } /** - * 娣诲姞鍛戒护鏃ュ織 - * @param po 鍛戒护鏃ュ織瀵硅薄 - * @return 瀛楃涓茬被鍨嬬殑涓婚敭 - */ - public Long insert(RmCommandHistory po) { - rmCommandHistoryMapper.insert(po); - return po.getId(); - } - - /** - * 淇敼鍛戒护鏃ュ織淇℃伅 - * @param po 鍛戒护鏃ュ織瀵硅薄 - * @return 褰卞搷璁板綍鏁伴噺 - */ - public Integer update(RmCommandHistory po) { - return rmCommandHistoryMapper.updateByPrimaryKeySelective(po); - } - - /** * 鏍规嵁鎿嶄綔鍛業D鑾峰彇鏈叧闃�璁板綍锛堝寘鍚湪绾挎儏鍐碉級 * @param operator * @return @@ -87,9 +99,9 @@ com.id = Command.defaultId; com.code = "LCD0001"; com.type = "innerCommand"; + comSendUrl = env.getProperty(pro_mw + "." + DataSourceContext.get() + "." + key_mw); JSONObject response = (JSONObject) JSON.toJSON(sendCom2Mw(com)); - if(response != null && response.getString("code").equals("0001")) { JSONObject attachment = response.getJSONObject("content").getJSONObject("attachment").getJSONObject("onLineMap"); HashMap<String, Boolean> onLineMap = JSON.parseObject(attachment.toJSONString(), HashMap.class); @@ -102,7 +114,7 @@ jsonArray.add(jsonObject); } - System.out.println(jsonArray); + System.out.println(jsonArray.toJSONString()); List<VoUnclosedValve> res = rmCommandHistoryMapper.getUnclosedValves(jsonArray.toJSONString(), operator); if(res != null) { return res; @@ -116,6 +128,16 @@ } /** + * 涓烘寚瀹氾紙闃�鎺у櫒鍦板潃銆佹按鍗$紪鍙枫�佹棤鍏抽榾璁板綍锛夊紑鍏抽榾鏈�鏂拌褰曟坊鍔犲叧闃�鏃堕棿锛屼娇涔嬩笉鍦ㄦ湭鍏抽榾璁板綍涓樉绀� + * @param rtuAddr + * @param icCardNo + * @return + */ + public Integer addClostTime(String rtuAddr, String icCardNo) { + return rmOpenCloseValveLastMapper.addCloseTime(rtuAddr, icCardNo); + } + + /** * 鏍规嵁鍙栨按鍙D鑾峰彇涓庝箣缁戝畾铏氭嫙鍗D * @param intakeId * @return @@ -123,4 +145,53 @@ public Long getVcIdByIntakeId(Long intakeId) { return prIntakeVcMapper.getVcIdByIntakeId(intakeId); } + + /** + * 鏍规嵁姘村崱缂栧彿鑾峰彇姘村崱瀵硅薄锛岃繙绋嬪厖鍊间娇鐢� + * @param cardId + * @return + */ + public SeClientCard geClientCardByCardId(Long cardId) { + return seClientCardMapper.selectByPrimaryKey(cardId); + } + + /** + * 娣诲姞鍛戒护鏃ュ織 + * @param po 鍛戒护鏃ュ織瀵硅薄 + * @return 瀛楃涓茬被鍨嬬殑涓婚敭 + */ + public Long insert(RmCommandHistory po) { + rmCommandHistoryMapper.insert(po); + return po.getComId(); + } + + /** + * 淇敼鍛戒护鏃ュ織淇℃伅 + * @param po 鍛戒护鏃ュ織瀵硅薄 + * @return 褰卞搷璁板綍鏁伴噺 + */ + public Integer update(RmCommandHistory po) { + return rmCommandHistoryMapper.updateByPrimaryKeySelective(po); + } + + /** + * 鍙栨按鍙e悕绉版崲鍙栨按鍙D锛屾壂鐮佸紑闃�浣跨敤 + * @param intakeName + * @return + */ + public Long getIntakeIdByName(String intakeName) { + return prIntakeMapper.getIntakeIdByName(intakeName); + } + + /** + * 鏍规嵁閰嶇疆绫诲瀷鑾峰彇閰嶇疆鍊� + * @param type + * @return + */ + QueryResultVo<List<VoIrrigaterProfile>> getIrrPro(Integer type) { + QueryResultVo<List<VoIrrigaterProfile>> rsVo = new QueryResultVo<>() ; + rsVo.obj = rmIrrigateProfileMapper.getIrrPro(type); + return rsVo ; + } + } -- Gitblit v1.8.0