shanxia/crm/backend/sql/crm_invalid_reason_dict.sql

-- ====================================================
-- CRM合同作废原因字典配置
-- ====================================================

-- 1. 添加字典类型
INSERT INTO sys_dict_type (dict_id, tenant_id, dict_name, dict_type, create_dept, create_by, create_time, remark)
VALUES (1100, '000000', '合同作废原因', 'crm_invalid_reason', 103, 1, sysdate(), 'CRM合同作废原因字典');

-- 2. 添加字典数据
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark)
VALUES (11001, '000000', 1, '客户取消订单', 'customer_cancel', 'crm_invalid_reason', '', 'danger', 'N', 103, 1, sysdate(), '客户主动取消订单');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark)
VALUES (11002, '000000', 2, '商务条件变化', 'business_change', 'crm_invalid_reason', '', 'warning', 'N', 103, 1, sysdate(), '商务条件或环境发生重大变化');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark)
VALUES (11003, '000000', 3, '合同条款争议', 'contract_dispute', 'crm_invalid_reason', '', 'danger', 'N', 103, 1, sysdate(), '双方对合同条款存在争议');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark)
VALUES (11004, '000000', 4, '无法履约', 'unable_perform', 'crm_invalid_reason', '', 'danger', 'N', 103, 1, sysdate(), '由于各种原因无法履行合同');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark)
VALUES (11005, '000000', 5, '重复签订', 'duplicate', 'crm_invalid_reason', '', 'warning', 'N', 103, 1, sysdate(), '合同重复签订');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark)
VALUES (11006, '000000', 6, '录入错误', 'input_error', 'crm_invalid_reason', '', 'info', 'N', 103, 1, sysdate(), '合同录入时出现错误');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_dept, create_by, create_time, remark)
VALUES (11007, '000000', 7, '其他原因', 'other', 'crm_invalid_reason', '', 'info', 'N', 103, 1, sysdate(), '其他未列出的作废原因');

-- ====================================================
-- 使用说明：
-- 1. 在合同作废时，用户需要选择作废原因
-- 2. 作废原因会记录在合同的 invalid_reason 字段中
-- 3. 详细说明会记录在合同的 remark 字段中
-- ====================================================