package com.dy.pipIrrRemote.valve; import com.alibaba.fastjson2.JSON; import com.alibaba.fastjson2.JSONObject; import com.dy.common.aop.SsoAop; import com.dy.common.mw.protocol.Command; import com.dy.common.mw.protocol.Data; import com.dy.common.mw.protocol.p206V202404.CodeV202404; import com.dy.common.mw.protocol.p206V202404.downVos.ComCd92_A2Vo; import com.dy.common.mw.protocol.p206V202404.downVos.ComCd93_A3Vo; import com.dy.common.util.IDLongGenerator; import com.dy.common.webUtil.BaseResponse; import com.dy.common.webUtil.BaseResponseUtils; import com.dy.pipIrrGlobal.daoPr.PrWaterPriceMapper; import com.dy.pipIrrGlobal.daoSe.SeVirtualCardMapper; import com.dy.pipIrrGlobal.pojoPr.PrController; import com.dy.pipIrrGlobal.pojoRm.RmCommandHistory; import com.dy.pipIrrGlobal.pojoSe.SeVirtualCard; import com.dy.pipIrrGlobal.voRm.VoUnclosedValve; import com.dy.pipIrrGlobal.voSe.VoVirtualCard; import com.dy.pipIrrRemote.common.ComSupport; import com.dy.pipIrrRemote.common.CommandSv; import com.dy.pipIrrRemote.common.dto.ValveClose; import com.dy.pipIrrRemote.common.dto.ValveOpen; import com.dy.pipIrrRemote.result.RemoteResultCode; import com.dy.pipIrrRemote.utils.RestTemplateUtils; import com.dy.pipIrrSell.virtualCard.enums.LastOperateENUM; import io.swagger.v3.oas.annotations.tags.Tag; import jakarta.validation.Valid; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.http.MediaType; import org.springframework.transaction.annotation.Transactional; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.*; import java.time.LocalDateTime; import java.time.format.DateTimeFormatter; import java.util.Date; import java.util.List; import java.util.Objects; import java.util.Random; /** * @author ZhuBaoMin * @date 2024-05-07 14:59 * @LastEditTime 2024-05-07 14:59 * @Description */ @Slf4j @Tag(name = "阀门管理", description = "阀门操作") @RestController @RequestMapping(path="valve") @RequiredArgsConstructor public class ValveCtrl extends ComSupport { private final RestTemplateUtils restTemplateUtils; private final CommandSv commandSv; private final SeVirtualCardMapper seVirtualCardMapper; private final PrWaterPriceMapper prWaterPriceMapper; private final IDLongGenerator idLongGenerator; /** * 远程开阀(平台、APP) * @param valve * @param bindingResult * @return */ @PostMapping(path = "open", consumes = MediaType.APPLICATION_JSON_VALUE) @Transactional(rollbackFor = Exception.class) @SsoAop() public BaseResponse open(@RequestBody @Valid ValveOpen valve, BindingResult bindingResult) { DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyMMddHHmmss"); if(bindingResult != null && bindingResult.hasErrors()){ return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); } Long intakeId = valve.getIntakeId(); Long vcId = valve.getVcId(); Integer userType = valve.getUserType(); Long operator = valve.getOperator(); Long comId = idLongGenerator.generate(); // 获取系统参数 if(!setuped) { setUp(); } // 虚拟卡ID换虚拟卡对象 VoVirtualCard vc = seVirtualCardMapper.getVcById(vcId); // 获取水价 Double waterPrice = prWaterPriceMapper.getPrice(); // 取水口ID换阀控器地址及通讯协议 PrController prController = commandSv.getControllerByIntakeId(intakeId); if(prController == null) { return BaseResponseUtils.buildError(RemoteResultCode.RTU_NOT_EXIST.getMessage()); } String rtuAddr = prController.getRtuAddr(); String protocol = prController.getProtocol(); // 生成订单号 LocalDateTime dateTime = LocalDateTime.now(); Random random = new Random(); String CHARACTERS = "0123456789"; StringBuilder sb = new StringBuilder(4); for (int i = 0; i < 4; i++) { int index = random.nextInt(CHARACTERS.length()); sb.append(CHARACTERS.charAt(index)); } String orderNo = dtf.format(dateTime) + sb.toString(); String commandCode = null; if(protocol.equals("p206V202404")) { // 获取功能码 if(userType == 1) { // 平台开阀 commandCode = CodeV202404.cd_92; }else { // APP开阀 commandCode = CodeV202404.cd_A2; } // 创建视图 ComCd92_A2Vo param = new ComCd92_A2Vo(); param.controllerType = controllerType; param.projectNo = projectNo; param.icCardNo = vc.getVcNum(); param.waterRemain = 0.0; param.moneyRemain = vc.getMoney(); param.waterPrice = waterPrice; param.elePrice = 0.0; param.orderNo = orderNo; // 构造命令 Command com = command(comId, commandCode, rtuAddr, protocol, param); // 发送命令 JSONObject response_SendCom= (JSONObject) JSON.toJSON(sendCom2Mw(com)); if(response_SendCom != null && response_SendCom.getString("code").equals("0001")) { // 请求成功 // 创建命令日志对象并添加到数据库中 RmCommandHistory rmCommandHistory = getComHistory(comId, commandCode, intakeId, rtuAddr, protocol, param, operator); commandSv.insert(rmCommandHistory); // 处理回调 BaseResponse response_CallBack = dealWithCallBack(comId); if(!response_CallBack.getCode().equals("0001")) { return BaseResponseUtils.buildError(RemoteResultCode.GET_RESULT_ERROR.getMessage()); } // 更改虚拟卡状态:是否使用中、最后操作、最后操作时间 SeVirtualCard virtualCard = new SeVirtualCard(); virtualCard.setId(vcId); virtualCard.setInUse((byte) 1); virtualCard.setLastOperate(LastOperateENUM.OPEN_VALVE.getCode()); virtualCard.setLastOperateTime(new Date()); seVirtualCardMapper.updateByPrimaryKeySelective(virtualCard); // 回调返回的内容 Data myData = (Data)response_CallBack.getContent(); return BaseResponseUtils.buildSuccess(myData) ; } else { // 请求失败 JSONObject job_param = response_SendCom.getJSONObject("content").getJSONObject("param"); return BaseResponseUtils.buildFail(job_param.getString("message")); } } else { // 获取功能码 if(userType == 1) { // 平台开阀 commandCode = "92"; }else { // APP开阀 commandCode = "97"; } // 创建视图 ComCd92_A2Vo param = new ComCd92_A2Vo(); // 创建命令日志对象并添加到数据库中 //RmCommandHistory rmCommandHistory = getComHistory(commandCode, rtuAddr, protocol, param, operator); //comId = commandSv.insert(rmCommandHistory); // 构造并发送命令 Command com = command(comId, commandCode, rtuAddr, protocol, param); sendCom2Mw(com); return BaseResponseUtils.buildSuccess(); } } /** * 远程关阀(平台、APP) * @param valve * @param bindingResult * @return */ @PostMapping(path = "close", consumes = MediaType.APPLICATION_JSON_VALUE) @Transactional(rollbackFor = Exception.class) @SsoAop() public BaseResponse close(@RequestBody @Valid ValveClose valve, BindingResult bindingResult) { DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyMMddHHmmss"); if(bindingResult != null && bindingResult.hasErrors()){ return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); } String rtuAddr = valve.getRtuAddr(); String vcNum = valve.getVcNum(); String orderNo = valve.getOrderNo(); Integer userType = valve.getUserType(); Long operator = valve.getOperator(); Long comId = idLongGenerator.generate(); // 获取系统参数 if(!setuped) { setUp(); } // 阀控器地址换取水口ID和通讯协议 PrController prController = commandSv.getControllerByRtuAddr(rtuAddr); if(prController == null) { return BaseResponseUtils.buildError(RemoteResultCode.RTU_NOT_EXIST.getMessage()); } Long intakeId = prController.getIntakeId(); String protocol = prController.getProtocol(); String commandCode = null; if(protocol.equals("p206V202404")) { // 获取功能码 if (userType == 1) { // 平台关阀 commandCode = CodeV202404.cd_93; } else { // APP关阀 commandCode = CodeV202404.cd_A3; } // 创建视图 ComCd93_A3Vo param = new ComCd93_A3Vo(); param.controllerType = controllerType; param.projectNo = projectNo; param.icCardNo = vcNum; param.orderNo = orderNo; // 构造命令 Command com = command(comId, commandCode, rtuAddr, protocol, param); // 发送命令 JSONObject response_SendCom= (JSONObject) JSON.toJSON(sendCom2Mw(com)); if(response_SendCom != null && response_SendCom.getString("code").equals("0001")) { // 请求成功 // 创建命令日志对象并添加到数据库中 RmCommandHistory rmCommandHistory = getComHistory(comId, commandCode, intakeId, rtuAddr, protocol, param, operator); commandSv.insert(rmCommandHistory); // 处理回调 BaseResponse response_CallBack = dealWithCallBack(comId); if(!response_CallBack.getCode().equals("0001")) { return BaseResponseUtils.buildError(RemoteResultCode.GET_RESULT_ERROR.getMessage()); } // 更改虚拟卡状态:是否使用中、最后操作、最后操作时间 Long vcId = seVirtualCardMapper.getVcIdByNum(vcNum); SeVirtualCard virtualCard = new SeVirtualCard(); virtualCard.setId(vcId); virtualCard.setInUse((byte) 1); virtualCard.setLastOperate(LastOperateENUM.OPEN_VALVE.getCode()); virtualCard.setLastOperateTime(new Date()); seVirtualCardMapper.updateByPrimaryKeySelective(virtualCard); // 回调返回的内容 Data myData = (Data)response_CallBack.getContent(); return BaseResponseUtils.buildSuccess(myData) ; } else { // 请求失败 JSONObject job_param = response_SendCom.getJSONObject("content").getJSONObject("param"); return BaseResponseUtils.buildFail(job_param.getString("message")); } } else { // 获取功能码 if (userType == 1) { // 平台关阀 commandCode = "93"; } else { // APP关阀 commandCode = "98"; } // 创建视图 ComCd93_A3Vo param = new ComCd93_A3Vo(); param.controllerType = controllerType; param.projectNo = projectNo; param.icCardNo = vcNum; param.orderNo = orderNo; // 创建命令日志对象并添加到数据库中 RmCommandHistory rmCommandHistory = getComHistory(comId, commandCode, intakeId, rtuAddr, protocol, param, operator); comId = commandSv.insert(rmCommandHistory); // 构造并发送命令 Command com = command(comId, commandCode, rtuAddr, protocol, param); sendCom2Mw(com); } // 处理回调 BaseResponse response = dealWithCallBack(comId); if(!response.getCode().equals("0001")) { return BaseResponseUtils.buildError(RemoteResultCode.GET_RESULT_ERROR.getMessage()); } // 更改虚拟卡状态:是否使用中、最后操作、最后操作时间 Long vcId = seVirtualCardMapper.getVcIdByNum(vcNum); SeVirtualCard virtualCard = new SeVirtualCard(); virtualCard.setId(vcId); virtualCard.setInUse((byte) 0); virtualCard.setLastOperate(LastOperateENUM.CLOSE_VALVE.getCode()); virtualCard.setLastOperateTime(new Date()); seVirtualCardMapper.updateByPrimaryKeySelective(virtualCard); Data myData = (Data)response.getContent(); return BaseResponseUtils.buildSuccess(myData) ; } /** * 根据操作员ID获取未关阀记录 * @param operator * @return */ @GetMapping(path = "/get") @SsoAop() public BaseResponse> getUnclosedValves(@RequestParam Long operator){ try { List res = commandSv.getUnclosedValves(operator); return BaseResponseUtils.buildSuccess(res); } catch (Exception e) { log.error("获取未关阀记录异常", e); return BaseResponseUtils.buildException(e.getMessage()) ; } } }