[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_615":616,"_617":618},"routes/_app.x.$handle.$name",{"_101":100,"_33":47,"_110":91,"_28":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":27,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_45":46,"_33":47,"_40":48,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":55,"_56":-5,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":27},"version",387,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":34,"_35":36,"_37":39,"_40":41,"_42":14,"_43":44,"_24":27},"previous",{"_31":32,"_33":34,"_35":36,"_37":38},"deleted",true,"deletedHere",false,"path","scripts/diagnostico_panel.ts","latestPath","fileId","52caa5b0-a995-11f1-869b-1607ee4eb77e","name","diagnostico_panel.ts","fileType","script","content","import { gsheet_call } from \"https://esm.town/v/mattx/gsheet_call\";\nimport { SHEET_ID } from \"../backend/sheets.ts\";\n\nfunction sa() {\n const v = Deno.env.get(\"GOOGLE_SA\");\n if (!v) throw new Error(\"Falta GOOGLE_SA\");\n return v;\n}\n\n// 1) Listar todas las pestañas\nconst meta = await (await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${SHEET_ID}?fields=sheets.properties.title`,\n { headers: { Authorization: `Bearer ${(await (async () => {\n const { getToken } = await import(\"https://deno.land/x/google_jwt_sa@v0.2.3/mod.ts\");\n const t = await getToken(sa(), { scope: [\"https://www.googleapis.com/auth/spreadsheets\"] });\n return t.access_token;\n })())}` } },\n)).json();\nconsole.log(\"PESTAÑAS:\", JSON.stringify(meta.sheets?.map((s: any) => s.properties?.title)));\n\n// 2) La pestaña \"Resumen\" es el panel de control\nconst nombrePosible = \"Resumen\";\nconsole.log(\"NOMBRE ENCONTRADO:\", nombrePosible);\n\n// 3) Revisar cuántas filas reales hay ahora en Pedidos y Gastos (para saber el rango correcto)\nconst pedidosVals = await gsheet_call(sa(), SHEET_ID, \"GET\", `values/${encodeURIComponent(\"'Pedidos'!A1:N20\")}?majorDimension=ROWS&valueRenderOption=UNFORMATTED_VALUE`, {});\nconsole.log(\"PEDIDOS (primeras filas):\", JSON.stringify(pedidosVals.values));\n\nconst gastosVals = await gsheet_call(sa(), SHEET_ID, \"GET\", `values/${encodeURIComponent(\"'Gastos'!A1:E20\")}?majorDimension=ROWS&valueRenderOption=UNFORMATTED_VALUE`, {});\nconsole.log(\"GASTOS (primeras filas):\", JSON.stringify(gastosVals.values));\n\nif (nombrePosible) {\n const range = `'${nombrePosible}'!A1:H40`;\n const dataFormulas = await gsheet_call(\n sa(),\n SHEET_ID,\n \"GET\",\n `values/${encodeURIComponent(range)}?majorDimension=ROWS&valueRenderOption=FORMULA`,\n {},\n );\n console.log(\"FORMULAS:\", JSON.stringify(dataFormulas.values));\n\n const dataValores = await gsheet_call(\n sa(),\n SHEET_ID,\n \"GET\",\n `values/${encodeURIComponent(range)}?majorDimension=ROWS&valueRenderOption=UNFORMATTED_VALUE`,\n {},\n );\n console.log(\"VALORES:\", JSON.stringify(dataValores.values));\n}\n","import { gsheet_call } from \"https://esm.town/v/mattx/gsheet_call\";\nimport { SHEET_ID } from \"../backend/sheets.ts\";\n\nfunction sa() {\n const v = Deno.env.get(\"GOOGLE_SA\");\n if (!v) throw new Error(\"Falta GOOGLE_SA\");\n return v;\n}\n\n// 1) Listar todas las pestañas\nconst meta = await (await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${SHEET_ID}?fields=sheets.properties.title`,\n { headers: { Authorization: `Bearer ${(await (async () => {\n const { getToken } = await import(\"https://deno.land/x/google_jwt_sa@v0.2.3/mod.ts\");\n const t = await getToken(sa(), { scope: [\"https://www.googleapis.com/auth/spreadsheets\"] });\n return t.access_token;\n })())}` } },\n)).json();\nconsole.log(\"PESTAÑAS:\", JSON.stringify(meta.sheets?.map((s: any) => s.properties?.title)));\n\n// 2) La pestaña \"Resumen\" es el panel de control\nconst nombrePosible = \"Resumen\";\nconsole.log(\"NOMBRE ENCONTRADO:\", nombrePosible);\n\n// 3) Revisar cuántas filas reales hay ahora en Pedidos y Gastos (para saber el rango correcto)\nconst pedidosVals = await gsheet_call(sa(), SHEET_ID, \"GET\", `values/${encodeURIComponent(\"'Pedidos'!A1:N20\")}?majorDimension=ROWS&valueRenderOption=UNFORMATTED_VALUE`, {});\nconsole.log(\"PEDIDOS (primeras filas):\", JSON.stringify(pedidosVals.values));\n\nconst gastosVals = await gsheet_call(sa(), SHEET_ID, \"GET\", `values/${encodeURIComponent(\"'Gastos'!A1:E20\")}?majorDimension=ROWS&valueRenderOption=UNFORMATTED_VALUE`, {});\nconsole.log(\"GASTOS (primeras filas):\", JSON.stringify(gastosVals.values));\n\nif (nombrePosible) {\n const range = `'${nombrePosible}'!A1:H40`;\n const dataFormulas = await gsheet_call(\n sa(),\n SHEET_ID,\n \"GET\",\n `values/${encodeURIComponent(range)}?majorDimension=ROWS&valueRenderOption=FORMULA`,\n {},\n );\n console.log(\"FORMULAS:\", JSON.stringify(dataFormulas.values));\n\n const dataValores = await gsheet_call(\n sa(),\n SHEET_ID,\n \"GET\",\n `values/${encodeURIComponent(range)}?majorDimension=ROWS&valueRenderOption=UNFORMATTED_VALUE`,\n {},\n );\n console.log(\"VALORES:\", JSON.stringify(dataValores.values));\n\n // 4) Arreglar las fórmulas: estaban fijas a las filas 130–207 de Pedidos (de cuando había\n // datos de prueba ahí) y a un rango fijo en Insumos que se quedaba corto. Las cambiamos a\n // columna completa para que sigan funcionando sin importar cuántas filas se agreguen.\n const accessToken = await (async () => {\n const { getToken } = await import(\"https://deno.land/x/google_jwt_sa@v0.2.3/mod.ts\");\n const t = await getToken(sa(), { scope: [\"https://www.googleapis.com/auth/spreadsheets\"] });\n return t.access_token;\n })();\n\n const updates = [\n { range: \"'Resumen'!B6\", values: [[\"=SUMIFS(Pedidos!$I:$I,Pedidos!$A:$A,TODAY())\"]] },\n { range: \"'Resumen'!E6\", values: [[\"=COUNTIFS(Pedidos!$A:$A,TODAY())\"]] },\n {\n range: \"'Resumen'!H6\",\n values: [[\n '=SUMIFS(Pedidos!$I:$I,Pedidos!$A:$A,\">=\"&DATE(YEAR(TODAY()),MONTH(TODAY()),1),Pedidos!$A:$A,\"<=\"&TODAY())',\n ]],\n },\n {\n range: \"'Resumen'!B10\",\n values: [[\n '=SUMIFS(Gastos!$D:$D,Gastos!$A:$A,\">=\"&DATE(YEAR(TODAY()),MONTH(TODAY()),1),Gastos!$A:$A,\"<=\"&TODAY())',\n ]],\n },\n { range: \"'Resumen'!E10\", values: [['=COUNTIF(Insumos!$I:$I,\"BAJO\")']] },\n { range: \"'Resumen'!H10\", values: [['=COUNTIF(Insumos!$I:$I,\"Falta dato\")']] },\n ];\n\n const resp = await fetch(\n `https://sheets.googleapis.com/v4/spreadsheets/${SHEET_ID}/values:batchUpdate`,\n {\n method: \"POST\",\n headers: { Authorization: `Bearer ${accessToken}`, \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ valueInputOption: \"USER_ENTERED\", data: updates }),\n },\n );\n console.log(\"RESULTADO UPDATE:\", resp.status, await resp.text());\n\n // 5) Releer los valores para confirmar que ya calculan bien\n const nuevosValores = await gsheet_call(\n sa(),\n SHEET_ID,\n \"GET\",\n `values/${encodeURIComponent(\"'Resumen'!A1:H12\")}?majorDimension=ROWS&valueRenderOption=UNFORMATTED_VALUE`,\n {},\n );\n console.log(\"VALORES DESPUÉS DEL FIX:\", JSON.stringify(nuevosValores.values));\n}\n","createdAt",["D",1788659499879],"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","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",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":57,"_106":107,"_108":27},"branch",{"_13":90,"_33":91,"_45":44,"_92":46,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":47,"_99":100},"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",{"_45":46,"_33":47,"_40":610,"_49":-5,"_50":27,"_51":52,"_53":52,"_54":55,"_56":-5,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":611,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":612,"_85":613,"_87":614,"_89":27},"tree",[440,446,457,459,460,461,462],"files",[440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462],"counts",{"_430":64,"_431":402,"_432":64,"_433":434,"_435":436},"contents",[373,374,375,376,377,378,379],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[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,250,251],"hasHttpFiles","grants","orgs","customDomains",{},{"_45":372,"_253":-5},{"_45":371,"_253":-5},{"_45":370,"_253":-5},{"_45":369,"_253":-5},{"_45":368,"_253":-5},{"_45":367,"_253":-5},{"_45":366,"_253":-5},{"_45":365,"_253":-5},{"_45":364,"_253":-5},{"_45":363,"_253":-5},{"_45":362,"_253":-5},{"_45":361,"_253":-5},{"_45":360,"_253":-5},{"_45":359,"_253":-5},{"_45":358,"_253":-5},{"_45":357,"_253":-5},{"_45":356,"_253":-5},{"_45":355,"_253":-5},{"_45":354,"_253":-5},{"_45":353,"_253":-5},{"_45":352,"_253":-5},{"_45":351,"_253":-5},{"_45":350,"_253":-5},{"_45":349,"_253":-5},{"_45":348,"_253":-5},{"_45":347,"_253":-5},{"_45":346,"_253":-5},{"_45":345,"_253":-5},{"_45":344,"_253":-5},{"_45":343,"_253":-5},{"_45":342,"_253":-5},{"_45":341,"_253":-5},{"_45":340,"_253":-5},{"_45":339,"_253":-5},{"_45":338,"_253":-5},{"_45":337,"_253":-5},{"_45":336,"_253":-5},{"_45":335,"_253":-5},{"_45":334,"_253":-5},{"_45":333,"_253":-5},{"_45":332,"_253":-5},{"_45":331,"_253":-5},{"_45":330,"_253":-5},{"_45":329,"_253":-5},{"_45":328,"_253":-5},{"_45":327,"_253":-5},{"_45":326,"_253":-5},{"_45":325,"_253":-5},{"_45":324,"_253":-5},{"_45":323,"_253":-5},{"_45":322,"_253":-5},{"_45":321,"_253":-5},{"_45":320,"_253":-5},{"_45":319,"_253":-5},{"_45":318,"_253":-5},{"_45":317,"_253":-5},{"_45":316,"_253":-5},{"_45":315,"_253":-5},{"_45":314,"_253":-5},{"_45":313,"_253":-5},{"_45":312,"_253":-5},{"_45":311,"_253":-5},{"_45":310,"_253":-5},{"_45":309,"_253":-5},{"_45":308,"_253":-5},{"_45":307,"_253":-5},{"_45":306,"_253":-5},{"_45":305,"_253":-5},{"_45":304,"_253":-5},{"_45":303,"_253":-5},{"_45":302,"_253":-5},{"_45":301,"_253":-5},{"_45":300,"_253":-5},{"_45":299,"_253":-5},{"_45":298,"_253":-5},{"_45":297,"_253":-5},{"_45":296,"_253":-5},{"_45":295,"_253":-5},{"_45":294,"_253":-5},{"_45":293,"_253":-5},{"_45":292,"_253":-5},{"_45":291,"_253":-5},{"_45":290,"_253":-5},{"_45":289,"_253":-5},{"_45":288,"_253":-5},{"_45":287,"_253":-5},{"_45":286,"_253":-5},{"_45":285,"_253":-5},{"_45":284,"_253":-5},{"_45":283,"_253":-5},{"_45":282,"_253":-5},{"_45":281,"_253":-5},{"_45":280,"_253":-5},{"_45":279,"_253":-5},{"_45":278,"_253":-5},{"_45":277,"_253":-5},{"_45":276,"_253":-5},{"_45":275,"_253":-5},{"_45":274,"_253":-5},{"_45":273,"_253":-5},{"_45":272,"_253":-5},{"_45":271,"_253":-5},{"_45":270,"_253":-5},{"_45":269,"_253":-5},{"_45":268,"_253":-5},{"_45":267,"_253":-5},{"_45":266,"_253":-5},{"_45":265,"_253":-5},{"_45":264,"_253":-5},{"_45":263,"_253":-5},{"_45":262,"_253":-5},{"_45":261,"_253":-5},{"_45":260,"_253":-5},{"_45":259,"_253":-5},{"_45":258,"_253":-5},{"_45":257,"_253":-5},{"_45":256,"_253":-5},{"_45":255,"_253":-5},{"_45":254,"_253":-5},{"_45":252,"_253":-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",{"_45":424,"_33":425,"_31":426,"_382":-5,"_43":44,"_42":427,"_384":25,"_40":428,"_13":64,"_35":417,"_37":-5,"_24":27,"_389":-5,"_28":429},{"_45":419,"_33":420,"_31":421,"_382":-5,"_43":44,"_42":402,"_384":25,"_40":422,"_13":64,"_35":417,"_37":-5,"_24":27,"_389":-5,"_28":423},{"_45":412,"_33":413,"_31":414,"_382":-5,"_43":44,"_42":415,"_384":25,"_40":416,"_13":64,"_35":417,"_37":-5,"_24":27,"_389":-5,"_28":418},{"_45":406,"_33":407,"_31":408,"_382":-5,"_43":44,"_42":402,"_384":25,"_40":409,"_13":64,"_35":20,"_37":410,"_24":27,"_389":-5,"_28":411},{"_45":399,"_33":400,"_31":401,"_382":-5,"_43":44,"_42":402,"_384":25,"_40":403,"_13":64,"_35":20,"_37":404,"_24":27,"_389":-5,"_28":405},{"_45":391,"_33":392,"_31":393,"_382":-5,"_43":44,"_42":394,"_384":25,"_40":395,"_13":64,"_35":396,"_37":397,"_24":27,"_389":-5,"_28":398},{"_45":380,"_33":381,"_31":59,"_382":-5,"_43":44,"_42":383,"_384":27,"_40":385,"_13":386,"_35":387,"_37":388,"_24":27,"_389":-5,"_28":390},"b78e5077-bbf9-4b3e-bd5e-b541e1ea6410","index.ts","parentId",369,"latest",["D",1788643007419],51,"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 listarHistorialPedidos,\n buscarPedidoCobradoEnSheet,\n calcularCorte,\n listarInsumosParaSeleccion,\n registrarCompraInsumo,\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} from \"./backend/pedidosActivos.ts\";\nimport { fechaHoyMX, formatearCorte, formatearTicket } from \"./backend/ticket.ts\";\nimport { obtenerFondoCaja, guardarFondoCaja } from \"./backend/caja.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\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\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 // 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/* ---------------- 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",[381],"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",[392],"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",[400],"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 · v387