1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
package cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse;
 
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.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.warehouse.vo.area.MesWmWarehouseAreaImportExcelVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.area.MesWmWarehouseAreaImportRespVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.area.MesWmWarehouseAreaPageReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.area.MesWmWarehouseAreaRespVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.area.MesWmWarehouseAreaSaveReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseAreaDO;
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseLocationDO;
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseDO;
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.Parameters;
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 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/warehouse-area")
@Validated
public class MesWmWarehouseAreaController {
 
    @Resource
    private MesWmWarehouseAreaService areaService;
    @Resource
    private MesWmWarehouseLocationService locationService;
    @Resource
    private MesWmWarehouseService warehouseService;
 
    @PostMapping("/create")
    @Operation(summary = "创建库位")
    @PreAuthorize("@ss.hasPermission('mes:wm-warehouse:create')")
    public CommonResult<Long> createWarehouseArea(@Valid @RequestBody MesWmWarehouseAreaSaveReqVO createReqVO) {
        return success(areaService.createWarehouseArea(createReqVO));
    }
 
    @PutMapping("/update")
    @Operation(summary = "更新库位")
    @PreAuthorize("@ss.hasPermission('mes:wm-warehouse:update')")
    public CommonResult<Boolean> updateWarehouseArea(@Valid @RequestBody MesWmWarehouseAreaSaveReqVO updateReqVO) {
        areaService.updateWarehouseArea(updateReqVO);
        return success(true);
    }
 
    @DeleteMapping("/delete")
    @Operation(summary = "删除库位")
    @Parameter(name = "id", description = "编号", required = true)
    @PreAuthorize("@ss.hasPermission('mes:wm-warehouse:delete')")
    public CommonResult<Boolean> deleteWarehouseArea(@RequestParam("id") Long id) {
        areaService.deleteWarehouseArea(id);
        return success(true);
    }
 
    @GetMapping("/get")
    @Operation(summary = "获得库位")
    @Parameter(name = "id", description = "编号", required = true, example = "1024")
    public CommonResult<MesWmWarehouseAreaRespVO> getWarehouseArea(@RequestParam("id") Long id) {
        MesWmWarehouseAreaDO area = areaService.getWarehouseArea(id);
        if (area == null) {
            return success(null);
        }
        return success(buildWarehouseAreaRespVOList(Collections.singletonList(area)).get(0));
    }
 
    @GetMapping("/page")
    @Operation(summary = "获得库位分页")
    public CommonResult<PageResult<MesWmWarehouseAreaRespVO>> getWarehouseAreaPage(@Valid MesWmWarehouseAreaPageReqVO pageReqVO) {
        PageResult<MesWmWarehouseAreaDO> pageResult = areaService.getWarehouseAreaPage(pageReqVO);
        return success(new PageResult<>(buildWarehouseAreaRespVOList(pageResult.getList()), pageResult.getTotal()));
    }
 
    @GetMapping("/simple-list")
    @Operation(summary = "获得库位精简列表", description = "可按库区过滤")
    public CommonResult<List<MesWmWarehouseAreaRespVO>> getWarehouseAreaSimpleList(
            @Parameter(name = "locationId", description = "库区编号") @RequestParam(value = "locationId", required = false) Long locationId) {
        List<MesWmWarehouseAreaDO> list = areaService.getWarehouseAreaList(locationId);
        return success(buildWarehouseAreaRespVOList(list));
    }
 
    @GetMapping("/get-import-template")
    @Operation(summary = "获得库位导入模板")
    public void importTemplate(HttpServletResponse response) throws IOException {
        // 手动创建导出 demo
        List<MesWmWarehouseAreaImportExcelVO> list = Collections.singletonList(
                MesWmWarehouseAreaImportExcelVO.builder()
                        .code("A001").name("示例库位").warehouseName("示例仓库").locationName("示例库区")
                        .type(1).area(new java.math.BigDecimal("20.00"))
                        .maxLoad(new java.math.BigDecimal("1000.00"))
                        .positionX(1).positionY(1).positionZ(1)
                        .status(0).frozen(false).allowItemMixing(true).allowBatchMixing(true)
                        .remark("").build()
        );
        // 输出
        ExcelUtils.write(response, "库位导入模板.xls", "库位列表", MesWmWarehouseAreaImportExcelVO.class, list);
    }
 
    @PostMapping("/import")
    @Operation(summary = "导入库位")
    @Parameters({
            @Parameter(name = "file", description = "Excel 文件", required = true),
            @Parameter(name = "updateSupport", description = "是否支持更新,默认为 false", example = "true")
    })
    @PreAuthorize("@ss.hasPermission('mes:wm-warehouse:import')")
    public CommonResult<MesWmWarehouseAreaImportRespVO> importExcel(@RequestParam("file") MultipartFile file,
                                                                    @RequestParam(value = "updateSupport", required = false,
                                                                            defaultValue = "false") Boolean updateSupport) throws Exception {
        List<MesWmWarehouseAreaImportExcelVO> list = ExcelUtils.read(file, MesWmWarehouseAreaImportExcelVO.class);
        return success(areaService.importWarehouseAreaList(list, updateSupport));
    }
 
    // ==================== 拼接 VO ====================
 
    /**
     * 批量构建库位响应 VO 列表(填充库区、仓库信息)
     *
     * @param list 库位列表
     * @return 响应 VO 列表
     */
    private List<MesWmWarehouseAreaRespVO> buildWarehouseAreaRespVOList(List<MesWmWarehouseAreaDO> list) {
        if (CollUtil.isEmpty(list)) {
            return Collections.emptyList();
        }
        // 1. 获得库区信息
        Map<Long, MesWmWarehouseLocationDO> locationMap = locationService.getWarehouseLocationMap(
                convertSet(list, MesWmWarehouseAreaDO::getLocationId));
        Map<Long, MesWmWarehouseDO> warehouseMap = warehouseService.getWarehouseMap(
                convertSet(locationMap.values(), MesWmWarehouseLocationDO::getWarehouseId));
        // 2. 构建结果
        return BeanUtils.toBean(list, MesWmWarehouseAreaRespVO.class, vo -> {
            MapUtils.findAndThen(locationMap, vo.getLocationId(), location -> {
                vo.setLocationName(location.getName());
                vo.setWarehouseId(location.getWarehouseId());
                MapUtils.findAndThen(warehouseMap, location.getWarehouseId(), warehouse -> vo.setWarehouseName(warehouse.getName()));
            });
        });
    }
 
}