[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_648":649,"_650":651},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_108":89,"_26":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":24,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_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":24},"version",458,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","scripts/resumen_historico.ts","latestPath","fileId","51457f66-b0d5-11f1-9d10-1607ee4eb77e","name","resumen_historico.ts","fileType","script","content","// Script de un solo uso: responde la pregunta de Noel de \"desde qué día llevamos el registro,\n// cuántos pedidos van y cuánto dinero se ha juntado en total\" — lee directo de \"Pedidos Resumen\"\n// (una fila por pedido cobrado) en vez de \"Pedidos\" (que tiene una fila por producto) para no\n// contar de más. También revisa la pestaña \"Gastos\" por si ahí hay algún rubro de \"inversión\"\n// capturado, para poder restarlo si existe.\nimport { readSheetAsObjects } from \"../backend/sheets.ts\";\n\nfunction parseFechaSheet(fecha: string): Date | null {\n const partes = String(fecha || \"\").trim().split(\"/\");\n if (partes.length !== 3) return null;\n const [d, m, y] = partes.map((p) => parseInt(p, 10));\n if (!d || !m || !y) return null;\n const f = new Date(y, m - 1, d);\n return isNaN(f.getTime()) ? null : f;\n}\n\nasync function main() {\n const rows = await readSheetAsObjects(\"Pedidos Resumen\");\n let primera: Date | null = null;\n let total = 0;\n let n = 0;\n for (const r of rows) {\n const f = parseFechaSheet(String(r[\"Fecha\"] || \"\"));\n const monto = Number(r[\"Total\"]) || 0;\n if (!f) continue;\n n++;\n total += monto;\n if (!primera || f < primera) primera = f;\n }\n\n const hoy = new Date();\n hoy.setHours(0, 0, 0, 0);\n const dias = primera ? Math.floor((hoy.getTime() - primera.getTime()) / 86400000) + 1 : null;\n\n console.log(\"Primer pedido con fecha válida:\", primera ? primera.toLocaleDateString(\"es-MX\") : \"no encontrado\");\n console.log(\"Días transcurridos (incluyendo hoy):\", dias);\n console.log(\"Pedidos cobrados contados:\", n);\n console.log(\"Total ventas acumuladas:\", total.toFixed(2));\n\n // Buscar algo parecido a \"inversión\" en Gastos\n try {\n const gastos = await readSheetAsObjects(\"Gastos\");\n const inversionRows = gastos.filter((g) =>\n String(g[\"Rubro\"] || \"\").toLowerCase().includes(\"inversi\") ||\n String(g[\"Descripción\"] || \"\").toLowerCase().includes(\"inversi\")\n );\n const totalInversion = inversionRows.reduce((s, g) => s + (Number(g[\"Monto\"]) || 0), 0);\n console.log(\"Filas en Gastos que mencionan 'inversión':\", inversionRows.length);\n console.log(\"Suma de esas filas:\", totalInversion.toFixed(2));\n if (inversionRows.length > 0) {\n console.log(JSON.stringify(inversionRows, null, 2));\n }\n } catch (e) {\n console.log(\"No se pudo leer Gastos:\", String(e));\n }\n}\n\nawait main();\n","createdAt",["D",1789456566229],"branchVersion","branchId","8c0e03b9-4364-49a7-9f88-4b3a597ffffc","id","8f3a6802-82b2-4247-8cf7-f627cfe596c3","suchi-house-pedidos",["D",1788198568874],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Sistema de pedidos por botones + inventario para Suchi House","imageUrl","fb83bb5a-9aee-4548-804a-06dc8e5f8bba","pinnedFileId","01a058f0-c40d-736f-b689-e16a000d9213","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a058ef-c604-7433-a919-134dbc7b0e08","tursoName","8f3a680282b242478cf7f627cfe596c3","tursoHostname","8f3a680282b242478cf7f627cfe596c3-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789501878689],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",469,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","noelgonzalezsuchi","handle","displayName","Gonzalez Garcia Noel","avatar","https://lh3.googleusercontent.com/a/ACg8ocIrFrculUXpRQjUt_dP3J-Hz7IQ4pouMXM2lew629FNmup_Ecm8=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":643,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":644,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":645,"_83":646,"_85":647,"_87":24},"tree",[438,446,457,461,462,463,464],"files",[438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464],"counts",{"_428":62,"_429":400,"_430":62,"_431":432,"_433":434},"contents",[371,372,373,374,375,376,377],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":370,"_251":-5},{"_42":369,"_251":-5},{"_42":368,"_251":-5},{"_42":367,"_251":-5},{"_42":366,"_251":-5},{"_42":365,"_251":-5},{"_42":364,"_251":-5},{"_42":363,"_251":-5},{"_42":362,"_251":-5},{"_42":361,"_251":-5},{"_42":360,"_251":-5},{"_42":359,"_251":-5},{"_42":358,"_251":-5},{"_42":357,"_251":-5},{"_42":356,"_251":-5},{"_42":355,"_251":-5},{"_42":354,"_251":-5},{"_42":353,"_251":-5},{"_42":352,"_251":-5},{"_42":351,"_251":-5},{"_42":350,"_251":-5},{"_42":349,"_251":-5},{"_42":348,"_251":-5},{"_42":347,"_251":-5},{"_42":346,"_251":-5},{"_42":345,"_251":-5},{"_42":344,"_251":-5},{"_42":343,"_251":-5},{"_42":342,"_251":-5},{"_42":341,"_251":-5},{"_42":340,"_251":-5},{"_42":339,"_251":-5},{"_42":338,"_251":-5},{"_42":337,"_251":-5},{"_42":336,"_251":-5},{"_42":335,"_251":-5},{"_42":334,"_251":-5},{"_42":333,"_251":-5},{"_42":332,"_251":-5},{"_42":331,"_251":-5},{"_42":330,"_251":-5},{"_42":329,"_251":-5},{"_42":328,"_251":-5},{"_42":327,"_251":-5},{"_42":326,"_251":-5},{"_42":325,"_251":-5},{"_42":324,"_251":-5},{"_42":323,"_251":-5},{"_42":322,"_251":-5},{"_42":321,"_251":-5},{"_42":320,"_251":-5},{"_42":319,"_251":-5},{"_42":318,"_251":-5},{"_42":317,"_251":-5},{"_42":316,"_251":-5},{"_42":315,"_251":-5},{"_42":314,"_251":-5},{"_42":313,"_251":-5},{"_42":312,"_251":-5},{"_42":311,"_251":-5},{"_42":310,"_251":-5},{"_42":309,"_251":-5},{"_42":308,"_251":-5},{"_42":307,"_251":-5},{"_42":306,"_251":-5},{"_42":305,"_251":-5},{"_42":304,"_251":-5},{"_42":303,"_251":-5},{"_42":302,"_251":-5},{"_42":301,"_251":-5},{"_42":300,"_251":-5},{"_42":299,"_251":-5},{"_42":298,"_251":-5},{"_42":297,"_251":-5},{"_42":296,"_251":-5},{"_42":295,"_251":-5},{"_42":294,"_251":-5},{"_42":293,"_251":-5},{"_42":292,"_251":-5},{"_42":291,"_251":-5},{"_42":290,"_251":-5},{"_42":289,"_251":-5},{"_42":288,"_251":-5},{"_42":287,"_251":-5},{"_42":286,"_251":-5},{"_42":285,"_251":-5},{"_42":284,"_251":-5},{"_42":283,"_251":-5},{"_42":282,"_251":-5},{"_42":281,"_251":-5},{"_42":280,"_251":-5},{"_42":279,"_251":-5},{"_42":278,"_251":-5},{"_42":277,"_251":-5},{"_42":276,"_251":-5},{"_42":275,"_251":-5},{"_42":274,"_251":-5},{"_42":273,"_251":-5},{"_42":272,"_251":-5},{"_42":271,"_251":-5},{"_42":270,"_251":-5},{"_42":269,"_251":-5},{"_42":268,"_251":-5},{"_42":267,"_251":-5},{"_42":266,"_251":-5},{"_42":265,"_251":-5},{"_42":264,"_251":-5},{"_42":263,"_251":-5},{"_42":262,"_251":-5},{"_42":261,"_251":-5},{"_42":260,"_251":-5},{"_42":259,"_251":-5},{"_42":258,"_251":-5},{"_42":257,"_251":-5},{"_42":256,"_251":-5},{"_42":255,"_251":-5},{"_42":254,"_251":-5},{"_42":253,"_251":-5},{"_42":252,"_251":-5},{"_42":250,"_251":-5},"7a1e4986-950a-4e5f-8083-864b53a05f46","reporterId","7347b6e2-7431-49e5-8204-d0b1e9a63c38","ddd77f07-cff0-4eda-82a1-731b2e9a901d","bcd7ad27-afd7-4a82-929e-32b82dc089d0","6408933e-a06a-448f-a9e6-9cb6461b1e7e","a08090b3-b9ad-49ab-b571-bcbd8e0f1d80","efa893e7-eee5-4bb3-a147-058278426055","c8b81440-a3e2-4e11-86ed-fb542dbb05cb","ffa8b1d4-1a34-4b94-9f5d-b13498b25716","5ca8f8b7-ec99-4aee-8fd9-23d140d684db","a2e31a6d-1a7e-4a33-b51a-f234b6941ac3","716e822b-1eb9-4a19-a6d1-4954036b6c58","0ee1f30d-c78d-4fdb-9391-3df7d0ba9b45","8e64949a-339a-4541-b553-ad0b15990ec6","3483a97e-b0c6-4e12-8539-6130a8c1e90f","8248401b-a670-474c-940d-9c3e09427653","4078546d-c9bf-4934-a822-a932a5a30067","e751d08e-6e47-4cc3-bea7-24a9b38ffc8f","4d1489ec-e973-4fc9-bc5c-9b7050fdce1a","bbb5ccec-b09c-4a45-a3c6-2fd6f8a70d74","21563e62-1333-4217-bf5e-4918cd92df90","423b4c86-9e37-430a-9746-4a478653cc33","9d756400-73cf-4b13-9a9a-9bb43b7abe34","8454ea50-1518-44a5-a311-98bb6e3de480","41d082ec-211b-45ad-8de2-3792d85436f5","ca479534-6224-4c82-a9cf-4f82c9688231","b675b90a-5c1e-4d13-a77e-20425a20e274","527cd861-9608-4022-954a-7243c3323b23","928f2688-beb6-4298-8eda-48c3c9790bb0","de6a3943-2c09-4d4b-82da-2881a28f578c","7e53ffcc-bda8-48d3-a3ea-17db42f18c13","234eac3f-84ee-496f-a98f-dc4a30472158","9db39016-e51d-41a4-9617-02c0238c2dde","7925d5ef-1561-4938-919a-515c37a00777","05953647-e283-4609-ab6c-230d9bb0b636","94820812-7c23-41b9-a391-1860d2eb4364","6f7f6edc-c24a-4688-8896-c1eab8f0e7de","7231499b-5e12-4fe6-b7cd-85fdbd5e93e7","46acad21-4801-416b-a616-4013f1c35d38","15bc1384-b318-4191-bc36-15ab5adbc965","3e455f0e-6469-46e3-aac8-ec3869f59194","6f45bfd7-8882-4ea2-9cb6-93df2bd17afb","c2c240e2-a33c-4308-a8b3-40294039f976","0be2461a-7ee4-41e9-9ff7-396730dc22f2","ed4d3963-5cea-49aa-9faf-b35046a616cf","39b211c0-b9ba-456a-a33a-272205eed05b","b4cb08bc-3092-4dc1-8135-f786573365ec","9da9823f-f365-4207-8df7-8ba3b20394f2","4a852160-52bd-4d94-bd49-c44d5f2e3fa1","7892ef76-f9eb-45e1-a382-3dd65659524f","8a5680cc-a2a9-41e9-aac7-d697d3433302","c73d0ad0-cabe-4c0f-81ed-a6eed528e7f2","25b49700-9df3-4327-b71d-608598ab6f4b","8496a95f-f8ae-4dc9-bb26-f4d35010fce8","077b8837-8bb7-4412-b015-74909894fd5a","6e2d134f-93fe-4d99-85b7-b68448bdbb12","1b3a05a9-41a9-4147-a735-e096229df6f7","f0ef885a-23ae-4491-846e-ed60c8b921fc","81e11671-a950-4c8b-b559-040028783876","b4f76924-f266-4586-8eae-354537b0717b","33199bf7-c103-44eb-a4a2-d1b880c53a13","55ba750b-2ad7-4acf-bc28-c077fa14ec05","ce7f30cf-6a57-4f17-8297-b51deebfd3d1","72d2208d-ab12-428a-bd23-c097f8ee25b7","b0449823-4581-4fa5-92ad-2eec4688d0e5","21f284a6-fc61-49e6-a156-98f5e0afd2bf","a03cb57f-1199-442e-8740-9414e70b9186","28909152-0e50-4e94-b02c-a907fdee3f01","6f741908-8104-4c11-a555-f28da9c1538f","7a4e508f-fd8d-47e0-a7e8-0b9ed4278e67","68a07995-0a40-4184-b292-a325851df8cb","067ae9a2-2817-40d0-9bc8-8c55089b3d94","9975cf0f-0726-4520-98dc-6253194d3159","c1bb268c-f880-47ec-a5d6-21611adaa16a","f8d1f425-4a0b-442c-8132-f2b4a51ee3cf","e9218e1a-f5cf-4aec-95cb-03d14a13dc9d","2c64cb14-1821-43ff-a1df-517ea150708b","cfb254e8-102e-4e06-a92c-8311e647b8ab","f2e5bc83-66da-4141-8bbf-064456c4ca71","93266443-6215-4233-b0af-b70552fe6a3b","19e30d43-570d-45f2-b0fe-1a4d155b7b38","53a36473-2263-4e15-86ac-97f05b23e912","794db6d0-a6ef-48b9-b58c-84ec468901b8","5ee5d37f-f10f-40de-ab5a-1a95e494c6bb","4e97b23c-e5df-4b64-a56c-4456b43c1937","3e779f7a-2a4c-486e-b1d2-66869689a57a","c5e6dcec-60eb-4435-8c9f-7ca32f152155","44c5391e-0ad6-4273-8373-127f22fee37c","e4c4bd1b-60cd-4473-b144-46014c595343","82d522bf-7c8c-4d3a-8f2e-37208f2d6270","ac7ca542-65cd-4dbc-b57e-77fc85574d27","f77c3a06-6fe9-4c1d-b9ce-c6f541c37243","08034413-99b3-4b81-9779-7219de9e8725","7abf230d-4f62-4a63-8090-f16ccfda7d75","00af3b9c-67ed-4a86-b9b2-7793322dc825","a7450d76-a295-489a-9bf6-21ea94eb1b3a","6d043740-e6f3-413d-a20c-3042d4727ae7","452ee35f-f7e1-451d-9a36-0389f23c3355","5983df28-46e7-4a77-aee4-ee8aec6812b5","bdf61394-93b9-47e3-8a20-e3b9ad813ffb","7459ca1c-f201-4b02-901b-f2ccac82cec6","ae659c51-4cc1-41e8-9f18-5ae70f2d3cc5","d4a7821c-4ee8-4ab0-869c-2f757cfb1f71","d54b1a72-b377-47d0-8f45-c22d5092098f","7eda3fae-2c67-47a6-ac39-78c6ef0c82b8","2cac639e-071e-4593-b920-876a98793156","58689f14-f71a-4ad6-b91a-46b08a95d8f5","7bf96fe2-9a72-46ae-a930-94bcc58a6dda","07df9b2b-7f2a-4f81-bc81-bd88f669035d","4699cd21-c62e-438c-92ae-975ffb436b61","c1395981-a402-4f66-8c0c-98f63a57f98b","effb1211-c286-481a-be4f-348a917cd015","5858a53f-603b-4ed9-a278-edf11c04793c","8e59573d-6180-4544-b1ed-5414690c0235","d17c71ab-35c4-4341-9686-d0f6eb31bc67","ad82796c-58fb-41ea-8bdd-a0eebda0e3c9","8faa66bf-f4bc-456e-a104-98ddc316dd90","9405dadc-aefb-40fe-a0e3-c33dbf0936b2","78ac20dc-65f5-45f1-850b-04242c08d0b9","3893c820-3e45-47a3-8999-5f7eda5bd7d3",{"_42":422,"_31":423,"_29":424,"_380":-5,"_40":41,"_39":425,"_382":58,"_37":426,"_13":62,"_33":415,"_35":-5,"_23":24,"_387":-5,"_26":427},{"_42":417,"_31":418,"_29":419,"_380":-5,"_40":41,"_39":400,"_382":58,"_37":420,"_13":62,"_33":415,"_35":-5,"_23":24,"_387":-5,"_26":421},{"_42":410,"_31":411,"_29":412,"_380":-5,"_40":41,"_39":413,"_382":58,"_37":414,"_13":62,"_33":415,"_35":-5,"_23":24,"_387":-5,"_26":416},{"_42":404,"_31":405,"_29":406,"_380":-5,"_40":41,"_39":400,"_382":58,"_37":407,"_13":62,"_33":20,"_35":408,"_23":24,"_387":-5,"_26":409},{"_42":397,"_31":398,"_29":399,"_380":-5,"_40":41,"_39":400,"_382":58,"_37":401,"_13":62,"_33":20,"_35":402,"_23":24,"_387":-5,"_26":403},{"_42":389,"_31":390,"_29":391,"_380":-5,"_40":41,"_39":392,"_382":58,"_37":393,"_13":62,"_33":394,"_35":395,"_23":24,"_387":-5,"_26":396},{"_42":378,"_31":379,"_29":56,"_380":-5,"_40":41,"_39":381,"_382":58,"_37":383,"_13":384,"_33":385,"_35":386,"_23":24,"_387":-5,"_26":388},"a1e4bd9e-cde7-4541-8255-e442298a3d5c","index.ts","parentId",450,"latest",["D",1789328354530],65,"http","import { immutableFileUrl, parseVal, serveFile, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\nimport {\n getMenu,\n getAlertasInsumos,\n buscarPrecioProducto,\n descontarInsumos,\n enviarAlertaInsumos,\n registrarPedidoEnSheet,\n registrarResumenPedidoEnSheet,\n escribirResumenVentasYGanancias,\n listarHistorialPedidos,\n buscarPedidoCobradoEnSheet,\n calcularCorte,\n listarInsumosParaSeleccion,\n registrarCompraInsumo,\n ajustarInsumoActual,\n obtenerReporteProductos,\n} from \"./backend/negocio.ts\";\nimport {\n crearPedido,\n getPedidosAbiertos,\n agregarItem,\n quitarItem,\n cancelarPedido,\n obtenerPedido,\n eliminarPedidoActivo,\n setEnvio,\n setNota,\n setListo,\n setItemHecho,\n} from \"./backend/pedidosActivos.ts\";\nimport { fechaHoyMX, formatearCorte, formatearTicket } from \"./backend/ticket.ts\";\nimport { obtenerFondoCaja, guardarFondoCaja } from \"./backend/caja.ts\";\nimport { obtenerEstadoAsistenciaHoy, marcarEntrada, marcarSalida } from \"./backend/asistencia.ts\";\nimport { calcularNominaPeriodo, escribirNominaYCostoOperativo, obtenerPagosPorHora } from \"./backend/nomina.ts\";\n\nconst app = new Hono();\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// Logos: rutas simples (sin versionar) para que el componente cliente los pueda\n// referenciar directo con un

