From 87ff2a60723119530d071f6ed6b16fc2f3f023ca Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期二, 05 十二月 2023 16:32:05 +0800
Subject: [PATCH] 报废单导出金额信息

---
 consum-base/src/main/java/com/consum/base/controller/LWhFormOutputController.java |  201 ++++++++++++++++++++++++++++++-------------------
 1 files changed, 123 insertions(+), 78 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/controller/LWhFormOutputController.java b/consum-base/src/main/java/com/consum/base/controller/LWhFormOutputController.java
index 5d0b7c4..1de90ad 100644
--- a/consum-base/src/main/java/com/consum/base/controller/LWhFormOutputController.java
+++ b/consum-base/src/main/java/com/consum/base/controller/LWhFormOutputController.java
@@ -1,39 +1,57 @@
 package com.consum.base.controller;
 
-import com.consum.base.BaseController;
-import com.consum.base.core.utils.CommonUtil;
-import com.consum.base.core.utils.MapUtils;
-import com.consum.base.pojo.LWhFormOutputExtend;
-import com.consum.base.pojo.LWhFormOutputInsertParam;
-import com.consum.base.pojo.query.LWhFormOutputQry;
-import com.consum.base.pojo.response.FormOutputGoodsVO;
-import com.consum.base.pojo.response.FormOutputTemplateInfoVO;
-import com.consum.base.pojo.response.FormOutputVO;
-import com.consum.base.pojo.response.GoodsModelVO;
-import com.consum.base.pojo.response.LWhFormOutputExtendVO;
-import com.consum.base.service.LWhFormOutputServiceImpl;
-import com.consum.base.service.LWhGoodsService;
-import com.consum.base.service.LWhProcureModelService;
-import com.consum.model.po.LWhFormOutput;
-import com.iplatform.model.po.S_user_core;
-import com.walker.db.page.GenericPager;
-import com.walker.infrastructure.utils.CollectionUtils;
-import com.walker.web.ResponseValue;
-import io.swagger.annotations.Api;
-import io.swagger.annotations.ApiImplicitParam;
-import io.swagger.annotations.ApiImplicitParams;
-import io.swagger.annotations.ApiOperation;
+import java.io.InputStream;
 import java.lang.reflect.Field;
 import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
+import java.util.Optional;
+
+import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
+
 import org.apache.commons.compress.utils.Lists;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
+import org.apache.poi.ss.usermodel.Workbook;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.core.io.ClassPathResource;
 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;
+
+import com.consum.base.BaseController;
+import com.consum.base.core.utils.CommonUtil;
+import com.consum.base.core.utils.MapUtils;
+import com.consum.base.core.utils.MapperUtil;
+import com.consum.base.core.utils.PageUtil;
+import com.consum.base.pojo.LWhFormOutputParam;
+import com.consum.base.pojo.excel.OutputExcelTemplate;
+import com.consum.base.pojo.query.LWhFormOutputQry;
+import com.consum.base.pojo.response.FormOutputGoodsVO;
+import com.consum.base.pojo.response.FormOutputVO;
+import com.consum.base.pojo.response.GoodsModelVO;
+import com.consum.base.pojo.response.GoodsTemplateCountVO;
+import com.consum.base.pojo.response.LWhFormOutputExtendVO;
+import com.consum.base.service.LWarehouseFlowService;
+import com.consum.base.service.LWhFormOutputService;
+import com.consum.base.service.LWhProcureModelService;
+import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.LWhFormOutput;
+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.web.ResponseValue;
+
+import cn.afterturn.easypoi.excel.ExcelExportUtil;
+import cn.afterturn.easypoi.excel.entity.TemplateExportParams;
+import cn.hutool.core.util.ReflectUtil;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiImplicitParam;
+import io.swagger.annotations.ApiImplicitParams;
+import io.swagger.annotations.ApiOperation;
 
 /**
  * @Description 鍑哄簱鍗�
@@ -46,11 +64,11 @@
 public class LWhFormOutputController extends BaseController {
 
     @Autowired
-    private LWhFormOutputServiceImpl lWhFormOutputService;
+    private LWhFormOutputService lWhFormOutputService;
     @Autowired
     private LWhProcureModelService lWhProcureModelService;
-    @Autowired
-    private LWhGoodsService lWhGoodsService;
+    @Resource
+    private LWarehouseFlowService lWarehouseFlowService;
 
     /**
      * @Description 鏂板鍑哄簱鍗�
@@ -58,12 +76,11 @@
      * @Date 2023/10/27
      */
     @ApiOperation(value = "鏂板鍑哄簱鍗�", notes = "鏂板鍑哄簱鍗�")
