From de3907ce04d3bc5d196953a69995c377ef0cdb4b Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期四, 27 八月 2026 14:39:28 +0800
Subject: [PATCH] chore(erp): 数据库变更脚本不入库(手动执行)
---
/dev/null | 172 -------------------------------------------
.gitignore | 16 +++
2 files changed, 15 insertions(+), 173 deletions(-)
diff --git a/.gitignore b/.gitignore
index d2323d7..c521e6a 100644
--- a/.gitignore
+++ b/.gitignore
@@ -59,5 +59,19 @@
.claude/worktrees/
.claude/scheduled_tasks.json
+######################################################################
+# AI / Personal Docs锛堜釜浜哄伐浣滄枃妗o紝涓嶇撼鍏ョ増鏈帶鍒讹級
+/docs/
+/TODO.md
+/fix_quartz_and_issues.md
+
+# 绯荤粺 & 鏃ュ織
+.DS_Store
+Thumbs.db
+*.log
+*.md
+
graphify-out/
-.agents/
\ No newline at end of file
+.agents/
+# 鏁版嵁搴撳彉鏇磋剼鏈紙鎵嬪姩鎵ц锛屼笉鍏ュ簱锛�
+sql/sale_order_bpm_approval.sql
diff --git a/sql/sale_order_bpm_approval.sql b/sql/sale_order_bpm_approval.sql
deleted file mode 100644
index d266b7a..0000000
--- a/sql/sale_order_bpm_approval.sql
+++ /dev/null
@@ -1,172 +0,0 @@
--- ============================================================
--- 閿�鍞鍗曞鎵规帴鍏ュ崗鍚屽姙鍏�(BPM) - 鏁版嵁搴撳彉鏇磋剼鏈�
--- 璇存槑:
--- 1. 鍙噸澶嶆墽琛�(骞傜瓑),閲嶅鎵ц涓嶄細鎶ラ敊/閲嶅鎻掑叆
--- 2. 椤圭洰涓嶄娇鐢ㄥ绉熸埛,鑴氭湰涓嶅寘鍚� tenant_id
--- 3. 鏈剼鏈寘鍚� BPM 娴佺▼瀹氫箟(sale_order_approve)鐨勯儴缃�,鎵ц鍚庡嵆鍙娇鐢�
--- ============================================================
-
--- 1. erp_sale_order 琛� BPM 瀛楁(骞傜瓑:缂哄垪鎵嶅姞)
--- ------------------------------------------------------------
-SET @s1 = IF((SELECT COUNT(*) FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='erp_sale_order' AND column_name='process_instance_id')=0,
- 'ALTER TABLE erp_sale_order ADD COLUMN process_instance_id VARCHAR(64) NULL COMMENT ''BPM 娴佺▼瀹炰緥缂栧彿'' AFTER remark', 'SELECT 1');
-PREPARE s1 FROM @s1; EXECUTE s1; DEALLOCATE PREPARE s1;
-
--- ------------------------------------------------------------
--- 2. 鏂板 BPM 娴佺▼鍒嗙被:閿�鍞鍗曞鎵�
--- ------------------------------------------------------------
-INSERT INTO bpm_category (id, name, code, description, status, sort, creator, create_time, updater, update_time, deleted)
-SELECT (SELECT COALESCE(MAX(id), 0) + 1 FROM bpm_category), '閿�鍞鍗曞鎵�', 'sale_order_approve',
- '閿�鍞鍗曞鎵规祦绋嬪垎绫�', 0, 30, '1', NOW(), '1', NOW(), 0
-FROM DUAL
-WHERE NOT EXISTS (SELECT 1 FROM bpm_category WHERE code = 'sale_order_approve' AND deleted = 0);
-
--- ------------------------------------------------------------
--- 3. 淇/鏂板 erp_audit_status 瀛楀吀(涓� ErpAuditStatus 鏋氫妇淇濇寔涓�鑷�)
--- ------------------------------------------------------------
--- 3.1 鍊� 0 = 鏈彁浜�(閿�鍞鍗曞垱寤哄悗鍒濆鐘舵��;涓嶅瓨鍦ㄥ垯鏂板,瀛樺湪鍒欎慨姝f爣绛�)
-INSERT INTO system_dict_data (id, sort, label, value, dict_type, status, color_type, css_class, remark, creator, create_time, updater, update_time, deleted)
-SELECT (SELECT COALESCE(MAX(id), 0) + 1 FROM system_dict_data), 0, '鏈彁浜�', '0', 'erp_audit_status', 0, 'info', '',
- '閿�鍞鍗曠瓑鏈彁浜ゅ鎵�', '1', NOW(), '1', NOW(), 0
-FROM DUAL
-WHERE NOT EXISTS (SELECT 1 FROM system_dict_data WHERE dict_type = 'erp_audit_status' AND value = '0' AND deleted = 0);
-
--- 3.2 鑻ュ凡瀛樺湪浣嗘爣绛句笉鏄�屾湭鎻愪氦銆�,寮哄埗淇涓恒�屾湭鎻愪氦銆�
-UPDATE system_dict_data
-SET label = '鏈彁浜�', remark = '閿�鍞鍗曠瓑鏈彁浜ゅ鎵�', updater = '1', update_time = NOW()
-WHERE dict_type = 'erp_audit_status' AND value = '0' AND deleted = 0;
-
--- ------------------------------------------------------------
--- 4. bpm_business_attach 琛�:娴佺▼瀹氫箟 -> 涓氬姟璇︽儏缁勪欢鏄犲皠
--- 浣滅敤:鍗忓悓鍔炲叕瀹℃壒璇︽儏椤靛姞杞藉搴斾笟鍔$粍浠跺睍绀轰笟鍔″唴瀹�
--- 鑻ラ攢鍞鍗曡鎯呯粍浠惰矾寰勪笉鏄� /erp/sale/order/detail/index.vue,璇蜂慨鏀� component_path
--- ------------------------------------------------------------
-CREATE TABLE IF NOT EXISTS `bpm_business_attach` (
- `id` bigint NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
- `process_definition_key` varchar(64) NOT NULL DEFAULT '' COMMENT '娴佺▼瀹氫箟鐨凨ey',
- `business_type` varchar(64) NOT NULL DEFAULT '' COMMENT '涓氬姟绫诲瀷',
- `component_path` varchar(255) NOT NULL DEFAULT '' COMMENT '涓氬姟璇︽儏缁勪欢璺緞',
- `status` tinyint NOT NULL DEFAULT '0' COMMENT '鐘舵��',
- `remark` varchar(255) 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 '鏄惁鍒犻櫎',
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='BPM涓氬姟闄勪欢閰嶇疆';
-
--- 4.1 閿�鍞鍗曞鎵� -> 閿�鍞鍗曡鎯呯粍浠�(鍗忓悓鍔炲叕瀹℃壒椤垫樉绀鸿鍗曞唴瀹�)
-INSERT INTO bpm_business_attach (id, process_definition_key, business_type, component_path, status, remark, creator, create_time, updater, update_time, deleted)
-SELECT (SELECT COALESCE(MAX(id), 0) + 1 FROM bpm_business_attach), 'sale_order_approve', 'erp_sale_order',
- '/erp/sale/order/detail/index.vue', 0, '閿�鍞鍗曞鎵逛笟鍔¤鎯呯粍浠�', '1', NOW(), '1', NOW(), 0
-FROM DUAL
-WHERE NOT EXISTS (SELECT 1 FROM bpm_business_attach WHERE process_definition_key = 'sale_order_approve' AND deleted = 0);
-
--- ------------------------------------------------------------
--- 5. 鍘嗗彶鏁版嵁杩佺Щ:瀛橀噺銆屾湭瀹℃牳(10)銆嶉攢鍞鍗曡皟鏁翠负銆屾湭鎻愪氦(0)銆�
--- 鏂伴�昏緫涓垱寤哄悗鍗充负鏈彁浜�,10 涓嶅啀鐢ㄤ簬閿�鍞鍗�
--- ------------------------------------------------------------
-UPDATE erp_sale_order SET status = 0, updater = '1', update_time = NOW()
-WHERE status = 10 AND deleted = 0;
-
--- ============================================================
--- 6. BPM 娴佺▼瀹氫箟閮ㄧ讲: sale_order_approve(骞傜瓑,濡傚凡瀛樺湪鍒欒烦杩�)
--- ============================================================
-INSERT INTO ACT_RE_DEPLOYMENT (ID_, NAME_, CATEGORY_, KEY_, TENANT_ID_, DEPLOY_TIME_, DERIVED_FROM_, DERIVED_FROM_ROOT_, PARENT_DEPLOYMENT_ID_, ENGINE_VERSION_)
-SELECT '532b0fc9-a1cb-11f1-b320-00ff263cc5e4', '閿�鍞鍗曞鎵�', 'sale_order_approve', 'sale_order_approve', '', NOW(), NULL, NULL, '532b0fc9-a1cb-11f1-b320-00ff263cc5e4', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM ACT_RE_PROCDEF WHERE KEY_='sale_order_approve');
-INSERT INTO ACT_RE_PROCDEF (ID_, REV_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, DESCRIPTION_, HAS_START_FORM_KEY_, HAS_GRAPHICAL_NOTATION_, SUSPENSION_STATE_, TENANT_ID_, ENGINE_VERSION_)
-SELECT 'sale_order_approve:1:537fe68c-a1cb-11f1-b320-00ff263cc5e4', 1, 'sale_order_approve', '閿�鍞鍗曞鎵�', 'sale_order_approve', '1', '532b0fc9-a1cb-11f1-b320-00ff263cc5e4', 'sale_order_approve.bpmn', 'sale_order_approve.sale_order_approve.png', NULL, '0', '1', '1', '', NULL FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM ACT_RE_PROCDEF WHERE KEY_='sale_order_approve');
-INSERT INTO ACT_GE_BYTEARRAY (ID_, REV_, NAME_, DEPLOYMENT_ID_, BYTES_, GENERATED_)
-SELECT '532b0fca-a1cb-11f1-b320-00ff263cc5e4', 1, 'sale_order_approve.bpmn', '532b0fc9-a1cb-11f1-b320-00ff263cc5e4', '<?xml version="1.0" encoding="UTF-8"?>
-<definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:flowable="http://flowable.org/bpmn" xmlns:bpmndi="http://www.omg.org/spec/BPMN/20100524/DI" xmlns:omgdc="http://www.omg.org/spec/DD/20100524/DC" xmlns:omgdi="http://www.omg.org/spec/DD/20100524/DI" typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath" targetNamespace="http://www.omg.org/spec/BPMN/20100524/MODEL">
- <process id="sale_order_approve" name="閿�鍞鍗曞鎵�" isExecutable="true">
- <startEvent id="StartEvent" name="寮�濮�"></startEvent>
- <userTask id="StartUserNode" name="鍙戣捣浜�">
- <extensionElements>
- <flowable:approveType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[1]]></flowable:approveType>
- <flowable:candidateStrategy xmlns:flowable="http://flowable.org/bpmn"><![CDATA[36]]></flowable:candidateStrategy>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="鎻愪氦" enable="true" id="1"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="鎷掔粷" enable="false" id="2"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="杞姙" enable="false" id="3"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="濮旀淳" enable="false" id="4"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="鍔犵" enable="false" id="5"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="閫�鍥�" enable="false" id="6"></flowable:buttonsSetting>
- <flowable:assignStartUserHandlerType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[2]]></flowable:assignStartUserHandlerType>
- </extensionElements>
- </userTask>
- <userTask id="Activity_sale_order_approve" name="瀹℃壒浜�">
- <extensionElements>
- <flowable:approveType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[1]]></flowable:approveType>
- <flowable:candidateStrategy xmlns:flowable="http://flowable.org/bpmn"><![CDATA[30]]></flowable:candidateStrategy>
- <flowable:candidateParam xmlns:flowable="http://flowable.org/bpmn"><![CDATA[1]]></flowable:candidateParam>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="閫氳繃" enable="true" id="1"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="鎷掔粷" enable="true" id="2"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="杞姙" enable="true" id="3"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="濮旀淳" enable="true" id="4"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="鍔犵" enable="true" id="5"></flowable:buttonsSetting>
- <flowable:buttonsSetting xmlns:flowable="http://flowable.org/bpmn" displayName="閫�鍥�" enable="true" id="6"></flowable:buttonsSetting>
- <flowable:approveMethod xmlns:flowable="http://flowable.org/bpmn"><![CDATA[4]]></flowable:approveMethod>
- <flowable:rejectHandlerType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[1]]></flowable:rejectHandlerType>
- <flowable:assignStartUserHandlerType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[1]]></flowable:assignStartUserHandlerType>
- <flowable:assignEmptyHandlerType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[1]]></flowable:assignEmptyHandlerType>
- <flowable:signEnable xmlns:flowable="http://flowable.org/bpmn"><![CDATA[false]]></flowable:signEnable>
- <flowable:reasonRequire xmlns:flowable="http://flowable.org/bpmn"><![CDATA[false]]></flowable:reasonRequire>
- <flowable:nodeType xmlns:flowable="http://flowable.org/bpmn"><![CDATA[11]]></flowable:nodeType>
- </extensionElements>
- <multiInstanceLoopCharacteristics isSequential="true" flowable:collection="${coll_userList}">
- <loopCardinality>1</loopCardinality>
- <completionCondition>${ nrOfCompletedInstances >= nrOfInstances }</completionCondition>
- </multiInstanceLoopCharacteristics>
- </userTask>
- <endEvent id="EndEvent" name="缁撴潫"></endEvent>
- <sequenceFlow id="sequenceFlow-55e2f6d8-5af6-4ea5-924b-e6ad6eee3d5f" sourceRef="StartEvent" targetRef="StartUserNode"></sequenceFlow>
- <sequenceFlow id="sequenceFlow-37666882-17da-46ee-840f-7de7a2211060" sourceRef="StartUserNode" targetRef="Activity_sale_order_approve"></sequenceFlow>
- <sequenceFlow id="sequenceFlow-b0342e71-0163-43ce-83d4-955beba1eda4" sourceRef="Activity_sale_order_approve" targetRef="EndEvent"></sequenceFlow>
- </process>
- <bpmndi:BPMNDiagram id="BPMNDiagram_sale_order_approve">
- <bpmndi:BPMNPlane bpmnElement="sale_order_approve" id="BPMNPlane_sale_order_approve">
- <bpmndi:BPMNShape bpmnElement="StartUserNode" id="BPMNShape_StartUserNode">
- <omgdc:Bounds height="60.0" width="100.0" x="80.0" y="0.0"></omgdc:Bounds>
- </bpmndi:BPMNShape>
- <bpmndi:BPMNShape bpmnElement="Activity_sale_order_approve" id="BPMNShape_Activity_sale_order_approve">
- <omgdc:Bounds height="60.0" width="100.0" x="230.0" y="0.0"></omgdc:Bounds>
- </bpmndi:BPMNShape>
- <bpmndi:BPMNShape bpmnElement="StartEvent" id="BPMNShape_StartEvent">
- <omgdc:Bounds height="30.0" width="30.0" x="0.0" y="15.0"></omgdc:Bounds>
- </bpmndi:BPMNShape>
- <bpmndi:BPMNShape bpmnElement="EndEvent" id="BPMNShape_EndEvent">
- <omgdc:Bounds height="30.0" width="30.0" x="380.0" y="15.0"></omgdc:Bounds>
- </bpmndi:BPMNShape>
- <bpmndi:BPMNEdge bpmnElement="sequenceFlow-37666882-17da-46ee-840f-7de7a2211060" id="BPMNEdge_sequenceFlow-37666882-17da-46ee-840f-7de7a2211060">
- <omgdi:waypoint x="180.0" y="30.0"></omgdi:waypoint>
- <omgdi:waypoint x="230.0" y="30.0"></omgdi:waypoint>
- </bpmndi:BPMNEdge>
- <bpmndi:BPMNEdge bpmnElement="sequenceFlow-55e2f6d8-5af6-4ea5-924b-e6ad6eee3d5f" id="BPMNEdge_sequenceFlow-55e2f6d8-5af6-4ea5-924b-e6ad6eee3d5f">
- <omgdi:waypoint x="30.0" y="30.0"></omgdi:waypoint>
- <omgdi:waypoint x="80.0" y="30.0"></omgdi:waypoint>
- </bpmndi:BPMNEdge>
- <bpmndi:BPMNEdge bpmnElement="sequenceFlow-b0342e71-0163-43ce-83d4-955beba1eda4" id="BPMNEdge_sequenceFlow-b0342e71-0163-43ce-83d4-955beba1eda4">
- <omgdi:waypoint x="330.0" y="30.0"></omgdi:waypoint>
- <omgdi:waypoint x="380.0" y="30.0"></omgdi:waypoint>
- </bpmndi:BPMNEdge>
- </bpmndi:BPMNPlane>
- </bpmndi:BPMNDiagram>
-</definitions>', 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM ACT_GE_BYTEARRAY WHERE NAME_='sale_order_approve.bpmn');
-INSERT INTO ACT_RE_MODEL (ID_, REV_, NAME_, KEY_, CATEGORY_, CREATE_TIME_, LAST_UPDATE_TIME_, VERSION_, META_INFO_, DEPLOYMENT_ID_, TENANT_ID_)
-SELECT '52b96236-a1cb-11f1-b320-00ff263cc5e4', 1, '閿�鍞鍗曞鎵�', 'sale_order_approve', 'sale_order_approve', NOW(), NOW(), '1', '{"allowCancelRunningProcess":true,"allowWithdrawTask":true,"autoApprovalType":null,"description":"閿�鍞鍗曟彁浜ゅ悗杩涘叆鍗忓悓鍔炲叕瀹℃壒","formCustomCreatePath":null,"formCustomViewPath":null,"formId":1,"formType":10,"icon":null,"managerUserIds":[1],"printTemplateSetting":null,"processAfterTriggerSetting":null,"processBeforeTriggerSetting":null,"processIdRule":null,"sort":1787584300000,"startDeptIds":null,"startUserIds":null,"summarySetting":null,"taskAfterTriggerSetting":null,"taskBeforeTriggerSetting":null,"titleSetting":null,"type":20,"visible":true}', '532b0fc9-a1cb-11f1-b320-00ff263cc5e4', '' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM ACT_RE_MODEL WHERE KEY_='sale_order_approve');
-INSERT INTO bpm_process_definition_info (process_definition_id, model_id, model_type, category, icon, description, form_type, form_id, form_conf, form_fields, form_custom_create_path, form_custom_view_path, simple_model, visible, sort, start_user_ids, start_dept_ids, manager_user_ids, allow_cancel_running_process, allow_withdraw_task, auto_approval_type, creator, create_time, updater, update_time, deleted)
-SELECT 'sale_order_approve:1:537fe68c-a1cb-11f1-b320-00ff263cc5e4', '52b96236-a1cb-11f1-b320-00ff263cc5e4', '20', 'sale_order_approve', NULL, '閿�鍞鍗曟彁浜ゅ悗杩涘叆鍗忓悓鍔炲叕瀹℃壒', '10', '1', '{"form":{"layout":"horizontal","labelAlign":"right","size":"middle","colon":false,"labelCol":{"style":{"width":"125px"}},"wrapperCol":{"span":24},"labelWidth":"100px"},"resetBtn":{"show":false,"innerText":"閲嶇疆"},"submitBtn":{"show":true,"innerText":"鎻愪氦"}}', '["{\\"type\\":\\"input\\",\\"field\\":\\"Fyqymqqdoln2abc\\",\\"title\\":\\"濮撳悕\\",\\"info\\":\\"\\",\\"$required\\":false,\\"_fc_id\\":\\"id_Fuplmqqdoln2acc\\",\\"name\\":\\"ref_F18omqqdoln2adc\\",\\"_fc_drag_tag\\":\\"input\\",\\"display\\":true,\\"hidden\\":false}", "{\\"type\\":\\"input\\",\\"field\\":\\"Fh6gmqqdooy5aec\\",\\"title\\":\\"骞撮緞\\",\\"info\\":\\"\\",\\"$required\\":false,\\"_fc_id\\":\\"id_F5whmqqdooy5afc\\",\\"name\\":\\"ref_Fltemqqdooy5agc\\",\\"_fc_drag_tag\\":\\"input\\",\\"display\\":true,\\"hidden\\":false}", "{\\"type\\":\\"select\\",\\"field\\":\\"F5mrmqqdutnnabc\\",\\"title\\":\\"閫夋嫨鍣╘\",\\"info\\":\\"\\",\\"effect\\":{\\"fetch\\":\\"\\"},\\"$required\\":false,\\"options\\":[{\\"label\\":\\"閫夐」01\\",\\"value\\":\\"1\\"},{\\"label\\":\\"閫夐」02\\",\\"value\\":\\"2\\"},{\\"label\\":\\"閫夐」03\\",\\"value\\":\\"3\\"}],\\"_fc_id\\":\\"id_Fhnumqqdutnoacc\\",\\"name\\":\\"ref_Fd1wmqqdutnoadc\\",\\"_fc_drag_tag\\":\\"select\\",\\"display\\":true,\\"hidden\\":false}", "{\\"type\\":\\"ApiSelect\\",\\"field\\":\\"dc4b501620bb4c8184aaaeb66398324a\\",\\"title\\":\\"鎺ュ彛閫夋嫨鍣╘\",\\"info\\":\\"\\",\\"$required\\":false,\\"props\\":{\\"method\\":\\"GET\\"},\\"_fc_id\\":\\"id_F6ewmrbn96xdc3c\\",\\"name\\":\\"ref_F1jomrbn96xdc4c\\",\\"display\\":true,\\"hidden\\":false,\\"_fc_drag_tag\\":\\"ApiSelect\\"}"]', NULL, NULL, '{"buttonsSetting":[{"displayName":"鎻愪氦","enable":true,"id":1},{"displayName":"鎷掔粷","enable":false,"id":2},{"displayName":"杞姙","enable":false,"id":3},{"displayName":"濮旀淳","enable":false,"id":4},{"displayName":"鍔犵","enable":false,"id":5},{"displayName":"閫�鍥�","enable":false,"id":6}],"childNode":{"approveMethod":4,"approveType":1,"assignEmptyHandler":{"type":1,"userIds":null},"assignStartUserHandlerType":1,"buttonsSetting":[{"displayName":"閫氳繃","enable":true,"id":1},{"displayName":"鎷掔粷","enable":true,"id":2},{"displayName":"杞姙","enable":true,"id":3},{"displayName":"濮旀淳","enable":true,"id":4},{"displayName":"鍔犵","enable":true,"id":5},{"displayName":"閫�鍥�","enable":true,"id":6}],"candidateParam":"1","candidateStrategy":30,"childNode":{"id":"EndEvent","name":"缁撴潫","type":1},"fieldsPermission":[],"id":"Activity_sale_order_approve","name":"瀹℃壒浜�","reasonRequire":false,"rejectHandler":{"returnNodeId":null,"type":1},"showText":"鎸囧畾鎴愬憳鎴栨寚瀹氳鑹插鎵�","signEnable":false,"skipExpression":"","taskAssignListener":{"body":[],"enable":false,"header":[],"path":null},"taskCompleteListener":{"body":[],"enable":false,"header":[],"path":null},"taskCreateListener":{"body":[],"enable":false,"header":[],"path":null},"timeoutHandler":{"enable":false,"maxRemindCount":null,"timeDuration":null,"type":null},"type":11},"fieldsPermission":[],"id":"StartUserNode","name":"鍙戣捣浜�","showText":"鍙戣捣浜�","type":10}', 1, '1787584300000', '', NULL, '1', 1, 1, NULL, '1', NOW(), '1', NOW(), 0 FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM bpm_process_definition_info WHERE deleted=0 AND category='sale_order_approve');
-
--- ============================================================
--- 璇存槑:浠ヤ笂涓洪攢鍞鍗曞鎵规帴鍏ュ崗鍚屽姙鍏殑鍏ㄩ儴鏁版嵁搴撳彉鏇�
--- 1. 姝ラ 1-5 涓鸿〃缁撴瀯/鍒嗙被/瀛楀吀/涓氬姟鏄犲皠/瀛橀噺鏁版嵁杩佺Щ
--- 2. 姝ラ 6 涓� BPM 娴佺▼瀹氫箟(sale_order_approve)閮ㄧ讲
--- 3. 瀹℃壒浜洪粯璁や负鐢ㄦ埛 id=1(admin),濡傞渶璋冩暣璇峰湪銆屽崗鍚屽姙鍏� -> 娴佺▼绠$悊銆嶄慨鏀�
--- ============================================================
--- ============================================================
--- 鍏ㄩ儴鏁版嵁搴撳彉鏇村凡瀹屾垚
--- 1. 姝ラ 1-5: 琛ㄧ粨鏋� / BPM鍒嗙被 / 瀹℃壒瀛楀吀 / 涓氬姟璇︽儏鏄犲皠 / 瀛橀噺鏁版嵁杩佺Щ
--- 2. 姝ラ 6: BPM 娴佺▼瀹氫箟(sale_order_approve)閮ㄧ讲(骞傜瓑)
--- 3. 瀹℃壒浜洪粯璁や负鐢ㄦ埛 id=1(admin),濡傞渶璋冩暣璇峰湪銆屽崗鍚屽姙鍏� -> 娴佺▼绠$悊銆嶄慨鏀规祦绋�
--- ============================================================
--
Gitblit v1.9.3