From 8c65f898ed6e5b0c7a94c792c4562f6ec831dccd Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期六, 07 十一月 2026 08:50:53 +0800
Subject: [PATCH] feat: 完善质检、生产、销售、财务与人事模块并接入审批流程

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/salesnotice/MesWmSalesNoticeController.java |  197 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 194 insertions(+), 3 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/salesnotice/MesWmSalesNoticeController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/salesnotice/MesWmSalesNoticeController.java
index 9ff4bc9..f9b315a 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/salesnotice/MesWmSalesNoticeController.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/salesnotice/MesWmSalesNoticeController.java
@@ -10,11 +10,20 @@
 import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
 import cn.iocoder.yudao.module.crm.api.customer.CrmCustomerApi;
 import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.salesnotice.vo.MesWmSalesNoticeLedgerRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.wm.salesnotice.vo.MesWmSalesNoticePageReqVO;
 import cn.iocoder.yudao.module.mes.controller.admin.wm.salesnotice.vo.MesWmSalesNoticeRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.wm.salesnotice.vo.MesWmSalesNoticeSaveReqVO;
+import cn.iocoder.yudao.module.mdm.api.item.MdmItemApi;
+import cn.iocoder.yudao.module.mdm.api.item.dto.MdmItemRespDTO;
+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.dal.dataobject.wm.salesnotice.MesWmSalesNoticeDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.wm.salesnotice.MesWmSalesNoticeLineDO;
+import cn.iocoder.yudao.module.mes.service.wm.document.MesWmDocumentRenderer;
+import cn.iocoder.yudao.module.mes.service.wm.salesnotice.MesWmSalesNoticeLineService;
 import cn.iocoder.yudao.module.mes.service.wm.salesnotice.MesWmSalesNoticeService;
+import cn.iocoder.yudao.module.system.service.companyconfig.SystemCompanyConfigService;
 import io.swagger.v3.oas.annotations.Operation;
 import io.swagger.v3.oas.annotations.Parameter;
 import io.swagger.v3.oas.annotations.tags.Tag;
@@ -26,13 +35,21 @@
 import org.springframework.web.bind.annotation.*;
 
 import java.io.IOException;
+import java.net.URLEncoder;
+import java.nio.charset.StandardCharsets;
+import java.time.format.DateTimeFormatter;
+import java.util.ArrayList;
 import java.util.Collections;
+import java.util.LinkedHashMap;
 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.exception.util.ServiceExceptionUtil.exception;
 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.security.core.util.SecurityFrameworkUtils.getLoginUserId;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.WM_SALES_NOTICE_NOT_EXISTS;
 
 @Tag(name = "绠$悊鍚庡彴 - MES 鍙戣揣閫氱煡鍗�")
 @RestController
@@ -44,6 +61,16 @@
     private MesWmSalesNoticeService salesNoticeService;
     @Resource
     private CrmCustomerApi crmCustomerApi;
+    @Resource
+    private MesWmSalesNoticeLineService salesNoticeLineService;
+    @Resource
+    private MdmItemApi mdmItemApi;
+    @Resource
+    private MdmUnitMeasureApi mdmUnitMeasureApi;
+    @Resource
+    private SystemCompanyConfigService companyConfigService;
+    @Resource
+    private cn.iocoder.yudao.module.system.api.user.AdminUserApi adminUserApi;
 
     @PostMapping("/create")
     @Operation(summary = "鍒涘缓鍙戣揣閫氱煡鍗�")
@@ -88,6 +115,83 @@
         return success(new PageResult<>(buildRespVOList(pageResult.getList()), pageResult.getTotal()));
     }
 
