From 0c1dd25eabc4472c007951d528ee7385cc114e32 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期六, 11 十一月 2023 19:06:23 +0800
Subject: [PATCH] -- 采购单 -- 分类
---
consum-base/src/main/java/com/consum/base/controller/LWhFormProcureController.java | 163 +++++++++++++++++++++++++++++++++++++++--------------
1 files changed, 119 insertions(+), 44 deletions(-)
diff --git a/consum-base/src/main/java/com/consum/base/controller/LWhFormProcureController.java b/consum-base/src/main/java/com/consum/base/controller/LWhFormProcureController.java
index 711d942..746e598 100644
--- a/consum-base/src/main/java/com/consum/base/controller/LWhFormProcureController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/LWhFormProcureController.java
@@ -4,35 +4,70 @@
import com.consum.base.core.CodeGeneratorEnum;
import com.consum.base.core.CodeGeneratorService;
import com.consum.base.core.WhBusinessEnum;
-import com.consum.base.pojo.LWhFormProcureExtend;
+import com.consum.base.core.tools.MapperUtil;
import com.consum.base.pojo.LWhFormProcureGoodsParams;
import com.consum.base.pojo.LWhFormProcureParam;
import com.consum.base.pojo.LWhProcureModelParams;
-import com.consum.base.service.*;
-import com.consum.model.po.*;
+import com.consum.base.pojo.query.FormProcureQryDto;
+import com.consum.base.pojo.response.FormProcureVO;
+import com.consum.base.pojo.response.FromProcureTemplateInfoVO;
+import com.consum.base.pojo.response.GoodsModelVO;
+import com.consum.base.pojo.response.LWhFormProcureExtendVO;
+import com.consum.base.pojo.response.LWhFormProcureGoodsVO;
+import com.consum.base.service.BaseGoodsTemplateServiceImpl;
+import com.consum.base.service.BaseWarehouseServiceImpl;
+import com.consum.base.service.FinSysTenantServiceImpl;
+import com.consum.base.service.LOrgSupplierServiceImpl;
+import com.consum.base.service.LWhFormProcureCoreService;
+import com.consum.base.service.LWhFormProcureGoodsService;
+import com.consum.base.service.LWhFormProcureService;
+import com.consum.base.service.LWhGoodsService;
+import com.consum.base.service.LWhProcureModelService;
+import com.consum.base.util.MapUtils;
+import com.consum.model.po.BaseGoodsTemplate;
+import com.consum.model.po.BaseWarehouse;
+import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LOrgSupplier;
+import com.consum.model.po.LWhFormProcure;
+import com.consum.model.po.LWhFormProcureGoods;
+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.CollectionUtils;
-import com.walker.infrastructure.utils.DateUtils;
import com.walker.infrastructure.utils.NumberGenerator;
import com.walker.web.ResponseValue;
-import org.springframework.beans.BeanUtils;
-import org.springframework.web.bind.annotation.*;
-
-import javax.annotation.Resource;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiImplicitParam;
+import io.swagger.annotations.ApiImplicitParams;
+import io.swagger.annotations.ApiOperation;
import java.lang.reflect.Field;
-import java.util.*;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.HashSet;
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+import javax.annotation.Resource;
+import org.apache.commons.compress.utils.Lists;
+import org.springframework.beans.BeanUtils;
+import org.springframework.web.bind.annotation.DeleteMapping;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
/**
* @ClassName LWhFormProcureController
-
* @Date 2023/10/27
* @Description
* @Version 1.0
**/
+@Api(value = "浠撳簱琛ㄥ崟閲囪喘", tags = "浠撳簱琛ㄥ崟閲囪喘")
@RestController
@RequestMapping("/pc/whForm/procure")
public class LWhFormProcureController extends BaseController {
+
@Resource
private LWhFormProcureService lWhFormProcureService;
@Resource
@@ -67,6 +102,8 @@
FinSysTenantUser sysTenantUser = this.getSysInfo();
String tenantId = sysTenantUser.getTenantId();
String tenantName = sysTenantUser.getTenantName();
+// String tenantId = "100";
+// String tenantName = "娌冲崡鐪佸垎鍏徃";
// 鍙兘娣诲姞鏈満鏋勪粨搴撶殑杩涜揣鍗�
//??????
//
@@ -82,12 +119,12 @@
if (whFormProcureId == null) {
whFormProcureId = NumberGenerator.getLongSequenceNumber();
}
- long procureTime = DateUtils.getDateTimeNumber(param.getProcureTime());
+ long procureTime = Long.valueOf(param.getProcureTime());
Set<String> supplierList = new HashSet<>();
ArrayList<LWhFormProcureGoods> procureGoodList = new ArrayList<>();
- ArrayList<LWhProcureModel> whProcureModeLlist = new ArrayList<>();
+ ArrayList<LWhProcureModel> procureModelList = new ArrayList<>();
for (int i = 0; i < procureGoods.size(); i++) {
LWhFormProcureGoodsParams procureGoodT = procureGoods.get(i);
@@ -99,7 +136,6 @@
supplierList.add(supplier);
}
-
List<LWhProcureModelParams> models = procureGoodT.getModels();
if (CollectionUtils.isEmpty(models)) {
return ResponseValue.error("閲囪喘鍗曚笉鑳戒负绌�");
@@ -110,7 +146,8 @@
procureGood.setWhFormProcureId(whFormProcureId);
procureGood.setBaseCategoryId(baseCategoryId);
procureGood.setBaseGoodsTemplateId(baseGoodsTemplateId);
- procureGood.setGoodsTemplateName(null);
+ // TODO 鐗╁搧鍘嗗彶鐗堟湰
+ procureGood.setGoodsTemplateName(procureGoodT.getGoodsTemplateName());
procureGood.setSupplier(supplier);
procureGood.setSort(i);
for (LWhProcureModelParams modelT : models) {
@@ -145,12 +182,12 @@
model.setCounts(counts);
model.setWorehouseCount(goodsModelNum);
model.setSupplier(supplier);
- whProcureModeLlist.add(model);
+ procureModelList.add(model);
}
procureGoodList.add(procureGood);
}
lWhFormProcureGoodsService.insertBatch(procureGoodList);
- lWhProcureModelService.insertBatch(whProcureModeLlist);
+ lWhProcureModelService.insertBatch(procureModelList);
// 鎻掑叆 閲囪喘鍗曠墿鍝併�怢_WH_FORM_PROCURE_GOODS銆�
LWhFormProcure lWhFormProcure = new LWhFormProcure();
@@ -185,8 +222,10 @@
/**
* @Description 鍒楄〃鏌ヨ
*/
+ @ApiOperation(value = "閲囪喘鍗曞垪琛ㄦ煡璇�", notes = "閲囪喘鍗曞垪琛ㄦ煡璇�")
+ @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "閲囪喘鏌ヨ鏉′欢", required = true, dataType = "FormProcureQryDto", paramType = "query")})
@GetMapping("/list")
- public ResponseValue queryFormProcureList(LWhFormProcureParam param) {
+ public ResponseValue queryFormProcureList(FormProcureQryDto param) {
S_user_core currentUser = this.getCurrentUser();
if (currentUser == null) {
return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�");
@@ -197,29 +236,38 @@
//??????
GenericPager genericPager = lWhFormProcureService.queryFormProcureList(param);
- List<LWhFormProcure> datas = genericPager.getDatas();
- ArrayList<LWhFormProcureExtend> newDatas = new ArrayList<>();
- if (!CollectionUtils.isEmpty(datas)) {
- datas.forEach(item -> {
+ List<LWhFormProcure> data = genericPager.getDatas();
+ ArrayList<FormProcureVO> result = new ArrayList<>();
+ if (!CollectionUtils.isEmpty(data)) {
+ data.forEach(item -> {
+
+ FormProcureVO fromProcureVO = new FormProcureVO();
+ BeanUtils.copyProperties(item, fromProcureVO);
+ List<FromProcureTemplateInfoVO> procureTemplateInfoList = Lists.newArrayList();
+
// 鏌ヨ鍨嬪彿鏁伴噺
- LWhProcureModel lWhProcureModel = new LWhProcureModel();
- lWhProcureModel.setBusinessType(1);
- lWhProcureModel.setBusinessId(item.getId());
- List<LWhProcureModel> models = lWhProcureModelService.select(lWhProcureModel);
- LWhFormProcureExtend formProcureExtend = new LWhFormProcureExtend();
- BeanUtils.copyProperties(item, formProcureExtend);
- formProcureExtend.setModels(models);
- newDatas.add(formProcureExtend);
+ String sql = "select fpg.id,BASE_CATEGORY_ID ,BASE_GOODS_TEMPLATE_ID ,GOODS_TEMPLATE_NAME ,sum(counts) count "
+ + "from L_WH_FORM_PROCURE_GOODS fpg left join L_WH_PROCURE_MODEL pm on fpg.id = pm.FROM_PROCURE_GOODS_ID "
+ + "where fpg.WH_FORM_PROCURE_ID =:id group by pm.FROM_PROCURE_GOODS_ID";
+ Map<String, Object> paramMap = new HashMap<>();
+ paramMap.put("id", item.getId());
+ List<Map<String, Object>> procureModelList = lWhProcureModelService.select(sql, paramMap);
+ for (Map<String, Object> map : procureModelList) {
+ FromProcureTemplateInfoVO procureTemplateInfoVO = MapUtils.convertMapToObj(MapUtils.toReplaceKeyLow(map), FromProcureTemplateInfoVO.class);
+ procureTemplateInfoList.add(procureTemplateInfoVO);
+ }
+ fromProcureVO.setFromProcureTemplateInfoList(procureTemplateInfoList);
+
+ result.add(fromProcureVO);
});
}
try {
Field fieldDatas = GenericPager.class.getDeclaredField("datas");
fieldDatas.setAccessible(true);
- fieldDatas.set(genericPager, newDatas);
+ fieldDatas.set(genericPager, result);
} catch (Exception e) {
e.printStackTrace();
}
-// genericPager.setDatas(newDatas);
return ResponseValue.success(genericPager);
}
@@ -281,8 +329,8 @@
return ResponseValue.error("閲囪喘鍗昳d涓虹┖");
}
LWhFormProcure lWhFormProcure = lWhFormProcureService.get(new LWhFormProcure(id));
- LWhFormProcureExtend formProcureExtend = new LWhFormProcureExtend();
- BeanUtils.copyProperties(lWhFormProcure, formProcureExtend);
+ LWhFormProcureExtendVO lWhFormProcureExtendVO = new LWhFormProcureExtendVO();
+ BeanUtils.copyProperties(lWhFormProcure, lWhFormProcureExtendVO);
// 鐗╁搧
LWhFormProcureGoods lWhFormProcureGoods = new LWhFormProcureGoods();
@@ -291,24 +339,51 @@
Field fieldModels = null;
try {
- fieldModels = LWhFormProcureGoodsParams.class.getDeclaredField("models");
+ fieldModels = LWhFormProcureGoodsVO.class.getDeclaredField("models");
} catch (NoSuchFieldException e) {
e.printStackTrace();
}
fieldModels.setAccessible(true);
- ArrayList<LWhFormProcureGoodsParams> procureGoodsParams = new ArrayList<>();
+ ArrayList<LWhFormProcureGoodsVO> procureGoodsVOList = new ArrayList<>();
for (LWhFormProcureGoods formProcureGood : formProcureGoods) {
- LWhFormProcureGoodsParams lWhFormProcureGoodsParams = new LWhFormProcureGoodsParams();
- BeanUtils.copyProperties(formProcureGood, lWhFormProcureGoodsParams);
+ LWhFormProcureGoodsVO lWhFormProcureGoodsVO = new LWhFormProcureGoodsVO();
+ BeanUtils.copyProperties(formProcureGood, lWhFormProcureGoodsVO);
+ Long baseGoodsTemplateId = formProcureGood.getBaseGoodsTemplateId();
+ BaseGoodsTemplate queryEntity = new BaseGoodsTemplate();
+ queryEntity.setId(baseGoodsTemplateId);
+ BaseGoodsTemplate baseGoodsTemplate = baseGoodsTemplateService.get(queryEntity);
+ lWhFormProcureGoodsVO.setBaseCategoryName(baseGoodsTemplate.getCategoryName());
// 鏌ヨ鍨嬪彿鏁伴噺
- LWhProcureModel lWhProcureModel = new LWhProcureModel();
- lWhProcureModel.setFromProcureGoodsId(formProcureGood.getId());
- List<LWhProcureModel> models = lWhProcureModelService.select(lWhProcureModel);
- fieldModels.set(lWhFormProcureGoodsParams, models);
- procureGoodsParams.add(lWhFormProcureGoodsParams);
+ Map<String, Object> paramMap = new HashMap<>();
+ paramMap.put("formProcureGoodId", formProcureGood.getId());
+ String sql = "SELECT\n" + "pm.BASE_GOODS_MODELS_ID,pm.BASE_GOODS_MODELS_NAME,pm.PRICE,pm.COUNTS,pm.WOREHOUSE_COUNT,bgm.unit " + "FROM\n"
+ + "\tl_wh_procure_model pm\n"
+ + "\tLEFT JOIN base_goods_models bgm on pm.BASE_GOODS_MODELS_ID = bgm.id where pm.FROM_PROCURE_GOODS_ID =:formProcureGoodId";
+ List<Map<String, Object>> procureModelList = lWhProcureModelService.select(sql, paramMap, new MapperUtil());
+ List<GoodsModelVO> goodsModelVOList = Lists.newArrayList();
+ procureModelList.forEach(item -> {
+ GoodsModelVO goodsModelVO = MapUtils.convertMapToObj(item, GoodsModelVO.class);
+ goodsModelVOList.add(goodsModelVO);
+ });
+ fieldModels.set(lWhFormProcureGoodsVO, goodsModelVOList);
+ procureGoodsVOList.add(lWhFormProcureGoodsVO);
}
- formProcureExtend.setProcureGoods(procureGoodsParams);
- return ResponseValue.success("鏌ヨ鎴愬姛!", formProcureExtend);
+ lWhFormProcureExtendVO.setProcureGoods(procureGoodsVOList);
+ return ResponseValue.success("鏌ヨ鎴愬姛!", lWhFormProcureExtendVO);
+ }
+
+
+ @ApiOperation(value = "閲囪喘鍗曟槑缁嗘煡璇�", notes = "閲囪喘鍗曟槑缁嗘煡璇�")
+ @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "閲囪喘鍗曟槑缁嗘煡璇�", required = true, dataType = "FormProcureQryDto", paramType = "query")})
+ @GetMapping("detail/list")
+ public ResponseValue queryFormProcureDetailList(FormProcureQryDto param) {
+ S_user_core currentUser = this.getCurrentUser();
+ if (currentUser == null) {
+ return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�");
+ }
+
+ GenericPager genericPager = lWhFormProcureService.queryFormProcureDetailList(param);
+ return ResponseValue.success(genericPager);
}
}
--
Gitblit v1.9.1