From 59f80df1e377e8775969ca4acadfa2eadd6e37ae Mon Sep 17 00:00:00 2001 From: zhangchao <zc857179121@qq.com> Date: 星期一, 04 十一月 2024 19:01:38 +0800 Subject: [PATCH] excel导出优化 --- src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java | 46 ++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 38 insertions(+), 8 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java index f92f070..1d7833c 100644 --- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java @@ -609,7 +609,7 @@ } Tag tag = tagService.selectByName("鍏ㄩ儴", 1); - Mat mat = matService.selectByMatnr(param.getCInvCCode()); + Mat mat = matService.selectByMatnr(param.getCInvCode()); if (Cools.isEmpty(mat)) { mat = new Mat(); mat.setTagId(tag.getId()); @@ -636,11 +636,11 @@ private void syncMat(Mat mat, MatSyncParam param){ Date date = new Date(); - mat.setMatnr(param.getCInvCCode());//鐗╂枡缂栫爜 + mat.setMatnr(param.getCInvCode());//鐗╂枡缂栫爜 mat.setMaktx(param.getCInvName());//鐗╂枡鍚嶇О mat.setSpecs(param.getCInvStd());//瑙勬牸 mat.setUnit(param.getCComUnitName()); - mat.setBeBatch(param.getBInvBatch()); + mat.setBeBatch(Cools.eq("true",param.getBInvBatch()) ? 1 : 0); mat.setStatus(param.getStates()); mat.setCreateBy(9999L);//9999琛ㄧずerp涓嬪彂 @@ -858,9 +858,29 @@ throw new CoolException("鍗曟嵁鍙傛暟涓虹┖鎴栬�呭崟鎹鎯呬负绌猴紝鏃犳硶鐢熸垚鍗曟嵁淇℃伅"); } + Order orderOld = null; + if(!Cools.isEmpty(orderService.selectByNo(param.getCPOID()))){ - callApiLogSave(param, "/order/pakout/default/v1", "鎺ュ彈鍗曟嵁澶辫触锛岃鍗曟嵁宸插瓨鍦紝鏃犳硶鐢熸垚鍗曟嵁淇℃伅", false); - throw new CoolException("璇ュ崟鎹凡瀛樺湪锛屾棤娉曠敓鎴愬崟鎹俊鎭�"); + + orderOld = orderService.selectByNo(param.getCPOID()); + if(orderOld.getSettle() > 1){ + throw new CoolException("璇ュ崟鎹凡鍦ㄤ綔涓氫腑锛屾棤娉曟洿鏀瑰崟鎹俊鎭�"); + } + +// String orderNo = param.getCPOID(); +// if (orderNo.contains("-")){ +// int index = Integer.parseInt(orderNo.split("-")[1]) + 1; +// orderNo = orderNo.split("-")[0] + "-" + index; +// param.setcPOID(orderNo); +// }else { +// orderNo = orderNo + "-1"; +// param.setcPOID(orderNo); +// } +// +// syncOrder(param,pakin,docName); + + //callApiLogSave(param, "/order/pakout/default/v1", "鎺ュ彈鍗曟嵁澶辫触锛岃鍗曟嵁宸插瓨鍦紝鏃犳硶鐢熸垚鍗曟嵁淇℃伅", false); + //throw new CoolException("璇ュ崟鎹凡瀛樺湪锛屾棤娉曠敓鎴愬崟鎹俊鎭�"); } Date now = new Date(); Order order = orderMapping(param,now,pakin,docName); @@ -869,6 +889,12 @@ OrderDetl orderDetl = orderDetlMapping(order,od,now); orderDetlService.insert(orderDetl); }); + + if(!Cools.isEmpty(orderOld)){ + //鍒犻櫎鍘熸湁鍗曟嵁淇℃伅 + orderService.delete(new EntityWrapper<Order>().eq("id",orderOld.getId())); + orderDetlService.delete(new EntityWrapper<OrderDetl>().eq("order_id",orderOld.getId())); + } callApiLogSave(param, "/order/pakout/default/v1", "鎺ュ彈鍗曟嵁鎴愬姛", true); @@ -887,7 +913,7 @@ } orderService.deleteById(order); - orderDetlService.delete(new EntityWrapper<OrderDetl>().eq("order_no",orderNo)); + orderDetlService.delete(new EntityWrapper<OrderDetl>().eq("order_id",order.getId())); return true; } @@ -907,6 +933,8 @@ order.setMemo(param.getCMemo()); //鍒跺崟浜� order.setShipCode(param.getCPersonCode()); + + order.setDefNumber(param.get鎿嶄綔绯荤粺鍙�()); order.setCreateTime(now); order.setUpdateTime(now); @@ -943,11 +971,13 @@ //鏁伴噺 od.setAnfme(odParam.getIQuantity()); //閿�鍞鍗曞彿 - od.setThreeCode(odParam.getCsocode()); + od.setThreeCode(odParam.getCDefine22()); //鑷敱椤� od.setDeadTime(odParam.getBFree1()); //IDs - od.setSku(odParam.getID()); + od.setSku(odParam.getId()); + + od.setLength(odParam.getINum()); od.setStatus(1); od.setQty(0.0D); -- Gitblit v1.9.1