NEXUS SCHOOL OS

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","alizhan0818","name","nexus-school-os","path","index.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_59":-5,"_60":-5,"_61":62,"_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/alizhan0818/nexus-school-os/code/index.ts","extension","id","03163139-2ca1-42f0-9228-472822cf42f1","fileId","01a081fe-8a60-7580-867f-1fc231bac9ef","parentId","branchId","eba0ae0b-c46f-4d1f-8076-2d4e48288fc4","branchVersion",9,"latest",true,"createdAt",["D",1788887544248],"version",8,"fileType","http","content","import { Hono } from \"npm:hono\";\nimport { cors } from \"npm:hono/cors\";\nimport { sqlite as db } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst app = new Hono();\napp.use(\"*\", cors());\n\nconst q = async (strings: TemplateStringsArray, ...values: unknown[]) => {\n const sql = strings.reduce((out, s, i) => out + s + (i < values.length ? \"?\" : \"\"), \"\");\n return db.execute({ sql, args: values as any[] });\n};\n\nawait q`CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT UNIQUE NOT NULL, pin_hash TEXT NOT NULL, balance INTEGER NOT NULL DEFAULT 100000, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`;\nawait q`CREATE TABLE IF NOT EXISTS transactions (id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, kind TEXT NOT NULL, amount INTEGER NOT NULL, note TEXT, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`;\nawait q`CREATE TABLE IF NOT EXISTS notes (id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, title TEXT NOT NULL, body TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`;\n\nconst hash = async (s:string) => {\n const b = await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(s));\n return [...new Uint8Array(b)].map(x=>x.toString(16).padStart(2,\"0\")).join(\"\");\n};\nconst json = (c:any, data:any, status=200) => c.json(data,status);\n\napp.get(\"/api/health\", c => json(c,{ok:true,app:\"NEXUS SCHOOL OS\",version:\"1.0\"}));\n\napp.post(\"/api/register\", async c => {\n const {name,pin}=await c.req.json();\n if(!name || !/^\\\\d{4,8}$/.test(String(pin))) return json(c,{error:\"Имя и PIN 4–8 цифр обязательны\"},400);\n try {\n const r=await q`INSERT INTO users (name,pin_hash) VALUES (${String(name).trim()},${await hash(String(pin))}) RETURNING id,name,balance`;\n return json(c,{user:r.rows[0]});\n } catch { return json(c,{error:\"Пользователь уже существует\"},409); }\n});\n\napp.post(\"/api/login\", async c => {\n const {name,pin}=await c.req.json();\n const r=await q`SELECT id,name,balance FROM users WHERE name=${String(name||\"\").trim()} AND pin_hash=${await hash(String(pin||\"\"))}`;\n return r.rows.length ? json(c,{user:r.rows[0]}) : json(c,{error:\"Неверные данные\"},401);\n});\n\napp.get(\"/api/dashboard\", async c => {\n const id=Number(c.req.query(\"user_id\"));\n const u=await q`SELECT id,name,balance,created_at FROM users WHERE id=${id}`;\n if(!u.rows.length) return json(c,{error:\"Пользователь не найден\"},404);\n const tx=await q`SELECT id,kind,amount,note,created_at FROM transactions WHERE user_id=${id} ORDER BY id DESC LIMIT 12`;\n const notes=await q`SELECT id,title,body,created_at FROM notes WHERE user_id=${id} ORDER BY id DESC LIMIT 20`;\n return json(c,{user:u.rows[0],transactions:tx.rows,notes:notes.rows});\n});\n\napp.post(\"/api/payment\", async c => {\n const {user_id,amount,note}=await c.req.json();\n const id=Number(user_id), n=Math.floor(Number(amount));\n if(!Number.isFinite(n)||n<=0||n>100000000) return json(c,{error:\"Некорректная сумма\"},400);\n const u=await q`SELECT balance FROM users WHERE id=${id}`;\n if(!u.rows.length) return json(c,{error:\"Пользователь не найден\"},404);\n if(Number(u.rows[0].balance) {\n const {user_id,amount}=await c.req.json();\n const id=Number(user_id), n=Math.floor(Number(amount));\n if(!Number.isFinite(n)||n<=0||n>100000000) return json(c,{error:\"Некорректная сумма\"},400);\n await q`UPDATE users SET balance=balance+${n} WHERE id=${id}`;\n await q`INSERT INTO transactions(user_id,kind,amount,note) VALUES(${id},'topup',${n},'Учебное пополнение')`;\n const u=await q`SELECT balance FROM users WHERE id=${id}`;\n return json(c,{ok:true,balance:u.rows[0]?.balance});\n});\n\napp.post(\"/api/notes\", async c => {\n const {user_id,title,body}=await c.req.json();\n if(!user_id||!title||!body) return json(c,{error:\"Заполните все поля\"},400);\n const r=await q`INSERT INTO notes(user_id,title,body) VALUES(${Number(user_id)},${String(title).slice(0,120)},${String(body).slice(0,5000)}) RETURNING *`;\n return json(c,{note:r.rows[0]});\n});\n\nconst page=`NEXUS SCHOOL OS

`;\napp.get(\"/\", c => c.html(page));\nexport default app.fetch;","deleted",false,"label",[14],"1f47a200-9cf4-407d-a3ec-38056e90de65",["D",1788887337369],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Учебная интеллектуальная система с виртуальными платежами","imageUrl","userId","6fbccba7-1304-452e-9c47-63a82b93ab80","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a07777-e619-74c3-b583-4fbaca18818a","tursoName","1f47a2009cf4407da3ec38056e90de65","tursoHostname","1f47a2009cf4407da3ec38056e90de65-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789495880338],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_104":100},"org",{"_9":10,"_97":98,"_99":100,"_55":56,"_101":102,"_103":42},"branch",{"_35":30,"_11":88,"_22":28,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":12,"_96":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Алижан","avatar","https://lh3.googleusercontent.com/a/ACg8ocJCKDI1euTzxy69SEJ3KYyrMIx0Lsefabw9acb-nqWJ6PtpYA=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":62,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":88,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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"]