package com.zy.asrs.task; import com.alibaba.excel.util.StringUtils; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.core.common.Cools; import com.zy.asrs.entity.*; import com.zy.asrs.entity.mes.MesInApply; import com.zy.asrs.entity.mes.MesRecvFeedback; import com.zy.asrs.entity.mes.MesReturn; import com.zy.asrs.service.*; import com.zy.asrs.service.impl.RcsServiceImpl; import com.zy.asrs.task.core.ReturnT; import com.zy.asrs.task.handler.OrderSyncHandler; import com.zy.asrs.utils.OrderInAndOutUtil; import com.zy.common.entity.Parameter; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.scheduling.annotation.Async; import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; import javax.annotation.Resource; import java.util.ArrayList; import java.util.List; import java.util.regex.Matcher; import java.util.regex.Pattern; /** * updated by IX in 2024/12/17 */ @Slf4j @Component public class OrderSyncScheduler { @Autowired private OrderSyncHandler orderSyncHandler; @Autowired private OrderService orderService; @Autowired private ApiLogService apiLogService; @Resource private OrderPakinService orderPakinService; @Resource private OrderPakoutService orderPakoutService; @Resource private MesService mesService; @Resource private OrderDetlPakinService orderDetlPakinService; @Value("${mes.url}") public String MES_URL; @Value("${erp.switch.ErpReportOld}") private boolean ErpReportOld; @Scheduled(cron = "0 0 1 * * ? ") public void clearApiLog() { try { apiLogService.clearWeekBefore(); } catch (Exception e) { log.error("第三方接口日志自动清除失败(范围:一周之前", e); } } // @Scheduled(cron = "0 1 * * * ? ") @Async("orderThreadPool") public void completeAndReportOrderIssuedOnceMore() { List orderList = orderService.selectComplete99(); for (Order order : orderList) { try { ReturnT result = orderSyncHandler.startOrderIssuedOnceMore(order); if (!result.isSuccess()) { log.error("单据[orderNo={}]再次转执行表失败:{}", order.getOrderNo(),result.getMsg()); } } catch (Exception e){ log.error(e.getMessage()); log.error("单据[orderNo={}]再次转执行表失败", order.getOrderNo()); } } } // @Scheduled(cron = "0/30 * * * * ? ") @Async("orderThreadPool") public void completeAndReportOrderIssued() { // String erpReport = Parameter.get().getErpReport(); // if (!Cools.isEmpty(erpReport) && erpReport.equals("true")) { List orderList = orderService.selectComplete1(); // List orderList = orderService.selectList(new EntityWrapper().eq("settle", 1L).eq("status", 1).orderBy("create_time", true)); for (Order order : orderList) { try { ReturnT result = orderSyncHandler.startOrderIssued(order); if (!result.isSuccess()) { log.error("单据[orderNo={}]转执行表失败", order.getOrderNo()); } } catch (Exception e){ log.error(e.getMessage()); log.error("单据[orderNo={}]转执行表失败", order.getOrderNo()); } } // } } // @Scheduled(cron = "0/5 * * * * ? ") @Async("orderThreadPool") public void completeAndReportOrderInAndOutUtil() { // String erpReport = Parameter.get().getErpReport(); // if (!Cools.isEmpty(erpReport) && erpReport.equals("true")) { List orders = OrderInAndOutUtil.selectComplete(null); for (Order order : orders) { try { ReturnT result = orderSyncHandler.startOrderInAndOutUtil(order); if (!result.isSuccess()) { log.error("单据[orderNo={}]转上报表失败", order.getOrderNo()); } } catch (Exception e){ log.error(e.getMessage()); log.error("单据[orderNo={}]转上报表失败", order.getOrderNo()); } } // } } // 入库订单完成上报-领料单,原材料 @Scheduled(cron = "0/30 * * * * ? ") @Async("orderThreadPool") void inOrderCompleteReport() { String erpReport = Parameter.get().getErpReport(); if (!Cools.isEmpty(erpReport) && erpReport.equals("true")) { OrderPakin orderPakin = orderPakinService.selectOne(new EntityWrapper().eq("settle", 4) .eq("doc_type",4).orderBy("update_time")); if (orderPakin == null) { return; } String orderNo = orderPakin.getOrderNo(); List orderDetlPakins = orderDetlPakinService.selectByOrderId(orderPakin.getId()); List list = new ArrayList<>(); JSONObject dbMemo = JSONObject.parseObject(orderPakin.getMemo()); for (OrderDetlPakin orderDetl : orderDetlPakins) { MesRecvFeedback.MesRecvFeedbackItem item = new MesRecvFeedback.MesRecvFeedbackItem(); item.setItemNo(orderDetl.getMatnr()); item.setOrderNo(orderNo); item.setQty(orderDetl.getAnfme().intValue()); item.setRealQty(orderDetl.getAnfme().intValue()); // 回传托盘绑定的零件二维码 String itemBarcode = orderDetl.getStandby1(); List itemBarCodeList = new ArrayList<>(); Matcher matcher = Pattern.compile("\"([^\"]*)\"").matcher(itemBarcode); while (matcher.find()) { itemBarCodeList.add(matcher.group(1)); } item.setItemBarcode(itemBarCodeList); list.add(item); } MesRecvFeedback mesRecvFeedback = new MesRecvFeedback(); mesRecvFeedback.setSourceNo(dbMemo.getString("sourceNo")); mesRecvFeedback.setOperuser(dbMemo.getString("operuser")); mesRecvFeedback.setItemdata(list); String url = MES_URL + "MaterialReceiptAndReturn"; String response = RcsServiceImpl.sendPost(url, JSONObject.toJSONString(mesRecvFeedback)); if (!StringUtils.isEmpty(response) && response.contains("Success")) { MesReturn mesReturn = JSONObject.parseObject(response, MesReturn.class); if ("1".equals(mesReturn.getSuccess())) { orderPakin.setSettle(6L); orderPakinService.updateById(orderPakin); log.info("订单上报成功,orderNo={}", orderNo); } } } } // 其他入库单上报 @Scheduled(cron = "0/30 * * * * ? ") @Async("orderThreadPool") void otherInOrderCompleteReport() { String erpReport = Parameter.get().getErpReport(); if (!Cools.isEmpty(erpReport) && erpReport.equals("true")) { OrderPakin orderPakin = orderPakinService.selectOne(new EntityWrapper().eq("settle", 4) .eq("doc_type", 3).orderBy("update_time")); if (orderPakin == null) { return; } List orderDetlPakins = orderDetlPakinService.selectByOrderId(orderPakin.getId()); for (OrderDetlPakin orderDetl : orderDetlPakins) { MesInApply result = JSONObject.parseObject(orderPakin.getMemo(), MesInApply.class); result.setQty(orderDetl.getQty().intValue()); // String url = MES_URL + "loadComplete"; // String response = RcsServiceImpl.sendPost(url, JSONObject.toJSONString(result)); // if (!StringUtils.isEmpty(response) && response.contains("Success")) { // MesReturn mesReturn = JSONObject.parseObject(response, MesReturn.class); // if ("1".equals(mesReturn.getSuccess())) { orderPakin.setSettle(6L); orderPakinService.updateById(orderPakin); log.info("订单上报成功,orderNo={}", orderPakin.getOrderNo()); // } // } } } } // @Scheduled(cron = "0/30 * * * * ? ") @Async("orderThreadPool") public void completeAndReportOrderReport() { // // 入库完成 // List pakins = orderPakinService.selectComplete(); // for (OrderPakin orderPakin : pakins) { // try { // mesService.inFeedback(orderPakin.getOrderNo()); // } catch (Exception e) { // log.error("推送入库完成信息错误, order{}", orderPakin, e); // } // } // List pakouts = orderPakoutService.selectComplete(); // for (OrderPakout orderPakout : pakouts) { // try { // mesService.outFeedback(orderPakout.getOrderNo()); // } catch (Exception e) { // log.error("推送出库完成信息错误, order{}", orderPakout, e); // } // } // if (!ErpReportOld){ // return; // } // String erpReport = Parameter.get().getErpReport(); // if (!Cools.isEmpty(erpReport) && erpReport.equals("true")) { // List orders = orderService.selectComplete(); // for (Order order : orders) { // try { // ReturnT result = orderSyncHandler.startOrderReport(order); // if (!result.isSuccess()) { // log.error("单据[orderNo={}]上报erp失败", order.getOrderNo()); // } // } catch (Exception e) { // log.error(e.getMessage()); // log.error("单据[orderNo={}]上报erp失败", order.getOrderNo()); // } // } // } } }