[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_608":609,"_610":611},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":49,"_124":125,"_126":25,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":49},"version",404,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",true,"deletedHere","path","scripts/regresar_uramaki_base.ts","latestPath","fileId","b0413fd2-ab2b-11f1-a4e1-1607ee4eb77e","name","regresar_uramaki_base.ts","fileType","script","content","import { readSheetAsObjects, batchUpdateValues } from \"../backend/sheets.ts\";\n\n// Noel pidió que SOLO en la categoría base \"Uramaki\" (no en \"Uramaki Mango\" ni \"Uramaki\n// Empanizado\") el nombre del producto vuelva a decir \"Uramaki\" al inicio — para que en las\n// comandas/notas no se confunda \"Camaron\" a secas (que no dice qué es) con el resto. En Mango\n// y Empanizado se queda igual que ya está (sin la palabra \"Uramaki\").\nconst menuRows = await readSheetAsObjects(\"Menu\");\nconst headerMenu = menuRows.length > 0 ? Object.keys(menuRows[0]).filter((k) => k !== \"_row\") : [];\nconst colLetter = (idx: number) => {\n let s = \"\";\n idx += 1;\n while (idx > 0) {\n const m = (idx - 1) % 26;\n s = String.fromCharCode(65 + m) + s;\n idx = Math.floor((idx - 1) / 26);\n }\n return s;\n};\nconst idxProducto = headerMenu.indexOf(\"Producto (nombre completo)\");\nconst idxCategoria = headerMenu.indexOf(\"Categoría\");\nif (idxProducto < 0 || idxCategoria < 0) throw new Error(\"Faltan columnas esperadas en Menu\");\n\nconst mapaNombres: Record = {}; // viejo (sin Uramaki) -> nuevo (con Uramaki)\nconst updatesMenu: { range: string; values: any[][] }[] = [];\n\nfor (const r of menuRows) {\n const categoria = String(r[\"Categoría\"] || \"\").trim();\n if (categoria !== \"Uramaki\") continue; // solo la categoría base, no \"Uramaki Mango\"/\"Uramaki Empanizado\"\n const nombreViejo = String(r[\"Producto (nombre completo)\"] || \"\");\n if (!nombreViejo || /^Uramaki\\s+/i.test(nombreViejo)) continue; // ya tiene el prefijo o está vacío\n const nombreNuevo = `Uramaki ${nombreViejo}`;\n mapaNombres[nombreViejo] = nombreNuevo;\n updatesMenu.push({ range: `Menu!${colLetter(idxProducto)}${r._row}`, values: [[nombreNuevo]] });\n}\n\nconsole.log(\"MAPEO (Menu, solo categoría Uramaki base):\", JSON.stringify(mapaNombres, null, 2));\nconsole.log(\"Total productos a renombrar en Menu:\", updatesMenu.length);\n\n// Recetas: renombrar cualquier \"Producto\" que coincida exactamente con un nombre viejo (bare)\n// para que las recetas sigan encontrando el producto correcto.\nconst recetasRows = await readSheetAsObjects(\"Recetas\");\nconst headerRecetas = recetasRows.length > 0 ? Object.keys(recetasRows[0]).filter((k) => k !== \"_row\") : [];\nconst idxProductoRecetas = headerRecetas.indexOf(\"Producto\");\nif (idxProductoRecetas < 0) throw new Error(\"No se encontró la columna Producto en Recetas\");\n\nconst updatesRecetas: { range: string; values: any[][] }[] = [];\nfor (const r of recetasRows) {\n const nombreViejo = String(r[\"Producto\"] || \"\");\n if (mapaNombres[nombreViejo]) {\n updatesRecetas.push({\n range: `Recetas!${colLetter(idxProductoRecetas)}${r._row}`,\n values: [[mapaNombres[nombreViejo]]],\n });\n }\n}\nconsole.log(\"Total filas de Recetas a actualizar:\", updatesRecetas.length);\n\nawait batchUpdateValues([...updatesMenu, ...updatesRecetas]);\nconsole.log(\"LISTO — Menu y Recetas actualizados.\");\n","createdAt",["D",1788833964186],"branchVersion","branchId","8c0e03b9-4364-49a7-9f88-4b3a597ffffc","id","8f3a6802-82b2-4247-8cf7-f627cfe596c3","suchi-house-pedidos",["D",1788198568874],"deletedAt","legacyEnvVars",false,"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",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":56,"_105":106,"_107":49},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"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",{"_43":44,"_32":45,"_38":603,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":604,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":605,"_84":606,"_86":607,"_88":49},"tree",[439,445,456,457,458,459,460],"files",[439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460],"counts",{"_429":63,"_430":401,"_431":63,"_432":433,"_434":435},"contents",[372,373,374,375,376,377,378],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[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,250],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":371,"_252":-5},{"_43":370,"_252":-5},{"_43":369,"_252":-5},{"_43":368,"_252":-5},{"_43":367,"_252":-5},{"_43":366,"_252":-5},{"_43":365,"_252":-5},{"_43":364,"_252":-5},{"_43":363,"_252":-5},{"_43":362,"_252":-5},{"_43":361,"_252":-5},{"_43":360,"_252":-5},{"_43":359,"_252":-5},{"_43":358,"_252":-5},{"_43":357,"_252":-5},{"_43":356,"_252":-5},{"_43":355,"_252":-5},{"_43":354,"_252":-5},{"_43":353,"_252":-5},{"_43":352,"_252":-5},{"_43":351,"_252":-5},{"_43":350,"_252":-5},{"_43":349,"_252":-5},{"_43":348,"_252":-5},{"_43":347,"_252":-5},{"_43":346,"_252":-5},{"_43":345,"_252":-5},{"_43":344,"_252":-5},{"_43":343,"_252":-5},{"_43":342,"_252":-5},{"_43":341,"_252":-5},{"_43":340,"_252":-5},{"_43":339,"_252":-5},{"_43":338,"_252":-5},{"_43":337,"_252":-5},{"_43":336,"_252":-5},{"_43":335,"_252":-5},{"_43":334,"_252":-5},{"_43":333,"_252":-5},{"_43":332,"_252":-5},{"_43":331,"_252":-5},{"_43":330,"_252":-5},{"_43":329,"_252":-5},{"_43":328,"_252":-5},{"_43":327,"_252":-5},{"_43":326,"_252":-5},{"_43":325,"_252":-5},{"_43":324,"_252":-5},{"_43":323,"_252":-5},{"_43":322,"_252":-5},{"_43":321,"_252":-5},{"_43":320,"_252":-5},{"_43":319,"_252":-5},{"_43":318,"_252":-5},{"_43":317,"_252":-5},{"_43":316,"_252":-5},{"_43":315,"_252":-5},{"_43":314,"_252":-5},{"_43":313,"_252":-5},{"_43":312,"_252":-5},{"_43":311,"_252":-5},{"_43":310,"_252":-5},{"_43":309,"_252":-5},{"_43":308,"_252":-5},{"_43":307,"_252":-5},{"_43":306,"_252":-5},{"_43":305,"_252":-5},{"_43":304,"_252":-5},{"_43":303,"_252":-5},{"_43":302,"_252":-5},{"_43":301,"_252":-5},{"_43":300,"_252":-5},{"_43":299,"_252":-5},{"_43":298,"_252":-5},{"_43":297,"_252":-5},{"_43":296,"_252":-5},{"_43":295,"_252":-5},{"_43":294,"_252":-5},{"_43":293,"_252":-5},{"_43":292,"_252":-5},{"_43":291,"_252":-5},{"_43":290,"_252":-5},{"_43":289,"_252":-5},{"_43":288,"_252":-5},{"_43":287,"_252":-5},{"_43":286,"_252":-5},{"_43":285,"_252":-5},{"_43":284,"_252":-5},{"_43":283,"_252":-5},{"_43":282,"_252":-5},{"_43":281,"_252":-5},{"_43":280,"_252":-5},{"_43":279,"_252":-5},{"_43":278,"_252":-5},{"_43":277,"_252":-5},{"_43":276,"_252":-5},{"_43":275,"_252":-5},{"_43":274,"_252":-5},{"_43":273,"_252":-5},{"_43":272,"_252":-5},{"_43":271,"_252":-5},{"_43":270,"_252":-5},{"_43":269,"_252":-5},{"_43":268,"_252":-5},{"_43":267,"_252":-5},{"_43":266,"_252":-5},{"_43":265,"_252":-5},{"_43":264,"_252":-5},{"_43":263,"_252":-5},{"_43":262,"_252":-5},{"_43":261,"_252":-5},{"_43":260,"_252":-5},{"_43":259,"_252":-5},{"_43":258,"_252":-5},{"_43":257,"_252":-5},{"_43":256,"_252":-5},{"_43":255,"_252":-5},{"_43":254,"_252":-5},{"_43":253,"_252":-5},{"_43":251,"_252":-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",{"_43":423,"_32":424,"_30":425,"_381":-5,"_41":42,"_40":426,"_383":25,"_38":427,"_13":63,"_34":416,"_36":-5,"_24":49,"_388":-5,"_27":428},{"_43":418,"_32":419,"_30":420,"_381":-5,"_41":42,"_40":401,"_383":25,"_38":421,"_13":63,"_34":416,"_36":-5,"_24":49,"_388":-5,"_27":422},{"_43":411,"_32":412,"_30":413,"_381":-5,"_41":42,"_40":414,"_383":25,"_38":415,"_13":63,"_34":416,"_36":-5,"_24":49,"_388":-5,"_27":417},{"_43":405,"_32":406,"_30":407,"_381":-5,"_41":42,"_40":401,"_383":25,"_38":408,"_13":63,"_34":20,"_36":409,"_24":49,"_388":-5,"_27":410},{"_43":398,"_32":399,"_30":400,"_381":-5,"_41":42,"_40":401,"_383":25,"_38":402,"_13":63,"_34":20,"_36":403,"_24":49,"_388":-5,"_27":404},{"_43":390,"_32":391,"_30":392,"_381":-5,"_41":42,"_40":393,"_383":25,"_38":394,"_13":63,"_34":395,"_36":396,"_24":49,"_388":-5,"_27":397},{"_43":379,"_32":380,"_30":58,"_381":-5,"_41":42,"_40":382,"_383":49,"_38":384,"_13":385,"_34":386,"_36":387,"_24":49,"_388":-5,"_27":389},"0d75223e-0ab4-4b54-a0d7-445193267cc1","index.ts","parentId",393,"latest",["D",1788659649470],53,"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 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} 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\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\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",[380],"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",[391],"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",[399],"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 · v404