[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_258":259,"_260":261},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_194":-5,"_20":195,"_22":196,"_197":198,"_199":200,"_26":201,"_24":202,"_203":-5,"_204":-5,"_205":52,"_206":207,"_208":43,"_209":-5,"_210":-5,"_211":212},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","agentia","name","canal8-control","branchName","main","version","path","index.ts","project",{"_33":136,"_13":14,"_44":137,"_138":-5,"_139":52,"_140":141,"_142":141,"_143":144,"_145":-5,"_146":147,"_148":36,"_149":43,"_150":-5,"_151":-5,"_152":68,"_153":154,"_155":156,"_157":158,"_159":160,"_161":-5,"_162":163,"_164":163,"_165":166,"_167":166,"_168":166,"_169":163,"_170":163,"_171":172,"_173":174,"_175":176,"_177":52},"tree",[55,56,57,58],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_18":54},"contents",[],"upstream","pull","ahead","behind","envVars","id","d3dce034-92aa-4555-b686-0dd2a797b45d","fileId","01a09f7d-4745-7404-b411-4a5159266c10","parentId","branchId","6115b29c-16d6-4e5c-adb4-8b5ae0947091","branchVersion",19,"latest",true,"createdAt",["D",1789386535414],16,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { Hono } from \"npm:hono\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst app = new Hono();\nconst ROLES = [\"IMPACTO\",\"DESCUBRIMIENTO\",\"GIRO\",\"EXPANSIÓN\",\"SUSPENSO\",\"CIERRE/AVANCE\"];\nconst STATUSES = new Set([\"IDEA\",\"GUION\",\"DISEÑO\",\"VIDEO\",\"AUDIO\",\"LISTO\",\"PUBLICADO\"]);\nconst CLIENT_JS = \"\\n(function(){\\n\\\"use strict\\\";\\nvar S={programs:[],episodes:[],admin:[],inbox:[],activity:[],view:\\\"control\\\",q:\\\"\\\",cat:\\\"TODAS\\\",status:\\\"TODOS\\\",draft:null,adminDraft:null,loading:false};\\nvar roles=[\\\"IMPACTO\\\",\\\"DESCUBRIMIENTO\\\",\\\"GIRO\\\",\\\"EXPANSIÓN\\\",\\\"SUSPENSO\\\",\\\"CIERRE/AVANCE\\\"];\\nvar statuses=[\\\"IDEA\\\",\\\"GUION\\\",\\\"DISEÑO\\\",\\\"VIDEO\\\",\\\"AUDIO\\\",\\\"LISTO\\\",\\\"PUBLICADO\\\"];\\nvar searchTimer=null;\\n\\nfunction el(id){return document.getElementById(id)}\\nfunction esc(v){return String(v==null?\\\"\\\":v).replace(/&/g,\\\"&\\\").replace(//g,\\\">\\\").replace(/\\\"/g,\\\""\\\").replace(/'/g,\\\"'\\\")}\\nfunction fmtDate(v){if(!v)return\\\"—\\\";return String(v).slice(0,10)}\\nfunction toast(msg,type){var old=document.querySelector(\\\".toast\\\");if(old)old.remove();var t=document.createElement(\\\"button\\\");t.className=\\\"toast \\\"+(type||\\\"\\\");t.textContent=msg+\\\" ×\\\";t.onclick=function(){t.remove()};document.body.appendChild(t);setTimeout(function(){if(t.parentNode)t.remove()},3600)}\\nfunction busy(button,on,label){if(!button)return;button.disabled=on;if(on){button.dataset.old=button.textContent;button.textContent=label||\\\"GUARDANDO…\\\"}else{button.textContent=button.dataset.old||button.textContent}}\\nasync function api(url,options){\\n var controller=new AbortController();var timer=setTimeout(function(){controller.abort()},15000);\\n try{\\n var opts=Object.assign({cache:\\\"no-store\\\",signal:controller.signal},options||{});\\n var r=await fetch(url,opts);var j={};try{j=await r.json()}catch(e){}\\n if(!r.ok)throw new Error(j.error||(\\\"Error \\\"+r.status));return j;\\n }catch(e){if(e.name===\\\"AbortError\\\")throw new Error(\\\"La operación tardó demasiado. Intenta de nuevo.\\\");throw e}\\n finally{clearTimeout(timer)}\\n}\\nasync function load(silent){\\n if(!silent&&el(\\\"main\\\"))el(\\\"main\\\").innerHTML='

