all-project/backend/script/sql/fix_all_graduate_dicts.sql

-- ==================================================
-- 修复所有毕业生相关字典数据 - 解决下拉框为空问题
-- 创建日期: 2025-01-26
-- 说明: 修复所有使用过大dict_code值的毕业生相关字典数据
-- ==================================================

-- 1. 查看所有需要修复的字典类型
SELECT '=== 需要修复的字典类型统计 ===' as info;
SELECT dict_type, COUNT(*) as count, MIN(dict_code) as min_code, MAX(dict_code) as max_code
FROM sys_dict_data
WHERE dict_type IN (
    'zsjy_graduate_employment_status',
    'zsjy_graduate_company_type',
    'zsjy_graduate_salary_range',
    'zsjy_graduate_audit_status'
)
GROUP BY dict_type;

-- 2. 修复毕业生就业状态字典
DELETE FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_employment_status';
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, update_by, update_time, remark
) VALUES
(220, '000000', 1, '待就业', '1', 'zsjy_graduate_employment_status', NULL, 'info', 'N', NULL, 103, NOW(), 103, NOW(), '未确定就业状态'),
(221, '000000', 2, '已签约', '2', 'zsjy_graduate_employment_status', NULL, 'success', 'N', NULL, 103, NOW(), 103, NOW(), '已签署就业协议'),
(222, '000000', 3, '升学', '3', 'zsjy_graduate_employment_status', NULL, 'primary', 'N', NULL, 103, NOW(), 103, NOW(), '继续深造学习'),
(223, '000000', 4, '出国', '4', 'zsjy_graduate_employment_status', NULL, 'warning', 'N', NULL, 103, NOW(), 103, NOW(), '出国留学或工作'),
(224, '000000', 5, '自主创业', '5', 'zsjy_graduate_employment_status', NULL, 'danger', 'N', NULL, 103, NOW(), 103, NOW(), '自主创业'),
(225, '000000', 6, '灵活就业', '6', 'zsjy_graduate_employment_status', NULL, 'info', 'N', NULL, 103, NOW(), 103, NOW(), '灵活就业'),
(226, '000000', 7, '暂不就业', '7', 'zsjy_graduate_employment_status', NULL, 'info', 'N', NULL, 103, NOW(), 103, NOW(), '暂不就业'),
(227, '000000', 8, '其他', '8', 'zsjy_graduate_employment_status', NULL, 'info', 'N', NULL, 103, NOW(), 103, NOW(), '其他情况');

-- 3. 修复就业单位性质字典
DELETE FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_company_type';
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, update_by, update_time, remark
) VALUES
(230, '000000', 1, '国有企业', '1', 'zsjy_graduate_company_type', NULL, 'primary', 'N', NULL, 103, NOW(), 103, NOW(), '国有企业'),
(231, '000000', 2, '私营企业', '2', 'zsjy_graduate_company_type', NULL, 'success', 'N', NULL, 103, NOW(), 103, NOW(), '私营企业'),
(232, '000000', 3, '外资企业', '3', 'zsjy_graduate_company_type', NULL, 'warning', 'N', NULL, 103, NOW(), 103, NOW(), '外资企业'),
(233, '000000', 4, '事业单位', '4', 'zsjy_graduate_company_type', NULL, 'info', 'N', NULL, 103, NOW(), 103, NOW(), '事业单位'),
(234, '000000', 5, '政府机关', '5', 'zsjy_graduate_company_type', NULL, 'danger', 'N', NULL, 103, NOW(), 103, NOW(), '政府机关');

-- 4. 修复月薪范围字典
DELETE FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_salary_range';
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, update_by, update_time, remark
) VALUES
(240, '000000', 1, '3000以下', '1', 'zsjy_graduate_salary_range', NULL, 'info', 'N', NULL, 103, NOW(), 103, NOW(), '月薪3000元以下'),
(241, '000000', 2, '3000-5000', '2', 'zsjy_graduate_salary_range', NULL, 'primary', 'N', NULL, 103, NOW(), 103, NOW(), '月薪3000-5000元'),
(242, '000000', 3, '5000-8000', '3', 'zsjy_graduate_salary_range', NULL, 'success', 'N', NULL, 103, NOW(), 103, NOW(), '月薪5000-8000元'),
(243, '000000', 4, '8000-12000', '4', 'zsjy_graduate_salary_range', NULL, 'warning', 'N', NULL, 103, NOW(), 103, NOW(), '月薪8000-12000元'),
(244, '000000', 5, '12000以上', '5', 'zsjy_graduate_salary_range', NULL, 'danger', 'N', NULL, 103, NOW(), 103, NOW(), '月薪12000元以上');

-- 5. 修复毕业生信息审核状态字典
DELETE FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_audit_status';
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, update_by, update_time, remark
) VALUES
(250, '000000', 1, '待审核', '0', 'zsjy_graduate_audit_status', NULL, 'info', 'Y', NULL, 103, NOW(), 103, NOW(), '待审核状态'),
(251, '000000', 2, '审核通过', '1', 'zsjy_graduate_audit_status', NULL, 'success', 'N', NULL, 103, NOW(), 103, NOW(), '审核通过'),
(252, '000000', 3, '审核拒绝', '2', 'zsjy_graduate_audit_status', NULL, 'danger', 'N', NULL, 103, NOW(), 103, NOW(), '审核拒绝');

-- 6. 验证修复后的数据
SELECT '=== 修复后的字典数据验证 ===' as info;

SELECT '--- 毕业生就业状态 ---' as info;
SELECT dict_code, dict_label, dict_value FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_employment_status' ORDER BY dict_sort;

SELECT '--- 就业单位性质 ---' as info;
SELECT dict_code, dict_label, dict_value FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_company_type' ORDER BY dict_sort;

SELECT '--- 月薪范围 ---' as info;
SELECT dict_code, dict_label, dict_value FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_salary_range' ORDER BY dict_sort;

SELECT '--- 审核状态 ---' as info;
SELECT dict_code, dict_label, dict_value FROM sys_dict_data WHERE dict_type = 'zsjy_graduate_audit_status' ORDER BY dict_sort;