// ============================================
// BRIAN SCHOOL RESULTS MANAGEMENT SYSTEM
// Auto Seed Database
// ============================================

import { db } from './firebase-config.js';
import {
  doc, getDoc, setDoc, addDoc, collection, serverTimestamp
} from "https://www.gstatic.com/firebasejs/12.19.0/firebase-firestore.js";

export const SUBJECT_GRADES = [
  { grade: 'A', min: 40.5, max: 50, remark: 'Excellent' },
  { grade: 'B', min: 30.5, max: 40, remark: 'Very Good' },
  { grade: 'C', min: 20.5, max: 30, remark: 'Good' },
  { grade: 'D', min: 10.5, max: 20, remark: 'Satisfactory' },
  { grade: 'E', min: 0,    max: 10, remark: 'Fail' }
];

export const TOTAL_GRADES = [
  { grade: 'A', min: 243, max: 300, division: 'I',   remark: 'Excellent' },
  { grade: 'B', min: 183, max: 242, division: 'II',  remark: 'Very Good' },
  { grade: 'C', min: 123, max: 182, division: 'III', remark: 'Good' },
  { grade: 'D', min: 63,  max: 122, division: 'IV',  remark: 'Satisfactory' },
  { grade: 'E', min: 0,   max: 62,  division: '0',   remark: 'Fail' }
];

export const SUBJECTS = [
  { code: 'MATH', name: 'Mathematics', order: 1, active: true },
  { code: 'ENG', name: 'English', order: 2, active: true },
  { code: 'KIS', name: 'Kiswahili', order: 3, active: true },
  { code: 'SCI', name: 'Science and Technology', order: 4, active: true },
  { code: 'SOC', name: 'Social Studies', order: 5, active: true },
  { code: 'CIV', name: 'Civic and Moral Education', order: 6, active: true }
];

export const CLASSES = [
  { code: 'STD1', name: 'Standard One', order: 1 },
  { code: 'STD2', name: 'Standard Two', order: 2 },
  { code: 'STD3', name: 'Standard Three', order: 3 },
  { code: 'STD4', name: 'Standard Four', order: 4 },
  { code: 'STD5', name: 'Standard Five', order: 5 },
  { code: 'STD6', name: 'Standard Six', order: 6 },
  { code: 'STD7', name: 'Standard Seven', order: 7 }
];

export const STREAMS = [
  { code: 'A', name: 'Stream A', order: 1 },
  { code: 'B', name: 'Stream B', order: 2 }
];

export async function seedDatabase(adminUid, adminEmail, adminName) {
  adminName = adminName || 'Brian Admin';

  try {
    var schoolRef = doc(db, 'settings', 'school');
    var schoolSnap = await getDoc(schoolRef);

    if (schoolSnap.exists()) {
      console.log('Database imesha-seedwa tayari.');
      return { seeded: false, message: 'Tayari imeseedwa' };
    }

    console.log('Inaanza kuunda database...');

    await setDoc(schoolRef, {
      schoolName: 'Brian Primary School',
      schoolCode: 'BPS',
      region: 'Dar es Salaam',
      district: 'Kinondoni',
      emisCode: 'PS0101001',
      academicYear: '2026',
      schoolMotto: 'Elimu ni Ufunguo wa Maisha',
      headTeacher: adminName,
      phone: '+255 700 000 000',
      email: adminEmail,
      address: 'S.L.P 123, Dar es Salaam',
      examTitle: 'Mtihani wa Muhula wa Kwanza 2026',
      passMark: 20.5,
      reportFooter: 'Hii ni ripoti ya shule - sio NECTA',
      logoUrl: '',
      createdAt: serverTimestamp()
    });
    console.log('settings/school OK');

    await setDoc(doc(db, 'settings', 'subjectGrades'), {
      grades: SUBJECT_GRADES,
      updatedAt: serverTimestamp()
    });
    console.log('settings/subjectGrades OK');

    await setDoc(doc(db, 'settings', 'totalGrades'), {
      grades: TOTAL_GRADES,
      updatedAt: serverTimestamp()
    });
    console.log('settings/totalGrades OK');

    await setDoc(doc(db, 'settings', 'subjects'), {
      list: SUBJECTS,
      updatedAt: serverTimestamp()
    });
    console.log('settings/subjects OK');

    await setDoc(doc(db, 'settings', 'classes'), {
      list: CLASSES,
      updatedAt: serverTimestamp()
    });
    console.log('settings/classes OK');

    await setDoc(doc(db, 'settings', 'streams'), {
      list: STREAMS,
      updatedAt: serverTimestamp()
    });
    console.log('settings/streams OK');

    await setDoc(doc(db, 'users', adminUid), {
      name: adminName,
      email: adminEmail,
      role: 'superadmin',
      active: true,
      createdAt: serverTimestamp()
    });
    console.log('users OK');

    await addDoc(collection(db, 'activity_logs'), {
      uid: adminUid,
      email: adminEmail,
      action: 'database_seeded',
      details: 'Database created automatically',
      timestamp: serverTimestamp()
    });

    console.log('Database imekamilika!');
    return { seeded: true, message: 'Database imeundwa kikamilifu' };

  } catch (err) {
    console.error('Seed error:', err);
    throw err;
  }
}