ENCENDIENDO SEÑALCargando programación…

';\\n try{\\n var d=await api(\\\"/api/state?ts=\\\"+Date.now());\\n S.programs=d.programs||[];S.episodes=d.episodes||[];S.admin=d.admin||[];S.inbox=d.c8_inbox||[];S.activity=d.activity||[];\\n render();\\n }catch(e){\\n if(el(\\\"main\\\"))el(\\\"main\\\").innerHTML='

No se pudo cargar CANAL8.TV'+esc(e.message)+'

';\\n }\\n}\\nfunction setView(v){S.view=v;S.q=\\\"\\\";S.cat=\\\"TODAS\\\";S.status=\\\"TODOS\\\";document.querySelectorAll(\\\"[data-view]\\\").forEach(function(b){b.classList.toggle(\\\"active\\\",b.dataset.view===v)});render()}\\nfunction count(st){return S.admin.filter(function(r){return r.status===st}).length}\\nfunction pendingC8(){return S.inbox.filter(function(x){return x.status!==\\\"PROCESADO\\\"}).length}\\nfunction adminHealthy(){return S.admin.length===S.episodes.length*6}\\nfunction episodeCard(e){\\n var rows=S.admin.filter(function(r){return r.episode_code===e.code});\\n var done=rows.filter(function(r){return r.status===\\\"LISTO\\\"||r.status===\\\"PUBLICADO\\\"}).length;\\n return '';\\n}\\nfunction dashboard(){\\n return '

CANAL8.TV CONTROL · v4

Programación viva,
8 segundos a la vez.

Sistema revisado: producción, planilla Admin, calendario, archivos y entradas /c8 en un solo flujo.

'+\\n '

'+(adminHealthy()?\\\"SISTEMA SINCRONIZADO\\\":\\\"REVISAR SINCRONIZACIÓN\\\")+''+S.episodes.length+' episodios · '+S.admin.length+' piezas Admin · '+pendingC8()+' entradas /c8 pendientes

'+\\n '

'+S.programs.length+'PROGRAMAS

'+S.episodes.length+'EPISODIOS

'+S.admin.length+'PIEZAS 8S

'+count(\\\"LISTO\\\")+'LISTAS

'+count(\\\"PUBLICADO\\\")+'PUBLICADAS

'+\\n '

FLUJO

De idea a publicación

'+statuses.map(function(st){return '

'+count(st)+''+st+'

'}).join(\\\"\\\")+'

'+\\n '

INICIO

Producción inicial

'+S.episodes.slice(0,6).map(episodeCard).join(\\\"\\\")+'

HISTORIAL

Actividad reciente

'+(S.activity.length?S.activity.slice(0,10).map(function(a){return '

'+esc(a.action)+''+esc(a.ref_code||\\\"\\\")+'

'+esc(a.detail||\\\"\\\")+'

'+esc(a.created_at||\\\"\\\")+'

'}).join(\\\"\\\"):'

Sin actividad registrada todavía.

')+'

';\\n}\\nfunction programs(){\\n return '

UNIVERSO

'+S.programs.length+' programas activos

'+S.programs.map(function(p){var eps=S.episodes.filter(function(e){return e.program_name===p.name});return '

'+esc(p.category)+'

'+esc(p.name)+'

'+eps.length+' capítulos · 6 × 8s · IMPACTO obligatorio.

'}).join(\\\"\\\")+'

';\\n}\\nfunction episodes(){\\n var cats=[\\\"TODAS\\\"].concat(Array.from(new Set(S.programs.map(function(p){return p.category}))));\\n var list=S.episodes.filter(function(e){return (S.cat===\\\"TODAS\\\"||e.category===S.cat)&&((e.code+\\\" \\\"+e.title+\\\" \\\"+e.program_name).toLowerCase().indexOf(S.q.toLowerCase())>=0)});\\n return '

BIBLIOTECA

Episodios · '+list.length+'

'+list.length+' resultados

'+list.map(episodeCard).join(\\\"\\\")+'

';\\n}\\nfunction loadForm(){\\n return '

ENTRADA

Cargar episodio completo

'+\\n '

1 · Ficha

PROGRAMACAPÍTULOTÍTULOESTADOPREMISA

'+\\n '

2 · Seis escenas

'+[1,2,3,4,5,6].map(function(n){return '

'+n+'8S

'+roles[n-1]+'

'}).join(\\\"\\\")+'

'+\\n '

3 · Distribución

