package com.dy.pipIrrWechat.command; 
 | 
  
 | 
import com.alibaba.fastjson2.JSONObject; 
 | 
import com.dy.common.multiDataSource.DataSourceContext; 
 | 
import com.dy.common.mw.protocol.p206V1_0_0.CodeV1_0_1; 
 | 
import com.dy.common.mw.protocol.p206V1_0_0.downVos.*; 
 | 
import com.dy.common.mw.protocol.p206V202404.CodeV202404; 
 | 
import com.dy.common.mw.protocol.p206V202404.downVos.ComCd15Vo; 
 | 
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.common.webUtil.QueryResultVo; 
 | 
import com.dy.pipIrrGlobal.command.ComSupport; 
 | 
import com.dy.pipIrrGlobal.command.dto.Param; 
 | 
import com.dy.pipIrrGlobal.daoSe.SeVirtualCardMapper; 
 | 
import com.dy.pipIrrGlobal.pojoSe.SeClientCard; 
 | 
import com.dy.pipIrrGlobal.voRm.VoIrrigaterProfile; 
 | 
import com.dy.pipIrrGlobal.voRm.VoUnclosedValve; 
 | 
import com.dy.pipIrrGlobal.voSe.VoVirtualCard; 
 | 
import com.dy.pipIrrWechat.command.dto.AutomaticClose; 
 | 
import com.dy.pipIrrWechat.command.dto.Recharge; 
 | 
import com.dy.pipIrrWechat.command.dto.ValveClose; 
 | 
import com.dy.pipIrrWechat.command.dto.ValveOpen; 
 | 
import com.dy.pipIrrWechat.result.WechatResultCode; 
 | 
import io.swagger.v3.oas.annotations.tags.Tag; 
 | 
import jakarta.validation.Valid; 
 | 
import lombok.extern.slf4j.Slf4j; 
 | 
import org.apache.commons.lang3.RandomStringUtils; 
 | 
import org.springframework.beans.factory.annotation.Autowired; 
 | 
import org.springframework.beans.factory.annotation.Value; 
 | 
import org.springframework.core.env.Environment; 
 | 
import org.springframework.http.MediaType; 
 | 
import org.springframework.transaction.annotation.Transactional; 
 | 
import org.springframework.validation.BindingResult; 
 | 
import org.springframework.web.bind.annotation.*; 
 | 
  
 | 
import java.util.Date; 
 | 
import java.util.List; 
 | 
import java.util.Objects; 
 | 
import java.util.Optional; 
 | 
  
 | 
/** 
 | 
 * @author ZhuBaoMin 
 | 
 * @date 2024-05-30 16:11 
 | 
 * @LastEditTime 2024-05-30 16:11 
 | 
 * @Description 
 | 
 */ 
 | 
  
 | 
@Slf4j 
 | 
@Tag(name = "小程序阀控器控制", description = "小程序阀控器控制") 
 | 
@RestController 
 | 
@RequestMapping(path = "valve") 
 | 
public class ValveCtrl extends ComSupport { 
 | 
    private final CommandSv commandSv; 
 | 
    private final SeVirtualCardMapper seVirtualCardMapper; 
 | 
    private final IDLongGenerator idLongGenerator; 
 | 
  
 | 
    @Value("${mw.rtuCallbackUrl_wx}") 
 | 
    private String rtuCallbackUrl_wx; 
 | 
  
 | 
    /** 
 | 
     * pro_mw:属性 
 | 
     * tag从控制器中获取 
 | 
     * key_mw:url的key 
 | 
     */ 
 | 
    private Environment env = null; 
 | 
    private String pro_mw = "mw"; 
 | 
    private String key_mw = "comSendUrl"; 
 | 
  
