From de0202274ed147e89fdbba0a953936a3b9997ec7 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期二, 22 九月 2026 17:37:50 +0800 Subject: [PATCH] feat(mes): 更新IPQC过程检验功能 --- docs/sql/config_export_all_20260918.sql | 69 ++++++++++++++++++++++++++++++++-- 1 files changed, 65 insertions(+), 4 deletions(-) diff --git a/docs/sql/config_export_all_20260918.sql b/docs/sql/config_export_all_20260918.sql index f948f41..fe459fb 100644 --- a/docs/sql/config_export_all_20260918.sql +++ b/docs/sql/config_export_all_20260918.sql @@ -22,9 +22,73 @@ -- ruoyi-vue-pro.system_menu WHERE deleted=b'0'`锛屾槸鎵ц鏈熻法搴撳叏閲忔嫹璐濓紝 -- 鍙婧愬簱 ruoyi-vue-pro 鏈夎繖鍑犺灏变細琚甫杩囧幓 鈥斺�� 涓庨樁娈典竴鐨勫瓧闈㈤噺 INSERT 涓嶅悓銆� -- 鍦ㄦ鐧昏鍙负璇存槑銆岃繖鐗堟枃浠剁‘瀹炶鐩栦簡璇ュ彉鏇淬�嶏紝閬垮厤鍚庢潵鑰呬互涓烘紡浜嗐�� +-- 鈶� 琛� 116 涓寜閽潈闄� + 鍒� 1 涓け鏁堣彍鍗曪紙2026-09-22锛屽墠鍚庣鑿滃崟/鏉冮檺瀵归綈锛夛細 +-- 116 涓寜閽潈闄愭槸銆屽悗绔� @PreAuthorize 娉ㄨВ閲屾湁銆乻ystem_menu 閲屾病鏈夈�嶇殑宸泦 +-- 锛圓 绫� 19 涓細鍓嶅悗绔兘鍦ㄧ敤鑰屽簱缂哄け锛屽睘鐪熺己锛汢 绫� 97 涓細浠呭悗绔畾涔夛級锛� +-- 鎸夈�屾ā鍧�:瀹炰綋銆嶅墠缂�鍒嗗埆鎸傚埌瀵瑰簲 type=2 鐨勮彍鍗曚笅锛堝 erp:supplier:* 鈫� 602525 渚涘簲鍟嗘。妗堬級銆� +-- 鍚屾椂杞垹 1063009 浠撳簱鍧愭爣閰嶇疆鍙婂叾 2 涓寜閽� 1063091/1063092 鈥斺�� +-- 璇ヨ彍鍗� component 鎸囧悜 bi/config/warehouse-coordinate/index锛屽墠绔苟鏃犳椤甸潰锛堝巻鍙叉畫鐣欙級锛� +-- 骞剁墿鐞嗘竻鎺夎繖 3 涓彍鍗曠殑 9 鏉� system_role_menu 瀛ゅ効鎺堟潈銆� +-- **鏈枃浠跺悓鏍锋棤闇�涓烘鏀瑰姩**锛氶樁娈碘憽 璺ㄥ簱鍏ㄩ噺鎷疯礉 system_menu(deleted=b'0') 涓� +-- system_role_menu锛屾簮搴� ruoyi-vue-pro 宸插啓鍏ワ紝鎵ц鏈熻嚜浼氬甫杩囧幓銆傜悊鐢卞悓 鈶ゃ�� +-- 鈶� 钖叕鎸夐挳鏉冮檺鐮佹敼鍚嶅榻� + 鍒犻櫎銆孍RP 绯荤粺銆嶆暣涓彍鍗曪紙2026-09-22锛夛細 +-- 鈶� 鍓嶇 hrm/salary/calculation/index.vue銆乸ayment/index.vue 鍘熷厛鐢� +-- hrm:salary-calculation:* / hrm:salary-payment:*锛岃�屽悗绔� +-- HrmSalaryCalculationController / HrmSalaryPaymentController 鐢ㄧ殑鏄� hrm:salary:*锛� +-- 涓よ竟瀵逛笉涓婏紙鎸夐挳瑕佷箞鍘嬫牴涓嶆樉绀猴紝瑕佷箞鏄剧ず浜嗚鍚庣 403锛夈�傚凡鏀瑰墠绔榻愬悗绔紝 +-- 骞惰蒋鍒犲簱涓� 5 鏉℃棫鐮佹寜閽紙60212/60213/60214/60244/60245锛夊強鍏� 15 鏉� role_menu銆� +-- 娉細鏃ф寜閽師鏈寕鍦ㄣ�岃秴绾х鐞嗗憳/楂樺眰绠＄悊/閿�鍞汉鍛樸��3 涓鑹蹭笂锛堥攢鍞汉鍛樻寔鏈夎柂璧勫彂鏀炬潈闄愶紝 +-- 鐤戜负瑙掕壊椤靛叏閫夎鎺堬級锛屽垹闄ゅ悗鏈縼绉绘巿鏉冿紝鏂版寜閽� hrm:salary:* 鐩墠鏃犱换浣曡鑹叉巿鏉冿紝 +-- 闇�鍦ㄨ鑹茬鐞嗛〉鎸夊疄闄呭矖浣嶉噸鏂板嬀閫夈�� +-- 鈶� 杞垹銆孍RP 绯荤粺銆�(id=2563, path=/erp) 鏁存５瀛愭爲鍏� 83 涓妭鐐� 鈥斺�� +-- 浜у搧绠＄悊 17 + 搴撳瓨绠＄悊 43 + 璐㈠姟绠＄悊 20 + ERP棣栭〉 1 + 鐩綍鑺傜偣 2锛� +-- 骞剁墿鐞嗘竻鎺夊叾 83 鏉� system_role_menu锛堣瀛愭爲浠呰秴绾х鐞嗗憳涓�涓鑹叉寕鏈夋巿鏉冿級銆� +-- 鍏朵腑浜у搧绠＄悊 / 搴撳瓨绠＄悊鍦ㄥ悗绔� yudao-module-erp 宸叉棤浠讳綍鎺у埗鍣� +-- 锛坋rp:product* / erp:warehouse* / erp:stock* 鍏ㄩ儴涓嶅瓨鍦級锛屽睘鍘嗗彶娈嬬暀锛� +-- 璐㈠姟绠＄悊锛堢粨绠楄处鎴�/浠樻鍗�/鏀舵鍗曪級鍚庣鎺у埗鍣ㄤ粛鍦紝鍒犲悗杩欎袱涓〉闈㈠け鍘昏彍鍗曞叆鍙� +-- 锛堜粯娆惧崟鍦ㄣ�岄噰璐鐞嗐�嶄笅鍙︽湁閲嶅鍏ュ彛 1063116锛夈�傘�岄噰璐鐞嗐��(2602)銆� +-- 銆岃惀閿�绠＄悊銆�(2617) 涓や釜鏍圭洰褰曟湭鍔紝鍏朵腑鐨� ERP 椤甸潰鐓у父淇濈暀銆� +-- 鈿� 杩欐槸**宸茬煡涓斿凡纭鎺ュ彈鐨勪唬浠�**锛氬垹闄ゅ悗 13 涓粛鍦ㄤ娇鐢ㄧ殑鏉冮檺鐮佸け鍘� system_menu 杞戒綋 鈥斺�� +-- erp:account:create/update/delete/export锛圓 绫伙細鍓嶅悗绔兘鍦ㄧ敤锛夈�� +-- erp:finance-receipt:create/update/delete/export/query/update-status锛圓 绫伙級銆� +-- erp:account:query銆乪rp:statistics:query锛圔 绫伙細浠呭悗绔� @PreAuthorize锛夈�� +-- 鍗崇粨绠楄处鎴枫�佹敹娆惧崟涓ら〉鍦ㄥ簱涓凡鏃犳潈闄愯锛屾墍鏈夎鑹叉寜閽叏闅愯棌涓斿悗绔繑鍥� 403锛� +-- 鏃ュ悗鑻ヨ鎭㈠杩欎袱涓〉闈紝闇�閲嶅缓鑿滃崟骞惰ˉ鍥炰笂杩� 13 涓潈闄愮爜銆� +-- **鏈枃浠跺悓鏍锋棤闇�涓烘鏀瑰姩**锛岀悊鐢卞悓 鈶も懃銆� +-- 鈶� 杩囩▼妫�楠屽崟 mes_qc_ipqc 瀛楁璋冩暣锛�2026-09-22锛孖PQC 鍘荤敓浜т俊鎭� + 鎵瑰彿蹇呭～锛夛細 +-- 鍒� work_order_id / task_id / workstation_id / process_id 鍥涘垪锛� +-- 鍦� source_doc_code 涔嬪悗鏂板 batch_code varchar(100) COMMENT '鎵瑰彿'銆� +-- 鍚屾鏀逛簡鏈湴 H2 鍗曟祴寤鸿〃鑴氭湰 create_tables.sql锛堝惁鍒� MesQcIpqcServiceImplTest 鍏ㄦ寕锛夈�� +-- **鏈枃浠跺繀椤绘敼**锛氶樁娈典竴鏄叏搴� CREATE TABLE 瀛楅潰閲忓鍑猴紝涓嶉噸瀵煎嚭灏变細寤哄嚭鏃х粨鏋勩�� +-- 婧愬簱 ruoyi-vue-pro 宸叉墽琛屽悓鏍风殑 DDL锛岀粨鏋勪互鏈枃浠朵负鍑嗐�� +-- 鈶� 琛� 18 涓寜閽潈闄愶紙2026-09-22锛孋2 绫伙細銆屽墠绔湪鐢ㄣ�佸悗绔� @PreAuthorize 鏈畾涔夈�佸簱涓害鏃犮�嶏級锛� +-- 1075533~1075550锛屽垎鍒负銆屾ā鏉垮鍑恒��(system:notify-template:export 鈫� 2145)銆� +-- 銆岀鑱屼氦鎺ャ��(hrm:resignation:handover 鈫� 6005)銆併�屾潅椤瑰叆搴撳崟銆�6 涓姩浣� +-- (mes:wm-misc-receipt:create/update/delete/export/cancel/finish 鈫� 5888)銆� +-- 銆屽浘绾稿鏍搞��1 涓�併�岃璁′换鍔°��5 涓�併�岀増鏈彉鏇淬��4 涓姩浣� (mes:pd-* 鈫� 602572)銆� +-- 琛ュ綍鏃� C2 鍏� 93 涓紙鍒犮�孍RP 绯荤粺銆嶅悗鐢� 54 娑ㄤ笂鏉ワ級锛屽叾涓粎杩� 18 涓兘瀹氫綅鍒� type=2 鐖惰彍鍗曪紱 +-- 宸插叏閮ㄨ惤搴撳苟閫愪釜澶嶆牳銆岀埗鑿滃崟 type=2銆乻tatus=0銆嶉�氳繃銆� +-- 鍓╀綑 75 涓�**鍒绘剰鏈ˉ**锛屽垎涓夌被锛� +-- 鈶� 67 涓� erp:*锛坧roduct / product-category / product-unit / warehouse / stock / +-- stock-in / stock-out / stock-move / stock-check / stock-record / purchase-in / +-- purchase-return / sale-out / sale-return锛夆�斺�� 瀵瑰簲椤甸潰**鍙湁鍓嶇銆佹病鏈夊悗绔�**锛� +-- yudao-module-erp 鏃犱换浣曡繖浜涙帶鍒跺櫒锛屽叏浠� grep 涔熸棤瀵瑰簲 @PreAuthorize銆� +-- 鍏朵腑 42 涓殑鐖惰彍鍗曪紙浜у搧绠＄悊/搴撳瓨绠＄悊瀛愭爲锛夊凡闅� 鈶� 涓�骞跺垹闄わ紝鍙� 25 涓� +-- 锛堥噰璐叆搴�/閲囪喘閫�璐�/閿�鍞嚭搴�/閿�鍞��璐э級鑷缓搴撹捣灏辨病鏈夎彍鍗曘�傚睘鍘嗗彶娈嬬暀锛屾寜鏃㈠畾鍙ｅ緞璺宠繃銆� +-- 鈶� 7 涓� crm:product:* / crm:product-category:* 鈥斺�� 涓诲伐浣滃尯 yudao-module-crm 涓嬪苟鏃� +-- CrmProductController / CrmProductCategoryController锛屽彧瀛樺湪浜庝袱涓苟琛� agent 鐨� +-- worktree 鍓湰閲岋紙灏氭湭鍚堝苟锛夛紱涓斿嵆渚垮悎骞朵篃缂恒�屽晢鍝併�嶈彍鍗曪紝鍗曡ˉ鎸夐挳鏃犳剰涔夛紝鐣欑粰璇ュ垎鏀嚜宸辫ˉ銆� +-- 鈶� 1 涓� mes:wm-approval:save 鈥斺�� 鍓嶇 views/wls/approval/config/index.vue 鐨�**鐮佸啓閿欎簡**锛� +-- 鍚庣 /mes/wms/approval/config/save 瀹為檯瑕佹眰 mes:wm-warehouse:update锛堝簱涓凡鏈夛紝id=5784锛夛紝 +-- 涓� 鈶︹憼 鐨勮柂閰紓绉诲悓绫婚棶棰樸�傛纭慨娉曟槸鏀瑰墠绔繖涓�琛岋紝鍥犳湭鑾锋巿鏉冩敼鍓嶇鏁呮湭鍔ㄣ�� +-- 锛堝彟锛氳椤垫墍鎸傜殑鐖剁洰褰� 6002銆屼汉浜嬪鎵广�嶆槸涓病鏈夊瓙鑿滃崟鐨勭┖ type=1锛屾湰灏辨病鏈夎彍鍗曟寕鍒拌椤甸潰锛� +-- **鏈枃浠跺悓鏍锋棤闇�涓烘鏀瑰姩**锛岀悊鐢卞悓 鈶も懃銆� -- 楠岃瘉锛氭湰鏂囦欢宸插湪鍏ㄦ柊绌哄簱锛圡ySQL 8.4.6锛夋暣浠芥墽琛岄�氳繃 鈥斺�� 419 寮犺〃銆�6 寮� qc_report_*銆� -- 6 涓瓧鍏哥被鍨� + 21 鏉″瓧鍏告暟鎹�乤dmin 璐﹀彿 / 1258 鏉¤彍鍗� / 2349 鏉� role_menu / -- 榛樿 OAuth2 瀹㈡埛绔潎姝ｇ‘钀藉簱銆� +-- 2026-09-22 涓婅堪鍙樻洿鍏ㄩ儴钀藉湴鍚庯紝婧愬簱 ruoyi-vue-pro 鐜版湁鏈夋晥鑿滃崟 1308 鏉★紙鍏朵腑鎸夐挳 1021 鏉★級銆� +-- 闃舵鈶� 灏嗘嫹璐濈殑 system_role_menu 1708 鏉★紙= admin 鍚嶄笅銆岃秴绾х鐞嗗憳銆�852 + 銆屾櫘閫氳鑹层��856锛� +-- 璇ユ瀛愭煡璇笉甯� deleted 杩囨护锛屽疄娴嬭繖涓よ鑹蹭笅鏃犺蒋鍒犺锛屾晠 1708 鍗虫渶缁堣鏁帮級锛屾墽琛屾椂搴斾笌姝や竴鑷淬�� -- 鑼冨洿锛氬叏搴� BASE TABLE 鍏� 419 寮狅紝鍏ㄩ儴杈撳嚭 CREATE TABLE锛� -- 浠呬互涓嬮厤缃被琛ㄥ甫鏁版嵁(INSERT)锛屽叾浣欎笟鍔�/绯荤粺/杩愯鍘嗗彶琛ㄥ彧淇濈暀绌鸿〃缁撴瀯锛� -- 鈶� 鍗忓悓瀹℃壒娴佺▼锛堝紩鎿庡厓鏁版嵁+瀹氫箟锛屼粎婵�娲绘祦绋嬶紝鍓斿巻鍙�/杩愯/韬唤锛夛細act_ge_property銆乤ct_id_property銆乤ct_re_procdef銆乤ct_re_deployment銆乤ct_ge_bytearray銆乤ct_re_model銆乥pm_process_definition_info @@ -8036,10 +8100,7 @@ `source_doc_id` bigint DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁缂栧彿', `source_line_id` bigint DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁琛岀紪鍙�', `source_doc_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鏉ユ簮鍗曟嵁缂栧彿', - `work_order_id` bigint DEFAULT NULL COMMENT '鐢熶骇宸ュ崟缂栧彿', - `task_id` bigint DEFAULT NULL COMMENT '鐢熶骇浠诲姟缂栧彿', - `workstation_id` bigint DEFAULT NULL COMMENT '宸ヤ綅缂栧彿', - `process_id` bigint DEFAULT NULL COMMENT '宸ュ簭缂栧彿', + `batch_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '鎵瑰彿', `item_id` bigint DEFAULT NULL COMMENT '浜у搧鐗╂枡缂栧彿', `check_quantity` decimal(24,6) DEFAULT NULL COMMENT '妫�娴嬫暟閲�', `qualified_quantity` decimal(24,6) DEFAULT NULL COMMENT '鍚堟牸鍝佹暟閲�', -- Gitblit v1.9.3