FECHAPLATAFORMASFORMATORESPONSABLECAPTIONHASHTAGSNOTAS

';\\n}\\nfunction admin(){\\n var cats=[\\\"TODAS\\\"].concat(Array.from(new Set(S.programs.map(function(p){return p.category}))));\\n var list=S.admin.filter(function(r){var hay=(r.episode_code+\\\" \\\"+r.episode_title+\\\" \\\"+r.program_name+\\\" \\\"+r.piece_title+\\\" \\\"+(r.caption||\\\"\\\")).toLowerCase();return (S.cat===\\\"TODAS\\\"||r.category===S.cat)&&(S.status===\\\"TODOS\\\"||r.status===S.status)&&hay.indexOf(S.q.toLowerCase())>=0});\\n return '

PLANILLA INTERNA

Admin · '+list.length+' piezas

'+list.map(function(r){return ''}).join(\\\"\\\")+'

CÓDIGO	ESC	CATEGORÍA	PROGRAMA	CAP	EPISODIO	ROL	PIEZA	ESTADO	FECHA	PLATAFORMA	RESP.	FUENTE
'+esc(r.episode_code)+'	'+r.scene_no+'	'+esc(r.category)+'	'+esc(r.program_name)+'	'+r.chapter+'	'+esc(r.episode_title)+'	'+esc(r.role)+'	'+esc(r.piece_title)+'	'+esc(r.status)+'	'+esc(r.planned_date\|\|\\\"—\\\")+'	'+esc(r.platform\|\|\\\"—\\\")+'	'+esc(r.owner\|\|\\\"—\\\")+'	'+esc(r.source\|\|\\\"APP\\\")+'

';\\n}\\nfunction calendar(){\\n var list=S.admin.filter(function(r){return r.planned_date}).sort(function(a,b){return String(a.planned_date).localeCompare(String(b.planned_date))});\\n return '

PROGRAMACIÓN

Calendario · '+list.length+' piezas

'+(list.length?list.map(function(r){return ''}).join(\\\"\\\"):'

No hay fechas planificadas todavía.

')+'

';\\n}\\nfunction c8Inbox(){\\n return '

ENTRADAS DEL CHAT

/c8 · '+pendingC8()+' pendientes

Cómo funcionaCuando usamos /c8 desde el chat, la entrada queda registrada aquí y luego se refleja en episodio/planilla Admin según corresponda.

'+(S.inbox.length?S.inbox.map(function(x){return '

C8-'+x.id+''+esc(x.status)+'

'+esc(x.raw_text)+'

'+esc(x.action_type)+' · '+esc(x.target_code||\\\"SIN DESTINO\\\")+' · '+esc(x.created_at)+'

'+(x.status!==\\\"PROCESADO\\\"?'':'')+'

'}).join(\\\"\\\"):'

No hay entradas /c8 todavía.

')+'

';\\n}\\nfunction render(){\\n var html=S.view===\\\"programas\\\"?programs():S.view===\\\"episodios\\\"?episodes():S.view===\\\"cargar\\\"?loadForm():S.view===\\\"admin\\\"?admin():S.view===\\\"calendario\\\"?calendar():S.view===\\\"c8\\\"?c8Inbox():dashboard();\\n if(el(\\\"main\\\"))el(\\\"main\\\").innerHTML=html;\\n document.querySelectorAll(\\\"[data-view]\\\").forEach(function(b){b.classList.toggle(\\\"active\\\",b.dataset.view===S.view)});\\n}\\nfunction closeModal(){el(\\\"modal\\\").innerHTML=\\\"\\\";S.draft=null;S.adminDraft=null}\\nfunction openEpisode(code){\\n var e=S.episodes.find(function(x){return x.code===code});if(!e)return toast(\\\"Episodio no encontrado\\\");\\n S.draft=Object.assign({},e);var d=S.draft;var lock=d.is_protected?'

CANON PROTEGIDO: título, programa y capítulo no se pueden cambiar.

':'';\\n el(\\\"modal\\\").innerHTML='

