| | |
| | | /** |
| | | * 获取入出库订单信息 |
| | | */ |
| | | @Scheduled(cron = "${erp.refreshtime}") |
| | | // @Scheduled(cron = "${erp.refreshtime}") |
| | | public void InOrOutOrder() { |
| | | if (!erpEnabledErpDetTb) return; |
| | | String sqlSelectErpDetTb = "select BIL_NO as billNo,prd_no as prdNo,ITM as itm,ADD_ID as addId2,QTY as qty,PRD_MARK as prdMark,WH as wh,STATUS as status,Temp1 as temp1,Temp2 as temp2,Temp3 as temp3 from ERP_DETTB where 1=1"; |
| | |
| | | callApiLogSave(erpDetTb, "ERP_DETTB", "品号信息在立库不存在,请先添加商品!!!", false); |
| | | } |
| | | } else { |
| | | Order order = orderService.selectByNo(erpDetTb.getBillNo()); |
| | | Order order = orderService.selectByNo(erpDetTb.getBillNo()+"---"+erpDetTb.getItm()); |
| | | if (Cools.isEmpty(order)) { |
| | | order = new Order( |
| | | String.valueOf(snowflakeIdWorker.nextId()), // 编号[非空] |
| | | erpDetTb.getBillNo(), // 订单编号 |
| | | erpDetTb.getBillNo()+"---"+erpDetTb.getItm(), // 订单编号 |
| | | DateUtils.convert(now), // 单据日期 |
| | | null, // 单据类型 |
| | | null, // 项目编号 |
| | |
| | | } |
| | | } |
| | | } |
| | | Order order1 = orderService.selectByNo(erpDetTb.getBillNo()); |
| | | Order order1 = orderService.selectByNo(erpDetTb.getBillNo()+"---"+erpDetTb.getItm()); |
| | | if (!Cools.isEmpty(order1)) { |
| | | OrderDetl orderDetl = orderDetlService.selectItem(order1.getId(), erpDetTb.getBillNo(), erpDetTb.getPrdMark()); |
| | | // OrderDetl orderDetl = orderDetlService.selectItem(order1.getId(), erpDetTb.getBillNo(), erpDetTb.getPrdMark()); |
| | | OrderDetl orderDetl = orderDetlService.selectOne(new EntityWrapper<OrderDetl>().eq("order_no",erpDetTb.getBillNo()+"---"+erpDetTb.getItm()).eq("matnr",erpDetTb.getPrdNo())); |
| | | if (Cools.isEmpty(orderDetl)) { |
| | | orderDetl = new OrderDetl(); |
| | | orderDetl.setOrderId(order1.getId()); |
| | | orderDetl.setOrderNo(erpDetTb.getBillNo()); |
| | | orderDetl.setOrderNo(erpDetTb.getBillNo()+"---"+erpDetTb.getItm()); |
| | | orderDetl.setAnfme(erpDetTb.getQty()); |
| | | orderDetl.setQty(0.0D); |
| | | orderDetl.setMatnr(erpDetTb.getPrdNo()); |