package com.dy.pipIrrWechat.command;
|
|
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.p206V1_0_0.CodeV1_0_1;
|
import com.dy.common.mw.protocol.p206V1_0_0.downVos.Com97Vo;
|
import com.dy.common.mw.protocol.p206V1_0_0.downVos.Com98Vo;
|
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.command.ComSupport;
|
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.pipIrrWechat.command.dto.ValveClose;
|
import com.dy.pipIrrWechat.command.dto.ValveOpen;
|
import com.dy.pipIrrWechat.command.enums.LastOperateENUM;
|
import com.dy.pipIrrWechat.result.WechatResultCode;
|
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.format.DateTimeFormatter;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
|
/**
|
* @author ZhuBaoMin
|
* @date 2024-05-30 16:11
|
* @LastEditTime 2024-05-30 16:11
|
* @Description
|
*/
|
|
@Slf4j
|
@Tag(name = "小程序阀控器控制", description = "小程序阀控器控制")
|
@RestController
|
@RequestMapping(path="valve")
|
@RequiredArgsConstructor
|
public class ValveCtrl extends ComSupport {
|
private final CommandSv commandSv;
|
private final SeVirtualCardMapper seVirtualCardMapper;
|
private final IDLongGenerator idLongGenerator;
|
private String rtuResultSendWebUrl = "http://127.0.0.1:8087/wx/comRes/receive" ;
|
|
/**
|
* 小程序远程开阀
|
* @param valve
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "open_wx", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> 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();
|
Long operator = valve.getOperator();
|
Long comId = idLongGenerator.generate();
|
|
/**
|
* 如果农户选择了虚拟卡，则使用该虚拟卡
|
* 如果农户未选择虚拟卡，则根据取水口ID获取与之绑定的虚拟卡
|
* 如果取水口没有与之绑定的虚拟卡，则提示农户选择一张虚拟卡
|
*/
|
if(vcId == null) {
|
vcId = commandSv.getVcIdByIntakeId(intakeId);
|
if(vcId == null) {
|
return BaseResponseUtils.buildFail(WechatResultCode.PLEASE_SELECT_A_VC.getMessage());
|
}
|
}
|
|
// 获取系统参数
|
if(!setuped) {
|
setUp();
|
}
|
|
// 虚拟卡ID换虚拟卡对象
|
VoVirtualCard vc = commandSv.getVcById(vcId);
|
if(vc == null) {
|
return BaseResponseUtils.buildFail(WechatResultCode.PLEASE_SELECT_A_VC.getMessage());
|
}
|
if(vc.getInUse() == 1) {
|
return BaseResponseUtils.buildFail(WechatResultCode.IN_USE_VC_CANNOT_OPEN_VALVE.getMessage());
|
}
|
|
// 获取水价
|
Double waterPrice = commandSv.getPrice();
|
|
// 取水口ID换阀控器地址及通讯协议
|
JSONObject job_rtu = getRtu(intakeId, null);
|
if(job_rtu == null) {
|
return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_EXIST.getMessage());
|
}
|
String rtuAddr = job_rtu.getString("rtuAddr");
|
String protocol = job_rtu.getString("protocol");
|
|
// 生成订单号
|
String orderNo = generateOrderNo();
|
|
String commandCode = null;
|
if(protocol.equals("p206V202404")) {
|
// 获取功能码
|
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, rtuResultSendWebUrl, param);
|
|
// 发送命令
|
JSONObject response_SendCom= (JSONObject) JSON.toJSON(sendCom2Mw(com));
|
if(response_SendCom != null && response_SendCom.getString("code").equals("0001")) {
|
//if(1 > 0) {
|
// 请求成功
|
|
// 创建命令日志对象并添加到数据库中
|
String commandName = CodeV202404.getCodeName(commandCode);
|
RmCommandHistory rmCommandHistory = getComHistory(comId, commandCode, commandName, intakeId, rtuAddr, protocol, param, operator);
|
commandSv.insert(rmCommandHistory);
|
|
// 处理回调
|
BaseResponse response_CallBack = dealWithCallBack(comId);
|
|
// 回调失败
|
if(!response_CallBack.getCode().equals("0001")) {
|
return BaseResponseUtils.buildFail(response_CallBack.getMsg());
|
//return BaseResponseUtils.buildFail(response_CallBack.getContent().toString());
|
}
|
|
// 回调成功，再判断执行是否成功
|
JSONObject job_content = (JSONObject)JSON.toJSON(response_CallBack.getContent());
|
System.out.println(job_content);
|
JSONObject job_subData = (JSONObject) job_content.getJSONObject("subData").getJSONObject("subData");
|
System.out.println(job_subData);
|
Boolean dealResult = job_subData.getBoolean("success");
|
if(!dealResult) {
|
return BaseResponseUtils.buildFail(response_CallBack.getContent().toString());
|
}
|
|
/**
|
* 执行成功
|
* 更改虚拟卡状态：是否使用中、最后操作、最后操作时间
|
*/
|
//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(protocol.equals("p206V1_0_1")) {
|
// 获取功能码
|
commandCode = CodeV1_0_1.cd_97;
|
|
// 创建视图
|
Com97Vo param = new Com97Vo() ;
|
param.icCardNo = vc.getVcNum();
|
param.moneyRemain = vc.getMoney();
|
param.waterPrice = waterPrice;
|
param.orderNo = orderNo;
|
|
// 构造命令
|
Command com = command(comId, commandCode, rtuAddr, protocol, rtuResultSendWebUrl, param);
|
|
// 发送命令
|
JSONObject response_SendCom= (JSONObject) JSON.toJSON(sendCom2Mw(com));
|
if(response_SendCom != null && response_SendCom.getString("code").equals("0001")) {
|
//if(1 > 0) {
|
// 请求成功
|
|
// 创建命令日志对象并添加到数据库中
|
String commandName = CodeV1_0_1.getCodeName(commandCode);
|
RmCommandHistory rmCommandHistory = getComHistory(comId, commandCode, commandName, intakeId, rtuAddr, protocol, param, operator);
|
commandSv.insert(rmCommandHistory);
|
|
// 处理回调
|
BaseResponse response_CallBack = dealWithCallBack(comId);
|
|
//回调异常
|
if(!response_CallBack.getCode().equals("0001")) {
|
// 命令日志执行结果改为失败
|
rmCommandHistory = new RmCommandHistory();
|
rmCommandHistory.setId(comId);
|
rmCommandHistory.setResult((byte)0);
|
commandSv.update(rmCommandHistory);
|
return BaseResponseUtils.buildFail(response_CallBack.getContent().toString());
|
}
|
|
// 回调超时
|
if(response_CallBack.getContent().toString().equals(WechatResultCode.GET_RESULT_IN_ONE_MINUTE.getMessage())) {
|
/**
|
* 回调超时，暂时认为执行失败
|
* 命令置为失败
|
* 虚拟卡依旧保持使用中的状态
|
*/
|
|
rmCommandHistory = new RmCommandHistory();
|
rmCommandHistory.setId(comId);
|
rmCommandHistory.setResult((byte)0);
|
commandSv.update(rmCommandHistory);
|
|
//SeVirtualCard virtualCard = new SeVirtualCard();
|
//virtualCard.setId(vcId);
|
//virtualCard.setInUse((byte) 1);
|
//virtualCard.setLastOperate(LastOperateENUM.OPEN_VALVE.getCode());
|
//virtualCard.setLastOperateTime(new Date());
|
//seVirtualCardMapper.updateByPrimaryKeySelective(virtualCard);
|
return BaseResponseUtils.buildFail(WechatResultCode.GET_RESULT_IN_ONE_MINUTE.getMessage());
|
}
|
|
// 回调成功，再判断执行是否成功
|
JSONObject job_content = (JSONObject)JSON.toJSON(response_CallBack.getContent());
|
System.out.println(job_content);
|
JSONObject job_subData = (JSONObject) job_content.getJSONObject("subData").getJSONObject("subData");
|
System.out.println(job_subData);
|
Boolean dealResult = job_subData.getBoolean("success");
|
if(!dealResult) {
|
return BaseResponseUtils.buildFail(response_CallBack.getContent().toString());
|
}
|
|
/**
|
* 执行成功
|
* 更改虚拟卡状态：是否使用中、最后操作、最后操作时间
|
*/
|
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 {
|
return BaseResponseUtils.buildFail("系统暂不支持该协议");
|
}
|
}
|
|
/**
|
* 小程序远程关阀
|
* @param valve
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "close_wx", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> close(@RequestBody @Valid ValveClose valve, BindingResult bindingResult) {
|
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyMMddHHmmss");
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
String rtuAddr = valve.getRtuAddr();
|
String vcNum = valve.getVcNum();
|
String orderNo = valve.getOrderNo();
|
Long operator = valve.getOperator();
|
Long comId = idLongGenerator.generate();
|
|
// 获取系统参数
|
if(!setuped) {
|
setUp();
|
}
|
|
// 阀控器地址换取水口ID和通讯协议
|
JSONObject job_rtu = getRtu(null, rtuAddr);
|
if(job_rtu == null) {
|
return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_EXIST.getMessage());
|
}
|
Long intakeId = job_rtu.getLong("intakeId");
|
String protocol = job_rtu.getString("protocol");
|
|
String commandCode = null;
|
if(protocol.equals("p206V202404")) {
|
// 获取功能码
|
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, rtuResultSendWebUrl, param);
|
|
// 发送命令
|
JSONObject response_SendCom= (JSONObject) JSON.toJSON(sendCom2Mw(com));
|
if(response_SendCom != null && response_SendCom.getString("code").equals("0001")) {
|
// 请求成功
|
|
// 创建命令日志对象并添加到数据库中
|
String commandName = CodeV202404.getCodeName(commandCode);
|
RmCommandHistory rmCommandHistory = getComHistory(comId, commandCode, commandName, intakeId, rtuAddr, protocol, param, operator);
|
commandSv.insert(rmCommandHistory);
|
|
// 处理回调
|
BaseResponse response_CallBack = dealWithCallBack(comId);
|
|
// 回调失败
|
if(!response_CallBack.getCode().equals("0001")) {
|
return BaseResponseUtils.buildFail(response_CallBack.getMsg());
|
//return BaseResponseUtils.buildErrorMsg(WechatResultCode.GET_RESULT_ERROR.getMessage());
|
}
|
|
// 回调成功，再判断执行是否成功
|
JSONObject job_content = (JSONObject)JSON.toJSON(response_CallBack.getContent());
|
System.out.println(job_content);
|
JSONObject job_subData = (JSONObject) job_content.getJSONObject("subData").getJSONObject("subData");
|
System.out.println(job_subData);
|
Boolean dealResult = job_subData.getBoolean("success");
|
if(!dealResult) {
|
return BaseResponseUtils.buildFail(response_CallBack.getContent().toString());
|
}
|
|
/**
|
* 执行成功
|
* 更改虚拟卡状态：是否使用中、最后操作、最后操作时间
|
*/
|
//Long vcId = seVirtualCardMapper.getVcIdByNum(vcNum);
|
//SeVirtualCard virtualCard = new SeVirtualCard();
|
//virtualCard.setId(vcId);
|
//virtualCard.setInUse((byte) 0);
|
//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(protocol.equals("p206V1_0_1")) {
|
// 获取功能码
|
commandCode = CodeV1_0_1.cd_98;
|
|
// 创建视图
|
Com98Vo param = new Com98Vo() ;
|
param.icCardNo = vcNum;
|
param.orderNo = orderNo;
|
|
// 构造命令
|
Command com = command(comId, commandCode, rtuAddr, protocol, rtuResultSendWebUrl, param);
|
|
// 发送命令
|
JSONObject response_SendCom= (JSONObject) JSON.toJSON(sendCom2Mw(com));
|
if(response_SendCom != null && response_SendCom.getString("code").equals("0001")) {
|
//if(1 > 0) {
|
// 请求成功
|
|
// 创建命令日志对象并添加到数据库中
|
String commandName = CodeV1_0_1.getCodeName(commandCode);
|
RmCommandHistory rmCommandHistory = getComHistory(comId, commandCode, commandName, intakeId, rtuAddr, protocol, param, operator);
|
commandSv.insert(rmCommandHistory);
|
|
// 处理回调
|
BaseResponse response_CallBack = dealWithCallBack(comId);
|
|
// 回调异常
|
if(!response_CallBack.getCode().equals("0001")) {
|
// 命令日志执行结果改为失败
|
rmCommandHistory = new RmCommandHistory();
|
rmCommandHistory.setId(comId);
|
rmCommandHistory.setResult((byte)0);
|
commandSv.update(rmCommandHistory);
|
return BaseResponseUtils.buildFail(response_CallBack.getContent().toString());
|
}
|
|
// 回调超时
|
if(response_CallBack.getContent().toString().equals(WechatResultCode.GET_RESULT_IN_ONE_MINUTE.getMessage())) {
|
/**
|
* 回调超时，暂时认为执行失败
|
* 命令置为失败
|
* 虚拟卡依旧保持使用中的状态
|
*/
|
|
rmCommandHistory = new RmCommandHistory();
|
rmCommandHistory.setId(comId);
|
rmCommandHistory.setResult((byte)0);
|
commandSv.update(rmCommandHistory);
|
|
//Long vcId = seVirtualCardMapper.getVcIdByNum(vcNum);
|
//SeVirtualCard virtualCard = new SeVirtualCard();
|
//virtualCard.setId(vcId);
|
//virtualCard.setInUse((byte) 0);
|
//virtualCard.setLastOperate(LastOperateENUM.OPEN_VALVE.getCode());
|
//virtualCard.setLastOperateTime(new Date());
|
//seVirtualCardMapper.updateByPrimaryKeySelective(virtualCard);
|
return BaseResponseUtils.buildFail(WechatResultCode.GET_RESULT_IN_ONE_MINUTE.getMessage());
|
}
|
|
// 回调成功，再判断执行是否成功
|
JSONObject job_content = (JSONObject)JSON.toJSON(response_CallBack.getContent());
|
System.out.println(job_content);
|
JSONObject job_subData = (JSONObject) job_content.getJSONObject("subData").getJSONObject("subData");
|
System.out.println(job_subData);
|
Boolean dealResult = job_subData.getBoolean("success");
|
if(!dealResult) {
|
return BaseResponseUtils.buildFail(response_CallBack.getContent().toString());
|
}
|
|
/**
|
* 执行成功
|
* 更改虚拟卡状态：是否使用中、最后操作、最后操作时间
|
*/
|
Long vcId = seVirtualCardMapper.getVcIdByNum(vcNum);
|
SeVirtualCard virtualCard = new SeVirtualCard();
|
virtualCard.setId(vcId);
|
virtualCard.setInUse((byte) 0);
|
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 {
|
return BaseResponseUtils.buildFail("系统暂不支持该协议");
|
}
|
}
|
|
/**
|
* 根据操作员ID获取未关阀记录
|
* @param operator
|
* @return
|
*/
|
@GetMapping(path = "/get")
|
@SsoAop()
|
public BaseResponse<List<VoUnclosedValve>> getUnclosedValves(@RequestParam Long operator){
|
try {
|
List<VoUnclosedValve> res = commandSv.getUnclosedValves(operator);
|
return BaseResponseUtils.buildSuccess(res);
|
} catch (Exception e) {
|
log.error("获取未关阀记录异常", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
}
|