';\\n}\\nasync function saveEpisode(btn){\\n var d=S.draft;if(!d)return;var program=el(\\\"e-program\\\").value;var p=S.programs.find(function(x){return x.name===program});\\n d.program_name=program;d.category=p?p.category:d.category;d.status=el(\\\"e-status\\\").value;d.title=el(\\\"e-title\\\").value.trim();d.chapter=Number(el(\\\"e-chapter\\\").value)||1;d.planned_date=el(\\\"e-date\\\").value;d.platforms=el(\\\"e-platforms\\\").value;d.premise=el(\\\"e-premise\\\").value;d.owner=el(\\\"e-owner\\\").value;d.content_format=el(\\\"e-format\\\").value;d.caption=el(\\\"e-caption\\\").value;d.hashtags=el(\\\"e-hashtags\\\").value;d.notes=el(\\\"e-notes\\\").value;for(var n=1;n<=6;n++)d[\\\"scene\\\"+n]=el(\\\"e-s\\\"+n).value;\\n if(!d.title)return toast(\\\"Falta el título\\\",\\\"error\\\");if(String(d.scene1).toUpperCase().indexOf(\\\"IMPACTO\\\")!==0)return toast(\\\"La escena 1 debe iniciar con IMPACTO\\\",\\\"error\\\");\\n busy(btn,true);try{await api(\\\"/api/episode/\\\"+encodeURIComponent(d.code),{method:\\\"POST\\\",headers:{\\\"Content-Type\\\":\\\"application/json\\\"},body:JSON.stringify(d)});closeModal();toast(\\\"Episodio actualizado\\\");await load(true)}catch(e){toast(e.message,\\\"error\\\")}finally{busy(btn,false)}\\n}\\nasync function createEpisode(btn){\\n var program=el(\\\"l-program\\\").value;var p=S.programs.find(function(x){return x.name===program});var d={category:p?p.category:\\\"SERIES\\\",program_name:program,chapter:Number(el(\\\"l-chapter\\\").value)||1,title:el(\\\"l-title\\\").value.trim(),premise:el(\\\"l-premise\\\").value,status:el(\\\"l-status\\\").value,planned_date:el(\\\"l-date\\\").value,platforms:el(\\\"l-platforms\\\").value,content_format:el(\\\"l-format\\\").value,owner:el(\\\"l-owner\\\").value,caption:el(\\\"l-caption\\\").value,hashtags:el(\\\"l-hashtags\\\").value,notes:el(\\\"l-notes\\\").value};for(var n=1;n<=6;n++)d[\\\"scene\\\"+n]=el(\\\"l-s\\\"+n).value.trim();\\n if(!d.title)return toast(\\\"Falta el título\\\",\\\"error\\\");if(String(d.scene1).toUpperCase().indexOf(\\\"IMPACTO\\\")!==0)return toast(\\\"La escena 1 debe iniciar con IMPACTO\\\",\\\"error\\\");\\n busy(btn,true,\\\"CREANDO…\\\");try{var j=await api(\\\"/api/episode\\\",{method:\\\"POST\\\",headers:{\\\"Content-Type\\\":\\\"application/json\\\"},body:JSON.stringify(d)});toast(j.code+\\\" creado con 6 filas Admin\\\");await load(true);setView(\\\"admin\\\")}catch(e){toast(e.message,\\\"error\\\")}finally{busy(btn,false)}\\n}\\nfunction openAdmin(id){\\n var r=S.admin.find(function(x){return Number(x.id)===Number(id)});if(!r)return toast(\\\"Fila Admin no encontrada\\\",\\\"error\\\");S.adminDraft=Object.assign({},r);\\n el(\\\"modal\\\").innerHTML='

