[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_178":179,"_180":181},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_132":-5,"_20":133,"_22":134,"_135":136,"_137":138,"_25":139,"_24":-5,"_140":-5,"_141":-5,"_142":54,"_143":144,"_145":45,"_146":-5,"_147":-5,"_148":149},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","monnoude","name","DimensionnementPV","branchName","main","version","path","","project",{"_34":74,"_13":14,"_46":75,"_76":-5,"_77":54,"_78":79,"_80":79,"_81":82,"_83":-5,"_84":85,"_86":-5,"_87":54,"_88":-5,"_89":-5,"_90":91,"_92":93,"_94":95,"_96":97,"_98":99,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":111,"_112":113,"_114":115,"_116":54},"tree",[65,66],"file","contents",[32,33],"upstream","pull","ahead","behind","envVars",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":50,"_51":63,"_53":54,"_55":-5,"_18":64},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":56},"id","86315cbd-2fd2-4266-bc1e-ef7cc2f77b81","version1_0.ts","fileId","9c2d9f22-7e94-11f1-9dea-1607ee4eb77e","parentId","branchId","69e778b1-81d9-4988-ae07-cde1bad6f408","branchVersion",11,"latest",true,"createdAt",["D",1783954581683],9,"fileType","http","content","/**\n * OUTIL DE DIMENSIONNEMENT PV RESIDENTIEL — basé sur le Manuel IFDD Module 4\n * \"Électricité solaire photovoltaïque - Dimensionnement d'une installation solaire photovoltaïque\"\n *\n * Déploiement : coller ce fichier tel quel dans un nouveau \"HTTP val\" sur val.town.\n * Il crée son propre schéma SQLite au premier appel (idempotent) et sert\n * une page web + une API JSON. Aucune variable d'environnement requise.\n */\n\nimport sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ============================================================\n// 1. SCHEMA SQL\n// ============================================================\n\nasync function initSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS clients (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n pays TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n `CREATE TABLE IF NOT EXISTS projects (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n client_id INTEGER,\n nom TEXT NOT NULL,\n pays TEXT,\n irradiation REAL NOT NULL,\n autonomie_jours INTEGER NOT NULL DEFAULT 1,\n taux_reserve REAL NOT NULL DEFAULT 0.25,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n `CREATE TABLE IF NOT EXISTS charges (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n project_id INTEGER NOT NULL,\n appareil TEXT NOT NULL,\n qte REAL NOT NULL,\n puissance_unitaire REAL NOT NULL,\n duree_jour REAL NOT NULL DEFAULT 0,\n duree_nuit REAL NOT NULL DEFAULT 0,\n type TEXT NOT NULL DEFAULT 'resistif'\n )`,\n `CREATE TABLE IF NOT EXISTS panels (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n puissance_wc REAL NOT NULL,\n vmpp REAL NOT NULL,\n voc REAL NOT NULL,\n isc REAL NOT NULL,\n tension_nominale REAL NOT NULL,\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS batteries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n tension REAL NOT NULL,\n capacite_ah REAL NOT NULL,\n techno TEXT NOT NULL DEFAULT 'plomb',\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS inverters (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n puissance_w REAL NOT NULL,\n tension_entree REAL NOT NULL,\n rendement REAL NOT NULL DEFAULT 0.9,\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS regulators (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n type TEXT NOT NULL,\n tension_max REAL,\n courant_max REAL,\n puissance_max REAL,\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS sizing_results (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n project_id INTEGER NOT NULL,\n method TEXT NOT NULL,\n result_json TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n ]);\n\n // Seed catalogue si vide (valeurs reprises de l'étude de cas IFDD 4.3)\n const p = await sqlite.execute(\"SELECT COUNT(*) as c FROM panels\");\n if ((p.rows[0] as any).c === 0) {\n await sqlite.batch([\n {\n sql:\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, prix) VALUES (?,?,?,?,?,?,?)\",\n args: [\"Panneau poly 250Wc/24V\", 250, 30.0, 37.6, 8.5, 24, null],\n },\n {\n sql:\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, prix) VALUES (?,?,?,?,?,?,?)\",\n args: [\"Panneau mono 460Wc\", 460, 42.5, 50.01, 11.45, 24, null],\n },\n {\n sql:\n \"INSERT INTO batteries (nom, tension, capacite_ah, techno, prix) VALUES (?,?,?,?,?)\",\n args: [\"Batterie plomb 12V/100Ah\", 12, 100, \"plomb\", null],\n },\n {\n sql:\n \"INSERT INTO batteries (nom, tension, capacite_ah, techno, prix) VALUES (?,?,?,?,?)\",\n args: [\"Batterie lithium 12V/100Ah\", 12, 100, \"lithium\", null],\n },\n {\n sql:\n \"INSERT INTO regulators (nom, type, tension_max, courant_max, puissance_max, prix) VALUES (?,?,?,?,?,?)\",\n args: [\"Régulateur PWM 30A/24V\", \"pwm\", 24, 30, null, null],\n },\n {\n sql:\n \"INSERT INTO regulators (nom, type, tension_max, courant_max, puissance_max, prix) VALUES (?,?,?,?,?,?)\",\n args: [\"Victron BlueSolar MPPT 100/50\", \"mppt\", 100, 50, null, null],\n },\n {\n sql:\n \"INSERT INTO inverters (nom, puissance_w, tension_entree, rendement, prix) VALUES (?,?,?,?,?)\",\n args: [\"Onduleur 24V / 800W\", 800, 24, 0.9, null],\n },\n ]);\n }\n}\n\n// ============================================================\n// 2. LOGIQUE DE CALCUL (formules manuel IFDD §4.1 - §4.2)\n// ============================================================\n\ntype Charge = {\n appareil: string;\n qte: number;\n puissance_unitaire: number;\n duree_jour: number;\n duree_nuit: number;\n type: \"resistif\" | \"moteur\"; // \"moteur\" = charge inductive (frigo, ventilo, pompe...)\n};\n\nfunction bilanEnergetique(charges: Charge[], tauxReserve: number) {\n let ejTotal = 0, enTotal = 0, pptResistif = 0, pptMoteur = 0;\n const detail = charges.map((c) => {\n const pt = c.puissance_unitaire * c.qte;\n const ej = pt * c.duree_jour;\n const en = pt * c.duree_nuit;\n ejTotal += ej;\n enTotal += en;\n if (c.type === \"moteur\") pptMoteur += pt;\n else pptResistif += pt;\n return { ...c, pt, ej, en };\n });\n const ejReserve = ejTotal * (1 + tauxReserve);\n const enReserve = enTotal * (1 + tauxReserve);\n const besoinTotal = ejReserve + enReserve; // Wh/jour\n // Puissance de pointe totale (pour l'onduleur) : charges résistives + 3x charges à démarrage moteur\n const ppt = pptResistif + 3 * pptMoteur;\n return { detail, ejTotal, enTotal, ejReserve, enReserve, besoinTotal, ppt };\n}\n\nfunction tensionSysteme(pcWc: number): number {\n if (pcWc <= 500) return 12;\n if (pcWc <= 2000) return 24;\n if (pcWc <= 10000) return 48;\n return 96;\n}\n\nfunction dimensionnerBatterie(opts: {\n enNocturneReserve: number; // Wh, énergie nocturne (avec réserve)\n autonomieJours: number;\n battery: { tension: number; capacite_ah: number; techno: string };\n dod?: number; // si non fourni, déduit de la techno\n rendement?: number;\n}) {\n const DOD = opts.dod ?? (opts.battery.techno === \"lithium\" ? 0.85 : 0.5);\n const Rb = opts.rendement ?? (opts.battery.techno === \"lithium\" ? 0.9 : 0.7);\n // NB: le manuel choisit Us = tension du système PV déjà déterminée ; ici on prend\n // la tension issue du dimensionnement PV, transmise par l'appelant via battery? -> voir usage plus bas\n return { DOD, Rb };\n}\n\nfunction calcCapaciteParc(\n enNocturneReserve: number,\n Nj: number,\n Us: number,\n DOD: number,\n Rb: number,\n) {\n return (enNocturneReserve * Nj) / (Us * DOD * Rb); // Ah\n}\n\n// ---- Méthode 1 : Rp global forfaitaire (0,65 poussiéreux / 0,8 propre) ----\nfunction methode1(input: {\n besoinTotal: number;\n irradiation: number;\n environnementPoussiereux: boolean;\n panel: {\n puissance_wc: number;\n tension_nominale: number;\n voc: number;\n isc: number;\n };\n regulatorCourantMax?: number;\n Ppt: number;\n k: number; // coefficient réserve onduleur (manuel: 1,5 dans l'exemple 1)\n rendementOnduleur: number;\n}) {\n const Rp = input.environnementPoussiereux ? 0.65 : 0.8;\n const PcMin = input.besoinTotal / (Rp * input.irradiation); // Wc\n const Np = Math.ceil(PcMin / input.panel.puissance_wc);\n const PcApprox = Np * input.panel.puissance_wc;\n const Us = tensionSysteme(PcApprox);\n const Nps = Math.max(1, Math.ceil(Us / input.panel.tension_nominale));\n const Nbrp = Math.max(1, Math.ceil(Np / Nps));\n const PcInstalle = Nps * Nbrp * input.panel.puissance_wc;\n\n // Régulateur PWM : Icct = 1,25 x Icc x Nbrp\n const Icct = 1.25 * input.panel.isc * Nbrp;\n const regulateurOk = input.regulatorCourantMax != null\n ? input.regulatorCourantMax >= Icct\n : null;\n\n const puissanceOnduleur = (input.k * input.Ppt) / input.rendementOnduleur;\n\n return {\n Rp,\n PcMin,\n Np,\n Us,\n Nps,\n Nbrp,\n PcInstalle,\n Icct,\n regulateurOk,\n puissanceOnduleur,\n };\n}\n\n// ---- Méthode 2 : rendements détaillés par composant (module x mppt x câbles x batterie x convertisseur) ----\nfunction methode2(input: {\n besoinTotal: number;\n irradiation: number;\n rendements: {\n panneau: number;\n mppt: number;\n cables: number;\n batterie: number;\n convertisseur: number;\n };\n panel: {\n puissance_wc: number;\n tension_nominale: number;\n voc: number;\n isc: number;\n };\n Ppt: number;\n k: number; // manuel: 1,25 dans l'exemple 2\n rendementOnduleur: number;\n}) {\n const Rp = input.rendements.panneau * input.rendements.mppt *\n input.rendements.cables *\n input.rendements.batterie * input.rendements.convertisseur;\n const PcMin = input.besoinTotal / (Rp * input.irradiation);\n const Np = Math.ceil(PcMin / input.panel.puissance_wc);\n const PcApprox = Np * input.panel.puissance_wc;\n const Us = tensionSysteme(PcApprox);\n const Nps = Math.max(1, Math.ceil(Us / input.panel.tension_nominale));\n const Nbrp = Math.max(1, Math.ceil(Np / Nps));\n const PcInstalle = Nps * Nbrp * input.panel.puissance_wc;\n\n // Régulateur MPPT : coefficient sécurité 1,25 sur P, V, I\n const Pmrc = 1.25 * input.panel.puissance_wc * Np;\n const Vmrc = 1.25 * input.panel.voc * Nps;\n const Imrc = 1.25 * input.panel.isc * Nbrp;\n\n const puissanceOnduleur = (input.k * input.Ppt) / input.rendementOnduleur;\n\n return {\n Rp,\n PcMin,\n Np,\n Us,\n Nps,\n Nbrp,\n PcInstalle,\n Pmrc,\n Vmrc,\n Imrc,\n puissanceOnduleur,\n };\n}\n\n// ============================================================\n// 3. API HTTP\n// ============================================================\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n}\n\nasync function handleApi(req: Request, url: URL): Promise {\n const path = url.pathname;\n\n if (path === \"/api/catalog\" && req.method === \"GET\") {\n const [panels, batteries, inverters, regulators] = await Promise.all([\n sqlite.execute(\"SELECT * FROM panels ORDER BY puissance_wc\"),\n sqlite.execute(\"SELECT * FROM batteries ORDER BY tension, capacite_ah\"),\n sqlite.execute(\"SELECT * FROM inverters ORDER BY puissance_w\"),\n sqlite.execute(\"SELECT * FROM regulators ORDER BY type\"),\n ]);\n return json({\n panels: panels.rows,\n batteries: batteries.rows,\n inverters: inverters.rows,\n regulators: regulators.rows,\n });\n }\n\n if (path === \"/api/catalog/panels\" && req.method === \"POST\") {\n const b = await req.json();\n const r = await sqlite.execute(\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, prix) VALUES (?,?,?,?,?,?,?)\",\n [\n b.nom,\n b.puissance_wc,\n b.vmpp,\n b.voc,\n b.isc,\n b.tension_nominale,\n b.prix ?? null,\n ],\n );\n return json({ id: Number(r.lastInsertRowid) });\n }\n\n if (path === \"/api/catalog/batteries\" && req.method === \"POST\") {\n const b = await req.json();\n const r = await sqlite.execute(\n \"INSERT INTO batteries (nom, tension, capacite_ah, techno, prix) VALUES (?,?,?,?,?)\",\n [b.nom, b.tension, b.capacite_ah, b.techno ?? \"plomb\", b.prix ?? null],\n );\n return json({ id: Number(r.lastInsertRowid) });\n }\n\n if (path === \"/api/catalog/regulators\" && req.method === \"POST\") {\n const b = await req.json();\n const r = await sqlite.execute(\n \"INSERT INTO regulators (nom, type, tension_max, courant_max, puissance_max, prix) VALUES (?,?,?,?,?,?)\",\n [\n b.nom,\n b.type,\n b.tension_max ?? null,\n b.courant_max ?? null,\n b.puissance_max ?? null,\n b.prix ?? null,\n ],\n );\n return json({ id: Number(r.lastInsertRowid) });\n }\n\n if (path === \"/api/catalog/inverters\" && req.method === \"POST\") {\n const b = await req.json();\n const r = await sqlite.execute(\n \"INSERT INTO inverters (nom, puissance_w, tension_entree, rendement, prix) VALUES (?,?,?,?,?)\",\n [\n b.nom,\n b.puissance_w,\n b.tension_entree,\n b.rendement ?? 0.9,\n b.prix ?? null,\n ],\n );\n return json({ id: Number(r.lastInsertRowid) });\n }\n\n if (path === \"/api/projects\" && req.method === \"GET\") {\n const rows = await sqlite.execute(\n \"SELECT * FROM projects ORDER BY created_at DESC\",\n );\n return json(rows.rows);\n }\n\n if (path.match(/^\\/api\\/projects\\/\\d+$/) && req.method === \"GET\") {\n const id = Number(path.split(\"/\").pop());\n const project = await sqlite.execute(\n \"SELECT * FROM projects WHERE id = ?\",\n [id],\n );\n const charges = await sqlite.execute(\n \"SELECT * FROM charges WHERE project_id = ?\",\n [id],\n );\n const results = await sqlite.execute(\n \"SELECT * FROM sizing_results WHERE project_id = ? ORDER BY created_at\",\n [id],\n );\n return json({\n project: project.rows[0] ?? null,\n charges: charges.rows,\n results: results.rows.map((r: any) => ({\n ...r,\n result_json: JSON.parse(r.result_json),\n })),\n });\n }\n\n if (path === \"/api/size\" && req.method === \"POST\") {\n const b = await req.json();\n\n const charges: Charge[] = b.charges;\n const bilan = bilanEnergetique(charges, b.taux_reserve ?? 0.25);\n\n // --- récupération des composants choisis ---\n const panel1 = await sqlite.execute(\"SELECT * FROM panels WHERE id = ?\", [\n b.methode1.panel_id,\n ]);\n const panel2 = await sqlite.execute(\"SELECT * FROM panels WHERE id = ?\", [\n b.methode2.panel_id,\n ]);\n const battery = await sqlite.execute(\n \"SELECT * FROM batteries WHERE id = ?\",\n [b.battery_id],\n );\n const regulatorPwm = b.methode1.regulator_id\n ? await sqlite.execute(\"SELECT * FROM regulators WHERE id = ?\", [\n b.methode1.regulator_id,\n ])\n : { rows: [] as any[] };\n\n const P1 = panel1.rows[0] as any;\n const P2 = panel2.rows[0] as any;\n const Bat = battery.rows[0] as any;\n\n if (!P1 || !P2 || !Bat) {\n return json({\n error: \"Panneau ou batterie introuvable dans le catalogue\",\n }, 400);\n }\n\n // --- Méthode 1 ---\n const m1 = methode1({\n besoinTotal: bilan.besoinTotal,\n irradiation: b.irradiation,\n environnementPoussiereux: !!b.methode1.poussiereux,\n panel: P1,\n regulatorCourantMax: (regulatorPwm.rows[0] as any)?.courant_max,\n Ppt: bilan.ppt,\n k: b.methode1.k ?? 1.5,\n rendementOnduleur: b.methode1.rendement_onduleur ?? 0.9,\n });\n const dod1 = b.dod ?? (Bat.techno === \"lithium\" ? 0.85 : 0.5);\n const rb1 = b.rendement_batterie ?? (Bat.techno === \"lithium\" ? 0.9 : 0.7);\n const cp1 = calcCapaciteParc(\n bilan.enReserve,\n b.autonomie_jours ?? 1,\n m1.Us,\n dod1,\n rb1,\n );\n const nbs1 = Math.max(1, Math.ceil(m1.Us / Bat.tension));\n const nbp1 = Math.max(1, Math.ceil(cp1 / Bat.capacite_ah));\n\n // --- Méthode 2 ---\n const rendements = b.methode2.rendements ?? {\n panneau: 0.8,\n mppt: 0.98,\n cables: 0.98,\n batterie: 0.9,\n convertisseur: 0.98,\n };\n const m2 = methode2({\n besoinTotal: bilan.besoinTotal,\n irradiation: b.irradiation,\n rendements,\n panel: P2,\n Ppt: bilan.ppt,\n k: b.methode2.k ?? 1.25,\n rendementOnduleur: b.methode2.rendement_onduleur ?? 0.98,\n });\n const dod2 = b.dod ?? (Bat.techno === \"lithium\" ? 0.85 : 0.5);\n const rb2 = b.rendement_batterie ?? (Bat.techno === \"lithium\" ? 0.9 : 0.7);\n const cp2 = calcCapaciteParc(\n bilan.enReserve,\n b.autonomie_jours ?? 1,\n m2.Us,\n dod2,\n rb2,\n );\n const nbs2 = Math.max(1, Math.ceil(m2.Us / Bat.tension));\n const nbp2 = Math.max(1, Math.ceil(cp2 / Bat.capacite_ah));\n\n const resultat = {\n bilan,\n methode1: {\n ...m1,\n panel: P1,\n batterie: {\n Cp: cp1,\n Nbs: nbs1,\n Nbp: nbp1,\n Nb: nbs1 * nbp1,\n ref: Bat,\n DOD: dod1,\n Rb: rb1,\n },\n },\n methode2: {\n ...m2,\n panel: P2,\n batterie: {\n Cp: cp2,\n Nbs: nbs2,\n Nbp: nbp2,\n Nb: nbs2 * nbp2,\n ref: Bat,\n DOD: dod2,\n Rb: rb2,\n },\n },\n };\n\n // --- persistance ---\n const proj = await sqlite.execute(\n \"INSERT INTO projects (client_id, nom, pays, irradiation, autonomie_jours, taux_reserve) VALUES (?,?,?,?,?,?)\",\n [\n b.client_id ?? null,\n b.nom ?? \"Projet sans nom\",\n b.pays ?? null,\n b.irradiation,\n b.autonomie_jours ?? 1,\n b.taux_reserve ?? 0.25,\n ],\n );\n const projectId = Number(proj.lastInsertRowid);\n\n if (charges.length > 0) {\n await sqlite.batch(charges.map((c) => ({\n sql:\n \"INSERT INTO charges (project_id, appareil, qte, puissance_unitaire, duree_jour, duree_nuit, type) VALUES (?,?,?,?,?,?,?)\",\n args: [\n projectId,\n c.appareil,\n c.qte,\n c.puissance_unitaire,\n c.duree_jour,\n c.duree_nuit,\n c.type,\n ],\n })));\n }\n\n await sqlite.execute(\n \"INSERT INTO sizing_results (project_id, method, result_json) VALUES (?,?,?)\",\n [projectId, \"comparatif\", JSON.stringify(resultat)],\n );\n\n return json({ project_id: projectId, ...resultat });\n }\n\n return json({ error: \"Not found\" }, 404);\n}\n\n// ============================================================\n// 4. FRONTEND (page unique, HTML + JS vanilla)\n// ============================================================\n\nconst PAGE = `\n\n\n\n\nDimensionnement PV résidentiel — IFDD\n\n\n\n

