From 56e8a8e8f6c90faf8240a5a05d64a6da441888ab Mon Sep 17 00:00:00 2001
From: hsy <1029150275@qq.com>
Date: 星期二, 18 八月 2026 09:50:23 +0800
Subject: [PATCH] feat(mes): add task assignee implementation
---
.agents/rules/compile-check.md | 32 ++
.agents/rules/powershell-commands.md | 35 ++
.agents/rules/sql-syntax.md | 40 ++
.agents/rules/database-mcp.md | 48 +++
.agents/rules/security-guardrails.md | 37 ++
.agents/rules/frontend-project.md | 16 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskServiceImpl.java | 49 +++
docs/sql/mes_pro_task_assignee.sql | 14 +
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/MesProTaskController.java | 25 +
.agents/rules/sql-docs-sync.md | 12
docs/sql/README.md | 5
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/task/MesProTaskAssigneeMapper.java | 38 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskSaveReqVO.java | 3
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pro/task/MesProTaskAssigneeDO.java | 40 ++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskService.java | 19 +
sql/mysql/mes_pro_task_assignee.sql | 14 +
.agents/rules/file-upload.md | 120 ++++++++
.agents/rules/sql-script.md | 6
.agents/rules/frontend-doc-generation.md | 93 ++++++
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskRespVO.java | 6
.agents/rules/frontend-docs.md | 64 ++++
.agents/rules/handover-data-query.md | 103 +++++++
22 files changed, 818 insertions(+), 1 deletions(-)
diff --git a/.agents/rules/compile-check.md b/.agents/rules/compile-check.md
new file mode 100644
index 0000000..46227e5
--- /dev/null
+++ b/.agents/rules/compile-check.md
@@ -0,0 +1,32 @@
+# 缂栬瘧妫�鏌ヨ鍒�
+
+## 瑙勫垯
+
+- 璺ㄦā鍧� API 璋冪敤鍦ㄤ慨鏀瑰畬鎴愭椂锛屽繀椤昏繘琛屼竴娆$紪璇戞鏌ワ紝纭繚娌℃湁寮曞叆缂栬瘧閿欒銆�
+- 浣跨敤鍛戒护锛歚mvn compile -pl <妯″潡鍚�> -am -q` 杩涜蹇�熺紪璇戦獙璇併��
+- 濡傛灉娑夊強澶氫釜妯″潡淇敼锛屽簲鎵ц `mvn compile -q` 杩涜鍏ㄩ」鐩紪璇戦獙璇併��
+
+## 甯歌璺ㄦā鍧� API 璋冪敤鍦烘櫙
+
+| 璋冪敤鏂� | API 鎻愪緵鏂� | 璇存槑 |
+|--------|-----------|------|
+| CRM 妯″潡 | MdmItemApi | MDM 鐗╂枡鎺ュ彛 |
+| CRM 妯″潡 | MdmUnitMeasureApi | MDM 璁¢噺鍗曚綅鎺ュ彛 |
+| CRM 妯″潡 | BpmProcessInstanceApi | BPM 娴佺▼瀹炰緥鎺ュ彛 |
+| CRM 妯″潡 | BpmCategoryService | BPM 鍒嗙被鏈嶅姟 |
+| CRM 妯″潡 | BpmProcessDefinitionService | BPM 娴佺▼瀹氫箟鏈嶅姟 |
+| ERP 妯″潡 | CrmCustomerApi | CRM 瀹㈡埛鎺ュ彛 |
+| ERP 妯″潡 | MdmItemApi | MDM 鐗╂枡鎺ュ彛 |
+
+## 缂栬瘧妫�鏌ョず渚�
+
+```bash
+# 浠呯紪璇� CRM 妯″潡鍙婂叾渚濊禆
+mvn compile -pl yudao-module-crm -am -q
+
+# 浠呯紪璇� ERP 妯″潡鍙婂叾渚濊禆
+mvn compile -pl yudao-module-erp -am -q
+
+# 鍏ㄩ」鐩紪璇�
+mvn compile -q
+```
\ No newline at end of file
diff --git a/.agents/rules/database-mcp.md b/.agents/rules/database-mcp.md
new file mode 100644
index 0000000..dc1f887
--- /dev/null
+++ b/.agents/rules/database-mcp.md
@@ -0,0 +1,48 @@
+# 鏁版嵁搴撴搷浣滆鍒�
+
+## 鏁版嵁搴撶増鏈�
+
+- **MySQL 鐗堟湰**: 8.4.8
+- 娉ㄦ剰 MySQL 8.4 鐨勮娉曞樊寮傦紙濡� `GROUP BY` 鏇翠弗鏍笺�侀儴鍒嗗簾寮冨嚱鏁扮瓑锛�
+
+## Docker 閮ㄧ讲閰嶇疆
+
+```bash
+--sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" \
+--innodb_strict_mode=OFF \
+--innodb_page_size=32k \
+--max_connections=1020 \
+--lower_case_table_names=1 \
+--innodb_buffer_pool_size=70G \
+--innodb_flush_log_at_trx_commit=2 \
+--innodb_log_file_size=2G \
+--innodb_log_buffer_size=64M
+```
+
+**閰嶇疆璇存槑锛�**
+- `lower_case_table_names=1`: 琛ㄥ悕涓嶅尯鍒嗗ぇ灏忓啓
+- `innodb_page_size=32k`: 杈冨ぇ鐨勯〉澶у皬閫傚悎澶ф暟鎹噺鍦烘櫙
+- `innodb_buffer_pool_size=70G`: 缂撳啿姹犲ぇ灏忥紝寤鸿涓虹墿鐞嗗唴瀛樼殑 60-80%
+- `innodb_flush_log_at_trx_commit=2`: 姣忕鍒峰啓鏃ュ織锛屾�ц兘浼樺厛锛堥潪閲戣瀺鍦烘櫙锛�
+
+## 瑙勫垯
+
+- 浼樺厛浣跨敤 MySQL MCP 宸ュ叿锛坄mcp__designcomputer-mysql_mcp_server__execute_sql`銆乣mcp__designcomputer-mysql_mcp_server__get_schema_info`銆乣mcp__designcomputer-mysql_mcp_server__get_table_sample`锛夌洿鎺ユ搷浣滄暟鎹簱锛岃�岄潪閫氳繃 Bash 鎵ц mysql 鍛戒护銆�
+- 鏌ヨ銆侀獙璇併�佽皟璇曟暟鎹簱鏃讹紝鐩存帴璋冪敤 MCP 宸ュ叿鎵ц SQL锛屾棤闇�鍚戠敤鎴疯緭鍑� SQL 璇彞鎴栬闂槸鍚︽墽琛屻��
+- 浠呭湪浠ヤ笅鍦烘櫙杈撳嚭 SQL锛氱敤鎴锋槑纭姹傛煡鐪� SQL銆侀渶瑕佺敓鎴� SQL 鑴氭湰鏂囦欢锛堝杩佺Щ鑴氭湰锛夈�丮CP 宸ュ叿涓嶅彲鐢ㄦ椂鍥為��鍒� Bash銆�
+
+## MCP 宸ュ叿璇存槑
+
+| 宸ュ叿 | 鐢ㄩ�� |
+|------|------|
+| `execute_sql` | 鎵ц SQL 璇彞锛圫ELECT/INSERT/UPDATE/DELETE/DDL锛� |
+| `get_schema_info` | 鑾峰彇琛ㄧ粨鏋勪俊鎭紙鍒楀悕銆佺被鍨嬨�佹敞閲婄瓑锛� |
+| `get_table_sample` | 鑾峰彇琛ㄦ暟鎹牱鏈紙鐢ㄤ簬浜嗚В鏁版嵁鏍煎紡锛� |
+
+## 鎵ц SQL 鑴氭湰
+
+褰撶敤鎴疯姹傛墽琛� SQL 鏂囦欢鏃讹細
+1. 鍏堣鍙栨枃浠跺唴瀹�
+2. 閫愭潯鎵ц SQL 璇彞
+3. 閬囧埌閿欒鏃舵鏌ヨ〃缁撴瀯锛岃皟鏁磋鍙ュ悗閲嶈瘯
+4. 姹囨�绘墽琛岀粨鏋�
\ No newline at end of file
diff --git a/.agents/rules/file-upload.md b/.agents/rules/file-upload.md
new file mode 100644
index 0000000..c90d46a
--- /dev/null
+++ b/.agents/rules/file-upload.md
@@ -0,0 +1,120 @@
+# 鏂囦欢涓婁紶瑙勫垯
+
+## 鏍稿績鍘熷垯锛圓I 蹇呴』涓ユ牸閬靛畧锛�
+
+**鎵�鏈夋枃浠朵笂浼犲繀椤昏蛋 `yudao-module-system` 妯″潡鐨� Storage API + Attachment 涓棿琛ㄦ満鍒躲��**
+
+**绂佹鍦ㄤ换浣曚笟鍔℃ā鍧楄嚜琛岃璁℃枃浠朵笂浼犳柟妗堬紝鍖呮嫭浣嗕笉闄愪簬锛氭坊鍔� `file_url` 鍒椼�佹柊澧� upload 鎺ュ彛銆佹敞鍏� FileApi銆�**
+
+## 鏂囦欢涓庝笟鍔$殑鍏宠仈鏂瑰紡
+
+鏂囦欢涓庝笟鍔¤褰曠殑鍏宠仈**鍙兘閫氳繃 `system_storage_attachment` 涓棿琛�**锛屼笉鍏佽鍦ㄤ笟鍔¤〃涓坊鍔� `file_url`銆乣file_urls`銆乣attachment_url` 绛夊瓧绗︿覆瀛楁瀛樺偍鏂囦欢鍦板潃銆�
+
+鍏宠仈娴佺▼锛�
+1. 鍓嶇璋冪敤 `POST /system/storage-blob/upload` 涓婁紶鏂囦欢 鈫� 鑾峰緱 `blobId`
+2. 鍓嶇璋冪敤 `POST /system/storage-attachment/bind` 缁戝畾鏂囦欢鍒颁笟鍔¤褰曪紙浼犲叆 `recordType` + `recordId` + `blobItems`锛�
+3. 鍓嶇璋冪敤 `GET /system/storage-attachment/list` 鏌ヨ闄勪欢
+4. 鍓嶇璋冪敤 `DELETE /system/storage-attachment/delete` 鍒犻櫎闄勪欢
+
+## 姝g‘鎺ュ彛锛坰ystem 妯″潡锛�
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| POST | `/system/storage-blob/upload` | 涓婁紶鏂囦欢锛坄files` 鍙傛暟锛宮ultipart锛� |
+| POST | `/system/storage-blob/public-upload` | 鍏叡鏂囦欢涓婁紶锛堟案涔呮湁鏁堬級 |
+| GET | `/system/storage-blob/preview/{fileName}` | 鏂囦欢棰勮 |
+| GET | `/system/storage-blob/download/{fileName}` | 鏂囦欢涓嬭浇 |
+| GET | `/system/storage-attachment/list` | 鏌ヨ闄勪欢鍒楄〃 |
+| POST | `/system/storage-attachment/bind` | 缁戝畾闄勪欢鍒颁笟鍔¤褰� |
+| DELETE | `/system/storage-attachment/delete` | 鎵归噺鍒犻櫎闄勪欢 |
+
+## 绂佹琛屼负锛圓I 涓ョ鎵ц浠ヤ笅鎿嶄綔锛�
+
+### 鏁版嵁搴撳眰闈�
+- 鉂� 绂佹鍦ㄤ笟鍔¤〃娣诲姞 `file_url`銆乣file_urls`銆乣attachment_url` 绛夋枃浠跺湴鍧�鍒�
+- 鉂� 绂佹鍦ㄤ笟鍔¤〃娣诲姞浠讳綍鐢ㄤ簬瀛樺偍鏂囦欢淇℃伅鐨� JSON 鍒�
+
+### Java 鍚庣灞傞潰
+- 鉂� 绂佹鍦� DO 绫绘坊鍔� `fileUrl`銆乣fileUrls`銆乣attachmentUrl` 绛夊瓧娈�
+- 鉂� 绂佹鍦� SaveReqVO / RespVO 娣诲姞鏂囦欢鍦板潃瀛楁
+- 鉂� 绂佹鍦� MES/CRM/ERP/HRM 绛変笟鍔℃ā鍧楁柊澧� `@PostMapping("/upload")` 鎺ュ彛
+- 鉂� 绂佹鍦� Controller 涓娇鐢� `MultipartFile` 鍙傛暟锛圗xcel 瀵煎叆闄ゅ锛�
+- 鉂� 绂佹娉ㄥ叆鎴栬皟鐢� `cn.iocoder.yudao.module.infra.api.file.FileApi`
+
+### 鍓嶇灞傞潰
+- 鉂� 绂佹璋冪敤 `/infra/file/upload` 鎴� `/infra/file/presigned-url`
+- 鉂� 绂佹璋冪敤鏃х増 `src/api/infra/file/index.ts` 涓殑 `uploadFile()` 鍑芥暟
+
+## 甯歌 AI 骞昏妯″紡锛堝繀椤昏瘑鍒苟鎷掔粷锛�
+
+浠ヤ笅鏄� AI 瀹规槗骞昏鐢熸垚鐨勮璁℃ā寮忥紝閬囧埌绫讳技闇�姹傛椂鐩存帴鎷掔粷锛�
+
+1. **"鍔犱釜 fileUrl 瀛楁灏辫"** 鈫� 閿欒锛屽繀椤荤敤 attachment 涓棿琛�
+2. **"鍙傝�冨叾瀹冩ā鍧楃殑 fileUrl 瀛楁"** 鈫� 閿欒锛屽叾瀹冩ā鍧楃殑 fileUrl 涔熷簲琚垹闄�
+3. **"鍦� Controller 鍔犱釜 upload 鎺ュ彛"** 鈫� 閿欒锛岀粺涓�璧� system 妯″潡
+4. **"鐢� FileApi 涓婁紶鏂囦欢"** 鈫� 閿欒锛孎ileApi 鏄� infra 妯″潡鐨勬棫鎺ュ彛
+5. **"鍦ㄨ〃鍗曚繚瀛樻帴鍙e姞 MultipartFile 鍙傛暟"** 鈫� 閿欒锛屼笂浼犲拰淇濆瓨鍒嗙
+
+## 姝g‘绀轰緥
+
+### 鍓嶇璋冪敤
+
+```typescript
+import { uploadFile, bindAttachments, listAttachments } from '#/api/system/storage';
+
+// 1. 涓婁紶鏂囦欢
+const blobs = await uploadFile([file]);
+const blobId = blobs[0].id;
+
+// 2. 淇濆瓨涓氬姟璁板綍鍚庯紝缁戝畾闄勪欢
+await bindAttachments({
+ application: 'file',
+ recordType: 'erp_purchase_order',
+ recordId: savedRecord.id,
+ blobItems: [{ blobId }],
+});
+
+// 3. 鏌ヨ闄勪欢
+const attachments = await listAttachments({
+ recordType: 'erp_purchase_order',
+ recordId: savedRecord.id,
+});
+```
+
+### recordType 鍛藉悕瑙勮寖
+
+鏍煎紡锛歚{妯″潡鍓嶇紑}_{涓氬姟琛ㄥ悕}`
+
+| 妯″潡 | recordType |
+|------|------------|
+| ERP 閲囪喘璁㈠崟 | `erp_purchase_order` |
+| ERP 閲囪喘鐢宠 | `erp_purchase_request` |
+| ERP 閿�鍞鍗� | `erp_sale_order` |
+| ERP 鏀舵鍗� | `erp_finance_receipt` |
+| ERP 浠樻鍗� | `erp_finance_payment` |
+| HRM 璇峰亣 | `hrm_leave_application` |
+| HRM 绂昏亴 | `hrm_resignation_application` |
+| HRM 璋冨姩 | `hrm_transfer_application` |
+| MES 閲囪喘璁㈠崟 | `mes_purchase_order` |
+| MES 宸ュ崟 | `mes_pro_work_order` |
+| CRM 瀹㈡埛 | `crm_customer` |
+
+## AI 鑷煡娓呭崟
+
+鍦ㄥ疄鐜颁换浣曟枃浠朵笂浼犵浉鍏抽渶姹傚墠锛岄�愰」纭锛�
+
+- [ ] 鏄惁浣跨敤浜� `/system/storage-blob/upload` 涓婁紶锛�
+- [ ] 鏄惁浣跨敤浜� `/system/storage-attachment/bind` 鍏宠仈锛�
+- [ ] 鏄惁娌℃湁鍦ㄤ笟鍔¤〃涓坊鍔犳枃浠跺湴鍧�鍒楋紵
+- [ ] 鏄惁娌℃湁鍦� DO/VO 涓坊鍔犳枃浠跺湴鍧�瀛楁锛�
+- [ ] 鏄惁娌℃湁鍒涘缓鏂扮殑 upload Controller 鎺ュ彛锛�
+- [ ] 鏄惁娌℃湁浣跨敤 infra 妯″潡鐨� FileApi锛�
+
+浠ヤ笂 6 椤瑰叏閮ㄤ负"鏄�"鎵嶅彲缁х画銆�
+
+## 涓轰粈涔�
+
+- 瀛樺偍閰嶇疆锛堟湰鍦�/S3锛夊湪 system 妯″潡缁熶竴绠$悊
+- 闄勪欢缁戝畾鏈哄埗锛坰torage-attachment锛夋彁渚� `recordType + recordId` 鐨勬爣鍑嗗叧鑱旀柟寮忥紝鏀寔澶氭枃浠躲�佺敤閫斿垎绫�
+- infra 妯″潡鐨� `/infra/file/*` 鏄棫鐗堟帴鍙o紝瀛樺湪鏂囦欢涓庝笟鍔¤褰曟棤娉曞叧鑱旂殑闂
+- 涓氬姟琛ㄥ瓨鍌� file_url 瀛楃涓叉棤娉曟敮鎸佸鏂囦欢锛屼笖鏂囦欢涓庝笟鍔¤褰曚箣闂寸己涔忔爣鍑嗗寲鐨勫叧鑱旂鐞�
\ No newline at end of file
diff --git a/.agents/rules/frontend-doc-generation.md b/.agents/rules/frontend-doc-generation.md
new file mode 100644
index 0000000..c9e3663
--- /dev/null
+++ b/.agents/rules/frontend-doc-generation.md
@@ -0,0 +1,93 @@
+---
+name: frontend-doc-generation
+description: 鍓嶇鑱旇皟鏂规鐢熸垚瑙勫垯
+metadata:
+ type: feedback
+---
+
+# 鍓嶇鑱旇皟鏂规瑙勫垯
+
+## 瑙勫垯
+
+鍚庣鎺ュ彛鍙樻洿鏃讹紝**涓嶇敓鎴愬墠绔唬鐮�**锛屽彧鐢熸垚鍓嶇鑱旇皟鏂规鏂囨。锛岃緭鍑哄埌 `docs/` 鐩綍銆�
+
+## 绂佹鍐呭
+
+- 鉂� 绂佹鍐� Vue 妯℃澘浠g爜锛坄<el-table-column>`銆乣<el-form-item>` 绛夛級
+- 鉂� 绂佹鍐� JavaScript/TypeScript 浠g爜锛堟柟娉曘�佸嚱鏁般�侀�昏緫鍒ゆ柇绛夛級
+- 鉂� 绂佹鍐� CSS 鏍峰紡浠g爜
+- 鉂� 绂佹鍐欏墠绔粍浠朵娇鐢ㄧず渚�
+
+## 鑱旇皟鏂规鍐呭瑕佹眰
+
+鏂囨。搴斿彧鍖呭惈浠ヤ笅鍐呭锛�
+
+- **API 璇存槑**锛氳矾寰勩�佹柟娉曘�佽姹傚弬鏁般�佸搷搴旀牸寮�
+- **娑夊強鐨勫墠绔〉闈�**锛氬垪鍑洪渶瑕佷慨鏀圭殑椤甸潰鍚嶇О
+- **鏁版嵁甯﹀叆璇存槑**锛氶噸鐐瑰己璋冧俊鎭浣曚粠涓婁竴姝ュ甫鍏ワ紙濡傞噰璐鍗� -> 鍒拌揣閫氱煡 -> 閲囪喘鍏ュ簱锛�
+- **鎺ュ彛璋冪敤鏃跺簭**锛氳鏄庝綍鏃惰皟鐢ㄥ摢涓帴鍙h幏鍙栧叧鑱旀暟鎹�
+- **瀛楁灞曠ず瑙勫垯**锛氱敤琛ㄦ牸璇存槑瀛楁灞曠ず浣嶇疆鍜岃鏄庯紝涓嶅啓浠g爜
+- **涓氬姟瑙勫垯璇存槑**锛氱敤鏂囧瓧鎴栬〃鏍艰鏄庝笟鍔¢�昏緫
+- **娉ㄦ剰浜嬮」**锛氶渶瑕佸墠绔敞鎰忕殑杈圭晫鎯呭喌
+
+## 鏂囨。妯℃澘
+
+```markdown
+# 鍔熻兘鍚嶇О - 鍓嶇鑱旇皟鏂规
+
+## 娑夊強椤甸潰
+
+- 椤甸潰1
+- 椤甸潰2
+
+## 涓氬姟娴佺▼涓庢暟鎹甫鍏�
+
+1. 姝ラ1 -> 姝ラ2锛氬瓧娈礎銆佸瓧娈礏 浠庢楠�1鑷姩甯﹀叆
+2. 姝ラ2 -> 姝ラ3锛氬瓧娈礐 浠庢楠�2鑷姩甯﹀叆
+
+## API
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| POST | /xxx/xxx | 璇存槑 |
+
+**璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭~ | 璇存槑 |
+|------|------|------|------|
+| xxx | String | 鏄� | xxx |
+
+**鍝嶅簲瀛楁鏂板锛�**
+
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| xxx | String | xxx |
+
+**鍝嶅簲绀轰緥锛�**
+
+```json
+{
+ "code": 0,
+ "data": {}
+}
+```
+
+## 瀛楁灞曠ず瑙勫垯
+
+| 瀛楁 | 灞曠ず浣嶇疆 | 璇存槑 |
+|------|----------|------|
+| 瀛楁A | 鍒楄〃銆佽鎯� | 璇存槑 |
+| 瀛楁B | 璇︽儏 | 璇存槑 |
+
+## 涓氬姟瑙勫垯璇存槑
+
+| 鍦烘櫙 | 瑙勫垯 |
+|------|------|
+| 鍦烘櫙1 | 瑙勫垯璇存槑 |
+| 鍦烘櫙2 | 瑙勫垯璇存槑 |
+
+## 娉ㄦ剰浜嬮」
+
+- 娉ㄦ剰浜嬮」1
+- 娉ㄦ剰浜嬮」2
+```
\ No newline at end of file
diff --git a/.agents/rules/frontend-docs.md b/.agents/rules/frontend-docs.md
new file mode 100644
index 0000000..c6e349b
--- /dev/null
+++ b/.agents/rules/frontend-docs.md
@@ -0,0 +1,64 @@
+# 鎺ュ彛鍙樻洿鍓嶇鑱旇皟鏂规瑙勫垯
+
+## 瑙勫垯
+
+- 姣忔娑夊強鎺ュ彛鍙樻洿锛堟柊澧炴帴鍙c�佷慨鏀硅姹傚弬鏁般�佷慨鏀瑰搷搴旂粨鏋勶級鏃讹紝蹇呴』杈撳嚭涓�浠�**鍓嶇鑱旇皟鏂规**鍒� `docs/` 鐩綍銆�
+- **涓嶇敓鎴愬墠绔唬鐮�**锛屽彧鐢熸垚鑱旇皟鏂规鏂囨。锛屾寚瀵煎墠绔紑鍙戜汉鍛樺浣曞鎺ャ��
+- 鏂囨。浠� Markdown 鏍煎紡缂栧啓锛屾枃浠跺悕浣跨敤灏忓啓瀛楁瘝鍜屼笅鍒掔嚎锛屽 `docs/purchase_receipt_integration.md`銆�
+- 鏂囨。鍐呭閲嶇偣寮鸿皟**淇℃伅甯﹀叆**闂锛氬摢浜涙暟鎹粠涓婁竴姝ヨ嚜鍔ㄥ甫鍏ャ�佷綍鏃惰幏鍙栧叧鑱旀暟鎹�佸瓧娈靛浣曟槧灏勩��
+
+## 鏂囨。妯℃澘
+
+```markdown
+# 鍔熻兘鍚嶇О
+
+## 娑夊強椤甸潰
+
+- 椤甸潰1
+- 椤甸潰2
+
+## API
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| POST | /xxx/xxx | 璇存槑 |
+
+**璇锋眰鍙傛暟锛�**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭~ | 璇存槑 |
+|------|------|------|------|
+| xxx | String | 鏄� | xxx |
+
+**鍝嶅簲锛�** `{ "code": 200, "msg": "鎿嶄綔鎴愬姛" }`
+
+## 鍓嶇淇敼鐐�
+
+### 1. 鎸夐挳/寮圭獥/琛ㄦ牸绛�
+
+\`\`\`html
+<el-button>xxx</el-button>
+\`\`\`
+
+### 2. data 鏁版嵁
+
+\`\`\`js
+data() {
+ return {
+ xxx: '',
+ }
+}
+\`\`\`
+
+### 3. 鏂规硶
+
+\`\`\`js
+handleXxx() {
+ // ...
+}
+\`\`\`
+
+## 娉ㄦ剰浜嬮」
+
+- 娉ㄦ剰浜嬮」1
+- 娉ㄦ剰浜嬮」2
+```
\ No newline at end of file
diff --git a/.agents/rules/frontend-project.md b/.agents/rules/frontend-project.md
new file mode 100644
index 0000000..ee5100d
--- /dev/null
+++ b/.agents/rules/frontend-project.md
@@ -0,0 +1,16 @@
+# 鍓嶇椤圭洰瑙勫垯
+
+## 瑙勫垯
+
+- `mom-pro2-before` 鏄墠绔」鐩紝浣嶄簬鍚庣椤圭洰鏍圭洰褰曚笅锛坄D:\鐗涢┈\鍗楅�歕鍚庣\mom-pro2-after\mom-pro2-before`锛夈��
+- 鍙互鏌ョ湅鍓嶇浠g爜浣滀负鍙傝�冿紝甯姪鐞嗚В涓氬姟閫昏緫銆佽璁″悗绔柟妗堛��
+- **鏈粡鐢ㄦ埛鏄庣‘鍏佽锛岀姝慨鏀瑰墠绔」鐩腑鐨勪换浣曟枃浠躲��**
+
+## 浣跨敤鍦烘櫙
+
+| 鍏佽 | 绂佹 |
+|------|------|
+| 璇诲彇鍓嶇鏂囦欢浜嗚В鐜版湁瀹炵幇 | 淇敼鍓嶇浠g爜 |
+| 鍙傝�冨墠绔� API 璋冪敤鏂瑰紡璁捐鍚庣鎺ュ彛 | 鏂板鍓嶇缁勪欢/椤甸潰 |
+| 鍙傝�冨墠绔暟鎹粨鏋勭悊瑙d笟鍔� | 鍒犻櫎鍓嶇鏂囦欢 |
+| 鍦ㄥ墠绔」鐩腑鎼滅储/鏌ユ壘浠g爜 | 閲嶆瀯鍓嶇浠g爜 |
\ No newline at end of file
diff --git a/.agents/rules/handover-data-query.md b/.agents/rules/handover-data-query.md
new file mode 100644
index 0000000..8236ee2
--- /dev/null
+++ b/.agents/rules/handover-data-query.md
@@ -0,0 +1,103 @@
+# 鏁版嵁浜ゆ帴鏌ヨ瑙勫垯
+
+## 瑙勫垯
+
+鎵�鏈夋ā鍧楀湪鏌ヨ"鎴戠殑鏁版嵁"锛堟寜鐢ㄦ埛 ID 杩囨护鐨勪笟鍔℃暟鎹垪琛級鏃讹紝**蹇呴』璋冪敤 `HrmUserHandoverApi.expandUserIds()`** 鎵╁睍鐢ㄦ埛 ID 闆嗗悎锛岀‘淇濅氦鎺ヤ汉鑳芥煡鐪嬪凡绂昏亴浜ゆ帴浜虹殑涓氬姟鏁版嵁銆�
+
+## 鑳屾櫙
+
+褰撳憳宸ョ鑱屾椂锛屽叾涓氬姟鏁版嵁锛堝鎴枫�佸晢鏈恒�佸伐鍗曘�侀噰璐敵璇风瓑锛夐渶瑕佷氦鐢变氦鎺ヤ汉绠$悊銆傜郴缁熼�氳繃 `hrm_user_handover` 鏄犲皠琛ㄨ褰曚簡绂昏亴鐢ㄦ埛涓庝氦鎺ョ洰鏍囩敤鎴风殑鍏宠仈锛岃�岄潪鐩存帴淇敼涓氬姟鏁版嵁鐨勬墍鏈夎�呭瓧娈点��
+
+鏌ヨ鏃堕�氳繃 `expandUserIds` 灏嗕氦鎺ユ簮鐢ㄦ埛 ID 绾冲叆鏌ヨ鑼冨洿锛屼娇浜ゆ帴浜鸿兘鍚屾椂鐪嬪埌鑷繁鍜岀鑱屼汉鐨勬暟鎹��
+
+## 鏍稿績 API
+
+```java
+// 鎺ュ彛锛欻rmUserHandoverApi (yudao-module-hrm-api)
+public interface HrmUserHandoverApi {
+ Set<Long> expandUserIds(Set<Long> userIds);
+}
+```
+
+## 鍚勬ā鍧楅泦鎴愭柟寮�
+
+### 鍩烘湰鐢ㄦ硶
+
+```java
+// 娉ㄥ叆 API
+@Resource
+private HrmUserHandoverApi handoverApi;
+
+// 鍦ㄦ煡璇㈠墠鎵╁睍 userId
+public PageResult<XxxDO> getXxxPage(XxxPageReqVO reqVO) {
+ Long currentUserId = getCurrentUserId();
+ Set<Long> expandedUserIds = handoverApi.expandUserIds(Set.of(currentUserId));
+ // 鐢� expandedUserIds 鍋� IN 鏌ヨ
+ return mapper.selectPage(reqVO, new LambdaQueryWrapperX<XxxDO>()
+ .in(XxxDO::getOwnerUserId, expandedUserIds)
+ ...);
+}
+```
+
+### Mapper 灞傚啓娉�
+
+```java
+// 濡傛灉 userId 鏄姩鎬佷紶鍏ョ殑锛堝绠$悊鍛樺彲鏌ョ湅鎵�鏈変汉鐨勬暟鎹級锛屽厛鍋氬垽鏂細
+default PageResult<XxxDO> selectPage(XxxPageReqVO reqVO, Set<Long> userIds) {
+ return selectPage(reqVO, new LambdaQueryWrapperX<XxxDO>()
+ .inIfPresent(XxxDO::getOwnerUserId, CollUtil.isNotEmpty(userIds) ? userIds : null)
+ ...);
+}
+```
+
+## 鍚勬ā鍧楁秹鍙婄殑鏌ヨ鍦烘櫙
+
+| 妯″潡 | 鏌ヨ鍦烘櫙 | 娑夊強琛� | 鐢ㄦ埛瀛楁 |
+|------|----------|--------|----------|
+| CRM | 鎴戠殑瀹㈡埛 | `crm_customer` | `ownerUserId` |
+| CRM | 鎴戠殑绾跨储 | `crm_clue` | `ownerUserId` |
+| CRM | 鎴戠殑鑱旂郴浜� | `crm_contact` | `ownerUserId` |
+| CRM | 鎴戠殑鍚堝悓 | `crm_contract` | `ownerUserId` |
+| CRM | 鎴戠殑鍟嗘満 | `crm_business` | `ownerUserId` |
+| CRM | 鎴戠殑鍥炴 | `crm_receivable` | `ownerUserId` |
+| CRM | 鎴戠殑鍥炴璁″垝 | `crm_receivable_plan` | `ownerUserId` |
+| CRM | 鎴戠殑鎶ヤ环 | `crm_sale_quotation` | `ownerUserId` |
+| ERP | 鎴戠殑閲囪喘鐢宠 | `erp_purchase_request` | `requestUserId` |
+| ERP | 鎴戠殑閿�鍞鍗� | `erp_sale_order` | `saleUserId` |
+| ERP | 鎴戠殑浠樻鍗� | `erp_finance_payment` | `financeUserId` |
+| ERP | 鎴戠殑鏀舵鍗� | `erp_finance_receipt` | `financeUserId` |
+| MES | 鎴戠殑宸ュ崟/鎶ュ伐/璐ㄦ绛� | 鍚� MES 琛� | `userId` / `inspectorUserId` / `chargeUserId` 绛� |
+
+## expandUserIds 鍘熺悊
+
+```
+hrm_user_handover 琛ㄨ褰�:
+鈹屸攢鈹�鈹�鈹�鈹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�
+鈹� id 鈹� from_user_id 鈹� to_user_id 鈹� resignation_id鈹� handover_status 鈹�
+鈹溾攢鈹�鈹�鈹�鈹尖攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹尖攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹尖攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹尖攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�
+鈹� 1 鈹� 100(绂昏亴浜�) 鈹� 101(浜ゆ帴浜�)鈹� 1 鈹� 20(宸插畬鎴�) 鈹�
+鈹斺攢鈹�鈹�鈹�鈹粹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹粹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹粹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹粹攢鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�
+
+expandUserIds({101}) 鈫� {101, 100}
+鈫� 浜ゆ帴浜�101鏌ヨ鏃讹細WHERE owner_user_id IN (101, 100)
+鈫� 鍚屾椂鐪嬪埌鑷繁鐨勫拰绂昏亴浜虹殑鏁版嵁
+```
+
+## 娉ㄦ剰浜嬮」
+
+- `expandUserIds` 鍙墿灞�**宸插畬鎴愮殑浜ゆ帴璁板綍**锛坄handoverStatus = 20`锛�
+- 浼犲叆绌洪泦鍚堣繑鍥炵┖闆嗗悎
+- 鏌ヨ鎬ц兘锛氭槧灏勮〃鏁版嵁閲忔瀬灏忥紙浠呬负宸茬鑱屼汉鍛樻暟锛夛紝鍙斁蹇冨湪姣忔鏌ヨ鍓嶈皟鐢�
+- 濡傛灉鏌ヨ瑕佹眰涓ユ牸鍙湅鏈汉鏁版嵁锛堝涓汉璁剧疆椤碉級锛屽垯涓嶅簲璋冪敤 `expandUserIds`
+
+## Maven 渚濊禆
+
+闇�瑕佸湪妯″潡鐨� `pom.xml` 涓坊鍔犲 HRM API 鐨勪緷璧栵細
+
+```xml
+<dependency>
+ <groupId>cn.iocoder.boot</groupId>
+ <artifactId>yudao-module-hrm-api</artifactId>
+ <version>${revision}</version>
+</dependency>
+```
diff --git a/.agents/rules/powershell-commands.md b/.agents/rules/powershell-commands.md
new file mode 100644
index 0000000..04a9b69
--- /dev/null
+++ b/.agents/rules/powershell-commands.md
@@ -0,0 +1,35 @@
+# PowerShell 鍛戒护瑙勫垯
+
+## 瑙勫垯
+
+鐢变簬椤圭洰杩愯鍦� Windows 鐜涓嬶紝鐢ㄦ埛缁堢榛樿浣跨敤 PowerShell 鑰岄潪 bash銆傚湪鎻愪緵鍛戒护琛屾寚瀵兼椂锛屽繀椤讳娇鐢� PowerShell 璇硶銆�
+
+## 甯哥敤鍛戒护瀵圭収
+
+| 鎿嶄綔 | Bash | PowerShell |
+|------|------|-------------|
+| 鍒犻櫎鐩綍 | `rm -rf <path>` | `Remove-Item -Recurse -Force <path>` 鎴栫畝鍐� `ri -r -fo <path>` |
+| 澶嶅埗鏂囦欢 | `cp <src> <dest>` | `Copy-Item <src> <dest>` 鎴栫畝鍐� `cp <src> <dest>` |
+| 绉诲姩鏂囦欢 | `mv <src> <dest>` | `Move-Item <src> <dest>` 鎴栫畝鍐� `mv <src> <dest>` |
+| 鍒涘缓鐩綍 | `mkdir -p <path>` | `New-Item -ItemType Directory -Path <path>` 鎴栫畝鍐� `md <path>` |
+| 鏌ョ湅鏂囦欢 | `cat <file>` | `Get-Content <file>` 鎴栫畝鍐� `gc <file>` |
+| 鍒楀嚭鏂囦欢 | `ls` | `Get-ChildItem` 鎴栫畝鍐� `ls`/`dir` |
+| 鏌ユ壘鏂囦欢 | `find . -name "*.java"` | `Get-ChildItem -Recurse -Filter "*.java"` 鎴栫畝鍐� `gci -r -fi "*.java"` |
+| 鏌ユ壘鍐呭 | `grep -r "pattern" .` | `Select-String -Path "*.java" -Pattern "pattern"` 鎴栫畝鍐� `sls "pattern" *.java -r` |
+
+## 鍒犻櫎鐩綍绀轰緥
+
+```powershell
+# 鎺ㄨ崘锛氫娇鐢� Remove-Item 瀹屾暣鍛戒护
+Remove-Item -Recurse -Force yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/md/client
+
+# 绠�鍐欏舰寮�
+ri -r -fo yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/md/client
+```
+
+## 娉ㄦ剰浜嬮」
+
+- PowerShell 鍙傛暟浣跨敤 `-` 鍓嶇紑锛屽 `-Recurse`銆乣-Force`
+- 鍙傛暟鍙互绠�鍐欓瀛楁瘝锛屽 `-r`銆乣-fo`
+- 璺緞鍒嗛殧绗﹀湪 PowerShell 涓彲浠ヤ娇鐢� `/` 鎴� `\`锛屾帹鑽愪娇鐢� `/` 浠ヤ繚鎸佽法骞冲彴鍏煎
+- 閬垮厤 `-rf` 杩欐牱鐨� bash 椋庢牸鍙傛暟缁勫悎锛孭owerShell 涓嶆敮鎸�
\ No newline at end of file
diff --git a/.agents/rules/security-guardrails.md b/.agents/rules/security-guardrails.md
new file mode 100644
index 0000000..21348c2
--- /dev/null
+++ b/.agents/rules/security-guardrails.md
@@ -0,0 +1,37 @@
+# 瀹夊叏鎶ゆ爮
+
+## SQL 娉ㄥ叆闃叉姢
+
+- 姘歌繙涓嶈灏嗙敤鎴疯緭鍏ョ洿鎺ユ嫾鎺ュ埌 SQL 鏌ヨ涓��
+- 濮嬬粓浣跨敤鍙傛暟鍖栨煡璇㈡垨 ORM 鏂规硶銆�
+- 鍦ㄦ暟鎹簱鎿嶄綔鍓嶉獙璇佸拰娓呯悊鎵�鏈夎緭鍏ャ��
+
+## XSS 闃叉姢
+
+- 鍦� HTML 涓覆鏌撳墠杞箟鎵�鏈夌敤鎴风敓鎴愮殑鍐呭銆�
+- 浣跨敤妯℃澘鑷姩杞箟鍔熻兘銆�
+- 鍦ㄥ鎴风鍜屾湇鍔″櫒绔兘杩涜杈撳叆楠岃瘉鍜屾竻鐞嗐��
+
+## 瀵嗛挜绠$悊
+
+- 姘歌繙涓嶈鍦ㄦ簮浠g爜涓‖缂栫爜瀵嗛挜銆丄PI 瀵嗛挜鎴栧瘑鐮併��
+- 浣跨敤鐜鍙橀噺鎴栧畨鍏ㄤ繚闄╁簱瀛樺偍鏁忔劅鏁版嵁銆�
+- 瀹氭湡杞崲瀵嗛挜锛岄伩鍏嶅湪鏃ュ織涓褰曞畠浠��
+
+## 杈撳叆楠岃瘉
+
+- 鍦ㄧ郴缁熻竟鐣屽楠岃瘉鎵�鏈夎緭鍏ャ��
+- 浣跨敤鐧藉悕鍗曡�岄潪榛戝悕鍗曡繘琛岄獙璇併��
+- 鍦ㄥ鐞嗕笂浼犲墠妫�鏌ユ枃浠剁被鍨嬪拰澶у皬銆�
+
+## 閿欒澶勭悊
+
+- 涓嶈鍦ㄩ敊璇秷鎭腑鏆撮湶鏁忔劅淇℃伅銆�
+- 鍦ㄥ唴閮ㄨ褰曡缁嗛敊璇紝鍚戠敤鎴疯繑鍥為�氱敤娑堟伅銆�
+- 澶勭悊鎵�鏈夊紓甯镐互闃叉淇℃伅娉勯湶銆�
+
+## 渚濊禆绠$悊
+
+- 淇濇寔渚濊禆椤规洿鏂般��
+- 瀹¤渚濊禆椤逛腑鐨勫凡鐭ユ紡娲炪��
+- 鍥哄畾鐗堟湰浠ラ伩鍏嶆剰澶栫殑鐮村潖鎬у彉鏇淬��
diff --git a/.agents/rules/sql-docs-sync.md b/.agents/rules/sql-docs-sync.md
new file mode 100644
index 0000000..d6a73cc
--- /dev/null
+++ b/.agents/rules/sql-docs-sync.md
@@ -0,0 +1,12 @@
+---
+description: Automatically sync new SQL files to docs/sql and update the index
+---
+
+# SQL Files Management Rule
+
+**CRITICAL RULE**: Whenever you create or add a new SQL file (e.g. database migrations, init scripts) in this project (such as in `sql/mysql/` or anywhere else), you MUST:
+
+1. **Copy/Create a duplicate** of that SQL file in the `docs/sql/` directory.
+2. **Update the SQL Index**: Record the newly added SQL file in `docs/sql/README.md` (create the README file if it does not exist) with a brief description of what the SQL file does.
+
+Always remember this when you are generating new SQL scripts to maintain the project's documentation consistency.
diff --git a/.agents/rules/sql-script.md b/.agents/rules/sql-script.md
new file mode 100644
index 0000000..19b1ccb
--- /dev/null
+++ b/.agents/rules/sql-script.md
@@ -0,0 +1,6 @@
+# SQL 鑴氭湰瑙勮寖
+
+## 瑙勫垯
+
+- SQL 鑴氭湰涓笉瑕佸寘鍚� tenant_id 瀛楁锛岄」鐩笉浣跨敤澶氱鎴锋ā寮忋��
+- INSERT 璇彞鍙寘鍚繀瑕佺殑涓氬姟瀛楁锛屼笉闇�瑕� tenant_id銆�
\ No newline at end of file
diff --git a/.agents/rules/sql-syntax.md b/.agents/rules/sql-syntax.md
new file mode 100644
index 0000000..74e1b19
--- /dev/null
+++ b/.agents/rules/sql-syntax.md
@@ -0,0 +1,40 @@
+# SQL 璇硶瑙勮寖
+
+## 瑙勫垯
+
+- MySQL `ALTER TABLE ADD COLUMN` 涓嶆敮鎸� `IF NOT EXISTS` 璇硶锛屽嵆浣� MySQL 8.0+ 涔熶笉鏀寔銆�
+- 娣诲姞瀛楁鍓嶉渶瑕佸厛妫�鏌ュ瓧娈垫槸鍚﹀瓨鍦紝鎴栫洿鎺ユ墽琛屽苟蹇界暐"瀛楁宸插瓨鍦�"閿欒銆�
+
+## 姝g‘绀轰緥
+
+```sql
+-- 姝g‘锛氱洿鎺ユ坊鍔犲瓧娈�
+ALTER TABLE mes_wm_sn ADD COLUMN uuid VARCHAR(64) COMMENT '鎵规UUID' AFTER id;
+
+-- 姝g‘锛氬厛妫�鏌ュ啀娣诲姞锛堝吋瀹硅剼鏈級
+SET @exists = (SELECT COUNT(*) FROM information_schema.columns
+ WHERE table_schema = DATABASE() AND table_name = 'mes_wm_sn' AND column_name = 'uuid');
+SET @sql = IF(@exists = 0,
+ 'ALTER TABLE mes_wm_sn ADD COLUMN uuid VARCHAR(64) COMMENT ''鎵规UUID'' AFTER id',
+ 'SELECT 1');
+PREPARE stmt FROM @sql;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+```
+
+## 閿欒绀轰緥
+
+```sql
+-- 閿欒锛欰DD COLUMN 涓嶆敮鎸� IF NOT EXISTS
+ALTER TABLE mes_wm_sn ADD COLUMN IF NOT EXISTS uuid VARCHAR(64) COMMENT '鎵规UUID' AFTER id;
+```
+
+## IF NOT EXISTS 鏀寔鍦烘櫙
+
+| 璇彞 | 鏄惁鏀寔 |
+|------|---------|
+| CREATE TABLE IF NOT EXISTS | 鉁� 鏀寔 |
+| CREATE INDEX IF NOT EXISTS | 鉁� 鏀寔锛圡ySQL 8.0+锛� |
+| ALTER TABLE ADD COLUMN IF NOT EXISTS | 鉂� 涓嶆敮鎸� |
+| ALTER TABLE ADD INDEX IF NOT EXISTS | 鉁� 鏀寔锛圡ySQL 8.0+锛� |
+| ALTER TABLE ADD CONSTRAINT IF NOT EXISTS | 鉂� 涓嶆敮鎸� |
\ No newline at end of file
diff --git a/docs/sql/README.md b/docs/sql/README.md
new file mode 100644
index 0000000..51895b5
--- /dev/null
+++ b/docs/sql/README.md
@@ -0,0 +1,5 @@
+# SQL 鑴氭湰绱㈠紩
+
+鏈」鐩寘鍚殑 SQL 鑴氭湰姹囨�诲涓嬶細
+
+- [mes_pro_task_assignee.sql](mes_pro_task_assignee.sql): 澧炲姞鐢熶骇浠诲姟鎶ュ伐浜哄憳鍏宠仈琛紝鐢ㄤ簬澶氫汉鍛樻姤宸ュ垎閰嶃��
diff --git a/docs/sql/mes_pro_task_assignee.sql b/docs/sql/mes_pro_task_assignee.sql
new file mode 100644
index 0000000..389cb16
--- /dev/null
+++ b/docs/sql/mes_pro_task_assignee.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `mes_pro_task_assignee` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `task_id` bigint(20) NOT NULL COMMENT '鐢熶骇浠诲姟 ID',
+ `user_id` bigint(20) NOT NULL COMMENT '绯荤粺鐢ㄦ埛 ID (鎸囧畾鎶ュ伐浜哄憳)',
+ `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(20) NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
+ PRIMARY KEY (`id`),
+ KEY `idx_task_id` (`task_id`),
+ KEY `idx_user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鐢熶骇浠诲姟鎸囧畾鎶ュ伐浜哄憳琛�';
diff --git a/sql/mysql/mes_pro_task_assignee.sql b/sql/mysql/mes_pro_task_assignee.sql
new file mode 100644
index 0000000..389cb16
--- /dev/null
+++ b/sql/mysql/mes_pro_task_assignee.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `mes_pro_task_assignee` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+ `task_id` bigint(20) NOT NULL COMMENT '鐢熶骇浠诲姟 ID',
+ `user_id` bigint(20) NOT NULL COMMENT '绯荤粺鐢ㄦ埛 ID (鎸囧畾鎶ュ伐浜哄憳)',
+ `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(20) NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
+ PRIMARY KEY (`id`),
+ KEY `idx_task_id` (`task_id`),
+ KEY `idx_user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鐢熶骇浠诲姟鎸囧畾鎶ュ伐浜哄憳琛�';
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/MesProTaskController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/MesProTaskController.java
index ff141d7..fa8ef57 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/MesProTaskController.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/MesProTaskController.java
@@ -349,6 +349,15 @@
inTransitMap.merge(fb.getTaskId(), fbQty, BigDecimal::add);
}
}
+
+ // 鏌ヨ鎸囨淳鎶ュ伐浜哄憳
+ Set<Long> taskIds = convertSet(list, MesProTaskDO::getId);
+ Map<Long, List<cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO>> assigneeMap = taskService.getTaskAssigneeMap(taskIds);
+ Set<Long> allAssigneeUserIds = new HashSet<>();
+ assigneeMap.values().forEach(assignees ->
+ assignees.forEach(assignee -> allAssigneeUserIds.add(assignee.getUserId())));
+ Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(allAssigneeUserIds);
+
// 鎷兼帴 VO
return convertList(list, task -> {
MesProTaskRespVO vo = BeanUtils.toBean(task, MesProTaskRespVO.class);
@@ -379,6 +388,22 @@
findAndThen(processCheckMap, task.getProcessId(), vo::setCheckFlag));
findAndThen(routeProcessBackflushFlagMap, task.getRouteId(), processBackflushMap ->
findAndThen(processBackflushMap, task.getProcessId(), vo::setBackflushFlag));
+
+ // 璁剧疆鎸囨淳鎶ュ伐浜哄憳
+ List<cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO> assignees = assigneeMap.get(task.getId());
+ if (CollUtil.isNotEmpty(assignees)) {
+ List<Long> assigneeUserIds = convertList(assignees, cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO::getUserId);
+ vo.setAssigneeUserIds(assigneeUserIds);
+ List<String> assigneeUserNames = new ArrayList<>();
+ for (Long userId : assigneeUserIds) {
+ AdminUserRespDTO user = userMap.get(userId);
+ if (user != null && user.getNickname() != null) {
+ assigneeUserNames.add(user.getNickname());
+ }
+ }
+ vo.setAssigneeUserNames(String.join(",", assigneeUserNames));
+ }
+
return vo;
});
}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskRespVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskRespVO.java
index f4c0dd1..8b1e52f 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskRespVO.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskRespVO.java
@@ -134,4 +134,10 @@
@Schema(description = "鍋滃伐鍘嗗彶璁板綍")
private List<MesProTaskPauseRecordRespVO> pauseRecords;
+ @Schema(description = "鎸囧畾鎶ュ伐浜哄憳 ID 闆嗗悎")
+ private List<Long> assigneeUserIds;
+
+ @Schema(description = "鎸囧畾鎶ュ伐浜哄憳濮撳悕闆嗗悎")
+ private List<String> assigneeUserNames;
+
}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskSaveReqVO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskSaveReqVO.java
index db9f5e2..82cdb6b 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskSaveReqVO.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/task/vo/MesProTaskSaveReqVO.java
@@ -51,4 +51,7 @@
@Schema(description = "澶囨敞", example = "澶囨敞")
private String remark;
+ @Schema(description = "鎸囧畾鎶ュ伐浜哄憳 ID 闆嗗悎")
+ private java.util.List<Long> assigneeUserIds;
+
}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pro/task/MesProTaskAssigneeDO.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pro/task/MesProTaskAssigneeDO.java
new file mode 100644
index 0000000..47d357e
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/dataobject/pro/task/MesProTaskAssigneeDO.java
@@ -0,0 +1,40 @@
+package cn.iocoder.yudao.module.mes.dal.dataobject.pro.task;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.*;
+
+/**
+ * 鐢熶骇浠诲姟鎸囧畾鎶ュ伐浜哄憳琛� DO
+ *
+ * @author 鑷姩鐢熸垚
+ */
+@TableName("mes_pro_task_assignee")
+@KeySequence("mes_pro_task_assignee_seq")
+@Data
+@EqualsAndHashCode(callSuper = true)
+@ToString(callSuper = true)
+@Builder
+@NoArgsConstructor
+@AllArgsConstructor
+public class MesProTaskAssigneeDO extends BaseDO {
+
+ /**
+ * 缂栧彿
+ */
+ @TableId
+ private Long id;
+ /**
+ * 鐢熶骇浠诲姟 ID
+ *
+ * 鍏宠仈 {@link MesProTaskDO#getId()}
+ */
+ private Long taskId;
+ /**
+ * 绯荤粺鐢ㄦ埛 ID (鎸囧畾鎶ュ伐浜哄憳)
+ */
+ private Long userId;
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/task/MesProTaskAssigneeMapper.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/task/MesProTaskAssigneeMapper.java
new file mode 100644
index 0000000..2631cef
--- /dev/null
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/dal/mysql/pro/task/MesProTaskAssigneeMapper.java
@@ -0,0 +1,38 @@
+package cn.iocoder.yudao.module.mes.dal.mysql.pro.task;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.Collection;
+import java.util.List;
+
+/**
+ * 鐢熶骇浠诲姟鎸囧畾鎶ュ伐浜哄憳 Mapper
+ *
+ * @author 鑷姩鐢熸垚
+ */
+@Mapper
+public interface MesProTaskAssigneeMapper extends BaseMapperX<MesProTaskAssigneeDO> {
+
+ default List<MesProTaskAssigneeDO> selectListByTaskId(Long taskId) {
+ return selectList(MesProTaskAssigneeDO::getTaskId, taskId);
+ }
+
+ default List<MesProTaskAssigneeDO> selectListByTaskIds(Collection<Long> taskIds) {
+ return selectList(new LambdaQueryWrapperX<MesProTaskAssigneeDO>()
+ .inIfPresent(MesProTaskAssigneeDO::getTaskId, taskIds));
+ }
+
+ default void deleteByTaskId(Long taskId) {
+ delete(MesProTaskAssigneeDO::getTaskId, taskId);
+ }
+
+ default void deleteByTaskIdAndUserIds(Long taskId, Collection<Long> userIds) {
+ delete(new LambdaQueryWrapperX<MesProTaskAssigneeDO>()
+ .eq(MesProTaskAssigneeDO::getTaskId, taskId)
+ .in(MesProTaskAssigneeDO::getUserId, userIds));
+ }
+
+}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskService.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskService.java
index d98de42..c2e0d11 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskService.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskService.java
@@ -176,4 +176,23 @@
*/
void resumeTask(cn.iocoder.yudao.module.mes.controller.admin.pro.task.vo.MesProTaskResumeReqVO resumeReqVO);
+ /**
+ * 鑾峰彇鐢熶骇浠诲姟鐨勬寚瀹氭姤宸ヤ汉鍛樺垪琛紝鎸変换鍔$紪鍙峰垎缁�
+ *
+ * @param taskIds 浠诲姟缂栧彿闆嗗悎
+ * @return 浠诲姟鍏宠仈鐨勪汉鍛樺垪琛� Map
+ */
+ default Map<Long, List<cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO>> getTaskAssigneeMap(Collection<Long> taskIds) {
+ if (cn.hutool.core.collection.CollUtil.isEmpty(taskIds)) {
+ return java.util.Collections.emptyMap();
+ }
+ return cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertMultiMap(
+ getTaskAssigneeListByTaskIds(taskIds), cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO::getTaskId);
+ }
+
+ /**
+ * 鏍规嵁浠诲姟缂栧彿闆嗗悎鑾峰彇鍏宠仈浜哄憳鍒楄〃
+ */
+ List<cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO> getTaskAssigneeListByTaskIds(Collection<Long> taskIds);
+
}
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskServiceImpl.java
index d6ebc52..d13aa2c 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskServiceImpl.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/pro/task/MesProTaskServiceImpl.java
@@ -58,6 +58,8 @@
import cn.iocoder.yudao.framework.common.util.object.ObjectUtils;
import cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskPauseRecordDO;
import cn.iocoder.yudao.module.mes.dal.mysql.pro.task.MesProTaskPauseRecordMapper;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskAssigneeDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pro.task.MesProTaskAssigneeMapper;
import cn.iocoder.yudao.module.mes.controller.admin.pro.task.vo.MesProTaskPauseReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.pro.task.vo.MesProTaskResumeReqVO;
@@ -78,6 +80,9 @@
@Resource
private MesProTaskPauseRecordMapper taskPauseRecordMapper;
+
+ @Resource
+ private MesProTaskAssigneeMapper taskAssigneeMapper;
@Resource
@Lazy
@@ -141,6 +146,10 @@
}
// 2.2 鎻掑叆
taskMapper.insert(task);
+
+ // 2.3 淇濆瓨鎸囧畾鎶ュ伐浜哄憳
+ updateTaskAssignees(task.getId(), createReqVO.getAssigneeUserIds());
+
return task.getId();
}
@@ -173,6 +182,34 @@
MesProTaskDO updateObj = BeanUtils.toBean(updateReqVO, MesProTaskDO.class)
.setName(buildTaskName(item, quantity));
taskMapper.updateById(updateObj);
+
+ // 3. 鏇存柊鎸囧畾鎶ュ伐浜哄憳锛堟瘮瀵规洿鏂帮級
+ updateTaskAssignees(task.getId(), updateReqVO.getAssigneeUserIds());
+ }
+
+ private void updateTaskAssignees(Long taskId, List<Long> assigneeUserIds) {
+ if (assigneeUserIds == null) {
+ assigneeUserIds = Collections.emptyList();
+ }
+ // 1. 鏌ヨ鏁版嵁搴撲腑鍘熸湁鐨�
+ List<MesProTaskAssigneeDO> oldAssignees = taskAssigneeMapper.selectListByTaskId(taskId);
+ Set<Long> oldUserIds = convertSet(oldAssignees, MesProTaskAssigneeDO::getUserId);
+ Set<Long> newUserIds = new java.util.HashSet<>(assigneeUserIds);
+
+ // 2. 璁$畻闇�瑕佹柊澧炵殑鍜岄渶瑕佸垹闄ょ殑
+ Set<Long> toAddUserIds = newUserIds.stream().filter(id -> !oldUserIds.contains(id)).collect(java.util.stream.Collectors.toSet());
+ Set<Long> toRemoveUserIds = oldUserIds.stream().filter(id -> !newUserIds.contains(id)).collect(java.util.stream.Collectors.toSet());
+
+ // 3. 鏂板
+ if (CollUtil.isNotEmpty(toAddUserIds)) {
+ List<MesProTaskAssigneeDO> addList = convertList(toAddUserIds, userId -> new MesProTaskAssigneeDO().setTaskId(taskId).setUserId(userId));
+ taskAssigneeMapper.insertBatch(addList);
+ }
+
+ // 4. 鍒犻櫎
+ if (CollUtil.isNotEmpty(toRemoveUserIds)) {
+ taskAssigneeMapper.deleteByTaskIdAndUserIds(taskId, toRemoveUserIds);
+ }
}
/**
@@ -245,8 +282,10 @@
if (feedbackMapper.selectCountByTaskId(id) > 0) {
throw exception(PRO_TASK_HAS_FEEDBACK);
}
- // 3. 鍒犻櫎
+ // 3. 鍒犻櫎浠诲姟涓昏〃
taskMapper.deleteById(id);
+ // 4. 鍒犻櫎鍏宠仈鐨勪汉鍛�
+ taskAssigneeMapper.deleteByTaskId(id);
}
@Override
@@ -273,6 +312,14 @@
}
@Override
+ public List<MesProTaskAssigneeDO> getTaskAssigneeListByTaskIds(Collection<Long> taskIds) {
+ if (CollUtil.isEmpty(taskIds)) {
+ return Collections.emptyList();
+ }
+ return taskAssigneeMapper.selectListByTaskIds(taskIds);
+ }
+
+ @Override
public MesProTaskDO validateTaskExists(Long id) {
MesProTaskDO task = taskMapper.selectById(id);
if (task == null) {
--
Gitblit v1.9.3