 | 
    @Autowired 
 | 
    public ValveCtrl(CommandSv commandSv, SeVirtualCardMapper seVirtualCardMapper, IDLongGenerator idLongGenerator, Environment env) { 
 | 
        this.commandSv = commandSv; 
 | 
        this.seVirtualCardMapper = seVirtualCardMapper; 
 | 
        this.idLongGenerator = idLongGenerator; 
 | 
        this.env = env; 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 小程序远程开阀 
 | 
     * @param valve 
 | 
     * @param bindingResult 
 | 
     * @return 
 | 
     */ 
 | 
    @PostMapping(path = "open_wx", consumes = MediaType.APPLICATION_JSON_VALUE) 
 | 
    //@Transactional(rollbackFor = Exception.class) 
 | 
    public BaseResponse<Boolean> open(@RequestBody @Valid ValveOpen valve, BindingResult bindingResult) { 
 | 
        if (bindingResult != null && bindingResult.hasErrors()) { 
 | 
            return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); 
 | 
        } 
 | 
  
 | 
        Long intakeId = valve.getIntakeId(); 
 | 
        String intakeName = valve.getIntakeName(); 
 | 
        Long vcId = valve.getVcId(); 
 | 
        Boolean forceOpen = valve.getForceOpen(); 
 | 
        Long operator = valve.getOperator(); 
 | 
        Long comId = idLongGenerator.generate(); 
 | 
  
 | 
        if(intakeId == null && intakeName == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_INTAKE.getMessage()); 
 | 
        } 
 | 
  
