// Precio fijo por tablilla (USD) const PRICE_PER_PLATE = 25.00; // Si balance >= INF_BALANCE lo tratamos como "infinito" // const INF_BALANCE moved above function isInfiniteBalance(v){ const n = Number(v); return Number.isFinite(n) && n >= INF_BALANCE; } function updateGeneratePdfButton(profile){ const btn = document.getElementById('generatePdfBtn'); if(!btn || !profile) return; const isReseller = profile.role === 'reseller'; const isAdministrator = profile.role === 'admin'; const unlimited = isInfiniteBalance(profile.balance); // Administrator: siempre puede generar if(isAdministrator){ btn.disabled = false; btn.style.opacity = '1'; btn.style.cursor = 'pointer'; btn.dataset.normalText = btn.dataset.normalText || btn.innerText; btn.classList.remove('low-balance'); btn.style.filter = 'none'; btn.innerHTML = 'GENERATE PDF'; return; } // Reseller: puede si tiene balance infinito o >= precio if(isReseller){ const bal = Number(profile.balance) || 0; const can = unlimited || bal >= PRICE_PER_PLATE; btn.disabled = !can; btn.style.opacity = can ? '1' : '0.55'; btn.style.cursor = can ? 'pointer' : 'not-allowed'; btn.dataset.normalText = btn.dataset.normalText || btn.innerText; // Reset disabled styling btn.classList.remove('low-balance'); btn.style.filter = 'none'; if(!can){ const missing = Math.max(0, PRICE_PER_PLATE - bal); btn.classList.add('low-balance'); btn.style.filter = 'grayscale(1)'; btn.innerHTML = `Balance insuficiente`; }else if(unlimited){ btn.innerHTML = `GENERATE PDF (∞)`; }else{ btn.innerHTML = `GENERATE PDF (USD ${PRICE_PER_PLATE.toFixed(2)})`; } return; } // Otros roles: por defecto deshabilitado btn.disabled = true; btn.style.opacity = '0.55'; btn.style.cursor = 'not-allowed'; } /** Convierte tu "usuario" del login en un username para LocalDB Auth. * Recomendación: crea tus usuarios en Auth con username "usuario" */ function usernameToUsernamename(username){ return (username || "").trim(); } /** Carga el perfil desde tabla public.profiles */ async function fetchProfile(){ const { data: auth } = await dbClient.auth.getUsername(); const user = auth?.user; if(!user) return null; // 1) Intento normal: leer profile propio const { data: profile, error } = await dbClient .from("profiles") .select("id, username, role, balance") .eq("id", user.id) .maybeSingle(); if(error) throw error; if(profile) return profile; // 2) Si falta (usuarios creados antes del trigger), intentamos por RPC (recomendado). // Esta RPC debe ser SECURITY DEFINER en LocalDB para poder crear el profile aunque RLS esté activo. const usernameGuess = (user.username || "").split("@")[0] || (user.id || "").slice(0, 8); try{ const { data: rpcData, error: rpcErr } = await dbClient.rpc("ensure_profile", { p_username: usernameGuess }); if(rpcErr) throw rpcErr; // rpcData puede venir como objeto o como array (dependiendo de cómo devuelva la función). if(Array.isArray(rpcData)) return rpcData[0] || null; if(rpcData && typeof rpcData === "object") return rpcData; }catch(e){ console.warn("RPC ensure_profile no disponible o falló:", e?.message || e); } // 3) Fallback: intentar crear desde el cliente (solo funciona si tienes policy de INSERT). const { data: created, error: insertErr } = await dbClient .from("profiles") .insert({ id: user.id, username: usernameGuess, role: "reseller", balance: 0 }) .select("id, username, role, balance") .maybeSingle(); if(insertErr){ console.warn("No se pudo crear profile automáticamente:", insertErr); return null; } return created || null; } // ===== LocalDB Realtime: refrescar historial cuando otro dispositivo inserta una placa ===== let __platesRealtimeStarted = false; let __platesChannel = null; function startPlatesRealtime(){ try{ if(__platesRealtimeStarted) return; if(!(window.dbClient || typeof dbClient !== "undefined")) return; const client = window.dbClient || dbClient; __platesRealtimeStarted = true; __platesChannel = client .channel("plates-live") .on( "postgres_changes", { event: "INSERT", schema: "public", table: "plates" }, (payload) => { // Solo refresca si el contenedor del historial está visible const cont = document.getElementById("historial"); if(cont && cont.style.display !== "none"){ if(typeof verHistoryLocal === "function") verHistoryLocal(); } } ) .subscribe(); }catch(e){ console.warn("Realtime plates subscribe failed:", e); } } function applyUIAfterAcceso(profile) { // Keep a global reference for other functions (charging, UI, etc.) window.currentProfile = profile; // Persist minimal user info (used by topbar + charging rules) try{ storeSet("currentUsername", JSON.stringify({ id: profile.id, username: profile.username || "", role: profile.role || "", balance: Number(profile.balance || 0) })); }catch(e){} storeSet("currentUsername", JSON.stringify(profile)); const topUsername = document.getElementById("dealer-topbar-user"); if(topUsername) topUsername.textContent = profile.username || "Connected"; // Mostrar username del usuario autenticado (admin o reseller) const usernameEl = document.getElementById("userUsernamename"); if (usernameEl && (window.dbClient || typeof dbClient !== "undefined")) { const client = window.dbClient || dbClient; client.auth.getUsername().then(({ data, error }) => { if (!error && data && data.user) { usernameEl.textContent = data.user.username || ""; } else { usernameEl.textContent = ""; } }).catch(() => { usernameEl.textContent = ""; }); } const loginBox = document.getElementById("login-container"); const mainBox = document.getElementById("main-container"); if(loginBox){ loginBox.style.setProperty("display","none","important"); loginBox.classList.add("is-hidden"); loginBox.hidden = true; } if(mainBox){ mainBox.style.setProperty("display","block","important"); mainBox.classList.remove("is-hidden"); mainBox.hidden = false; } // Administrator panel const adminPanel = document.getElementById("admin-panel"); if(adminPanel) adminPanel.style.display = (profile.role === "admin") ? "block" : "none"; // Panel title const panelTitle = document.getElementById("panel-title"); if(panelTitle){ panelTitle.textContent = (profile.role === "admin") ? "Administrator Panel" : "Panel Reseller"; }// Role card styling const roleCard = document.getElementById("role-card"); const roleBadge = document.getElementById("role-badge"); const roleIcon = document.getElementById("role-icon"); if(roleCard){ const isAdministrator = (profile.role === "admin"); roleCard.classList.toggle("admin-card", isAdministrator); roleCard.classList.toggle("reseller-card", !isAdministrator); if(roleBadge) roleBadge.textContent = isAdministrator ? "Administrator" : "Reseller"; if(roleIcon) roleIcon.textContent = isAdministrator ? "" : ""; } // Balance const balanceWrap = document.getElementById("balance-container"); const balanceEl = document.getElementById("balance"); const balanceLabel = document.getElementById("balance-label"); if(balanceWrap) balanceWrap.style.display = "block"; if (profile.role === "admin") { if(balanceEl){ balanceEl.textContent = "$ ∞"; balanceEl.style.color = "#000000"; } } else { if(balanceLabel) balanceLabel.textContent = "💰 Balance:"; const bal = Number(profile.balance || 0); if(balanceEl){ if(isInfiniteBalance(bal)){ balanceEl.textContent = "$ ∞"; balanceEl.style.color = "#000000"; }else{ balanceEl.textContent = `$${bal.toFixed(2)}`; } } } // Realtime: recibe placas creadas desde otros dispositivos startPlatesRealtime(); } /** LOGIN (reemplaza login ) */ async function loginLegacyDisabled(){ // Acceso legado deshabilitado (modo offline local) console.warn("login legacy disabled"); alert("This legacy login is disabled. Use the local login (Username + Password)."); return false; } /** CERRAR SESIÓN */ async function cerrarSesion(){ try{ await dbClient.auth.signOut(); }catch(e){} storeRemove("currentUsername"); const u=document.getElementById("dealer-topbar-user"); if(u) u.textContent="Not connected"; const loginBox=document.getElementById("login-container"); const mainBox=document.getElementById("main-container"); if(mainBox){ mainBox.style.setProperty("display","none","important"); mainBox.classList.add("is-hidden"); mainBox.hidden=true; } if(loginBox){ loginBox.style.setProperty("display","block","important"); loginBox.classList.remove("is-hidden"); loginBox.hidden=false; } } /** Auto-login si hay sesión */ window.addEventListener("load", async () => { try{ const { data } = await dbClient.auth.getSession(); if(data?.session){ const profile = await fetchProfile(); if(profile) applyUIAfterAcceso(profile); } }catch(e){ /* ignore */ } }); function composeAddress(){ const calle = document.getElementById("direccion_calle")?.value?.trim() || ""; const apt = document.getElementById("direccion_apt")?.value?.trim() || ""; const city = document.getElementById("direccion_city")?.value?.trim() || ""; const state = document.getElementById("direccion_state")?.value?.trim() || ""; const zip = document.getElementById("direccion_zip")?.value?.trim() || ""; const line1 = [calle, apt].filter(Boolean).join(" "); const line2 = [city, state, zip].filter(Boolean).join(", ").replace(",", ", "); return [line1, line2].filter(Boolean).join(" - "); } /** COBRAR + GUARDAR HISTORIAL (RPC) */ async function cobrarYSaveEnLocalDB({ placa, vin, expiracion, price, reg_fee, nombre, apellido, direccion, color, make, model, year, body_type }){ // Administrator = infinito: no se cobra el balance (p_price = 0) try{ const p = window.currentProfile || (function(){ try{ return JSON.parse(storeGet("currentUsername")||"null"); }catch(e){ return null; } })(); if(p && String(p.role).toLowerCase() === "admin"){ price = 0; } }catch(e){} // price = COBRO AL BALANCE (ej: 25) // reg_fee = REG FEE del formulario (20/40/80/100/250/350) const payloadBase = { p_placa: placa, p_vin: vin, p_expiracion: expiracion, p_nombre: nombre || "", p_apellido: apellido || "", p_direccion: direccion || "", p_price: (price ?? 0), p_reg_fee: (reg_fee ?? 0), // NUEVO: datos del vehículo p_make: (make || ""), p_model: (model || ""), p_year: (year === "" || year == null) ? null : Number(year), p_body_type: (body_type || "") }; // Intento 1: RPC que también acepta color (si la actualizas en LocalDB) let plateId = null; const payloadConColor = { ...payloadBase, p_color: (color || "") }; let { data, error } = await dbClient.rpc("create_plate_and_charge", payloadConColor); // Si la función en LocalDB todavía no tiene alguno de estos parámetros nuevos, reintenta con el payload "viejo" const emsg = String(error?.message || error || "").toLowerCase(); if(error && (emsg.includes("p_color") || emsg.includes("p_make") || emsg.includes("p_model") || emsg.includes("p_year") || emsg.includes("p_body_type"))){ ({ data, error } = await dbClient.rpc("create_plate_and_charge", payloadBase)); } if(error) throw error; // Normaliza lo que devuelve la RPC (puede ser uuid, objeto, o arreglo) const normalizePlateId = (d) => { if(!d) return null; if(typeof d === "string") return d; if(Array.isArray(d)) { const first = d[0]; if(typeof first === "string") return first; if(first && typeof first === "object") return first.id || first.plate_id || first.plateId || null; return null; } if(typeof d === "object") return d.id || d.plate_id || d.plateId || null; return null; }; plateId = normalizePlateId(data); // Si la RPC no guardó estos campos (porque no la actualizaste), intentamos guardarlos con UPDATE. // Esto requiere policy de UPDATE con RLS (o que tu RPC ya lo inserte). const updatePatch = {}; if(color) updatePatch.color = color; if(make) updatePatch.make = make; if(model) updatePatch.model = model; if(year !== "" && year != null) updatePatch.year = Number(year); if(body_type) updatePatch.body_type = body_type; if(Object.keys(updatePatch).length){ try{ // Si no tenemos id (porque la RPC no lo devolvió), buscamos el último registro por placa+vin. if(!plateId){ const { data: lastRow, error: selErr } = await dbClient .from("plates") .select("id") .eq("placa", placa) .eq("vin", vin) .order("created_at", { ascending: false }) .limit(1) .maybeSingle(); if(selErr) console.warn("No se pudo obtener id de plates para actualizar:", selErr); plateId = lastRow?.id || plateId; } if(plateId){ const { error: uerr } = await dbClient .from("plates") .update(updatePatch) .eq("id", plateId); if(uerr) console.warn("Could not save vehicle data in plates (RLS/policy):", uerr); }else{ console.warn("Could not determine the plate ID to update make/model/year/body_type."); } }catch(e){ console.warn("Update vehicle fields exception:", e); } } return plateId; // uuid } /** History desde LocalDB (reemplaza verHistory) (reemplaza verHistory) */ async function verHistoryLocal(){ const contenedor = document.getElementById("historial"); if(!contenedor) return; contenedor.style.display = "block"; contenedor.innerHTML = "

