Acasă Explorează Ajutor
Autentificare
sop
/
server
2
0
Bifurcare 0
Fisiere Probleme 0 Trageți solicitările 0 Wiki
Ramură: dev_1.1.3
Ramuri Etichete
server
/
sop-api
/
install
/
mysql
/
upgrade
/
1.1.2.sql

1.1.2.sql 26 KB
Permalink Istoric Crud

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286 
  1. USE sop_db;
    2. 

  2. 

  3. -- 2024-09-18
    4. 

  4. UPDATE sys_privilege
    5. 

  5. SET name='数据驾驶舱', url='dataCockpit', `type`='MENU', parent_id=NULL, `sequence`=11, property=NULL, related=NULL, enable=1, default_auth=0, front_display=1
    6. 

  6. WHERE id=1100;
    7. 

  7. UPDATE sys_privilege
    8. 

  8. SET name='智能客服', url='aiCustomerManage', `type`='MENU', parent_id=NULL, `sequence`=12, property=NULL, related=NULL, enable=1, default_auth=0, front_display=1
    9. 

  9. WHERE id=2053;
    10. 

  10. UPDATE sys_privilege
    11. 

  11. SET name='流程检查统计', url='FlowCheck', `type`='MENU', parent_id=1100, `sequence`=3, property=NULL, related=NULL, enable=1, default_auth=0, front_display=1
    12. 

  12. WHERE id=1101;
    13. 

  13. UPDATE sys_privilege
    14. 

  14. SET name='服务单元分析', url='serviceAnalyse', `type`='MENU', parent_id=1100, `sequence`=1, property=NULL, related=NULL, enable=1, default_auth=0, front_display=1
    15. 

  15. WHERE id=1102;
    16. 

  16. UPDATE sys_privilege
    17. 

  17. SET name='SOP预警监控', url='sopAnalyse', `type`='MENU', parent_id=1100, `sequence`=4, property=NULL, related=NULL, enable=1, default_auth=0, front_display=1
    18. 

  18. WHERE id=1103;
    19. 

  19. UPDATE sys_privilege
    20. 

  20. SET name='项目进度分析', url='sopSchedule', `type`='MENU', parent_id=1100, `sequence`=2, property=NULL, related=NULL, enable=1, default_auth=0, front_display=1
    21. 

  21. WHERE id=1104;
    22. 

  22. UPDATE sys_privilege
    23. 

  23. SET name='资源保障分析', url='deviceMonitor', `type`='MENU', parent_id=1100, `sequence`=5, property=NULL, related='1107,1108,1109,1110', enable=1, default_auth=0, front_display=1
    24. 

  24. WHERE id=1105;
    25. 

  25. UPDATE sys_privilege
    26. 

  26. SET name='质量监控分析', url='qualityAnalyse', `type`='MENU', parent_id=1100, `sequence`=6, property=NULL, related=NULL, enable=1, default_auth=0, front_display=1
    27. 

  27. WHERE id=1106;
    28. 

  28. 

  29. INSERT INTO sys_privilege
    30. 

  30. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    31. 

  31. VALUES(1107, '设备商供货数量分布接口', '/api/admin/resource/security/device_supplier_count/report', 'URL', 1105, 1, 'AUTH', NULL, 1, 1, 1);
    32. 

  32. INSERT INTO sys_privilege
    33. 

  33. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    34. 

  34. VALUES(1108, '人力数量分布接口', '/api/admin/resource/security/human_supplier_count/report', 'URL', 1105, 1, 'AUTH', NULL, 1, 1, 1);
    35. 

  35. INSERT INTO sys_privilege
    36. 

  36. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    37. 

  37. VALUES(1109, '大区考勤异常数统计接口', '/api/admin/resource/security/area_ding_exception_count/report', 'URL', 1105, 1, 'AUTH', NULL, 1, 1, 1);
    38. 

  38. INSERT INTO sys_privilege
    39. 

  39. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    40. 

  40. VALUES(1110, '人力供应商考勤异常数统计', '/api/admin/resource/security/human_ding_exception_count/report', 'URL', 1105, 1, 'AUTH', NULL, 1, 1, 1);
    41. 

  41. 

  42. -- 2024-09-20
    43. 

  43. INSERT INTO sys_privilege
    44. 

  44. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    45. 

  45. VALUES(1111, '大区经理查阅统计', '/api/admin/flow/msg/refer/area_manager/report', 'URL', 1101, 1, 'AUTH', NULL, 1, 1, 1);
    46. 

  46. INSERT INTO sys_privilege
    47. 

  47. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    48. 

  48. VALUES(1112, '区域协调人查阅统计', '/api/admin/flow/msg/refer/regional_coordinator/report', 'URL', 1101, 1, 'AUTH', NULL, 1, 1, 1);
    49. 

  49. UPDATE sys_privilege
    50. 

  50. SET name='流程检查统计', url='FlowCheck', `type`='MENU', parent_id=1100, `sequence`=3, property=NULL, related='1111,1112', enable=1, default_auth=0, front_display=1
    51. 

  51. WHERE id=1101;
    52. 

  52. 

  53. UPDATE sys_privilege
    54. 

  54. SET name='设备商供货数量分布接口', url='/api/admin/resource/security/device_supplier/report', `type`='URL', parent_id=1105, `sequence`=1, property='AUTH', related=NULL, enable=1, default_auth=1, front_display=1
    55. 

  55. WHERE id=1107;
    56. 

  56. UPDATE sys_privilege
    57. 

  57. SET name='人力数量分布接口', url='/api/admin/resource/security/human_supplier/report', `type`='URL', parent_id=1105, `sequence`=1, property='AUTH', related=NULL, enable=1, default_auth=1, front_display=1
    58. 

  58. WHERE id=1108;
    59. 

  59. UPDATE sys_privilege
    60. 

  60. SET name='大区考勤异常数统计接口', url='/api/admin/resource/security/area_ding_exception/report', `type`='URL', parent_id=1105, `sequence`=1, property='AUTH', related=NULL, enable=1, default_auth=1, front_display=1
    61. 

  61. WHERE id=1109;
    62. 

  62. UPDATE sys_privilege
    63. 

  63. SET name='人力供应商考勤异常数统计', url='/api/admin/resource/security/human_ding_exception/report', `type`='URL', parent_id=1105, `sequence`=1, property='AUTH', related=NULL, enable=1, default_auth=1, front_display=1
    64. 

  64. WHERE id=1110;
    65. 

  65. 

  66. DELETE FROM sys_privilege
    67. 

  67. WHERE id=1073;
    68. 

  68. DELETE FROM sys_privilege
    69. 

  69. WHERE id=1074;
    70. 

  70. DELETE FROM sys_privilege
    71. 

  71. WHERE id=1075;
    72. 

  72. DELETE FROM sys_privilege
    73. 

  73. WHERE id=1076;
    74. 

  74. DELETE FROM sys_privilege
    75. 

  75. WHERE id=1077;
    76. 

  76. DELETE FROM sys_privilege
    77. 

  77. WHERE id=1078;
    78. 

  78. DELETE FROM sys_privilege
    79. 

  79. WHERE id=1079;
    80. 

  80. DELETE FROM sys_privilege
    81. 

  81. WHERE id=1080;
    82. 

  82. DELETE FROM sys_privilege
    83. 

  83. WHERE id=1081;
    84. 

  84. DELETE FROM sys_privilege
    85. 

  85. WHERE id=1082;
    86. 

  86. DELETE FROM sys_privilege
    87. 

  87. WHERE id=1083;
    88. 

  88. DELETE FROM sys_privilege
    89. 

  89. WHERE id=1084;
    90. 

  90. DELETE FROM sys_privilege
    91. 

  91. WHERE id=1085;
    92. 

  92. DELETE FROM sys_privilege
    93. 

  93. WHERE id=1086;
    94. 

  94. DELETE FROM sys_privilege
    95. 

  95. WHERE id=1087;
    96. 

  96. DELETE FROM sys_privilege
    97. 

  97. WHERE id=1088;
    98. 

  98. DELETE FROM sys_privilege
    99. 

  99. WHERE id=1089;
    100. 

  100. DELETE FROM sys_privilege
    101. 

  101. WHERE id=1090;
    102. 

  102. DELETE FROM sys_privilege
    103. 

  103. WHERE id=1091;
    104. 

  104. DELETE FROM sys_privilege
    105. 

  105. WHERE id=1092;
    106. 

  106. DELETE FROM sys_privilege
    107. 

  107. WHERE id=1093;
    108. 

  108. 

  109. -- 2024-09-24
    110. 

  110. UPDATE sys_privilege
    111. 

  111. SET name='质量监控分析', url='qualityAnalyse', `type`='MENU', parent_id=1100, `sequence`=6, property=NULL, related='1113,1114,1115,1116,1117', enable=1, default_auth=0, front_display=1
    112. 

  112. WHERE id=1106;
    113. 

  113. INSERT INTO sys_privilege
    114. 

  114. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    115. 

  115. VALUES(1113, '大区质量问题统计', '/api/admin/quality/analyse/area_manager/report', 'URL', 1106, 1, 'AUTH', NULL, 1, 1, 1);
    116. 

  116. INSERT INTO sys_privilege
    117. 

  117. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    118. 

  118. VALUES(1114, '人力商质量问题统计', '/api/admin/quality/analyse/human_supplier/report', 'URL', 1106, 1, 'AUTH', NULL, 1, 1, 1);
    119. 

  119. INSERT INTO sys_privilege
    120. 

  120. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    121. 

  121. VALUES(1115, '质量问题原因分类', '/api/admin/quality/analyse/type/report', 'URL', 1106, 1, 'AUTH', NULL, 1, 1, 1);
    122. 

  122. INSERT INTO sys_privilege
    123. 

  123. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    124. 

  124. VALUES(1116, '报表详情', '/api/admin/quality/analyse/report/view', 'URL', 1106, 1, 'AUTH', NULL, 1, 1, 1);
    125. 

  125. INSERT INTO sys_privilege
    126. 

  126. (id, name, url, `type`, parent_id, `sequence`, property, related, enable, default_auth, front_display)
    127. 

  127. VALUES(1117, '报表详情导出', '/api/admin/quality/analyse/report/view/export', 'URL', 1106, 1, 'AUTH', NULL, 1, 1, 1);
    128. 

  128. 

  129. -- 2024-09-20
    130. 

  130. -- 删除以前的关联
    131. 

  131. delete from sys_privilege where id in (1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072) and parent_id=1102;
    132. 

  132. delete from sys_privilege where id in (1094,1095,1097) and parent_id=1104;
    133. 

  133. delete from sys_privilege where id in (1057,1058,1059,1060,1061) and parent_id=1103;
    134. 

  134. 

  135. -- 服务单元、项目进度监控、sop预警报表脚本
    136. 

  136. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1140, '查询条件', 'Condition', 'CONDITION', 1102, 1, 'AUTH', '1146,1147,1148', 1, 0, 1);
    137. 

  137. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1141, '查询', 'Select', 'BUTTON', 1102, 1, 'AUTH', '1146,1147,1148', 1, 0, 1);
    138. 

  138. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1142, '列表', 'List', 'LIST', 1102, 1, 'AUTH', '1146,1147,1148', 1, 1, 1);
    139. 

  139. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1143, '详情', 'Detail', 'LINK', 1102, 1, 'AUTH', '1149,1150', 1, 1, 1);
    140. 

  140. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1146, '服务单元概况接口', '/api/admin/service/analyse/overview', 'URL', 1102, 1, 'AUTH', NULL, 1, 1, 1);
    141. 

  141. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1147, '项目整体进度接口', '/api/admin/service/analyse/progress', 'URL', 1102, 2, 'AUTH', NULL, 1, 1, 1);
    142. 

  142. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1148, '区域概况接口', '/api/admin/service/analyse/province', 'URL', 1102, 3, 'AUTH', NULL, 1, 1, 1);
    143. 

  143. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1149, '详情接口', '/api/admin/service/analyse/detail', 'URL', 1102, 4, 'AUTH', NULL, 1, 1, 1);
    144. 

  144. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1150, '导出接口', '/api/admin/service/analyse/detail/export', 'URL', 1102, 5, 'AUTH', NULL, 1, 1, 1);
    145. 

  145. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1151, '查询条件', 'Condition', 'CONDITION', 1104, 1, 'AUTH', '1155,1156,1157', 1, 0, 1);
    146. 

  146. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1152, '查询', 'Select', 'BUTTON', 1104, 1, 'AUTH', '1155,1156,1157', 1, 0, 1);
    147. 

  147. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1153, '列表', 'List', 'LIST', 1104, 1, 'AUTH', '1155,1156,1157', 1, 1, 1);
    148. 

  148. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1154, '详情', 'Detail', 'LINK', 1104, 1, 'AUTH', '1149,1150', 1, 1, 1);
    149. 

  149. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1155, '按大区进度统计接口', '/api/admin/crm/process/monitor/region', 'URL', 1104, 1, 'AUTH', NULL, 1, 1, 1);
    150. 

  150. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1156, '按人力商进度统计接口', '/api/admin/crm/process/monitor/supplier', 'URL', 1104, 2, 'AUTH', NULL, 1, 1, 1);
    151. 

  151. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1157, '按区域协调人进度统计接口', '/api/admin/crm/process/monitor/coordinator', 'URL', 1104, 3, 'AUTH', NULL, 1, 1, 1);
    152. 

  152. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1160, '查询条件', 'Condition', 'CONDITION', 1103, 1, 'AUTH', '1164,1165,1166', 1, 0, 1);
    153. 

  153. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1161, '查询', 'Select', 'BUTTON', 1103, 1, 'AUTH', '1164,1165,1166', 1, 0, 1);
    154. 

  154. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1162, '列表', 'List', 'LIST', 1103, 1, 'AUTH', '1164,1165,1166', 1, 1, 1);
    155. 

  155. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1163, '详情', 'Detail', 'LINK', 1103, 1, 'AUTH', '1149,1150', 1, 1, 1);
    156. 

  156. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1164, '按大区预警统计接口', '/api/admin/sop/warn/monitor/region', 'URL', 1103, 1, 'AUTH', NULL, 1, 1, 1);
    157. 

  157. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1165, '按人力商预警统计接口', '/api/admin/sop/warn/monitor/supplier', 'URL', 1103, 2, 'AUTH', NULL, 1, 1, 1);
    158. 

  158. INSERT INTO sys_privilege(`id`, `name`, `url`, `type`, `parent_id`, `sequence`, `property`, `related`, `enable`, `default_auth`, `front_display`) VALUES (1166, '按区域协调人预警统计接口', '/api/admin/sop/warn/monitor/coordinator', 'URL', 1103, 3, 'AUTH', NULL, 1, 1, 1);
    159. 

  159. 

  160. -- 2024-10-08
    161. 

  161. UPDATE sys_privilege
    162. 

  162. SET name='服务单元分析', url='serviceAnalyse', `type`='MENU', parent_id=1100, `sequence`=1, property=NULL, related='1146,1147,1148,1149,1150', enable=1, default_auth=0, front_display=1
    163. 

  163. WHERE id=1102;
    164. 

  164. 

  165. UPDATE sys_privilege
    166. 

  166. SET name='项目进度分析', url='sopSchedule', `type`='MENU', parent_id=1100, `sequence`=2, property=NULL, related='1155,1156,1157,1149,1150', enable=1, default_auth=0, front_display=1
    167. 

  167. WHERE id=1104;
    168. 

  168. 

  169. UPDATE sys_privilege
    170. 

  170. SET name='SOP预警监控', url='sopAnalyse', `type`='MENU', parent_id=1100, `sequence`=4, property=NULL, related='1164,1165,1166,1149,1150', enable=1, default_auth=0, front_display=1
    171. 

  171. WHERE id=1103;
    172. 

  172. 

  173. DELETE FROM sys_privilege
    174. 

  174. WHERE id=1140;
    175. 

  175. DELETE FROM sys_privilege
    176. 

  176. WHERE id=1141;
    177. 

  177. DELETE FROM sys_privilege
    178. 

  178. WHERE id=1142;
    179. 

  179. DELETE FROM sys_privilege
    180. 

  180. WHERE id=1143;
    181. 

  181. 

  182. DELETE FROM sys_privilege
    183. 

  183. WHERE id=1151;
    184. 

  184. DELETE FROM sys_privilege
    185. 

  185. WHERE id=1152;
    186. 

  186. DELETE FROM sys_privilege
    187. 

  187. WHERE id=1153;
    188. 

  188. DELETE FROM sys_privilege
    189. 

  189. WHERE id=1154;
    190. 

  190. 

  191. DELETE FROM sys_privilege
    192. 

  192. WHERE id=1160;
    193. 

  193. DELETE FROM sys_privilege
    194. 

  194. WHERE id=1161;
    195. 

  195. DELETE FROM sys_privilege
    196. 

  196. WHERE id=1162;
    197. 

  197. DELETE FROM sys_privilege
    198. 

  198. WHERE id=1163;
    199. 

  199. 

  200. -- 2024-10-10
    201. 

  201. UPDATE t_d_form_widget
    202. 

  202. SET code='SINGLE_SELECT', `type`='FORM', form_id='project_manager_id', form_name='project_manager_id', title='项目经理', input_type='LONG', required=0, readable=1, writable=0, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid='/api/admin/user/archives/allocation/can_choose?crmDetailId=#{id}&sopRoleType=PROJECT_MANAGER', tips=NULL, format=NULL, span=4, sub_title=NULL, `options`=NULL, flow_type='OFFICE_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=12
    203. 

  203. WHERE id=199;
    204. 

  204. DELETE FROM sys_privilege
    205. 

  205. WHERE id=198;
    206. 

  206. UPDATE t_d_form_widget
    207. 

  207. SET code='MULTIPLE_SELECT', `type`='FORM', form_id='engineer_users_id', form_name='engineer_users_id', title='工程师', input_type='ARRAY', required=0, readable=1, writable=0, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid='/api/admin/user/archives/allocation/can_choose?crmDetailId=#{id}&sopRoleType=ENGINEER', tips=NULL, format=NULL, span=4, sub_title=NULL, `options`=NULL, flow_type='OFFICE_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=13
    208. 

  208. WHERE id=28;
    209. 

  209. UPDATE t_d_form_widget
    210. 

  210. SET code='SIGN', `type`='FORM', form_id='sign_region', form_name='sign_region', title='添加签名', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='OFFICE_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=14
    211. 

  211. WHERE id=29;
    212. 

  212. 

  213. -- 2024-10-11
    214. 

  214. UPDATE t_d_form_widget
    215. 

  215. SET code='SIGN', `type`='FORM', form_id='sign_region', form_name='sign_region', title='添加签名', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=3, handle=0, form_group=1, role_type='REGION_MANAGER', create_id=1, create_time=1
    216. 

  216. WHERE id=135;
    217. 

  217. UPDATE t_d_form_widget
    218. 

  218. SET code='SIGN', `type`='FORM', form_id='sign_project', form_name='sign_project', title='添加签名', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=3, handle=0, form_group=2, role_type='PROJECT_MANAGER', create_id=1, create_time=1
    219. 

  219. WHERE id=139;
    220. 

  220. 

  221. -- 2024-10-12
    222. 

  222. UPDATE t_d_form_widget
    223. 

  223. SET code='TEXT', `type`='FORM', form_id='problem_point', form_name='problem_point', title='问题简要', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=300, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='QUALITY_PROBLEM_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=1
    224. 

  224. WHERE id=1;
    225. 

  225. UPDATE t_d_form_widget
    226. 

  226. SET code='TEXT', `type`='FORM', form_id='verify_point', form_name='verify_point', title='核实情况简要', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='QUALITY_PROBLEM_FLOW', form_setup=2, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=1
    227. 

  227. WHERE id=4;
    228. 

  228. UPDATE t_d_form_widget
    229. 

  229. SET code='TEXT', `type`='FORM', form_id='contacts', form_name='contacts', title='联系人', input_type='STRING', required=0, readable=1, writable=0, visable=1, `scale`=NULL, `length`=100, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=6, sub_title=NULL, `options`=NULL, flow_type='OFFICE_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=5
    230. 

  230. WHERE id=22;
    231. 

  231. UPDATE t_d_form_widget
    232. 

  232. SET code='TEXT', `type`='FORM', form_id='mobile_number', form_name='mobile_number', title='电话', input_type='STRING', required=0, readable=1, writable=0, visable=1, `scale`=NULL, `length`=100, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=6, sub_title=NULL, `options`=NULL, flow_type='OFFICE_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=6
    233. 

  233. WHERE id=23;
    234. 

  234. UPDATE t_d_form_widget
    235. 

  235. SET code='TEXT', `type`='TABLE', form_id='school_college', form_name='school_college', title='项目联系人表格_机构输入框', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=100, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=3, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=25
    236. 

  236. WHERE id=113;
    237. 

  237. UPDATE t_d_form_widget
    238. 

  238. SET code='TEXT', `type`='TABLE', form_id='school_name', form_name='school_name', title='项目联系人表格_姓名输入框', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=100, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=3, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=26
    239. 

  239. WHERE id=114;
    240. 

  240. UPDATE t_d_form_widget
    241. 

  241. SET code='TEXT', `type`='TABLE', form_id='school_job', form_name='school_job', title='项目联系人表格_职务输入框', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=100, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=3, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=27
    242. 

  242. WHERE id=115;
    243. 

  243. UPDATE t_d_form_widget
    244. 

  244. SET code='TEXT', `type`='TABLE', form_id='school_tel', form_name='school_tel', title='项目联系人表格_电话输入框', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=100, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=3, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=28
    245. 

  245. WHERE id=116;
    246. 

  246. 

  247. UPDATE t_d_form_widget
    248. 

  248. SET code='TEXTAREA', `type`='FORM', form_id='problem_remark', form_name='problem_remark', title='问题情况说明', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=300, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='QUALITY_PROBLEM_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=1
    249. 

  249. WHERE id=2;
    250. 

  250. UPDATE t_d_form_widget
    251. 

  251. SET code='TEXTAREA', `type`='FORM', form_id='verify_remark', form_name='verify_remark', title='核实情况备注', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='QUALITY_PROBLEM_FLOW', form_setup=2, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=1
    252. 

  252. WHERE id=5;
    253. 

  253. UPDATE t_d_form_widget
    254. 

  254. SET code='TEXTAREA', `type`='FORM', form_id='approve_remark', form_name='approve_remark', title='备注', input_type='STRING', required=0, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='QUALITY_PROBLEM_FLOW', form_setup=3, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=1
    255. 

  255. WHERE id=14;
    256. 

  256. UPDATE t_d_form_widget
    257. 

  257. SET code='TEXTAREA', `type`='FORM', form_id='approve_remark', form_name='approve_remark', title='备注', input_type='STRING', required=0, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='QUALITY_PROBLEM_FLOW', form_setup=4, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=1
    258. 

  258. WHERE id=17;
    259. 

  259. UPDATE t_d_form_widget
    260. 

  260. SET code='TEXTAREA', `type`='FORM', form_id='other_remark', form_name='other_remark', title='其它备注（建议关注的其它方面）', input_type='STRING', required=0, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=1, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=22
    261. 

  261. WHERE id=110;
    262. 

  262. UPDATE t_d_form_widget
    263. 

  263. SET code='TEXTAREA', `type`='FORM', form_id='ramark', form_name='ramark', title='其它特殊要求', input_type='STRING', required=0, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=2, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=16
    264. 

  264. WHERE id=131;
    265. 

  265. UPDATE t_d_form_widget
    266. 

  266. SET code='TEXTAREA', `type`='FORM', form_id='approve_ramark_region', form_name='approve_ramark_region', title='审批意见', input_type='STRING', required=0, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=3, handle=0, form_group=1, role_type='REGION_MANAGER', create_id=1, create_time=1
    267. 

  267. WHERE id=136;
    268. 

  268. UPDATE t_d_form_widget
    269. 

  269. SET code='TEXTAREA', `type`='FORM', form_id='approve_ramark_project', form_name='approve_ramark_project', title='审批意见', input_type='STRING', required=0, readable=0, writable=1, visable=1, `scale`=NULL, `length`=500, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=12, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=3, handle=0, form_group=2, role_type='PROJECT_MANAGER', create_id=1, create_time=1
    270. 

  270. WHERE id=140;
    271. 

  271. 

  272. UPDATE t_d_form_widget
    273. 

  273. SET code='NUMBER', `type`='FORM', form_id='scan_page_count', form_name='scan_page_count', title='扫描张数', input_type='INT', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=3, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=9, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=8
    274. 

  274. WHERE id=195;
    275. 

  275. UPDATE t_d_form_widget
    276. 

  276. SET code='LABEL', `type`='FORM', form_id='scan_page_count_label', form_name='scan_page_count_label', title='[{"label":"操作说明","color":"black"},{"label":"1、待补充","color":"black"},{"label":"2、待补充","color":"black"},{"label":"3、待补充","color":"black"}]', input_type='STRING', required=0, readable=1, writable=0, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=6, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=9, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=9
    277. 

  277. WHERE id=196;
    278. 

  278. 

  279. -- 2024-10-14
    280. 

  280. UPDATE t_d_form_widget
    281. 

  281. SET code='LABEL', `type`='FORM', form_id='scan_page_count_label', form_name='scan_page_count_label', title='[{"label":"操作说明","color":"black"},{"label":"1、考试管理>选择对应的考试点击“详情”","color":"black"},{"label":"2、查看“扫描张数” 或者点击验收报告查看扫描总张数","color":"black"}]', input_type='STRING', required=0, readable=1, writable=0, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid=NULL, tips=NULL, format=NULL, span=6, sub_title=NULL, `options`=NULL, flow_type='CLOUD_MARK_SOP_FLOW', form_setup=9, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=9
    282. 

  282. WHERE id=196;
    283. 

  283. 

  284. UPDATE t_d_form_widget
    285. 

  285. SET code='RADIO', `type`='FORM', form_id='run_env_accord', form_name='run_env_accord', title='运行环境是否与学校沟通', input_type='STRING', required=1, readable=0, writable=1, visable=1, `scale`=NULL, `length`=NULL, binding=NULL, data_grid='https://sop-file.qmth.com.cn/logo/operation.png', tips=NULL, format=NULL, span=6, sub_title=NULL, `options`='[{"value":"YES","label":"是"},{"value":"NO","label":"否"}]', flow_type='CLOUD_MARK_SOP_FLOW', form_setup=2, handle=0, form_group=NULL, role_type=NULL, create_id=1, create_time=2
    286. 

  286. WHERE id=118;
    287.