-- Optional demo seed. Password seluruh akun: demo12345.
USE sekolahku;

INSERT INTO users (id, role, full_name, email, password_hash, phone) VALUES
(1, 'admin', 'Alya Pratama', 'admin@sekolahku.test', '$2y$12$EO23cZtmB7u/AjTSo/fHkOzTKdZpqT979.PNxQZKqd/Y66yQMc9YW', '081200000001'),
(2, 'guru', 'Budi Santoso', 'guru@sekolahku.test', '$2y$12$EO23cZtmB7u/AjTSo/fHkOzTKdZpqT979.PNxQZKqd/Y66yQMc9YW', '081200000002'),
(3, 'siswa', 'Nadia Putri', 'siswa@sekolahku.test', '$2y$12$EO23cZtmB7u/AjTSo/fHkOzTKdZpqT979.PNxQZKqd/Y66yQMc9YW', '081200000003'),
(4, 'orangtua', 'Rina Wulandari', 'orangtua@sekolahku.test', '$2y$12$EO23cZtmB7u/AjTSo/fHkOzTKdZpqT979.PNxQZKqd/Y66yQMc9YW', '081200000004');

INSERT INTO students (id, user_id, nisn, class_name, grade_level, enrollment_year, status) VALUES
(1, 3, '0087123490', 'XI IPA 2', 'XI', 2024, 'active');

INSERT INTO teachers (id, user_id, employee_number, subject_name) VALUES
(1, 2, 'GURU-2024-001', 'Matematika & Informatika');

INSERT INTO guardians (id, user_id, relationship) VALUES
(1, 4, 'Orang Tua Nadia Putri');

INSERT INTO guardian_students (guardian_id, student_id, relationship, is_primary) VALUES
(1, 1, 'Ibu', 1);

INSERT INTO attendance (student_id, attendance_date, check_in_at, status, qr_token) VALUES
(1, CURDATE(), NOW(), 'hadir', 'DEMO-QR-TODAY');

INSERT INTO invoices (student_id, invoice_number, billing_period, description, amount, due_date, status) VALUES
(1, 'INV-2026-09-0001', '2026-09', 'SPP September 2026', 450000, '2026-09-10', 'paid'),
(1, 'INV-2026-10-0001', '2026-10', 'SPP Oktober 2026', 450000, '2026-10-10', 'unpaid');

INSERT INTO payments (invoice_id, payer_user_id, payment_number, amount, payment_method, paid_at, status) VALUES
(1, 4, 'PAY-2026-09-0001', 450000, 'transfer', '2026-09-04 09:12:00', 'verified');

INSERT INTO courses (id, teacher_id, code, name, description, class_name, is_published) VALUES
(1, 1, 'MAT-XI-01', 'Matematika Wajib XI', 'Fungsi komposisi dan invers.', 'XI IPA 2', 1),
(2, 1, 'INF-XI-01', 'Informatika Terapan', 'Algoritma, data, dan proyek digital.', 'XI IPA 2', 1);

INSERT INTO course_enrollments (course_id, student_id, status) VALUES
(1, 1, 'active'),
(2, 1, 'active');

INSERT INTO course_lessons (course_id, title, content, sort_order, published_at) VALUES
(1, 'Fungsi Komposisi', 'Materi pengantar fungsi komposisi.', 1, NOW()),
(2, 'Berpikir Komputasional', 'Mengenal pola, dekomposisi, dan algoritma.', 1, NOW());

INSERT INTO assignments (course_id, title, instructions, due_at, max_score) VALUES
(1, 'Latihan Fungsi Invers', 'Kerjakan 10 soal pada lembar kerja.', '2026-11-08 23:59:00', 100),
(2, 'Mini Project Algoritma', 'Buat diagram alur untuk masalah sederhana.', '2026-11-12 23:59:00', 100);

INSERT INTO library_books (isbn, title, author, category, stock_total, stock_available, is_digital) VALUES
('9786020320001', 'Laskar Pelangi', 'Andrea Hirata', 'Fiksi', 6, 4, 1),
('9786020620002', 'Matematika untuk SMA XI', 'Tim Edukasi', 'Pelajaran', 12, 10, 1),
('9786021120003', 'Dasar-Dasar Informatika', 'Pusat Kurikulum', 'Teknologi', 8, 7, 1);

INSERT INTO announcements (author_user_id, title, body, audience, published_at) VALUES
(1, 'Pekan Literasi Sekolah', 'Pendaftaran lomba resensi buku dibuka sampai 14 November.', 'all', NOW()),
(2, 'Materi baru Informatika', 'Materi berpikir komputasional sudah tersedia di LMS.', 'siswa', NOW());