[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_107":108,"_109":110},"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","finding-actions.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":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":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/finding-actions.ts","extension","id","24eef7a6-63e2-492e-8046-00f5099970ef","fileId","ee89546c-a542-11f1-9edd-1607ee4eb77e","parentId","branchId","2ab34335-fa22-4373-a1af-bdcbf80ff8f6","branchVersion",44,"latest",true,"createdAt",["D",1788185140285],"version",1,"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 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

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})}","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",0,"orgId","01a02a5a-86ef-7312-9a9e-ddcd707af361","tursoName","c811235d739947c7914a5abcdc76c707","tursoHostname","c811235d739947c7914a5abcdc76c707-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789579303050],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_106":102},"org",{"_9":10,"_99":100,"_101":102,"_55":56,"_103":104,"_105":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":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",{"_82":-5,"_140":141,"_142":143,"_144":145,"_146":42,"_147":42,"_148":42,"_149":32,"_150":-5,"_151":-7,"_152":-7,"_153":63,"_154":42,"_155":42,"_156":-5,"_157":42,"_158":42,"_159":42,"_160":-5},"ENV",{"_111":112,"_113":114,"_115":90,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137,"_138":139},"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"]