[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_98":97,"_32":44,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":26,"_122":123,"_124":24,"_125":-5,"_126":-5,"_127":128},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":26},"version",11,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","deleted",true,"deletedHere",false,"path","inspect_ui.ts","latestPath","fileId","89a44232-b0ff-11f1-83b6-1607ee4eb77e","name","fileType","script","content","import { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function () {\n const keys = Array.from({length:11},(_,i)=>\"glovil_full_\"+String(i).padStart(2,\"0\")+\".txt\");\n const html = (await Promise.all(keys.map(async k => await (await blob.get(k)).text()))).join(\"\");\n const buttonTags = [...html.matchAll(/]*>/gi)].map(m=>m[0]);\n const disabled = buttonTags.filter(t=>/\\\\bdisabled\\\\b|aria-disabled\\\\s*=\\\\s*[\"\\']true[\"\\']/i.test(t));\n const noOnclick = buttonTags.filter(t=>!/onclick\\\\s*=|type\\\\s*=\\\\s*[\"\\']submit[\"\\']/i.test(t));\n const onclicks = [...html.matchAll(/onclick\\\\s*=\\\\s*[\"\\']([^\"\\']+)[\"\\']/gi)].map(m=>m[1]);\n const fnCalls = [...new Set(onclicks.flatMap(s => [...s.matchAll(/\\\\b([A-Za-z_$][\\\\w$]*)\\\\s*\\\$/g)].map(m=>m[1])))];\n const fnDefs = new Set([\n ...[...html.matchAll(/function\\\\s+([A-Za-z_$][\\\\w$]*)\\\\s*\\\\(/g)].map(m=>m[1]),\n ...[...html.matchAll(/(?:const|let|var)\\\\s+([A-Za-z_$][\\\\w$]*)\\\\s*=\\\\s*(?:async\\\\s*)?\\\\([^)]*\\\$\\\\s*=>/g)].map(m=>m[1]),\n ]);\n const globals = new Set([\"alert\",\"confirm\",\"open\",\"close\",\"setTimeout\",\"clearTimeout\"]);\n const missing = fnCalls.filter(n=>!fnDefs.has(n)&&!globals.has(n));\n const markers = [\"próximamente\",\"proximamente\",\"no disponible\",\"en desarrollo\",\"disabled\",\"alert(\",\"TODO\",\"placeholder\"];\n const markerHits = {};\n for (const s of markers) markerHits[s] = html.toLowerCase().split(s.toLowerCase()).length - 1;\n const unavailableSnippets = [...html.matchAll(/.{0,100}(próximamente|proximamente|no disponible|en desarrollo|TODO|alert\\\\().{0,180}/gi)].slice(0,40).map(m=>m[0]);\n return {htmlLength:html.length,buttonCount:buttonTags.length,disabledCount:disabled.length,disabled:disabled.slice(0,50),noOnclickCount:noOnclick.length,noOnclick:noOnclick.slice(0,80),onclickCount:onclicks.length,onclickFunctions:fnCalls,missingFunctions:missing,markerHits,unavailableSnippets};\n}","createdAt",["D",1789474699748],"branchVersion","branchId","74deb634-f033-4ddc-beae-82e4b28d0858","id","c89a6ab0-4e28-44a3-91ff-01f1f5c1bfde","glovil-piscis",["D",1789336614123],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","GLOVIL Piscis exact design app","imageUrl","b162e777-26d5-4b57-b5d4-824de1b425e2","pinnedFileId","08374466-afbe-11f1-8d54-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a087a7-039d-766a-a2cb-d9a1a861d44b","tursoName","c89a6ab04e2844a391ff01f1f5c1bfde","tursoHostname","c89a6ab04e2844a391ff01f1f5c1bfde-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519256886],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":26},"branch",{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"isOwned",66,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","agentia","handle","displayName","Agent Ia","avatar","https://lh3.googleusercontent.com/a/ACg8ocJFdiW2REahwLO-JAErcTTOgHyYDVN6VBKDk9RmathkK-sumQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_32":44,"_37":165,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":166,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":167,"_82":168,"_84":169,"_86":26},"tree",[156,157],"files",[156,157],"counts",{"_145":61,"_146":147,"_148":61,"_149":150,"_151":152},"contents",[129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":142,"_32":28,"_30":31,"_133":-5,"_40":41,"_39":14,"_135":26,"_37":143,"_13":61,"_33":34,"_35":36,"_23":26,"_140":-5,"_27":144},{"_42":131,"_32":132,"_30":56,"_133":-5,"_40":41,"_39":134,"_135":26,"_37":136,"_13":137,"_33":138,"_35":139,"_23":26,"_140":-5,"_27":141},"910f43b1-a426-4ad2-9d5b-fd8b63d51662","main.ts","parentId",10,"latest",["D",1789386958018],9,"http","import { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst SIGNS = [\"Aries\",\"Tauro\",\"Géminis\",\"Cáncer\",\"Leo\",\"Virgo\",\"Libra\",\"Escorpio\",\"Sagitario\",\"Capricornio\",\"Acuario\",\"Piscis\"];\nconst ELEMENTS: Record = {Aries:\"Fuego\",Tauro:\"Tierra\",\"Géminis\":\"Aire\",\"Cáncer\":\"Agua\",Leo:\"Fuego\",Virgo:\"Tierra\",Libra:\"Aire\",Escorpio:\"Agua\",Sagitario:\"Fuego\",Capricornio:\"Tierra\",Acuario:\"Aire\",Piscis:\"Agua\"};\n\nfunction J(data:unknown,statusOrInit:any=200){const status=typeof statusOrInit===\"number\"?statusOrInit:(statusOrInit?.status??200);return new Response(JSON.stringify(data),{status,headers:{\"content-type\":\"application/json; charset=utf-8\",\"access-control-allow-origin\":\"*\",\"access-control-allow-headers\":\"content-type\",\"access-control-allow-methods\":\"GET,POST,PUT,DELETE,OPTIONS\"}})}\nfunction hash(value:string){let h=2166136261;for(const ch of value){h^=ch.charCodeAt(0);h=Math.imul(h,16777619)}return Math.abs(h>>>0)}\nfunction pick(list:string[],key:string){return list[hash(key)%list.length]}\nfunction sunSign(date:string){const d=new Date(date+\"T12:00:00Z\"),m=d.getUTCMonth()+1,day=d.getUTCDate();if((m===3&&day>=21)||(m===4&&day<=19))return\"Aries\";if((m===4&&day>=20)||(m===5&&day<=20))return\"Tauro\";if((m===5&&day>=21)||(m===6&&day<=20))return\"Géminis\";if((m===6&&day>=21)||(m===7&&day<=22))return\"Cáncer\";if((m===7&&day>=23)||(m===8&&day<=22))return\"Leo\";if((m===8&&day>=23)||(m===9&&day<=22))return\"Virgo\";if((m===9&&day>=23)||(m===10&&day<=22))return\"Libra\";if((m===10&&day>=23)||(m===11&&day<=21))return\"Escorpio\";if((m===11&&day>=22)||(m===12&&day<=21))return\"Sagitario\";if((m===12&&day>=22)||(m===1&&day<=19))return\"Capricornio\";if((m===1&&day>=20)||(m===2&&day<=18))return\"Acuario\";return\"Piscis\"}\n\nconst CORS_HEADERS: Record = {\n \"Access-Control-Allow-Origin\":\"*\",\n \"Access-Control-Allow-Methods\":\"GET,POST,PUT,DELETE,OPTIONS\",\n \"Access-Control-Allow-Headers\":\"Content-Type\"\n};\n\nfunction jsonCors(data:unknown, init:ResponseInit = {}):Response {\n const headers = new Headers(init.headers || {});\n for (const [key,value] of Object.entries(CORS_HEADERS)) headers.set(key,value);\n return J(data,{...init,headers});\n}\n\nasync function ensureDb(){\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS admin_rows (id INTEGER PRIMARY KEY AUTOINCREMENT, workspace TEXT NOT NULL, type TEXT NOT NULL, label TEXT NOT NULL, value TEXT NOT NULL DEFAULT '', status TEXT NOT NULL DEFAULT 'activo', created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS user_tasks (id INTEGER PRIMARY KEY AUTOINCREMENT, workspace TEXT NOT NULL, task_key TEXT NOT NULL, label TEXT NOT NULL, done INTEGER NOT NULL DEFAULT 0, task_date TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE(workspace,task_key,task_date))`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS space_items (id INTEGER PRIMARY KEY AUTOINCREMENT, workspace TEXT NOT NULL, kind TEXT NOT NULL, content TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS energy_logs (id INTEGER PRIMARY KEY AUTOINCREMENT, workspace TEXT NOT NULL, energy_date TEXT NOT NULL, value INTEGER NOT NULL, note TEXT NOT NULL DEFAULT '', updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, UNIQUE(workspace,energy_date))`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS favorites (id INTEGER PRIMARY KEY AUTOINCREMENT, workspace TEXT NOT NULL, kind TEXT NOT NULL, label TEXT NOT NULL, value TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS profiles (workspace TEXT PRIMARY KEY, name TEXT NOT NULL DEFAULT '', birth_date TEXT NOT NULL DEFAULT '', birth_time TEXT NOT NULL DEFAULT '', birth_place TEXT NOT NULL DEFAULT '', updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS analytics_events (id INTEGER PRIMARY KEY AUTOINCREMENT, workspace TEXT NOT NULL, event TEXT NOT NULL, detail TEXT NOT NULL DEFAULT '', created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`);\n}\n\nexport default async function(req:Request):Promise{\n const url=new URL(req.url);\n if(req.method===\"OPTIONS\") return new Response(null,{status:204,headers:CORS_HEADERS});\n if(url.pathname===\"/\"||url.pathname===\"/index.html\"){\n try{const keys=Array.from({length:11},(_,i)=>\"glovil_full_\"+String(i).padStart(2,\"0\")+\".txt\");const parts=await Promise.all(keys.map(async key=>await (await blob.get(key)).text()));const html=parts.join(\"\");return new Response(html,{headers:{\"content-type\":\"text/html; charset=utf-8\",\"cache-control\":\"no-cache\"}})}catch{return new Response(\"GLOVIL preparando diseño…\",{status:503})}\n }\n if(url.pathname===\"/api/horoscope\"&&req.method===\"GET\"){\n const date=new Date().toISOString().slice(0,10);const workspace=url.searchParams.get(\"workspace\")||\"\";let custom:any=null;\n if(workspace){await ensureDb();const r=await sqlite.execute({sql:\"SELECT * FROM admin_rows WHERE workspace=? AND type=? AND status=? ORDER BY created_at DESC LIMIT 1\",args:[workspace,\"Horóscopo\",\"activo\"]});custom=r.rows[0]||null}\n return jsonCors({date,source:custom?\"admin-local\":\"motor-local\",main:(custom&&(custom.value||custom.label))||pick([\"Todo se acomoda a tu favor.\",\"Tu intuición te muestra el camino.\",\"Hoy conviene fluir, no forzar.\",\"Una conversación bonita puede cambiar tu día.\",\"Lo simple trae claridad.\"],date+\"main\"),love:pick([\"Habla con calma y escucha de verdad.\",\"Un gesto pequeño vale mucho hoy.\",\"Deja espacio para recibir cariño.\"],date+\"love\"),money:pick([\"Ordena primero, decide después.\",\"Cuida los detalles antes de gastar.\",\"Una idea sencilla puede rendir más de lo esperado.\"],date+\"money\"),energy:pick([\"Alta para crear.\",\"Suave: ve a tu ritmo.\",\"En equilibrio si haces pausas.\"],date+\"energy\"),advice:pick([\"Confía en tu primera sensación.\",\"Haz una cosa a la vez.\",\"Descansa sin sentir culpa.\"],date+\"advice\")});\n }\n if(url.pathname===\"/api/chart\"&&req.method===\"POST\"){\n const data=await req.json().catch(()=>({})) as any;if(!data.date||!data.time||!String(data.place||\"\").trim())return jsonCors({error:\"Completa fecha, hora y lugar\"},{status:400});\n const sun=sunSign(data.date),day=Math.floor(new Date(data.date+\"T12:00:00Z\").getTime()/86400000),hour=Number(String(data.time).split(\":\")[0]||0),placeKey=hash(String(data.place).toLowerCase()),moon=SIGNS[Math.abs(day+placeKey)%12],ascendant=SIGNS[Math.abs(hour*2+placeKey)%12];\n return jsonCors({sun,moon,ascendant,element:ELEMENTS[sun],mode:\"motor local orientativo\",summary:\"Tu Sol en \"+sun+\" habla de tu forma central de expresarte. Tu Luna en \"+moon+\" representa tu mundo emocional y tu Ascendente en \"+ascendant+\" describe cómo te mueves frente a lo nuevo.\"});\n }\n if(url.pathname===\"/api/admin-rows\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";\n if(req.method===\"GET\"){if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});const r=await sqlite.execute({sql:\"SELECT id,workspace,type,label,value,status,created_at AS createdAt FROM admin_rows WHERE workspace=? ORDER BY created_at DESC LIMIT 100\",args:[workspace]});return jsonCors({rows:r.rows})}\n const body=await req.json().catch(()=>({})) as any;\n if(req.method===\"POST\"){if(!body.workspace||!body.type||!body.label)return jsonCors({error:\"Faltan datos\"},{status:400});const r=await sqlite.execute({sql:\"INSERT INTO admin_rows (workspace,type,label,value,status) VALUES (?,?,?,?,?) RETURNING id,workspace,type,label,value,status,created_at AS createdAt\",args:[body.workspace,body.type,body.label,body.value||\"\",body.status||\"activo\"]});return jsonCors(r.rows[0],{status:201})}\n if(req.method===\"PUT\"){if(!body.id||!body.workspace)return jsonCors({error:\"Faltan datos\"},{status:400});const r=await sqlite.execute({sql:\"UPDATE admin_rows SET status=COALESCE(?,status),label=COALESCE(?,label),value=COALESCE(?,value),type=COALESCE(?,type),updated_at=CURRENT_TIMESTAMP WHERE id=? AND workspace=? RETURNING id,workspace,type,label,value,status,created_at AS createdAt\",args:[body.status||null,body.label||null,body.value??null,body.type||null,body.id,body.workspace]});return r.rows[0]?jsonCors(r.rows[0]):jsonCors({error:\"No existe\"},{status:404})}\n if(req.method===\"DELETE\"){if(!body.id||!body.workspace)return jsonCors({error:\"Faltan datos\"},{status:400});const r=await sqlite.execute({sql:\"DELETE FROM admin_rows WHERE id=? AND workspace=?\",args:[body.id,body.workspace]});return jsonCors({ok:r.rowsAffected>0})}\n }\n if(url.pathname===\"/api/home\"&&req.method===\"GET\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});\n const date=new Date().toISOString().slice(0,10);\n const [taskR,energyR,noteR,dreamR]=await Promise.all([\n sqlite.execute({sql:\"SELECT task_key,label,done FROM user_tasks WHERE workspace=? AND task_date=? ORDER BY id\",args:[workspace,date]}),\n sqlite.execute({sql:\"SELECT value FROM energy_logs WHERE workspace=? AND energy_date=?\",args:[workspace,date]}),\n sqlite.execute({sql:\"SELECT id,content,created_at AS createdAt FROM space_items WHERE workspace=? AND kind='note' ORDER BY id DESC LIMIT 3\",args:[workspace]}),\n sqlite.execute({sql:\"SELECT id,content,created_at AS createdAt FROM space_items WHERE workspace=? AND kind='dream' ORDER BY id DESC LIMIT 3\",args:[workspace]})\n ]);\n return jsonCors({date,tasks:taskR.rows,energy:(energyR.rows[0] as any)?.value??3,notes:noteR.rows,dreams:dreamR.rows});\n }\n if(url.pathname===\"/api/tasks\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";const date=url.searchParams.get(\"date\")||new Date().toISOString().slice(0,10);\n if(req.method===\"GET\"){\n if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});\n const custom=await sqlite.execute({sql:\"SELECT label FROM admin_rows WHERE workspace=? AND type='Tareas' AND status='activo' ORDER BY id\",args:[workspace]});\n const labels=[\"Respira\",\"Escribe\",\"Agradece\",\"Descansa\",...custom.rows.map((r:any)=>String(r.label))].slice(0,7);\n for(let i=0;i({})) as any;\n if(req.method===\"PUT\"){\n if(!body.workspace||!body.taskKey)return jsonCors({error:\"Faltan datos\"},{status:400});\n const r=await sqlite.execute({sql:\"UPDATE user_tasks SET done=?,updated_at=CURRENT_TIMESTAMP WHERE workspace=? AND task_key=? AND task_date=? RETURNING id,task_key AS taskKey,label,done,task_date AS taskDate\",args:[body.done?1:0,body.workspace,body.taskKey,body.date||date]});return r.rows[0]?jsonCors(r.rows[0]):jsonCors({error:\"No existe\"},{status:404});\n }\n }\n if(url.pathname===\"/api/space\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";\n if(req.method===\"GET\"){\n if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});\n const kind=url.searchParams.get(\"kind\");const r=kind?await sqlite.execute({sql:\"SELECT id,kind,content,created_at AS createdAt FROM space_items WHERE workspace=? AND kind=? ORDER BY id DESC LIMIT 50\",args:[workspace,kind]}):await sqlite.execute({sql:\"SELECT id,kind,content,created_at AS createdAt FROM space_items WHERE workspace=? ORDER BY id DESC LIMIT 100\",args:[workspace]});return jsonCors({rows:r.rows});\n }\n const body=await req.json().catch(()=>({})) as any;\n if(req.method===\"POST\"){\n if(!body.workspace||![\"note\",\"dream\"].includes(body.kind)||!String(body.content||\"\").trim())return jsonCors({error:\"Faltan datos\"},{status:400});\n const r=await sqlite.execute({sql:\"INSERT INTO space_items (workspace,kind,content) VALUES (?,?,?) RETURNING id,kind,content,created_at AS createdAt\",args:[body.workspace,body.kind,String(body.content).trim()]});return jsonCors(r.rows[0],{status:201});\n }\n if(req.method===\"DELETE\"){\n if(!body.workspace||!body.id)return jsonCors({error:\"Faltan datos\"},{status:400});\n const r=await sqlite.execute({sql:\"DELETE FROM space_items WHERE id=? AND workspace=?\",args:[body.id,body.workspace]});return jsonCors({ok:r.rowsAffected>0});\n }\n }\n if(url.pathname===\"/api/energy\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";const date=url.searchParams.get(\"date\")||new Date().toISOString().slice(0,10);\n if(req.method===\"GET\"){\n if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});const r=await sqlite.execute({sql:\"SELECT value,note,energy_date AS energyDate FROM energy_logs WHERE workspace=? AND energy_date=?\",args:[workspace,date]});return jsonCors(r.rows[0]||{value:3,note:\"\",energyDate:date});\n }\n const body=await req.json().catch(()=>({})) as any;\n if(req.method===\"PUT\"){\n if(!body.workspace||Number(body.value)<1||Number(body.value)>5)return jsonCors({error:\"Valor inválido\"},{status:400});\n const d=body.date||date;await sqlite.execute({sql:\"INSERT INTO energy_logs (workspace,energy_date,value,note) VALUES (?,?,?,?) ON CONFLICT(workspace,energy_date) DO UPDATE SET value=excluded.value,note=excluded.note,updated_at=CURRENT_TIMESTAMP\",args:[body.workspace,d,Number(body.value),String(body.note||\"\")]});return jsonCors({ok:true,value:Number(body.value),energyDate:d});\n }\n }\n if(url.pathname===\"/api/favorites\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";\n if(req.method===\"GET\"){if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});const r=await sqlite.execute({sql:\"SELECT id,kind,label,value,created_at AS createdAt FROM favorites WHERE workspace=? ORDER BY id DESC LIMIT 50\",args:[workspace]});return jsonCors({rows:r.rows})}\n const body=await req.json().catch(()=>({})) as any;\n if(req.method===\"POST\"){if(!body.workspace||!body.label)return jsonCors({error:\"Faltan datos\"},{status:400});const r=await sqlite.execute({sql:\"INSERT INTO favorites (workspace,kind,label,value) VALUES (?,?,?,?) RETURNING id,kind,label,value,created_at AS createdAt\",args:[body.workspace,body.kind||\"general\",body.label,body.value||\"\"]});return jsonCors(r.rows[0],{status:201})}\n if(req.method===\"DELETE\"){if(!body.workspace||!body.id)return jsonCors({error:\"Faltan datos\"},{status:400});const r=await sqlite.execute({sql:\"DELETE FROM favorites WHERE id=? AND workspace=?\",args:[body.id,body.workspace]});return jsonCors({ok:r.rowsAffected>0})}\n }\n if(url.pathname===\"/api/profile\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";\n if(req.method===\"GET\"){if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});const r=await sqlite.execute({sql:\"SELECT workspace,name,birth_date AS birthDate,birth_time AS birthTime,birth_place AS birthPlace,updated_at AS updatedAt FROM profiles WHERE workspace=?\",args:[workspace]});return jsonCors(r.rows[0]||{workspace,name:\"\",birthDate:\"\",birthTime:\"\",birthPlace:\"\"})}\n const body=await req.json().catch(()=>({})) as any;\n if(req.method===\"PUT\"){if(!body.workspace)return jsonCors({error:\"workspace requerido\"},{status:400});await sqlite.execute({sql:\"INSERT INTO profiles (workspace,name,birth_date,birth_time,birth_place) VALUES (?,?,?,?,?) ON CONFLICT(workspace) DO UPDATE SET name=excluded.name,birth_date=excluded.birth_date,birth_time=excluded.birth_time,birth_place=excluded.birth_place,updated_at=CURRENT_TIMESTAMP\",args:[body.workspace,String(body.name||\"\"),String(body.birthDate||\"\"),String(body.birthTime||\"\"),String(body.birthPlace||\"\")]});return jsonCors({ok:true})}\n }\n if(url.pathname===\"/api/analytics\"){\n await ensureDb();const body=req.method===\"POST\"?await req.json().catch(()=>({})) as any:{};\n if(req.method===\"POST\"){if(!body.workspace||!body.event)return jsonCors({error:\"Faltan datos\"},{status:400});await sqlite.execute({sql:\"INSERT INTO analytics_events (workspace,event,detail) VALUES (?,?,?)\",args:[body.workspace,String(body.event),String(body.detail||\"\")]});return jsonCors({ok:true})}\n if(req.method===\"GET\"){const workspace=url.searchParams.get(\"workspace\")||\"\";if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});const r=await sqlite.execute({sql:\"SELECT event,COUNT(*) AS total FROM analytics_events WHERE workspace=? GROUP BY event ORDER BY total DESC\",args:[workspace]});return jsonCors({rows:r.rows})}\n }\n if(url.pathname===\"/api/admin-summary\"&&req.method===\"GET\"){\n await ensureDb();const workspace=url.searchParams.get(\"workspace\")||\"\";if(!workspace)return jsonCors({error:\"workspace requerido\"},{status:400});\n const [rows,tasks,space,favs,events]=await Promise.all([\n sqlite.execute({sql:\"SELECT COUNT(*) AS total,SUM(CASE WHEN status='activo' THEN 1 ELSE 0 END) AS active FROM admin_rows WHERE workspace=?\",args:[workspace]}),\n sqlite.execute({sql:\"SELECT COUNT(*) AS total,SUM(done) AS done FROM user_tasks WHERE workspace=?\",args:[workspace]}),\n sqlite.execute({sql:\"SELECT kind,COUNT(*) AS total FROM space_items WHERE workspace=? GROUP BY kind\",args:[workspace]}),\n sqlite.execute({sql:\"SELECT COUNT(*) AS total FROM favorites WHERE workspace=?\",args:[workspace]}),\n sqlite.execute({sql:\"SELECT COUNT(*) AS total FROM analytics_events WHERE workspace=?\",args:[workspace]})\n ]);\n return jsonCors({admin:rows.rows[0]||{},tasks:tasks.rows[0]||{},space:space.rows,favorites:(favs.rows[0] as any)?.total||0,events:(events.rows[0] as any)?.total||0});\n }\n return new Response(\"Not found\",{status:404,headers:CORS_HEADERS});\n}","label",[132],"1af189cd-54c0-4f72-936e-19f882947f5e",["D",1789474699748],[28],"pulls","branches",1,"forks","envVars",{"_153":61,"_155":61},"connections",{"_153":61,"_154":61},"count","unfilledCount","emptyCount",{"_42":142,"_32":28,"_30":31,"_133":-5,"_40":41,"_39":14,"_135":26,"_37":162,"_13":61,"_33":34,"_35":36,"_23":26,"_140":-5,"_159":163,"_27":164},{"_42":131,"_32":132,"_30":56,"_133":-5,"_40":41,"_39":134,"_135":26,"_37":158,"_13":137,"_33":138,"_35":139,"_23":26,"_140":-5,"_159":160,"_27":161},["D",1789386958018],"children",[],[132],["D",1789474699748],[],[28],["D",1789336614123],["D",1789519256886],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":26},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_126":203,"_204":205,"_206":207,"_208":26,"_209":26,"_210":26,"_211":24,"_212":-5,"_213":-7,"_214":-7,"_215":61,"_216":26,"_217":26,"_218":-5,"_219":26,"_220":26,"_221":26,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":88,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v11