package cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock; import cn.hutool.core.collection.CollUtil; import cn.iocoder.yudao.framework.apilog.core.annotation.ApiAccessLog; import cn.iocoder.yudao.framework.common.pojo.CommonResult; import cn.iocoder.yudao.framework.common.pojo.PageParam; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.common.util.collection.MapUtils; 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.materialstock.vo.MesWmMaterialStockAdjustReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockPageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockRespVO; import cn.iocoder.yudao.module.mes.controller.admin.wm.materialstock.vo.MesWmMaterialStockFreezeReqVO; 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.md.vendor.MesMdVendorDO; import cn.iocoder.yudao.module.mes.dal.dataobject.wm.materialstock.MesWmMaterialStockDO; 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.md.vendor.MesMdVendorService; import cn.iocoder.yudao.module.mes.service.wm.materialstock.MesWmMaterialStockService; 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 java.io.IOException; import java.math.BigDecimal; import java.util.Collections; import java.util.List; import java.util.Map; import java.util.stream.Collectors; import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT; import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success; import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet; @Tag(name = "管理后台 - MES 库存台账") @RestController @RequestMapping("/mes/wm/material-stock") @Validated public class MesWmMaterialStockController { @Resource private MesWmMaterialStockService materialStockService; @Resource private MdmItemApi mdmItemApi; @Resource private MdmUnitMeasureApi mdmUnitMeasureApi; @Resource private MesWmWarehouseService warehouseService; @Resource private MesWmWarehouseLocationService locationService; @Resource private MesWmWarehouseAreaService areaService; @Resource private MesMdVendorService vendorService; @GetMapping("/get") @Operation(summary = "获得库存记录") @Parameter(name = "id", description = "编号", required = true, example = "1024") @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:query')") public CommonResult getMaterialStock(@RequestParam("id") Long id) { MesWmMaterialStockDO stock = materialStockService.getMaterialStock(id); if (stock == null) { return success(null); } return success(buildRespVOList(Collections.singletonList(stock)).get(0)); } @GetMapping("/page") @Operation(summary = "获得库存台账分页") @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:query')") public CommonResult> getMaterialStockPage( @Valid MesWmMaterialStockPageReqVO pageReqVO) { PageResult pageResult = materialStockService.getMaterialStockPage(pageReqVO); return success(new PageResult<>(buildRespVOList(pageResult.getList()), pageResult.getTotal())); } @PutMapping("/update-frozen") @Operation(summary = "更新库存冻结状态") @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:update')") public CommonResult updateMaterialStockFrozen( @Valid @RequestBody MesWmMaterialStockFreezeReqVO updateReqVO) { materialStockService.updateMaterialStockFrozen(updateReqVO); return success(true); } @PostMapping("/adjust-in") @Operation(summary = "自定义入库") @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:adjust')") public CommonResult adjustMaterialStockIn(@Valid @RequestBody MesWmMaterialStockAdjustReqVO reqVO) { return success(materialStockService.adjustMaterialStockIn(reqVO)); } @PostMapping("/adjust-out") @Operation(summary = "自定义出库") @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:adjust')") public CommonResult adjustMaterialStockOut(@Valid @RequestBody MesWmMaterialStockAdjustReqVO reqVO) { return success(materialStockService.adjustMaterialStockOut(reqVO)); } @GetMapping("/export-excel") @Operation(summary = "导出库存台账 Excel") @PreAuthorize("@ss.hasPermission('mes:wm-material-stock:export')") @ApiAccessLog(operateType = EXPORT) public void exportMaterialStockExcel(@Valid MesWmMaterialStockPageReqVO pageReqVO, HttpServletResponse response) throws IOException { pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE); PageResult pageResult = materialStockService.getMaterialStockPage(pageReqVO); ExcelUtils.write(response, "库存台账.xls", "数据", MesWmMaterialStockRespVO.class, buildRespVOList(pageResult.getList())); } // ==================== 拼接 VO ==================== private List buildRespVOList(List list) { if (CollUtil.isEmpty(list)) { return Collections.emptyList(); } // 1. 获得关联数据 Map itemMap = mdmItemApi.getItemMap( convertSet(list, MesWmMaterialStockDO::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, MesWmMaterialStockDO::getWarehouseId)); Map locationMap = locationService.getWarehouseLocationMap( convertSet(list, MesWmMaterialStockDO::getLocationId)); Map areaMap = areaService.getWarehouseAreaMap( convertSet(list, MesWmMaterialStockDO::getAreaId)); Map vendorMap = vendorService.getVendorMap( convertSet(list, MesWmMaterialStockDO::getVendorId)); // 2. 构建结果 return BeanUtils.toBean(list, MesWmMaterialStockRespVO.class, vo -> { MapUtils.findAndThen(itemMap, vo.getItemId(), item -> { vo.setItemCode(item.getCode()).setItemName(item.getName()).setSpecification(item.getSpecification()); MapUtils.findAndThen(unitMeasureMap, item.getUnitMeasureId(), unitMeasure -> vo.setUnitMeasureName(unitMeasure.getName())); }); MapUtils.findAndThen(warehouseMap, vo.getWarehouseId(), warehouse -> vo.setWarehouseCode(warehouse.getCode()).setWarehouseName(warehouse.getName())); MapUtils.findAndThen(locationMap, vo.getLocationId(), location -> vo.setLocationName(location.getName())); MapUtils.findAndThen(areaMap, vo.getAreaId(), area -> vo.setAreaName(area.getName())); MapUtils.findAndThen(vendorMap, vo.getVendorId(), vendor -> vo.setVendorName(vendor.getName())); // 计算可用量 = 在库数量 - 冻结数量 - 占用量 BigDecimal quantity = vo.getQuantity() != null ? vo.getQuantity() : BigDecimal.ZERO; BigDecimal frozenQty = vo.getFrozenQuantity() != null ? vo.getFrozenQuantity() : BigDecimal.ZERO; BigDecimal reservedQty = vo.getReservedQuantity() != null ? vo.getReservedQuantity() : BigDecimal.ZERO; vo.setAvailableQuantity(quantity.subtract(frozenQty).subtract(reservedQty)); }); } }