+    @GetMapping("/ledger-page")
+    @Operation(summary = "鑾峰緱鍙戣揣鍙拌处鍒嗛〉锛堟寜浜у搧骞抽摵锛�")
+    public CommonResult<PageResult<MesWmSalesNoticeLedgerRespVO>> getSalesNoticeLedgerPage(
+            @Valid MesWmSalesNoticePageReqVO pageReqVO) {
+        int pageNo = pageReqVO.getPageNo();
+        int pageSize = pageReqVO.getPageSize();
+        // 1. 鍏堟煡鍑虹鍚堟潯浠剁殑鍏ㄩ儴鍙戣揣鍗曪紝鍐嶅钩閾烘槑缁嗗悗鎵嬪姩鍒嗛〉锛堟槑缁嗚鏁版棤娉曞湪 SQL 灞傜洿鎺ュ垎椤碉級
+        List<MesWmSalesNoticeDO> notices;
+        try {
+            pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
+            notices = salesNoticeService.getSalesNoticePage(pageReqVO).getList();
+        } finally {
+            pageReqVO.setPageSize(pageSize);
+        }
+        if (CollUtil.isEmpty(notices)) {
+            return success(new PageResult<>(Collections.emptyList(), 0L));
+        }
+        List<MesWmSalesNoticeLineDO> lines = salesNoticeLineService.getSalesNoticeLineListByNoticeIds(
+                convertSet(notices, MesWmSalesNoticeDO::getId));
+        Map<Long, List<MesWmSalesNoticeLineDO>> lineMap = lines.stream()
+                .collect(java.util.stream.Collectors.groupingBy(MesWmSalesNoticeLineDO::getNoticeId));
+        Map<Long, CrmCustomerRespDTO> customerMap = crmCustomerApi.getCustomerMap(
+                convertSet(notices, MesWmSalesNoticeDO::getClientId));
+        Map<Long, MdmItemRespDTO> itemMap = mdmItemApi.getItemMap(
+                convertSet(lines, MesWmSalesNoticeLineDO::getItemId));
+        Map<Long, MdmUnitMeasureRespDTO> unitMap = CollUtil.isEmpty(itemMap) ? Collections.emptyMap()
+                : mdmUnitMeasureApi.getUnitMeasureList(
+                        convertSet(itemMap.values(), MdmItemRespDTO::getUnitMeasureId))
+                .getCheckedData().stream()
+                .collect(java.util.stream.Collectors.toMap(MdmUnitMeasureRespDTO::getId, e -> e));
+
+        // 2. 鎸夊崟鎹『搴忓钩閾烘垚銆屼竴琛屼竴涓骇鍝併��
+        List<MesWmSalesNoticeLedgerRespVO> rows = new ArrayList<>();
+        for (MesWmSalesNoticeDO notice : notices) {
+            List<MesWmSalesNoticeLineDO> noticeLines = lineMap.getOrDefault(notice.getId(), Collections.emptyList());
+            CrmCustomerRespDTO customer = customerMap.get(notice.getClientId());
+            for (MesWmSalesNoticeLineDO line : noticeLines) {
+                MesWmSalesNoticeLedgerRespVO row = new MesWmSalesNoticeLedgerRespVO();
+                row.setNoticeId(notice.getId());
+                row.setNoticeCode(notice.getCode());
+                row.setSaleOrderCode(notice.getSaleOrderCode());
+                row.setClientId(notice.getClientId());
+                row.setClientName(customer != null ? customer.getName() : null);
+                row.setSalesDate(notice.getSalesDate());
+                row.setRecipientName(notice.getRecipientName());
+                row.setRecipientAddress(notice.getRecipientAddress());
+                row.setLogisticsCompany(notice.getLogisticsCompany());
+                row.setExpressFee(notice.getExpressFee());
+                row.setInvoiceStatus(notice.getInvoiceStatus());
+                row.setStatus(notice.getStatus());
+                row.setOutStatus(notice.getOutStatus());
+                row.setLineId(line.getId());
+                row.setItemId(line.getItemId());
+                MdmItemRespDTO item = itemMap.get(line.getItemId());
+                row.setItemCode(item != null ? item.getCode() : null);
+                row.setItemName(item != null ? item.getName() : null);
+                row.setItemSpecification(item != null ? item.getSpecification() : null);
+                MdmUnitMeasureRespDTO unit = item != null ? unitMap.get(item.getUnitMeasureId()) : null;
+                row.setUnitName(unit != null ? unit.getName() : null);
+                row.setQuantity(line.getQuantity());
+                row.setOutCount(line.getOutCount());
+                row.setBatchCode(line.getBatchCode());
+                row.setLineRemark(line.getRemark());
+                rows.add(row);
+            }
+        }
+
+        // 3. 鎵嬪姩鍒嗛〉
+        long total = rows.size();
+        if (pageSize == PageParam.PAGE_SIZE_NONE) {
+            return success(new PageResult<>(rows, total));
+        }
+        int from = Math.min(Math.max(pageNo - 1, 0) * pageSize, rows.size());
+        int to = Math.min(from + pageSize, rows.size());
+        return success(new PageResult<>(rows.subList(from, to), total));
+    }
+
     @GetMapping("/export-excel")
     @Operation(summary = "瀵煎嚭鍙戣揣閫氱煡鍗� Excel")
     @PreAuthorize("@ss.hasPermission('mes:wm-sales-notice:export')")
@@ -100,15 +204,102 @@
                 buildRespVOList(pageResult.getList()));
     }
 
