script.js

// ================= SUPABASE SETUP =================
const SUPABASE_URL = "https://gunkkbepdlsdwgxgpcxj.supabase.co";
const SUPABASE_ANON_KEY = "sb_publishable__peI72hPciL0iaBVn0odIg_Uv6D1OTz";

const supabaseClient = window.supabase.createClient(
  SUPABASE_URL,
  SUPABASE_ANON_KEY
);

let currentUserId = null;
let html5QrCode = null;
let scannedCode = null;
let userMap = {};

// ================= 🔔 CUSTOM NOTIFICATION =================
function showNotify(message) {
  const overlay = document.getElementById("notifyOverlay");
  const text = document.getElementById("notifyMessage");
  if (!overlay || !text) return;

  text.textContent = message;
  overlay.classList.remove("hidden");
}

function closeNotify() {
  document.getElementById("notifyOverlay").classList.add("hidden");
}

// ================= 👤 PROFILE =================
async function ensureProfile(user) {
  const username = user.user_metadata?.username || "unknown";

  const { data } = await supabaseClient
    .from("profiles")
    .select("id")
    .eq("id", user.id)
    .single();

  if (!data) {
    await supabaseClient.from("profiles").insert({
      id: user.id,
      username
    });
  }
}

async function loadUsernames() {
  const { data } = await supabaseClient
    .from("profiles")
    .select("id, username");

  userMap = {};
  data?.forEach(u => userMap[u.id] = u.username);
}

// ================= SELECT ALL (MY BARCODES) =================
function toggleSelectAll(master) {
  document
    .querySelectorAll(".row-check")
    .forEach(cb => cb.checked = master.checked);
}

function syncSelectAll() {
  const all = document.querySelectorAll(".row-check");
  const checked = document.querySelectorAll(".row-check:checked");
  const master = document.getElementById("selectAll");

  if (master) {
    master.checked = all.length && all.length === checked.length;
  }
}

// ================= LOAD USER =================
async function loadUser() {
  const { data } = await supabaseClient.auth.getUser();

  if (!data.user) {
    window.location.href = "../login-UI/signin.html";
    return;
  }

  currentUserId = data.user.id;

  await ensureProfile(data.user);
  await loadUsernames();

  document.getElementById("dashboard-title").textContent =
    `${userMap[currentUserId]} Dashboard`;

  closeScanner(true);
  loadMyBarcodes();
  loadCommonSummary();
}

// ================= TABS =================
function showTab(tabName) {
  document.getElementById("my").classList.add("hidden");
  document.getElementById("common").classList.add("hidden");

  document.querySelectorAll(".tab").forEach(b => b.classList.remove("active"));
  document.getElementById(tabName).classList.remove("hidden");
  event.target.classList.add("active");
}

// ================= SAVE BARCODE =================
async function saveBarcode() {
  const input = document.getElementById("barcode-input");
  const barcode = input.value.trim();

  if (!barcode) {
    showNotify("Please enter a barcode");
    return;
  }

  const { data: existing } = await supabaseClient
    .from("user_scans")
    .select("*")
    .eq("user_id", currentUserId)
    .eq("barcode", barcode)
    .single();

  if (existing) {
    await supabaseClient
      .from("user_scans")
      .update({ quantity: existing.quantity + 1 })
      .eq("id", existing.id);
  } else {
    await supabaseClient
      .from("user_scans")
      .insert({ user_id: currentUserId, barcode, quantity: 1 });
  }

  input.value = "";
  loadMyBarcodes();
  loadCommonSummary();
}

// ================= DELETE SINGLE (MY) =================
async function deleteBarcode(barcode) {
  const { error } = await supabaseClient
    .from("user_scans")
    .delete()
    .eq("user_id", currentUserId)
    .eq("barcode", barcode);

  if (error) {
    showNotify("Delete failed");
    return;
  }

  loadMyBarcodes();
  loadCommonSummary();
}

// ================= BULK DELETE (MY) =================
async function deleteSelected() {
  const checked = document.querySelectorAll(".row-check:checked");

  if (!checked.length) {
    showNotify("No barcodes selected");
    return;
  }

  const barcodes = Array.from(checked).map(cb => cb.dataset.barcode);

  const { error } = await supabaseClient
    .from("user_scans")
    .delete()
    .eq("user_id", currentUserId)
    .in("barcode", barcodes);

  if (error) {
    showNotify("Failed to delete selected");
    return;
  }

  showNotify("Selected barcodes deleted");
  loadMyBarcodes();
  loadCommonSummary();
}

// ================= LOAD MY BARCODES =================
async function loadMyBarcodes() {
  const tbody = document.getElementById("myBarcodesBody");
  tbody.innerHTML = "";

  const { data } = await supabaseClient
    .from("user_scans")
    .select("*")
    .eq("user_id", currentUserId)
    .order("created_at", { ascending: false });

  data.forEach(row => {
    const tr = document.createElement("tr");
    tr.innerHTML = `
      <td>
        <input type="checkbox"
          class="row-check"
          data-barcode="${row.barcode}"
          onchange="syncSelectAll()">
        ${row.barcode}
      </td>
      <td>${row.quantity}</td>
      <td>${new Date(row.created_at).toLocaleDateString()}</td>
      <td>
        <span class="delete" onclick="deleteBarcode('${row.barcode}')">🗑</span>
      </td>
    `;
    tbody.appendChild(tr);
  });

  syncSelectAll();
}

