Página Principal Explorar Ajuda
Registe-se Iniciar Sessão
tl
/
api
5
0
Fork 0
Ficheiros Problemas 0 Pull Requests 0 Wiki
Árvore: fad25c5e39
Ramos Etiquetas
api
/
target
/
classes
/
sqlScript
/
20240407_sql.sql

20240407_sql.sql 24 KB
Histórico Em bruto

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152 
  1. -- ------------------------------------------------
    2. 

  2. -- 资产管理盘点
    3. 

  3. -- ------------------------------------------------
    4. 

  4. DROP TABLE IF EXISTS wf_asset_manage_inventory;
    5. 

  5. CREATE TABLE `wf_asset_manage_inventory` (
    6. 

  6.   `id` BIGINT NOT NULL,
    7. 

  7.   `create_user_id` BIGINT DEFAULT NULL,
    8. 

  8.   `create_date` DATETIME(3) DEFAULT NULL,
    9. 

  9.   `modify_user_id` BIGINT DEFAULT NULL,
    10. 

  10.   `modify_date` DATETIME(3) DEFAULT NULL,
    11. 

  11.   `delete_mark` INT DEFAULT NULL,
    12. 

  12.   `enabled_mark` INT DEFAULT NULL,
    13. 

  13.   `status` SMALLINT DEFAULT 0 COMMENT '状态(0:未结束 1:结束)',
    14. 

  14.   `area_type` VARCHAR(50) DEFAULT NULL COMMENT '区域类型',
    15. 

  15.   `folder_id` BIGINT DEFAULT NULL COMMENT '附件id',
    16. 

  16.   `base_office_build_id` BIGINT DEFAULT NULL COMMENT '楼栋id',
    17. 

  17.   `floor_number` INT DEFAULT NULL COMMENT '楼层',
    18. 

  18.   `room_number` VARCHAR(50) DEFAULT NULL COMMENT '门牌号',
    19. 

  19.   PRIMARY KEY (`id`) USING BTREE
    20. 

  20. ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='资产管理盘点';
    21. 

  21. 

  22. 

  23. -- -----------------------------------------------------------
    24. 

  24. -- 学籍表中增加考号
    25. 

  25. -- -----------------------------------------------------------
    26. 

  26. DROP PROCEDURE IF EXISTS createCom;
    27. 

  27. DELIMITER $$
    28. 

  28. CREATE
    29. 

  29.     PROCEDURE createCom()
    30. 

  30. BEGIN
    31. 

  31.     IF NOT EXISTS(SELECT 1 FROM information_schema.columns  WHERE table_name='wf_asset_manage' AND COLUMN_NAME = 'extend_json') THEN
    32. 

  32. ALTER TABLE `wf_asset_manage`   
    33. 

  33.   ADD COLUMN `extend_json` LONGTEXT NULL   COMMENT '附件其他信息' AFTER `status`;
    34. 

  34.     END IF;
    35. 

  35. END$$
    36. 

  36. DELIMITER ;
    37. 

  37. CALL createCom;
    38. 

  38. DROP PROCEDURE createCom;
    39. 

  39. 

  40. -- -----------------------------------------------------------
    41. 

  41. -- 公务派车
    42. 

  42. -- -----------------------------------------------------------
    43. 

  43. DROP TABLE IF EXISTS wf_official_vehicles;
    44. 

  44. CREATE TABLE `wf_official_vehicles` (
    45. 

  45.   `id` BIGINT NOT NULL,
    46. 

  46.   `create_user_id` BIGINT DEFAULT NULL,
    47. 

  47.   `create_date` DATETIME(3) DEFAULT NULL,
    48. 

  48.   `modify_user_id` BIGINT DEFAULT NULL,
    49. 

  49.   `modify_date` DATETIME(3) DEFAULT NULL,
    50. 

  50.   `delete_mark` INT DEFAULT NULL,
    51. 

  51.   `enabled_mark` INT DEFAULT NULL,
    52. 

  52.   `status` SMALLINT DEFAULT '0' COMMENT '状态(0:未结束 1:结束)',
    53. 

  53.   `name` VARCHAR(50) DEFAULT NULL COMMENT '姓名',
    54. 

  54.   `dept_id` BIGINT DEFAULT NULL COMMENT '部门id',
    55. 

  55.   `number_of_people` BIGINT DEFAULT '0' COMMENT '人数',
    56. 

  56.   `folder_id` BIGINT DEFAULT NULL COMMENT '附件',
    57. 

  57.   `destination` VARCHAR(100) DEFAULT NULL COMMENT '目的地',
    58. 

  58.   `liaison_man` VARCHAR(50) DEFAULT NULL COMMENT '联系人',
    59. 

  59.   `phone` VARCHAR(50) DEFAULT NULL COMMENT '联系电话',
    60. 

  60.   `set_out_date` DATETIME DEFAULT NULL COMMENT '出发时间',
    61. 

  61.   `leader_id` BIGINT DEFAULT NULL COMMENT '分管领导id',
    62. 

  62.   PRIMARY KEY (`id`) USING BTREE
    63. 

  63. ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='公务派车';
    64. 

  64. 

  65. 

  66. -- -----------------------------------------------------------
    67. 

  67. -- 菜单部门关联表
    68. 

  68. -- -----------------------------------------------------------
    69. 

  69. DROP TABLE IF EXISTS xjr_menu_dept_relation;
    70. 

  70. CREATE TABLE `xjr_menu_dept_relation` (
    71. 

  71.   `id` BIGINT NOT NULL,
    72. 

  72.   `create_user_id` BIGINT DEFAULT NULL,
    73. 

  73.   `create_date` DATETIME(3) DEFAULT NULL,
    74. 

  74.   `modify_user_id` BIGINT DEFAULT NULL,
    75. 

  75.   `modify_date` DATETIME(3) DEFAULT NULL,
    76. 

  76.   `delete_mark` INT DEFAULT NULL,
    77. 

  77.   `enabled_mark` INT DEFAULT NULL,
    78. 

  78.   `menu_id` BIGINT DEFAULT NULL COMMENT '菜单id',
    79. 

  79.   `dept_id` BIGINT DEFAULT NULL COMMENT '部门id',
    80. 

  80.   PRIMARY KEY (`id`) USING BTREE
    81. 

  81. ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单部门关联表';
    82. 

  82. 

  83. ALTER TABLE `pb_v_xsxxsfytb`   
    84. 

  84.   ADD INDEX (`personalid`),
    85. 

  85.   ADD INDEX (`feeitemcode`);
    86. 

  86.   
    87. 

  87. ALTER TABLE `pb_v_xssfdetail`   
    88. 

  88.   ADD INDEX (`personalid`),
    89. 

  89.   ADD INDEX (`feeitemcode`);
    90. 

  90.   
    91. 

  91.   ALTER TABLE `base_student_school_roll`   
    92. 

  92.   ADD INDEX (`student_type`),
    93. 

  93.   ADD INDEX (`archives_status`),
    94. 

  94.   ADD INDEX (`stduy_status`);
    95. 

  95. 

  96. ALTER TABLE `base_student_family_member`   
    97. 

  97.   ADD INDEX (`user_id`);
    98. 

  98. 

  99. ALTER TABLE `pb_v_xsxxsfytb`   
    100. 

  100. ADD INDEX (`Studentcode`);
    101. 

  101. 

  102. ALTER TABLE `pb_v_xsxxsfytb`   
    103. 

  103.   ADD INDEX (`jfzt`),
    104. 

  104.   ADD INDEX (`beltcode`);
    105. 

  105. 

  106. -- -----------------------------------------------------------
    107. 

  107. -- 公务派车表增加出发时间
    108. 

  108. -- -----------------------------------------------------------
    109. 

  109. DROP PROCEDURE IF EXISTS createCom;
    110. 

  110. DELIMITER $$
    111. 

  111. CREATE
    112. 

  112.     PROCEDURE createCom()
    113. 

  113. BEGIN
    114. 

  114.     IF NOT EXISTS(SELECT 1 FROM information_schema.columns  WHERE table_name='wf_official_vehicles' AND COLUMN_NAME = 'set_out_date') THEN
    115. 

  115. ALTER TABLE `wf_official_vehicles`   
    116. 

  116.   ADD COLUMN `set_out_date` DATETIME NULL   COMMENT '出发时间' AFTER `phone`;
    117. 

  117. 

  118.     END IF;
    119. 

  119. END$$
    120. 

  120. DELIMITER ;
    121. 

  121. CALL createCom;
    122. 

  122. DROP PROCEDURE createCom;
    123. 

  123. 

  124. ALTER TABLE `xjr_workflow_record`   
    125. 

  125.   ADD COLUMN `show_node` BOOLEAN NULL   COMMENT '是否显示该记录' AFTER `create_user_id`;
    126. 

  126. ALTER TABLE `xjr_workflow_operate_record`   
    127. 

  127.   ADD COLUMN `show_node` BOOLEAN NULL   COMMENT '是否显示该记录';
    128. 

  128.   ALTER TABLE `xjr_workflow_approve_record`   
    129. 

  129.   ADD COLUMN `show_node` BOOLEAN NULL   COMMENT '是否显示该记录';
    130. 

  130. 

  131. DROP TABLE IF EXISTS wf_document_circulation;
    132. 

  132. CREATE TABLE `wf_document_circulation` (
    133. 

  133.   `id` BIGINT NOT NULL COMMENT '主键编号',
    134. 

  134.   `create_user_id` BIGINT DEFAULT NULL COMMENT '创建人',
    135. 

  135.   `create_date` DATETIME DEFAULT NULL COMMENT '创建时间',
    136. 

  136.   `modify_user_id` BIGINT DEFAULT NULL COMMENT '修改人',
    137. 

  137.   `modify_date` DATETIME DEFAULT NULL COMMENT '修改时间',
    138. 

  138.   `delete_mark` INT DEFAULT NULL COMMENT '删除标志',
    139. 

  139.   `enabled_mark` INT DEFAULT NULL COMMENT '有效标志',
    140. 

  140.   `file_title` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '文件标题',
    141. 

  141.   `dispatch_unit` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '发文单位',
    142. 

  142.   `Issue_number` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '期号',
    143. 

  143.   `date` DATETIME DEFAULT NULL COMMENT '日期',
    144. 

  144.   `file_id` BIGINT DEFAULT NULL COMMENT '附件文件id',
    145. 

  145.   `status` INT DEFAULT NULL COMMENT '流程状态（0:未结束 1：结束）',
    146. 

  146.   PRIMARY KEY (`id`)
    147. 

  147. ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='文件传阅';
    148. 

  148. 

  149. 

  150. INSERT INTO `tl`.`xjr_form_template` (`id`, `name`, `category`, `form_type`, `form_json`, `sort_code`, `remark`, `create_user_id`, `create_date`, `modify_user_id`, `modify_date`, `delete_mark`, `enabled_mark`, `config_json`, `form_design_type`) VALUES (1778625118535204865, '公务派车', 1650387621322219521, 1, '{\"tableConfigs\":[{\"pkField\":\"id\",\"isMain\":true,\"relationField\":null,\"tableName\":\"wf_official_vehicles\",\"relationTableField\":null,\"pkType\":\"Long\"}],\"dataAuthList\":[],\"tableStructureConfigs\":[{\"pkField\":null,\"isMain\":true,\"tableComment\":null,\"operator\":4,\"tableName\":\"wf_official_vehicles\",\"tableFieldConfigs\":[{\"fieldName\":\"name\",\"fieldComment\":\"申请人\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"dept_id\",\"fieldComment\":\"所属部门\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"destination\",\"fieldComment\":\"目的地\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"set_out_date\",\"fieldComment\":\"出发时间\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"number_of_people\",\"fieldComment\":\"出行人数\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"leader_id\",\"fieldComment\":\"领导id\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"liaison_man\",\"fieldComment\":\"联系人\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"phone\",\"fieldComment\":\"联系电话\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"folder_id\",\"fieldComment\":\"附件\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"status\",\"fieldComment\":\"status\",\"fieldType\":null,\"fieldLength\":50}]}],\"isDataAuth\":false,\"formEventConfig\":{\"0\":[{\"color\":\"#2774ff\",\"icon\":\"#icon-kaishi\",\"type\":\"circle\",\"bgcColor\":\"#D8E5FF\",\"isClick\":false,\"isUserDefined\":false,\"text\":\"开始节点\"},{\"color\":\"#F6AB01\",\"icon\":\"#icon-chushihua\",\"bgcColor\":\"#f9f5ea\",\"isClick\":false,\"isUserDefined\":false,\"text\":\"初始化表单\",\"nodeInfo\":{\"processEvent\":[]}},{\"color\":\"#2774FF\",\"icon\":\"#icon-yonghu-xianxing\",\"bgcColor\":\"#F5F8FA\",\"isClick\":true,\"isUserDefined\":true,\"text\":\"用户自定义节点\",\"nodeInfo\":{\"processEvent\":[{\"operateConfig\":\"if(formModel.folder_id == \\\"\\\"||formModel.folder_id == null)\\n{\\nformModel.folder_id = 0;\\n}\",\"operateType\":\"js\",\"showValue\":\"已配置\"}]}}],\"1\":[{\"color\":\"#B36EDB\",\"icon\":\"#icon-shujufenxi\",\"bgcColor\":\"#F8F2FC\",\"isClick\":false,\"isUserDefined\":false,\"text\":\"获取表单数据\",\"detail\":\"(新增无此操作)\",\"nodeInfo\":{\"processEvent\":[]}}],\"2\":[{\"color\":\"#F8625C\",\"icon\":\"#icon-jiazai\",\"bgcColor\":\"#FFF1F1\",\"isClick\":false,\"isUserDefined\":false,\"text\":\"加载表单\",\"nodeInfo\":{\"processEvent\":[]}}],\"3\":[{\"color\":\"#6C6AE0\",\"icon\":\"#icon-jsontijiao\",\"bgcColor\":\"#F5F4FF\",\"isClick\":false,\"isUserDefined\":false,\"text\":\"提交表单\",\"nodeInfo\":{\"processEvent\":[]}}],\"4\":[{\"color\":\"#F8625C\",\"isLast\":true,\"icon\":\"#icon-jieshuzhiliao\",\"type\":\"circle\",\"bgcColor\":\"#FFD6D6\",\"isClick\":false,\"isUserDefined\":false,\"text\":\"结束节点\"}]},\"formJson\":{\"hiddenComponent\":[{\"code\":\"status\",\"label\":\"status\",\"type\":\"hiddenComponent\",\"bindField\":\"status\",\"bindTable\":\"wf_official_vehicles\",\"value\":\"0\",\"key\":\"hiddenComponent1712892228526\"}],\"list\":[{\"code\":null,\"rules\":[],\"label\":\"栅格布局\",\"type\":\"grid\",\"isSubFormChild\":false,\"layout\":[{\"list\":[{\"code\":null,\"rules\":[],\"label\":\"申请人\",\"type\":\"info\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"name\",\"options\":{\"showLabel\":true,\"isShow\":true,\"infoType\":0,\"width\":\"100%\",\"disabled\":true,\"placeholder\":\"\",\"loadAgain\":false,\"events\":{},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"1cb60b1274d54bac9bd0774980526f88\",\"bindEndTime\":null}],\"name\":null,\"span\":12},{\"list\":[{\"code\":null,\"rules\":null,\"label\":\"所属部门\",\"type\":\"select\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"dept_id\",\"options\":{\"clearable\":false,\"multiple\":\"combobox\",\"defaultSelect\":null,\"rules\":[],\"params\":null,\"valueField\":\"value\",\"showLabel\":true,\"required\":true,\"labelField\":\"label\",\"isShow\":true,\"datasourceType\":\"api\",\"dicOptions\":[],\"showSearch\":true,\"width\":\"100%\",\"apiConfig\":{\"method\":\"GET\",\"script\":\"return db.select(\\\"\\\"\\\"\\r\\n\\tSELECT t.name as label,t.id AS value FROM xjr_department  t\\r\\n\\r\\nWHERE t.parent_id = 1684107782861680000 AND t.delete_mark = 0 AND t.code !=10001\\r\\n\\\"\\\"\\\");\",\"apiParams\":[{\"tableInfo\":[],\"title\":\"Query Params\",\"key\":\"1\"},{\"tableInfo\":[],\"title\":\"Header\",\"key\":\"2\"},{\"title\":\"Body\",\"key\":\"3\"}],\"path\":\"baseData/department/option\",\"apiId\":\"090dc643d95b4efc92b1c44d41fdde86\"},\"disabled\":false,\"placeholder\":\"请选择所属部门\",\"staticOptions\":[{\"label\":\"Option 1\",\"value\":\"Option 1\",\"key\":1},{\"label\":\"Option 2\",\"value\":\"Option 2\",\"key\":2},{\"label\":\"Option 3\",\"value\":\"Option 3\",\"key\":3}],\"events\":{\"change\":\"var isPc = false;\\ntry{\\nisPc = window.isPc;\\n}\\ncatch(_){};\\nif(formModel.isChange || !isPc ){\\nformActionType.httpRequest({\\n    requestType: \'get\', //请求方式有: get、post、put、delete\\n    requestUrl: \'/magic-api/educational/depart-leader\', //请求地址\\n    params: {\\n      dep_id:formModel.dept_id\\n    },//请求参数\\n    errorMessageMode: \'none\' //错误提示方式，默认为none\\n}).then(function(res){//行动\\nvar v=res.data||res;\\n formModel.leader_id=v;\\n})\\n};\",\"click\":\"formModel.isChange = true;\"},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"4fd6ee2489164c329ca99d54c66c3f8f\",\"bindEndTime\":null}],\"name\":null,\"span\":12}],\"bindStartTime\":null,\"children\":null,\"bindField\":null,\"options\":{\"align\":\"top\",\"isShow\":true,\"gutter\":16,\"justify\":\"start\"},\"bindTable\":null,\"value\":null,\"key\":\"bf6e564972b644e4be49f039daa28ec3\",\"bindEndTime\":null},{\"code\":null,\"rules\":[],\"label\":\"栅格布局\",\"type\":\"grid\",\"isSubFormChild\":false,\"layout\":[{\"list\":[{\"code\":null,\"rules\":null,\"label\":\"目的地\",\"type\":\"input\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"destination\",\"options\":{\"maxlength\":null,\"defaultValue\":\"\",\"prefix\":\"\",\"rules\":[],\"suffix\":\"\",\"addonAfter\":\"\",\"showLabel\":true,\"required\":true,\"isSave\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请输入目的地\",\"allowClear\":false,\"addonBefore\":\"\",\"events\":{},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"e8d25ac9f8b34be988e216f274c14fef\",\"bindEndTime\":null},{\"code\":null,\"rules\":null,\"label\":\"出发时间\",\"type\":\"date\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"set_out_date\",\"options\":{\"defaultValue\":\"\",\"format\":\"YYYY-MM-DD HH:mm:ss\",\"rules\":[],\"showLabel\":true,\"required\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请选择出发时间\",\"allowClear\":true,\"events\":{},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"16413226567f4b5581cf6ea5825e930a\",\"bindEndTime\":null}],\"name\":null,\"span\":12},{\"list\":[{\"code\":null,\"rules\":null,\"label\":\"出行人数\",\"type\":\"number\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"number_of_people\",\"options\":{\"controls\":true,\"max\":100,\"maxlength\":null,\"defaultValue\":null,\"rules\":[],\"subTotal\":false,\"showLabel\":true,\"required\":true,\"isShow\":true,\"min\":0,\"width\":\"100%\",\"step\":1,\"disabled\":false,\"events\":{},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"1fc2db6441184964997dd1f5d9ef5102\",\"bindEndTime\":null},{\"code\":null,\"rules\":[],\"label\":\"领导id\",\"type\":\"input\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"leader_id\",\"options\":{\"maxlength\":null,\"defaultValue\":\"0\",\"prefix\":\"\",\"rules\":[],\"suffix\":\"\",\"addonAfter\":\"\",\"showLabel\":true,\"required\":false,\"isSave\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":true,\"placeholder\":\"请输入领导id\",\"allowClear\":false,\"addonBefore\":\"\",\"events\":{},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"d0a61379637743a7aa62e6b69ba8a58e\",\"bindEndTime\":null}],\"name\":null,\"span\":12}],\"bindStartTime\":null,\"children\":null,\"bindField\":null,\"options\":{\"align\":\"top\",\"isShow\":true,\"gutter\":16,\"justify\":\"start\"},\"bindTable\":null,\"value\":null,\"key\":\"4a1518041fe449a3b54da4b574dff919\",\"bindEndTime\":null},{\"code\":null,\"rules\":[],\"label\":\"栅格布局\",\"type\":\"grid\",\"isSubFormChild\":false,\"layout\":[{\"list\":[{\"code\":null,\"rules\":null,\"label\":\"联系人\",\"type\":\"input\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"liaison_man\",\"options\":{\"maxlength\":null,\"defaultValue\":\"\",\"prefix\":\"\",\"rules\":[],\"suffix\":\"\",\"addonAfter\":\"\",\"showLabel\":true,\"required\":true,\"isSave\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请输入联系人\",\"allowClear\":false,\"addonBefore\":\"\",\"events\":{},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"01488459443c4fe6b138e23b808f03ad\",\"bindEndTime\":null}],\"name\":null,\"span\":12},{\"list\":[{\"code\":null,\"rules\":null,\"label\":\"联系电话\",\"type\":\"input\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"phone\",\"options\":{\"maxlength\":null,\"defaultValue\":\"\",\"prefix\":\"\",\"rules\":[],\"suffix\":\"\",\"addonAfter\":\"\",\"showLabel\":true,\"required\":true,\"isSave\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请输入联系电话\",\"allowClear\":false,\"addonBefore\":\"\",\"events\":{},\"span\":7},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"40e5e5462b674895a9882fe7adc423d2\",\"bindEndTime\":null}],\"name\":null,\"span\":12}],\"bindStartTime\":null,\"children\":null,\"bindField\":null,\"options\":{\"align\":\"top\",\"isShow\":true,\"gutter\":16,\"justify\":\"start\"},\"bindTable\":null,\"value\":null,\"key\":\"3a8b5f27f1b641d287146f8bb847b733\",\"bindEndTime\":null},{\"code\":null,\"rules\":[],\"label\":\"附件\",\"type\":\"upload\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"folder_id\",\"options\":{\"defaultValue\":[],\"multiple\":false,\"maxSize\":5,\"listType\":\"text\",\"showLabel\":true,\"required\":false,\"accept\":\"\",\"isShow\":true,\"maxNumber\":5,\"disabled\":false,\"events\":{},\"span\":\"\"},\"bindTable\":\"wf_official_vehicles\",\"value\":null,\"key\":\"c840664d2fc14a859bbadc46d0349b29\",\"bindEndTime\":null},{\"code\":\"status\",\"rules\":null,\"label\":\"status\",\"type\":\"hiddenComponent\",\"isSubFormChild\":null,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"status\",\"options\":null,\"bindTable\":\"wf_official_vehicles\",\"value\":\"0\",\"key\":\"hiddenComponent1712892228526\",\"bindEndTime\":null}],\"config\":{\"formType\":\"modal\",\"hideRequiredMark\":null,\"formWidth\":800,\"layout\":\"vertical\",\"size\":\"default\",\"labelAlign\":\"right\",\"labelCol\":{\"offset\":0,\"span\":3}}},\"databaseId\":\"master\"}', NULL, '', 1000000000000000000, '2024-04-12 11:24:08.173', 1000000000000000000, '2024-04-12 15:45:52.409', 0, 1, NULL, 0);
    151. 

  151. INSERT INTO `tl`.`xjr_form_template` (`id`, `name`, `category`, `form_type`, `form_json`, `sort_code`, `remark`, `create_user_id`, `create_date`, `modify_user_id`, `modify_date`, `delete_mark`, `enabled_mark`, `config_json`, `form_design_type`) VALUES (1778676770646573058, '文件传阅', 1650387621322219521, 1, '{\"tableConfigs\":[{\"pkField\":\"id\",\"isMain\":true,\"relationField\":null,\"tableName\":\"wf_document_circulation\",\"relationTableField\":null,\"pkType\":\"Long\"}],\"dataAuthList\":[],\"tableStructureConfigs\":[{\"pkField\":null,\"isMain\":true,\"tableComment\":null,\"operator\":4,\"tableName\":\"wf_document_circulation\",\"tableFieldConfigs\":[{\"fieldName\":\"file_title\",\"fieldComment\":\"文件标题\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"dispatch_unit\",\"fieldComment\":\"发文单位\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"Issue_number\",\"fieldComment\":\"期号\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"date\",\"fieldComment\":\"日期\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"file_id\",\"fieldComment\":\"附件\",\"fieldType\":null,\"fieldLength\":50},{\"fieldName\":\"status\",\"fieldComment\":\"流程状态\",\"fieldType\":null,\"fieldLength\":50}]}],\"isDataAuth\":false,\"formEventConfig\":{\"0\":[{\"color\":\"#2774ff\",\"icon\":\"#icon-kaishi\",\"type\":\"circle\",\"bgcColor\":\"#D8E5FF\",\"isUserDefined\":false,\"text\":\"开始节点\"},{\"color\":\"#F6AB01\",\"icon\":\"#icon-chushihua\",\"bgcColor\":\"#f9f5ea\",\"isUserDefined\":false,\"text\":\"初始化表单\",\"nodeInfo\":{\"processEvent\":[]}}],\"1\":[{\"color\":\"#B36EDB\",\"icon\":\"#icon-shujufenxi\",\"bgcColor\":\"#F8F2FC\",\"isUserDefined\":false,\"text\":\"获取表单数据\",\"detail\":\"(新增无此操作)\",\"nodeInfo\":{\"processEvent\":[]}}],\"2\":[{\"color\":\"#F8625C\",\"icon\":\"#icon-jiazai\",\"bgcColor\":\"#FFF1F1\",\"isUserDefined\":false,\"text\":\"加载表单\",\"nodeInfo\":{\"processEvent\":[]}}],\"3\":[{\"color\":\"#6C6AE0\",\"icon\":\"#icon-jsontijiao\",\"bgcColor\":\"#F5F4FF\",\"isUserDefined\":false,\"text\":\"提交表单\",\"nodeInfo\":{\"processEvent\":[]}}],\"4\":[{\"color\":\"#F8625C\",\"isLast\":true,\"icon\":\"#icon-jieshuzhiliao\",\"type\":\"circle\",\"bgcColor\":\"#FFD6D6\",\"isUserDefined\":false,\"text\":\"结束节点\"}]},\"formJson\":{\"hiddenComponent\":[{\"code\":\"status\",\"label\":\"流程状态\",\"type\":\"hiddenComponent\",\"bindField\":\"status\",\"bindTable\":\"wf_document_circulation\",\"value\":\"0\",\"key\":\"hiddenComponent1712904534382\"}],\"list\":[{\"code\":null,\"rules\":[],\"label\":\"文件标题\",\"type\":\"input\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"file_title\",\"options\":{\"maxlength\":null,\"defaultValue\":\"\",\"prefix\":\"\",\"rules\":[],\"suffix\":\"\",\"addonAfter\":\"\",\"showLabel\":true,\"required\":true,\"isSave\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请输入文件标题\",\"allowClear\":false,\"addonBefore\":\"\",\"events\":{},\"span\":\"\"},\"bindTable\":\"wf_document_circulation\",\"value\":null,\"key\":\"4a26042339994f339ef9d1c9011ad758\",\"bindEndTime\":null},{\"code\":null,\"rules\":[],\"label\":\"发文单位\",\"type\":\"input\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"dispatch_unit\",\"options\":{\"maxlength\":null,\"defaultValue\":\"\",\"prefix\":\"\",\"rules\":[],\"suffix\":\"\",\"addonAfter\":\"\",\"showLabel\":true,\"required\":false,\"isSave\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请输入发文单位\",\"allowClear\":false,\"addonBefore\":\"\",\"events\":{},\"span\":\"\"},\"bindTable\":\"wf_document_circulation\",\"value\":null,\"key\":\"1e984e2f2d2941ca9da86bd1a662b185\",\"bindEndTime\":null},{\"code\":null,\"rules\":[],\"label\":\"栅格布局\",\"type\":\"grid\",\"isSubFormChild\":false,\"layout\":[{\"list\":[{\"code\":null,\"rules\":null,\"label\":\"期号\",\"type\":\"input\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"Issue_number\",\"options\":{\"maxlength\":null,\"defaultValue\":\"\",\"prefix\":\"\",\"rules\":[],\"suffix\":\"\",\"addonAfter\":\"\",\"showLabel\":true,\"required\":false,\"isSave\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请输入期号\",\"allowClear\":false,\"addonBefore\":\"\",\"events\":{},\"span\":7},\"bindTable\":\"wf_document_circulation\",\"value\":null,\"key\":\"432dabdaf575429bb374e1c4bbe57ff2\",\"bindEndTime\":null}],\"name\":null,\"span\":12},{\"list\":[{\"code\":null,\"rules\":null,\"label\":\"日期\",\"type\":\"date\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"date\",\"options\":{\"defaultValue\":\"\",\"format\":\"YYYY-MM-DD\",\"rules\":[],\"showLabel\":true,\"required\":false,\"isShow\":true,\"width\":\"100%\",\"disabled\":false,\"placeholder\":\"请选择日期\",\"allowClear\":true,\"events\":{},\"span\":7},\"bindTable\":\"wf_document_circulation\",\"value\":null,\"key\":\"60a768b3324c4e7d999d7f61cd4eaaef\",\"bindEndTime\":null}],\"name\":null,\"span\":12}],\"bindStartTime\":null,\"children\":null,\"bindField\":null,\"options\":{\"align\":\"top\",\"isShow\":true,\"gutter\":16,\"justify\":\"start\"},\"bindTable\":null,\"value\":null,\"key\":\"23d93d2c1fbb45dc9a2a163bd27ba321\",\"bindEndTime\":null},{\"code\":null,\"rules\":[],\"label\":\"附件\",\"type\":\"upload\",\"isSubFormChild\":false,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"file_id\",\"options\":{\"defaultValue\":[],\"multiple\":false,\"maxSize\":50,\"listType\":\"text\",\"showLabel\":true,\"required\":true,\"accept\":\"\",\"isShow\":true,\"maxNumber\":10,\"disabled\":false,\"events\":{},\"span\":\"\"},\"bindTable\":\"wf_document_circulation\",\"value\":null,\"key\":\"2ff6cc27a65144c68d507f554a50b39a\",\"bindEndTime\":null},{\"code\":\"status\",\"rules\":null,\"label\":\"流程状态\",\"type\":\"hiddenComponent\",\"isSubFormChild\":null,\"layout\":null,\"bindStartTime\":null,\"children\":null,\"bindField\":\"status\",\"options\":null,\"bindTable\":\"wf_document_circulation\",\"value\":\"0\",\"key\":\"hiddenComponent1712904534382\",\"bindEndTime\":null}],\"config\":{\"formType\":\"modal\",\"hideRequiredMark\":null,\"formWidth\":800,\"layout\":\"vertical\",\"size\":\"default\",\"labelAlign\":\"right\",\"labelCol\":{\"offset\":0,\"span\":3}}},\"databaseId\":\"master\"}', NULL, '文件传阅', 1000000000000000000, '2024-04-12 14:49:23.000', NULL, NULL, 0, 1, NULL, 0);
    152. 

  152.