// ID SPREADSHEET SESUAI CONFIG
const SPREADSHEET_ID = "1k6W-6C5nH5vtujbWKdVBmmdRkP4k3tNYjDn2qBsHtYU";

function doGet(e) {
  // Penanganan request API eksternal (CORS Bypass)
  if (e && e.parameter && e.parameter.action) {
    return handleGetApiRequests(e);
  }
  // Default: Serve Webpage inside Google domain
  return HtmlService.createTemplateFromFile('Index')
      .evaluate()
      .setTitle('eRapor Informatika')
      .addMetaTag('viewport', 'width=device-width, initial-scale=1');
}

// Handler request GET dari luar (mendukung fetch dari Canvas)
function handleGetApiRequests(e) {
  var action = e.parameter.action;
  var ss = SpreadsheetApp.openById(SPREADSHEET_ID);
  var userSheet = ss.getSheetByName("user");
  var nilaiSheet = ss.getSheetByName("nilai");
  
  var responseData = {};
  
  try {
    if (action === "readAll") {
      var users = userSheet.getDataRange().getValues();
      var nilai = nilaiSheet.getDataRange().getValues();
      var result = [];
      
      // Lewati header (indeks 0)
      for (var i = 1; i < users.length; i++) {
        var nism = users[i][0].toString();
        var dataNilai = { tugas1: 0, tugas2: 0, tugas3: 0, tugas4: 0, tugas5: 0, pat: 0 };
        
        for (var j = 1; j < nilai.length; j++) {
          if (nilai[j][0].toString() === nism) {
            dataNilai = {
              tugas1: Number(nilai[j][1]) || 0,
              tugas2: Number(nilai[j][2]) || 0,
              tugas3: Number(nilai[j][3]) || 0,
              tugas4: Number(nilai[j][4]) || 0,
              tugas5: Number(nilai[j][5]) || 0,
              pat: Number(nilai[j][6]) || 0
            };
            break;
          }
        }
        
        result.push({
          nism: nism,
          nama: users[i][1],
          lp: users[i][2],
          kelas: users[i][3],
          password: users[i][4].toString(),
          role: users[i][5],
          ...dataNilai
        });
      }
      responseData = { status: "success", data: result };
      
    } else if (action === "updateGrade") {
      var nism = e.parameter.nism;
      var data = nilaiSheet.getDataRange().getValues();
      var found = false;
      var newGrades = [
        Number(e.parameter.tugas1) || 0,
        Number(e.parameter.tugas2) || 0,
        Number(e.parameter.tugas3) || 0,
        Number(e.parameter.tugas4) || 0,
        Number(e.parameter.tugas5) || 0,
        Number(e.parameter.pat) || 0
      ];
      
      for (var i = 1; i < data.length; i++) {
        if (data[i][0].toString() === nism) {
          nilaiSheet.getRange(i + 1, 2, 1, 6).setValues([newGrades]);
          found = true;
          break;
        }
      }
      if (!found) {
        nilaiSheet.appendRow([nism, ...newGrades]);
      }
      responseData = { status: "success", message: "Nilai berhasil diperbarui" };
      
    } else if (action === "addStudent") {
      var nism = e.parameter.nism;
      var nama = e.parameter.nama;
      var lp = e.parameter.lp;
      var kelas = e.parameter.kelas;
      var password = e.parameter.password;
      
      // Cari apakah sudah terdaftar
      var users = userSheet.getDataRange().getValues();
      var exists = false;
      for (var i = 1; i < users.length; i++) {
        if (users[i][0].toString() === nism) {
          exists = true; break;
        }
      }
      
      if (exists) {
        responseData = { status: "error", message: "NISM sudah terdaftar!" };
      } else {
        userSheet.appendRow([nism, nama, lp, kelas, password, "siswa"]);
        nilaiSheet.appendRow([nism, 0, 0, 0, 0, 0, 0]);
        responseData = { status: "success", message: "Siswa berhasil didaftarkan" };
      }
      
    } else if (action === "deleteGrades") {
      var nism = e.parameter.nism;
      var data = nilaiSheet.getDataRange().getValues();
      
      for (var i = 1; i < data.length; i++) {
        if (data[i][0].toString() === nism) {
          nilaiSheet.getRange(i + 1, 2, 1, 6).setValues([[0, 0, 0, 0, 0, 0]]);
          break;
        }
      }
      responseData = { status: "success", message: "Nilai berhasil dikosongkan" };
    }
    
  } catch (err) {
    responseData = { status: "error", message: err.toString() };
  }
  
  return ContentService.createTextOutput(JSON.stringify(responseData))
    .setMimeType(ContentService.MimeType.JSON);
}