 | 
        // intakeName换intakeId 
 | 
        if(intakeId == null) { 
 | 
            intakeId = commandSv.getIntakeIdByName(intakeName); 
 | 
            if(intakeId == null) { 
 | 
                return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_INTAKE.getMessage()); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        /** 
 | 
         * 如果农户选择了虚拟卡,则使用该虚拟卡 
 | 
         * 如果农户未选择虚拟卡,则根据取水口ID获取与之绑定的虚拟卡 
 | 
         * 如果取水口没有与之绑定的虚拟卡,则提示农户选择一张虚拟卡 
 | 
         */ 
 | 
        if (vcId == null) { 
 | 
            vcId = commandSv.getVcIdByIntakeId(intakeId); 
 | 
            if (vcId == null) { 
 | 
                return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        // 虚拟卡ID换虚拟卡对象 
 | 
        VoVirtualCard vc = commandSv.getVcById(vcId); 
 | 
        if (vc == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
        } 
 | 
  
 | 
        // 虚拟卡状态为使用中,且不是强制开阀时提示 
 | 
        if (vc.getInUse() && !forceOpen) { 
 | 
            return BaseResponseUtils.buildCodeMsg(WechatResultCode.IN_USE_VC_CANNOT_OPEN_VALVE.getCode(), WechatResultCode.IN_USE_VC_CANNOT_OPEN_VALVE.getMessage()); 
 | 
        } 
 | 
  
 | 
        // 获取水价 
 | 
        Double waterPrice = commandSv.getPrice(); 
 | 
        if(waterPrice == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_WATER_PRICE.getMessage()); 
 | 
        } 
 | 
  
 | 
        // 取水口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 orgTag = job_rtu.getString("orgTag"); 
 | 
        //if(orgTag == null) { 
 | 
        //    return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_SET_DATA_SOURCE.getMessage()); 
 | 
        //} 
 | 
        //comSendUrl = env.getProperty(pro_mw + "." + orgTag + "." + key_mw); 
 | 
        comSendUrl = env.getProperty(pro_mw + "." + DataSourceContext.get() + "." + key_mw); 
 | 
  
 | 
        // 生成订单号 
 | 
        String orderNo = generateOrderNo(); 
 | 
        if(orderNo == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_ORDER_NUMBER.getMessage()); 
 | 
        } 
 | 
  
 | 
        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().toString(); 
 | 
            param.waterRemain = 0.0; 
 | 
            param.moneyRemain = vc.getMoney(); 
 | 
            param.waterPrice = waterPrice; 
 | 
            param.elePrice = 0.0; 
 | 
            param.orderNo = orderNo; 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)1); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV202404.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
  
 | 
        } else if (protocol.equals("p206V1_0_1")) { 
 | 
            // 获取功能码 
 | 
            commandCode = CodeV1_0_1.cd_97; 
 | 
  
 | 
            // 创建视图 
 | 
            Com97Vo param = new Com97Vo(); 
 | 
            param.icCardNo = vc.getVcNum().toString(); 
 | 
            param.moneyRemain = vc.getMoney(); 
 | 
            param.waterPrice = waterPrice; 
 | 
            param.orderNo = orderNo; 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)1); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV1_0_1.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else { 
 | 
            return BaseResponseUtils.buildErrorMsg("系统暂不支持该协议"); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 小程序远程关阀 
 | 
     * 
 | 
     * @param valve 
 | 
     * @param bindingResult 
 | 
     * @return 
 | 
     */ 
 | 
    @PostMapping(path = "close_wx", consumes = MediaType.APPLICATION_JSON_VALUE) 
 | 
    //@Transactional(rollbackFor = Exception.class) 
 | 
    public BaseResponse<Boolean> close(@RequestBody @Valid ValveClose valve, BindingResult bindingResult) { 
 | 
        if (bindingResult != null && bindingResult.hasErrors()) { 
 | 
            return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); 
 | 
        } 
 | 
  
 | 
        String rtuAddr = valve.getRtuAddr(); 
 | 
        String vcNum = valve.getVcNum(); 
 | 
        Long vcId = Optional.ofNullable(seVirtualCardMapper.getVcIdByNum(vcNum)).orElse(0L); 
 | 
        String orderNo = valve.getOrderNo(); 
 | 
        Long operator = valve.getOperator(); 
 | 
        Long comId = idLongGenerator.generate(); 
 | 
  
 | 
        // 阀控器地址换取水口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 orgTag = job_rtu.getString("orgTag"); 
 | 
        //if(orgTag == null) { 
 | 
        //    return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_SET_DATA_SOURCE.getMessage()); 
 | 
        //} 
 | 
        //comSendUrl = env.getProperty(pro_mw + "." + orgTag + "." + key_mw); 
 | 
        comSendUrl = env.getProperty(pro_mw + "." + DataSourceContext.get() + "." + key_mw); 
 | 
  
 | 
        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; 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)2); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV202404.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else if (protocol.equals("p206V1_0_1")) { 
 | 
            // 获取功能码 
 | 
            commandCode = CodeV1_0_1.cd_98; 
 | 
  
 | 
            // 创建视图 
 | 
            Com98Vo param = new Com98Vo(); 
 | 
            param.icCardNo = vcNum; 
 | 
            param.orderNo = orderNo; 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)2); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV1_0_1.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else { 
 | 
            return BaseResponseUtils.buildErrorMsg("系统暂不支持该协议"); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 定时关阀 
 | 
     * @param automaticClose 
 | 
     * @param bindingResult 
 | 
     * @return 
 | 
     */ 
 | 
    @PostMapping(path = "timed_close", consumes = MediaType.APPLICATION_JSON_VALUE) 
 | 
    @Transactional(rollbackFor = Exception.class) 
 | 
    public BaseResponse<Boolean> timedClose(@RequestBody @Valid AutomaticClose automaticClose, BindingResult bindingResult) { 
 | 
        if(bindingResult != null && bindingResult.hasErrors()){ 
 | 
            return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); 
 | 
        } 
 | 
  
 | 
        Long intakeId = automaticClose.getIntakeId(); 
 | 
        Long vcId = automaticClose.getVcId(); 
 | 
        Integer minutes = automaticClose.getMinutes(); 
 | 
        Long operator = automaticClose.getOperator(); 
 | 
        Long comId = idLongGenerator.generate(); 
 | 
  
 | 
        /** 
 | 
         * 如果农户选择了虚拟卡,则使用该虚拟卡 
 | 
         * 如果农户未选择虚拟卡,则根据取水口ID获取与之绑定的虚拟卡 
 | 
         * 如果取水口没有与之绑定的虚拟卡,则提示农户选择一张虚拟卡 
 | 
         */ 
 | 
        if(vcId == null) { 
 | 
            vcId = commandSv.getVcIdByIntakeId(intakeId); 
 | 
            if(vcId == null) { 
 | 
                return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        // 虚拟卡ID换虚拟卡对象 
 | 
        VoVirtualCard vc = commandSv.getVcById(vcId); 
 | 
        if(vc == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
        } 
 | 
        String vcNum = vc.getVcNum().toString(); 
 | 
        Double moneyRemain = vc.getMoney(); 
 | 
  
 | 
        // 获取水价 
 | 
        Double waterPrice = commandSv.getPrice(); 
 | 
        if(waterPrice == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_WATER_PRICE.getMessage()); 
 | 
        } 
 | 
  
 | 
        // 取水口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 orgTag = job_rtu.getString("orgTag"); 
 | 
        //if(orgTag == null) { 
 | 
        //    return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_SET_DATA_SOURCE.getMessage()); 
 | 
        //} 
 | 
        //comSendUrl = env.getProperty(pro_mw + "." + orgTag + "." + key_mw); 
 | 
        comSendUrl = env.getProperty(pro_mw + "." + DataSourceContext.get() + "." + key_mw); 
 | 
  
 | 
        // 生成订单号 
 | 
        String orderNo = generateOrderNo(); 
 | 
        if(orderNo == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_ORDER_NUMBER.getMessage()); 
 | 
        } 
 | 
  
 | 
        String commandCode = null; 
 | 
        if(protocol.equals("p206V202404")) { 
 | 
            return BaseResponseUtils.buildSuccess(); 
 | 
        } else if(protocol.equals("p206V1_0_1")) { 
 | 
            // 获取功能码 
 | 
            commandCode = CodeV1_0_1.cd_99; 
 | 
  
 | 
            // 创建视图 
 | 
            Com99Vo param = new Com99Vo(); 
 | 
            param.setIcCardNo(vcNum); 
 | 
            param.setMoneyRemain(moneyRemain); 
 | 
            param.setWaterPrice(waterPrice); 
 | 
            param.setMinutes(minutes); 
 | 
            param.setOrderNo(orderNo); 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)2); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV1_0_1.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else { 
 | 
            return BaseResponseUtils.buildErrorMsg("系统暂不支持该协议"); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 定量关阀 
 | 
     * @param automaticClose 
 | 
     * @param bindingResult 
 | 
     * @return 
 | 
     */ 
 | 
    @PostMapping(path = "quantify_close", consumes = MediaType.APPLICATION_JSON_VALUE) 
 | 
    @Transactional(rollbackFor = Exception.class) 
 | 
    public BaseResponse<Boolean> quantifyClose(@RequestBody @Valid AutomaticClose automaticClose, BindingResult bindingResult) { 
 | 
        if(bindingResult != null && bindingResult.hasErrors()){ 
 | 
            return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); 
 | 
        } 
 | 
  
 | 
        Long intakeId = automaticClose.getIntakeId(); 
 | 
        Long vcId = automaticClose.getVcId(); 
 | 
        Integer waterAmount = automaticClose.getWaterAmount(); 
 | 
        Long operator = automaticClose.getOperator(); 
 | 
        Long comId = idLongGenerator.generate(); 
 | 
  
 | 
        /** 
 | 
         * 如果农户选择了虚拟卡,则使用该虚拟卡 
 | 
         * 如果农户未选择虚拟卡,则根据取水口ID获取与之绑定的虚拟卡 
 | 
         * 如果取水口没有与之绑定的虚拟卡,则提示农户选择一张虚拟卡 
 | 
         */ 
 | 
        if(vcId == null) { 
 | 
            vcId = commandSv.getVcIdByIntakeId(intakeId); 
 | 
            if(vcId == null) { 
 | 
                return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        // 虚拟卡ID换虚拟卡对象 
 | 
        VoVirtualCard vc = commandSv.getVcById(vcId); 
 | 
        if(vc == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
        } 
 | 
        String vcNum = vc.getVcNum().toString(); 
 | 
        Double moneyRemain = vc.getMoney(); 
 | 
  
 | 
        // 获取水价 
 | 
        Double waterPrice = commandSv.getPrice(); 
 | 
        if(waterPrice == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_WATER_PRICE.getMessage()); 
 | 
        } 
 | 
  
 | 
        // 取水口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 orgTag = job_rtu.getString("orgTag"); 
 | 
        //if(orgTag == null) { 
 | 
        //    return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_SET_DATA_SOURCE.getMessage()); 
 | 
        //} 
 | 
        //comSendUrl = env.getProperty(pro_mw + "." + orgTag + "." + key_mw); 
 | 
        comSendUrl = env.getProperty(pro_mw + "." + DataSourceContext.get() + "." + key_mw); 
 | 
  
 | 
        // 生成订单号 
 | 
        String orderNo = generateOrderNo(); 
 | 
        if(orderNo == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_ORDER_NUMBER.getMessage()); 
 | 
        } 
 | 
  
 | 
        String commandCode = null; 
 | 
        if(protocol.equals("p206V202404")) { 
 | 
            return BaseResponseUtils.buildSuccess(); 
 | 
        } else if(protocol.equals("p206V1_0_1")) { 
 | 
            // 获取功能码 
 | 
            commandCode = CodeV1_0_1.cd_A0; 
 | 
  
 | 
            // 创建视图 
 | 
            ComA0Vo param = new ComA0Vo(); 
 | 
            param.setIcCardNo(vcNum); 
 | 
            param.setMoneyRemain(moneyRemain); 
 | 
            param.setWaterPrice(waterPrice); 
 | 
            param.setWaterAmount(waterAmount); 
 | 
            param.setOrderNo(orderNo); 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)2); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV1_0_1.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else { 
 | 
            return BaseResponseUtils.buildErrorMsg("系统暂不支持该协议"); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 计划开阀定时关阀 
 | 
     * @param automaticClose 
 | 
     * @param bindingResult 
 | 
     * @return 
 | 
     */ 
 | 
    @PostMapping(path = "planed_open_timed_close", consumes = MediaType.APPLICATION_JSON_VALUE) 
 | 
    @Transactional(rollbackFor = Exception.class) 
 | 
    public BaseResponse<Boolean> planedOpenTimedClose(@RequestBody @Valid AutomaticClose automaticClose, BindingResult bindingResult) { 
 | 
        if(bindingResult != null && bindingResult.hasErrors()){ 
 | 
            return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); 
 | 
        } 
 | 
  
 | 
        Long intakeId = automaticClose.getIntakeId(); 
 | 
        Long vcId = automaticClose.getVcId(); 
 | 
        Date plannedOpenTime = automaticClose.getPlannedOpenTime(); 
 | 
        Integer minutes = automaticClose.getMinutes(); 
 | 
        Long operator = automaticClose.getOperator(); 
 | 
        Long comId = idLongGenerator.generate(); 
 | 
  
 | 
        Integer year = Integer.parseInt(String.format("%tY", plannedOpenTime)); 
 | 
        Integer month = Integer.parseInt(String.format("%tm", plannedOpenTime)); 
 | 
        Integer day = Integer.parseInt(String.format("%td", plannedOpenTime)); 
 | 
        Integer hour = Integer.parseInt(String.format("%tH", plannedOpenTime)); 
 | 
        Integer minute = Integer.parseInt(String.format("%tM", plannedOpenTime)); 
 | 
  
 | 
        /** 
 | 
         * 如果农户选择了虚拟卡,则使用该虚拟卡 
 | 
         * 如果农户未选择虚拟卡,则根据取水口ID获取与之绑定的虚拟卡 
 | 
         * 如果取水口没有与之绑定的虚拟卡,则提示农户选择一张虚拟卡 
 | 
         */ 
 | 
        if(vcId == null) { 
 | 
            vcId = commandSv.getVcIdByIntakeId(intakeId); 
 | 
            if(vcId == null) { 
 | 
                return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        // 虚拟卡ID换虚拟卡对象 
 | 
        VoVirtualCard vc = commandSv.getVcById(vcId); 
 | 
        if(vc == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
        } 
 | 
        String vcNum = vc.getVcNum().toString(); 
 | 
        Double moneyRemain = vc.getMoney(); 
 | 
  
 | 
        // 获取水价 
 | 
        Double waterPrice = commandSv.getPrice(); 
 | 
        if(waterPrice == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_WATER_PRICE.getMessage()); 
 | 
        } 
 | 
  
 | 
        // 取水口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 orgTag = job_rtu.getString("orgTag"); 
 | 
        //if(orgTag == null) { 
 | 
        //    return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_SET_DATA_SOURCE.getMessage()); 
 | 
        //} 
 | 
        //comSendUrl = env.getProperty(pro_mw + "." + orgTag + "." + key_mw); 
 | 
        comSendUrl = env.getProperty(pro_mw + "." + DataSourceContext.get() + "." + key_mw); 
 | 
  
 | 
        // 生成订单号 
 | 
        String orderNo = generateOrderNo(); 
 | 
        if(orderNo == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_ORDER_NUMBER.getMessage()); 
 | 
        } 
 | 
  
 | 
        String commandCode = null; 
 | 
        if(protocol.equals("p206V202404")) { 
 | 
            return BaseResponseUtils.buildSuccess(); 
 | 
        } else if(protocol.equals("p206V1_0_1")) { 
 | 
            // 获取功能码 
 | 
            commandCode = CodeV1_0_1.cd_A1; 
 | 
  
 | 
            // 创建视图 
 | 
            ComA1Vo param = new ComA1Vo(); 
 | 
            param.setIcCardNo(vcNum); 
 | 
            param.setMoneyRemain(moneyRemain); 
 | 
            param.setWaterPrice(waterPrice); 
 | 
            param.setMinutes(minutes); 
 | 
            param.setYear(year); 
 | 
            param.setMonth(month); 
 | 
            param.setDay(day); 
 | 
            param.setHour(hour); 
 | 
            param.setMinute(minute); 
 | 
            param.setOrderNo(orderNo); 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)2); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV1_0_1.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else { 
 | 
            return BaseResponseUtils.buildErrorMsg("系统暂不支持该协议"); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 计划开阀定量关阀 
 | 
     * @param automaticClose 
 | 
     * @param bindingResult 
 | 
     * @return 
 | 
     */ 
 | 
    @PostMapping(path = "planed_open_quantify_close", consumes = MediaType.APPLICATION_JSON_VALUE) 
 | 
    @Transactional(rollbackFor = Exception.class) 
 | 
    public BaseResponse<Boolean> planedOpenQuantifyClose(@RequestBody @Valid AutomaticClose automaticClose, BindingResult bindingResult) { 
 | 
        if(bindingResult != null && bindingResult.hasErrors()){ 
 | 
            return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); 
 | 
        } 
 | 
  
 | 
        Long intakeId = automaticClose.getIntakeId(); 
 | 
        Long vcId = automaticClose.getVcId(); 
 | 
        Date plannedOpenTime = automaticClose.getPlannedOpenTime(); 
 | 
        Integer waterAmount = automaticClose.getWaterAmount(); 
 | 
        Long operator = automaticClose.getOperator(); 
 | 
        Long comId = idLongGenerator.generate(); 
 | 
  
 | 
        Integer year = Integer.parseInt(String.format("%tY", plannedOpenTime)); 
 | 
        Integer month = Integer.parseInt(String.format("%tm", plannedOpenTime)); 
 | 
        Integer day = Integer.parseInt(String.format("%td", plannedOpenTime)); 
 | 
        Integer hour = Integer.parseInt(String.format("%tH", plannedOpenTime)); 
 | 
        Integer minute = Integer.parseInt(String.format("%tM", plannedOpenTime)); 
 | 
  
 | 
        /** 
 | 
         * 如果农户选择了虚拟卡,则使用该虚拟卡 
 | 
         * 如果农户未选择虚拟卡,则根据取水口ID获取与之绑定的虚拟卡 
 | 
         * 如果取水口没有与之绑定的虚拟卡,则提示农户选择一张虚拟卡 
 | 
         */ 
 | 
        if(vcId == null) { 
 | 
            vcId = commandSv.getVcIdByIntakeId(intakeId); 
 | 
            if(vcId == null) { 
 | 
                return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
            } 
 | 
        } 
 | 
  
 | 
        // 虚拟卡ID换虚拟卡对象 
 | 
        VoVirtualCard vc = commandSv.getVcById(vcId); 
 | 
        if(vc == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.PLEASE_SELECT_A_VC.getMessage()); 
 | 
        } 
 | 
        String vcNum = vc.getVcNum().toString(); 
 | 
        Double moneyRemain = vc.getMoney(); 
 | 
  
 | 
        // 获取水价 
 | 
        Double waterPrice = commandSv.getPrice(); 
 | 
        if(waterPrice == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_WATER_PRICE.getMessage()); 
 | 
        } 
 | 
  
 | 
        // 取水口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 orgTag = job_rtu.getString("orgTag"); 
 | 
        //if(orgTag == null) { 
 | 
        //    return BaseResponseUtils.buildErrorMsg(WechatResultCode.RTU_NOT_SET_DATA_SOURCE.getMessage()); 
 | 
        //} 
 | 
        //comSendUrl = env.getProperty(pro_mw + "." + orgTag + "." + key_mw); 
 | 
        comSendUrl = env.getProperty(pro_mw + "." + DataSourceContext.get() + "." + key_mw); 
 | 
  
 | 
        // 生成订单号 
 | 
        String orderNo = generateOrderNo(); 
 | 
        if(orderNo == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.NO_ORDER_NUMBER.getMessage()); 
 | 
        } 
 | 
  
 | 
        String commandCode = null; 
 | 
        if(protocol.equals("p206V202404")) { 
 | 
            return BaseResponseUtils.buildSuccess(); 
 | 
        } else if(protocol.equals("p206V1_0_1")) { 
 | 
            // 获取功能码 
 | 
            commandCode = CodeV1_0_1.cd_A2; 
 | 
  
 | 
            // 创建视图 
 | 
            ComA2Vo param = new ComA2Vo(); 
 | 
            param.setIcCardNo(vcNum); 
 | 
            param.setMoneyRemain(moneyRemain); 
 | 
            param.setWaterPrice(waterPrice); 
 | 
            param.setWaterAmount(waterAmount); 
 | 
            param.setYear(year); 
 | 
            param.setMonth(month); 
 | 
            param.setDay(day); 
 | 
            param.setHour(hour); 
 | 
            param.setMinute(minute); 
 | 
            param.setOrderNo(orderNo); 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setComType((byte)2); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV1_0_1.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setVcId(vcId); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else { 
 | 
            return BaseResponseUtils.buildErrorMsg("系统暂不支持该协议"); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 根据操作员ID获取未关阀记录 
 | 
     * 
 | 
     * @param operator 
 | 
     * @return 
 | 
     */ 
 | 
    @GetMapping(path = "/get") 
 | 
    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()); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 小程序远程充值 
 | 
     * @param po 
 | 
     * @param bindingResult 
 | 
     * @return 
 | 
     */ 
 | 
    @PostMapping(path = "recharge", consumes = MediaType.APPLICATION_JSON_VALUE) 
 | 
    @Transactional(rollbackFor = Exception.class) 
 | 
    public BaseResponse<Boolean> recharge(@RequestBody @Valid Recharge po, BindingResult bindingResult) { 
 | 
        if(bindingResult != null && bindingResult.hasErrors()){ 
 | 
            return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage()); 
 | 
        } 
 | 
  
 | 
        Long intakeId = po.getIntakeId(); 
 | 
        Long cardId = po.getCardId(); 
 | 
        Double chargeMoney = po.getChargeMoney(); 
 | 
        Double chargeWater = po.getChargeWater(); 
 | 
        Long operator = po.getOperator(); 
 | 
        String flowNo = RandomStringUtils.randomNumeric(12); // 生成12位随机数 
 | 
        Long comId = idLongGenerator.generate(); 
 | 
  
 | 
        // 取水口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"); 
 | 
  
 | 
        // 水卡ID换水卡地址及水卡编号 
 | 
        SeClientCard seClientCard = commandSv.geClientCardByCardId(cardId); 
 | 
        if(seClientCard == null) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.CLIENT_CARD_NOT_EXIST.getMessage()); 
 | 
        } 
 | 
        String icCardAddr = seClientCard.getCardaddr(); 
 | 
        String icCardNo = seClientCard.getCardnum(); 
 | 
  
 | 
        String commandCode = null; 
 | 
        if(protocol.equals("p206V202404")) { 
 | 
            // 获取功能码 
 | 
            commandCode = CodeV202404.cd_15; 
 | 
  
 | 
            // 创建视图 
 | 
            ComCd15Vo param = new ComCd15Vo(); 
 | 
            param.controllerType = controllerType; 
 | 
            param.projectNo = projectNo; 
 | 
            param.icCardAddr = icCardAddr; 
 | 
            param.icCardNo = icCardNo; 
 | 
            param.chargeMoney = chargeMoney; 
 | 
            param.chargeWater = chargeWater; 
 | 
            param.flowNo = flowNo; 
 | 
  
 | 
            /** 
 | 
             * 构造命令、发送命令并处理请求结果及执行结果 
 | 
             * 1 准备参数 
 | 
             * 2 调用公共方法 
 | 
             */ 
 | 
            Param myParam = new Param(); 
 | 
            myParam.setComId(comId); 
 | 
            myParam.setCommandCode(commandCode); 
 | 
            myParam.setCommandName(CodeV202404.getCodeName(commandCode)); 
 | 
            myParam.setIntakeId(intakeId); 
 | 
            myParam.setRtuAddr(rtuAddr); 
 | 
            myParam.setProtocol(protocol); 
 | 
            myParam.setParam(param); 
 | 
            myParam.setRtuResultSendWebUrl(rtuCallbackUrl_wx); 
 | 
            myParam.setOperator(operator); 
 | 
            return dealWithCommandResult(myParam); 
 | 
        } else if(protocol.equals("p206V1_0_1")) { 
 | 
            return BaseResponseUtils.buildErrorMsg(WechatResultCode.THE_DEVICE_DOES_NOT_HAVE_THIS_FUNCTION.getMessage()); 
 | 
        } else { 
 | 
            return BaseResponseUtils.buildFail("系统暂不支持该协议"); 
 | 
        } 
 | 
    } 
 | 
  
 | 
    /** 
 | 
     * 根据配置类型获取配置值 
 | 
     * @param type 
 | 
     * @return 
 | 
     */ 
 | 
    @GetMapping(path = "/irrigate_profile") 
 | 
    public BaseResponse<QueryResultVo<List<VoIrrigaterProfile>>> getIrrPro(Integer type){ 
 | 
        try { 
 | 
            return BaseResponseUtils.buildSuccess(commandSv.getIrrPro(type)); 
 | 
        } catch (Exception e) { 
 | 
            return BaseResponseUtils.buildException(e.getMessage()) ; 
 | 
        } 
 | 
    } 
 | 
} 
 |