-- ============================================================================ -- 考勤记录补充请假关联字段(随长辉电力分支移植) -- -- 用途:考勤记录展示请假状态、请假工时,打卡面板提示已请假 -- 对应实体:HrmAttendanceRecordDO#leaveFlag / leaveHours / leaveTypes -- 特性:幂等,可重复执行 -- ============================================================================ SET @exists := (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record' AND column_name = 'leave_flag'); SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `leave_flag` bit(1) NOT NULL DEFAULT b'0' COMMENT '当天是否请假'", "SELECT 1"); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET @exists := (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record' AND column_name = 'leave_hours'); SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `leave_hours` decimal(10,2) DEFAULT NULL COMMENT '当天请假工时'", "SELECT 1"); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET @exists := (SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = DATABASE() AND table_name = 'hrm_attendance_record' AND column_name = 'leave_types'); SET @sql := IF(@exists = 0, "ALTER TABLE `hrm_attendance_record` ADD COLUMN `leave_types` varchar(255) DEFAULT NULL COMMENT '当天请假类型,多个以逗号分隔'", "SELECT 1"); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;