shanxia2.0/backend/scripts/migrate_20260816_crm_settlement_method_options.sql

-- backend/scripts/migrate_20260816_crm_settlement_method_options.sql
-- 合同结算方式：按量结算 / 月结 / 季结 / 其他
-- 可重复执行（幂等）

INSERT INTO `sys_dict_data` (
  `id`, `dict_label`, `dict_value`, `tag_type`, `dict_type`, `tenant_no`,
  `order_num`, `remark`, `create_by`, `create_dept_id`, `create_time`,
  `update_by`, `update_time`, `del_flag`
) VALUES
(
  'SXDC20260816SETTLE00000000000001', '按量结算', 'volume_settlement', '',
  'crm_settlement_method', 'shanxia2.0', 2, '', '1', '', NOW(), NULL, NOW(), 0
),
(
  'SXDC20260816SETTLE00000000000002', '月结', 'monthly_settlement', '',
  'crm_settlement_method', 'shanxia2.0', 3, '', '1', '', NOW(), NULL, NOW(), 0
),
(
  'SXDC20260816SETTLE00000000000003', '季结', 'quarterly_settlement', '',
  'crm_settlement_method', 'shanxia2.0', 4, '', '1', '', NOW(), NULL, NOW(), 0
),
(
  'SXDC20260816SETTLE00000000000004', '其他', 'other_settlement', '',
  'crm_settlement_method', 'shanxia2.0', 5, '', '1', '', NOW(), NULL, NOW(), 0
)
ON DUPLICATE KEY UPDATE
  `dict_label` = VALUES(`dict_label`),
  `dict_value` = VALUES(`dict_value`),
  `dict_type` = VALUES(`dict_type`),
  `tenant_no` = VALUES(`tenant_no`),
  `order_num` = VALUES(`order_num`),
  `del_flag` = 0,
  `update_time` = NOW();