[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","aurorinmagazine","name","mc5-service-engines","path","scope-review.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_60":-5,"_61":-5,"_62":36,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/aurorinmagazine/mc5-service-engines/code/scope-review.ts","extension","id","35b27e24-0baa-4f42-95d8-f9b951d952d3","fileId","a8ba380c-a529-11f1-b053-1607ee4eb77e","parentId","branchId","2ab34335-fa22-4373-a1af-bdcbf80ff8f6","branchVersion",28,"latest",true,"createdAt",["D",1788173376809],"version",0,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nconst esc=(v:unknown)=>String(v??\"\").replace(/[&<>\\\"']/g,c=>({\"&\":\"&\",\"<\":\"<\",\">\":\">\",\"\\\"\":\""\",\"'\":\"'\"}[c]!));\nconst headers={\"content-type\":\"text/html;charset=utf-8\",\"cache-control\":\"no-store\"};\nasync function db(){await sqlite.execute(`CREATE TABLE IF NOT EXISTS project_scopes (project_id TEXT PRIMARY KEY, scope_summary TEXT NOT NULL, deliverables TEXT NOT NULL, inclusions TEXT NOT NULL, exclusions TEXT NOT NULL, assumptions TEXT NOT NULL, acceptance_criteria TEXT NOT NULL, dependencies TEXT NOT NULL, build_plan TEXT NOT NULL, scope_decision TEXT NOT NULL, reviewer TEXT NOT NULL, updated_at TEXT NOT NULL)`)}\nexport default async function(req:Request){await db();const u=new URL(req.url),id=u.searchParams.get(\"id\")||\"\";if(!id)return new Response(\"Missing project id\",{status:400});const p:any=(await sqlite.execute({sql:`SELECT * FROM service_tickets WHERE id=?`,args:[id]})).rows[0];if(!p)return new Response(\"Project not found\",{status:404});if(req.method===\"POST\"){let b:any;try{b=await req.json()}catch{return Response.json({error:\"Invalid request\"},{status:400})}const keys=[\"scope_summary\",\"deliverables\",\"inclusions\",\"exclusions\",\"assumptions\",\"acceptance_criteria\",\"dependencies\",\"build_plan\",\"scope_decision\",\"reviewer\"],missing=keys.filter(k=>!String(b[k]??\"\").trim());if(missing.length)return Response.json({error:\"Complete every scope field\",missing},{status:400});const now=new Date().toISOString();await sqlite.execute({sql:`INSERT INTO project_scopes VALUES (?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT(project_id) DO UPDATE SET scope_summary=excluded.scope_summary,deliverables=excluded.deliverables,inclusions=excluded.inclusions,exclusions=excluded.exclusions,assumptions=excluded.assumptions,acceptance_criteria=excluded.acceptance_criteria,dependencies=excluded.dependencies,build_plan=excluded.build_plan,scope_decision=excluded.scope_decision,reviewer=excluded.reviewer,updated_at=excluded.updated_at`,args:[id,...keys.map(k=>String(b[k]??\"\").trim()),now]});if(String(b.scope_decision)===\"Approved for build\")await sqlite.execute({sql:`UPDATE service_tickets SET status=? WHERE id=? AND status IN ('scope_review','diagnosis')`,args:[\"approved_for_build\",id]});return Response.json({ok:true,projectId:id,scopeDecision:b.scope_decision,updatedAt:now})}const r:any=(await sqlite.execute({sql:`SELECT * FROM project_scopes WHERE project_id=?`,args:[id]})).rows[0]||{};const fields=[['scope_summary','Scope summary'],['deliverables','Deliverables'],['inclusions','Inclusions'],['exclusions','Exclusions'],['assumptions','Assumptions'],['acceptance_criteria','Acceptance criteria'],['dependencies','Dependencies'],['build_plan','Build plan']];return new Response(`5MC Scope Review

5MC PERFORMANCE / SCOPE

${esc(p.id)}

${esc(p.organization)}

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

Objective: ${esc(p.objective)}

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

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

`,{headers})}","deleted",false,"label",[14],"c811235d-7399-47c7-914a-5abcdc76c707",["D",1788016624119],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","5MC service execution engine hub","imageUrl","userId","1066b61b-f70a-46a7-8125-91c596378659","pinnedFileId","b0dc8e0e-a3bc-11f1-9c56-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a02a5a-86ef-7312-9a9e-ddcd707af361","tursoName","c811235d739947c7914a5abcdc76c707","tursoHostname","c811235d739947c7914a5abcdc76c707-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789492855745],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":101},"org",{"_9":10,"_98":99,"_100":101,"_55":56,"_102":103,"_104":42},"branch",{"_35":88,"_11":89,"_22":28,"_90":45,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned",106,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Aurorin Magazine","avatar","https://lh3.googleusercontent.com/a/ACg8ocJ8i2UIZrlsQap-nn3UPmSBKMkeYfBAHCiy5Y-K4y1DhFt-Bh4=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":36,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":89,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]