From edc87e2fc3760cd7d1230bc058acf5620ea2c465 Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期六, 02 十二月 2023 15:03:15 +0800
Subject: [PATCH] 部门分发添加,分发单型号查询
---
consum-base/src/main/java/com/consum/base/controller/LWhFormTransferController.java | 88 +++++++++++++++++++++++++++++++------------
1 files changed, 63 insertions(+), 25 deletions(-)
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 d7c0e2c..fc14402 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
@@ -1,5 +1,7 @@
package com.consum.base.controller;
+import cn.afterturn.easypoi.excel.ExcelExportUtil;
+import cn.afterturn.easypoi.excel.entity.TemplateExportParams;
import cn.hutool.core.util.ReflectUtil;
import com.consum.base.BaseController;
import com.consum.base.core.utils.CommonUtil;
@@ -11,17 +13,18 @@
import com.consum.base.pojo.RecordUserInfoVO;
import com.consum.base.pojo.UseRecordSkuVO;
import com.consum.base.pojo.dto.UseRecordDTO;
+import com.consum.base.pojo.excel.TransferExcelTemplate;
import com.consum.base.pojo.query.TransferQry;
import com.consum.base.pojo.request.LWhFormTransferParam;
import com.consum.base.pojo.request.ProcureModelInfoParam;
+import com.consum.base.pojo.request.RecordInfoParam;
import com.consum.base.pojo.response.FormTransferVO;
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.BaseGoodsModelsServiceImpl;
import com.consum.base.service.BaseWarehouseServiceImpl;
import com.consum.base.service.LWhFormTransferCoreService;
-import com.consum.base.service.LWhFormTransferServiceImpl;
+import com.consum.base.service.LWhFormTransferService;
import com.consum.base.service.LWhProcureModelService;
import com.consum.base.service.LWhProcureModelUserRecordServiceImpl;
import com.consum.base.service.LWhProcureModelUserServiceImpl;
@@ -30,7 +33,6 @@
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;
import com.walker.infrastructure.utils.CollectionUtils;
@@ -42,12 +44,15 @@
import io.swagger.annotations.ApiOperation;
import java.lang.reflect.Field;
import java.util.ArrayList;
+import java.util.Comparator;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Optional;
import java.util.stream.Collectors;
+import javax.servlet.http.HttpServletResponse;
import org.apache.commons.compress.utils.Lists;
+import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
@@ -66,7 +71,7 @@
public class LWhFormTransferController extends BaseController {
@Autowired
- private LWhFormTransferServiceImpl lWhFormTransferService;
+ private LWhFormTransferService lWhFormTransferService;
@Autowired
private LWhProcureModelService lWhProcureModelService;
@Autowired
@@ -75,8 +80,6 @@
private LWhProcureModelUserServiceImpl lWhProcureModelUserService;
@Autowired
private LWhProcureModelUserRecordServiceImpl lWhProcureModelUserRecordService;
- @Autowired
- private BaseGoodsModelsServiceImpl baseGoodsModelsService;
@Autowired
private BaseWarehouseServiceImpl baseWarehouseService;
@@ -296,18 +299,47 @@
return ResponseValue.success();
}
- /**
- * @Description 瀵煎嚭璋冩嫧鍑哄簱鍗�
- * @Author 鍗㈠簡闃�
- * @Date 2023/10/31
- */
- @GetMapping("/export")
- public ResponseValue export(Long id) {
- if (id == null) {
- return ResponseValue.error("璋冩嫧鍗昳d涓虹┖");
+
+ @ApiOperation(value = "璋冩嫧鍗曞鍑�", notes = "璋冩嫧鍗曞鍑�")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "id", value = "璋冩嫧鍗昳d", required = true, dataType = "Long"),
+ @ApiImplicitParam(name = "type", value = "瀵煎嚭绫诲瀷 1 鍏ュ簱 2 鍑哄簱", required = true, dataType = "Integer"),
+ })
+ @GetMapping("/list/export")
+ public void export(Long id, Integer type, HttpServletResponse response) throws Exception {
+
+ TemplateExportParams params;
+ String fileName;
+ if (type == 1) {
+ params = new TemplateExportParams("import/璋冩嫧鍏ュ簱鍗�.xls");
+ fileName = "璋冩嫧鍏ュ簱鍗�";
+ } else {
+ params = new TemplateExportParams("import/璋冩嫧鍑哄簱鍗�.xls");
+ fileName = "璋冩嫧鍑哄簱鍗�";
}
- LWhFormOutputVo vo = this.lWhFormTransferService.export(id, this.getCurrentUser());
- return ResponseValue.success(vo);
+ params.setHeadingStartRow(2);
+ List<TransferExcelTemplate> export = this.lWhFormTransferService.export(id, type);
+
+ int countNum = export.stream().filter(item -> item.getNum() != null).mapToInt(TransferExcelTemplate::getNum).sum();
+ int totalAmount = export.stream().filter(item -> item.getTotalAmount() != null).mapToInt(TransferExcelTemplate::getTotalAmount).sum();
+ Optional<TransferExcelTemplate> first = export.stream().findFirst();
+ TransferExcelTemplate entity = first.get();
+ String businessFormCode = entity.getBusinessFormCode();
+ Long createTime = entity.getCreateTime();
+ String operatorName = entity.getOperatorName();
+ String tenantName = entity.getTenantName();
+
+ Map<String, Object> map = new HashMap<>();
+ map.put("code", businessFormCode);
+ map.put("date", DateUtils.toShowDate(createTime));
+ map.put("tenantName", tenantName);
+ map.put("name", operatorName);
+ map.put("countNum", countNum);
+ map.put("totalAmount", totalAmount);
+
+ Workbook workbook = ExcelExportUtil.exportExcel(params, TransferExcelTemplate.class, export, map);
+ downLoadExcel(fileName, response, workbook);
+
}
@@ -344,19 +376,20 @@
@PostMapping("/useInfo/update")
public ResponseValue infoUpdate() {
- List<ProcureModelInfoParam> param = CommonUtil.getObjFromReqBody(List.class);
- List<ProcureModelInfoParam> procureModelInfoParam = Lists.newArrayList();
- procureModelInfoParam.addAll(param);
+ RecordInfoParam param = CommonUtil.getObjFromReqBody(RecordInfoParam.class);
+ RecordInfoParam recordInfoParam = new RecordInfoParam();
+ CommonUtil.copyProperties(param, recordInfoParam);
+ param = recordInfoParam;
S_user_core currentUser = this.getCurrentUser();
if (currentUser == null) {
return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�");
}
- if (CollectionUtils.isEmpty(procureModelInfoParam)) {
+ if (CollectionUtils.isEmpty(param.getRecordInfoList())) {
return ResponseValue.error("鍙傛暟閿欒");
}
- Map<Long, List<ProcureModelInfoParam>> collect = procureModelInfoParam.stream()
+ Map<Long, List<ProcureModelInfoParam>> collect = param.getRecordInfoList().stream()
.collect(Collectors.groupingBy(ProcureModelInfoParam::getBaseGoodModelId));
for (Map.Entry<Long, List<ProcureModelInfoParam>> entry : collect.entrySet()) {
Long baseGoodModelId = entry.getKey();
@@ -375,7 +408,7 @@
lWhProcureModelUserRecordService.insert(lWhProcureModelUserRecord);
List<LWhProcureModelUser> procureModelUserList = Lists.newArrayList();
- if (CollectionUtils.isEmpty(procureModelInfoList)) {
+ if (!CollectionUtils.isEmpty(procureModelInfoList)) {
for (ProcureModelInfoParam item : procureModelInfoList) {
LWhProcureModelUser lWhProcureModelUser = new LWhProcureModelUser();
lWhProcureModelUser.setId(IdUtil.generateId());
@@ -418,7 +451,7 @@
if (CollectionUtils.isEmpty(useRecordDTOList)) {
return ResponseValue.error("鏈煡璇㈠埌浣跨敤璁板綍");
}
- List<GoodsUseRecordVO> result = Lists.newArrayList();
+ List<GoodsUseRecordVO> goodsUseRecordList = Lists.newArrayList();
//鍒嗙粍
Map<Long, Map<Long, List<UseRecordDTO>>> collect = useRecordDTOList.stream()
.collect(Collectors.groupingBy(UseRecordDTO::getId, Collectors.groupingBy(UseRecordDTO::getBaseGoodsModelsId)));
@@ -452,10 +485,15 @@
useRecordSkuVO.setRecordUserInfos(recordUserInfoList);
useRecordSkuList.add(useRecordSkuVO);
goodsUseRecordVO.setRecordSkuDtoList(useRecordSkuList);
- result.add(goodsUseRecordVO);
+ goodsUseRecordList.add(goodsUseRecordVO);
}
}
}
+ //鍒嗙粍涔嬪悗閲嶆柊鎺掑簭
+ List<GoodsUseRecordVO> result = goodsUseRecordList.stream()
+ .sorted(Comparator.comparing(GoodsUseRecordVO::getUpdateTime
+ , Comparator.nullsFirst(Long::compareTo)).reversed())
+ .collect(Collectors.toList());
return ResponseValue.success(result);
}
--
Gitblit v1.9.1