package cn.iocoder.yudao.module.mes.controller.admin.qc.oqc;
|
|
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.object.BeanUtils;
|
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
|
import cn.iocoder.yudao.module.mes.controller.admin.qc.oqc.vo.MesQcOqcPageReqVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.qc.oqc.vo.MesQcOqcRespVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.qc.oqc.vo.MesQcOqcSaveReqVO;
|
import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi;
|
import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO;
|
import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.md.unitmeasure.MesMdUnitMeasureDO;
|
import cn.iocoder.yudao.module.mes.dal.dataobject.qc.oqc.MesQcOqcDO;
|
import cn.iocoder.yudao.module.mes.service.md.unitmeasure.MesMdUnitMeasureService;
|
import cn.iocoder.yudao.module.mes.service.qc.oqc.MesQcOqcService;
|
import cn.iocoder.yudao.module.mes.service.qc.support.MesQcItemResolver;
|
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 static cn.iocoder.yudao.framework.common.util.collection.MapUtils.findAndThen;
|
import org.springframework.web.multipart.MultipartFile;
|
import io.swagger.v3.oas.annotations.Parameters;
|
import cn.iocoder.yudao.module.mes.controller.admin.qc.oqc.vo.MesQcOqcImportExcelVO;
|
import cn.iocoder.yudao.module.mes.controller.admin.qc.oqc.vo.MesQcOqcImportRespVO;
|
|
@Tag(name = "管理后台 - MES 出货检验单（OQC）")
|
@RestController
|
@RequestMapping("/mes/qc/oqc")
|
@Validated
|
public class MesQcOqcController {
|
|
@Resource
|
private MesQcOqcService oqcService;
|
@Resource
|
private CrmCustomerApi customerApi;
|
@Resource
|
private MesQcItemResolver qcItemResolver;
|
@Resource
|
private MesMdUnitMeasureService unitMeasureService;
|
|
@Resource
|
private AdminUserApi adminUserApi;
|
|
@PostMapping("/create")
|
@Operation(summary = "创建出货检验单")
|
@PreAuthorize("@ss.hasPermission('mes:qc-oqc:create')")
|
public CommonResult<Long> createOqc(@Valid @RequestBody MesQcOqcSaveReqVO createReqVO) {
|
return success(oqcService.createOqc(createReqVO));
|
}
|
|
@PutMapping("/update")
|
@Operation(summary = "更新出货检验单")
|
@PreAuthorize("@ss.hasPermission('mes:qc-oqc:update')")
|
public CommonResult<Boolean> updateOqc(@Valid @RequestBody MesQcOqcSaveReqVO updateReqVO) {
|
oqcService.updateOqc(updateReqVO);
|
return success(true);
|
}
|
|
@PutMapping("/finish")
|
@Operation(summary = "完成出货检验单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:qc-oqc:finish')")
|
public CommonResult<Boolean> finishOqc(@RequestParam("id") Long id) {
|
oqcService.finishOqc(id);
|
return success(true);
|
}
|
|
@DeleteMapping("/delete")
|
@Operation(summary = "删除出货检验单")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('mes:qc-oqc:delete')")
|
public CommonResult<Boolean> deleteOqc(@RequestParam("id") Long id) {
|
oqcService.deleteOqc(id);
|
return success(true);
|
}
|
|
@GetMapping("/get")
|
@Operation(summary = "获得出货检验单")
|
@Parameter(name = "id", description = "编号", required = true, example = "1024")
|
@PreAuthorize("@ss.hasPermission('mes:qc-oqc:query')")
|
public CommonResult<MesQcOqcRespVO> getOqc(@RequestParam("id") Long id) {
|
MesQcOqcDO oqc = oqcService.getOqc(id);
|
return success(buildOqcRespVOList(Collections.singletonList(oqc)).get(0));
|
}
|
|
@GetMapping("/page")
|
@Operation(summary = "获得出货检验单分页")
|
@PreAuthorize("@ss.hasPermission('mes:qc-oqc:query')")
|
public CommonResult<PageResult<MesQcOqcRespVO>> getOqcPage(@Valid MesQcOqcPageReqVO pageReqVO) {
|
PageResult<MesQcOqcDO> pageResult = oqcService.getOqcPage(pageReqVO);
|
return success(new PageResult<>(buildOqcRespVOList(pageResult.getList()), pageResult.getTotal()));
|
}
|
|
@GetMapping("/export-excel")
|
@Operation(summary = "导出出货检验单 Excel")
|
@PreAuthorize("@ss.hasPermission('mes:qc-oqc:export')")
|
@ApiAccessLog(operateType = EXPORT)
|
public void exportOqcExcel(@Valid MesQcOqcPageReqVO pageReqVO,
|
HttpServletResponse response) throws IOException {
|
pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
|
List<MesQcOqcDO> list = oqcService.getOqcPage(pageReqVO).getList();
|
List<MesQcOqcRespVO> voList = buildOqcRespVOList(list);
|
ExcelUtils.write(response, "出货检验单.xls", "数据", MesQcOqcRespVO.class, voList);
|
}
|
|
// ==================== 拼接 VO ====================
|
|
private List<MesQcOqcRespVO> buildOqcRespVOList(List<MesQcOqcDO> list) {
|
if (CollUtil.isEmpty(list)) {
|
return Collections.emptyList();
|
}
|
// 批量查询客户
|
Map<Long, CrmCustomerRespDTO> clientMap = customerApi.getCustomerMap(
|
convertSet(list, MesQcOqcDO::getClientId));
|
// 批量查询物料（兼容 mdm_item.id / mes_md_item.id）
|
Map<Long, MdmItemRespDTO> itemMap = qcItemResolver.getItemMap(
|
convertSet(list, MesQcOqcDO::getItemId));
|
// 批量查询计量单位
|
Map<Long, MesMdUnitMeasureDO> unitMeasureMap = unitMeasureService.getUnitMeasureMap(
|
convertSet(itemMap.values(), MdmItemRespDTO::getUnitMeasureId));
|
// 批量查询检测人员
|
Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(
|
convertSet(list, MesQcOqcDO::getInspectorUserId));
|
// 拼装 VO
|
return BeanUtils.toBean(list, MesQcOqcRespVO.class, vo -> {
|
findAndThen(clientMap, vo.getClientId(),
|
client -> vo.setClientNickname(client.getName()));
|
findAndThen(itemMap, vo.getItemId(), item -> {
|
vo.setItemCode(item.getCode()).setItemName(item.getName()).setItemSpecification(item.getSpecification());
|
findAndThen(unitMeasureMap, item.getUnitMeasureId(),
|
unit -> vo.setUnitName(unit.getName()));
|
});
|
findAndThen(userMap, vo.getInspectorUserId(),
|
user -> vo.setInspectorNickname(user.getNickname()));
|
});
|
}
|
|
|
@GetMapping("/get-import-template")
|
@Operation(summary = "获得出货检验单导入模板")
|
public void importTemplate(HttpServletResponse response) throws IOException {
|
// 手动创建导出 demo
|
List<MesQcOqcImportExcelVO> list = Collections.singletonList(
|
MesQcOqcImportExcelVO.builder()
|
.clientName("示例客户").itemCode("M-001").name("出货检验单")
|
.outQuantity(new java.math.BigDecimal("100"))
|
.checkQuantity(new java.math.BigDecimal("100"))
|
.qualifiedQuantity(new java.math.BigDecimal("98"))
|
.unqualifiedQuantity(new java.math.BigDecimal("2"))
|
.checkResult(1).outDate(java.time.LocalDateTime.of(2026, 12, 31, 8, 0))
|
.inspectDate(java.time.LocalDateTime.of(2026, 12, 31, 9, 0))
|
.inspectorUserId(1L).remark("")
|
.build()
|
);
|
// 输出
|
ExcelUtils.write(response, "出货检验单导入模板.xls", "出货检验单列表", MesQcOqcImportExcelVO.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:qc-oqc:import')")
|
public CommonResult<MesQcOqcImportRespVO> importExcel(@RequestParam("file") MultipartFile file,
|
@RequestParam(value = "updateSupport", required = false,
|
defaultValue = "false") Boolean updateSupport) throws Exception {
|
List<MesQcOqcImportExcelVO> list = ExcelUtils.read(file, MesQcOqcImportExcelVO.class);
|
return success(oqcService.importOqcList(list, updateSupport));
|
}
|
|
}
|
