[{"_1":2,"_316":-5,"_317":-5},"loaderData",{"_3":4,"_91":92,"_270":271},"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","e3ca0a77ab07ff2ce3097208ffd6aa0e378d3c47","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,"_249":250,"_251":252,"_258":259,"_260":261,"_264":-5,"_265":-5,"_266":22,"_267":22,"_268":269},"handle","arequipe","name","tuempresa","branchName","path","test101.tsx","version",89,"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,182,192,201,211,221,229,238],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":22,"_106":160,"_100":161,"_162":163,"_164":165,"_166":22,"_167":-5,"_168":169,"_98":170},"249a5384-487f-11f0-a347-76b3cceeab13","SQLite_JSON.tsx","fileId","61a62714-487d-11f0-b3cd-76b3cceeab13","parentId","branchId","branchVersion",75,"latest",["D",1749837136051],8,"fileType","http","content","import { blob } from \"https://esm.town/v/std/blob\";\n\nexport default async function uploadSatCatalogs(req: Request) {\n console.log(\"Request received:\", req.method, req.url, \"Headers:\", req.headers);\n\n if (req.method !== \"POST\") {\n return new Response(\n JSON.stringify({ message: \"Send POST with { filename, content } as base64\" }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n console.log(\"Processing POST request\");\n let body;\n try {\n body = await req.json();\n console.log(\"Body received:\", body);\n } catch (e) {\n console.error(\"Failed to parse JSON body:\", e);\n return new Response(\"Invalid JSON payload\", { status: 400 });\n }\n\n const { filename, content } = body;\n\n if (!filename || !content) {\n console.log(\"Missing filename or content\");\n return new Response(\"Missing filename or content\", { status: 400 });\n }\n\n try {\n console.log(\"Decoding base64 content\");\n const binaryString = atob(content);\n const bytes = new Uint8Array(binaryString.length);\n for (let i = 0; i < binaryString.length; i++) {\n bytes[i] = binaryString.charCodeAt(i);\n }\n const text = new TextDecoder().decode(bytes);\n console.log(\"Saving to blob:\", filename, \"Length:\", text.length);\n await blob.save(filename, text, { overwrite: true });\n console.log(`✅ Successfully uploaded ${filename}`);\n return new Response(`✅ Uploaded ${filename} to blob storage`, { status: 200 });\n } catch (error: any) {\n console.error(`❌ Error uploading ${filename}:`, error.message);\n return new Response(`❌ Error uploading ${filename}: ${error.message}`, { status: 500 });\n }\n}","deleted","label","children",[],[152],{"_104":172,"_95":173,"_153":174,"_155":-5,"_156":138,"_157":175,"_159":22,"_106":176,"_100":177,"_162":163,"_164":178,"_166":22,"_167":179,"_168":180,"_98":181},"435d94ec-486c-11f0-a6c5-76b3cceeab13","ValidationCatalogGemini.tsx","46583898-47fc-11f0-87ba-76b3cceeab13",60,["D",1749829027223],9,"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\")!; // Corregido\n const CLIENTES_TABLE = Deno.env.get(\"CLIENTES_TABLE\")!; // Corregido\n const UBICACIONES_TABLE = Deno.env.get(\"UBICACIONES_TABLE\")!; // Corregido\n const UNIDADES_TABLE = Deno.env.get(\"UNIDADES_TABLE\")!; // Corregido\n const BIENES_TABLE = Deno.env.get(\"BIENES_TABLE\")!; // Corregido\n const OPERADORES_TABLE = Deno.env.get(\"OPERADORES_TABLE\")!; // Corregido\n const REMOLQUES_TABLE = Deno.env.get(\"REMOLQUES_TABLE\")!; // Corregido\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 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\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;\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;\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\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) {\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}","arequipegemini",[],[173],{"_104":183,"_95":184,"_153":185,"_155":-5,"_156":138,"_157":186,"_159":22,"_106":187,"_100":188,"_162":163,"_164":189,"_166":22,"_167":-5,"_168":190,"_98":191},"930a74e2-486c-11f0-86b8-76b3cceeab13","ValidationCatalogGrok.tsx","2d451bc4-467a-11f0-83b8-76b3cceeab13",61,["D",1749829160896],20,"import { blob } from \"https://esm.town/v/std/blob\";\n\nconst 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 url = new URL(req.url);\n const recordId = url.searchParams.get(\"recordId\");\n if (!recordId) {\n return new Response(JSON.stringify({ error: \"Missing recordId\" }), { status: 400 });\n }\n\n console.log(`Iniciando validación de catálogos SAT para Viaje ID: ${recordId}`);\n const viaje = await fetchRecord(VIAJES_TABLE, recordId);\n if (!viaje) throw new Error(\"Viaje no encontrado\");\n\n const bienesIds = viaje.Bienes || [];\n if (bienesIds.length === 0) throw new Error(\"Se requiere al menos un Bien\");\n\n const bienes = await Promise.all(bienesIds.map((id: string) => fetchRecord(BIENES_TABLE, id)));\n\n console.log(\"Cargando catálogos SAT...\");\n const c_ClaveProdServ = await blob.getJSON(\"c_ClaveProdServ\");\n if (!c_ClaveProdServ) throw new Error(\"No se pudo cargar el catálogo c_ClaveProdServ\");\n\n const c_CveUnidad = await blob.getJSON(\"c_CveUnidad\");\n if (!c_CveUnidad) throw new Error(\"No se pudo cargar el catálogo 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 console.log(\"Validación completada con éxito\");\n return new Response(JSON.stringify({ success: true, message: \"Validación pasada\" }), { status: 200 });\n } catch (err: any) {\n console.error(\"Error global durante la validación:\", err);\n return new Response(JSON.stringify({ error: err.message || \"Error inesperado\" }), { status: 500 });\n }\n}",[],[184],{"_104":193,"_95":194,"_153":195,"_155":-5,"_156":138,"_157":101,"_159":22,"_106":196,"_100":197,"_162":163,"_164":198,"_166":22,"_167":-5,"_168":199,"_98":200},"7c334bb4-4bf9-11f0-9012-76b3cceeab13","arequipe_uploadBlobProxy.tsx","b68279e4-4b80-11f0-a820-76b3cceeab13",["D",1750219535103],6,"import { blob } from \"https://esm.town/v/std/blob\";\n\nexport async function uploadBlobProxy(req: Request): Promise {\n // Asegurarse de que la solicitud sea un POST\n if (req.method !== \"POST\") {\n return new Response(\"Método no permitido. Por favor, usa POST.\", { status: 405 });\n }\n\n // Obtener el nombre del blob de los parámetros de la URL\n const url = new URL(req.url);\n const blobName = url.searchParams.get(\"blobName\");\n\n if (!blobName) {\n return new Response(\"Parámetro 'blobName' faltante en la URL. Ejemplo: ?blobName=mi_archivo.db\", { status: 400 });\n }\n\n try {\n // Leer el cuerpo de la solicitud como un ArrayBuffer (datos binarios)\n const arrayBuffer = await req.arrayBuffer();\n\n if (arrayBuffer.byteLength === 0) {\n return new Response(\"El cuerpo de la solicitud está vacío. No se recibió ningún archivo.\", { status: 400 });\n }\n\n // Guardar el ArrayBuffer en el almacenamiento de blobs de Val Town\n // 'overwrite: true' permite actualizar el blob si ya existe\n await blob.save(blobName, arrayBuffer, { overwrite: true });\n\n console.log(`✅ Blob '${blobName}' (${arrayBuffer.byteLength} bytes) subido exitosamente a Val Town.`);\n return new Response(`Blob '${blobName}' subido exitosamente.`, { status: 200 });\n } catch (error: any) {\n console.error(`❌ Error al procesar la carga del blob '${blobName}': ${error.message}`);\n return new Response(`Error al subir el blob: ${error.message}`, { status: 500 });\n }\n}",[],[194],{"_104":202,"_95":203,"_153":204,"_155":-5,"_156":138,"_157":205,"_159":22,"_106":206,"_100":207,"_162":163,"_164":208,"_166":22,"_167":-5,"_168":209,"_98":210},"ac775c50-40ac-11f0-b42d-76b3cceeab13","main.tsx","67929d8e-40ac-11f0-ad8f-76b3cceeab13",4,["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}",[],[203],{"_104":212,"_95":213,"_153":214,"_155":-5,"_156":138,"_157":215,"_159":22,"_106":216,"_100":205,"_162":217,"_164":218,"_166":22,"_167":-5,"_168":219,"_98":220},"7c16ebf2-4b15-11f0-9d37-76b3cceeab13","satcronval.tsx","6e6b8cc4-4b15-11f0-a085-76b3cceeab13",81,["D",1750121609667],"interval","// sat-cron.val.tsx\nimport { blob } from \"https://esm.town/v/std/blob\";\n\nexport default async function cronHandler() {\n const RAW = \"https://raw.githubusercontent.com/phpcfdi/resources-sat-catalogs/master/database/tables.list\";\n const res = await fetch(RAW);\n if (!res.ok) throw new Error(`Fetch failed ${res.status}`);\n const text = await res.text();\n await blob.set(\"tables.list\", new TextEncoder().encode(text));\n console.log(\"✅ Updated tables.list:\", text.length, \"bytes\");\n}",[],[213],{"_104":222,"_95":99,"_153":223,"_155":-5,"_156":138,"_157":224,"_159":22,"_106":225,"_100":177,"_162":163,"_164":226,"_166":22,"_167":-5,"_168":227,"_98":228},"a34e9412-46de-11f0-8062-76b3cceeab13","497de286-4642-11f0-bced-76b3cceeab13",21,["D",1749658248490],"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}",[],[99],{"_104":230,"_95":231,"_153":232,"_155":-5,"_156":138,"_157":233,"_159":22,"_106":234,"_100":177,"_162":217,"_164":235,"_166":22,"_167":-5,"_168":236,"_98":237},"4b3a95f6-487c-11f0-9910-76b3cceeab13","updateSatCatalogsBlob.tsx","bb04bcba-47ee-11f0-83b2-76b3cceeab13",66,["D",1749835912365],"import { blob } from \"https://esm.town/v/std/blob\";\nimport { fetch } from \"https://esm.town/v/std/fetch\";\n\n// Base URL for the dist/json directory (using main branch)\nconst JSON_BASE_URL = \"https://raw.githubusercontent.com/phpcfdi/resources-sat-catalogs/main/dist/json/\";\nconst CATALOGS = [\n \"c_ClaveProdServ\",\n \"c_CveUnidad\",\n \"cfdi_tipos_comprobantes\",\n \"cfdi_tipos_factores\",\n \"cfdi_tipos_relaciones\",\n \"cfdi_usos_cfdi\",\n \"nomina_bancos\",\n \"nomina_estados\",\n \"nomina_origenes_recursos\",\n \"nomina_periodicidades_pagos\",\n \"nomina_riesgos_puestos\",\n \"nomina_tipos_contratos\",\n \"nomina_tipos_deducciones\",\n \"nomina_tipos_percepciones\",\n \"nomina_tipos_regimenes\",\n \"pagos_tipos_cadena_pago\",\n \"ret_20_claves_retencion\",\n \"ret_20_ejercicios\",\n \"ret_20_entidades_federativas\",\n \"ret_20_paises\",\n \"ret_20_periodicidades\",\n \"ret_20_periodos\",\n \"ret_20_tipos_contribuyentes\",\n \"ret_20_tipos_dividendos_utilidades\",\n \"ret_20_tipos_impuestos\",\n \"ret_20_tipos_pago_retencion\",\n];\n\nexport default async function updateSatCatalogsBlob() {\n console.log(\"Starting SAT catalogs update from dist/json\");\n\n try {\n for (const catalog of CATALOGS) {\n const url = `${JSON_BASE_URL}${catalog}.json`;\n console.log(`Downloading ${catalog} from ${url}`);\n const response = await fetch(url);\n if (!response.ok) {\n throw new Error(`Failed to download ${catalog}: ${response.status} - ${response.statusText}`);\n }\n const text = await response.text();\n await blob.save(catalog, text, { overwrite: true });\n console.log(`✅ Catalog ${catalog} saved to blob storage.`);\n }\n console.log(\"✅ All catalogs updated successfully.\");\n } catch (error: any) {\n console.error(`❌ Error updating SAT catalogs: ${error.message}`);\n }\n}",[],[231],{"_104":239,"_95":240,"_153":241,"_155":-5,"_156":138,"_157":242,"_159":243,"_106":244,"_100":245,"_162":163,"_164":246,"_166":22,"_167":94,"_168":247,"_98":248},"928f34de-4b1a-11f0-986e-76b3cceeab13","uploadblob.tsx","6fd1500a-47ad-11f0-ad1b-76b3cceeab13",82,true,["D",1750123794847],12,"import { blob } from \"https://esm.town/v/std/blob\";\n\nexport async function uploadCatalogsDbToBlobManual() {\n // ⚠️ IMPORTANTE: PEGA LA LARGA CADENA BASE64 AQUÍ ⚠️\n // Asegúrate de que toda la cadena esté EXACTAMENTE entre las dos comillas (```).\n // Será una cadena MUY larga, ¡no te asustes!\n\n const base64Content = ``; // <--- ¡Borra lo que hay entre las comillas y pega tu cadena Base64 aquí!\n\n if (base64Content === \"\") {\n console.error(\n \"❌ Error: La cadena Base64 está vacía. ¡Asegúrate de pegar el contenido de tu archivo catalogs.db aquí!\",\n );\n return new Response(\"Error: La cadena Base64 está vacía.\", { status: 400 });\n }\n\n // Convierte la cadena Base64 de nuevo a un ArrayBuffer (formato binario)\n const binaryString = atob(base64Content);\n const len = binaryString.length;\n const bytes = new Uint8Array(len);\n for (let i = 0; i < len; i++) {\n bytes[i] = binaryString.charCodeAt(i);\n }\n const arrayBuffer = bytes.buffer;\n\n // Guarda el ArrayBuffer como un blob en Val Town.\n // El nombre 'sat-catalogs.db' es CRUCIAL, ya que tu código de validación lo buscará exactamente así.\n try {\n await blob.save(\"sat-catalogs.db\", arrayBuffer, { overwrite: true }); // Usamos overwrite: true por si ya existía una versión.\n console.log(\"✅ ¡El archivo catalogs.db se ha subido y guardado exitosamente como blob 'sat-catalogs.db'!\");\n return new Response(\"Upload successful: sat-catalogs.db created!\", { status: 200 });\n } catch (error: any) {\n console.error(`❌ Error al subir el blob: ${error.message}`);\n return new Response(`Upload failed: ${error.message}`, { status: 500 });\n }\n}",[],[240],"files",[150,171,182,192,201,211,221,229,238],"counts",{"_253":32,"_254":255,"_256":32,"_257":245},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_104":222,"_95":99,"_153":223,"_155":-5,"_156":138,"_157":224,"_159":22,"_106":262,"_100":177,"_162":163,"_164":226,"_166":22,"_167":-5,"_98":263},["D",1749658248490],[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":272,"_148":277,"_249":305,"_260":306,"_258":308,"_309":-5,"_310":22,"_311":-5,"_312":-5,"_313":-5,"_314":315},{"_104":105,"_95":96,"_106":273,"_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":274,"_132":275,"_135":276,"_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},[278,281,284,287,290,293,296,299,302],{"_104":151,"_95":152,"_153":154,"_155":-5,"_156":138,"_157":158,"_159":22,"_106":160,"_100":161,"_162":163,"_164":165,"_166":22,"_167":-5,"_168":279,"_98":280},[],[152],{"_104":172,"_95":173,"_153":174,"_155":-5,"_156":138,"_157":175,"_159":22,"_106":176,"_100":177,"_162":163,"_164":178,"_166":22,"_167":179,"_168":282,"_98":283},[],[173],{"_104":183,"_95":184,"_153":185,"_155":-5,"_156":138,"_157":186,"_159":22,"_106":187,"_100":188,"_162":163,"_164":189,"_166":22,"_167":-5,"_168":285,"_98":286},[],[184],{"_104":193,"_95":194,"_153":195,"_155":-5,"_156":138,"_157":101,"_159":22,"_106":196,"_100":197,"_162":163,"_164":198,"_166":22,"_167":-5,"_168":288,"_98":289},[],[194],{"_104":202,"_95":203,"_153":204,"_155":-5,"_156":138,"_157":205,"_159":22,"_106":206,"_100":207,"_162":163,"_164":208,"_166":22,"_167":-5,"_168":291,"_98":292},[],[203],{"_104":212,"_95":213,"_153":214,"_155":-5,"_156":138,"_157":215,"_159":22,"_106":216,"_100":205,"_162":217,"_164":218,"_166":22,"_167":-5,"_168":294,"_98":295},[],[213],{"_104":222,"_95":99,"_153":223,"_155":-5,"_156":138,"_157":224,"_159":22,"_106":225,"_100":177,"_162":163,"_164":226,"_166":22,"_167":-5,"_168":297,"_98":298},[],[99],{"_104":230,"_95":231,"_153":232,"_155":-5,"_156":138,"_157":233,"_159":22,"_106":234,"_100":177,"_162":217,"_164":235,"_166":22,"_167":-5,"_168":300,"_98":301},[],[231],{"_104":239,"_95":240,"_153":241,"_155":-5,"_156":138,"_157":242,"_159":243,"_106":244,"_100":245,"_162":163,"_164":246,"_166":22,"_167":94,"_168":303,"_98":304},[],[240],[278,281,284,287,290,293,296,299,302],{"_104":222,"_95":99,"_153":223,"_155":-5,"_156":138,"_157":224,"_159":22,"_106":262,"_100":177,"_162":163,"_164":226,"_166":22,"_167":-5,"_98":307},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]