// ================= COMMON SUMMARY =================
async function loadCommonSummary() {
  const tbody = document.getElementById("commonSummaryBody");
  tbody.innerHTML = "";

  const { data } = await supabaseClient
    .from("user_scans")
    .select("barcode, quantity, user_id");

  const summary = {};

  data.forEach(row => {
    if (!summary[row.barcode]) {
      summary[row.barcode] = { total: 0, users: {} };
    }
    summary[row.barcode].total += row.quantity;
    summary[row.barcode].users[row.user_id] =
      (summary[row.barcode].users[row.user_id] || 0) + row.quantity;
  });

  Object.entries(summary).forEach(([barcode, info]) => {
    const usersHtml = Object.entries(info.users)
      .map(([uid, count]) => {
        const name = uid === currentUserId ? "you" : userMap[uid] || "unknown";
        return `<span class="chip">${name}: ${count}</span>`;
      }).join(" ");

    const tr = document.createElement("tr");
    tr.innerHTML = `
      <td>
        <input type="checkbox" class="common-check" data-barcode="${barcode}">
        ${barcode}
      </td>
      <td>${usersHtml}</td>
      <td>${info.total}</td>
      <td>
        <span class="delete" onclick="deleteCommonBarcode('${barcode}')">🗑</span>
      </td>
    `;
    tbody.appendChild(tr);
  });
}

// ================= DELETE COMMON (SINGLE) =================
async function deleteCommonBarcode(barcode) {
  const { error } = await supabaseClient
    .from("user_scans")
    .delete()
    .eq("barcode", barcode);

  if (error) {
    showNotify("Delete failed");
    return;
  }

  loadMyBarcodes();
  loadCommonSummary();
}

// ================= DELETE COMMON (BULK) =================
async function deleteCommonSelected() {
  const checked = document.querySelectorAll(".common-check:checked");

  if (!checked.length) {
    showNotify("No barcodes selected");
    return;
  }

  const barcodes = Array.from(checked).map(cb => cb.dataset.barcode);

  const { error } = await supabaseClient
    .from("user_scans")
    .delete()
    .in("barcode", barcodes);

  if (error) {
    showNotify("Failed to delete selected");
    return;
  }

  showNotify("Selected barcodes deleted");
  loadMyBarcodes();
  loadCommonSummary();
}

// ================= CAMERA =================
function openScanner() {
  document.getElementById("scannerOverlay").classList.remove("hidden");
  scannedCode = null;

  html5QrCode = new Html5Qrcode("reader");
  html5QrCode.start(
    { facingMode: "environment" },
    { fps: 10, qrbox: { width: 250, height: 150 } },
    text => scannedCode = text
  );
}

function tryAgain() {
  closeScanner();
  openScanner();
}

function saveScanned() {
  if (!scannedCode) {
    showNotify("No barcode detected yet");
    return;
  }
  document.getElementById("barcode-input").value = scannedCode;
  saveBarcode();
  closeScanner();
}

function closeScanner(force = false) {
  if (html5QrCode) {
    html5QrCode.stop().catch(() => {});
    html5QrCode = null;
  }
  document.getElementById("scannerOverlay").classList.add("hidden");
}
 
//excel my barcode//
async function downloadMyBarcodesExcel() {
  const { data, error } = await supabaseClient
    .from("user_scans")
    .select("barcode, quantity, created_at")
    .eq("user_id", currentUserId)
    .order("created_at", { ascending: false });

  if (error || !data.length) {
    showNotify("No data to export");
    return;
  }

  const formatted = data.map(row => ({
    Barcode: row.barcode,
    Quantity: row.quantity,
    "Last Scanned": new Date(row.created_at).toLocaleDateString()
  }));

  const worksheet = XLSX.utils.json_to_sheet(formatted);
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, "My Barcodes");

  XLSX.writeFile(workbook, "my-barcodes.xlsx");
}

//excel common summary//
async function downloadCommonSummaryExcel() {
  const { data, error } = await supabaseClient
    .from("user_scans")
    .select("barcode, quantity, user_id");

  if (error || !data.length) {
    showNotify("No data to export");
    return;
  }

  const summary = {};

  data.forEach(row => {
    if (!summary[row.barcode]) {
      summary[row.barcode] = {
        users: {},
        total: 0
      };
    }

    const username =
      row.user_id === currentUserId
        ? "you"
        : userMap[row.user_id] || "unknown";

    summary[row.barcode].users[username] =
      (summary[row.barcode].users[username] || 0) + row.quantity;

    summary[row.barcode].total += row.quantity;
  });

  const rows = Object.entries(summary).map(([barcode, info]) => {
    const userCounts = Object.entries(info.users)
      .map(([name, count]) => `${name}: ${count}`)
      .join(", ");

    return {
      Barcode: barcode,
      "User Counts": userCounts,
      Total: info.total
    };
  });

  const worksheet = XLSX.utils.json_to_sheet(rows);
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, "Common Summary");

  XLSX.writeFile(workbook, "common-summary.xlsx");
}

//logout//
async function logout() {
  await supabaseClient.auth.signOut();

  // force-clear browser state
  localStorage.clear();
  sessionStorage.clear();

  window.location.href = "../login-UI/signin.html";
}

// ================= INIT =================
loadUser();