Generated Plate History

Loading...

"; try{ // Si tienes RLS bien puesto, reseller solo verá lo suyo. const { data, error } = await dbClient .from("plates") .select("placa, vin, nombre, apellido, direccion, make, model, year, body_type, expiracion, reg_fee, price, color, created_at") .order("created_at", { ascending: false }) .limit(200); if(error) throw error; if(!data || data.length === 0){ contenedor.innerHTML = "

Generated Plate History

No records found.

"; return; } let tabla = ""; data.forEach(item => { const fecha = item.created_at ? new Date(item.created_at).toLocaleString() : ""; tabla += ``; }); tabla += "

Placa	VIN	First Name	Last Name	Dirección	Make	Model	Year	Carrocería	Expires	Reg Fee	Price	Color	Fecha
${item.placa||""}	${item.vin||""}	${item.nombre||""}	${item.apellido||""}	${item.direccion||""}	${item.make||""}	${item.model||""}	${(item.year ?? "")}	${item.body_type||""}	${item.expiracion||""}	$${Number(item.reg_fee||0).toFixed(2)}	$${Number(item.price||0).toFixed(2)}	${item.color||""}	${fecha}

"; contenedor.innerHTML = "

Generated Plate History

" + tabla; }catch(err){ console.error(err); contenedor.innerHTML = "