normal, sin depender de immutableFileUrl.\napp.get(\"/frontend/logo-wordmark.svg\", () => serveFile(\"/frontend/logo-wordmark.svg\"));\napp.get(\"/frontend/logo-icon.svg\", () => serveFile(\"/frontend/logo-icon.svg\"));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Pantalla de cocina: para dejar abierta en una tablet/celular en la cocina, mostrando los\n// pedidos abiertos en tiempo real (se refresca sola cada 5s). Es HTML+JS plano a propósito\n// (sin React) para que sea ligera y a prueba de fallos en cualquier dispositivo, por viejo que\n// sea, y para que nunca dependa de que la pantalla principal esté abierta en otro lado.\napp.get(\"/cocina\", (c) =>\n c.html(`\n\n\n\n\nSuchi House — Cocina\n\n\n\n

👨‍🍳 Suchi House — Cocina

\n\n\n\n`));\n\n// Manifest de PWA (para \"Agregar a pantalla de inicio\" en el celular). Se genera aquí\n// -no como archivo estático- para que el ícono siempre apunte a la versión actual del val.\napp.get(\"/manifest.json\", (c) =>\n c.json({\n name: \"Suchi House — Pedidos\",\n short_name: \"Suchi House\",\n description: \"Sistema de pedidos e inventario de Suchi House\",\n start_url: \"/\",\n scope: \"/\",\n display: \"standalone\",\n orientation: \"portrait\",\n background_color: \"#0d1f1e\",\n theme_color: \"#0d1f1e\",\n icons: [\n { src: immutableFileUrl(\"/frontend/logo-icon.svg\"), sizes: \"any\", type: \"image/svg+xml\", purpose: \"any maskable\" },\n ],\n }));\n\n/* ---------------- API ---------------- */\n\napp.get(\"/api/menu\", async (c) => {\n try {\n const menu = await getMenu();\n return c.json({ ok: true, menu });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.get(\"/api/insumos/alertas\", async (c) => {\n try {\n const alertas = await getAlertasInsumos();\n return c.json({ ok: true, alertas });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.get(\"/api/insumos/lista\", async (c) => {\n try {\n const insumos = await listarInsumosParaSeleccion();\n return c.json({ ok: true, insumos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/insumos/compra\", async (c) => {\n try {\n const { insumo, cantidad } = await c.req.json();\n const n = Number(cantidad);\n if (!insumo) return c.json({ ok: false, error: \"Falta el insumo\" }, 400);\n if (!isFinite(n) || n <= 0) return c.json({ ok: false, error: \"Cantidad inválida\" }, 400);\n const resultado = await registrarCompraInsumo(insumo, n);\n return c.json({ ok: true, ...resultado });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n// Fija la cantidad exacta contada físicamente (a diferencia de /api/insumos/compra, que suma).\n// Usado por el flujo de captura inicial de inventario (\"de 5 en 5\") y para recuentos.\napp.post(\"/api/insumos/ajustar\", async (c) => {\n try {\n const { insumo, actual } = await c.req.json();\n const n = Number(actual);\n if (!insumo) return c.json({ ok: false, error: \"Falta el insumo\" }, 400);\n if (!isFinite(n) || n < 0) return c.json({ ok: false, error: \"Cantidad inválida\" }, 400);\n const resultado = await ajustarInsumoActual(insumo, n);\n return c.json({ ok: true, ...resultado });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.get(\"/api/pedidos\", async (c) => {\n try {\n const pedidos = await getPedidosAbiertos();\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/pedidos\", async (c) => {\n try {\n const { tipo, identificador } = await c.req.json();\n if (!tipo) return c.json({ ok: false, error: \"Falta tipo\" }, 400);\n const id = await crearPedido(tipo, identificador || \"\");\n return c.json({ ok: true, id });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/pedidos/:id/items\", async (c) => {\n try {\n const idPedido = c.req.param(\"id\");\n const { categoria, producto, cantidad } = await c.req.json();\n if (!producto) return c.json({ ok: false, error: \"Falta producto\" }, 400);\n const info = await buscarPrecioProducto(producto);\n if (!info) return c.json({ ok: false, error: `Producto no encontrado en el Menú: ${producto}` }, 404);\n const pedidos = await agregarItem(idPedido, categoria || info.categoria, producto, Number(cantidad) || 1, info.precio);\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.delete(\"/api/pedidos/items/:rowId\", async (c) => {\n try {\n const rowId = c.req.param(\"rowId\");\n const pedidos = await quitarItem(rowId);\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/pedidos/:id/envio\", async (c) => {\n try {\n const idPedido = c.req.param(\"id\");\n const { monto } = await c.req.json();\n const n = Number(monto);\n if (!isFinite(n) || n < 0) return c.json({ ok: false, error: \"Monto de envío inválido\" }, 400);\n const pedido = await obtenerPedido(idPedido);\n if (!pedido) return c.json({ ok: false, error: \"Pedido no encontrado\" }, 404);\n if (pedido.tipo !== \"Domicilio\") return c.json({ ok: false, error: \"El envío solo aplica a pedidos a Domicilio\" }, 400);\n const pedidos = await setEnvio(idPedido, n);\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/pedidos/:id/nota\", async (c) => {\n try {\n const idPedido = c.req.param(\"id\");\n const { nota } = await c.req.json();\n const pedidos = await setNota(idPedido, String(nota || \"\").slice(0, 300));\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n// Lo usa la pantalla de Cocina (botón de palomita) para marcar un pedido como terminado —\n// deja de mostrarse ahí, y la pantalla principal avisa (sonido + insignia) a quien va a cobrar.\napp.post(\"/api/pedidos/:id/listo\", async (c) => {\n try {\n const idPedido = c.req.param(\"id\");\n const body = await c.req.json().catch(() => ({}));\n const listo = body.listo === false ? false : true;\n const pedidos = await setListo(idPedido, listo);\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n// Lo usa la pantalla de Cocina (palomita por ítem) para marcar solo UNA parte del pedido como\n// hecha mientras el resto sigue pendiente. A propósito NO manda ninguna notificación a nadie —\n// es solo memoria visual local de esa pantalla, distinto del botón \"✅ Listo\" de todo el pedido.\napp.post(\"/api/pedidos/items/:rowId/hecho\", async (c) => {\n try {\n const rowId = c.req.param(\"rowId\");\n const body = await c.req.json().catch(() => ({}));\n const hecho = body.hecho === false ? false : true;\n const pedidos = await setItemHecho(rowId, hecho);\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.delete(\"/api/pedidos/:id\", async (c) => {\n try {\n const idPedido = c.req.param(\"id\");\n const pedidos = await cancelarPedido(idPedido);\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/pedidos/:id/cobrar\", async (c) => {\n try {\n const idPedido = c.req.param(\"id\");\n const body = await c.req.json().catch(() => ({}));\n const metodoPago: string = body.metodoPago || \"\";\n const atendioQuien: string = body.atendioQuien || \"\";\n if (!metodoPago) return c.json({ ok: false, error: \"Falta indicar el método de pago.\" }, 400);\n\n const pedido = await obtenerPedido(idPedido);\n if (!pedido) return c.json({ ok: false, error: \"Pedido no encontrado\" }, 404);\n if (pedido.items.length === 0) return c.json({ ok: false, error: \"Este pedido no tiene productos todavía.\" }, 400);\n if (pedido.tipo === \"Domicilio\" && (pedido.envio === null || pedido.envio === undefined)) {\n return c.json({ ok: false, error: \"Falta agregar el envío antes de cobrar este pedido a domicilio.\" }, 400);\n }\n\n const itemsPedido = pedido.items.map((it) => ({\n categoria: it.categoria,\n producto: it.producto,\n cantidad: it.cantidad,\n precioUnitario: it.precioUnitario,\n subtotal: it.subtotal,\n }));\n\n // El envío de domicilio se agrega como una línea más del pedido (sin receta, así que\n // descontarInsumos no le busca insumos) para que fluya solo por el registro en el Sheet,\n // el ticket y el total, sin duplicar lógica.\n if (pedido.tipo === \"Domicilio\" && pedido.envio) {\n itemsPedido.push({\n categoria: \"Envio\",\n producto: \"Envío a domicilio\",\n cantidad: 1,\n precioUnitario: pedido.envio,\n subtotal: pedido.envio,\n });\n }\n\n const total = itemsPedido.reduce((s, it) => s + it.subtotal, 0);\n\n const ahora = new Date();\n const fecha = ahora.toLocaleDateString(\"es-MX\", { timeZone: \"America/Mexico_City\" });\n const hora = ahora.toLocaleTimeString(\"es-MX\", { timeZone: \"America/Mexico_City\", hour: \"2-digit\", minute: \"2-digit\" });\n\n // 1) Registrar en Pedidos (Sheet) — el pedido activo NO se borra localmente\n // hasta que esto tenga éxito, para no perderlo si falla la escritura.\n await registrarPedidoEnSheet(idPedido, pedido.tipo, pedido.identificador, itemsPedido, fecha, hora, metodoPago, atendioQuien);\n\n // 1b) Registrar también en \"Pedidos Resumen\" (una sola fila por pedido, fácil de leer) —\n // si esto falla no debe tumbar el cobro, ya que \"Pedidos\" (arriba) es la fuente de\n // verdad real y ya quedó guardada.\n try {\n await registrarResumenPedidoEnSheet(idPedido, pedido.tipo, pedido.identificador, itemsPedido, fecha, hora, total, metodoPago, atendioQuien);\n } catch (e) {\n console.error(\"No se pudo escribir en Pedidos Resumen (el pedido ya se registró bien en Pedidos):\", e);\n }\n\n // 1c) Refrescar la pestaña \"Ventas y Ganancias\" (Hoy/Semana/Mes) con este pedido ya incluido.\n // Igual que arriba: si falla, nunca debe tumbar el cobro — el pedido ya quedó guardado.\n try {\n await escribirResumenVentasYGanancias();\n } catch (e) {\n console.error(\"No se pudo actualizar la pestaña Ventas y Ganancias (el pedido ya se registró bien):\", e);\n }\n\n // Ya quedó registrado en el Sheet: ahora sí lo quitamos de \"activos\".\n await eliminarPedidoActivo(idPedido);\n\n // 2) Descontar insumos según Recetas y 3) enviar alerta por correo si algo quedó\n // BAJO (solo lo recién cruzado). El pedido YA quedó registrado en el Sheet arriba,\n // así que un problema aquí (Sheet lento, correo, etc.) nunca debe tumbar el cobro\n // ni impedir que aparezca la comanda/cuenta para imprimir.\n // El envío es una línea sin receta y sin empaque propio (no es un producto físico que se\n // sirva en un domo) — se excluye de descontarInsumos para no sumarle Domo/Estiquer de más.\n const itemsParaInsumos = itemsPedido.filter((it) => it.categoria !== \"Envio\");\n\n // El empaque (Domo + Estiquer / vaso-tapa de Ramen) aplica a todo lo que se va para llevar:\n // Domicilio y también \"Para llevar\" (mostrador). En Mesa/Barra se come en el local, sin empaque.\n const esParaLlevar = pedido.tipo === \"Domicilio\" || pedido.tipo === \"Para llevar\";\n\n let alertasNuevas: Awaited> = [];\n try {\n alertasNuevas = await descontarInsumos(itemsParaInsumos, esParaLlevar);\n if (alertasNuevas.length > 0) {\n await enviarAlertaInsumos(alertasNuevas);\n }\n } catch (e) {\n console.error(\"Error descontando insumos / enviando alerta (el pedido ya se registró bien):\", e);\n }\n\n // 4) Armar textos de Comanda y Cuenta\n const encabezado = pedido.tipo ? `${pedido.tipo}: ${pedido.identificador}\\n` : \"\";\n const notaLinea = pedido.nota ? `\\n📝 NOTA: ${pedido.nota}\\n` : \"\";\n const comanda = `COMANDA — Pedido #${idPedido}\\n${encabezado}${fecha} ${hora}${notaLinea}\\n------------------------\\n` +\n itemsPedido.map((it) => `${it.cantidad}x ${it.producto}`).join(\"\\n\");\n\n const cuenta = formatearTicket({ idPedido, pedido, itemsPedido, total, fecha, hora, metodoPago, atendioQuien });\n\n return c.json({ ok: true, comanda, cuenta, total, alertas: alertasNuevas });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n/* ---------------- Historial, reimpresión de tickets y corte de caja ---------------- */\n\napp.get(\"/api/pedidos/historial\", async (c) => {\n try {\n const limit = Number(c.req.query(\"limit\")) || 50;\n const buscar = c.req.query(\"buscar\") || \"\";\n const pedidos = await listarHistorialPedidos(limit, buscar);\n return c.json({ ok: true, pedidos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n// IMPORTANTE: esta ruta va ANTES de \"/api/pedidos/:id/ticket\" — si no, Hono trataría \"ultimo\"\n// como si fuera el :id de la otra ruta y esta nunca se alcanzaría.\napp.get(\"/api/pedidos/ultimo/ticket\", async (c) => {\n try {\n const historial = await listarHistorialPedidos(1);\n if (historial.length === 0) {\n return c.json({ ok: false, error: \"Todavía no hay ningún pedido cobrado.\" }, 404);\n }\n const idPedido = historial[0].idPedido;\n const datos = await reconstruirTicketDesdeSheet(idPedido);\n if (!datos) return c.json({ ok: false, error: \"No se encontró el último pedido.\" }, 404);\n return c.json({ ok: true, ...datos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.get(\"/api/pedidos/:id/ticket\", async (c) => {\n try {\n const idPedido = c.req.param(\"id\");\n const datos = await reconstruirTicketDesdeSheet(idPedido);\n if (!datos) return c.json({ ok: false, error: `No se encontró el pedido #${idPedido} (¿ya está cobrado?).` }, 404);\n return c.json({ ok: true, ...datos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.get(\"/api/reportes/top-productos\", async (c) => {\n try {\n const dias = Number(c.req.query(\"dias\")) || 7;\n const reporte = await obtenerReporteProductos(dias);\n return c.json({ ok: true, reporte });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.get(\"/api/caja/fondo\", async (c) => {\n try {\n const fecha = c.req.query(\"fecha\") || fechaHoyMX();\n const monto = await obtenerFondoCaja(fecha);\n return c.json({ ok: true, fecha, monto });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/caja/fondo\", async (c) => {\n try {\n const { fecha, monto } = await c.req.json();\n const n = Number(monto);\n if (!isFinite(n) || n < 0) return c.json({ ok: false, error: \"Monto de fondo de caja inválido\" }, 400);\n const fechaFinal = fecha || fechaHoyMX();\n await guardarFondoCaja(fechaFinal, n);\n return c.json({ ok: true, fecha: fechaFinal, monto: n });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.get(\"/api/corte\", async (c) => {\n try {\n const fecha = c.req.query(\"fecha\") || fechaHoyMX();\n const resumen = await calcularCorte(fecha);\n const texto = formatearCorte(resumen);\n return c.json({ ok: true, resumen, texto });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n/* ---------------- Checador (entrada/salida de empleados) ---------------- */\n\napp.get(\"/api/asistencia/estado\", async (c) => {\n try {\n const estado = await obtenerEstadoAsistenciaHoy();\n return c.json({ ok: true, estado });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\napp.post(\"/api/asistencia/entrada\", async (c) => {\n try {\n const { empleado } = await c.req.json();\n if (!empleado) return c.json({ ok: false, error: \"Falta indicar el empleado.\" }, 400);\n await marcarEntrada(empleado);\n const estado = await obtenerEstadoAsistenciaHoy();\n return c.json({ ok: true, estado });\n } catch (e) {\n return c.json({ ok: false, error: String(e instanceof Error ? e.message : e) }, 400);\n }\n});\n\napp.post(\"/api/asistencia/salida\", async (c) => {\n try {\n const { empleado } = await c.req.json();\n if (!empleado) return c.json({ ok: false, error: \"Falta indicar el empleado.\" }, 400);\n await marcarSalida(empleado);\n const estado = await obtenerEstadoAsistenciaHoy();\n return c.json({ ok: true, estado });\n } catch (e) {\n return c.json({ ok: false, error: String(e instanceof Error ? e.message : e) }, 400);\n }\n});\n\n/* ---------------- Nómina (costo de personal, pestaña \"Nómina y Costo Operativo\") ---------------- */\n\n// Pago por hora vigente de cada empleado, tal como está capturado ahora mismo en la pestaña\n// \"Nómina\" del Sheet (Noel la puede editar a mano ahí, esto solo la lee).\napp.get(\"/api/nomina/pagos\", async (c) => {\n try {\n const pagos = await obtenerPagosPorHora();\n return c.json({ ok: true, pagos });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n// Horas trabajadas y costo de nómina Hoy/Semana/Mes, calculados en el momento (sin escribir\n// nada en el Sheet) — útil para mostrarlo dentro de la app si algún día se quiere.\napp.get(\"/api/nomina/resumen\", async (c) => {\n try {\n const resumen = await calcularNominaPeriodo();\n return c.json({ ok: true, resumen });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n// Refresca a mano la pestaña \"Nómina y Costo Operativo\" (normalmente se refresca sola al\n// marcar una salida en el Checador, pero este endpoint permite forzarlo, p. ej. después de\n// editar un pago por hora en la pestaña \"Nómina\").\napp.post(\"/api/nomina/refrescar\", async (c) => {\n try {\n await escribirNominaYCostoOperativo();\n const resumen = await calcularNominaPeriodo();\n return c.json({ ok: true, resumen });\n } catch (e) {\n return c.json({ ok: false, error: String(e) }, 500);\n }\n});\n\n/* ---------------- Ticket (para cliente, al cobrar) ---------------- */\n\n/** Reconstruye el ticket de un pedido YA COBRADO leyendo sus líneas directamente de la pestaña\n * Pedidos (no depende de la tabla local de pedidos activos, que ya se borró al cobrar). Se usa\n * para \"Reimprimir ticket\", tanto por ID como para el último cobrado. */\nasync function reconstruirTicketDesdeSheet(idPedido: string) {\n const pedido = await buscarPedidoCobradoEnSheet(idPedido);\n if (!pedido) return null;\n const cuenta = formatearTicket({\n idPedido: pedido.idPedido,\n pedido: { tipo: pedido.tipo, identificador: pedido.identificador },\n itemsPedido: pedido.itemsPedido,\n total: pedido.total,\n fecha: pedido.fecha,\n hora: pedido.hora,\n metodoPago: pedido.metodoPago,\n atendioQuien: pedido.atendioQuien,\n });\n return { idPedido: pedido.idPedido, cuenta, total: pedido.total };\n}\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;\n","label",[379],"abf87f74-f1ea-4d74-adbd-a5c36bf7e192","corte-diario.ts","2a54411e-a6ba-11f1-afb1-1607ee4eb77e",265,["D",1788345392931],"interval","// Corte de caja automático diario: corre solo cada noche a la hora de cierre y le manda a\n// Noel por correo el corte del día, sin que tenga que abrir la app ni darle clic a nada.\n// Hora por defecto: 11:00pm hora CDMX (mañana Noel confirma la hora real de cierre y se\n// ajusta el cron con write_interval_settings — ver el comentario al fondo de este archivo).\nimport { email } from \"https://esm.town/v/std/email\";\nimport { calcularCorte } from \"./backend/negocio.ts\";\nimport { fechaHoyMX, formatearCorte } from \"./backend/ticket.ts\";\n\nexport default async function (interval: Interval) {\n const fecha = fechaHoyMX();\n const resumen = await calcularCorte(fecha);\n const texto = formatearCorte(resumen);\n\n // Si no hubo ningún pedido cobrado hoy, igual mandamos el correo (útil para confirmar que\n // el sistema sigue corriendo, y para detectar rápido si algo se quedó sin registrar).\n const asunto = resumen.numPedidos > 0\n ? `Suchi House — Corte de caja: $${resumen.totalVentas.toFixed(2)} (${resumen.numPedidos} pedidos)`\n : `Suchi House — Corte de caja: sin ventas hoy`;\n\n await email({\n subject: asunto,\n text: texto,\n });\n\n console.log(`Corte diario enviado para ${fecha}: $${resumen.totalVentas.toFixed(2)}, ${resumen.numPedidos} pedidos.`);\n}\n\n// Cron actual: \"0 5 * * *\" (05:00 UTC = 23:00 / 11pm hora CDMX, sin considerar horario de\n// verano — Val Town no lo ajusta solo). Para cambiar la hora, usar write_interval_settings\n// sobre este archivo con el nuevo cron expression en UTC.\n",[390],"79f1e00e-3a4b-4bc6-b2af-20c3e74f03d3","README.md","01a058f0-c40d-736f-b689-dd29e61e5e85",1,["D",1788198568874],"# 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",[398],"a81540c7-19be-49b2-bf27-9d4307e3abd0","CHANGELOG.md","01a058f0-c40d-736f-b689-da60c822ec3b",["D",1788198568874],"# 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

Diff · v458