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})}","label",[18],"pulls","branches",1,"forks","envVars",{"_163":26,"_165":26},"connections",{"_163":26,"_164":26},"count","unfilledCount","emptyCount",{"_32":722,"_13":634,"_63":628,"_42":-5,"_34":35,"_148":678,"_149":85,"_36":723,"_38":26,"_65":608,"_151":-5,"_67":24,"_153":-5,"_235":724,"_17":725},{"_32":714,"_13":715,"_63":716,"_42":628,"_34":35,"_148":717,"_149":85,"_36":718,"_38":26,"_65":66,"_151":719,"_67":24,"_153":-5,"_235":720,"_17":721},{"_32":706,"_13":707,"_63":708,"_42":628,"_34":35,"_148":709,"_149":85,"_36":710,"_38":26,"_65":66,"_151":711,"_67":24,"_153":-5,"_235":712,"_17":713},{"_32":698,"_13":699,"_63":700,"_42":628,"_34":35,"_148":701,"_149":85,"_36":702,"_38":26,"_65":66,"_151":703,"_67":24,"_153":-5,"_235":704,"_17":705},{"_32":691,"_13":692,"_63":693,"_42":628,"_34":35,"_148":111,"_149":85,"_36":694,"_38":26,"_65":66,"_151":695,"_67":24,"_153":-5,"_235":696,"_17":697},{"_32":683,"_13":684,"_63":685,"_42":628,"_34":35,"_148":686,"_149":85,"_36":687,"_38":26,"_65":21,"_151":688,"_67":24,"_153":-5,"_235":689,"_17":690},{"_32":675,"_13":676,"_63":677,"_42":628,"_34":35,"_148":678,"_149":85,"_36":679,"_38":26,"_65":21,"_151":680,"_67":24,"_153":-5,"_235":681,"_17":682},{"_32":667,"_13":668,"_63":669,"_42":628,"_34":35,"_148":670,"_149":85,"_36":671,"_38":26,"_65":66,"_151":672,"_67":24,"_153":-5,"_235":673,"_17":674},{"_32":659,"_13":660,"_63":661,"_42":628,"_34":35,"_148":662,"_149":85,"_36":663,"_38":26,"_65":66,"_151":664,"_67":24,"_153":-5,"_235":665,"_17":666},{"_32":651,"_13":652,"_63":653,"_42":628,"_34":35,"_148":654,"_149":85,"_36":655,"_38":26,"_65":66,"_151":656,"_67":24,"_153":-5,"_235":657,"_17":658},{"_32":643,"_13":644,"_63":645,"_42":628,"_34":35,"_148":646,"_149":85,"_36":647,"_38":26,"_65":66,"_151":648,"_67":24,"_153":-5,"_235":649,"_17":650},{"_32":635,"_13":636,"_63":637,"_42":628,"_34":35,"_148":638,"_149":85,"_36":639,"_38":26,"_65":66,"_151":640,"_67":24,"_153":-5,"_235":641,"_17":642},{"_32":625,"_13":626,"_63":627,"_42":628,"_34":35,"_148":629,"_149":85,"_36":630,"_38":283,"_65":66,"_151":631,"_67":24,"_153":-5,"_235":632,"_17":633},{"_32":621,"_13":620,"_63":614,"_42":-5,"_34":35,"_148":615,"_149":85,"_36":622,"_38":26,"_65":608,"_151":-5,"_67":24,"_153":-5,"_235":623,"_17":624},{"_32":611,"_13":612,"_63":613,"_42":614,"_34":35,"_148":615,"_149":85,"_36":616,"_38":26,"_65":21,"_151":617,"_67":24,"_153":-5,"_235":618,"_17":619},{"_32":606,"_13":549,"_63":543,"_42":-5,"_34":35,"_148":577,"_149":85,"_36":607,"_38":26,"_65":608,"_151":-5,"_67":24,"_153":-5,"_235":609,"_17":610},{"_32":598,"_13":599,"_63":600,"_42":543,"_34":35,"_148":601,"_149":85,"_36":602,"_38":26,"_65":66,"_151":603,"_67":24,"_153":-5,"_235":604,"_17":605},{"_32":590,"_13":591,"_63":592,"_42":543,"_34":35,"_148":593,"_149":85,"_36":594,"_38":26,"_65":66,"_151":595,"_67":24,"_153":-5,"_235":596,"_17":597},{"_32":582,"_13":583,"_63":584,"_42":543,"_34":35,"_148":585,"_149":85,"_36":586,"_38":26,"_65":66,"_151":587,"_67":24,"_153":-5,"_235":588,"_17":589},{"_32":574,"_13":575,"_63":576,"_42":543,"_34":35,"_148":577,"_149":85,"_36":578,"_38":26,"_65":21,"_151":579,"_67":24,"_153":-5,"_235":580,"_17":581},{"_32":566,"_13":567,"_63":568,"_42":543,"_34":35,"_148":569,"_149":85,"_36":570,"_38":26,"_65":66,"_151":571,"_67":24,"_153":-5,"_235":572,"_17":573},{"_32":558,"_13":559,"_63":560,"_42":543,"_34":35,"_148":561,"_149":85,"_36":562,"_38":26,"_65":66,"_151":563,"_67":24,"_153":-5,"_235":564,"_17":565},{"_32":550,"_13":551,"_63":552,"_42":543,"_34":35,"_148":553,"_149":85,"_36":554,"_38":26,"_65":66,"_151":555,"_67":24,"_153":-5,"_235":556,"_17":557},{"_32":540,"_13":541,"_63":542,"_42":543,"_34":35,"_148":544,"_149":85,"_36":545,"_38":26,"_65":66,"_151":546,"_67":24,"_153":-5,"_235":547,"_17":548},{"_32":532,"_13":533,"_63":534,"_42":-5,"_34":35,"_148":535,"_149":85,"_36":536,"_38":157,"_65":66,"_151":537,"_67":24,"_153":-5,"_235":538,"_17":539},{"_32":524,"_13":525,"_63":526,"_42":-5,"_34":35,"_148":527,"_149":85,"_36":528,"_38":283,"_65":66,"_151":529,"_67":24,"_153":-5,"_235":530,"_17":531},{"_32":516,"_13":517,"_63":518,"_42":-5,"_34":35,"_148":519,"_149":85,"_36":520,"_38":26,"_65":66,"_151":521,"_67":24,"_153":-5,"_235":522,"_17":523},{"_32":508,"_13":509,"_63":510,"_42":-5,"_34":35,"_148":511,"_149":85,"_36":512,"_38":26,"_65":66,"_151":513,"_67":24,"_153":-5,"_235":514,"_17":515},{"_32":500,"_13":501,"_63":502,"_42":-5,"_34":35,"_148":503,"_149":85,"_36":504,"_38":26,"_65":66,"_151":505,"_67":24,"_153":-5,"_235":506,"_17":507},{"_32":492,"_13":493,"_63":494,"_42":-5,"_34":35,"_148":495,"_149":85,"_36":496,"_38":26,"_65":66,"_151":497,"_67":24,"_153":-5,"_235":498,"_17":499},{"_32":484,"_13":485,"_63":486,"_42":-5,"_34":35,"_148":487,"_149":85,"_36":488,"_38":26,"_65":66,"_151":489,"_67":24,"_153":-5,"_235":490,"_17":491},{"_32":476,"_13":477,"_63":478,"_42":-5,"_34":35,"_148":479,"_149":85,"_36":480,"_38":26,"_65":66,"_151":481,"_67":24,"_153":-5,"_235":482,"_17":483},{"_32":147,"_13":18,"_63":64,"_42":-5,"_34":35,"_148":39,"_149":85,"_36":473,"_38":26,"_65":66,"_151":152,"_67":24,"_153":-5,"_235":474,"_17":475},{"_32":464,"_13":465,"_63":466,"_42":-5,"_34":35,"_148":467,"_149":85,"_36":468,"_38":469,"_65":66,"_151":470,"_67":24,"_153":-5,"_235":471,"_17":472},{"_32":456,"_13":457,"_63":458,"_42":-5,"_34":35,"_148":459,"_149":85,"_36":460,"_38":26,"_65":66,"_151":461,"_67":24,"_153":-5,"_235":462,"_17":463},{"_32":448,"_13":449,"_63":450,"_42":-5,"_34":35,"_148":451,"_149":85,"_36":452,"_38":283,"_65":66,"_151":453,"_67":24,"_153":-5,"_235":454,"_17":455},{"_32":440,"_13":441,"_63":442,"_42":-5,"_34":35,"_148":443,"_149":85,"_36":444,"_38":26,"_65":66,"_151":445,"_67":24,"_153":-5,"_235":446,"_17":447},{"_32":432,"_13":433,"_63":434,"_42":-5,"_34":35,"_148":435,"_149":85,"_36":436,"_38":26,"_65":66,"_151":437,"_67":24,"_153":-5,"_235":438,"_17":439},{"_32":424,"_13":425,"_63":426,"_42":-5,"_34":35,"_148":427,"_149":85,"_36":428,"_38":26,"_65":66,"_151":429,"_67":24,"_153":-5,"_235":430,"_17":431},{"_32":416,"_13":417,"_63":418,"_42":-5,"_34":35,"_148":419,"_149":85,"_36":420,"_38":157,"_65":66,"_151":421,"_67":24,"_153":-5,"_235":422,"_17":423},{"_32":408,"_13":409,"_63":410,"_42":-5,"_34":35,"_148":411,"_149":85,"_36":412,"_38":157,"_65":66,"_151":413,"_67":24,"_153":-5,"_235":414,"_17":415},{"_32":400,"_13":401,"_63":402,"_42":-5,"_34":35,"_148":403,"_149":85,"_36":404,"_38":26,"_65":66,"_151":405,"_67":24,"_153":-5,"_235":406,"_17":407},{"_32":392,"_13":393,"_63":394,"_42":-5,"_34":35,"_148":395,"_149":85,"_36":396,"_38":26,"_65":66,"_151":397,"_67":24,"_153":-5,"_235":398,"_17":399},{"_32":384,"_13":385,"_63":386,"_42":-5,"_34":35,"_148":387,"_149":85,"_36":388,"_38":26,"_65":66,"_151":389,"_67":24,"_153":-5,"_235":390,"_17":391},{"_32":377,"_13":378,"_63":379,"_42":-5,"_34":35,"_148":349,"_149":85,"_36":380,"_38":26,"_65":308,"_151":381,"_67":24,"_153":-5,"_235":382,"_17":383},{"_32":369,"_13":370,"_63":371,"_42":-5,"_34":35,"_148":372,"_149":85,"_36":373,"_38":26,"_65":66,"_151":374,"_67":24,"_153":-5,"_235":375,"_17":376},{"_32":361,"_13":362,"_63":363,"_42":-5,"_34":35,"_148":364,"_149":85,"_36":365,"_38":157,"_65":66,"_151":366,"_67":24,"_153":-5,"_235":367,"_17":368},{"_32":353,"_13":354,"_63":355,"_42":-5,"_34":35,"_148":356,"_149":85,"_36":357,"_38":26,"_65":66,"_151":358,"_67":24,"_153":-5,"_235":359,"_17":360},{"_32":344,"_13":345,"_63":346,"_42":-5,"_34":35,"_148":347,"_149":85,"_36":348,"_38":349,"_65":66,"_151":350,"_67":24,"_153":-5,"_235":351,"_17":352},{"_32":336,"_13":337,"_63":338,"_42":-5,"_34":35,"_148":339,"_149":85,"_36":340,"_38":26,"_65":66,"_151":341,"_67":24,"_153":-5,"_235":342,"_17":343},{"_32":328,"_13":329,"_63":330,"_42":-5,"_34":35,"_148":331,"_149":85,"_36":332,"_38":26,"_65":66,"_151":333,"_67":24,"_153":-5,"_235":334,"_17":335},{"_32":320,"_13":321,"_63":322,"_42":-5,"_34":35,"_148":323,"_149":85,"_36":324,"_38":157,"_65":66,"_151":325,"_67":24,"_153":-5,"_235":326,"_17":327},{"_32":312,"_13":313,"_63":314,"_42":-5,"_34":35,"_148":315,"_149":85,"_36":316,"_38":26,"_65":66,"_151":317,"_67":24,"_153":-5,"_235":318,"_17":319},{"_32":303,"_13":304,"_63":305,"_42":-5,"_34":35,"_148":306,"_149":85,"_36":307,"_38":26,"_65":308,"_151":309,"_67":24,"_153":-5,"_235":310,"_17":311},{"_32":295,"_13":296,"_63":297,"_42":-5,"_34":35,"_148":298,"_149":85,"_36":299,"_38":26,"_65":66,"_151":300,"_67":24,"_153":-5,"_235":301,"_17":302},{"_32":287,"_13":288,"_63":83,"_42":-5,"_34":35,"_148":289,"_149":85,"_36":290,"_38":291,"_65":66,"_151":292,"_67":24,"_153":-5,"_235":293,"_17":294},{"_32":278,"_13":279,"_63":280,"_42":-5,"_34":35,"_148":281,"_149":85,"_36":282,"_38":283,"_65":66,"_151":284,"_67":24,"_153":-5,"_235":285,"_17":286},{"_32":270,"_13":271,"_63":272,"_42":-5,"_34":35,"_148":273,"_149":85,"_36":274,"_38":26,"_65":66,"_151":275,"_67":24,"_153":-5,"_235":276,"_17":277},{"_32":262,"_13":263,"_63":264,"_42":-5,"_34":35,"_148":265,"_149":85,"_36":266,"_38":26,"_65":66,"_151":267,"_67":24,"_153":-5,"_235":268,"_17":269},{"_32":254,"_13":255,"_63":256,"_42":-5,"_34":35,"_148":257,"_149":85,"_36":258,"_38":26,"_65":66,"_151":259,"_67":24,"_153":-5,"_235":260,"_17":261},{"_32":246,"_13":247,"_63":248,"_42":-5,"_34":35,"_148":249,"_149":85,"_36":250,"_38":26,"_65":66,"_151":251,"_67":24,"_153":-5,"_235":252,"_17":253},{"_32":238,"_13":239,"_63":240,"_42":-5,"_34":35,"_148":241,"_149":85,"_36":242,"_38":26,"_65":66,"_151":243,"_67":24,"_153":-5,"_235":244,"_17":245},{"_32":229,"_13":230,"_63":231,"_42":-5,"_34":35,"_148":232,"_149":85,"_36":233,"_38":26,"_65":66,"_151":234,"_67":24,"_153":-5,"_235":236,"_17":237},"35b27e24-0baa-4f42-95d8-f9b951d952d3","scope-review.ts","a8ba380c-a529-11f1-b053-1607ee4eb77e",28,["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

