From 6843b10472482b305b5580cc2f5cdbb97fb9a203 Mon Sep 17 00:00:00 2001 From: haoyahui <2032914783@qq.com> Date: 星期一, 13 十一月 2023 17:31:43 +0800 Subject: [PATCH] 调拨,库存盘点,报废管理,台账管理 --- consum-base/src/main/java/com/consum/base/service/LWhFormOutputServiceImpl.java | 42 +++++++++++++++++++++++------------------- 1 files changed, 23 insertions(+), 19 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormOutputServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhFormOutputServiceImpl.java index e79b9e0..dd97fbc 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhFormOutputServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhFormOutputServiceImpl.java @@ -3,23 +3,27 @@ import com.consum.base.core.CodeGeneratorEnum; import com.consum.base.core.CodeGeneratorService; import com.consum.base.core.param.BaseWarehouseParam1; -import com.consum.base.pojo.*; -import com.consum.base.util.IdUtil; -import com.consum.model.po.*; +import com.consum.base.core.utils.IdUtil; +import com.consum.base.pojo.LWFormsOutputGoodsModelParam; +import com.consum.base.pojo.LWFormsOutputGoodsParam; +import com.consum.base.pojo.LWhFormOutputInsertParam; +import com.consum.base.pojo.LWhFormOutputParam; +import com.consum.model.po.BaseGoodsModels; +import com.consum.model.po.BaseWarehouse; +import com.consum.model.po.FinSysTenantUser; +import com.consum.model.po.LWhFormOutput; +import com.consum.model.po.LWhProcureModel; import com.iplatform.model.po.S_user_core; import com.walker.db.page.GenericPager; -import com.walker.infrastructure.utils.DateUtils; import com.walker.infrastructure.utils.StringUtils; import com.walker.jdbc.service.BaseServiceImpl; +import java.util.ArrayList; +import java.util.HashMap; +import java.util.List; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.interceptor.TransactionAspectSupport; -import org.springframework.util.CollectionUtils; - -import java.util.ArrayList; -import java.util.HashMap; -import java.util.List; /** * @Description 鍑哄簱鍗� @@ -44,7 +48,6 @@ private BaseGoodsModelsServiceImpl baseGoodsModelsService; private static String QUERY_FORM_OUTPUT_LIST = "SELECT * FROM l_wh_form_output WHERE 1 = 1"; - // /** // * @Description 鏂板鍑哄簱鍗� @@ -177,11 +180,11 @@ return 0; } //2.鏂板鐗╁搧鍨嬪彿璁板綍 - List<LWhFormOutputGoodsParams> goodsList = param.getGoods(); + List<LWFormsOutputGoodsParam> goodsList = param.getGoods(); List<LWhProcureModel> modelList = new ArrayList<>(); - for (LWhFormOutputGoodsParams goods : goodsList) { - List<LWhProcureModelParams> models = goods.getModels(); - for (LWhProcureModelParams model : models) { + for (LWFormsOutputGoodsParam goods : goodsList) { + List<LWFormsOutputGoodsModelParam> models = goods.getModels(); + for (LWFormsOutputGoodsModelParam model : models) { LWhProcureModel lWhProcureModel = new LWhProcureModel(); lWhProcureModel.setId(IdUtil.generateId()); lWhProcureModel.setBusinessType(3); @@ -194,7 +197,7 @@ } lWhProcureModel.setCounts(model.getCounts()); //鏍规嵁鐗╁搧鍨嬪彿鏌ヨ鐗╁搧搴撳瓨 - int goodsNum = this.lWhGoodsService.queryGoodsModelNum(0,warehouseId, model.getBaseGoodsModelsId(), (short) 1, null); + int goodsNum = this.lWhGoodsService.queryGoodsModelNum(0, warehouseId, model.getBaseGoodsModelsId(), (short) 1, null); lWhProcureModel.setWorehouseCount(goodsNum); modelList.add(lWhProcureModel); } @@ -218,7 +221,7 @@ } /** - * @Description 鍒楄〃鏌ヨ + * @Description 鍒楄〃鏌ヨ * @Author 鍗㈠簡闃� * @Date 2023/10/30 */ @@ -232,13 +235,14 @@ } //鐗╁搧鍚嶇О if (!StringUtils.isEmpty(param.getGoodsTemplateName())) { - sql.append(" AND id IN (SELECT BUSINESS_ID FROM L_WH_PROCURE_MODEL procureModel LEFT JOIN BASE_GOODS_MODELS baseModel ON procureModel.BASE_GOODS_MODELS_ID=baseModel.ID LEFT JOIN BASE_GOODS_TEMPLATE baseTemp ON baseModel.GOODS_TEMPLATES_ID=baseTemp.id WHERE procureModel.BUSINESS_TYPE=1 AND baseTemp.GOODS_NAME LIKE :goodsTemplateName)"); + sql.append( + " AND id IN (SELECT BUSINESS_ID FROM L_WH_PROCURE_MODEL procureModel LEFT JOIN BASE_GOODS_MODELS baseModel ON procureModel.BASE_GOODS_MODELS_ID=baseModel.ID LEFT JOIN BASE_GOODS_TEMPLATE baseTemp ON baseModel.GOODS_TEMPLATES_ID=baseTemp.id WHERE procureModel.BUSINESS_TYPE=1 AND baseTemp.GOODS_NAME LIKE :goodsTemplateName)"); paramts.put("goodsTemplateName", StringUtils.CHAR_PERCENT + param.getGoodsTemplateName() + StringUtils.CHAR_PERCENT); } //鏈烘瀯 - if (param.getAgencyId() != null){ + if (param.getAgencyId() != null) { sql.append(" and AGENCY_ID like :agencyId "); - paramts.put("agencyId", param.getAgencyId() + StringUtils.CHAR_PERCENT); + paramts.put("agencyId", param.getAgencyId() + StringUtils.CHAR_PERCENT); } //鍒涘缓浜� if (!StringUtils.isEmpty(param.getOperatorName())) { -- Gitblit v1.9.1