1351 lines
190 KiB
SQL
1351 lines
190 KiB
SQL
-- Seed data generated from 暑期班课表 更新-2.xlsx
|
|
-- Source dates: 2026-07-20 through 2026-08-16.
|
|
-- Idempotency: stable records are upserted; the source-owned summer schedule/duty range is replaced; legacy seeded exams are removed.
|
|
|
|
SET NAMES utf8mb4;
|
|
USE `dorm_billing_v2`;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
START TRANSACTION;
|
|
|
|
INSERT INTO `organizations` (`public_id`, `code`, `name`, `is_host`, `color`, `notes`, `status`)
|
|
VALUES ('00000000-0000-7000-8000-000000000001', 'HOST', '本机构', 1, '#1677ff', '系统默认运营主体', 'active')
|
|
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`), `is_host`=1, `status`='active';
|
|
|
|
INSERT INTO `permissions` (`code`, `name`, `group`) VALUES
|
|
('dashboard:view', '查看数据面板', 'dashboard'),
|
|
('notification:view', '查看通知', 'notification'),
|
|
('student:view', '查看学生管理', 'student'),
|
|
('student:basic-view', '查看学生基础信息', 'student-scope'),
|
|
('teacher-workspace:view', '查看教师工作台', 'teacher-workspace'),
|
|
('teacher:view', '查看教师', 'teacher'),
|
|
('teacher:edit', '编辑教师', 'teacher'),
|
|
('student:create', '新增学生', 'student'),
|
|
('student:edit', '编辑学生', 'student'),
|
|
('student:delete', '归档学生', 'student'),
|
|
('student:import', '导入学生', 'student'),
|
|
('student:export', '导出学生', 'student'),
|
|
('exam:view', '查看和录入考试成绩', 'exam'),
|
|
('room:view', '查看宿舍', 'room'),
|
|
('room:inspect', '宿舍查寝', 'room'),
|
|
('room:create', '新增宿舍', 'room'),
|
|
('room:edit', '编辑宿舍', 'room'),
|
|
('room:delete', '归档宿舍', 'room'),
|
|
('occupancy:view', '查看入住', 'occupancy'),
|
|
('occupancy:checkin', '办理入住', 'occupancy'),
|
|
('occupancy:checkout', '办理退宿', 'occupancy'),
|
|
('occupancy:transfer', '调换宿舍', 'occupancy'),
|
|
('occupancy:delete', '归档入住记录', 'occupancy'),
|
|
('expense:view', '查看费用', 'expense'),
|
|
('expense:create', '录入费用', 'expense'),
|
|
('expense:edit', '编辑费用', 'expense'),
|
|
('expense:delete', '归档费用', 'expense'),
|
|
('bill:view', '查看账单', 'bill'),
|
|
('bill:generate', '生成账单', 'bill'),
|
|
('bill:confirm', '确认账单', 'bill'),
|
|
('bill:delete', '归档账单', 'bill'),
|
|
('bill:export-excel', '导出 Excel', 'bill'),
|
|
('bill:export-pdf', '导出 PDF', 'bill'),
|
|
('deposit:view', '查看押金', 'deposit'),
|
|
('deposit:create', '新增押金', 'deposit'),
|
|
('deposit:edit', '编辑押金', 'deposit'),
|
|
('deposit:delete', '归档押金', 'deposit'),
|
|
('deposit:refund', '直接退还押金', 'deposit'),
|
|
('wallet:view', '查看学生余额', 'wallet'),
|
|
('wallet:edit', '充值和调账', 'wallet'),
|
|
('classroom:view', '查看教室', 'classroom'),
|
|
('classroom:create', '新增教室', 'classroom'),
|
|
('classroom:edit', '编辑教室', 'classroom'),
|
|
('classroom:delete', '归档教室', 'classroom'),
|
|
('organization:view', '查看机构', 'organization'),
|
|
('organization:create', '新增机构', 'organization'),
|
|
('organization:edit', '编辑机构', 'organization'),
|
|
('organization:delete', '归档机构', 'organization'),
|
|
('rental:view', '查看租赁订单', 'rental'),
|
|
('rental:create', '新增租赁订单', 'rental'),
|
|
('rental:edit', '编辑租赁订单', 'rental'),
|
|
('rental:delete', '归档租赁订单', 'rental'),
|
|
('log:view', '查看操作日志', 'log'),
|
|
('log:create', '写入操作日志', 'log'),
|
|
('user:view', '查看用户', 'user'),
|
|
('user:create', '创建用户', 'user'),
|
|
('user:edit', '编辑用户', 'user'),
|
|
('user:reset-password', '重置密码', 'user'),
|
|
('role:view', '查看角色', 'role'),
|
|
('role:create', '创建角色', 'role'),
|
|
('role:edit', '编辑角色', 'role'),
|
|
('role:delete', '停用角色', 'role'),
|
|
('class:view', '查看班级', 'class'),
|
|
('class:create', '创建班级', 'class'),
|
|
('class:edit', '编辑班级', 'class'),
|
|
('class:delete', '归档班级', 'class'),
|
|
('schedule:view', '查看排课', 'schedule'),
|
|
('schedule:create', '创建排课', 'schedule'),
|
|
('schedule:edit', '编辑排课', 'schedule'),
|
|
('schedule:delete', '停用排课', 'schedule'),
|
|
('attendance:view', '查看考勤', 'attendance'),
|
|
('attendance:create', '新增考勤', 'attendance'),
|
|
('attendance:edit', '编辑全部考勤', 'attendance'),
|
|
('attendance:self-edit', '编辑任教班级考勤', 'attendance-scope'),
|
|
('attendance:export', '导出考勤', 'attendance'),
|
|
('sync:trigger', '触发数据同步', 'sync'),
|
|
('sync:read', '查看同步状态', 'sync'),
|
|
('integration:trigger', '触发集成', 'integration'),
|
|
('integration:read', '查看集成状态', 'integration'),
|
|
('ai:config:read', '查看 AI 配置', 'ai'),
|
|
('ai:config:write', '修改 AI 配置', 'ai'),
|
|
('ai:config:test', '测试 AI 连接', 'ai'),
|
|
('ai:chat:use', '使用 AI 助手', 'ai-chat')
|
|
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`), `group`=VALUES(`group`);
|
|
|
|
INSERT INTO `roles` (`name`, `code`, `description`, `is_system`, `status`) VALUES
|
|
('超级管理员', 'super_admin', '系统初始化、应急维护和全局权限处理', 1, 1),
|
|
('任课老师', 'teacher', '查看自己的排课、今日课程和任教班级考勤', 1, 1),
|
|
('教务管理员', 'academic', '管理学生、班级、教师、全局排课和历史考勤', 1, 1),
|
|
('住宿运营管理员', 'accommodation_operations', '管理宿舍、入住、住宿费用、账单、押金和退宿结算', 1, 1),
|
|
('教室运营管理员', 'classroom_operations', '管理教室、教室排期、外部机构和租赁订单', 1, 1),
|
|
('系统管理员', 'system_admin', '管理账号、角色、日志、同步和系统配置', 1, 1)
|
|
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`), `description`=VALUES(`description`), `is_system`=1, `status`=1;
|
|
|
|
INSERT INTO `users` (`username`, `password_hash`, `name`, `is_active`, `is_archived`)
|
|
VALUES ('admin', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '管理员', 1, 0)
|
|
ON DUPLICATE KEY UPDATE `name`='管理员', `is_active`=1, `is_archived`=0;
|
|
|
|
INSERT IGNORE INTO `user_roles` (`user_id`, `role_id`)
|
|
SELECT u.id, r.id FROM `users` u JOIN `roles` r ON r.code='super_admin' WHERE u.username='admin';
|
|
|
|
-- Preset roles use the same authoritative permission matrix as RbacService.seedData().
|
|
DELETE rp FROM `role_permissions` rp
|
|
JOIN `roles` r ON r.id=rp.role_id
|
|
WHERE r.code IN ('super_admin','teacher','academic','accommodation_operations','classroom_operations','system_admin');
|
|
|
|
INSERT IGNORE INTO `role_permissions` (`role_id`, `permission_id`)
|
|
SELECT r.id, p.id FROM `roles` r CROSS JOIN `permissions` p WHERE r.code='super_admin';
|
|
|
|
INSERT IGNORE INTO `role_permissions` (`role_id`, `permission_id`)
|
|
SELECT r.id, p.id FROM `roles` r CROSS JOIN `permissions` p
|
|
WHERE r.code='teacher'
|
|
AND (p.`group` IN ('notification') OR p.code IN ('teacher-workspace:view','schedule:view','attendance:view','attendance:create','attendance:self-edit'));
|
|
|
|
INSERT IGNORE INTO `role_permissions` (`role_id`, `permission_id`)
|
|
SELECT r.id, p.id FROM `roles` r CROSS JOIN `permissions` p
|
|
WHERE r.code='academic'
|
|
AND (p.`group` IN ('student','exam','class','schedule','attendance','classroom','dashboard','notification')
|
|
OR p.code IN ('teacher-workspace:view','teacher:view','teacher:edit','sync:read','sync:trigger'));
|
|
|
|
INSERT IGNORE INTO `role_permissions` (`role_id`, `permission_id`)
|
|
SELECT r.id, p.id FROM `roles` r CROSS JOIN `permissions` p
|
|
WHERE r.code='accommodation_operations'
|
|
AND (p.`group` IN ('room','occupancy','expense','bill','deposit','wallet','dashboard','notification')
|
|
OR p.code IN ('student:basic-view'));
|
|
|
|
INSERT IGNORE INTO `role_permissions` (`role_id`, `permission_id`)
|
|
SELECT r.id, p.id FROM `roles` r CROSS JOIN `permissions` p
|
|
WHERE r.code='classroom_operations'
|
|
AND p.`group` IN ('classroom','rental','organization','notification');
|
|
|
|
INSERT IGNORE INTO `role_permissions` (`role_id`, `permission_id`)
|
|
SELECT r.id, p.id FROM `roles` r CROSS JOIN `permissions` p
|
|
WHERE r.code='system_admin'
|
|
AND p.`group` IN ('user','role','log','integration','sync','ai','notification');
|
|
|
|
INSERT INTO `users` (`username`, `password_hash`, `name`, `is_active`, `is_archived`) VALUES
|
|
('summer_teacher_01', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '柴艳', 1, 0),
|
|
('summer_teacher_02', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '陈奕静', 1, 0),
|
|
('summer_teacher_03', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '郭婧', 1, 0),
|
|
('summer_teacher_04', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '郭馨', 1, 0),
|
|
('summer_teacher_05', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '李鸿图', 1, 0),
|
|
('summer_teacher_06', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '师哲', 1, 0),
|
|
('summer_teacher_07', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '王贵晶', 1, 0),
|
|
('summer_teacher_08', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '王家欣', 1, 0),
|
|
('summer_teacher_09', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '王沐妍', 1, 0),
|
|
('summer_teacher_10', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '杨婷', 1, 0),
|
|
('summer_teacher_11', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '袁嘉琪', 1, 0),
|
|
('summer_teacher_12', '$2b$10$/uXpQttv.Ud7sfUeZmVta./ZwMjHF59JbO4scA6pnHDtUZo1EMzA2', '张永杰', 1, 0)
|
|
ON DUPLICATE KEY UPDATE `password_hash`=VALUES(`password_hash`), `name`=VALUES(`name`), `is_active`=1, `is_archived`=0;
|
|
|
|
INSERT IGNORE INTO `user_roles` (`user_id`, `role_id`)
|
|
SELECT u.id, r.id FROM `users` u CROSS JOIN `roles` r WHERE u.username LIKE 'summer_teacher_%' AND r.code='teacher';
|
|
|
|
INSERT INTO `classes` (`name`, `code`, `class_type`, `start_date`, `end_date`, `status`, `max_students`, `notes`, `is_archived`) VALUES
|
|
('暑期1班', 'SUMMER_2026_1', 'culture', '2026-07-20', '2026-08-16', 'active', 0, '来源: 暑期班课表 更新-2.xlsx; 教室 212', 0),
|
|
('暑期2班', 'SUMMER_2026_2', 'culture', '2026-07-20', '2026-08-16', 'active', 0, '来源: 暑期班课表 更新-2.xlsx; 教室 210', 0),
|
|
('暑期3班', 'SUMMER_2026_3', 'culture', '2026-07-20', '2026-08-16', 'active', 0, '来源: 暑期班课表 更新-2.xlsx; 教室 301', 0),
|
|
('暑期4班', 'SUMMER_2026_4', 'culture', '2026-07-20', '2026-08-16', 'active', 0, '来源: 暑期班课表 更新-2.xlsx; 教室 208', 0),
|
|
('暑期5班', 'SUMMER_2026_5', 'culture', '2026-07-20', '2026-08-16', 'active', 0, '来源: 暑期班课表 更新-2.xlsx; 教室 211', 0),
|
|
('暑期6班', 'SUMMER_2026_6', 'culture', '2026-07-20', '2026-08-16', 'active', 0, '来源: 暑期班课表 更新-2.xlsx; 教室 209', 0),
|
|
('暑期7班', 'SUMMER_2026_7', 'culture', '2026-07-20', '2026-08-16', 'active', 0, '来源: 暑期班课表 更新-2.xlsx; 教室 207', 0)
|
|
ON DUPLICATE KEY UPDATE `name`=VALUES(`name`), `class_type`=VALUES(`class_type`), `start_date`=VALUES(`start_date`), `end_date`=VALUES(`end_date`), `status`='active', `notes`=VALUES(`notes`), `is_archived`=0;
|
|
|
|
INSERT INTO `classrooms` (`name`, `building`, `floor`, `capacity`, `room_type`, `status`, `notes`)
|
|
SELECT '207', NULL, 2, 30, '大', 'available', '来源: 暑期班课表 更新-2.xlsx'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `classrooms` WHERE `name`='207');
|
|
UPDATE `classrooms` SET `floor`=2, `status`='available' WHERE `name`='207';
|
|
|
|
INSERT INTO `classrooms` (`name`, `building`, `floor`, `capacity`, `room_type`, `status`, `notes`)
|
|
SELECT '208', NULL, 2, 30, '大', 'available', '来源: 暑期班课表 更新-2.xlsx'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `classrooms` WHERE `name`='208');
|
|
UPDATE `classrooms` SET `floor`=2, `status`='available' WHERE `name`='208';
|
|
|
|
INSERT INTO `classrooms` (`name`, `building`, `floor`, `capacity`, `room_type`, `status`, `notes`)
|
|
SELECT '209', NULL, 2, 30, '大', 'available', '来源: 暑期班课表 更新-2.xlsx'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `classrooms` WHERE `name`='209');
|
|
UPDATE `classrooms` SET `floor`=2, `status`='available' WHERE `name`='209';
|
|
|
|
INSERT INTO `classrooms` (`name`, `building`, `floor`, `capacity`, `room_type`, `status`, `notes`)
|
|
SELECT '210', NULL, 2, 30, '大', 'available', '来源: 暑期班课表 更新-2.xlsx'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `classrooms` WHERE `name`='210');
|
|
UPDATE `classrooms` SET `floor`=2, `status`='available' WHERE `name`='210';
|
|
|
|
INSERT INTO `classrooms` (`name`, `building`, `floor`, `capacity`, `room_type`, `status`, `notes`)
|
|
SELECT '211', NULL, 2, 30, '大', 'available', '来源: 暑期班课表 更新-2.xlsx'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `classrooms` WHERE `name`='211');
|
|
UPDATE `classrooms` SET `floor`=2, `status`='available' WHERE `name`='211';
|
|
|
|
INSERT INTO `classrooms` (`name`, `building`, `floor`, `capacity`, `room_type`, `status`, `notes`)
|
|
SELECT '212', NULL, 2, 30, '大', 'available', '来源: 暑期班课表 更新-2.xlsx'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `classrooms` WHERE `name`='212');
|
|
UPDATE `classrooms` SET `floor`=2, `status`='available' WHERE `name`='212';
|
|
|
|
INSERT INTO `classrooms` (`name`, `building`, `floor`, `capacity`, `room_type`, `status`, `notes`)
|
|
SELECT '301', NULL, 3, 30, '大', 'available', '来源: 暑期班课表 更新-2.xlsx'
|
|
WHERE NOT EXISTS (SELECT 1 FROM `classrooms` WHERE `name`='301');
|
|
UPDATE `classrooms` SET `floor`=3, `status`='available' WHERE `name`='301';
|
|
|
|
DELETE ct FROM `class_teacher` ct JOIN `classes` c ON c.id=ct.class_id JOIN `users` u ON u.id=ct.user_id WHERE c.code LIKE 'SUMMER_2026_%' AND u.username LIKE 'summer_teacher_%';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '英语' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '计算机' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '数学' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '计算机' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '英语' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '数学' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '数学' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '计算机' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '英语' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '英语' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '数学' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '计算机' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '语文' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '英语' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '计算机' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '语文' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '计算机' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '英语' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '数学' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '英语' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7';
|
|
|
|
INSERT INTO `class_teacher` (`class_id`, `user_id`, `role_type`, `subject`)
|
|
SELECT c.id, u.id, 'subject_teacher', '计算机' FROM `classes` c JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7';
|
|
|
|
DELETE ar FROM `attendance_records` ar JOIN `class_schedule` cs ON cs.id=ar.schedule_id JOIN `classes` c ON c.id=cs.class_id WHERE c.code LIKE 'SUMMER_2026_%' AND cs.start_date BETWEEN '2026-07-20' AND '2026-08-16';
|
|
DELETE ats FROM `attendance_sessions` ats JOIN `class_schedule` cs ON cs.id=ats.schedule_id JOIN `classes` c ON c.id=cs.class_id WHERE c.code LIKE 'SUMMER_2026_%' AND cs.start_date BETWEEN '2026-07-20' AND '2026-08-16';
|
|
DELETE cs FROM `class_schedule` cs JOIN `classes` c ON c.id=cs.class_id WHERE c.code LIKE 'SUMMER_2026_%' AND cs.start_date BETWEEN '2026-07-20' AND '2026-08-16';
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-20', '2026-07-20', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-20', '2026-07-20', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-21', '2026-07-21', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-21', '2026-07-21', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-22', '2026-07-22', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-22', '2026-07-22', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-23', '2026-07-23', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-23', '2026-07-23', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-24', '2026-07-24', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-24', '2026-07-24', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-07-26', '2026-07-26', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-07-26', '2026-07-26', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-20', '2026-07-20', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-20', '2026-07-20', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-21', '2026-07-21', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-21', '2026-07-21', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-22', '2026-07-22', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-22', '2026-07-22', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-23', '2026-07-23', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-23', '2026-07-23', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-24', '2026-07-24', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-24', '2026-07-24', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-07-26', '2026-07-26', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-07-26', '2026-07-26', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-20', '2026-07-20', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-20', '2026-07-20', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-21', '2026-07-21', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-21', '2026-07-21', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-22', '2026-07-22', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-22', '2026-07-22', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-23', '2026-07-23', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-23', '2026-07-23', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-24', '2026-07-24', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-24', '2026-07-24', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-07-26', '2026-07-26', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-07-26', '2026-07-26', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-20', '2026-07-20', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-20', '2026-07-20', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-21', '2026-07-21', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-21', '2026-07-21', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-22', '2026-07-22', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-22', '2026-07-22', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-23', '2026-07-23', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-23', '2026-07-23', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-24', '2026-07-24', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-24', '2026-07-24', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-07-26', '2026-07-26', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-07-26', '2026-07-26', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-20', '2026-07-20', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-20', '2026-07-20', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-21', '2026-07-21', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-21', '2026-07-21', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-22', '2026-07-22', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-22', '2026-07-22', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-23', '2026-07-23', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-23', '2026-07-23', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-24', '2026-07-24', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-24', '2026-07-24', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-07-26', '2026-07-26', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-07-26', '2026-07-26', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-20', '2026-07-20', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-20', '2026-07-20', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-21', '2026-07-21', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-21', '2026-07-21', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-22', '2026-07-22', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-22', '2026-07-22', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-23', '2026-07-23', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-23', '2026-07-23', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-24', '2026-07-24', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-24', '2026-07-24', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-07-26', '2026-07-26', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-07-26', '2026-07-26', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-20', '2026-07-20', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-20', '2026-07-20', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-21', '2026-07-21', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-21', '2026-07-21', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-22', '2026-07-22', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-22', '2026-07-22', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-23', '2026-07-23', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-23', '2026-07-23', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-24', '2026-07-24', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-24', '2026-07-24', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-07-26', '2026-07-26', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-07-26', '2026-07-26', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-27', '2026-07-27', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-27', '2026-07-27', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-28', '2026-07-28', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-28', '2026-07-28', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-29', '2026-07-29', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-29', '2026-07-29', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-30', '2026-07-30', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-30', '2026-07-30', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-31', '2026-07-31', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-31', '2026-07-31', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-02', '2026-08-02', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-02', '2026-08-02', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-27', '2026-07-27', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-27', '2026-07-27', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-28', '2026-07-28', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-28', '2026-07-28', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-29', '2026-07-29', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-29', '2026-07-29', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-30', '2026-07-30', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-30', '2026-07-30', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-31', '2026-07-31', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-31', '2026-07-31', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-02', '2026-08-02', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-02', '2026-08-02', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-27', '2026-07-27', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-27', '2026-07-27', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-28', '2026-07-28', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-28', '2026-07-28', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-29', '2026-07-29', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-29', '2026-07-29', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-30', '2026-07-30', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-30', '2026-07-30', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-31', '2026-07-31', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-31', '2026-07-31', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-02', '2026-08-02', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-02', '2026-08-02', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-27', '2026-07-27', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-27', '2026-07-27', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-28', '2026-07-28', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-28', '2026-07-28', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-29', '2026-07-29', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-29', '2026-07-29', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-30', '2026-07-30', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-30', '2026-07-30', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-31', '2026-07-31', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-31', '2026-07-31', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-02', '2026-08-02', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-02', '2026-08-02', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-27', '2026-07-27', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-27', '2026-07-27', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-28', '2026-07-28', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-28', '2026-07-28', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-29', '2026-07-29', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-29', '2026-07-29', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-30', '2026-07-30', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-30', '2026-07-30', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-31', '2026-07-31', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-31', '2026-07-31', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-02', '2026-08-02', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-02', '2026-08-02', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-27', '2026-07-27', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-27', '2026-07-27', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-28', '2026-07-28', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-28', '2026-07-28', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-29', '2026-07-29', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-29', '2026-07-29', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-30', '2026-07-30', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-30', '2026-07-30', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-31', '2026-07-31', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-31', '2026-07-31', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-02', '2026-08-02', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-02', '2026-08-02', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-07-27', '2026-07-27', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-07-27', '2026-07-27', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-07-28', '2026-07-28', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-07-28', '2026-07-28', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-07-29', '2026-07-29', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-07-29', '2026-07-29', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-07-30', '2026-07-30', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-07-30', '2026-07-30', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-07-31', '2026-07-31', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-07-31', '2026-07-31', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-02', '2026-08-02', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-02', '2026-08-02', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-03', '2026-08-03', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-03', '2026-08-03', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-04', '2026-08-04', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-04', '2026-08-04', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-05', '2026-08-05', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-05', '2026-08-05', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-08-06', '2026-08-06', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-08-06', '2026-08-06', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-07', '2026-08-07', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-07', '2026-08-07', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-09', '2026-08-09', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-09', '2026-08-09', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-03', '2026-08-03', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-03', '2026-08-03', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-04', '2026-08-04', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-04', '2026-08-04', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-05', '2026-08-05', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-05', '2026-08-05', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-08-06', '2026-08-06', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-08-06', '2026-08-06', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-07', '2026-08-07', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-07', '2026-08-07', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-09', '2026-08-09', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-09', '2026-08-09', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-03', '2026-08-03', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-03', '2026-08-03', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-04', '2026-08-04', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-04', '2026-08-04', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-05', '2026-08-05', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-05', '2026-08-05', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-08-06', '2026-08-06', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-08-06', '2026-08-06', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-07', '2026-08-07', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-07', '2026-08-07', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-09', '2026-08-09', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-09', '2026-08-09', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-03', '2026-08-03', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-03', '2026-08-03', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-04', '2026-08-04', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-04', '2026-08-04', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-05', '2026-08-05', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-05', '2026-08-05', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-08-06', '2026-08-06', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-08-06', '2026-08-06', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-07', '2026-08-07', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-07', '2026-08-07', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-09', '2026-08-09', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-09', '2026-08-09', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-03', '2026-08-03', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-03', '2026-08-03', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-04', '2026-08-04', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-04', '2026-08-04', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-05', '2026-08-05', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-05', '2026-08-05', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-08-06', '2026-08-06', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-08-06', '2026-08-06', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-07', '2026-08-07', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-07', '2026-08-07', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-09', '2026-08-09', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-09', '2026-08-09', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-03', '2026-08-03', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-03', '2026-08-03', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-04', '2026-08-04', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-04', '2026-08-04', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-05', '2026-08-05', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-05', '2026-08-05', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-08-06', '2026-08-06', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-08-06', '2026-08-06', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-07', '2026-08-07', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-07', '2026-08-07', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-09', '2026-08-09', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-09', '2026-08-09', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-03', '2026-08-03', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-03', '2026-08-03', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-04', '2026-08-04', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-04', '2026-08-04', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-05', '2026-08-05', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-05', '2026-08-05', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '09:00', '12:00', 30, '2026-08-06', '2026-08-06', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 4, '14:00', '17:00', 30, '2026-08-06', '2026-08-06', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-07', '2026-08-07', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-07', '2026-08-07', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-09', '2026-08-09', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-09', '2026-08-09', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-10', '2026-08-10', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-10', '2026-08-10', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-11', '2026-08-11', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-11', '2026-08-11', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-12', '2026-08-12', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-12', '2026-08-12', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-14', '2026-08-14', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-14', '2026-08-14', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '09:00', '12:00', 30, '2026-08-15', '2026-08-15', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '14:00', '17:00', 30, '2026-08-15', '2026-08-15', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-16', '2026-08-16', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_03' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-16', '2026-08-16', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='212' JOIN `users` u ON u.username='summer_teacher_05' WHERE c.code='SUMMER_2026_1' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-10', '2026-08-10', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-10', '2026-08-10', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-11', '2026-08-11', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-11', '2026-08-11', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-12', '2026-08-12', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-12', '2026-08-12', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-14', '2026-08-14', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-14', '2026-08-14', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '09:00', '12:00', 30, '2026-08-15', '2026-08-15', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '14:00', '17:00', 30, '2026-08-15', '2026-08-15', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-16', '2026-08-16', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-16', '2026-08-16', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='210' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_2' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-10', '2026-08-10', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-10', '2026-08-10', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-11', '2026-08-11', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-11', '2026-08-11', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-12', '2026-08-12', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-12', '2026-08-12', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-14', '2026-08-14', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-14', '2026-08-14', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_02' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '09:00', '12:00', 30, '2026-08-15', '2026-08-15', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '14:00', '17:00', 30, '2026-08-15', '2026-08-15', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-16', '2026-08-16', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-16', '2026-08-16', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='301' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_3' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-10', '2026-08-10', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-10', '2026-08-10', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-11', '2026-08-11', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-11', '2026-08-11', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-12', '2026-08-12', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-12', '2026-08-12', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-14', '2026-08-14', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-14', '2026-08-14', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '09:00', '12:00', 30, '2026-08-15', '2026-08-15', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '14:00', '17:00', 30, '2026-08-15', '2026-08-15', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-16', '2026-08-16', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-16', '2026-08-16', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='208' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_4' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-10', '2026-08-10', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-10', '2026-08-10', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-11', '2026-08-11', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-11', '2026-08-11', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-12', '2026-08-12', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-12', '2026-08-12', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-14', '2026-08-14', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-14', '2026-08-14', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '09:00', '12:00', 30, '2026-08-15', '2026-08-15', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '14:00', '17:00', 30, '2026-08-15', '2026-08-15', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_09' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-16', '2026-08-16', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_11' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-16', '2026-08-16', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='211' JOIN `users` u ON u.username='summer_teacher_08' WHERE c.code='SUMMER_2026_5' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-10', '2026-08-10', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-10', '2026-08-10', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-11', '2026-08-11', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-11', '2026-08-11', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-12', '2026-08-12', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-12', '2026-08-12', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-14', '2026-08-14', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-14', '2026-08-14', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '09:00', '12:00', 30, '2026-08-15', '2026-08-15', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '14:00', '17:00', 30, '2026-08-15', '2026-08-15', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_04' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-16', '2026-08-16', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_12' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-16', '2026-08-16', '语文', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='209' JOIN `users` u ON u.username='summer_teacher_07' WHERE c.code='SUMMER_2026_6' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '09:00', '12:00', 30, '2026-08-10', '2026-08-10', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 1, '14:00', '17:00', 30, '2026-08-10', '2026-08-10', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '09:00', '12:00', 30, '2026-08-11', '2026-08-11', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 2, '14:00', '17:00', 30, '2026-08-11', '2026-08-11', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '09:00', '12:00', 30, '2026-08-12', '2026-08-12', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 3, '14:00', '17:00', 30, '2026-08-12', '2026-08-12', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '09:00', '12:00', 30, '2026-08-14', '2026-08-14', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 5, '14:00', '17:00', 30, '2026-08-14', '2026-08-14', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '09:00', '12:00', 30, '2026-08-15', '2026-08-15', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 6, '14:00', '17:00', 30, '2026-08-15', '2026-08-15', '英语', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_10' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '09:00', '12:00', 30, '2026-08-16', '2026-08-16', '计算机', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_01' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
INSERT INTO `class_schedule` (`class_id`, `classroom_id`, `week_day`, `start_time`, `end_time`, `attendance_advance_minutes`, `start_date`, `end_date`, `subject`, `teacher_id`, `schedule_type`, `status`, `notes`)
|
|
SELECT c.id, cr.id, 7, '14:00', '17:00', 30, '2026-08-16', '2026-08-16', '数学', u.id, 'INTERNAL', 'active', '来源: 暑期班课表 更新-2.xlsx' FROM `classes` c JOIN `classrooms` cr ON cr.name='207' JOIN `users` u ON u.username='summer_teacher_06' WHERE c.code='SUMMER_2026_7' LIMIT 1;
|
|
|
|
DELETE es FROM `exam_scores` es JOIN `exams` e ON e.id=es.exam_id JOIN `classes` c ON c.id=e.class_id WHERE c.code LIKE 'SUMMER_2026_%' AND e.exam_date BETWEEN '2026-07-20' AND '2026-08-16';
|
|
DELETE e FROM `exams` e JOIN `classes` c ON c.id=e.class_id WHERE c.code LIKE 'SUMMER_2026_%' AND e.exam_date BETWEEN '2026-07-20' AND '2026-08-16';
|
|
|
|
-- Do not seed default exams. The cleanup above removes exams created by older versions of this seed file.
|
|
|
|
DELETE FROM `evening_study_duties` WHERE `duty_date` BETWEEN '2026-07-20' AND '2026-08-16';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-20', u.id, '郭馨' FROM `users` u WHERE u.username='summer_teacher_04';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-21', u.id, '师哲' FROM `users` u WHERE u.username='summer_teacher_06';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-22', u.id, '王家欣' FROM `users` u WHERE u.username='summer_teacher_08';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-23', u.id, '张永杰' FROM `users` u WHERE u.username='summer_teacher_12';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-24', u.id, '袁嘉琪' FROM `users` u WHERE u.username='summer_teacher_11';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-26', u.id, '陈奕静' FROM `users` u WHERE u.username='summer_teacher_02';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-27', u.id, '王家欣' FROM `users` u WHERE u.username='summer_teacher_08';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-28', u.id, '师哲' FROM `users` u WHERE u.username='summer_teacher_06';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-29', u.id, '郭馨' FROM `users` u WHERE u.username='summer_teacher_04';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-30', u.id, '李鸿图' FROM `users` u WHERE u.username='summer_teacher_05';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-07-31', u.id, '袁嘉琪' FROM `users` u WHERE u.username='summer_teacher_11';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-02', u.id, '张永杰' FROM `users` u WHERE u.username='summer_teacher_12';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-03', u.id, '师哲' FROM `users` u WHERE u.username='summer_teacher_06';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-04', u.id, '张永杰' FROM `users` u WHERE u.username='summer_teacher_12';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-05', u.id, '王沐妍' FROM `users` u WHERE u.username='summer_teacher_09';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-06', u.id, '师哲' FROM `users` u WHERE u.username='summer_teacher_06';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-07', u.id, '郭馨' FROM `users` u WHERE u.username='summer_teacher_04';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-09', u.id, '王家欣' FROM `users` u WHERE u.username='summer_teacher_08';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-10', u.id, '师哲' FROM `users` u WHERE u.username='summer_teacher_06';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-11', u.id, '袁嘉琪' FROM `users` u WHERE u.username='summer_teacher_11';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-12', u.id, '李鸿图' FROM `users` u WHERE u.username='summer_teacher_05';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-14', u.id, '陈奕静' FROM `users` u WHERE u.username='summer_teacher_02';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-15', u.id, '张永杰' FROM `users` u WHERE u.username='summer_teacher_12';
|
|
|
|
INSERT INTO `evening_study_duties` (`duty_date`, `teacher_id`, `teacher_name`) SELECT '2026-08-16', u.id, '李鸿图' FROM `users` u WHERE u.username='summer_teacher_05';
|
|
|
|
COMMIT;
|
|
|
|
-- Default login: admin / admin123
|
|
-- Summer teacher accounts: summer_teacher_01 ... summer_teacher_12; password admin123.
|
|
-- Change all default passwords immediately after first login.
|