[{"_1":2,"_277":-5,"_278":-5},"loaderData",{"_3":4,"_91":92,"_240":241},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","ff0419d68e57d8cc3e37e5d3da688157c5dd37c6","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":43,"_98":99,"_100":101,"_102":103,"_148":149,"_218":219,"_220":221,"_228":229,"_230":231,"_234":-5,"_235":-5,"_236":22,"_237":22,"_238":239},"handle","arequipe","name","tuempresa","branchName","path","ValidationCatalogGemini.tsx","version",46,"project",{"_104":105,"_95":96,"_106":107,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":129,"_132":133,"_135":136,"_147":22},"id","67904a0c-40ac-11f0-ad8f-76b3cceeab13","createdAt",["D",1748976966452],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","b45123f0-3406-11f0-994d-f304847156a7","pinnedFileId","pinPreview","screenshotVersion","likeCount","a7d312c4-47a4-45c8-b4c3-e46228d5db68","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_130":131},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4SEUwMzRLMGRyUDM0ZTVuazBHR1Jaa3g3VyJ9","org",{"_93":94,"_134":131},"avatar","branch",{"_100":137,"_95":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},189,"67909098-40ac-11f0-ad8f-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[150,170,179,188,198,208],{"_104":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":101,"_157":22,"_106":158,"_100":159,"_160":161,"_162":163,"_164":22,"_165":166,"_167":168,"_98":169},"11b6dab2-47fd-11f0-88b9-76b3cceeab13","fileId","46583898-47fc-11f0-87ba-76b3cceeab13","parentId","branchId","branchVersion","latest",["D",1749781269782],3,"fileType","http","content","import { blob } from \"https://esm.town/v/std/blob\";\nimport { fetch } from \"https://esm.town/v/std/fetch\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function validateCartaPorteData(req: Request): Promise {\n const AIRTABLE_API_KEY = Deno.env.get(\"AIRTABLE_API_KEY\")!;\n const AIRTABLE_BASE_ID = Deno.env.get(\"AIRTABLE_BASE_ID\")!;\n const VIAJES_TABLE = Deno.env.get(\"VIAJES_TABLE\")!;\n const CLIENTES_TABLE = Deno.env.get(\"CLIENTES_TABLE\")!;\n const UBICACIONES_TABLE = Deno.env.get(\"UBICACIONES_TABLE\")!;\n const UNIDADES_TABLE = Deno.env.get(\"UNIDADES_TABLE\")!;\n const BIENES_TABLE = Deno.env.get(\"BIENES_TABLE\")!;\n const OPERADORES_TABLE = Deno.env.get(\"OPERADORES_TABLE\")!;\n const REMOLQUES_TABLE = Deno.env.get(\"REMOLQUES_TABLE\")!;\n\n const airtableHeaders = {\n Authorization: `Bearer ${AIRTABLE_API_KEY}`,\n \"Content-Type\": \"application/json\",\n };\n\n const recordId = new URL(req.url).searchParams.get(\"recordId\");\n if (!recordId) {\n return new Response(JSON.stringify({ error: \"Missing recordId\" }), { status: 400 });\n }\n\n const fetchLinkedRecord = async (tableId: string, recordId: string) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${tableId}/${recordId}`, {\n headers: airtableHeaders,\n });\n if (!res.ok) {\n const errorText = await res.text();\n throw new Error(`Airtable fetch failed for ${tableId}/${recordId}: ${res.status} - ${errorText}`);\n }\n return (await res.json()).fields;\n };\n\n const fetchMultipleLinkedRecords = async (tableId: string, recordIds: string[]) => {\n if (!recordIds || recordIds.length === 0) return [];\n const records = await Promise.all(recordIds.map(id => fetchLinkedRecord(tableId, id)));\n return records;\n };\n\n const updateAirtableFields = async (targetTable: string, targetRecordId: string, fields: Record) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${targetTable}/${targetRecordId}`, {\n method: \"PATCH\",\n headers: airtableHeaders,\n body: JSON.stringify({ fields }),\n });\n if (!res.ok) {\n const errorText = await res.text();\n throw new Error(`Airtable update failed for ${targetTable}/${targetRecordId}: ${res.status} - ${errorText}`);\n }\n };\n\n let validationMessages: string[] = [];\n let allValid = true;\n\n try {\n console.log(`Iniciando validación de catálogos SAT para Viaje ID: ${recordId}`);\n\n // CORRECCIÓN: Usando blob.get() en lugar de blob.load()\n const db = await blob.get(\"sat-catalogs.db\");\n if (!db) {\n throw new Error(\"Base de datos de catálogos SAT (sat-catalogs.db) no encontrada en blob storage.\");\n }\n console.log(\"Base de datos de catálogos SAT cargada.\");\n\n const viajeData = await fetchLinkedRecord(VIAJES_TABLE, recordId);\n\n const emisorId = viajeData.Emisor?.[0];\n const clienteOrigenId = viajeData.ClienteOrigen?.[0];\n const clienteDestinoId = viajeData.ClienteDestino?.[0];\n const origenId = viajeData.Origen?.[0];\n const destinoId = viajeData.Destino?.[0];\n const unidadId = viajeData.Unidad?.[0];\n const operadorId = viajeData.Operador?.[0];\n const bienesIds = viajeData.Bienes || [];\n const remolqueId = viajeData.Remolque?.[0];\n\n const [emisor, clienteOrigen, clienteDestino, origen, destino, unidad, operador, remolque, bienes] = await Promise\n .all([\n emisorId ? fetchLinkedRecord(CLIENTES_TABLE, emisorId) : Promise.resolve(null),\n clienteOrigenId ? fetchLinkedRecord(CLIENTES_TABLE, clienteOrigenId) : Promise.resolve(null),\n clienteDestinoId ? fetchLinkedRecord(CLIENTES_TABLE, clienteDestinoId) : Promise.resolve(null),\n origenId ? fetchLinkedRecord(UBICACIONES_TABLE, origenId) : Promise.resolve(null),\n destinoId ? fetchLinkedRecord(UBICACIONES_TABLE, destinoId) : Promise.resolve(null),\n unidadId ? fetchLinkedRecord(UNIDADES_TABLE, unidadId) : Promise.resolve(null),\n operadorId ? fetchLinkedRecord(OPERADORES_TABLE, operadorId) : Promise.resolve(null),\n remolqueId ? fetchLinkedRecord(REMOLQUES_TABLE, remolqueId) : Promise.resolve(null),\n fetchMultipleLinkedRecords(BIENES_TABLE, bienesIds),\n ]);\n\n // --- Lógica de Validación (como en la respuesta anterior) ---\n\n // 1. Validar Ubicación de Origen (CP, Municipio, Estado, Colonia)\n if (origen) {\n const cp = origen[\"CP Link\"];\n const municipio = origen[\"Municipio Link\"];\n const estado = origen[\"Estado Link\"];\n const colonia = origen[\"Colonia Link\"];\n\n if (cp && municipio && estado) {\n const { rows } = await sqlite.execute({\n sql: `SELECT T2.c_Municipio, T3.c_Estado, T1.c_CodigoPostal, T4.c_Colonia\n FROM c_CodigoPostal AS T1\n JOIN c_Municipio AS T2 ON T1.c_Municipio = T2.c_Municipio AND T1.c_Estado = T2.c_Estado\n JOIN c_Estado AS T3 ON T1.c_Estado = T3.c_Estado\n LEFT JOIN c_Colonia AS T4 ON T1.c_CodigoPostal = T4.c_CodigoPostal\n WHERE T1.c_CodigoPostal = ?`,\n args: [cp],\n file: db,\n });\n\n let cpValid = false;\n let coloniaValid = !colonia; // Assume valid if no colonia provided in Airtable\n if (rows.length > 0) {\n for (const row of rows) {\n if (row.c_Municipio === municipio && row.c_Estado === estado) {\n cpValid = true;\n if (colonia && row.c_Colonia === colonia) {\n coloniaValid = true;\n } else if (!colonia) {\n coloniaValid = true;\n }\n }\n }\n }\n\n if (!cpValid) {\n validationMessages.push(\n `Origen: Código Postal '${cp}' no coincide con Municipio '${municipio}' o Estado '${estado}' en el catálogo SAT.`,\n );\n allValid = false;\n }\n if (colonia && !coloniaValid) {\n validationMessages.push(\n `Origen: Colonia '${colonia}' no válida para el Código Postal '${cp}' en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(\"Origen: Faltan Código Postal, Municipio o Estado para validación.\");\n allValid = false;\n }\n }\n\n // 2. Validar Ubicación de Destino (CP, Municipio, Estado, Colonia)\n if (destino) {\n const cp = destino[\"CP Link\"];\n const municipio = destino[\"Municipio Link\"];\n const estado = destino[\"Estado Link\"];\n const colonia = destino[\"Colonia Link\"];\n\n if (cp && municipio && estado) {\n const { rows } = await sqlite.execute({\n sql: `SELECT T2.c_Municipio, T3.c_Estado, T1.c_CodigoPostal, T4.c_Colonia\n FROM c_CodigoPostal AS T1\n JOIN c_Municipio AS T2 ON T1.c_Municipio = T2.c_Municipio AND T1.c_Estado = T2.c_Estado\n JOIN c_Estado AS T3 ON T1.c_Estado = T3.c_Estado\n LEFT JOIN c_Colonia AS T4 ON T1.c_CodigoPostal = T4.c_CodigoPostal\n WHERE T1.c_CodigoPostal = ?`,\n args: [cp],\n file: db,\n });\n\n let cpValid = false;\n let coloniaValid = !colonia;\n if (rows.length > 0) {\n for (const row of rows) {\n if (row.c_Municipio === municipio && row.c_Estado === estado) {\n cpValid = true;\n if (colonia && row.c_Colonia === colonia) {\n coloniaValid = true;\n } else if (!colonia) {\n coloniaValid = true;\n }\n }\n }\n }\n\n if (!cpValid) {\n validationMessages.push(\n `Destino: Código Postal '${cp}' no coincide con Municipio '${municipio}' o Estado '${estado}' en el catálogo SAT.`,\n );\n allValid = false;\n }\n if (colonia && !coloniaValid) {\n validationMessages.push(\n `Destino: Colonia '${colonia}' no válida para el Código Postal '${cp}' en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(\"Destino: Faltan Código Postal, Municipio o Estado para validación.\");\n allValid = false;\n }\n }\n\n // 3. Validar Emisor/Receptor (RegimenFiscal, UsoCFDI, CodigoPostal)\n if (emisor) {\n const fiscalRegime = emisor.FiscalRegime;\n const usoCfdi = emisor.UsoCFDI;\n const taxZipCode = emisor.TaxZipCode;\n\n if (fiscalRegime) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_RegimenFiscal FROM c_RegimenFiscal WHERE c_RegimenFiscal = ?`,\n args: [fiscalRegime],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Emisor: Régimen Fiscal '${fiscalRegime}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(\"Emisor: Falta Régimen Fiscal para validación.\");\n allValid = false;\n }\n\n if (usoCfdi) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_UsoCFDI FROM c_UsoCFDI WHERE c_UsoCFDI = ?`,\n args: [usoCfdi],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Emisor: Uso CFDI '${usoCfdi}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(\"Emisor: Falta Uso CFDI para validación.\");\n allValid = false;\n }\n\n if (taxZipCode) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_CodigoPostal FROM c_CodigoPostal WHERE c_CodigoPostal = ?`,\n args: [taxZipCode],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Emisor: Código Postal Fiscal '${taxZipCode}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(\"Emisor: Falta Código Postal Fiscal para validación.\");\n allValid = false;\n }\n }\n\n // 4. Validar Bienes (ClaveProdServ, ClaveUnidad, MaterialPeligroso)\n for (const bien of bienes) {\n const prodServKey = bien.SAT_ClaveProdServP;\n const unidadKey = bien.SAT_ClaveUnidadPeso;\n const materialPeligroso = bien.MaterialPeligroso;\n\n if (prodServKey) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_ClaveProdServ FROM c_ClaveProdServ WHERE c_ClaveProdServ = ?`,\n args: [prodServKey],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(\n `Bien (ID: ${\n bien.ID || \"N/A\"\n }): Clave Producto/Servicio '${prodServKey}' no encontrada en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(`Bien (ID: ${bien.ID || \"N/A\"}): Falta Clave Producto/Servicio.`);\n allValid = false;\n }\n\n if (unidadKey) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_ClaveUnidad FROM c_ClaveUnidad WHERE c_ClaveUnidad = ?`,\n args: [unidadKey],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(\n `Bien (ID: ${bien.ID || \"N/A\"}): Clave Unidad '${unidadKey}' no encontrada en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(`Bien (ID: ${bien.ID || \"N/A\"}): Falta Clave Unidad.`);\n allValid = false;\n }\n\n if (materialPeligroso && ![\"Sí\", \"No\", \"\"].includes(materialPeligroso)) {\n validationMessages.push(\n `Bien (ID: ${\n bien.ID || \"N/A\"\n }): Material Peligroso '${materialPeligroso}' no es un valor válido (esperado 'Sí' o 'No').`,\n );\n allValid = false;\n }\n }\n\n // 5. Validar Autotransporte (PermSCT, ConfigVehicular, SubTipoRem)\n if (unidad) {\n const permSct = unidad.PermisoSCT;\n const configVehicular = unidad.ConfigVehicular;\n const subTipoRem1 = unidad.SubTipoRem1;\n const subTipoRem2 = unidad.SubTipoRem2;\n\n if (permSct) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_TipoPermiso FROM c_TipoPermiso WHERE c_TipoPermiso = ?`,\n args: [permSct],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Unidad: Permiso SCT '${permSct}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(\"Unidad: Falta Permiso SCT para validación.\");\n allValid = false;\n }\n\n if (configVehicular) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_ConfigAutotransporte FROM c_ConfigAutotransporte WHERE c_ConfigAutotransporte = ?`,\n args: [configVehicular],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(\n `Unidad: Configuración Vehicular '${configVehicular}' no encontrada en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(\"Unidad: Falta Configuración Vehicular para validación.\");\n allValid = false;\n }\n\n if (subTipoRem1) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_SubTipoRem FROM c_SubTipoRem WHERE c_SubTipoRem = ?`,\n args: [subTipoRem1],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Unidad: SubTipoRem1 '${subTipoRem1}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n }\n\n if (subTipoRem2) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_SubTipoRem FROM c_SubTipoRem WHERE c_SubTipoRem = ?`,\n args: [subTipoRem2],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Unidad: SubTipoRem2 '${subTipoRem2}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n }\n }\n\n // 6. Validar Operador (TipoFigura)\n if (operador) {\n const tipoFigura = operador.TipoFigura;\n\n if (tipoFigura) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_FiguraTransporte FROM c_FiguraTransporte WHERE c_FiguraTransporte = ?`,\n args: [tipoFigura],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Operador: Tipo Figura '${tipoFigura}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(\"Operador: Falta Tipo Figura para validación.\");\n allValid = false;\n }\n }\n\n // 7. Validar Remolque (SubTipoRem)\n if (remolque) {\n const subTipoRem = remolque.SubTipoRem;\n if (subTipoRem) {\n const { rows } = await sqlite.execute({\n sql: `SELECT c_SubTipoRem FROM c_SubTipoRem WHERE c_SubTipoRem = ?`,\n args: [subTipoRem],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`Remolque: SubTipoRem '${subTipoRem}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(\"Remolque: Falta SubTipoRem para validación.\");\n allValid = false;\n }\n }\n\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n \"SAT_Validation_Status\": allValid ? \"Válido\" : \"Inválido\",\n \"SAT_Validation_Messages\": validationMessages.join(\"\\n\") || \"No se encontraron problemas de validación.\",\n });\n\n console.log(\n `Validación finalizada. Estado: ${allValid ? \"Válido\" : \"Inválido\"}. Mensajes: ${validationMessages.join(\", \")}`,\n );\n\n return new Response(JSON.stringify({ success: true, allValid: allValid, messages: validationMessages }), {\n status: 200,\n });\n } catch (error: any) {\n console.error(`❌ Error global durante la validación: ${error.message}`);\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n \"SAT_Validation_Status\": \"Error\",\n \"SAT_Validation_Messages\": `Error crítico: ${error.message}`,\n });\n return new Response(JSON.stringify({ error: error.message || \"Error inesperado durante la validación\" }), {\n status: 500,\n });\n }\n}","deleted","label","arequipegemini","children",[],[99],{"_104":171,"_95":172,"_152":173,"_154":-5,"_155":138,"_156":174,"_157":22,"_106":175,"_100":176,"_160":161,"_162":163,"_164":22,"_165":-5,"_167":177,"_98":178},"436019bc-47fc-11f0-add2-76b3cceeab13","ValidationCatalogGrok.tsx","2d451bc4-467a-11f0-83b8-76b3cceeab13",42,["D",1749780923606],11,[],[172],{"_104":180,"_95":181,"_152":182,"_154":-5,"_155":138,"_156":183,"_157":22,"_106":184,"_100":159,"_160":161,"_162":185,"_164":22,"_165":-5,"_167":186,"_98":187},"ac775c50-40ac-11f0-b42d-76b3cceeab13","main.tsx","67929d8e-40ac-11f0-ad8f-76b3cceeab13",4,["D",1748977082042],"export default async function handler(req: Request): Promise {\n const AIRTABLE_API_KEY = Deno.env.get(\"AIRTABLE_API_KEY\")!;\n const AIRTABLE_BASE_ID = Deno.env.get(\"AIRTABLE_BASE_ID\")!;\n const FACTURAMA_AUTH = Deno.env.get(\"FACTURAMA_AUTH\")!;\n const CLOUDINARY_UPLOAD_PRESET = Deno.env.get(\"CLOUDINARY_UPLOAD_PRESET\")!;\n const CLOUDINARY_CLOUD_NAME = Deno.env.get(\"CLOUDINARY_CLOUD_NAME\")!;\n const VIAJES_TABLE = \"Viajes\";\n\n const recordId = new URL(req.url).searchParams.get(\"recordId\");\n if (!recordId) return new Response(JSON.stringify({ error: \"Missing recordId\" }), { status: 400 });\n\n const airtableHeaders = {\n Authorization: `Bearer ${AIRTABLE_API_KEY}`,\n \"Content-Type\": \"application/json\",\n };\n\n const fetchRecord = async () => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${VIAJES_TABLE}/${recordId}`, {\n headers: airtableHeaders,\n });\n if (!res.ok) throw new Error(`Airtable fetch failed: ${res.status}`);\n return (await res.json()).fields;\n };\n\n const uploadToCloudinary = async (base64: string, filename: string, mime: string): Promise => {\n const form = new FormData();\n form.append(\"file\", `data:${mime};base64,${base64}`);\n form.append(\"upload_preset\", CLOUDINARY_UPLOAD_PRESET);\n\n const res = await fetch(`https://api.cloudinary.com/v1_1/${CLOUDINARY_CLOUD_NAME}/upload`, {\n method: \"POST\",\n body: form,\n });\n\n if (!res.ok) {\n const err = await res.text();\n throw new Error(`Cloudinary upload failed: ${res.status} - ${err}`);\n }\n\n return (await res.json()).secure_url;\n };\n\n const updateAirtableFields = async (fields: Record) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${VIAJES_TABLE}/${recordId}`, {\n method: \"PATCH\",\n headers: airtableHeaders,\n body: JSON.stringify({ fields }),\n });\n if (!res.ok) throw new Error(`Airtable update failed: ${res.status}`);\n };\n\n const fetchFromFacturama = async (id: string, type: \"xml\" | \"pdf\") => {\n const url = `https://apisandbox.facturama.mx/api/Cfdi/${type}/issued/${id}`;\n const res = await fetch(url, {\n headers: {\n Authorization: FACTURAMA_AUTH,\n \"User-Agent\": \"Arequipe\",\n },\n });\n\n const body = await res.text();\n if (!res.ok) throw new Error(`Facturama ${type.toUpperCase()} fetch failed: ${res.status} - ${body}`);\n return JSON.parse(body)?.Content;\n };\n\n const formatDate = (date: Date) => {\n const pad = (n: number) => n.toString().padStart(2, \"0\");\n return `${date.getFullYear()}-${pad(date.getMonth() + 1)}-${pad(date.getDate())}T${pad(date.getHours())}:${\n pad(date.getMinutes())\n }:${pad(date.getSeconds())}`;\n };\n\n try {\n const data = await fetchRecord();\n const facturaDate = data?.Fecha ? formatDate(new Date(data.Fecha)) : formatDate(new Date());\n const folio = data.Folio || \"V-00001-GENERADO\";\n\n const cfdi = {\n CfdiType: \"I\",\n NameId: \"36\",\n PaymentForm: \"01\",\n PaymentMethod: \"PUE\",\n ExpeditionPlace: \"76140\",\n Date: facturaDate,\n Folio: folio,\n Issuer: {\n Rfc: \"EKU9003173C9\",\n Name: \"ESCUELA KEMPER URGATE\",\n FiscalRegime: \"601\",\n },\n Receiver: {\n Rfc: \"EKU9003173C9\",\n Name: \"ESCUELA KEMPER URGATE\",\n CfdiUse: \"G03\",\n FiscalRegime: \"601\",\n TaxZipCode: \"42501\",\n },\n Items: [{\n ProductCode: \"78121603\",\n Description: \"TRANSPORTE DE Diesel\",\n UnitCode: \"E48\",\n Quantity: 1,\n UnitPrice: 30000,\n Subtotal: 30000,\n TaxObject: \"02\",\n Taxes: [{ Total: 4800, Name: \"IVA\", Base: 30000, Rate: 0.16, IsRetention: false }],\n Total: 34800,\n }],\n Complemento: {\n CartaPorte31: {\n Version: \"3.1\",\n TranspInternac: \"No\",\n TotalDistRec: 345,\n LogisticaInversaRecoleccionDevolucion: \"Sí\",\n Ubicaciones: [\n {\n TipoUbicacion: \"Origen\",\n IDUbicacion: \"OR000001\",\n FechaHoraSalidaLlegada: facturaDate,\n RFCRemitenteDestinatario: \"EKU9003173C9\",\n NombreRemitenteDestinatario: \"ESCUELA KEMPER URGATE\",\n Domicilio: {\n Calle: \"Calle1\",\n NumeroExterior: \"211\",\n NumeroInterior: \"212\",\n Colonia: \"0347\",\n Localidad: \"23\",\n Referencia: \"casa blanca\",\n Municipio: \"004\",\n Estado: \"COA\",\n Pais: \"MEX\",\n CodigoPostal: \"25350\",\n },\n },\n {\n TipoUbicacion: \"Destino\",\n IDUbicacion: \"DE000001\",\n FechaHoraSalidaLlegada: facturaDate,\n DistanciaRecorrida: 345,\n RFCRemitenteDestinatario: \"EKU9003173C9\",\n NombreRemitenteDestinatario: \"ESCUELA KEMPER URGATE\",\n Domicilio: {\n Calle: \"Calle2\",\n NumeroExterior: \"214\",\n NumeroInterior: \"215\",\n Colonia: \"0347\",\n Localidad: \"23\",\n Referencia: \"casa negra\",\n Municipio: \"004\",\n Estado: \"COA\",\n Pais: \"MEX\",\n CodigoPostal: \"25350\",\n },\n },\n ],\n Mercancias: {\n UnidadPeso: \"KGM\",\n PesoBrutoTotal: 150,\n NumTotalMercancias: 1,\n Mercancia: [{\n BienesTransp: \"15101505\",\n FraccionArancelaria: \"\",\n Descripcion: \"Diesel\",\n Cantidad: 200,\n ClaveUnidad: \"LTR\",\n Unidad: \"Litros\",\n PesoEnKg: 150,\n ValorMercancia: 2000,\n Moneda: \"MXN\",\n MaterialPeligroso: \"No\",\n ClaveSTCC: \"4912163\",\n PesoNeto: 150,\n PesoBruto: 150,\n PesoTara: 0,\n UnidadPeso: \"KGM\",\n }],\n Autotransporte: {\n PermSCT: \"TPAF03\",\n NumPermisoSCT: \"TPXX123456789\",\n IdentificacionVehicular: {\n ConfigVehicular: \"T3S2\",\n PlacaVM: \"02AW3Z\",\n AnioModeloVM: 2024,\n PesoBrutoVehicular: 40,\n },\n Seguros: {\n AseguraRespCivil: \"Seguros Ejemplo\",\n PolizaRespCivil: \"123456789\",\n AseguraCarga: \"Seguros Ejemplo\",\n PolizaCarga: \"456789123\",\n },\n Remolques: [\n { SubTipoRem: \"CTR004\", Placa: \"XYZ123\" },\n { SubTipoRem: \"CTR004\", Placa: \"ABC456\" },\n ],\n },\n },\n FiguraTransporte: [\n {\n TipoFigura: \"01\",\n RFCFigura: \"EKU9003173C9\",\n NumLicencia: \"84848488\",\n NombreFigura: \"FRANCISCO JAVIER HERNANDEZ FLORES\",\n },\n ],\n },\n },\n };\n\n const facturamaRes = await fetch(\"https://apisandbox.facturama.mx/3/cfdis\", {\n method: \"POST\",\n headers: {\n Authorization: FACTURAMA_AUTH,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(cfdi),\n });\n\n if (!facturamaRes.ok) {\n const errorText = await facturamaRes.text();\n return new Response(JSON.stringify({ error: errorText }), { status: 400 });\n }\n\n const result = await facturamaRes.json();\n const uuid = result?.Complement?.TaxStamp?.Uuid;\n const id = result?.Id;\n\n if (!uuid || !id) {\n return new Response(JSON.stringify({ error: \"UUID or Facturama ID missing in response\" }), { status: 500 });\n }\n\n await updateAirtableFields({ CartaPorteUUID: uuid, FacturamaID: id });\n\n const [xmlBase64, pdfBase64] = await Promise.all([\n fetchFromFacturama(id, \"xml\"),\n fetchFromFacturama(id, \"pdf\"),\n ]);\n\n const [xmlUrl, pdfUrl] = await Promise.all([\n uploadToCloudinary(xmlBase64, `cfdi_${id}.xml`, \"application/xml\"),\n uploadToCloudinary(pdfBase64, `cfdi_${id}.pdf`, \"application/pdf\"),\n ]);\n\n await updateAirtableFields({\n XML: [{ url: xmlUrl, filename: \"cfdi.xml\" }],\n PDF: [{ url: pdfUrl, filename: \"cfdi.pdf\" }],\n });\n\n return new Response(JSON.stringify({ success: true, uuid, facturamaId: id, xmlUrl, pdfUrl }), { status: 200 });\n } catch (err: any) {\n console.error(\"\\u274C Error:\", err);\n return new Response(JSON.stringify({ error: err.message || \"Unexpected error\" }), { status: 500 });\n }\n}",[],[181],{"_104":189,"_95":190,"_152":191,"_154":-5,"_155":138,"_156":192,"_157":22,"_106":193,"_100":194,"_160":161,"_162":195,"_164":22,"_165":-5,"_167":196,"_98":197},"a34e9412-46de-11f0-8062-76b3cceeab13","test101.tsx","497de286-4642-11f0-bced-76b3cceeab13",21,["D",1749658248490],9,"export default async function handler(req: Request): Promise {\n const AIRTABLE_API_KEY = Deno.env.get(\"AIRTABLE_API_KEY\")!;\n const AIRTABLE_BASE_ID = Deno.env.get(\"AIRTABLE_BASE_ID\")!;\n const FACTURAMA_AUTH = Deno.env.get(\"FACTURAMA_AUTH\")!;\n const CLOUDINARY_UPLOAD_PRESET = Deno.env.get(\"CLOUDINARY_UPLOAD_PRESET\")!;\n const CLOUDINARY_CLOUD_NAME = Deno.env.get(\"CLOUDINARY_CLOUD_NAME\")!;\n const VIAJES_TABLE = Deno.env.get(\"VIAJES_TABLE\")!;\n const CLIENTES_TABLE = Deno.env.get(\"CLIENTES_TABLE\")!;\n const UBICACIONES_TABLE = Deno.env.get(\"UBICACIONES_TABLE\")!;\n const UNIDADES_TABLE = Deno.env.get(\"UNIDADES_TABLE\")!;\n const BIENES_TABLE = Deno.env.get(\"BIENES_TABLE\")!;\n const OPERADORES_TABLE = Deno.env.get(\"OPERADORES_TABLE\")!;\n\n const airtableHeaders = {\n Authorization: `Bearer ${AIRTABLE_API_KEY}`,\n \"Content-Type\": \"application/json\",\n };\n\n const recordId = new URL(req.url).searchParams.get(\"recordId\");\n if (!recordId) return new Response(JSON.stringify({ error: \"Missing recordId\" }), { status: 400 });\n\n const fetchRecord = async () => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${VIAJES_TABLE}/${recordId}`, {\n headers: airtableHeaders,\n });\n if (!res.ok) throw new Error(`Airtable fetch failed: ${res.status}`);\n return (await res.json()).fields;\n };\n\n const fetchLinkedRecord = async (tableId: string, recordId: string) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${tableId}/${recordId}`, {\n headers: airtableHeaders,\n });\n if (!res.ok) throw new Error(`Airtable fetch failed for ${tableId}/${recordId}: ${res.status}`);\n return (await res.json()).fields;\n };\n\n const fetchMultipleLinkedRecords = async (tableId: string, recordIds: string[]) => {\n const records = await Promise.all(recordIds.map(id => fetchLinkedRecord(tableId, id)));\n return records;\n };\n\n const uploadToCloudinary = async (base64: string, filename: string, mime: string): Promise => {\n const form = new FormData();\n form.append(\"file\", `data:${mime};base64,${base64}`);\n form.append(\"upload_preset\", CLOUDINARY_UPLOAD_PRESET);\n\n const res = await fetch(`https://api.cloudinary.com/v1_1/${CLOUDINARY_CLOUD_NAME}/upload`, {\n method: \"POST\",\n body: form,\n });\n\n if (!res.ok) {\n const err = await res.text();\n throw new Error(`Cloudinary upload failed: ${res.status} - ${err}`);\n }\n\n return (await res.json()).secure_url;\n };\n\n const updateAirtableFields = async (fields: Record) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${VIAJES_TABLE}/${recordId}`, {\n method: \"PATCH\",\n headers: airtableHeaders,\n body: JSON.stringify({ fields }),\n });\n if (!res.ok) throw new Error(`Airtable update failed: ${res.status}`);\n };\n\n const fetchFromFacturama = async (id: string, type: \"xml\" | \"pdf\") => {\n const url = `https://apisandbox.facturama.mx/api/Cfdi/${type}/issued/${id}`;\n const res = await fetch(url, {\n headers: {\n Authorization: FACTURAMA_AUTH,\n \"User-Agent\": \"Arequipe\",\n },\n });\n\n const body = await res.text();\n if (!res.ok) throw new Error(`Facturama ${type.toUpperCase()} fetch failed: ${res.status} - ${body}`);\n return JSON.parse(body)?.Content;\n };\n\n const formatDate = (date: Date) => {\n const pad = (n: number) => n.toString().padStart(2, \"0\");\n return `${date.getFullYear()}-${pad(date.getMonth() + 1)}-${pad(date.getDate())}T${pad(date.getHours())}:${\n pad(date.getMinutes())\n }:${pad(date.getSeconds())}`;\n };\n\n try {\n const viajeData = await fetchRecord();\n\n // Extract linked record IDs\n const emisorId = viajeData.Emisor?.[0];\n const clienteOrigenId = viajeData.ClienteOrigen?.[0];\n const clienteDestinoId = viajeData.ClienteDestino?.[0];\n const origenId = viajeData.Origen?.[0];\n const destinoId = viajeData.Destino?.[0];\n const unidadId = viajeData.Unidad?.[0];\n const operadorId = viajeData.Operador?.[0];\n const bienesIds = viajeData.Bienes || [];\n\n // Fetch linked records\n const emisor = await fetchLinkedRecord(CLIENTES_TABLE, emisorId);\n const clienteOrigen = await fetchLinkedRecord(CLIENTES_TABLE, clienteOrigenId);\n const clienteDestino = await fetchLinkedRecord(CLIENTES_TABLE, clienteDestinoId);\n const origen = await fetchLinkedRecord(UBICACIONES_TABLE, origenId);\n const destino = await fetchLinkedRecord(UBICACIONES_TABLE, destinoId);\n const unidad = await fetchLinkedRecord(UNIDADES_TABLE, unidadId);\n const operador = await fetchLinkedRecord(OPERADORES_TABLE, operadorId);\n const bienes = await fetchMultipleLinkedRecords(BIENES_TABLE, bienesIds);\n\n // Construct CFDI object\n const facturaDate = viajeData.Fecha ? formatDate(new Date(viajeData.Fecha)) : formatDate(new Date());\n const folio = viajeData.Folio || \"V-00001-GENERADO\";\n\n const cfdi = {\n CfdiType: viajeData.TipoCFDI || \"I\",\n NameId: \"36\",\n PaymentForm: viajeData.PaymentForm || \"01\",\n PaymentMethod: viajeData.PaymentMethod || \"PUE\",\n ExpeditionPlace: viajeData.ExpeditionPlace || \"76140\",\n Date: facturaDate,\n Folio: folio,\n Issuer: {\n Rfc: emisor.RFC,\n Name: emisor.Nombre,\n FiscalRegime: emisor.FiscalRegime,\n },\n Receiver: {\n Rfc: emisor.RFC,\n Name: emisor.Nombre,\n CfdiUse: emisor.UsoCFDI,\n FiscalRegime: emisor.FiscalRegime,\n TaxZipCode: emisor.TaxZipCode,\n },\n Items: bienes.map(bien => ({\n ProductCode: \"78121603\", // Placeholder\n Description: bien.Descripcion,\n UnitCode: \"E48\", // Placeholder\n Quantity: parseFloat(bien.Cantidad),\n UnitPrice: parseFloat(bien.Valor),\n Subtotal: parseFloat(bien.Cantidad) * parseFloat(bien.Valor),\n TaxObject: \"02\",\n Taxes: [{\n Total: (parseFloat(bien.Cantidad) * parseFloat(bien.Valor)) * 0.16,\n Name: \"IVA\",\n Base: parseFloat(bien.Cantidad) * parseFloat(bien.Valor),\n Rate: 0.16,\n IsRetention: false,\n }],\n Total: (parseFloat(bien.Cantidad) * parseFloat(bien.Valor)) * 1.16,\n })),\n Complemento: {\n CartaPorte31: {\n Version: \"3.1\",\n TranspInternac: \"No\",\n TotalDistRec: parseFloat(viajeData.TotalDistRec),\n LogisticaInversaRecoleccionDevolucion: viajeData.LogisticaInversaRecoleccionDevolucion || \"Sí\",\n Ubicaciones: [\n {\n TipoUbicacion: \"Origen\",\n IDUbicacion: origenId,\n FechaHoraSalidaLlegada: viajeData.FechaHoraSalida,\n RFCRemitenteDestinatario: clienteOrigen.RFC,\n NombreRemitenteDestinatario: clienteOrigen.Nombre,\n Domicilio: {\n Calle: origen.Calle,\n NumeroExterior: origen.NumeroExterior,\n NumeroInterior: origen.NumeroInterior || \"\",\n Colonia: \"0347\", // Placeholder\n Localidad: \"23\",\n Referencia: origen.Referencia,\n Municipio: \"004\",\n Estado: \"COA\",\n Pais: \"MEX\",\n CodigoPostal: \"25350\", // Placeholder\n },\n },\n {\n TipoUbicacion: \"Destino\",\n IDUbicacion: destinoId,\n FechaHoraSalidaLlegada: viajeData.FechaHoraLlegada,\n DistanciaRecorrida: parseFloat(viajeData.TotalDistRec),\n RFCRemitenteDestinatario: clienteDestino.RFC,\n NombreRemitenteDestinatario: clienteDestino.Nombre,\n Domicilio: {\n Calle: destino.Calle,\n NumeroExterior: destino.NumeroExterior,\n NumeroInterior: destino.NumeroInterior || \"\",\n Colonia: \"0347\", // Placeholder\n Localidad: \"23\",\n Referencia: destino.Referencia,\n Municipio: \"004\",\n Estado: \"COA\",\n Pais: \"MEX\",\n CodigoPostal: \"25350\", // Placeholder\n },\n },\n ],\n Mercancias: {\n UnidadPeso: \"KGM\",\n PesoBrutoTotal: bienes.reduce((sum, bien) => sum + parseFloat(bien.PesoBruto || \"0\"), 0),\n NumTotalMercancias: bienes.length,\n Mercancia: bienes.map(bien => ({\n BienesTransp: \"15101505\", // Placeholder\n FraccionArancelaria: bien.FraccionArancelaria || \"\",\n Descripcion: bien.Descripcion,\n Cantidad: parseFloat(bien.Cantidad),\n ClaveUnidad: \"LTR\", // Placeholder\n Unidad: bien.Unidad,\n PesoEnKg: parseFloat(bien.PesoEnKg || bien.PesoBruto),\n ValorMercancia: parseFloat(bien.Valor),\n Moneda: bien.Moneda || \"MXN\",\n MaterialPeligroso: bien.MaterialPeligroso || \"No\",\n ClaveSTCC: bien.ClaveSTCC || \"\",\n PesoNeto: parseFloat(bien.PesoNeto),\n PesoBruto: parseFloat(bien.PesoBruto),\n PesoTara: parseFloat(bien.PesoTara),\n UnidadPeso: \"KGM\",\n })),\n Autotransporte: {\n PermSCT: unidad.PermisoSCT,\n NumPermisoSCT: unidad.NumPermisoSCT,\n IdentificacionVehicular: {\n ConfigVehicular: unidad.ConfigVehicular,\n PlacaVM: unidad.Placa,\n AnioModeloVM: parseInt(unidad.AnioModelo),\n PesoBrutoVehicular: parseFloat(unidad.PesoBrutoVehicular),\n },\n Seguros: {\n AseguraRespCivil: unidad[\"Seguro de la Unidad\"],\n PolizaRespCivil: unidad.PolizaRespCivil,\n AseguraCarga: viajeData.AseguraCarga,\n PolizaCarga: viajeData.PolizaCarga,\n },\n Remolques: [\n { SubTipoRem: unidad.SubTipoRem1, Placa: unidad.PlacaRem1 },\n { SubTipoRem: unidad.SubTipoRem2, Placa: unidad.PlacaRem2 },\n ].filter(rem => rem.SubTipoRem && rem.Placa),\n },\n },\n FiguraTransporte: [\n {\n TipoFigura: operador.TipoFigura || \"01\",\n RFCFigura: operador.RFC,\n NumLicencia: operador.NumLicencia,\n NombreFigura: operador.Nombre,\n },\n ],\n },\n },\n };\n\n const facturamaRes = await fetch(\"https://apisandbox.facturama.mx/3/cfdis\", {\n method: \"POST\",\n headers: {\n Authorization: FACTURAMA_AUTH,\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(cfdi),\n });\n\n if (!facturamaRes.ok) {\n const errorText = await facturamaRes.text();\n return new Response(JSON.stringify({ error: errorText }), { status: 400 });\n }\n\n const result = await facturamaRes.json();\n const uuid = result?.Complement?.TaxStamp?.Uuid;\n const id = result?.Id;\n\n if (!uuid || !id) {\n return new Response(JSON.stringify({ error: \"UUID or Facturama ID missing in response\" }), { status: 500 });\n }\n\n await updateAirtableFields({ CartaPorteUUID: uuid, FacturamaID: id });\n\n const [xmlBase64, pdfBase64] = await Promise.all([\n fetchFromFacturama(id, \"xml\"),\n fetchFromFacturama(id, \"pdf\"),\n ]);\n\n const [xmlUrl, pdfUrl] = await Promise.all([\n uploadToCloudinary(xmlBase64, `cfdi_${id}.xml`, \"application/xml\"),\n uploadToCloudinary(pdfBase64, `cfdi_${id}.pdf`, \"application/pdf\"),\n ]);\n\n await updateAirtableFields({\n XML: [{ url: xmlUrl, filename: \"cfdi.xml\" }],\n PDF: [{ url: pdfUrl, filename: \"cfdi.pdf\" }],\n });\n\n return new Response(JSON.stringify({ success: true, uuid, facturamaId: id, xmlUrl, pdfUrl }), { status: 200 });\n } catch (err: any) {\n console.error(\"\\u274C Error:\", err);\n return new Response(JSON.stringify({ error: err.message || \"Unexpected error\" }), { status: 500 });\n }\n}",[],[190],{"_104":199,"_95":200,"_152":201,"_154":-5,"_155":138,"_156":202,"_157":22,"_106":203,"_100":183,"_160":204,"_162":205,"_164":22,"_165":-5,"_167":206,"_98":207},"d4efc9da-47ee-11f0-82fa-76b3cceeab13","updateSatCatalogsBlob.tsx","bb04bcba-47ee-11f0-83b2-76b3cceeab13",37,["D",1749775154866],"interval","import { blob } from \"https://esm.town/v/std/blob\";\nimport { fetch } from \"https://esm.town/v/std/fetch\";\n\n// URL para la última versión de catalogs.db.bz2\nconst CATALOGS_BZ2_URL = \"https://github.com/phpcfdi/resources-sat-catalogs/releases/latest/download/catalogs.db.bz2\";\nconst BLOB_NAME = \"sat-catalogs.db\";\n\nexport default async function updateSatCatalogsBlob() {\n console.log(`Iniciando actualización de catálogos SAT desde: ${CATALOGS_BZ2_URL}`);\n\n try {\n const response = await fetch(CATALOGS_BZ2_URL);\n if (!response.ok) {\n throw new Error(`Fallo al descargar el archivo .bz2: ${response.status} - ${response.statusText}`);\n }\n const compressedBuffer = await response.arrayBuffer();\n\n // Importante: La descompresión de .bz2 no está soportada directamente por las librerías estándar de Deno.\n // Asumimos que para una automatización completa, el .db se obtiene ya descomprimido\n // (ej. si la URL cambiara a un .db directo o si se usara un servicio externo de descompresión).\n // Si la fuente sigue siendo .bz2, este Val guardará el archivo comprimido.\n // Para que la validación funcione, el blob 'sat-catalogs.db' *debe* ser la versión descomprimida.\n // La carga inicial que hiciste manualmente ya aseguró esto.\n console.warn(\n \"Advertencia: Asegúrese de que el blob 'sat-catalogs.db' sea la versión descomprimida para que funcione la validación.\",\n );\n\n await blob.save(BLOB_NAME, compressedBuffer, { overwrite: true }); // Guardar el buffer (comprimido o no)\n console.log(`✅ Base de datos SAT Catalogs guardada como blob: ${BLOB_NAME}.`);\n } catch (error: any) {\n console.error(`❌ Error actualizando la base de datos SAT Catalogs: ${error.message}`);\n }\n}",[],[200],{"_104":209,"_95":210,"_152":211,"_154":-5,"_155":138,"_156":212,"_157":22,"_106":213,"_100":214,"_160":161,"_162":215,"_164":22,"_165":94,"_167":216,"_98":217},"37e0218a-47bc-11f0-abac-76b3cceeab13","uploadblob.tsx","6fd1500a-47ad-11f0-ad1b-76b3cceeab13",32,["D",1749753416519],10,"import { blob } from \"https://esm.town/v/std/blob\";\n\nexport default async function(req: Request): Promise {\n if (req.method === \"POST\") {\n const formData = await req.formData();\n const file = formData.get(\"file\");\n if (file instanceof Blob) {\n const arrayBuffer = await file.arrayBuffer();\n await blob.set(\"my_file\", new Uint8Array(arrayBuffer));\n return new Response(\"File uploaded successfully\", { status: 200 });\n }\n return new Response(\"No file uploaded\", { status: 400 });\n }\n return new Response(\n `\n \n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n}",[],[210],"files",[150,170,179,188,198,208],"counts",{"_222":32,"_223":224,"_225":32,"_226":227},"pulls","branches",1,"forks","envVars",12,"contents",[],"file",{"_104":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":101,"_157":22,"_106":232,"_100":159,"_160":161,"_162":163,"_164":22,"_165":166,"_98":233},["D",1749781269782],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":242,"_148":247,"_218":266,"_230":267,"_228":269,"_270":-5,"_271":22,"_272":-5,"_273":-5,"_274":-5,"_275":276},{"_104":105,"_95":96,"_106":243,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":244,"_132":245,"_135":246,"_147":22},["D",1748976966452],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_104":138,"_139":105,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},[248,251,254,257,260,263],{"_104":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":101,"_157":22,"_106":158,"_100":159,"_160":161,"_162":163,"_164":22,"_165":166,"_167":249,"_98":250},[],[99],{"_104":171,"_95":172,"_152":173,"_154":-5,"_155":138,"_156":174,"_157":22,"_106":175,"_100":176,"_160":161,"_162":163,"_164":22,"_165":-5,"_167":252,"_98":253},[],[172],{"_104":180,"_95":181,"_152":182,"_154":-5,"_155":138,"_156":183,"_157":22,"_106":184,"_100":159,"_160":161,"_162":185,"_164":22,"_165":-5,"_167":255,"_98":256},[],[181],{"_104":189,"_95":190,"_152":191,"_154":-5,"_155":138,"_156":192,"_157":22,"_106":193,"_100":194,"_160":161,"_162":195,"_164":22,"_165":-5,"_167":258,"_98":259},[],[190],{"_104":199,"_95":200,"_152":201,"_154":-5,"_155":138,"_156":202,"_157":22,"_106":203,"_100":183,"_160":204,"_162":205,"_164":22,"_165":-5,"_167":261,"_98":262},[],[200],{"_104":209,"_95":210,"_152":211,"_154":-5,"_155":138,"_156":212,"_157":22,"_106":213,"_100":214,"_160":161,"_162":215,"_164":22,"_165":94,"_167":264,"_98":265},[],[210],[248,251,254,257,260,263],{"_104":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":101,"_157":22,"_106":232,"_100":159,"_160":161,"_162":163,"_164":22,"_165":166,"_98":268},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]