';\\n}\\nasync function uploadFile(file){if(!file)return;var fd=new FormData();fd.append(\\\"file\\\",file);try{toast(\\\"Subiendo archivo…\\\");var r=await fetch(\\\"/api/upload\\\",{method:\\\"POST\\\",body:fd});var j=await r.json();if(!r.ok)throw new Error(j.error||\\\"No se pudo subir\\\");el(\\\"a-url\\\").value=j.url;toast(\\\"Archivo enlazado\\\")}catch(e){toast(e.message,\\\"error\\\")}}\\nasync function saveAdmin(btn){var r=S.adminDraft;if(!r)return;var b={piece_title:el(\\\"a-piece\\\").value,status:el(\\\"a-status\\\").value,planned_date:el(\\\"a-date\\\").value,published_date:el(\\\"a-pubdate\\\").value,platform:el(\\\"a-platform\\\").value,owner:el(\\\"a-owner\\\").value,caption:el(\\\"a-caption\\\").value,hashtags:el(\\\"a-hashtags\\\").value,asset_url:el(\\\"a-url\\\").value,notes:el(\\\"a-notes\\\").value};busy(btn,true);try{await api(\\\"/api/admin/\\\"+r.id,{method:\\\"POST\\\",headers:{\\\"Content-Type\\\":\\\"application/json\\\"},body:JSON.stringify(b)});closeModal();toast(\\\"Fila Admin guardada\\\");await load(true)}catch(e){toast(e.message,\\\"error\\\")}finally{busy(btn,false)}}\\nasync function markC8(id,btn){busy(btn,true,\\\"PROCESANDO…\\\");try{await api(\\\"/api/c8/\\\"+id+\\\"/status\\\",{method:\\\"POST\\\",headers:{\\\"Content-Type\\\":\\\"application/json\\\"},body:JSON.stringify({status:\\\"PROCESADO\\\"})});toast(\\\"Entrada /c8 procesada\\\");await load(true)}catch(e){toast(e.message,\\\"error\\\")}finally{busy(btn,false)}}\\nfunction exportCsv(){var rows=[[\\\"Código\\\",\\\"Escena\\\",\\\"Categoría\\\",\\\"Programa\\\",\\\"Capítulo\\\",\\\"Episodio\\\",\\\"Rol\\\",\\\"Pieza\\\",\\\"Estado\\\",\\\"Plataforma\\\",\\\"Fecha planificada\\\",\\\"Fecha publicada\\\",\\\"Caption\\\",\\\"Hashtags\\\",\\\"Responsable\\\",\\\"URL\\\",\\\"Notas\\\",\\\"Fuente\\\"]];S.admin.forEach(function(r){rows.push([r.episode_code,r.scene_no,r.category,r.program_name,r.chapter,r.episode_title,r.role,r.piece_title,r.status,r.platform,r.planned_date,r.published_date,r.caption,r.hashtags,r.owner,r.asset_url,r.notes,r.source])});var csv=rows.map(function(row){return row.map(function(v){return '\\\"'+String(v==null?\\\"\\\":v).replace(/\\\"/g,'\\\"\\\"')+'\\\"'}).join(\\\",\\\")}).join(\\\"\\\\n\\\");var blob=new Blob([csv],{type:\\\"text/csv;charset=utf-8\\\"});var a=document.createElement(\\\"a\\\");a.href=URL.createObjectURL(blob);a.download=\\\"CANAL8TV_Admin.csv\\\";document.body.appendChild(a);a.click();a.remove();setTimeout(function(){URL.revokeObjectURL(a.href)},500);toast(\\\"CSV exportado\\\")}\\n\\ndocument.addEventListener(\\\"click\\\",function(e){var t=e.target.closest(\\\"[data-view],[data-code],[data-admin],[data-action],[data-c8-process]\\\");if(!t)return;if(t.dataset.view){setView(t.dataset.view);return}if(t.dataset.code){openEpisode(t.dataset.code);return}if(t.dataset.admin){openAdmin(t.dataset.admin);return}if(t.dataset.c8Process){markC8(t.dataset.c8Process,t);return}var a=t.dataset.action;if(a===\\\"retry\\\"){load();return}if(a===\\\"close\\\"){closeModal();return}if(a===\\\"backdrop\\\"&&e.target===t){closeModal();return}if(a===\\\"save-episode\\\"){saveEpisode(t);return}if(a===\\\"create-episode\\\"){createEpisode(t);return}if(a===\\\"save-admin\\\"){saveAdmin(t);return}if(a===\\\"export\\\"){exportCsv();return}});\\ndocument.addEventListener(\\\"input\\\",function(e){if(e.target.id===\\\"search\\\"){S.q=e.target.value;clearTimeout(searchTimer);searchTimer=setTimeout(function(){var pos=S.q.length;render();var s=el(\\\"search\\\");if(s){s.focus();try{s.setSelectionRange(pos,pos)}catch(_){}}},220)}});\\ndocument.addEventListener(\\\"change\\\",function(e){if(e.target.id===\\\"category\\\"){S.cat=e.target.value;render();return}if(e.target.id===\\\"statusFilter\\\"){S.status=e.target.value;render();return}if(e.target.id===\\\"a-file\\\"){uploadFile(e.target.files&&e.target.files[0]);return}});\\nwindow.addEventListener(\\\"error\\\",function(e){console.error(\\\"CANAL8 client:\\\",e.message)});\\nwindow.addEventListener(\\\"unhandledrejection\\\",function(e){console.error(\\\"CANAL8 promise:\\\",e.reason)});\\nload();\\n})();\";\n\nconst clean=(v:any)=>String(v??\"\").trim();\nconst goodStatus=(v:any)=>STATUSES.has(clean(v))?clean(v):\"IDEA\";\nasync function log(action:string,ref:string,detail:string){\n await sqlite.execute({sql:\"INSERT INTO activity_log(action,ref_code,detail) VALUES(?,?,?)\",args:[action,ref,detail]});\n}\nasync function repairAdminRows(){\n const counts=await sqlite.execute(\"SELECT (SELECT COUNT(*) FROM episodes) AS e,(SELECT COUNT(*) FROM content_admin) AS a\");\n const e=Number(counts.rows[0]?.e||0),a=Number(counts.rows[0]?.a||0);\n if(a===e*6)return;\n for(let i=0;ic.body(null,204));\napp.get(\"/app.js\",(c)=>{c.header(\"Content-Type\",\"application/javascript; charset=utf-8\");c.header(\"Cache-Control\",\"no-store, max-age=0\");return c.body(CLIENT_JS)});\n\napp.get(\"/api/health\",async(c)=>{\n await repairAdminRows();\n const q=await sqlite.execute(\"SELECT (SELECT COUNT(*) FROM programs) AS programs,(SELECT COUNT(*) FROM episodes) AS episodes,(SELECT COUNT(*) FROM content_admin) AS admin_rows,(SELECT COUNT(*) FROM c8_inbox WHERE status!='PROCESADO') AS c8_pending\");\n const row=q.rows[0]||{};return c.json({...row,admin_ok:Number(row.admin_rows||0)===Number(row.episodes||0)*6});\n});\n\napp.get(\"/api/state\",async(c)=>{\n c.header(\"Cache-Control\",\"no-store, max-age=0\");await repairAdminRows();\n const [programs,episodes,admin,inbox,activity]=await Promise.all([\n sqlite.execute(\"SELECT * FROM programs ORDER BY code\"),\n sqlite.execute(\"SELECT * FROM episodes ORDER BY code\"),\n sqlite.execute(\"SELECT * FROM content_admin ORDER BY episode_code,scene_no\"),\n sqlite.execute(\"SELECT * FROM c8_inbox ORDER BY id DESC LIMIT 100\"),\n sqlite.execute(\"SELECT * FROM activity_log ORDER BY id DESC LIMIT 30\")\n ]);\n return c.json({programs:programs.rows,episodes:episodes.rows,admin:admin.rows,c8_inbox:inbox.rows,activity:activity.rows});\n});\n\napp.post(\"/api/episode/:code\",async(c)=>{\n const code=c.req.param(\"code\"),b=await c.req.json();\n const existing=await sqlite.execute({sql:\"SELECT * FROM episodes WHERE code=?\",args:[code]});\n const current=existing.rows[0];if(!current)return c.json({error:\"Episodio no encontrado\"},404);\n const scenes=[1,2,3,4,5,6].map(n=>String(b[\"scene\"+n]??\"\"));\n if(!clean(b.title))return c.json({error:\"El título es requerido\"},400);\n if(!scenes[0].toUpperCase().startsWith(\"IMPACTO\"))return c.json({error:\"La escena 1 debe iniciar con IMPACTO\"},400);\n const protectedCanon=Number(current.is_protected||0)===1;\n const category=protectedCanon?current.category:clean(b.category);\n const program=protectedCanon?current.program_name:clean(b.program_name);\n const chapter=protectedCanon?current.chapter:(Number(b.chapter)||1);\n const title=protectedCanon?current.title:clean(b.title);\n await sqlite.execute({sql:\"UPDATE episodes SET category=?,program_name=?,chapter=?,title=?,premise=?,status=?,scene1=?,scene2=?,scene3=?,scene4=?,scene5=?,scene6=?,planned_date=?,platforms=?,content_format=?,caption=?,hashtags=?,owner=?,notes=?,updated_at=CURRENT_TIMESTAMP WHERE code=?\",args:[category,program,chapter,title,String(b.premise||\"\"),goodStatus(b.status),...scenes,clean(b.planned_date),clean(b.platforms)||\"TikTok, YouTube Shorts\",clean(b.content_format)||\"Vertical 9:16\",String(b.caption||\"\"),String(b.hashtags||\"\"),String(b.owner||\"\"),String(b.notes||\"\"),code]});\n await syncAdmin({...b,category,program_name:program,chapter,title},code);\n await log(\"EPISODE_UPDATE\",code,\"Episodio actualizado.\");\n return c.json({ok:true,protected:protectedCanon});\n});\n\napp.post(\"/api/episode\",async(c)=>{\n const b=await c.req.json(),program=clean(b.program_name),title=clean(b.title),chapter=Number(b.chapter)||1;\n const scenes=[1,2,3,4,5,6].map(n=>String(b[\"scene\"+n]??\"\"));\n if(!title||!program)return c.json({error:\"Título y programa son requeridos\"},400);\n if(!scenes[0].toUpperCase().startsWith(\"IMPACTO\"))return c.json({error:\"La escena 1 debe iniciar con IMPACTO\"},400);\n const dupe=await sqlite.execute({sql:\"SELECT code FROM episodes WHERE program_name=? AND chapter=? LIMIT 1\",args:[program,chapter]});\n if(dupe.rows.length)return c.json({error:\"Ese programa ya tiene el capítulo \"+chapter+\" (\"+dupe.rows[0].code+\").\"},409);\n const q=await sqlite.execute(\"SELECT COALESCE(MAX(CAST(SUBSTR(code,2) AS INTEGER)),0) AS m FROM episodes\");\n const code=\"E\"+String(Number(q.rows[0]?.m||0)+1).padStart(3,\"0\");\n await sqlite.execute({sql:\"INSERT INTO episodes(code,category,program_name,chapter,title,premise,status,scene1,scene2,scene3,scene4,scene5,scene6,planned_date,platforms,content_format,caption,hashtags,owner,notes,is_protected,updated_at) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,0,CURRENT_TIMESTAMP)\",args:[code,clean(b.category)||\"SERIES\",program,chapter,title,String(b.premise||\"\"),goodStatus(b.status),...scenes,clean(b.planned_date),clean(b.platforms)||\"TikTok, YouTube Shorts\",clean(b.content_format)||\"Vertical 9:16\",String(b.caption||\"\"),String(b.hashtags||\"\"),String(b.owner||\"\"),String(b.notes||\"\")]});\n for(let n=1;n<=6;n++)await sqlite.execute({sql:\"INSERT INTO content_admin(episode_code,scene_no,category,program_name,chapter,episode_title,role,piece_title,status,platform,planned_date,caption,hashtags,owner,notes,source) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\",args:[code,n,clean(b.category)||\"SERIES\",program,chapter,title,ROLES[n-1],code+\"-S\"+n,goodStatus(b.status),clean(b.platforms)||\"TikTok, YouTube Shorts\",clean(b.planned_date),String(b.caption||\"\"),String(b.hashtags||\"\"),String(b.owner||\"\"),String(b.notes||\"\"),\"APP\"]});\n await log(\"EPISODE_CREATE\",code,title);\n return c.json({ok:true,code});\n});\n\napp.post(\"/api/admin/:id\",async(c)=>{\n const id=Number(c.req.param(\"id\")),b=await c.req.json();if(!id)return c.json({error:\"Fila inválida\"},400);\n const row=await sqlite.execute({sql:\"SELECT episode_code,scene_no FROM content_admin WHERE id=?\",args:[id]});if(!row.rows.length)return c.json({error:\"Fila no encontrada\"},404);\n await sqlite.execute({sql:\"UPDATE content_admin SET piece_title=?,status=?,platform=?,planned_date=?,published_date=?,caption=?,hashtags=?,asset_url=?,owner=?,notes=?,updated_at=CURRENT_TIMESTAMP WHERE id=?\",args:[String(b.piece_title||\"\"),goodStatus(b.status),String(b.platform||\"\"),clean(b.planned_date),clean(b.published_date),String(b.caption||\"\"),String(b.hashtags||\"\"),String(b.asset_url||\"\"),String(b.owner||\"\"),String(b.notes||\"\"),id]});\n await log(\"ADMIN_UPDATE\",String(row.rows[0].episode_code),\"Escena \"+row.rows[0].scene_no+\" actualizada.\");\n return c.json({ok:true});\n});\n\napp.post(\"/api/c8\",async(c)=>{\n const b=await c.req.json(),raw=clean(b.raw_text);if(!raw)return c.json({error:\"Información requerida\"},400);\n const status=clean(b.status)||\"PENDIENTE\";\n const q=await sqlite.execute({sql:\"INSERT INTO c8_inbox(raw_text,action_type,target_code,status,result_note,processed_at) VALUES(?,?,?,?,?,?) RETURNING *\",args:[raw,clean(b.action_type)||\"AUTO\",clean(b.target_code),status,String(b.result_note||\"\"),status===\"PROCESADO\"?new Date().toISOString():\"\"]});\n await log(\"C8_INBOX\",clean(b.target_code)||\"C8\",\"Entrada /c8 registrada.\");\n return c.json({ok:true,item:q.rows[0]});\n});\napp.post(\"/api/c8/:id/status\",async(c)=>{\n const id=Number(c.req.param(\"id\")),b=await c.req.json();if(!id)return c.json({error:\"Entrada inválida\"},400);\n const status=clean(b.status)||\"PROCESADO\";\n await sqlite.execute({sql:\"UPDATE c8_inbox SET status=?,processed_at=? WHERE id=?\",args:[status,status===\"PROCESADO\"?new Date().toISOString():\"\",id]});\n await log(\"C8_STATUS\",\"C8-\"+id,status);return c.json({ok:true});\n});\n\napp.post(\"/api/upload\",async(c)=>{\n const body=await c.req.parseBody(),file=body.file;if(!(file instanceof File))return c.json({error:\"Archivo requerido\"},400);\n if(file.size>4*1024*1024)return c.json({error:\"Máximo 4 MB\"},413);\n const safe=file.name.replace(/[^a-zA-Z0-9._-]+/g,\"-\").slice(-80),key=\"canal8-\"+Date.now()+\"-\"+safe;\n await blob.set(key,file);await log(\"FILE_UPLOAD\",safe,\"Archivo de \"+file.size+\" bytes\");\n return c.json({ok:true,url:\"/asset/\"+encodeURIComponent(key),name:file.name});\n});\napp.get(\"/asset/:key\",async(c)=>{try{const res=await blob.get(decodeURIComponent(c.req.param(\"key\")));return new Response(res.body,{headers:{\"content-type\":res.headers.get(\"content-type\")||\"application/octet-stream\",\"cache-control\":\"public,max-age=31536000\"}})}catch{return c.text(\"Archivo no encontrado\",404)}});\n\napp.get(\"/\",(c)=>{\n const host=c.req.header(\"host\")||\"\";if(host&&host!==\"canal8-control.val.run\")return c.redirect(\"https://canal8-control.val.run/\");\n c.header(\"Cache-Control\",\"no-store, max-age=0\");\n return c.html(`CANAL8.TV Control

