package com.dy.pipIrrRemote.valve; 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.webUtil.BaseResponse; import com.dy.common.webUtil.BaseResponseUtils; import com.dy.pipIrrGlobal.daoPr.PrWaterPriceMapper; import com.dy.pipIrrGlobal.daoRm.RmCommandHistoryMapper; import com.dy.pipIrrGlobal.daoSe.SeVirtualCardMapper; 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 RmCommandHistoryMapper rmCommandHistoryMapper; /** * 远程开阀(平台、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(); String comId = null; // 获取系统参数 if(!setuped) { setUp(); } // 虚拟卡ID换虚拟卡对象 VoVirtualCard vc = seVirtualCardMapper.getVcById(vcId); // 获取水价 Double waterPrice = prWaterPriceMapper.getPrice(); // 取水口ID换阀控器地址 String rtuAddr = commandSv.getRtuAddrByIntakeId(intakeId); if(rtuAddr == null || rtuAddr.length() == 0) { return BaseResponseUtils.buildError(RemoteResultCode.RTU_ADDR_CANNOT_BE_NULL.getMessage()); } // 生成订单号 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(protocolName.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; // 创建命令日志对象并添加到数据库中 RmCommandHistory rmCommandHistory = getComHistory(commandCode, rtuAddr, param, operator); comId = commandSv.insert(rmCommandHistory); // 构造并发送命令 Command com = command(comId, commandCode, rtuAddr, param); sendCom2Mw(com); } else { // 获取功能码 if(userType == 1) { // 平台开阀 commandCode = "92"; }else { // APP开阀 commandCode = "97"; } // 创建视图 ComCd92_A2Vo param = new ComCd92_A2Vo(); // 创建命令日志对象并添加到数据库中 RmCommandHistory rmCommandHistory = getComHistory(commandCode, rtuAddr, param, operator); comId = commandSv.insert(rmCommandHistory); // 构造并发送命令 Command com = command(comId, commandCode, rtuAddr, param); sendCom2Mw(com); } // 处理回调 BaseResponse response = dealWithCallBack(comId); if(!response.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.getContent(); return BaseResponseUtils.buildSuccess(myData) ; } /** * 远程关阀(平台、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(); String comId = null; // 获取系统参数 if(!setuped) { setUp(); } String commandCode = null; if(protocolName.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; // 创建命令日志对象并添加到数据库中 RmCommandHistory rmCommandHistory = getComHistory(commandCode, rtuAddr, param, operator); comId = commandSv.insert(rmCommandHistory); // 构造并发送命令 Command com = command(comId, commandCode, rtuAddr, param); sendCom2Mw(com); } 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(commandCode, rtuAddr, param, operator); comId = commandSv.insert(rmCommandHistory); // 构造并发送命令 Command com = command(comId, commandCode, rtuAddr, 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 = rmCommandHistoryMapper.getUnclosedValves(operator); return BaseResponseUtils.buildSuccess(res); } catch (Exception e) { log.error("获取未关阀记录异常", e); return BaseResponseUtils.buildException(e.getMessage()) ; } } }