[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","agentia","name","canal8-control","path","index.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":12,"_13":44},"permalink","https://www.val.town/x/agentia/canal8-control/code/index.ts","extension","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],"version",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",[14],"6356f220-ba45-4970-82b1-c17504400284",["D",1789382182597],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","CANAL8.TV production control","imageUrl","userId","b162e777-26d5-4b57-b5d4-824de1b425e2","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a087a7-039d-766a-a2cb-d9a1a861d44b","tursoName","6356f220ba45497082b1c17504400284","tursoHostname","6356f220ba45497082b1c17504400284-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789476033740],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_104":100},"org",{"_9":10,"_97":98,"_99":100,"_55":56,"_101":102,"_103":42},"branch",{"_35":30,"_11":88,"_22":28,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":12,"_96":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Agent Ia","avatar","https://lh3.googleusercontent.com/a/ACg8ocJFdiW2REahwLO-JAErcTTOgHyYDVN6VBKDk9RmathkK-sumQ=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":62,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":88,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

'+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.