[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_580":581,"_582":583},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_107":88,"_26":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":24,"_122":123,"_124":57,"_125":-5,"_126":-5,"_127":128},"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":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":24},"version",80,"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","client-project-control.ts","latestPath","fileId","e49bf59a-a579-11f1-a446-1607ee4eb77e","name","fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS client_projects (id TEXT PRIMARY KEY,client_ref TEXT NOT NULL,project_name TEXT NOT NULL,service_path TEXT NOT NULL,current_engine TEXT NOT NULL,status TEXT NOT NULL,owner TEXT NOT NULL,brief_ref TEXT NOT NULL,success_criteria TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nconst engines=[\"GROW\",\"CREATIVE\",\"DIGITAL\",\"PROMOTION\"];const statuses=[\"intake\",\"active\",\"awaiting_client\",\"blocked\",\"completed\",\"closed\"];\nexport default async function(req:Request){await db();if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"client_ref\",\"project_name\",\"service_path\",\"current_engine\",\"status\",\"owner\",\"brief_ref\",\"success_criteria\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete client project record\",missing},{status:400});if(!engines.includes(b.current_engine)||!statuses.includes(b.status))return Response.json({error:\"Invalid engine or project status\"},{status:400});const id=`CPR-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO client_projects VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...keys.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,projectId:id},{headers:J})}const rows:any[]=(await sqlite.execute(`SELECT * FROM client_projects ORDER BY updated_at DESC`)).rows;return Response.json({projects:rows,enginePath:engines,statuses},{headers:J})}","createdAt",["D",1788207837012],"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","b0dc8e0e-a3bc-11f1-9c56-1607ee4eb77e","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",1789492855745],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"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":575,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":576,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":577,"_82":578,"_84":579,"_86":24},"tree",[430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465],"files",[430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465],"counts",{"_420":61,"_421":252,"_422":61,"_423":424,"_425":426},"contents",[129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":413,"_31":414,"_29":415,"_168":-5,"_39":40,"_38":416,"_170":57,"_36":417,"_13":252,"_32":33,"_34":418,"_23":24,"_173":-5,"_26":419},{"_41":406,"_31":407,"_29":408,"_168":-5,"_39":40,"_38":409,"_170":57,"_36":410,"_13":215,"_32":33,"_34":411,"_23":24,"_173":-5,"_26":412},{"_41":403,"_31":27,"_29":30,"_168":-5,"_39":40,"_38":14,"_170":57,"_36":404,"_13":61,"_32":33,"_34":35,"_23":24,"_173":-5,"_26":405},{"_41":396,"_31":397,"_29":398,"_168":-5,"_39":40,"_38":399,"_170":57,"_36":400,"_13":61,"_32":33,"_34":401,"_23":24,"_173":-5,"_26":402},{"_41":389,"_31":390,"_29":391,"_168":-5,"_39":40,"_38":392,"_170":57,"_36":393,"_13":61,"_32":33,"_34":394,"_23":24,"_173":-5,"_26":395},{"_41":382,"_31":383,"_29":384,"_168":-5,"_39":40,"_38":385,"_170":57,"_36":386,"_13":61,"_32":33,"_34":387,"_23":24,"_173":-5,"_26":388},{"_41":374,"_31":375,"_29":376,"_168":-5,"_39":40,"_38":377,"_170":57,"_36":378,"_13":379,"_32":33,"_34":380,"_23":24,"_173":-5,"_26":381},{"_41":367,"_31":368,"_29":369,"_168":-5,"_39":40,"_38":370,"_170":57,"_36":371,"_13":61,"_32":33,"_34":372,"_23":24,"_173":-5,"_26":373},{"_41":360,"_31":361,"_29":362,"_168":-5,"_39":40,"_38":363,"_170":57,"_36":364,"_13":215,"_32":33,"_34":365,"_23":24,"_173":-5,"_26":366},{"_41":353,"_31":354,"_29":355,"_168":-5,"_39":40,"_38":356,"_170":57,"_36":357,"_13":61,"_32":33,"_34":358,"_23":24,"_173":-5,"_26":359},{"_41":346,"_31":347,"_29":348,"_168":-5,"_39":40,"_38":349,"_170":57,"_36":350,"_13":61,"_32":33,"_34":351,"_23":24,"_173":-5,"_26":352},{"_41":339,"_31":340,"_29":341,"_168":-5,"_39":40,"_38":342,"_170":57,"_36":343,"_13":61,"_32":33,"_34":344,"_23":24,"_173":-5,"_26":345},{"_41":332,"_31":333,"_29":334,"_168":-5,"_39":40,"_38":335,"_170":57,"_36":336,"_13":252,"_32":33,"_34":337,"_23":24,"_173":-5,"_26":338},{"_41":325,"_31":326,"_29":327,"_168":-5,"_39":40,"_38":328,"_170":57,"_36":329,"_13":252,"_32":33,"_34":330,"_23":24,"_173":-5,"_26":331},{"_41":318,"_31":319,"_29":320,"_168":-5,"_39":40,"_38":321,"_170":57,"_36":322,"_13":61,"_32":33,"_34":323,"_23":24,"_173":-5,"_26":324},{"_41":311,"_31":312,"_29":313,"_168":-5,"_39":40,"_38":314,"_170":57,"_36":315,"_13":61,"_32":33,"_34":316,"_23":24,"_173":-5,"_26":317},{"_41":304,"_31":305,"_29":306,"_168":-5,"_39":40,"_38":307,"_170":57,"_36":308,"_13":61,"_32":33,"_34":309,"_23":24,"_173":-5,"_26":310},{"_41":298,"_31":299,"_29":300,"_168":-5,"_39":40,"_38":274,"_170":57,"_36":301,"_13":61,"_32":237,"_34":302,"_23":24,"_173":-5,"_26":303},{"_41":291,"_31":292,"_29":293,"_168":-5,"_39":40,"_38":294,"_170":57,"_36":295,"_13":61,"_32":33,"_34":296,"_23":24,"_173":-5,"_26":297},{"_41":284,"_31":285,"_29":286,"_168":-5,"_39":40,"_38":287,"_170":57,"_36":288,"_13":252,"_32":33,"_34":289,"_23":24,"_173":-5,"_26":290},{"_41":277,"_31":278,"_29":279,"_168":-5,"_39":40,"_38":280,"_170":57,"_36":281,"_13":61,"_32":33,"_34":282,"_23":24,"_173":-5,"_26":283},{"_41":269,"_31":270,"_29":271,"_168":-5,"_39":40,"_38":272,"_170":57,"_36":273,"_13":274,"_32":33,"_34":275,"_23":24,"_173":-5,"_26":276},{"_41":262,"_31":263,"_29":264,"_168":-5,"_39":40,"_38":265,"_170":57,"_36":266,"_13":61,"_32":33,"_34":267,"_23":24,"_173":-5,"_26":268},{"_41":255,"_31":256,"_29":257,"_168":-5,"_39":40,"_38":258,"_170":57,"_36":259,"_13":61,"_32":33,"_34":260,"_23":24,"_173":-5,"_26":261},{"_41":247,"_31":248,"_29":249,"_168":-5,"_39":40,"_38":250,"_170":57,"_36":251,"_13":252,"_32":33,"_34":253,"_23":24,"_173":-5,"_26":254},{"_41":240,"_31":241,"_29":242,"_168":-5,"_39":40,"_38":243,"_170":57,"_36":244,"_13":61,"_32":33,"_34":245,"_23":24,"_173":-5,"_26":246},{"_41":232,"_31":233,"_29":234,"_168":-5,"_39":40,"_38":235,"_170":57,"_36":236,"_13":61,"_32":237,"_34":238,"_23":24,"_173":-5,"_26":239},{"_41":225,"_31":226,"_29":227,"_168":-5,"_39":40,"_38":228,"_170":57,"_36":229,"_13":61,"_32":33,"_34":230,"_23":24,"_173":-5,"_26":231},{"_41":218,"_31":219,"_29":55,"_168":-5,"_39":40,"_38":220,"_170":57,"_36":221,"_13":222,"_32":33,"_34":223,"_23":24,"_173":-5,"_26":224},{"_41":210,"_31":211,"_29":212,"_168":-5,"_39":40,"_38":213,"_170":57,"_36":214,"_13":215,"_32":33,"_34":216,"_23":24,"_173":-5,"_26":217},{"_41":203,"_31":204,"_29":205,"_168":-5,"_39":40,"_38":206,"_170":57,"_36":207,"_13":61,"_32":33,"_34":208,"_23":24,"_173":-5,"_26":209},{"_41":196,"_31":197,"_29":198,"_168":-5,"_39":40,"_38":199,"_170":57,"_36":200,"_13":61,"_32":33,"_34":201,"_23":24,"_173":-5,"_26":202},{"_41":189,"_31":190,"_29":191,"_168":-5,"_39":40,"_38":192,"_170":57,"_36":193,"_13":61,"_32":33,"_34":194,"_23":24,"_173":-5,"_26":195},{"_41":182,"_31":183,"_29":184,"_168":-5,"_39":40,"_38":185,"_170":57,"_36":186,"_13":61,"_32":33,"_34":187,"_23":24,"_173":-5,"_26":188},{"_41":175,"_31":176,"_29":177,"_168":-5,"_39":40,"_38":178,"_170":57,"_36":179,"_13":61,"_32":33,"_34":180,"_23":24,"_173":-5,"_26":181},{"_41":165,"_31":166,"_29":167,"_168":-5,"_39":40,"_38":169,"_170":57,"_36":171,"_13":61,"_32":33,"_34":172,"_23":24,"_173":-5,"_26":174},"35b27e24-0baa-4f42-95d8-f9b951d952d3","scope-review.ts","a8ba380c-a529-11f1-b053-1607ee4eb77e","parentId",28,"latest",["D",1788173376809],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst esc=(v:unknown)=>String(v??\"\").replace(/[&<>\\\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nconst headers={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS project_scopes (project_id TEXT PRIMARY KEY, scope_summary TEXT NOT NULL, deliverables TEXT NOT NULL, inclusions TEXT NOT NULL, exclusions TEXT NOT NULL, assumptions TEXT NOT NULL, acceptance_criteria TEXT NOT NULL, dependencies TEXT NOT NULL, build_plan TEXT NOT NULL, scope_decision TEXT NOT NULL, reviewer TEXT NOT NULL, updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();const u=new URL(req.url),id=u.searchParams.get(\"id\")||\"\";if(!id)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[id]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"scope_summary\",\"deliverables\",\"inclusions\",\"exclusions\",\"assumptions\",\"acceptance_criteria\",\"dependencies\",\"build_plan\",\"scope_decision\",\"reviewer\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete every scope field\",missing},{status:400});const now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_scopes VALUES (?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT(project_id) DO UPDATE SET scope_summary=excluded.scope_summary,deliverables=excluded.deliverables,inclusions=excluded.inclusions,exclusions=excluded.exclusions,assumptions=excluded.assumptions,acceptance_criteria=excluded.acceptance_criteria,dependencies=excluded.dependencies,build_plan=excluded.build_plan,scope_decision=excluded.scope_decision,reviewer=excluded.reviewer,updated_at=excluded.updated_at`,args:[id,...keys.map(k=>String(b[k]??\"\").trim()),now]});if(String(b.scope_decision)===\"Approved for build\")await sqlite.execute({sql:`UPDATE service_tickets SET status=? WHERE id=? AND status IN ('scope_review','diagnosis')`,args:[\"approved_for_build\",id]});return Response.json({ok:true,projectId:id,scopeDecision:b.scope_decision,updatedAt:now})}const r:any=(await sqlite.execute({sql:`SELECT * FROM project_scopes WHERE project_id=?`,args:[id]})).rows[0]||{};const fields=[['scope_summary','Scope summary'],['deliverables','Deliverables'],['inclusions','Inclusions'],['exclusions','Exclusions'],['assumptions','Assumptions'],['acceptance_criteria','Acceptance criteria'],['dependencies','Dependencies'],['build_plan','Build plan']];return new Response(`5MC Scope Review

5MC PERFORMANCE / SCOPE

${esc(p.id)}

${esc(p.organization)}

${esc(p.service)} · ${esc(p.industry)}

Objective: ${esc(p.objective)}

Diagnosis/current situation: ${esc(p.current_state)}

Build gate: scope must be explicit before build approval. Define what we will deliver, what we will not deliver, assumptions, dependencies and how completion will be accepted. Do not imply outcomes that have not been measured.

`,{headers})}","label",[166],"e0ff2cd4-5f44-47a4-b337-a7d24a6c2186","promotion-setup.ts","8f087b64-a554-11f1-8f29-1607ee4eb77e",72,["D",1788191802062],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS promotion_setup (id TEXT PRIMARY KEY,promotion_id TEXT NOT NULL,platform TEXT NOT NULL,account_reference TEXT NOT NULL,campaign_reference TEXT NOT NULL,budget_basis TEXT NOT NULL,targeting_reference TEXT NOT NULL,creative_reference TEXT NOT NULL,tracking_reference TEXT NOT NULL,prelaunch_checks TEXT NOT NULL,setup_status TEXT NOT NULL,launch_evidence TEXT NOT NULL,owner TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst sts=[\"draft\",\"configured\",\"ready_for_launch\",\"launched\",\"blocked\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing promotion id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM promotion_projects WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Promotion project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"platform\",\"account_reference\",\"campaign_reference\",\"budget_basis\",\"targeting_reference\",\"creative_reference\",\"tracking_reference\",\"prelaunch_checks\",\"setup_status\",\"launch_evidence\",\"owner\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete setup record\",missing},{status:400});if(!sts.includes(b.setup_status))return Response.json({error:\"Invalid setup status\"},{status:400});if(b.setup_status===\"launched\"&&!String(b.launch_evidence).trim())return Response.json({error:\"Launch evidence is required before marking launched\"},{status:400});const id=`PSU-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO promotion_setup VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,pid,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,setupId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM promotion_setup WHERE promotion_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(`5MC Promotion Setup

5MC / PROMOTION SETUP & LAUNCH CONTROL

${esc(p.campaign_name)}

Configuration is separate from launch. Launch is only recorded with actual launch evidence.

Record setup

Setup history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.platform)} · ${esc(r.campaign_reference)} ${esc(r.setup_status)}

Targeting: ${esc(r.targeting_reference)}
Tracking: ${esc(r.tracking_reference)}
Launch evidence: ${esc(r.launch_evidence)}

${esc(r.owner)} · ${esc(r.created_at)} · ${esc(r.id)}

`).join(''):'

No setup records yet.

`,{headers:H})}",[176],"4617c695-0b1e-4b74-893a-ee662bab86f3","promotion-reporting.ts","121f4f4a-a556-11f1-b387-1607ee4eb77e",75,["D",1788192451484],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS promotion_reports (id TEXT PRIMARY KEY,promotion_id TEXT NOT NULL,period_start TEXT NOT NULL,period_end TEXT NOT NULL,data_sources TEXT NOT NULL,observed_results TEXT NOT NULL,targets TEXT NOT NULL,optimization_summary TEXT NOT NULL,limitations TEXT NOT NULL,final_status TEXT NOT NULL,closeout_decision TEXT NOT NULL,approved_by TEXT NOT NULL,approved_at TEXT NOT NULL,evidence_reference TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst statuses=[\"draft\",\"ready_for_review\",\"closed\",\"blocked\"];const decisions=[\"pending\",\"closed\",\"reopen_required\",\"not_applicable\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing promotion id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM promotion_projects WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Promotion project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"period_start\",\"period_end\",\"data_sources\",\"observed_results\",\"targets\",\"optimization_summary\",\"limitations\",\"final_status\",\"closeout_decision\",\"approved_by\",\"approved_at\",\"evidence_reference\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete promotion report\",missing},{status:400});if(!statuses.includes(b.final_status)||!decisions.includes(b.closeout_decision))return Response.json({error:\"Invalid report status or closeout decision\"},{status:400});if(b.final_status===\"closed\"&&b.closeout_decision!==\"closed\")return Response.json({error:\"Closed report requires closeout_decision=closed\"},{status:400});const id=`PRP-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO promotion_reports VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,pid,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,reportId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM promotion_reports WHERE promotion_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(JSON.stringify({promotionId:pid,campaign:p.campaign_name,reports:rows}),{headers:J})}",[183],"a53f6859-152c-4e3f-976d-0155698ad232","promotion-optimization.ts","1e1f2410-a555-11f1-9259-1607ee4eb77e",74,["D",1788192042121],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS promotion_optimization (id TEXT PRIMARY KEY,promotion_id TEXT NOT NULL,evidence_reference TEXT NOT NULL,observation TEXT NOT NULL,recommendation TEXT NOT NULL,reason TEXT NOT NULL,expected_impact TEXT NOT NULL,risk TEXT NOT NULL,action_owner TEXT NOT NULL,decision TEXT NOT NULL,decision_by TEXT NOT NULL,decision_at TEXT NOT NULL,followup_date TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst decisions=[\"proposed\",\"approved\",\"rejected\",\"deferred\",\"implemented\",\"cancelled\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing promotion id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM promotion_projects WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Promotion project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"evidence_reference\",\"observation\",\"recommendation\",\"reason\",\"expected_impact\",\"risk\",\"action_owner\",\"decision\",\"decision_by\",\"decision_at\",\"followup_date\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete optimization decision\",missing},{status:400});if(!decisions.includes(b.decision))return Response.json({error:\"Invalid decision\"},{status:400});const id=`POP-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO promotion_optimization VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,pid,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,optimizationId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM promotion_optimization WHERE promotion_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(JSON.stringify({promotionId:pid,campaign:p.campaign_name,decisions:rows}),{headers:J})}",[190],"6cfdae41-36e6-4e65-b714-5355bb543385","promotion-monitoring.ts","d6ca83a2-a554-11f1-84e1-1607ee4eb77e",73,["D",1788191922444],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS promotion_monitoring (id TEXT PRIMARY KEY,promotion_id TEXT NOT NULL,source TEXT NOT NULL,period_start TEXT NOT NULL,period_end TEXT NOT NULL,metric_name TEXT NOT NULL,metric_value TEXT NOT NULL,unit TEXT NOT NULL,evidence_reference TEXT NOT NULL,data_status TEXT NOT NULL,notes TEXT NOT NULL,recorded_by TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst ds=[\"observed\",\"estimated\",\"target\",\"unavailable\",\"inconclusive\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing promotion id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM promotion_projects WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Promotion project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"source\",\"period_start\",\"period_end\",\"metric_name\",\"metric_value\",\"unit\",\"evidence_reference\",\"data_status\",\"notes\",\"recorded_by\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete performance record\",missing},{status:400});if(!ds.includes(b.data_status))return Response.json({error:\"Invalid data status\"},{status:400});if([\"observed\",\"estimated\",\"target\"].includes(b.data_status)&&!String(b.evidence_reference).trim())return Response.json({error:\"Evidence reference required for quantified records\"},{status:400});const id=`PMT-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO promotion_monitoring VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,pid,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,monitoringId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM promotion_monitoring WHERE promotion_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(JSON.stringify({promotionId:pid,campaign:p.campaign_name,records:rows}),{headers:J})}",[197],"d87193e1-2ac9-41b8-8a15-6800534c7164","promotion-engine.ts","9dadea74-a553-11f1-9bec-1607ee4eb77e",71,["D",1788191397129],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS promotion_projects (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,campaign_name TEXT NOT NULL,objective TEXT NOT NULL,audience TEXT NOT NULL,offer_message TEXT NOT NULL,channels TEXT NOT NULL,creative_reference TEXT NOT NULL,setup_requirements TEXT NOT NULL,success_criteria TEXT NOT NULL,status TEXT NOT NULL,owner TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst sts=[\"brief\",\"ready_for_setup\",\"setup\",\"ready_for_launch\",\"launched\",\"paused\",\"completed\",\"blocked\"];\nexport default async function(req:Request){await db();if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"project_ref\",\"campaign_name\",\"objective\",\"audience\",\"offer_message\",\"channels\",\"creative_reference\",\"setup_requirements\",\"success_criteria\",\"status\",\"owner\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete promotion brief\",missing},{status:400});if(!sts.includes(b.status))return Response.json({error:\"Invalid promotion status\"},{status:400});const id=`PRM-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO promotion_projects VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,promotionId:id},{headers:J})}const rows:any[]=(await sqlite.execute(`SELECT * FROM promotion_projects ORDER BY created_at DESC`)).rows;return new Response(`5MC Promotion Engine

5MC / PROMOTION ENGINE

Campaign Brief & Control

Promotion starts with an objective and measurable criteria. Performance is never invented.

Create campaign

Campaigns (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.campaign_name)} ${esc(r.status)}

${esc(r.objective)}

${esc(r.audience)} · ${esc(r.channels)}
Success criteria: ${esc(r.success_criteria)}

${esc(r.project_ref)} · ${esc(r.owner)} · ${esc(r.created_at)} · ${esc(r.id)}

`).join(''):'

No promotion campaigns yet.

`,{headers:H})}",[204],"33b33150-f6d9-472c-8d62-bfd6967a39fa","operations.ts","d420f2c2-a526-11f1-83a1-1607ee4eb77e",18,["D",1788172181339],2,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"application/json; charset=utf-8\",\"cache-control\":\"no-store\",\"access-control-allow-origin\":\"*\",\"access-control-allow-methods\":\"GET,POST,PATCH,OPTIONS\",\"access-control-allow-headers\":\"content-type\"};\nconst json=(x:unknown,s=200)=>new Response(JSON.stringify(x),{status:s,headers:H});\nasync function db(){await sqlite`CREATE TABLE IF NOT EXISTS service_tickets (id TEXT PRIMARY KEY, service TEXT NOT NULL, name TEXT NOT NULL, organization TEXT NOT NULL, contact TEXT NOT NULL, industry TEXT NOT NULL, location TEXT NOT NULL, website TEXT NOT NULL, timeline TEXT NOT NULL, objective TEXT NOT NULL, current_state TEXT NOT NULL, audience TEXT NOT NULL, scope TEXT NOT NULL, deliverables TEXT NOT NULL, assets TEXT NOT NULL, constraints TEXT NOT NULL, success_signal TEXT NOT NULL, budget_range TEXT NOT NULL, brief TEXT NOT NULL, status TEXT NOT NULL, created_at TEXT NOT NULL)`;}\nconst esc=(v:unknown)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nconst statuses=[\"brief_received\",\"diagnosis\",\"scope_review\",\"approved_for_build\",\"in_progress\",\"client_review\",\"completed\",\"on_hold\",\"cancelled\"];\nfunction page(rows:any[]){const cards=rows.map(r=>{const opts=statuses.map(s=>``).join(\"\");return `

${esc(r.id)}

${esc(r.organization)}

${esc(r.service)} · ${esc(r.industry)}

CONTACT
${esc(r.name)}

TIMELINE
${esc(r.timeline)}

LOCATION
${esc(r.location)}

BUDGET
${esc(r.budget_range)}

OBJECTIVE

${esc(r.objective)}

CURRENT SITUATION

${esc(r.current_state)}

STATUS

`}).join(\"\") || `

No projects have been submitted yet.

`;return `5MC Operations

5MC PERFORMANCE / OPERATIONS

Payments deliberately disconnected

Operating gate: brief received → diagnosis → scope review → build approval. No fabricated scores, revenue loss, competitors, scans, results or evidence.

${cards}

`}\nexport default async function(req:Request){if(req.method==='OPTIONS')return new Response(null,{status:204,headers:H});await db();const u=new URL(req.url);if(req.method==='GET'&&u.pathname==='/api/projects'){return json({projects:await sqlite`SELECT * FROM service_tickets ORDER BY created_at DESC`});}if(req.method==='PATCH'&&u.pathname.startsWith('/api/projects/')){const id=decodeURIComponent(u.pathname.split('/').pop()||'');let b:any;try{b=await req.json()}catch{return json({error:'Invalid JSON'},400)}const status=String(b.status||'');if(!statuses.includes(status))return json({error:'Invalid project status'},400);await sqlite`UPDATE service_tickets SET status=${status} WHERE id=${id}`;return json({ok:true,id,status});}if(req.method==='GET'){const rows=await sqlite`SELECT id,service,name,organization,contact,industry,location,timeline,objective,current_state,budget_range,status,created_at FROM service_tickets ORDER BY created_at DESC`;return new Response(page(rows),{headers:{...H,\"content-type\":\"text/html;charset=utf-8\"}});}return json({error:'Not found'},404)}",[211],"16645525-a883-498c-ac5e-bd47391d5c51","index.ts",63,["D",1788188420035],23,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst engines = {\n advertising: { name: \"Digital Advertising\", promise: \"Turn attention into qualified demand with a structured campaign system.\", tasks: [\"Business & offer diagnosis\", \"Audience and channel strategy\", \"Campaign architecture\", \"Ad creative brief\", \"Tracking and lead capture\", \"Launch, monitor and optimize\"] },\n video: { name: \"Ad Videos & Content\", promise: \"Turn your offer into clear, high-retention promotional content.\", tasks: [\"Content objective\", \"Audience and hook strategy\", \"Script / storyboard\", \"Production requirements\", \"Editing and CTA\", \"Publishing and performance handoff\"] },\n branding: { name: \"Branding & Rebranding\", promise: \"Build a recognizable identity that makes your business easier to trust and remember.\", tasks: [\"Brand diagnosis\", \"Positioning and messaging\", \"Identity direction\", \"Visual system\", \"Brand asset production\", \"Deployment and consistency checklist\"] },\n web: { name: \"Websites & Landing Pages\", promise: \"Build a digital destination that turns interest into a clear next action.\", tasks: [\"Goal and audience definition\", \"Information architecture\", \"Conversion copy structure\", \"UI / page build\", \"Forms, analytics and integrations\", \"QA, launch and handoff\"] },\n promotion: { name: \"Social & 360° Promotion\", promise: \"Coordinate content, channels and campaigns into one market-visibility system.\", tasks: [\"Market and offer diagnosis\", \"Channel strategy\", \"Campaign calendar\", \"Creative production\", \"Distribution and outreach\", \"Performance review and iteration\"] },\n creative: { name: \"Graphics & Business Design\", promise: \"Produce professional visual assets built around the actual business objective.\", tasks: [\"Asset requirement\", \"Content and hierarchy\", \"Creative direction\", \"Design production\", \"Review and revision\", \"Export and delivery\"] },\n seo: { name: \"SEO & Google Business\", promise: \"Strengthen how your business is represented and discovered in search.\", tasks: [\"Search presence audit\", \"Business information cleanup\", \"Keyword and content opportunities\", \"On-page improvements\", \"Local profile optimization\", \"Measurement and growth plan\"] },\n automation: { name: \"Lead Capture & Automation\", promise: \"Reduce lost enquiries by connecting capture, routing and follow-up.\", tasks: [\"Lead-flow diagnosis\", \"Capture point design\", \"Qualification logic\", \"Routing and notifications\", \"Follow-up automation\", \"Testing and monitoring\"] },\n media: { name: \"Cinematography & Media\", promise: \"Create professional visual storytelling for campaigns, products and organizations.\", tasks: [\"Creative concept\", \"Production plan\", \"Shot list and logistics\", \"Capture\", \"Post-production\", \"Master delivery and distribution\"] },\n verification: { name: \"Business Verification\", promise: \"Improve the credibility and discoverability of your business presence through proper setup and verification support.\", tasks: [\"Presence assessment\", \"Business information preparation\", \"Profile setup\", \"Verification readiness\", \"Submission / support\", \"Status and maintenance guidance\"] },\n systems: { name: \"AI & Smart Business Systems\", promise: \"Design practical AI-powered tools and workflows around a real operational need.\", tasks: [\"Process diagnosis\", \"System architecture\", \"AI workflow design\", \"Integration and data flow\", \"Testing and safeguards\", \"Deployment and handoff\"] },\n documents: { name: \"Documents & Presentation Assets\", promise: \"Turn business information into polished documents that communicate clearly and professionally.\", tasks: [\"Purpose and audience\", \"Content structure\", \"Visual direction\", \"Document production\", \"Review and revision\", \"Final export and delivery\"] },\n marketplace: { name: \"Marketplace Asset Deployment\", promise: \"Select, scope, customize and deploy a 5MC asset for a specific business objective.\", tasks: [\"Asset selection\", \"Use-case diagnosis\", \"Customization brief\", \"Deployment requirements\", \"Quality check\", \"Delivery and performance handoff\"] },\n academy: { name: \"5MC Academy\", promise: \"Move from learning a practical digital skill to executing a real project.\", tasks: [\"Skill assessment\", \"Learning path\", \"Tool setup\", \"Practical project\", \"Portfolio output\", \"Execution plan\"] },\n partnership: { name: \"Strategic Partnership\", promise: \"Structure a collaboration around a clear commercial objective, roles and next steps.\", tasks: [\"Partnership diagnosis\", \"Opportunity mapping\", \"Scope definition\", \"Roles and resources\", \"Commercial framework\", \"Next-step plan\"] }\n} as const;\n\ntype EngineKey = keyof typeof engines;\n\nfunction esc(v: unknown) { return String(v ?? \"\").replace(/[&<>\\\"']/g, c => ({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!)); }\nfunction json(data: unknown, status = 200) { return new Response(JSON.stringify(data), { status, headers: { \"content-type\": \"application/json\", \"access-control-allow-origin\": \"*\", \"cache-control\": \"no-store\" } }); }\n\nasync function ensureDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS service_tickets (\n id TEXT PRIMARY KEY, service TEXT NOT NULL, name TEXT NOT NULL, organization TEXT NOT NULL,\n contact TEXT NOT NULL, industry TEXT NOT NULL, location TEXT NOT NULL, website TEXT NOT NULL,\n timeline TEXT NOT NULL, objective TEXT NOT NULL, current_state TEXT NOT NULL, audience TEXT NOT NULL,\n scope TEXT NOT NULL, deliverables TEXT NOT NULL, assets TEXT NOT NULL, constraints TEXT NOT NULL,\n success_signal TEXT NOT NULL, budget_range TEXT NOT NULL, brief TEXT NOT NULL, status TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n}\n\nfunction page(key: EngineKey) {\n const e = engines[key];\n const steps = e.tasks.map((x,i)=>`

${i+1}${esc(x)}

`).join(\"\");\n return `5MC ${esc(e.name)} Engine

5MC PERFORMANCE

← Back to 5MC

Live 5MC GROW Execution Engine

${esc(e.name)}

${esc(e.promise)}

What this engine executes

${steps}

Build your project brief

GROW starts with understanding, not a generic quote. Give 5MC enough context to diagnose the work, define the scope and create a project that the team can actually execute.

5MC Performance · Diagnose before recommending · Understand before selling · Build before charging · Prove before claiming

`;\n}\n\nfunction reqText(body: Record, key: string) { return String(body[key] ?? \"\").trim(); }\n\nexport default async function(req: Request) {\n const url = new URL(req.url);\n if (req.method === \"OPTIONS\") return new Response(null,{status:204,headers:{\"access-control-allow-origin\":\"*\",\"access-control-allow-methods\":\"GET,POST,OPTIONS\",\"access-control-allow-headers\":\"content-type\"}});\n if (req.method === \"GET\" && url.pathname === \"/api/engines\") return json(Object.entries(engines).map(([key,e])=>({key,name:e.name,promise:e.promise,tasks:e.tasks})));\n if (req.method === \"GET\" && url.pathname !== \"/operations\" && url.pathname !== \"/api/projects\") {\n const raw = url.searchParams.get(\"engine\") || url.searchParams.get(\"service\") || \"advertising\";\n const key = raw as EngineKey;\n if (!(key in engines)) return json({error:\"Unknown service engine\", available:Object.keys(engines)},404);\n return new Response(page(key),{headers:{\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"}});\n }\n if (req.method === \"POST\" && url.pathname === \"/api/execute\") {\n let body:any; try{body=await req.json()}catch{return json({error:\"Invalid request\"},400)}\n const service=String(body.service||\"\") as EngineKey;\n if(!(service in engines)) return json({error:\"Unknown service engine\"},400);\n const name=reqText(body,\"name\"), organization=reqText(body,\"organization\"), contact=reqText(body,\"contact\"), industry=reqText(body,\"industry\"), location=reqText(body,\"location\"), website=reqText(body,\"website\"), timeline=reqText(body,\"timeline\")||\"Standard Sprint (7–14 Days)\", objective=reqText(body,\"objective\"), current_state=reqText(body,\"current_state\"), audience=reqText(body,\"audience\"), scope=reqText(body,\"scope\"), deliverables=reqText(body,\"deliverables\"), assets=reqText(body,\"assets\"), constraints=reqText(body,\"constraints\"), success_signal=reqText(body,\"success_signal\"), budget_range=reqText(body,\"budget_range\")||\"Not decided yet\", brief=reqText(body,\"brief\");\n const required={name,organization,contact,industry,location,website,objective,current_state,audience,scope,deliverables,assets,constraints,success_signal,brief};\n const missing=Object.entries(required).filter(([,v])=>!v).map(([k])=>k);\n if(missing.length)return json({error:\"Complete the structured project brief before submitting.\",missing},400);\n await ensureDb();\n const projectId=`5MC-${Date.now().toString(36).toUpperCase()}`;\n const now=new Date().toISOString();\n await sqlite.execute({sql:`INSERT INTO service_tickets (id,service,name,organization,contact,industry,location,website,timeline,objective,current_state,audience,scope,deliverables,assets,constraints,success_signal,budget_range,brief,status,created_at) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[projectId,service,name,organization,contact,industry,location,website,timeline,objective,current_state,audience,scope,deliverables,assets,constraints,success_signal,budget_range,brief,\"brief_received\",now]});\n return json({projectId,service,serviceName:engines[service].name,tasks:engines[service].tasks,status:\"brief_received\",receivedAt:now,nextStage:\"5MC review → scope confirmation → execution plan\"},201);\n }\n if (req.method === \"GET\" && url.pathname === \"/operations\") {\n await ensureDb();\n const rows:any[] = (await sqlite.execute(`SELECT id,service,name,organization,contact,industry,location,timeline,objective,current_state,budget_range,status,created_at FROM service_tickets ORDER BY created_at DESC`)).rows;\n return new Response(operationsPage(rows),{headers:{\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"}});\n }\n if (req.method === \"GET\" && url.pathname === \"/api/projects\") {\n await ensureDb();\n return json({projects:(await sqlite.execute(`SELECT * FROM service_tickets ORDER BY created_at DESC`)).rows});\n }\n if (req.method === \"PATCH\" && url.pathname.startsWith(\"/api/projects/\")) {\n await ensureDb();\n const id=decodeURIComponent(url.pathname.split(\"/\").pop()||\"\");\n let body:any; try{body=await req.json()}catch{return json({error:\"Invalid JSON\"},400)}\n const statuses=[\"brief_received\",\"diagnosis\",\"scope_review\",\"approved_for_build\",\"in_progress\",\"client_review\",\"completed\",\"on_hold\",\"cancelled\"];\n const status=String(body.status||\"\");\n if(!statuses.includes(status)) return json({error:\"Invalid project status\"},400);\n await sqlite.execute({sql:`UPDATE service_tickets SET status=? WHERE id=?`,args:[status,id]});\n return json({ok:true,id,status});\n }\n return json({error:\"Not found\"},404);\n}\n\nfunction operationsPage(rows:any[]){\n const esc=(v:unknown)=>String(v??\"\").replace(/[&<>\\\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\n const statuses=[\"brief_received\",\"diagnosis\",\"scope_review\",\"approved_for_build\",\"in_progress\",\"client_review\",\"completed\",\"on_hold\",\"cancelled\"];\n const cards=rows.map(r=>{const opts=statuses.map(s=>``).join(\"\");return `

${esc(r.id)}

${esc(r.organization)}

${esc(r.service)} · ${esc(r.industry)}

CONTACT
${esc(r.name)}

TIMELINE
${esc(r.timeline)}

LOCATION
${esc(r.location)}

BUDGET
${esc(r.budget_range)}

OBJECTIVE

${esc(r.objective)}

CURRENT SITUATION

${esc(r.current_state)}

Open diagnosis & evidence →Open scope review →Open execution workspace →Open task & activity control →Open client review & acceptance →Open Intelligence & Audit →Open Creative Engine →Open Creative Engine →Open Digital Engine →Open evidence ledger →STATUS

`}).join(\"\") || `

No projects have been submitted yet.

`;\n return `5MC Operations

5MC PERFORMANCE / OPERATIONS

Payments deliberately disconnected

Operating gate: brief received → diagnosis → scope review → build approval. No fabricated scores, revenue loss, competitors, scans, results or evidence.

${cards}

`;\n}",[219],"ca4f053c-1b5a-410a-b286-567df114878b","handoff-gate.ts","93753942-a579-11f1-90a0-1607ee4eb77e",79,["D",1788207700861],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst contracts:any={\"GROW->CREATIVE\":[\"growth objective\",\"audience\",\"offer/message\",\"approved scope\",\"success criteria\"],\"CREATIVE->DIGITAL\":[\"approved creative reference\",\"creative specification\",\"usage/delivery requirements\",\"acceptance criteria\"],\"DIGITAL->PROMOTION\":[\"digital delivery reference\",\"verified acceptance\",\"approved creative reference\",\"implementation/technical constraints\",\"success criteria\"]};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS handoff_gates (id TEXT PRIMARY KEY,source_engine TEXT NOT NULL,target_engine TEXT NOT NULL,source_ref TEXT NOT NULL,target_ref TEXT NOT NULL,context_received TEXT NOT NULL,missing_context TEXT NOT NULL,evidence_reference TEXT NOT NULL,status TEXT NOT NULL,checked_by TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({contracts},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const pair=`${String(b.source_engine||\"\").toUpperCase()}->${String(b.target_engine||\"\").toUpperCase()}`,required=contracts[pair];if(!required)return Response.json({error:\"Unsupported engine handoff\",allowed:Object.keys(contracts)},{status:400});const received=String(b.context_received||\"\").split(\"|\").map(x=>x.trim().toLowerCase()).filter(Boolean),missing=required.filter((x:string)=>!received.includes(x));if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Required upstream context is missing\",missing,required},{status:409});if(!String(b.evidence_reference||\"\").trim())return Response.json({ok:false,gate:\"blocked\",error:\"Handoff evidence is required\"},{status:409});const keys=[\"source_engine\",\"target_engine\",\"source_ref\",\"target_ref\",\"context_received\",\"evidence_reference\",\"checked_by\"],miss=keys.filter(k=>!String(b[k]??\"\").trim());if(miss.length)return Response.json({error:\"Complete handoff gate\",missing:miss},{status:400});const id=`HGT-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO handoff_gates VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,pair.split(\"->\")[0],pair.split(\"->\")[1],...keys.slice(2).map(k=>String(b[k]).trim()),missing.join(\";\"),\"verified\",String(b.checked_by).trim(),now]});return Response.json({ok:true,gate:\"verified\",gateId:id,source:pair.split(\"->\")[0],target:pair.split(\"->\")[1]},{headers:J})}",[226],"30335612-602c-494d-93f1-0b355e1caa3e","frontier-engines.ts","433e0d9a-a4a8-11f1-afcb-1607ee4eb77e",13,["D",1788117801473],"script","export type FrontierEngineStatus = \"active\" | \"proposed\" | \"blocked\" | \"connected\";\n\nexport type FrontierEngine = {\n id: string;\n name: string;\n division: string;\n role: string;\n status: FrontierEngineStatus;\n evidenceRequired: string[];\n requiredIntegrations: string[];\n clientValue: string;\n revenueModel: string;\n};\n\n/**\n * 5MC Performance 2.0 frontier-engine registry.\n * These are governed product definitions, not claims of live connectivity.\n */\nexport const FRONTIER_ENGINES: FrontierEngine[] = [\n {\n id: \"oracle-core\",\n name: \"Oracle Core\",\n division: \"Intelligence Command\",\n role: \"Strategic intelligence, diagnosis and routing authority\",\n status: \"active\",\n evidenceRequired: [\"verified business context\", \"source attribution\", \"decision trace\"],\n requiredIntegrations: [],\n clientValue: \"Turns business evidence into prioritized decisions and governed next actions.\",\n revenueModel: \"Included in diagnostics; premium intelligence for enterprise engagements.\"\n },\n {\n id: \"sentinel-01\",\n name: \"Sentinel-01\",\n division: \"Oracle Studios\",\n role: \"Market surveillance, intent detection and opportunity radar\",\n status: \"proposed\",\n evidenceRequired: [\"source provenance\", \"freshness timestamp\", \"verified identity\", \"intent evidence\"],\n requiredIntegrations: [\"approved business-data source\", \"social/listening source where permitted\"],\n clientValue: \"Surfaces legitimate market and buying-intent signals for authorized territories.\",\n revenueModel: \"Premium intelligence subscription / managed market-radar service.\"\n },\n {\n id: \"nexus-seo\",\n name: \"Nexus-SEO\",\n division: \"Oracle Studios\",\n role: \"Search visibility and entity authority intelligence\",\n status: \"proposed\",\n evidenceRequired: [\"crawl evidence\", \"search/indexation data\", \"verified business entities\"],\n requiredIntegrations: [\"Search Console\", \"crawler\", \"analytics where authorized\"],\n clientValue: \"Maps search opportunities and measures discoverability improvements.\",\n revenueModel: \"SEO recovery projects plus recurring visibility monitoring.\"\n },\n {\n id: \"kinetic-v\",\n name: \"Kinetic-V\",\n division: \"Oracle Studios\",\n role: \"Creative and short-form content intelligence\",\n status: \"proposed\",\n evidenceRequired: [\"approved brand assets\", \"campaign objective\", \"platform constraints\"],\n requiredIntegrations: [\"authorized media generation/storage\", \"publishing channels where connected\"],\n clientValue: \"Turns business objectives into governed creative production workflows.\",\n revenueModel: \"Creative production packages plus managed content retainers.\"\n },\n {\n id: \"apex-ads\",\n name: \"Apex-Ads\",\n division: \"Oracle Studios\",\n role: \"Advertising performance and conversion intelligence\",\n status: \"proposed\",\n evidenceRequired: [\"authorized ad account telemetry\", \"campaign data\", \"conversion data\"],\n requiredIntegrations: [\"Meta Ads\", \"Google Ads\", \"analytics platforms as authorized\"],\n clientValue: \"Diagnoses campaign performance and identifies measurable optimization opportunities.\",\n revenueModel: \"Paid advertising management / optimization retainers.\"\n },\n {\n id: \"core-ops\",\n name: \"Core-Ops\",\n division: \"Oracle Studios\",\n role: \"Infrastructure operations, deployment and system-health intelligence\",\n status: \"proposed\",\n evidenceRequired: [\"application telemetry\", \"deployment state\", \"system-health signals\"],\n requiredIntegrations: [\"GitHub\", \"deployment provider\", \"error monitoring\", \"database monitoring\"],\n clientValue: \"Keeps critical 5MC and client systems observable, recoverable and operational.\",\n revenueModel: \"Enterprise automation and managed operations.\"\n },\n {\n id: \"guardian-agent\",\n name: \"Guardian Agent\",\n division: \"Oracle Studios\",\n role: \"Security, runtime resilience and policy enforcement\",\n status: \"proposed\",\n evidenceRequired: [\"security telemetry\", \"audit logs\", \"runtime health\", \"policy state\"],\n requiredIntegrations: [\"error monitoring\", \"security telemetry\", \"deployment controls\"],\n clientValue: \"Detects abnormal behavior and escalates reliability or security events within defined authority.\",\n revenueModel: \"Enterprise reliability/security automation layer.\"\n },\n {\n id: \"eye-in-the-sky\",\n name: \"Eye in the Sky\",\n division: \"Oracle Studios\",\n role: \"Global telemetry, market pulse and executive intelligence\",\n status: \"proposed\",\n evidenceRequired: [\"time-series telemetry\", \"source freshness\", \"verified external signals\"],\n requiredIntegrations: [\"analytics\", \"search data\", \"approved market intelligence feeds\"],\n clientValue: \"Aggregates internal and external signals into executive-level trend intelligence.\",\n revenueModel: \"Premium business intelligence and monitoring subscription.\"\n }\n];\n\nexport function getFrontierEngine(id: string) {\n return FRONTIER_ENGINES.find((engine) => engine.id === id);\n}\n",[233],"b3fbd301-1e98-4f97-843b-c94244184e3d","frontier-api.ts","4825b20e-a4a8-11f1-8491-1607ee4eb77e",14,["D",1788117809701],"import { FRONTIER_ENGINES, getFrontierEngine, type FrontierEngineStatus } from \"./frontier-engines.ts\";\n\nconst headers = {\n \"content-type\": \"application/json; charset=utf-8\",\n \"cache-control\": \"no-store\",\n \"x-content-type-options\": \"nosniff\",\n \"access-control-allow-origin\": \"*\",\n \"access-control-allow-methods\": \"GET, OPTIONS\",\n \"access-control-allow-headers\": \"content-type\",\n};\n\nfunction json(body: unknown, status = 200) {\n return new Response(JSON.stringify(body), { status, headers });\n}\n\nfunction summary() {\n const byStatus = FRONTIER_ENGINES.reduce>((acc, engine) => {\n acc[engine.status] = (acc[engine.status] ?? 0) + 1;\n return acc;\n }, { active: 0, proposed: 0, blocked: 0, connected: 0 });\n return { total: FRONTIER_ENGINES.length, byStatus };\n}\n\nexport default async function handler(req: Request) {\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers });\n if (req.method !== \"GET\") return json({ ok: false, error: \"Method not allowed\" }, 405);\n\n try {\n const url = new URL(req.url);\n const id = url.searchParams.get(\"id\")?.trim();\n if (id) {\n const engine = getFrontierEngine(id);\n if (!engine) return json({ ok: false, error: \"Frontier engine not found\" }, 404);\n return json({ ok: true, engine, governed: true, executable: engine.status === \"connected\" || engine.status === \"active\" });\n }\n\n return json({\n ok: true,\n system: \"5MC Performance 2.0 — Oracle Studios Frontier Engine Registry\",\n policy: \"Definitions and requirements only; a proposed engine is not a claim of live connectivity or execution.\",\n summary: summary(),\n engines: FRONTIER_ENGINES,\n });\n } catch (error) {\n console.error(\"Frontier registry error:\", error);\n return json({ ok: false, error: \"Unable to read frontier engine registry\" }, 500);\n }\n}\n",[241],"24eef7a6-63e2-492e-8046-00f5099970ef","finding-actions.ts","ee89546c-a542-11f1-9edd-1607ee4eb77e",44,["D",1788185140285],1,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS finding_actions (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, finding_id TEXT NOT NULL, action_type TEXT NOT NULL, task_id TEXT NOT NULL, rationale TEXT NOT NULL, status TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});\nconst findingTable=await sqlite.execute(`SELECT name FROM sqlite_master WHERE type='table' AND name='audit_findings'`),hasFindings=(findingTable.rows as any[]).length>0;const findings:any[]=hasFindings?(await sqlite.execute({sql:`SELECT * FROM audit_findings WHERE project_id=? ORDER BY created_at DESC`,args:[pid]})).rows:[];\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const f=String(b.finding_id||\"\"),type=String(b.action_type||\"\"),r=String(b.rationale||\"\").trim(),task=String(b.task_id||\"\").trim();if(!f||!r||!['scope_action','evidence_gap'].includes(type))return Response.json({error:\"Choose a finding, action type and rationale\"},{status:400});const target=hasFindings?(await sqlite.execute({sql:`SELECT * FROM audit_findings WHERE id=? AND project_id=?`,args:[f,pid]})).rows[0] as any:null;if(!target)return Response.json({error:\"Finding not found\"},{status:404});if(type==='evidence_gap' && String(target.finding_status)!=='unknown')return Response.json({error:\"Evidence-gap action is intended for unknown findings\"},{status:400});const now=new Date().toISOString(),aid=`ACT-${crypto.randomUUID().slice(0,8).toUpperCase()}`;let taskId=task;if(!taskId){taskId=`TASK-${crypto.randomUUID().slice(0,8).toUpperCase()}`;const title=type==='evidence_gap'?`Collect evidence: ${String(target.finding).slice(0,120)}`:`Action: ${String(target.action||target.recommendation).slice(0,120)}`;const due=new Date(Date.now()+14*86400000).toISOString().slice(0,10);await sqlite.execute({sql:`INSERT INTO execution_tasks VALUES (?,?,?,?,?,?,?,?,?,?)`,args:[taskId,pid,title,'Operations',type==='evidence_gap'?'Evidence gathering':'Audit action','not_started',due,r,now,now]})}await sqlite.execute({sql:`INSERT INTO finding_actions VALUES (?,?,?,?,?,?,?,?)`,args:[aid,pid,f,type,taskId,r,'open',now]});await sqlite.execute({sql:`INSERT INTO execution_activity VALUES (?,?,?,?,?,?)`,args:[crypto.randomUUID(),pid,'audit_action_created','5MC Intelligence & Audit',`${aid} mapped from ${f} to ${taskId}`,now]});return Response.json({ok:true,actionId:aid,taskId},{headers:J})}\nconst actions:any[]=(await sqlite.execute({sql:`SELECT * FROM finding_actions WHERE project_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(`5MC Finding Actions

← Findings

5MC / FINDING → ACTION

${esc(p.organization)}

${esc(p.id)} · ${esc(p.service)}

Decision rule: a verified or partially verified finding may become a scoped action. An unknown finding becomes an evidence-gap action. Unsupported or conflicting findings should not be presented as established facts.

Map a finding

Finding records

${findings.length?findings.map(f=>`

${esc(f.id)} · ${esc(f.finding)}

${esc(f.finding_status)}${esc(f.confidence)}

Recommendation: ${esc(f.recommendation)}
Action: ${esc(f.action)}
Evidence required: ${esc(f.evidence_required)}

`).join(''):'

No audit findings are recorded for this project.

Action mappings (${actions.length})

${actions.length?actions.map(a=>`

${esc(a.id)} · ${esc(a.action_type)} · ${esc(a.status)}

Finding: ${esc(a.finding_id)}
Task: ${esc(a.task_id)}
${esc(a.rationale)}

${esc(a.created_at)}

`).join(''):'

No action mappings yet.

`,{headers:H})}",[248],"b6ac21a0-6ec9-4e06-9162-03a5d1c4ee6c","execution.ts","e1a20a3e-a53b-11f1-b413-1607ee4eb77e",30,["D",1788181203217],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"}; const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\",\"access-control-allow-origin\":\"*\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nconst statuses=[\"approved_for_build\",\"in_progress\",\"client_review\",\"completed\",\"on_hold\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS project_execution (project_id TEXT PRIMARY KEY, owner TEXT NOT NULL, milestone TEXT NOT NULL, tasks TEXT NOT NULL, deliverable_status TEXT NOT NULL, client_review_notes TEXT NOT NULL, completion_evidence TEXT NOT NULL, blockers TEXT NOT NULL, updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();const u=new URL(req.url),id=u.searchParams.get(\"id\")||\"\";if(!id)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[id]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const required=[\"owner\",\"milestone\",\"tasks\",\"deliverable_status\",\"client_review_notes\",\"completion_evidence\",\"blockers\"],missing=required.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete every execution field\",missing},{status:400});const now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_execution VALUES (?,?,?,?,?,?,?, ?,?) ON CONFLICT(project_id) DO UPDATE SET owner=excluded.owner,milestone=excluded.milestone,tasks=excluded.tasks,deliverable_status=excluded.deliverable_status,client_review_notes=excluded.client_review_notes,completion_evidence=excluded.completion_evidence,blockers=excluded.blockers,updated_at=excluded.updated_at`,args:[id,...required.map(k=>String(b[k]).trim()),now]});const next=String(b.deliverable_status);if(statuses.includes(next))await sqlite.execute({sql:`UPDATE service_tickets SET status=? WHERE id=? AND status IN ('approved_for_build','in_progress','client_review','on_hold')`,args:[next,id]});return Response.json({ok:true,projectId:id,status:next,updatedAt:now},{headers:J})}\nconst e:any=(await sqlite.execute({sql:`SELECT * FROM project_execution WHERE project_id=?`,args:[id]})).rows[0]||{};return new Response(`5MC Execution

5MC PERFORMANCE / EXECUTION

← Operations

${esc(p.id)}

${esc(p.organization)}

${esc(p.service)} · ${esc(p.industry)}

Objective: ${esc(p.objective)}

Execution rule: approved scope becomes work. Track ownership, milestones, deliverables, blockers, client review and completion evidence. Completion means the agreed acceptance criteria are met—not that an unmeasured business outcome is guaranteed.

`,{headers:H})}",[256],"f19e9f50-5442-44ef-97ac-ffcdd40db252","execution-tasks.ts","be151b6e-a53c-11f1-87c0-1607ee4eb77e",32,["D",1788181573072],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\",\"access-control-allow-origin\":\"*\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS execution_tasks (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, title TEXT NOT NULL, owner TEXT NOT NULL, milestone TEXT NOT NULL, status TEXT NOT NULL, due_date TEXT NOT NULL, evidence TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL)`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS execution_activity (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, event TEXT NOT NULL, actor TEXT NOT NULL, note TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst taskStatuses=[\"not_started\",\"in_progress\",\"blocked\",\"client_review\",\"completed\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),id=u.searchParams.get(\"id\")||\"\";if(!id)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[id]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}if(b.action===\"task\"){const reqs=[\"title\",\"owner\",\"milestone\",\"due_date\"];const missing=reqs.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete task fields\",missing},{status:400});const now=new Date().toISOString(),tid=`TASK-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO execution_tasks VALUES (?,?,?,?,?,?,?,?,?,?)`,args:[tid,id,...reqs.map(k=>String(b[k]).trim()),String(b.status||\"not_started\"),String(b.evidence||\"\").trim(),now,now]});await sqlite.execute({sql:`INSERT INTO execution_activity VALUES (?,?,?,?,?,?)`,args:[crypto.randomUUID(),id,\"task_created\",String(b.actor||\"Operations\"),`Created ${tid}: ${b.title}`,now]});return Response.json({ok:true,taskId:tid},{headers:J})}if(b.action===\"task_update\"){const tid=String(b.task_id||\"\"),status=String(b.status||\"\");if(!tid||!taskStatuses.includes(status))return Response.json({error:\"Invalid task update\"},{status:400});const now=new Date().toISOString();await sqlite.execute({sql:`UPDATE execution_tasks SET status=?,evidence=?,updated_at=? WHERE id=? AND project_id=?`,args:[status,String(b.evidence||\"\").trim(),now,tid,id]});await sqlite.execute({sql:`INSERT INTO execution_activity VALUES (?,?,?,?,?,?)`,args:[crypto.randomUUID(),id,\"task_status_changed\",String(b.actor||\"Operations\"),`${tid} → ${status}`,now]});return Response.json({ok:true,taskId:tid,status},{headers:J})}if(b.action===\"activity\"){const note=String(b.note||\"\").trim();if(!note)return Response.json({error:\"Activity note required\"},{status:400});const now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO execution_activity VALUES (?,?,?,?,?,?)`,args:[crypto.randomUUID(),id,String(b.event||\"note\"),String(b.actor||\"Operations\"),note,now]});return Response.json({ok:true},{headers:J})}return Response.json({error:\"Unknown action\"},{status:400})}\nconst tasks:any[]=(await sqlite.execute({sql:`SELECT * FROM execution_tasks WHERE project_id=? ORDER BY created_at DESC`,args:[id]})).rows;const acts:any[]=(await sqlite.execute({sql:`SELECT * FROM execution_activity WHERE project_id=? ORDER BY created_at DESC LIMIT 30`,args:[id]})).rows;return new Response(`5MC Execution Control

5MC PERFORMANCE / EXECUTION CONTROL

${esc(p.organization)} · ${esc(p.id)}

← Operations

New task

Tasks (${tasks.length})

${tasks.length?tasks.map(t=>`

${esc(t.title)}${esc(t.status)}

${esc(t.id)} · ${esc(t.owner)} · ${esc(t.milestone)} · due ${esc(t.due_date)}

`).join(''):'

No tasks yet. Create the first execution task above.

Activity history

${acts.length?acts.map(a=>`

${esc(a.event)} · ${esc(a.actor)}
${esc(a.note)}
${esc(a.created_at)}

`).join(''):'

No activity recorded yet.

`,{headers:H})}",[263],"a7fbacb5-4340-4798-b2f0-7dae888cbe49","execution-api.ts","266d14d0-a3be-11f1-8d3f-1607ee4eb77e",10,["D",1788017292644],4,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { SERVICES, getService } from \"./engine-config.ts\";\nconst db = sqlite;\nawait db.execute(`CREATE TABLE IF NOT EXISTS jobs (id TEXT PRIMARY KEY, created_at TEXT NOT NULL, status TEXT NOT NULL, service_id TEXT NOT NULL, client_name TEXT, contact TEXT, brief TEXT, payload TEXT NOT NULL)`);\nawait db.execute(`CREATE TABLE IF NOT EXISTS job_events (id INTEGER PRIMARY KEY AUTOINCREMENT, job_id TEXT NOT NULL, created_at TEXT NOT NULL, stage TEXT NOT NULL, status TEXT NOT NULL, detail TEXT)`);\nconst headers={\"content-type\":\"application/json; charset=utf-8\",\"access-control-allow-origin\":\"*\",\"access-control-allow-methods\":\"GET,POST,OPTIONS\",\"access-control-allow-headers\":\"content-type\"};\nconst json=(data:unknown,status=200)=>new Response(JSON.stringify(data),{status,headers});\nconst makeId=()=>`5MC-${Date.now().toString(36).toUpperCase()}-${crypto.randomUUID().slice(0,8).toUpperCase()}`;\nexport default async function(req:Request){\n if(req.method===\"OPTIONS\")return new Response(null,{status:204,headers});\n const u=new URL(req.url);\n if(req.method===\"GET\"&&u.pathname===\"/health\")return json({ok:true,system:\"5MC Service Execution Engine\",version:\"1.0\"});\n if(req.method===\"GET\"&&u.pathname===\"/services\")return json({services:SERVICES});\n if(req.method===\"GET\"&&u.pathname===\"/jobs\"){const r=await db.execute(`SELECT id,created_at,status,service_id,client_name,contact,brief FROM jobs ORDER BY created_at DESC LIMIT 100`);return json({jobs:r.rows});}\n if(req.method===\"GET\"&&u.pathname.startsWith(\"/jobs/\")){const jobId=u.pathname.split(\"/\")[2];const j=await db.execute(`SELECT * FROM jobs WHERE id=?`,[jobId]);if(!j.rows.length)return json({error:\"Job not found\"},404);const e=await db.execute(`SELECT * FROM job_events WHERE job_id=? ORDER BY id`,[jobId]);return json({job:j.rows[0],events:e.rows});}\n if(req.method===\"POST\"&&u.pathname===\"/execute\"){\n let b:any;try{b=await req.json()}catch{return json({error:\"Invalid JSON\"},400)}\n const s=getService(String(b.serviceId||\"\"));if(!s)return json({error:\"Unknown service\",available:SERVICES.map(x=>x.id)},400);\n const jobId=makeId(),now=new Date().toISOString(),name=String(b.clientName||b.name||\"\").slice(0,200),contact=String(b.contact||\"\").slice(0,200),brief=String(b.brief||b.objective||\"\").slice(0,4000);\n await db.execute(`INSERT INTO jobs(id,created_at,status,service_id,client_name,contact,brief,payload) VALUES(?,?,?,?,?,?,?,?)`,[jobId,now,\"queued\",s.id,name,contact,brief,JSON.stringify(b)]);\n await db.execute(`INSERT INTO job_events(job_id,created_at,stage,status,detail) VALUES(?,?,?,?,?)`,[jobId,now,s.stages[0],\"queued\",\"Execution plan created\"]);\n return json({ok:true,jobId,status:\"queued\",service:{id:s.id,name:s.name},execution:{stages:s.stages,outputs:s.outputs},nextAction:\"fulfillment_review\"},201);\n }\n return json({error:\"Not found\"},404);\n}\n",[270],"738b9d72-5e9c-4bcf-adda-06d86d5ad2d5","evidence-ledger.ts","dfc107ce-a540-11f1-8fb6-1607ee4eb77e",36,["D",1788183347539],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS evidence_ledger (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, stage TEXT NOT NULL, claim TEXT NOT NULL, evidence_type TEXT NOT NULL, source TEXT NOT NULL, measured_value TEXT NOT NULL, confidence TEXT NOT NULL, verification_status TEXT NOT NULL, recorded_by TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst stages=[\"brief\",\"diagnosis\",\"scope\",\"execution\",\"client_review\",\"completion\"];const evtypes=[\"client_provided\",\"internal_measurement\",\"external_source\",\"deliverable_proof\",\"client_confirmation\",\"not_available\"];const conf=[\"high\",\"medium\",\"low\",\"unknown\"];const ver=[\"verified\",\"partially_verified\",\"unverified\",\"unknown\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),id=u.searchParams.get(\"id\")||\"\";if(!id)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[id]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const required=[\"stage\",\"claim\",\"evidence_type\",\"source\",\"measured_value\",\"confidence\",\"verification_status\",\"recorded_by\"],missing=required.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete evidence record\",missing},{status:400});if(!stages.includes(b.stage)||!evtypes.includes(b.evidence_type)||!conf.includes(b.confidence)||!ver.includes(b.verification_status))return Response.json({error:\"Invalid evidence classification\"},{status:400});const now=new Date().toISOString(),eid=`EVD-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO evidence_ledger VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[eid,id,...required.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,evidenceId:eid},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM evidence_ledger WHERE project_id=? ORDER BY created_at DESC`,args:[id]})).rows;return new Response(`5MC Evidence Ledger

← Operations

Evidence Ledger

${esc(p.organization)} · ${esc(p.id)}

Every material claim should have a traceable basis. If something was not measured or verified, record it explicitly instead of filling the gap with an assumption.

Record evidence

Evidence history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.claim)}

${esc(r.stage)}${esc(r.evidence_type)}${esc(r.verification_status)}confidence: ${esc(r.confidence)}

Measured: ${esc(r.measured_value)}
Source: ${esc(r.source)}

${esc(r.recorded_by)} · ${esc(r.created_at)} · ${esc(r.id)}

`).join(''):'

No evidence records yet.

`,{headers:H})}",[278],"273e330e-6225-4945-9a8e-f1807e1641c3","engine-handoff-audit.ts","8d58847e-a556-11f1-b796-1607ee4eb77e",77,["D",1788192668672],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS engine_handoff_audits (id TEXT PRIMARY KEY,source_engine TEXT NOT NULL,target_engine TEXT NOT NULL,source_ref TEXT NOT NULL,target_ref TEXT NOT NULL,required_context TEXT NOT NULL,evidence_reference TEXT NOT NULL,status TEXT NOT NULL,checked_by TEXT NOT NULL,notes TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst statuses=[\"not_checked\",\"verified\",\"failed\",\"blocked\",\"inconclusive\"];\nexport default async function(req:Request){await db();if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"source_engine\",\"target_engine\",\"source_ref\",\"target_ref\",\"required_context\",\"evidence_reference\",\"status\",\"checked_by\",\"notes\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete handoff audit\",missing},{status:400});if(!statuses.includes(b.status))return Response.json({error:\"Invalid handoff status\"},{status:400});const id=`EHA-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO engine_handoff_audits VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,auditId:id},{headers:J})}const rows:any[]=(await sqlite.execute(`SELECT * FROM engine_handoff_audits ORDER BY created_at DESC`)).rows;return Response.json({handoffAuditCount:rows.length,records:rows},{headers:J})}",[285],"4d1189eb-2e91-4b47-ba8c-23f25071a315","engine-contracts.ts","1214eb58-a557-11f1-b948-1607ee4eb77e",78,["D",1788192880894],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst contracts=[\n {source:\"GROW\",target:\"CREATIVE\",required:[\"growth objective\",\"audience\",\"offer/message\",\"approved scope\",\"success criteria\"]},\n {source:\"CREATIVE\",target:\"DIGITAL\",required:[\"approved creative reference\",\"creative specification\",\"usage/delivery requirements\",\"acceptance criteria\"]},\n {source:\"DIGITAL\",target:\"PROMOTION\",required:[\"digital delivery reference\",\"verified acceptance\",\"approved creative reference\",\"implementation/technical constraints\",\"success criteria\"]},\n];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS engine_contract_checks (id TEXT PRIMARY KEY,source_engine TEXT NOT NULL,target_engine TEXT NOT NULL,source_ref TEXT NOT NULL,target_ref TEXT NOT NULL,context_received TEXT NOT NULL,missing_context TEXT NOT NULL,status TEXT NOT NULL,evidence_reference TEXT NOT NULL,checked_by TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"source_engine\",\"target_engine\",\"source_ref\",\"target_ref\",\"context_received\",\"missing_context\",\"status\",\"evidence_reference\",\"checked_by\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete contract check\",missing},{status:400});const valid=contracts.some(c=>c.source===b.source_engine&&c.target===b.target_engine);if(!valid)return Response.json({error:\"Unsupported engine handoff\",allowed:contracts.map(c=>`${c.source}->${c.target}`)},{status:400});const id=`ECC-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO engine_contract_checks VALUES (?,?,?,?,?,?,?,?,?,?)`,args:[id,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,checkId:id,requiredContext:contracts.find(c=>c.source===b.source_engine&&c.target===b.target_engine)?.required},{headers:J})}return Response.json({contracts,checks:(await sqlite.execute(`SELECT * FROM engine_contract_checks ORDER BY created_at DESC`)).rows},{headers:J})}",[292],"27482be1-2780-4e63-b63f-5af634a5fc3f","engine-config.ts","1f9904de-a3be-11f1-9bc8-1607ee4eb77e",["D",1788017239401],"export type ServiceDefinition = {\n id: string;\n name: string;\n category: string;\n promise: string;\n intake: string[];\n stages: string[];\n outputs: string[];\n};\n\nexport const SERVICES: ServiceDefinition[] = [\n { id:'advertising', name:'Precision Advertising', category:'Growth', promise:'Turn attention into qualified demand.', intake:['business','offer','audience','budget','goal'], stages:['diagnose offer and audience','build campaign architecture','produce creative brief','prepare launch checklist','measure and optimize'], outputs:['campaign plan','creative brief','audience plan','measurement plan'] },\n { id:'creative', name:'Ad Videos & Content', category:'Creative', promise:'Create attention assets built for action.', intake:['business','offer','platform','format','goal'], stages:['define hook','write storyboard','produce asset brief','quality review','deployment package'], outputs:['creative brief','storyboard','asset specifications','deployment checklist'] },\n { id:'branding', name:'Brand Architecture', category:'Brand', promise:'Build a brand people can recognize and trust.', intake:['business','positioning','audience','competitors','desired perception'], stages:['brand diagnosis','positioning architecture','identity direction','messaging system','brand handoff'], outputs:['brand brief','positioning statement','messaging pillars','identity specification'] },\n { id:'web', name:'Websites & Landing Pages', category:'Infrastructure', promise:'Build digital experiences that move visitors to action.', intake:['business','offer','audience','conversion_goal','content'], stages:['conversion diagnosis','information architecture','page specification','build checklist','launch QA'], outputs:['page architecture','conversion copy brief','technical specification','QA checklist'] },\n { id:'promotion', name:'Social & 360° Promotion', category:'Growth', promise:'Coordinate visibility across the channels that matter.', intake:['business','campaign','audience','location','goal'], stages:['channel diagnosis','promotion plan','content schedule','distribution checklist','performance review'], outputs:['channel plan','content calendar','distribution plan','KPI sheet'] },\n { id:'design', name:'Graphics & Business Design', category:'Creative', promise:'Turn business information into clear visual communication.', intake:['business','asset_type','message','audience','format'], stages:['message hierarchy','design direction','production specification','QA','delivery'], outputs:['design brief','layout specification','copy hierarchy','delivery checklist'] },\n { id:'seo', name:'SEO & Google Business', category:'Visibility', promise:'Make the business easier to discover and trust.', intake:['business','location','website','services','target_queries'], stages:['visibility diagnosis','keyword and intent map','local optimization plan','content opportunities','measurement setup'], outputs:['SEO audit brief','keyword map','local optimization checklist','content plan'] },\n { id:'automation', name:'Lead Capture & Automation', category:'Systems', promise:'Turn inbound interest into an organized operating pipeline.', intake:['business','lead_source','offer','qualification_rules','destination'], stages:['funnel mapping','lead schema','automation design','routing rules','QA'], outputs:['funnel map','lead schema','automation specification','routing matrix'] },\n { id:'media', name:'Cinematography & Media', category:'Production', promise:'Capture professional media that strengthens the commercial story.', intake:['business','production_type','location','message','deliverables'], stages:['creative treatment','shot planning','production checklist','post-production plan','delivery QA'], outputs:['treatment','shot list','production schedule','delivery specification'] },\n { id:'verification', name:'Business Verification', category:'Trust', promise:'Strengthen the trust layer around the business.', intake:['business','platform','location','existing_assets','issue'], stages:['asset audit','verification requirements','submission checklist','exception handling','status tracking'], outputs:['verification checklist','asset requirements','submission plan','exception log'] },\n { id:'ai-systems', name:'AI & Smart Systems', category:'Intelligence', promise:'Convert repetitive business work into intelligent workflows.', intake:['business','workflow','inputs','desired_output','constraints'], stages:['workflow discovery','system architecture','automation specification','test cases','handoff'], outputs:['system map','prompt/specification pack','automation plan','test suite'] },\n { id:'documents', name:'Business Documents & Presentations', category:'Business', promise:'Package business information for decisions, sales and partnerships.', intake:['business','document_type','audience','objective','source_material'], stages:['content audit','information architecture','draft specification','review checklist','delivery'], outputs:['document outline','content specification','review checklist','delivery plan'] },\n];\n\nexport const getService = (id: string) => SERVICES.find(s => s.id === id);\n",[299],"acc02c7b-4ef8-4f00-8a7a-e848a4d5da54","digital-testing.ts","d5677eb6-a54f-11f1-b3c7-1607ee4eb77e",68,["D",1788189772603],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_tests (id TEXT PRIMARY KEY,digital_id TEXT NOT NULL,implementation_id TEXT NOT NULL,test_name TEXT NOT NULL,test_method TEXT NOT NULL,expected_result TEXT NOT NULL,actual_result TEXT NOT NULL,result TEXT NOT NULL,evidence_reference TEXT NOT NULL,tested_by TEXT NOT NULL,tested_at TEXT NOT NULL,notes TEXT NOT NULL)`)}\nconst results=[\"not_run\",\"passed\",\"failed\",\"blocked\",\"inconclusive\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),did=u.searchParams.get(\"id\")||\"\";if(!did)return new Response(\"Missing digital project id\",{status:400});const d:any=(await sqlite.execute({sql:`SELECT * FROM digital_projects WHERE id=?`,args:[did]})).rows[0];if(!d)return new Response(\"Digital project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"implementation_id\",\"test_name\",\"test_method\",\"expected_result\",\"actual_result\",\"result\",\"evidence_reference\",\"tested_by\",\"tested_at\",\"notes\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete test record\",missing},{status:400});if(!results.includes(b.result))return Response.json({error:\"Invalid test result\"},{status:400});const now=new Date().toISOString(),id=`DTE-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO digital_tests VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,did,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,testId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM digital_tests WHERE digital_id=? ORDER BY tested_at DESC`,args:[did]})).rows;return new Response(`5MC Digital Testing

← Digital project

5MC / DIGITAL TESTING & VERIFICATION

${esc(d.id)}

Testing records the method, expected result, observed result and evidence. No pass is inferred.

Record test

Test history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.test_name)} ${esc(r.result)}