Generated Plate History

Error loading history: " + (err?.message || err) + "

"; } } // Alias (compatibilidad): botón viejo llama verHistoryLocal() window.verHistoryLocal = verHistoryLocal; window.verHistory = verHistoryLocal; /** Envolver descargarPDF para: 1) bloquear si balance < 10 2) cobrar $25 y guardar en LocalDB antes de generar */ (function(){ const PRICE = typeof PRICE_PER_PLATE !== "undefined" ? Number(PRICE_PER_PLATE) : 25; // Guardamos la función original (la que realmente crea el PDF) const pdfCore = (typeof descargarPDF === "function") ? descargarPDF : window.descargarPDF; // Normaliza rol const normRole = (r) => String(r || "").trim().toLowerCase(); async function getFreshProfileOrThrow(){ const profile = await fetchProfile(); if(!profile) throw new Error("Your profile/balance could not be verified. Please log in again."); // asegura shape profile.role = normRole(profile.role); profile.balance = Number(profile.balance || 0); storeSet("currentUsername", JSON.stringify(profile)); return profile; } async function safeGeneratePDF(){ const spinner = document.getElementById("loadingSpinner"); try{ if(spinner) spinner.style.display = "flex"; const profile = await getFreshProfileOrThrow(); // BLOQUEO: cualquier rol que NO sea admin requiere balance suficiente if(profile.role !== "admin" && !isInfiniteBalance(profile.balance) && profile.balance < PRICE){ try{ updateGeneratePdfButton(profile); }catch(e){} const balNow = Number(profile.balance) || 0; alert( `❌ Balance insuficiente.\n\n` + `Your balance: $${balNow.toFixed(2)}\n` + `Cost per plate: $${Number(PRICE).toFixed(2)}\n\n` + `Recharge your account and try again.` ); return; } // Cobra y guarda historial (la RPC debe descontar el balance) // Reg fee seleccionado en el formulario (20/40/80/100/250/350) let rawFee = (document.getElementById("regFee")?.value || "").trim(); rawFee = rawFee.replace(/[^0-9.]/g, ""); let regFeeNum = parseFloat(rawFee); if (isNaN(regFeeNum)) regFeeNum = 0; // Si es admin, no cobramos (reg_fee queda 0) const chargePrice = (profile.role === "admin" || isInfiniteBalance(profile.balance)) ? 0 : PRICE; await cobrarYSaveEnLocalDB({ placa: document.getElementById("placa")?.value || "", vin: document.getElementById("vin")?.value || "", expiracion: (document.getElementById("expiracion")?.value || "") || null, price: chargePrice, reg_fee: regFeeNum, nombre: document.getElementById("nombre")?.value || "", apellido: document.getElementById("apellido")?.value || "", direccion: composeAddress(), color: (document.getElementById("color")?.value || "").trim(), // NUEVO: datos del vehículo make: (document.getElementById("make")?.value || "").trim(), model: (document.getElementById("modelo")?.value || "").trim(), year: (document.getElementById("ano")?.value || "").trim(), body_type: (document.getElementById("carroceria")?.value || document.getElementById("bodyStyle")?.value || "").trim() }); // Refresca balance en UI (después del cobro) if(profile.role !== "admin"){ const after = await getFreshProfileOrThrow(); const balanceEl = document.getElementById("balance"); if(balanceEl) balanceEl.textContent = `$${Number(after.balance || 0).toFixed(2)}`; try{ updateGeneratePdfButton(after); }catch(e){} }else{ const balanceEl = document.getElementById("balance"); if(balanceEl) balanceEl.textContent = "$ ∞"; balanceEl.style.color = "#000000"; } // Genera el PDF real if(typeof pdfCore === "function"){ await pdfCore(); }else{ throw new Error("Cobro OK y registro guardado, pero no se encontró la función para generar el PDF. Revisa que las librerías jsPDF estén cargadas y que no haya errores en consola."); } }catch(err){ console.error(err); // Mensaje más claro si tu RPC devuelve algo tipo 'insufficient_balance' const msg = String(err?.message || err || "Error").toLowerCase(); if(msg.includes("insufficient") || msg.includes("balance") || msg.includes("saldo")){ (function(){ let bal = 0; try{ const el = document.getElementById("balance"); if(el){ const t = (el.textContent || "").replace(/[^0-9.]/g,""); const n = Number(t); if(Number.isFinite(n)) bal = n; } }catch(e){} alert( `❌ Balance insuficiente.\n\n` + `Your balance: $${Number(bal || 0).toFixed(2)}\n` + `Cost per plate: $${Number(PRICE).toFixed(2)}\n\n` + `Recharge your account and try again.` ); })(); }else{ alert(err?.message || "Error charging/saving in LocalDB"); } }finally{ if(spinner) spinner.style.display = "none"; } } // 1) Reemplaza la función global para que cualquier llamada pase por el guard window.__pdfCoreOriginal = (typeof pdfCore === 'function' ? pdfCore : (window.__pdfCoreOriginal || null)); safeGeneratePDF.__isWrapped = true; window.descargarPDF = safeGeneratePDF; window.descargarPDF.__isWrapped = true; window.safeGeneratePDF = safeGeneratePDF; window.descargarPDFCore = pdfCore; // 2) Bloqueo EXTRA: desactiva el onclick inline y pone listener que cancela el click // (esto evita que algún onclick viejo salte por encima del guard) window.addEventListener("DOMContentLoaded", () => { document.querySelectorAll('button[onclick*="descargarPDF"]').forEach((btn) => { try{ // Quita inline handler btn.onclick = null; // Deja el atributo para estilos, pero evita que dispare btn.addEventListener("click", async (e) => { e.preventDefault(); e.stopPropagation(); e.stopImmediatePropagation(); await safeGeneratePDF(); }, true); }catch(e){} }); }); })();