[{"_1":2,"_360":-5,"_361":-5},"loaderData",{"_3":4,"_93":94,"_345":346},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":-5,"_32":33,"_34":22,"_35":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","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_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,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","6050acf0705e6826bb1b68e27572c5b8979c5bd9","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",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":22,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":22,"_92":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",{"_83":22,"_21":22,"_84":74,"_85":86,"_87":74,"_88":47,"_89":22,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_95":96,"_97":98,"_99":45,"_100":74,"_101":102,"_103":104,"_156":157,"_285":286,"_287":288,"_300":301,"_338":-5,"_339":-5,"_340":-5,"_341":22,"_342":22,"_343":344},"handle","arequipe","name","tuempresa","branchName","path","version",112,"project",{"_105":106,"_97":98,"_107":108,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":117,"_118":119,"_120":119,"_121":-5,"_122":33,"_16":123,"_124":-5,"_125":-5,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":135,"_138":139,"_143":144,"_155":22},"id","67904a0c-40ac-11f0-ad8f-76b3cceeab13","createdAt",["D",1748976966452],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","b45123f0-3406-11f0-994d-f304847156a7","pinnedFileId","d3cd990c-4d38-11f0-8110-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","a7d312c4-47a4-45c8-b4c3-e46228d5db68","tursoName","tursoHostname","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_136":137},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4SEUwMzRLMGRyUDM0ZTVuazBHR1Jaa3g3VyJ9","org",{"_95":96,"_140":137,"_14":115,"_141":142},"avatar","tier","free","branch",{"_101":145,"_97":45,"_105":146,"_147":106,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},189,"67909098-40ac-11f0-ad8f-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[158,179,190,200,210,220,229,238,246,256,266,275],{"_105":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":22,"_107":168,"_101":169,"_170":171,"_172":173,"_174":22,"_175":-5,"_176":177,"_100":178},"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",[],[160],{"_105":180,"_97":181,"_161":182,"_163":-5,"_164":146,"_165":183,"_167":22,"_107":184,"_101":185,"_170":171,"_172":186,"_174":22,"_175":187,"_176":188,"_100":189},"3d3051ba-4c93-11f0-bdb7-76b3cceeab13","ValidationCatalogGemini.tsx","46583898-47fc-11f0-87ba-76b3cceeab13",110,["D",1750285571886],17,"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\n // Nombres de tablas de Airtable basados en tu esquema base_schema_arequipe5.json\n const VIAJES_TABLE = \"tbluae26QBVM79lNO\"; // ID de la tabla \"Viajes\"\n const CLIENTES_TABLE = \"tbl391JuSAYCeO8nq\"; // ID de la tabla \"Clientes\"\n const UBICACIONES_TABLE = \"tbl4vciZ7spIKkzoD\"; // ID de la tabla \"Ubicaciones\"\n const UNIDADES_TABLE = \"tbl56jPt2HESbWExO\"; // ID de la tabla \"Unidades\"\n const BIENES_TABLE = \"tblza2bdpnYjXtdjO\"; // ID de la tabla \"Bienes\"\n const OPERADORES_TABLE = \"tblu4mViAwHSAEpCc\"; // ID de la tabla \"Operadores\"\n const REMOLQUES_TABLE = \"tblptnOuENKOQmvyD\"; // ID de la tabla \"Remolques\"\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 // Función auxiliar para obtener un solo registro enlazado\n const fetchLinkedRecord = async (tableId: string, recordId: string) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${tableId}/${recordId}`, {\n headers: airtableHeaders,\n });\n if (!res.ok) {\n const errorText = await res.text();\n throw new Error(`Airtable fetch failed for ${tableId}/${recordId}: ${res.status} - ${errorText}`);\n }\n return (await res.json()).fields;\n };\n\n // Función auxiliar para obtener múltiples registros enlazados (para campos de múltiples enlaces)\n const fetchMultipleLinkedRecords = async (tableId: string, recordIds: string[]) => {\n if (!recordIds || recordIds.length === 0) return [];\n const records = await Promise.all(recordIds.map(id => fetchRecord(tableId, id)));\n return records;\n };\n\n // Función auxiliar para actualizar campos en Airtable\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 // Cargar la base de datos de catálogos SAT del blob storage\n const db = await blob.get(\"sat-catalogs.db\");\n if (!db) {\n throw new Error(\n \"Base de datos de catálogos SAT (sat-catalogs.db) no encontrada en blob storage. Por favor, asegúrate de haberla subido.\",\n );\n }\n console.log(\"Base de datos de catálogos SAT cargada.\");\n\n // ** VERIFICACIÓN DE TABLA (Mantenida para diagnóstico) **\n try {\n const { rows } = await sqlite.execute({\n sql: \"SELECT name FROM sqlite_master WHERE type='table' AND name = 'cfdi_40_codigos_postales';\",\n args: [],\n file: db,\n });\n if (rows.length === 0) {\n const errorMsg =\n `❌ Error: La tabla 'cfdi_40_codigos_postales' NO FUE ENCONTRADA en el blob 'sat-catalogs.db'. Esto es crítico.`;\n console.error(errorMsg);\n throw new Error(errorMsg);\n }\n console.log(\"Tabla 'cfdi_40_codigos_postales' encontrada en el blob.\");\n } catch (tableCheckError: any) {\n throw new Error(`Error al verificar la tabla 'cfdi_40_codigos_postales': ${tableCheckError.message}`);\n }\n\n // Obtener datos del registro de Viajes\n const viajeData = await fetchLinkedRecord(VIAJES_TABLE, recordId);\n\n // Extraer IDs de registros enlazados\n const emisorId = viajeData.Emisor?.[0];\n const clienteOrigenId = viajeData.ClienteOrigen?.[0];\n const clienteDestinoId = viajeData.ClienteDestino?.[0];\n const origenId = viajeData.Origen?.[0];\n const destinoId = viajeData.Destino?.[0];\n const unidadId = viajeData.Unidad?.[0];\n const operadorId = viajeData.Operador?.[0];\n const bienesIds = viajeData.Bienes || [];\n const remolqueId = viajeData.Remolque?.[0];\n\n // Cargar datos completos de los registros enlazados en paralelo\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 de Catálogos SAT ---\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\"]; // Este es el ID del municipio en Airtable\n const estado = origen[\"Estado Link\"]; // Este es el ID del estado en Airtable\n const colonia = origen[\"Colonia Link\"]; // Este es el código de colonia en Airtable\n\n if (cp && municipio && estado) {\n // Consultar cfdi_40_codigos_postales por el CP\n // y luego verificar que el estado y municipio enlazados en esa tabla coincidan\n // con los valores de Airtable.\n // También verificar la colonia.\n const { rows } = await sqlite.execute({\n sql: `SELECT \n T1.estado AS cp_estado_id, \n T1.municipio AS cp_municipio_id, \n T4.colonia AS cp_colonia_id\n FROM cfdi_40_codigos_postales AS T1\n LEFT JOIN cfdi_40_colonias AS T4 ON T1.id = T4.codigo_postal\n WHERE T1.id = ?`,\n args: [cp],\n file: db,\n });\n\n let cpValid = false;\n let coloniaValid = !colonia; // Si no hay colonia en Airtable, se asume válida por defecto.\n\n if (rows.length > 0) {\n for (const row of rows) {\n // Se verifica que el estado y municipio del CP del SAT coincidan con los de Airtable\n if (row.cp_municipio_id === municipio && row.cp_estado_id === estado) {\n cpValid = true;\n // Si Airtable tiene una colonia, se verifica que también coincida\n if (colonia && row.cp_colonia_id === colonia) {\n coloniaValid = true;\n } else if (!colonia) { // Si Airtable no tiene colonia, y CP/Mun/Edo son válidos, es OK.\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 en Airtable para validación.\");\n allValid = false;\n }\n } else {\n validationMessages.push(\"Origen: No se pudo cargar el registro de Origen de Airtable.\");\n allValid = false;\n }\n\n // 2. Validar Ubicación de Destino (CP, Municipio, Estado, Colonia) - MISMA LÓGICA\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 \n T1.estado AS cp_estado_id, \n T1.municipio AS cp_municipio_id, \n T4.colonia AS cp_colonia_id\n FROM cfdi_40_codigos_postales AS T1\n LEFT JOIN cfdi_40_colonias AS T4 ON T1.id = T4.codigo_postal\n WHERE T1.id = ?`,\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.cp_municipio_id === municipio && row.cp_estado_id === estado) {\n cpValid = true;\n if (colonia && row.cp_colonia_id === 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 en Airtable para validación.\");\n allValid = false;\n }\n } else {\n validationMessages.push(\"Destino: No se pudo cargar el registro de Destino de Airtable.\");\n allValid = false;\n }\n\n // 3. Validar Emisor/Receptor (RFC, RegimenFiscal, UsoCFDI, CodigoPostal)\n const validateClientData = async (clientData: any, clientType: string) => {\n if (!clientData) {\n validationMessages.push(`${clientType}: No se pudo cargar el registro de ${clientType} de Airtable.`);\n allValid = false;\n return;\n }\n\n const rfc = clientData.RFC;\n const fiscalRegime = clientData.FiscalRegime;\n const usoCfdi = clientData.UsoCFDI;\n const taxZipCode = clientData.TaxZipCode;\n\n if (!rfc) {\n validationMessages.push(`${clientType}: Falta el campo 'RFC' en Airtable para validación.`);\n allValid = false;\n }\n\n if (fiscalRegime) {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM cfdi_40_regimenes_fiscales WHERE id = ?`,\n args: [fiscalRegime],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`${clientType}: Régimen Fiscal '${fiscalRegime}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(`${clientType}: Falta Régimen Fiscal en Airtable para validación.`);\n allValid = false;\n }\n\n if (usoCfdi) {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM cfdi_40_usos_cfdi WHERE id = ?`,\n args: [usoCfdi],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(`${clientType}: Uso CFDI '${usoCfdi}' no encontrado en el catálogo SAT.`);\n allValid = false;\n }\n } else {\n validationMessages.push(`${clientType}: Falta Uso CFDI en Airtable para validación.`);\n allValid = false;\n }\n\n if (taxZipCode) {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM cfdi_40_codigos_postales WHERE id = ?`,\n args: [taxZipCode],\n file: db,\n });\n if (rows.length === 0) {\n validationMessages.push(\n `${clientType}: Código Postal Fiscal '${taxZipCode}' no encontrado en el catálogo SAT.`,\n );\n allValid = false;\n }\n } else {\n validationMessages.push(`${clientType}: Falta Código Postal Fiscal en Airtable para validación.`);\n allValid = false;\n }\n };\n\n await validateClientData(emisor, \"Emisor\");\n await validateClientData(clienteDestino, \"Cliente Destino\");\n\n // 4. Validar Bienes (SAT_ClaveProdServP, SAT_ClaveUnidadPeso, MaterialPeligroso)\n if (bienes && bienes.length > 0) {\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 validationMessages.push(\n `Bien (ID: ${bien.ID || \"N/A\"}): Falta Clave Producto/Servicio 'SAT_ClaveProdServP' en Airtable.`,\n );\n allValid = false;\n } else {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM ccp_31_productos_servicios WHERE id = ?`,\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 }\n\n if (!unidadKey) {\n validationMessages.push(\n `Bien (ID: ${bien.ID || \"N/A\"}): Falta Clave Unidad 'SAT_ClaveUnidadPeso' en Airtable.`,\n );\n allValid = false;\n } else {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM ccp_31_claves_unidades WHERE id = ?`,\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 }\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 } else {\n validationMessages.push(\"Mercancías: No se encontraron Bienes para validar en Airtable.\");\n allValid = false;\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 validationMessages.push(\"Unidad: Falta Permiso SCT en Airtable para validación.\");\n allValid = false;\n } else {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM ccp_31_tipos_permiso WHERE id = ?`,\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 }\n\n if (!configVehicular) {\n validationMessages.push(\"Unidad: Falta Configuración Vehicular en Airtable para validación.\");\n allValid = false;\n } else {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM ccp_31_configuraciones_autotransporte WHERE id = ?`,\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 }\n\n if (subTipoRem1) {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM ccp_31_tipos_remolque WHERE id = ?`,\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 id FROM ccp_31_tipos_remolque WHERE id = ?`,\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 } else {\n validationMessages.push(\"Autotransporte: No se pudo cargar el registro de la Unidad de Airtable.\");\n allValid = false;\n }\n\n // 6. Validar Operador (TipoFigura)\n if (operador) {\n const tipoFigura = operador.TipoFigura;\n\n if (!tipoFigura) {\n validationMessages.push(\"Operador: Falta Tipo Figura en Airtable para validación.\");\n allValid = false;\n } else {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM ccp_31_figuras_transporte WHERE id = ?`,\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 }\n } else {\n validationMessages.push(\"Operador: No se pudo cargar el registro del Operador de Airtable.\");\n allValid = false;\n }\n\n // 7. Validar Remolque (SubTipoRem) - Si es un campo enlazado, se valida el registro completo\n if (remolque) {\n const subTipoRem = remolque.SubTipoRem;\n const placaRemolque = remolque.Placa;\n\n if (!subTipoRem) {\n validationMessages.push(\"Remolque: Falta SubTipoRem en Airtable para validación.\");\n allValid = false;\n } else {\n const { rows } = await sqlite.execute({\n sql: `SELECT id FROM ccp_31_tipos_remolque WHERE id = ?`,\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 }\n if (!placaRemolque) {\n validationMessages.push(\"Remolque: Falta la Placa en Airtable para validación.\");\n allValid = false;\n }\n } else {\n validationMessages.push(\n \"Remolque: No se pudo cargar el registro del Remolque de Airtable (o no se seleccionó ninguno).\",\n );\n }\n\n // Actualizar registro en Airtable con el estado y los mensajes de validació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 // Intentar actualizar Airtable incluso si hay un error global\n try {\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n \"SAT_Validation_Status\": \"Error\",\n \"SAT_Validation_Messages\": `Error crítico: ${error.message}`,\n });\n } catch (updateError: any) {\n console.error(`❌ Error al actualizar Airtable con el mensaje de error: ${updateError.message}`);\n }\n return new Response(JSON.stringify({ error: error.message || \"Error inesperado durante la validación\" }), {\n status: 500,\n });\n }\n}","arequipegemini",[],[181],{"_105":191,"_97":192,"_161":193,"_163":-5,"_164":146,"_165":194,"_167":22,"_107":195,"_101":196,"_170":171,"_172":197,"_174":22,"_175":-5,"_176":198,"_100":199},"63006258-4c8a-11f0-a1e2-76b3cceeab13","ValidationCatalogGrok.tsx","2d451bc4-467a-11f0-83b8-76b3cceeab13",107,["D",1750281769857],27,"import { Airtable } from \"https://deno.land/x/airtable@v1.1.1/mod.ts\";\nimport initSqlJs from \"https://esm.sh/sql.js@1.10.3\";\nimport { blob } from \"https://esm.town/v/std/blob\";\n\n// Load environment variables\nconst apiKey = Deno.env.get(\"AIRTABLE_API_KEY\")!;\nconst baseId = Deno.env.get(\"AIRTABLE_BASE_ID\")!;\nconst tableName = Deno.env.get(\"VIAJES_TABLE\")!;\n\nexport default async (req: Request): Promise => {\n const url = new URL(req.url);\n const recordId = url.searchParams.get(\"recordId\");\n\n if (!recordId) {\n return new Response(\"Missing recordId\", { status: 400 });\n }\n\n // Connect to Airtable\n const airtable = new Airtable({ apiKey, baseId, tableName });\n const record = await airtable.find(recordId);\n if (!record) {\n return new Response(\"Record not found\", { status: 404 });\n }\n\n const fields = record.fields;\n const mensajes: string[] = [];\n\n // Load SQLite from blob\n const blobResp = await blob.get(\"sat-catalogs.db\");\n if (!blobResp) {\n return new Response(\"SAT DB blob not found\", { status: 500 });\n }\n\n const binary = new Uint8Array(await blobResp.arrayBuffer());\n const SQL = await initSqlJs();\n const db = new SQL.Database(binary);\n\n // Helper: Validate SQL query returns a result\n const validate = (sql: string, values: any[], errorMessage: string) => {\n const stmt = db.prepare(sql);\n stmt.bind(values);\n if (!stmt.step()) {\n mensajes.push(errorMessage);\n }\n stmt.free();\n };\n\n // === VALIDACIONES ===\n\n // Código Postal\n if (fields.CodigoPostalOrigen) {\n validate(\n `SELECT 1 FROM cfdi_40_codigos_postales WHERE codigo_postal = ?`,\n [fields.CodigoPostalOrigen],\n `Código Postal Origen inválido: ${fields.CodigoPostalOrigen}`,\n );\n }\n\n if (fields.CodigoPostalDestino) {\n validate(\n `SELECT 1 FROM cfdi_40_codigos_postales WHERE codigo_postal = ?`,\n [fields.CodigoPostalDestino],\n `Código Postal Destino inválido: ${fields.CodigoPostalDestino}`,\n );\n }\n\n // Estado/Municipio\n if (fields.CodigoEstadoOrigen && fields.CodigoMunicipioOrigen) {\n validate(\n `SELECT 1 FROM cfdi_40_municipios WHERE c_Estado = ? AND c_Municipio = ?`,\n [fields.CodigoEstadoOrigen, fields.CodigoMunicipioOrigen],\n `Estado/Municipio Origen inválido: ${fields.CodigoEstadoOrigen}/${fields.CodigoMunicipioOrigen}`,\n );\n }\n\n if (fields.CodigoEstadoDestino && fields.CodigoMunicipioDestino) {\n validate(\n `SELECT 1 FROM cfdi_40_municipios WHERE c_Estado = ? AND c_Municipio = ?`,\n [fields.CodigoEstadoDestino, fields.CodigoMunicipioDestino],\n `Estado/Municipio Destino inválido: ${fields.CodigoEstadoDestino}/${fields.CodigoMunicipioDestino}`,\n );\n }\n\n // Colonia\n if (fields.CodigoPostalOrigen && fields.CodigoColoniaOrigen) {\n validate(\n `SELECT 1 FROM cfdi_40_colonias WHERE c_CodigoPostal = ? AND c_Colonia = ?`,\n [fields.CodigoPostalOrigen, fields.CodigoColoniaOrigen],\n `Colonia Origen inválida: ${fields.CodigoColoniaOrigen}`,\n );\n }\n\n if (fields.CodigoPostalDestino && fields.CodigoColoniaDestino) {\n validate(\n `SELECT 1 FROM cfdi_40_colonias WHERE c_CodigoPostal = ? AND c_Colonia = ?`,\n [fields.CodigoPostalDestino, fields.CodigoColoniaDestino],\n `Colonia Destino inválida: ${fields.CodigoColoniaDestino}`,\n );\n }\n\n // Régimen Fiscal\n if (fields.RegimenFiscal) {\n validate(\n `SELECT 1 FROM cfdi_40_regimenes_fiscales WHERE c_RegimenFiscal = ?`,\n [fields.RegimenFiscal],\n `Régimen Fiscal inválido: ${fields.RegimenFiscal}`,\n );\n }\n\n // Uso CFDI\n if (fields.UsoCFDI) {\n validate(\n `SELECT 1 FROM cfdi_40_usos_cfdi WHERE c_UsoCFDI = ?`,\n [fields.UsoCFDI],\n `Uso CFDI inválido: ${fields.UsoCFDI}`,\n );\n }\n\n // Clave Producto/Servicio\n if (fields.ClaveProdServ) {\n validate(\n `SELECT 1 FROM ccp_31_productos_servicios WHERE c_ClaveProdServ = ?`,\n [fields.ClaveProdServ],\n `Clave Producto/Servicio inválida: ${fields.ClaveProdServ}`,\n );\n }\n\n // Clave Unidad\n if (fields.ClaveUnidad) {\n validate(\n `SELECT 1 FROM ccp_31_claves_unidades WHERE c_ClaveUnidad = ?`,\n [fields.ClaveUnidad],\n `Clave Unidad inválida: ${fields.ClaveUnidad}`,\n );\n }\n\n // Tipo Permiso\n if (fields.TipoPermiso) {\n validate(\n `SELECT 1 FROM ccp_31_tipos_permiso WHERE c_TipoPermiso = ?`,\n [fields.TipoPermiso],\n `Tipo Permiso inválido: ${fields.TipoPermiso}`,\n );\n }\n\n // Configuración Autotransporte\n if (fields.ConfigAutotransporte) {\n validate(\n `SELECT 1 FROM ccp_31_configuraciones_autotransporte WHERE c_Configuracion = ?`,\n [fields.ConfigAutotransporte],\n `Config. Autotransporte inválida: ${fields.ConfigAutotransporte}`,\n );\n }\n\n // Tipo Remolque\n if (fields.TipoRemolque) {\n validate(\n `SELECT 1 FROM ccp_31_tipos_remolque WHERE c_TipoRem = ?`,\n [fields.TipoRemolque],\n `Tipo Remolque inválido: ${fields.TipoRemolque}`,\n );\n }\n\n // Figura Transporte\n if (fields.FiguraTransporte) {\n validate(\n `SELECT 1 FROM ccp_31_figuras_transporte WHERE c_Figura = ?`,\n [fields.FiguraTransporte],\n `Figura Transporte inválida: ${fields.FiguraTransporte}`,\n );\n }\n\n // === Update Airtable ===\n const isValid = mensajes.length === 0;\n await airtable.update(recordId, {\n SAT_Validation_Status: isValid ? \"Válido\" : \"Inválido\",\n SAT_Validation_Messages: mensajes.join(\"; \"),\n });\n\n // Return visible response\n return new Response(\n JSON.stringify(\n {\n recordId,\n status: isValid ? \"Válido\" : \"Inválido\",\n errores: mensajes,\n },\n null,\n 2,\n ),\n {\n status: isValid ? 200 : 400,\n headers: { \"content-type\": \"application/json\" },\n },\n );\n};",[],[192],{"_105":201,"_97":202,"_161":203,"_163":-5,"_164":146,"_165":204,"_167":22,"_107":205,"_101":206,"_170":171,"_172":207,"_174":22,"_175":-5,"_176":208,"_100":209},"041fddb2-4bfa-11f0-bfff-76b3cceeab13","arequipe_uploadBlobProxy.tsx","b68279e4-4b80-11f0-a820-76b3cceeab13",90,["D",1750219763145],7,"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 // CORRECCIÓN: Usando blob.set() en lugar de blob.save()\n // blob.set() sobrescribe automáticamente si el blob ya existe con el mismo nombre.\n await blob.set(blobName, arrayBuffer);\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}",[],[202],{"_105":211,"_97":212,"_161":213,"_163":-5,"_164":146,"_165":214,"_167":22,"_107":215,"_101":216,"_170":171,"_172":217,"_174":22,"_175":-5,"_176":218,"_100":219},"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}",[],[212],{"_105":221,"_97":222,"_161":223,"_163":-5,"_164":146,"_165":224,"_167":22,"_107":225,"_101":33,"_170":226,"_172":74,"_174":22,"_175":-5,"_176":227,"_100":228},"8bb02e64-4c75-11f0-914b-76b3cceeab13","new-file-4982.tsx","8bb02f0e-4c75-11f0-914b-76b3cceeab13",94,["D",1750272818689],"script",[],[222],{"_105":230,"_97":231,"_161":232,"_163":-5,"_164":146,"_165":102,"_167":22,"_107":233,"_101":234,"_170":171,"_172":235,"_174":22,"_175":-5,"_176":236,"_100":237},"3c20e7e8-4c94-11f0-9107-76b3cceeab13","new-file-6367.tsx","94d008c0-4c75-11f0-938e-76b3cceeab13",["D",1750285999605],2,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function listSatCatalogTables() {\n const BLOB_NAME = \"sat-catalogs.db\";\n let responseMessage = \"\";\n\n try {\n console.log(`Intentando acceder al blob '${BLOB_NAME}'...`);\n const db = await blob.get(BLOB_NAME);\n\n if (!db) {\n responseMessage = `❌ Error: El blob '${BLOB_NAME}' no fue encontrado en tu almacenamiento de Val Town.`;\n console.error(responseMessage);\n return new Response(JSON.stringify({ error: responseMessage }), { status: 404 });\n }\n\n console.log(`Blob '${BLOB_NAME}' cargado. Consultando tablas...`);\n // Consulta SQL para obtener todos los nombres de tabla del esquema\n const { rows } = await sqlite.execute({\n sql: \"SELECT name FROM sqlite_master WHERE type='table';\",\n args: [], // Argumentos vacíos, ya que no hay parámetros en la consulta.\n file: db,\n });\n\n if (rows.length === 0) {\n responseMessage = `⚠️ Advertencia: El blob '${BLOB_NAME}' no contiene tablas.`;\n console.warn(responseMessage);\n return new Response(JSON.stringify({ message: responseMessage, tables: [] }), { status: 200 });\n }\n\n const tableNames = rows.map(row => row.name);\n responseMessage = `✅ Tablas encontradas en '${BLOB_NAME}':\\n${tableNames.join(\"\\n\")}`;\n console.log(responseMessage);\n\n return new Response(JSON.stringify({ message: \"Tablas listadas exitosamente\", tables: tableNames }), {\n status: 200,\n });\n } catch (error: any) {\n responseMessage = `❌ Error al listar tablas del blob '${BLOB_NAME}': ${error.message}`;\n console.error(responseMessage);\n return new Response(JSON.stringify({ error: responseMessage }), { status: 500 });\n }\n}",[],[231],{"_105":239,"_97":240,"_161":241,"_163":-5,"_164":146,"_165":242,"_167":22,"_107":243,"_101":234,"_170":171,"_172":235,"_174":22,"_175":-5,"_176":244,"_100":245},"c234a19e-4c8a-11f0-a1e2-76b3cceeab13","new-file-7566.tsx","9377d6b0-4c75-11f0-80fd-76b3cceeab13",109,["D",1750281929582],[],[240],{"_105":247,"_97":248,"_161":249,"_163":-5,"_164":146,"_165":250,"_167":22,"_107":251,"_101":214,"_170":252,"_172":253,"_174":22,"_175":-5,"_176":254,"_100":255},"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}",[],[248],{"_105":257,"_97":258,"_161":259,"_163":-5,"_164":146,"_165":260,"_167":22,"_107":261,"_101":262,"_170":171,"_172":263,"_174":22,"_175":-5,"_176":264,"_100":265},"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}",[],[258],{"_105":267,"_97":268,"_161":269,"_163":-5,"_164":146,"_165":270,"_167":22,"_107":271,"_101":262,"_170":252,"_172":272,"_174":22,"_175":-5,"_176":273,"_100":274},"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}",[],[268],{"_105":276,"_97":277,"_161":278,"_163":-5,"_164":146,"_165":279,"_167":119,"_107":280,"_101":281,"_170":171,"_172":282,"_174":22,"_175":96,"_176":283,"_100":284},"928f34de-4b1a-11f0-986e-76b3cceeab13","uploadblob.tsx","6fd1500a-47ad-11f0-ad1b-76b3cceeab13",82,["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}",[],[277],"files",[158,179,190,200,210,220,229,238,246,256,266,275],"counts",{"_289":33,"_290":291,"_292":33,"_293":294,"_297":298},"pulls","branches",1,"forks","envVars",{"_295":281,"_296":33},"count","emptyCount","connections",{"_295":33,"_299":33},"unfilledCount","contents",[302,305,308,311,314,317,320,323,326,329,332,335],{"_105":159,"_97":160,"_161":162,"_163":-5,"_164":146,"_165":166,"_167":22,"_107":303,"_101":169,"_170":171,"_172":173,"_174":22,"_175":-5,"_100":304},["D",1749837136051],[160],{"_105":180,"_97":181,"_161":182,"_163":-5,"_164":146,"_165":183,"_167":22,"_107":306,"_101":185,"_170":171,"_172":186,"_174":22,"_175":187,"_100":307},["D",1750285571886],[181],{"_105":191,"_97":192,"_161":193,"_163":-5,"_164":146,"_165":194,"_167":22,"_107":309,"_101":196,"_170":171,"_172":197,"_174":22,"_175":-5,"_100":310},["D",1750281769857],[192],{"_105":201,"_97":202,"_161":203,"_163":-5,"_164":146,"_165":204,"_167":22,"_107":312,"_101":206,"_170":171,"_172":207,"_174":22,"_175":-5,"_100":313},["D",1750219763145],[202],{"_105":211,"_97":212,"_161":213,"_163":-5,"_164":146,"_165":214,"_167":22,"_107":315,"_101":216,"_170":171,"_172":217,"_174":22,"_175":-5,"_100":316},["D",1748977082042],[212],{"_105":221,"_97":222,"_161":223,"_163":-5,"_164":146,"_165":224,"_167":22,"_107":318,"_101":33,"_170":226,"_172":74,"_174":22,"_175":-5,"_100":319},["D",1750272818689],[222],{"_105":230,"_97":231,"_161":232,"_163":-5,"_164":146,"_165":102,"_167":22,"_107":321,"_101":234,"_170":171,"_172":235,"_174":22,"_175":-5,"_100":322},["D",1750285999605],[231],{"_105":239,"_97":240,"_161":241,"_163":-5,"_164":146,"_165":242,"_167":22,"_107":324,"_101":234,"_170":171,"_172":235,"_174":22,"_175":-5,"_100":325},["D",1750281929582],[240],{"_105":247,"_97":248,"_161":249,"_163":-5,"_164":146,"_165":250,"_167":22,"_107":327,"_101":214,"_170":252,"_172":253,"_174":22,"_175":-5,"_100":328},["D",1750121609667],[248],{"_105":257,"_97":258,"_161":259,"_163":-5,"_164":146,"_165":260,"_167":22,"_107":330,"_101":262,"_170":171,"_172":263,"_174":22,"_175":-5,"_100":331},["D",1749658248490],[258],{"_105":267,"_97":268,"_161":269,"_163":-5,"_164":146,"_165":270,"_167":22,"_107":333,"_101":262,"_170":252,"_172":272,"_174":22,"_175":-5,"_100":334},["D",1749835912365],[268],{"_105":276,"_97":277,"_161":278,"_163":-5,"_164":146,"_165":279,"_167":119,"_107":336,"_101":281,"_170":171,"_172":282,"_174":22,"_175":96,"_100":337},["D",1750123794847],[277],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_103":347,"_101":102,"_352":353},{"_105":106,"_97":98,"_107":348,"_109":-5,"_110":22,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":117,"_118":119,"_120":119,"_121":-5,"_122":33,"_16":123,"_124":-5,"_125":-5,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":349,"_138":350,"_143":351,"_155":22},["D",1748976966452],{"_95":96,"_136":137},{"_95":96,"_140":137,"_14":115,"_141":142},{"_101":145,"_97":45,"_105":146,"_147":106,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},"changes",[354],{"_338":355,"_357":358,"_174":119,"_100":231,"_359":231},{"_161":232,"_97":231,"_170":171,"_172":235,"_107":356,"_165":102,"_164":146},["D",1750285999605],"previous",{"_161":232,"_97":231,"_170":226,"_172":235},"latestPath","actionData","errors"]