${esc(r.actual_result)}

Expected: ${esc(r.expected_result)}
Method: ${esc(r.test_method)}
Evidence: ${esc(r.evidence_reference)}

${esc(r.tested_by)} · ${esc(r.tested_at)} · ${esc(r.id)}

`).join(''):'

No tests recorded yet.

`,{headers:H})}",[305],"2247e290-9161-42d7-ad39-e985a8a9ac9a","digital-remediation.ts","83a02604-a550-11f1-82ff-1607ee4eb77e",69,["D",1788190064936],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_remediation (id TEXT PRIMARY KEY,digital_id TEXT NOT NULL,test_id TEXT NOT NULL,issue TEXT NOT NULL,action TEXT NOT NULL,owner TEXT NOT NULL,status TEXT NOT NULL,evidence_reference TEXT NOT NULL,resolution_note TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nconst st=[\"open\",\"in_progress\",\"blocked\",\"resolved\",\"wont_fix\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),did=u.searchParams.get(\"id\")||\"\";if(!did)return new Response(\"Missing digital project id\",{status:400});const d:any=(await sqlite.execute({sql:`SELECT * FROM digital_projects WHERE id=?`,args:[did]})).rows[0];if(!d)return new Response(\"Digital project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"test_id\",\"issue\",\"action\",\"owner\",\"status\",\"evidence_reference\",\"resolution_note\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete remediation record\",missing},{status:400});if(!st.includes(b.status))return Response.json({error:\"Invalid remediation status\"},{status:400});const now=new Date().toISOString(),id=`DRM-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO digital_remediation VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,did,...keys.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,remediationId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM digital_remediation WHERE digital_id=? ORDER BY created_at DESC`,args:[did]})).rows;return new Response(`5MC Digital Remediation

