[{"_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",{"_95":94,"_32":45,"_104":85,"_27":53,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125},"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":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",22,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.ts","latestPath","fileId","459aca92-5e67-11f1-8e30-1607ee4eb77e","name","fileType","http","content","import { Buffer } from \"node:buffer\";\n\n// 🔑 --- CONFIGURATION DE VOTRE COMPTE BASEROW ---\nconst BASEROW_TOKEN = \"WDdLWaaujGge3U2Bi5JmY9q2yjdIguGx\";\nconst BASEROW_TABLE_ID = \"1000513\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n let items: any[] = [];\n let isManualButton = false;\n\n // 1. ADAPTATION DU FLUX (Bouton GET ou Webhook POST)\n if (req.method === \"GET\") {\n isManualButton = true;\n const rawRowId = url.searchParams.get(\"id\");\n const nameParam = url.searchParams.get(\"name\");\n const phoneParam = url.searchParams.get(\"phone\");\n const amountParam = url.searchParams.get(\"amount\");\n\n if (!rawRowId) {\n return new Response(\n \"⚠️ Erreur : Aucun ID de ligne fourni dans l'URL du bouton.\",\n { status: 400 },\n );\n }\n\n const rowId = rawRowId.replace(/[^0-9]/g, \"\");\n console.log(\n `🎯 Clic manuel détecté pour la ligne ID: ${rowId}. Récupération du document depuis Baserow...`,\n );\n\n try {\n const baserowUrl =\n `https://api.baserow.io/api/database/rows/table/${BASEROW_TABLE_ID}/${rowId}/?user_field_names=true`;\n const baserowResp = await fetch(baserowUrl, {\n headers: { \"Authorization\": `Token ${BASEROW_TOKEN}` },\n });\n\n if (!baserowResp.ok) {\n const baserowErrorText = await baserowResp.text();\n return new Response(\n `\n

❌ Erreur renvoyée par Baserow (Code ${baserowResp.status})

Détails : ${baserowErrorText}

\n `,\n {\n status: 400,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n },\n );\n }\n\n const rowData = await baserowResp.json();\n items = [{\n ...rowData,\n \"Phone Number\": phoneParam || rowData[\"Phone Number\"],\n \"Full Name\": nameParam || rowData[\"Full Name\"],\n \"Allocated Amount\": amountParam || rowData[\"Allocated Amount\"],\n }];\n } catch (err: any) {\n return new Response(\n `Erreur d'initialisation de la requête Baserow : ${err.message}`,\n { status: 500 },\n );\n }\n } else if (req.method === \"POST\") {\n const payload = await req.json();\n items = payload.items || [payload];\n } else {\n return new Response(\"Méthode non autorisée\", { status: 405 });\n }\n\n // 2. LOGIQUE DE TRAITEMENT ET D'ENVOI WHATSAPP\n try {\n let successCount = 0;\n let lastErrorDetails = \"\";\n\n for (const item of items) {\n const getField = (obj: any, key: string): any => {\n if (!obj) return \"\";\n const val = obj[key] !== undefined\n ? obj[key]\n : (obj.values?.[key] !== undefined\n ? obj.values[key]\n : obj.row_values?.[key]);\n\n if (!val) return \"\";\n if (Array.isArray(val)) {\n return val.length === 0\n ? \"\"\n : (val[0]?.value || val[0]?.name || String(val[0]));\n }\n return val.value || val.name || String(val);\n };\n\n const phoneRaw = getField(item, \"Phone Number\") || \"\";\n const phone = phoneRaw.replace(/[^0-9]/g, \"\");\n\n const fullName = getField(item, \"Full Name\") || \"Client\";\n const firstName = fullName.trim().split(\" \")[0];\n\n const amountNum = parseFloat(getField(item, \"Allocated Amount\")) || 0;\n const amount = amountNum.toFixed(2);\n\n let pdfUrl = \"\";\n const docField = item[\"Invoice Document\"] ||\n item.values?.[\"Invoice Document\"] ||\n item.row_values?.[\"Invoice Document\"];\n if (docField && docField.length > 0) {\n pdfUrl = docField[0].url;\n }\n\n if (!phone || !pdfUrl) {\n lastErrorDetails = `Données manquantes. Téléphone : \"${\n phone || \"ABSENT\"\n }\", Reçu PDF : \"${pdfUrl ? \"GÉNÉRÉ\" : \"MANQUANT\"}\"`;\n continue;\n }\n\n console.log(`🚀 Téléchargement du reçu pour ${firstName} (${phone})...`);\n\n const pdfResp = await fetch(pdfUrl);\n const pdfBuffer = await pdfResp.arrayBuffer();\n const base64Media = Buffer.from(pdfBuffer).toString(\"base64\");\n\n // Configuration Evolution API\n const EVO_URL = \"https://whatsapp.poin.care\";\n const INSTANCE = \"whatsapp-n8n\";\n const APIKEY = \"260AA2B46DAA-46CE-819D-A4396E1AC755\";\n\n const captionText =\n `Bonjour ${firstName} 👋,\\n\\nNous vous confirmons la bonne réception de votre paiement de *${amount} DT*.\\n\\nMerci pour votre confiance ! 😊`;\n\n const evoRes = await fetch(`${EVO_URL}/message/sendMedia/${INSTANCE}`, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n \"apikey\": APIKEY,\n },\n body: JSON.stringify({\n number: phone,\n mediatype: \"document\",\n mimetype: \"application/pdf\",\n fileName: `Recu_Poincare.pdf`,\n caption: captionText,\n media: base64Media,\n }),\n });\n\n if (!evoRes.ok) {\n const err = await evoRes.text();\n console.error(`❌ Erreur API Evolution :`, err);\n\n try {\n const errObj = JSON.parse(err);\n // Interception chirurgicale du numéro introuvable sur WhatsApp\n if (\n errObj.response?.message?.[0]?.exists === false ||\n errObj.message?.[0]?.exists === false\n ) {\n lastErrorDetails =\n `Le numéro de téléphone (${phone}) n'est pas relié à un compte WhatsApp actif.`;\n } else {\n lastErrorDetails = `Evolution API : ${\n errObj.error || errObj.message || err\n }`;\n }\n } catch {\n lastErrorDetails = `Erreur Evolution API (${evoRes.status})`;\n }\n } else {\n console.log(`✅ Message WhatsApp envoyé avec succès à ${firstName} !`);\n successCount++;\n }\n }\n\n // Rendu visuel propre pour l'utilisateur suite au clic bouton\n if (isManualButton) {\n if (successCount > 0) {\n return new Response(\n `\n

✅ Reçu WhatsApp envoyé !

Le document a été transmis avec succès. Vous pouvez fermer cet onglet.

\n `,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n } else {\n return new Response(\n `\n

⚠️ L'envoi WhatsApp a été annulé

${\n lastErrorDetails ||\n \"Le document PDF n'est pas présent ou n'a pas pu être récupéré.\"\n }

\n `,\n {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n },\n );\n }\n }\n\n return new Response(\"Webhook traité avec succès\", { status: 200 });\n } catch (e: any) {\n console.error(\"Erreur critique :\", e.message);\n return new Response(e.message, { status: 500 });\n }\n}","import { Buffer } from \"node:buffer\";\n\nconst BASEROW_TOKEN = \"WDdLWaaujGge3U2Bi5JmY9q2yjdIguGx\";\nconst BASEROW_TABLE_ID = \"1000513\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n let items: any[] = [];\n let isManualButton = false;\n\n if (req.method === \"GET\") {\n isManualButton = true;\n const rawRowId = url.searchParams.get(\"id\");\n const nameParam = url.searchParams.get(\"name\");\n const phoneParam = url.searchParams.get(\"phone\");\n const amountParam = url.searchParams.get(\"amount\");\n\n if (!rawRowId) {\n return new Response(\"⚠️ Erreur : Aucun ID de ligne fourni.\", {\n status: 400,\n });\n }\n\n const rowId = rawRowId.replace(/[^0-9]/g, \"\");\n\n try {\n const baserowUrl =\n `https://api.baserow.io/api/database/rows/table/${BASEROW_TABLE_ID}/${rowId}/?user_field_names=true`;\n const baserowResp = await fetch(baserowUrl, {\n headers: { \"Authorization\": `Token ${BASEROW_TOKEN}` },\n });\n\n if (!baserowResp.ok) {\n const errTxt = await baserowResp.text();\n return new Response(\n `

❌ Erreur Baserow : ${errTxt}

`,\n {\n status: 400,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n },\n );\n }\n\n const rowData = await baserowResp.json();\n items = [{\n ...rowData,\n \"Phone Number\": phoneParam || rowData[\"Phone Number\"],\n \"Full Name\": nameParam || rowData[\"Full Name\"],\n \"Allocated Amount\": amountParam || rowData[\"Allocated Amount\"],\n }];\n } catch (err: any) {\n return new Response(`Erreur d'initialisation : ${err.message}`, {\n status: 500,\n });\n }\n } else if (req.method === \"POST\") {\n const payload = await req.json();\n items = payload.items || [payload];\n } else {\n return new Response(\"Méthode non autorisée\", { status: 405 });\n }\n\n // LOGIQUE WHATSAPP\n try {\n let successCount = 0;\n let lastErrorDetails = \"\";\n\n for (const item of items) {\n const getField = (obj: any, key: string): any => {\n if (!obj) return \"\";\n const val = obj[key] !== undefined\n ? obj[key]\n : (obj.values?.[key] !== undefined\n ? obj.values[key]\n : obj.row_values?.[key]);\n if (!val) return \"\";\n if (Array.isArray(val)) {\n return val.length === 0\n ? \"\"\n : (val[0]?.value || val[0]?.name || String(val[0]));\n }\n return val.value || val.name || String(val);\n };\n\n const phoneRaw = getField(item, \"Phone Number\") || \"\";\n const phone = phoneRaw.replace(/[^0-9]/g, \"\");\n\n const fullName = getField(item, \"Full Name\") || \"Client\";\n const firstName = fullName.trim().split(\" \")[0];\n\n const amountNum = parseFloat(getField(item, \"Allocated Amount\")) || 0;\n\n // 🛑 LE VIGILE ANTI-SPAM : Si le montant est de 0, on annule l'envoi WhatsApp !\n if (amountNum <= 0) {\n console.log(\n `⚠️ Action ignorée : Le montant calculé pour ${firstName} est de 0 DT.`,\n );\n continue;\n }\n\n const amount = amountNum.toFixed(2);\n\n let pdfUrl = \"\";\n const docField = item[\"Invoice Document\"] ||\n item.values?.[\"Invoice Document\"] ||\n item.row_values?.[\"Invoice Document\"];\n if (docField && docField.length > 0) pdfUrl = docField[0].url;\n\n if (!phone || !pdfUrl) {\n lastErrorDetails = `Téléphone ou PDF manquant pour ${firstName}.`;\n console.log(`⚠️ ${lastErrorDetails}`);\n continue;\n }\n\n const pdfResp = await fetch(pdfUrl);\n const pdfBuffer = await pdfResp.arrayBuffer();\n const base64Media = Buffer.from(pdfBuffer).toString(\"base64\");\n\n const EVO_URL = \"https://whatsapp.poin.care\";\n const INSTANCE = \"whatsapp-n8n\";\n const APIKEY = \"260AA2B46DAA-46CE-819D-A4396E1AC755\";\n\n const captionText =\n `Bonjour ${firstName} 👋,\\n\\nNous vous confirmons la bonne réception de votre paiement de *${amount} DT*.\\n\\nMerci pour votre confiance ! 😊`;\n\n const evoRes = await fetch(`${EVO_URL}/message/sendMedia/${INSTANCE}`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\", \"apikey\": APIKEY },\n body: JSON.stringify({\n number: phone,\n mediatype: \"document\",\n mimetype: \"application/pdf\",\n fileName: `Recu_Poincare.pdf`,\n caption: captionText,\n media: base64Media,\n }),\n });\n\n if (!evoRes.ok) {\n console.error(`❌ Erreur API Evolution`);\n } else {\n console.log(`✅ Message WhatsApp envoyé avec succès à ${firstName} !`);\n successCount++;\n }\n }\n\n if (isManualButton) {\n if (successCount > 0) {\n return new Response(\n `

✅ Reçu WhatsApp envoyé !

`,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n } else {\n return new Response(\n `

⚠️ Envoi annulé

${\n lastErrorDetails || \"PDF absent ou montant à 0.\"\n }

`,\n {\n status: 200,\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n },\n );\n }\n }\n\n return new Response(\"Webhook traité avec succès\", { status: 200 });\n } catch (e: any) {\n return new Response(e.message, { status: 500 });\n }\n}","createdAt",["D",1780488753090],"branchVersion","branchId","459899a2-5e67-11f1-8e30-1607ee4eb77e","id","459782c4-5e67-11f1-8e30-1607ee4eb77e","AutoSendInvoice",["D",1780393306739],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","","imageUrl","a214b031-d1fa-421b-8a8f-14f20a862277","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019dddd6-f12f-720e-b7f4-15afca913bf7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_103":99},"org",{"_95":94,"_96":97,"_98":99,"_18":55,"_100":101,"_102":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",25,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","devpoincare","handle","displayName","Dev Poincare","avatar","https://lh3.googleusercontent.com/a/ACg8ocIbzlYrxy-TCul8F_rixmFltAwc1RmSWPQGKJUktcXwg9sWAA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":150,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":151,"_79":152,"_81":153,"_83":25},"tree",[145],"files",[145],"counts",{"_134":61,"_135":136,"_137":61,"_138":139,"_140":141},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"800eb998-5f45-11f1-b725-1607ee4eb77e","parentId","latest",["D",1780488753090],21,"label",[28],"pulls","branches",1,"forks","envVars",{"_142":61,"_144":61},"connections",{"_142":61,"_143":61},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":25,"_38":146,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_147":148,"_27":149},["D",1780488753090],"children",[],[28],["D",1780393306739],{"_95":94,"_103":99},{"_95":94,"_96":97,"_98":99,"_18":55,"_100":101,"_102":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_123":187,"_188":189,"_190":191,"_192":25,"_193":25,"_194":25,"_195":121,"_196":-5,"_197":-7,"_198":-7,"_199":61,"_200":25,"_201":25,"_202":-5,"_203":25,"_204":25,"_205":25,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":85,"_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"]

Diff · v22