☀️ Dimensionnement PV résidentiel — Off-grid

Basé sur le Manuel IFDD Module 4 (méthode 1 : ratio de performance global — méthode 2 : rendements détaillés par composant)
Par Monnoudé Judist A. Steven TCHEFFA

\n\n

1. Projet

Nom du projet

Pays / localité

Irradiation mois défavorable (kWh/m²/j)

Jours d'autonomie

Taux de réserve (ex 0.25)

\n\n

2. Bilan énergétique — charges

Appareil

Qté

Pu (W)

Durée jour (h)

Durée nuit (h)

Type

\n \n

\n\n

3. Composants & hypothèses

Panneau — Méthode 1

Environnement poussiéreux ?\n \n

Régulateur PWM (méthode 1)

Panneau — Méthode 2

Batterie (commune aux 2 méthodes)

Onduleur (indicatif)

k onduleur méthode 1 (défaut 1,5)

k onduleur méthode 2 (défaut 1,25)

\n \n \n

\n\n

\n\n\n\n`;\n\n// ============================================================\n// 5. ENTRY POINT\n// ============================================================\n\nlet schemaReady = false;\n\nexport default async function (req: Request): Promise {\n if (!schemaReady) {\n await initSchema();\n schemaReady = true;\n }\n\n const url = new URL(req.url);\n\n if (url.pathname.startsWith(\"/api/\")) {\n try {\n return await handleApi(req, url);\n } catch (e) {\n return json({ error: String(e) }, 500);\n }\n }\n\n if (url.pathname === \"/\" || url.pathname === \"/index.html\") {\n return new Response(PAGE, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}","deleted",false,"label",[36],"21f8da66-9872-4329-9c56-42298c76facc","Version1_1.ts","3debb6aa-7e95-11f1-9ffd-1607ee4eb77e",16,["D",1783978046449],5,"/**\n * OUTIL DE DIMENSIONNEMENT PV RESIDENTIEL — basé sur le Manuel IFDD Module 4\n * + retours terrain (coefficient de simultanéité, catalogue 48V, sizing MPPT\n * basé sur la tension max réelle du régulateur — cf. fiches Victron).\n *\n * Déploiement : coller ce fichier dans un HTTP val sur val.town. Le schéma\n * SQLite se crée / se met à jour tout seul au premier appel (idempotent).\n */\n\nimport sqlite from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// ============================================================\n// 1. SCHEMA SQL + CATALOGUE\n// ============================================================\n\nasync function initSchema() {\n await sqlite.batch([\n `CREATE TABLE IF NOT EXISTS clients (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n pays TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n `CREATE TABLE IF NOT EXISTS projects (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n client_id INTEGER,\n nom TEXT NOT NULL,\n pays TEXT,\n irradiation REAL NOT NULL,\n autonomie_jours INTEGER NOT NULL DEFAULT 1,\n taux_reserve REAL NOT NULL DEFAULT 0.25,\n coefficient_simultaneite REAL NOT NULL DEFAULT 0.75,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n `CREATE TABLE IF NOT EXISTS charges (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n project_id INTEGER NOT NULL,\n appareil TEXT NOT NULL,\n qte REAL NOT NULL,\n puissance_unitaire REAL NOT NULL,\n duree_jour REAL NOT NULL DEFAULT 0,\n duree_nuit REAL NOT NULL DEFAULT 0,\n type TEXT NOT NULL DEFAULT 'resistif'\n )`,\n `CREATE TABLE IF NOT EXISTS panels (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n puissance_wc REAL NOT NULL,\n vmpp REAL NOT NULL,\n voc REAL NOT NULL,\n isc REAL NOT NULL,\n tension_nominale REAL,\n compatible_pwm INTEGER NOT NULL DEFAULT 1,\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS batteries (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n tension REAL NOT NULL,\n capacite_ah REAL NOT NULL,\n techno TEXT NOT NULL DEFAULT 'plomb',\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS inverters (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n puissance_w REAL NOT NULL,\n tension_entree REAL NOT NULL,\n rendement REAL NOT NULL DEFAULT 0.9,\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS regulators (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n type TEXT NOT NULL,\n tension_max REAL,\n courant_max REAL,\n puissance_max REAL,\n prix REAL\n )`,\n `CREATE TABLE IF NOT EXISTS sizing_results (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n project_id INTEGER NOT NULL,\n method TEXT NOT NULL,\n result_json TEXT NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )`,\n ]);\n\n // Migration douce pour les vals déjà déployés avant l'ajout de ces colonnes.\n for (\n const stmt of [\n \"ALTER TABLE panels ADD COLUMN compatible_pwm INTEGER NOT NULL DEFAULT 1\",\n \"ALTER TABLE projects ADD COLUMN coefficient_simultaneite REAL NOT NULL DEFAULT 0.75\",\n ]\n ) {\n try {\n await sqlite.execute(stmt);\n } catch (_e) {\n // colonne déjà présente : rien à faire\n }\n }\n\n await seedIfMissing(\n \"SELECT id FROM panels WHERE puissance_wc = ?\",\n [250],\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, compatible_pwm) VALUES (?,?,?,?,?,?,?)\",\n [\"Panneau poly 250Wc/24V\", 250, 30.0, 37.6, 8.5, 24, 1],\n );\n await seedIfMissing(\n \"SELECT id FROM panels WHERE puissance_wc = ?\",\n [460],\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, compatible_pwm) VALUES (?,?,?,?,?,?,?)\",\n [\"Panneau mono 460Wc\", 460, 42.5, 50.01, 11.45, null, 0],\n );\n // Panneaux 400-650Wc — gamme courante du marché (valeurs indicatives à\n // ajuster selon la fiche technique du fabricant retenu). Utilisables\n // uniquement avec un régulateur MPPT (compatible_pwm = 0).\n await seedIfMissing(\n \"SELECT id FROM panels WHERE puissance_wc = ?\",\n [400],\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, compatible_pwm) VALUES (?,?,?,?,?,?,?)\",\n [\"Panneau mono 400Wc (indicatif)\", 400, 37.4, 44.9, 11.6, null, 0],\n );\n await seedIfMissing(\n \"SELECT id FROM panels WHERE puissance_wc = ?\",\n [450],\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, compatible_pwm) VALUES (?,?,?,?,?,?,?)\",\n [\"Panneau mono 450Wc (indicatif)\", 450, 41.5, 49.5, 11.9, null, 0],\n );\n await seedIfMissing(\n \"SELECT id FROM panels WHERE puissance_wc = ?\",\n [550],\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, compatible_pwm) VALUES (?,?,?,?,?,?,?)\",\n [\"Panneau mono 550Wc (indicatif)\", 550, 41.7, 49.9, 13.9, null, 0],\n );\n await seedIfMissing(\n \"SELECT id FROM panels WHERE puissance_wc = ?\",\n [650],\n \"INSERT INTO panels (nom, puissance_wc, vmpp, voc, isc, tension_nominale, compatible_pwm) VALUES (?,?,?,?,?,?,?)\",\n [\"Panneau mono 650Wc (indicatif)\", 650, 43.9, 52.0, 15.5, null, 0],\n );\n\n await seedIfMissing(\n \"SELECT id FROM batteries WHERE tension = ? AND capacite_ah = ? AND techno = ?\",\n [12, 100, \"plomb\"],\n \"INSERT INTO batteries (nom, tension, capacite_ah, techno) VALUES (?,?,?,?)\",\n [\"Batterie plomb 12V/100Ah\", 12, 100, \"plomb\"],\n );\n await seedIfMissing(\n \"SELECT id FROM batteries WHERE tension = ? AND capacite_ah = ? AND techno = ?\",\n [12, 100, \"lithium\"],\n \"INSERT INTO batteries (nom, tension, capacite_ah, techno) VALUES (?,?,?,?)\",\n [\"Batterie lithium 12V/100Ah\", 12, 100, \"lithium\"],\n );\n await seedIfMissing(\n \"SELECT id FROM batteries WHERE tension = ? AND capacite_ah = ? AND techno = ?\",\n [48, 100, \"lithium\"],\n \"INSERT INTO batteries (nom, tension, capacite_ah, techno) VALUES (?,?,?,?)\",\n [\"Batterie lithium 48V/100Ah\", 48, 100, \"lithium\"],\n );\n await seedIfMissing(\n \"SELECT id FROM batteries WHERE tension = ? AND capacite_ah = ? AND techno = ?\",\n [48, 100, \"plomb\"],\n \"INSERT INTO batteries (nom, tension, capacite_ah, techno) VALUES (?,?,?,?)\",\n [\"Batterie plomb (OPzV) 48V/100Ah\", 48, 100, \"plomb\"],\n );\n\n await seedIfMissing(\n \"SELECT id FROM regulators WHERE type = ? AND courant_max = ?\",\n [\"pwm\", 30],\n \"INSERT INTO regulators (nom, type, tension_max, courant_max) VALUES (?,?,?,?)\",\n [\"Régulateur PWM 30A/24V\", \"pwm\", 24, 30],\n );\n await seedIfMissing(\n \"SELECT id FROM regulators WHERE type = ? AND courant_max = ? AND tension_max = ?\",\n [\"mppt\", 50, 100],\n \"INSERT INTO regulators (nom, type, tension_max, courant_max, puissance_max) VALUES (?,?,?,?,?)\",\n [\"Victron SmartSolar MPPT 100/50\", \"mppt\", 100, 50, 1450],\n );\n // Valeurs 250/60 et 250/100 — cf. fiches Victron SmartSolar MPPT VE.Can.\n // Puissance nominale PV donnée @48V (se référer à la fiche constructeur\n // pour les autres tensions batterie ; 250/60 estimée par interpolation,\n // 250/100 = valeur exacte de la fiche constructeur).\n await seedIfMissing(\n \"SELECT id FROM regulators WHERE type = ? AND courant_max = ? AND tension_max = ?\",\n [\"mppt\", 60, 250],\n \"INSERT INTO regulators (nom, type, tension_max, courant_max, puissance_max) VALUES (?,?,?,?,?)\",\n [\"Victron SmartSolar MPPT 250/60 (indicatif)\", \"mppt\", 250, 60, 3400],\n );\n await seedIfMissing(\n \"SELECT id FROM regulators WHERE type = ? AND courant_max = ? AND tension_max = ?\",\n [\"mppt\", 100, 250],\n \"INSERT INTO regulators (nom, type, tension_max, courant_max, puissance_max) VALUES (?,?,?,?,?)\",\n [\"Victron SmartSolar MPPT 250/100 VE.Can\", \"mppt\", 250, 100, 5800],\n );\n\n await seedIfMissing(\n \"SELECT id FROM inverters WHERE puissance_w = ? AND tension_entree = ?\",\n [800, 24],\n \"INSERT INTO inverters (nom, puissance_w, tension_entree, rendement) VALUES (?,?,?,?)\",\n [\"Onduleur 24V / 800VA\", 800, 24, 0.9],\n );\n // Gamme 48V standard demandée : 1500 / 2000 / 3000 / 5000 VA.\n // 3000 et 5000 VA correspondent aux Victron MultiPlus-II 48/3000/35-32 et\n // 48/5000/70-50 (cf. fiche jointe) ; 1500 et 2000 VA sont des tailles\n // génériques couramment disponibles sur le marché en 48V.\n await seedIfMissing(\n \"SELECT id FROM inverters WHERE puissance_w = ? AND tension_entree = ?\",\n [1500, 48],\n \"INSERT INTO inverters (nom, puissance_w, tension_entree, rendement) VALUES (?,?,?,?)\",\n [\"Onduleur 48V / 1500VA\", 1500, 48, 0.93],\n );\n await seedIfMissing(\n \"SELECT id FROM inverters WHERE puissance_w = ? AND tension_entree = ?\",\n [2000, 48],\n \"INSERT INTO inverters (nom, puissance_w, tension_entree, rendement) VALUES (?,?,?,?)\",\n [\"Onduleur 48V / 2000VA\", 2000, 48, 0.93],\n );\n await seedIfMissing(\n \"SELECT id FROM inverters WHERE puissance_w = ? AND tension_entree = ?\",\n [3000, 48],\n \"INSERT INTO inverters (nom, puissance_w, tension_entree, rendement) VALUES (?,?,?,?)\",\n [\"Victron MultiPlus-II 48/3000/35-32\", 3000, 48, 0.95],\n );\n await seedIfMissing(\n \"SELECT id FROM inverters WHERE puissance_w = ? AND tension_entree = ?\",\n [5000, 48],\n \"INSERT INTO inverters (nom, puissance_w, tension_entree, rendement) VALUES (?,?,?,?)\",\n [\"Victron MultiPlus-II 48/5000/70-50\", 5000, 48, 0.96],\n );\n}\n\nasync function seedIfMissing(\n checkSql: string,\n checkArgs: unknown[],\n insertSql: string,\n insertArgs: unknown[],\n) {\n const r = await sqlite.execute(checkSql, checkArgs);\n if (r.rows.length === 0) {\n await sqlite.execute(insertSql, insertArgs);\n }\n}\n\n// ============================================================\n// 2. VALIDATION — irradiation & autres entrées utilisateur\n// ============================================================\n\n// Bornes réalistes pour une irradiation \"mois le plus défavorable\" (kWh/m²/jour) :\n// de zones très nuageuses/hautes latitudes en hiver (~1) aux déserts les plus\n// ensoleillés (~8). Hors de cette plage, c'est presque sûrement une erreur de\n// saisie — sans ça, un \"0\" ou un \"50\" tapé par erreur donnait un résultat\n// absurde mais silencieux.\nconst IRRADIATION_MIN = 1;\nconst IRRADIATION_MAX = 8;\n\nfunction validateSizingInput(b: any): string | null {\n const irr = Number(b.irradiation);\n if (\n b.irradiation === undefined || b.irradiation === null ||\n b.irradiation === \"\" || !Number.isFinite(irr)\n ) {\n return \"Irradiation manquante ou non numérique. Indique une valeur en kWh/m²/jour (ex : 4.5).\";\n }\n if (irr < IRRADIATION_MIN || irr > IRRADIATION_MAX) {\n return `Irradiation invalide (${irr} kWh/m²/j) : une valeur réaliste est comprise entre ${IRRADIATION_MIN} et ${IRRADIATION_MAX} kWh/m²/jour. Vérifie ta source ou utilise le tableau de valeurs indicatives du formulaire.`;\n }\n const nj = Number(b.autonomie_jours);\n if (!Number.isFinite(nj) || nj < 1 || nj > 15) {\n return \"Jours d'autonomie invalide : choisis un entier entre 1 et 15.\";\n }\n const ks = Number(b.coefficient_simultaneite);\n if (!Number.isFinite(ks) || ks <= 0 || ks > 1) {\n return \"Coefficient de simultanéité invalide : choisis une valeur entre 0 (exclu) et 1.\";\n }\n if (!Array.isArray(b.charges) || b.charges.length === 0) {\n return \"Aucun appareil renseigné dans le bilan énergétique.\";\n }\n for (const c of b.charges) {\n if (\n !Number.isFinite(Number(c.puissance_unitaire)) ||\n Number(c.puissance_unitaire) <= 0\n ) {\n return `Puissance invalide pour l'appareil \"${c.appareil || \"?\"}\".`;\n }\n if (Number(c.duree_jour) === 0 && Number(c.duree_nuit) === 0) {\n return `L'appareil \"${\n c.appareil || \"?\"\n }\" a une durée d'utilisation nulle (jour et nuit) : retire-le ou renseigne une durée.`;\n }\n }\n if (!b.methode1?.panel_id || !b.methode1?.regulator_id) {\n return \"Sélectionne un panneau et un régulateur PWM pour la méthode 1.\";\n }\n if (!b.methode2?.panel_id || !b.methode2?.regulator_id) {\n return \"Sélectionne un panneau et un régulateur MPPT pour la méthode 2.\";\n }\n if (!b.battery_id) return \"Sélectionne une batterie.\";\n return null;\n}\n\n// ============================================================\n// 3. LOGIQUE DE CALCUL (formules manuel IFDD §4.1 - §4.2 + ajustements)\n// ============================================================\n\ntype Charge = {\n appareil: string;\n qte: number;\n puissance_unitaire: number;\n duree_jour: number;\n duree_nuit: number;\n type: \"resistif\" | \"moteur\"; // \"moteur\" = charge inductive -> appel de courant au démarrage\n};\n\nfunction bilanEnergetique(charges: Charge[], tauxReserve: number, Ks: number) {\n let ejTotal = 0, enTotal = 0, pptResistif = 0, pptMoteur = 0;\n const detail = charges.map((c) => {\n const pt = c.puissance_unitaire * c.qte;\n const ej = pt * c.duree_jour;\n const en = pt * c.duree_nuit;\n ejTotal += ej;\n enTotal += en;\n if (c.type === \"moteur\") pptMoteur += pt;\n else pptResistif += pt;\n return { ...c, pt, ej, en };\n });\n const ejReserve = ejTotal * (1 + tauxReserve);\n const enReserve = enTotal * (1 + tauxReserve);\n const besoinTotal = ejReserve + enReserve; // Wh/jour\n\n // Puissance de pointe pour l'onduleur :\n // - charges \"moteur\" : x3 pour le courant d'appel au démarrage (manuel §4.1.3.1)\n // - charges \"résistif\" : pondérées par le coefficient de simultanéité Ks (<=1),\n // car en usage réel tous les appareils ne tournent pas au même instant.\n // Le x3 des moteurs n'est PAS réduit par Ks : c'est un phénomène physique de\n // démarrage, pas un effet de simultanéité d'usage.\n const pptBrut = pptResistif + 3 * pptMoteur; // pire cas absolu, sans Ks\n const ppt = Ks * pptResistif + 3 * pptMoteur; // valeur utilisée pour le dimensionnement\n\n return {\n detail,\n ejTotal,\n enTotal,\n ejReserve,\n enReserve,\n besoinTotal,\n pptBrut,\n ppt,\n Ks,\n };\n}\n\nfunction tensionSysteme(pcWc: number): number {\n if (pcWc <= 500) return 12;\n if (pcWc <= 2000) return 24;\n if (pcWc <= 10000) return 48;\n return 96;\n}\n\nfunction calcCapaciteParc(\n enNocturneReserve: number,\n Nj: number,\n Us: number,\n DOD: number,\n Rb: number,\n) {\n return (enNocturneReserve * Nj) / (Us * DOD * Rb); // Ah\n}\n\nfunction methode1(input: {\n besoinTotal: number;\n irradiation: number;\n environnementPoussiereux: boolean;\n panel: {\n puissance_wc: number;\n tension_nominale: number;\n voc: number;\n isc: number;\n };\n regulator: { courant_max?: number };\n Ppt: number;\n k: number;\n rendementOnduleur: number;\n}) {\n const Rp = input.environnementPoussiereux ? 0.65 : 0.8;\n const PcMin = input.besoinTotal / (Rp * input.irradiation);\n const Np = Math.ceil(PcMin / input.panel.puissance_wc);\n const PcApprox = Np * input.panel.puissance_wc;\n const Us = tensionSysteme(PcApprox);\n const Nps = Math.max(1, Math.ceil(Us / input.panel.tension_nominale));\n const Nbrp = Math.max(1, Math.ceil(Np / Nps));\n const PcInstalle = Nps * Nbrp * input.panel.puissance_wc;\n\n // Régulateur PWM : Icct = 1,25 x Icc x Nbrp (manuel §4.2.2.2.1)\n const Icct = 1.25 * input.panel.isc * Nbrp;\n const regulateurOk = input.regulator.courant_max != null\n ? input.regulator.courant_max >= Icct\n : null;\n\n const puissanceOnduleur = (input.k * input.Ppt) / input.rendementOnduleur;\n\n return {\n Rp,\n PcMin,\n Np,\n Us,\n Nps,\n Nbrp,\n PcInstalle,\n Icct,\n regulateurOk,\n puissanceOnduleur,\n };\n}\n\nfunction methode2(input: {\n besoinTotal: number;\n irradiation: number;\n rendements: {\n panneau: number;\n mppt: number;\n cables: number;\n batterie: number;\n convertisseur: number;\n };\n panel: { puissance_wc: number; voc: number; isc: number };\n regulator: {\n tension_max: number;\n courant_max?: number;\n puissance_max?: number;\n };\n Ppt: number;\n k: number;\n rendementOnduleur: number;\n}) {\n const Rp = input.rendements.panneau * input.rendements.mppt *\n input.rendements.cables *\n input.rendements.batterie * input.rendements.convertisseur;\n const PcMin = input.besoinTotal / (Rp * input.irradiation);\n const Np = Math.ceil(PcMin / input.panel.puissance_wc);\n\n // Nps limité par la tension MAX du régulateur MPPT (Voc du champ ne doit\n // jamais la dépasser, même par temps froid où Voc augmente). On reprend le\n // coefficient de sécurité 1,2 utilisé par le manuel pour le même type de\n // marge (§4.2.2.5.3, choix de Ucpv des parafoudres : Ucpv > 1,2 x Ns x Voc_stc).\n const Nps = Math.max(\n 1,\n Math.floor(input.regulator.tension_max / (1.2 * input.panel.voc)),\n );\n const Nbrp = Math.max(1, Math.ceil(Np / Nps));\n const PcInstalle = Nps * Nbrp * input.panel.puissance_wc;\n const Us = tensionSysteme(PcInstalle);\n\n // Vérification de marge (manuel §4.2.2.2.2, coefficient de sécurité 1,25)\n const Pmrc = 1.25 * input.panel.puissance_wc * Np;\n const Vmrc = 1.25 * input.panel.voc * Nps;\n const Imrc = 1.25 * input.panel.isc * Nbrp;\n const regulateurOk = {\n tension: Vmrc <= input.regulator.tension_max,\n courant: input.regulator.courant_max != null\n ? Imrc <= input.regulator.courant_max\n : null,\n puissance: input.regulator.puissance_max != null\n ? Pmrc <= input.regulator.puissance_max * 1.25\n : null,\n };\n\n const puissanceOnduleur = (input.k * input.Ppt) / input.rendementOnduleur;\n\n return {\n Rp,\n PcMin,\n Np,\n Nps,\n Nbrp,\n PcInstalle,\n Us,\n Pmrc,\n Vmrc,\n Imrc,\n regulateurOk,\n puissanceOnduleur,\n };\n}\n\n// ============================================================\n// 4. API HTTP\n// ============================================================\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data, null, 2), {\n status,\n headers: { \"content-type\": \"application/json; charset=utf-8\" },\n });\n}\n\nasync function handleApi(req: Request, url: URL): Promise {\n const path = url.pathname;\n\n if (path === \"/api/catalog\" && req.method === \"GET\") {\n const [panels, batteries, inverters, regulators] = await Promise.all([\n sqlite.execute(\"SELECT * FROM panels ORDER BY puissance_wc\"),\n sqlite.execute(\"SELECT * FROM batteries ORDER BY tension, capacite_ah\"),\n sqlite.execute(\n \"SELECT * FROM inverters ORDER BY tension_entree, puissance_w\",\n ),\n sqlite.execute(\"SELECT * FROM regulators ORDER BY type, courant_max\"),\n ]);\n return json({\n panels: panels.rows,\n batteries: batteries.rows,\n inverters: inverters.rows,\n regulators: regulators.rows,\n });\n }\n\n if (path.startsWith(\"/api/catalog/\") && req.method === \"POST\") {\n const table = path.split(\"/\").pop()!;\n const cols: Record = {\n panels: [\n \"nom\",\n \"puissance_wc\",\n \"vmpp\",\n \"voc\",\n \"isc\",\n \"tension_nominale\",\n \"compatible_pwm\",\n \"prix\",\n ],\n batteries: [\"nom\", \"tension\", \"capacite_ah\", \"techno\", \"prix\"],\n inverters: [\"nom\", \"puissance_w\", \"tension_entree\", \"rendement\", \"prix\"],\n regulators: [\n \"nom\",\n \"type\",\n \"tension_max\",\n \"courant_max\",\n \"puissance_max\",\n \"prix\",\n ],\n };\n if (!cols[table]) {\n return json({ error: \"Table de catalogue inconnue.\" }, 400);\n }\n const b = await req.json();\n const fields = cols[table].filter((c) => b[c] !== undefined);\n const placeholders = fields.map(() => \"?\").join(\",\");\n const r = await sqlite.execute(\n `INSERT INTO ${table} (${fields.join(\",\")}) VALUES (${placeholders})`,\n fields.map((f) => b[f]),\n );\n return json({ id: Number(r.lastInsertRowid) });\n }\n\n if (path === \"/api/projects\" && req.method === \"GET\") {\n const rows = await sqlite.execute(\n \"SELECT * FROM projects ORDER BY created_at DESC\",\n );\n return json(rows.rows);\n }\n\n // GET /api/projects/ — \":id\" est un PARAMETRE à remplacer par\n // un vrai identifiant, ex. /api/projects/1 (renvoyé par POST /api/size).\n const projectMatch = path.match(/^\\/api\\/projects\\/([^/]+)$/);\n if (projectMatch && req.method === \"GET\") {\n const raw = projectMatch[1];\n const id = Number(raw);\n if (!Number.isInteger(id) || id <= 0) {\n return json({\n error:\n `\":id\" doit être remplacé par un identifiant numérique de projet, ex. /api/projects/1. Valeur reçue : \"${raw}\".`,\n hint:\n \"La liste des projets existants est disponible sur GET /api/projects.\",\n }, 400);\n }\n const project = await sqlite.execute(\n \"SELECT * FROM projects WHERE id = ?\",\n [id],\n );\n if (project.rows.length === 0) {\n return json({ error: `Aucun projet avec l'id ${id}.` }, 404);\n }\n const charges = await sqlite.execute(\n \"SELECT * FROM charges WHERE project_id = ?\",\n [id],\n );\n const results = await sqlite.execute(\n \"SELECT * FROM sizing_results WHERE project_id = ? ORDER BY created_at\",\n [id],\n );\n return json({\n project: project.rows[0],\n charges: charges.rows,\n results: results.rows.map((r: any) => ({\n ...r,\n result_json: JSON.parse(r.result_json),\n })),\n });\n }\n\n if (path === \"/api/size\" && req.method === \"POST\") {\n const b = await req.json();\n\n const validationError = validateSizingInput(b);\n if (validationError) return json({ error: validationError }, 400);\n\n const charges: Charge[] = b.charges;\n const Ks = Number(b.coefficient_simultaneite ?? 0.75);\n const bilan = bilanEnergetique(charges, b.taux_reserve ?? 0.25, Ks);\n\n const [panel1, panel2, battery, reg1, reg2] = await Promise.all([\n sqlite.execute(\"SELECT * FROM panels WHERE id = ?\", [\n b.methode1.panel_id,\n ]),\n sqlite.execute(\"SELECT * FROM panels WHERE id = ?\", [\n b.methode2.panel_id,\n ]),\n sqlite.execute(\"SELECT * FROM batteries WHERE id = ?\", [b.battery_id]),\n sqlite.execute(\"SELECT * FROM regulators WHERE id = ?\", [\n b.methode1.regulator_id,\n ]),\n sqlite.execute(\"SELECT * FROM regulators WHERE id = ?\", [\n b.methode2.regulator_id,\n ]),\n ]);\n\n const P1 = panel1.rows[0] as any,\n P2 = panel2.rows[0] as any,\n Bat = battery.rows[0] as any;\n const Reg1 = reg1.rows[0] as any, Reg2 = reg2.rows[0] as any;\n if (!P1 || !P2 || !Bat || !Reg1 || !Reg2) {\n return json({\n error:\n \"Panneau, batterie ou régulateur introuvable dans le catalogue (id invalide).\",\n }, 400);\n }\n if (!P1.tension_nominale) {\n return json({\n error:\n `Le panneau \"${P1.nom}\" n'a pas de tension nominale définie : il n'est pas compatible avec un régulateur PWM (méthode 1). Choisis un panneau marqué \"compatible PWM\".`,\n }, 400);\n }\n\n const m1 = methode1({\n besoinTotal: bilan.besoinTotal,\n irradiation: Number(b.irradiation),\n environnementPoussiereux: !!b.methode1.poussiereux,\n panel: P1,\n regulator: Reg1,\n Ppt: bilan.ppt,\n k: b.methode1.k ?? 1.5,\n rendementOnduleur: b.methode1.rendement_onduleur ?? 0.9,\n });\n const dod1 = b.dod ?? (Bat.techno === \"lithium\" ? 0.85 : 0.5);\n const rb1 = b.rendement_batterie ?? (Bat.techno === \"lithium\" ? 0.9 : 0.7);\n const cp1 = calcCapaciteParc(\n bilan.enReserve,\n Number(b.autonomie_jours) ?? 1,\n m1.Us,\n dod1,\n rb1,\n );\n const nbs1 = Math.max(1, Math.ceil(m1.Us / Bat.tension));\n const nbp1 = Math.max(1, Math.ceil(cp1 / Bat.capacite_ah));\n\n const rendements = b.methode2.rendements ?? {\n panneau: 0.8,\n mppt: 0.98,\n cables: 0.98,\n batterie: 0.9,\n convertisseur: 0.98,\n };\n const m2 = methode2({\n besoinTotal: bilan.besoinTotal,\n irradiation: Number(b.irradiation),\n rendements,\n panel: P2,\n regulator: Reg2,\n Ppt: bilan.ppt,\n k: b.methode2.k ?? 1.25,\n rendementOnduleur: b.methode2.rendement_onduleur ?? 0.98,\n });\n const dod2 = b.dod ?? (Bat.techno === \"lithium\" ? 0.85 : 0.5);\n const rb2 = b.rendement_batterie ?? (Bat.techno === \"lithium\" ? 0.9 : 0.7);\n const cp2 = calcCapaciteParc(\n bilan.enReserve,\n Number(b.autonomie_jours) ?? 1,\n m2.Us,\n dod2,\n rb2,\n );\n const nbs2 = Math.max(1, Math.ceil(m2.Us / Bat.tension));\n const nbp2 = Math.max(1, Math.ceil(cp2 / Bat.capacite_ah));\n\n const resultat = {\n bilan,\n methode1: {\n ...m1,\n panel: P1,\n regulator: Reg1,\n batterie: {\n Cp: cp1,\n Nbs: nbs1,\n Nbp: nbp1,\n Nb: nbs1 * nbp1,\n ref: Bat,\n DOD: dod1,\n Rb: rb1,\n },\n },\n methode2: {\n ...m2,\n panel: P2,\n regulator: Reg2,\n batterie: {\n Cp: cp2,\n Nbs: nbs2,\n Nbp: nbp2,\n Nb: nbs2 * nbp2,\n ref: Bat,\n DOD: dod2,\n Rb: rb2,\n },\n },\n };\n\n const proj = await sqlite.execute(\n \"INSERT INTO projects (client_id, nom, pays, irradiation, autonomie_jours, taux_reserve, coefficient_simultaneite) VALUES (?,?,?,?,?,?,?)\",\n [\n b.client_id ?? null,\n b.nom ?? \"Projet sans nom\",\n b.pays ?? null,\n Number(b.irradiation),\n Number(b.autonomie_jours) ?? 1,\n b.taux_reserve ?? 0.25,\n Ks,\n ],\n );\n const projectId = Number(proj.lastInsertRowid);\n\n if (charges.length > 0) {\n await sqlite.batch(charges.map((c) => ({\n sql:\n \"INSERT INTO charges (project_id, appareil, qte, puissance_unitaire, duree_jour, duree_nuit, type) VALUES (?,?,?,?,?,?,?)\",\n args: [\n projectId,\n c.appareil,\n c.qte,\n c.puissance_unitaire,\n c.duree_jour,\n c.duree_nuit,\n c.type,\n ],\n })));\n }\n\n await sqlite.execute(\n \"INSERT INTO sizing_results (project_id, method, result_json) VALUES (?,?,?)\",\n [projectId, \"comparatif\", JSON.stringify(resultat)],\n );\n\n return json({ project_id: projectId, ...resultat });\n }\n\n return json({ error: \"Endpoint inconnu.\" }, 404);\n}\n\n// ============================================================\n// 5. FRONTEND (page unique, HTML + JS vanilla)\n// ============================================================\n\nconst IRRADIATION_PRESETS = [\n { lieu: \"Niamey, Niger\", valeur: 5.4 },\n { lieu: \"Bamako, Mali\", valeur: 5.0 },\n { lieu: \"Ouagadougou, Burkina Faso\", valeur: 5.0 },\n { lieu: \"Dakar, Sénégal\", valeur: 4.6 },\n { lieu: \"Cotonou, Bénin\", valeur: 4.0 },\n { lieu: \"Lomé, Togo\", valeur: 4.0 },\n { lieu: \"Abidjan, Côte d'Ivoire\", valeur: 4.0 },\n { lieu: \"Kinshasa, RD Congo\", valeur: 3.8 },\n { lieu: \"Douala, Cameroun\", valeur: 3.5 },\n { lieu: \"Antananarivo, Madagascar\", valeur: 4.3 },\n { lieu: \"Casablanca, Maroc\", valeur: 3.6 },\n { lieu: \"Tunis, Tunisie\", valeur: 3.0 },\n { lieu: \"Paris, France\", valeur: 1.6 },\n { lieu: \"Bruxelles, Belgique\", valeur: 1.1 },\n];\n\nconst PAGE = `\n\n\n\n\nDimensionnement PV résidentiel — IFDD\n\n\n\n

☀️ Dimensionnement PV résidentiel — Off-grid

Basé sur le Manuel IFDD Module 4 — méthode 1 (Rp global, régulateur PWM) et méthode 2 (rendements détaillés, régulateur MPPT)

\n\n

1. Projet

Nom du projet

Pays / localité

\n Irradiation mois défavorable (kWh/m²/j)\n \n

Jours d'autonomie

Taux de réserve (ex 0.25)

\n Coefficient de simultanéité Ks (charges résistives)\n \n

Je ne connais pas l'irradiation de mon pays — voir des valeurs indicatives

Valeurs approximatives (mois le plus défavorable). Clique sur une ligne pour la reporter dans le champ ci-dessus. Pour une valeur précise, utilise PVGIS.

\n\n

2. Bilan énergétique — charges

Le type \"Moteur\" applique un facteur ×3 sur sa puissance (appel de courant au démarrage). Le coefficient de simultanéité ci-dessus ne s'applique qu'aux charges \"Résistif\".

Appareil

Qté

Pu (W)

Durée jour (h)

Durée nuit (h)

Type

\n \n

\n\n

3. Composants & hypothèses

Panneau — Méthode 1 (PWM)

Environnement poussiéreux ?\n \n

Régulateur PWM (méthode 1)

Panneau — Méthode 2 (MPPT)

Régulateur MPPT (méthode 2)

Batterie (commune aux 2 méthodes)

k onduleur méthode 1 (défaut 1,5)

k onduleur méthode 2 (défaut 1,25)

\n \n \n

\n\n

\n\n\n\n`;\n\n// ============================================================\n// 6. ENTRY POINT\n// ============================================================\n\nlet schemaReady = false;\n\nexport default async function (req: Request): Promise {\n if (!schemaReady) {\n await initSchema();\n schemaReady = true;\n }\n\n const url = new URL(req.url);\n\n if (url.pathname.startsWith(\"/api/\")) {\n try {\n return await handleApi(req, url);\n } catch (e) {\n return json({ error: String(e) }, 500);\n }\n }\n\n if (url.pathname === \"/\" || url.pathname === \"/index.html\") {\n return new Response(PAGE, {\n headers: { \"content-type\": \"text/html; charset=utf-8\" },\n });\n }\n\n return new Response(\"Not found\", { status: 404 });\n}",[58],{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":50,"_51":63,"_53":54,"_55":-5,"_68":72,"_18":73},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":69,"_18":70},["D",1783954581683],"children",[],[36],["D",1783978046449],[],[58],"f2a74f61-b06b-4cb0-8aac-8e086a2172e2",["D",1783931216541],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Version 2 of my PV Sizing software","imageUrl","userId","019c18cf-f8f9-70c2-9cda-03dddc9a1375","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c18cf-f8f9-70c2-9cda-04bc4d12bee6","tursoName","f2a74f61b06b4cb08aac8e086a2172e2","tursoHostname","f2a74f61b06b4cb08aac8e086a2172e2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_131":127},"org",{"_11":12,"_125":-5,"_126":127,"_84":85,"_128":129,"_130":54},"branch",{"_17":60,"_13":16,"_34":41,"_117":74,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM5NDYySGo2S2dUdWpvN2xHdHVRY2ZxcUF3MCJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":74,"_13":14,"_46":173,"_76":-5,"_77":54,"_78":79,"_80":79,"_81":82,"_83":-5,"_84":85,"_86":-5,"_87":54,"_88":-5,"_89":-5,"_90":91,"_92":93,"_94":95,"_96":97,"_98":174,"_100":-5,"_101":102,"_103":102,"_104":105,"_106":105,"_107":105,"_108":102,"_109":102,"_110":175,"_112":176,"_114":177,"_116":54},[167,168],"files",[167,168],"counts",{"_157":91,"_158":159,"_160":91,"_31":161,"_162":163},[153,154],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[150],"hasHttpFiles","grants","orgs","customDomains",{},{"_34":151,"_152":-5},"fe0ee020-76b7-4792-9ebd-ec6b64b59c68","reporterId",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":61,"_17":62,"_49":50,"_51":63,"_53":54,"_55":-5,"_18":156},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":47,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_18":155},[36],[58],"pulls","branches",1,"forks",{"_164":91,"_166":91},"connections",{"_164":91,"_165":91},"count","unfilledCount","emptyCount",{"_34":57,"_13":58,"_37":59,"_39":-5,"_40":41,"_42":60,"_44":45,"_46":71,"_17":62,"_49":50,"_51":63,"_53":54,"_55":-5,"_68":171,"_18":172},{"_34":35,"_13":36,"_37":38,"_39":-5,"_40":41,"_42":43,"_44":45,"_46":67,"_17":48,"_49":50,"_51":52,"_53":54,"_55":-5,"_68":169,"_18":170},[],[36],[],[58],["D",1783931216541],["D",1789525245864],{"_11":12,"_131":127},{"_11":12,"_125":-5,"_126":127,"_84":85,"_128":129,"_130":54},{"_17":60,"_13":16,"_34":41,"_117":74,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"ctx",{"_110":-5,"_147":211,"_212":213,"_214":215,"_216":54,"_217":54,"_218":54,"_219":45,"_220":-5,"_221":-7,"_222":-7,"_223":91,"_224":54,"_225":54,"_226":-5,"_227":54,"_228":54,"_229":54,"_230":-5},"ENV",{"_182":183,"_184":185,"_186":16,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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"]

Code