package com.dy.pipIrrIrrigate.irrigatePlan; import com.alibaba.fastjson2.JSON; import com.alibaba.fastjson2.JSONObject; import com.dy.common.multiDataSource.DataSourceContext; import com.dy.common.mw.protocol.Command; import com.dy.common.mw.protocol.CommandType; import com.dy.common.webUtil.BaseResponse; import com.dy.common.webUtil.BaseResponseUtils; import com.dy.common.webUtil.QueryConditionVo; import com.dy.common.webUtil.QueryResultVo; import com.dy.pipIrrGlobal.daoIr.*; import com.dy.pipIrrGlobal.daoRm.RmCommandHistoryMapper; import com.dy.pipIrrGlobal.pojoIr.IrIrrigatePlan; import com.dy.pipIrrGlobal.pojoIr.IrIrrigateSchedule; import com.dy.pipIrrGlobal.pojoIr.IrPlanOperate; import com.dy.pipIrrGlobal.pojoIr.IrPlanSchedule; import com.dy.pipIrrGlobal.rtuMw.CodeLocal; import com.dy.pipIrrGlobal.voIr.*; import com.dy.pipIrrGlobal.voRm.VoIntakeVc; import com.dy.pipIrrIrrigate.command.CommandSv; import com.dy.pipIrrIrrigate.command.dto.AutomaticClose; import com.dy.pipIrrIrrigate.command.dto.ValveClose; import com.dy.pipIrrIrrigate.irrigatePlan.dto.IrrigatePlan; import com.dy.pipIrrIrrigate.irrigatePlan.dto.IrrigateSchedule; import com.dy.pipIrrIrrigate.irrigatePlan.dto.PlanSimple; import com.dy.pipIrrIrrigate.irrigatePlan.enums.OperateTypeENUM; import lombok.extern.slf4j.Slf4j; import org.apache.dubbo.common.utils.PojoUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.core.env.Environment; import org.springframework.http.HttpEntity; import org.springframework.http.HttpHeaders; import org.springframework.http.HttpMethod; import org.springframework.http.ResponseEntity; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.web.client.RestTemplate; import org.springframework.web.util.UriComponentsBuilder; import java.time.LocalDate; import java.time.LocalDateTime; import java.time.ZoneId; import java.time.format.DateTimeFormatter; import java.util.*; /** * @author ZhuBaoMin * @date 2025-06-30 14:58 * @LastEditTime 2025-06-30 14:58 * @Description */ @Slf4j @Service public class IrrigatePlanSv { @Autowired private IrIrrigatePlanMapper irrigatePlanMapper; @Autowired private IrIrrigateScheduleMapper irIrrigateScheduleMapper; @Autowired private IrPlanScheduleMapper irPlanScheduleMapper; @Autowired private IrPlanOperateMapper irPlanOperateMapper; @Autowired private IrGroupIntakeMapper irGroupIntakeMapper; @Autowired private CommandSv commandSv; @Autowired private IrIntakeOperateMapper irIntakeOperateMapper; @Autowired private RmCommandHistoryMapper rmdCommandHistoryMapper; @Autowired private IrIrrigateGroupMapper irIrrigateGroupMapper; protected String comSendUrl; private String key_mw = "comSendUrl"; @Value("${irr.plan.delay:5}") private Integer irrPlanDelay;//轮灌中计划开阀的延迟时长 private static final Integer irrPlanDelayDefault = 5;//轮灌中计划开阀的默认延迟时长 @Value("${irr.plan.preOpeningTime:10}") private Integer preOpeningTime; @Value("${irr.plan.planTerminateLimitMinutes:5}") private Integer planTerminateLimitMinutes; // 计划终止后限制发布新计划的时间间隔(分钟) /** * 添加灌溉计划 * * @param po * @return */ @Transactional(rollbackFor = Exception.class) public Long addIrrigatePlan(IrIrrigatePlan po) { irrigatePlanMapper.insert(po); return po.getId(); } /** * 添加灌溉次序记录 * * @param po * @return */ @Transactional(rollbackFor = Exception.class) public Long addIrrigateSchedule(IrIrrigateSchedule po) { irIrrigateScheduleMapper.insert(po); return po.getId(); } /** * 添加计划次序关联记录 * * @param po * @return */ @Transactional(rollbackFor = Exception.class) public Long addPlanSchedule(IrPlanSchedule po) { irPlanScheduleMapper.insert(po); return po.getId(); } /** * 添加灌溉计划操作记录 * * @param po * @return */ @Transactional(rollbackFor = Exception.class) public Long addPlanOperate(IrPlanOperate po) { irPlanOperateMapper.insert(po); return po.getId(); } /** * 创建灌溉计划 * 1. 添加灌溉计划 * 2. 添加灌溉次序 * 3. 添加灌溉计划操作记录 * @param planAndSchedule * @return */ public Map createPlan(IrrigatePlan planAndSchedule) { Map map = new HashMap<>(); map.put("success", false); Long projectId = planAndSchedule.getProjectId(); Long operatorId = planAndSchedule.getOperatorId(); Byte startupMode = planAndSchedule.getStartupMode(); Date planStartTime = planAndSchedule.getPlanStartTime();; Date planStopTime = null; Integer duration = 0; for(IrrigateSchedule schedule : planAndSchedule.getSchedules()){ duration = duration + schedule.getDuration(); } if(startupMode == 2){ if(planStartTime == null) { map.put("msg", "自动启动模式必须指定计划启动时间"); map.put("content", null); return map; } LocalDateTime startTime = planStartTime.toInstant().atZone(ZoneId.systemDefault()) .toLocalDateTime(); LocalDateTime currentTime = LocalDateTime.now(); currentTime = currentTime.plusHours(8); if(!startTime.isAfter(currentTime)) { map.put("msg", "启动时间不能在8小时之内"); map.put("content", null); return map; } } IrIrrigatePlan plan = new IrIrrigatePlan(); plan.setProjectId(projectId); plan.setPlanName(planAndSchedule.getPlanName()); plan.setStartupMode(startupMode); plan.setPlanStartTime(planStartTime); plan.setDuration(duration); plan.setPlanState((byte)1); plan.setExecutingState((byte)1); plan.setDeleted(0L); Long planId = addIrrigatePlan(plan); if(planId == null) { map.put("msg", "创建灌溉计划失败"); map.put("content", null); return map; } // 添加灌溉次序及计划次序关联表 Integer sort = 1; for(IrrigateSchedule schedule : planAndSchedule.getSchedules()){ IrIrrigateSchedule po = new IrIrrigateSchedule(); po.setGroupId(schedule.getGroupId()); po.setDuration(schedule.getDuration()); po.setCurrentState((byte)1); Long scheduleId = addIrrigateSchedule(po); if(scheduleId == null) { map.put("msg", "创建灌溉次序失败"); map.put("content", null); return map; } IrPlanSchedule planSchedule = new IrPlanSchedule(); planSchedule.setPlanId(planId); planSchedule.setScheduleId(scheduleId); planSchedule.setSort(sort++); Long planScheduleId = addPlanSchedule(planSchedule); if(planScheduleId == null) { map.put("msg", "创建灌溉次序失败"); map.put("content", null); return map; } } // 添加灌溉计划操作记录 IrPlanOperate planOperate = new IrPlanOperate(); planOperate.setPlanId(planId); planOperate.setOperator(operatorId); planOperate.setOperateType(OperateTypeENUM.CREATE.getCode()); planOperate.setOperateTime(new Date()); if(addPlanOperate(planOperate) == 0){ map.put("msg", "添加灌溉计划操作记录失败"); map.put("content", null); return map; } map.put("success", true); map.put("msg", "灌溉计划创建成功"); map.put("content", null); return map; } /** * 删除灌溉计划 * * @param planSimple * @return */ @Transactional(rollbackFor = Exception.class) public Map deletePlan(PlanSimple planSimple) { Long planId = planSimple.getPlanId(); Long operatorId = planSimple.getOperatorId(); Integer planState = irrigatePlanMapper.getPlanState(planId); if (planState == null) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "灌溉计划不存在"); map.put("content", null); return map; } if (planState != 1) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "灌溉计划非草稿状态,不允许删除"); map.put("content", null); return map; } try { irrigatePlanMapper.deleteByPrimaryKey(planId); // 添加灌溉计划操作记录 IrPlanOperate planOperate = new IrPlanOperate(); planOperate.setPlanId(planId); planOperate.setOperator(operatorId); planOperate.setOperateType(OperateTypeENUM.DELETE.getCode()); planOperate.setOperateTime(new Date()); addPlanOperate(planOperate); Map map = new HashMap<>(); map.put("success", true); map.put("msg", "灌溉项目删除成功"); map.put("content", null); return map; } catch (Exception e) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "灌溉项目删除失败"); map.put("content", null); return map; } } /** * 根据计划ID获取灌溉次序记录 * * @param planId * @return */ public List getSchedulesByPlanId(Long planId) { return irIrrigateScheduleMapper.getSchedulesByPlanId(planId); } /** * 根据灌溉次序ID更新次序开始时间 * * @param scheduleId * @param startTime * @return */ @Transactional(rollbackFor = Exception.class) public Integer updateScheduleStartTime(Long scheduleId, Date startTime) { return irIrrigateScheduleMapper.updateScheduleStartTime(scheduleId, startTime); } @Transactional(rollbackFor = Exception.class) Integer updatePlanTimes(Date planStartTime, Date planEndTime, Long planId) { return irrigatePlanMapper.updatePlanTimes(planStartTime, planEndTime, planId); } /** * 根据组ID获取取水口ID集合 * * @param groupId * @return */ public List getIntakeIdsByGroupId(Long groupId) { return irGroupIntakeMapper.getIntakeIdsByGroupId(groupId); } /** * 发布灌溉计划 * * @param planSimple * @return */ @Transactional(rollbackFor = Exception.class) public Map publishPlan(PlanSimple planSimple) { Long planId = planSimple.getPlanId(); Long operatorId = planSimple.getOperatorId(); Byte operateType = 1; // 检查当前项目是否存在未完成的灌溉计划 if (irrigatePlanMapper.hasPlan_CurrentProject(planId) > 0) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "当前项目存在未完成的灌溉计划"); map.put("content", null); return map; } // 检查其他项目中是否存在未完成的灌溉计划 if (irrigatePlanMapper.hasPlan_OtherProject(planId) > 0) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "待发布计划的轮灌组在其他项目的灌溉计划中,且该计划尚未完成"); map.put("content", null); return map; } // 检查5分钟内是否有终止的计划,且轮灌组有重叠 Long lastTerminatedPlanId = irPlanOperateMapper.getLastTerminatedPlanId(planTerminateLimitMinutes); if (lastTerminatedPlanId != null) { // 检查当前计划与最近终止计划的轮灌组是否有重叠 if (irrigatePlanMapper.hasPlanOverlapWithTerminated(planId, lastTerminatedPlanId) > 0) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "上一个计划终止后" + planTerminateLimitMinutes + "分钟内不能发布新计划"); map.put("content", null); return map; } } /** * 获取灌溉计划信息 * 更新灌溉计划起止时间及计划状态 */ VoPlanSimple plan = irrigatePlanMapper.getPlanSimple(planId); if (plan == null) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "您要发布的计划不存在,或该计划已发布"); map.put("content", null); return map; } Byte startupMode = plan.getStartupMode(); Integer duration = plan.getDuration(); Date planStartTime = plan.getPlanStartTime(); Date planStopTime = null; if (startupMode == 1) { planStartTime = new Date(); } LocalDateTime startTime = planStartTime.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime(); if (startupMode == 1) { if (irrPlanDelay == null || irrPlanDelay <= 0) { irrPlanDelay = irrPlanDelayDefault; } startTime = startTime.plusMinutes(irrPlanDelay); } planStartTime = Date.from(startTime.atZone(ZoneId.systemDefault()).toInstant()); // 更新每个灌溉次序的开始时间并计算最后一组关阀时间 List schedules = getSchedulesByPlanId(planId); Date scheduleStartTime = null; LocalDateTime lastScheduleEndTime = null; Integer sort = 0; // 第一次遍历:更新每个灌溉次序的开始时间 for (VoIrrigateSchedule schedule : schedules) { if (scheduleStartTime == null) { scheduleStartTime = planStartTime; } this.updateScheduleStartTime(schedule.getScheduleId(), scheduleStartTime); // 计算当前次序的结束时间 LocalDateTime currentScheduleStartTime = scheduleStartTime.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime(); LocalDateTime currentScheduleEndTime = currentScheduleStartTime.plusMinutes(schedule.getDuration()); // 更新最后一组的结束时间 lastScheduleEndTime = currentScheduleEndTime; // 计算下一组的开始时间 LocalDateTime LocalscheduleStartTime = scheduleStartTime.toInstant().atZone(ZoneId.systemDefault()).toLocalDateTime(); LocalscheduleStartTime = LocalscheduleStartTime.plusMinutes(schedule.getDuration()); LocalscheduleStartTime = LocalscheduleStartTime.minusMinutes(preOpeningTime); scheduleStartTime = Date.from(LocalscheduleStartTime.atZone(ZoneId.systemDefault()).toInstant()); // 确保下一组的开始时间不早于计划开始时间 if (scheduleStartTime.before(planStartTime)) { scheduleStartTime = planStartTime; } } // 根据最后一组关阀时间设置计划结束时间 if (lastScheduleEndTime != null) { planStopTime = Date.from(lastScheduleEndTime.atZone(ZoneId.systemDefault()).toInstant()); } else { // 如果没有灌溉次序,则使用原来的计算方式 LocalDateTime stopTime = startTime.plusMinutes(duration); planStopTime = Date.from(stopTime.atZone(ZoneId.systemDefault()).toInstant()); } // 根据计划ID更新计划信息(起止时间、计划状态) if (this.updatePlanTimes(planStartTime, planStopTime, planId) == 0) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "计划信息更新失败"); map.put("content", null); return map; } // 添加灌溉计划操作记录 IrPlanOperate planOperate = new IrPlanOperate(); planOperate.setPlanId(planId); planOperate.setOperator(operatorId); planOperate.setOperateType(OperateTypeENUM.PUBLISH.getCode()); planOperate.setOperateTime(new Date()); if (addPlanOperate(planOperate) == 0) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "添加灌溉计划操作记录失败"); map.put("content", null); return map; } schedules = getSchedulesByPlanId(planId); for (VoIrrigateSchedule schedule : schedules) { Long groupId = schedule.getGroupId(); List intakeIds = getIntakeIdsByGroupId(groupId); if(intakeIds == null || intakeIds.size() <= 0) { Map map = new HashMap<>(); map.put("success", false); map.put("msg", "当前轮灌组内没有有效的取水口"); map.put("content", null); return map; } for (Long intakeId : intakeIds) { if (schedule.getDuration() > 0) { // 今发布灌溉时长大于0的 AutomaticClose automaticClose = new AutomaticClose(); automaticClose.setIntakeId(intakeId); automaticClose.setPlannedOpenTime(schedule.getStartTime()); automaticClose.setMinutes(schedule.getDuration()); automaticClose.setOperator(operatorId); automaticClose.setOpenType(Byte.valueOf("1")); commandSv.planedOpenTimedClose(automaticClose, planId, operateType, schedule.getStartTime(), schedule.getDuration()); } } } Map map = new HashMap<>(); map.put("success", true); map.put("msg", "灌溉计划发布成功"); map.put("content", null); return map; } /** * 根据计划ID获取待终止计划的结束时间:未删除、未终止、已发布、当前时间小于计划结束时间 * * @param planId * @return */ public Date getToTerminatePlan(Long planId) { return irrigatePlanMapper.getToTerminatePlan(planId); } /** * 根据计划ID获取待终止的取水口列表(开阀成功的) * * @param planId * @return */ public List getToTerminateIntakes(Long planId) { return irIntakeOperateMapper.getToTerminateIntakes(planId); } /** * 根据命令日志ID获取取水口及虚拟卡信息,终止灌溉计划时使用,用来执行远程关阀 * * @param commandId * @return */ public VoIntakeVc getValveOpen(Long commandId) { return rmdCommandHistoryMapper.getValveOpen(commandId); } /** * 修改灌溉计划 * * @param po * @return */ @Transactional(rollbackFor = Exception.class) public Integer updatePlan(IrIrrigatePlan po) { return irrigatePlanMapper.updateByPrimaryKeySelective(po); } /** * 根据计划ID终止灌溉次序,将灌溉次序的当前状态改为已终止 * * @param planId * @return */ @Transactional(rollbackFor = Exception.class) public Integer terminateSchedule(Long planId) { return irIrrigateScheduleMapper.terminateSchedule(planId); } /** * 终止灌溉计划 * @param planSimple * @return */ @Transactional(rollbackFor = Exception.class) public Map terminatePlan(PlanSimple planSimple) { Map map = new HashMap<>(); map.put("success", false); map.put("content", null); Long planId = planSimple.getPlanId(); Long operatorId = planSimple.getOperatorId(); // 生成终止开始时间、终止灌溉时长 DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); String terminateStartTimeStr = LocalDate.now().getYear() + "-01-01 00:00:00"; Date terminateStartTime = Date.from(LocalDateTime.parse(terminateStartTimeStr, formatter).atZone(ZoneId.systemDefault()).toInstant()); Integer terminateDuration = 0; // 判断该计划是否可执行终止操作:未删除、未终止、已发布、当前时间小于计划结束时间 Date planStartTime = getToTerminatePlan(planId); if(planStartTime == null){ map.put("msg", "该计划不存在或不支持终止操作"); return map; } List toTerminateIntakes = getToTerminateIntakes(planId); if(toTerminateIntakes != null && toTerminateIntakes.size() > 0){ for(VoToTerminateIntakes toTerminateIntake : toTerminateIntakes){ Long intakeId = toTerminateIntake.getIntakeId(); Long commandId = toTerminateIntake.getCommandId(); Date startTime = toTerminateIntake.getStartTime(); Date currentTime = new Date(); if(currentTime.before(startTime)){ // 取消(覆盖开阀计划) AutomaticClose automaticClose = new AutomaticClose(); automaticClose.setIntakeId(intakeId); automaticClose.setPlannedOpenTime(terminateStartTime); automaticClose.setMinutes(terminateDuration); automaticClose.setOperator(operatorId); automaticClose.setOpenType(Byte.valueOf("1")); commandSv.planedOpenTimedClose(automaticClose, planId, (byte)2, terminateStartTime, terminateDuration); }else { // 终止(远程关阀) VoIntakeVc intakeVc = getValveOpen(commandId); String rtuAddr = intakeVc.getRtuAddr(); String vcNum = intakeVc.getVcNum(); String orderNo = intakeVc.getOrderNo(); ValveClose valveClose = new ValveClose(); valveClose.setRtuAddr(rtuAddr); valveClose.setVcNum(vcNum); valveClose.setOrderNo(orderNo); valveClose.setOperator(operatorId); valveClose.setOpenType(Byte.valueOf("1")); commandSv.closeWx(valveClose, planId, (byte)3); } } } // 终止计划 IrIrrigatePlan iIrrigatePlan = new IrIrrigatePlan(); iIrrigatePlan.setId(planId); iIrrigatePlan.setExecutingState((byte)3); if(updatePlan(iIrrigatePlan) == 0){ map.put("msg", "终止计划失败"); return map; } // 终止灌溉次序 if(terminateSchedule(planId) == 0){ map.put("msg", "终止灌溉次序失败"); return map; } // 添加终止操作记录 IrPlanOperate planOperate = new IrPlanOperate(); planOperate.setPlanId(planId); planOperate.setOperator(operatorId); planOperate.setOperateType(OperateTypeENUM.TERMINATE.getCode()); planOperate.setOperateTime(new Date()); if(addPlanOperate(planOperate) == 0){ map.put("msg", "添加终止操作记录失败"); return map; } map.put("success", true); map.put("msg", "终止灌溉计划成功"); return map; } /** * 获取未完成的计划列表,灌溉模块计划列表页使用 * * @return */ public List getNotCompletePlans() { return irrigatePlanMapper.getNotCompletePlans(); } /** * 获取已完成的计划列表,灌溉模块计划列表页使用 * * @return */ public QueryResultVo> getCompletedPlans(QueryConditionVo queryVo) { Map params = (Map) PojoUtils.generalize(queryVo); Long itemTotal = (long) irrigatePlanMapper.getCompletedPlansCount(params); QueryResultVo> rsVo = new QueryResultVo<>(); rsVo.pageSize = queryVo.pageSize; rsVo.pageCurr = queryVo.pageCurr; rsVo.calculateAndSet(itemTotal, params); rsVo.obj = irrigatePlanMapper.getCompletedPlans(params); return rsVo; } /** * 根据计划ID获取计划发布结果 * * @param planId * @return */ public VoPlanDetails getPublishResults(Long planId) { VoPlanDetails planDetails = irrigatePlanMapper.getPlanDetails(planId); if (planDetails == null) { return null; } Integer failureCount = Optional.ofNullable(irIntakeOperateMapper.getFailureCount(planId)).orElse(0); planDetails.setFailureCount(failureCount); Date terminateTime = Optional.ofNullable(irPlanOperateMapper.getTerminateTime(planId)).orElse(null); List groupResults = irIrrigateGroupMapper.getGroupResult(planId); if (groupResults == null || groupResults.size() == 0) { return null; } for (VoGroupResult groupResult : groupResults) { List intakeResults = irIntakeOperateMapper.getIntakeResult(planId, groupResult.getGroupId()); if (intakeResults != null) { groupResult.setPublishResult(intakeResults); } } planDetails.setGroups(groupResults); return planDetails; } /** * 根据计划ID获取计划终止操作结果 * * @param planId * @return */ public VoPlanDetails getTerminateResults(Long planId) { // 获取计划终止时间 Date terminateTime = Optional.ofNullable(irPlanOperateMapper.getTerminateTime(planId)).orElse(null); VoPlanDetails planDetails = irrigatePlanMapper.getPlanDetails_terminate(planId, terminateTime); if (planDetails == null) { return null; } Integer failureCount = Optional.ofNullable(irIntakeOperateMapper.getFailureCount(planId)).orElse(0); planDetails.setFailureCount(failureCount); List groupResults = irIrrigateGroupMapper.getGroupResult_terminate(planId, terminateTime); if (groupResults == null || groupResults.size() == 0) { return null; } for (VoGroupResult groupResult : groupResults) { List intakeResults = irIntakeOperateMapper.getIntakeResult(planId, groupResult.getGroupId()); if (intakeResults != null) { groupResult.setPublishResult(intakeResults); } } planDetails.setGroups(groupResults); return planDetails; } /** * 根据计划ID获取计划最新状态 * * @param planId * @return */ public Integer getPlanLatestState(Long planId) { return irrigatePlanMapper.getPlanLatestState(planId); } }