From 7085354cb7e6283f72e99d7eff8e73b8c7ba0cb9 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期五, 03 七月 2026 18:02:41 +0800
Subject: [PATCH] 产品设计-设计项目/归档台账 接口开发
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectRespVO.java | 73 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentSaveReqVO.java | 46
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/project/MesPdProjectMapper.java | 28
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java | 8
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentServiceImpl.java | 91 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/document/MesPdDocumentDO.java | 76 +
docs/sql/mes_pd_init.sql | 160 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveServiceImpl.java | 187 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveRespVO.java | 83 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveSaveReqVO.java | 37
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectServiceImpl.java | 274 ++++
docs/archive_group_by_product.md | 397 ++++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditService.java | 64 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/MesPdProjectController.java | 163 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentPageReqVO.java | 24
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditRespVO.java | 61
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/pd/MesPdProjectStatusEnum.java | 68 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/MesPdDocumentAuditController.java | 121 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectSaveReqVO.java | 45
yudao-module-mes/src/main/resources/mapper/pd/archive/MesPdArchiveMapper.xml | 49
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchivePageReqVO.java | 30
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/MesPdDocumentController.java | 121 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditPageReqVO.java | 24
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesPdStatusConstants.java | 36
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/document/MesPdDocumentMapper.java | 31
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentService.java | 71 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/MesPdArchiveController.java | 146 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/md/autocode/MesMdAutoCodeRuleCodeEnum.java | 6
docs/product_design.md | 301 ++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/archive/MesPdArchiveMapper.java | 49
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditSaveReqVO.java | 41
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/documentaudit/MesPdDocumentAuditMapper.java | 47
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectService.java | 110 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectPageReqVO.java | 39
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditServiceImpl.java | 91 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java | 28
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveService.java | 64 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveDetailRespVO.java | 145 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/documentaudit/MesPdDocumentAuditDO.java | 72 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesBizTypeConstants.java | 9
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentRespVO.java | 65 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/archive/MesPdArchiveDO.java | 64 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveGroupRespVO.java | 71 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/project/MesPdProjectDO.java | 81 +
44 files changed, 3,796 insertions(+), 1 deletions(-)
diff --git a/docs/archive_group_by_product.md b/docs/archive_group_by_product.md
new file mode 100644
index 0000000..d295cf2
--- /dev/null
+++ b/docs/archive_group_by_product.md
@@ -0,0 +1,397 @@
+# 褰掓。鍙拌处锛堟寜浜у搧鑱氬悎锛夊墠绔鎺ユ枃妗�
+
+## 娑夊強椤甸潰
+
+- 褰掓。鍙拌处鍒楄〃椤碉紙淇敼锛�
+- 褰掓。鍙拌处璇︽儏寮圭獥/椤甸潰锛堟柊澧烇級
+
+## API
+
+### 1. 鍒嗛〉鏌ヨ锛堟寜椤圭洰/浜у搧鑱氬悎锛�
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| GET | /mes/pd/archive/page | 褰掓。鍙拌处鍒嗛〉锛堟寜椤圭洰/浜у搧鑱氬悎锛� |
+
+**璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭～ | 璇存槑 |
+|------|------|------|------|
+| pageNo | Integer | 鏄� | 椤电爜锛堜粠1寮�濮嬶級 |
+| pageSize | Integer | 鏄� | 姣忛〉鏉℃暟 |
+| archiveCode | String | 鍚� | 褰掓。缂栧彿锛堟ā绯婃悳绱級 |
+| projectId | Long | 鍚� | 璁捐椤圭洰ID |
+| archiveStatus | Integer | 鍚� | 褰掓。鐘舵�侊紙0=寰呭綊妗� 1=宸插綊妗ｏ級 |
+| productCode | String | 鍚� | 浜у搧缂栫爜锛堟ā绯婃悳绱級 |
+| productName | String | 鍚� | 浜у搧鍚嶇О锛堟ā绯婃悳绱級 |
+
+**鍝嶅簲缁撴瀯锛�**
+
+```json
+{
+ "code": 200,
+ "data": {
+ "list": [
+ {
+ "id": 3,
+ "archiveCode": "ARC20240003",
+ "projectId": 1,
+ "taskCode": "PD20240001",
+ "taskName": "鏂颁骇鍝佽璁′换鍔�",
+ "productCode": "P001",
+ "productName": "娉ㄥ浜у搧A",
+ "archiveCount": 3,
+ "archiver": 1,
+ "archiverNickname": "鐜嬩簲",
+ "archiveStatus": 1,
+ "archiveTime": "2024-01-03 10:00:00",
+ "remark": "",
+ "createTime": "2024-01-01 00:00:00",
+ "updater": "1",
+ "updaterNickname": "寮犱笁",
+ "updateTime": "2024-01-03 15:30:00"
+ }
+ ],
+ "total": 5
+ }
+}
+```
+
+**瀛楁璇存槑锛�**
+
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | Long | 鏈�鏂板綊妗ｈ褰旾D |
+| archiveCode | String | 鏈�鏂板綊妗ｇ紪鍙� |
+| projectId | Long | 璁捐椤圭洰ID |
+| taskCode | String | 浠诲姟缂栫爜 |
+| taskName | String | 浠诲姟鍚嶇О |
+| productCode | String | 浜у搧缂栫爜 |
+| productName | String | 浜у搧鍚嶇О |
+| archiveCount | Integer | 璇ラ」鐩笅褰掓。璁板綍鎬绘暟 |
+| archiver | Long | 褰掓。浜篒D |
+| archiverNickname | String | 褰掓。浜哄悕绉� |
+| archiveStatus | Integer | 褰掓。鐘舵�侊紙瀛楀吀 mes_pd_archive_status锛� |
+| archiveTime | LocalDateTime | 褰掓。鏃堕棿 |
+| remark | String | 澶囨敞 |
+| createTime | LocalDateTime | 鍒涘缓鏃堕棿 |
+| updater | String | 鏇存柊浜篒D |
+| updaterNickname | String | 鏇存柊浜哄悕绉� |
+| updateTime | LocalDateTime | 鏇存柊鏃堕棿 |
+
+---
+
+### 2. 璇︽儏鏌ヨ锛堟寜浜у搧缂栫爜锛�
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| GET | /mes/pd/archive/detail-by-product | 褰掓。鍙拌处璇︽儏锛堟寜浜у搧缂栫爜鏌ヨ锛� |
+
+**璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭～ | 璇存槑 |
+|------|------|------|------|
+| productCode | String | 鏄� | 浜у搧缂栫爜 |
+
+**鍝嶅簲缁撴瀯锛�**
+
+杩斿洖 `List<MesPdArchiveDetailRespVO>`锛屽悓涓�浜у搧缂栫爜鍙兘鍏宠仈澶氫釜璁捐椤圭洰锛屾瘡涓」鐩竴鏉¤鎯呫��
+
+```json
+{
+ "code": 200,
+ "data": [
+ {
+ "project": {
+ "id": 1,
+ "taskCode": "PD20240001",
+ "taskName": "鏂颁骇鍝佽璁′换鍔�",
+ "productCode": "P001",
+ "productName": "娉ㄥ浜у搧A",
+ "version": "V1.0",
+ "status": 4,
+ "chiefDesigner": 1,
+ "chiefDesignerNickname": "寮犱笁",
+ "reviewer": 2,
+ "reviewerNickname": "鏉庡洓",
+ "planFinishTime": "2024-12-31 00:00:00",
+ "remark": "",
+ "createTime": "2024-01-01 00:00:00"
+ },
+ "archives": [
+ {
+ "id": 1,
+ "archiveCode": "ARC20240001",
+ "archiver": 1,
+ "archiverNickname": "鐜嬩簲",
+ "archiveStatus": 1,
+ "archiveTime": "2024-01-01 10:00:00",
+ "remark": "",
+ "createTime": "2024-01-01 10:00:00"
+ },
+ {
+ "id": 2,
+ "archiveCode": "ARC20240002",
+ "archiver": 1,
+ "archiverNickname": "鐜嬩簲",
+ "archiveStatus": 1,
+ "archiveTime": "2024-01-02 10:00:00",
+ "remark": "",
+ "createTime": "2024-01-02 10:00:00"
+ }
+ ],
+ "documents": [
+ {
+ "id": 1,
+ "documentType": "1",
+ "documentName": "浜у搧璁捐鍥�",
+ "documentVersion": "V1.0",
+ "fileName": "design.pdf",
+ "fileUrl": "/files/design.pdf",
+ "uploadUserId": 1,
+ "uploadUserNickname": "璧靛叚",
+ "uploadTime": "2024-01-01 09:00:00",
+ "remark": "",
+ "createTime": "2024-01-01 09:00:00"
+ }
+ ]
+ }
+ ]
+}
+```
+
+**ProjectInfo 瀛楁璇存槑锛�**
+
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | Long | 椤圭洰ID |
+| taskCode | String | 浠诲姟缂栫爜 |
+| taskName | String | 浠诲姟鍚嶇О |
+| productCode | String | 浜у搧缂栫爜 |
+| productName | String | 浜у搧鍚嶇О |
+| version | String | 鐗堟湰鍙� |
+| status | Integer | 椤圭洰鐘舵�侊紙瀛楀吀 mes_pd_project_status锛�0=寰呭彂甯� 1=寰呬笂浼� 2=寰呭鏍� 3=寰呭綊妗� 4=宸插綊妗ｏ級 |
+| chiefDesigner | Long | 涓昏璁″笀ID |
+| chiefDesignerNickname | String | 涓昏璁″笀鍚嶇О |
+| reviewer | Long | 瀹℃牳浜篒D |
+| reviewerNickname | String | 瀹℃牳浜哄悕绉� |
+| planFinishTime | LocalDateTime | 璁″垝瀹屾垚鏃堕棿 |
+| remark | String | 澶囨敞 |
+| createTime | LocalDateTime | 鍒涘缓鏃堕棿 |
+
+**ArchiveInfo 瀛楁璇存槑锛�**
+
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | Long | 褰掓。ID |
+| archiveCode | String | 褰掓。缂栧彿 |
+| archiver | Long | 褰掓。浜篒D |
+| archiverNickname | String | 褰掓。浜哄悕绉� |
+| archiveStatus | Integer | 褰掓。鐘舵�侊紙瀛楀吀 mes_pd_archive_status锛� |
+| archiveTime | LocalDateTime | 褰掓。鏃堕棿 |
+| remark | String | 澶囨敞 |
+| createTime | LocalDateTime | 鍒涘缓鏃堕棿 |
+
+**DocumentInfo 瀛楁璇存槑锛�**
+
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| id | Long | 璧勬枡ID |
+| documentType | String | 璧勬枡绫诲瀷锛堝瓧鍏� mes_pd_document_type锛� |
+| documentName | String | 璧勬枡鍚嶇О |
+| documentVersion | String | 璧勬枡鐗堟湰 |
+| fileName | String | 鏂囦欢鍚� |
+| fileUrl | String | 鏂囦欢URL |
+| uploadUserId | Long | 涓婁紶浜篒D |
+| uploadUserNickname | String | 涓婁紶浜哄悕绉� |
+| uploadTime | LocalDateTime | 涓婁紶鏃堕棿 |
+| remark | String | 澶囨敞 |
+| createTime | LocalDateTime | 鍒涘缓鏃堕棿 |
+
+---
+
+## 鍓嶇淇敼鐐�
+
+### 1. 鍒楄〃椤� - 鎼滅储鏍忔柊澧�
+
+```html
+<el-form :model="queryParams" ref="queryFormRef" :inline="true">
+ <el-form-item label="浜у搧缂栫爜" prop="productCode">
+ <el-input v-model="queryParams.productCode" placeholder="璇疯緭鍏ヤ骇鍝佺紪鐮�" clearable />
+ </el-form-item>
+ <el-form-item label="浜у搧鍚嶇О" prop="productName">
+ <el-input v-model="queryParams.productName" placeholder="璇疯緭鍏ヤ骇鍝佸悕绉�" clearable />
+ </el-form-item>
+ <el-form-item label="褰掓。鐘舵��" prop="archiveStatus">
+ <el-select v-model="queryParams.archiveStatus" placeholder="璇烽�夋嫨褰掓。鐘舵��" clearable>
+ <el-option v-for="dict in getIntDictOptions(DICT_TYPE.MES_PD_ARCHIVE_STATUS)"
+ :key="dict.value" :label="dict.label" :value="dict.value" />
+ </el-select>
+ </el-form-item>
+ <el-form-item>
+ <el-button type="primary" @click="handleQuery"><Icon icon="ep:search" />鎼滅储</el-button>
+ <el-button @click="resetQuery"><Icon icon="ep:refresh" />閲嶇疆</el-button>
+ </el-form-item>
+</el-form>
+```
+
+### 2. 鍒楄〃椤� - 琛ㄦ牸鏂板鍒�
+
+```html
+<el-table v-loading="loading" :data="list">
+ <el-table-column label="浜у搧缂栫爜" align="center" prop="productCode" />
+ <el-table-column label="浜у搧鍚嶇О" align="center" prop="productName" />
+ <el-table-column label="褰掓。鏁伴噺" align="center" prop="archiveCount" width="100" />
+ <el-table-column label="鏇存柊浜�" align="center" prop="updaterNickname" />
+ <el-table-column label="鏇存柊鏃堕棿" align="center" prop="updateTime" width="180" />
+ <el-table-column label="鎿嶄綔" align="center" width="100">
+ <template #default="scope">
+ <el-button link type="primary" @click="handleDetail(scope.row.productCode)"
+ v-hasPermi="['mes:pd-archive:query']">璇︽儏</el-button>
+ </template>
+ </el-table-column>
+</el-table>
+```
+
+### 3. 璇︽儏寮圭獥/椤甸潰 - 鏂板
+
+```html
+<!-- 鎸変骇鍝佺紪鐮佸彲鑳借繑鍥炲涓」鐩紝鐢� tab 鎴栨墜椋庣惔灞曠ず -->
+<el-tabs v-model="activeProject" type="border-card">
+ <el-tab-pane v-for="(detail, index) in detailList" :key="detail.project.id"
+ :label="detail.project.taskName" :name="String(index)">
+
+ <!-- 椤圭洰淇℃伅 -->
+ <el-descriptions :column="3" border>
+ <el-descriptions-item label="浠诲姟缂栫爜">{{ detail.project.taskCode }}</el-descriptions-item>
+ <el-descriptions-item label="浠诲姟鍚嶇О">{{ detail.project.taskName }}</el-descriptions-item>
+ <el-descriptions-item label="浜у搧缂栫爜">{{ detail.project.productCode }}</el-descriptions-item>
+ <el-descriptions-item label="浜у搧鍚嶇О">{{ detail.project.productName }}</el-descriptions-item>
+ <el-descriptions-item label="鐗堟湰鍙�">{{ detail.project.version }}</el-descriptions-item>
+ <el-descriptions-item label="涓昏璁″笀">{{ detail.project.chiefDesignerNickname }}</el-descriptions-item>
+ <el-descriptions-item label="瀹℃牳浜�">{{ detail.project.reviewerNickname }}</el-descriptions-item>
+ <el-descriptions-item label="璁″垝瀹屾垚鏃堕棿">{{ detail.project.planFinishTime }}</el-descriptions-item>
+ </el-descriptions>
+
+ <!-- 褰掓。璁板綍鍒楄〃 -->
+ <el-card header="褰掓。璁板綍" style="margin-top: 16px">
+ <el-table :data="detail.archives" border>
+ <el-table-column label="褰掓。缂栧彿" prop="archiveCode" />
+ <el-table-column label="褰掓。浜�" prop="archiverNickname" />
+ <el-table-column label="褰掓。鐘舵��" prop="archiveStatus">
+ <template #default="scope">
+ <dict-tag :type="DICT_TYPE.MES_PD_ARCHIVE_STATUS" :value="scope.row.archiveStatus" />
+ </template>
+ </el-table-column>
+ <el-table-column label="褰掓。鏃堕棿" prop="archiveTime" width="180" />
+ <el-table-column label="澶囨敞" prop="remark" show-overflow-tooltip />
+ </el-table>
+ </el-card>
+
+ <!-- 璁捐璧勬枡鍒楄〃 -->
+ <el-card header="璁捐璧勬枡" style="margin-top: 16px">
+ <el-table :data="detail.documents" border>
+ <el-table-column label="璧勬枡鍚嶇О" prop="documentName" />
+ <el-table-column label="璧勬枡绫诲瀷" prop="documentType">
+ <template #default="scope">
+ <dict-tag :type="DICT_TYPE.MES_PD_DOCUMENT_TYPE" :value="scope.row.documentType" />
+ </template>
+ </el-table-column>
+ <el-table-column label="鐗堟湰" prop="documentVersion" width="80" />
+ <el-table-column label="鏂囦欢鍚�" prop="fileName" />
+ <el-table-column label="涓婁紶浜�" prop="uploadUserNickname" />
+ <el-table-column label="涓婁紶鏃堕棿" prop="uploadTime" width="180" />
+ <el-table-column label="鎿嶄綔" width="80">
+ <template #default="scope">
+ <el-button v-if="scope.row.fileUrl" link type="primary" @click="handleDownload(scope.row)">涓嬭浇</el-button>
+ </template>
+ </el-table-column>
+ </el-table>
+ </el-card>
+
+ </el-tab-pane>
+</el-tabs>
+```
+
+### 4. API 鎺ュ彛瀹氫箟
+
+鏂囦欢璺緞锛歚src/api/mes/pd/archive/index.ts`
+
+```ts
+import request from '@/config/axios'
+
+// 鑾峰緱褰掓。鍙拌处鍒嗛〉锛堟寜椤圭洰/浜у搧鑱氬悎锛�
+export const getArchivePage = (params) => {
+ return request.get({ url: '/mes/pd/archive/page', params })
+}
+
+// 鑾峰緱褰掓。鍙拌处璇︽儏锛堟寜浜у搧缂栫爜锛�
+export const getArchiveDetailByProduct = (productCode: string) => {
+ return request.get({ url: '/mes/pd/archive/detail-by-product', params: { productCode } })
+}
+
+// 鍒涘缓褰掓。鍙拌处
+export const createArchive = (data) => {
+ return request.post({ url: '/mes/pd/archive/create', data })
+}
+
+// 鏇存柊褰掓。鍙拌处
+export const updateArchive = (data) => {
+ return request.put({ url: '/mes/pd/archive/update', data })
+}
+
+// 鍒犻櫎褰掓。鍙拌处
+export const deleteArchive = (id: number) => {
+ return request.delete({ url: '/mes/pd/archive/delete?id=' + id })
+}
+
+// 鑾峰緱褰掓。鍙拌处
+export const getArchive = (id: number) => {
+ return request.get({ url: '/mes/pd/archive/get?id=' + id })
+}
+
+// 瀵煎嚭褰掓。鍙拌处 Excel
+export const exportArchiveExcel = (params) => {
+ return request.download({ url: '/mes/pd/archive/export-excel', params })
+}
+```
+
+### 5. data 鏁版嵁
+
+```js
+const queryParams = reactive({
+ pageNo: 1,
+ pageSize: 10,
+ archiveCode: undefined,
+ projectId: undefined,
+ archiveStatus: undefined,
+ productCode: undefined,
+ productName: undefined,
+})
+
+const detailList = ref([])
+const detailVisible = ref(false)
+const activeProject = ref('0')
+```
+
+### 6. 鏂规硶
+
+```js
+// 鏌ョ湅璇︽儏锛堟寜浜у搧缂栫爜锛�
+const handleDetail = async (productCode) => {
+ const res = await ArchiveApi.getArchiveDetailByProduct(productCode)
+ detailList.value = res
+ activeProject.value = '0'
+ detailVisible.value = true
+}
+```
+
+## 娉ㄦ剰浜嬮」
+
+- **鍒嗛〉鑱氬悎閫昏緫**锛歚/page` 鎺ュ彛鎸� `project_id` 鍒嗙粍锛屾瘡缁勫彇鏈�鏂颁竴鏉″綊妗ｈ褰曪紙`MAX(id)`锛夛紝鎵�浠� `updater` 鍜� `updateTime` 鏄缁勬渶鏂板綊妗ｇ殑鏇存柊淇℃伅
+- **璇︽儏鎺ュ彛鍙傛暟鍙樺寲**锛氫粠 `projectId` 鏀逛负 `productCode`锛屽洜涓哄墠绔垪琛ㄥ睍绀虹殑鏄骇鍝佺淮搴︼紝鐐瑰嚮璇︽儏鏃朵紶浜у搧缂栫爜鏇磋嚜鐒�
+- **璇︽儏杩斿洖鍒楄〃**锛歚detail-by-product` 杩斿洖 `List`锛屽洜涓哄悓涓�浜у搧缂栫爜鍙兘鍏宠仈澶氫釜璁捐椤圭洰锛堝涓嶅悓鐗堟湰锛夛紝鍓嶇鐢� tab 鍒囨崲灞曠ず
+- **瀛楀吀绫诲瀷**锛�
+ - 褰掓。鐘舵�侊細`mes_pd_archive_status`锛�0=寰呭綊妗� 1=宸插綊妗ｏ級
+ - 椤圭洰鐘舵�侊細`mes_pd_project_status`锛�0=寰呭彂甯� 1=寰呬笂浼� 2=寰呭鏍� 3=寰呭綊妗� 4=宸插綊妗ｏ級
+ - 璧勬枡绫诲瀷锛歚mes_pd_document_type`
diff --git a/docs/product_design.md b/docs/product_design.md
new file mode 100644
index 0000000..519aef3
--- /dev/null
+++ b/docs/product_design.md
@@ -0,0 +1,301 @@
+# 浜у搧璁捐
+
+## 娑夊強椤甸潰
+
+- 璁捐椤圭洰鍒楄〃椤碉紙`mes/pd/project/index`锛�
+- 璁捐椤圭洰璇︽儏/鏂板/缂栬緫寮圭獥
+- 璧勬枡瀛愯〃绠＄悊寮圭獥
+- 璧勬枡瀹℃牳寮圭獥
+- 褰掓。鍙拌处鍒楄〃椤碉紙`mes/pd/archive/index`锛�
+- 褰掓。鍙拌处璇︽儏/鏂板/缂栬緫寮圭獥
+
+## 鐘舵�佹祦杞�
+
+**寰呭彂甯�(0) 鈫� 寰呬笂浼�(1) 鈫� 寰呭鏍�(2) 鈫� 寰呭綊妗�(3) 鈫� 宸插綊妗�(4)**
+
+| 鐘舵�佸�� | 鐘舵�佸悕 | 鍏佽鎿嶄綔 |
+|--------|--------|----------|
+| 0 | 寰呭彂甯� | 淇敼銆佸垹闄ゃ�佸彂甯� |
+| 1 | 寰呬笂浼� | 涓婁紶璧勬枡 |
+| 2 | 寰呭鏍� | 瀹℃牳 |
+| 3 | 寰呭綊妗� | 褰掓。 |
+| 4 | 宸插綊妗� | 鏃� |
+
+## API
+
+### 璁捐椤圭洰
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| POST | /mes/pd/project/create | 鍒涘缓璁捐椤圭洰 |
+| PUT | /mes/pd/project/update | 鏇存柊璁捐椤圭洰 |
+| DELETE | /mes/pd/project/delete | 鍒犻櫎璁捐椤圭洰 |
+| GET | /mes/pd/project/get | 鑾峰彇璁捐椤圭洰璇︽儏 |
+| GET | /mes/pd/project/page | 鑾峰彇璁捐椤圭洰鍒嗛〉 |
+| GET | /mes/pd/project/export-excel | 瀵煎嚭璁捐椤圭洰Excel |
+| PUT | /mes/pd/project/publish | 鍙戝竷锛堝緟鍙戝竷鈫掑緟涓婁紶锛� |
+| PUT | /mes/pd/project/upload | 涓婁紶璧勬枡锛堝緟涓婁紶鈫掑緟瀹℃牳锛夛紝**鑷姩鍒涘缓璧勬枡瀹℃牳璁板綍** |
+| PUT | /mes/pd/project/audit | 瀹℃牳锛堝緟瀹℃牳鈫掑緟褰掓。锛� |
+| PUT | /mes/pd/project/archive | 褰掓。锛堝緟褰掓。鈫掑凡褰掓。锛夛紝**鑷姩鍒涘缓褰掓。鍙拌处璁板綍** |
+
+**鍒涘缓/鏇存柊璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭～ | 璇存槑 |
+|------|------|------|------|
+| id | Long | 鍚︼紙鏇存柊鏃跺繀濉級 | 缂栧彿 |
+| taskCode | String | 鏄� | 浠诲姟缂栫爜 |
+| taskName | String | 鏄� | 浠诲姟鍚嶇О |
+| productCode | String | 鍚� | 浜у搧缂栫爜 |
+| productName | String | 鍚� | 浜у搧鍚嶇О |
+| version | String | 鍚� | 鐗堟湰鍙� |
+| chiefDesigner | Long | 鍚� | 涓昏璁″笀锛堢敤鎴稩D锛� |
+| reviewer | Long | 鍚� | 瀹℃牳浜猴紙鐢ㄦ埛ID锛� |
+| planFinishTime | LocalDateTime | 鍚� | 璁″垝瀹屾垚鏃堕棿 |
+| remark | String | 鍚� | 澶囨敞 |
+
+**鍒嗛〉璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭～ | 璇存槑 |
+|------|------|------|------|
+| taskCode | String | 鍚� | 浠诲姟缂栫爜锛堟ā绯婏級 |
+| taskName | String | 鍚� | 浠诲姟鍚嶇О锛堟ā绯婏級 |
+| productCode | String | 鍚� | 浜у搧缂栫爜锛堟ā绯婏級 |
+| productName | String | 鍚� | 浜у搧鍚嶇О锛堟ā绯婏級 |
+| status | Integer | 鍚� | 鐘舵�� |
+| planFinishTime | LocalDateTime[] | 鍚� | 璁″垝瀹屾垚鏃堕棿鑼冨洿 |
+
+**鍝嶅簲锛�** 鍦ㄥ熀纭�瀛楁涓婇澶栧寘鍚� `chiefDesignerNickname`锛堜富璁捐甯堝悕绉帮級銆乣reviewerNickname`锛堝鏍镐汉鍚嶇О锛�
+
+### 璁捐璧勬枡
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| POST | /mes/pd/document/create | 鍒涘缓璁捐璧勬枡 |
+| PUT | /mes/pd/document/update | 鏇存柊璁捐璧勬枡 |
+| DELETE | /mes/pd/document/delete | 鍒犻櫎璁捐璧勬枡 |
+| GET | /mes/pd/document/get | 鑾峰彇璁捐璧勬枡璇︽儏 |
+| GET | /mes/pd/document/page | 鑾峰彇璁捐璧勬枡鍒嗛〉 |
+| GET | /mes/pd/document/export-excel | 瀵煎嚭璁捐璧勬枡Excel |
+
+**鍒涘缓/鏇存柊璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭～ | 璇存槑 |
+|------|------|------|------|
+| id | Long | 鍚︼紙鏇存柊鏃跺繀濉級 | 缂栧彿 |
+| projectId | Long | 鏄� | 璁捐椤圭洰ID |
+| documentType | String | 鍚� | 璧勬枡绫诲瀷锛堝瓧鍏� mes_pd_document_type锛� |
+| documentName | String | 鏄� | 璧勬枡鍚嶇О |
+| documentVersion | String | 鍚� | 鐗堟湰 |
+| fileName | String | 鍚� | 鏂囦欢鍚� |
+| uploadUserId | Long | 鍚� | 涓婁紶浜猴紙鐢ㄦ埛ID锛� |
+| uploadTime | LocalDateTime | 鍚� | 涓婁紶鏃堕棿 |
+| fileUrl | String | 鍚� | 鏂囦欢URL锛堥�氳繃 `/infra/file/upload` 涓婁紶鍚庤幏鍙栵級 |
+| remark | String | 鍚� | 澶囨敞 |
+
+**鍝嶅簲锛�** 鍦ㄥ熀纭�瀛楁涓婇澶栧寘鍚� `uploadUserNickname`锛堜笂浼犱汉鍚嶇О锛夈�乣fileUrl`锛堟枃浠禪RL锛�
+
+### 璧勬枡瀹℃牳
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| POST | /mes/pd/document-audit/create | 鍒涘缓璧勬枡瀹℃牳锛�**涓婁紶璧勬枡鏃跺悗绔嚜鍔ㄨ皟鐢紝鍓嶇鏃犻渶鍗曠嫭璋冪敤**锛� |
+| PUT | /mes/pd/document-audit/update | 鏇存柊璧勬枡瀹℃牳 |
+| DELETE | /mes/pd/document-audit/delete | 鍒犻櫎璧勬枡瀹℃牳 |
+| GET | /mes/pd/document-audit/get | 鑾峰彇璧勬枡瀹℃牳璇︽儏 |
+| GET | /mes/pd/document-audit/page | 鑾峰彇璧勬枡瀹℃牳鍒嗛〉 |
+| GET | /mes/pd/document-audit/export-excel | 瀵煎嚭璧勬枡瀹℃牳Excel |
+
+**鍒涘缓/鏇存柊璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭～ | 璇存槑 |
+|------|------|------|------|
+| id | Long | 鍚︼紙鏇存柊鏃跺繀濉級 | 缂栧彿 |
+| auditNo | String | 鏄� | 瀹℃牳鍗曞彿锛堢紪鐮佽鍒� PD_DOCUMENT_AUDIT_CODE 鑷姩鐢熸垚锛� |
+| documentId | Long | 鏄� | 璧勬枡ID |
+| documentName | String | 鍚� | 璧勬枡鍚嶇О锛堝啑浣欙級 |
+| documentVersion | String | 鍚� | 璧勬枡鐗堟湰锛堝啑浣欙級 |
+| reviewer | Long | 鍚� | 瀹℃牳浜猴紙鐢ㄦ埛ID锛岃嚜鍔ㄥ彇椤圭洰鐨勫鏍镐汉锛� |
+| auditStatus | Integer | 鍚� | 瀹℃牳鐘舵�侊紙瀛楀吀 mes_pd_document_audit_status锛� |
+| auditTime | LocalDateTime | 鍚� | 瀹℃牳鏃堕棿 |
+| remark | String | 鍚� | 澶囨敞 |
+
+**鍝嶅簲锛�** 鍦ㄥ熀纭�瀛楁涓婇澶栧寘鍚� `reviewerNickname`锛堝鏍镐汉鍚嶇О锛�
+
+### 褰掓。鍙拌处
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| POST | /mes/pd/archive/create | 鍒涘缓褰掓。鍙拌处锛�**褰掓。鏃跺悗绔嚜鍔ㄨ皟鐢紝鍓嶇鏃犻渶鍗曠嫭璋冪敤**锛� |
+| PUT | /mes/pd/archive/update | 鏇存柊褰掓。鍙拌处 |
+| DELETE | /mes/pd/archive/delete | 鍒犻櫎褰掓。鍙拌处 |
+| GET | /mes/pd/archive/get | 鑾峰彇褰掓。鍙拌处璇︽儏 |
+| GET | /mes/pd/archive/page | 鑾峰彇褰掓。鍙拌处鍒嗛〉 |
+| GET | /mes/pd/archive/export-excel | 瀵煎嚭褰掓。鍙拌处Excel |
+
+**鍒涘缓/鏇存柊璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭～ | 璇存槑 |
+|------|------|------|------|
+| id | Long | 鍚︼紙鏇存柊鏃跺繀濉級 | 缂栧彿 |
+| archiveCode | String | 鏄� | 褰掓。缂栧彿锛堢紪鐮佽鍒� PD_ARCHIVE_CODE 鑷姩鐢熸垚锛� |
+| projectId | Long | 鏄� | 璁捐椤圭洰ID |
+| archiver | Long | 鍚� | 褰掓。浜猴紙鐢ㄦ埛ID锛岃嚜鍔ㄥ彇褰撳墠鐧诲綍鐢ㄦ埛锛� |
+| archiveStatus | Integer | 鍚� | 褰掓。鐘舵�侊紙瀛楀吀 mes_pd_archive_status锛� |
+| archiveTime | LocalDateTime | 鍚� | 褰掓。鏃堕棿锛堣嚜鍔ㄥ彇褰撳墠鏃堕棿锛� |
+| remark | String | 鍚� | 澶囨敞 |
+
+**鍝嶅簲锛�** 鍦ㄥ熀纭�瀛楁涓婇澶栧寘鍚� `archiverNickname`锛堝綊妗ｄ汉鍚嶇О锛夈�乣taskCode`锛堜换鍔＄紪鐮侊級銆乣taskName`锛堜换鍔″悕绉帮級
+
+## 鍓嶇淇敼鐐�
+
+### 1. 璁捐椤圭洰鍒楄〃椤�
+
+```html
+<!-- 鐘舵�佹爣绛� -->
+<el-tag :type="getStatusTagType(row.status)">
+ {{ getStatusLabel(row.status) }}
+</el-tag>
+
+<!-- 鐘舵�佹祦杞寜閽� -->
+<el-button v-if="row.status === 0" @click="handlePublish(row.id)" type="primary">鍙戝竷</el-button>
+<el-button v-if="row.status === 1" @click="handleUpload(row.id)" type="warning">涓婁紶璧勬枡</el-button>
+<el-button v-if="row.status === 2" @click="handleAudit(row.id)" type="success">瀹℃牳</el-button>
+<el-button v-if="row.status === 3" @click="handleArchive(row.id)" type="danger">褰掓。</el-button>
+```
+
+### 2. data 鏁版嵁
+
+```js
+data() {
+ return {
+ // 鐘舵�佹祦杞珹PI鏄犲皠
+ statusFlowApi: {
+ 0: publishProject,
+ 1: uploadProject,
+ 2: auditProject,
+ 3: archiveProject,
+ },
+ }
+}
+```
+
+### 3. 鏂规硶
+
+```js
+// 鐘舵�佹祦杞�
+handlePublish(id) {
+ publishProject(id).then(() => { this.getList() })
+},
+handleUpload(id) {
+ uploadProject(id).then(() => { this.getList() })
+},
+handleAudit(id) {
+ auditProject(id).then(() => { this.getList() })
+},
+handleArchive(id) {
+ archiveProject(id).then(() => { this.getList() })
+},
+
+// 璧勬枡瀛愯〃 - 鎵撳紑寮圭獥
+handleDocument(projectId) {
+ this.documentOpen = true
+ this.documentProjectId = projectId
+ this.getDocumentList()
+},
+```
+
+### 4. API 瀹氫箟
+
+```js
+// 璁捐椤圭洰
+export function createProject(data) { return request({ url: '/mes/pd/project/create', method: 'post', data }) }
+export function updateProject(data) { return request({ url: '/mes/pd/project/update', method: 'put', data }) }
+export function deleteProject(id) { return request({ url: '/mes/pd/project/delete', method: 'delete', params: { id } }) }
+export function getProject(id) { return request({ url: '/mes/pd/project/get', method: 'get', params: { id } }) }
+export function getProjectPage(params) { return request({ url: '/mes/pd/project/page', method: 'get', params }) }
+export function exportProjectExcel(params) { return request({ url: '/mes/pd/project/export-excel', method: 'get', params, responseType: 'blob' }) }
+export function publishProject(id) { return request({ url: '/mes/pd/project/publish', method: 'put', params: { id } }) }
+export function uploadProject(id) { return request({ url: '/mes/pd/project/upload', method: 'put', params: { id } }) }
+export function auditProject(id) { return request({ url: '/mes/pd/project/audit', method: 'put', params: { id } }) }
+export function archiveProject(id) { return request({ url: '/mes/pd/project/archive', method: 'put', params: { id } }) }
+
+// 璁捐璧勬枡
+export function createDocument(data) { return request({ url: '/mes/pd/document/create', method: 'post', data }) }
+export function updateDocument(data) { return request({ url: '/mes/pd/document/update', method: 'put', data }) }
+export function deleteDocument(id) { return request({ url: '/mes/pd/document/delete', method: 'delete', params: { id } }) }
+export function getDocument(id) { return request({ url: '/mes/pd/document/get', method: 'get', params: { id } }) }
+export function getDocumentPage(params) { return request({ url: '/mes/pd/document/page', method: 'get', params }) }
+
+// 鏂囦欢涓婁紶锛堥�氱敤鎺ュ彛锛屼笂浼犲悗杩斿洖URL锛屽瓨鍏ヨ祫鏂欒〃 fileUrl 瀛楁锛�
+export function uploadFile(file, directory) { return request({ url: '/infra/file/upload', method: 'post', data: { file, directory }, headers: { 'Content-Type': 'multipart/form-data' } }) }
+
+// 璧勬枡瀹℃牳锛堝墠绔棤闇�璋冪敤 create锛屼笂浼犺祫鏂欐椂鍚庣鑷姩鍒涘缓锛�
+export function updateDocumentAudit(data) { return request({ url: '/mes/pd/document-audit/update', method: 'put', data }) }
+export function deleteDocumentAudit(id) { return request({ url: '/mes/pd/document-audit/delete', method: 'delete', params: { id } }) }
+export function getDocumentAuditPage(params) { return request({ url: '/mes/pd/document-audit/page', method: 'get', params }) }
+
+// 褰掓。鍙拌处锛堝墠绔棤闇�璋冪敤 create锛屽綊妗ｆ椂鍚庣鑷姩鍒涘缓锛�
+export function updateArchive(data) { return request({ url: '/mes/pd/archive/update', method: 'put', data }) }
+export function deleteArchive(id) { return request({ url: '/mes/pd/archive/delete', method: 'delete', params: { id } }) }
+export function getArchive(id) { return request({ url: '/mes/pd/archive/get', method: 'get', params: { id } }) }
+export function getArchivePage(params) { return request({ url: '/mes/pd/archive/page', method: 'get', params }) }
+export function exportArchiveExcel(params) { return request({ url: '/mes/pd/archive/export-excel', method: 'get', params, responseType: 'blob' }) }
+```
+
+### 5. 璧勬枡瀛愯〃 - 鏂囦欢涓婁紶缁勪欢
+
+```html
+<!-- 璁捐璧勬枡鏂板/缂栬緫寮圭獥涓坊鍔犳枃浠朵笂浼� -->
+<el-form-item label="鏂囦欢" prop="fileUrl">
+ <UploadFile v-model="formData.fileUrl" :limit="1" />
+</el-form-item>
+
+<!-- 璧勬枡鍒楄〃涓樉绀烘枃浠堕摼鎺� -->
+<el-table-column label="鏂囦欢" prop="fileUrl">
+ <template #default="{ row }">
+ <el-link v-if="row.fileUrl" :href="row.fileUrl" target="_blank" type="primary">
+ {{ row.fileName || '鏌ョ湅鏂囦欢' }}
+ </el-link>
+ <span v-else>-</span>
+ </template>
+</el-table-column>
+```
+
+```js
+// 鏂囦欢涓婁紶鍥炶皟
+handleFileUploadSuccess(url) {
+ this.formData.fileUrl = url
+},
+```
+
+### 6. 瀛楀吀鏁版嵁鏇存柊 SQL
+
+```sql
+UPDATE system_dict_data SET label = '寰呭彂甯�' WHERE dict_type = 'mes_pd_project_status' AND value = '0';
+UPDATE system_dict_data SET label = '寰呬笂浼�' WHERE dict_type = 'mes_pd_project_status' AND value = '1';
+UPDATE system_dict_data SET label = '寰呭鏍�' WHERE dict_type = 'mes_pd_project_status' AND value = '2';
+UPDATE system_dict_data SET label = '寰呭綊妗�' WHERE dict_type = 'mes_pd_project_status' AND value = '3';
+UPDATE system_dict_data SET label = '宸插綊妗�' WHERE dict_type = 'mes_pd_project_status' AND value = '4';
+```
+
+## 缂栫爜瑙勫垯閰嶇疆
+
+闇�瑕佸湪缂栫爜瑙勫垯绠＄悊涓柊澧炰互涓嬩袱鏉¤鍒欙細
+
+| 瑙勫垯浠ｇ爜 | 瑙勫垯鍚嶇О | 璇存槑 |
+|----------|----------|------|
+| PD_DOCUMENT_AUDIT_CODE | 璧勬枡瀹℃牳鍗曠紪鐮� | 涓婁紶璧勬枡鏃惰嚜鍔ㄧ敓鎴愬鏍稿崟鍙� |
+| PD_ARCHIVE_CODE | 褰掓。鍙拌处缂栫爜 | 褰掓。鏃惰嚜鍔ㄧ敓鎴愬綊妗ｇ紪鍙� |
+
+## 娉ㄦ剰浜嬮」
+
+- 璁捐椤圭洰鐘舵�佹祦杞负绾挎��5鐘舵�侊紙0鈫�1鈫�2鈫�3鈫�4锛夛紝涓嶆敮鎸佸洖閫�鎴栧彇娑�
+- 鍙湁寰呭彂甯�(0)鐘舵�佹墠鍏佽淇敼鍜屽垹闄よ璁￠」鐩�
+- 鍒犻櫎璁捐椤圭洰浼氱骇鑱斿垹闄ゅ叾涓嬬殑鎵�鏈夎祫鏂欒褰�
+- 璧勬枡瀛愯〃鐨� `fileUrl` 瀛楁瀛樺偍鏂囦欢URL锛屽墠绔�氳繃 `/infra/file/upload` 閫氱敤鎺ュ彛涓婁紶鏂囦欢鍚庤幏鍙朥RL
+- 璧勬枡瀹℃牳琛ㄤ笌璧勬枡瀛愯〃涓轰竴瀵瑰鍏崇郴锛屼竴鏉¤祫鏂欏彲浠ユ湁澶氭潯瀹℃牳璁板綍
+- 瀛楀吀绫诲瀷闇�瑕佸湪绯荤粺绠＄悊涓厤缃細`mes_pd_project_status`銆乣mes_pd_document_type`銆乣mes_pd_document_audit_status`銆乣mes_pd_archive_status`
+- `mes_pd_document_type`锛堣祫鏂欑被鍨嬶級鐨勫瓧鍏告暟鎹渶瑕佹牴鎹疄闄呬笟鍔¤ˉ鍏�
+- **涓婁紶璧勬枡**鏃跺悗绔嚜鍔ㄤ负椤圭洰涓嬫墍鏈夎祫鏂欏垱寤哄鏍歌褰曪紙瀹℃牳浜�=椤圭洰 reviewer锛屽鏍哥姸鎬�=寰呭鏍革級锛屽墠绔棤闇�鍗曠嫭璋冪敤 `POST /mes/pd/document-audit/create`
+- **褰掓。**鏃跺悗绔嚜鍔ㄥ垱寤哄綊妗ｅ彴璐﹁褰曪紙褰掓。浜�=褰撳墠鐧诲綍鐢ㄦ埛锛屽綊妗ｆ椂闂�=褰撳墠鏃堕棿锛夛紝鍓嶇鏃犻渶鍗曠嫭璋冪敤 `POST /mes/pd/archive/create`
+- 涓婁紶璧勬枡鍜屽綊妗ｆ搷浣滄槸浜嬪姟鎬х殑锛岀姸鎬佹洿鏂板拰瀛愯〃鍒涘缓鍦ㄥ悓涓�涓簨鍔′腑锛岃涔堝叏閮ㄦ垚鍔熻涔堝叏閮ㄥ洖婊�
diff --git a/docs/sql/mes_pd_init.sql b/docs/sql/mes_pd_init.sql
new file mode 100644
index 0000000..6289a32
--- /dev/null
+++ b/docs/sql/mes_pd_init.sql
@@ -0,0 +1,160 @@
+-- =============================================
+-- MES 浜у搧璁捐妯″潡 - 鍒濆鍖栬剼鏈�
+-- =============================================
+
+-- ----------------------------
+-- 璁捐椤圭洰
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_project` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `task_code` varchar(64) DEFAULT NULL COMMENT '浠诲姟缂栫爜',
+ `task_name` varchar(255) DEFAULT NULL COMMENT '浠诲姟鍚嶇О',
+ `product_code` varchar(64) DEFAULT NULL COMMENT '浜у搧缂栫爜',
+ `product_name` varchar(255) DEFAULT NULL COMMENT '浜у搧鍚嶇О',
+ `version` varchar(64) DEFAULT NULL COMMENT '鐗堟湰鍙�',
+ `status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵�侊紙0=寰呭彂甯� 1=寰呬笂浼� 2=寰呭鏍� 3=寰呭綊妗� 4=宸插綊妗ｏ級',
+ `chief_designer` bigint DEFAULT NULL COMMENT '涓昏璁″笀',
+ `reviewer` bigint DEFAULT NULL COMMENT '瀹℃牳浜�',
+ `plan_finish_time` datetime DEFAULT NULL COMMENT '璁″垝瀹屾垚鏃堕棿',
+ `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+ `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 璁捐椤圭洰';
+
+-- ----------------------------
+-- 璁捐璧勬枡瀛愯〃
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_document` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `project_id` bigint NOT NULL COMMENT '璁捐椤圭洰ID',
+ `document_type` varchar(64) DEFAULT NULL COMMENT '璧勬枡绫诲瀷',
+ `document_name` varchar(255) DEFAULT NULL COMMENT '璧勬枡鍚嶇О',
+ `document_version` varchar(64) DEFAULT NULL COMMENT '鐗堟湰',
+ `file_name` varchar(255) DEFAULT NULL COMMENT '鏂囦欢鍚�',
+ `upload_user_id` bigint DEFAULT NULL COMMENT '涓婁紶浜�',
+ `upload_time` datetime DEFAULT NULL COMMENT '涓婁紶鏃堕棿',
+ `file_url` varchar(512) DEFAULT NULL COMMENT '鏂囦欢URL锛堥鐣欙級',
+ `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+ `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 璁捐璧勬枡';
+
+-- ----------------------------
+-- 璧勬枡瀹℃牳琛�
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_document_audit` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `audit_no` varchar(64) DEFAULT NULL COMMENT '瀹℃牳鍗曞彿',
+ `document_id` bigint NOT NULL COMMENT '璧勬枡ID',
+ `document_name` varchar(255) DEFAULT NULL COMMENT '璧勬枡鍚嶇О锛堝啑浣欙級',
+ `document_version` varchar(64) DEFAULT NULL COMMENT '璧勬枡鐗堟湰锛堝啑浣欙級',
+ `reviewer` bigint DEFAULT NULL COMMENT '瀹℃牳浜�',
+ `audit_status` tinyint DEFAULT NULL COMMENT '瀹℃牳鐘舵��',
+ `audit_time` datetime DEFAULT NULL COMMENT '瀹℃牳鏃堕棿',
+ `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+ `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 璧勬枡瀹℃牳';
+
+-- ----------------------------
+-- 褰掓。鍙拌处
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS `mes_pd_archive` (
+ `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `archive_code` varchar(64) DEFAULT NULL COMMENT '褰掓。缂栧彿',
+ `project_id` bigint NOT NULL COMMENT '璁捐椤圭洰ID',
+ `archiver` bigint DEFAULT NULL COMMENT '褰掓。浜�',
+ `archive_status` tinyint DEFAULT NULL COMMENT '褰掓。鐘舵��',
+ `archive_time` datetime DEFAULT NULL COMMENT '褰掓。鏃堕棿',
+ `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+ `creator` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�',
+ `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `updater` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�',
+ `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+ `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '绉熸埛缂栧彿',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB COMMENT='MES 褰掓。鍙拌处';
+
+-- ----------------------------
+-- 瀛楀吀绫诲瀷
+-- ----------------------------
+INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('璁捐椤圭洰鐘舵��', 'mes_pd_project_status', 0, '璁捐椤圭洰鐘舵��', '1', NOW(), '1', NOW(), b'0'),
+('璧勬枡绫诲瀷', 'mes_pd_document_type', 0, '璧勬枡绫诲瀷', '1', NOW(), '1', NOW(), b'0'),
+('璧勬枡瀹℃牳鐘舵��', 'mes_pd_document_audit_status', 0, '璧勬枡瀹℃牳鐘舵��', '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鐘舵��', 'mes_pd_archive_status', 0, '褰掓。鐘舵��', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 瀛楀吀鏁版嵁 - 璁捐椤圭洰鐘舵��
+-- ----------------------------
+INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+(0, '寰呭彂甯�', '0', 'mes_pd_project_status', 0, 'info', '', '', '1', NOW(), '1', NOW(), b'0'),
+(1, '寰呬笂浼�', '1', 'mes_pd_project_status', 0, 'primary', '', '', '1', NOW(), '1', NOW(), b'0'),
+(2, '寰呭鏍�', '2', 'mes_pd_project_status', 0, 'warning', '', '', '1', NOW(), '1', NOW(), b'0'),
+(3, '寰呭綊妗�', '3', 'mes_pd_project_status', 0, 'success', '', '', '1', NOW(), '1', NOW(), b'0'),
+(4, '宸插綊妗�', '4', 'mes_pd_project_status', 0, 'danger', '', '', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 瀛楀吀鏁版嵁 - 璧勬枡瀹℃牳鐘舵��
+-- ----------------------------
+INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+(0, '寰呭鏍�', '0', 'mes_pd_document_audit_status', 0, 'info', '', '', '1', NOW(), '1', NOW(), b'0'),
+(1, '瀹℃牳閫氳繃', '1', 'mes_pd_document_audit_status', 0, 'success', '', '', '1', NOW(), '1', NOW(), b'0'),
+(2, '瀹℃牳涓嶉�氳繃', '2', 'mes_pd_document_audit_status', 0, 'danger', '', '', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 瀛楀吀鏁版嵁 - 褰掓。鐘舵��
+-- ----------------------------
+INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+(0, '寰呭綊妗�', '0', 'mes_pd_archive_status', 0, 'info', '', '', '1', NOW(), '1', NOW(), b'0'),
+(1, '宸插綊妗�', '1', 'mes_pd_archive_status', 0, 'success', '', '', '1', NOW(), '1', NOW(), b'0');
+
+-- ----------------------------
+-- 鑿滃崟 - 涓�绾х洰褰曪細浜у搧璁捐
+-- 娉ㄦ剰锛歱arent_id 闇�瑕佹牴鎹疄闄匨ES鐖惰彍鍗旾D璋冩暣
+-- ----------------------------
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('浜у搧璁捐', '', 2, 20, 0, 'pd', '', '', 0, '1', NOW(), '1', NOW(), b'0');
+SET @pd_menu_id = LAST_INSERT_ID();
+
+-- 浜岀骇鑿滃崟锛氳璁￠」鐩�
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('璁捐椤圭洰', '', 2, 1, @pd_menu_id, 'project', '', 'mes/pd/project/index', 0, '1', NOW(), '1', NOW(), b'0');
+SET @project_menu_id = LAST_INSERT_ID();
+
+-- 璁捐椤圭洰鎸夐挳鏉冮檺
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('璁捐椤圭洰鏌ヨ', 'mes:pd-project:query', 3, 1, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰鍒涘缓', 'mes:pd-project:create', 3, 2, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰鏇存柊', 'mes:pd-project:update', 3, 3, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰鍒犻櫎', 'mes:pd-project:delete', 3, 4, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('璁捐椤圭洰瀵煎嚭', 'mes:pd-project:export', 3, 5, @project_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0');
+
+-- 浜岀骇鑿滃崟锛氬綊妗ｅ彴璐�
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('褰掓。鍙拌处', '', 2, 2, @pd_menu_id, 'archive', '', 'mes/pd/archive/index', 0, '1', NOW(), '1', NOW(), b'0');
+SET @archive_menu_id = LAST_INSERT_ID();
+
+-- 褰掓。鍙拌处鎸夐挳鏉冮檺
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES
+('褰掓。鍙拌处鏌ヨ', 'mes:pd-archive:query', 3, 1, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处鍒涘缓', 'mes:pd-archive:create', 3, 2, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处鏇存柊', 'mes:pd-archive:update', 3, 3, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处鍒犻櫎', 'mes:pd-archive:delete', 3, 4, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0'),
+('褰掓。鍙拌处瀵煎嚭', 'mes:pd-archive:export', 3, 5, @archive_menu_id, '', '', '', 0, '1', NOW(), '1', NOW(), b'0');
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/MesPdArchiveController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/MesPdArchiveController.java
new file mode 100644
index 0000000..990d82d
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/MesPdArchiveController.java
@@ -0,0 +1,146 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.archive;
+
+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.pd.archive.vo.*;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.archive.MesPdArchiveDO;
+import cn.iocoder.yudao.module.mes.service.pd.archive.MesPdArchiveService;
+import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
+import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+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.*;
+import java.util.stream.Collectors;
+
+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/pd/archive")
+@Validated
+public class MesPdArchiveController {
+
+ @Resource
+ private MesPdArchiveService archiveService;
+
+ @Resource
+ private AdminUserApi adminUserApi;
+
+ @PostMapping("/create")
+ @Operation(summary = "鍒涘缓褰掓。鍙拌处")
+ @PreAuthorize("@ss.hasPermission('mes:pd-archive:create')")
+ public CommonResult<Long> createArchive(@Valid @RequestBody MesPdArchiveSaveReqVO createReqVO) {
+ return success(archiveService.createArchive(createReqVO));
+ }
+
+ @PutMapping("/update")
+ @Operation(summary = "鏇存柊褰掓。鍙拌处")
+ @PreAuthorize("@ss.hasPermission('mes:pd-archive:update')")
+ public CommonResult<Boolean> updateArchive(@Valid @RequestBody MesPdArchiveSaveReqVO updateReqVO) {
+ archiveService.updateArchive(updateReqVO);
+ return success(true);
+ }
+
+ @DeleteMapping("/delete")
+ @Operation(summary = "鍒犻櫎褰掓。鍙拌处")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-archive:delete')")
+ public CommonResult<Boolean> deleteArchive(@RequestParam("id") Long id) {
+ archiveService.deleteArchive(id);
+ return success(true);
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱褰掓。鍙拌处")
+ @Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
+ @PreAuthorize("@ss.hasPermission('mes:pd-archive:query')")
+ public CommonResult<MesPdArchiveRespVO> getArchive(@RequestParam("id") Long id) {
+ MesPdArchiveDO archive = archiveService.getArchive(id);
+ if (archive == null) {
+ return success(null);
+ }
+ return success(BeanUtils.toBean(archive, MesPdArchiveRespVO.class));
+ }
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱褰掓。鍙拌处鍒嗛〉锛堟寜椤圭洰/浜у搧鑱氬悎锛�")
+ @PreAuthorize("@ss.hasPermission('mes:pd-archive:query')")
+ public CommonResult<PageResult<MesPdArchiveRespVO>> getArchivePage(@Valid MesPdArchivePageReqVO pageReqVO,
+ Page<MesPdArchiveGroupRespVO> page) {
+ IPage<MesPdArchiveGroupRespVO> archivePage = archiveService.getArchivePageGroupByProject(pageReqVO, page);
+ return CommonResult.success(new PageResult<>(
+ buildArchiveRespVOList(archivePage.getRecords()), archivePage.getTotal()));
+ }
+
+ @GetMapping("/detail-by-product")
+ @Operation(summary = "鑾峰緱褰掓。鍙拌处璇︽儏锛堟寜浜у搧锛�")
+ @Parameter(name = "productCode", description = "浜у搧缂栧彿", required = true, example = "1")
+ @PreAuthorize("@ss.hasPermission('mes:pd-archive:query')")
+ public CommonResult<List<MesPdArchiveDetailRespVO>> getArchiveDetailByProduct(@RequestParam("productCode") String productCode) {
+ return success(archiveService.getArchiveDetailByProductCode(productCode));
+ }
+
+ @GetMapping("/export-excel")
+ @Operation(summary = "瀵煎嚭褰掓。鍙拌处 Excel")
+ @PreAuthorize("@ss.hasPermission('mes:pd-archive:export')")
+ @ApiAccessLog(operateType = EXPORT)
+ public void exportArchiveExcel(@Valid MesPdArchivePageReqVO pageReqVO,
+ HttpServletResponse response) throws IOException {
+ pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
+ IPage<MesPdArchiveGroupRespVO> archivePage = archiveService.getArchivePageGroupByProject(pageReqVO, null);
+ ExcelUtils.write(response, "褰掓。鍙拌处.xls", "鏁版嵁", MesPdArchiveRespVO.class,
+ buildArchiveRespVOList(archivePage.getRecords()));
+ }
+
+ // ==================== 鎷兼帴 VO ====================
+
+ private List<MesPdArchiveRespVO> buildArchiveRespVOList(List<MesPdArchiveGroupRespVO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ // 1. 鎵归噺鑾峰彇鏇存柊浜烘樀绉帮紙updater 鏄� String 绫诲瀷鐨勭敤鎴稩D锛�
+ Set<String> updaterIds = list.stream()
+ .map(MesPdArchiveGroupRespVO::getUpdater)
+ .filter(Objects::nonNull)
+ .collect(Collectors.toSet());
+ Map<Long, AdminUserRespDTO> userMap = Collections.emptyMap();
+ if (!updaterIds.isEmpty()) {
+ Set<Long> userIds = updaterIds.stream()
+ .filter(id -> id.matches("\\d+"))
+ .map(Long::parseLong)
+ .collect(Collectors.toSet());
+ if (!userIds.isEmpty()) {
+ userMap = adminUserApi.getUserMap(userIds);
+ }
+ }
+ // 2. 鎷兼帴 VO
+ Map<Long, AdminUserRespDTO> finalUserMap = userMap;
+ return BeanUtils.toBean(list, MesPdArchiveRespVO.class, vo -> {
+ // productCode銆乸roductName銆乤rchiveCount 宸蹭粠 XML 鏌ヨ鏄犲皠鍒� GroupRespVO
+ // 鏇存柊浜烘樀绉�
+ if (vo.getUpdater() != null && vo.getUpdater().matches("\\d+")) {
+ MapUtils.findAndThen(finalUserMap, Long.parseLong(vo.getUpdater()),
+ user -> vo.setUpdaterNickname(user.getNickname()));
+ }
+ });
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveDetailRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveDetailRespVO.java
new file mode 100644
index 0000000..1ced7b7
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveDetailRespVO.java
@@ -0,0 +1,145 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo;
+
+import cn.iocoder.yudao.framework.excel.core.annotations.DictFormat;
+import cn.iocoder.yudao.framework.excel.core.convert.DictConvert;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+import java.util.List;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 褰掓。鍙拌处璇︽儏锛堟寜浜у搧锛� Response VO")
+@Data
+public class MesPdArchiveDetailRespVO {
+
+ @Schema(description = "椤圭洰淇℃伅")
+ private ProjectInfo project;
+
+ @Schema(description = "褰掓。璁板綍鍒楄〃")
+ private List<ArchiveInfo> archives;
+
+ @Schema(description = "璁捐璧勬枡鍒楄〃")
+ private List<DocumentInfo> documents;
+
+ @Schema(description = "椤圭洰淇℃伅")
+ @Data
+ public static class ProjectInfo {
+
+ @Schema(description = "椤圭洰ID", example = "1")
+ private Long id;
+
+ @Schema(description = "浠诲姟缂栫爜", example = "PD2024001")
+ private String taskCode;
+
+ @Schema(description = "浠诲姟鍚嶇О", example = "鏂颁骇鍝佽璁′换鍔�")
+ private String taskName;
+
+ @Schema(description = "浜у搧缂栫爜", example = "P001")
+ private String productCode;
+
+ @Schema(description = "浜у搧鍚嶇О", example = "娉ㄥ浜у搧A")
+ private String productName;
+
+ @Schema(description = "鐗堟湰鍙�", example = "V1.0")
+ private String version;
+
+ @Schema(description = "椤圭洰鐘舵��", example = "4")
+ @DictFormat(DictTypeConstants.MES_PD_PROJECT_STATUS)
+ private Integer status;
+
+ @Schema(description = "涓昏璁″笀", example = "1")
+ private Long chiefDesigner;
+
+ @Schema(description = "涓昏璁″笀鍚嶇О", example = "寮犱笁")
+ private String chiefDesignerNickname;
+
+ @Schema(description = "瀹℃牳浜�", example = "2")
+ private Long reviewer;
+
+ @Schema(description = "瀹℃牳浜哄悕绉�", example = "鏉庡洓")
+ private String reviewerNickname;
+
+ @Schema(description = "璁″垝瀹屾垚鏃堕棿")
+ private LocalDateTime planFinishTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+ }
+
+ @Schema(description = "褰掓。璁板綍淇℃伅")
+ @Data
+ public static class ArchiveInfo {
+
+ @Schema(description = "褰掓。ID", example = "1")
+ private Long id;
+
+ @Schema(description = "褰掓。缂栧彿", example = "ARC2024001")
+ private String archiveCode;
+
+ @Schema(description = "褰掓。浜�", example = "1")
+ private Long archiver;
+
+ @Schema(description = "褰掓。浜哄悕绉�", example = "鐜嬩簲")
+ private String archiverNickname;
+
+ @Schema(description = "褰掓。鐘舵��", example = "1")
+ @DictFormat(DictTypeConstants.MES_PD_ARCHIVE_STATUS)
+ private Integer archiveStatus;
+
+ @Schema(description = "褰掓。鏃堕棿")
+ private LocalDateTime archiveTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+ }
+
+ @Schema(description = "璁捐璧勬枡淇℃伅")
+ @Data
+ public static class DocumentInfo {
+
+ @Schema(description = "璧勬枡ID", example = "1")
+ private Long id;
+
+ @Schema(description = "璧勬枡绫诲瀷", example = "1")
+ @DictFormat(DictTypeConstants.MES_PD_DOCUMENT_TYPE)
+ private String documentType;
+
+ @Schema(description = "璧勬枡鍚嶇О", example = "浜у搧璁捐鍥�")
+ private String documentName;
+
+ @Schema(description = "璧勬枡鐗堟湰", example = "V1.0")
+ private String documentVersion;
+
+ @Schema(description = "鏂囦欢鍚�", example = "design.pdf")
+ private String fileName;
+
+ @Schema(description = "鏂囦欢URL", example = "/files/design.pdf")
+ private String fileUrl;
+
+ @Schema(description = "涓婁紶浜�", example = "1")
+ private Long uploadUserId;
+
+ @Schema(description = "涓婁紶浜哄悕绉�", example = "璧靛叚")
+ private String uploadUserNickname;
+
+ @Schema(description = "涓婁紶鏃堕棿")
+ private LocalDateTime uploadTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveGroupRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveGroupRespVO.java
new file mode 100644
index 0000000..8a6781e
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveGroupRespVO.java
@@ -0,0 +1,71 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+/**
+ * 褰掓。鍙拌处鍒嗙粍鏌ヨ Response VO
+ * <p>
+ * 鍦ㄥ綊妗ｅ彴璐﹀瓧娈靛熀纭�涓婏紝棰濆鍖呭惈鍏宠仈椤圭洰鐨勪骇鍝佺紪鐮併�佷骇鍝佸悕绉般��
+ * 鐢ㄤ簬 XML mapper 鐨勫垎缁勬煡璇㈢粨鏋滄槧灏勶紝涓嶇牬鍧� MesPdArchiveDO 涓庢暟鎹簱鐨勬槧灏勫叧绯汇��
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@Schema(description = "绠＄悊鍚庡彴 - MES 褰掓。鍙拌处鍒嗙粍鏌ヨ Response VO")
+@Data
+public class MesPdArchiveGroupRespVO {
+
+ // ========== 褰掓。鍙拌处鑷韩瀛楁 ==========
+
+ @Schema(description = "缂栧彿", example = "1024")
+ private Long id;
+
+ @Schema(description = "褰掓。缂栧彿", example = "ARC2024001")
+ private String archiveCode;
+
+ @Schema(description = "璁捐椤圭洰ID", example = "1")
+ private Long projectId;
+
+ @Schema(description = "褰掓。浜�", example = "1")
+ private Long archiver;
+
+ @Schema(description = "褰掓。鐘舵��", example = "0")
+ private Integer archiveStatus;
+
+ @Schema(description = "褰掓。鏃堕棿")
+ private LocalDateTime archiveTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鑰�")
+ private String creator;
+
+ @Schema(description = "鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+ @Schema(description = "鏇存柊浜�")
+ private String updater;
+
+ @Schema(description = "鏇存柊鏃堕棿")
+ private LocalDateTime updateTime;
+
+ // ========== 鍏宠仈椤圭洰瀛楁锛圶ML 鏌ヨ棰濆杩斿洖锛� ==========
+
+ @Schema(description = "浜у搧缂栫爜", example = "P001")
+ private String productCode;
+
+ @Schema(description = "浜у搧鍚嶇О", example = "娉ㄥ浜у搧A")
+ private String productName;
+
+ @Schema(description = "褰掓。璁板綍鏁伴噺", example = "3")
+ private Integer archiveCount;
+
+ private String taskCode;
+ private String taskName;
+
+ private String archiverNickname;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchivePageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchivePageReqVO.java
new file mode 100644
index 0000000..0766fda
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchivePageReqVO.java
@@ -0,0 +1,30 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 褰掓。鍙拌处鍒嗛〉 Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesPdArchivePageReqVO extends PageParam {
+
+ @Schema(description = "褰掓。缂栧彿", example = "ARC2024001")
+ private String archiveCode;
+
+ @Schema(description = "璁捐椤圭洰ID", example = "1")
+ private Long projectId;
+
+ @Schema(description = "褰掓。鐘舵��", example = "0")
+ private Integer archiveStatus;
+
+ @Schema(description = "浜у搧缂栫爜", example = "P001")
+ private String productCode;
+
+ @Schema(description = "浜у搧鍚嶇О", example = "娉ㄥ浜у搧A")
+ private String productName;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveRespVO.java
new file mode 100644
index 0000000..c9d50c0
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveRespVO.java
@@ -0,0 +1,83 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo;
+
+import cn.iocoder.yudao.framework.excel.core.annotations.DictFormat;
+import cn.iocoder.yudao.framework.excel.core.convert.DictConvert;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import cn.idev.excel.annotation.ExcelIgnoreUnannotated;
+import cn.idev.excel.annotation.ExcelProperty;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 褰掓。鍙拌处 Response VO")
+@Data
+@ExcelIgnoreUnannotated
+public class MesPdArchiveRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ @ExcelProperty("缂栧彿")
+ private Long id;
+
+ @Schema(description = "褰掓。缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "ARC2024001")
+ @ExcelProperty("褰掓。缂栧彿")
+ private String archiveCode;
+
+ @Schema(description = "璁捐椤圭洰ID", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ private Long projectId;
+
+ @Schema(description = "浠诲姟缂栫爜", example = "PD2024001")
+ @ExcelProperty("浠诲姟缂栫爜")
+ private String taskCode;
+
+ @Schema(description = "浠诲姟鍚嶇О", example = "鏂颁骇鍝佽璁′换鍔�")
+ @ExcelProperty("浠诲姟鍚嶇О")
+ private String taskName;
+
+ @Schema(description = "浜у搧缂栫爜", example = "P001")
+ @ExcelProperty("浜у搧缂栫爜")
+ private String productCode;
+
+ @Schema(description = "浜у搧鍚嶇О", example = "娉ㄥ浜у搧A")
+ @ExcelProperty("浜у搧鍚嶇О")
+ private String productName;
+
+ @Schema(description = "褰掓。璁板綍鏁伴噺", example = "3")
+ private Integer archiveCount;
+
+ @Schema(description = "褰掓。浜�", example = "1")
+ private Long archiver;
+
+ @Schema(description = "褰掓。浜哄悕绉�", example = "鐜嬩簲")
+ @ExcelProperty("褰掓。浜�")
+ private String archiverNickname;
+
+ @Schema(description = "褰掓。鐘舵��", example = "0")
+ @ExcelProperty(value = "褰掓。鐘舵��", converter = DictConvert.class)
+ @DictFormat(DictTypeConstants.MES_PD_ARCHIVE_STATUS)
+ private Integer archiveStatus;
+
+ @Schema(description = "褰掓。鏃堕棿")
+ @ExcelProperty("褰掓。鏃堕棿")
+ private LocalDateTime archiveTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ @ExcelProperty("澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿", requiredMode = Schema.RequiredMode.REQUIRED)
+ @ExcelProperty("鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+ @Schema(description = "鏇存柊浜�", example = "1")
+ private String updater;
+
+ @Schema(description = "鏇存柊浜哄悕绉�", example = "鏉庡洓")
+ @ExcelProperty("鏇存柊浜�")
+ private String updaterNickname;
+
+ @Schema(description = "鏇存柊鏃堕棿")
+ @ExcelProperty("鏇存柊鏃堕棿")
+ private LocalDateTime updateTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveSaveReqVO.java
new file mode 100644
index 0000000..f6ac767
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/archive/vo/MesPdArchiveSaveReqVO.java
@@ -0,0 +1,37 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import jakarta.validation.constraints.NotBlank;
+import jakarta.validation.constraints.NotNull;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 褰掓。鍙拌处鏂板/淇敼 Request VO")
+@Data
+public class MesPdArchiveSaveReqVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.NOT_REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "褰掓。缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "ARC2024001")
+ @NotBlank(message = "褰掓。缂栧彿涓嶈兘涓虹┖")
+ private String archiveCode;
+
+ @Schema(description = "璁捐椤圭洰ID", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "璁捐椤圭洰ID涓嶈兘涓虹┖")
+ private Long projectId;
+
+ @Schema(description = "褰掓。浜�", example = "1")
+ private Long archiver;
+
+ @Schema(description = "褰掓。鐘舵��", example = "0")
+ private Integer archiveStatus;
+
+ @Schema(description = "褰掓。鏃堕棿")
+ private LocalDateTime archiveTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/MesPdDocumentController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/MesPdDocumentController.java
new file mode 100644
index 0000000..3c84e72
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/MesPdDocumentController.java
@@ -0,0 +1,121 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.document;
+
+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.pd.document.vo.MesPdDocumentPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo.MesPdDocumentRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo.MesPdDocumentSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.document.MesPdDocumentDO;
+import cn.iocoder.yudao.module.mes.service.pd.document.MesPdDocumentService;
+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;
+
+@Tag(name = "绠＄悊鍚庡彴 - MES 璁捐璧勬枡")
+@RestController
+@RequestMapping("/mes/pd/document")
+@Validated
+public class MesPdDocumentController {
+
+ @Resource
+ private MesPdDocumentService documentService;
+
+ @Resource
+ private AdminUserApi adminUserApi;
+
+ @PostMapping("/create")
+ @Operation(summary = "鍒涘缓璁捐璧勬枡")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document:create')")
+ public CommonResult<Long> createDocument(@Valid @RequestBody MesPdDocumentSaveReqVO createReqVO) {
+ return success(documentService.createDocument(createReqVO));
+ }
+
+ @PutMapping("/update")
+ @Operation(summary = "鏇存柊璁捐璧勬枡")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document:update')")
+ public CommonResult<Boolean> updateDocument(@Valid @RequestBody MesPdDocumentSaveReqVO updateReqVO) {
+ documentService.updateDocument(updateReqVO);
+ return success(true);
+ }
+
+ @DeleteMapping("/delete")
+ @Operation(summary = "鍒犻櫎璁捐璧勬枡")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-document:delete')")
+ public CommonResult<Boolean> deleteDocument(@RequestParam("id") Long id) {
+ documentService.deleteDocument(id);
+ return success(true);
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱璁捐璧勬枡")
+ @Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document:query')")
+ public CommonResult<MesPdDocumentRespVO> getDocument(@RequestParam("id") Long id) {
+ MesPdDocumentDO document = documentService.getDocument(id);
+ if (document == null) {
+ return success(null);
+ }
+ return success(buildDocumentRespVOList(Collections.singletonList(document)).get(0));
+ }
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱璁捐璧勬枡鍒嗛〉")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document:query')")
+ public CommonResult<PageResult<MesPdDocumentRespVO>> getDocumentPage(@Valid MesPdDocumentPageReqVO pageReqVO) {
+ PageResult<MesPdDocumentDO> pageResult = documentService.getDocumentPage(pageReqVO);
+ return success(new PageResult<>(buildDocumentRespVOList(pageResult.getList()), pageResult.getTotal()));
+ }
+
+ @GetMapping("/export-excel")
+ @Operation(summary = "瀵煎嚭璁捐璧勬枡 Excel")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document:export')")
+ @ApiAccessLog(operateType = EXPORT)
+ public void exportDocumentExcel(@Valid MesPdDocumentPageReqVO pageReqVO,
+ HttpServletResponse response) throws IOException {
+ pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
+ List<MesPdDocumentDO> list = documentService.getDocumentPage(pageReqVO).getList();
+ // 瀵煎嚭 Excel
+ ExcelUtils.write(response, "璁捐璧勬枡.xls", "鏁版嵁", MesPdDocumentRespVO.class,
+ buildDocumentRespVOList(list));
+ }
+
+ // ==================== 鎷兼帴 VO ====================
+
+ private List<MesPdDocumentRespVO> buildDocumentRespVOList(List<MesPdDocumentDO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ // 1.1 鎵归噺鑾峰彇鍏宠仈鏁版嵁锛堜笂浼犱汉锛�
+ Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(convertSet(list, MesPdDocumentDO::getUploadUserId));
+ // 2. 鎷兼帴 VO
+ return BeanUtils.toBean(list, MesPdDocumentRespVO.class, vo -> {
+ MapUtils.findAndThen(userMap, vo.getUploadUserId(),
+ user -> vo.setUploadUserNickname(user.getNickname()));
+ });
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentPageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentPageReqVO.java
new file mode 100644
index 0000000..44d7470
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentPageReqVO.java
@@ -0,0 +1,24 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璁捐璧勬枡鍒嗛〉 Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesPdDocumentPageReqVO extends PageParam {
+
+ @Schema(description = "璁捐椤圭洰ID", example = "1")
+ private Long projectId;
+
+ @Schema(description = "璧勬枡鍚嶇О", example = "浜у搧璁捐鍥�")
+ private String documentName;
+
+ @Schema(description = "璧勬枡绫诲瀷", example = "drawing")
+ private String documentType;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentRespVO.java
new file mode 100644
index 0000000..54668b6
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentRespVO.java
@@ -0,0 +1,65 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo;
+
+import cn.iocoder.yudao.framework.excel.core.annotations.DictFormat;
+import cn.iocoder.yudao.framework.excel.core.convert.DictConvert;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import cn.idev.excel.annotation.ExcelIgnoreUnannotated;
+import cn.idev.excel.annotation.ExcelProperty;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璁捐璧勬枡 Response VO")
+@Data
+@ExcelIgnoreUnannotated
+public class MesPdDocumentRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ @ExcelProperty("缂栧彿")
+ private Long id;
+
+ @Schema(description = "璁捐椤圭洰ID", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ private Long projectId;
+
+ @Schema(description = "璧勬枡绫诲瀷", example = "drawing")
+ @ExcelProperty(value = "璧勬枡绫诲瀷", converter = DictConvert.class)
+ @DictFormat(DictTypeConstants.MES_PD_DOCUMENT_TYPE)
+ private String documentType;
+
+ @Schema(description = "璧勬枡鍚嶇О", requiredMode = Schema.RequiredMode.REQUIRED, example = "浜у搧璁捐鍥�")
+ @ExcelProperty("璧勬枡鍚嶇О")
+ private String documentName;
+
+ @Schema(description = "鐗堟湰", example = "V1.0")
+ @ExcelProperty("鐗堟湰")
+ private String documentVersion;
+
+ @Schema(description = "鏂囦欢鍚�", example = "design_v1.pdf")
+ @ExcelProperty("鏂囦欢鍚�")
+ private String fileName;
+
+ @Schema(description = "涓婁紶浜�", example = "1")
+ private Long uploadUserId;
+
+ @Schema(description = "涓婁紶浜哄悕绉�", example = "寮犱笁")
+ @ExcelProperty("涓婁紶浜�")
+ private String uploadUserNickname;
+
+ @Schema(description = "涓婁紶鏃堕棿")
+ @ExcelProperty("涓婁紶鏃堕棿")
+ private LocalDateTime uploadTime;
+
+ @Schema(description = "鏂囦欢URL", example = "https://xxx/file.pdf")
+ @ExcelProperty("鏂囦欢URL")
+ private String fileUrl;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ @ExcelProperty("澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿", requiredMode = Schema.RequiredMode.REQUIRED)
+ @ExcelProperty("鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentSaveReqVO.java
new file mode 100644
index 0000000..cbbc65e
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/document/vo/MesPdDocumentSaveReqVO.java
@@ -0,0 +1,46 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import jakarta.validation.constraints.NotBlank;
+import jakarta.validation.constraints.NotNull;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璁捐璧勬枡鏂板/淇敼 Request VO")
+@Data
+public class MesPdDocumentSaveReqVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.NOT_REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "璁捐椤圭洰ID", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ @NotNull(message = "璁捐椤圭洰ID涓嶈兘涓虹┖")
+ private Long projectId;
+
+ @Schema(description = "璧勬枡绫诲瀷", example = "drawing")
+ private String documentType;
+
+ @Schema(description = "璧勬枡鍚嶇О", requiredMode = Schema.RequiredMode.REQUIRED, example = "浜у搧璁捐鍥�")
+ @NotBlank(message = "璧勬枡鍚嶇О涓嶈兘涓虹┖")
+ private String documentName;
+
+ @Schema(description = "鐗堟湰", example = "V1.0")
+ private String documentVersion;
+
+ @Schema(description = "鏂囦欢鍚�", example = "design_v1.pdf")
+ private String fileName;
+
+ @Schema(description = "涓婁紶浜�", example = "1")
+ private Long uploadUserId;
+
+ @Schema(description = "涓婁紶鏃堕棿")
+ private LocalDateTime uploadTime;
+
+ @Schema(description = "鏂囦欢URL", example = "https://xxx/file.pdf")
+ private String fileUrl;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/MesPdDocumentAuditController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/MesPdDocumentAuditController.java
new file mode 100644
index 0000000..423b411
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/MesPdDocumentAuditController.java
@@ -0,0 +1,121 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit;
+
+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.pd.documentaudit.vo.MesPdDocumentAuditPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo.MesPdDocumentAuditRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo.MesPdDocumentAuditSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.documentaudit.MesPdDocumentAuditDO;
+import cn.iocoder.yudao.module.mes.service.pd.documentaudit.MesPdDocumentAuditService;
+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;
+
+@Tag(name = "绠＄悊鍚庡彴 - MES 璧勬枡瀹℃牳")
+@RestController
+@RequestMapping("/mes/pd/document-audit")
+@Validated
+public class MesPdDocumentAuditController {
+
+ @Resource
+ private MesPdDocumentAuditService documentAuditService;
+
+ @Resource
+ private AdminUserApi adminUserApi;
+
+ @PostMapping("/create")
+ @Operation(summary = "鍒涘缓璧勬枡瀹℃牳")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document-audit:create')")
+ public CommonResult<Long> createDocumentAudit(@Valid @RequestBody MesPdDocumentAuditSaveReqVO createReqVO) {
+ return success(documentAuditService.createDocumentAudit(createReqVO));
+ }
+
+ @PutMapping("/update")
+ @Operation(summary = "鏇存柊璧勬枡瀹℃牳")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document-audit:update')")
+ public CommonResult<Boolean> updateDocumentAudit(@Valid @RequestBody MesPdDocumentAuditSaveReqVO updateReqVO) {
+ documentAuditService.updateDocumentAudit(updateReqVO);
+ return success(true);
+ }
+
+ @DeleteMapping("/delete")
+ @Operation(summary = "鍒犻櫎璧勬枡瀹℃牳")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-document-audit:delete')")
+ public CommonResult<Boolean> deleteDocumentAudit(@RequestParam("id") Long id) {
+ documentAuditService.deleteDocumentAudit(id);
+ return success(true);
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱璧勬枡瀹℃牳")
+ @Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document-audit:query')")
+ public CommonResult<MesPdDocumentAuditRespVO> getDocumentAudit(@RequestParam("id") Long id) {
+ MesPdDocumentAuditDO documentAudit = documentAuditService.getDocumentAudit(id);
+ if (documentAudit == null) {
+ return success(null);
+ }
+ return success(buildDocumentAuditRespVOList(Collections.singletonList(documentAudit)).get(0));
+ }
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱璧勬枡瀹℃牳鍒嗛〉")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document-audit:query')")
+ public CommonResult<PageResult<MesPdDocumentAuditRespVO>> getDocumentAuditPage(@Valid MesPdDocumentAuditPageReqVO pageReqVO) {
+ PageResult<MesPdDocumentAuditDO> pageResult = documentAuditService.getDocumentAuditPage(pageReqVO);
+ return success(new PageResult<>(buildDocumentAuditRespVOList(pageResult.getList()), pageResult.getTotal()));
+ }
+
+ @GetMapping("/export-excel")
+ @Operation(summary = "瀵煎嚭璧勬枡瀹℃牳 Excel")
+ @PreAuthorize("@ss.hasPermission('mes:pd-document-audit:export')")
+ @ApiAccessLog(operateType = EXPORT)
+ public void exportDocumentAuditExcel(@Valid MesPdDocumentAuditPageReqVO pageReqVO,
+ HttpServletResponse response) throws IOException {
+ pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
+ List<MesPdDocumentAuditDO> list = documentAuditService.getDocumentAuditPage(pageReqVO).getList();
+ // 瀵煎嚭 Excel
+ ExcelUtils.write(response, "璧勬枡瀹℃牳.xls", "鏁版嵁", MesPdDocumentAuditRespVO.class,
+ buildDocumentAuditRespVOList(list));
+ }
+
+ // ==================== 鎷兼帴 VO ====================
+
+ private List<MesPdDocumentAuditRespVO> buildDocumentAuditRespVOList(List<MesPdDocumentAuditDO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ // 1.1 鎵归噺鑾峰彇鍏宠仈鏁版嵁锛堝鏍镐汉锛�
+ Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(convertSet(list, MesPdDocumentAuditDO::getReviewer));
+ // 2. 鎷兼帴 VO
+ return BeanUtils.toBean(list, MesPdDocumentAuditRespVO.class, vo -> {
+ MapUtils.findAndThen(userMap, vo.getReviewer(),
+ user -> vo.setReviewerNickname(user.getNickname()));
+ });
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditPageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditPageReqVO.java
new file mode 100644
index 0000000..d41bf8f
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditPageReqVO.java
@@ -0,0 +1,24 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璧勬枡瀹℃牳鍒嗛〉 Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesPdDocumentAuditPageReqVO extends PageParam {
+
+ @Schema(description = "璧勬枡ID", example = "1")
+ private Long documentId;
+
+ @Schema(description = "瀹℃牳鍗曞彿", example = "AUD2024001")
+ private String auditNo;
+
+ @Schema(description = "瀹℃牳鐘舵��", example = "0")
+ private Integer auditStatus;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditRespVO.java
new file mode 100644
index 0000000..063c212
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditRespVO.java
@@ -0,0 +1,61 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo;
+
+import cn.iocoder.yudao.framework.excel.core.annotations.DictFormat;
+import cn.iocoder.yudao.framework.excel.core.convert.DictConvert;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import cn.idev.excel.annotation.ExcelIgnoreUnannotated;
+import cn.idev.excel.annotation.ExcelProperty;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璧勬枡瀹℃牳 Response VO")
+@Data
+@ExcelIgnoreUnannotated
+public class MesPdDocumentAuditRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ @ExcelProperty("缂栧彿")
+ private Long id;
+
+ @Schema(description = "瀹℃牳鍗曞彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "AUD2024001")
+ @ExcelProperty("瀹℃牳鍗曞彿")
+ private String auditNo;
+
+ @Schema(description = "璧勬枡ID", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ private Long documentId;
+
+ @Schema(description = "璧勬枡鍚嶇О", example = "浜у搧璁捐鍥�")
+ @ExcelProperty("璧勬枡鍚嶇О")
+ private String documentName;
+
+ @Schema(description = "璧勬枡鐗堟湰", example = "V1.0")
+ @ExcelProperty("璧勬枡鐗堟湰")
+ private String documentVersion;
+
+ @Schema(description = "瀹℃牳浜�", example = "1")
+ private Long reviewer;
+
+ @Schema(description = "瀹℃牳浜哄悕绉�", example = "鏉庡洓")
+ @ExcelProperty("瀹℃牳浜�")
+ private String reviewerNickname;
+
+ @Schema(description = "瀹℃牳鐘舵��", example = "0")
+ @ExcelProperty(value = "瀹℃牳鐘舵��", converter = DictConvert.class)
+ @DictFormat(DictTypeConstants.MES_PD_DOCUMENT_AUDIT_STATUS)
+ private Integer auditStatus;
+
+ @Schema(description = "瀹℃牳鏃堕棿")
+ @ExcelProperty("瀹℃牳鏃堕棿")
+ private LocalDateTime auditTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ @ExcelProperty("澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿", requiredMode = Schema.RequiredMode.REQUIRED)
+ @ExcelProperty("鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditSaveReqVO.java
new file mode 100644
index 0000000..9b39cdc
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/documentaudit/vo/MesPdDocumentAuditSaveReqVO.java
@@ -0,0 +1,41 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import jakarta.validation.constraints.NotBlank;
+import jakarta.validation.constraints.NotNull;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璧勬枡瀹℃牳鏂板/淇敼 Request VO")
+@Data
+public class MesPdDocumentAuditSaveReqVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.NOT_REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "瀹℃牳鍗曞彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "AUD2024001")
+ private String auditNo;
+
+ @Schema(description = "璧勬枡ID", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+ private Long documentId;
+
+ @Schema(description = "璧勬枡鍚嶇О", example = "浜у搧璁捐鍥�")
+ private String documentName;
+
+ @Schema(description = "璧勬枡鐗堟湰", example = "V1.0")
+ private String documentVersion;
+
+ @Schema(description = "瀹℃牳浜�", example = "1")
+ private Long reviewer;
+
+ @Schema(description = "瀹℃牳鐘舵��", example = "0")
+ private Integer auditStatus;
+
+ @Schema(description = "瀹℃牳鏃堕棿")
+ private LocalDateTime auditTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/MesPdProjectController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/MesPdProjectController.java
new file mode 100644
index 0000000..88b79d1
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/MesPdProjectController.java
@@ -0,0 +1,163 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.project;
+
+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.pd.project.vo.MesPdProjectPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo.MesPdProjectRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo.MesPdProjectSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.project.MesPdProjectDO;
+import cn.iocoder.yudao.module.mes.service.pd.project.MesPdProjectService;
+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 java.util.stream.Stream;
+
+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.CollectionUtils.convertSetByFlatMap;
+import static cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils.getLoginUserId;
+
+@Tag(name = "绠＄悊鍚庡彴 - MES 璁捐椤圭洰")
+@RestController
+@RequestMapping("/mes/pd/project")
+@Validated
+public class MesPdProjectController {
+
+ @Resource
+ private MesPdProjectService projectService;
+
+ @Resource
+ private AdminUserApi adminUserApi;
+
+ @PostMapping("/create")
+ @Operation(summary = "鍒涘缓璁捐椤圭洰")
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:create')")
+ public CommonResult<Long> createProject(@Valid @RequestBody MesPdProjectSaveReqVO createReqVO) {
+ return success(projectService.createProject(createReqVO));
+ }
+
+ @PutMapping("/update")
+ @Operation(summary = "鏇存柊璁捐椤圭洰")
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:update')")
+ public CommonResult<Boolean> updateProject(@Valid @RequestBody MesPdProjectSaveReqVO updateReqVO) {
+ projectService.updateProject(updateReqVO);
+ return success(true);
+ }
+
+ @DeleteMapping("/delete")
+ @Operation(summary = "鍒犻櫎璁捐椤圭洰")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:delete')")
+ public CommonResult<Boolean> deleteProject(@RequestParam("id") Long id) {
+ projectService.deleteProject(id);
+ return success(true);
+ }
+
+ @GetMapping("/get")
+ @Operation(summary = "鑾峰緱璁捐椤圭洰")
+ @Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:query')")
+ public CommonResult<MesPdProjectRespVO> getProject(@RequestParam("id") Long id) {
+ MesPdProjectDO project = projectService.getProject(id);
+ if (project == null) {
+ return success(null);
+ }
+ return success(buildProjectRespVOList(Collections.singletonList(project)).get(0));
+ }
+
+ @GetMapping("/page")
+ @Operation(summary = "鑾峰緱璁捐椤圭洰鍒嗛〉")
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:query')")
+ public CommonResult<PageResult<MesPdProjectRespVO>> getProjectPage(@Valid MesPdProjectPageReqVO pageReqVO) {
+ PageResult<MesPdProjectDO> pageResult = projectService.getProjectPage(pageReqVO);
+ return success(new PageResult<>(buildProjectRespVOList(pageResult.getList()), pageResult.getTotal()));
+ }
+
+ @GetMapping("/export-excel")
+ @Operation(summary = "瀵煎嚭璁捐椤圭洰 Excel")
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:export')")
+ @ApiAccessLog(operateType = EXPORT)
+ public void exportProjectExcel(@Valid MesPdProjectPageReqVO pageReqVO,
+ HttpServletResponse response) throws IOException {
+ pageReqVO.setPageSize(PageParam.PAGE_SIZE_NONE);
+ List<MesPdProjectDO> list = projectService.getProjectPage(pageReqVO).getList();
+ // 瀵煎嚭 Excel
+ ExcelUtils.write(response, "璁捐椤圭洰.xls", "鏁版嵁", MesPdProjectRespVO.class,
+ buildProjectRespVOList(list));
+ }
+
+ @PutMapping("/publish")
+ @Operation(summary = "鍙戝竷璁捐椤圭洰锛堝緟鍙戝竷鈫掑緟涓婁紶锛�")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:update')")
+ public CommonResult<Boolean> publishProject(@RequestParam("id") Long id) {
+ projectService.publishProject(id);
+ return success(true);
+ }
+
+ @PutMapping("/upload")
+ @Operation(summary = "涓婁紶璧勬枡锛堝緟涓婁紶鈫掑緟瀹℃牳锛夛紝鍚屾椂鑷姩鍒涘缓璧勬枡瀹℃牳璁板綍")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:update')")
+ public CommonResult<Boolean> uploadProject(@RequestParam("id") Long id) {
+ projectService.uploadProject(id, getLoginUserId());
+ return success(true);
+ }
+
+ @PutMapping("/audit")
+ @Operation(summary = "瀹℃牳璁捐椤圭洰锛堝緟瀹℃牳鈫掑緟褰掓。锛�")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:update')")
+ public CommonResult<Boolean> auditProject(@RequestParam("id") Long id) {
+ projectService.auditProject(id);
+ return success(true);
+ }
+
+ @PutMapping("/archive")
+ @Operation(summary = "褰掓。璁捐椤圭洰锛堝緟褰掓。鈫掑凡褰掓。锛夛紝鍚屾椂鑷姩鍒涘缓褰掓。鍙拌处")
+ @Parameter(name = "id", description = "缂栧彿", required = true)
+ @PreAuthorize("@ss.hasPermission('mes:pd-project:update')")
+ public CommonResult<Boolean> archiveProject(@RequestParam("id") Long id) {
+ projectService.archiveProject(id, getLoginUserId());
+ return success(true);
+ }
+
+ // ==================== 鎷兼帴 VO ====================
+
+ private List<MesPdProjectRespVO> buildProjectRespVOList(List<MesPdProjectDO> list) {
+ if (CollUtil.isEmpty(list)) {
+ return Collections.emptyList();
+ }
+ // 1.1 鎵归噺鑾峰彇鍏宠仈鏁版嵁锛堜富璁捐甯� + 瀹℃牳浜猴級
+ Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(convertSetByFlatMap(list,
+ project -> Stream.of(project.getChiefDesigner(), project.getReviewer())));
+ // 2. 鎷兼帴 VO
+ return BeanUtils.toBean(list, MesPdProjectRespVO.class, vo -> {
+ MapUtils.findAndThen(userMap, vo.getChiefDesigner(),
+ user -> vo.setChiefDesignerNickname(user.getNickname()));
+ MapUtils.findAndThen(userMap, vo.getReviewer(),
+ user -> vo.setReviewerNickname(user.getNickname()));
+ });
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectPageReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectPageReqVO.java
new file mode 100644
index 0000000..d5c638c
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectPageReqVO.java
@@ -0,0 +1,39 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo;
+
+import cn.iocoder.yudao.framework.common.pojo.PageParam;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.ToString;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import java.time.LocalDateTime;
+
+import static cn.iocoder.yudao.framework.common.util.date.DateUtils.FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璁捐椤圭洰鍒嗛〉 Request VO")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+public class MesPdProjectPageReqVO extends PageParam {
+
+ @Schema(description = "浠诲姟缂栫爜", example = "PD2024001")
+ private String taskCode;
+
+ @Schema(description = "浠诲姟鍚嶇О", example = "鏂颁骇鍝佽璁′换鍔�")
+ private String taskName;
+
+ @Schema(description = "浜у搧缂栫爜", example = "ITEM001")
+ private String productCode;
+
+ @Schema(description = "浜у搧鍚嶇О", example = "鏅鸿兘浼犳劅鍣�")
+ private String productName;
+
+ @Schema(description = "鐘舵��", example = "0")
+ private Integer status;
+
+ @Schema(description = "璁″垝瀹屾垚鏃堕棿")
+ @DateTimeFormat(pattern = FORMAT_YEAR_MONTH_DAY_HOUR_MINUTE_SECOND)
+ private LocalDateTime[] planFinishTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectRespVO.java
new file mode 100644
index 0000000..d0ea908
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectRespVO.java
@@ -0,0 +1,73 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo;
+
+import cn.iocoder.yudao.framework.excel.core.annotations.DictFormat;
+import cn.iocoder.yudao.framework.excel.core.convert.DictConvert;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import cn.idev.excel.annotation.ExcelIgnoreUnannotated;
+import cn.idev.excel.annotation.ExcelProperty;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璁捐椤圭洰 Response VO")
+@Data
+@ExcelIgnoreUnannotated
+public class MesPdProjectRespVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1024")
+ @ExcelProperty("缂栧彿")
+ private Long id;
+
+ @Schema(description = "浠诲姟缂栫爜", requiredMode = Schema.RequiredMode.REQUIRED, example = "PD2024001")
+ @ExcelProperty("浠诲姟缂栫爜")
+ private String taskCode;
+
+ @Schema(description = "浠诲姟鍚嶇О", requiredMode = Schema.RequiredMode.REQUIRED, example = "鏂颁骇鍝佽璁′换鍔�")
+ @ExcelProperty("浠诲姟鍚嶇О")
+ private String taskName;
+
+ @Schema(description = "浜у搧缂栫爜", example = "ITEM001")
+ @ExcelProperty("浜у搧缂栫爜")
+ private String productCode;
+
+ @Schema(description = "浜у搧鍚嶇О", example = "鏅鸿兘浼犳劅鍣�")
+ @ExcelProperty("浜у搧鍚嶇О")
+ private String productName;
+
+ @Schema(description = "鐗堟湰鍙�", example = "V1.0")
+ @ExcelProperty("鐗堟湰鍙�")
+ private String version;
+
+ @Schema(description = "鐘舵��", requiredMode = Schema.RequiredMode.REQUIRED, example = "0")
+ @ExcelProperty(value = "鐘舵��", converter = DictConvert.class)
+ @DictFormat(DictTypeConstants.MES_PD_PROJECT_STATUS)
+ private Integer status;
+
+ @Schema(description = "涓昏璁″笀", example = "1")
+ private Long chiefDesigner;
+
+ @Schema(description = "涓昏璁″笀鍚嶇О", example = "寮犱笁")
+ @ExcelProperty("涓昏璁″笀")
+ private String chiefDesignerNickname;
+
+ @Schema(description = "瀹℃牳浜�", example = "1")
+ private Long reviewer;
+
+ @Schema(description = "瀹℃牳浜哄悕绉�", example = "鏉庡洓")
+ @ExcelProperty("瀹℃牳浜�")
+ private String reviewerNickname;
+
+ @Schema(description = "璁″垝瀹屾垚鏃堕棿")
+ @ExcelProperty("璁″垝瀹屾垚鏃堕棿")
+ private LocalDateTime planFinishTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ @ExcelProperty("澶囨敞")
+ private String remark;
+
+ @Schema(description = "鍒涘缓鏃堕棿", requiredMode = Schema.RequiredMode.REQUIRED)
+ @ExcelProperty("鍒涘缓鏃堕棿")
+ private LocalDateTime createTime;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectSaveReqVO.java
new file mode 100644
index 0000000..01af0fe
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pd/project/vo/MesPdProjectSaveReqVO.java
@@ -0,0 +1,45 @@
+package cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import jakarta.validation.constraints.NotBlank;
+import java.time.LocalDateTime;
+
+@Schema(description = "绠＄悊鍚庡彴 - MES 璁捐椤圭洰鏂板/淇敼 Request VO")
+@Data
+public class MesPdProjectSaveReqVO {
+
+ @Schema(description = "缂栧彿", requiredMode = Schema.RequiredMode.NOT_REQUIRED, example = "1024")
+ private Long id;
+
+ @Schema(description = "浠诲姟缂栫爜", requiredMode = Schema.RequiredMode.REQUIRED, example = "PD2024001")
+ @NotBlank(message = "浠诲姟缂栫爜涓嶈兘涓虹┖")
+ private String taskCode;
+
+ @Schema(description = "浠诲姟鍚嶇О", requiredMode = Schema.RequiredMode.REQUIRED, example = "鏂颁骇鍝佽璁′换鍔�")
+ @NotBlank(message = "浠诲姟鍚嶇О涓嶈兘涓虹┖")
+ private String taskName;
+
+ @Schema(description = "浜у搧缂栫爜", example = "ITEM001")
+ private String productCode;
+
+ @Schema(description = "浜у搧鍚嶇О", example = "鏅鸿兘浼犳劅鍣�")
+ private String productName;
+
+ @Schema(description = "鐗堟湰鍙�", example = "V1.0")
+ private String version;
+
+ @Schema(description = "涓昏璁″笀", example = "1")
+ private Long chiefDesigner;
+
+ @Schema(description = "瀹℃牳浜�", example = "1")
+ private Long reviewer;
+
+ @Schema(description = "璁″垝瀹屾垚鏃堕棿")
+ private LocalDateTime planFinishTime;
+
+ @Schema(description = "澶囨敞", example = "娴嬭瘯澶囨敞")
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/archive/MesPdArchiveDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/archive/MesPdArchiveDO.java
new file mode 100644
index 0000000..09b503b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/archive/MesPdArchiveDO.java
@@ -0,0 +1,64 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.archive;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.project.MesPdProjectDO;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.time.LocalDateTime;
+
+/**
+ * MES 褰掓。鍙拌处 DO
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@TableName("mes_pd_archive")
+@KeySequence("mes_pd_archive_seq") // 鐢ㄤ簬 Oracle銆丳ostgreSQL銆並ingbase銆丏B2銆丠2 鏁版嵁搴撶殑涓婚敭鑷銆傚鏋滄槸 MySQL 绛夋暟鎹簱锛屽彲涓嶅啓銆�
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesPdArchiveDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 褰掓。缂栧彿
+ */
+ private String archiveCode;
+ /**
+ * 璁捐椤圭洰ID
+ *
+ * 鍏宠仈 {@link MesPdProjectDO#getId()}
+ */
+ private Long projectId;
+ /**
+ * 褰掓。浜�
+ *
+ * 鍏宠仈 AdminUserDO#getId()
+ */
+ private Long archiver;
+ /**
+ * 褰掓。鐘舵��
+ *
+ * 瀛楀吀 {@link DictTypeConstants#MES_PD_ARCHIVE_STATUS}
+ */
+ private Integer archiveStatus;
+ /**
+ * 褰掓。鏃堕棿
+ */
+ private LocalDateTime archiveTime;
+ /**
+ * 澶囨敞
+ */
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/document/MesPdDocumentDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/document/MesPdDocumentDO.java
new file mode 100644
index 0000000..92f4e0f
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/document/MesPdDocumentDO.java
@@ -0,0 +1,76 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.document;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.project.MesPdProjectDO;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.time.LocalDateTime;
+
+/**
+ * MES 璁捐璧勬枡 DO
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@TableName("mes_pd_document")
+@KeySequence("mes_pd_document_seq") // 鐢ㄤ簬 Oracle銆丳ostgreSQL銆並ingbase銆丏B2銆丠2 鏁版嵁搴撶殑涓婚敭鑷銆傚鏋滄槸 MySQL 绛夋暟鎹簱锛屽彲涓嶅啓銆�
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesPdDocumentDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 璁捐椤圭洰ID
+ *
+ * 鍏宠仈 {@link MesPdProjectDO#getId()}
+ */
+ private Long projectId;
+ /**
+ * 璧勬枡绫诲瀷
+ *
+ * 瀛楀吀 {@link DictTypeConstants#MES_PD_DOCUMENT_TYPE}
+ */
+ private String documentType;
+ /**
+ * 璧勬枡鍚嶇О
+ */
+ private String documentName;
+ /**
+ * 鐗堟湰
+ */
+ private String documentVersion;
+ /**
+ * 鏂囦欢鍚�
+ */
+ private String fileName;
+ /**
+ * 涓婁紶浜�
+ *
+ * 鍏宠仈 AdminUserDO#getId()
+ */
+ private Long uploadUserId;
+ /**
+ * 涓婁紶鏃堕棿
+ */
+ private LocalDateTime uploadTime;
+ /**
+ * 鏂囦欢URL
+ */
+ private String fileUrl;
+ /**
+ * 澶囨敞
+ */
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/documentaudit/MesPdDocumentAuditDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/documentaudit/MesPdDocumentAuditDO.java
new file mode 100644
index 0000000..4ec1e86
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/documentaudit/MesPdDocumentAuditDO.java
@@ -0,0 +1,72 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.documentaudit;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.document.MesPdDocumentDO;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.time.LocalDateTime;
+
+/**
+ * MES 璧勬枡瀹℃牳 DO
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@TableName("mes_pd_document_audit")
+@KeySequence("mes_pd_document_audit_seq") // 鐢ㄤ簬 Oracle銆丳ostgreSQL銆並ingbase銆丏B2銆丠2 鏁版嵁搴撶殑涓婚敭鑷銆傚鏋滄槸 MySQL 绛夋暟鎹簱锛屽彲涓嶅啓銆�
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesPdDocumentAuditDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 瀹℃牳鍗曞彿
+ */
+ private String auditNo;
+ /**
+ * 璧勬枡ID
+ *
+ * 鍏宠仈 {@link MesPdDocumentDO#getId()}
+ */
+ private Long documentId;
+ /**
+ * 璧勬枡鍚嶇О锛堝啑浣欙級
+ */
+ private String documentName;
+ /**
+ * 璧勬枡鐗堟湰锛堝啑浣欙級
+ */
+ private String documentVersion;
+ /**
+ * 瀹℃牳浜�
+ *
+ * 鍏宠仈 AdminUserDO#getId()
+ */
+ private Long reviewer;
+ /**
+ * 瀹℃牳鐘舵��
+ *
+ * 瀛楀吀 {@link DictTypeConstants#MES_PD_DOCUMENT_AUDIT_STATUS}
+ */
+ private Integer auditStatus;
+ /**
+ * 瀹℃牳鏃堕棿
+ */
+ private LocalDateTime auditTime;
+ /**
+ * 澶囨敞
+ */
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/project/MesPdProjectDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/project/MesPdProjectDO.java
new file mode 100644
index 0000000..1749472
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pd/project/MesPdProjectDO.java
@@ -0,0 +1,81 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pd.project;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import cn.iocoder.yudao.module.mes.enums.pd.MesPdProjectStatusEnum;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+import java.time.LocalDateTime;
+
+/**
+ * MES 璁捐椤圭洰 DO
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@TableName("mes_pd_project")
+@KeySequence("mes_pd_project_seq") // 鐢ㄤ簬 Oracle銆丳ostgreSQL銆並ingbase銆丏B2銆丠2 鏁版嵁搴撶殑涓婚敭鑷銆傚鏋滄槸 MySQL 绛夋暟鎹簱锛屽彲涓嶅啓銆�
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesPdProjectDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 浠诲姟缂栫爜
+ */
+ private String taskCode;
+ /**
+ * 浠诲姟鍚嶇О
+ */
+ private String taskName;
+ /**
+ * 浜у搧缂栫爜
+ */
+ private String productCode;
+ /**
+ * 浜у搧鍚嶇О
+ */
+ private String productName;
+ /**
+ * 鐗堟湰鍙�
+ */
+ private String version;
+ /**
+ * 鐘舵��
+ *
+ * 瀛楀吀 {@link DictTypeConstants#MES_PD_PROJECT_STATUS}
+ * 鏋氫妇 {@link MesPdProjectStatusEnum}
+ */
+ private Integer status;
+ /**
+ * 涓昏璁″笀
+ *
+ * 鍏宠仈 AdminUserDO#getId()
+ */
+ private Long chiefDesigner;
+ /**
+ * 瀹℃牳浜�
+ *
+ * 鍏宠仈 AdminUserDO#getId()
+ */
+ private Long reviewer;
+ /**
+ * 璁″垝瀹屾垚鏃堕棿
+ */
+ private LocalDateTime planFinishTime;
+ /**
+ * 澶囨敞
+ */
+ private String remark;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/archive/MesPdArchiveMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/archive/MesPdArchiveMapper.java
new file mode 100644
index 0000000..d63cf9b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/archive/MesPdArchiveMapper.java
@@ -0,0 +1,49 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.archive;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchiveGroupRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchivePageReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.archive.MesPdArchiveDO;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+@Mapper
+public interface MesPdArchiveMapper extends BaseMapperX<MesPdArchiveDO> {
+
+ default PageResult<MesPdArchiveDO> selectPage(MesPdArchivePageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesPdArchiveDO>()
+ .likeIfPresent(MesPdArchiveDO::getArchiveCode, reqVO.getArchiveCode())
+ .eqIfPresent(MesPdArchiveDO::getProjectId, reqVO.getProjectId())
+ .eqIfPresent(MesPdArchiveDO::getArchiveStatus, reqVO.getArchiveStatus())
+ .orderByDesc(MesPdArchiveDO::getId));
+ }
+
+ default MesPdArchiveDO selectByArchiveCode(String archiveCode) {
+ return selectOne(MesPdArchiveDO::getArchiveCode, archiveCode);
+ }
+
+ default List<MesPdArchiveDO> selectListByProjectId(Long projectId) {
+ return selectList(MesPdArchiveDO::getProjectId, projectId);
+ }
+
+ /**
+ * 鏌ヨ鏌愰」鐩笅褰掓。璁板綍鏁伴噺
+ */
+ default Long selectCountByProjectId(Long projectId) {
+ return selectCount(MesPdArchiveDO::getProjectId, projectId);
+ }
+
+ /**
+ * XML mapper 瀹炵幇鐨勫垎缁勫垎椤垫煡璇�
+ * 杩斿洖 MesPdArchiveGroupRespVO锛堝寘鍚綊妗ｅ瓧娈� + 鍏宠仈椤圭洰鐨勪骇鍝佺紪鐮�/鍚嶇О锛�
+ */
+ IPage<MesPdArchiveGroupRespVO> selectPageGroupByProjectId(Page<MesPdArchiveGroupRespVO> page,
+ @Param("req") MesPdArchivePageReqVO reqVO);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/document/MesPdDocumentMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/document/MesPdDocumentMapper.java
new file mode 100644
index 0000000..2b3a04c
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/document/MesPdDocumentMapper.java
@@ -0,0 +1,31 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.document;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo.MesPdDocumentPageReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.document.MesPdDocumentDO;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.List;
+
+@Mapper
+public interface MesPdDocumentMapper extends BaseMapperX<MesPdDocumentDO> {
+
+ default PageResult<MesPdDocumentDO> selectPage(MesPdDocumentPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesPdDocumentDO>()
+ .eqIfPresent(MesPdDocumentDO::getProjectId, reqVO.getProjectId())
+ .likeIfPresent(MesPdDocumentDO::getDocumentName, reqVO.getDocumentName())
+ .eqIfPresent(MesPdDocumentDO::getDocumentType, reqVO.getDocumentType())
+ .orderByDesc(MesPdDocumentDO::getId));
+ }
+
+ default List<MesPdDocumentDO> selectListByProjectId(Long projectId) {
+ return selectList(MesPdDocumentDO::getProjectId, projectId);
+ }
+
+ default int deleteByProjectId(Long projectId) {
+ return delete(MesPdDocumentDO::getProjectId, projectId);
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/documentaudit/MesPdDocumentAuditMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/documentaudit/MesPdDocumentAuditMapper.java
new file mode 100644
index 0000000..f876368
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/documentaudit/MesPdDocumentAuditMapper.java
@@ -0,0 +1,47 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.documentaudit;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo.MesPdDocumentAuditPageReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.documentaudit.MesPdDocumentAuditDO;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.Collection;
+import java.util.List;
+
+@Mapper
+public interface MesPdDocumentAuditMapper extends BaseMapperX<MesPdDocumentAuditDO> {
+
+ default PageResult<MesPdDocumentAuditDO> selectPage(MesPdDocumentAuditPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesPdDocumentAuditDO>()
+ .eqIfPresent(MesPdDocumentAuditDO::getDocumentId, reqVO.getDocumentId())
+ .likeIfPresent(MesPdDocumentAuditDO::getAuditNo, reqVO.getAuditNo())
+ .eqIfPresent(MesPdDocumentAuditDO::getAuditStatus, reqVO.getAuditStatus())
+ .orderByDesc(MesPdDocumentAuditDO::getId));
+ }
+
+ default List<MesPdDocumentAuditDO> selectListByDocumentId(Long documentId) {
+ return selectList(MesPdDocumentAuditDO::getDocumentId, documentId);
+ }
+
+ default int deleteByDocumentId(Long documentId) {
+ return delete(MesPdDocumentAuditDO::getDocumentId, documentId);
+ }
+
+ /**
+ * 鏌ヨ鎸囧畾璧勬枡ID鍒楄〃涓槸鍚﹀瓨鍦ㄥ緟瀹℃牳鐨勮褰�
+ *
+ * @param documentIds 璧勬枡ID鍒楄〃
+ * @return 鏄惁瀛樺湪寰呭鏍歌褰�
+ */
+ default boolean existsPendingAuditByDocumentIds(Collection<Long> documentIds) {
+ if (documentIds == null || documentIds.isEmpty()) {
+ return false;
+ }
+ return selectCount(new LambdaQueryWrapperX<MesPdDocumentAuditDO>()
+ .in(MesPdDocumentAuditDO::getDocumentId, documentIds)
+ .eq(MesPdDocumentAuditDO::getAuditStatus, 0)) > 0;
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/project/MesPdProjectMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/project/MesPdProjectMapper.java
new file mode 100644
index 0000000..1da3d0b
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pd/project/MesPdProjectMapper.java
@@ -0,0 +1,28 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pd.project;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo.MesPdProjectPageReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.project.MesPdProjectDO;
+import org.apache.ibatis.annotations.Mapper;
+
+@Mapper
+public interface MesPdProjectMapper extends BaseMapperX<MesPdProjectDO> {
+
+ default PageResult<MesPdProjectDO> selectPage(MesPdProjectPageReqVO reqVO) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<MesPdProjectDO>()
+ .likeIfPresent(MesPdProjectDO::getTaskCode, reqVO.getTaskCode())
+ .likeIfPresent(MesPdProjectDO::getTaskName, reqVO.getTaskName())
+ .likeIfPresent(MesPdProjectDO::getProductCode, reqVO.getProductCode())
+ .likeIfPresent(MesPdProjectDO::getProductName, reqVO.getProductName())
+ .eqIfPresent(MesPdProjectDO::getStatus, reqVO.getStatus())
+ .betweenIfPresent(MesPdProjectDO::getPlanFinishTime, reqVO.getPlanFinishTime())
+ .orderByDesc(MesPdProjectDO::getId));
+ }
+
+ default MesPdProjectDO selectByTaskCode(String taskCode) {
+ return selectOne(MesPdProjectDO::getTaskCode, taskCode);
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java
index 3e937d3..d505ca0 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/DictTypeConstants.java
@@ -100,4 +100,12 @@
// ========== 宸ュ叿绠＄悊 (TM) ==========
String MES_TM_TOOL_STATUS = "mes_tm_tool_status"; // MES 宸ュ叿鐘舵��
String MES_TM_MAINTEN_TYPE = "mes_tm_mainten_type"; // MES 淇濆吇缁存姢绫诲瀷
+
+ // ========== 浜у搧璁捐 (PD) ==========
+ String MES_PD_PROJECT_STATUS = "mes_pd_project_status"; // 璁捐椤圭洰鐘舵��
+ String MES_PD_DOCUMENT_TYPE = "mes_pd_document_type"; // 璧勬枡绫诲瀷
+ String MES_PD_DOCUMENT_AUDIT_STATUS = "mes_pd_document_audit_status"; // 璧勬枡瀹℃牳鐘舵��
+ String MES_PD_ARCHIVE_STATUS = "mes_pd_archive_status"; // 褰掓。鐘舵��
+ String MES_PD_PROCESS_PARAM_TYPE = "mes_pd_process_param_type"; // 宸ヨ壓鍙傛暟绫诲瀷
+ String MES_PD_PROCESS_PARAM_TEMPLATE_TYPE = "mes_pd_process_param_template_type"; // 宸ヨ壓鍙傛暟妯℃澘绫诲瀷
}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java
index 14c22c2..e7a9d3d 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/ErrorCodeConstants.java
@@ -708,4 +708,32 @@
ErrorCode WM_PACKAGE_HAS_CHILDREN = new ErrorCode(1_040_740_008, "瀛樺湪瀛愮锛屼笉鍏佽鍒犻櫎");
ErrorCode WM_PACKAGE_LINE_NOT_EXISTS = new ErrorCode(1_040_740_100, "瑁呯鏄庣粏涓嶅瓨鍦�");
+ // ========== MES 浜у搧璁捐-璁捐椤圭洰锛�1-040-800-000锛� ==========
+ ErrorCode PD_PROJECT_NOT_EXISTS = new ErrorCode(1_040_800_000, "璁捐椤圭洰涓嶅瓨鍦�");
+ ErrorCode PD_PROJECT_NOT_INITIATE = new ErrorCode(1_040_800_001, "璁捐椤圭洰涓嶆槸寰呭彂甯冪姸鎬侊紝涓嶅厑璁镐慨鏀规垨鍒犻櫎");
+ ErrorCode PD_PROJECT_CODE_DUPLICATE = new ErrorCode(1_040_800_002, "璁捐椤圭洰浠诲姟缂栫爜宸插瓨鍦�");
+ ErrorCode PD_PROJECT_NOT_INITIATE_FOR_PUBLISH = new ErrorCode(1_040_800_003, "鍙湁寰呭彂甯冪姸鎬佺殑璁捐椤圭洰鎵嶈兘鍙戝竷");
+ ErrorCode PD_PROJECT_NOT_PUBLISH_FOR_UPLOAD = new ErrorCode(1_040_800_004, "鍙湁寰呬笂浼犵姸鎬佺殑璁捐椤圭洰鎵嶈兘涓婁紶璧勬枡");
+ ErrorCode PD_PROJECT_NOT_UPLOAD_FOR_AUDIT = new ErrorCode(1_040_800_005, "鍙湁寰呭鏍哥姸鎬佺殑璁捐椤圭洰鎵嶈兘瀹℃牳");
+ ErrorCode PD_PROJECT_NOT_AUDIT_FOR_ARCHIVE = new ErrorCode(1_040_800_006, "鍙湁寰呭綊妗ｇ姸鎬佺殑璁捐椤圭洰鎵嶈兘褰掓。");
+ ErrorCode PD_PROJECT_AUDIT_NOT_FINISHED = new ErrorCode(1_040_800_007, "璇ラ」鐩笅瀛樺湪鏈鏍哥殑璧勬枡锛岃鍏堝畬鎴愭墍鏈夎祫鏂欏鏍�");
+
+ // ========== MES 浜у搧璁捐-璧勬枡瀛愯〃锛�1-040-801-000锛� ==========
+ ErrorCode PD_DOCUMENT_NOT_EXISTS = new ErrorCode(1_040_801_000, "璁捐璧勬枡涓嶅瓨鍦�");
+
+ // ========== MES 浜у搧璁捐-璧勬枡瀹℃牳锛�1-040-802-000锛� ==========
+ ErrorCode PD_DOCUMENT_AUDIT_NOT_EXISTS = new ErrorCode(1_040_802_000, "璧勬枡瀹℃牳璁板綍涓嶅瓨鍦�");
+
+ // ========== MES 浜у搧璁捐-褰掓。鍙拌处锛�1-040-803-000锛� ==========
+ ErrorCode PD_ARCHIVE_NOT_EXISTS = new ErrorCode(1_040_803_000, "褰掓。鍙拌处涓嶅瓨鍦�");
+ ErrorCode PD_ARCHIVE_CODE_DUPLICATE = new ErrorCode(1_040_803_001, "褰掓。缂栧彿宸插瓨鍦�");
+
+ // ========== MES 浜у搧璁捐-宸ヨ壓鍙傛暟锛�1-040-804-000锛� ==========
+ ErrorCode PD_PROCESS_PARAM_NOT_EXISTS = new ErrorCode(1_040_804_000, "宸ヨ壓鍙傛暟涓嶅瓨鍦�");
+ ErrorCode PD_PROCESS_PARAM_CODE_DUPLICATE = new ErrorCode(1_040_804_001, "宸ヨ壓鍙傛暟缂栫爜宸插瓨鍦�");
+
+ // ========== MES 浜у搧璁捐-宸ヨ壓鍙傛暟妯℃澘锛�1-040-805-000锛� ==========
+ ErrorCode PD_PROCESS_PARAM_TEMPLATE_NOT_EXISTS = new ErrorCode(1_040_805_000, "宸ヨ壓鍙傛暟妯℃澘涓嶅瓨鍦�");
+ ErrorCode PD_PROCESS_PARAM_TEMPLATE_CODE_DUPLICATE = new ErrorCode(1_040_805_001, "宸ヨ壓鍙傛暟妯℃澘缂栫爜宸插瓨鍦�");
+
}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesBizTypeConstants.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesBizTypeConstants.java
index 518f5b5..021c297 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesBizTypeConstants.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesBizTypeConstants.java
@@ -76,6 +76,15 @@
public static final int MD_USER = 604; // 浜哄憳锛氱郴缁熺敤鎴�
public static final int MD_CLIENT = 605; // 瀹㈡埛锛歁esMdClientDO
+ // ========== PD 浜у搧璁捐妯″潡 [700, 800) ==========
+
+ public static final int PD_PROJECT = 700; // 璁捐椤圭洰锛歁esPdProjectDO
+ public static final int PD_DOCUMENT = 701; // 璧勬枡瀛愯〃锛歁esPdDocumentDO
+ public static final int PD_DOCUMENT_AUDIT = 702; // 璧勬枡瀹℃牳锛歁esPdDocumentAuditDO
+ public static final int PD_ARCHIVE = 703; // 褰掓。鍙拌处锛歁esPdArchiveDO
+ public static final int PD_PROCESS_PARAM = 704; // 宸ヨ壓鍙傛暟锛歁esPdProcessParamDO
+ public static final int PD_PROCESS_PARAM_TEMPLATE = 705; // 宸ヨ壓鍙傛暟妯℃澘锛歁esPdProcessParamTemplateDO
+
// ========== 鐗规畩绫诲瀷锛堥潪涓氬姟瀹炰綋锛� [900, 1000) ==========
public static final int QUALITY_STATUS = 900; // 璐ㄩ噺鐘舵�侊細闈炲疄浣擄紝鐢ㄤ簬鐩樼偣绛夊満鏅殑鐘舵�佺瓫閫�
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesPdStatusConstants.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesPdStatusConstants.java
new file mode 100644
index 0000000..13f484c
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/MesPdStatusConstants.java
@@ -0,0 +1,36 @@
+package cn.iocoder.yudao.module.mes.enums;
+
+/**
+ * MES 浜у搧璁捐鐘舵�佸父閲�
+ *
+ * 闆嗕腑绠＄悊浜у搧璁捐妯″潡鍚勫崟鎹姸鎬佺殑缂栧彿锛屼綔涓虹姸鎬佸�肩殑涓ぎ娉ㄥ唽涓績銆�
+ * 鍚勬灇涓剧被寮曠敤姝ゅ甯搁噺锛岄伩鍏嶇‖缂栫爜鏁板瓧銆�
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+public final class MesPdStatusConstants {
+
+ private MesPdStatusConstants() {}
+
+ /**
+ * 寰呭彂甯�
+ */
+ public static final int INITIATE = 0;
+ /**
+ * 寰呬笂浼�
+ */
+ public static final int PUBLISH = 1;
+ /**
+ * 寰呭鏍�
+ */
+ public static final int UPLOAD = 2;
+ /**
+ * 寰呭綊妗�
+ */
+ public static final int AUDIT = 3;
+ /**
+ * 宸插綊妗�
+ */
+ public static final int ARCHIVE = 4;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/md/autocode/MesMdAutoCodeRuleCodeEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/md/autocode/MesMdAutoCodeRuleCodeEnum.java
index 1acb33c..b3ef3e3 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/md/autocode/MesMdAutoCodeRuleCodeEnum.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/md/autocode/MesMdAutoCodeRuleCodeEnum.java
@@ -52,7 +52,11 @@
PRO_WORK_ORDER_CODE("PRO_WORK_ORDER_CODE", "鐢熶骇宸ュ崟缂栫爜"),
QC_DEFECT_CODE("QC_DEFECT_CODE", "缂洪櫡绫诲瀷缂栫爜"),
QC_INDICATOR_RESULT_CODE("QC_INDICATOR_RESULT_CODE", "鏍峰搧妫�楠岀粨鏋滅紪鐮�"),
- WM_OUTSOURCE_RECEIPT_CODE("WM_OUTSOURCE_RECEIPT_CODE", "澶栧崗鍏ュ簱鍗曠紪鐮�");
+ WM_OUTSOURCE_RECEIPT_CODE("WM_OUTSOURCE_RECEIPT_CODE", "澶栧崗鍏ュ簱鍗曠紪鐮�"),
+ PD_DOCUMENT_AUDIT_CODE("PD_DOCUMENT_AUDIT_CODE", "璧勬枡瀹℃牳鍗曠紪鐮�"),
+ PD_ARCHIVE_CODE("PD_ARCHIVE_CODE", "褰掓。鍙拌处缂栫爜"),
+ PD_PROCESS_PARAM_CODE("PD_PROCESS_PARAM_CODE", "宸ヨ壓鍙傛暟缂栫爜"),
+ PD_PROCESS_PARAM_TEMPLATE_CODE("PD_PROCESS_PARAM_TEMPLATE_CODE", "宸ヨ壓鍙傛暟妯℃澘缂栫爜");
/**
* 瑙勫垯浠ｇ爜
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/pd/MesPdProjectStatusEnum.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/pd/MesPdProjectStatusEnum.java
new file mode 100644
index 0000000..261b1c2
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/enums/pd/MesPdProjectStatusEnum.java
@@ -0,0 +1,68 @@
+package cn.iocoder.yudao.module.mes.enums.pd;
+
+import cn.iocoder.yudao.framework.common.core.ArrayValuable;
+import cn.iocoder.yudao.module.mes.enums.MesPdStatusConstants;
+import lombok.AllArgsConstructor;
+import lombok.Getter;
+
+import java.util.Arrays;
+
+/**
+ * MES 璁捐椤圭洰鐘舵�佹灇涓�
+ *
+ * 鐘舵�佹祦杞細寰呭彂甯� 鈫� 寰呬笂浼� 鈫� 寰呭鏍� 鈫� 寰呭綊妗� 鈫� 宸插綊妗�
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@Getter
+@AllArgsConstructor
+public enum MesPdProjectStatusEnum implements ArrayValuable<Integer> {
+
+ /**
+ * 寰呭彂甯�
+ *
+ * 瀵瑰簲 MesPdProjectService#createProject 鏂规硶
+ */
+ INITIATE(MesPdStatusConstants.INITIATE, "寰呭彂甯�"),
+ /**
+ * 寰呬笂浼�
+ *
+ * 瀵瑰簲 MesPdProjectService#publishProject 鏂规硶
+ */
+ PUBLISH(MesPdStatusConstants.PUBLISH, "寰呬笂浼�"),
+ /**
+ * 寰呭鏍�
+ *
+ * 瀵瑰簲 MesPdProjectService#uploadProject 鏂规硶
+ */
+ UPLOAD(MesPdStatusConstants.UPLOAD, "寰呭鏍�"),
+ /**
+ * 寰呭綊妗�
+ *
+ * 瀵瑰簲 MesPdProjectService#auditProject 鏂规硶
+ */
+ AUDIT(MesPdStatusConstants.AUDIT, "寰呭綊妗�"),
+ /**
+ * 宸插綊妗�
+ *
+ * 瀵瑰簲 MesPdProjectService#archiveProject 鏂规硶
+ */
+ ARCHIVE(MesPdStatusConstants.ARCHIVE, "宸插綊妗�");
+
+ public static final Integer[] ARRAYS = Arrays.stream(values()).map(MesPdProjectStatusEnum::getStatus).toArray(Integer[]::new);
+
+ /**
+ * 鐘舵�佸��
+ */
+ private final Integer status;
+ /**
+ * 鐘舵�佸悕
+ */
+ private final String name;
+
+ @Override
+ public Integer[] array() {
+ return ARRAYS;
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveService.java
new file mode 100644
index 0000000..be7f583
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveService.java
@@ -0,0 +1,64 @@
+package cn.iocoder.yudao.module.mes.service.pd.archive;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchiveDetailRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchiveGroupRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchivePageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchiveSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.archive.MesPdArchiveDO;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import jakarta.validation.Valid;
+
+import java.util.List;
+
+/**
+ * MES 褰掓。鍙拌处 Service 鎺ュ彛
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+public interface MesPdArchiveService {
+
+ /**
+ * 鍒涘缓褰掓。鍙拌处
+ */
+ Long createArchive(@Valid MesPdArchiveSaveReqVO createReqVO);
+
+ /**
+ * 鏇存柊褰掓。鍙拌处
+ */
+ void updateArchive(@Valid MesPdArchiveSaveReqVO updateReqVO);
+
+ /**
+ * 鍒犻櫎褰掓。鍙拌处
+ */
+ void deleteArchive(Long id);
+
+ /**
+ * 鑾峰緱褰掓。鍙拌处
+ */
+ MesPdArchiveDO getArchive(Long id);
+
+ /**
+ * 鑾峰緱褰掓。鍙拌处鍒嗛〉
+ */
+ PageResult<MesPdArchiveDO> getArchivePage(MesPdArchivePageReqVO pageReqVO);
+
+ /**
+ * 鑾峰緱褰掓。鍙拌处鍒嗛〉锛堟寜椤圭洰/浜у搧鍒嗙粍锛屾瘡缁勫彇鏈�鏂颁竴鏉★級
+ * 杩斿洖 MesPdArchiveGroupRespVO锛堝寘鍚綊妗ｅ瓧娈� + 鍏宠仈椤圭洰鐨勪骇鍝佺紪鐮�/鍚嶇О锛�
+ */
+ IPage<MesPdArchiveGroupRespVO> getArchivePageGroupByProject(MesPdArchivePageReqVO pageReqVO,
+ Page<MesPdArchiveGroupRespVO> page);
+
+ /**
+ * 鑾峰緱褰掓。鍙拌处璇︽儏锛堟寜浜у搧锛夛紝鍖呭惈椤圭洰淇℃伅銆佸綊妗ｈ褰曞垪琛ㄣ�佽璁¤祫鏂欏垪琛�
+ */
+ List<MesPdArchiveDetailRespVO> getArchiveDetailByProductCode(String productCode);
+
+ /**
+ * 鑾峰緱鏌愰」鐩笅褰掓。璁板綍鏁伴噺
+ */
+ Long getArchiveCountByProjectId(Long projectId);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveServiceImpl.java
new file mode 100644
index 0000000..7c80e0e
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/archive/MesPdArchiveServiceImpl.java
@@ -0,0 +1,187 @@
+package cn.iocoder.yudao.module.mes.service.pd.archive;
+
+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.module.mes.controller.admin.pd.archive.vo.MesPdArchiveDetailRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchiveGroupRespVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchivePageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchiveSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.archive.MesPdArchiveDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.document.MesPdDocumentDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.project.MesPdProjectDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.archive.MesPdArchiveMapper;
+import cn.iocoder.yudao.module.mes.service.pd.document.MesPdDocumentService;
+import cn.iocoder.yudao.module.mes.service.pd.project.MesPdProjectService;
+import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
+import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import jakarta.annotation.Resource;
+import org.springframework.context.annotation.Lazy;
+import org.springframework.stereotype.Service;
+import org.springframework.validation.annotation.Validated;
+
+import java.util.ArrayList;
+import java.util.List;
+import java.util.Map;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
+
+/**
+ * MES 褰掓。鍙拌处 Service 瀹炵幇绫�
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@Service
+@Validated
+public class MesPdArchiveServiceImpl implements MesPdArchiveService {
+
+ @Resource
+ private MesPdArchiveMapper archiveMapper;
+
+ @Resource
+ @Lazy
+ private MesPdProjectService projectService;
+
+ @Resource
+ @Lazy
+ private MesPdDocumentService documentService;
+
+ @Resource
+ @Lazy
+ private AdminUserApi adminUserApi;
+
+ @Override
+ public Long createArchive(MesPdArchiveSaveReqVO createReqVO) {
+ // 鏍￠獙褰掓。缂栧彿鍞竴
+ validateArchiveCodeUnique(null, createReqVO.getArchiveCode());
+ // 鏍￠獙璁捐椤圭洰瀛樺湪
+ projectService.validateProjectExists(createReqVO.getProjectId());
+ // 鎻掑叆
+ MesPdArchiveDO archive = BeanUtils.toBean(createReqVO, MesPdArchiveDO.class);
+ archiveMapper.insert(archive);
+ return archive.getId();
+ }
+
+ @Override
+ public void updateArchive(MesPdArchiveSaveReqVO updateReqVO) {
+ // 鏍￠獙瀛樺湪
+ validateArchiveExists(updateReqVO.getId());
+ // 鏍￠獙褰掓。缂栧彿鍞竴
+ validateArchiveCodeUnique(updateReqVO.getId(), updateReqVO.getArchiveCode());
+ // 鏇存柊
+ MesPdArchiveDO updateObj = BeanUtils.toBean(updateReqVO, MesPdArchiveDO.class);
+ archiveMapper.updateById(updateObj);
+ }
+
+ @Override
+ public void deleteArchive(Long id) {
+ // 鏍￠獙瀛樺湪
+ validateArchiveExists(id);
+ // 鍒犻櫎
+ archiveMapper.deleteById(id);
+ }
+
+ @Override
+ public MesPdArchiveDO getArchive(Long id) {
+ return archiveMapper.selectById(id);
+ }
+
+ @Override
+ public PageResult<MesPdArchiveDO> getArchivePage(MesPdArchivePageReqVO pageReqVO) {
+ return archiveMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public IPage<MesPdArchiveGroupRespVO> getArchivePageGroupByProject(MesPdArchivePageReqVO pageReqVO, Page<MesPdArchiveGroupRespVO> page) {
+ return archiveMapper.selectPageGroupByProjectId(page,pageReqVO);
+ }
+
+ @Override
+ public List<MesPdArchiveDetailRespVO> getArchiveDetailByProductCode(String productCode) {
+ // 1. 鏌ラ」鐩俊鎭�
+ List<MesPdProjectDO> projects = projectService.getProjectByProductCode(productCode);
+ List<MesPdArchiveDetailRespVO> mesPdArchiveDetailRespVOS = new ArrayList<>();
+ projects.forEach(project -> {
+ if (project == null) {
+ throw exception(PD_PROJECT_NOT_EXISTS);
+ }
+ // 2. 鏌ュ綊妗ｅ垪琛�
+ List<MesPdArchiveDO> archives = archiveMapper.selectListByProjectId(project.getId());
+ // 3. 鏌ヨ祫鏂欏垪琛�
+ List<MesPdDocumentDO> documents = documentService.getDocumentListByProjectId(project.getId());
+
+ // 4. 缁勮 VO
+ MesPdArchiveDetailRespVO respVO = new MesPdArchiveDetailRespVO();
+
+ // 4.1 椤圭洰淇℃伅
+ MesPdArchiveDetailRespVO.ProjectInfo projectInfo = BeanUtils.toBean(project, MesPdArchiveDetailRespVO.ProjectInfo.class);
+ // 鎵归噺鑾峰彇鐢ㄦ埛淇℃伅
+ Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(
+ cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet(
+ java.util.stream.Stream.of(project.getChiefDesigner(), project.getReviewer())
+ .filter(java.util.Objects::nonNull)
+ .collect(java.util.stream.Collectors.toSet()),
+ id -> id));
+ MapUtils.findAndThen(userMap, project.getChiefDesigner(),
+ user -> projectInfo.setChiefDesignerNickname(user.getNickname()));
+ MapUtils.findAndThen(userMap, project.getReviewer(),
+ user -> projectInfo.setReviewerNickname(user.getNickname()));
+ respVO.setProject(projectInfo);
+
+ // 4.2 褰掓。璁板綍鍒楄〃
+ if (!archives.isEmpty()) {
+ Map<Long, AdminUserRespDTO> archiverUserMap = adminUserApi.getUserMap(
+ cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet(archives, MesPdArchiveDO::getArchiver));
+ List<MesPdArchiveDetailRespVO.ArchiveInfo> archiveInfos = BeanUtils.toBean(archives, MesPdArchiveDetailRespVO.ArchiveInfo.class,
+ info -> MapUtils.findAndThen(archiverUserMap, info.getArchiver(),
+ user -> info.setArchiverNickname(user.getNickname())));
+ respVO.setArchives(archiveInfos);
+ }
+
+ // 4.3 璁捐璧勬枡鍒楄〃
+ if (!documents.isEmpty()) {
+ Map<Long, AdminUserRespDTO> uploadUserMap = adminUserApi.getUserMap(
+ cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet(documents, MesPdDocumentDO::getUploadUserId));
+ List<MesPdArchiveDetailRespVO.DocumentInfo> documentInfos = BeanUtils.toBean(documents, MesPdArchiveDetailRespVO.DocumentInfo.class,
+ info -> MapUtils.findAndThen(uploadUserMap, info.getUploadUserId(),
+ user -> info.setUploadUserNickname(user.getNickname())));
+ respVO.setDocuments(documentInfos);
+ }
+ mesPdArchiveDetailRespVOS.add(respVO);
+ });
+
+ return mesPdArchiveDetailRespVOS;
+ }
+
+ @Override
+ public Long getArchiveCountByProjectId(Long projectId) {
+ return archiveMapper.selectCountByProjectId(projectId);
+ }
+
+ private MesPdArchiveDO validateArchiveExists(Long id) {
+ MesPdArchiveDO archive = archiveMapper.selectById(id);
+ if (archive == null) {
+ throw exception(PD_ARCHIVE_NOT_EXISTS);
+ }
+ return archive;
+ }
+
+ private void validateArchiveCodeUnique(Long id, String archiveCode) {
+ MesPdArchiveDO existing = archiveMapper.selectByArchiveCode(archiveCode);
+ if (existing == null) {
+ return;
+ }
+ // 濡傛灉 id 涓虹┖锛岃鏄庢槸鏂板锛岀紪鐮侀噸澶�
+ if (id == null) {
+ throw exception(PD_ARCHIVE_CODE_DUPLICATE);
+ }
+ // 濡傛灉 id 涓嶄负绌猴紝璇存槑鏄慨鏀癸紝缂栫爜閲嶅涓斾笉鏄悓涓�鏉¤褰�
+ if (!existing.getId().equals(id)) {
+ throw exception(PD_ARCHIVE_CODE_DUPLICATE);
+ }
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentService.java
new file mode 100644
index 0000000..54fe5d4
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentService.java
@@ -0,0 +1,71 @@
+package cn.iocoder.yudao.module.mes.service.pd.document;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo.MesPdDocumentPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo.MesPdDocumentSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.document.MesPdDocumentDO;
+import jakarta.validation.Valid;
+
+import java.util.List;
+
+/**
+ * MES 璁捐璧勬枡 Service 鎺ュ彛
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+public interface MesPdDocumentService {
+
+ /**
+ * 鍒涘缓璁捐璧勬枡
+ *
+ * @param createReqVO 鍒涘缓淇℃伅
+ * @return 缂栧彿
+ */
+ Long createDocument(@Valid MesPdDocumentSaveReqVO createReqVO);
+
+ /**
+ * 鏇存柊璁捐璧勬枡
+ *
+ * @param updateReqVO 鏇存柊淇℃伅
+ */
+ void updateDocument(@Valid MesPdDocumentSaveReqVO updateReqVO);
+
+ /**
+ * 鍒犻櫎璁捐璧勬枡
+ *
+ * @param id 缂栧彿
+ */
+ void deleteDocument(Long id);
+
+ /**
+ * 鑾峰緱璁捐璧勬枡
+ *
+ * @param id 缂栧彿
+ * @return 璁捐璧勬枡
+ */
+ MesPdDocumentDO getDocument(Long id);
+
+ /**
+ * 鑾峰緱璁捐璧勬枡鍒嗛〉
+ *
+ * @param pageReqVO 鍒嗛〉鏌ヨ
+ * @return 璁捐璧勬枡鍒嗛〉
+ */
+ PageResult<MesPdDocumentDO> getDocumentPage(MesPdDocumentPageReqVO pageReqVO);
+
+ /**
+ * 鑾峰緱鎸囧畾璁捐椤圭洰涓嬬殑璧勬枡鍒楄〃
+ *
+ * @param projectId 璁捐椤圭洰ID
+ * @return 璧勬枡鍒楄〃
+ */
+ List<MesPdDocumentDO> getDocumentListByProjectId(Long projectId);
+
+ /**
+ * 鍒犻櫎鎸囧畾璁捐椤圭洰涓嬬殑鎵�鏈夎祫鏂�
+ *
+ * @param projectId 璁捐椤圭洰ID
+ */
+ void deleteByProjectId(Long projectId);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentServiceImpl.java
new file mode 100644
index 0000000..c733e24
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/document/MesPdDocumentServiceImpl.java
@@ -0,0 +1,91 @@
+package cn.iocoder.yudao.module.mes.service.pd.document;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo.MesPdDocumentPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.document.vo.MesPdDocumentSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.document.MesPdDocumentDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.document.MesPdDocumentMapper;
+import cn.iocoder.yudao.module.mes.service.pd.project.MesPdProjectService;
+import jakarta.annotation.Resource;
+import org.springframework.context.annotation.Lazy;
+import org.springframework.stereotype.Service;
+import org.springframework.validation.annotation.Validated;
+
+import java.util.List;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.PD_DOCUMENT_NOT_EXISTS;
+
+/**
+ * MES 璁捐璧勬枡 Service 瀹炵幇绫�
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@Service
+@Validated
+public class MesPdDocumentServiceImpl implements MesPdDocumentService {
+
+ @Resource
+ private MesPdDocumentMapper documentMapper;
+
+ @Resource
+ @Lazy
+ private MesPdProjectService projectService;
+
+ @Override
+ public Long createDocument(MesPdDocumentSaveReqVO createReqVO) {
+ // 鏍￠獙璁捐椤圭洰瀛樺湪
+ projectService.validateProjectExists(createReqVO.getProjectId());
+ // 鎻掑叆
+ MesPdDocumentDO document = BeanUtils.toBean(createReqVO, MesPdDocumentDO.class);
+ documentMapper.insert(document);
+ return document.getId();
+ }
+
+ @Override
+ public void updateDocument(MesPdDocumentSaveReqVO updateReqVO) {
+ // 鏍￠獙瀛樺湪
+ validateDocumentExists(updateReqVO.getId());
+ // 鏇存柊
+ MesPdDocumentDO updateObj = BeanUtils.toBean(updateReqVO, MesPdDocumentDO.class);
+ documentMapper.updateById(updateObj);
+ }
+
+ @Override
+ public void deleteDocument(Long id) {
+ // 鏍￠獙瀛樺湪
+ validateDocumentExists(id);
+ // 鍒犻櫎
+ documentMapper.deleteById(id);
+ }
+
+ @Override
+ public MesPdDocumentDO getDocument(Long id) {
+ return documentMapper.selectById(id);
+ }
+
+ @Override
+ public PageResult<MesPdDocumentDO> getDocumentPage(MesPdDocumentPageReqVO pageReqVO) {
+ return documentMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public List<MesPdDocumentDO> getDocumentListByProjectId(Long projectId) {
+ return documentMapper.selectListByProjectId(projectId);
+ }
+
+ @Override
+ public void deleteByProjectId(Long projectId) {
+ documentMapper.deleteByProjectId(projectId);
+ }
+
+ private MesPdDocumentDO validateDocumentExists(Long id) {
+ MesPdDocumentDO document = documentMapper.selectById(id);
+ if (document == null) {
+ throw exception(PD_DOCUMENT_NOT_EXISTS);
+ }
+ return document;
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditService.java
new file mode 100644
index 0000000..7f15e08
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditService.java
@@ -0,0 +1,64 @@
+package cn.iocoder.yudao.module.mes.service.pd.documentaudit;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo.MesPdDocumentAuditPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo.MesPdDocumentAuditSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.documentaudit.MesPdDocumentAuditDO;
+import jakarta.validation.Valid;
+
+import java.util.List;
+
+/**
+ * MES 璧勬枡瀹℃牳 Service 鎺ュ彛
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+public interface MesPdDocumentAuditService {
+
+ /**
+ * 鍒涘缓璧勬枡瀹℃牳
+ *
+ * @param createReqVO 鍒涘缓淇℃伅
+ * @return 缂栧彿
+ */
+ Long createDocumentAudit(@Valid MesPdDocumentAuditSaveReqVO createReqVO);
+
+ /**
+ * 鏇存柊璧勬枡瀹℃牳
+ *
+ * @param updateReqVO 鏇存柊淇℃伅
+ */
+ void updateDocumentAudit(@Valid MesPdDocumentAuditSaveReqVO updateReqVO);
+
+ /**
+ * 鍒犻櫎璧勬枡瀹℃牳
+ *
+ * @param id 缂栧彿
+ */
+ void deleteDocumentAudit(Long id);
+
+ /**
+ * 鑾峰緱璧勬枡瀹℃牳
+ *
+ * @param id 缂栧彿
+ * @return 璧勬枡瀹℃牳
+ */
+ MesPdDocumentAuditDO getDocumentAudit(Long id);
+
+ /**
+ * 鑾峰緱璧勬枡瀹℃牳鍒嗛〉
+ *
+ * @param pageReqVO 鍒嗛〉鏌ヨ
+ * @return 璧勬枡瀹℃牳鍒嗛〉
+ */
+ PageResult<MesPdDocumentAuditDO> getDocumentAuditPage(MesPdDocumentAuditPageReqVO pageReqVO);
+
+ /**
+ * 鑾峰緱鎸囧畾璧勬枡涓嬬殑瀹℃牳鍒楄〃
+ *
+ * @param documentId 璧勬枡ID
+ * @return 瀹℃牳鍒楄〃
+ */
+ List<MesPdDocumentAuditDO> getDocumentAuditListByDocumentId(Long documentId);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditServiceImpl.java
new file mode 100644
index 0000000..1119fc3
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/documentaudit/MesPdDocumentAuditServiceImpl.java
@@ -0,0 +1,91 @@
+package cn.iocoder.yudao.module.mes.service.pd.documentaudit;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo.MesPdDocumentAuditPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.documentaudit.vo.MesPdDocumentAuditSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.documentaudit.MesPdDocumentAuditDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.documentaudit.MesPdDocumentAuditMapper;
+import cn.iocoder.yudao.module.mes.service.pd.document.MesPdDocumentService;
+import com.mysql.cj.protocol.Security;
+import jakarta.annotation.Resource;
+import org.springframework.stereotype.Service;
+import org.springframework.validation.annotation.Validated;
+
+import java.time.LocalDateTime;
+import java.util.List;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.PD_DOCUMENT_AUDIT_NOT_EXISTS;
+
+/**
+ * MES 璧勬枡瀹℃牳 Service 瀹炵幇绫�
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@Service
+@Validated
+public class MesPdDocumentAuditServiceImpl implements MesPdDocumentAuditService {
+
+ @Resource
+ private MesPdDocumentAuditMapper documentAuditMapper;
+
+ @Resource
+ private MesPdDocumentService documentService;
+
+ @Override
+ public Long createDocumentAudit(MesPdDocumentAuditSaveReqVO createReqVO) {
+ // 鏍￠獙璧勬枡瀛樺湪
+ documentService.getDocument(createReqVO.getDocumentId());
+ // 鎻掑叆
+ MesPdDocumentAuditDO documentAudit = BeanUtils.toBean(createReqVO, MesPdDocumentAuditDO.class);
+ documentAuditMapper.insert(documentAudit);
+ return documentAudit.getId();
+ }
+
+ @Override
+ public void updateDocumentAudit(MesPdDocumentAuditSaveReqVO updateReqVO) {
+ // 鏍￠獙瀛樺湪
+ validateDocumentAuditExists(updateReqVO.getId());
+ if (updateReqVO.getAuditStatus() ==1 ) {
+ updateReqVO.setReviewer(SecurityFrameworkUtils.getLoginUserId());
+ updateReqVO.setAuditTime(LocalDateTime.now());
+ }
+ // 鏇存柊
+ MesPdDocumentAuditDO updateObj = BeanUtils.toBean(updateReqVO, MesPdDocumentAuditDO.class);
+ documentAuditMapper.updateById(updateObj);
+ }
+
+ @Override
+ public void deleteDocumentAudit(Long id) {
+ // 鏍￠獙瀛樺湪
+ validateDocumentAuditExists(id);
+ // 鍒犻櫎
+ documentAuditMapper.deleteById(id);
+ }
+
+ @Override
+ public MesPdDocumentAuditDO getDocumentAudit(Long id) {
+ return documentAuditMapper.selectById(id);
+ }
+
+ @Override
+ public PageResult<MesPdDocumentAuditDO> getDocumentAuditPage(MesPdDocumentAuditPageReqVO pageReqVO) {
+ return documentAuditMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public List<MesPdDocumentAuditDO> getDocumentAuditListByDocumentId(Long documentId) {
+ return documentAuditMapper.selectListByDocumentId(documentId);
+ }
+
+ private MesPdDocumentAuditDO validateDocumentAuditExists(Long id) {
+ MesPdDocumentAuditDO documentAudit = documentAuditMapper.selectById(id);
+ if (documentAudit == null) {
+ throw exception(PD_DOCUMENT_AUDIT_NOT_EXISTS);
+ }
+ return documentAudit;
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectService.java
new file mode 100644
index 0000000..1ac4511
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectService.java
@@ -0,0 +1,110 @@
+package cn.iocoder.yudao.module.mes.service.pd.project;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo.MesPdProjectPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo.MesPdProjectSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.project.MesPdProjectDO;
+import jakarta.validation.Valid;
+
+import java.util.Collection;
+import java.util.List;
+import java.util.Map;
+
+/**
+ * MES 璁捐椤圭洰 Service 鎺ュ彛
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+public interface MesPdProjectService {
+
+ /**
+ * 鍒涘缓璁捐椤圭洰
+ *
+ * @param createReqVO 鍒涘缓淇℃伅
+ * @return 缂栧彿
+ */
+ Long createProject(@Valid MesPdProjectSaveReqVO createReqVO);
+
+ /**
+ * 鏇存柊璁捐椤圭洰
+ *
+ * @param updateReqVO 鏇存柊淇℃伅
+ */
+ void updateProject(@Valid MesPdProjectSaveReqVO updateReqVO);
+
+ /**
+ * 鍒犻櫎璁捐椤圭洰
+ *
+ * @param id 缂栧彿
+ */
+ void deleteProject(Long id);
+
+ /**
+ * 鏍￠獙璁捐椤圭洰鏄惁瀛樺湪
+ *
+ * @param id 缂栧彿
+ * @return 璁捐椤圭洰
+ */
+ MesPdProjectDO validateProjectExists(Long id);
+
+ /**
+ * 鑾峰緱璁捐椤圭洰
+ *
+ * @param id 缂栧彿
+ * @return 璁捐椤圭洰
+ */
+ MesPdProjectDO getProject(Long id);
+
+ /**
+ * 鑾峰緱璁捐椤圭洰鍒嗛〉
+ *
+ * @param pageReqVO 鍒嗛〉鏌ヨ
+ * @return 璁捐椤圭洰鍒嗛〉
+ */
+ PageResult<MesPdProjectDO> getProjectPage(MesPdProjectPageReqVO pageReqVO);
+
+ /**
+ * 鍙戝竷璁捐椤圭洰锛堝緟鍙戝竷鈫掑緟涓婁紶锛�
+ *
+ * @param id 缂栧彿
+ */
+ void publishProject(Long id);
+
+ /**
+ * 涓婁紶璧勬枡锛堝緟涓婁紶鈫掑緟瀹℃牳锛�
+ * <p>
+ * 鍚屾椂鑷姩涓鸿椤圭洰涓嬫墍鏈夎祫鏂欏垱寤哄鏍歌褰�
+ *
+ * @param id 缂栧彿
+ * @param userId 褰撳墠鐧诲綍鐢ㄦ埛ID
+ */
+ void uploadProject(Long id, Long userId);
+
+ /**
+ * 瀹℃牳璁捐椤圭洰锛堝緟瀹℃牳鈫掑緟褰掓。锛�
+ *
+ * @param id 缂栧彿
+ */
+ void auditProject(Long id);
+
+ /**
+ * 褰掓。璁捐椤圭洰锛堝緟褰掓。鈫掑凡褰掓。锛�
+ * <p>
+ * 鍚屾椂鑷姩鍒涘缓褰掓。鍙拌处璁板綍
+ *
+ * @param id 缂栧彿
+ * @param userId 褰撳墠鐧诲綍鐢ㄦ埛ID
+ */
+ void archiveProject(Long id, Long userId);
+
+ /**
+ * 鎵归噺鑾峰彇璁捐椤圭洰 Map
+ *
+ * @param ids 缂栧彿闆嗗悎
+ * @return 璁捐椤圭洰 Map
+ */
+ Map<Long, MesPdProjectDO> getProjectMap(Collection<Long> ids);
+
+ List<MesPdProjectDO> getProjectByProductCode(String productCode);
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectServiceImpl.java
new file mode 100644
index 0000000..729076a
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pd/project/MesPdProjectServiceImpl.java
@@ -0,0 +1,274 @@
+package cn.iocoder.yudao.module.mes.service.pd.project;
+
+import cn.iocoder.yudao.framework.common.pojo.PageResult;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo.MesPdProjectPageReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pd.project.vo.MesPdProjectSaveReqVO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.document.MesPdDocumentDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.documentaudit.MesPdDocumentAuditDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.archive.MesPdArchiveDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pd.project.MesPdProjectDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.project.MesPdProjectMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.documentaudit.MesPdDocumentAuditMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.pd.archive.MesPdArchiveMapper;
+import cn.iocoder.yudao.module.mes.enums.md.autocode.MesMdAutoCodeRuleCodeEnum;
+import cn.iocoder.yudao.module.mes.enums.pd.MesPdProjectStatusEnum;
+import cn.iocoder.yudao.module.mes.service.md.autocode.MesMdAutoCodeRecordService;
+import cn.iocoder.yudao.module.mes.service.pd.document.MesPdDocumentService;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import jakarta.annotation.Resource;
+import org.springframework.context.annotation.Lazy;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.validation.annotation.Validated;
+
+import java.time.LocalDateTime;
+import java.util.Collection;
+import java.util.List;
+import java.util.Map;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertMap;
+import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
+
+/**
+ * MES 璁捐椤圭洰 Service 瀹炵幇绫�
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@Service
+@Validated
+public class MesPdProjectServiceImpl implements MesPdProjectService {
+
+ @Resource
+ private MesPdProjectMapper projectMapper;
+
+ @Resource
+ @Lazy
+ private MesPdDocumentService documentService;
+
+ @Resource
+ private MesPdDocumentAuditMapper documentAuditMapper;
+
+ @Resource
+ private MesPdArchiveMapper archiveMapper;
+
+ @Resource
+ @Lazy
+ private MesMdAutoCodeRecordService autoCodeRecordService;
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public Long createProject(MesPdProjectSaveReqVO createReqVO) {
+ // 鏍￠獙浠诲姟缂栫爜鍞竴
+ validateTaskCodeUnique(null, createReqVO.getTaskCode());
+ // 鎻掑叆
+ MesPdProjectDO project = MesPdProjectDO.builder()
+ .taskCode(createReqVO.getTaskCode())
+ .taskName(createReqVO.getTaskName())
+ .productCode(createReqVO.getProductCode())
+ .productName(createReqVO.getProductName())
+ .version(createReqVO.getVersion())
+ .status(MesPdProjectStatusEnum.INITIATE.getStatus())
+ .chiefDesigner(createReqVO.getChiefDesigner())
+ .reviewer(createReqVO.getReviewer())
+ .planFinishTime(createReqVO.getPlanFinishTime())
+ .remark(createReqVO.getRemark())
+ .build();
+ projectMapper.insert(project);
+ return project.getId();
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void updateProject(MesPdProjectSaveReqVO updateReqVO) {
+ // 鏍￠獙瀛樺湪
+ MesPdProjectDO project = validateProjectExists(updateReqVO.getId());
+ // 鏍￠獙鐘舵�佷负寰呭彂甯�
+ validateProjectInitiate(project);
+ // 鏍￠獙浠诲姟缂栫爜鍞竴
+ validateTaskCodeUnique(updateReqVO.getId(), updateReqVO.getTaskCode());
+ // 鏇存柊
+ MesPdProjectDO updateObj = MesPdProjectDO.builder()
+ .id(updateReqVO.getId())
+ .taskCode(updateReqVO.getTaskCode())
+ .taskName(updateReqVO.getTaskName())
+ .productCode(updateReqVO.getProductCode())
+ .productName(updateReqVO.getProductName())
+ .version(updateReqVO.getVersion())
+ .chiefDesigner(updateReqVO.getChiefDesigner())
+ .reviewer(updateReqVO.getReviewer())
+ .planFinishTime(updateReqVO.getPlanFinishTime())
+ .remark(updateReqVO.getRemark())
+ .build();
+ projectMapper.updateById(updateObj);
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void deleteProject(Long id) {
+ // 鏍￠獙瀛樺湪
+ MesPdProjectDO project = validateProjectExists(id);
+ // 鏍￠獙鐘舵�佷负寰呭彂甯�
+ validateProjectInitiate(project);
+ // 鍒犻櫎璧勬枡瀛愯〃
+ documentService.deleteByProjectId(id);
+ // 鍒犻櫎
+ projectMapper.deleteById(id);
+ }
+
+ @Override
+ public MesPdProjectDO validateProjectExists(Long id) {
+ MesPdProjectDO project = projectMapper.selectById(id);
+ if (project == null) {
+ throw exception(PD_PROJECT_NOT_EXISTS);
+ }
+ return project;
+ }
+
+ @Override
+ public MesPdProjectDO getProject(Long id) {
+ return projectMapper.selectById(id);
+ }
+
+ @Override
+ public PageResult<MesPdProjectDO> getProjectPage(MesPdProjectPageReqVO pageReqVO) {
+ return projectMapper.selectPage(pageReqVO);
+ }
+
+ @Override
+ public void publishProject(Long id) {
+ // 鏍￠獙瀛樺湪
+ MesPdProjectDO project = validateProjectExists(id);
+ // 鏍￠獙鐘舵�佷负寰呭彂甯�
+ if (!MesPdProjectStatusEnum.INITIATE.getStatus().equals(project.getStatus())) {
+ throw exception(PD_PROJECT_NOT_INITIATE_FOR_PUBLISH);
+ }
+ // 鏇存柊鐘舵��
+ projectMapper.updateById(MesPdProjectDO.builder()
+ .id(id)
+ .status(MesPdProjectStatusEnum.PUBLISH.getStatus())
+ .build());
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void uploadProject(Long id, Long userId) {
+ // 鏍￠獙瀛樺湪
+ MesPdProjectDO project = validateProjectExists(id);
+ // 鏍￠獙鐘舵�佷负寰呬笂浼�
+ if (!MesPdProjectStatusEnum.PUBLISH.getStatus().equals(project.getStatus())) {
+ throw exception(PD_PROJECT_NOT_PUBLISH_FOR_UPLOAD);
+ }
+ // 鏇存柊椤圭洰鐘舵�佷负寰呭鏍�
+ projectMapper.updateById(MesPdProjectDO.builder()
+ .id(id)
+ .status(MesPdProjectStatusEnum.UPLOAD.getStatus())
+ .build());
+ // 鑷姩涓鸿椤圭洰涓嬫墍鏈夎祫鏂欏垱寤哄鏍歌褰�
+ List<MesPdDocumentDO> documents = documentService.getDocumentListByProjectId(id);
+ for (MesPdDocumentDO document : documents) {
+ MesPdDocumentAuditDO audit = MesPdDocumentAuditDO.builder()
+ .auditNo(generateAuditNo())
+ .documentId(document.getId())
+ .documentName(document.getDocumentName())
+ .documentVersion(document.getDocumentVersion())
+ .reviewer(project.getReviewer())
+ .auditStatus(0) // 寰呭鏍�
+ .build();
+ documentAuditMapper.insert(audit);
+ }
+ }
+
+ @Override
+ public void auditProject(Long id) {
+ // 鏍￠獙瀛樺湪
+ MesPdProjectDO project = validateProjectExists(id);
+ // 鏍￠獙鐘舵�佷负寰呭鏍�
+ if (!MesPdProjectStatusEnum.UPLOAD.getStatus().equals(project.getStatus())) {
+ throw exception(PD_PROJECT_NOT_UPLOAD_FOR_AUDIT);
+ }
+ // 鏍￠獙璇ラ」鐩笅鎵�鏈夎祫鏂欏鏍歌褰曞潎宸插鏍革紙涓嶅瓨鍦ㄥ緟瀹℃牳鐨勮褰曪級
+ List<MesPdDocumentDO> documents = documentService.getDocumentListByProjectId(id);
+ List<Long> documentIds = documents.stream().map(MesPdDocumentDO::getId).toList();
+ if (documentAuditMapper.existsPendingAuditByDocumentIds(documentIds)) {
+ throw exception(PD_PROJECT_AUDIT_NOT_FINISHED);
+ }
+ // 鏇存柊鐘舵��
+ projectMapper.updateById(MesPdProjectDO.builder()
+ .id(id)
+ .status(MesPdProjectStatusEnum.AUDIT.getStatus())
+ .build());
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void archiveProject(Long id, Long userId) {
+ // 鏍￠獙瀛樺湪
+ MesPdProjectDO project = validateProjectExists(id);
+ // 鏍￠獙鐘舵�佷负寰呭綊妗�
+ if (!MesPdProjectStatusEnum.AUDIT.getStatus().equals(project.getStatus())) {
+ throw exception(PD_PROJECT_NOT_AUDIT_FOR_ARCHIVE);
+ }
+ // 鏇存柊椤圭洰鐘舵�佷负宸插綊妗�
+ projectMapper.updateById(MesPdProjectDO.builder()
+ .id(id)
+ .status(MesPdProjectStatusEnum.ARCHIVE.getStatus())
+ .build());
+ // 鑷姩鍒涘缓褰掓。鍙拌处璁板綍
+ MesPdArchiveDO archive = MesPdArchiveDO.builder()
+ .archiveCode(generateArchiveCode())
+ .projectId(id)
+ .archiver(userId)
+ .archiveStatus(1) // 宸插綊妗�
+ .archiveTime(LocalDateTime.now())
+ .build();
+ archiveMapper.insert(archive);
+ }
+
+ @Override
+ public Map<Long, MesPdProjectDO> getProjectMap(Collection<Long> ids) {
+ List<MesPdProjectDO> list = projectMapper.selectBatchIds(ids);
+ return convertMap(list, MesPdProjectDO::getId);
+ }
+
+ @Override
+ public List<MesPdProjectDO> getProjectByProductCode(String productCode) {
+ return projectMapper.selectList(new QueryWrapper<MesPdProjectDO>().lambda().eq(MesPdProjectDO::getProductCode,productCode).eq(MesPdProjectDO::getStatus, MesPdProjectStatusEnum.ARCHIVE.getStatus()));
+ }
+
+ private void validateProjectInitiate(MesPdProjectDO project) {
+ if (!MesPdProjectStatusEnum.INITIATE.getStatus().equals(project.getStatus())) {
+ throw exception(PD_PROJECT_NOT_INITIATE);
+ }
+ }
+
+ private void validateTaskCodeUnique(Long id, String taskCode) {
+ MesPdProjectDO existing = projectMapper.selectByTaskCode(taskCode);
+ if (existing == null) {
+ return;
+ }
+ // 濡傛灉 id 涓虹┖锛岃鏄庢槸鏂板锛岀紪鐮侀噸澶�
+ if (id == null) {
+ throw exception(PD_PROJECT_CODE_DUPLICATE);
+ }
+ // 濡傛灉 id 涓嶄负绌猴紝璇存槑鏄慨鏀癸紝缂栫爜閲嶅涓斾笉鏄悓涓�鏉¤褰�
+ if (!existing.getId().equals(id)) {
+ throw exception(PD_PROJECT_CODE_DUPLICATE);
+ }
+ }
+
+ /**
+ * 鐢熸垚瀹℃牳鍗曞彿锛堜娇鐢ㄧ紪鐮佽鍒欙級
+ */
+ private String generateAuditNo() {
+ return autoCodeRecordService.generateAutoCode(MesMdAutoCodeRuleCodeEnum.PD_DOCUMENT_AUDIT_CODE.getCode());
+ }
+
+ /**
+ * 鐢熸垚褰掓。缂栧彿锛堜娇鐢ㄧ紪鐮佽鍒欙級
+ */
+ private String generateArchiveCode() {
+ return autoCodeRecordService.generateAutoCode(MesMdAutoCodeRuleCodeEnum.PD_ARCHIVE_CODE.getCode());
+ }
+
+}
diff --git a/yudao-module-mes/src/main/resources/mapper/pd/archive/MesPdArchiveMapper.xml b/yudao-module-mes/src/main/resources/mapper/pd/archive/MesPdArchiveMapper.xml
new file mode 100644
index 0000000..dfa5a92
--- /dev/null
+++ b/yudao-module-mes/src/main/resources/mapper/pd/archive/MesPdArchiveMapper.xml
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="cn.iocoder.yudao.module.mes.dal.mysql.pd.archive.MesPdArchiveMapper">
+
+ <!--
+ 鎸� project_id 鍒嗙粍鍒嗛〉鏌ヨ锛氭瘡缁勫彇鏈�鏂颁竴鏉″綊妗ｈ褰�
+ 鍚屾椂鍏宠仈椤圭洰琛ㄨ幏鍙栦骇鍝佺紪鐮併�佷骇鍝佸悕绉�
+ 瀛愭煡璇㈢粺璁℃瘡涓」鐩笅鐨勫綊妗ｆ暟閲�
+ 杩斿洖鏈�鏂板綊妗ｇ殑 updater銆乽pdate_time
+ MyBatis-Plus 鍒嗛〉鎻掍欢浼氳嚜鍔ㄦ嫤鎴� IPage 鍙傛暟骞舵坊鍔� LIMIT
+ -->
+ <select id="selectPageGroupByProjectId" resultType="cn.iocoder.yudao.module.mes.controller.admin.pd.archive.vo.MesPdArchiveGroupRespVO">
+ SELECT a.*, p.product_code, p.product_name,p.task_code,p.task_name,su.nickname as archiver_nickname,
+ (SELECT COUNT(*) FROM mes_pd_archive cnt WHERE cnt.project_id = a.project_id AND cnt.deleted = 0) AS archive_count
+ FROM mes_pd_archive a
+ INNER JOIN (
+ SELECT MAX(sub.id) AS id
+ FROM mes_pd_archive sub
+ WHERE sub.deleted = 0
+ <if test="req.archiveStatus != null">
+ AND sub.archive_status = #{req.archiveStatus}
+ </if>
+ <if test="req.productCode != null and req.productCode != ''">
+ AND EXISTS (
+ SELECT 1 FROM mes_pd_project pp
+ WHERE pp.id = sub.project_id AND pp.deleted = 0
+ AND pp.product_code LIKE CONCAT('%', #{req.productCode}, '%')
+ )
+ </if>
+ <if test="req.productName != null and req.productName != ''">
+ AND EXISTS (
+ SELECT 1 FROM mes_pd_project pp
+ WHERE pp.id = sub.project_id AND pp.deleted = 0
+ AND pp.product_name LIKE CONCAT('%', #{req.productName}, '%')
+ )
+ </if>
+ GROUP BY sub.project_id
+ ) g ON a.id = g.id
+ LEFT JOIN mes_pd_project p ON a.project_id = p.id AND p.deleted = 0
+ left join system_users su on su.id = a.archiver
+ <where>
+ <if test="req.archiveCode != null and req.archiveCode != ''">
+ AND a.archive_code LIKE CONCAT('%', #{req.archiveCode}, '%')
+ </if>
+ </where>
+ ORDER BY a.update_time DESC
+ </select>
+
+</mapper>
--
Gitblit v1.9.3