← Testing

5MC / DIGITAL REMEDIATION

${esc(d.id)}

Failed or blocked tests become explicit remediation work. Resolution requires evidence.

Record remediation

Remediation history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.id)} ${esc(r.status)}

${esc(r.issue)}

Action: ${esc(r.action)}
Evidence: ${esc(r.evidence_reference)}
Resolution: ${esc(r.resolution_note)}

${esc(r.owner)} · ${esc(r.created_at)}

`).join(''):'

No remediation records.

`,{headers:H})}",[312],"dd171f01-4670-4ca5-819b-5e6f62353542","digital-implementation.ts","93c59580-a54d-11f1-81b5-1607ee4eb77e",67,["D",1788188803531],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_implementation (id TEXT PRIMARY KEY,digital_id TEXT NOT NULL,scope_item TEXT NOT NULL,component TEXT NOT NULL,implementation_ref TEXT NOT NULL,status TEXT NOT NULL,owner TEXT NOT NULL,started_at TEXT NOT NULL,completed_at TEXT NOT NULL,notes TEXT NOT NULL,created_at TEXT NOT NULL)`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_changes (id TEXT PRIMARY KEY,digital_id TEXT NOT NULL,implementation_id TEXT NOT NULL,request TEXT NOT NULL,reason TEXT NOT NULL,requested_by TEXT NOT NULL,impact TEXT NOT NULL,risk TEXT NOT NULL,decision TEXT NOT NULL,status TEXT NOT NULL,decided_by TEXT NOT NULL,decided_at TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst ist=[\"planned\",\"in_progress\",\"blocked\",\"implemented\",\"superseded\"];const cst=[\"requested\",\"under_review\",\"approved\",\"rejected\",\"implemented\",\"cancelled\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),did=u.searchParams.get(\"id\")||\"\";if(!did)return new Response(\"Missing digital project id\",{status:400});const d:any=(await sqlite.execute({sql:`SELECT * FROM digital_projects WHERE id=?`,args:[did]})).rows[0];if(!d)return new Response(\"Digital project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const kind=b.kind;if(kind===\"implementation\"){const keys=[\"scope_item\",\"component\",\"implementation_ref\",\"status\",\"owner\",\"started_at\",\"completed_at\",\"notes\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete implementation record\",missing},{status:400});if(!ist.includes(b.status))return Response.json({error:\"Invalid implementation status\"},{status:400});const now=new Date().toISOString(),id=`DIM-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO digital_implementation VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,did,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,implementationId:id},{headers:J})}if(kind===\"change\"){const keys=[\"implementation_id\",\"request\",\"reason\",\"requested_by\",\"impact\",\"risk\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete change request\",missing},{status:400});const now=new Date().toISOString(),id=`DCH-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO digital_changes VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,did,...keys.map(k=>String(b[k]).trim()),\"requested\",\"\",\"\",now]});return Response.json({ok:true,changeId:id},{headers:J})}return Response.json({error:\"Unknown record kind\"},{status:400})}\nconst impl:any[]=(await sqlite.execute({sql:`SELECT * FROM digital_implementation WHERE digital_id=? ORDER BY created_at DESC`,args:[did]})).rows;const ch:any[]=(await sqlite.execute({sql:`SELECT * FROM digital_changes WHERE digital_id=? ORDER BY created_at DESC`,args:[did]})).rows;return new Response(`5MC Digital Implementation

