package cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task; import cn.hutool.core.collection.CollUtil; import cn.iocoder.yudao.framework.common.pojo.CommonResult; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.common.util.object.BeanUtils; import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils; import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.line.MesWmStockTakingTaskLineImportExcelVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.line.MesWmStockTakingTaskLineImportRespVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.line.MesWmStockTakingTaskLinePageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.line.MesWmStockTakingTaskLineRespVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.stocktaking.task.vo.line.MesWmStockTakingTaskLineSaveReqVO; import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi; import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.stocktaking.task.MesWmStockTakingTaskLineDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseAreaDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseLocationDO; import cn.iocoder.yudao.module.mdm.api.unit.MdmUnitMeasureApi; import cn.iocoder.yudao.module.mdm.api.unit.dto.MdmUnitMeasureRespDTO; import cn.iocoder.yudao.module.mes.service.wm.stocktaking.task.MesWmStockTakingTaskLineService; import cn.iocoder.yudao.module.mes.service.wm.warehouse.MesWmWarehouseAreaService; import cn.iocoder.yudao.module.mes.service.wm.warehouse.MesWmWarehouseLocationService; import cn.iocoder.yudao.module.mes.service.wm.warehouse.MesWmWarehouseService; import io.swagger.v3.oas.annotations.Operation; import io.swagger.v3.oas.annotations.Parameter; import io.swagger.v3.oas.annotations.tags.Tag; import jakarta.annotation.Resource; import jakarta.servlet.http.HttpServletResponse; import jakarta.validation.Valid; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.validation.annotation.Validated; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import java.io.IOException; import java.util.Collections; import java.util.List; import java.util.Map; import java.util.stream.Collectors; import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success; import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet; import static cn.iocoder.yudao.framework.common.util.collection.MapUtils.findAndThen; @Tag(name = "管理后台 - MES 盘点任务行") @RestController @RequestMapping("/mes/wm/stocktaking-task-line") @Validated public class MesWmStockTakingTaskLineController { @Resource private MesWmStockTakingTaskLineService stockTakingTaskLineService; @Resource private MdmItemApi mdmItemApi; @Resource private MdmUnitMeasureApi mdmUnitMeasureApi; @Resource private MesWmWarehouseService warehouseService; @Resource private MesWmWarehouseLocationService locationService; @Resource private MesWmWarehouseAreaService areaService; @GetMapping("/get") @Operation(summary = "获得盘点任务行") @Parameter(name = "id", description = "编号", required = true) @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:query')") public CommonResult getStockTakingTaskLine(@RequestParam("id") Long id) { MesWmStockTakingTaskLineDO line = stockTakingTaskLineService.getStockTakingTaskLine(id); if (line == null) { return success(null); } return success(buildStockTakingTaskLineRespVOList(Collections.singletonList(line)).get(0)); } @GetMapping("/page") @Operation(summary = "获得盘点任务行分页") @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:query')") public CommonResult> getStockTakingTaskLinePage( @Valid MesWmStockTakingTaskLinePageReqVO pageReqVO) { PageResult pageResult = stockTakingTaskLineService.getStockTakingTaskLinePage(pageReqVO); return success(new PageResult<>(buildStockTakingTaskLineRespVOList(pageResult.getList()), pageResult.getTotal())); } @PostMapping("/create") @Operation(summary = "创建盘点任务行") @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:update')") public CommonResult createStockTakingTaskLine(@Valid @RequestBody MesWmStockTakingTaskLineSaveReqVO createReqVO) { return success(stockTakingTaskLineService.createStockTakingTaskLine(createReqVO)); } @PutMapping("/update") @Operation(summary = "更新盘点任务行") @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:update')") public CommonResult updateStockTakingTaskLine(@Valid @RequestBody MesWmStockTakingTaskLineSaveReqVO updateReqVO) { stockTakingTaskLineService.updateStockTakingTaskLine(updateReqVO); return success(true); } @DeleteMapping("/delete") @Operation(summary = "删除盘点任务行") @Parameter(name = "id", description = "编号", required = true) @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:update')") public CommonResult deleteStockTakingTaskLine(@RequestParam("id") Long id) { stockTakingTaskLineService.deleteStockTakingTaskLine(id); return success(true); } @GetMapping("/simple-list") @Operation(summary = "获得盘点任务行精简列表", description = "根据任务编号查询,主要用于前端的下拉选项") @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:query')") public CommonResult> getStockTakingTaskLineSimpleList( @RequestParam("taskId") Long taskId) { List list = stockTakingTaskLineService.getStockTakingTaskLineListByTaskId(taskId); return success(buildStockTakingTaskLineRespVOList(list)); } @PostMapping("/import-excel") @Operation(summary = "导入盘点实盘数量", description = "按 物料编码 + 批次号 匹配盘点行,写入实盘数量") @Parameter(name = "file", description = "Excel 文件", required = true) @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:update')") public CommonResult importStockTakingQuantity( @RequestParam("taskId") Long taskId, @RequestParam("file") MultipartFile file) throws IOException { List list = ExcelUtils.read(file, MesWmStockTakingTaskLineImportExcelVO.class); return success(stockTakingTaskLineService.importTakingQuantity(taskId, list)); } @GetMapping("/get-import-template") @Operation(summary = "下载盘点导入模板") @PreAuthorize("@ss.hasPermission('mes:wm-stock-taking-task:query')") public void getImportTemplate(HttpServletResponse response) throws IOException { ExcelUtils.write(response, "盘点实盘数导入模板.xls", "实盘数", MesWmStockTakingTaskLineImportExcelVO.class, Collections.emptyList()); } // ==================== 拼接 VO ==================== private List buildStockTakingTaskLineRespVOList(List list) { if (CollUtil.isEmpty(list)) { return Collections.emptyList(); } // 查询关联数据 Map itemMap = mdmItemApi.getItemMap(convertSet(list, MesWmStockTakingTaskLineDO::getItemId)); Map unitMeasureMap = mdmUnitMeasureApi.getUnitMeasureList( convertSet(itemMap.values(), MdmItemRespDTO::getUnitMeasureId)).getCheckedData() .stream().collect(Collectors.toMap(MdmUnitMeasureRespDTO::getId, e -> e)); Map warehouseMap = warehouseService.getWarehouseMap( convertSet(list, MesWmStockTakingTaskLineDO::getWarehouseId)); Map locationMap = locationService.getWarehouseLocationMap( convertSet(list, MesWmStockTakingTaskLineDO::getLocationId)); Map areaMap = areaService.getWarehouseAreaMap( convertSet(list, MesWmStockTakingTaskLineDO::getAreaId)); // 拼接 VO return BeanUtils.toBean(list, MesWmStockTakingTaskLineRespVO.class, vo -> { findAndThen(itemMap, vo.getItemId(), item -> { vo.setItemCode(item.getCode()).setItemName(item.getName()).setSpecification(item.getSpecification()); findAndThen(unitMeasureMap, item.getUnitMeasureId(), unitMeasure -> vo.setUnitMeasureName(unitMeasure.getName())); }); findAndThen(warehouseMap, vo.getWarehouseId(), warehouse -> vo.setWarehouseName(warehouse.getName())); findAndThen(locationMap, vo.getLocationId(), location -> vo.setLocationName(location.getName())); findAndThen(areaMap, vo.getAreaId(), area -> vo.setAreaName(area.getName())); }); } }