all-project/script/sql/supplement-student-leave-approval-status-dict.sql

-- 补充学生请假审批状态字典数据脚本
-- 日期: 2025-01-27
-- 说明: 补充缺失的学生请假审批状态字典数据

-- 补充缺失的字典数据
-- 已撤销
INSERT IGNORE INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) 
VALUES (2000000000000009032, '000000', 1, '已撤销', 'cancel', 'student_leave_approval_status', '', 'info', 'N', 1, now(), '已撤销');

-- 草稿
INSERT IGNORE INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) 
VALUES (2000000000000009033, '000000', 2, '草稿', 'draft', 'student_leave_approval_status', '', 'info', 'N', 1, now(), '草稿状态');

-- 待审核
INSERT IGNORE INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) 
VALUES (2000000000000009034, '000000', 3, '待审核', 'waiting', 'student_leave_approval_status', '', 'warning', 'N', 1, now(), '待审核状态');

-- 已完成
INSERT IGNORE INTO sys_dict_data(dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) 
VALUES (2000000000000009035, '000000', 4, '已完成', 'finish', 'student_leave_approval_status', '', 'success', 'N', 1, now(), '已完成状态');

-- 验证补充结果
SELECT 
    '补充后完整字典数据' as check_item,
    dict_sort,
    dict_label,
    dict_value,
    list_class
FROM sys_dict_data 
WHERE dict_type = 'student_leave_approval_status'
ORDER BY dict_sort;