← Digital project

5MC / DIGITAL IMPLEMENTATION & CHANGE CONTROL

${esc(d.id)}

Implementation records what changed. Change requests protect the approved scope.

Implementation record

Change request

Implementation history (${impl.length})

${impl.length?impl.map(r=>`

${esc(r.scope_item)} · ${esc(r.component)} ${esc(r.status)}

${esc(r.implementation_ref)}

${esc(r.owner)} · ${esc(r.created_at)} · ${esc(r.id)}

`).join(''):'

No implementation records.

Change history (${ch.length})

${ch.length?ch.map(r=>`

${esc(r.id)} ${esc(r.status)}

${esc(r.request)}

Reason: ${esc(r.reason)} · Impact: ${esc(r.impact)} · Risk: ${esc(r.risk)}

${esc(r.requested_by)} · ${esc(r.created_at)}

`).join(''):'

No change requests.

`,{headers:H})}",[319],"97e62b20-ca50-4725-b763-7f6b5222e188","digital-engine.ts","a945a57c-a54c-11f1-a72a-1607ee4eb77e",65,["D",1788188570876],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_projects (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, digital_type TEXT NOT NULL, objective TEXT NOT NULL, audience TEXT NOT NULL, current_state TEXT NOT NULL, platform TEXT NOT NULL, requirements TEXT NOT NULL, integrations TEXT NOT NULL, access_needed TEXT NOT NULL, content_source TEXT NOT NULL, success_criteria TEXT NOT NULL, risks TEXT NOT NULL, status TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL)`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_deliverables (id TEXT PRIMARY KEY, digital_id TEXT NOT NULL, deliverable TEXT NOT NULL, version TEXT NOT NULL, reference TEXT NOT NULL, review_status TEXT NOT NULL, acceptance_status TEXT NOT NULL, notes TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst types=[\"website\",\"landing_page\",\"web_app\",\"automation\",\"integration\",\"seo_setup\",\"analytics_setup\",\"business_profile\",\"technical_support\"],statuses=[\"briefed\",\"discovery\",\"build\",\"internal_review\",\"client_review\",\"approved\",\"delivered\",\"on_hold\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing GROW project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const reqs=[\"digital_type\",\"objective\",\"audience\",\"current_state\",\"platform\",\"requirements\",\"integrations\",\"access_needed\",\"content_source\",\"success_criteria\",\"risks\"],missing=reqs.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete the digital brief\",missing},{status:400});if(!types.includes(b.digital_type)||!statuses.includes(b.status||\"briefed\"))return Response.json({error:\"Invalid digital type or status\"},{status:400});if(!['approved_for_build','in_progress','client_review','completed'].includes(String(p.status)))return Response.json({error:\"Digital work can only start from an approved GROW project\"},{status:409});const now=new Date().toISOString(),did=`DIG-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO digital_projects VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[did,pid,...reqs.map(k=>String(b[k]).trim()),String(b.status||\"briefed\"),now,now]});await sqlite.execute({sql:`INSERT INTO execution_activity VALUES (?,?,?,?,?,?)`,args:[crypto.randomUUID(),pid,'digital_brief_created','5MC Digital Engine',`${did} created for ${b.digital_type}`,now]});return Response.json({ok:true,digitalId:did,projectId:pid,status:b.status||\"briefed\"},{headers:J})}\nconst rows:any[]=(await sqlite.execute({sql:`SELECT * FROM digital_projects WHERE project_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(`5MC Digital Engine

← Operations

5MC DIGITAL ENGINE

${esc(p.organization)}

${esc(p.id)} · ${esc(p.service)}

Digital rule: start from a defined business objective and approved GROW scope. Record platform, access, integrations, dependencies and measurable acceptance criteria. Never claim a technical check, analytics result or integration is complete unless it was actually performed.

Create digital project

Digital projects (${rows.length})

${rows.length?rows.map(x=>`

${esc(x.id)} · ${esc(x.digital_type)} · ${esc(x.status)}

${esc(x.objective)}
${esc(x.platform)} · Acceptance: ${esc(x.success_criteria)}

`).join(''):'

No digital projects yet.

Discovery & Technical Scope →`,{headers:H})}",[326],"02391a21-f2d7-404f-ae61-21ced7253b8f","digital-discovery.ts","05880b40-a54d-11f1-aa8e-1607ee4eb77e",66,["D",1788188577370],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_discovery (id TEXT PRIMARY KEY, digital_id TEXT NOT NULL, current_state TEXT NOT NULL, platform_environment TEXT NOT NULL, access_status TEXT NOT NULL, integrations TEXT NOT NULL, dependencies TEXT NOT NULL, technical_findings TEXT NOT NULL, acceptance_criteria TEXT NOT NULL, risk_notes TEXT NOT NULL, evidence_reference TEXT NOT NULL, status TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL)`)}\nconst states=[\"not_assessed\",\"documented\",\"tested\",\"blocked\"],access=[\"not_requested\",\"requested\",\"received\",\"verified\",\"blocked\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),did=u.searchParams.get(\"id\")||\"\";if(!did)return new Response(\"Missing digital project id\",{status:400});const d:any=(await sqlite.execute({sql:`SELECT * FROM digital_projects WHERE id=?`,args:[did]})).rows[0];if(!d)return new Response(\"Digital project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"current_state\",\"platform_environment\",\"access_status\",\"integrations\",\"dependencies\",\"technical_findings\",\"acceptance_criteria\",\"risk_notes\",\"evidence_reference\",\"status\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete discovery record\",missing},{status:400});if(!states.includes(b.current_state)||!access.includes(b.access_status))return Response.json({error:\"Invalid discovery state or access status\"},{status:400});const now=new Date().toISOString(),id=`DDC-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO digital_discovery VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,did,...keys.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,discoveryId:id},{headers:J})}\nconst rows:any[]=(await sqlite.execute({sql:`SELECT * FROM digital_discovery WHERE digital_id=? ORDER BY created_at DESC`,args:[did]})).rows;return new Response(`5MC Digital Discovery

← Digital project

5MC / DIGITAL DISCOVERY & TECHNICAL SCOPE

${esc(d.id)}

Discovery separates what is known, tested, blocked, and not yet assessed.

Record discovery

Discovery history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.current_state)} · ${esc(r.status)} access: ${esc(r.access_status)}

${esc(r.technical_findings)}

Acceptance: ${esc(r.acceptance_criteria)}

Evidence: ${esc(r.evidence_reference)}

${esc(r.id)} · ${esc(r.created_at)}

`).join(''):'

No discovery records yet.

`,{headers:H})}",[333],"c1c4bd34-1acc-4563-a807-406fbe93f5bf","digital-acceptance.ts","64287ba4-a551-11f1-a32d-1607ee4eb77e",70,["D",1788190441631],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS digital_acceptance (id TEXT PRIMARY KEY,digital_id TEXT NOT NULL,criteria TEXT NOT NULL,verification_basis TEXT NOT NULL,status TEXT NOT NULL,client_decision TEXT NOT NULL,decided_by TEXT NOT NULL,decided_at TEXT NOT NULL,delivery_reference TEXT NOT NULL,notes TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nconst statuses=[\"pending\",\"ready_for_review\",\"accepted\",\"changes_requested\",\"blocked\",\"rejected\"];const decisions=[\"pending\",\"accepted\",\"changes_requested\",\"rejected\",\"not_applicable\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),did=u.searchParams.get(\"id\")||\"\";if(!did)return new Response(\"Missing digital project id\",{status:400});const d:any=(await sqlite.execute({sql:`SELECT * FROM digital_projects WHERE id=?`,args:[did]})).rows[0];if(!d)return new Response(\"Digital project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"criteria\",\"verification_basis\",\"status\",\"client_decision\",\"decided_by\",\"decided_at\",\"delivery_reference\",\"notes\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete acceptance record\",missing},{status:400});if(!statuses.includes(b.status)||!decisions.includes(b.client_decision))return Response.json({error:\"Invalid acceptance status or decision\"},{status:400});if(b.client_decision===\"accepted\"&&b.status!==\"accepted\")return Response.json({error:\"Accepted decision requires status=accepted\"},{status:400});const now=new Date().toISOString(),id=`DAC-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO digital_acceptance VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,did,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,acceptanceId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM digital_acceptance WHERE digital_id=? ORDER BY created_at DESC`,args:[did]})).rows;return new Response(`5MC Digital Acceptance

