[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_155":156,"_157":158},"routes/_app.x.$handle.$name",{"_97":96,"_31":43,"_106":87,"_26":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":24,"_121":122,"_123":56,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":30,"_55":56,"_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":24},"version",1,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","index.ts","latestPath","fileId","b0dc8e0e-a3bc-11f1-9c56-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst SERVICES: Record = {\n advertising:{name:\"Digital Advertising\",outcome:\"Campaign brief, audience plan, creative requirements and launch checklist\",steps:[\"Diagnose offer and target customer\",\"Define campaign objective and conversion event\",\"Build audience and channel plan\",\"Prepare creative requirements\",\"Set tracking and lead capture\",\"Launch, monitor and optimize\"]},\n video:{name:\"Ad Videos & Content\",outcome:\"Production brief, script structure, shot list and delivery checklist\",steps:[\"Define campaign message and audience\",\"Create hook and script structure\",\"Build shot list/storyboard\",\"Production or asset collection\",\"Edit and quality review\",\"Prepare platform-ready exports\"]},\n branding:{name:\"Branding & Rebranding\",outcome:\"Brand discovery brief, identity direction and asset checklist\",steps:[\"Brand discovery and positioning\",\"Audience and competitor review\",\"Identity direction\",\"Logo and visual system requirements\",\"Asset production checklist\",\"Brand handoff and usage guide\"]},\n web:{name:\"Websites & Landing Pages\",outcome:\"Conversion architecture, page scope and launch checklist\",steps:[\"Define business goal and conversion action\",\"Map visitor journey\",\"Create sitemap and page requirements\",\"Design conversion sections\",\"Implement forms/integrations\",\"QA, analytics and launch\"]},\n promotion:{name:\"Social & 360° Promotion\",outcome:\"Promotion plan, content schedule and campaign checklist\",steps:[\"Define promotion objective\",\"Channel and audience mapping\",\"Content and offer plan\",\"Publishing schedule\",\"Campaign execution\",\"Performance review and iteration\"]},\n creative:{name:\"Graphics & Business Design\",outcome:\"Creative brief, specifications and production queue\",steps:[\"Confirm use case and audience\",\"Define dimensions and platform\",\"Create copy/content requirements\",\"Design production\",\"Review and revisions\",\"Export delivery package\"]},\n seo:{name:\"SEO & Google Business\",outcome:\"Search visibility action plan and optimization checklist\",steps:[\"Audit public search presence\",\"Identify priority queries and local signals\",\"Optimize business information\",\"Improve on-page search foundations\",\"Build content/citation opportunities\",\"Measure visibility and refine\"]},\n automation:{name:\"Lead Capture & Automation\",outcome:\"Lead-flow map, automation specification and deployment checklist\",steps:[\"Map lead journey\",\"Define capture fields and qualification\",\"Design routing and notifications\",\"Connect CRM/sheets/database\",\"Test edge cases\",\"Deploy and monitor\"]},\n media:{name:\"Cinematography & Media\",outcome:\"Production brief, shot plan and post-production checklist\",steps:[\"Creative concept and objective\",\"Location/talent/logistics plan\",\"Shot list and production schedule\",\"Capture footage\",\"Edit and quality control\",\"Master and delivery\"]},\n verification:{name:\"Business Verification\",outcome:\"Verification readiness checklist and evidence package\",steps:[\"Identify platform and requirements\",\"Audit business information consistency\",\"Prepare required evidence\",\"Submit/complete verification workflow\",\"Track status\",\"Resolve requested corrections\"]},\n systems:{name:\"AI & Smart Business Systems\",outcome:\"System specification, workflow map and implementation plan\",steps:[\"Discover operational bottleneck\",\"Define inputs, outputs and rules\",\"Design AI/workflow architecture\",\"Build integrations\",\"Test reliability and safeguards\",\"Deploy and monitor\"]},\n documents:{name:\"Documents & Presentation Assets\",outcome:\"Document brief, content architecture and production checklist\",steps:[\"Define audience and purpose\",\"Collect source information\",\"Structure content\",\"Design document/presentation\",\"Review accuracy and consistency\",\"Export final package\"]}\n};\n\nfunction json(data:unknown,status=200){return Response.json(data,{status,headers:{\"cache-control\":\"no-store\"}})}\nfunction keyForService(name:string){const n=name.toLowerCase(); if(n.includes(\"advertising\")||n.includes(\"ads\"))return \"advertising\";if(n.includes(\"video\"))return \"video\";if(n.includes(\"brand\"))return \"branding\";if(n.includes(\"web\"))return \"web\";if(n.includes(\"promotion\"))return \"promotion\";if(n.includes(\"graphic\"))return \"creative\";if(n.includes(\"seo\")||n.includes(\"google\"))return \"seo\";if(n.includes(\"lead\")||n.includes(\"automation\"))return \"automation\";if(n.includes(\"cinematography\")||n.includes(\"media\"))return \"media\";if(n.includes(\"verification\"))return \"verification\";if(n.includes(\"ai\")||n.includes(\"system\"))return \"systems\";return \"documents\"}\n\nasync function init(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS projects(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, contact TEXT, service_key TEXT, service_name TEXT, timeline TEXT, brief TEXT, status TEXT, created_at TEXT)`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS tasks(id INTEGER PRIMARY KEY AUTOINCREMENT, project_id INTEGER, step_no INTEGER, title TEXT, status TEXT, created_at TEXT)`)}\n\nexport default async function(req:Request){await init();const url=new URL(req.url);if(req.method===\"GET\"&&url.pathname===\"/\"){return new Response(`

5MC Service Execution Engine

Operational engine hub. Select a service to begin execution.

${v.name}

`,{headers:{\"content-type\":\"text/html\"})}if(req.method===\"GET\"&&url.pathname===\"/api/services\"){return json(SERVICES)}if(req.method===\"POST\"&&url.pathname===\"/api/execute\"){const body=await req.json().catch(()=>null);if(!body?.name||!body?.contact||!body?.service)return json({error:\"name, contact and service are required\"},400);const serviceKey=SERVICES[body.service]?body.service:keyForService(body.service);const s=SERVICES[serviceKey]||SERVICES.documents;const now=new Date().toISOString();const result=await sqlite.execute({sql:`INSERT INTO projects(name,contact,service_key,service_name,timeline,brief,status,created_at) VALUES(?,?,?,?,?,?,?,?)`,args:[String(body.name).slice(0,200),String(body.contact).slice(0,200),serviceKey,s.name,String(body.timeline||\"standard\").slice(0,100),String(body.brief||\"\").slice(0,5000),\"queued\",now]});const id=Number(result.lastInsertRowid);for(let i=0;i({step:i+1,title,status:i===0?\"ready\":\"queued\"}))},201)}if(req.method===\"GET\"&&url.pathname===\"/api/project\"){const id=Number(url.searchParams.get(\"id\"));if(!id)return json({error:\"id required\"},400);const p=await sqlite.execute({sql:`SELECT * FROM projects WHERE id=?`,args:[id]});const t=await sqlite.execute({sql:`SELECT step_no,title,status FROM tasks WHERE project_id=? ORDER BY step_no`,args:[id]});if(!p.rows.length)return json({error:\"project not found\"},404);return json({project:p.rows[0],tasks:t.rows})}return json({error:\"Not found\"},404)}\n","createdAt",["D",1788016624151],"branchVersion","branchId","2ab34335-fa22-4373-a1af-bdcbf80ff8f6","id","c811235d-7399-47c7-914a-5abcdc76c707","mc5-service-engines",["D",1788016624119],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","5MC service execution engine hub","imageUrl","1066b61b-f70a-46a7-8125-91c596378659","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a02a5a-86ef-7312-9a9e-ddcd707af361","tursoName","c811235d739947c7914a5abcdc76c707","tursoHostname","c811235d739947c7914a5abcdc76c707-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789579303050],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_105":101},"org",{"_97":96,"_98":99,"_100":101,"_18":53,"_102":103,"_104":24},"branch",{"_13":86,"_31":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"isOwned",106,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","aurorinmagazine","handle","displayName","Aurorin Magazine","avatar","https://lh3.googleusercontent.com/a/ACg8ocJ8i2UIZrlsQap-nn3UPmSBKMkeYfBAHCiy5Y-K4y1DhFt-Bh4=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":150,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":151,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":152,"_81":153,"_83":154,"_85":24},"tree",[145],"files",[145],"counts",{"_135":60,"_136":14,"_137":60,"_138":139,"_140":141},"contents",[128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":129,"_31":27,"_29":30,"_130":-5,"_39":40,"_38":14,"_131":24,"_36":132,"_13":60,"_32":33,"_34":35,"_23":24,"_133":-5,"_26":134},"eb0b4694-d9d5-42ef-aef0-a0ee4eb9d919","parentId","latest",["D",1788016624151],"label",[27],"pulls","branches","forks","envVars",{"_142":60,"_144":60},"connections",{"_142":60,"_143":60},"count","unfilledCount","emptyCount",{"_41":129,"_31":27,"_29":30,"_130":-5,"_39":40,"_38":14,"_131":24,"_36":146,"_13":60,"_32":33,"_34":35,"_23":24,"_133":-5,"_147":148,"_26":149},["D",1788016624151],"children",[],[27],["D",1788016624119],["D",1789579303050],{"_97":96,"_105":101},{"_97":96,"_98":99,"_100":101,"_18":53,"_102":103,"_104":24},{"_13":86,"_31":87,"_41":40,"_88":42,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":43,"_95":96},"ctx",{"_79":-5,"_125":188,"_189":190,"_191":192,"_193":24,"_194":24,"_195":24,"_196":56,"_197":-5,"_198":-7,"_199":-7,"_200":60,"_201":24,"_202":24,"_203":-5,"_204":24,"_205":24,"_206":24,"_207":-5},"ENV",{"_159":160,"_161":162,"_163":87,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187},"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"]

Diff · v1