| | |
| | | import org.jeecg.common.system.util.JwtUtil; |
| | | import org.jeecg.common.util.RedisUtil; |
| | | import org.jeecg.common.util.SpringContextUtils; |
| | | import org.jeecg.modules.dry.api.JeecgSystemApi; |
| | | import org.jeecg.modules.dry.common.CacheConstants; |
| | | import org.jeecg.modules.dry.entity.*; |
| | | import org.jeecg.modules.dry.service.*; |
| | |
| | | private IDryHerbService herbService; |
| | | |
| | | @Autowired |
| | | private IDryHerbFormulaService dryHerbFormulaService; |
| | | |
| | | @Autowired |
| | | private IDryEquipmentService equipmentService; |
| | | |
| | | @Autowired |
| | |
| | | @Autowired |
| | | private IDryProdRecordService prodRecordService; |
| | | |
| | | @Autowired |
| | | private CommonAPI commonAPI; |
| | | |
| | | private String token; |
| | | |
| | |
| | | @Transactional |
| | | public Result<?> realTimeDataHandle(RealTimeDataVo realTimeDataVo) { |
| | | TenantContext.setTenant(realTimeDataVo.getTenantid()+""); |
| | | log.info("实时数据:"+realTimeDataVo.toString()); |
| | | // log.info("实时数据:"+realTimeDataVo.toString()); |
| | | |
| | | |
| | | // 1 查询或创建工单 |
| | |
| | | // 2 更新工单实时数据 |
| | | // 2.1 将工单中的数据替换为最新数据 |
| | | realTimeDataVo.setOrderId(orderVo.getId()); |
| | | |
| | | orderVo.setInitial(realTimeDataVo.getMoisture1()); |
| | | orderVo.setDryTime(realTimeDataVo.getTime3()); |
| | | orderVo.setDelay(realTimeDataVo.getDelay()); |
| | |
| | | orderVo.getBellowsTemp().put(realTimeDataVo.getTime3(), realTimeDataVo.getTemp2()); |
| | | // 2.3 更新到redis缓存 |
| | | redisUtil.hset(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), |
| | | realTimeDataVo.getTenantid()+"_"+realTimeDataVo.getMachineid(),orderVo, 600000); |
| | | realTimeDataVo.getTenantid()+"_"+realTimeDataVo.getMachineid(),orderVo, 60*60); |
| | | return Result.ok(); |
| | | } |
| | | |
| | |
| | | } |
| | | // 3 数据库没有则新增一条数据 |
| | | } else { |
| | | |
| | | orderVo = saveNewOrder(realTimeDataVo); |
| | | } |
| | | return orderVo; |
| | |
| | | private DryOrderVo saveNewOrder(RealTimeDataVo realTimeDataVo) { |
| | | DryOrderVo orderVo; |
| | | // 查询药材 |
| | | DryHerb herb = queryHerbByIndexTenant(realTimeDataVo); |
| | | DryHerbFormula herbFormula = queryHerbByIndexTenant(realTimeDataVo); |
| | | // 查询设备 |
| | | DryEquipment equ = queryEquipmentByCodeTenant(realTimeDataVo); |
| | | |
| | | // 创建新工单 |
| | | orderVo = new DryOrderVo(realTimeDataVo); |
| | | orderVo.setHerbId(herb.getId()); |
| | | orderVo.setHerbId(herbFormula.getId()); |
| | | orderVo.setEquId(equ.getId()); |
| | | DryOrder dryOrder = BeanUtil.toBean(orderVo, DryOrder.class); |
| | | boolean save = dryOrderService.save(dryOrder); |
| | |
| | | * @param realTimeDataVo |
| | | * @return |
| | | */ |
| | | private DryHerb queryHerbByIndexTenant(RealTimeDataVo realTimeDataVo) { |
| | | LambdaQueryWrapper<DryHerb> queryWrapper = new LambdaQueryWrapper<>(); |
| | | queryWrapper.eq(DryHerb::getTenantId, realTimeDataVo.getTenantid()); |
| | | queryWrapper.eq(DryHerb::getCode, realTimeDataVo.getIndex()); |
| | | DryHerb one = herbService.getOne(queryWrapper); |
| | | if (one == null) { |
| | | one = new DryHerb(realTimeDataVo); |
| | | herbService.save(one); |
| | | } |
| | | private DryHerbFormula queryHerbByIndexTenant(RealTimeDataVo realTimeDataVo) { |
| | | LambdaQueryWrapper<DryHerbFormula> queryWrapper = new LambdaQueryWrapper<>(); |
| | | queryWrapper.eq(DryHerbFormula::getTenantId, realTimeDataVo.getTenantid()); |
| | | queryWrapper.eq(DryHerbFormula::getCode, realTimeDataVo.getIndex()); |
| | | DryHerbFormula one = dryHerbFormulaService.getOne(queryWrapper); |
| | | // if (one == null) { |
| | | // one = new DryHerb(realTimeDataVo); |
| | | // herbService.save(one); |
| | | // } |
| | | return one; |
| | | } |
| | | |
| | |
| | | */ |
| | | private void saveOrderTrendVo(DryOrderTrendVo trendVo, DryOrderVo orderVo) { |
| | | //判断 实时含水率 或 实时重量有没有变化,有变化则更新 |
| | | if(orderVo.getTrendVo() == null |
| | | if(orderVo.getTrendVo() == null && trendVo != null && trendVo.getWeight() > 0 |
| | | || trendVo.getWeight() < orderVo.getTrendVo().getWeight() |
| | | ) { |
| | | DryOrder byId = dryOrderService.getById(orderVo.getId()); |
| | |
| | | public Result<?> queryMachineRealTImeData(RealTimeDataVo realTimeDataVo) { |
| | | TenantContext.setTenant(realTimeDataVo.getTenantid()+""); |
| | | |
| | | |
| | | // 查询所有机台查询组装 |
| | | LambdaQueryWrapper<DryEquipment> queryWrapper = new LambdaQueryWrapper<>(); |
| | | |
| | | queryWrapper.eq(DryEquipment::getTenantId, realTimeDataVo.getTenantid()); |
| | | queryWrapper.eq(DryEquipment::getEnable, "Y"); |
| | | |
| | | queryWrapper.orderByAsc(DryEquipment::getCode); |
| | | // 查询所有机台 |
| | | List<DryEquipment> dryEquipments = equipmentService.list(queryWrapper); |
| | | // 机台列表,用于效率对比 |
| | | List<String> list = new ArrayList<>(); |
| | | |
| | | // 效率列表,用于效率对比 |
| | | List<Double> dList = new ArrayList<>(); |
| | | // 查询当前机台工单 |
| | | DryOrderVo orderVo = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + realTimeDataVo.getMachineid()); |
| | | try { |
| | | try { |
| | | // 如果有可用机台 |
| | | if (dryEquipments != null && dryEquipments.size() > 0) { |
| | | // 查询其它机台工单 |
| | | dryEquipments.stream().forEach(item -> { |
| | | // 获取工单 |
| | | DryOrderVo order = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + item.getCode()); |
| | | list.add(item.getName().substring(0, item.getName().indexOf('#')+1)); |
| | | if (order != null) { |
| | | // 计算干燥效率,用于对比 |
| | | DryOrderTrendVo dryOrderTrendVo = order.getDetailList().get(order.getDetailList().size() - 1); |
| | | double v = order.getOriginWeight() - dryOrderTrendVo.getWeight(); |
| | | |
| | | |
| | | if (dryEquipments != null && dryEquipments.size() > 0) { |
| | | dryEquipments.stream().forEach(item -> { |
| | | DryOrderVo order = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + item.getCode()); |
| | | if (order != null) { |
| | | double v = order.getOriginWeight() - order.getYield(); |
| | | list.add(item.getName().substring(0, item.getName().indexOf('#')+1)); |
| | | if (v > 0 && order.getDryTime()>0) { |
| | | DecimalFormat df = new DecimalFormat("#.00"); |
| | | dList.add(Double.valueOf(df.format(v / order.getDryTime() * 60))); |
| | | } else { |
| | | dList.add(50d); |
| | | } |
| | | |
| | | if (v > 0 && dryOrderTrendVo.getTotalTime()>0) { |
| | | DecimalFormat df = new DecimalFormat("#.00"); |
| | | dList.add(Double.valueOf(df.format(v / dryOrderTrendVo.getTotalTime() * 60))); |
| | | } else { |
| | | dList.add(50d); |
| | | } |
| | | }); |
| | | } |
| | | if (orderVo != null) { |
| | | orderVo.setCompEqpNum(list); |
| | | orderVo.setCompEqpEffic(dList); |
| | | } |
| | | }catch (Exception e) { |
| | | e.printStackTrace(); |
| | | |
| | | } |
| | | // 如果没有生产,效率置0 |
| | | dList.add(0d); |
| | | }); |
| | | } |
| | | |
| | | if (orderVo != null) { |
| | | // 将效率对比数据放入当前机台实时数据中返回 |
| | | orderVo.setCompEqpNum(list); |
| | | orderVo.setCompEqpEffic(dList); |
| | | // 查询近十次效率和能能耗平均 |
| | | dryOrderService.queryRecentOrderAvg(orderVo); |
| | | } |
| | | }catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } |
| | | return Result.ok(orderVo); |
| | | } |
| | | |
| | |
| | | // }); |
| | | return Result.OK(); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public Result<?> queryWorkshopStatistics(RealTimeDataVo realTimeDataVo) { |
| | | LambdaQueryWrapper<DryEquipment> queryWrapper = new LambdaQueryWrapper<>(); |
| | | queryWrapper.eq(DryEquipment::getTenantId, realTimeDataVo.getTenantid()); |
| | | queryWrapper.eq(DryEquipment::getEnable, "Y"); |
| | | List<DryEquipment> dryEquipments = equipmentService.list(queryWrapper); |
| | | DryOrderVo orderVo = new DryOrderVo(); |
| | | if (dryEquipments != null && dryEquipments.size() > 0) { |
| | | dryEquipments.stream().forEach(item -> { |
| | | DryOrderVo order = (DryOrderVo) redisUtil.hget(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode(), realTimeDataVo.getTenantid() + "_" + item.getCode()); |
| | | if (order != null) { |
| | | orderVo.setEnvHum(order.getEnvHum()); |
| | | orderVo.setEnvTemp(order.getEnvTemp()); |
| | | double watt = order.getWatt() - order.getDetailList().get(0).getWatt(); |
| | | orderVo.setWatt(orderVo.getWatt()==null? watt : orderVo.getWatt() + watt); |
| | | double steam = order.getSteam() - order.getDetailList().get(0).getSteam(); |
| | | orderVo.setSteam(orderVo.getSteam()==null? steam : orderVo.getSteam() + steam); |
| | | orderVo.setOriginWeight(orderVo.getOriginWeight()==null? order.getOriginWeight(): orderVo.getOriginWeight() + order.getOriginWeight()); |
| | | |
| | | double yield = order.getOriginWeight()*(1-(order.getInitial()/100))/(1-(order.getTarget()/100)); |
| | | orderVo.setYield(orderVo.getYield()==null? yield: orderVo.getYield() + yield); |
| | | double sub = order.getOriginWeight() - order.getYield(); |
| | | orderVo.setReduce(orderVo.getReduce()==null? sub: orderVo.getReduce() + sub); |
| | | |
| | | |
| | | } |
| | | }); |
| | | } |
| | | //redisUtil.get(CacheConstants.RedisKeyEnum.WORK_ORDER.getCode() |
| | | return Result.OK(orderVo); |
| | | } |
| | | |
| | | @Override |
| | | public Result<?> statisticsDataHandle(StatisticsDataVo statsDataVo) { |
| | | return null; |
| | | } |
| | | } |