From fae8a9349499cd045bc73e8fd22aeae52618a46c Mon Sep 17 00:00:00 2001
From: WangHan <wwh_work@126,com>
Date: 星期四, 19 十二月 2024 10:02:02 +0800
Subject: [PATCH] 采购明细查询修改，查询本级及以下
---
consum-base/src/main/java/com/consum/base/controller/BaseWarehouseController.java | 105 +++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 95 insertions(+), 10 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/controller/BaseWarehouseController.java b/consum-base/src/main/java/com/consum/base/controller/BaseWarehouseController.java
index 3cad491..127a948 100644
--- a/consum-base/src/main/java/com/consum/base/controller/BaseWarehouseController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/BaseWarehouseController.java
@@ -5,6 +5,9 @@
import java.util.List;
import java.util.stream.Collectors;
+import com.consum.base.service.FinSysTenantService;
+import com.consum.model.po.FinSysTenant;
+import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
@@ -13,6 +16,7 @@
import org.springframework.web.bind.annotation.RestController;
import com.consum.base.BaseController;
+import com.consum.base.core.type.StatesType;
import com.consum.base.core.utils.CommonUtil;
import com.consum.base.pojo.BaseWarehouseParam;
import com.consum.base.pojo.query.WarehouseQry;
@@ -20,7 +24,9 @@
import com.consum.base.service.LWhGoodsService;
import com.consum.model.po.BaseWarehouse;
import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LWhGoods;
import com.walker.db.page.GenericPager;
+import com.walker.infrastructure.utils.CollectionUtils;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.web.ResponseValue;
@@ -37,12 +43,17 @@
@Api(value = "浠撳簱绠＄悊", tags = "浠撳簱绠＄悊")
@RestController
@RequestMapping("/pc/base/warehouse")
+@Slf4j
public class BaseWarehouseController extends BaseController {
@Autowired
private BaseWarehouseService baseWarehouseService;
+
@Autowired
private LWhGoodsService lWhGoodsService;
+
+ @Autowired
+ private FinSysTenantService finSysTenantService;
/**
* @Description 鏂板
@@ -59,7 +70,13 @@
if (StringUtils.isEmpty(param.getWarehouseName())) {
return ResponseValue.error("浠撳簱鍚嶇О涓虹┖");
}
- // TODO 鍔犳潈闄� 鐪佺骇绠＄悊鍛樺綍鍏ユ墍鏈変粨搴撲俊鎭�
+ Long agencyId = param.getAgencyId();
+ BaseWarehouse baseWarehouse = new BaseWarehouse();
+ baseWarehouse.setAgencyId(agencyId);
+ List<BaseWarehouse> select = baseWarehouseService.select(baseWarehouse);
+ if (!CollectionUtils.isEmpty(select)) {
+ return ResponseValue.error("璇ユ満鏋勫凡鏈変粨搴撲笉鑳界户缁柊澧烇紒");
+ }
int result = baseWarehouseService.add(param);
if (result > 0) {
@@ -67,6 +84,67 @@
}
return ResponseValue.error("鏂板澶辫触锛�");
}
+
+ // 渚涗骇鍝佸鏁版嵁涓存椂鐢�(鍙垹)
+ public String add1(BaseWarehouseParam param) {
+ BaseWarehouseParam param2 = new BaseWarehouseParam();
+ CommonUtil.copyProperties(param, param2);
+ param = param2;
+
+ if (StringUtils.isEmpty(param.getWarehouseName())) {
+ return "浠撳簱鍚嶇О涓虹┖";
+ }
+ Long agencyId = param.getAgencyId();
+ BaseWarehouse baseWarehouse = new BaseWarehouse();
+ baseWarehouse.setAgencyId(agencyId);
+ List<BaseWarehouse> select = baseWarehouseService.select(baseWarehouse);
+ if (!CollectionUtils.isEmpty(select)) {
+ return "璇ユ満鏋勫凡鏈変粨搴撲笉鑳界户缁柊澧烇紒";
+ }
+ int result = baseWarehouseService.add(param);
+ if (result > 0) {
+ return "1";
+ }
+ return "鏂板澶辫触锛�";
+ }
+
+ //渚涗骇鍝佸鏁版嵁涓存椂鐢�(鍙垹)(鏂板浠撳簱)
+ //@PostMapping("/addCk")
+ public String addCk() {
+ int ok = 0;
+ int isNull = 0;
+ int bnxz = 0;
+ int err = 0;
+ // 鏌ヨ鎵�鏈夌殑鏈烘瀯
+ FinSysTenant finSysTenant = new FinSysTenant();
+ List<FinSysTenant> finSysTenants = finSysTenantService.selectAll(finSysTenant);
+ for (FinSysTenant fst : finSysTenants) {
+ // 缁勮浠撳簱鏁版嵁
+ BaseWarehouseParam baseWarehouseParam = new BaseWarehouseParam();
+ baseWarehouseParam.setWarehouseName(fst.getName() + "浠撳簱");
+ baseWarehouseParam.setAdress("");
+ baseWarehouseParam.setAgencyId(fst.getId());
+ baseWarehouseParam.setClassificationCode("29");
+ baseWarehouseParam.setStates(1);
+ // 璋冪敤鍘熸湰鐨勬柊澧炴帴鍙ｆ柊澧炰粨搴�
+ String resSta = add1(baseWarehouseParam);
+ if("1".equals(resSta)){
+ ok++;
+ }else if("浠撳簱鍚嶇О涓虹┖".equals(resSta)){
+ isNull++;
+ }else if("璇ユ満鏋勫凡鏈変粨搴撲笉鑳界户缁柊澧烇紒".equals(resSta)){
+ bnxz++;
+ }else if("鏂板澶辫触锛�".equals(resSta)){
+ err++;
+ }
+ }
+ log.info("ok:"+ok);
+ log.info("isNull:"+isNull);
+ log.info("bnxz:"+bnxz);
+ log.info("err:"+err);
+ return "鏂板浠撳簱..."+"##ok:"+ok+"##isNull:"+isNull+"##bnxz:"+bnxz+"##err:"+err;
+ }
+
/**
* @Description 浠撳簱鍒楄〃鏌ヨ
@@ -146,6 +224,13 @@
if (baseWarehouse.getId() == null) {
return ResponseValue.error("浠撳簱id涓虹┖");
}
+ Long id = baseWarehouse.getId();
+ LWhGoods lWhGoods = new LWhGoods();
+ lWhGoods.setWarehouseId(id);
+ List<LWhGoods> select = lWhGoodsService.select(lWhGoods);
+ if (!CollectionUtils.isEmpty(select)) {
+ return ResponseValue.error("璇ヤ粨搴撴鍦ㄤ娇鐢紝涓嶈兘鍒犻櫎");
+ }
int num = baseWarehouseService.updateById(baseWarehouse);
return num > 0 ? ResponseValue.success(1) : ResponseValue.error("鍒犻櫎澶辫触锛�");
@@ -161,7 +246,7 @@
if (agencyId == null) {
return ResponseValue.success(new ArrayList<>());
}
- List<BaseWarehouse> list = baseWarehouseService.getBaseWareHouseList(agencyId, null, null);
+ List<BaseWarehouse> list = baseWarehouseService.getBaseWareHouseList(agencyId, StatesType.NORMAL.getValue());
if (list == null) {
return ResponseValue.error("鏌ヨ澶辫触锛�");
}
@@ -170,7 +255,7 @@
@ApiOperation(value = "鏍规嵁浠撳簱id鍜屽瀷鍙穒d 鏌ヨ搴撳瓨", notes = "鏍规嵁浠撳簱id鍜屽瀷鍙穒d 鏌ヨ搴撳瓨")
@ApiImplicitParams({@ApiImplicitParam(name = "warehouseQry", value = "浠撳簱id鍜屽瀷鍙穒d", required = true,
- dataType = "WarehouseQry", paramType = "query")})
+ dataType = "WarehouseQry", paramType = "query")})
@GetMapping("/select/number")
public ResponseValue selectNumber() {
WarehouseQry warehouseQry = CommonUtil.getObjFromReq(WarehouseQry.class);
@@ -181,15 +266,14 @@
Long warehouseId = warehouseQry.getWarehouseId();
if (warehouseId == null) {
Long agencyId = warehouseQry.getAgencyId();
- BaseWarehouse defaultWarehouseByAgencyId = baseWarehouseService.getDefaultWarehouseByAgencyId(agencyId);
- warehouseId = defaultWarehouseByAgencyId.getId();
+ BaseWarehouse baseWarehouse = baseWarehouseService.getWarehouseByAgencyId(agencyId, null);
+ warehouseId = baseWarehouse.getId();
}
Long baseGoodsModelsId = warehouseQry.getBaseGoodsModelsId();
Integer warehouseType = warehouseQry.getWarehouseType();
- Integer states = warehouseQry.getStates();
Integer buyType = warehouseQry.getBuyType();
- // TODO 鍏朵粬绫诲瀷鐨勫簱瀛樻煡璇㈡槸鍚﹁鏌ラ儴闂ㄧ被鍨嬬殑搴撳瓨
+ // 鍏朵粬绫诲瀷鐨勫簱瀛樻煡璇㈡槸鍚︿篃瑕佹煡閮ㄩ棬绫诲瀷鐨勫簱瀛�
List<Long> warehouseIds = new ArrayList<>(Arrays.asList(warehouseId));
int num = lWhGoodsService.queryGoodsModelNum(warehouseType, warehouseIds, baseGoodsModelsId, 1, buyType);
return ResponseValue.success(num);
@@ -197,7 +281,7 @@
@ApiOperation(value = "鏍规嵁浠撳簱id鍜屽瀷鍙穒d 鏌ヨ搴撳瓨", notes = "鏍规嵁浠撳簱id鍜屽瀷鍙穒d 鏌ヨ搴撳瓨")
@ApiImplicitParams({@ApiImplicitParam(name = "warehouseQry", value = "浠撳簱id鍜屽瀷鍙穒d", required = true,
- dataType = "WarehouseQry", paramType = "query")})
+ dataType = "WarehouseQry", paramType = "query")})
@GetMapping("/select/in/warehouse/num")
public ResponseValue selectAllNumber() {
WarehouseQry warehouseQry = CommonUtil.getObjFromReq(WarehouseQry.class);
@@ -206,7 +290,8 @@
warehouseQry = param2;
Long agencyId = warehouseQry.getAgencyId();
- List<BaseWarehouse> baseWarehouseList = baseWarehouseService.getBaseWareHouseList(agencyId, null, (short)1);
+ List<BaseWarehouse> baseWarehouseList =
+ baseWarehouseService.getBaseWareHouseList(agencyId, StatesType.NORMAL.getValue());
List<Long> warehouseIdList = baseWarehouseList.stream().map(BaseWarehouse::getId).collect(Collectors.toList());
Long baseGoodsModelsId = warehouseQry.getBaseGoodsModelsId();
@@ -217,7 +302,7 @@
// 璋冩嫧鏃跺彧鏌ユ満鏋勭被鍨嬬殑闆嗛噰浠撳簱搴撳瓨
// 閮ㄩ棬鍒嗗彂鏃朵笉鍒嗘満鏋勫拰閮ㄩ棬锛屽洜涓鸿皟鎷ㄨ繘鏉ョ殑鐗╁搧涔熺畻鍦ㄥ簱瀛橀噷鍙槸绫诲瀷涓洪儴闂紝鍚屾牱妫�瑙嗘墍鏈変粨搴撹鍨嬪彿鐨勬暟閲�
int num = lWhGoodsService.queryGoodsModelInWareHouseNum(warehouseType, warehouseIdList, baseGoodsModelsId,
- states, buyType);
+ states, buyType);
return ResponseValue.success(num);
}
--
Gitblit v1.9.1