← Operations

${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})}","children",[],[230],"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})}",[],[239],"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})}",[],[247],"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})}",[],[255],"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})}",[],[263],"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})}",[],[271],"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)}",[],[279],"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}",[],[288],"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})}",[],[296],"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",[],[304],"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",[],[313],"24eef7a6-63e2-492e-8046-00f5099970ef","finding-actions.ts","ee89546c-a542-11f1-9edd-1607ee4eb77e",44,["D",1788185140285],"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})}",[],[321],"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})}",[],[329],"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})}",[],[337],"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",[],[345],"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})}",[],[354],"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})}",[],[362],"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})}",[],[370],"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",[],[378],"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})}",[],[385],"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})}",[],[393],"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})}",[],[401],"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})}",[],[409],"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})}",[],[417],"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})}",[],[425],"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})}",[],[433],"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})}",[],[441],"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})}",[],[449],"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})}",[],[457],"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})}",[],[465],["D",1788185811961],[],[18],"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})}",[],[477],"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})}",[],[485],"d7aca62e-291b-47a0-84d6-eb425ab99508","client-project-workspace.ts","42bb5ccc-a586-11f1-bedb-1607ee4eb77e",87,["D",1788213148833],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst stages=[\"intake\",\"active\",\"awaiting_client\",\"blocked\",\"completed\",\"closed\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS project_workspace_events (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,event_type TEXT NOT NULL,title TEXT NOT NULL,details TEXT NOT NULL,visibility TEXT NOT NULL,evidence_ref TEXT NOT NULL,created_by TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\"){const rows:any[]=(await sqlite.execute(`SELECT * FROM project_workspace_events ORDER BY created_at DESC`)).rows;return Response.json({stages,workspaceSections:[\"current stage\",\"next action\",\"client action\",\"approvals\",\"deliverables\",\"evidence\",\"timeline\"],events:rows},{headers:J})}let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"project_ref\",\"event_type\",\"title\",\"details\",\"visibility\",\"evidence_ref\",\"created_by\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Workspace event blocked\",missing},{status:409});if(![\"client\",\"internal\"].includes(String(b.visibility)))return Response.json({error:\"Invalid visibility\",allowed:[\"client\",\"internal\"]},{status:400});const id=`PWE-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_workspace_events VALUES (?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,eventId:id,next:\"project-workspace\"},{headers:J})}",[],[493],"e67585d2-716e-4c63-9728-c4000b478ec3","client-project-control.ts","e49bf59a-a579-11f1-a446-1607ee4eb77e",80,["D",1788207837012],"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})}",[],[501],"e28b0c0a-0015-4719-9b08-0131e140e2c5","client-project-brief.ts","f0384492-a580-11f1-b057-1607ee4eb77e",85,["D",1788210862929],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst services=[\"GROW\",\"CREATIVE\",\"DIGITAL\",\"PROMOTION\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS project_briefs (id TEXT PRIMARY KEY,intake_ref TEXT NOT NULL,client_ref TEXT NOT NULL,service_engine TEXT NOT NULL,business_context TEXT NOT NULL,problem_statement TEXT NOT NULL,objective TEXT NOT NULL,scope_in TEXT NOT NULL,scope_out TEXT NOT NULL,audience TEXT NOT NULL,deliverables TEXT NOT NULL,success_criteria TEXT NOT NULL,dependencies TEXT NOT NULL,risks TEXT NOT NULL,client_requirements TEXT NOT NULL,approval_status TEXT NOT NULL,approved_by TEXT NOT NULL,approval_at TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({serviceOptions:services,rule:\"A brief records what is known; unknowns remain explicit and approval is separate from creation.\"},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"intake_ref\",\"client_ref\",\"service_engine\",\"business_context\",\"problem_statement\",\"objective\",\"scope_in\",\"scope_out\",\"audience\",\"deliverables\",\"success_criteria\",\"dependencies\",\"risks\",\"client_requirements\",\"approval_status\",\"approved_by\",\"approval_at\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Project brief gate blocked\",missing},{status:409});if(!services.includes(String(b.service_engine).toUpperCase()))return Response.json({error:\"Invalid service engine\",allowed:services},{status:400});const id=`BRF-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_briefs VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,briefId:id,next:\"governed-project\",serviceEngine:String(b.service_engine).toUpperCase()},{headers:J})}",[],[509],"5e8ec478-57b0-42d5-bf2f-5a4d82cf5d20","client-intake.ts","c823c4fe-a580-11f1-8801-1607ee4eb77e",84,["D",1788210795725],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst services=[\"GROW\",\"CREATIVE\",\"DIGITAL\",\"PROMOTION\"];\nconst statuses=[\"new\",\"needs_clarification\",\"qualified\",\"converted\",\"declined\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS client_intake (id TEXT PRIMARY KEY,client_ref TEXT NOT NULL,contact_reference TEXT NOT NULL,business_context TEXT NOT NULL,problem TEXT NOT NULL,desired_outcome TEXT NOT NULL,service_interest TEXT NOT NULL,budget_context TEXT NOT NULL,timeline TEXT NOT NULL,qualification_notes TEXT NOT NULL,status TEXT NOT NULL,consent_reference TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\"){const rows:any[]=(await sqlite.execute(`SELECT * FROM client_intake ORDER BY created_at DESC`)).rows;return Response.json({serviceOptions:services,statuses,intakeCount:rows.length,intakes:rows},{headers:J})}let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"client_ref\",\"contact_reference\",\"business_context\",\"problem\",\"desired_outcome\",\"service_interest\",\"budget_context\",\"timeline\",\"qualification_notes\",\"status\",\"consent_reference\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete client intake\",missing},{status:409});const interests=String(b.service_interest).split(\",\").map((x:string)=>x.trim().toUpperCase()).filter(Boolean);if(interests.some((x:string)=>!services.includes(x)))return Response.json({error:\"Invalid service interest\",allowed:services},{status:400});if(!statuses.includes(b.status))return Response.json({error:\"Invalid intake status\",allowed:statuses},{status:400});const id=`INT-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO client_intake VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,intakeId:id,next:\"project-brief\",serviceOptions:services},{headers:J})}",[],[517],"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})}",[],[525],"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})}",[],[533],"2945a867-4b61-4b02-a383-8ede598704c2","project-stage-control.ts","bcf5150a-a586-11f1-9500-1607ee4eb77e","39e56b06-2f7a-4424-906a-aaaff376a6db",88,["D",1788213353927],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst flow=[\"intake\",\"active\",\"awaiting_client\",\"blocked\",\"completed\",\"closed\"];\nconst transitions:any={intake:[\"active\",\"blocked\"],active:[\"awaiting_client\",\"blocked\",\"completed\"],awaiting_client:[\"active\",\"blocked\"],blocked:[\"active\",\"closed\"],completed:[\"closed\"]};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS project_stage_events (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,from_stage TEXT NOT NULL,to_stage TEXT NOT NULL,reason TEXT NOT NULL,evidence_ref TEXT NOT NULL,approval_ref TEXT NOT NULL,created_by TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({constitutionVersion:\"1.0\",stages:flow,transitions,rule:\"Stage movement must be explicit, traceable and evidence-backed; invalid transitions are blocked.\"},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"project_ref\",\"from_stage\",\"to_stage\",\"reason\",\"evidence_ref\",\"approval_ref\",\"created_by\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Stage transition requires complete control record\",missing},{status:409});if(!flow.includes(b.from_stage)||!flow.includes(b.to_stage)||!(transitions[b.from_stage]||[]).includes(b.to_stage))return Response.json({ok:false,gate:\"blocked\",error:\"Invalid project stage transition\",allowedFrom:transitions[b.from_stage]||[]},{status:409});const id=`PST-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_stage_events VALUES (?,?,?,?,?,?,?,?,?)`,args:[id,b.project_ref,b.from_stage,b.to_stage,b.reason,b.evidence_ref,b.approval_ref,b.created_by,now]});return Response.json({ok:true,gate:\"verified\",eventId:id,projectRef:b.project_ref,currentStage:b.to_stage},{headers:J})}",[],[549,541],"governance","c93aa3b7-4428-4bfd-ac55-8ad2af3dab68","project-progression.ts","8416e58a-a57f-11f1-8c3f-1607ee4eb77e",83,["D",1788210252057],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst order=[\"GROW\",\"CREATIVE\",\"DIGITAL\",\"PROMOTION\"];\nconst handoff: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 project_progression (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,from_engine TEXT NOT NULL,to_engine TEXT NOT NULL,gate_ref TEXT NOT NULL,evidence_ref TEXT NOT NULL,approved_by TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({servicePath:order,handoffRequirements:handoff,rule:\"Engine progression requires the immediately preceding service, a gate reference, evidence reference and approval.\"},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const from=String(b.from_engine||\"\").toUpperCase(),to=String(b.to_engine||\"\").toUpperCase(),pair=`${from}->${to}`;if(!handoff[pair])return Response.json({error:\"Invalid progression: only sequential service handoffs are permitted\",allowed:Object.keys(handoff)},{status:409});const fields=[\"project_ref\",\"from_engine\",\"to_engine\",\"gate_ref\",\"evidence_ref\",\"approved_by\",\"status\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Progression blocked: complete governance record\",missing},{status:409});const id=`PPR-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_progression VALUES (?,?,?,?,?,?,?,?)`,args:[id,b.project_ref,from,to,b.gate_ref,b.evidence_ref,b.approved_by,b.status,now]});return Response.json({ok:true,progressionId:id,transition:pair,status:\"recorded\"},{headers:J})}",[],[549,551],"35d5f40e-a65f-4f4b-99c5-f109c452b1d0","project-governance.ts","572b78f6-a57f-11f1-98b3-1607ee4eb77e",82,["D",1788210176698],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst required={GROW:[\"objective\",\"scope\",\"success_criteria\",\"brief_ref\"],CREATIVE:[\"objective\",\"scope\",\"success_criteria\",\"brief_ref\"],DIGITAL:[\"objective\",\"scope\",\"success_criteria\",\"brief_ref\"],PROMOTION:[\"objective\",\"scope\",\"success_criteria\",\"brief_ref\"]};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS governed_projects (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,engine TEXT NOT NULL,constitution_version TEXT NOT NULL,objective TEXT NOT NULL,scope TEXT NOT NULL,success_criteria TEXT NOT NULL,brief_ref TEXT NOT NULL,evidence_ref TEXT NOT NULL,approval_ref TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({constitutionVersion:\"1.0\",governedEngines:Object.keys(required),rule:\"A project record must preserve objective, scope, success criteria and brief reference; evidence and approval references are explicit fields and may not be invented.\"},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"project_ref\",\"engine\",\"objective\",\"scope\",\"success_criteria\",\"brief_ref\",\"evidence_ref\",\"approval_ref\",\"status\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Constitutional project gate blocked\",missing},{status:409});if(!required[b.engine])return Response.json({error:\"Unsupported service engine\"},{status:400});const id=`GPR-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO governed_projects VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,b.project_ref,b.engine,\"1.0\",b.objective,b.scope,b.success_criteria,b.brief_ref,b.evidence_ref,b.approval_ref,b.status,now]});return Response.json({ok:true,governanceRecord:id,constitutionVersion:\"1.0\",status:\"recorded\"},{headers:J})}",[],[549,559],"23b63e54-aa31-4306-bc38-e26e9ec12da9","deliverable-evidence.ts","bf3a9a72-a588-11f1-9a9d-1607ee4eb77e",90,["D",1788214216731],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst types=[\"deliverable\",\"revision\",\"approval\",\"measurement\",\"result\"];\nconst statuses=[\"draft\",\"submitted\",\"approved\",\"rejected\",\"superseded\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS deliverable_evidence (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,engine TEXT NOT NULL,deliverable_type TEXT NOT NULL,title TEXT NOT NULL,description TEXT NOT NULL,artifact_ref TEXT NOT NULL,evidence_ref TEXT NOT NULL,acceptance_ref TEXT NOT NULL,status TEXT NOT NULL,created_by TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\"){const rows:any[]=(await sqlite.execute(`SELECT * FROM deliverable_evidence ORDER BY created_at DESC`)).rows;return Response.json({deliverableTypes:types,statuses,rule:\"A deliverable is not proof merely because it is marked complete; artifact, evidence and acceptance references must remain traceable.\",records:rows},{headers:J})}let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"project_ref\",\"engine\",\"deliverable_type\",\"title\",\"description\",\"artifact_ref\",\"evidence_ref\",\"acceptance_ref\",\"status\",\"created_by\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Deliverable evidence gate blocked\",missing},{status:409});if(!types.includes(b.deliverable_type)||!statuses.includes(b.status))return Response.json({error:\"Invalid deliverable type or status\",deliverableTypes:types,statuses},{status:400});const id=`DEL-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO deliverable_evidence VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,recordId:id,status:b.status,traceability:\"artifact→evidence→acceptance\"},{headers:J})}",[],[549,567],"514b1f00-0dce-463a-be31-17ac28ae7863","constitution.md","190d47d4-a57f-11f1-aaab-1607ee4eb77e",81,["D",1788210072452],"# 5MC PERFORMANCE 2.0 — CONSTITUTION\n\n**Version:** 1.0 — Foundational Draft \n**Status:** Governing specification \n**Scope:** Entire 5MC Performance ecosystem\n\n## Preamble\n5MC Performance exists to help businesses understand problems, make better decisions, build appropriate solutions, promote them responsibly, and improve through evidence. The ecosystem is governed by integrity before revenue and evidence before claims.\n\n## Article I — Identity and Scope\n5MC Performance is the company/master brand. Its customer-facing Business/Service architecture remains: **GROW, CREATIVE, DIGITAL, PROMOTION**. These services must not be conflated with ecosystem infrastructure such as Hunter, Oracle, governance, evidence, or future internal engines.\n\n## Article II — Foundational Principles\n1. Diagnose before recommending.\n2. Understand before selling.\n3. Build before charging.\n4. Prove before claiming.\n5. Client interests and truth take priority over artificial performance signals.\n6. Missing evidence must remain missing evidence; it must never be silently converted into a claim.\n\n## Article III — Truth, Evidence and Verification\n5MC shall not represent an action, measurement, audit, scan, result, client outcome, competitor finding, revenue loss, testimonial, credential, portfolio item, or performance claim as factual without sufficient evidence. The system must distinguish observed, verified, estimated, target, unavailable, and inconclusive information where applicable.\n\n## Article IV — Service Governance\nGROW, CREATIVE, DIGITAL and PROMOTION are the core customer-facing service engines. Each service may have its own workflows and standards, but none may override this Constitution.\n\n## Article V — Client and Project Governance\nEvery material engagement should have a traceable project identity, defined objective/scope, success criteria, owner, status, relevant approvals, evidence, and closeout state. Silent scope changes are prohibited.\n\n## Article VI — Handoffs\nEngine handoffs must preserve required upstream context and evidence. A downstream engine must not treat incomplete, unsupported, or unverified context as verified. Handoff gates may block progression.\n\n## Article VII — Automation and Hunter\nHunter is the automation department. The permanent internal Hunter operates for 5MC and may discover, qualify, research, route, and automate approved workflows. Customer-facing Hunter deployments (including Hunter X5 through X50 and future tiers) operate for clients under defined permissions and scope. Automation may execute authorized processes but may not fabricate facts, bypass governance, or silently take consequential actions outside its authority.\n\n## Article VIII — Oracle\nOracle is the ecosystem intelligence and user-journey layer, not merely a chatbot. Oracle may use authorized 5MC knowledge to understand intent, explain services, guide visitors, collect appropriate information, and route users. Broad knowledge access does not imply unrestricted action authority. Oracle must respect evidence, permissions, privacy, and service boundaries.\n\n## Article IX — Intelligence and Audit\nThe Intelligence & Audit Engine must report what can actually be established. It must never manufacture scores, losses, competitors, scans, or findings to satisfy expectations. Every conclusion should preserve its evidence basis and limitations.\n\n## Article X — Data, Privacy and Security\nClient and prospect information must be handled according to purpose, authorization, security requirements, and applicable law. Access must follow least-privilege principles where technically feasible.\n\n## Article XI — Change Control and Exceptions\nMaterial changes to scope, workflow, data authority, automation authority, or governance require documented change control. Exceptions must be explicit, time-bounded where appropriate, attributable, and auditable.\n\n## Article XII — Commercial Governance\nCommercial and payment infrastructure is downstream of operational integrity. Payment integrations, including Flutterwave and Stripe, must not determine service truth, audit outcomes, project status, or performance claims. They are reserved for the final commercial-infrastructure stage after core workflows have been tested and verified.\n\n## Article XIII — Quality and Testing\nA feature is not considered trustworthy merely because it exists. Workflows must be tested for valid operation, invalid inputs, missing evidence, permission boundaries, handoff integrity, failure states, and recoverability appropriate to their risk.\n\n## Article XIV — Public Transparency\nThe full Constitution is an internal governing specification. 5MC may publish a concise public Integrity/Performance Standard that communicates its core principles without exposing internal security, operational, or governance details.\n\n## Article XV — Future Engines\nFuture engines, departments, products, agents, and infrastructure—including Hunter, Oracle, and systems not yet designed—must be classified and governed before receiving operational authority. The Constitution is extensible and applies to them by default.\n\n## Article XVI — Amendment and Supremacy\nThis Constitution is version-controlled. Policies, service standards, workflow contracts, application logic, automation rules, and commercial integrations are subordinate to it. Where lower-level rules conflict with the Constitution, the conflict must be surfaced and resolved rather than silently ignored.\n\n## Non-Negotiable Integrity Clause\n**5MC Performance shall not claim what it cannot support. Where the ecosystem cannot actually measure, verify, observe, or establish something, it shall say so.**\n",[],[549,575],"7ca52a29-46d1-40d4-aee8-cc9344af91b1","client-actions.ts","6be4b20e-a588-11f1-b9d8-1607ee4eb77e",89,["D",1788214076937],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst kinds=[\"information\",\"approval\",\"asset\",\"decision\",\"access\",\"payment-excluded\"];\nconst statuses=[\"open\",\"submitted\",\"approved\",\"rejected\",\"cancelled\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS client_actions (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,action_type TEXT NOT NULL,title TEXT NOT NULL,description TEXT NOT NULL,requested_from TEXT NOT NULL,due_at TEXT NOT NULL,blocking INTEGER NOT NULL,status TEXT NOT NULL,response_ref TEXT NOT NULL,evidence_ref TEXT NOT NULL,created_by TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\"){const rows:any[]=(await sqlite.execute(`SELECT * FROM client_actions ORDER BY created_at DESC`)).rows;return Response.json({actionTypes:kinds,statuses,rule:\"Client actions must be explicit; blocking requests are visible, traceable and cannot be silently treated as approved.\",actions:rows},{headers:J})}let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"project_ref\",\"action_type\",\"title\",\"description\",\"requested_from\",\"due_at\",\"blocking\",\"status\",\"response_ref\",\"evidence_ref\",\"created_by\"],missing=fields.filter(k=>b[k]===undefined||b[k]===null||String(b[k]).trim()===\"\");if(missing.length)return Response.json({error:\"Client action gate blocked\",missing},{status:409});if(!kinds.includes(b.action_type)||!statuses.includes(b.status))return Response.json({error:\"Invalid action type or status\",actionTypes:kinds,statuses},{status:400});if(![0,1,true,false].includes(b.blocking))return Response.json({error:\"blocking must be boolean\"},{status:400});const id=`ACT-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO client_actions VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,b.project_ref,b.action_type,b.title,b.description,b.requested_from,b.due_at,b.blocking?1:0,b.status,b.response_ref,b.evidence_ref,b.created_by,now,now]});return Response.json({ok:true,actionId:id,status:b.status,blocking:!!b.blocking},{headers:J})}",[],[549,583],"ad86464a-1394-4135-a8c7-616810ffd096","change-control.ts","ae9bd860-a589-11f1-a08f-1607ee4eb77e",91,["D",1788214618361],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst types=[\"client_revision\",\"scope_change\",\"requirement_change\",\"schedule_change\",\"deliverable_change\",\"technical_change\"];\nconst statuses=[\"proposed\",\"under_review\",\"approved\",\"rejected\",\"implemented\",\"superseded\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS change_requests (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,change_type TEXT NOT NULL,title TEXT NOT NULL,reason TEXT NOT NULL,impact TEXT NOT NULL,old_scope TEXT NOT NULL,new_scope TEXT NOT NULL,requested_by TEXT NOT NULL,approval_ref TEXT NOT NULL,evidence_ref TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\"){const rows:any[]=(await sqlite.execute(`SELECT * FROM change_requests ORDER BY created_at DESC`)).rows;return Response.json({changeTypes:types,statuses,rule:\"No material scope or requirement change may be silently treated as part of the original project; change history remains traceable.\",requests:rows},{headers:J})}let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"project_ref\",\"change_type\",\"title\",\"reason\",\"impact\",\"old_scope\",\"new_scope\",\"requested_by\",\"approval_ref\",\"evidence_ref\",\"status\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Change-control gate blocked\",missing},{status:409});if(!types.includes(b.change_type)||!statuses.includes(b.status))return Response.json({error:\"Invalid change type or status\",changeTypes:types,statuses},{status:400});const id=`CHG-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO change_requests VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now,now]});return Response.json({ok:true,changeId:id,status:b.status,rule:\"No silent scope expansion\"},{headers:J})}",[],[549,591],"8e08cbb5-f35d-425c-bf6d-29fe0bf646a5","brief-to-project.ts","58c58318-a585-11f1-aa09-1607ee4eb77e",86,["D",1788212756363],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst allowed=[\"GROW\",\"CREATIVE\",\"DIGITAL\",\"PROMOTION\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS governed_projects (id TEXT PRIMARY KEY,project_ref TEXT NOT NULL,engine TEXT NOT NULL,constitution_version TEXT NOT NULL,objective TEXT NOT NULL,scope TEXT NOT NULL,success_criteria TEXT NOT NULL,brief_ref TEXT NOT NULL,evidence_ref TEXT NOT NULL,approval_ref TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({constitutionVersion:\"1.0\",rule:\"Only an approved project brief with explicit evidence and approval references may become a governed project.\"},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"brief_ref\",\"project_ref\",\"engine\",\"objective\",\"scope\",\"success_criteria\",\"evidence_ref\",\"approval_ref\",\"approved_by\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Brief-to-project governance gate blocked\",missing},{status:409});const engine=String(b.engine).toUpperCase();if(!allowed.includes(engine))return Response.json({error:\"Unsupported service engine\",allowed},{status:400});if(String(b.approval_ref).toLowerCase()===\"pending\"||String(b.approved_by).toLowerCase()===\"pending\")return Response.json({ok:false,gate:\"blocked\",error:\"Project cannot be created with pending approval\"},{status:409});const id=`GPR-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO governed_projects VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,b.project_ref,engine,\"1.0\",b.objective,b.scope,b.success_criteria,b.brief_ref,b.evidence_ref,b.approval_ref,\"intake\",now]});return Response.json({ok:true,gate:\"verified\",governanceRecord:id,constitutionVersion:\"1.0\",status:\"intake\",next:\"service-execution\"},{headers:J})}",[],[549,599],"9c98b82c-60ff-47a2-80ec-04e57713f8f6",["D",1788210072452],"directory",[182,183,184,185,186,187,188,189],[549],"c142a27c-4d4e-430f-b7b5-abdf27dd864b","portfolio-candidates.md","b4b0ef2e-a589-11f1-9796-1607ee4eb77e","d2127289-105b-4453-9c50-e4568d4b281f",92,["D",1788214628523],"# 5MC Performance — Portfolio Candidate Register\n\n**Status:** UNVERIFIED SOURCE REGISTER\n**Purpose:** Preserve names supplied as historical client/portfolio/case-study candidates without presenting them publicly as confirmed clients.\n\n## Integrity rule\nThese names were supplied as a historical portfolio list. They are **not verified by this register**. No website, case study, testimonial, logo, client count, result, revenue impact, or statement of work may be published as factual until supporting evidence is attached and reviewed.\n\n## Verification states\n- `unverified` — name supplied, no supporting evidence recorded.\n- `identity_verified` — business identity/source confirmed.\n- `relationship_verified` — evidence supports that 5MC worked with/for the business.\n- `work_verified` — specific deliverable/work is evidenced.\n- `result_verified` — measurable outcome is evidenced.\n- `publishable` — approved for public portfolio use after required checks.\n\n## Supplied candidates\n\n### Technology, Software & Digital Agencies\nApex Digital Solutions; Nexus Cloud Systems; CyberShield Technologies; Quantum Code Labs; AlphaByte Software; Stellar Web Works; InfiniTech Global; BitStream Analytics; NovaWire Networks; VeloCloud Solutions; OmniDesk CRM; SyncroMedia Group; PixelCraft Studio; Hyperion Data Systems; EchoByte Innovations; CodeCraft Labs; AppVanguard; TechPulse Media; Zenith Software Hub; BinaryForge Solutions; Infinitum Digital; CloudMatrix Systems; NextGen Web Solutions; Apex Automation; SmartGrid Technologies; DevSphere Corp; QuantumLink AI; TekHorizon; CoreStack Innovations; ByteDance Partners.\n\n### Fashion, Apparel & Lifestyle\nVelvet & Vine Couture; Urban Edge Apparel; Sovereign Men's Tailoring; Aura Luxury Wear; Nomad Streetwear; Elegance & Co. Bespoke; Zenith Threads; Heritage Loom & Fabric; Prestige Suit & Tie; Silk Road Textiles; PrimeFit Activewear; Rogue Gentleman; Chic Avenue Boutique; Bella Vista Fashion; Timber & Thread; Modernist Garments; Velvet Street Studio; Royal Crown Clothiers; Urban Nomad Style; Infinite Denim Co.; House of Classics; Vanguard Fashion Lab; Signature Look Atelier; Horizon Tailors; Obsidian Wear; Crestline Apparel; Velvet Rose Boutique; Artisan Stitch Co.; Luminary Fashion House; Golden Thread Studio; Apex Menswear; Heritage & Co.; MetroStyle Apparel; Luxe Line Boutique; Prime Garments.\n\n### Real Estate & Property Development\nHorizon Estate Management; PrimeView Properties; Crestline Real Estate; Urban Nest Living; Sterling Heights Realty; Grandview Properties; Vanguard Housing Group; Milestone Realty Partners; Apex Landmark Developments; Oakridge Property Corp; Silverline Estates; Keystone Real Estate; Summit View Homes; Golden Gate Properties; Prosperity Acres; Metroplex Living; Haven & Hearth Realty; Elite Space Developments; Crown Jewel Properties; Visionary Estates; Latitude Real Estate; Northstar Properties; Pacific Coast Realty; Regal Crest Developments; Urban Oasis Living; Titan Property Group; Emerald City Estates; Signature Properties; Pioneer Real Estate; Blue Harbor Realty.\n\n### Hospitality, Resorts & Lounge Management\nAzure Bay Resort & Spa; Velvet Lounge & Bar; The Grand Oasis Hotel; Zenith Hospitality Group; Skyline Rooftop Lounge; Oasis Palms Resort; Eclipse Nightclub & Bar; Royal Palm Suites; Sapphire Coast Resort; Momentum Lounge; The Prestige Hotel; Horizon Bay Resort; Velvet Night Social Club; Crystal Waters Resort; The Golden Plate Restaurant; Summit Lodge & Retreat; Grandview Hospitality; Blue Lagoon Resort; The Obsidian Lounge; Serenity Spa & Resort; Urban Retreat Hotel; Pioneer Hospitality Group; Starlight Lounge; Imperial Palace Hotel; Latitude Beach Resort; The Velvet Lounge; Tradewinds Resort; Apex Hospitality; Cascade Falls Resort; Harmony Hotel Group.\n\n### E-Commerce & Retail Brands\nGlobalMart Online; SwiftCart E-Commerce; Alpha Retail Hub; OmniStore Direct; PrimeShelf Marketplace; NextGen Goods; VibeStore Retail; Crestline Commerce; Horizon Retail Group; Urban Market Co.; Elite Choice Retail; Sterling Goods Co.; Vanguard Market; FlashSale Express; Nexus E-Commerce; Infinite Retail Solutions; Apex Marketplace; Catalyst Retail Group; Golden Basket Co.; TrueValue Retail; MetroStore Online; Blueprint Commerce; Alpha & Omega Store; Peak Performance Retail; Coastline Goods; Savvy Shopper Hub; Pioneer Retail Direct; Titan Commerce Group; Nova Retail Partners; Synergy Storefront.\n\n### Media, Advertising & Creative Studios\nSoundWave Audio Productions; PixelPerfect Media; Visionary Ad Group; Apex Creative Labs; Momentum Video Productions; Stellar Motion Pictures; Pulse Media Agency; Echo Creative Studio; Vanguard Advertising; Horizon Media Group; Alpha Sound & Vision; Kinetic Design Studio; Nexus Brand Partners; Titan Media Works; Prime Content Group; Studio 360 Media; Infinite Visuals; Zenith Ad Network; Luminary Media House; Dynamic Creative Co.; Eclipse Production Studio; Fusion Media Group; Crestline Creative; Catalyst Advertising; Blueprint Media Labs.\n\n### Logistics, Security & Enterprise Services\nSafeGuard Security Systems; SwiftRoute Logistics; Apex Enterprise Group; Ironclad Security Corp; Velocity Freight & Delivery; Vanguard Security Solutions; Titan Transport & Logistics; Sentinel 4G Security; PrimeLine Express; ShieldWall Systems; Global Transit Partners; Apex Guardian Security; Horizon Freight Co.; SecureNet Enterprise; Metro Logistics Hub; Pioneer Transport Solutions; Falcon Eye Surveillance; Stellar Logistics Group; Alpha Fleet Management; Zenith Security Systems.\n",[],[620,612],"evidence","7dd42769-2f48-41f0-9de8-c8d8e6e33c43",["D",1788214628523],[180],[620],"fafbd0db-5f66-4afd-bf0e-40e05c1bf794","scoring-engine.ts","d6646ca0-a59c-11f1-8b1c-1607ee4eb77e","7601bde0-89be-49f2-999c-f80931bd0b68",100,["D",1788222862914],"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 audit_scores (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,rubric_version TEXT NOT NULL,score REAL NOT NULL,max_score REAL NOT NULL,components TEXT NOT NULL,inputs_ref TEXT NOT NULL,calculation_ref TEXT NOT NULL,limitations TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){\n await db();\n if(req.method!==\"POST\") return Response.json({rubricVersion:\"1.0\",rule:\"Score only when every mandatory component is measured, evidence-backed, and reproducible. Otherwise return Not Scorable.\",required:[\"audit_ref\",\"rubric_version\",\"components\",\"inputs_ref\",\"calculation_ref\",\"limitations\"]},{headers:J});\n let b:any; try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}\n const fields=[\"audit_ref\",\"rubric_version\",\"components\",\"inputs_ref\",\"calculation_ref\",\"limitations\"];\n const missing=fields.filter(k=>!String(b[k]??\"\").trim());\n if(missing.length)return Response.json({ok:false,gate:\"blocked\",status:\"Not Scorable\",missing},{status:409});\n let components:any; try{components=typeof b.components===\"string\"?JSON.parse(b.components):b.components}catch{return Response.json({error:\"components must be valid JSON\"},{status:400})}\n if(!Array.isArray(components)||!components.length)return Response.json({ok:false,status:\"Not Scorable\",reason:\"No scoring components supplied\"},{status:409});\n const invalid=components.filter((c:any)=>!c||c.mandatory!==true||typeof c.value!==\"number\"||typeof c.max!==\"number\"||c.max<=0||typeof c.evidence_ref!==\"string\"||!c.evidence_ref.trim());\n if(invalid.length)return Response.json({ok:false,status:\"Not Scorable\",reason:\"Every mandatory component needs a numeric result, maximum, and evidence reference\"},{status:409});\n const total=components.reduce((a:number,c:any)=>a+c.value,0),max=components.reduce((a:number,c:any)=>a+c.max,0);\n if(total<0||components.some((c:any)=>c.value<0||c.value>c.max))return Response.json({ok:false,status:\"Not Scorable\",reason:\"Component values must be within declared ranges\"},{status:409});\n const score=Math.round((total/max)*10000)/100,id=`SCR-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();\n await sqlite.execute({sql:`INSERT INTO audit_scores VALUES (?,?,?,?,?,?,?,?,?,?)`,args:[id,b.audit_ref,b.rubric_version,score,100,JSON.stringify(components),b.inputs_ref,b.calculation_ref,b.limitations,now]});\n return Response.json({ok:true,status:\"Scored\",score,maxScore:100,scoreId:id,rubricVersion:b.rubric_version,traceability:b.audit_ref+\"->inputs->components->\"+id},{headers:J});\n}",[],[634,626],"audit","a987777f-66c5-4c56-9472-e69938c2c47f","roi-projection-engine.ts","6e608612-a5a0-11f1-8883-1607ee4eb77e",104,["D",1788224389018],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst modes=[\"verified\",\"scenario\",\"unavailable\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_roi_projections (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,mode TEXT NOT NULL,inputs TEXT NOT NULL,assumptions TEXT NOT NULL,projection TEXT NOT NULL,limitations TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){\n await db();\n if(req.method!==\"POST\")return Response.json({modes,rule:\"ROI/revenue projections require explicit inputs and assumptions. Verified mode requires verified financial/performance inputs; scenario mode must disclose assumptions; insufficient evidence returns unavailable.\"},{headers:J});\n let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}\n for(const k of [\"audit_ref\",\"mode\",\"inputs\",\"assumptions\",\"projection\",\"limitations\"]){if(b[k]===undefined||b[k]===null||String(b[k]).trim()===\"\")return Response.json({ok:false,gate:\"blocked\",status:\"Unavailable\",missing:k},{status:409})}\n const mode=String(b.mode).toLowerCase();if(!modes.includes(mode))return Response.json({error:\"Invalid mode\",allowed:modes},{status:400});\n let inputs:any;try{inputs=typeof b.inputs===\"string\"?JSON.parse(b.inputs):b.inputs}catch{return Response.json({error:\"inputs must be valid JSON\"},{status:400})}\n if(typeof inputs!==\"object\"||Array.isArray(inputs))return Response.json({error:\"inputs must be an object\"},{status:400});\n if(mode===\"verified\"&&!inputs.verification_ref)return Response.json({ok:false,gate:\"blocked\",status:\"Unavailable\",reason:\"Verified mode requires verification_ref\"},{status:409});\n if(mode===\"scenario\"&&!inputs.assumption_basis)return Response.json({ok:false,gate:\"blocked\",status:\"Unavailable\",reason:\"Scenario mode requires assumption_basis\"},{status:409});\n const id=`ROI-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();\n await sqlite.execute({sql:`INSERT INTO audit_roi_projections VALUES (?,?,?,?,?,?,?,?)`,args:[id,b.audit_ref,mode,JSON.stringify(inputs),String(b.assumptions),String(b.projection),String(b.limitations),now]});\n return Response.json({ok:true,status:mode===\"unavailable\"?\"Unavailable\":\"Available\",projectionMode:mode,projection:b.projection,projectionId:id,guarantee:false,traceability:b.audit_ref+\"->validated-inputs->\"+id},{headers:J});\n}",[],[634,636],"1879df51-c611-4d1d-8cc5-550affe19f4e","report-engine.ts","0fabf192-a5a0-11f1-a218-1607ee4eb77e",103,["D",1788224230126],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst pillars=[\"fear\",\"lost\",\"leakage\",\"solution\",\"seo-engine\"];\nconst statuses=[\"draft\",\"review\",\"ready\",\"delivered\",\"superseded\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_reports (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,title TEXT NOT NULL,executive_summary TEXT NOT NULL,pillars TEXT NOT NULL,scorecard TEXT NOT NULL,injury_level TEXT NOT NULL,leakage_map TEXT NOT NULL,recovery_plan_ref TEXT NOT NULL,roi_status TEXT NOT NULL,limitations TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){\n await db();\n if(req.method!==\"POST\")return Response.json({required:[\"audit_ref\",\"title\",\"executive_summary\",\"pillars\",\"scorecard\",\"injury_level\",\"leakage_map\",\"recovery_plan_ref\",\"roi_status\",\"limitations\",\"status\"],pillars,statuses,rule:\"A report summarizes traceable audit outputs. It must not upgrade hypotheses into facts or unavailable financial evidence into ROI claims.\"},{headers:J});\n let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}\n const required=[\"audit_ref\",\"title\",\"executive_summary\",\"pillars\",\"scorecard\",\"injury_level\",\"leakage_map\",\"recovery_plan_ref\",\"roi_status\",\"limitations\",\"status\"];\n const missing=required.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",missing},{status:409});\n let p:any,s:any,l:any;try{p=typeof b.pillars===\"string\"?JSON.parse(b.pillars):b.pillars;s=typeof b.scorecard===\"string\"?JSON.parse(b.scorecard):b.scorecard;l=typeof b.leakage_map===\"string\"?JSON.parse(b.leakage_map):b.leakage_map}catch{return Response.json({error:\"pillars, scorecard and leakage_map must be valid JSON\"},{status:400})}\n if(!Array.isArray(p)||p.length!==5||p.some((x:any)=>!pillars.includes(String(x.pillar??x).toLowerCase())))return Response.json({ok:false,status:\"blocked\",reason:\"Report must account for all five audit pillars\"},{status:409});\n if(!Array.isArray(s))return Response.json({ok:false,status:\"blocked\",reason:\"scorecard must be an array\"},{status:409});\n if(!Array.isArray(l))return Response.json({ok:false,status:\"blocked\",reason:\"leakage_map must be an array\"},{status:409});\n const status=String(b.status).toLowerCase();if(!statuses.includes(status))return Response.json({error:\"Invalid status\",allowed:statuses},{status:400});\n const id=`RPT-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();\n await sqlite.execute({sql:`INSERT INTO audit_reports VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,b.audit_ref,b.title,b.executive_summary,JSON.stringify(p),JSON.stringify(s),b.injury_level,JSON.stringify(l),b.recovery_plan_ref,b.roi_status,b.limitations,status,now]});\n return Response.json({ok:true,reportId:id,status,claimType:\"audit-report\",traceability:b.audit_ref+\"->findings->scorecard->recovery->\"+id},{headers:J});\n}",[],[634,644],"96b1bf4c-9334-4e6c-83b4-05fa66ea1c5a","recovery-plan-engine.ts","c9d95df8-a59f-11f1-ba9d-1607ee4eb77e",102,["D",1788224112992],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst pillars=[\"fear\",\"lost\",\"leakage\",\"solution\",\"seo-engine\"];\nconst services=[\"GROW\",\"CREATIVE\",\"DIGITAL\",\"PROMOTION\"];\nconst phases=[\"foundation\",\"growth\",\"dominance\"];\nconst priorities=[\"critical\",\"high\",\"medium\",\"low\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_recovery_plans (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,title TEXT NOT NULL,objective TEXT NOT NULL,horizon_days INTEGER NOT NULL,actions TEXT NOT NULL,measurement_checkpoints TEXT NOT NULL,dependencies TEXT NOT NULL,limitations TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){\n await db();\n if(req.method!==\"POST\") return Response.json({horizonDays:90,phases, pillars,services,priorities,statuses:[\"draft\",\"approved\",\"in_progress\",\"paused\",\"completed\",\"superseded\"],rule:\"A recovery plan must be derived from validated recommendations. It defines interventions and measurement checkpoints; it does not guarantee revenue recovery or profitability.\"},{headers:J});\n let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}\n const required=[\"audit_ref\",\"title\",\"objective\",\"actions\",\"measurement_checkpoints\",\"dependencies\",\"limitations\",\"status\"];\n const missing=required.filter(k=>!String(b[k]??\"\").trim());\n if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Recovery-plan gate blocked\",missing},{status:409});\n let actions:any,checkpoints:any;try{actions=typeof b.actions===\"string\"?JSON.parse(b.actions):b.actions;checkpoints=typeof b.measurement_checkpoints===\"string\"?JSON.parse(b.measurement_checkpoints):b.measurement_checkpoints}catch{return Response.json({error:\"actions and measurement_checkpoints must be valid JSON\"},{status:400})}\n if(!Array.isArray(actions)||!actions.length)return Response.json({ok:false,status:\"blocked\",reason:\"At least one action is required\"},{status:409});\n const invalid=actions.filter((a:any)=>!a||!a.recommendation_ref||!a.pillar||!pillars.includes(String(a.pillar).toLowerCase())||!a.action||!priorities.includes(String(a.priority).toLowerCase())||!a.phase||!phases.includes(String(a.phase).toLowerCase())||(a.service_mapping!==\"NONE\"&&!services.includes(String(a.service_mapping).toUpperCase())));\n if(invalid.length)return Response.json({ok:false,status:\"blocked\",reason:\"Every action needs a recommendation reference, valid pillar, action, priority, phase, and service mapping\"},{status:409});\n if(!Array.isArray(checkpoints)||!checkpoints.length)return Response.json({ok:false,status:\"blocked\",reason:\"At least one measurement checkpoint is required\"},{status:409});\n const horizon=Number(b.horizon_days??90);if(!Number.isInteger(horizon)||horizon<1||horizon>365)return Response.json({error:\"horizon_days must be an integer from 1 to 365\"},{status:400});\n const status=String(b.status).toLowerCase();if(![\"draft\",\"approved\",\"in_progress\",\"paused\",\"completed\",\"superseded\"].includes(status))return Response.json({error:\"Invalid status\"},{status:400});\n const id=`RCP-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();\n await sqlite.execute({sql:`INSERT INTO audit_recovery_plans VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,b.audit_ref,b.title,b.objective,horizon,JSON.stringify(actions),JSON.stringify(checkpoints),b.dependencies,b.limitations,status,now]});\n return Response.json({ok:true,planId:id,status,horizonDays:horizon,claimType:\"recovery-plan\",guarantee:false,traceability:b.audit_ref+\"->recommendations->\"+id},{headers:J});\n}",[],[634,652],"31efabc6-3c53-4c23-851f-4841aa86c549","recommendation-engine.ts","8e23b0e8-a59e-11f1-9c47-1607ee4eb77e",101,["D",1788223583320],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst pillars=[\"fear\",\"lost\",\"leakage\",\"solution\",\"seo-engine\"];\nconst services=[\"GROW\",\"CREATIVE\",\"DIGITAL\",\"PROMOTION\"];\nconst priorities=[\"critical\",\"high\",\"medium\",\"low\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_recommendations (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,finding_ref TEXT NOT NULL,pillar TEXT NOT NULL,recommendation TEXT NOT NULL,rationale TEXT NOT NULL,priority TEXT NOT NULL,objective TEXT NOT NULL,service_mapping TEXT NOT NULL,dependencies TEXT NOT NULL,limitations TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){\n await db();\n if(req.method!==\"POST\") return Response.json({pillars,services,priorities,statuses:[\"proposed\",\"accepted\",\"rejected\",\"implemented\",\"superseded\"],rule:\"Recommendations must trace to a supported finding. They are proposed interventions, not measured facts, guaranteed outcomes, or revenue promises.\"},{headers:J});\n let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}\n const fields=[\"audit_ref\",\"finding_ref\",\"pillar\",\"recommendation\",\"rationale\",\"priority\",\"objective\",\"service_mapping\",\"dependencies\",\"limitations\",\"status\"];\n const missing=fields.filter(k=>!String(b[k]??\"\").trim());\n if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Recommendation gate blocked\",missing},{status:409});\n if(!pillars.includes(String(b.pillar).toLowerCase()))return Response.json({error:\"Invalid pillar\",allowed:pillars},{status:400});\n if(!priorities.includes(String(b.priority).toLowerCase()))return Response.json({error:\"Invalid priority\",allowed:priorities},{status:400});\n if(![\"proposed\",\"accepted\",\"rejected\",\"implemented\",\"superseded\"].includes(String(b.status).toLowerCase()))return Response.json({error:\"Invalid status\"},{status:400});\n const mapped=String(b.service_mapping).trim();if(mapped!==\"NONE\"&&mapped.split(\",\").some((x:string)=>!services.includes(x.trim().toUpperCase())))return Response.json({error:\"Invalid 5MC service mapping\",allowed:[\"NONE\",...services]},{status:400});\n if(String(b.finding_ref).trim().toUpperCase().startsWith(\"NONE\"))return Response.json({ok:false,gate:\"blocked\",error:\"A recommendation cannot exist without a finding reference\"},{status:409});\n const id=`REC-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();\n await sqlite.execute({sql:`INSERT INTO audit_recommendations VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now]});\n return Response.json({ok:true,recommendationId:id,status:b.status,claimType:\"recommendation\",serviceMapping:mapped,traceability:b.audit_ref+\"->\"+b.finding_ref+\"->\"+id},{headers:J});\n}",[],[634,660],"c7935d2d-e9ce-400b-941a-3d4d1a617a6d","reaudit-comparison-engine.ts","85da56b4-a5a1-11f1-864d-1607ee4eb77e",105,["D",1788224857904],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst dimensions=[\"visual_trust\",\"navigation_clarity\",\"message_match\",\"hook_retention\",\"offer_strength\",\"checkout_intake_friction\",\"seo_indexing\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_reaudits (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,baseline_ref TEXT NOT NULL,comparison_ref TEXT NOT NULL,dimensions TEXT NOT NULL,overall_before REAL,overall_after REAL,change REAL,status TEXT NOT NULL,limitations TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){\n await db();\n if(req.method!==\"POST\") return Response.json({dimensions,rule:\"Compare only like-for-like measured dimensions. Missing or non-comparable measurements remain unavailable; a change is not proof of causation.\",statuses:[\"draft\",\"review\",\"completed\",\"inconclusive\"]},{headers:J});\n let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}\n const required=[\"audit_ref\",\"baseline_ref\",\"comparison_ref\",\"dimensions\",\"limitations\"];\n const missing=required.filter(k=>!String(b[k]??\"\").trim());\n if(missing.length)return Response.json({ok:false,status:\"inconclusive\",missing},{status:409});\n let ds:any;try{ds=typeof b.dimensions===\"string\"?JSON.parse(b.dimensions):b.dimensions}catch{return Response.json({error:\"dimensions must be valid JSON\"},{status:400})}\n if(!Array.isArray(ds)||!ds.length)return Response.json({ok:false,status:\"inconclusive\",reason:\"No comparison dimensions supplied\"},{status:409});\n const invalid=ds.filter((d:any)=>!d||!dimensions.includes(String(d.name).toLowerCase())||typeof d.before!==\"number\"||typeof d.after!==\"number\"||d.before<0||d.after<0||typeof d.comparable!==\"boolean\");\n if(invalid.length)return Response.json({ok:false,status:\"inconclusive\",reason:\"Each dimension needs a valid name, numeric before/after values, and comparable flag\"},{status:409});\n const comparable=ds.filter((d:any)=>d.comparable),before=comparable.length?comparable.reduce((a:number,d:any)=>a+d.before,0)/comparable.length:null,after=comparable.length?comparable.reduce((a:number,d:any)=>a+d.after,0)/comparable.length:null,change=before===null||after===null?null:Math.round((after-before)*100)/100;\n const id=`RA-${crypto.randomUUID().slice(0,8).toUpperCase()}`,status=comparable.length?\"completed\":\"inconclusive\",now=new Date().toISOString();\n await sqlite.execute({sql:`INSERT INTO audit_reaudits VALUES (?,?,?,?,?,?,?,?,?,?)`,args:[id,b.audit_ref,b.baseline_ref,b.comparison_ref,JSON.stringify(ds),before,after,change,status,b.limitations,now]});\n return Response.json({ok:true,id,status,dimensionsCompared:comparable.length,overallBefore:before,overallAfter:after,change,causalityClaim:false,traceability:b.audit_ref+\"->\"+b.baseline_ref+\"->\"+b.comparison_ref+\"->\"+id},{headers:J});\n}",[],[634,668],"4e86cdc7-baa9-4970-8f6d-383ef3f07acf","methodology.md","5e0f082c-a58e-11f1-8c8f-1607ee4eb77e",93,["D",1788216630704],"# 5MC PERFORMANCE 2.0 — AUDIT METHODOLOGY & EVIDENCE CONTRACT\n\n**Version:** 1.0\n**Status:** Foundational audit specification\n\n## 1. Purpose\nThe Audit Engine exists to establish what can actually be observed, measured, verified, or reasonably inferred about a defined business/digital subject. It is a diagnostic system, not a sales-score generator.\n\n## 2. Audit States\nREQUESTED → SCOPED → COLLECTING → EVIDENCE_REVIEW → FINDINGS → REPORT_READY → DELIVERED.\nA failed, inaccessible, or insufficiently evidenced audit must be recorded as such rather than represented as completed.\n\n## 3. Evidence Classes\n- **Observed:** directly observed during the audit session or from an explicitly identified source.\n- **Verified:** independently supported by a reliable source or reproducible check.\n- **Measured:** produced by a defined measurement procedure with a known basis.\n- **Client-provided:** supplied by the client and retained as client-provided unless independently verified.\n- **Estimated:** calculated from stated assumptions; never presented as observed fact.\n- **Target:** desired future state, not a current result.\n- **Unavailable:** could not be accessed or measured.\n- **Inconclusive:** available evidence is insufficient for a reliable conclusion.\n\n## 4. Evidence Contract\nEvery substantive finding must have an evidence reference. Every measurement must identify its measurement method, source, timestamp where relevant, and limitations. A source that cannot be accessed must not be described as scanned or inspected.\n\n## 5. Scoring Rules\nA score may be produced only when a documented scoring rubric exists, the required inputs are available, and the calculation is reproducible. Missing inputs may not silently become zero, average, pass, or fail values. If the methodology does not support a score, report **Not Scorable** and explain why.\n\n## 6. Prohibited Claims\nThe Audit Engine must never fabricate:\n- revenue loss or revenue opportunity;\n- competitors or competitor activity;\n- traffic, conversion, engagement, or performance figures;\n- scans, crawls, tests, or observations that did not occur;\n- rankings, health scores, grades, or benchmark positions without a valid basis;\n- client outcomes or testimonials;\n- recommendations presented as measured facts.\n\n## 7. Finding Structure\nEach finding should preserve: **finding → evidence → confidence → implication → recommendation → limitation**. Recommendations must be distinguishable from observations.\n\n## 8. Confidence\nConfidence describes evidentiary strength, not business performance. Use defined labels such as High, Medium, Low, or Inconclusive only when the evidence basis is documented.\n\n## 9. Audit Scope\nAn audit must state what was included, excluded, inaccessible, and not assessed. A partial audit must be labelled partial.\n\n## 10. Reproducibility\nWhere technically possible, audit checks should record the check definition, input/source, timestamp, and result. A later re-audit must be able to distinguish changed evidence from changed methodology.\n\n## 11. Separation of Roles\n**Audit Engine:** establishes evidence and findings. \n**Oracle:** guides users and explains available information. \n**Hunter:** performs authorized automation. \n**GROW / CREATIVE / DIGITAL / PROMOTION:** act on appropriate findings through governed projects.\n\n## 12. Integrity Gate\nBefore an audit report is marked ready, the system must verify that substantive claims have evidence references, unsupported measurements are labelled, unavailable checks are disclosed, and any score is reproducible under the declared rubric.\n\n## Non-Negotiable Rule\n**If the system did not observe, measure, verify, or establish it, the audit must not present it as fact.**\n",[],[634,676],"5a9310f7-5fea-48dc-b049-b713f12acc5d","measurement-scoring-framework.md","af50dcca-a59c-11f1-b041-1607ee4eb77e",97,["D",1788222779971],"# 5MC PERFORMANCE 2.0 — AUDIT MEASUREMENT & SCORING FRAMEWORK\n\n**Version:** 1.0\n**Status:** Foundational scoring specification\n\n## 1. Principle\nA score is a calculated representation of defined evidence. It is never a substitute for evidence and must never be generated merely because a user expects a number.\n\n## 2. Measurement Record\nEvery measurement must retain: audit reference, metric name, definition, source/evidence reference, method, input values, unit, timestamp where relevant, calculation, result, limitations, and measurement status.\n\n## 3. Measurement Status\n- **Measured:** required inputs were actually obtained and the defined method was executed.\n- **Partially measured:** some required inputs were obtained, but the result has material limitations.\n- **Estimated:** result depends on explicit assumptions and is labelled as such.\n- **Unavailable:** required evidence/input could not be obtained.\n- **Not applicable:** metric does not apply to the scoped subject.\n- **Inconclusive:** evidence exists but cannot support a reliable measurement.\n\n## 4. Scoring Eligibility\nA score is eligible only if:\n1. a published rubric exists;\n2. all mandatory inputs for that rubric are available;\n3. the measurement method was actually executed;\n4. missing values were not silently substituted;\n5. the calculation is reproducible; and\n6. the limitations do not invalidate the interpretation.\n\nIf any mandatory condition fails, the result is **Not Scorable**.\n\n## 5. Missing Data Rule\nMissing, inaccessible, stale, contradictory, or unverified inputs must remain explicitly labelled. They may not automatically become zero, average, worst-case, best-case, or a neutral value unless the declared rubric explicitly defines that treatment before the audit.\n\n## 6. Score Construction\nWhere a rubric permits scoring, each component must identify its weight, allowed range, input source, normalization rule, and calculation. The final score must be reproducible from the stored component records. Rounding must occur only after the underlying calculation.\n\n## 7. Benchmark Rule\nA benchmark may be shown only when its source, population, period, definition, and comparability are known. A generic industry number is not evidence about an individual business.\n\n## 8. Causality Rule\nA measured correlation, observation, or diagnostic finding must not be presented as proof that a particular business outcome was caused by a particular factor unless the evidence and methodology support causal attribution.\n\n## 9. Recommendation Separation\nScores and measurements describe the assessed state. Recommendations describe proposed action. A recommendation must never be used as evidence for a score.\n\n## 10. Audit Integrity Gate\nBefore publishing a scored result, verify: rubric version, mandatory inputs, evidence references, calculation trace, missing-data treatment, benchmark provenance where applicable, timestamp, limitations, and reviewer/system identity.\n\n## 11. Re-Audit Compatibility\nRubric versions must be retained. A later audit must identify whether a change in score comes from changed evidence, changed inputs, changed methodology, or changed weighting.\n\n## 12. Public Language\nUse precise states such as **Measured**, **Estimated**, **Unavailable**, **Inconclusive**, and **Not Scorable**. Never use a numerical score to create an appearance of certainty that the evidence does not support.\n\n## Non-Negotiable Rule\n**No evidence + no valid measurement method = no score.**\n",[],[634,684],"818108f6-a3e3-445b-b784-547e7d48e150","integrity-qa-engine.ts","143ab250-a5a2-11f1-bf99-1607ee4eb77e",["D",1788225096759],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst H={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst stages=[\"input\",\"evidence\",\"finding\",\"measurement\",\"score\",\"recommendation\",\"recovery_plan\",\"report\",\"projection\",\"comparison\"];\nconst errors=[\"unsupported_claim\",\"missing_evidence\",\"invalid_score\",\"undisclosed_assumption\",\"broken_traceability\",\"non_comparable_measurement\",\"unsupported_financial_claim\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_integrity_checks (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,checks TEXT NOT NULL,issues TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({stages,errors,statuses:[\"blocked\",\"review\",\"audit_ready\"],rule:\"Only an audit with complete required checks and no blocking integrity issues may be marked AUDIT_READY.\"},{headers:H});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}if(!b.audit_ref)return Response.json({error:\"audit_ref is required\"},{status:400});const checks=b.checks; if(!checks||typeof checks!==\"object\")return Response.json({error:\"checks object is required\"},{status:400});const issues:Array=[];for(const s of stages){const c=checks[s];if(!c||c.present!==true||c.traceable!==true)issues.push({stage:s,type:\"broken_traceability\",reason:\"Stage is missing or not traceable\"})}for(const e of errors){if(checks[e]===true)issues.push({type:e})}const status=issues.length?\"blocked\":\"audit_ready\";const id=`QA-${crypto.randomUUID().slice(0,8).toUpperCase()}`;await sqlite.execute({sql:`INSERT INTO audit_integrity_checks VALUES (?,?,?,?,?,?)`,args:[id,b.audit_ref,JSON.stringify(checks),JSON.stringify(issues),status,new Date().toISOString()]});return Response.json({ok:!issues.length,id,audit_ref:b.audit_ref,status,issues,releaseGate:status===\"audit_ready\",rule:\"AUDIT_READY requires all stages present and traceable and zero blocking integrity issues.\"},{headers:H})}",[],[634,692],"af3ffc3e-b82c-4734-b8ca-f993da7d322d","evidence-validation-findings.ts","807ed3de-a59c-11f1-bca2-1607ee4eb77e",96,["D",1788222701437],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst evidenceClasses=[\"observed\",\"verified\",\"measured\",\"client-provided\",\"estimated\",\"target\",\"unavailable\",\"inconclusive\"];\nconst confidence=[\"high\",\"medium\",\"low\",\"inconclusive\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_findings (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,evidence_ref TEXT NOT NULL,finding TEXT NOT NULL,evidence_sufficiency TEXT NOT NULL,confidence TEXT NOT NULL,implication TEXT NOT NULL,recommendation TEXT NOT NULL,limitation TEXT NOT NULL,status TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({evidenceClasses,confidence,rule:\"A finding requires traceable evidence and a documented sufficiency judgment. Unsupported claims remain inconclusive; recommendations never become observations.\",statuses:[\"supported\",\"inconclusive\",\"rejected\"]},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"audit_ref\",\"evidence_ref\",\"finding\",\"evidence_sufficiency\",\"confidence\",\"implication\",\"recommendation\",\"limitation\",\"status\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Finding validation gate blocked\",missing},{status:409});if(!confidence.includes(String(b.confidence).toLowerCase()))return Response.json({error:\"Invalid confidence\",allowed:confidence},{status:400});if(![\"supported\",\"inconclusive\",\"rejected\"].includes(b.status))return Response.json({error:\"Invalid finding status\",allowed:[\"supported\",\"inconclusive\",\"rejected\"]},{status:400});if(String(b.evidence_sufficiency).toLowerCase()===\"insufficient\"&&b.status===\"supported\")return Response.json({ok:false,gate:\"blocked\",error:\"Insufficient evidence cannot produce a supported finding\"},{status:409});const id=`FND-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO audit_findings VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,findingId:id,status:b.status,score:\"not generated\",traceability:`${b.audit_ref}→${b.evidence_ref}→${id}`},{headers:J})}",[],[634,699],"cd853fa7-45f9-414a-806d-43a9721f25a1","evidence-collection.ts","e307fbb8-a59a-11f1-97d2-1607ee4eb77e",95,["D",1788222007757],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst classes=[\"observed\",\"verified\",\"measured\",\"client-provided\",\"estimated\",\"target\",\"unavailable\",\"inconclusive\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_evidence (id TEXT PRIMARY KEY,audit_ref TEXT NOT NULL,evidence_class TEXT NOT NULL,source_ref TEXT NOT NULL,check_definition TEXT NOT NULL,observed_at TEXT NOT NULL,result TEXT NOT NULL,limitations TEXT NOT NULL,status TEXT NOT NULL,created_by TEXT NOT NULL,created_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\")return Response.json({evidenceClasses:classes,rule:\"Evidence records only what was actually observed, verified, measured, supplied, estimated, targeted, unavailable or inconclusive. No record means no scan occurred.\",records:[]},{headers:J});let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"audit_ref\",\"evidence_class\",\"source_ref\",\"check_definition\",\"observed_at\",\"result\",\"limitations\",\"status\",\"created_by\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Evidence collection gate blocked\",missing},{status:409});if(!classes.includes(b.evidence_class))return Response.json({error:\"Invalid evidence class\",allowed:classes},{status:400});const id=`EVD-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO audit_evidence VALUES (?,?,?,?,?,?,?,?,?,?,?)`,args:[id,...fields.map(k=>String(b[k]).trim()),now]});return Response.json({ok:true,evidenceId:id,status:b.status,auditRef:b.audit_ref,integrity:\"Evidence recorded; no unsupported conclusion or score has been generated.\"},{headers:J})}",[],[634,707],"fc17bf94-651a-452b-b9b0-d19559e8702e","audit-request-scope.ts","b894e842-a58f-11f1-9d2f-1607ee4eb77e",94,["D",1788217212068],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst J={\"content-type\":\"application/json\",\"cache-control\":\"no-store\"};\nconst areas=[\"website\",\"advertising\",\"creative\",\"digital-presence\",\"conversion-journey\",\"growth-infrastructure\"];\nconst states=[\"requested\",\"scoped\",\"collecting\",\"evidence_review\",\"findings\",\"report_ready\",\"delivered\",\"blocked\"];\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS audit_requests (id TEXT PRIMARY KEY,client_ref TEXT NOT NULL,subject TEXT NOT NULL,objective TEXT NOT NULL,areas TEXT NOT NULL,in_scope TEXT NOT NULL,out_scope TEXT NOT NULL,access_notes TEXT NOT NULL,success_definition TEXT NOT NULL,state TEXT NOT NULL,created_at TEXT NOT NULL,updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();if(req.method!==\"POST\"){const rows:any[]=(await sqlite.execute(`SELECT * FROM audit_requests ORDER BY created_at DESC`)).rows;return Response.json({auditAreas:areas,states,rule:\"No audit may be represented as completed until its defined scope and evidence state support that claim.\",requests:rows},{headers:J})}let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const fields=[\"client_ref\",\"subject\",\"objective\",\"areas\",\"in_scope\",\"out_scope\",\"access_notes\",\"success_definition\"],missing=fields.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({ok:false,gate:\"blocked\",error:\"Audit scope gate blocked\",missing},{status:409});const selected=String(b.areas).split(\",\").map((x:string)=>x.trim().toLowerCase()).filter(Boolean);if(!selected.length||selected.some((x:string)=>!areas.includes(x)))return Response.json({error:\"Invalid audit area\",allowed:areas},{status:400});const id=`AUD-${crypto.randomUUID().slice(0,8).toUpperCase()}`,now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO audit_requests VALUES (?,?,?,?,?,?,?,?,?,?,?,?)`,args:[id,b.client_ref,b.subject,b.objective,selected.join(\",\"),b.in_scope,b.out_scope,b.access_notes,b.success_definition,\"requested\",now,now]});return Response.json({ok:true,auditId:id,state:\"requested\",next:\"scope-review\",integrity:\"No score or scan has been performed.\"},{headers:J})}",[],[634,715],"989cc649-b8ac-488a-bbdf-4055320902df",["D",1788216630704],[167,168,169,170,171,172,173,174,175,176,177,178],[634],["D",1788016624119],["D",1789492855745],{"_11":12,"_125":70},{"_11":12,"_120":121,"_69":70,"_30":68,"_122":123,"_124":24},{"_38":111,"_13":16,"_32":35,"_112":72,"_113":-5,"_114":-5,"_115":-5,"_116":-5,"_117":-5,"_118":14,"_119":12},"ctx",{"_53":-5,"_144":764,"_765":766,"_767":768,"_769":24,"_770":24,"_771":24,"_772":85,"_773":-5,"_774":-7,"_775":-7,"_776":26,"_777":24,"_778":24,"_779":-5,"_780":24,"_781":24,"_782":24,"_783":-5},"ENV",{"_735":736,"_737":738,"_739":16,"_740":741,"_742":743,"_744":745,"_746":747,"_748":749,"_750":751,"_752":753,"_754":755,"_756":757,"_758":759,"_760":761,"_762":763},"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"]

History · creative-delivery.ts