-    @ApiImplicitParams({
-        @ApiImplicitParam(name = "param", value = "鍑哄簱鍗曞疄浣�", required = true, dataType = "LWhFormOutputInsertParam", paramType = "body")
-    })
+    @ApiImplicitParams({@ApiImplicitParam(name = "param", value = "鍑哄簱鍗曞疄浣�", dataType = "lWhFormOutputParam",
+        dataTypeClass = LWhFormOutputParam.class, paramType = "body")})
     @PostMapping("/add")
     public ResponseValue add() {
-        LWhFormOutputInsertParam param = CommonUtil.getObjFromReqBody(LWhFormOutputInsertParam.class);
+        LWhFormOutputParam param = CommonUtil.getObjFromReqBody(LWhFormOutputParam.class);
         S_user_core currentUser = this.getCurrentUser();
         if (currentUser == null) {
             return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�");
@@ -79,7 +96,8 @@
      * @Description 鍒楄〃鏌ヨ
      */
     @ApiOperation(value = "鍒楄〃鏌ヨ", notes = "鍒楄〃鏌ヨ")
-    @ApiImplicitParam(name = "param", value = "鍑哄簱鍗曞疄浣�", required = true, dataType = "LWhFormOutputParam", paramType = "query")
+    @ApiImplicitParam(name = "param", value = "鍑哄簱鍗曞疄浣�", required = true, dataType = "LWhFormOutputParam",
+        paramType = "query")
     @GetMapping("/list")
     public ResponseValue queryFormOutputList() {
         LWhFormOutputQry param = CommonUtil.getObjFromReq(LWhFormOutputQry.class);
@@ -87,42 +105,36 @@
         if (currentUser == null) {
             return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�");
         }
-
+        /*褰撳墠鐧诲綍浜哄彧鑳界湅鍒拌嚜宸辨満鏋勪笅鐨勫垪琛�*/
+        FinSysTenantUser sysInfo = this.getSysInfo();
+        String tenantId = sysInfo.getTenantId();
+        if (param.getAgencyId() == null) {
+            param.setAgencyId(Long.valueOf(tenantId));
+        }
         GenericPager genericPager = lWhFormOutputService.queryFormOutputList(param);
         List<LWhFormOutput> data = genericPager.getDatas();
 
         List<FormOutputVO> resultList = Lists.newArrayList();
         if (!CollectionUtils.isEmpty(data)) {
             data.forEach(item -> {
-                // 鏌ヨ鍨嬪彿鏁伴噺
                 FormOutputVO formOutputVO = new FormOutputVO();
                 BeanUtils.copyProperties(item, formOutputVO);
 
-                List<FormOutputTemplateInfoVO> procureTemplateInfoList = Lists.newArrayList();
-
-                // 鏌ヨ鍨嬪彿鏁伴噺
-                String sql = "SELECT bgt.id,bgm.GOODS_TEMPLATES_ID,GOODS_NAME,sum( counts ) count FROM "
-                    + "l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON pm.BASE_GOODS_MODELS_ID = bgm.id "
-                    + "LEFT JOIN base_goods_template bgt ON bgm.GOODS_TEMPLATES_ID = bgt.id "
-                    + "WHERE pm.BUSINESS_ID =:id GROUP BY bgm.GOODS_TEMPLATES_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) {
-                    FormOutputTemplateInfoVO procureTemplateInfoVO = MapUtils.convertMapToObj(MapUtils.toReplaceKeyLow(map), FormOutputTemplateInfoVO.class);
-                    procureTemplateInfoList.add(procureTemplateInfoVO);
-                }
-                formOutputVO.setFormOutputTemplateInfoList(procureTemplateInfoList);
+                // 鏌ヨ鐗╁搧鍨嬪彿缁熻鏁伴噺
+                List<GoodsTemplateCountVO> goodsTemplateCount =
+                    lWhProcureModelService.getGoodsTemplateCountByBusinessId(item.getId());
+                formOutputVO.setFormOutputTemplateInfoList(goodsTemplateCount);
 
                 resultList.add(formOutputVO);
             });
         }
         try {
             Field fieldDatas = GenericPager.class.getDeclaredField("datas");
-            fieldDatas.setAccessible(true);
-            fieldDatas.set(genericPager, resultList);
+            // fieldDatas.setAccessible(true);
+            // fieldDatas.set(genericPager, resultList);
+            ReflectUtil.setFieldValue(genericPager, fieldDatas, resultList);
         } catch (Exception e) {
-            e.printStackTrace();
+            logger.error("鏌ヨ鍑哄簱鍗曞垪琛ㄥけ璐�", e);
         }
         return ResponseValue.success(genericPager);
     }
@@ -139,11 +151,8 @@
         }
         LWhFormOutput lWhFormOutput = lWhFormOutputService.get(new LWhFormOutput(id));
         LWhFormOutputExtendVO lWhFormOutputExtendVO = new LWhFormOutputExtendVO();
