[{"_1":2,"_278":-5,"_279":-5},"loaderData",{"_3":4,"_91":92,"_241":242},"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","d481f3d28ac6dd3f9b89bb10f2a0c9798df3020a","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,"_219":220,"_221":222,"_229":230,"_231":232,"_235":-5,"_236":-5,"_237":22,"_238":22,"_239":240},"handle","arequipe","name","tuempresa","branchName","path","updateSatCatalogsBlob.tsx","version",49,"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,171,181,190,200,209],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":101,"_158":22,"_106":159,"_100":160,"_161":162,"_163":164,"_165":22,"_166":167,"_168":169,"_98":170},"b980a326-47fe-11f0-9b0c-76b3cceeab13","ValidationCatalogGemini.tsx","fileId","46583898-47fc-11f0-87ba-76b3cceeab13","parentId","branchId","branchVersion","latest",["D",1749781980781],4,"fileType","http","content","import { blob } from \"https://esm.town/v/std/blob\";\nimport { fetch } from \"https://esm.town/v/std/fetch\"; // Asegúrate de que esta línea sea 'import { fetch } from \"https://esm.town/v/std/fetch\";' y no 'fetch\" = \"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 // El error de Airtable será capturado aquí con el mensaje específico\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]; // ClienteOrigen para validación de origen en CartaPorte\n const clienteDestinoId = viajeData.ClienteDestino?.[0]; // ClienteDestino para validación de destino en CartaPorte\n\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 ---\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 (RFC, RegimenFiscal, UsoCFDI, CodigoPostal)\n if (emisor) {\n const rfc = emisor.RFC; // Obtener RFC del campo enlazado (Tabla Clientes)\n const fiscalRegime = emisor.FiscalRegime;\n const usoCfdi = emisor.UsoCFDI;\n const taxZipCode = emisor.TaxZipCode;\n\n if (!rfc) {\n validationMessages.push(`Emisor: Falta el campo 'RFC' para validación.`);\n allValid = false;\n }\n // Opcional: Si necesitas validar el formato del RFC, podrías añadir una regex aquí\n // else if (!/^[A-Z&Ñ]{3,4}[0-9]{2}(0[1-9]|1[0-2])(0[1-9]|[12][0-9]|3[01])[A-Z0-9]{2}[A-Z0-9]$/.test(rfc)) {\n // validationMessages.push(`Emisor: RFC '${rfc}' tiene un formato inválido.`);\n // allValid = false;\n // }\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 } else {\n validationMessages.push(\"Emisor: No se pudo cargar el registro del Emisor para validación.\");\n allValid = false;\n }\n\n if (clienteDestino) { // Validar clienteDestino similar a Emisor\n const rfc = clienteDestino.RFC;\n const fiscalRegime = clienteDestino.FiscalRegime;\n const usoCfdi = clienteDestino.UsoCFDI;\n const taxZipCode = clienteDestino.TaxZipCode;\n\n if (!rfc) {\n validationMessages.push(`Cliente Destino: Falta el campo 'RFC' para validación.`);\n allValid = false;\n }\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(\n `Cliente Destino: Régimen Fiscal '${fiscalRegime}' no encontrado en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(\"Cliente Destino: 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(`Cliente Destino: Uso CFDI '${usoCfdi}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(\"Cliente Destino: 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(\n `Cliente Destino: Código Postal Fiscal '${taxZipCode}' no encontrado en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(\"Cliente Destino: Falta Código Postal Fiscal para validación.\");\n allValid = false;\n }\n } else {\n validationMessages.push(\"Cliente Destino: No se pudo cargar el registro del Cliente Destino para validación.\");\n allValid = false;\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",[],[152],{"_104":172,"_95":173,"_153":174,"_155":-5,"_156":138,"_157":175,"_158":22,"_106":176,"_100":177,"_161":162,"_163":178,"_165":22,"_166":-5,"_168":179,"_98":180},"9a4115f4-47fe-11f0-9d0f-76b3cceeab13","ValidationCatalogGrok.tsx","2d451bc4-467a-11f0-83b8-76b3cceeab13",48,["D",1749781928351],13,"const AIRTABLE_API_KEY = Deno.env.get(\"AIRTABLE_API_KEY\")!;\nconst AIRTABLE_BASE_ID = Deno.env.get(\"AIRTABLE_BASE_ID\")!;\nconst VIAJES_TABLE = \"Viajes\";\nconst BIENES_TABLE = \"Bienes\";\n\nconst airtableHeaders = {\n Authorization: `Bearer ${AIRTABLE_API_KEY}`,\n \"Content-Type\": \"application/json\",\n};\n\nasync function fetchRecord(table: string, recordId: string) {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${table}/${recordId}`, {\n headers: airtableHeaders,\n });\n if (!res.ok) throw new Error(`Failed to fetch record ${recordId} from ${table}: ${res.status}`);\n return (await res.json()).fields;\n}\n\nexport async function validateRecord(req: Request): Promise {\n try {\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 viaje = await fetchRecord(VIAJES_TABLE, recordId);\n const bienesIds = viaje.Bienes || [];\n if (bienesIds.length === 0) throw new Error(\"At least one Bien is required\");\n\n const bienes = await Promise.all(bienesIds.map((id: string) => fetchRecord(BIENES_TABLE, id)));\n\n const c_ClaveProdServ = await blob.getJSON(\"c_ClaveProdServ\");\n const c_CveUnidad = await blob.getJSON(\"c_CveUnidad\");\n\n const errors: string[] = [];\n\n for (const bien of bienes) {\n const prodServ = bien.SAT_ClaveProdServP;\n if (!prodServ || !c_ClaveProdServ.some((item: any) => item.clave === prodServ)) {\n errors.push(`Invalid SAT_ClaveProdServP: ${prodServ || \"missing\"}`);\n }\n const unidad = bien.SAT_ClaveUnidadP;\n if (!unidad || !c_CveUnidad.some((item: any) => item.clave === unidad)) {\n errors.push(`Invalid SAT_ClaveUnidadP: ${unidad || \"missing\"}`);\n }\n // Add more validations as needed, e.g., MaterialPeligroso, ClaveSTCC\n }\n\n if (errors.length > 0) {\n return new Response(JSON.stringify({ success: false, errors }), { status: 400 });\n }\n\n return new Response(JSON.stringify({ success: true, message: \"Validation passed\" }), { status: 200 });\n } catch (err: any) {\n console.error(\"Validation error:\", err);\n return new Response(JSON.stringify({ error: err.message || \"Unexpected error\" }), { status: 500 });\n }\n}",[],[173],{"_104":182,"_95":183,"_153":184,"_155":-5,"_156":138,"_157":160,"_158":22,"_106":185,"_100":186,"_161":162,"_163":187,"_165":22,"_166":-5,"_168":188,"_98":189},"ac775c50-40ac-11f0-b42d-76b3cceeab13","main.tsx","67929d8e-40ac-11f0-ad8f-76b3cceeab13",["D",1748977082042],3,"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}",[],[183],{"_104":191,"_95":192,"_153":193,"_155":-5,"_156":138,"_157":194,"_158":22,"_106":195,"_100":196,"_161":162,"_163":197,"_165":22,"_166":-5,"_168":198,"_98":199},"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}",[],[192],{"_104":201,"_95":99,"_153":202,"_155":-5,"_156":138,"_157":203,"_158":22,"_106":204,"_100":160,"_161":205,"_163":206,"_165":22,"_166":-5,"_168":207,"_98":208},"d4efc9da-47ee-11f0-82fa-76b3cceeab13","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}",[],[99],{"_104":210,"_95":211,"_153":212,"_155":-5,"_156":138,"_157":213,"_158":22,"_106":214,"_100":215,"_161":162,"_163":216,"_165":22,"_166":94,"_168":217,"_98":218},"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}",[],[211],"files",[150,171,181,190,200,209],"counts",{"_223":32,"_224":225,"_226":32,"_227":228},"pulls","branches",1,"forks","envVars",12,"contents",[],"file",{"_104":201,"_95":99,"_153":202,"_155":-5,"_156":138,"_157":203,"_158":22,"_106":233,"_100":160,"_161":205,"_163":206,"_165":22,"_166":-5,"_98":234},["D",1749775154866],[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":243,"_148":248,"_219":267,"_231":268,"_229":270,"_271":-5,"_272":22,"_273":-5,"_274":-5,"_275":-5,"_276":277},{"_104":105,"_95":96,"_106":244,"_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":245,"_132":246,"_135":247,"_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},[249,252,255,258,261,264],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":101,"_158":22,"_106":159,"_100":160,"_161":162,"_163":164,"_165":22,"_166":167,"_168":250,"_98":251},[],[152],{"_104":172,"_95":173,"_153":174,"_155":-5,"_156":138,"_157":175,"_158":22,"_106":176,"_100":177,"_161":162,"_163":178,"_165":22,"_166":-5,"_168":253,"_98":254},[],[173],{"_104":182,"_95":183,"_153":184,"_155":-5,"_156":138,"_157":160,"_158":22,"_106":185,"_100":186,"_161":162,"_163":187,"_165":22,"_166":-5,"_168":256,"_98":257},[],[183],{"_104":191,"_95":192,"_153":193,"_155":-5,"_156":138,"_157":194,"_158":22,"_106":195,"_100":196,"_161":162,"_163":197,"_165":22,"_166":-5,"_168":259,"_98":260},[],[192],{"_104":201,"_95":99,"_153":202,"_155":-5,"_156":138,"_157":203,"_158":22,"_106":204,"_100":160,"_161":205,"_163":206,"_165":22,"_166":-5,"_168":262,"_98":263},[],[99],{"_104":210,"_95":211,"_153":212,"_155":-5,"_156":138,"_157":213,"_158":22,"_106":214,"_100":215,"_161":162,"_163":216,"_165":22,"_166":94,"_168":265,"_98":266},[],[211],[249,252,255,258,261,264],{"_104":201,"_95":99,"_153":202,"_155":-5,"_156":138,"_157":203,"_158":22,"_106":233,"_100":160,"_161":205,"_163":206,"_165":22,"_166":-5,"_98":269},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]