← Digital project

5MC / DIGITAL ACCEPTANCE & DELIVERY

${esc(d.id)}

Acceptance is based on documented criteria and verification—not a generic completion claim.

Record acceptance

Acceptance history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.id)} ${esc(r.status)} / ${esc(r.client_decision)}

${esc(r.criteria)}

Verification: ${esc(r.verification_basis)}
Delivery: ${esc(r.delivery_reference)}

${esc(r.decided_by)} · ${esc(r.decided_at)}

`).join(''):'

No acceptance records.

`,{headers:H})}",[340],"714ac8ce-f228-4e1d-8646-8632bec5f1a9","diagnosis.ts","e2d980ac-a528-11f1-86ad-1607ee4eb77e",26,["D",1788173044830],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst headers={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};\nconst esc=(v:unknown)=>String(v??\"\").replace(/[&<>\\\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS project_reviews (project_id TEXT PRIMARY KEY, verified_findings TEXT NOT NULL, evidence_sources TEXT NOT NULL, unknowns TEXT NOT NULL, risks TEXT NOT NULL, diagnosis TEXT NOT NULL, recommendation TEXT NOT NULL, scope_decision TEXT NOT NULL, reviewer TEXT NOT NULL, updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();const u=new URL(req.url);const id=u.searchParams.get(\"id\")||\"\";if(!id)return new Response(\"Missing project id\",{status:400});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid JSON\"},{status:400})}const vals=[\"verified_findings\",\"evidence_sources\",\"unknowns\",\"risks\",\"diagnosis\",\"recommendation\",\"scope_decision\",\"reviewer\"];const missing=vals.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete every review field\",missing},{status:400});const now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_reviews (project_id,verified_findings,evidence_sources,unknowns,risks,diagnosis,recommendation,scope_decision,reviewer,updated_at) VALUES (?,?,?,?,?,?,?,?,?,?) ON CONFLICT(project_id) DO UPDATE SET verified_findings=excluded.verified_findings,evidence_sources=excluded.evidence_sources,unknowns=excluded.unknowns,risks=excluded.risks,diagnosis=excluded.diagnosis,recommendation=excluded.recommendation,scope_decision=excluded.scope_decision,reviewer=excluded.reviewer,updated_at=excluded.updated_at`,args:[id,...vals.map(k=>String(b[k]??\"\").trim()),now]});return Response.json({ok:true,projectId:id,updatedAt:now})}const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[id]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});const r:any=(await sqlite.execute({sql:`SELECT * FROM project_reviews WHERE project_id=?`,args:[id]})).rows[0]||{};return new Response(`5MC Diagnosis

