package cn.iocoder.yudao.module.mes.controller.admin.qc.ledger; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.StrUtil; 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.dict.core.DictFrameworkUtils; import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils; import cn.iocoder.yudao.module.mes.controller.admin.qc.ledger.vo.MesQcInspectionLedgerExportVO; import cn.iocoder.yudao.module.mes.controller.admin.qc.ledger.vo.MesQcInspectionLedgerPageReqVO; import cn.iocoder.yudao.module.mes.controller.admin.qc.ledger.vo.MesQcInspectionLedgerRespVO; import cn.iocoder.yudao.module.mes.controller.admin.qc.vo.MesQcQualityExportVO; import cn.iocoder.yudao.module.mes.enums.DictTypeConstants; import cn.iocoder.yudao.module.mes.enums.qc.MesQcTypeEnum; import cn.iocoder.yudao.module.mes.service.qc.ledger.MesQcInspectionLedgerService; import io.swagger.v3.oas.annotations.Operation; 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.GetMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.io.IOException; import java.util.ArrayList; import java.util.List; import java.util.Objects; import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT; import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success; @Tag(name = "管理后台 - MES 检测结果台账") @RestController @RequestMapping("/mes/qc/inspection-ledger") @Validated public class MesQcInspectionLedgerController { @Resource private MesQcInspectionLedgerService ledgerService; @GetMapping("/page") @Operation(summary = "获得检测结果台账分页(四类检验单统一查询)") @PreAuthorize("@ss.hasPermission('mes:qc-inspection-ledger:query')") public CommonResult> getInspectionLedgerPage( @Valid MesQcInspectionLedgerPageReqVO pageReqVO) { return success(ledgerService.getInspectionLedgerPage(pageReqVO)); } @GetMapping("/export-excel") @Operation(summary = "导出检测结果台账 Excel") @PreAuthorize("@ss.hasPermission('mes:qc-inspection-ledger:export')") @ApiAccessLog(operateType = EXPORT) public void exportInspectionLedgerExcel(@Valid MesQcInspectionLedgerPageReqVO pageReqVO, HttpServletResponse response) throws IOException { pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE); List list = ledgerService.getInspectionLedgerPage(pageReqVO).getList(); ExcelUtils.write(response, "检测结果台账.xls", "检测结果台账", MesQcInspectionLedgerExportVO.class, buildExportList(list)); } private List buildExportList(List list) { if (CollUtil.isEmpty(list)) { return new ArrayList<>(); } List exportList = new ArrayList<>(list.size()); for (MesQcInspectionLedgerRespVO vo : list) { MesQcInspectionLedgerExportVO export = new MesQcInspectionLedgerExportVO(); export.setQcTypeName(qcTypeName(vo.getQcType())); export.setCode(vo.getCode()); export.setName(vo.getName()); export.setItemCode(vo.getItemCode()); export.setItemName(vo.getItemName()); export.setItemSpecification(vo.getItemSpecification()); export.setBatchNo(vo.getBatchNo()); export.setIndicatorName(vo.getIndicatorName()); export.setIndicatorValue(vo.getIndicatorValue()); export.setJudgementBasis(vo.getJudgementBasis()); export.setCheckResultText(parseDictLabel(DictTypeConstants.MES_QC_CHECK_RESULT, vo.getCheckResult())); export.setCheckQuantity(MesQcQualityExportVO.formatDecimal(vo.getCheckQuantity())); export.setQualifiedQuantity(MesQcQualityExportVO.formatDecimal(vo.getQualifiedQuantity())); export.setUnqualifiedQuantity(MesQcQualityExportVO.formatDecimal(vo.getUnqualifiedQuantity())); export.setInspectorName(vo.getInspectorName()); export.setInspectDate(MesQcQualityExportVO.formatDateTime(vo.getInspectDate())); export.setStatusText(parseDictLabel(DictTypeConstants.MES_ORDER_STATUS, vo.getStatus())); export.setRemark(vo.getRemark()); exportList.add(export); } return exportList; } private static String qcTypeName(Integer qcType) { for (MesQcTypeEnum e : MesQcTypeEnum.values()) { if (Objects.equals(e.getType(), qcType)) { return e.getName(); } } return ""; } private static String parseDictLabel(String dictType, Integer value) { if (value == null) { return ""; } String label = DictFrameworkUtils.parseDictDataLabel(dictType, String.valueOf(value)); return StrUtil.nullToEmpty(label); } }