Головна сторінка Огляд Довідка
Увійти
sxzgd
/
java-insagent-pc
3
1
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: b111c72003
Гілки Теги
java-insagent-p...
/
sql
/
Online.sql

Online.sql 33 KB
Історія Запис

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268 
  1. --  2024-04-15    武鸿鹏  结算需求
    2. 

  2. ALTER TABLE `ins_ply_income`  ADD COLUMN `voucher_number` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '凭证号' AFTER `create_time`;
    3. 

  3. ALTER TABLE `ins_ply_income`  ADD COLUMN `contract_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '合同号' AFTER `voucher_number`;
    4. 

  4. ALTER TABLE `ins_ply_income`  ADD COLUMN `contract_file_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '合同附件id' AFTER `contract_id`;
    5. 

  5. ALTER TABLE `ins_ply_income`  ADD COLUMN `handling_fees_status` varchar(5) NULL COMMENT '手续费结算状态  1 为已结算' AFTER `contract_file_id`;
    6. 

  6. ALTER TABLE `ins_ply_income` ADD COLUMN `documentary_fees_status` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '跟单费结算状态  1 为已结算' AFTER `handling_fees_status`;
    7. 

  7. ALTER TABLE `ins_ply_income` ADD COLUMN `is_not_car` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '跟单费结算状态  1 为已结算' AFTER `documentary_fees_status`;
    8. 

  8. ALTER TABLE `ins_ply_income` ADD COLUMN `no_policyno` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '非车保单号' AFTER `is_not_car`;
    9. 

  9. ALTER TABLE `ins_ply_income` ADD COLUMN `sy_policyno` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商业保单号' AFTER `no_policyno`;
    10. 

  10. 

  11. 

  12. DROP TABLE IF EXISTS `settlement_documentary_fees`;
    13. 

  13. CREATE TABLE `settlement_documentary_fees`  (
    14. 

  14.                                                 `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
    15. 

  15.                                                 `total_orders` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '结算单数',
    16. 

  16.                                                 `time_frame` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '时间范围',
    17. 

  17.                                                 `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '结算总金额',
    18. 

  18.                                                 `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    19. 

  19.                                                 `start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
    20. 

  20.                                                 `end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
    21. 

  21.                                                 `settlement_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '结算金额',
    22. 

  22.                                                 `unsettled_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '未结算金额',
    23. 

  23.                                                 `company_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '保险公司id',
    24. 

  24.                                                 `signing_time` datetime(0) NULL DEFAULT NULL COMMENT '签单日期',
    25. 

  25.                                                 PRIMARY KEY (`id`) USING BTREE,
    26. 

  26.                                                 UNIQUE INDEX `id`(`id`) USING BTREE
    27. 

  27. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '跟单费结算' ROW_FORMAT = Dynamic;
    28. 

  28. 

  29. SET FOREIGN_KEY_CHECKS = 1;
    30. 

  30. 

  31. 

  32. DROP TABLE IF EXISTS `settlement_documentary_log`;
    33. 

  33. CREATE TABLE `settlement_documentary_log`  (
    34. 

  34.                                                `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
    35. 

  35.                                                `amount_type` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '金额类型 1 手续费结算 2 跟单费结算',
    36. 

  36.                                                `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '金额',
    37. 

  37.                                                `settlement_documentary_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联跟单费id',
    38. 

  38.                                                `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    39. 

  39.                                                `handing_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '手续费结算金额',
    40. 

  40.                                                PRIMARY KEY (`id`) USING BTREE,
    41. 

  41.                                                UNIQUE INDEX `id`(`id`) USING BTREE
    42. 

  42. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '跟单费结算' ROW_FORMAT = Dynamic;
    43. 

  43. 

  44. SET FOREIGN_KEY_CHECKS = 1;
    45. 

  45. 

  46. --     菜单sql   结算菜单   提现菜单
    47. 

  47. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (643, '手续费待提现', '663', '/financialManagement/withdrawalManagement/withdrawalProceduresPending', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    48. 

  48. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (645, '非跟单待提现', '665', '/financialManagement/withdrawalManagement/nonDocumentaryPending', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    49. 

  49. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (646, '推广待提现', '664', '/financialManagement/withdrawalManagement/generalizationPending', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    50. 

  50. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (647, '手续费已提现', '663', '/financialManagement/withdrawalManagement/withdrawalProceduresEnd', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    51. 

  51. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (648, '非跟单已提现', '665', '/financialManagement/withdrawalManagement/nonDocumentaryEnd', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    52. 

  52. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (649, '推广已提现', '664', '/financialManagement/withdrawalManagement/generalizationEnd', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    53. 

  53. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (650, '审核并支付', '643', NULL, 'sys:withdrawalProceduresPending:examine', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    54. 

  54. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (651, '审核提现', '643', NULL, 'sys:withdrawalProceduresPending:examinepay', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    55. 

  55. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (652, '审核并支付', '645', NULL, 'sys:nonDocumentaryPending:examine', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    56. 

  56. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (653, '审核提现', '645', NULL, 'sys:nonDocumentaryPending:examinepay', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    57. 

  57. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (654, '审核提现', '646', NULL, 'sys:generalizationPending:examinepay', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    58. 

  58. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (655, '审核并支付', '646', NULL, 'sys:generalizationPending:examine', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    59. 

  59. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (663, '手续费提现', '201', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    60. 

  60. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (664, '推广费提现', '201', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    61. 

  61. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (665, '非跟单费提现', '201', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    62. 

  62. 

  63. 

  64. 

  65. --  inv_source表 新增修改人名字 修改人id  前端还没联调  正式库先不加字段
    66. 

  66. ALTER TABLE `inv_source` ADD COLUMN `update_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '修改人名字' AFTER `revenue_userid`;
    67. 

  67. ALTER TABLE `inv_source` ADD COLUMN `update_userid` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '修改人id' AFTER `update_name`;
    68. 

  68. 

  69. 

  70. 

  71. --  add by hxl   2024-04-18 添加后线人员关联协议表
    72. 

  72. DROP TABLE IF EXISTS `sys_user_link_pl_agreement`;
    73. 

  73. CREATE TABLE `sys_user_link_pl_agreement`  (
    74. 

  74.                                                `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键/自增',
    75. 

  75.                                                `user_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前线用户ID',
    76. 

  76.                                                `ptl_agreement_id` bigint(20) NULL DEFAULT NULL COMMENT '协议ID',
    77. 

  77.                                                `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
    78. 

  78.                                                `create_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
    79. 

  79.                                                `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    80. 

  80.                                                `update_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
    81. 

  81.                                                `update_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人名称',
    82. 

  82.                                                `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
    83. 

  83.                                                `type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '协议类型  0 车险 1 非车',
    84. 

  84.                                                PRIMARY KEY (`id`) USING BTREE,
    85. 

  85.                                                INDEX `user_id_index`(`user_id`) USING BTREE,
    86. 

  86.                                                INDEX `ptl_agreement_id_index`(`ptl_agreement_id`) USING BTREE
    87. 

  87. ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后线人员关联协议表' ROW_FORMAT = DYNAMIC;
    88. 

  88. 

  89. --  add by hxl   2024-04-18 添加子订单表操作人和操作时间和操作人名称
    90. 

  90. ALTER TABLE ins_area_company ADD COLUMN operator_id VARCHAR(30) COMMENT '操作人';
    91. 

  91. ALTER TABLE ins_area_company ADD COLUMN operator_name VARCHAR(100) COMMENT '操作人名称';
    92. 

  92. ALTER TABLE ins_area_company ADD COLUMN operator_time datetime COMMENT '操作时间';
    93. 

  93. 

  94. --  add  by  hxl  2024-04-18 添加子订单转发收回记录表
    95. 

  95. DROP TABLE IF EXISTS `ins_order_set_user_his`;
    96. 

  96. CREATE TABLE `ins_order_set_user_his`  (
    97. 

  97.                                            `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键/自增',
    98. 

  98.                                            `orderno` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号',
    99. 

  99.                                            `quoteno` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报价单号',
    100. 

  100.                                            `old_operator_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原操作人',
    101. 

  101.                                            `new_operator_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现操作人',
    102. 

  102.                                            `create_time` datetime NULL DEFAULT NULL COMMENT '操作时间',
    103. 

  103.                                            `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    104. 

  104.                                            `suborder_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子订单id',
    105. 

  105.                                            `old_operator_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原操作人名称',
    106. 

  106.                                            `new_operator_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现操作人名称',
    107. 

  107.                                            `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    108. 

  108.                                            PRIMARY KEY (`id`) USING BTREE
    109. 

  109. ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '子订单转发收回记录表' ROW_FORMAT = DYNAMIC;
    110. 

  110. 

  111. 

  112. --  add  by  hy  2024-04-19 添加协议授权表
    113. 

  113. DROP TABLE IF EXISTS `ptl_agreement_dept_history`;
    114. 

  114. CREATE TABLE `ptl_agreement_dept_history`  (
    115. 

  115.                                                `agreement_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '协议ID',
    116. 

  116.                                                `dept_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门ID',
    117. 

  117.                                                `batch` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次'
    118. 

  118. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    119. 

  119. 

  120. --  add by hy   2024-04-19 添加协议表产品类型字段
    121. 

  121. ALTER TABLE ptl_agreement ADD COLUMN products_code VARCHAR(30) COMMENT '产品类型';
    122. 

  122. 

  123. -- add by hxl  2024-04-19  添加后线人员协议配置菜单
    124. 

  124. INSERT INTO `sys_menu` (`name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES ('后线人员协议配置', '232', '/agreementManage/carInsurance/backlineAllocation', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    125. 

  125. 

  126. --  add by hxl   2024-04-18 添加子订单表新操作人和新操作人名称
    127. 

  127. ALTER TABLE ins_area_company ADD COLUMN new_operator_id VARCHAR(30) COMMENT '新操作人';
    128. 

  128. ALTER TABLE ins_area_company ADD COLUMN new_operator_name VARCHAR(100) COMMENT '新操作人名称';
    129. 

  129. 

  130. 

  131. -- 2024-0419  武鸿鹏
    132. 

  132. ALTER TABLE `settlement_documentary_log` ADD COLUMN `company_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '保险公司id' AFTER `handing_amount`;
    133. 

  133. ALTER TABLE `settlement_documentary_log` ADD COLUMN `year` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '年度' AFTER `company_id`;
    134. 

  134. ALTER TABLE `ins_ply_income` ADD COLUMN `is_not_documentary` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '是否是跟单' AFTER `is_not_car`;
    135. 

  135. 

  136. 

  137. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (663, '手续费提现', '201', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    138. 

  138. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (664, '推广费提现', '201', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    139. 

  139. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (665, '非跟单费提现', '201', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    140. 

  140. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (667, '车险结算', '200', '/financialManagement/carInsurance/platformSettlement/carInsuranceBalance', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    141. 

  141. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (668, '非车结算', '200', '/financialManagement/carInsurance/platformSettlement/nonVehicleBalance', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    142. 

  142. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (669, '车险', '199', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    143. 

  143. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (670, '非车', '199', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, 0);
    144. 

  144. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (671, '手续费结算', '669', '/financialManagement/carInsurance/companySettlement/carInsurance/handlingFees', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    145. 

  145. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (672, '手续费结算', '670', '/financialManagement/carInsurance/companySettlement/noCarInsurance/handlingFees', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    146. 

  146. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (673, '跟单费结算', '669', '/financialManagement/carInsurance/companySettlement/carInsurance/documentaryFees', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    147. 

  147. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (674, '跟单费结算', '670', '/financialManagement/carInsurance/companySettlement/noCarInsurance/documentaryFees', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    148. 

  148. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (677, '结算', '673', NULL, 'sys:documentaryFees1:balance', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    149. 

  149. INSERT INTO `sys_menu`(`id`, `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES (678, '结算', '674', NULL, 'sys:documentaryFees2:balance', 2, NULL, 0, NULL, NULL, NULL, NULL, 0);
    150. 

  150. 

  151. 

  152. --  2024-0422   武鸿鹏
    153. 

  153. ALTER TABLE `settlement_documentary_log` ADD COLUMN `crud_status` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '操作表示 1.新增 2 修改  3 删除' AFTER `handing_amount`;
    154. 

  154. 

  155. -- add by hxl  2024-04-22 添加渠道、保险公司、代理人任务池菜单
    156. 

  156. INSERT INTO `sys_menu` ( `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES ('任务池（渠道）', '64', '/task/taskPoolChannel', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    157. 

  157. INSERT INTO `sys_menu` (`name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES ('任务池（保险公司）', '64', '/task/companyPoolChannel', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    158. 

  158. INSERT INTO `sys_menu` ( `name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES ( '任务池（代理人）', '64', '/task/agentPoolChannel', NULL, 1, NULL, 0, NULL, NULL, NULL, NULL, 0);
    159. 

  159. 

  160. 

  161. 

  162. -- 添加出口手续费比例
    163. 

  163. ALTER TABLE `ptl_agreement_product_costs_new`
    164. 

  164. ADD COLUMN `jq_costs_export_proportion` varchar(64) NULL DEFAULT 0  COMMENT '出口手续费比例（交强）' AFTER `jq_car_other_costs_proportion`;
    165. 

  165. ADD COLUMN `sy_costs_export_proportion` varchar(64) NULL DEFAULT 0  COMMENT '出口手续费比例（商业）' AFTER `sy_car_other_costs_proportion`;
    166. 

  166. ADD COLUMN `no_costs_export_proportion` varchar(64) NULL DEFAULT 0  COMMENT '出口手续费比例（非车）' AFTER `no_car_other_costs_proportion`;
    167. 

  167. 

  168. -- 协议添加审核状态
    169. 

  169. ALTER TABLE `ptl_agreement`
    170. 

  170. ADD COLUMN `audit_type` tinyint(1) NULL DEFAULT 1 COMMENT '审核状态 1 人工审核 2 自动审核' AFTER `underwriting_description`;
    171. 

  171. 

  172. -- 费用表 添加出口比例
    173. 

  173. ALTER TABLE `ins_fee_order_new`
    174. 

  174. ADD COLUMN `jq_costs_export_proportion` decimal(10, 2) NULL DEFAULT 0 COMMENT '交强出口比例' AFTER `no_dept_premiums_level_5`;
    175. 

  175. ADD COLUMN `sy_costs_export_proportion` decimal(10, 2) NULL DEFAULT 0 COMMENT '商业出口比例' AFTER `jq_costs_export_proportion`;
    176. 

  176. ADD COLUMN `no_costs_export_proportion` decimal(10, 2) NULL DEFAULT 0 COMMENT '非车出口比例' AFTER `sy_costs_export_proportion`;
    177. 

  177. 

  178. 

  179. -- 添加手续费修改历史表
    180. 

  180. DROP TABLE IF EXISTS `ins_fee_order_new_record`;
    181. 

  181. CREATE TABLE `ins_fee_order_new_record`  (
    182. 

  182.                                              `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
    183. 

  183.                                              `fee_order_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '关联ins_fee_order_new id',
    184. 

  184.                                              `costs_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用费用id',
    185. 

  185.                                              `jq_costs_proportion_old` decimal(10, 2) NULL DEFAULT NULL COMMENT '交强险费用比例历史',
    186. 

  186.                                              `jq_costs_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '交强险费用比例',
    187. 

  187.                                              `sy_costs_proportion_old` decimal(10, 2) NULL DEFAULT NULL COMMENT '商业险费用比例历史',
    188. 

  188.                                              `sy_costs_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '商业险费用比例',
    189. 

  189.                                              `no_costs_proportion_old` decimal(10, 2) NULL DEFAULT NULL COMMENT '非车险费用比例历史',
    190. 

  190.                                              `no_costs_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '非车险费用比例',
    191. 

  191.                                              `jq_supervise_costs_proportion_old` decimal(10, 2) NULL DEFAULT NULL COMMENT '交强监管费比例历史',
    192. 

  192.                                              `jq_supervise_costs_proportion` decimal(10, 2) NULL DEFAULT NULL COMMENT '交强监管费比例',
    193. 

  193.                                              `sy_supervise_costs_proportion_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业监管费比例历史',
    194. 

  194.                                              `sy_supervise_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业监管费比例',
    195. 

  195.                                              `no_supervise_costs_proportion_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车监管费比例历史',
    196. 

  196.                                              `no_supervise_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车监管费比例',
    197. 

  197.                                              `jq_other_costs_proportion_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强其他费用比例历史',
    198. 

  198.                                              `jq_other_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强其他费用比例',
    199. 

  199.                                              `sy_other_costs_proportion_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业其他费用比例历史',
    200. 

  200.                                              `sy_other_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业其他费用比例',
    201. 

  201.                                              `no_other_costs_proportion_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车其他费用比例历史',
    202. 

  202.                                              `no_other_costs_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车其他费用比例',
    203. 

  203.                                              `jq_dept_proportion_level_1_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强一级机构管理费比例历史',
    204. 

  204.                                              `jq_dept_proportion_level_1` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强一级机构管理费比例',
    205. 

  205.                                              `sy_dept_proportion_level_1_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业一级机构管理费比例历史',
    206. 

  206.                                              `sy_dept_proportion_level_1` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业一级机构管理费比例',
    207. 

  207.                                              `no_dept_proportion_level_1_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车一级机构管理费比例历史',
    208. 

  208.                                              `no_dept_proportion_level_1` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车一级机构管理费比例',
    209. 

  209.                                              `jq_dept_proportion_level_2_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强二级机构管理费比例历史',
    210. 

  210.                                              `jq_dept_proportion_level_2` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强二级机构管理费比例',
    211. 

  211.                                              `sy_dept_proportion_level_2_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业二级机构管理费比例历史',
    212. 

  212.                                              `sy_dept_proportion_level_2` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业二级机构管理费比例',
    213. 

  213.                                              `no_dept_proportion_level_2_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车二级机构管理费比例历史',
    214. 

  214.                                              `no_dept_proportion_level_2` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车二级机构管理费比例',
    215. 

  215.                                              `jq_dept_proportion_level_3_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强三级机构管理费比例历史',
    216. 

  216.                                              `jq_dept_proportion_level_3` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强三级机构管理费比例',
    217. 

  217.                                              `sy_dept_proportion_level_3_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业三级机构管理费比例历史',
    218. 

  218.                                              `sy_dept_proportion_level_3` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业三级机构管理费比例',
    219. 

  219.                                              `no_dept_proportion_level_3_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车三级机构管理费比例历史',
    220. 

  220.                                              `no_dept_proportion_level_3` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车三级机构管理费比例',
    221. 

  221.                                              `jq_dept_proportion_level_4_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强四级机构管理费比例历史',
    222. 

  222.                                              `jq_dept_proportion_level_4` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强四级机构管理费比例',
    223. 

  223.                                              `sy_dept_proportion_level_4_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业四级机构管理费比例历史',
    224. 

  224.                                              `sy_dept_proportion_level_4` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业四级机构管理费比例',
    225. 

  225.                                              `no_dept_proportion_level_4_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车四级机构管理费比例历史',
    226. 

  226.                                              `no_dept_proportion_level_4` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车四级机构管理费比例',
    227. 

  227.                                              `jq_dept_proportion_level_5_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强五级机构管理费比例历史',
    228. 

  228.                                              `jq_dept_proportion_level_5` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '交强五级机构管理费比例',
    229. 

  229.                                              `sy_dept_proportion_level_5_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业五级机构管理费比例历史',
    230. 

  230.                                              `sy_dept_proportion_level_5` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '商业五级机构管理费比例',
    231. 

  231.                                              `no_dept_proportion_level_5_old` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车五级机构管理费比例历史',
    232. 

  232.                                              `no_dept_proportion_level_5` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '非车五级机构管理费比例',
    233. 

  233.                                              `first_detail_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '一级分销比例',
    234. 

  234.                                              `second_detail_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '二级分销比例',
    235. 

  235.                                              `third_detail_proportion` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '三级分销比例',
    236. 

  236.                                              `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    237. 

  237.                                              PRIMARY KEY (`id`) USING BTREE,
    238. 

  238.                                              INDEX `ins_order_no`(`fee_order_id`) USING BTREE
    239. 

  239. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '调整费用后的记录' ROW_FORMAT = Dynamic;
    240. 

  240. 

  241. -- 费用添加创建时间 创建人
    242. 

  242. ALTER TABLE `ptl_agreement_product_costs_new`
    243. 

  243. ADD COLUMN `create_time` datetime NULL COMMENT '创建时间' AFTER `costs_end_date`,
    244. 

  244. ADD COLUMN `create_by` varchar(30) NULL COMMENT '创建人' AFTER `create_time`;
    245. 

  245. -- 费用表 添加审核信息
    246. 

  246. ADD COLUMN `is_audit` tinyint(1) NULL DEFAULT 0 COMMENT '是否审核 0未审核 1审核成功 2驳回' AFTER `priority_level`;
    247. 

  247. ADD COLUMN `reject` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '驳回信息' AFTER `is_audit`;
    248. 

  248. ADD COLUMN `audit_person` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核人' AFTER `reject`;
    249. 

  249. ADD COLUMN `audit_time` datetime NULL DEFAULT NULL COMMENT '审核时间' AFTER `audit_person`;
    250. 

  250. 

  251. 

  252. -- 费用表添加 出口手续费比例
    253. 

  253. ALTER TABLE `ins_fee_order_new`
    254. 

  254.     ADD COLUMN `jq_costs_export_proportion` decimal(10, 2) NULL DEFAULT 0 COMMENT '交强出口手续费比例' AFTER `no_dept_premiums_level_5`,
    255. 

  255.     ADD COLUMN `sy_costs_export_proportion` decimal(10, 2) NULL DEFAULT 0 COMMENT '商业出口手续费比例' AFTER `jq_costs_export_proportion`,
    256. 

  256.     ADD COLUMN `no_costs_export_proportion` decimal(10, 2) NULL DEFAULT 0 COMMENT '非车出口手续费比例' AFTER `sy_costs_export_proportion`;
    257. 

  257. 

  258. 

  259. -- 协议费用审核菜单
    260. 

  260. INSERT INTO `sys_menu` (`name`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `del_flag`) VALUES ('协议费用审核', '232', 'agreementManage/carInsurance/productCostExamine', NULL, 1, NULL, 3, NULL, NULL, NULL, NULL, 0);
    261. 

  261. 

  262. -- 字典表 协议状态审核
    263. 

  263. INSERT INTO `sys_dict` (`id`, `value`, `label`, `itemname`, `description`, `sort`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `remarks`, `del_flag`, `create_user_id`, `update_user_id`, `update_time`) VALUES (157, '0', '未审核', 'agreement_audit_status', 'desc', 0, NULL, NULL, NULL, NULL, 'remark', 0, 0, 0, '2024-04-17 09:06:16');
    264. 

  264. INSERT INTO `sys_dict` (`id`, `value`, `label`, `itemname`, `description`, `sort`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `remarks`, `del_flag`, `create_user_id`, `update_user_id`, `update_time`) VALUES (158, '1', '审核通过', 'agreement_audit_status', 'desc', 0, NULL, NULL, NULL, NULL, 'remark', 0, 0, 0, '2024-04-17 09:06:34');
    265. 

  265. INSERT INTO `sys_dict` (`id`, `value`, `label`, `itemname`, `description`, `sort`, `create_by`, `create_time`, `last_update_by`, `last_update_time`, `remarks`, `del_flag`, `create_user_id`, `update_user_id`, `update_time`) VALUES (159, '2', '驳回', 'agreement_audit_status', 'desc', 0, NULL, NULL, NULL, NULL, 'remark', 0, 0, 0, '2024-04-17 09:07:00');
    266. 

  266. 

  267. -- 字典类型表  协议审核
    268. 

  268. INSERT INTO `sys_dict_type` (`id`, `name`, `parent_id`, `itemname`, `description`, `create_time`, `update_time`, `remarks`, `del_flag`, `tenant_id`) VALUES ('102009', '协议审核状态', '102', 'agreement_audit_status', NULL, '2024-04-17 09:09:30', '2024-04-17 09:09:30', NULL, '0', 0);
    269.