// ================================================================
// SCRIPT DONG BO DOD - CHI CAN CAI 1 LAN, KHONG BAO GIO SUA LAI
// Logic cao va giao dien deu tu dong cap nhat tu server
// ================================================================

var LOGIC_URL = "https://researchsampletracker.vercel.app/api/sync-logic";
var UI_URL    = "https://researchsampletracker.vercel.app/api/sync-ui";
var MASTER_ID = "1SIoVJCcQCy1ttzHumQPP75EyEzjb3xxIHpIwXOuk-6M";

// Giao dien - fetch truc tiep tu server (khong co HTML trong script)
function doGet(e) {
  var html = UrlFetchApp.fetch(UI_URL, { muteHttpExceptions: true }).getContentText();
  return HtmlService.createHtmlOutput(html)
    .setTitle("Dong bo du lieu DOD")
    .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}

// Lay thong tin khoi tao: email + danh sach file can cao
function getInitData() {
  var email = (Session.getActiveUser().getEmail() || Session.getEffectiveUser().getEmail()).toLowerCase().trim();
  var masterSS = SpreadsheetApp.openById(MASTER_ID);
  var sheet = masterSS.getSheetByName("link DOD tong");
  var lastRow = sheet.getLastRow();
  var tasks = [];
  if (lastRow >= 2) {
    var data = sheet.getRange(2, 1, lastRow - 1, 4).getValues();
    for (var i = 0; i < data.length; i++) {
      var link = data[i][1] ? data[i][1].toString().trim() : "";
      var ncvEmail = data[i][3] ? data[i][3].toString().toLowerCase().trim() : "";
      if (ncvEmail === email && link.indexOf("http") !== -1) {
        tasks.push({ url: link, productName: data[i][0], ncvEmail: email });
      }
    }
  }
  return { email: email, tasks: tasks };
}

// Cao 1 file - fetch logic moi nhat tu server roi chay
// Canh bao email tu dong duoc gui neu phat hien xu huong bat thuong
function syncSingleFile(url, productName, ncvEmail) {
  try {
    var logicCode = UrlFetchApp.fetch(LOGIC_URL, { muteHttpExceptions: true }).getContentText();
    eval(logicCode);
    // _dodRemoteSync nhan email de gui canh bao tu dong
    return _dodRemoteSync(url, productName, ncvEmail);
  } catch(err) {
    return { success: false, error: "Loi tai logic: " + err.message };
  }
}

function syncUserGmail() { return { count: 0 }; }