From 07ef5e332c8184c4fc6e6c02343eb1b49cbc07e3 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期六, 02 十二月 2023 20:59:50 +0800 Subject: [PATCH] feat: 物品报废 --- consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryController.java | 70 ++++++++++++++++++++++++++++------ 1 files changed, 57 insertions(+), 13 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..0a6772f 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 @@ -1,8 +1,11 @@ package com.consum.base.controller; +import cn.afterturn.easypoi.excel.ExcelExportUtil; +import cn.afterturn.easypoi.excel.entity.TemplateExportParams; import com.consum.base.BaseController; import com.consum.base.core.utils.CommonUtil; import com.consum.base.core.utils.PageUtil; +import com.consum.base.pojo.excel.InventoryExcelTemplate; import com.consum.base.pojo.query.LWhFormInventoryQry; import com.consum.base.pojo.request.FormInventoryParam; import com.consum.base.pojo.request.LWhFormInventoryParam; @@ -10,19 +13,26 @@ import com.consum.base.pojo.response.FormInventoryGoodsVO; import com.consum.base.pojo.response.FormInventoryVO; import com.consum.base.service.FinSysTenantUserServiceImpl; -import com.consum.base.service.LWhFormInventoryServiceImpl; +import com.consum.base.service.LWhFormInventoryService; import com.consum.model.po.FinSysTenantUser; import com.consum.model.po.LWhFormInventory; 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 io.swagger.annotations.Api; import io.swagger.annotations.ApiImplicitParam; import io.swagger.annotations.ApiImplicitParams; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiResponse; +import java.util.HashMap; import java.util.List; +import java.util.Map; import java.util.Objects; +import java.util.Optional; +import javax.servlet.http.HttpServletResponse; +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.DeleteMapping; @@ -42,7 +52,7 @@ public class LWhFormInventoryController extends BaseController { @Autowired - private LWhFormInventoryServiceImpl lWhFormInventoryService; + private LWhFormInventoryService lWhFormInventoryService; @Autowired private FinSysTenantUserServiceImpl finSysTenantUserService; @@ -76,7 +86,7 @@ FinSysTenantUser monitorUserInfo = new FinSysTenantUser(); monitorUserInfo.setId(param.getMonitorUserId()); FinSysTenantUser monitorUser = finSysTenantUserService.get(monitorUserInfo); - int result = this.lWhFormInventoryService.add(param, this.getSysInfo(), operatorUser, monitorUser); + int result = lWhFormInventoryService.add(param, this.getSysInfo(), operatorUser, monitorUser); if (result > 0) { return ResponseValue.success(); } @@ -103,7 +113,7 @@ if (sysInfo == null) { return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�"); } - GenericPager<LWhFormInventory> pager = this.lWhFormInventoryService.queryList(param, sysInfo); + GenericPager<LWhFormInventory> pager = lWhFormInventoryService.queryList(param, sysInfo); return ResponseValue.success(pager); } @@ -121,10 +131,12 @@ if (id == null) { return ResponseValue.error("鍙傛暟涓嶈兘涓虹┖"); } - FormInventoryVO formInventoryVO = this.lWhFormInventoryService.queryInventBaseGoodTemplate(id); + //閫氳繃鏈烘瀯鏌ヨ鐩稿叧鐨勬ā鏉夸俊鎭� + FormInventoryVO formInventoryVO = lWhFormInventoryService.queryInventBaseGoodTemplate(id); - this.lWhFormInventoryService.saveInventory(formInventoryVO, id); - return ResponseValue.success(formInventoryVO); + // 淇濆瓨鍚庤繑鍥炶褰曚俊鎭� + FormInventoryVO result = lWhFormInventoryService.saveInventory(formInventoryVO, id); + return ResponseValue.success(result); } /** @@ -163,7 +175,7 @@ FinSysTenantUser monitorUserInfo = new FinSysTenantUser(); monitorUserInfo.setId(param.getMonitorUserId()); FinSysTenantUser monitorUser = finSysTenantUserService.get(monitorUserInfo); - int result = this.lWhFormInventoryService.add(param, this.getSysInfo(), operatorUser, monitorUser); + int result = lWhFormInventoryService.add(param, this.getSysInfo(), operatorUser, monitorUser); if (result > 0) { return ResponseValue.success(); @@ -221,7 +233,7 @@ return ResponseValue.error("鍙傛暟閿欒"); } - int num = this.lWhFormInventoryService.updateInventoryInfo(param, 1, null, null); + int num = lWhFormInventoryService.updateInventoryInfo(param, 1, null, null); return num > 0 ? ResponseValue.success(1) : ResponseValue.error("鏆傚瓨澶辫触锛�"); } @@ -247,7 +259,7 @@ } S_user_core currentUser = this.getCurrentUser(); FinSysTenantUser sysInfo = this.getSysInfo(); - int num = this.lWhFormInventoryService.updateInventoryInfo(param, 2, currentUser, sysInfo); + int num = lWhFormInventoryService.updateInventoryInfo(param, 2, currentUser, sysInfo); return num > 0 ? ResponseValue.success(1) : ResponseValue.error("鐩樼偣澶辫触锛�"); } @@ -272,7 +284,7 @@ if (sysInfo == null) { return ResponseValue.error("鐧诲綍鐢ㄦ埛淇℃伅涓嶅瓨鍦�"); } - PageUtil<FormInventoryDetailVO> result = this.lWhFormInventoryService.queryPdDetailList(param, sysInfo); + PageUtil<FormInventoryDetailVO> result = lWhFormInventoryService.queryPdDetailList(param, sysInfo); return ResponseValue.success(result); } @@ -290,16 +302,48 @@ LWhFormInventory lWhFormInventory = new LWhFormInventory(); lWhFormInventory.setId(id); - LWhFormInventory item = this.lWhFormInventoryService.get(lWhFormInventory); + LWhFormInventory item = lWhFormInventoryService.get(lWhFormInventory); if (Objects.isNull(item)) { return ResponseValue.error("鐩樼偣鍗曚笉瀛樺湪"); } BeanUtils.copyProperties(item, formInventoryVO); - List<FormInventoryGoodsVO> formInventoryGoodsVOS = this.lWhFormInventoryService.selectDetailById(id); + List<FormInventoryGoodsVO> formInventoryGoodsVOS = lWhFormInventoryService.selectDetailById(id); formInventoryVO.setFormInventoryGoodsList(formInventoryGoodsVOS); return ResponseValue.success(formInventoryVO); } + @ApiOperation(value = "鐩樼偣鍗曞鍑�", notes = "鐩樼偣鍗曞鍑�") + @ApiImplicitParams({ + @ApiImplicitParam(name = "id", value = "鐩樼偣鍗昳d", dataType = "Long", required = true, paramType = "query") + }) + @GetMapping("/list/export") + public void export(Long id, HttpServletResponse response) throws Exception { + + List<InventoryExcelTemplate> exportList = lWhFormInventoryService.getExportList(id); + if (CollectionUtils.isEmpty(exportList)) { + throw new RuntimeException("鏁版嵁涓虹┖"); + } + TemplateExportParams params = new TemplateExportParams("import/浣庡�兼槗鑰楀搧鐩樼偣琛�.xls"); + params.setHeadingStartRow(2); + + Optional<InventoryExcelTemplate> first = exportList.stream().findFirst(); + InventoryExcelTemplate inventoryExcelTemplate = first.get(); + Long createTime = inventoryExcelTemplate.getCreateTime(); + String operatorName = inventoryExcelTemplate.getOperatorName(); + String monitorName = inventoryExcelTemplate.getMonitorName(); + Long endTime = inventoryExcelTemplate.getEndTime(); + + Map<String, Object> map = new HashMap<>(); + map.put("date", DateUtils.toShowDate(createTime)); + map.put("endDate", DateUtils.toShowDate(endTime)); + map.put("monitorName", monitorName); + map.put("name", operatorName); + Workbook workbook = ExcelExportUtil.exportExcel(params, InventoryExcelTemplate.class, + exportList, map); + + downLoadExcel("浣庡�兼槗鑰楀搧鐩樼偣琛�", response, workbook); + } + } -- Gitblit v1.9.1