5MC Operations

[{"_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","operations.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/operations.ts","extension","id","33b33150-f6d9-472c-8d62-bfd6967a39fa","fileId","d420f2c2-a526-11f1-83a1-1607ee4eb77e","parentId","branchId","2ab34335-fa22-4373-a1af-bdcbf80ff8f6","branchVersion",18,"latest",true,"createdAt",["D",1788172181339],"version",2,"fileType","http","content","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)}","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",1789492855745],"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","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"]