云
21 小时以前 ac2e2b5af3726ee64dc37c3ebf26989a0346f22a
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
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
package cn.iocoder.yudao.module.mes.controller.admin.dv.checkrecord;
 
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.dv.checkrecord.vo.MesDvCheckRecordPageReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.dv.checkrecord.vo.MesDvCheckRecordRespVO;
import cn.iocoder.yudao.module.mes.controller.admin.dv.checkrecord.vo.MesDvCheckRecordSaveReqVO;
import cn.iocoder.yudao.module.mes.dal.dataobject.dv.checkplan.MesDvCheckPlanDO;
import cn.iocoder.yudao.module.mes.dal.dataobject.dv.checkrecord.MesDvCheckRecordDO;
import cn.iocoder.yudao.module.mes.dal.dataobject.dv.machinery.MesDvMachineryDO;
import cn.iocoder.yudao.module.mes.service.dv.checkplan.MesDvCheckPlanService;
import cn.iocoder.yudao.module.mes.service.dv.checkrecord.MesDvCheckRecordService;
import cn.iocoder.yudao.module.mes.service.dv.machinery.MesDvMachineryService;
import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
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.util.Collections;
import java.util.List;
import java.util.Map;
 
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;
import org.springframework.web.multipart.MultipartFile;
import io.swagger.v3.oas.annotations.Parameters;
import cn.iocoder.yudao.module.mes.controller.admin.dv.checkrecord.vo.MesDvCheckRecordImportExcelVO;
import cn.iocoder.yudao.module.mes.controller.admin.dv.checkrecord.vo.MesDvCheckRecordImportRespVO;
 
@Tag(name = "管理后台 - MES 设备点检记录")
@RestController
@RequestMapping("/mes/dv/check-record")
@Validated
public class MesDvCheckRecordController {
 
    @Resource
    private MesDvCheckRecordService checkRecordService;
    @Resource
    private MesDvCheckPlanService checkPlanService;
    @Resource
    private MesDvMachineryService machineryService;
 
    @Resource
    private AdminUserApi adminUserApi;
 
    @PostMapping("/create")
    @Operation(summary = "创建设备点检记录")
    @PreAuthorize("@ss.hasPermission('mes:dv-check-record:create')")
    public CommonResult<Long> createCheckRecord(@Valid @RequestBody MesDvCheckRecordSaveReqVO createReqVO) {
        return success(checkRecordService.createCheckRecord(createReqVO));
    }
 
    @PutMapping("/update")
    @Operation(summary = "更新设备点检记录")
    @PreAuthorize("@ss.hasPermission('mes:dv-check-record:update')")
    public CommonResult<Boolean> updateCheckRecord(@Valid @RequestBody MesDvCheckRecordSaveReqVO updateReqVO) {
        checkRecordService.updateCheckRecord(updateReqVO);
        return success(true);
    }
 
    @PutMapping("/submit")
    @Operation(summary = "提交设备点检记录(草稿→已完成)")
    @Parameter(name = "id", description = "编号", required = true)
    @PreAuthorize("@ss.hasPermission('mes:dv-check-record:update')")
    public CommonResult<Boolean> submitCheckRecord(@RequestParam("id") Long id) {
        checkRecordService.submitCheckRecord(id);
        return success(true);
    }
 
    @DeleteMapping("/delete")
    @Operation(summary = "删除设备点检记录")
    @Parameter(name = "id", description = "编号", required = true)
    @PreAuthorize("@ss.hasPermission('mes:dv-check-record:delete')")
    public CommonResult<Boolean> deleteCheckRecord(@RequestParam("id") Long id) {
        checkRecordService.deleteCheckRecord(id);
        return success(true);
    }
 
    @GetMapping("/get")
    @Operation(summary = "获得设备点检记录")
    @Parameter(name = "id", description = "编号", required = true, example = "1024")
    public CommonResult<MesDvCheckRecordRespVO> getCheckRecord(@RequestParam("id") Long id) {
        MesDvCheckRecordDO checkRecord = checkRecordService.getCheckRecord(id);
        if (checkRecord == null) {
            return success(null);
        }
        return success(buildCheckRecordRespVOList(Collections.singletonList(checkRecord)).get(0));
    }
 
