From abc5baf903a2bd229fb7f2decd35b26536d86e13 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期三, 29 十一月 2023 15:07:57 +0800 Subject: [PATCH] 部门分发增加出库和入库 --- consum-base/src/main/java/com/consum/base/service/LWhFormInventoryGoodsServiceImpl.java | 7 + consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java | 97 +++++++++++++++++++---- consum-base/src/main/java/com/consum/base/pojo/query/TransferQry.java | 27 ------ consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryController.java | 6 + consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java | 45 +++++++--- consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java | 31 +++---- 6 files changed, 136 insertions(+), 77 deletions(-) diff --git a/consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryController.java b/consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryController.java index aa8da03..a7f8bab 100644 --- a/consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryController.java +++ b/consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryController.java @@ -121,10 +121,12 @@ if (id == null) { return ResponseValue.error("鍙傛暟涓嶈兘涓虹┖"); } + //閫氳繃鏈烘瀯鏌ヨ鐩稿叧鐨勬ā鏉夸俊鎭� FormInventoryVO formInventoryVO = this.lWhFormInventoryService.queryInventBaseGoodTemplate(id); - this.lWhFormInventoryService.saveInventory(formInventoryVO, id); - return ResponseValue.success(formInventoryVO); + // 淇濆瓨鍚庤繑鍥炶褰曚俊鎭� + List<FormInventoryGoodsVO> result = this.lWhFormInventoryService.saveInventory(formInventoryVO, id); + return ResponseValue.success(result); } /** diff --git a/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java b/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java index 7630640..d7c0e2c 100644 --- a/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java +++ b/consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java @@ -2,6 +2,7 @@ import cn.hutool.core.util.ReflectUtil; import com.consum.base.BaseController; +import com.consum.base.core.utils.CommonUtil; import com.consum.base.core.utils.IdUtil; import com.consum.base.core.utils.MapUtils; import com.consum.base.core.utils.MapperUtil; @@ -17,8 +18,18 @@ import com.consum.base.pojo.response.FromTransferTemplateInfoVO; import com.consum.base.pojo.response.LWHFromTransferExtendVO; import com.consum.base.pojo.response.TransferInfoVO; -import com.consum.base.service.*; -import com.consum.model.po.*; +import com.consum.base.service.BaseGoodsModelsServiceImpl; +import com.consum.base.service.BaseWarehouseServiceImpl; +import com.consum.base.service.LWhFormTransferCoreService; +import com.consum.base.service.LWhFormTransferServiceImpl; +import com.consum.base.service.LWhProcureModelService; +import com.consum.base.service.LWhProcureModelUserRecordServiceImpl; +import com.consum.base.service.LWhProcureModelUserServiceImpl; +import com.consum.model.po.BaseWarehouse; +import com.consum.model.po.FinSysTenantUser; +import com.consum.model.po.LWhFormTransfer; +import com.consum.model.po.LWhProcureModelUser; +import com.consum.model.po.LWhProcureModelUserRecord; import com.consum.model.vo.LWhFormOutputVo; import com.iplatform.model.po.S_user_core; import com.walker.db.page.GenericPager; @@ -29,14 +40,20 @@ import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; +import java.lang.reflect.Field; +import java.util.ArrayList; +import java.util.HashMap; +import java.util.List; +import java.util.Map; +import java.util.Optional; +import java.util.stream.Collectors; import org.apache.commons.compress.utils.Lists; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.web.bind.annotation.*; - -import java.lang.reflect.Field; -import java.util.*; -import java.util.stream.Collectors; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; /** * @Description 璋冩嫧绠$悊 @@ -69,7 +86,12 @@ @ApiOperation(value = "鍗曟嵁鏂板", notes = "鍗曟嵁鏂板") @ApiImplicitParam(name = "param", value = "鍗曟嵁鏂板", required = true, dataType = "LWhFormTransferParam") @PostMapping("/add") - public ResponseValue add(@RequestBody LWhFormTransferParam param) throws Exception { + public ResponseValue add() throws Exception { + LWhFormTransferParam param = CommonUtil.getObjFromReqBody(LWhFormTransferParam.class); + LWhFormTransferParam param2 = new LWhFormTransferParam(); + CommonUtil.copyProperties(param, param2); + param = param2; + S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�"); @@ -78,11 +100,32 @@ if (CollectionUtils.isEmpty(transferGoods)) { return ResponseValue.error("璋冩嫧鍗曚笉鑳戒负绌�"); } - int result = this.lWhFormTransferService.add(param, this.getSysInfo()); - if (result > 0) { - return ResponseValue.success(); + long id = this.lWhFormTransferService.add(param, this.getSysInfo()); + + Integer transferBusinessType = param.getTransferBusinessType(); + //閮ㄩ棬鍒嗗彂涓氬姟闇�瑕佸鐞� + if (transferBusinessType == 1) { + // 鍏堝嚭搴擄紝鍐嶅叆搴� + // 鍑哄簱鍓� 璁剧疆鍑哄簱浠撳簱 + FinSysTenantUser sysTenantUser = this.getSysInfo(); + String agencyId = sysTenantUser.getTenantId(); + List<BaseWarehouse> baseWarehouseList = baseWarehouseService.getByAgencyId(Long.valueOf(agencyId), (short) 1, (short) 1); + if (CollectionUtils.isEmpty(baseWarehouseList)) { + return ResponseValue.error("鏈烘瀯鏃犻粯璁や粨搴擄紒"); + } + BaseWarehouse baseWarehouse = baseWarehouseList.get(0); + Long wareHouseId = baseWarehouse.getId(); + String warehouseName = baseWarehouse.getWarehouseName(); + LWhFormTransfer lWhFormTransfer = new LWhFormTransfer(id); + lWhFormTransfer.setOutWarehouseId(wareHouseId); + lWhFormTransfer.setOutWarehouseName(warehouseName); + lWhFormTransferService.update(lWhFormTransfer); + lWhFormTransferCoreService.doTransferOutPut(id, getCurrentUser()); + + lWhFormTransferCoreService.doTransferInPut(id, getCurrentUser()); } - return ResponseValue.error("鏂板澶辫触锛�"); + + return ResponseValue.success(); } /** @@ -101,7 +144,12 @@ @ApiImplicitParam(name = "param", value = "鏉′欢鍙傛暟", required = true, dataType = "TransferQry"), }) @GetMapping("/list") - public ResponseValue queryFormTransferList(TransferQry param) { + public ResponseValue queryFormTransferList() { + TransferQry param = CommonUtil.getObjFromReq(TransferQry.class); + TransferQry param2 = new TransferQry(); + CommonUtil.copyProperties(param, param2); + param = param2; + S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�"); @@ -169,7 +217,12 @@ @ApiImplicitParam(name = "param", value = "鏉′欢", required = true, dataType = "TransferQry"), }) @GetMapping("/detail/list") - public ResponseValue queryFormTransferDetailList(TransferQry param) { + public ResponseValue queryFormTransferDetailList() { + TransferQry param = CommonUtil.getObjFromReq(TransferQry.class); + TransferQry param2 = new TransferQry(); + CommonUtil.copyProperties(param, param2); + param = param2; + FinSysTenantUser sysInfo = this.getSysInfo(); if (sysInfo == null) { return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�"); @@ -261,7 +314,7 @@ /** * 閮ㄩ棬鐗╁搧鍒嗗彂鍒楄〃鏄庣粏 * - * @param transferQry + * @param * @return */ @ApiOperation(value = "閮ㄩ棬鐗╁搧鍒嗗彂鍒楄〃鏄庣粏", notes = "閮ㄩ棬鐗╁搧鍒嗗彂鍒楄〃鏄庣粏") @@ -269,13 +322,17 @@ @ApiImplicitParam(name = "transferQryDto", value = "璋冩嫧鍗曟煡璇㈡潯浠�", required = true) }) @GetMapping("/department/list") - public ResponseValue departmentTransferList(TransferQry transferQry) { + public ResponseValue departmentTransferList() { + TransferQry param = CommonUtil.getObjFromReq(TransferQry.class); + TransferQry param2 = new TransferQry(); + CommonUtil.copyProperties(param, param2); + param = param2; S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�"); } - GenericPager<Map<String, Object>> transferInfoDetailsVoGenericPager = this.lWhFormTransferService.queryTransferInfo(transferQry); + GenericPager<Map<String, Object>> transferInfoDetailsVoGenericPager = this.lWhFormTransferService.queryTransferInfo(param); return ResponseValue.success(transferInfoDetailsVoGenericPager); } @@ -285,7 +342,11 @@ @ApiImplicitParam(name = "procureModelInfoDto", value = "浣跨敤淇℃伅", required = true) }) @PostMapping("/useInfo/update") - public ResponseValue infoUpdate(@RequestBody List<ProcureModelInfoParam> procureModelInfoParam) { + public ResponseValue infoUpdate() { + + List<ProcureModelInfoParam> param = CommonUtil.getObjFromReqBody(List.class); + List<ProcureModelInfoParam> procureModelInfoParam = Lists.newArrayList(); + procureModelInfoParam.addAll(param); S_user_core currentUser = this.getCurrentUser(); if (currentUser == null) { diff --git a/consum-base/src/main/java/com/consum/base/pojo/query/TransferQry.java b/consum-base/src/main/java/com/consum/base/pojo/query/TransferQry.java index a927723..5f6c8ef 100644 --- a/consum-base/src/main/java/com/consum/base/pojo/query/TransferQry.java +++ b/consum-base/src/main/java/com/consum/base/pojo/query/TransferQry.java @@ -86,31 +86,8 @@ @ApiModelProperty(value = "鏌ヨ绫诲瀷") private Integer qryType; -// /** -// * 鍏ュ簱浠撳簱缂栧彿 -// */ -// private Long inWarehouseId; -// -// /** -// * 璋冩嫧鏃堕棿 -// */ -// private Long createTime; -// /** -// * 璋冩嫧鎵嬬画 -// */ -// private String procureDoc; -// /** -// * 璋冩嫧鍗曞瀷鍙� -// */ -// private List<LWhProcureModelParams> models; -// /** -// * 鐗╁搧id -// */ -// private Long baseGoodsTemplateId; -// /** -// * 鍗曟嵁绫诲瀷銆�0浠撳簱璋冩嫧锛�1閮ㄩ棬鍒嗗彂锛�2閮ㄩ棬鐗╁搧鍥為�� -// */ -// private Integer transferBusinessType; + @ApiModelProperty(value = "鍒嗗彂閮ㄩ棬,閮ㄩ棬鍒嗗彂鏃朵粨搴搃d灏辨槸鍒嗗彂閮ㄩ棬") + private Long inWarehouseId; } diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryGoodsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryGoodsServiceImpl.java index c6f4220..4bfe3ca 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryGoodsServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryGoodsServiceImpl.java @@ -34,7 +34,7 @@ } - public int add(List<FormInventoryGoodsVO> inventoryGoodsList, Long inventoryId) { + public List<FormInventoryGoodsVO> add(List<FormInventoryGoodsVO> inventoryGoodsList, Long inventoryId) { List<LWhFormInventoryGoods> goodsList = new ArrayList<>(); for (FormInventoryGoodsVO inventoryGoods : inventoryGoodsList) { LWhFormInventoryGoods lWhFormInventoryGoods = new LWhFormInventoryGoods(); @@ -46,9 +46,12 @@ lWhFormInventoryGoods.setBaseGoodsModelsId(inventoryGoods.getId()); lWhFormInventoryGoods.setBaseGoodsModelsName(inventoryGoods.getBaseGoodsModelsName()); lWhFormInventoryGoods.setInitCounts(inventoryGoods.getInventoryCount()); + //淇濆瓨鎴愬姛鍚庤繑鍥瀒d,鐢ㄦ潵杩涜璁板綍鐨勬洿鏂� + inventoryGoods.setId(lWhFormInventoryGoods.getId()); goodsList.add(lWhFormInventoryGoods); } - return this.insert(goodsList); + this.insert(goodsList); + return inventoryGoodsList; } public int updateInventoryGoods(List<FormInventoryGoodsVO> inventoryGoodsList) { diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java index cb62402..79c9669 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java @@ -21,17 +21,17 @@ import com.walker.infrastructure.utils.DateUtils; import com.walker.infrastructure.utils.StringUtils; import com.walker.jdbc.service.BaseServiceImpl; +import java.util.HashMap; +import java.util.List; +import java.util.Map; import lombok.extern.slf4j.Slf4j; import org.apache.commons.compress.utils.Lists; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; - -import java.util.HashMap; -import java.util.List; -import java.util.Map; /** * @Description 鐩樼偣 @@ -157,7 +157,7 @@ } - public void saveInventory(FormInventoryVO dto, Long id) { + public List<FormInventoryGoodsVO> saveInventory(FormInventoryVO dto, Long id) { //1.鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗� LWhFormInventory lWhFormInventory = this.get(new LWhFormInventory(id)); if (lWhFormInventory == null) { @@ -175,11 +175,9 @@ if (CollectionUtils.isEmpty(formInventoryGoodsList)) { log.error("鐩樼偣鍗曠墿鍝佷负绌�"); } - int num = inventoryGoodsService.add(formInventoryGoodsList, id); - if (num != formInventoryGoodsList.size()) { - log.error("鏇存柊鐩樼偣鍗曠墿鍝佸け璐�"); - } + List<FormInventoryGoodsVO> result = inventoryGoodsService.add(formInventoryGoodsList, id); + return result; } @@ -189,6 +187,7 @@ * @author 鍗㈠簡闃� * @date 2023/10/31 */ + @Transactional(rollbackFor = Exception.class) public int updateInventoryInfo(LWhFormInventoryParam dto, Integer state, S_user_core currentUser, FinSysTenantUser sysInfo) { //1.鏍规嵁鐩樼偣鍗昳d鏌ヨ鐩樼偣鍗� LWhFormInventory lWhFormInventory = this.get(new LWhFormInventory(dto.getId())); @@ -338,9 +337,9 @@ mapGenericPager.getDatas().forEach(item -> { FormInventoryDetailVO formInventoryDetailVO = MapUtils.convertMapToObj(item, FormInventoryDetailVO.class); formInventoryDetailVO.setInventoryResultType( - formInventoryDetailVO.getInventoryResult() == null ? null : (formInventoryDetailVO.getInventoryResult() == 2 ? "鐩樼泩" : "鐩樹簭")); + formInventoryDetailVO.getInventoryResult() == null ? null : (formInventoryDetailVO.getInventoryResult() == 2 ? "鐩樼泩" : "鐩樹簭")); formInventoryDetailVO.setInventoryType( - formInventoryDetailVO.getInventoryResult() == null ? null : (formInventoryDetailVO.getInventoryResult() == 2 ? "鐩樼泩鍏ュ簱" : "鐩樹簭鍑哄簱")); + formInventoryDetailVO.getInventoryResult() == null ? null : (formInventoryDetailVO.getInventoryResult() == 2 ? "鐩樼泩鍏ュ簱" : "鐩樹簭鍑哄簱")); formInventoryDetailVO.setWarehouseFormCode(formInventoryDetailVO.getWarehouseFormCode()); result.add(formInventoryDetailVO); }); @@ -351,8 +350,8 @@ public List<FormInventoryGoodsVO> selectDetailById(Long id) { String sql = "select fig.id, fig.BASE_GOODS_TEMPLATE_ID,fig.GOODS_TEMPLATE_NAME,fig.BASE_GOODS_MODELS_NAME," - + "fig.INIT_COUNTS inventoryCount,fig.INVENTORY_COUNTS realNum,fig.INVENTORY_RESULT status,fig.unit,bgt.CLASSIFICATION type from " - + "l_wh_form_inventory_goods fig left join base_goods_template bgt on bgt.id =fig.BASE_GOODS_TEMPLATE_ID where fig.WH_FORM_INVENTORY_ID = :id"; + + "fig.INIT_COUNTS inventoryCount,fig.INVENTORY_COUNTS realNum,fig.INVENTORY_RESULT status,fig.unit,bgt.CLASSIFICATION type from " + + "l_wh_form_inventory_goods fig left join base_goods_template bgt on bgt.id =fig.BASE_GOODS_TEMPLATE_ID where fig.WH_FORM_INVENTORY_ID = :id"; HashMap<String, Object> param = new HashMap<>(); param.put("id", id); List<Map<String, Object>> select = select(sql, param, new MapperUtil()); @@ -382,9 +381,9 @@ formInventoryVO.setWarehouseName(inventory.getWarehouseName()); String sql = - "select bgm.id,bgt.id baseGoodsTemplateId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT " - + "from base_goods_models bgm left join base_goods_template bgt on bgm.GOODS_TEMPLATES_ID = bgt.id " - + "where bgt.AGENCY_ID = :agencyId"; + "select bgt.id baseGoodsTemplateId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT " + + "from base_goods_models bgm left join base_goods_template bgt on bgm.GOODS_TEMPLATES_ID = bgt.id " + + "where bgt.AGENCY_ID = :agencyId"; HashMap<String, Object> param = new HashMap<>(); param.put("agencyId", inventory.getAgencyId()); List<Map<String, Object>> result = this.select(sql, param, new MapperUtil()); diff --git a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java index 4a10dbc..ca86152 100644 --- a/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java +++ b/consum-base/src/main/java/com/consum/base/service/LWhFormTransferServiceImpl.java @@ -14,7 +14,17 @@ import com.consum.base.pojo.response.FormTransferGoodsVO; import com.consum.base.pojo.response.GoodsModelVO; import com.consum.base.pojo.response.LWHFromTransferExtendVO; -import com.consum.model.po.*; +import com.consum.model.po.BaseGoodsModels; +import com.consum.model.po.BaseWarehouse; +import com.consum.model.po.BaseWarehouseManager; +import com.consum.model.po.FinSysTenant; +import com.consum.model.po.FinSysTenantUser; +import com.consum.model.po.LWhFormOutput; +import com.consum.model.po.LWhFormTransfer; +import com.consum.model.po.LWhGoodsRecord; +import com.consum.model.po.LWhProcureModel; +import com.consum.model.po.LWhProcureModelUser; +import com.consum.model.po.LWhProcureModelUserRecord; import com.consum.model.vo.LWhFormOutputVo; import com.consum.model.vo.LWhGoodsRecordVo; import com.iplatform.model.po.S_user_core; @@ -22,14 +32,17 @@ 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 java.util.Map; +import java.util.Optional; import org.apache.commons.compress.utils.Lists; import org.springframework.beans.BeanUtils; 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.*; /** * @Description 璋冩嫧绠$悊 @@ -75,7 +88,7 @@ * @Author 鍗㈠簡闃� * @Date 2023/10/30 */ - public int add(LWhFormTransferParam param, FinSysTenantUser sysInfo) throws Exception { + public long add(LWhFormTransferParam param, FinSysTenantUser sysInfo) throws Exception { //1.鏂板璋冩嫧鍗曡褰� LWhFormTransfer lWhFormTransfer = new LWhFormTransfer(); //璋冩嫧鍗昳d @@ -87,11 +100,11 @@ // TODO 鏋氫妇瀛楀吀 lWhFormTransfer.setBusinessType(businessType); CodeGeneratorEnum codeGeneratorEnum = null; - if (businessType == 0){ + if (businessType == 0) { codeGeneratorEnum = CodeGeneratorEnum.Transfer; - } else if (businessType == 1){ + } else if (businessType == 1) { codeGeneratorEnum = CodeGeneratorEnum.Distribute; - } else if (businessType == 2){ + } else if (businessType == 2) { codeGeneratorEnum = CodeGeneratorEnum.GOBACK; } @@ -156,7 +169,6 @@ FinSysTenant finSysTenant = finSysTenantService.get(new FinSysTenant(param.getOutAgencyId())); if (finSysTenant == null) { log.error("璋冩嫧鏈烘瀯涓嶅瓨鍦�"); - return 0; } lWhFormTransfer.setOutAgencyId(finSysTenant.getId()); lWhFormTransfer.setOutAgencyName(finSysTenant.getName()); @@ -170,7 +182,6 @@ int flag1 = this.insert(lWhFormTransfer); if (flag1 == 0) { log.error("鏂板璋冩嫧鍗曞け璐�"); - return 0; } //2.鏂板鐗╁搧鍨嬪彿璁板綍 @@ -228,7 +239,6 @@ if (procureInsertNum != procureModelUserList.size()) { log.error("鏂板鐗╁搧浣跨敤淇℃伅澶辫触"); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); - return 0; } } @@ -241,10 +251,8 @@ if (flag2 != modelList.size()) { log.error("鏂板鐗╁搧鍨嬪彿澶辫触"); TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); - return 0; } - - return 1; + return lWhFormTransferId; } @@ -307,6 +315,11 @@ if (param.getEndTime() != null) { sql.append(" and IN_TIME <:inTimeEnd "); paramts.put("inTimeEnd", param.getEndTime() * 1000000 + 240000); + } + //鍒嗗彂閮ㄩ棬 + if (param.getInWarehouseId() != null) { + sql.append("and ft.IN_WAREHOUSE_ID = :inWarehouseId "); + paramts.put("inWarehouseId", param.getInWarehouseId()); } sql.append(" ORDER BY ft.CREATE_TIME DESC"); @@ -467,7 +480,11 @@ sql.append("AND OUT_AGENCY_ID = :OUT_AGENCY_ID "); paramts.put("OUT_AGENCY_ID", transferQry.getOutAgencyId()); } - + //鍒嗗彂閮ㄩ棬 + if (transferQry.getInWarehouseId() != null) { + sql.append("and ft.IN_WAREHOUSE_ID = :inWarehouseId "); + paramts.put("inWarehouseId", transferQry.getInWarehouseId()); + } //鍒涘缓浜� if (StringUtils.isNotEmpty(transferQry.getOperatorName())) { sql.append("AND ft.OPERATOR_NAME =:OPERATOR_NAME "); -- Gitblit v1.9.1