Home Explore Help
Sign In
cnbg
/
cnbg-be
4
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: a5d6d54b61
Branches Tags
cnbg-be
/
db
/
v2.0
/
220830.sql

220830.sql 19 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 
  1. -- 1.新增任务类型 库存盘点-中药颗粒剂 字段配置
    2. 

  2. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp32', '关联积分包', 1, 'domain', 1, 200, '', '', 'package_list', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    3. 

  3. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp23', '调查类别', 2, 'select', 1, 2, '', '', 'market_survey_type', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    4. 

  4. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp2', '标题', 3, 'text', 4, 50, '', '', '', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    5. 

  5. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp26', '调查对象', 4, 'inputautoselect', 1, 500, '', '', 'ent_dclx1', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    6. 

  6. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp4', '调研时间', 6, 'datetime', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    7. 

  7. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp5', '所属地区', 7, 'area', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    8. 

  8. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp31', '位置打卡', 8, 'map', 1, 200, '', '', '', '0', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    9. 

  9. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp6', '盘点表上传（请将库存调查表按示例全表拍摄上传）', 9, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    10. 

  10. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp7', '调研总结', 12, 'longtext', 5, 100, '', '', '', '0', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    11. 

  11. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp9', '监盘人签名', 10, 'sign', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    12. 

  12. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '37', 'temp10', '现场照片上传（请将库存信息屏幕/现场照片拍照上传）', 11, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-08-30 17:12:25', null, '2022-08-30 17:12:25', null);
    13. 

  13. 

  14. 

  15. -- 2.新增任务类型 调剂服务 字段配置
    16. 

  16. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp32', '关联积分包', 1, 'domain', 1, 200, '', '', 'package_list', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    17. 

  17. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp23', '医院选择', 3, 'inputautoselect', 1, 2, '', '', 'https://plat.yaoyi.net/admin/wmdahospital/listHospitalByName', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    18. 

  18. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp2', '标题', 2, 'text', 4, 50, '', '', '', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    19. 

  19. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp25', '调剂周期', 4, 'datatimerange', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    20. 

  20. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp5', '所属地区', 6, 'area', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    21. 

  21. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp6', '上传调剂单（上传调剂单的味数应与上面调剂味数相同）', 9, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    22. 

  22. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp9', '复核人签名', 10, 'sign', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    23. 

  23. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp10', '现场图片上传（至少上传一张调剂现场照片）', 11, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    24. 

  24. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp7', '调剂说明', 12, 'longtext', 5, 100, '', '', '', '0', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    25. 

  25. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp31', '位置打卡', 7, 'map', 1, 200, '', '', '', '0', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    26. 

  26. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '38', 'temp24', '调剂味数', 5, 'money', 1, 50, '', '', '', '1', null, '0', '0', 1, '2022-08-30 15:44:17', null, '2022-08-30 15:44:17', null);
    27. 

  27. 

  28. -- 3.应收账款回款-A类/B类/C类 字段配置
    29. 

  29. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp32', '关联积分包', 1, 'domain', 1, 200, '', '', 'package_list', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    30. 

  30. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp2', '标题', 2, 'text', 4, 50, '', '', '', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    31. 

  31. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp26', '回款对象', 3, 'select', 1, 2, '', '', 'payment_object', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    32. 

  32. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp4', '付款通知时间', 4, 'datatimerange', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    33. 

  33. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp5', '所属地区', 8, 'area', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    34. 

  34. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp31', '位置打卡', 9, 'map', 1, 200, '', '', '', '0', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    35. 

  35. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp6', '付款证明上传（“本级医院”请将付款通知单/银行回单全部信息拍摄上传，至少上传一张；基层诊所请将加盖财务章的付款回款清单拍摄上传，至少上传一张）', 10, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    36. 

  36. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp7', '回款说明', 11, 'longtext', 5, 100, '', '', '', '0', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    37. 

  37. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp25', '回款时间', 5, 'datatimerange', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    38. 

  38. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp8', '回款总额', 6, 'money', 1, 200, null, '', '', '1', null, '0', '0', 1, '2022-08-30 11:49:02', null, '2022-08-30 11:49:02', null);
    39. 

  39. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('3', '39', 'temp23', '回款类别', 7, 'select', 1, 2, '', '', 'payment_type', '1', null, '0', '0', 1, '2021-06-11 16:29:17', null, '2021-06-11 16:29:16', null);
    40. 

  40. 

  41. -- 4.字典项task_filed_type 值新增 sign 签名，datatimerange 时间范围
    42. 

  42. -- 5.字典项score_task_type 值新增 p-17 专项服务
    43. 

  43. 

  44. -- 6.新增任务类型 库存盘点-中药颗粒剂/调剂服务/应收账款回款-A类/应收账款回款-B类/应收账款回款-C类
    45. 

  45. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id, durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user, status, base_id, real_flag, rule_id, parent_id) VALUES (37, '库存盘点-中药颗粒剂', '1', 0, 5000, 5000, null, null, null, null, 0, '0', 1, '2022-08-29 16:10:00', null, '2022-08-29 16:08:01', 0, 0, '库存调查', null, '1', 'p-3');
    46. 

  46. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id, durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user, status, base_id, real_flag, rule_id, parent_id) VALUES (38, '调剂服务', '1', 0, 500, 200, null, null, null, null, 0, '0', 1, '2022-09-02 15:15:47', null, '2022-09-02 17:02:25', 0, 0, '专项服务', null, '1', 'p-17');
    47. 

  47. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id, durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user, status, base_id, real_flag, rule_id, parent_id) VALUES (39, '应收账款回款-A类', '1', 0, 25, 25, null, null, null, null, 0, '0', 1, '2022-09-02 15:15:46', null, '2022-08-29 16:08:01', 0, 0, '专项服务', null, '1', 'p-17');
    48. 

  48. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id, durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user, status, base_id, real_flag, rule_id, parent_id) VALUES (40, '应收账款回款-B类', '1', 0, 50, 40, null, null, null, null, 0, '0', 1, '2022-09-02 15:15:47', null, '2022-09-02 17:02:26', 0, 0, '专项服务', null, '1', 'p-17');
    49. 

  49. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id, durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user, status, base_id, real_flag, rule_id, parent_id) VALUES (41, '应收账款回款-C类', '1', 0, 75, 75, null, null, null, null, 0, '0', 1, '2022-09-02 15:15:47', null, '2022-09-02 17:02:26', 0, 0, '专项服务', null, '1', 'p-17');
    50. 

  50. -- 7.记得把上面新增的任务类型 同步给所有企业!!!
    51.