${mine ? "🧑 Tú" : "🤖 Asistente"}${tools && tools.length ? " · " + tools.join(", ") : ""}
${text}
`; $("chat-history").appendChild(div); $("chat-history").scrollTop = 1e9; } async function loadChatHistory() { const historyEl = $("chat-history"); historyEl.innerHTML = 'Cargando historial...'; const fid = $("select-parcela")?.value || ""; try { let url = "/chat/history/" + sessionId; if (fid) url += "?field_id=" + fid; const r = await api(url); if (r.ok) { const data = await r.json(); historyEl.innerHTML = ""; if (data.length === 0) { historyEl.innerHTML = `Pregúntame sobre el NDVI, el clima o la densidad de tus parcelas.
`; } else { data.forEach((msg) => { appendChat(msg.role, msg.content); }); } } else { historyEl.innerHTML = 'Error al cargar historial.
'; } } catch (e) { historyEl.innerHTML = `Error de red al cargar historial: ${e}
`; } } async function sendChat() { const msg = $("chat-input").value.trim(); if (!msg) return; const fid = $("select-parcela")?.value || null; track("chat_send", { len: msg.length, field_id: fid }); appendChat("user", msg); $("chat-input").value = ""; try { const r = await api("/chat", { method: "POST", body: JSON.stringify({ session_id: sessionId, message: msg, field_id: fid }) }); if (r.ok) { const d = await r.json(); appendChat("assistant", d.reply, (d.tool_logs || []).map((t) => t.tool)); } else { const e = await r.json().catch(() => ({})); appendChat("assistant", "Error: " + (e.detail || r.status)); } } catch (e) { appendChat("assistant", "Error de red: " + e); } } $("btn-chat").addEventListener("click", sendChat); $("chat-input").addEventListener("keydown", (e) => { if (e.key === "Enter") sendChat(); }); // ===== Telemetría Modal ===== function openTelemetryModal() { $("telemetry-modal").classList.remove("hidden"); $("telemetry-modal").classList.add("flex"); $("telemetry-session-id").innerText = sessionId; loadTelemetryEvents(); track("telemetry_open", {}); } function closeTelemetryModal() { $("telemetry-modal").classList.add("hidden"); $("telemetry-modal").classList.remove("flex"); } async function loadTelemetryEvents() { const content = $("telemetry-content"); content.innerHTML = 'Cargando eventos...
'; try { let events = []; try { const r = await api("/events/all?limit=200"); if (r.ok) { events = await r.json(); } } catch {} if (!events || events.length === 0) { try { const r2 = await api("/events/recent?limit=200"); if (r2.ok) { events = await r2.json(); } } catch {} } if (!events || events.length === 0) { content.innerHTML = 'Sin eventos en esta sesión.
'; return; } renderTelemetryEvents(events, content); } catch (e) { content.innerHTML = `Error al cargar eventos: ${e}
`; } } function renderTelemetryEvents(events, container) { const html = events.map((ev) => { const ts = ev.created_at || ev.ts || ""; const time = ts ? new Date(ts).toLocaleTimeString() : ""; const isError = ev.action.includes("error"); const bg = isError ? "bg-red-50 border-red-200" : "bg-stone-50 border-stone-200"; const icon = isError ? "fa-circle-exclamation text-red-500" : "fa-circle-dot text-emerald-500"; const metaStr = ev.meta && Object.keys(ev.meta).length ? JSON.stringify(ev.meta).slice(0, 120) : ""; return `Error al cargar esquema.
'; return; } const d = await r.json(); const tables = d.tables || {}; const shortType = (t) => { if (t.includes("timestamp")) return "timestamptz"; if (t.includes("double")) return "float"; if (t === "USER-DEFINED") return "geometry"; return t; }; let mmd = "erDiagram\n"; for (const [name, cols] of Object.entries(tables)) { mmd += ` ${name} {\n`; for (const c of cols) { const ann = c.name === "id" ? " PK" : c.name.endsWith("_id") ? " FK" : ""; mmd += ` ${shortType(c.type)} ${c.name}${ann}\n`; } mmd += " }\n"; } mmd += ' fields ||--o{ vegetation_indices : "tiene"\n'; mmd += ' fields ||--o{ weather_data : "registra clima"\n'; mmd += ' fields ||--o{ plant_counts : "tiene"\n'; mmd += ' fields ||--o{ events : "genera"\n'; mmd += ' fields ||--o{ chat_messages : "genera"\n'; const id = "er-" + Date.now(); const { svg } = await mermaid.render(id, mmd); el.innerHTML = svg; } catch (e) { el.innerHTML = 'Error al renderizar diagrama ER: ' + String(e?.message || e) + '
'; } } async function loadTableData(table) { $("data-view-title").innerText = `Tabla: ${table}`; $("data-view-content").innerHTML = 'Cargando...
'; try { const r = await api(`/data/${table}`); if (!r.ok) { $("data-view-content").innerHTML = 'Error al cargar. Verifica credenciales.
'; return; } const d = await r.json(); const rows = d.rows || []; $("data-view-count").innerText = `${rows.length} registros`; if (!rows.length) { $("data-view-content").innerHTML = 'Sin registros.
'; return; } const cols = Object.keys(rows[0]); const html = `| ${c} | `).join("")}
|---|
| ${formatCell(row[c])} | `).join("")}
Error: ${e}
`; } } function formatCell(v) { if (v === null || v === undefined) return 'NULL'; if (typeof v === "object") return `${JSON.stringify(v).slice(0, 80)}`;
return String(v).slice(0, 100);
}
$("btn-run-query").addEventListener("click", async () => {
const sql = $("sql-query").value.trim();
if (!sql) return notify("Falta la consulta", "Escribe una consulta SQL.");
$("query-result").innerHTML = 'Ejecutando...
'; try { const r = await api("/data/query", { method: "POST", body: JSON.stringify({ sql }) }); if (!r.ok) { const e = await r.json().catch(() => ({})); $("query-result").innerHTML = `Error: ${e.detail || r.status}
`; return; } const d = await r.json(); const rows = d.rows || []; if (!rows.length) { $("query-result").innerHTML = 'Sin registros.
'; return; } const cols = Object.keys(rows[0]); const html = `| ${c} | `).join("")}
|---|
| ${formatCell(row[c])} | `).join("")}
Error: ${e}
`; } }); $("btn-clear-query").addEventListener("click", () => { $("sql-query").value = ""; $("query-result").innerHTML = ""; }); // ===== Credenciales ===== async function connectUserDatabase() { if (!creds.dbUrl) return null; track("connect_db_attempt", {}); try { const r = await fetch("./api/credentials/connect-db", { method: "POST", headers: { "Content-Type": "application/json", ...authHeaders() }, body: JSON.stringify({ database_url: creds.dbUrl }) }); if (!r.ok) { const e = await r.json().catch(() => ({})); track("connect_db_error", { status: r.status }); notify( r.status === 404 ? "Auto-conexión no disponible" : "Error al conectar la base de datos", r.status === 404 ? "El backend todavía no expone connect-db (pendiente Fase 9)." : (e.detail || `Error ${r.status} al conectar con tu Supabase.`) ); return null; } const data = await r.json(); const migraciones = Array.isArray(data.migrations_applied) ? data.migrations_applied.length : 0; if (migraciones > 0) { notify("Esquema inicializado", `Se creó la arquitectura PostGIS automáticamente (${migraciones} migración(es) aplicadas).`); } else if ((data.existing_parcels ?? 0) > 0) { notify("Base de datos conectada", `Se detectaron ${data.existing_parcels} parcela(s) existentes en tu Supabase.`); } else { notify("Base de datos conectada", "Tu Supabase se conectó correctamente."); } track("connect_db_success", { migraciones, existing_parcels: data.existing_parcels ?? 0 }); updateStatus(); return data; } catch (e) { track("connect_db_error", { error: String(e) }); notify("Error de red", `No se pudo conectar a tu base de datos: ${e}`); return null; } } $("btn-save-creds").addEventListener("click", async () => { creds = { groq: $("in-groq").value, copId: $("in-copid").value, copSecret: $("in-copsecret").value, sbUrl: $("in-sburl").value, sbKey: $("in-sbkey").value, dbUrl: $("cred-db-url").value }; const n = Object.values(creds).filter(Boolean).length; track("creds_set", { count: n }); $("creds-state").innerText = `${n} llave(s) activas (se borran al refrescar)`; notify("Credenciales en sesión", `${n} llave(s) activas solo en esta sesión.`); updateStatus(); checkMissingCredentials(); await connectUserDatabase(); await refreshParcels(); await connectUserProfile(); }); $("btn-check-env").addEventListener("click", async () => { try { const r = await fetch("./api/credentials/status"); if (!r.ok) return notify("No disponible", "No se pudo consultar el .env del servidor."); const s = await r.json(); appEnv = s.env || "development"; const have = Object.entries({ Groq: s.groq, Copernicus: s.copernicus, Supabase: s.supabase }).filter(([, v]) => v).map(([k]) => k); track("env_check", { have, env: appEnv }); if (appEnv === "production") { $("env-status").innerHTML = " Producción: cada usuario debe ingresar sus propias credenciales."; } else { $("env-status").innerHTML = have.length ? `✅ En el servidor (.env): ${have.join(", ")}. Se usan automáticamente; no necesitas reescribirlas aquí.` : "No se detectaron credenciales en el .env del servidor."; } } catch { notify("Error", "No se pudo consultar el .env del servidor."); } }); // ===== Perfiles y Modos de Sesión ===== $("btn-profile-menu").addEventListener("click", (e) => { e.stopPropagation(); $("profile-dropdown").classList.toggle("hidden"); }); document.addEventListener("click", () => { $("profile-dropdown").classList.add("hidden"); }); $("profile-dropdown").addEventListener("click", (e) => { e.stopPropagation(); }); document.querySelectorAll(".dropdown-btn").forEach((btn) => { btn.addEventListener("click", () => { $("profile-dropdown").classList.add("hidden"); switchTab(btn.dataset.action); }); }); $("dropdown-telemetry").addEventListener("click", () => { $("profile-dropdown").classList.add("hidden"); openTelemetryModal(); }); $("dropdown-logout").addEventListener("click", () => { $("profile-dropdown").classList.add("hidden"); logout(); }); $("btn-save-settings").addEventListener("click", async () => { if (isSharedMode) return notify("Modo compartido", "No puedes editar ajustes en modo de solo lectura."); const displayName = $("settings-display-name").value.trim(); const sessionMode = $("settings-session-mode").value; const cfgDbUrl = ($("cfg-db-url")?.value || "").trim(); if (cfgDbUrl) { creds.dbUrl = cfgDbUrl; updateStatus(); } if (!displayName) return notify("Falta el nombre", "Escribe un nombre para el perfil."); if (!profileId) return notify("Error", "No hay un perfil conectado."); try { track("profile_update_attempt", { displayName, sessionMode }); const r = await api(`/profiles/${profileId}`, { method: "PATCH", body: JSON.stringify({ display_name: displayName, session_mode: sessionMode }) }); if (r.ok) { currentProfile = await r.json(); notify("Ajustes guardados", "El perfil se ha actualizado correctamente."); updateProfileUI(); if (sessionMode === "saved") { localStorage.setItem("agrovision_profile_id", profileId); } else { localStorage.removeItem("agrovision_profile_id"); } track("profile_update_success", { displayName, sessionMode }); if (creds.dbUrl) { await connectUserDatabase(); await refreshParcels(); } } else { const e = await r.json().catch(() => ({})); notify("Error " + r.status, e.detail || "No se pudo actualizar el perfil."); } } catch (e) { notify("Error de red", String(e)); } }); $("btn-delete-profile").addEventListener("click", async () => { if (isSharedMode) return notify("Modo compartido", "No puedes eliminar perfiles en modo de solo lectura."); if (!profileId) return; if (!confirm("¿Estás seguro de que deseas eliminar permanentemente tu perfil? Se perderán todas tus preferencias.")) return; try { track("profile_delete_attempt", { profileId }); const r = await api(`/profiles/${profileId}`, { method: "DELETE" }); if (r.ok) { track("profile_delete_success", { profileId }); notify("Perfil eliminado", "Tu perfil ha sido eliminado. Volviendo a sesión efímera."); logout(); } else { const e = await r.json().catch(() => ({})); notify("Error " + r.status, e.detail || "No se pudo eliminar el perfil."); } } catch (e) { notify("Error de red", String(e)); } }); function logout() { track("session_logout", { profileId }); localStorage.removeItem("agrovision_profile_id"); profileId = null; currentProfile = null; creds = {}; $("in-groq").value = ""; $("in-copid").value = ""; $("in-copsecret").value = ""; $("in-sburl").value = ""; $("in-sbkey").value = ""; $("cred-db-url").value = ""; $("cfg-db-url").value = ""; $("creds-state").innerText = "0 llaves activas (se borran al refrescar)"; $("settings-display-name").value = "Agrónomo"; $("settings-session-mode").value = "ephemeral"; updateProfileUI(); updateStatus(); checkMissingCredentials(); refreshParcels(); switchTab("tab-resumen"); notify("Sesión cerrada", "Se han limpiado todas las llaves y preferencias."); } async function connectUserProfile() { if (isSharedMode) return; let sbUrl = creds.sbUrl || creds.dbUrl; if (!sbUrl) { try { const r = await fetch("./api/credentials/status", { headers: authHeaders() }); if (r.ok) { const s = await r.json(); if (s.supabase_url) sbUrl = s.supabase_url; } } catch {} } if (!sbUrl) { profileId = null; currentProfile = null; updateProfileUI(); return; } try { fingerprint = await sha256(sbUrl); track("profile_connect_attempt", { hash: fingerprint }); const r = await fetch("./api/profiles/connect", { method: "POST", headers: { "Content-Type": "application/json" }, body: JSON.stringify({ supabase_url_hash: fingerprint, display_name: $("settings-display-name").value || "Agrónomo" }) }); if (r.ok) { currentProfile = await r.json(); profileId = currentProfile.id; updateProfileUI(); if (currentProfile.active_field_id) { localStorage.setItem("agrovision_last_field_id", currentProfile.active_field_id); } if (currentProfile.session_mode === "saved") { localStorage.setItem("agrovision_profile_id", profileId); } else { localStorage.removeItem("agrovision_profile_id"); } track("profile_connect_success", { profileId, mode: currentProfile.session_mode }); } } catch (e) { track("profile_connect_error", { error: String(e) }); } } async function loadSharedProfile(id) { isSharedMode = true; profileId = id; track("shared_mode_start", { profileId }); document.body.classList.add("shared-read-only"); $("btn-save-parcela").disabled = true; $("btn-save-parcela").classList.add("opacity-50", "cursor-not-allowed"); $("btn-demo").style.display = "none"; $("btn-save-creds").style.display = "none"; $("btn-save-settings").style.display = "none"; $("btn-delete-profile").style.display = "none"; const droneBtn = document.querySelector('[data-tab="tab-vision"]'); if (droneBtn) droneBtn.style.display = "none"; const settingsBtn = document.querySelector('[data-action="tab-settings"]'); if (settingsBtn) settingsBtn.style.display = "none"; const logoutBtn = $("dropdown-logout"); if (logoutBtn) logoutBtn.style.display = "none"; $("btn-telemetry").style.display = "none"; try { const r = await fetch(`./api/profiles/${id}`); if (r.ok) { currentProfile = await r.json(); updateProfileUI(); notify("Modo compartido", `Visualizando perfil de: ${currentProfile.display_name}`); } else { notify("Error", "No se pudo cargar el perfil compartido."); } } catch (e) { notify("Error de red", String(e)); } } function updateProfileUI() { if (currentProfile) { $("user-display-name").innerText = currentProfile.display_name; $("avatar-circle").innerText = currentProfile.display_name.slice(0, 2).toUpperCase(); $("settings-display-name").value = currentProfile.display_name; $("settings-session-mode").value = currentProfile.session_mode; let modeText = "Sesión efímera (BYOK)"; if (isSharedMode) { modeText = "Modo compartido (Lectura)"; } else if (currentProfile.session_mode === "saved") { modeText = "Modo guardado temporal"; } $("user-session-mode").innerText = modeText; // Sincronizar con widget flotante if ($("floating-user-name")) $("floating-user-name").innerText = currentProfile.display_name; if ($("floating-avatar")) $("floating-avatar").innerText = currentProfile.display_name.slice(0, 2).toUpperCase(); if ($("floating-user-email")) { $("floating-user-email").innerText = currentProfile.display_name.toLowerCase().replace(/\s+/g, "") === "alexprieto" ? "alexprieto1997@gmail.com" : `${currentProfile.display_name.toLowerCase().replace(/\s+/g, ".")}@agrovision.com`; } } else { $("user-display-name").innerText = "Agrónomo"; $("avatar-circle").innerText = "AG"; $("settings-display-name").value = "Agrónomo"; $("settings-session-mode").value = "ephemeral"; $("user-session-mode").innerText = "Sesión efímera (BYOK)"; // Valores por defecto para widget flotante if ($("floating-user-name")) $("floating-user-name").innerText = "Agrónomo"; if ($("floating-avatar")) $("floating-avatar").innerText = "AG"; if ($("floating-user-email")) $("floating-user-email").innerText = "alexprieto1997@gmail.com"; } } async function checkMissingCredentials() { try { const r = await fetch("./api/credentials/status", { headers: authHeaders() }); if (!r.ok) return; const s = await r.json(); appEnv = s.env || "development"; if (appEnv === "production") { const missing = []; const hasGroq = creds.groq || s.groq; const hasCop = (creds.copId && creds.copSecret) || s.copernicus; const hasSb = Boolean(creds.dbUrl || (creds.sbUrl && creds.sbKey) || s.supabase); if (!hasGroq) missing.push("Groq API Key"); if (!hasCop) missing.push("Copernicus Credentials"); if (!hasSb) missing.push("Supabase Connection"); const toast = $("creds-toast-warning"); if (missing.length > 0) { toast.innerHTML = `Para la funcionalidad completa necesitas configurar: ${missing.join(", ")}.