// @deno-types="https://cdn.sheetjs.com/xlsx-0.20.3/package/types/index.d.ts"
import * as XLSX from "https://cdn.sheetjs.com/xlsx-0.20.3/package/xlsx.mjs";

// --- Template 1: Students ---
{
  const wb = XLSX.utils.book_new();
  const ws = XLSX.utils.aoa_to_sheet([
    [
      null,
      null,
      null,
      "Promotion peut etre vide mais doit prealablement Exister",
    ],
    ["Nom", "Prenom", "Numero-etudiant", "Promotion"],
    ["NOM", "PRENOM", 12345678, "3AFISE24-25"],
  ]);
  XLSX.utils.book_append_sheet(wb, ws, "Eleves");
  XLSX.writeFile(wb, "static/templates/modele_etudiants.xlsx");
  console.log("Created static/templates/modele_etudiants.xlsx");
}

// --- Template 2: Notes ---
{
  const headers = [
    null,
    null,
    "MOD01 - Module 1",
    "MOD02 - Module 2",
    "MOD03 - Module 3",
  ];
  const coeffs = [null, null, 2, 3, 2];
  const row1 = ["NOM", "PRENOM", 12, 15.5, 14];
  const row2 = ["DUPONT", "JEAN", 8, 10, 16.5];

  const wb = XLSX.utils.book_new();
  const ws = XLSX.utils.aoa_to_sheet([headers, coeffs, row1, row2]);
  XLSX.utils.book_append_sheet(wb, ws, "Session 1");
  XLSX.writeFile(wb, "static/templates/modele_notes.xlsx");
  console.log("Created static/templates/modele_notes.xlsx");
}

// --- Template 3: Maquette ---
{
  const data = [
    ["Intitule du diplome", null, "Informatique - Annee 20.. - 20.."],
    [
      "Description des UE du diplome",
      null,
      null,
      null,
      null,
      null,
      "Nombre d'heures",
    ],
    [
      "Annee\nSemestres",
      "Codes APOGEE",
      null,
      null,
      "Credits\n ECTS",
      "Coeff.",
      "CM",
      "TD",
      "TP",
    ],
    ["INFO3A", null, null, null, "ECTS", "Coef", "CM", "TD", "TP"],
    ["SEM 5", null, null, null, 30],
    ["UE", "CODE_UE1", "Nom de l'UE 1", null, 6],
    [null, "MOD01", null, "Module 1", null, 2, 10, 10, 10],
    [null, "MOD02", null, "Module 2", null, 2, 10, 10, 10],
    [null, "MOD03", null, "Module 3", null, 2, 10, 10, 10],
    [],
    ["UE", "CODE_UE2", "Nom de l'UE 2", null, 4],
    [null, "MOD04", null, "Module 4", null, 2, 10, 10, 10],
    [null, "MOD05", null, "Module 5", null, 2, 10, 10, 10],
  ];

  const wb = XLSX.utils.book_new();
  const ws = XLSX.utils.aoa_to_sheet(data);
  XLSX.utils.book_append_sheet(wb, ws, "Maquette");
  XLSX.writeFile(wb, "static/templates/modele_maquette.xlsx");
  console.log("Created static/templates/modele_maquette.xlsx");
}