5MC PERFORMANCE / DIAGNOSIS

← Operations

${esc(p.id)}

${esc(p.organization)}

${esc(p.service)} · ${esc(p.industry)} · ${esc(p.location)}

Client objective: ${esc(p.objective)}

Current situation: ${esc(p.current_state)}

Evidence rule: record what is actually verified. If evidence is unavailable, record it as unknown. Never manufacture a score, revenue loss, competitor, scan, result or claim.

`,{headers})}",[347],"0bdc34d5-af01-4e34-b491-c3033a94f9d8","creative-revisions.ts","1ea4c506-a547-11f1-9bbb-1607ee4eb77e",56,["D",1788186029969],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS creative_revisions (id TEXT PRIMARY KEY, creative_id TEXT NOT NULL, parent_production_id TEXT NOT NULL, revision_no INTEGER NOT NULL, reason TEXT NOT NULL, requested_by TEXT NOT NULL, requested_at TEXT NOT NULL, status TEXT NOT NULL, resolution_note TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst statuses=[\"requested\",\"in_progress\",\"resolved\",\"cancelled\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),cid=u.searchParams.get(\"id\")||\"\";if(!cid)return new Response(\"Missing creative id\",{status:400});const c:any=(await sqlite.execute({sql:`SELECT * FROM creative_projects WHERE id=?`,args:[cid]})).rows[0];if(!c)return new Response(\"Creative project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}if(!String(b.reason||\"\").trim()||!String(b.requested_by||\"\").trim())return Response.json({error:\"Revision reason and requester are required\"},{status:400});const last:any=(await sqlite.execute({sql:`SELECT MAX(revision_no) n FROM creative_revisions WHERE creative_id=?`,args:[cid]})).rows[0];const n=Number(last?.n||0)+1,now=new Date().toISOString(),id=`REV-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO creative_revisions VALUES (?,?,?,?,?,?,?,?,?,?)`,args:[id,cid,String(b.parent_production_id||\"none\"),n,String(b.reason).trim(),String(b.requested_by).trim(),now,\"requested\",\"\",now]});return Response.json({ok:true,revisionId:id,revisionNo:n},{headers:J})}\nconst rows:any[]=(await sqlite.execute({sql:`SELECT * FROM creative_revisions WHERE creative_id=? ORDER BY revision_no DESC`,args:[cid]})).rows;return new Response(`5MC Creative Revisions

← Creative project

5MC / REVISION CONTROL

${esc(c.id)}

Revision history is immutable: every requested change receives its own revision record.

Request revision

Revision history (${rows.length})

${rows.length?rows.map(r=>`

Revision ${r.revision_no} ${esc(r.status)}

${esc(r.reason)}

${esc(r.requested_by)} · ${esc(r.requested_at)} · ${esc(r.id)}

`).join(''):'

No revision requests recorded.

`,{headers:H})}",[354],"0ff11ca8-9a70-426e-858e-bed08701eb76","creative-production.ts","31499aa2-a546-11f1-b65a-1607ee4eb77e",54,["D",1788185815676],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"}; const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS creative_production (id TEXT PRIMARY KEY, creative_id TEXT NOT NULL, version TEXT NOT NULL, concept TEXT NOT NULL, draft_reference TEXT NOT NULL, review_status TEXT NOT NULL, reviewer TEXT NOT NULL, review_notes TEXT NOT NULL, approval_status TEXT NOT NULL, delivery_evidence TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL)`)}\nconst reviews=[\"internal_review\",\"changes_requested\",\"client_review\",\"approved\",\"rejected\"];const approvals=[\"pending\",\"approved\",\"rejected\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),cid=u.searchParams.get(\"id\")||\"\";if(!cid)return new Response(\"Missing creative brief id\",{status:400});const c:any=(await sqlite.execute({sql:`SELECT * FROM creative_projects WHERE id=?`,args:[cid]})).rows[0];if(!c)return new Response(\"Creative brief not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const reqs=[\"version\",\"concept\",\"draft_reference\",\"review_status\",\"reviewer\",\"review_notes\",\"approval_status\",\"delivery_evidence\"],missing=reqs.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete production record\",missing},{status:400});if(!reviews.includes(b.review_status)||!approvals.includes(b.approval_status))return Response.json({error:\"Invalid review or approval status\"},{status:400});const now=new Date().toISOString(),id=`CRP-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO creative_production VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,cid,...reqs.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,productionId:id},{headers:J})}\nconst rows:any[]=(await sqlite.execute({sql:`SELECT * FROM creative_production WHERE creative_id=? ORDER BY created_at DESC`,args:[cid]})).rows;return new Response(`5MC Creative Production

← OperationsFinal delivery →

5MC / CREATIVE PRODUCTION

${esc(c.title||c.name||cid)}

Creative brief ${esc(cid)}

Objective: ${esc(c.objective)}

Production version

Version history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.version)} · ${esc(r.concept)} ${esc(r.review_status)} / ${esc(r.approval_status)}

