all-project/backend/script/sql/fix-enrollment-dict-data.sql

-- ========================================
-- 修复招生就业模块字典数据脚本
-- 文件：fix-enrollment-dict-data.sql
-- 创建时间：2025-07-03
-- 说明：修复性别显示和校服尺码问题
-- ========================================

-- ----------------------------
-- 1、更新字典标签值
-- ----------------------------

-- 修复性别字典数据
UPDATE sys_dict_data
SET dict_label = '男', remark = '男性'
WHERE dict_type = 'zsjy_gender' AND dict_value = 'M';

UPDATE sys_dict_data
SET dict_label = '女', remark = '女性'
WHERE dict_type = 'zsjy_gender' AND dict_value = 'F';

-- 确保校服尺码字典数据存在并可用
-- 如果不存在则插入
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT 480, '000000', 1, 'XS', 'XS', 'zsjy_uniform_size', '', 'default', 'N', '0', 1, NOW(), '加小号'
FROM dual
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data WHERE dict_type = 'zsjy_uniform_size' AND dict_value = 'XS');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT 481, '000000', 2, 'S', 'S', 'zsjy_uniform_size', '', 'default', 'N', '0', 1, NOW(), '小号'
FROM dual
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data WHERE dict_type = 'zsjy_uniform_size' AND dict_value = 'S');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT 482, '000000', 3, 'M', 'M', 'zsjy_uniform_size', '', 'default', 'Y', '0', 1, NOW(), '中号'
FROM dual
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data WHERE dict_type = 'zsjy_uniform_size' AND dict_value = 'M');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT 483, '000000', 4, 'L', 'L', 'zsjy_uniform_size', '', 'default', 'N', '0', 1, NOW(), '大号'
FROM dual
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data WHERE dict_type = 'zsjy_uniform_size' AND dict_value = 'L');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT 484, '000000', 5, 'XL', 'XL', 'zsjy_uniform_size', '', 'default', 'N', '0', 1, NOW(), '加大号'
FROM dual
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data WHERE dict_type = 'zsjy_uniform_size' AND dict_value = 'XL');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT 485, '000000', 6, 'XXL', 'XXL', 'zsjy_uniform_size', '', 'default', 'N', '0', 1, NOW(), '加加大号'
FROM dual
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data WHERE dict_type = 'zsjy_uniform_size' AND dict_value = 'XXL');

INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
SELECT 486, '000000', 7, 'XXXL', 'XXXL', 'zsjy_uniform_size', '', 'default', 'N', '0', 1, NOW(), '加加加大号'
FROM dual
WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data WHERE dict_type = 'zsjy_uniform_size' AND dict_value = 'XXXL');