-
-        LWhFormOutputExtend formOutputExtend = new LWhFormOutputExtend();
-        BeanUtils.copyProperties(lWhFormOutput, formOutputExtend);
-
         BeanUtils.copyProperties(lWhFormOutput, lWhFormOutputExtendVO);
+        lWhFormOutputExtendVO.setDoc(lWhFormOutput.getOutputDoc());
 
         String sql = "SELECT bgt.id, CATEGORY_ID, CATEGORY_NAME, GOODS_NAME "
             + "FROM l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID "
@@ -151,20 +160,19 @@
             + "WHERE pm.BUSINESS_ID =:id GROUP BY bgt.id ";
         Map<String, Object> paramMap = new HashMap<>();
         paramMap.put("id", lWhFormOutputExtendVO.getId());
-        List<Map<String, Object>> procureModelList = lWhFormOutputService.select(sql, paramMap);
+        List<Map<String, Object>> procureModelList = lWhFormOutputService.select(sql, paramMap, new MapperUtil());
         List<FormOutputGoodsVO> fromOutputGoods = Lists.newArrayList();
         for (Map<String, Object> map : procureModelList) {
-            FormOutputGoodsVO procureTemplateInfoVO = MapUtils.convertMapToObj(MapUtils.toReplaceKeyLow(map), FormOutputGoodsVO.class);
+            FormOutputGoodsVO procureTemplateInfoVO = MapUtils.convertMapToObj(map, FormOutputGoodsVO.class);
 
             // 鏌ヨ鍨嬪彿鏁伴噺
             List<GoodsModelVO> goodsModelVOList = Lists.newArrayList();
             String sql2 = "SELECT pm.id,pm.BASE_GOODS_MODELS_NAME,bgm.UNIT,COUNTS,total_amount "
                 + "FROM l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID "
-                + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID "
-                + "WHERE pm.BUSINESS_ID =:id";
-            List<Map<String, Object>> modelList = lWhFormOutputService.select(sql2, paramMap);
+                + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID " + "WHERE pm.BUSINESS_ID =:id";
+            List<Map<String, Object>> modelList = lWhFormOutputService.select(sql2, paramMap, new MapperUtil());
             modelList.forEach(item -> {
-                GoodsModelVO goodsModelVO = MapUtils.convertMapToObj(MapUtils.toReplaceKeyLow(item), GoodsModelVO.class);
+                GoodsModelVO goodsModelVO = MapUtils.convertMapToObj(item, GoodsModelVO.class);
                 goodsModelVOList.add(goodsModelVO);
             });
             procureTemplateInfoVO.setModels(goodsModelVOList);
@@ -175,24 +183,61 @@
         return ResponseValue.success("鏌ヨ鎴愬姛!", lWhFormOutputExtendVO);
     }
 
