[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":37,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":25,"_119":120,"_121":122,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":37,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",12,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","refs.ts","latestPath","fileId","458774d2-6354-11f1-8d98-1607ee4eb77e","name","new-file-3217.ts","fileType","script","content","","createdAt",["D",1780934907400],"branchVersion","branchId","923a67f8-555b-41c8-ae77-3aa7665e843e","id","b5f14c9f-72a6-475f-9bd8-e8cd05e449b0","data-inpi",["D",1780579259355],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019b4a6f-acf9-72bd-bb4b-4e73c81fa54c","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019b4a6f-acf9-72bd-bb4b-508df4b6ead2","tursoName","b5f14c9f72a6475f9bd8e8cd05e449b0","tursoHostname","b5f14c9f72a6475f9bd8e8cd05e449b0-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789489305251],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","thomala","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM3RXU1d1VJZ3IzZGdQcXNNT2lYa0l0cTYzSCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":165,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":37,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":166,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":167,"_81":168,"_83":169,"_85":25},"tree",[156,157],"files",[156,157],"counts",{"_145":60,"_146":133,"_147":60,"_148":149,"_150":151},"contents",[127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":140,"_13":141,"_34":142,"_36":143,"_24":25,"_134":-5,"_27":144},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":132,"_13":133,"_34":35,"_36":37,"_24":25,"_134":-5,"_27":135},"b628d76b-a2c8-40e9-8c60-aac99e9ca74a","parentId","latest",["D",1780934907400],1,"label",[28],"bdfc8be5-9e8e-4c6f-af29-117d20a41501","main.ts","3a0139a2-6018-11f1-b61d-1607ee4eb77e",10,["D",1780934890981],9,"http","import { Hono } from \"npm:hono@4\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { FORME_JURIDIQUE, ROLE } from \"./refs.ts\";\n\nconst app = new Hono();\n\nconst INPI_BASE = \"https://registre-national-entreprises.inpi.fr/api\";\nconst INPI_USERNAME = Deno.env.get(\"INPI_USERNAME\")!;\nconst INPI_PASSWORD = Deno.env.get(\"INPI_PASSWORD\")!;\nconst FETCH_TIMEOUT_MS = 20_000;\nconst CACHE_TTL_MS = 30 * 24 * 60 * 60 * 1000; // 30 jours\n\nconst ALLOWED_GET = [\n /^\\/companies$/,\n /^\\/companies\\/\\d{9}$/,\n /^\\/companies\\/\\d{9}\\/attachments$/,\n /^\\/bilans\\/[\\w-]+$/,\n /^\\/bilans\\/[\\w-]+\\/download$/,\n /^\\/bilans-saisis\\/[\\w-]+$/,\n];\n\n// ===================== SQLITE : 2 domaines (identité + comptes) =====================\nlet dbReady: Promise | null = null;\nasync function dbInit() {\n // Fiche identité RNE + sert d'index de recherche par nom\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS inpi_company (\n siren TEXT PRIMARY KEY, denomination TEXT, code_naf TEXT, forme_juridique TEXT,\n payload TEXT, updated_at INTEGER)`);\n // Comptes annuels (financials) par siren+scope\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS inpi_fin_cache (\n key TEXT PRIMARY KEY, siren TEXT, scope TEXT, payload TEXT, updated_at INTEGER)`);\n}\nconst ensureDb = () => (dbReady ??= dbInit());\n\nconst strip = (o: any) => {\n const { _status, ...rest } = o;\n return rest;\n};\n\n// ===================== AUTH INPI : token JWT + singleflight =====================\nlet cachedToken: string | null = null;\nlet tokenExpiry = 0;\nlet tokenPromise: Promise | null = null;\n\nfunction jwtExpiryMs(token: string): number {\n try {\n const part = token.split(\".\")[1].replace(/-/g, \"+\").replace(/_/g, \"/\");\n const b64 = part + \"=\".repeat((4 - (part.length % 4)) % 4);\n const exp = JSON.parse(atob(b64)).exp;\n if (typeof exp === \"number\") return exp * 1000;\n } catch { /* fallback */ }\n return Date.now() + 23 * 60 * 60 * 1000;\n}\n\nasync function fetchWithTimeout(\n url: string,\n init: RequestInit,\n): Promise {\n const ctrl = new AbortController();\n const t = setTimeout(() => ctrl.abort(), FETCH_TIMEOUT_MS);\n try {\n return await fetch(url, { ...init, signal: ctrl.signal });\n } finally {\n clearTimeout(t);\n }\n}\n\nasync function login(): Promise {\n const res = await fetchWithTimeout(`${INPI_BASE}/sso/login`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ username: INPI_USERNAME, password: INPI_PASSWORD }),\n });\n if (!res.ok) {\n throw new Error(\n `INPI login ${res.status}: ${(await res.text()).slice(0, 200)}`,\n );\n }\n const data = await res.json();\n if (!data?.token) throw new Error(\"INPI login: champ 'token' absent\");\n cachedToken = data.token as string;\n tokenExpiry = jwtExpiryMs(cachedToken);\n return cachedToken;\n}\n\nasync function getInpiToken(force = false): Promise {\n const now = Date.now();\n if (!force && cachedToken && now < tokenExpiry - 5 * 60 * 1000) {\n return cachedToken;\n }\n if (!tokenPromise) {\n tokenPromise = login().finally(() => {\n tokenPromise = null;\n });\n }\n return tokenPromise;\n}\n\nasync function callInpi(path: string, search: string): Promise {\n const url = `${INPI_BASE}${path}${search}`;\n const h = (tok: string) => ({\n \"Authorization\": `Bearer ${tok}`,\n \"User-Agent\": \"8Advisory-Test\",\n });\n let res = await fetchWithTimeout(url, { headers: h(await getInpiToken()) });\n if (res.status === 401) {\n res = await fetchWithTimeout(url, { headers: h(await getInpiToken(true)) });\n }\n return res;\n}\n\napp.get(\"/\", (c) =>\n c.json({\n ok: true,\n usage:\n \"/inpi/lookup/{nom|siren}[?scope=social|conso&refresh=1] | /inpi/company/{siren} | /inpi/financials/{siren} | /inpi/search/{nom} | /inpi/cache/search/{nom}\",\n }));\n\n// ===================== DOMAINE 1 : IDENTITÉ (fiche RNE) =====================\n// Extraction best-effort selon structure RNE personneMorale (à confirmer au 1er test).\nfunction buildIdentity(data: any, siren: string) {\n const root = Array.isArray(data) ? data[0] : data;\n const pm = root?.formality?.content?.personneMorale ?? {};\n const ent = pm.identite?.entreprise ?? {};\n const desc = pm.identite?.description ?? {};\n const a = pm.adresseEntreprise?.adresse ?? {};\n const adresse =\n [a.numVoie, a.typeVoie, a.voie, a.codePostal, a.commune].filter(Boolean)\n .join(\" \") || null;\n const dirigeants = (pm.composition?.pouvoirs ?? []).map((p: any) => {\n const role = p.roleEntreprise ?? null;\n const roleLabel = role != null ? (ROLE[String(role)] ?? null) : null;\n const ind = p.individu?.descriptionPersonne;\n if (ind) {\n return {\n type: \"personne\",\n nom: ind.nom ?? null,\n prenoms: (ind.prenoms ?? []).join(\" \") || null,\n role,\n roleLabel,\n };\n }\n const e = p.entreprise;\n if (e) {\n return {\n type: \"entreprise\",\n denomination: e.denomination ?? null,\n siren: e.siren ?? null,\n role,\n roleLabel,\n };\n }\n return null;\n }).filter(Boolean);\n const fj = ent.formeJuridique ?? null;\n return {\n siren,\n denomination: ent.denomination ?? null,\n sigle: ent.sigle ?? null,\n formeJuridique: fj,\n formeJuridiqueLabel: fj != null\n ? (FORME_JURIDIQUE[String(fj)] ?? null)\n : null,\n codeNaf: ent.codeApe ?? null,\n capital: desc.montantCapital ?? null,\n deviseCapital: desc.deviseCapital ?? null,\n dateImmatriculation: ent.dateImmat ?? null,\n adresse,\n dirigeants,\n };\n}\n\nasync function getCompany(siren: string, refresh: boolean) {\n await ensureDb();\n if (!refresh) {\n const cached = await sqlite.execute({\n sql:\n \"SELECT payload, updated_at FROM inpi_company WHERE siren = ? AND payload IS NOT NULL\",\n args: [siren],\n });\n const row = (cached.rows as any[])[0];\n if (row && Date.now() - Number(row[1]) < CACHE_TTL_MS) {\n return {\n ...JSON.parse(row[0] as string),\n cached: true,\n dateMaj: new Date(Number(row[1])).toISOString(),\n };\n }\n }\n let res: Response;\n try {\n res = await callInpi(`/companies/${siren}`, \"\");\n } catch (e) {\n console.error(e);\n return { _status: 502, error: \"INPI KO\" };\n }\n if (res.status === 429) {\n return { _status: 429, error: \"Quota journalier INPI dépassé\" };\n }\n if (!res.ok) return { _status: res.status, error: `INPI ${res.status}` };\n\n const data = await res.json();\n const ident = buildIdentity(data, siren);\n const now = Date.now();\n try {\n await sqlite.execute({\n sql:\n `INSERT INTO inpi_company(siren, denomination, code_naf, forme_juridique, payload, updated_at)\n VALUES(?,?,?,?,?,?)\n ON CONFLICT(siren) DO UPDATE SET denomination=excluded.denomination, code_naf=excluded.code_naf,\n forme_juridique=excluded.forme_juridique, payload=excluded.payload, updated_at=excluded.updated_at`,\n args: [\n siren,\n ident.denomination,\n ident.codeNaf,\n ident.formeJuridique,\n JSON.stringify(ident),\n now,\n ],\n });\n } catch (e) {\n console.error(\"identity cache write failed:\", e);\n }\n return { ...ident, cached: false, dateMaj: new Date(now).toISOString() };\n}\n\n// ===================== DOMAINE 2 : COMPTES ANNUELS (doc v5 §E) =====================\nconst FINANCIAL_KEYS = [\n \"ca\",\n \"produitsExploitation\",\n \"chargesExploitation\",\n \"resultatExploitation\",\n \"resultatFinancier\",\n \"resultatCourant\",\n \"resultatExceptionnel\",\n \"impotBenefices\",\n \"resultatNet\",\n \"actifImmobilise\",\n \"actifCirculant\",\n \"totalActif\",\n \"capitalSocial\",\n \"capitauxPropres\",\n \"provisions\",\n \"dettesFiscalesSociales\",\n \"empruntsDettesFin\",\n \"totalDettes\",\n \"totalPassif\",\n];\n\nconst MAP: Record> = {\n C: {\n ca: { page: \"03\", code: \"FJ\", col: \"m3\" },\n produitsExploitation: { page: \"03\", code: \"FR\", col: \"m3\" },\n chargesExploitation: { page: \"03\", code: \"GF\", col: \"m3\" },\n resultatExploitation: { page: \"03\", code: \"GG\", col: \"m3\" },\n resultatFinancier: { page: \"03\", code: \"GV\", col: \"m3\" },\n resultatCourant: { page: \"03\", code: \"GW\", col: \"m3\" },\n resultatExceptionnel: { page: \"04\", code: \"HI\", col: \"m1\" },\n impotBenefices: { page: \"04\", code: \"HK\", col: \"m1\" },\n resultatNet: {\n page: \"04\",\n code: \"HN\",\n col: \"m1\",\n fallback: { page: \"02\", code: \"DI\", col: \"m1\" },\n },\n actifImmobilise: {\n page: \"01\",\n code: \"BJ\",\n col: \"m3\",\n altCol: \"m1\",\n positive: true,\n },\n actifCirculant: {\n page: \"01\",\n code: \"CJ\",\n col: \"m3\",\n altCol: \"m1\",\n positive: true,\n },\n totalActif: {\n page: \"01\",\n code: \"CO\",\n col: \"m3\",\n altCol: \"m1\",\n positive: true,\n },\n capitalSocial: { page: \"02\", code: \"DA\", col: \"m1\" },\n capitauxPropres: { page: \"02\", code: \"DL\", col: \"m1\" },\n provisions: { page: \"02\", code: \"DR\", col: \"m1\" },\n dettesFiscalesSociales: { page: \"02\", code: \"DY\", col: \"m1\" },\n empruntsDettesFin: { page: \"02\", code: \"DU\", col: \"m1\" },\n totalDettes: { page: \"02\", code: \"EC\", col: \"m1\" },\n totalPassif: { page: \"02\", code: \"EE\", col: \"m1\" },\n },\n S: {\n ca: { page: \"02\", code: \"232\", col: \"m1\" },\n produitsExploitation: { page: \"02\", code: \"232\", col: \"m1\" },\n resultatExploitation: { page: \"02\", code: \"270\", col: \"m1\" },\n resultatNet: {\n page: \"02\",\n code: \"310\",\n col: \"m1\",\n fallback: { page: \"01\", code: \"136\", col: \"m3\" },\n },\n totalActif: {\n page: \"01\",\n code: \"110\",\n col: \"m3\",\n altCol: \"m1\",\n positive: true,\n },\n capitauxPropres: { page: \"01\", code: \"142\", col: \"m3\" },\n empruntsDettesFin: { page: \"01\", code: \"156\", col: \"m3\" },\n },\n K: {},\n};\n\nconst norm2 = (n: any) => String(n ?? \"\").padStart(2, \"0\");\n\nfunction getLiasse(\n pages: any[],\n page: string,\n code: string,\n col: string,\n): number | null {\n const p = pages?.find((x) => norm2(x.numero) === norm2(page));\n const l = p?.liasses?.find((x: any) => x.code === code);\n const v = l?.[col];\n if (v == null || v === \"\") return null;\n const n = parseInt(v, 10);\n return Number.isFinite(n) ? n : null;\n}\n\nfunction resolveLiasse(pages: any[], spec: any): number | null {\n if (!spec) return null;\n let v = getLiasse(pages, spec.page, spec.code, spec.col);\n if ((v == null || (spec.positive && v <= 0)) && spec.altCol) {\n const alt = getLiasse(pages, spec.page, spec.code, spec.altCol);\n if (alt != null && (!spec.positive || alt > 0)) v = alt;\n }\n if ((v == null || (spec.positive && v <= 0)) && spec.fallback) {\n const fb = resolveLiasse(pages, spec.fallback);\n if (fb != null) v = fb;\n }\n return v;\n}\n\nfunction extractIndic(pages: any[], type: string) {\n const m = MAP[type] ?? MAP.C;\n const out: Record = {};\n for (const k of FINANCIAL_KEYS) out[k] = resolveLiasse(pages, m[k]);\n return out;\n}\n\nfunction normalizeUnits(exos: any[]) {\n const cas = exos.map((e) => e.ca).filter((x) => x && x > 0).sort((a, b) =>\n a - b\n );\n if (cas.length < 2) {\n return exos.map((e) => ({ ...e, uniteNormalisee: false }));\n }\n const median = cas[Math.floor(cas.length / 2)];\n return exos.map((e) => {\n if (e.ca && median / e.ca > 100) {\n const s: any = { ...e };\n for (const k of FINANCIAL_KEYS) if (s[k] != null) s[k] *= 1000;\n return { ...s, uniteNormalisee: true };\n }\n return { ...e, uniteNormalisee: false };\n });\n}\n\nfunction selectBilans(saisis: any[], scope: string) {\n const allowed = scope === \"conso\" ? [\"K\"] : [\"C\", \"S\"];\n const prio: Record = { C: 0, S: 1, K: 0 };\n const byDate = new Map();\n for (const b of saisis) {\n if (b.deleted || !allowed.includes(b.typeBilan)) continue;\n const cur = byDate.get(b.dateCloture);\n if (!cur || (prio[b.typeBilan] ?? 9) < (prio[cur.typeBilan] ?? 9)) {\n byDate.set(b.dateCloture, b);\n }\n }\n return [...byDate.values()]\n .sort((a, b) => (b.dateCloture || \"\").localeCompare(a.dateCloture || \"\"))\n .slice(0, 5);\n}\n\nasync function getFinancials(\n siren: string,\n scope: string,\n origin: string,\n refresh: boolean,\n) {\n await ensureDb();\n const key = `${siren}_${scope}`;\n if (!refresh) {\n const cached = await sqlite.execute({\n sql: \"SELECT payload, updated_at FROM inpi_fin_cache WHERE key = ?\",\n args: [key],\n });\n const row = (cached.rows as any[])[0];\n if (row && Date.now() - Number(row[1]) < CACHE_TTL_MS) {\n return {\n ...JSON.parse(row[0] as string),\n cached: true,\n dateMaj: new Date(Number(row[1])).toISOString(),\n };\n }\n }\n let res: Response;\n try {\n res = await callInpi(`/companies/${siren}/attachments`, \"\");\n } catch (e) {\n console.error(e);\n return { _status: 502, error: \"INPI KO\" };\n }\n if (res.status === 429) {\n return { _status: 429, error: \"Quota journalier INPI dépassé\" };\n }\n if (!res.ok) return { _status: res.status, error: `INPI ${res.status}` };\n\n const data = await res.json();\n const selected = selectBilans(data.bilansSaisis ?? [], scope);\n let exercices = selected.map((b: any) => {\n const bilan = b.bilanSaisi?.bilan ?? {};\n const id = bilan.identite ?? {};\n const pages = bilan.detail?.pages ?? [];\n const fiable = b.typeBilan !== \"K\";\n const ind = fiable\n ? extractIndic(pages, b.typeBilan)\n : Object.fromEntries(FINANCIAL_KEYS.map((k) => [k, null]));\n return {\n dateCloture: b.dateCloture,\n typeBilan: b.typeBilan,\n devise: id.codeDevise ?? \"EUR\",\n dureeExerciceMois: Number(id.dureeExerciceN) || null,\n codeConfidentialite: id.codeConfidentialite ?? b.confidentiality ?? null,\n bilanId: b.id ?? null,\n pdfUrl: b.id ? `${origin}/inpi/bilans/${b.id}/download` : null,\n fiable,\n ...ind,\n };\n });\n const fiables = normalizeUnits(exercices.filter((e: any) => e.fiable));\n exercices = fiables.concat(exercices.filter((e: any) => !e.fiable));\n\n const first = selected[0]?.bilanSaisi?.bilan?.identite ?? {};\n const out: any = {\n siren,\n scope,\n denomination: first.denomination ?? null,\n codeNaf: first.codeActivite ?? null,\n note: scope === \"conso\"\n ? \"Comptes consolidés en format libre : valeurs non fiables, voir PDF (pdfUrl).\"\n : undefined,\n exercices,\n };\n const now = Date.now();\n try {\n await sqlite.execute({\n sql:\n `INSERT INTO inpi_fin_cache(key, siren, scope, payload, updated_at) VALUES(?,?,?,?,?)\n ON CONFLICT(key) DO UPDATE SET payload=excluded.payload, updated_at=excluded.updated_at`,\n args: [key, siren, scope, JSON.stringify(out), now],\n });\n // alimente l'index de recherche sans écraser la fiche identité éventuelle\n if (out.denomination) {\n await sqlite.execute({\n sql:\n `INSERT INTO inpi_company(siren, denomination, code_naf, updated_at) VALUES(?,?,?,?)\n ON CONFLICT(siren) DO UPDATE SET denomination=excluded.denomination, code_naf=excluded.code_naf, updated_at=excluded.updated_at`,\n args: [siren, out.denomination, out.codeNaf, now],\n });\n }\n } catch (e) {\n console.error(\"fin cache write failed:\", e);\n }\n return { ...out, cached: false, dateMaj: new Date(now).toISOString() };\n}\n\n// Recherche live INPI -> candidats triés (match exact d'abord)\nasync function searchInpi(q: string) {\n const res = await callInpi(\n `/companies`,\n `?companyName=${encodeURIComponent(q)}&pageSize=20`,\n );\n if (!res.ok) return { _status: res.status, candidates: [] as any[] };\n const data = await res.json();\n const list = Array.isArray(data) ? data : (data.items ?? data.results ?? []);\n let candidates = list.map((e: any) => {\n const pm = e?.formality?.content?.personneMorale?.identite ?? {};\n const ent = pm.entreprise ?? {};\n return {\n siren: e.siren ?? e?.formality?.siren ?? null,\n denomination: ent.denomination ?? pm.denomination ?? null,\n codeNaf: ent.codeApe ?? null,\n formeJuridique: ent.formeJuridique ?? null,\n };\n });\n const qn = q.trim().toUpperCase();\n const score = (r: any) => {\n const d = (r.denomination || \"\").toUpperCase();\n return d === qn ? 3 : d.startsWith(qn) ? 2 : d.includes(qn) ? 1 : 0;\n };\n candidates = candidates.sort((a, b) => score(b) - score(a)).slice(0, 10);\n return { candidates };\n}\n\n// Résout un input (siren ou nom) -> { siren, resolvedFrom } ou { candidates } (désambiguïsation)\nasync function resolveSiren(q: string) {\n if (/^\\d{9}$/.test(q)) return { siren: q, resolvedFrom: \"siren\" };\n const qn = q.toUpperCase();\n const hit = await sqlite.execute({\n sql: \"SELECT siren FROM inpi_company WHERE UPPER(denomination) = ? LIMIT 2\",\n args: [qn],\n });\n const hRows = hit.rows as any[];\n if (hRows.length === 1) {\n return { siren: hRows[0][0] as string, resolvedFrom: \"cache\" };\n }\n const s = await searchInpi(q);\n if ((s as any)._status) {\n return { _status: (s as any)._status, candidates: [] };\n }\n const exact = s.candidates.filter((r: any) =>\n (r.denomination || \"\").toUpperCase() === qn\n );\n if (exact.length === 1 && exact[0].siren) {\n return { siren: exact[0].siren, resolvedFrom: \"search-exact\" };\n }\n return { candidates: s.candidates };\n}\n\n// ===================== LOOKUP UNIFIÉ (identité + comptes, cache-first) =====================\napp.get(\"/inpi/lookup/:q\", async (c) => {\n const q = c.req.param(\"q\").trim();\n const scope = c.req.query(\"scope\") === \"conso\" ? \"conso\" : \"social\";\n const refresh = c.req.query(\"refresh\") === \"1\";\n const origin = new URL(c.req.url).origin;\n await ensureDb();\n\n const r = await resolveSiren(q);\n if (r._status === 429) {\n return c.json({ error: \"Quota journalier INPI dépassé\" }, 429);\n }\n if (!r.siren) {\n return c.json({\n mode: \"disambiguation\",\n query: q,\n count: (r.candidates ?? []).length,\n candidates: r.candidates ?? [],\n });\n }\n\n const [identite, financials] = await Promise.all([\n getCompany(r.siren, refresh),\n getFinancials(r.siren, scope, origin, refresh),\n ]);\n return c.json({\n resolvedFrom: r.resolvedFrom,\n siren: r.siren,\n identite: strip(identite),\n financials: strip(financials),\n });\n});\n\n// ===================== Endpoints unitaires =====================\napp.get(\"/inpi/company/:siren\", async (c) => {\n const siren = c.req.param(\"siren\");\n if (!/^\\d{9}$/.test(siren)) return c.json({ error: \"SIREN invalide\" }, 400);\n const r = await getCompany(siren, c.req.query(\"refresh\") === \"1\");\n if (r._status) return c.json(strip(r), r._status);\n return c.json(r);\n});\n\napp.get(\"/inpi/financials/:siren\", async (c) => {\n const siren = c.req.param(\"siren\");\n if (!/^\\d{9}$/.test(siren)) return c.json({ error: \"SIREN invalide\" }, 400);\n const scope = c.req.query(\"scope\") === \"conso\" ? \"conso\" : \"social\";\n const r = await getFinancials(\n siren,\n scope,\n new URL(c.req.url).origin,\n c.req.query(\"refresh\") === \"1\",\n );\n if (r._status) return c.json(strip(r), r._status);\n return c.json(r);\n});\n\napp.get(\"/inpi/search/:q\", async (c) => {\n let s;\n try {\n s = await searchInpi(c.req.param(\"q\"));\n } catch (e) {\n console.error(e);\n return c.json({ error: \"INPI KO\" }, 502);\n }\n if ((s as any)._status === 429) {\n return c.json({ error: \"Quota journalier INPI dépassé\" }, 429);\n }\n if ((s as any)._status) {\n return c.json({ error: `INPI ${(s as any)._status}` }, (s as any)._status);\n }\n return c.json({\n query: c.req.param(\"q\"),\n count: s.candidates.length,\n results: s.candidates,\n });\n});\n\napp.get(\"/inpi/cache/search/:q\", async (c) => {\n await ensureDb();\n const q = c.req.param(\"q\");\n const like = `%${q.toUpperCase()}%`;\n const r = await sqlite.execute({\n sql: `SELECT siren, denomination, code_naf, updated_at FROM inpi_company\n WHERE UPPER(denomination) LIKE ? OR siren LIKE ? ORDER BY denomination LIMIT 20`,\n args: [like, `%${q}%`],\n });\n const results = (r.rows as any[]).map((row) => ({\n siren: row[0],\n denomination: row[1],\n codeNaf: row[2],\n dateMaj: row[3] ? new Date(Number(row[3])).toISOString() : null,\n }));\n return c.json({ query: q, count: results.length, results, source: \"cache\" });\n});\n\n// ===================== PROXY GÉNÉRIQUE (allowlist GET) =====================\napp.get(\"/inpi/*\", async (c) => {\n const path = c.req.path.replace(/^\\/inpi/, \"\");\n if (!ALLOWED_GET.some((re) => re.test(path))) {\n return c.json({ error: \"Endpoint non autorisé\", path }, 403);\n }\n const search = new URL(c.req.url).search;\n let res: Response;\n try {\n res = await callInpi(path, search);\n } catch (e) {\n return c.json({ error: \"INPI KO\", detail: String(e) }, 502);\n }\n if (res.status === 429) {\n return c.json({ error: \"Quota journalier INPI dépassé (429)\" }, 429);\n }\n const contentType = res.headers.get(\"content-type\") ??\n \"application/octet-stream\";\n return new Response(await res.arrayBuffer(), {\n status: res.status,\n headers: { \"content-type\": contentType },\n });\n});\n\nexport default app.fetch;",[137],"pulls","branches","forks","envVars",{"_152":154,"_155":60},"connections",{"_152":60,"_153":60},"count","unfilledCount",2,"emptyCount",{"_43":136,"_32":137,"_30":138,"_130":-5,"_41":42,"_40":139,"_131":25,"_38":162,"_13":141,"_34":142,"_36":143,"_24":25,"_134":-5,"_159":163,"_27":164},{"_43":129,"_32":28,"_30":31,"_130":-5,"_41":42,"_40":14,"_131":25,"_38":158,"_13":133,"_34":35,"_36":37,"_24":25,"_134":-5,"_159":160,"_27":161},["D",1780934907400],"children",[],[28],["D",1780934890981],[],[137],["D",1780579259355],["D",1789489305251],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_124":203,"_204":205,"_206":207,"_208":25,"_209":25,"_210":25,"_211":122,"_212":-5,"_213":-7,"_214":-7,"_215":60,"_216":25,"_217":25,"_218":-5,"_219":25,"_220":25,"_221":25,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":87,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v12