From caf451f76ac30aa222230e0bc2d0d7cb9f420bdf Mon Sep 17 00:00:00 2001 From: 杨凯 <398860375@qq.com> Date: 星期三, 18 十月 2023 21:54:42 +0800 Subject: [PATCH] 新增部门出入库 --- consum-base/src/main/java/com/consum/base/core/WarehouseBusinessService.java | 100 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 99 insertions(+), 1 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/core/WarehouseBusinessService.java b/consum-base/src/main/java/com/consum/base/core/WarehouseBusinessService.java index ca8e0d8..05eadcc 100644 --- a/consum-base/src/main/java/com/consum/base/core/WarehouseBusinessService.java +++ b/consum-base/src/main/java/com/consum/base/core/WarehouseBusinessService.java @@ -94,6 +94,7 @@ CheckWarehouseParam param = new CheckWarehouseParam(); param.setIsCheckIn(false); param.setWarehouseId(output.getWarehouseId()); + param.setModelId(goods.getBaseGoodsModelsId()); param.setCount(goods.getCounts()); List<CheckWarehouseResult> results = coreService.unifyCheck(param); @@ -565,11 +566,108 @@ insertBatch(warningList); } + public void doDepBack(DepFormBack back){ + String sql = "SELECT\n" + + " * \n" + + "FROM\n" + + " DEP_FORM_BACK_GOODS A \n" + + "WHERE\n" + + " A.DEP_FORM_BACK_ID = :BACK_ID \n"; + + List<DepFormBackGoods> goodsList = this.select(sql,new SqlParameter() + .put("BACK_ID",back.getId()),new DepFormBackGoods()); + + for (DepFormBackGoods goods : goodsList) { + CheckUsingParam param = new CheckUsingParam(); + param.setIsCheckIn(false); + param.setLending_id(back.getDepFormLendingId()); + param.setOutputCount(goods.getBackCounts()); + //鍨嬪彿 +// param.setModel_id(model.); + + //瀛楄〃璁捐鏈夐棶棰橈紝闇�瑕侀噸鏂拌璁★紝鍙傝�冩姤搴熻〃銆� + } + + + } + + /** * 閮ㄩ棬鐗╁搧鍒嗗彂 */ - public void doDepLending(){ + public void doDepLending(DepFormLending lending){ + String sql = "SELECT\n" + + " * \n" + + "FROM\n" + + " DEP_FORM_LENDING_GOODS A \n" + + "WHERE\n" + + " A.DEP_FORM_LENDING_ID = :LENDING_ID"; + List<DepFormLendingGoods> goodsList = this.select(sql,new SqlParameter() + .put("LENDING_ID",lending.getId()),new DepFormLendingGoods()); + + for (DepFormLendingGoods goods : goodsList){ + CheckWarehouseParam param = new CheckWarehouseParam(); + param.setIsCheckIn(false); + param.setWarehouseId(lending.getWarehouseId()); + param.setModelId(goods.getBaseGoodsModelsId()); + param.setCount(goods.getCounts()); + + //棣栧厛浠庢満鏋勪粨搴撳嚭搴� + List<CheckWarehouseResult> results = coreService.unifyCheck(param); + for (CheckWarehouseResult result : results){ + WhGoodsDetails details = new WhGoodsDetails(); + details.setId(NumberGenerator.getLongSequenceNumber()); + details.setBusinessFormId(lending.getId()); + details.setBusinessFormCode(lending.getBusinessFormCode()); + details.setBusinessFormName("鍒嗗彂鍗曪細" + lending.getBusinessFormCode()); + details.setInitialCount(result.getInitial_count()); + details.setThisType(2); + details.setThisCount(result.getInitial_count() - result.getEnd_count()); + details.setEndCount(result.getEnd_count()); + details.setWarehouseId(result.getWhGoods().getWarehouseId()); + details.setWarehouseName(result.getWhGoods().getWarehouseName()); + details.setClassification(11); + details.setOperatorId(lending.getOperatorId()); + details.setOperatorName(lending.getOperatorName()); + details.setDealTime(lending.getDealTime()); + details.setWhGoodsId(result.getWhGoods().getId()); + this.insert(details); + + //鍥炲~鍑哄簱娴佹按ID锛岀敤浜庡垎鍙戞椂浣跨敤 + result.setWh_goods_detail_id(details.getId()); + } + + CheckUsingParam usingParam = new CheckUsingParam(); + usingParam.setIsCheckIn(true); + usingParam.setInput_type(1); + usingParam.setOutputList(results); + + List<CheckUsingResult> usingResults = coreService.unifyUsingCheck(usingParam); + for (CheckUsingResult usingResult : usingResults) { + UsingGoodsHis his = new UsingGoodsHis(); + his.setId(NumberGenerator.getLongSequenceNumber()); + his.setBusinessFormId(lending.getId()); + his.setBusinessFormCode(lending.getBusinessFormCode()); + his.setBusinessFormName("鍒嗗彂鍗曪細" + lending.getBusinessFormCode()); + his.setClassification(1); + his.setOperatorId(lending.getOperatorId()); + his.setOperatorName(lending.getOperatorName()); + his.setDealTime(lending.getDealTime()); + his.setDepFormLendingModelId(usingResult.getLendingModel().getId()); + his.setDepFormLendingGoodsId(usingResult.getLendingModel().getDepFormLendingGoodsId()); + his.setDepFormLendingId(lending.getId()); + his.setWhGoodsId(usingResult.getLendingModel().getWhGoodsId()); + his.setInitialCount(usingResult.getInitial_count()); + his.setEndCount(usingResult.getEnd_count()); + his.setWarehouseId(lending.getWarehouseId()); + his.setWarehouseName(lending.getWarehouseName()); + his.setDepartmentId(lending.getDepartmentId()); + his.setDepartmentName(lending.getDepartmentName()); + insert(his); + } + + } } } -- Gitblit v1.9.1