[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_117":-5,"_20":118,"_22":119,"_120":121,"_122":123,"_25":124,"_24":-5,"_125":-5,"_126":-5,"_127":53,"_128":129,"_130":44,"_131":-5,"_132":-5,"_133":134},"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","APIAERO","name","hg","branchName","main","version","path","","project",{"_33":62,"_13":14,"_45":63,"_64":-5,"_65":53,"_66":67,"_68":67,"_69":19,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":95,"_96":97,"_98":99,"_100":53},"tree",[57],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_18":56},"id","40fc8ac8-e184-44a6-9740-786b6e57968a","main.ts","fileId","2f73800c-7e28-11f1-a917-1607ee4eb77e","parentId","branchId","1c2f8e6f-ba3b-4d1c-8cfe-46690f9294fc","branchVersion",7,"latest",true,"createdAt",["D",1783885412980],6,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n const action = url.searchParams.get(\"action\");\n\n // ==========================================\n // 1. INITIALISATION DE LA BASE DE DONNÉES\n // ==========================================\n // Ces commandes créent les fichiers de stockage directement sur le serveur Val Town\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS avia_clients (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nom TEXT NOT NULL,\n email TEXT,\n telephone TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS avia_vols (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n client_id INTEGER,\n date_vol TEXT,\n formule TEXT,\n performance_score INTEGER,\n ambiance TEXT,\n conseils TEXT\n )\n `);\n } catch (dbError) {\n console.error(\"Impossible d'initialiser la base SQLite intégrée:\", dbError);\n }\n\n // ==========================================\n // PARTIE ACTIONS (STOCKAGE & API backend)\n // ==========================================\n\n // Action : Liste des clients\n if (action === \"liste_clients\") {\n const result = await sqlite.execute(\n \"SELECT * FROM avia_clients ORDER BY nom ASC\",\n );\n return new Response(JSON.stringify(result.rows), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n }\n\n // Action : Créer un client\n if (action === \"creer_client\" && req.method === \"POST\") {\n try {\n const data = await req.json();\n if (!data.nom) {\n return new Response(\n JSON.stringify({ success: false, message: \"Nom manquant\" }),\n { status: 400 },\n );\n }\n\n // Insertion persistante dans la table SQL\n await sqlite.execute({\n sql:\n \"INSERT INTO avia_clients (nom, email, telephone) VALUES (:nom, :email, :telephone)\",\n args: {\n nom: data.nom,\n email: data.email || \"\",\n telephone: data.telephone || \"\",\n },\n });\n\n return new Response(\n JSON.stringify({\n success: true,\n message: \"Pilote créé avec succès dans le stockage central\",\n }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n },\n );\n } catch (e) {\n return new Response(\n JSON.stringify({ success: false, error: e.message }),\n { status: 500 },\n );\n }\n }\n\n // Action : Dossier complet d'un client (Infos + Vols)\n if (action === \"dossier_client\") {\n const id = url.searchParams.get(\"id\");\n const client = await sqlite.execute({\n sql: \"SELECT * FROM avia_clients WHERE id = :id\",\n args: { id },\n });\n const vols = await sqlite.execute({\n sql:\n \"SELECT * FROM avia_vols WHERE client_id = :id ORDER BY date_vol DESC\",\n args: { id },\n });\n return new Response(\n JSON.stringify({ info: client.rows[0], vols: vols.rows }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n },\n );\n }\n\n // Action : Ajouter un vol\n if (action === \"ajouter_vol\" && req.method === \"POST\") {\n try {\n const data = await req.json();\n await sqlite.execute({\n sql:\n \"INSERT INTO avia_vols (client_id, date_vol, formule, performance_score, ambiance, conseils) VALUES (:client_id, :date_vol, :formule, :performance_score, :ambiance, :conseils)\",\n args: {\n client_id: data.client_id,\n date_vol: data.date_vol,\n formule: data.formule,\n performance_score: data.performance_score,\n ambiance: data.ambiance,\n conseils: data.conseils,\n },\n });\n return new Response(\n JSON.stringify({\n success: true,\n message: \"Vol enregistré avec succès\",\n }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n },\n );\n } catch (e) {\n return new Response(\n JSON.stringify({ success: false, error: e.message }),\n { status: 500 },\n );\n }\n }\n\n // Gestion du protocole CORS\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"GET, POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n },\n });\n }\n\n // ==========================================\n // PARTIE VISUELLE : L'INTERFACE DU SITE\n // ==========================================\n const htmlCode = `\n\n\n \n AviaPassion | Central Flight System\n \n\n\n

\n $\"Logo\"$ \n

AviaPassion // Central Flight System

AVIA PASSION SIMULATION

Rapport d'Évaluation de Vol Officiel & Archivage Commandant

[SYSTEM] Recherche Pilote en Base de Données

\n \n

[DATA-ENTRY] Fiche d'Identité & Journal de Session

\n \n

\n Nom complet du client\n \n

\n Date de Naissance / Réf\n \n

\n Adresse E-mail\n \n

\n \n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Date & Formule	Score SOP (%)	Observations & Ambiance	Conseils de l'Instructeur
\n \n \n

\n \n \n

[ARCHIVES] Sessions passées

\n \n\n`;\n\n return new Response(htmlCode, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n });\n}","deleted",false,"label","pilote",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":58,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_59":60,"_18":61},["D",1783885412980],"children",[],[35],"985bb636-279c-4c79-bb26-31f6adb3f3b8",["D",1783884648449],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","1ef81022-1039-46cd-9a58-34fe213a5609","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e126f-76fd-750b-9680-34a2cc331b34","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_116":112},"org",{"_11":12,"_109":110,"_111":112,"_71":72,"_113":114,"_115":53},"branch",{"_17":42,"_13":16,"_33":40,"_101":62,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Youssouf Diarassouba","avatar","https://lh3.googleusercontent.com/a/ACg8ocJlcPa2YlMEUaljEo4LC2hcnvtSMnB8qko4w-BDwR_mtSV-aXE=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":62,"_13":14,"_45":150,"_64":-5,"_65":53,"_66":67,"_68":67,"_69":19,"_70":-5,"_71":72,"_73":-5,"_74":53,"_75":-5,"_76":-5,"_77":78,"_79":80,"_81":-5,"_82":-5,"_83":-5,"_84":-5,"_85":86,"_87":86,"_88":89,"_90":89,"_91":89,"_92":86,"_93":86,"_94":151,"_96":152,"_98":153,"_100":53},[147],"files",[147],"counts",{"_137":78,"_138":139,"_140":78,"_31":141,"_142":143},[135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_18":136},[35],"pulls","branches",1,"forks",{"_144":78,"_146":78},"connections",{"_144":78,"_145":78},"count","unfilledCount","emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":58,"_17":47,"_48":49,"_50":51,"_52":53,"_54":55,"_59":148,"_18":149},[],[35],["D",1783884648449],{"_11":12,"_116":112},{"_11":12,"_109":110,"_111":112,"_71":72,"_113":114,"_115":53},{"_17":42,"_13":16,"_33":40,"_101":62,"_102":-5,"_103":-5,"_104":-5,"_105":-5,"_106":-5,"_107":14,"_108":12},"ctx",{"_94":-5,"_132":187,"_188":189,"_190":191,"_192":53,"_193":53,"_194":53,"_195":44,"_196":-5,"_197":-7,"_198":-7,"_199":78,"_200":53,"_201":53,"_202":-5,"_203":53,"_204":53,"_205":53,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":16,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"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"]