[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_102":103,"_104":105},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","aurorinmagazine","name","mc5-relationship-engine","path","index.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/aurorinmagazine/mc5-relationship-engine/code/index.ts","extension","id","bb63bccf-4bb4-4c82-a572-f4d3b6b118b9","fileId","073cbf14-a4ab-11f1-8089-1607ee4eb77e","parentId","branchId","00a37e94-e65f-4137-8f61-ca83d3d09a17","branchVersion",2,"latest",true,"createdAt",["D",1788119051661],"version",1,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst ORACLE=\"https://aurorinmagazine--8d4cb4f6a3ac11f1809b1607ee4eb77e.web.val.run/\";\nconst json=(x:unknown,s=200,h:Record={})=>new Response(JSON.stringify(x),{status:s,headers:{\"content-type\":\"application/json\",\"cache-control\":\"no-store\",...h}});\nconst cors={\"access-control-allow-origin\":\"*\",\"access-control-allow-methods\":\"GET,POST,OPTIONS\",\"access-control-allow-headers\":\"content-type\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS relationship_events (id TEXT PRIMARY KEY, channel TEXT NOT NULL, external_id TEXT, contact TEXT, message TEXT NOT NULL, intent TEXT, route TEXT, status TEXT NOT NULL, consent TEXT, referral_code TEXT, created_at TEXT NOT NULL)`);try{await sqlite.execute(`ALTER TABLE relationship_events ADD COLUMN referral_code TEXT`);}catch{}}\nfunction classify(message:string){const m=message.toLowerCase();if(/audit|leak|losing|sales|leads|traffic|ads|advertising|conversion/.test(m))return \"BUSINESS_DIAGNOSTIC\";if(/price|cost|quote|hire|hunter|service/.test(m))return \"COMMERCIAL\";if(/previous|continue|again|last chat|we spoke/.test(m))return \"CONTINUE_PREVIOUS\";return \"GENERAL_5MC\";}\nfunction referralCode(seed:string){const clean=seed.replace(/[^a-z0-9]/gi,\"\").toUpperCase().slice(0,8)||\"5MC\";return `5MC-${clean}-${crypto.randomUUID().slice(0,6).toUpperCase()}`;}\nasync function concierge(message:string,channel:string){const kind=classify(message);let route=\"general\";let reply=\"Welcome to 5MC Performance. I’m here with you. Are you here for a business audit, a service/Hunter discussion, to continue a previous conversation, or to speak with 5MC?\";if(kind===\"BUSINESS_DIAGNOSTIC\"){route=\"audit\";try{const r=await fetch(ORACLE,{method:\"POST\",headers:{\"content-type\":\"application/json\"},body:JSON.stringify({prompt:`Customer inquiry received through ${channel}: ${message}`}),signal:AbortSignal.timeout(10000)});if(r.ok){const j=await r.json();reply=String(j.reply||reply)}}catch{reply=\"I can help diagnose the issue. Send your business name, website or social profile and the main outcome you need.\"}}else if(kind===\"COMMERCIAL\")reply=\"I can scope the right 5MC service or Hunter level. Tell me what you want built, repaired or automated and I’ll keep the conversation moving.\";else if(kind===\"CONTINUE_PREVIOUS\")reply=\"I can continue a previous discussion only when the previous conversation is actually available to this system. I will not invent or guess missing history. Please send the last message or a reference and I’ll resume accurately.\";return {kind,route,reply};}\nasync function handleInbound(body:Record,channel:string){await db();const message=String(body.message||\"\").trim();if(!message)return json({ok:false,error:\"message is required\"},400,cors);const result=await concierge(message,channel);const eventId=crypto.randomUUID();const contact=body.contact?String(body.contact):null;const externalId=body.externalId?String(body.externalId):null;const referral=body.referralCode?String(body.referralCode):null;await sqlite.execute({sql:\"INSERT INTO relationship_events (id,channel,external_id,contact,message,intent,route,status,consent,referral_code,created_at) VALUES (?,?,?,?,?,?,?,?,?,?,?)\",args:[eventId,channel,externalId,contact,message,result.kind,result.route,\"received\",\"unknown\",referral,new Date().toISOString()]});return json({ok:true,eventId,channel,intent:result.kind,route:result.route,reply:result.reply,historyAvailable:false,deliveryStatus:channel===\"whatsapp\"?\"INBOUND_WEBHOOK_READY_OUTBOUND_META_NOT_CONNECTED\":\"INTERNAL_REFERRAL_READY\"},201,cors);}\nexport default async function(req:Request){const u=new URL(req.url);if(req.method===\"OPTIONS\")return new Response(null,{status:204,headers:cors});try{if(req.method===\"GET\"&&u.pathname===\"/health\")return json({ok:true,system:\"5MC Relationship Engine\",whatsapp:{status:\"WEBHOOK_READY_REQUIRES_META_CREDENTIALS\"},referrals:{status:\"ACTIVE\"},oracle:{status:\"CONNECTED\"} },200,cors);if(req.method===\"GET\"&&u.pathname===\"/\")return new Response(`5MC Relationship Engine

5MC Relationship Engine

WhatsApp inbound webhook and referral intake are available. WhatsApp outbound delivery requires Meta credentials and activation.

Return to 5MC Customer Service →

`,{headers:{\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"}});if(req.method===\"GET\"&&u.pathname===\"/api/whatsapp/webhook\"){const configured=Deno.env.get(\"WHATSAPP_VERIFY_TOKEN\");const mode=u.searchParams.get(\"hub.mode\");const token=u.searchParams.get(\"hub.verify_token\");const challenge=u.searchParams.get(\"hub.challenge\");if(configured&&mode===\"subscribe\"&&token===configured&&challenge)return new Response(challenge,{status:200,headers:{\"content-type\":\"text/plain\"}});return json({ok:false,error:\"WhatsApp webhook verification is not configured or token is invalid.\"},403,cors);}if(req.method===\"POST\"&&u.pathname===\"/api/whatsapp/webhook\"){const payload=await req.json().catch(()=>null);if(!payload||typeof payload!==\"object\")return json({ok:false,error:\"Invalid webhook payload\"},400,cors);return await handleInbound({externalId:(payload as any).entry?.[0]?.id||undefined,message:(payload as any).entry?.[0]?.changes?.[0]?.value?.messages?.[0]?.text?.body||\"\",contact:(payload as any).entry?.[0]?.changes?.[0]?.value?.contacts?.[0]?.wa_id||undefined},\"whatsapp\");}if(req.method===\"POST\"&&u.pathname===\"/api/referral\"){const body=await req.json().catch(()=>null);const seed=String(body?.referrer||body?.name||\"REFERRER\");return json({ok:true,referralCode:referralCode(seed),status:\"READY_TO_ATTRIBUTE\"},201,cors);}if(req.method===\"POST\"&&u.pathname===\"/api/intake\")return await handleInbound(await req.json(),String((await req.clone().json().catch(()=>({})))?.channel||\"referral\"));return json({ok:false,error:\"Method not allowed\"},405,cors);}catch(e){console.error(e);return json({ok:false,error:e instanceof Error?e.message:\"Relationship engine error\"},500,cors);}}\n","deleted",false,"label",[14],"54259d05-1469-406b-8f76-3181d7898d8d",["D",1788118989213],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","5MC WhatsApp and referral intake engine","imageUrl","userId","1066b61b-f70a-46a7-8125-91c596378659","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a02a5a-86ef-7312-9a9e-ddcd707af361","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_101":97},"org",{"_9":10,"_94":95,"_96":97,"_55":56,"_98":99,"_100":42},"branch",{"_35":30,"_11":85,"_22":28,"_86":45,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":12,"_93":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Aurorin Magazine","avatar","https://lh3.googleusercontent.com/a/ACg8ocJ8i2UIZrlsQap-nn3UPmSBKMkeYfBAHCiy5Y-K4y1DhFt-Bh4=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_78":-5,"_135":136,"_137":138,"_139":140,"_141":42,"_142":42,"_143":42,"_144":32,"_145":-5,"_146":-7,"_147":-7,"_148":62,"_149":42,"_150":42,"_151":-5,"_152":42,"_153":42,"_154":42,"_155":-5},"ENV",{"_106":107,"_108":109,"_110":85,"_111":112,"_113":114,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]