kris/hh-vue
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
master
hh-vue/sql/warm/v1-upgrade/warm-flow_form.sql

16 lines
11 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1125, '表单定义', 1106, 1, 'form', 'form/definition/index', NULL, '', 1, 0, 'C', '0', '0', 'flow:form:list', 'online', 'admin', '2023-04-11 13:06:38', 'admin', '2023-04-13 13:00:05', '表单定义菜单');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1126, '表单定义查询', 1125, 1, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'flow:form:query', '#', 'admin', '2023-04-11 13:06:38', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1127, '表单定义新增', 1125, 2, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'flow:form:add', '#', 'admin', '2023-04-11 13:06:38', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1128, '表单定义修改', 1125, 4, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'flow:form:edit', '#', 'admin', '2023-04-11 13:06:38', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1129, '流程定义删除', 1125, 5, '#', '', NULL, '', 1, 0, 'F', '0', '0', 'flow:form:remove', '#', 'admin', '2023-04-11 13:06:38', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1130, '发布', 1125, 9, '', NULL, NULL, '', 1, 0, 'F', '0', '0', 'flow:form:publish', '#', 'admin', '2023-04-14 17:03:57', '', NULL, '');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1131, '取消发布', 1125, 10, '', NULL, NULL, '', 1, 0, 'F', '0', '0', 'flow:form:unPublish', '#', 'admin', '2023-04-14 23:05:27', '', NULL, '内置表单处理');
INSERT INTO `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1132, '任务加载(内置表单处理)', 1118, 2, 'load', '', NULL, '', 1, 0, 'F', '0', '0', 'flow:execute:load', 'guide', 'admin', '2023-04-17 17:21:21', 'admin', '2023-06-11 00:33:39', '');
INSERT INTO `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (129, 11, '表单-简单', '11', 'leave_type', NULL, 'default', 'N', '0', 'admin', '2023-04-01 23:32:40', 'admin', '2024-06-06 16:31:11', 'leaveFlow-form1');
INSERT INTO `flow_form` (`id`, `form_code`, `form_name`, `version`, `is_publish`, `form_type`, `form_path`, `form_content`, `ext`, `create_time`, `update_time`, `del_flag`, `tenant_id`) VALUES (1272523094673723391, 'TEST-FORM', 'hr审批', '1', 1, 0, '', '{\"rule\":[{\"type\":\"input\",\"field\":\"Fua5m50q7wl8abc\",\"title\":\"输入框\",\"info\":\"\",\"$required\":false,\"_fc_id\":\"id_F43fm50q7wl8acc\",\"name\":\"ref_F2aym50q7wl8adc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"input\"}],\"option\":{\"form\":{\"inline\":false,\"hideRequiredAsterisk\":false,\"labelPosition\":\"right\",\"size\":\"default\",\"labelWidth\":\"125px\"},\"resetBtn\":{\"show\":false,\"innerText\":\"重置\"},\"submitBtn\":{\"show\":true,\"innerText\":\"提交\"}}}', NULL, '2024-11-02 16:37:33', '2024-12-27 16:27:00', '0', '000000');
INSERT INTO `flow_form` (`id`, `form_code`, `form_name`, `version`, `is_publish`, `form_type`, `form_path`, `form_content`, `ext`, `create_time`, `update_time`, `del_flag`, `tenant_id`) VALUES (1304134676025315328, 'TEST-FORM', '部门经理审批', '1', 1, 0, '', '{\"rule\":[{\"type\":\"select\",\"field\":\"type\",\"title\":\"请假类型\",\"info\":\"\",\"$required\":\"请假类型不能为空\",\"props\":{\"_optionType\":2,\"clearable\":true,\"placeholder\":\"请选择请假类型\",\"filterable\":true},\"_fc_id\":\"id_Fwiem38bhk9pacc\",\"name\":\"ref_Fp3dm38bhk9padc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"select\",\"options\":[{\"label\":\"串行-简单\",\"value\":\"30\"},{\"label\":\"串行-通过互斥\",\"value\":\"31\"},{\"label\":\"并行-汇聚\",\"value\":\"46\"},{\"label\":\"并行-分开\",\"value\":\"49\"},{\"label\":\"串行-退回互斥\",\"value\":\"51\"},{\"label\":\"会签\",\"value\":\"109\"},{\"label\":\"票签\",\"value\":\"110\"},{\"label\":\"串行-复杂互斥\",\"value\":\"118\"},{\"label\":\"并行-串行\",\"value\":\"119\"},{\"label\":\"办理人权限表达式\",\"value\":\"123\"}]},{\"type\":\"input\",\"field\":\"reason\",\"title\":\"请假原因\",\"info\":\"\",\"$required\":\"请假原因不能为空\",\"props\":{\"type\":\"textarea\",\"maxlength\":200,\"showWordLimit\":false,\"placeholder\":\"请输入内容\"},\"_fc_id\":\"id_Fw3mm38c2x6uaec\",\"name\":\"ref_Fhr5m38c2x6uafc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"textarea\"},{\"type\":\"datePicker\",\"field\":\"startTime\",\"title\":\"开始时间\",\"info\":\"\",\"$required\":\"开始时间不能为空\",\"props\":{\"type\":\"date\",\"placeholder\":\"选择开始时间\",\"editable\":false},\"_fc_id\":\"id_F6qtm38gbs4zaec\",\"name\":\"ref_Fjhcm38gbs4zafc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"datePicker\"},{\"type\":\"datePicker\",\"field\":\"endTime\",\"title\":\"结束时间\",\"info\":\"\",\"$required\":\"结束时间不能为空\",\"props\":{\"type\":\"date\",\"placeholder\":\"选择结束时间\",\"editable\":false},\"_fc_id\":\"id_F4ejm38gf7soahc\",\"name\":\"ref_Fjhcm38gbs4zafc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"datePicker\"},{\"type\":\"input\",\"field\":\"day\",\"title\":\"请假天数\",\"info\":\"\",\"$required\":\"请假天数不能为空\",\"props\":{\"placeholder\":\"请输入请假天数\",\"clearable\":true},\"_fc_id\":\"id_Fdpfm38ify69acc\",\"name\":\"ref_F4ism38ify69adc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"input\"},{\"type\":\"input\",\"field\":\"flowStatus\",\"title\":\"自定义流程状态\",\"info\":\"warm-flow工作流默认内置了一套流程状态，如果此字段填写可以自定义流程状态\",\"$required\":false,\"props\":{\"placeholder\":\"请输入流程状态\",\"clearable\":true},\"_fc_id\":\"id_Fqjum38inuu3afc\",\"name\":\"ref_F4ism38ify69adc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"input\"},{\"type\":\"select\",\"field\":\"additionalHandler\",\"title\":\"抄送人\",\"info\":\"\",\"$required\":false,\"props\":{\"_optionType\":2,\"clearable\":true,\"placeholder\":\"请选择抄送人\",\"filterable\":true,\"multiple\":true,\"collapseTags\":true},\"_fc_id\":\"id_Fh3hm38ir0nnahc\",\"name\":\"ref_Fp3dm38bhk9padc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"select\",\"options\":[{\"label\":\"若依\",\"value\":\"1\"},{\"label\":\"若依\",\"value\":\"2\"},{\"label\":\"领导\",\"value\":\"100\"},{\"label\":\"员工\",\"value\":\"101\"}]}],\"option\":{\"form\":{\"inline\":false,\"hideRequiredAsterisk\":false,\"labelPosition\":\"right\",\"size\":\"default\",\"labelWidth\":\"125px\"},\"resetBtn\":{\"show\":false,\"innerText\":\"重置\"},\"submitBtn\":{\"show\":true,\"innerText\":\"提交\"}}}', NULL, '2024-11-07 17:25:36', '2024-12-27 16:26:24', '0', '000000');
INSERT INTO `flow_form` (`id`, `form_code`, `form_name`, `version`, `is_publish`, `form_type`, `form_path`, `form_content`, `ext`, `create_time`, `update_time`, `del_flag`, `tenant_id`) VALUES (1315748253194653696, 'LEAVE-FORM', '待提交', '1', 1, 0, '', '{\"rule\":[{\"type\":\"input\",\"field\":\"reason\",\"title\":\"请假原因\",\"info\":\"\",\"$required\":false,\"props\":{\"type\":\"textarea\",\"placeholder\":\"请输入请假原因\"},\"_fc_id\":\"id_Feg1m4pn9fl1afc\",\"name\":\"ref_Fe4om4pn9fl1agc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"textarea\"},{\"type\":\"datePicker\",\"field\":\"time\",\"title\":\"请假时间\",\"info\":\"\",\"$required\":false,\"props\":{\"type\":\"daterange\"},\"_fc_id\":\"id_F5wnm4pn9q0aaic\",\"name\":\"ref_F42tm4pn9q0aajc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"dateRange\",\"on\":{}},{\"type\":\"input\",\"field\":\"days\",\"title\":\"请假天数\",\"info\":\"\",\"$required\":false,\"props\":{\"type\":\"number\"},\"_fc_id\":\"id_F2wqm4pna4p8alc\",\"name\":\"ref_Fl40m4pna4p8amc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"input\"}],\"option\":{\"form\":{\"inline\":false,\"hideRequiredAsterisk\":false,\"labelPosition\":\"right\",\"size\":\"default\",\"labelWidth\":\"125px\"},\"resetBtn\":{\"show\":false,\"innerText\":\"重置\"},\"submitBtn\":{\"show\":true,\"innerText\":\"提交\"}}}', NULL, '2024-12-09 18:33:49', '2024-12-27 16:18:59', '0', NULL);
INSERT INTO `flow_form` (`id`, `form_code`, `form_name`, `version`, `is_publish`, `form_type`, `form_path`, `form_content`, `ext`, `create_time`, `update_time`, `del_flag`, `tenant_id`) VALUES (1317970320258371584, 'LEAVE-VIEW', '中间节点-会签', '1', 1, 0, '', '{\"rule\":[{\"type\":\"input\",\"field\":\"reason\",\"title\":\"请假原因\",\"info\":\"\",\"$required\":false,\"props\":{\"type\":\"textarea\",\"placeholder\":\"请输入请假原因\",\"readonly\":false},\"_fc_id\":\"id_Feg1m4pn9fl1afc\",\"name\":\"ref_Fe4om4pn9fl1agc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"textarea\"},{\"type\":\"datePicker\",\"field\":\"time\",\"title\":\"请假时间\",\"info\":\"\",\"$required\":false,\"props\":{\"type\":\"daterange\",\"readonly\":false},\"_fc_id\":\"id_F5wnm4pn9q0aaic\",\"name\":\"ref_F42tm4pn9q0aajc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"dateRange\"},{\"type\":\"input\",\"field\":\"days\",\"title\":\"请假天数\",\"info\":\"\",\"$required\":false,\"props\":{\"type\":\"number\",\"readonly\":false},\"_fc_id\":\"id_F2wqm4pna4p8alc\",\"name\":\"ref_Fl40m4pna4p8amc\",\"display\":true,\"hidden\":false,\"_fc_drag_tag\":\"input\"}],\"option\":{\"form\":{\"inline\":false,\"hideRequiredAsterisk\":false,\"labelPosition\":\"right\",\"size\":\"default\",\"labelWidth\":\"125px\"},\"resetBtn\":{\"show\":false,\"innerText\":\"重置\"},\"submitBtn\":{\"show\":true,\"innerText\":\"提交\"}}}', NULL, '2024-12-15 21:43:31', '2024-12-27 16:19:32', '0', NULL);
Reference in New Issue View Git Blame Copy Permalink