    @GetMapping("/page")
    @Operation(summary = "获得设备点检记录分页")
    public CommonResult<PageResult<MesDvCheckRecordRespVO>> getCheckRecordPage(@Valid MesDvCheckRecordPageReqVO pageReqVO) {
        PageResult<MesDvCheckRecordDO> pageResult = checkRecordService.getCheckRecordPage(pageReqVO);
        return success(new PageResult<>(buildCheckRecordRespVOList(pageResult.getList()), pageResult.getTotal()));
    }
 
    @GetMapping("/export-excel")
    @Operation(summary = "导出设备点检记录 Excel")
    @PreAuthorize("@ss.hasPermission('mes:dv-check-record:export')")
    @ApiAccessLog(operateType = EXPORT)
    public void exportCheckRecordExcel(@Valid MesDvCheckRecordPageReqVO pageReqVO,
                                       HttpServletResponse response) throws IOException {
        pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
        List<MesDvCheckRecordDO> list = checkRecordService.getCheckRecordPage(pageReqVO).getList();
        ExcelUtils.write(response, "设备点检记录.xls", "数据", MesDvCheckRecordRespVO.class,
                buildCheckRecordRespVOList(list));
    }
 
    // ==================== 拼接 VO ====================
 
    @SuppressWarnings("DuplicatedCode")
    private List<MesDvCheckRecordRespVO> buildCheckRecordRespVOList(List<MesDvCheckRecordDO> list) {
        if (CollUtil.isEmpty(list)) {
            return Collections.emptyList();
        }
        // 1. 批量获取关联数据
        Map<Long, MesDvCheckPlanDO> planMap = checkPlanService.getCheckPlanMap(
                convertSet(list, MesDvCheckRecordDO::getPlanId));
        Map<Long, MesDvMachineryDO> machineryMap = machineryService.getMachineryMap(
                convertSet(list, MesDvCheckRecordDO::getMachineryId));
        Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(
                convertSet(list, MesDvCheckRecordDO::getUserId));
        // 2. 拼接 VO
        return BeanUtils.toBean(list, MesDvCheckRecordRespVO.class, vo -> {
            MapUtils.findAndThen(planMap, vo.getPlanId(),
                    plan -> vo.setPlanName(plan.getName()).setPlanCode(plan.getCode())
                            .setPlanStartDate(plan.getStartDate()).setPlanEndDate(plan.getEndDate())
                            .setPlanCycleType(plan.getCycleType()).setPlanCycleCount(plan.getCycleCount()));
            MapUtils.findAndThen(machineryMap, vo.getMachineryId(), machinery -> vo
                    .setMachineryCode(machinery.getCode()).setMachineryName(machinery.getName())
                    .setMachineryBrand(machinery.getBrand()).setMachinerySpecification(machinery.getSpecification()));
            MapUtils.findAndThen(userMap, vo.getUserId(),
                    user -> vo.setNickname(user.getNickname()));
        });
    }
 
 
    @GetMapping("/get-import-template")
    @Operation(summary = "获得设备点检记录导入模板")
    public void importTemplate(HttpServletResponse response) throws IOException {
        // 手动创建导出 demo
        List<MesDvCheckRecordImportExcelVO> list = Collections.singletonList(
                MesDvCheckRecordImportExcelVO.builder()
                        .machineryCode("MC-001").planCode("CP-001")
                        .checkTime(java.time.LocalDateTime.of(2026, 12, 31, 8, 0))
                        .userId(1L).remark("")
                        .build()
        );
        // 输出
        ExcelUtils.writeTemplate(response, "设备点检记录导入模板.xls", "设备点检记录列表", MesDvCheckRecordImportExcelVO.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:dv-check-record:import')")
    public CommonResult<MesDvCheckRecordImportRespVO> importExcel(@RequestParam("file") MultipartFile file,
                                                           @RequestParam(value = "updateSupport", required = false,
                                                                   defaultValue = "false") Boolean updateSupport) throws Exception {
        List<MesDvCheckRecordImportExcelVO> list = ExcelUtils.read(file, MesDvCheckRecordImportExcelVO.class);
        return success(checkRecordService.importCheckRecordList(list, updateSupport));
    }
 
}