Draft: ${esc(r.draft_reference)}

${esc(r.review_notes)}

${esc(r.reviewer)} · ${esc(r.created_at)}

`).join(''):'

No production versions recorded yet.

`,{headers:H})}",[361],"a87d6f15-17c5-429c-91ab-9cea2a146976","creative-evidence.ts","a9874586-a547-11f1-a911-1607ee4eb77e",60,["D",1788186263016],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS creative_evidence (id TEXT PRIMARY KEY, creative_id TEXT NOT NULL, asset_id TEXT NOT NULL, evidence_type TEXT NOT NULL, claim TEXT NOT NULL, reference TEXT NOT NULL, verification_status TEXT NOT NULL, recorded_by TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst types=[\"asset_delivery\",\"client_acceptance\",\"approval_record\",\"revision_resolution\",\"production_proof\"];const states=[\"verified\",\"partially_verified\",\"unverified\",\"unknown\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),cid=u.searchParams.get(\"id\")||\"\";if(!cid)return new Response(\"Missing creative project id\",{status:400});const c:any=(await sqlite.execute({sql:`SELECT * FROM creative_projects WHERE id=?`,args:[cid]})).rows[0];if(!c)return new Response(\"Creative project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"asset_id\",\"evidence_type\",\"claim\",\"reference\",\"verification_status\",\"recorded_by\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete evidence record\",missing},{status:400});if(!types.includes(b.evidence_type)||!states.includes(b.verification_status))return Response.json({error:\"Invalid evidence type or status\"},{status:400});const now=new Date().toISOString(),id=`CEV-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO creative_evidence VALUES (?,?,?,?,?,?,?,?,?)`,args:[id,cid,...keys.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,evidenceId:id},{headers:J})}const rows:any[]=(await sqlite.execute({sql:`SELECT * FROM creative_evidence WHERE creative_id=? ORDER BY created_at DESC`,args:[cid]})).rows;return new Response(`5MC Creative Evidence

← Creative

5MC / CREATIVE EVIDENCE

${esc(c.id)}

Proof belongs to the asset it supports. Evidence status is explicit.

Record evidence

Evidence history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.claim)} ${esc(r.verification_status)}

${esc(r.evidence_type)} · ${esc(r.reference)}

${esc(r.asset_id)} · ${esc(r.recorded_by)} · ${esc(r.created_at)}

`).join(''):'

No creative evidence recorded.

`,{headers:H})}",[368],"34cc3c6b-30a7-47e1-9438-31d166b6573d","creative-engine.ts","d2e4a394-a545-11f1-95ba-1607ee4eb77e",61,["D",1788186269112],6,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS creative_projects (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, creative_type TEXT NOT NULL, objective TEXT NOT NULL, audience TEXT NOT NULL, core_message TEXT NOT NULL, tone TEXT NOT NULL, format TEXT NOT NULL, hook TEXT NOT NULL, cta TEXT NOT NULL, asset_requirements TEXT NOT NULL, brand_requirements TEXT NOT NULL, status TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL)`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS execution_activity (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, event TEXT NOT NULL, actor TEXT NOT NULL, note TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst types=[\"ad_video\",\"product_video\",\"social_creative\",\"campaign_creative\",\"brand_content\",\"graphics\",\"copy\"],statuses=[\"draft\",\"briefed\",\"concept\",\"production\",\"internal_review\",\"client_review\",\"approved\",\"archived\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const reqs=[\"creative_type\",\"objective\",\"audience\",\"core_message\",\"tone\",\"format\",\"hook\",\"cta\",\"asset_requirements\",\"brand_requirements\"],missing=reqs.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete the creative brief\",missing},{status:400});if(!types.includes(b.creative_type)||!statuses.includes(b.status||\"draft\"))return Response.json({error:\"Invalid creative type or status\"},{status:400});if(!['approved_for_build','in_progress','client_review','completed'].includes(String(p.status)))return Response.json({error:\"Creative work can only be opened from an approved GROW project\"},{status:409});const now=new Date().toISOString(),cid=`CRT-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO creative_projects VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[cid,pid,...reqs.map(k=>String(b[k]).trim()),String(b.status||\"briefed\"),now,now]});await sqlite.execute({sql:`INSERT INTO execution_activity (id,project_id,event,actor,note,created_at) VALUES (?,?,?,?,?,?)`,args:[crypto.randomUUID(),pid,'creative_brief_created','5MC Creative Engine',`${cid} created for ${b.creative_type}`,now]});return Response.json({ok:true,creativeId:cid,projectId:pid,status:b.status||\"briefed\"},{headers:J})}\nconst c:any[]=(await sqlite.execute({sql:`SELECT * FROM creative_projects WHERE project_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(`5MC Creative Engine

← Operations

5MC CREATIVE ENGINE

${esc(p.organization)}

${esc(p.id)} · ${esc(p.service)}

Creative rule: creative starts from a business objective and approved scope. Concepts are hypotheses, not promised performance. Required assets, brand constraints and review gates are explicit.

Create creative brief

Creative projects (${c.length})

${c.length?c.map(x=>`

${esc(x.id)} · ${esc(x.creative_type)} · ${esc(x.status)}

${esc(x.objective)}
Audience: ${esc(x.audience)}
Format: ${esc(x.format)} · CTA: ${esc(x.cta)}

Open production → · Revision control → · Asset registry → · Evidence →

`).join(''):'

No creative projects yet.

`,{headers:H})}",[375],"15ff638c-8954-4cfb-8dc6-9dc1132117ff","creative-delivery.ts","9ca72576-a546-11f1-85d8-1607ee4eb77e",53,["D",1788185811961],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS creative_deliveries (id TEXT PRIMARY KEY, production_id TEXT NOT NULL, deliverable_name TEXT NOT NULL, final_version TEXT NOT NULL, asset_reference TEXT NOT NULL, delivery_channel TEXT NOT NULL, delivered_to TEXT NOT NULL, delivery_status TEXT NOT NULL, acceptance_status TEXT NOT NULL, notes TEXT NOT NULL, created_at TEXT NOT NULL)`);await sqlite.execute(`CREATE TABLE IF NOT EXISTS evidence_ledger (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, stage TEXT NOT NULL, claim TEXT NOT NULL, evidence_type TEXT NOT NULL, source TEXT NOT NULL, measured_value TEXT NOT NULL, confidence TEXT NOT NULL, verification_status TEXT NOT NULL, recorded_by TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst ds=[\"ready\",\"delivered\",\"delivery_failed\"],as=[\"pending\",\"accepted\",\"changes_requested\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),cid=u.searchParams.get(\"id\")||\"\";if(!cid)return new Response(\"Missing production id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM creative_production WHERE id=?`,args:[cid]})).rows[0];if(!p)return new Response(\"Production version not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const reqs=[\"deliverable_name\",\"final_version\",\"asset_reference\",\"delivery_channel\",\"delivered_to\",\"delivery_status\",\"acceptance_status\",\"notes\"],missing=reqs.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete delivery record\",missing},{status:400});if(!ds.includes(b.delivery_status)||!as.includes(b.acceptance_status))return Response.json({error:\"Invalid delivery or acceptance status\"},{status:400});const now=new Date().toISOString(),did=`DLV-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO creative_deliveries VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[did,cid,...reqs.map(k=>String(b[k]).trim()),now]});const project:any=(await sqlite.execute({sql:`SELECT project_id FROM creative_projects WHERE id=?`,args:[p.creative_id]})).rows[0];if(project&&b.delivery_status==='delivered'){await sqlite.execute({sql:`INSERT INTO evidence_ledger VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[`EVD-${crypto.randomUUID().slice(0,8).toUpperCase()}`,project.project_id,'completion',`Creative deliverable ${b.deliverable_name} ${b.final_version} delivered to ${b.delivered_to}`,'deliverable_proof',b.asset_reference,'delivered','high','verified','5MC Creative Engine',now]})}return Response.json({ok:true,deliveryId:did,recordedEvidence:b.delivery_status==='delivered'},{headers:J})}\nconst rows:any[]=(await sqlite.execute({sql:`SELECT * FROM creative_deliveries WHERE production_id=? ORDER BY created_at DESC`,args:[cid]})).rows;return new Response(`5MC Creative Delivery

← Production

5MC / FINAL DELIVERY

Document deliverable handoff

Production ${esc(p.id)} · ${esc(p.version)} · ${esc(p.concept)}

Delivery rule: a final asset is not considered delivered because a team member says it is. Record the exact asset reference, recipient/channel, delivery status and acceptance state. When marked delivered, a completion evidence record is written to the project Evidence Ledger.

Delivery history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.deliverable_name)} · ${esc(r.final_version)} ${esc(r.delivery_status)} / ${esc(r.acceptance_status)}

${esc(r.asset_reference)}
${esc(r.delivery_channel)} → ${esc(r.delivered_to)}
${esc(r.notes)}

${esc(r.created_at)}

`).join(''):'

No delivery records yet.

`,{headers:H})}",[383],"3522ce90-ac5b-4b5a-a930-445960ad9963","creative-assets.ts","6bc839f8-a547-11f1-b035-1607ee4eb77e",58,["D",1788186159465],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS creative_assets (id TEXT PRIMARY KEY, creative_id TEXT NOT NULL, production_id TEXT NOT NULL, asset_name TEXT NOT NULL, asset_type TEXT NOT NULL, version TEXT NOT NULL, asset_reference TEXT NOT NULL, status TEXT NOT NULL, delivered_to TEXT NOT NULL, delivery_channel TEXT NOT NULL, delivery_at TEXT NOT NULL, acceptance_status TEXT NOT NULL, notes TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nconst statuses=[\"draft\",\"internal_approved\",\"client_approved\",\"delivered\",\"superseded\"];const accept=[\"pending\",\"accepted\",\"changes_requested\",\"not_applicable\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),cid=u.searchParams.get(\"id\")||\"\";if(!cid)return new Response(\"Missing creative project id\",{status:400});const c:any=(await sqlite.execute({sql:`SELECT * FROM creative_projects WHERE id=?`,args:[cid]})).rows[0];if(!c)return new Response(\"Creative project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const reqs=[\"production_id\",\"asset_name\",\"asset_type\",\"version\",\"asset_reference\",\"status\",\"delivered_to\",\"delivery_channel\",\"delivery_at\",\"acceptance_status\",\"notes\"],missing=reqs.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete asset record\",missing},{status:400});if(!statuses.includes(b.status)||!accept.includes(b.acceptance_status))return Response.json({error:\"Invalid asset status or acceptance status\"},{status:400});if(b.status===\"client_approved\"&&!['accepted'].includes(b.acceptance_status))return Response.json({error:\"Client-approved assets require acceptance=accepted\"},{status:400});const now=new Date().toISOString(),id=`AST-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO creative_assets VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,cid,...reqs.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,assetId:id},{headers:J})}\nconst rows:any[]=(await sqlite.execute({sql:`SELECT * FROM creative_assets WHERE creative_id=? ORDER BY created_at DESC`,args:[cid]})).rows;return new Response(`5MC Creative Assets

← Creative project

5MC / ASSET & DELIVERABLE REGISTRY

${esc(c.id)}

Every asset gets an identity, version, status and delivery trail.

Register asset

Asset history (${rows.length})