CANAL8.TV

SIEMPRE INICIA IMPACTO

1 CLIP = 8S6 ESCENAS = 48SPLANILLA ADMIN INTERNA/c8 ACTIVO

ENCENDIENDO SEÑALPreparando sistema…

`);\n});\n\napp.onError((err)=>{console.error(err);return new Response(JSON.stringify({error:\"Error interno de CANAL8.TV\"}),{status:500,headers:{\"content-type\":\"application/json\"}})});\nexport default app.fetch;","deleted",false,"label",[19],{"_33":79,"_13":80,"_35":81,"_37":-5,"_38":39,"_40":66,"_42":43,"_44":82,"_17":68,"_47":83,"_49":-5,"_51":52,"_53":-5,"_60":84,"_18":85},{"_33":72,"_13":73,"_35":74,"_37":-5,"_38":39,"_40":66,"_42":43,"_44":75,"_17":68,"_47":24,"_49":76,"_51":52,"_53":-5,"_60":77,"_18":78},{"_33":63,"_13":64,"_35":65,"_37":-5,"_38":39,"_40":66,"_42":43,"_44":67,"_17":68,"_47":24,"_49":69,"_51":52,"_53":-5,"_60":70,"_18":71},{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":59,"_17":46,"_47":48,"_49":50,"_51":52,"_53":14,"_60":61,"_18":62},["D",1789386535414],"children",[],[19],"ae125ce8-d829-4628-9c06-80591501231a","README.md","01a09f7d-4745-7404-b411-44001c7df98e",1,["D",1789382182597],0,"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"root.tsx\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[],[64],"40d17095-896c-40f4-b476-a964e0a00978","CHANGELOG.md","01a09f7d-4745-7404-b411-42f16a1eb76e",["D",1789382182597],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

'+esc(e.title)+'

Programación viva,8 segundos a la vez.

De idea a publicación

Producción inicial

Actividad reciente

'+S.programs.length+' programas activos

'+esc(p.name)+'

Episodios · '+list.length+'

Cargar episodio completo

1 · Ficha

2 · Seis escenas

3 · Distribución

Admin · '+list.length+' piezas

Calendario · '+list.length+' piezas

/c8 · '+pendingC8()+' pendientes

Programación viva,
8 segundos a la vez.