export async function loadSettings() {
  var results = await Promise.all([
    getDoc(doc(db, 'settings', 'school')),
    getDoc(doc(db, 'settings', 'subjectGrades')),
    getDoc(doc(db, 'settings', 'totalGrades')),
    getDoc(doc(db, 'settings', 'subjects')),
    <!DOCTYPE html>
<html lang="en" data-theme="light">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Dashboard - Brian School Results</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
<style>
:root {
  --primary: #006B3F;
  --bg: #f4f6f9;
  --card-bg: #ffffff;
  --text: #1a1a1a;
  --muted: #6c757d;
  --border: #e0e0e0;
}
[data-theme="dark"] {
  --bg: #121212; --card-bg: #1e1e1e; --text: #f0f0f0;
  --muted: #a0a0a0; --border: #333;
}
* { box-sizing: border-box; }
body {
  margin: 0; font-family: 'Segoe UI', system-ui, sans-serif;
  background: var(--bg); color: var(--text); min-height: 100vh;
}
.navbar {
  background: #006B3F; color: #fff; padding: 14px 24px;
  display: flex; align-items: center; justify-content: space-between;
  box-shadow: 0 2px 8px rgba(0,0,0,.15);
  position: sticky; top: 0; z-index: 100;
}
.navbar .brand { display: flex; align-items: center; gap: 12px; font-weight: 700; }
.navbar .brand i { font-size: 1.4rem; }
.navbar nav a {
  color: #fff; text-decoration: none; margin-left: 12px;
  padding: 6px 12px; border-radius: 6px; cursor: pointer; font-size: .9rem;
}
.navbar nav a:hover { background: rgba(255,255,255,.15); }
.container { max-width: 1300px; margin: 20px auto; padding: 0 16px; }
h1 { font-size: 1.6rem; margin-bottom: 6px; }
.subtitle { color: var(--muted); margin-bottom: 24px; }
.grid { display: grid; gap: 16px; }
.grid-2 { grid-template-columns: repeat(auto-fit, minmax(300px, 1fr)); }
.grid-4 { grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); }
.stat {
  background: var(--card-bg); border-radius: 12px; padding: 20px;
  border-left: 5px solid #006B3F;
  box-shadow: 0 2px 8px rgba(0,0,0,.05);
  display: flex; align-items: center; gap: 14px;
}
.stat .icon { font-size: 2rem; color: #006B3F; width: 50px; text-align: center; }
.stat .label { color: var(--muted); font-size: .8rem; text-transform: uppercase; }
.stat .value { font-size: 1.7rem; font-weight: 700; color: #006B3F; }
.card {
  background: var(--card-bg); border-radius: 12px; padding: 20px;
  box-shadow: 0 2px 10px rgba(0,0,0,.06);
  margin-bottom: 20px; border: 1px solid var(--border);
}
.card h3 {
  margin-top: 0; color: #006B3F; font-size: 1.1rem;
  display: flex; align-items: center; gap: 8px;
}
.card ul { line-height: 1.9; padding-left: 20px; }
.card ul li { font-size: .92rem; }
.toast {
  position: fixed; bottom: 20px; right: 20px;
  background: #006B3F; color: #fff;
  padding: 14px 20px; border-radius: 8px;
  box-shadow: 0 4px 12px rgba(0,0,0,.2);
  transform: translateY(100px); opacity: 0;
  transition: all .3s; z-index: 9999;
}
.toast.show { transform: translateY(0); opacity: 1; }
.toast.error { background: #dc3545; }
.loading { text-align: center; padding: 60px 20px; color: var(--muted); }
.loading i { font-size: 3rem; color: #006B3F; animation: spin 1s linear infinite; }
@keyframes spin { to { transform: rotate(360deg); } }
.footer { text-align: center; color: var(--muted); font-size: .8rem; padding: 30px 20px; }
@media (max-width: 768px) {
  .navbar nav a { margin-left: 4px; padding: 6px 8px; font-size: .75rem; }
}
</style>
</head>
<body>

<header class="navbar">
  <div class="brand">
    <i class="fa-solid fa-graduation-cap"></i>
    <span id="schoolName">Brian School Results</span>
  </div>
  <nav>
    <a href="./dashboard.html">
    <a href="./students.html">
    <a href="./settings.html">
  </nav>
</header>

<div class="container" id="mainContent">
  <div class="loading">
    <i class="fa fa-spinner"></i>
    <p>Inapakia dashboard...</p>
  </div>
</div>

<div class="toast" id="toast"></div>

<script type="module">
import { auth, db } from './js/firebase-config.js';
import { watchAuth, logout, getUserProfile } from './js/auth.js';
import { loadSettings } from './js/seed.js';
import { collection, getDocs } from "https://www.gstatic.com/firebasejs/12.19.0/firebase-firestore.js";

var savedTheme = localStorage.getItem('theme') || 'light';
document.documentElement.dataset.theme = savedTheme;
var themeIcon = document.querySelector('#themeToggle i');
if (themeIcon) themeIcon.className = savedTheme === 'light' ? 'fa fa-moon' : 'fa fa-sun';

function toast(msg, type) {
  type = type || '';
  var t = document.getElementById('toast');
  t.textContent = msg;
  t.className = 'toast show ' + type;
  setTimeout(function() { t.className = 'toast'; }, 4000);
}

watchAuth(async function(user) {
  if (!user) { window.location.href = 'index.html'; return; }
  await loadDashboard(user);
});

document.addEventListener('click', function(e) {
  if (e.target.closest('#themeToggle')) {
    e.preventDefault();
    var t = document.documentElement.dataset.theme === 'light' ? 'dark' : 'light';
    document.documentElement.dataset.theme = t;
    localStorage.setItem('theme', t);
    var icon = document.querySelector('#themeToggle i');
    icon.className = t === 'light' ? 'fa fa-moon' : 'fa fa-sun';
  }
  if (e.target.closest('#logoutBtn')) {
    e.preventDefault();
    logout();
  }
});

async function loadDashboard(user) {
  try {
    var profile = await getUserProfile(user.uid);
    var userName = profile ? profile.name : 'Admin';
    var settings = await loadSettings();
    var s = settings.school;

    if (s && s.schoolName) {
      document.getElementById('schoolName').textContent = s.schoolName;
    }

    var studentsSnap = await getDocs(collection(db, 'students'));
    var examsSnap    = await getDocs(collection(db, 'exams'));
    var marksSnap    = await getDocs(collection(db, 'marks'));
    var resultsSnap  = await getDocs(collection(db, 'results'));
    var usersSnap    = await getDocs(collection(db, 'users'));

    var studentCount = studentsSnap.size;
    var examCount    = examsSnap.size;
    var marksCount   = marksSnap.size;
    var resultCount  = resultsSnap.size;

    var teacherCount = 0;
    usersSnap.forEach(function(d) {
      if (d.data().role === 'teacher') teacherCount++;
    });

    var subjectsList = settings.subjects || [];
    var classesList  = settings.classes  || [];
    var streamsList  = settings.streams  || [];

    var html = '';
    html += '<h1>Karibu, ' + userName + '! 👋</h1>';
    html += '<p class="subtitle">';
    if (s) {
      html += s.schoolName + ' &bull; ' + s.district + ', ' + s.region + ' &bull; ' + s.academicYear;
    } else {
      html += 'Brian School Results Management System';
    }
    html += '</p>';

    html += '<div class="grid grid-4">';
    html += statCard('fa-users', 'Wanafunzi', studentCount);
    html += statCard('fa-chalkboard-user', 'Walimu', teacherCount);
    html += statCard('fa-book', 'Masomo', subjectsList.length);
    html += statCard('fa-school', 'Madarasa', classesList.length);
    html += statCard('fa-layer-group', 'Streams', streamsList.length);
    html += statCard('fa-file-pen', 'Mitihani', examCount);
    html += statCard('fa-clipboard-check', 'Alama', marksCount);
    html += statCard('fa-award', 'Matokeo', resultCount);
    html += '</div>';

    html += '<div class="card" style="margin-top:20px">';
    html += '<h3><i class="fa fa-database"></i> Hali ya Database</h3>';
    html += '<ul>';
    html += '<li>✅ <strong>settings/school</strong> — ' + (s ? s.schoolName : 'HAIPO') + '</li>';
    html += '<li>✅ <strong>settings/subjectGrades</strong> — ' + settings.subjectGrades.length + ' grades</li>';
    html += '<li>✅ <strong>settings/totalGrades</strong> — ' + settings.totalGrades.length + ' grades</li>';
    html += '<li>✅ <strong>settings/subjects</strong> — ' + subjectsList.length + ' masomo</li>';
    html += '<li>✅ <strong>settings/classes</strong> — ' + classesList.length + ' madarasa</li>';
    html += '<li>✅ <strong>settings/streams</strong> — ' + streamsList.length + ' streams</li>';
    html += '<li>📊 <strong>students</strong> — ' + studentCount + ' wanafunzi</li>';
    html += '<li>📊 <strong>exams</strong> — ' + examCount + ' mitihani</li>';
    html += '</ul>';
    html += '</div>';

    html += '<div class="grid grid-2">';
    html += '<div class="card">';
    html += '<h3><i class="fa fa-book"></i> Masomo</h3><ul>';
    subjectsList.forEach(function(x) {
      html += '<li>📘 <strong>' + x.name + '</strong> <span style="color:var(--muted)">(' + x.code + ')</span></li>';
    });
    html += '</ul></div>';

    html += '<div class="card">';
    html += '<h3><i class="fa fa-school"></i> Madarasa</h3><ul>';
    classesList.forEach(function(x) {
      html += '<li>🏫 <strong>' + x.name + '</strong> <span style="color:var(--muted)">(' + x.code + ')</span></li>';
    });
    html += '</ul></div>';
    html += '</div>';

    html += '<div class="footer"><i class="fa fa-shield-alt"></i> Brian School Results Management System v1.0</div>';

    document.getElementById('mainContent').innerHTML = html;
    toast('Dashboard imepakiwa!', '');

  } catch (err) {
    console.error('Dashboard error:', err);
    document.getElementById('mainContent').innerHTML =
      '<div class="card"><h3>❌ Kosa</h3><p>' + err.message + '</p></div>';
  }
}

function statCard(icon, label, value) {
  return '<div class="stat"><div class="icon"><i class="fa ' + icon + '"></i></div>' +
    '<div><div class="label">' + label + '</div>' +
    '<div class="value">' + value + '</div></div></div>';
}
</script>
</body>
</html>