[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_93":92,"_31":44,"_101":83,"_26":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":24,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":76,"_77":78,"_79":80,"_81":24},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/routes/users.ts","latestPath","fileId","230977fa-3459-11f0-b9e4-9e149126039e","name","users.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getAllUsers, \n getUserById, \n createUser \n} from \"../database/queries.ts\";\nimport * as bcrypt from \"https://esm.sh/bcryptjs@2.4.3\";\n\nconst app = new Hono();\n\n// Get all users\napp.get(\"/\", async (c) => {\n try {\n const users = await getAllUsers();\n return c.json(users);\n } catch (error) {\n console.error(\"Error fetching users:\", error);\n return c.json({ error: \"Failed to fetch users\" }, 500);\n }\n});\n\n// Get user by ID\napp.get(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid user ID\" }, 400);\n }\n \n try {\n const user = await getUserById(id);\n \n if (!user) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n return c.json(user);\n } catch (error) {\n console.error(`Error fetching user ${id}:`, error);\n return c.json({ error: \"Failed to fetch user\" }, 500);\n }\n});\n\n// Create new user\napp.post(\"/\", async (c) => {\n try {\n const userData = await c.req.json();\n \n // Validate required fields\n if (!userData.email || !userData.password || !userData.name || !userData.phone) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n // Check if email already exists\n const existingUser = await getUserById(userData.email);\n if (existingUser) {\n return c.json({ error: \"Email already in use\" }, 409);\n }\n \n // Hash password\n const passwordHash = await bcrypt.hash(userData.password, 10);\n \n // Create user\n const userId = await createUser({\n email: userData.email,\n name: userData.name,\n phone: userData.phone,\n role: userData.role || [\"member\"],\n memberSince: userData.memberSince || new Date().toISOString().split('T')[0],\n pilotRatings: userData.pilotRatings,\n towPilotQualified: userData.towPilotQualified || false,\n emergencyContact: userData.emergencyContact\n }, passwordHash);\n \n const newUser = await getUserById(userId);\n return c.json(newUser, 201);\n } catch (error) {\n console.error(\"Error creating user:\", error);\n return c.json({ error: \"Failed to create user\" }, 500);\n }\n});\n\n// Update user\napp.put(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid user ID\" }, 400);\n }\n \n try {\n const userData = await c.req.json();\n const existingUser = await getUserById(id);\n \n if (!existingUser) {\n return c.json({ error: \"User not found\" }, 404);\n }\n \n // Update user in database\n await c.env.sqlite.execute(\n `UPDATE glider_users_v1 SET\n name = ?, phone = ?, pilot_ratings = ?, tow_pilot_qualified = ?,\n emergency_contact_name = ?, emergency_contact_phone = ?, emergency_contact_relationship = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n [\n userData.name || existingUser.name,\n userData.phone || existingUser.phone,\n userData.pilotRatings ? userData.pilotRatings.join(',') : existingUser.pilotRatings?.join(','),\n userData.towPilotQualified !== undefined ? (userData.towPilotQualified ? 1 : 0) : (existingUser.towPilotQualified ? 1 : 0),\n userData.emergencyContact?.name || existingUser.emergencyContact?.name,\n userData.emergencyContact?.phone || existingUser.emergencyContact?.phone,\n userData.emergencyContact?.relationship || existingUser.emergencyContact?.relationship,\n id\n ]\n );\n \n // Update roles if provided\n if (userData.role && Array.isArray(userData.role)) {\n // Delete existing roles\n await c.env.sqlite.execute(\n `DELETE FROM glider_user_roles_v1 WHERE user_id = ?`,\n [id]\n );\n \n // Insert new roles\n for (const role of userData.role) {\n await c.env.sqlite.execute(\n `INSERT INTO glider_user_roles_v1 (user_id, role) VALUES (?, ?)`,\n [id, role]\n );\n }\n }\n \n const updatedUser = await getUserById(id);\n return c.json(updatedUser);\n } catch (error) {\n console.error(`Error updating user ${id}:`, error);\n return c.json({ error: \"Failed to update user\" }, 500);\n }\n});\n\nexport const userRoutes = app;","createdAt",["D",1747621789297],"branchVersion","branchId","88adfa46-3458-11f0-a04d-9e149126039e","id","88adccf6-3458-11f0-a04d-9e149126039e","Gliderops",["D",1747621530332],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","edf04d00-e0ac-11ef-b589-bf0d59e1abdf","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","c9388b01-c598-4d0f-bacb-e146aba80959","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},"branch",{"_13":82,"_31":83,"_42":41,"_84":43,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":44,"_91":92},"isOwned",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jasonr","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJzUmNXSXVCcGRvd0FvMjlRcGo5aVRvRFppdiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":235,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":236,"_77":237,"_79":238,"_81":24},"tree",[160,168,170],"files",[160,161,162,163,164,165,166,167,168,169,170],"counts",{"_150":59,"_151":130,"_152":59,"_153":154,"_155":156},"contents",[123,124,125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":144,"_31":145,"_29":146,"_129":-5,"_40":41,"_39":147,"_131":132,"_37":148,"_13":59,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":149},{"_42":137,"_31":138,"_29":139,"_129":-5,"_40":41,"_39":140,"_131":132,"_37":141,"_13":59,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":143},{"_42":126,"_31":127,"_29":128,"_129":-5,"_40":41,"_39":130,"_131":132,"_37":133,"_13":59,"_33":20,"_35":134,"_23":24,"_135":-5,"_26":136},"cb378b84-3458-11f0-b747-9e149126039e","README.md","cb378c42-3458-11f0-b747-9e149126039e","parentId",1,"latest",true,["D",1747621641959],"# Glider Tow Operation Management System\n\nA comprehensive web application for managing a glider tow operation, including scheduling, billing, aircraft maintenance, and member information.\n\n## Features\n\n- **User Management**\n - Member profiles and qualifications\n - Pilot certification tracking (glider pilots and tow pilots)\n - Admin dashboard\n\n- **Scheduling System**\n - Flight booking calendar\n - Pilot and aircraft availability\n - Weather integration and alerts\n\n- **Aircraft Management**\n - Aircraft inventory and status\n - Maintenance tracking and scheduling\n - Flight logs\n\n- **Billing System**\n - Flight cost calculation\n - Member billing history\n - Payment processing\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/ # SQLite database setup and queries\n│ ├── routes/ # API endpoints\n│ └── index.ts # Main entry point\n├── frontend/\n│ ├── components/ # React components\n│ ├── pages/ # Page layouts\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript interfaces\n```\n\n## Getting Started\n\n1. Visit the application URL\n2. Log in with your credentials\n3. Navigate to the desired section (Schedule, Aircraft, Billing, etc.)\n\n## Technology Stack\n\n- Backend: Hono.js (TypeScript)\n- Frontend: React with TailwindCSS\n- Database: SQLite\n- Authentication: JWT-based auth","label",[127],"d34cc55a-3458-11f0-a3d7-9e149126039e","shared","95e67a57-b221-4b11-b8e2-8657177fd21d",2,["D",1747621655502],"directory",[138],"eb77d476-3458-11f0-8698-9e149126039e","backend","a5d5f9a3-e2ea-48a2-8317-3c17226ecfaf",3,["D",1747621696065],[145],"pulls","branches","forks","envVars",{"_157":59,"_159":59},"connections",{"_157":59,"_158":59},"count","unfilledCount","emptyCount",{"_42":144,"_31":145,"_29":146,"_129":-5,"_40":41,"_39":147,"_131":132,"_37":232,"_13":59,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":233,"_26":234},{"_42":228,"_31":220,"_29":214,"_129":146,"_40":41,"_39":147,"_131":132,"_37":229,"_13":59,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":230,"_26":231},{"_42":221,"_31":222,"_29":223,"_129":214,"_40":41,"_39":147,"_131":132,"_37":224,"_13":59,"_33":34,"_35":225,"_23":24,"_135":-5,"_172":226,"_26":227},{"_42":211,"_31":212,"_29":213,"_129":214,"_40":41,"_39":215,"_131":132,"_37":216,"_13":59,"_33":34,"_35":217,"_23":24,"_135":-5,"_172":218,"_26":219},{"_42":207,"_31":198,"_29":194,"_129":146,"_40":41,"_39":202,"_131":132,"_37":208,"_13":59,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":209,"_26":210},{"_42":199,"_31":200,"_29":201,"_129":194,"_40":41,"_39":202,"_131":132,"_37":203,"_13":59,"_33":34,"_35":204,"_23":24,"_135":-5,"_172":205,"_26":206},{"_42":193,"_31":32,"_29":30,"_129":194,"_40":41,"_39":14,"_131":132,"_37":195,"_13":59,"_33":34,"_35":36,"_23":24,"_135":-5,"_172":196,"_26":197},{"_42":185,"_31":186,"_29":187,"_129":146,"_40":41,"_39":188,"_131":132,"_37":189,"_13":59,"_33":34,"_35":190,"_23":24,"_135":-5,"_172":191,"_26":192},{"_42":137,"_31":138,"_29":139,"_129":-5,"_40":41,"_39":140,"_131":132,"_37":182,"_13":59,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":183,"_26":184},{"_42":175,"_31":176,"_29":177,"_129":139,"_40":41,"_39":140,"_131":132,"_37":178,"_13":59,"_33":34,"_35":179,"_23":24,"_135":-5,"_172":180,"_26":181},{"_42":126,"_31":127,"_29":128,"_129":-5,"_40":41,"_39":130,"_131":132,"_37":171,"_13":59,"_33":20,"_35":134,"_23":24,"_135":-5,"_172":173,"_26":174},["D",1747621641959],"children",[],[127],"d34c9d0a-3458-11f0-a3d7-9e149126039e","types.ts","d34c9dd2-3458-11f0-a3d7-9e149126039e",["D",1747621655502],"// User roles and types\nexport enum UserRole {\n ADMIN = \"admin\",\n TOW_PILOT = \"tow_pilot\",\n GLIDER_PILOT = \"glider_pilot\",\n MEMBER = \"member\",\n}\n\nexport enum PilotRating {\n STUDENT = \"student\",\n PRIVATE = \"private\",\n COMMERCIAL = \"commercial\",\n CFI = \"cfi\", // Certified Flight Instructor\n}\n\nexport interface User {\n id: number;\n email: string;\n name: string;\n phone: string;\n role: UserRole[];\n memberSince: string; // ISO date string\n pilotRatings?: PilotRating[];\n towPilotQualified?: boolean;\n emergencyContact?: {\n name: string;\n phone: string;\n relationship: string;\n };\n}\n\n// Aircraft types\nexport enum AircraftType {\n GLIDER = \"glider\",\n TOW_PLANE = \"tow_plane\",\n}\n\nexport interface Aircraft {\n id: number;\n registration: string; // N-number\n type: AircraftType;\n make: string;\n model: string;\n year: number;\n lastAnnual: string; // ISO date string\n nextAnnual: string; // ISO date string\n totalHours: number;\n status: \"available\" | \"maintenance\" | \"out-of-service\";\n notes?: string;\n}\n\n// Maintenance records\nexport interface MaintenanceRecord {\n id: number;\n aircraftId: number;\n date: string; // ISO date string\n description: string;\n performedBy: string;\n hoursAtService: number;\n type: \"scheduled\" | \"unscheduled\" | \"annual\";\n cost: number;\n completed: boolean;\n notes?: string;\n}\n\n// Flight scheduling\nexport interface FlightBooking {\n id: number;\n date: string; // ISO date string\n startTime: string; // ISO time string\n endTime: string; // ISO time string\n gliderId: number;\n towPlaneId: number;\n gliderPilotId: number;\n towPilotId: number;\n status: \"scheduled\" | \"completed\" | \"cancelled\" | \"no-show\";\n weatherStatus: \"favorable\" | \"marginal\" | \"unfavorable\";\n notes?: string;\n}\n\n// Billing\nexport interface BillingRecord {\n id: number;\n userId: number;\n flightId?: number; // Optional if billing is not flight-related\n date: string; // ISO date string\n amount: number;\n description: string;\n status: \"pending\" | \"paid\" | \"overdue\";\n paymentMethod?: string;\n paymentDate?: string; // ISO date string\n}\n\n// Weather data\nexport interface WeatherData {\n timestamp: string; // ISO date string\n temperature: number;\n windSpeed: number;\n windDirection: number;\n visibility: number;\n cloudCeiling: number;\n conditions: string;\n suitable: boolean; // Whether conditions are suitable for flying\n}",[],[138,176],["D",1747621655502],[169],[138],"0e8b88b8-3459-11f0-b615-9e149126039e","index.ts","0e8b89da-3459-11f0-b615-9e149126039e",5,["D",1747621754920],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { cors } from \"https://esm.sh/hono@3.11.7/middleware\";\nimport { jwt } from \"https://esm.sh/hono@3.11.7/middleware/jwt\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations, insertSampleData } from \"./database/migrations.ts\";\nimport { getUserByEmail } from \"./database/queries.ts\";\n\n// Import route handlers\nimport { userRoutes } from \"./routes/users.ts\";\nimport { aircraftRoutes } from \"./routes/aircraft.ts\";\nimport { maintenanceRoutes } from \"./routes/maintenance.ts\";\nimport { flightRoutes } from \"./routes/flights.ts\";\nimport { billingRoutes } from \"./routes/billing.ts\";\nimport { weatherRoutes } from \"./routes/weather.ts\";\nimport { authRoutes } from \"./routes/auth.ts\";\n\n// Initialize database (comment out for production after first run)\nawait runMigrations();\nawait insertSampleData();\n\n// Create Hono app\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Add CORS middleware\napp.use(cors({\n origin: '*',\n allowHeaders: ['Content-Type', 'Authorization'],\n allowMethods: ['GET', 'POST', 'PUT', 'DELETE', 'OPTIONS'],\n exposeHeaders: ['Content-Length'],\n maxAge: 600,\n}));\n\n// Auth routes (no JWT required)\napp.route(\"/api/auth\", authRoutes);\n\n// JWT middleware for protected routes\napp.use(\"/api/*\", async (c, next) => {\n // Skip JWT check for auth routes and OPTIONS requests\n if (c.req.path.startsWith(\"/api/auth\") || c.req.method === \"OPTIONS\") {\n return next();\n }\n \n const jwtMiddleware = jwt({\n secret: Deno.env.get(\"JWT_SECRET\") || \"glider-tow-secret-key\",\n });\n \n return jwtMiddleware(c, next);\n});\n\n// API routes\napp.route(\"/api/users\", userRoutes);\napp.route(\"/api/aircraft\", aircraftRoutes);\napp.route(\"/api/maintenance\", maintenanceRoutes);\napp.route(\"/api/flights\", flightRoutes);\napp.route(\"/api/billing\", billingRoutes);\napp.route(\"/api/weather\", weatherRoutes);\n\n// Serve frontend files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve index.html for all other routes (SPA support)\napp.get(\"*\", async c => {\n try {\n // Read the HTML file\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Get initial data for bootstrapping the app\n const initialData = {\n apiUrl: \"/api\",\n projectInfo: {\n name: \"Glider Tow Operation Management\",\n version: \"1.0.0\"\n }\n };\n \n // Inject initial data into the HTML\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n \n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index.html:\", error);\n return c.text(\"Error loading application. Please try again later.\", 500);\n }\n});\n\n// Export the Hono app for HTTP val\nexport default app.fetch;",[],[145,186],"2309773c-3459-11f0-b9e4-9e149126039e","4cdc63d4-e857-41be-bdd1-de049653f26e",["D",1747621789297],[],[145,198,32],"routes","15a6926e-3459-11f0-b8d7-9e149126039e","auth.ts","15a69318-3459-11f0-b8d7-9e149126039e",6,["D",1747621766788],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sign } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { getUserByEmail } from \"../database/queries.ts\";\nimport * as bcrypt from \"https://esm.sh/bcryptjs@2.4.3\";\n\nconst app = new Hono();\n\n// Login endpoint\napp.post(\"/login\", async (c) => {\n const { email, password } = await c.req.json();\n \n if (!email || !password) {\n return c.json({ error: \"Email and password are required\" }, 400);\n }\n \n try {\n // Get user by email\n const user = await getUserByEmail(email);\n \n if (!user) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Get password hash from database\n const result = await c.env.sqlite.execute(\n `SELECT password_hash FROM glider_users_v1 WHERE email = ?`,\n [email]\n );\n \n if (result.rows.length === 0) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n const passwordHash = result.rows[0].password_hash;\n \n // Compare password\n const isPasswordValid = await bcrypt.compare(password, passwordHash);\n \n if (!isPasswordValid) {\n return c.json({ error: \"Invalid email or password\" }, 401);\n }\n \n // Generate JWT token\n const token = await sign({\n id: user.id,\n email: user.email,\n roles: user.role\n }, Deno.env.get(\"JWT_SECRET\") || \"glider-tow-secret-key\");\n \n // Return user data and token\n return c.json({\n user: {\n id: user.id,\n email: user.email,\n name: user.name,\n roles: user.role\n },\n token\n });\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({ error: \"An error occurred during login\" }, 500);\n }\n});\n\nexport const authRoutes = app;",[],[145,198,200],"15a69a20-3459-11f0-b8d7-9e149126039e",["D",1747621766788],[165,166],[145,198],"019276f8-3459-11f0-b615-9e149126039e","queries.ts","019278ec-3459-11f0-b615-9e149126039e","e12e4c7c-94a2-49cb-b33c-8ea959791772",4,["D",1747621733156],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport { \n User, UserRole, Aircraft, MaintenanceRecord, \n FlightBooking, BillingRecord, WeatherData \n} from \"../../shared/types.ts\";\n\n// User queries\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT u.*, GROUP_CONCAT(ur.role) as roles \n FROM ${TABLES.USERS} u\n LEFT JOIN ${TABLES.USER_ROLES} ur ON u.id = ur.user_id\n WHERE u.id = ?\n GROUP BY u.id`,\n [id]\n );\n \n if (result.rows.length === 0) return null;\n \n const user = result.rows[0];\n return {\n id: user.id,\n email: user.email,\n name: user.name,\n phone: user.phone,\n role: (user.roles ? user.roles.split(',') : []) as UserRole[],\n memberSince: user.member_since,\n pilotRatings: user.pilot_ratings ? user.pilot_ratings.split(',') : undefined,\n towPilotQualified: Boolean(user.tow_pilot_qualified),\n emergencyContact: user.emergency_contact_name ? {\n name: user.emergency_contact_name,\n phone: user.emergency_contact_phone,\n relationship: user.emergency_contact_relationship\n } : undefined\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT u.*, GROUP_CONCAT(ur.role) as roles \n FROM ${TABLES.USERS} u\n LEFT JOIN ${TABLES.USER_ROLES} ur ON u.id = ur.user_id\n WHERE u.email = ?\n GROUP BY u.id`,\n [email]\n );\n \n if (result.rows.length === 0) return null;\n \n const user = result.rows[0];\n return {\n id: user.id,\n email: user.email,\n name: user.name,\n phone: user.phone,\n role: (user.roles ? user.roles.split(',') : []) as UserRole[],\n memberSince: user.member_since,\n pilotRatings: user.pilot_ratings ? user.pilot_ratings.split(',') : undefined,\n towPilotQualified: Boolean(user.tow_pilot_qualified),\n emergencyContact: user.emergency_contact_name ? {\n name: user.emergency_contact_name,\n phone: user.emergency_contact_phone,\n relationship: user.emergency_contact_relationship\n } : undefined\n };\n}\n\nexport async function getAllUsers(): Promise {\n const result = await sqlite.execute(\n `SELECT u.*, GROUP_CONCAT(ur.role) as roles \n FROM ${TABLES.USERS} u\n LEFT JOIN ${TABLES.USER_ROLES} ur ON u.id = ur.user_id\n GROUP BY u.id`\n );\n \n return result.rows.map(user => ({\n id: user.id,\n email: user.email,\n name: user.name,\n phone: user.phone,\n role: (user.roles ? user.roles.split(',') : []) as UserRole[],\n memberSince: user.member_since,\n pilotRatings: user.pilot_ratings ? user.pilot_ratings.split(',') : undefined,\n towPilotQualified: Boolean(user.tow_pilot_qualified),\n emergencyContact: user.emergency_contact_name ? {\n name: user.emergency_contact_name,\n phone: user.emergency_contact_phone,\n relationship: user.emergency_contact_relationship\n } : undefined\n }));\n}\n\nexport async function createUser(user: Omit, passwordHash: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} \n (email, password_hash, name, phone, member_since, pilot_ratings, tow_pilot_qualified, \n emergency_contact_name, emergency_contact_phone, emergency_contact_relationship)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n user.email,\n passwordHash,\n user.name,\n user.phone,\n user.memberSince,\n user.pilotRatings?.join(','),\n user.towPilotQualified ? 1 : 0,\n user.emergencyContact?.name,\n user.emergencyContact?.phone,\n user.emergencyContact?.relationship\n ]\n );\n \n const userId = result.rows[0].id;\n \n // Insert user roles\n for (const role of user.role) {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USER_ROLES} (user_id, role) VALUES (?, ?)`,\n [userId, role]\n );\n }\n \n return userId;\n}\n\n// Aircraft queries\nexport async function getAllAircraft(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${TABLES.AIRCRAFT}`);\n \n return result.rows.map(aircraft => ({\n id: aircraft.id,\n registration: aircraft.registration,\n type: aircraft.type,\n make: aircraft.make,\n model: aircraft.model,\n year: aircraft.year,\n lastAnnual: aircraft.last_annual,\n nextAnnual: aircraft.next_annual,\n totalHours: aircraft.total_hours,\n status: aircraft.status,\n notes: aircraft.notes\n }));\n}\n\nexport async function getAircraftById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.AIRCRAFT} WHERE id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) return null;\n \n const aircraft = result.rows[0];\n return {\n id: aircraft.id,\n registration: aircraft.registration,\n type: aircraft.type,\n make: aircraft.make,\n model: aircraft.model,\n year: aircraft.year,\n lastAnnual: aircraft.last_annual,\n nextAnnual: aircraft.next_annual,\n totalHours: aircraft.total_hours,\n status: aircraft.status,\n notes: aircraft.notes\n };\n}\n\n// Maintenance queries\nexport async function getMaintenanceByAircraftId(aircraftId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.MAINTENANCE} WHERE aircraft_id = ? ORDER BY date DESC`,\n [aircraftId]\n );\n \n return result.rows.map(record => ({\n id: record.id,\n aircraftId: record.aircraft_id,\n date: record.date,\n description: record.description,\n performedBy: record.performed_by,\n hoursAtService: record.hours_at_service,\n type: record.type,\n cost: record.cost,\n completed: Boolean(record.completed),\n notes: record.notes\n }));\n}\n\n// Flight booking queries\nexport async function getFlightsByDate(date: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.FLIGHTS} WHERE date = ? ORDER BY start_time`,\n [date]\n );\n \n return result.rows.map(flight => ({\n id: flight.id,\n date: flight.date,\n startTime: flight.start_time,\n endTime: flight.end_time,\n gliderId: flight.glider_id,\n towPlaneId: flight.tow_plane_id,\n gliderPilotId: flight.glider_pilot_id,\n towPilotId: flight.tow_pilot_id,\n status: flight.status,\n weatherStatus: flight.weather_status,\n notes: flight.notes\n }));\n}\n\nexport async function createFlightBooking(flight: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.FLIGHTS}\n (date, start_time, end_time, glider_id, tow_plane_id, glider_pilot_id, tow_pilot_id, status, weather_status, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n flight.date,\n flight.startTime,\n flight.endTime,\n flight.gliderId,\n flight.towPlaneId,\n flight.gliderPilotId,\n flight.towPilotId,\n flight.status,\n flight.weatherStatus,\n flight.notes\n ]\n );\n \n return result.rows[0].id;\n}\n\n// Billing queries\nexport async function getBillingByUserId(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.BILLING} WHERE user_id = ? ORDER BY date DESC`,\n [userId]\n );\n \n return result.rows.map(record => ({\n id: record.id,\n userId: record.user_id,\n flightId: record.flight_id,\n date: record.date,\n amount: record.amount,\n description: record.description,\n status: record.status,\n paymentMethod: record.payment_method,\n paymentDate: record.payment_date\n }));\n}\n\nexport async function createBillingRecord(billing: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.BILLING}\n (user_id, flight_id, date, amount, description, status, payment_method, payment_date)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n billing.userId,\n billing.flightId,\n billing.date,\n billing.amount,\n billing.description,\n billing.status,\n billing.paymentMethod,\n billing.paymentDate\n ]\n );\n \n return result.rows[0].id;\n}\n\n// Weather queries\nexport async function getLatestWeather(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.WEATHER} ORDER BY timestamp DESC LIMIT 1`\n );\n \n if (result.rows.length === 0) return null;\n \n const weather = result.rows[0];\n return {\n timestamp: weather.timestamp,\n temperature: weather.temperature,\n windSpeed: weather.wind_speed,\n windDirection: weather.wind_direction,\n visibility: weather.visibility,\n cloudCeiling: weather.cloud_ceiling,\n conditions: weather.conditions,\n suitable: Boolean(weather.suitable)\n };\n}\n\nexport async function saveWeatherData(weather: Omit): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.WEATHER}\n (timestamp, temperature, wind_speed, wind_direction, visibility, cloud_ceiling, conditions, suitable)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n weather.timestamp,\n weather.temperature,\n weather.windSpeed,\n weather.windDirection,\n weather.visibility,\n weather.cloudCeiling,\n weather.conditions,\n weather.suitable ? 1 : 0\n ]\n );\n}",[],[145,220,212],"database","eb7788f4-3458-11f0-8698-9e149126039e","migrations.ts","eb7789da-3458-11f0-8698-9e149126039e",["D",1747621696065],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names - use these constants throughout the application\n// If schema changes, increment the version number\nexport const TABLES = {\n USERS: \"glider_users_v1\",\n USER_ROLES: \"glider_user_roles_v1\",\n AIRCRAFT: \"glider_aircraft_v1\",\n MAINTENANCE: \"glider_maintenance_v1\",\n FLIGHTS: \"glider_flights_v1\",\n BILLING: \"glider_billing_v1\",\n WEATHER: \"glider_weather_v1\",\n};\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.USERS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n name TEXT NOT NULL,\n phone TEXT NOT NULL,\n member_since TEXT NOT NULL,\n pilot_ratings TEXT,\n tow_pilot_qualified INTEGER DEFAULT 0,\n emergency_contact_name TEXT,\n emergency_contact_phone TEXT,\n emergency_contact_relationship TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // User roles junction table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.USER_ROLES} (\n user_id INTEGER NOT NULL,\n role TEXT NOT NULL,\n PRIMARY KEY (user_id, role),\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id) ON DELETE CASCADE\n )\n `);\n\n // Aircraft table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.AIRCRAFT} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n registration TEXT UNIQUE NOT NULL,\n type TEXT NOT NULL,\n make TEXT NOT NULL,\n model TEXT NOT NULL,\n year INTEGER NOT NULL,\n last_annual TEXT NOT NULL,\n next_annual TEXT NOT NULL,\n total_hours REAL NOT NULL,\n status TEXT NOT NULL,\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Maintenance records table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.MAINTENANCE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n aircraft_id INTEGER NOT NULL,\n date TEXT NOT NULL,\n description TEXT NOT NULL,\n performed_by TEXT NOT NULL,\n hours_at_service REAL NOT NULL,\n type TEXT NOT NULL,\n cost REAL NOT NULL,\n completed INTEGER NOT NULL DEFAULT 0,\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (aircraft_id) REFERENCES ${TABLES.AIRCRAFT}(id) ON DELETE CASCADE\n )\n `);\n\n // Flight bookings table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.FLIGHTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n date TEXT NOT NULL,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n glider_id INTEGER NOT NULL,\n tow_plane_id INTEGER NOT NULL,\n glider_pilot_id INTEGER NOT NULL,\n tow_pilot_id INTEGER NOT NULL,\n status TEXT NOT NULL,\n weather_status TEXT NOT NULL,\n notes TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (glider_id) REFERENCES ${TABLES.AIRCRAFT}(id),\n FOREIGN KEY (tow_plane_id) REFERENCES ${TABLES.AIRCRAFT}(id),\n FOREIGN KEY (glider_pilot_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (tow_pilot_id) REFERENCES ${TABLES.USERS}(id)\n )\n `);\n\n // Billing records table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.BILLING} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n flight_id INTEGER,\n date TEXT NOT NULL,\n amount REAL NOT NULL,\n description TEXT NOT NULL,\n status TEXT NOT NULL,\n payment_method TEXT,\n payment_date TEXT,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES ${TABLES.USERS}(id),\n FOREIGN KEY (flight_id) REFERENCES ${TABLES.FLIGHTS}(id)\n )\n `);\n\n // Weather data table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.WEATHER} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp TEXT NOT NULL,\n temperature REAL NOT NULL,\n wind_speed REAL NOT NULL,\n wind_direction INTEGER NOT NULL,\n visibility REAL NOT NULL,\n cloud_ceiling INTEGER NOT NULL,\n conditions TEXT NOT NULL,\n suitable INTEGER NOT NULL,\n created_at TEXT DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Create indexes for performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_flights_date ON ${TABLES.FLIGHTS}(date)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_maintenance_aircraft ON ${TABLES.MAINTENANCE}(aircraft_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_billing_user ON ${TABLES.BILLING}(user_id)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_weather_timestamp ON ${TABLES.WEATHER}(timestamp)`);\n}\n\n// Insert some sample data for testing\nexport async function insertSampleData() {\n // Sample users\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${TABLES.USERS} \n (email, password_hash, name, phone, member_since, pilot_ratings, tow_pilot_qualified)\n VALUES \n ('admin@gliderclub.com', '$2a$10$hACwQ5/HQI6FhbIISOUVeusy3sKyUDhSq36fF5d/54aULe9c5QXle', 'Admin User', '555-123-4567', '2020-01-01', NULL, 0),\n ('towpilot@gliderclub.com', '$2a$10$hACwQ5/HQI6FhbIISOUVeusy3sKyUDhSq36fF5d/54aULe9c5QXle', 'Tow Pilot', '555-234-5678', '2020-02-15', 'commercial,cfi', 1),\n ('gliderpilot@gliderclub.com', '$2a$10$hACwQ5/HQI6FhbIISOUVeusy3sKyUDhSq36fF5d/54aULe9c5QXle', 'Glider Pilot', '555-345-6789', '2020-03-20', 'private', 0),\n ('member@gliderclub.com', '$2a$10$hACwQ5/HQI6FhbIISOUVeusy3sKyUDhSq36fF5d/54aULe9c5QXle', 'Regular Member', '555-456-7890', '2020-04-10', 'student', 0)\n `);\n\n // Sample user roles\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${TABLES.USER_ROLES} (user_id, role)\n VALUES \n (1, 'admin'),\n (2, 'tow_pilot'),\n (3, 'glider_pilot'),\n (4, 'member')\n `);\n\n // Sample aircraft\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${TABLES.AIRCRAFT}\n (registration, type, make, model, year, last_annual, next_annual, total_hours, status)\n VALUES\n ('N12345', 'tow_plane', 'Piper', 'Pawnee', 1985, '2023-05-15', '2024-05-15', 3450.5, 'available'),\n ('N67890', 'glider', 'Schleicher', 'ASK 21', 2010, '2023-06-20', '2024-06-20', 1250.3, 'available'),\n ('N54321', 'glider', 'Grob', 'G103 Twin Astir', 1995, '2023-04-10', '2024-04-10', 2100.8, 'maintenance')\n `);\n\n // Sample maintenance records\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${TABLES.MAINTENANCE}\n (aircraft_id, date, description, performed_by, hours_at_service, type, cost, completed)\n VALUES\n (1, '2023-05-15', 'Annual inspection', 'AirMech Services', 3400.0, 'annual', 1200.00, 1),\n (2, '2023-06-20', 'Annual inspection', 'GliderTech Inc.', 1200.5, 'annual', 800.00, 1),\n (3, '2023-07-10', 'Replace aileron cables', 'GliderTech Inc.', 2050.3, 'unscheduled', 450.00, 1),\n (3, '2023-08-15', '100-hour inspection', 'AirMech Services', 2100.0, 'scheduled', 350.00, 0)\n `);\n\n // Sample flights\n const today = new Date().toISOString().split('T')[0];\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${TABLES.FLIGHTS}\n (date, start_time, end_time, glider_id, tow_plane_id, glider_pilot_id, tow_pilot_id, status, weather_status)\n VALUES\n ('${today}', '10:00:00', '10:30:00', 2, 1, 3, 2, 'scheduled', 'favorable'),\n ('${today}', '11:00:00', '11:45:00', 2, 1, 4, 2, 'scheduled', 'favorable'),\n ('${today}', '13:00:00', '13:30:00', 2, 1, 3, 2, 'scheduled', 'favorable')\n `);\n\n // Sample billing records\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${TABLES.BILLING}\n (user_id, flight_id, date, amount, description, status)\n VALUES\n (3, 1, '${today}', 85.00, 'Glider tow and rental', 'pending'),\n (4, 2, '${today}', 120.00, 'Glider tow, rental, and instruction', 'pending'),\n (3, NULL, '${today}', 250.00, 'Annual membership dues', 'paid')\n `);\n\n // Sample weather data\n await sqlite.execute(`\n INSERT OR IGNORE INTO ${TABLES.WEATHER}\n (timestamp, temperature, wind_speed, wind_direction, visibility, cloud_ceiling, conditions, suitable)\n VALUES\n ('${today}T08:00:00', 72.5, 5.2, 270, 10.0, 5000, 'Clear', 1),\n ('${today}T09:00:00', 74.0, 6.5, 280, 10.0, 5000, 'Few clouds', 1),\n ('${today}T10:00:00', 76.2, 7.8, 290, 9.5, 4500, 'Scattered clouds', 1),\n ('${today}T11:00:00', 78.5, 8.5, 300, 9.0, 4000, 'Partly cloudy', 1)\n `);\n}",[],[145,220,222],"eb77d7dc-3458-11f0-8698-9e149126039e",["D",1747621696065],[162,163],[145,220],["D",1747621696065],[161,164,167],[145],["D",1747621530332],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},{"_13":82,"_31":83,"_42":41,"_84":43,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":44,"_91":92},"ctx",{"_75":-5,"_120":272,"_273":274,"_275":276,"_277":24,"_278":24,"_279":24,"_280":132,"_281":-5,"_282":-7,"_283":-7,"_284":59,"_285":24,"_286":24,"_287":-5,"_288":24,"_289":24,"_290":24,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":83,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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"]

Diff · v7