-- 考勤定位字段迁移。旧规则保持 location_required=0,先配置地点再启用范围限制。 DELIMITER $$ DROP PROCEDURE IF EXISTS xgdl_hrm_attendance_add_column_20261024$$ CREATE PROCEDURE xgdl_hrm_attendance_add_column_20261024( IN p_table_name VARCHAR(64), IN p_column_name VARCHAR(64), IN p_ddl_sql VARCHAR(1000)) BEGIN IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = p_table_name AND COLUMN_NAME = p_column_name) THEN SET @hrm_location_ddl = p_ddl_sql; PREPARE hrm_location_stmt FROM @hrm_location_ddl; EXECUTE hrm_location_stmt; DEALLOCATE PREPARE hrm_location_stmt; END IF; END$$ DELIMITER ; CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_rule','location_name', 'ALTER TABLE hrm_attendance_rule ADD COLUMN location_name varchar(100) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_rule','location_address', 'ALTER TABLE hrm_attendance_rule ADD COLUMN location_address varchar(255) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_rule','longitude', 'ALTER TABLE hrm_attendance_rule ADD COLUMN longitude decimal(10,7) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_rule','latitude', 'ALTER TABLE hrm_attendance_rule ADD COLUMN latitude decimal(10,7) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_rule','radius_meters', 'ALTER TABLE hrm_attendance_rule ADD COLUMN radius_meters int DEFAULT 200'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_rule','location_required', 'ALTER TABLE hrm_attendance_rule ADD COLUMN location_required bit(1) NOT NULL DEFAULT b''0'''); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_rule','coordinate_system', 'ALTER TABLE hrm_attendance_rule ADD COLUMN coordinate_system varchar(20) DEFAULT ''WGS84'''); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_in_longitude', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_in_longitude decimal(10,7) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_in_latitude', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_in_latitude decimal(10,7) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_in_accuracy', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_in_accuracy decimal(8,2) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_in_distance', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_in_distance decimal(10,2) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_in_address', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_in_address varchar(255) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_out_longitude', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_out_longitude decimal(10,7) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_out_latitude', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_out_latitude decimal(10,7) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_out_accuracy', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_out_accuracy decimal(8,2) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_out_distance', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_out_distance decimal(10,2) NULL'); CALL xgdl_hrm_attendance_add_column_20261024('hrm_attendance_record','clock_out_address', 'ALTER TABLE hrm_attendance_record ADD COLUMN clock_out_address varchar(255) NULL'); DROP PROCEDURE xgdl_hrm_attendance_add_column_20261024;