-    /**
-     * @Description 鏍规嵁浠撳簱id鍜屽瀷鍙穒d 鏌ヨ搴撳瓨
-     * @Author 鍗㈠簡闃�
-     * @Date 2023/11/2
-     */
-    @ApiOperation(value = "鏍规嵁浠撳簱id鍜屽瀷鍙穒d 鏌ヨ搴撳瓨", notes = "鏍规嵁浠撳簱id鍜屽瀷鍙穒d 鏌ヨ搴撳瓨")
-    @ApiImplicitParams({
-        @ApiImplicitParam(name = "warehouseId", value = "浠撳簱id", required = true, dataType = "Long", paramType = "query"),
-        @ApiImplicitParam(name = "baseGoodsModelsId", value = "鍨嬪彿id", required = true, dataType = "Long", paramType = "query")
-    })
-    @GetMapping("/select/number")
-    public ResponseValue selectNumber(Long warehouseId, Long baseGoodsModelsId) {
-        if (warehouseId == null || baseGoodsModelsId == null) {
-            return ResponseValue.error("鍙傛暟閿欒");
+    @ApiOperation(value = "鏌ヨ鍑哄簱鍗曡鎯呮槑缁�", notes = "鏌ヨ鍑哄簱鍗曡鎯呮槑缁�")
+    @ApiImplicitParam(name = "formOutputQry", value = "鍑哄簱鍗曡鎯呮煡璇㈡潯浠�", required = true, dataType = "LWhFormOutputQry",
+        paramType = "query")
+    @GetMapping("/detail/list")
+    public ResponseValue queryFormOutputDetailList() {
+        LWhFormOutputQry formOutputQry = CommonUtil.getObjFromReq(LWhFormOutputQry.class);
+        S_user_core currentUser = this.getCurrentUser();
+        if (currentUser == null) {
+            return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�");
         }
-        int num = this.lWhGoodsService.queryGoodsModelNum(0, warehouseId, baseGoodsModelsId, (short) 1, null);
-        return ResponseValue.success(num);
+        PageUtil genericPager = lWarehouseFlowService.queryAllBusinessFlow(formOutputQry);
+        return ResponseValue.success(genericPager);
+    }
+
+    @ApiOperation(value = "鍑哄簱鍗曞鍑�", notes = "鍑哄簱鍗曞鍑�")
+    @ApiImplicitParam(name = "id", value = "鍑哄簱鍗昳d", required = true, dataType = "Long", paramType = "query")
+    @GetMapping("/list/export")
+    public void export(Long id, HttpServletResponse response) throws Exception {
+        FinSysTenantUser sysInfo = this.getSysInfo();
+        if (sysInfo == null) {
+            throw new RuntimeException("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�");
+        }
+        ClassPathResource classPathResource = new ClassPathResource("import/鍑哄簱鍗�.xls");
+        // 鑾峰彇鏂囦欢杈撳叆娴�
+        InputStream inputStream = classPathResource.getInputStream();
+        Workbook wb = new HSSFWorkbook(inputStream);
+        TemplateExportParams params = new TemplateExportParams();
+        params.setTemplateWb(wb);
+        params.setHeadingStartRow(2);
+
+        List<OutputExcelTemplate> exportList = lWhFormOutputService.getExportList(id);
+
+        if (CollectionUtils.isEmpty(exportList)) {
+            throw new RuntimeException("鏁版嵁涓虹┖");
+        }
+        int countNum =
+            exportList.stream().filter(item -> item.getNum() != null).mapToInt(OutputExcelTemplate::getNum).sum();
+        double totalAmount = exportList.stream().filter(item -> item.getTotalAmount() != null)
+            .mapToDouble(OutputExcelTemplate::getAmount).sum();
+        Optional<OutputExcelTemplate> first = exportList.stream().findFirst();
+        OutputExcelTemplate templateExcelExport = first.get();
+        String businessFormCode = templateExcelExport.getBusinessFormCode();
+        Long createTime = templateExcelExport.getCreateTime();
+        String operatorName = templateExcelExport.getOperatorName();
+
+        Map<String, Object> map = new HashMap<>();
+        map.put("code", businessFormCode);
+        map.put("date", DateUtils.toShowDate(createTime));
+        map.put("name", operatorName);
+        map.put("countNum", countNum);
+        map.put("totalAmount", totalAmount);
+
+        Workbook workbook = ExcelExportUtil.exportExcel(params, OutputExcelTemplate.class, exportList, map);
+        downLoadExcel("鍑哄簱鍗�", response, workbook);
+
     }
 
 }
-

--
Gitblit v1.9.1