Housing Resource Manager

\n \n

\n \n \n \n

Name	Address	Phone	Website	Status	Verified	Actions

\n\n\n\n\n\n\n\n\n\n\n",[107],"f05233a8-191e-4a78-b9de-1e753b745931",["D",1783452966213],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type Category =\n | \"Properties & Management Companies\"\n | \"Private Landlord List\"\n | \"Transitional Housing Group Homes\"\n | \"Assisted Living\"\n | \"Unsuitable Landlords\";\n\nexport const CATEGORIES: Category[] = [\n \"Properties & Management Companies\",\n \"Private Landlord List\",\n \"Transitional Housing Group Homes\",\n \"Assisted Living\",\n \"Unsuitable Landlords\",\n];\n\nexport interface Resource {\n id?: number;\n category: Category;\n name: string;\n address: string;\n city: string;\n state: string;\n zip: string;\n phone: string;\n website: string;\n email: string;\n notes: string;\n status: string;\n last_verified: string;\n created_at?: string;\n updated_at?: string;\n}\n\nexport interface UnsuitableUpdate {\n id?: number;\n resource_id: number;\n team_member: string;\n update_text: string;\n created_at?: string;\n}\n\n// Initialize database tables\nexport async function initDB() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS resources (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n category TEXT NOT NULL,\n name TEXT NOT NULL,\n address TEXT DEFAULT '',\n city TEXT DEFAULT '',\n state TEXT DEFAULT '',\n zip TEXT DEFAULT '',\n phone TEXT DEFAULT '',\n website TEXT DEFAULT '',\n email TEXT DEFAULT '',\n notes TEXT DEFAULT '',\n status TEXT DEFAULT 'active',\n last_verified TEXT DEFAULT '',\n created_at TEXT DEFAULT (datetime('now')),\n updated_at TEXT DEFAULT (datetime('now'))\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS unsuitable_updates (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n resource_id INTEGER NOT NULL,\n team_member TEXT NOT NULL,\n update_text TEXT NOT NULL,\n created_at TEXT DEFAULT (datetime('now')),\n FOREIGN KEY (resource_id) REFERENCES resources(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions (\n token TEXT PRIMARY KEY,\n created_at TEXT DEFAULT (datetime('now')),\n expires_at TEXT NOT NULL\n )\n `);\n}\n\n// --- Resource CRUD ---\n\nexport async function getResources(category?: string): Promise {\n await initDB();\n if (category) {\n const result = await sqlite.execute({\n sql: `SELECT * FROM resources WHERE category = ? ORDER BY name`,\n args: [category],\n });\n return result.rows as unknown as Resource[];\n }\n const result = await sqlite.execute(`SELECT * FROM resources ORDER BY category, name`);\n return result.rows as unknown as Resource[];\n}\n\nexport async function getResource(id: number): Promise {\n await initDB();\n const result = await sqlite.execute({\n sql: `SELECT * FROM resources WHERE id = ?`,\n args: [id],\n });\n const rows = result.rows as unknown as Resource[];\n return rows[0] ?? null;\n}\n\nexport async function createResource(r: Resource): Promise {\n await initDB();\n const result = await sqlite.execute({\n sql: `INSERT INTO resources (category, name, address, city, state, zip, phone, website, email, notes, status, last_verified)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [r.category, r.name, r.address, r.city, r.state, r.zip, r.phone, r.website, r.email, r.notes, r.status, r.last_verified],\n });\n return result.lastInsertRowid as number;\n}\n\nexport async function updateResource(id: number, r: Partial): Promise {\n await initDB();\n const fields: string[] = [];\n const args: (string | number)[] = [];\n for (const [key, value] of Object.entries(r)) {\n if (key === \"id\" || key === \"created_at\") continue;\n fields.push(`${key} = ?`);\n args.push(value as string | number);\n }\n fields.push(`updated_at = datetime('now')`);\n args.push(id);\n await sqlite.execute({\n sql: `UPDATE resources SET ${fields.join(\", \")} WHERE id = ?`,\n args,\n });\n}\n\nexport async function deleteResource(id: number): Promise {\n await initDB();\n await sqlite.execute({ sql: `DELETE FROM unsuitable_updates WHERE resource_id = ?`, args: [id] });\n await sqlite.execute({ sql: `DELETE FROM resources WHERE id = ?`, args: [id] });\n}\n\n// --- Unsuitable Updates ---\n\nexport async function getUnsuitableUpdates(resourceId: number): Promise {\n await initDB();\n const result = await sqlite.execute({\n sql: `SELECT * FROM unsuitable_updates WHERE resource_id = ? ORDER BY created_at DESC`,\n args: [resourceId],\n });\n return result.rows as unknown as UnsuitableUpdate[];\n}\n\nexport async function addUnsuitableUpdate(u: UnsuitableUpdate): Promise {\n await initDB();\n const result = await sqlite.execute({\n sql: `INSERT INTO unsuitable_updates (resource_id, team_member, update_text) VALUES (?, ?, ?)`,\n args: [u.resource_id, u.team_member, u.update_text],\n });\n return result.lastInsertRowid as number;\n}\n\n// --- CSV Export ---\n\nexport async function exportCSV(category?: string): Promise {\n const resources = await getResources(category);\n const headers = [\"ID\", \"Category\", \"Name\", \"Address\", \"City\", \"State\", \"ZIP\", \"Phone\", \"Website\", \"Email\", \"Notes\", \"Status\", \"Last Verified\", \"Updated At\"];\n const rows = resources.map((r) =>\n [r.id, r.category, r.name, r.address, r.city, r.state, r.zip, r.phone, r.website, r.email, r.notes, r.status, r.last_verified, r.updated_at]\n .map((v) => `\"${String(v ?? \"\").replace(/\"/g, '\"\"')}\"`)\n .join(\",\")\n );\n return [headers.join(\",\"), ...rows].join(\"\\n\");\n}\n\n// --- CSV Import (from Google Sheets export) ---\n\nexport async function importCSV(csvText: string): Promise<{ imported: number; errors: string[] }> {\n await initDB();\n const lines = csvText.split(\"\\n\").filter((l) => l.trim());\n const errors: string[] = [];\n let imported = 0;\n\n // Skip header row\n for (let i = 1; i < lines.length; i++) {\n try {\n const cols = parseCSVLine(lines[i]);\n if (cols.length < 3) continue;\n\n const category = cols[1] || cols[0]; // Try to match category from either position\n const name = cols[2] || cols[1];\n if (!name) continue;\n\n await sqlite.execute({\n sql: `INSERT INTO resources (category, name, address, city, state, zip, phone, website, email, notes, status, last_verified)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\n category,\n name,\n cols[3] || \"\",\n cols[4] || \"\",\n cols[5] || \"\",\n cols[6] || \"\",\n cols[7] || \"\",\n cols[8] || \"\",\n cols[9] || \"\",\n cols[10] || \"\",\n cols[11] || \"active\",\n cols[12] || \"\",\n ],\n });\n imported++;\n } catch (e) {\n errors.push(`Row ${i + 1}: ${e.message}`);\n }\n }\n return { imported, errors };\n}\n\nfunction parseCSVLine(line: string): string[] {\n const result: string[] = [];\n let current = \"\";\n let inQuotes = false;\n for (let i = 0; i < line.length; i++) {\n const char = line[i];\n if (char === '\"') {\n if (inQuotes && line[i + 1] === '\"') {\n current += '\"';\n i++;\n } else {\n inQuotes = !inQuotes;\n }\n } else if (char === \",\" && !inQuotes) {\n result.push(current);\n current = \"\";\n } else {\n current += char;\n }\n }\n result.push(current);\n return result.map((s) => s.trim().replace(/^\"|\"$/g, \"\"));\n}\n",[63],"e24ca1cd-7928-4a71-9339-638e00b4ee77",["D",1783452974021],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst SESSION_DURATION_HOURS = 12;\n\n// Create a session token after successful login\nexport async function createSession(): Promise {\n const token = crypto.randomUUID() + crypto.randomUUID();\n const expiresAt = new Date(Date.now() + SESSION_DURATION_HOURS * 60 * 60 * 1000).toISOString();\n await sqlite.execute({\n sql: `INSERT INTO sessions (token, expires_at) VALUES (?, ?)`,\n args: [token, expiresAt],\n });\n return token;\n}\n\n// Verify a session token from the Authorization header\nexport async function verifySession(authHeader: string | null): Promise {\n if (!authHeader) return false;\n const token = authHeader.replace(\"Bearer \", \"\");\n if (!token) return false;\n\n const result = await sqlite.execute({\n sql: `SELECT * FROM sessions WHERE token = ? AND expires_at > datetime('now')`,\n args: [token],\n });\n return result.rows.length > 0;\n}\n\n// Check password against env var\nexport function checkPassword(password: string): boolean {\n const teamPassword = Deno.env.get(\"TEAM_PASSWORD\");\n if (!teamPassword) return false;\n return password === teamPassword;\n}\n\n// Delete a session (logout)\nexport async function deleteSession(token: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM sessions WHERE token = ?`,\n args: [token],\n });\n}\n\n// Clean up expired sessions (called periodically)\nexport async function cleanupSessions(): Promise {\n await sqlite.execute(`DELETE FROM sessions WHERE expires_at < datetime('now')`);\n}\n",[78],"pulls","branches","forks","envVars",{"_218":20,"_220":20},"connections",{"_218":20,"_219":20},"count","unfilledCount","emptyCount",{"_31":207,"_13":78,"_61":77,"_41":-5,"_33":34,"_188":72,"_189":120,"_35":239,"_37":20,"_64":65,"_191":209,"_66":24,"_193":-5,"_227":240,"_160":241},{"_31":203,"_13":63,"_61":62,"_41":-5,"_33":34,"_188":38,"_189":120,"_35":236,"_37":20,"_64":65,"_191":205,"_66":24,"_193":-5,"_227":237,"_160":238},{"_31":199,"_13":107,"_61":106,"_41":-5,"_33":34,"_188":101,"_189":120,"_35":233,"_37":20,"_64":52,"_191":201,"_66":24,"_193":-5,"_227":234,"_160":235},{"_31":195,"_13":87,"_61":86,"_41":-5,"_33":34,"_188":81,"_189":120,"_35":230,"_37":20,"_64":88,"_191":197,"_66":24,"_193":-5,"_227":231,"_160":232},{"_31":187,"_13":97,"_61":96,"_41":-5,"_33":34,"_188":91,"_189":120,"_35":226,"_37":20,"_64":98,"_191":192,"_66":24,"_193":-5,"_227":228,"_160":229},["D",1783453078486],"children",[],[97],["D",1783453077944],[],[87],["D",1783453271548],[],[107],["D",1783452966213],[],[63],["D",1783452974021],[],[78],["D",1783452899835],["D",1789492268774],{"_11":12,"_159":69},{"_11":12,"_154":155,"_68":69,"_25":67,"_156":157,"_158":24},{"_37":101,"_13":16,"_31":34,"_146":108,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":14,"_153":12},"ctx",{"_50":-5,"_179":280,"_281":282,"_283":284,"_285":24,"_286":24,"_287":24,"_288":120,"_289":-5,"_290":-7,"_291":-7,"_292":20,"_293":24,"_294":24,"_295":-5,"_296":24,"_297":24,"_298":24,"_299":-5},"ENV",{"_251":252,"_253":254,"_255":16,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

🏠 Housing Resource Manager

🏠 Housing Resource Manager

Add Resource

Import CSV from Google Sheets

Unsuitable Landlord Updates

History