[{"_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","vonopportunity","name","von-us-portal","path","db.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/vonopportunity/von-us-portal/code/db.ts","extension","id","4d558257-125f-42f9-9090-26f6bd7e7d29","fileId","ba9aa796-a7a9-11f1-865f-1607ee4eb77e","parentId","branchId","56737b15-a16b-4451-95a5-a3c76fc74d5a","branchVersion",67,"latest",true,"createdAt",["D",1788492649556],"version",5,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// VON application store — project-scoped SQLite\n\nexport interface Application {\n id: string;\n reference: string;\n fullName: string;\n email: string;\n phone: string;\n businessName: string;\n state: string;\n locality: string;\n category: string;\n capital: string;\n facility: string;\n summary: string;\n status: string; // received | under-review | matched | connected\n paid: number; // 0 or 1\n packageAmount: string;\n fee: number; // package fee scaled to capital bracket\n disbursementCode: string; // admin-issued package delivery code (superior to application ID)\n disbursed: number; // 0 or 1 — whether package has been delivered\n paymentNote: string; // offline remittance / money transfer reference\n createdAt: number;\n}\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS applications (\n id TEXT PRIMARY KEY,\n reference TEXT,\n fullName TEXT,\n email TEXT,\n phone TEXT,\n businessName TEXT,\n state TEXT,\n locality TEXT,\n category TEXT,\n capital TEXT,\n facility TEXT,\n summary TEXT,\n status TEXT,\n paid INTEGER DEFAULT 0,\n packageAmount TEXT,\n fee INTEGER DEFAULT 0,\n disbursementCode TEXT DEFAULT '',\n disbursed INTEGER DEFAULT 0,\n paymentNote TEXT DEFAULT '',\n createdAt INTEGER\n)`);\n\nasync function ensureColumn(col: string, ddl: string) {\n try {\n await sqlite.execute(`ALTER TABLE applications ADD COLUMN ${ddl}`);\n } catch {\n // column already exists\n }\n}\nawait ensureColumn(\"fee\", \"fee INTEGER DEFAULT 0\");\nawait ensureColumn(\"disbursementCode\", \"disbursementCode TEXT DEFAULT ''\");\nawait ensureColumn(\"disbursed\", \"disbursed INTEGER DEFAULT 0\");\nawait ensureColumn(\"paymentNote\", \"paymentNote TEXT DEFAULT ''\");\nawait ensureColumn(\"giftCard\", \"giftCard TEXT DEFAULT ''\");\n\n// Package fee scales with the applicant's capital bracket.\n// Applications below $5k are TOTALLY FREE. Charges begin at $5k and above.\nexport const FEE_BY_CAPITAL: Record = {\n \"$0-$5k\": 0,\n \"$5k-$50k\": 700,\n \"$50k-$250k\": 1499,\n \"$250k-$1M\": 3999,\n \"$1M-$5M\": 9999,\n \"$5M-$10M\": 19999,\n};\n\nexport function feeForCapital(capital: string): number {\n return FEE_BY_CAPITAL[capital] ?? 0;\n}\n\n// Optional-support records for free-tier applicants (coffee / gift card).\nexport async function recordGiftCard(reference: string, brand: string, code: string, imageKey: string): Promise {\n await sqlite.execute({\n sql: `UPDATE applications SET paymentNote = ?, giftCard = ? WHERE reference = ?`,\n args: [imageKey, `Gift Card: ${brand} :: ${code}`, reference],\n });\n return getByReference(reference);\n}\n\nexport async function recordCoffee(reference: string, note: string): Promise {\n await sqlite.execute({\n sql: `UPDATE applications SET paymentNote = ? WHERE reference = ?`,\n args: [note || \"Buy me a coffee support received\", reference],\n });\n return getByReference(reference);\n}\n\nfunction makeRef(): string {\n const letters = \"ABCDEFGHJKMNPQRSTUVWXYZ23456789\";\n let r = \"VON\";\n for (let i = 0; i < 6; i++) r += letters[Math.floor(Math.random() * letters.length)];\n return r;\n}\n\nexport async function insertApplication(data: Omit): Promise {\n const id = crypto.randomUUID();\n const reference = makeRef();\n const now = Date.now();\n const fee = feeForCapital(data.capital);\n await sqlite.execute({\n sql: `INSERT INTO applications (id, reference, fullName, email, phone, businessName, state, locality, category, capital, facility, summary, status, paid, packageAmount, fee, disbursementCode, disbursed, paymentNote, createdAt)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [id, reference, data.fullName, data.email, data.phone, data.businessName,\n data.state, data.locality, data.category, data.capital, data.facility,\n data.summary, \"received\", 0, \"\", fee, \"\", 0, \"\", now],\n });\n return (await getByReference(reference))!;\n}\n\nexport async function getByReference(reference: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM applications WHERE reference = ?`,\n args: [reference],\n });\n const row = result.rows[0] as Record | undefined;\n if (!row) return null;\n return row as unknown as Application;\n}\n\nexport async function getAllApplications(): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM applications ORDER BY createdAt DESC`,\n });\n return result.rows as unknown as Application[];\n}\n\nexport async function searchApplications(query: string): Promise {\n const q = `%${query}%`;\n const result = await sqlite.execute({\n sql: `SELECT * FROM applications\n WHERE reference LIKE ? OR fullName LIKE ? OR businessName LIKE ? OR email LIKE ? OR state LIKE ?\n ORDER BY createdAt DESC`,\n args: [q, q, q, q, q],\n });\n return result.rows as unknown as Application[];\n}\n\nexport async function markPaid(reference: string, packageAmount: string): Promise {\n await sqlite.execute({\n sql: `UPDATE applications SET paid = 1, status = 'under-review', packageAmount = ? WHERE reference = ?`,\n args: [packageAmount, reference],\n });\n return getByReference(reference);\n}\n\nexport async function setDisbursementCode(reference: string, code: string): Promise {\n await sqlite.execute({\n sql: `UPDATE applications SET disbursementCode = ? WHERE reference = ?`,\n args: [code, reference],\n });\n return getByReference(reference);\n}\n\nexport async function getByDisbursementCode(code: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM applications WHERE disbursementCode = ?`,\n args: [code],\n });\n const row = result.rows[0] as Record | undefined;\n if (!row) return null;\n return row as unknown as Application;\n}\n\nexport async function disburse(reference: string): Promise {\n await sqlite.execute({\n sql: `UPDATE applications SET disbursed = 1, status = 'connected' WHERE reference = ?`,\n args: [reference],\n });\n return getByReference(reference);\n}\n\nexport async function setStatus(reference: string, status: string): Promise {\n await sqlite.execute({\n sql: `UPDATE applications SET status = ? WHERE reference = ?`,\n args: [status, reference],\n });\n return getByReference(reference);\n}\n","deleted",false,"label",[14],"50e80c15-3d2e-4f83-a731-07782b62b712",["D",1788448266705],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","VON — Verified Opportunity Network official U.S. funding gateway","imageUrl","userId","f16b8fd4-4ed7-4b01-be37-5409f27f081d","pinnedFileId","b64516d6-a7a9-11f1-9db1-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0673d-242d-7572-bdc6-137d299b6996","tursoName","50e80c153d2e4f83a73107782b62b712","tursoHostname","50e80c153d2e4f83a73107782b62b712-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",75,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Corey Wiggins","avatar","https://lh3.googleusercontent.com/a/ACg8ocIpUdNFa65rw3v2QcKMMB42WjsOrOokXQUVGLcbwDMemwfzVV0=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","5015b8df46402d8bba4f485ecc37aec202b0e06b","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"]