${rows.length?rows.map(r=>`

${esc(r.asset_name)} · ${esc(r.version)} ${esc(r.status)} / ${esc(r.acceptance_status)}

${esc(r.asset_type)} · ${esc(r.asset_reference)}

Delivered to ${esc(r.delivered_to)} via ${esc(r.delivery_channel)}

${esc(r.created_at)} · ${esc(r.id)}

`).join(''):'

No assets registered.

`,{headers:H})}",[390],"a7ea69e5-46a0-40a4-96ce-09eda8f1c70a","client-review.ts","30262774-a53e-11f1-bd4e-1607ee4eb77e",34,["D",1788182193944],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\",\"access-control-allow-origin\":\"*\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\"\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS client_reviews (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, deliverable TEXT NOT NULL, version TEXT NOT NULL, evidence TEXT NOT NULL, decision TEXT NOT NULL, client_name TEXT NOT NULL, client_notes TEXT NOT NULL, reviewed_at TEXT NOT NULL)`)}\nconst decisions=[\"pending\",\"approved\",\"changes_requested\",\"rejected\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),id=u.searchParams.get(\"id\")||\"\";if(!id)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[id]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const missing=[\"deliverable\",\"version\",\"evidence\",\"decision\",\"client_name\",\"client_notes\"].filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete review fields\",missing},{status:400});if(!decisions.includes(b.decision))return Response.json({error:\"Invalid decision\"},{status:400});const now=new Date().toISOString(),rid=`REV-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO client_reviews VALUES (?,?,?,?,?,?,?,?,?)`,args:[rid,id,...[\"deliverable\",\"version\",\"evidence\",\"decision\",\"client_name\",\"client_notes\"].map(k=>String(b[k]).trim()),now]});const next=b.decision===\"approved\"?\"completed\":b.decision===\"changes_requested\"?\"in_progress\":\"client_review\";await sqlite.execute({sql:`UPDATE service_tickets SET status=? WHERE id=? AND status='client_review'`,args:[next,id]});return Response.json({ok:true,reviewId:rid,status:next},{headers:J})}const reviews:any[]=(await sqlite.execute({sql:`SELECT * FROM client_reviews WHERE project_id=? ORDER BY reviewed_at DESC`,args:[id]})).rows;return new Response(`5MC Client Review

← Operations

${esc(p.id)}

${esc(p.organization)}

${esc(p.service)} · ${esc(p.objective)}

Client acceptance review

Record the exact deliverable reviewed, version, supporting evidence and the client's decision. Approval confirms acceptance of the agreed deliverable; it does not certify an unmeasured business outcome.

Review history

${reviews.length?reviews.map(r=>`

${esc(r.deliverable)} · ${esc(r.version)} · ${esc(r.decision)}

${esc(r.client_notes)}

${esc(r.client_name)} · ${esc(r.reviewed_at)}

`).join(''):'

No client review recorded yet.

`,{headers:H})}",[397],"e67585d2-716e-4c63-9728-c4000b478ec3",["D",1788207837012],[27],"bc387f62-d480-4400-8e7e-8127e27868b1","audit-findings.ts","c8b4aed6-a541-11f1-a157-1607ee4eb77e",45,["D",1788185147793],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_findings (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, finding TEXT NOT NULL, evidence_ids TEXT NOT NULL, finding_status TEXT NOT NULL, confidence TEXT NOT NULL, recommendation TEXT NOT NULL, action TEXT NOT NULL, evidence_required TEXT NOT NULL, owner TEXT NOT NULL, created_at TEXT NOT NULL, updated_at TEXT NOT NULL)`)}\nconst states=[\"verified\",\"partially_verified\",\"unsupported\",\"unknown\",\"conflicting_evidence\"],conf=[\"high\",\"medium\",\"low\",\"not_assessed\"];\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});\nif(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const reqs=[\"finding\",\"evidence_ids\",\"finding_status\",\"confidence\",\"recommendation\",\"action\",\"evidence_required\",\"owner\"],missing=reqs.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete every finding field\",missing},{status:400});if(!states.includes(b.finding_status)||!conf.includes(b.confidence))return Response.json({error:\"Invalid finding state or confidence\"},{status:400});const now=new Date().toISOString(),fid=`FND-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO audit_findings VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[fid,pid,...reqs.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,findingId:fid},{headers:J})}\nconst rows:any[]=(await sqlite.execute({sql:`SELECT * FROM audit_findings WHERE project_id=? ORDER BY created_at DESC`,args:[pid]})).rows;return new Response(`5MC Audit Findings

← Audit · Finding → Action Mapping →

5MC / FINDINGS & RECOMMENDATIONS

${esc(p.organization)}

${esc(p.id)} · ${esc(p.service)}

Traceability rule: every recommendation must point to evidence or explicitly state what evidence is still required. Unsupported findings cannot be presented as facts.

Record finding

Finding history (${rows.length})

Open finding → action mapping

${rows.length?rows.map(r=>`

${esc(r.finding)} ${esc(r.finding_status)} · ${esc(r.confidence)}

Evidence: ${esc(r.evidence_ids)}

Recommendation: ${esc(r.recommendation)}

Action: ${esc(r.action)}

Evidence required: ${esc(r.evidence_required)}

${esc(r.owner)} · ${esc(r.created_at)}

`).join(''):'

No findings recorded yet.

`,{headers:H})}",[407],"4b92c0f4-b438-4b17-bec0-8d43402f6a5e","audit-engine.ts","860217ae-a541-11f1-b80d-1607ee4eb77e",41,["D",1788183743309],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};const J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst esc=(v:any)=>String(v??\"\").replace(/[&<>\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_reports (id TEXT PRIMARY KEY, project_id TEXT NOT NULL, methodology TEXT NOT NULL, generated_by TEXT NOT NULL, created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();const u=new URL(req.url),pid=u.searchParams.get(\"id\")||\"\";if(!pid)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[pid]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});\nconst evidenceTable=await sqlite.execute(`SELECT name FROM sqlite_master WHERE type='table' AND name='evidence_ledger'`);const hasEvidence=(evidenceTable.rows as any[]).length>0;const ev:any[]=hasEvidence?(await sqlite.execute({sql:`SELECT * FROM evidence_ledger WHERE project_id=? ORDER BY created_at DESC`,args:[pid]})).rows:[];\nconst verified=ev.filter(e=>e.verification_status===\"verified\"),partial=ev.filter(e=>e.verification_status===\"partially_verified\"),unknown=ev.filter(e=>[\"unknown\",\"unverified\"].includes(e.verification_status));\nif(req.method===\"POST\"){const now=new Date().toISOString(),aid=`AUD-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO audit_reports VALUES (?,?,?,?,?)`,args:[aid,pid,\"Evidence-led review: only ledgered evidence is considered; missing measurements remain unknown; no synthetic score is produced.\",\"5MC Intelligence & Audit Engine\",now]});return Response.json({ok:true,auditId:aid,counts:{verified:verified.length,partiallyVerified:partial.length,unknown:unknown.length}},{headers:J})}\nreturn new Response(`5MC Intelligence & Audit

← Operations

5MC INTELLIGENCE & AUDIT ENGINE

${esc(p.organization)}

${esc(p.id)} · ${esc(p.service)}

VERIFIED

${verified.length}

PARTIALLY VERIFIED

${partial.length}

UNKNOWN / UNVERIFIED

${unknown.length}

Audit methodology

This audit reads only evidence recorded in the Evidence Ledger. It does not infer a scan that did not occur, invent competitors, estimate revenue loss without measurement, or create a score from missing data.

Findings → Recommendations

Evidence used

${ev.length?ev.map(e=>`

${esc(e.claim||e.description||\"Evidence item\")} ${esc(e.verification_status||\"unknown\")}

${esc(e.source||e.reference||\"No source recorded\")}

`).join(''):'

No Evidence Ledger records exist for this project. The audit therefore has no verified findings to report.

Audit conclusion

${ev.length?`The engine found ${verified.length} verified, ${partial.length} partially verified, and ${unknown.length} unknown/unverified evidence item(s). Recommendations must be tied to those findings; unsupported conclusions remain explicitly unverified.`:'No measurable evidence is currently available. The correct conclusion is unknown / insufficient evidence, not a fabricated performance score.'}

`,{headers:H})}",[414],"pulls","branches","forks","envVars",{"_427":61,"_429":61},"connections",{"_427":61,"_428":61},"count","unfilledCount","emptyCount",{"_41":413,"_31":414,"_29":415,"_168":-5,"_39":40,"_38":416,"_170":57,"_36":572,"_13":252,"_32":33,"_34":418,"_23":24,"_173":-5,"_467":573,"_26":574},{"_41":406,"_31":407,"_29":408,"_168":-5,"_39":40,"_38":409,"_170":57,"_36":569,"_13":215,"_32":33,"_34":411,"_23":24,"_173":-5,"_467":570,"_26":571},{"_41":403,"_31":27,"_29":30,"_168":-5,"_39":40,"_38":14,"_170":57,"_36":566,"_13":61,"_32":33,"_34":35,"_23":24,"_173":-5,"_467":567,"_26":568},{"_41":396,"_31":397,"_29":398,"_168":-5,"_39":40,"_38":399,"_170":57,"_36":563,"_13":61,"_32":33,"_34":401,"_23":24,"_173":-5,"_467":564,"_26":565},{"_41":389,"_31":390,"_29":391,"_168":-5,"_39":40,"_38":392,"_170":57,"_36":560,"_13":61,"_32":33,"_34":394,"_23":24,"_173":-5,"_467":561,"_26":562},{"_41":382,"_31":383,"_29":384,"_168":-5,"_39":40,"_38":385,"_170":57,"_36":557,"_13":61,"_32":33,"_34":387,"_23":24,"_173":-5,"_467":558,"_26":559},{"_41":374,"_31":375,"_29":376,"_168":-5,"_39":40,"_38":377,"_170":57,"_36":554,"_13":379,"_32":33,"_34":380,"_23":24,"_173":-5,"_467":555,"_26":556},{"_41":367,"_31":368,"_29":369,"_168":-5,"_39":40,"_38":370,"_170":57,"_36":551,"_13":61,"_32":33,"_34":372,"_23":24,"_173":-5,"_467":552,"_26":553},{"_41":360,"_31":361,"_29":362,"_168":-5,"_39":40,"_38":363,"_170":57,"_36":548,"_13":215,"_32":33,"_34":365,"_23":24,"_173":-5,"_467":549,"_26":550},{"_41":353,"_31":354,"_29":355,"_168":-5,"_39":40,"_38":356,"_170":57,"_36":545,"_13":61,"_32":33,"_34":358,"_23":24,"_173":-5,"_467":546,"_26":547},{"_41":346,"_31":347,"_29":348,"_168":-5,"_39":40,"_38":349,"_170":57,"_36":542,"_13":61,"_32":33,"_34":351,"_23":24,"_173":-5,"_467":543,"_26":544},{"_41":339,"_31":340,"_29":341,"_168":-5,"_39":40,"_38":342,"_170":57,"_36":539,"_13":61,"_32":33,"_34":344,"_23":24,"_173":-5,"_467":540,"_26":541},{"_41":332,"_31":333,"_29":334,"_168":-5,"_39":40,"_38":335,"_170":57,"_36":536,"_13":252,"_32":33,"_34":337,"_23":24,"_173":-5,"_467":537,"_26":538},{"_41":325,"_31":326,"_29":327,"_168":-5,"_39":40,"_38":328,"_170":57,"_36":533,"_13":252,"_32":33,"_34":330,"_23":24,"_173":-5,"_467":534,"_26":535},{"_41":318,"_31":319,"_29":320,"_168":-5,"_39":40,"_38":321,"_170":57,"_36":530,"_13":61,"_32":33,"_34":323,"_23":24,"_173":-5,"_467":531,"_26":532},{"_41":311,"_31":312,"_29":313,"_168":-5,"_39":40,"_38":314,"_170":57,"_36":527,"_13":61,"_32":33,"_34":316,"_23":24,"_173":-5,"_467":528,"_26":529},{"_41":304,"_31":305,"_29":306,"_168":-5,"_39":40,"_38":307,"_170":57,"_36":524,"_13":61,"_32":33,"_34":309,"_23":24,"_173":-5,"_467":525,"_26":526},{"_41":298,"_31":299,"_29":300,"_168":-5,"_39":40,"_38":274,"_170":57,"_36":521,"_13":61,"_32":237,"_34":302,"_23":24,"_173":-5,"_467":522,"_26":523},{"_41":291,"_31":292,"_29":293,"_168":-5,"_39":40,"_38":294,"_170":57,"_36":518,"_13":61,"_32":33,"_34":296,"_23":24,"_173":-5,"_467":519,"_26":520},{"_41":284,"_31":285,"_29":286,"_168":-5,"_39":40,"_38":287,"_170":57,"_36":515,"_13":252,"_32":33,"_34":289,"_23":24,"_173":-5,"_467":516,"_26":517},{"_41":277,"_31":278,"_29":279,"_168":-5,"_39":40,"_38":280,"_170":57,"_36":512,"_13":61,"_32":33,"_34":282,"_23":24,"_173":-5,"_467":513,"_26":514},{"_41":269,"_31":270,"_29":271,"_168":-5,"_39":40,"_38":272,"_170":57,"_36":509,"_13":274,"_32":33,"_34":275,"_23":24,"_173":-5,"_467":510,"_26":511},{"_41":262,"_31":263,"_29":264,"_168":-5,"_39":40,"_38":265,"_170":57,"_36":506,"_13":61,"_32":33,"_34":267,"_23":24,"_173":-5,"_467":507,"_26":508},{"_41":255,"_31":256,"_29":257,"_168":-5,"_39":40,"_38":258,"_170":57,"_36":503,"_13":61,"_32":33,"_34":260,"_23":24,"_173":-5,"_467":504,"_26":505},{"_41":247,"_31":248,"_29":249,"_168":-5,"_39":40,"_38":250,"_170":57,"_36":500,"_13":252,"_32":33,"_34":253,"_23":24,"_173":-5,"_467":501,"_26":502},{"_41":240,"_31":241,"_29":242,"_168":-5,"_39":40,"_38":243,"_170":57,"_36":497,"_13":61,"_32":33,"_34":245,"_23":24,"_173":-5,"_467":498,"_26":499},{"_41":232,"_31":233,"_29":234,"_168":-5,"_39":40,"_38":235,"_170":57,"_36":494,"_13":61,"_32":237,"_34":238,"_23":24,"_173":-5,"_467":495,"_26":496},{"_41":225,"_31":226,"_29":227,"_168":-5,"_39":40,"_38":228,"_170":57,"_36":491,"_13":61,"_32":33,"_34":230,"_23":24,"_173":-5,"_467":492,"_26":493},{"_41":218,"_31":219,"_29":55,"_168":-5,"_39":40,"_38":220,"_170":57,"_36":488,"_13":222,"_32":33,"_34":223,"_23":24,"_173":-5,"_467":489,"_26":490},{"_41":210,"_31":211,"_29":212,"_168":-5,"_39":40,"_38":213,"_170":57,"_36":485,"_13":215,"_32":33,"_34":216,"_23":24,"_173":-5,"_467":486,"_26":487},{"_41":203,"_31":204,"_29":205,"_168":-5,"_39":40,"_38":206,"_170":57,"_36":482,"_13":61,"_32":33,"_34":208,"_23":24,"_173":-5,"_467":483,"_26":484},{"_41":196,"_31":197,"_29":198,"_168":-5,"_39":40,"_38":199,"_170":57,"_36":479,"_13":61,"_32":33,"_34":201,"_23":24,"_173":-5,"_467":480,"_26":481},{"_41":189,"_31":190,"_29":191,"_168":-5,"_39":40,"_38":192,"_170":57,"_36":476,"_13":61,"_32":33,"_34":194,"_23":24,"_173":-5,"_467":477,"_26":478},{"_41":182,"_31":183,"_29":184,"_168":-5,"_39":40,"_38":185,"_170":57,"_36":473,"_13":61,"_32":33,"_34":187,"_23":24,"_173":-5,"_467":474,"_26":475},{"_41":175,"_31":176,"_29":177,"_168":-5,"_39":40,"_38":178,"_170":57,"_36":470,"_13":61,"_32":33,"_34":180,"_23":24,"_173":-5,"_467":471,"_26":472},{"_41":165,"_31":166,"_29":167,"_168":-5,"_39":40,"_38":169,"_170":57,"_36":466,"_13":61,"_32":33,"_34":172,"_23":24,"_173":-5,"_467":468,"_26":469},["D",1788173376809],"children",[],[166],["D",1788191802062],[],[176],["D",1788192451484],[],[183],["D",1788192042121],[],[190],["D",1788191922444],[],[197],["D",1788191397129],[],[204],["D",1788172181339],[],[211],["D",1788188420035],[],[219],["D",1788207700861],[],[226],["D",1788117801473],[],[233],["D",1788117809701],[],[241],["D",1788185140285],[],[248],["D",1788181203217],[],[256],["D",1788181573072],[],[263],["D",1788017292644],[],[270],["D",1788183347539],[],[278],["D",1788192668672],[],[285],["D",1788192880894],[],[292],["D",1788017239401],[],[299],["D",1788189772603],[],[305],["D",1788190064936],[],[312],["D",1788188803531],[],[319],["D",1788188570876],[],[326],["D",1788188577370],[],[333],["D",1788190441631],[],[340],["D",1788173044830],[],[347],["D",1788186029969],[],[354],["D",1788185815676],[],[361],["D",1788186263016],[],[368],["D",1788186269112],[],[375],["D",1788185811961],[],[383],["D",1788186159465],[],[390],["D",1788182193944],[],[397],["D",1788207837012],[],[27],["D",1788185147793],[],[407],["D",1788183743309],[],[414],["D",1788016624119],["D",1789492855745],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":53,"_103":104,"_105":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_126":613,"_614":615,"_616":617,"_618":24,"_619":24,"_620":24,"_621":57,"_622":-5,"_623":-7,"_624":-7,"_625":61,"_626":24,"_627":24,"_628":-5,"_629":24,"_630":24,"_631":24,"_632":-5},"ENV",{"_584":585,"_586":587,"_588":88,"_589":590,"_591":592,"_593":594,"_595":596,"_597":598,"_599":600,"_601":602,"_603":604,"_605":606,"_607":608,"_609":610,"_611":612},"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 · v80