[{"_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","digital-implementation.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/digital-implementation.ts","extension","id","dd171f01-4670-4ca5-819b-5e6f62353542","fileId","93c59580-a54d-11f1-81b5-1607ee4eb77e","parentId","branchId","2ab34335-fa22-4373-a1af-bdcbf80ff8f6","branchVersion",67,"latest",true,"createdAt",["D",1788188803531],"version",0,"fileType","http","content","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

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})}","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","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]