+    @GetMapping("/export-word")
+    @Operation(summary = "瀵煎嚭鍙戣揣鍗� Word锛堝甫鐢靛瓙绔狅紝鍙墜濉瀛楀悗褰掓。锛�")
+    @Parameter(name = "id", description = "鍙戣揣閫氱煡鍗曠紪鍙�", required = true)
+    @PreAuthorize("@ss.hasPermission('mes:wm-sales-notice:export')")
+    @ApiAccessLog(operateType = EXPORT)
+    public void exportSalesNoticeWord(@RequestParam("id") Long id,
+                                      HttpServletResponse response) throws IOException {
+        MesWmSalesNoticeDO notice = salesNoticeService.getSalesNotice(id);
+        if (notice == null) {
+            throw exception(WM_SALES_NOTICE_NOT_EXISTS);
+        }
+        List<MesWmSalesNoticeLineDO> lines = salesNoticeLineService.getSalesNoticeLineListByNoticeId(id);
+        Map<Long, MdmItemRespDTO> itemMap = mdmItemApi.getItemMap(
+                convertSet(lines, MesWmSalesNoticeLineDO::getItemId));
+        Map<Long, MdmUnitMeasureRespDTO> unitMap = mdmUnitMeasureApi
+                .getUnitMeasureList(convertSet(itemMap.values(), MdmItemRespDTO::getUnitMeasureId))
+                .getCheckedData().stream()
+                .collect(java.util.stream.Collectors.toMap(MdmUnitMeasureRespDTO::getId, e -> e));
+
+        Map<String, String> fields = new LinkedHashMap<>();
+        fields.put("clientName", resolveClientName(notice.getClientId()));
+        fields.put("code", notice.getCode());
+        fields.put("salesDate", notice.getSalesDate() == null ? null
+                : notice.getSalesDate().format(DateTimeFormatter.ofPattern("yyyy-MM-dd")));
+        fields.put("saleOrderCode", notice.getSaleOrderCode());
+        fields.put("recipientName", notice.getRecipientName());
+        fields.put("recipientTelephone", notice.getRecipientTelephone());
+        fields.put("recipientAddress", notice.getRecipientAddress());
+        fields.put("logisticsCompany", notice.getLogisticsCompany());
+        fields.put("expressFee", notice.getExpressFee() == null ? "0.00" : notice.getExpressFee().toPlainString());
+        fields.put("creator", resolveCreatorName(notice.getCreator()));
+        fields.put("remark", notice.getRemark());
+
+        List<Map<String, String>> items = new ArrayList<>();
+        for (MesWmSalesNoticeLineDO line : lines) {
+            MdmItemRespDTO item = itemMap.get(line.getItemId());
+            Map<String, String> row = new LinkedHashMap<>();
+            row.put("itemName", item != null ? item.getName() : null);
+            row.put("itemSpecification", item != null ? item.getSpecification() : null);
+            MdmUnitMeasureRespDTO unit = item != null ? unitMap.get(item.getUnitMeasureId()) : null;
+            row.put("unitName", unit != null ? unit.getName() : null);
+            row.put("quantity", line.getQuantity() == null ? null : line.getQuantity().toPlainString());
+            row.put("batchCode", line.getBatchCode());
+            row.put("itemRemark", line.getRemark());
+            items.add(row);
+        }
+
+        var companyConfig = companyConfigService.getCompanyConfig();
+        byte[] content = MesWmDocumentRenderer.renderSalesDelivery(fields, items,
+                companyConfig != null ? companyConfig.getCompanyName() : null);
+        writeWord(response, "鍙戣揣鍗�-" + notice.getCode() + ".docx", content);
+    }
+
+    private String resolveClientName(Long clientId) {
+        if (clientId == null) {
+            return null;
+        }
+        CrmCustomerRespDTO customer = crmCustomerApi.getCustomer(clientId);
+        return customer != null ? customer.getName() : null;
+    }
+
+    private String resolveCreatorName(String creator) {
+        if (creator == null) {
+            return null;
+        }
+        try {
+            var user = adminUserApi.getUser(Long.valueOf(creator));
+            return user != null ? user.getNickname() : null;
+        } catch (NumberFormatException ignored) {
+            return creator;
+        }
+    }
+
+    private static void writeWord(HttpServletResponse response, String filename, byte[] content) throws IOException {
+        String encoded = URLEncoder.encode(filename, StandardCharsets.UTF_8).replace("+", "%20");
+        response.setContentType("application/vnd.openxmlformats-officedocument.wordprocessingml.document");
+        response.setHeader("Content-Disposition", "attachment;filename*=UTF-8''" + encoded);
+        response.getOutputStream().write(content);
+    }
+
     @PutMapping("/submit")
-    @Operation(summary = "鎻愪氦鍙戣揣閫氱煡鍗�")
+    @Operation(summary = "鎻愪氦鍙戣揣閫氱煡鍗曞鎵�")
     @Parameter(name = "id", description = "缂栧彿", required = true)
     @PreAuthorize("@ss.hasPermission('mes:wm-sales-notice:update')")
-    public CommonResult<Boolean> submitSalesNotice(@RequestParam("id") Long id) {
-        salesNoticeService.submitSalesNotice(id);
+    public CommonResult<Boolean> submitSalesNotice(@RequestParam("id") Long id,
+                                                   @RequestParam(value = "processDefinitionKey", required = false) String processDefinitionKey) {
+        salesNoticeService.submitSalesNotice(id, processDefinitionKey, getLoginUserId());
         return success(true);
     }
 
+    @GetMapping("/approve-process-list")
+    @Operation(summary = "鑾峰彇鍙戣揣瀹℃壒娴佺▼鍒楄〃")
+    public CommonResult<List<Map<String, Object>>> getSalesNoticeApproveProcessList() {
+        return success(salesNoticeService.getSalesNoticeApproveProcessDefinitionList());
+    }
+
     @PostMapping("/generate-from-sale-order")
     @Operation(summary = "浠庨攢鍞鍗曠敓鎴愬彂璐ч�氱煡鍗�")
     @PreAuthorize("@ss.hasPermission('mes:wm-sales-notice:create')")

--
Gitblit v1.9.3