Glider Tow Operation Management

\n \n

Loading Glider Tow Operation Management System...

\n \n \n \n\n",[],[105,122],["D",1747621696065],[131,132,133],[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":202,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_86":203,"_18":204},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":137,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_86":138,"_18":139},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":134,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":135,"_18":136},["D",1747621754920],[],[19,38],["D",1747621766788],[140,141,142,143,144,145,146],[19,61],{"_36":194,"_13":195,"_39":196,"_41":62,"_43":44,"_45":197,"_47":48,"_49":198,"_17":51,"_52":53,"_54":199,"_56":57,"_58":-5,"_86":200,"_18":201},{"_36":187,"_13":188,"_39":189,"_41":62,"_43":44,"_45":63,"_47":48,"_49":190,"_17":51,"_52":53,"_54":191,"_56":57,"_58":-5,"_86":192,"_18":193},{"_36":179,"_13":180,"_39":181,"_41":62,"_43":44,"_45":182,"_47":48,"_49":183,"_17":51,"_52":53,"_54":184,"_56":57,"_58":-5,"_86":185,"_18":186},{"_36":171,"_13":172,"_39":173,"_41":62,"_43":44,"_45":174,"_47":48,"_49":175,"_17":51,"_52":53,"_54":176,"_56":57,"_58":-5,"_86":177,"_18":178},{"_36":163,"_13":164,"_39":165,"_41":62,"_43":44,"_45":166,"_47":48,"_49":167,"_17":51,"_52":53,"_54":168,"_56":57,"_58":-5,"_86":169,"_18":170},{"_36":155,"_13":156,"_39":157,"_41":62,"_43":44,"_45":158,"_47":48,"_49":159,"_17":51,"_52":53,"_54":160,"_56":57,"_58":-5,"_86":161,"_18":162},{"_36":147,"_13":148,"_39":149,"_41":62,"_43":44,"_45":150,"_47":48,"_49":151,"_17":51,"_52":53,"_54":152,"_56":57,"_58":-5,"_86":153,"_18":154},"bf13f22c-350a-11f0-85e3-9e149126039e","weather.ts","bf13f2e0-350a-11f0-85e3-9e149126039e",12,["D",1747698072013],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\n\nconst app = new Hono();\n\n// Get current weather for the airfield\napp.get(\"/current\", async (c) => {\n try {\n // Default coordinates for the airfield (should be configured in environment variables)\n const latitude = Deno.env.get(\"AIRFIELD_LATITUDE\") || \"37.5236\";\n const longitude = Deno.env.get(\"AIRFIELD_LONGITUDE\") || \"-122.0795\";\n \n // Fetch weather data from Open-Meteo API (no API key required)\n const response = await fetch(\n `https://api.open-meteo.com/v1/forecast?latitude=${latitude}&longitude=${longitude}¤t=temperature_2m,relative_humidity_2m,apparent_temperature,precipitation,rain,weather_code,cloud_cover,pressure_msl,surface_pressure,wind_speed_10m,wind_direction_10m,wind_gusts_10m&wind_speed_unit=mph&temperature_unit=fahrenheit`\n );\n \n if (!response.ok) {\n throw new Error(`Weather API returned ${response.status}: ${response.statusText}`);\n }\n \n const data = await response.json();\n \n // Add human-readable descriptions for weather codes\n const weatherCodes: Record = {\n 0: \"Clear sky\",\n 1: \"Mainly clear\",\n 2: \"Partly cloudy\",\n 3: \"Overcast\",\n 45: \"Fog\",\n 48: \"Depositing rime fog\",\n 51: \"Light drizzle\",\n 53: \"Moderate drizzle\",\n 55: \"Dense drizzle\",\n 56: \"Light freezing drizzle\",\n 57: \"Dense freezing drizzle\",\n 61: \"Slight rain\",\n 63: \"Moderate rain\",\n 65: \"Heavy rain\",\n 66: \"Light freezing rain\",\n 67: \"Heavy freezing rain\",\n 71: \"Slight snow fall\",\n 73: \"Moderate snow fall\",\n 75: \"Heavy snow fall\",\n 77: \"Snow grains\",\n 80: \"Slight rain showers\",\n 81: \"Moderate rain showers\",\n 82: \"Violent rain showers\",\n 85: \"Slight snow showers\",\n 86: \"Heavy snow showers\",\n 95: \"Thunderstorm\",\n 96: \"Thunderstorm with slight hail\",\n 99: \"Thunderstorm with heavy hail\"\n };\n \n // Add weather description\n if (data.current && data.current.weather_code !== undefined) {\n data.current.weather_description = weatherCodes[data.current.weather_code] || \"Unknown\";\n }\n \n // Add flying conditions assessment\n if (data.current) {\n const windSpeed = data.current.wind_speed_10m || 0;\n const windGusts = data.current.wind_gusts_10m || 0;\n const cloudCover = data.current.cloud_cover || 0;\n const weatherCode = data.current.weather_code || 0;\n \n let flyingConditions = \"Excellent\";\n let flyingNotes = [];\n \n // Check wind conditions\n if (windSpeed > 25 || windGusts > 30) {\n flyingConditions = \"Dangerous\";\n flyingNotes.push(\"High winds\");\n } else if (windSpeed > 15 || windGusts > 20) {\n flyingConditions = \"Marginal\";\n flyingNotes.push(\"Strong winds\");\n } else if (windSpeed > 10) {\n flyingConditions = \"Good\";\n flyingNotes.push(\"Moderate winds\");\n }\n \n // Check precipitation\n if (weatherCode >= 51 && weatherCode <= 67) {\n flyingConditions = \"Poor\";\n flyingNotes.push(\"Rain or drizzle\");\n } else if (weatherCode >= 71 && weatherCode <= 77) {\n flyingConditions = \"Dangerous\";\n flyingNotes.push(\"Snow\");\n } else if (weatherCode >= 80 && weatherCode <= 82) {\n flyingConditions = \"Poor\";\n flyingNotes.push(\"Rain showers\");\n } else if (weatherCode >= 85 && weatherCode <= 86) {\n flyingConditions = \"Dangerous\";\n flyingNotes.push(\"Snow showers\");\n } else if (weatherCode >= 95) {\n flyingConditions = \"Dangerous\";\n flyingNotes.push(\"Thunderstorm\");\n }\n \n // Check visibility\n if (weatherCode === 45 || weatherCode === 48) {\n flyingConditions = \"Dangerous\";\n flyingNotes.push(\"Fog\");\n }\n \n // Check cloud cover\n if (cloudCover > 90) {\n if (flyingConditions === \"Excellent\") flyingConditions = \"Good\";\n flyingNotes.push(\"Overcast\");\n } else if (cloudCover > 70) {\n if (flyingConditions === \"Excellent\") flyingConditions = \"Good\";\n flyingNotes.push(\"Mostly cloudy\");\n }\n \n data.flying_assessment = {\n conditions: flyingConditions,\n notes: flyingNotes\n };\n }\n \n return c.json(data);\n } catch (error) {\n console.error(\"Error fetching weather data:\", error);\n return c.json({ error: \"Failed to fetch weather data\" }, 500);\n }\n});\n\n// Get weather forecast for the next few days\napp.get(\"/forecast\", async (c) => {\n try {\n // Default coordinates for the airfield (should be configured in environment variables)\n const latitude = Deno.env.get(\"AIRFIELD_LATITUDE\") || \"37.5236\";\n const longitude = Deno.env.get(\"AIRFIELD_LONGITUDE\") || \"-122.0795\";\n \n // Fetch forecast data from Open-Meteo API\n const response = await fetch(\n `https://api.open-meteo.com/v1/forecast?latitude=${latitude}&longitude=${longitude}&daily=weather_code,temperature_2m_max,temperature_2m_min,sunrise,sunset,precipitation_sum,precipitation_hours,wind_speed_10m_max,wind_gusts_10m_max,wind_direction_10m_dominant&wind_speed_unit=mph&temperature_unit=fahrenheit&forecast_days=7`\n );\n \n if (!response.ok) {\n throw new Error(`Weather API returned ${response.status}: ${response.statusText}`);\n }\n \n const data = await response.json();\n \n // Add human-readable descriptions for weather codes\n const weatherCodes: Record = {\n 0: \"Clear sky\",\n 1: \"Mainly clear\",\n 2: \"Partly cloudy\",\n 3: \"Overcast\",\n 45: \"Fog\",\n 48: \"Depositing rime fog\",\n 51: \"Light drizzle\",\n 53: \"Moderate drizzle\",\n 55: \"Dense drizzle\",\n 56: \"Light freezing drizzle\",\n 57: \"Dense freezing drizzle\",\n 61: \"Slight rain\",\n 63: \"Moderate rain\",\n 65: \"Heavy rain\",\n 66: \"Light freezing rain\",\n 67: \"Heavy freezing rain\",\n 71: \"Slight snow fall\",\n 73: \"Moderate snow fall\",\n 75: \"Heavy snow fall\",\n 77: \"Snow grains\",\n 80: \"Slight rain showers\",\n 81: \"Moderate rain showers\",\n 82: \"Violent rain showers\",\n 85: \"Slight snow showers\",\n 86: \"Heavy snow showers\",\n 95: \"Thunderstorm\",\n 96: \"Thunderstorm with slight hail\",\n 99: \"Thunderstorm with heavy hail\"\n };\n \n // Add weather descriptions and flying conditions to each day\n if (data.daily && data.daily.weather_code) {\n data.daily.weather_description = data.daily.weather_code.map((code: number) => \n weatherCodes[code] || \"Unknown\"\n );\n \n // Add flying conditions assessment for each day\n data.daily.flying_conditions = data.daily.weather_code.map((code: number, index: number) => {\n const windSpeed = data.daily.wind_speed_10m_max[index] || 0;\n const windGusts = data.daily.wind_gusts_10m_max[index] || 0;\n const precipitation = data.daily.precipitation_sum[index] || 0;\n \n let conditions = \"Excellent\";\n let notes = [];\n \n // Check wind conditions\n if (windSpeed > 25 || windGusts > 30) {\n conditions = \"Dangerous\";\n notes.push(\"High winds\");\n } else if (windSpeed > 15 || windGusts > 20) {\n conditions = \"Marginal\";\n notes.push(\"Strong winds\");\n } else if (windSpeed > 10) {\n conditions = \"Good\";\n notes.push(\"Moderate winds\");\n }\n \n // Check precipitation\n if (precipitation > 10) {\n conditions = \"Dangerous\";\n notes.push(\"Heavy precipitation\");\n } else if (precipitation > 5) {\n conditions = \"Poor\";\n notes.push(\"Moderate precipitation\");\n } else if (precipitation > 1) {\n conditions = \"Marginal\";\n notes.push(\"Light precipitation\");\n }\n \n // Check weather code\n if (code >= 51 && code <= 67) {\n if (conditions !== \"Dangerous\") conditions = \"Poor\";\n notes.push(\"Rain or drizzle\");\n } else if (code >= 71 && code <= 77) {\n conditions = \"Dangerous\";\n notes.push(\"Snow\");\n } else if (code >= 80 && code <= 82) {\n if (conditions !== \"Dangerous\") conditions = \"Poor\";\n notes.push(\"Rain showers\");\n } else if (code >= 85 && code <= 86) {\n conditions = \"Dangerous\";\n notes.push(\"Snow showers\");\n } else if (code >= 95) {\n conditions = \"Dangerous\";\n notes.push(\"Thunderstorm\");\n } else if (code === 45 || code === 48) {\n conditions = \"Dangerous\";\n notes.push(\"Fog\");\n }\n \n return {\n conditions,\n notes\n };\n });\n }\n \n return c.json(data);\n } catch (error) {\n console.error(\"Error fetching weather forecast:\", error);\n return c.json({ error: \"Failed to fetch weather forecast\" }, 500);\n }\n});\n\n// Get METAR/TAF data for nearby airports\napp.get(\"/aviation\", async (c) => {\n try {\n // Get airport code from query parameter or use default\n const airport = c.req.query(\"airport\") || \"KPAO\"; // Default to Palo Alto Airport\n \n // Fetch METAR data from Aviation Weather Center API\n const metarResponse = await fetch(\n `https://aviationweather.gov/api/data/metar?ids=${airport}&format=json`\n );\n \n if (!metarResponse.ok) {\n throw new Error(`METAR API returned ${metarResponse.status}: ${metarResponse.statusText}`);\n }\n \n const metarData = await metarResponse.json();\n \n // Fetch TAF data\n const tafResponse = await fetch(\n `https://aviationweather.gov/api/data/taf?ids=${airport}&format=json`\n );\n \n let tafData = [];\n if (tafResponse.ok) {\n tafData = await tafResponse.json();\n }\n \n return c.json({\n metar: metarData,\n taf: tafData\n });\n } catch (error) {\n console.error(\"Error fetching aviation weather data:\", error);\n return c.json({ error: \"Failed to fetch aviation weather data\" }, 500);\n }\n});\n\nexport const weatherRoutes = app;",[],[19,61,148],"2309773c-3459-11f0-b9e4-9e149126039e","users.ts","230977fa-3459-11f0-b9e4-9e149126039e",7,["D",1747621789297],"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;",[],[19,61,156],"78a8bab6-350a-11f0-af9c-9e149126039e","maintenance.ts","78a8bb92-350a-11f0-af9c-9e149126039e",9,["D",1747697953870],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"../database/migrations.ts\";\n\nconst app = new Hono();\n\n// Get all maintenance records\napp.get(\"/\", async (c) => {\n try {\n const result = await sqlite.execute(\n `SELECT m.*, a.registration as aircraft_registration\n FROM ${TABLES.MAINTENANCE} m\n JOIN ${TABLES.AIRCRAFT} a ON m.aircraft_id = a.id\n ORDER BY m.date DESC`\n );\n \n return c.json(result.rows);\n } catch (error) {\n console.error(\"Error fetching maintenance records:\", error);\n return c.json({ error: \"Failed to fetch maintenance records\" }, 500);\n }\n});\n\n// Get maintenance records for a specific aircraft\napp.get(\"/aircraft/:id\", async (c) => {\n const aircraftId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(aircraftId)) {\n return c.json({ error: \"Invalid aircraft ID\" }, 400);\n }\n \n try {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLES.MAINTENANCE}\n WHERE aircraft_id = ?\n ORDER BY date DESC`,\n [aircraftId]\n );\n \n return c.json(result.rows);\n } catch (error) {\n console.error(`Error fetching maintenance for aircraft ${aircraftId}:`, error);\n return c.json({ error: \"Failed to fetch maintenance records\" }, 500);\n }\n});\n\n// Get maintenance record 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 maintenance ID\" }, 400);\n }\n \n try {\n const result = await sqlite.execute(\n `SELECT m.*, a.registration as aircraft_registration\n FROM ${TABLES.MAINTENANCE} m\n JOIN ${TABLES.AIRCRAFT} a ON m.aircraft_id = a.id\n WHERE m.id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return c.json({ error: \"Maintenance record not found\" }, 404);\n }\n \n return c.json(result.rows[0]);\n } catch (error) {\n console.error(`Error fetching maintenance record ${id}:`, error);\n return c.json({ error: \"Failed to fetch maintenance record\" }, 500);\n }\n});\n\n// Create new maintenance record\napp.post(\"/\", async (c) => {\n try {\n const data = await c.req.json();\n \n // Validate required fields\n if (!data.aircraftId || !data.type || !data.date) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n // Create maintenance record\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.MAINTENANCE}\n (aircraft_id, type, date, description, hours, cost, performed_by, status)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n data.aircraftId,\n data.type,\n data.date,\n data.description || null,\n data.hours || null,\n data.cost || null,\n data.performedBy || null,\n data.status || \"scheduled\"\n ]\n );\n \n const newId = result.rows[0].id;\n \n // Fetch the newly created record\n const newRecord = await sqlite.execute(\n `SELECT m.*, a.registration as aircraft_registration\n FROM ${TABLES.MAINTENANCE} m\n JOIN ${TABLES.AIRCRAFT} a ON m.aircraft_id = a.id\n WHERE m.id = ?`,\n [newId]\n );\n \n return c.json(newRecord.rows[0], 201);\n } catch (error) {\n console.error(\"Error creating maintenance record:\", error);\n return c.json({ error: \"Failed to create maintenance record\" }, 500);\n }\n});\n\n// Update maintenance record\napp.put(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid maintenance ID\" }, 400);\n }\n \n try {\n const data = await c.req.json();\n \n // Check if record exists\n const existingResult = await sqlite.execute(\n `SELECT * FROM ${TABLES.MAINTENANCE} WHERE id = ?`,\n [id]\n );\n \n if (existingResult.rows.length === 0) {\n return c.json({ error: \"Maintenance record not found\" }, 404);\n }\n \n const existing = existingResult.rows[0];\n \n // Update record\n await sqlite.execute(\n `UPDATE ${TABLES.MAINTENANCE} SET\n aircraft_id = ?, type = ?, date = ?, description = ?,\n hours = ?, cost = ?, performed_by = ?, status = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n [\n data.aircraftId || existing.aircraft_id,\n data.type || existing.type,\n data.date || existing.date,\n data.description !== undefined ? data.description : existing.description,\n data.hours !== undefined ? data.hours : existing.hours,\n data.cost !== undefined ? data.cost : existing.cost,\n data.performedBy !== undefined ? data.performedBy : existing.performed_by,\n data.status || existing.status,\n id\n ]\n );\n \n // Fetch updated record\n const updatedResult = await sqlite.execute(\n `SELECT m.*, a.registration as aircraft_registration\n FROM ${TABLES.MAINTENANCE} m\n JOIN ${TABLES.AIRCRAFT} a ON m.aircraft_id = a.id\n WHERE m.id = ?`,\n [id]\n );\n \n return c.json(updatedResult.rows[0]);\n } catch (error) {\n console.error(`Error updating maintenance record ${id}:`, error);\n return c.json({ error: \"Failed to update maintenance record\" }, 500);\n }\n});\n\n// Delete maintenance record\napp.delete(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid maintenance ID\" }, 400);\n }\n \n try {\n // Check if record exists\n const existingResult = await sqlite.execute(\n `SELECT id FROM ${TABLES.MAINTENANCE} WHERE id = ?`,\n [id]\n );\n \n if (existingResult.rows.length === 0) {\n return c.json({ error: \"Maintenance record not found\" }, 404);\n }\n \n // Delete record\n await sqlite.execute(\n `DELETE FROM ${TABLES.MAINTENANCE} WHERE id = ?`,\n [id]\n );\n \n return c.json({ success: true });\n } catch (error) {\n console.error(`Error deleting maintenance record ${id}:`, error);\n return c.json({ error: \"Failed to delete maintenance record\" }, 500);\n }\n});\n\nexport const maintenanceRoutes = app;",[],[19,61,164],"8f6cdffc-350a-11f0-b883-9e149126039e","flights.ts","8f6ce0c4-350a-11f0-b883-9e149126039e",10,["D",1747697992065],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"../database/migrations.ts\";\n\nconst app = new Hono();\n\n// Get all flights\napp.get(\"/\", async (c) => {\n try {\n const result = await sqlite.execute(\n `SELECT f.*, \n ga.registration as glider_registration,\n ta.registration as tow_plane_registration,\n gp.name as glider_pilot_name,\n tp.name as tow_pilot_name\n FROM ${TABLES.FLIGHTS} f\n LEFT JOIN ${TABLES.AIRCRAFT} ga ON f.glider_id = ga.id\n LEFT JOIN ${TABLES.AIRCRAFT} ta ON f.tow_plane_id = ta.id\n LEFT JOIN glider_users_v1 gp ON f.glider_pilot_id = gp.id\n LEFT JOIN glider_users_v1 tp ON f.tow_pilot_id = tp.id\n ORDER BY f.date DESC, f.start_time DESC`\n );\n \n return c.json(result.rows);\n } catch (error) {\n console.error(\"Error fetching flights:\", error);\n return c.json({ error: \"Failed to fetch flights\" }, 500);\n }\n});\n\n// Get flights for a specific date\napp.get(\"/date/:date\", async (c) => {\n const date = c.req.param(\"date\");\n \n try {\n const result = await sqlite.execute(\n `SELECT f.*, \n ga.registration as glider_registration,\n ta.registration as tow_plane_registration,\n gp.name as glider_pilot_name,\n tp.name as tow_pilot_name\n FROM ${TABLES.FLIGHTS} f\n LEFT JOIN ${TABLES.AIRCRAFT} ga ON f.glider_id = ga.id\n LEFT JOIN ${TABLES.AIRCRAFT} ta ON f.tow_plane_id = ta.id\n LEFT JOIN glider_users_v1 gp ON f.glider_pilot_id = gp.id\n LEFT JOIN glider_users_v1 tp ON f.tow_pilot_id = tp.id\n WHERE f.date = ?\n ORDER BY f.start_time`,\n [date]\n );\n \n return c.json(result.rows);\n } catch (error) {\n console.error(`Error fetching flights for date ${date}:`, error);\n return c.json({ error: \"Failed to fetch flights\" }, 500);\n }\n});\n\n// Get flights for a specific pilot\napp.get(\"/pilot/:id\", async (c) => {\n const pilotId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(pilotId)) {\n return c.json({ error: \"Invalid pilot ID\" }, 400);\n }\n \n try {\n const result = await sqlite.execute(\n `SELECT f.*, \n ga.registration as glider_registration,\n ta.registration as tow_plane_registration,\n gp.name as glider_pilot_name,\n tp.name as tow_pilot_name\n FROM ${TABLES.FLIGHTS} f\n LEFT JOIN ${TABLES.AIRCRAFT} ga ON f.glider_id = ga.id\n LEFT JOIN ${TABLES.AIRCRAFT} ta ON f.tow_plane_id = ta.id\n LEFT JOIN glider_users_v1 gp ON f.glider_pilot_id = gp.id\n LEFT JOIN glider_users_v1 tp ON f.tow_pilot_id = tp.id\n WHERE f.glider_pilot_id = ? OR f.tow_pilot_id = ?\n ORDER BY f.date DESC, f.start_time DESC`,\n [pilotId, pilotId]\n );\n \n return c.json(result.rows);\n } catch (error) {\n console.error(`Error fetching flights for pilot ${pilotId}:`, error);\n return c.json({ error: \"Failed to fetch flights\" }, 500);\n }\n});\n\n// Get flight 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 flight ID\" }, 400);\n }\n \n try {\n const result = await sqlite.execute(\n `SELECT f.*, \n ga.registration as glider_registration,\n ta.registration as tow_plane_registration,\n gp.name as glider_pilot_name,\n tp.name as tow_pilot_name\n FROM ${TABLES.FLIGHTS} f\n LEFT JOIN ${TABLES.AIRCRAFT} ga ON f.glider_id = ga.id\n LEFT JOIN ${TABLES.AIRCRAFT} ta ON f.tow_plane_id = ta.id\n LEFT JOIN glider_users_v1 gp ON f.glider_pilot_id = gp.id\n LEFT JOIN glider_users_v1 tp ON f.tow_pilot_id = tp.id\n WHERE f.id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return c.json({ error: \"Flight not found\" }, 404);\n }\n \n return c.json(result.rows[0]);\n } catch (error) {\n console.error(`Error fetching flight ${id}:`, error);\n return c.json({ error: \"Failed to fetch flight\" }, 500);\n }\n});\n\n// Create new flight\napp.post(\"/\", async (c) => {\n try {\n const data = await c.req.json();\n \n // Validate required fields\n if (!data.date || !data.gliderId || !data.gliderPilotId) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n // Create flight record\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.FLIGHTS}\n (date, glider_id, glider_pilot_id, tow_plane_id, tow_pilot_id, \n start_time, end_time, tow_height, landing_pattern, notes, status, cost)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n data.date,\n data.gliderId,\n data.gliderPilotId,\n data.towPlaneId || null,\n data.towPilotId || null,\n data.startTime || null,\n data.endTime || null,\n data.towHeight || null,\n data.landingPattern || null,\n data.notes || null,\n data.status || \"scheduled\",\n data.cost || null\n ]\n );\n \n const newId = result.rows[0].id;\n \n // Fetch the newly created flight\n const newFlight = await sqlite.execute(\n `SELECT f.*, \n ga.registration as glider_registration,\n ta.registration as tow_plane_registration,\n gp.name as glider_pilot_name,\n tp.name as tow_pilot_name\n FROM ${TABLES.FLIGHTS} f\n LEFT JOIN ${TABLES.AIRCRAFT} ga ON f.glider_id = ga.id\n LEFT JOIN ${TABLES.AIRCRAFT} ta ON f.tow_plane_id = ta.id\n LEFT JOIN glider_users_v1 gp ON f.glider_pilot_id = gp.id\n LEFT JOIN glider_users_v1 tp ON f.tow_pilot_id = tp.id\n WHERE f.id = ?`,\n [newId]\n );\n \n return c.json(newFlight.rows[0], 201);\n } catch (error) {\n console.error(\"Error creating flight:\", error);\n return c.json({ error: \"Failed to create flight\" }, 500);\n }\n});\n\n// Update flight\napp.put(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid flight ID\" }, 400);\n }\n \n try {\n const data = await c.req.json();\n \n // Check if flight exists\n const existingResult = await sqlite.execute(\n `SELECT * FROM ${TABLES.FLIGHTS} WHERE id = ?`,\n [id]\n );\n \n if (existingResult.rows.length === 0) {\n return c.json({ error: \"Flight not found\" }, 404);\n }\n \n const existing = existingResult.rows[0];\n \n // Update flight\n await sqlite.execute(\n `UPDATE ${TABLES.FLIGHTS} SET\n date = ?, glider_id = ?, glider_pilot_id = ?, tow_plane_id = ?, tow_pilot_id = ?,\n start_time = ?, end_time = ?, tow_height = ?, landing_pattern = ?,\n notes = ?, status = ?, cost = ?, updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n [\n data.date || existing.date,\n data.gliderId || existing.glider_id,\n data.gliderPilotId || existing.glider_pilot_id,\n data.towPlaneId !== undefined ? data.towPlaneId : existing.tow_plane_id,\n data.towPilotId !== undefined ? data.towPilotId : existing.tow_pilot_id,\n data.startTime !== undefined ? data.startTime : existing.start_time,\n data.endTime !== undefined ? data.endTime : existing.end_time,\n data.towHeight !== undefined ? data.towHeight : existing.tow_height,\n data.landingPattern !== undefined ? data.landingPattern : existing.landing_pattern,\n data.notes !== undefined ? data.notes : existing.notes,\n data.status || existing.status,\n data.cost !== undefined ? data.cost : existing.cost,\n id\n ]\n );\n \n // Fetch updated flight\n const updatedFlight = await sqlite.execute(\n `SELECT f.*, \n ga.registration as glider_registration,\n ta.registration as tow_plane_registration,\n gp.name as glider_pilot_name,\n tp.name as tow_pilot_name\n FROM ${TABLES.FLIGHTS} f\n LEFT JOIN ${TABLES.AIRCRAFT} ga ON f.glider_id = ga.id\n LEFT JOIN ${TABLES.AIRCRAFT} ta ON f.tow_plane_id = ta.id\n LEFT JOIN glider_users_v1 gp ON f.glider_pilot_id = gp.id\n LEFT JOIN glider_users_v1 tp ON f.tow_pilot_id = tp.id\n WHERE f.id = ?`,\n [id]\n );\n \n return c.json(updatedFlight.rows[0]);\n } catch (error) {\n console.error(`Error updating flight ${id}:`, error);\n return c.json({ error: \"Failed to update flight\" }, 500);\n }\n});\n\n// Delete flight\napp.delete(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid flight ID\" }, 400);\n }\n \n try {\n // Check if flight exists\n const existingResult = await sqlite.execute(\n `SELECT id FROM ${TABLES.FLIGHTS} WHERE id = ?`,\n [id]\n );\n \n if (existingResult.rows.length === 0) {\n return c.json({ error: \"Flight not found\" }, 404);\n }\n \n // Delete flight\n await sqlite.execute(\n `DELETE FROM ${TABLES.FLIGHTS} WHERE id = ?`,\n [id]\n );\n \n return c.json({ success: true });\n } catch (error) {\n console.error(`Error deleting flight ${id}:`, error);\n return c.json({ error: \"Failed to delete flight\" }, 500);\n }\n});\n\nexport const flightRoutes = app;",[],[19,61,172],"a4be13b2-350a-11f0-b60e-9e149126039e","billing.ts","a4be1506-350a-11f0-b60e-9e149126039e",11,["D",1747698027831],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"../database/migrations.ts\";\n\nconst app = new Hono();\n\n// Get all billing records\napp.get(\"/\", async (c) => {\n try {\n const result = await sqlite.execute(\n `SELECT b.*, u.name as user_name, u.email as user_email\n FROM ${TABLES.BILLING} b\n JOIN glider_users_v1 u ON b.user_id = u.id\n ORDER BY b.date DESC`\n );\n \n return c.json(result.rows);\n } catch (error) {\n console.error(\"Error fetching billing records:\", error);\n return c.json({ error: \"Failed to fetch billing records\" }, 500);\n }\n});\n\n// Get billing records for a specific user\napp.get(\"/user/:id\", async (c) => {\n const userId = parseInt(c.req.param(\"id\"));\n \n if (isNaN(userId)) {\n return c.json({ error: \"Invalid user ID\" }, 400);\n }\n \n try {\n const result = await sqlite.execute(\n `SELECT b.*, u.name as user_name, u.email as user_email\n FROM ${TABLES.BILLING} b\n JOIN glider_users_v1 u ON b.user_id = u.id\n WHERE b.user_id = ?\n ORDER BY b.date DESC`,\n [userId]\n );\n \n return c.json(result.rows);\n } catch (error) {\n console.error(`Error fetching billing for user ${userId}:`, error);\n return c.json({ error: \"Failed to fetch billing records\" }, 500);\n }\n});\n\n// Get billing record 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 billing ID\" }, 400);\n }\n \n try {\n const result = await sqlite.execute(\n `SELECT b.*, u.name as user_name, u.email as user_email\n FROM ${TABLES.BILLING} b\n JOIN glider_users_v1 u ON b.user_id = u.id\n WHERE b.id = ?`,\n [id]\n );\n \n if (result.rows.length === 0) {\n return c.json({ error: \"Billing record not found\" }, 404);\n }\n \n return c.json(result.rows[0]);\n } catch (error) {\n console.error(`Error fetching billing record ${id}:`, error);\n return c.json({ error: \"Failed to fetch billing record\" }, 500);\n }\n});\n\n// Create new billing record\napp.post(\"/\", async (c) => {\n try {\n const data = await c.req.json();\n \n // Validate required fields\n if (!data.userId || !data.amount || !data.date || !data.description) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n // Create billing record\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.BILLING}\n (user_id, amount, date, description, flight_id, payment_status, payment_date, payment_method, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n data.userId,\n data.amount,\n data.date,\n data.description,\n data.flightId || null,\n data.paymentStatus || \"pending\",\n data.paymentDate || null,\n data.paymentMethod || null,\n data.notes || null\n ]\n );\n \n const newId = result.rows[0].id;\n \n // Fetch the newly created record\n const newRecord = await sqlite.execute(\n `SELECT b.*, u.name as user_name, u.email as user_email\n FROM ${TABLES.BILLING} b\n JOIN glider_users_v1 u ON b.user_id = u.id\n WHERE b.id = ?`,\n [newId]\n );\n \n return c.json(newRecord.rows[0], 201);\n } catch (error) {\n console.error(\"Error creating billing record:\", error);\n return c.json({ error: \"Failed to create billing record\" }, 500);\n }\n});\n\n// Update billing record\napp.put(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid billing ID\" }, 400);\n }\n \n try {\n const data = await c.req.json();\n \n // Check if record exists\n const existingResult = await sqlite.execute(\n `SELECT * FROM ${TABLES.BILLING} WHERE id = ?`,\n [id]\n );\n \n if (existingResult.rows.length === 0) {\n return c.json({ error: \"Billing record not found\" }, 404);\n }\n \n const existing = existingResult.rows[0];\n \n // Update record\n await sqlite.execute(\n `UPDATE ${TABLES.BILLING} SET\n user_id = ?, amount = ?, date = ?, description = ?, flight_id = ?,\n payment_status = ?, payment_date = ?, payment_method = ?, notes = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n [\n data.userId || existing.user_id,\n data.amount !== undefined ? data.amount : existing.amount,\n data.date || existing.date,\n data.description || existing.description,\n data.flightId !== undefined ? data.flightId : existing.flight_id,\n data.paymentStatus || existing.payment_status,\n data.paymentDate !== undefined ? data.paymentDate : existing.payment_date,\n data.paymentMethod !== undefined ? data.paymentMethod : existing.payment_method,\n data.notes !== undefined ? data.notes : existing.notes,\n id\n ]\n );\n \n // Fetch updated record\n const updatedRecord = await sqlite.execute(\n `SELECT b.*, u.name as user_name, u.email as user_email\n FROM ${TABLES.BILLING} b\n JOIN glider_users_v1 u ON b.user_id = u.id\n WHERE b.id = ?`,\n [id]\n );\n \n return c.json(updatedRecord.rows[0]);\n } catch (error) {\n console.error(`Error updating billing record ${id}:`, error);\n return c.json({ error: \"Failed to update billing record\" }, 500);\n }\n});\n\n// Process payment for a billing record\napp.post(\"/:id/payment\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid billing ID\" }, 400);\n }\n \n try {\n const data = await c.req.json();\n \n // Validate required fields\n if (!data.paymentMethod) {\n return c.json({ error: \"Payment method is required\" }, 400);\n }\n \n // Check if record exists\n const existingResult = await sqlite.execute(\n `SELECT * FROM ${TABLES.BILLING} WHERE id = ?`,\n [id]\n );\n \n if (existingResult.rows.length === 0) {\n return c.json({ error: \"Billing record not found\" }, 404);\n }\n \n // Update payment information\n const paymentDate = data.paymentDate || new Date().toISOString().split('T')[0];\n \n await sqlite.execute(\n `UPDATE ${TABLES.BILLING} SET\n payment_status = 'paid',\n payment_date = ?,\n payment_method = ?,\n notes = CASE WHEN notes IS NULL THEN ? ELSE notes || '\\n' || ? END,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n [\n paymentDate,\n data.paymentMethod,\n `Payment processed on ${paymentDate} via ${data.paymentMethod}`,\n `Payment processed on ${paymentDate} via ${data.paymentMethod}`,\n id\n ]\n );\n \n // Fetch updated record\n const updatedRecord = await sqlite.execute(\n `SELECT b.*, u.name as user_name, u.email as user_email\n FROM ${TABLES.BILLING} b\n JOIN glider_users_v1 u ON b.user_id = u.id\n WHERE b.id = ?`,\n [id]\n );\n \n return c.json(updatedRecord.rows[0]);\n } catch (error) {\n console.error(`Error processing payment for billing record ${id}:`, error);\n return c.json({ error: \"Failed to process payment\" }, 500);\n }\n});\n\n// Delete billing record\napp.delete(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid billing ID\" }, 400);\n }\n \n try {\n // Check if record exists\n const existingResult = await sqlite.execute(\n `SELECT id FROM ${TABLES.BILLING} WHERE id = ?`,\n [id]\n );\n \n if (existingResult.rows.length === 0) {\n return c.json({ error: \"Billing record not found\" }, 404);\n }\n \n // Delete record\n await sqlite.execute(\n `DELETE FROM ${TABLES.BILLING} WHERE id = ?`,\n [id]\n );\n \n return c.json({ success: true });\n } catch (error) {\n console.error(`Error deleting billing record ${id}:`, error);\n return c.json({ error: \"Failed to delete billing record\" }, 500);\n }\n});\n\nexport const billingRoutes = app;",[],[19,61,180],"15a6926e-3459-11f0-b8d7-9e149126039e","auth.ts","15a69318-3459-11f0-b8d7-9e149126039e",["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;",[],[19,61,188],"331de5d6-3459-11f0-8675-9e149126039e","aircraft.ts","331de680-3459-11f0-8675-9e149126039e",8,["D",1747621816277],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllAircraft, getAircraftById } from \"../database/queries.ts\";\nimport { TABLES } from \"../database/migrations.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst app = new Hono();\n\n// Get all aircraft\napp.get(\"/\", async (c) => {\n try {\n const aircraft = await getAllAircraft();\n return c.json(aircraft);\n } catch (error) {\n console.error(\"Error fetching aircraft:\", error);\n return c.json({ error: \"Failed to fetch aircraft\" }, 500);\n }\n});\n\n// Get aircraft 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 aircraft ID\" }, 400);\n }\n \n try {\n const aircraft = await getAircraftById(id);\n \n if (!aircraft) {\n return c.json({ error: \"Aircraft not found\" }, 404);\n }\n \n return c.json(aircraft);\n } catch (error) {\n console.error(`Error fetching aircraft ${id}:`, error);\n return c.json({ error: \"Failed to fetch aircraft\" }, 500);\n }\n});\n\n// Create new aircraft\napp.post(\"/\", async (c) => {\n try {\n const aircraftData = await c.req.json();\n \n // Validate required fields\n if (!aircraftData.registration || !aircraftData.type || !aircraftData.make || !aircraftData.model) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n // Check if registration already exists\n const existingResult = await sqlite.execute(\n `SELECT id FROM ${TABLES.AIRCRAFT} WHERE registration = ?`,\n [aircraftData.registration]\n );\n \n if (existingResult.rows.length > 0) {\n return c.json({ error: \"Aircraft registration already exists\" }, 409);\n }\n \n // Create aircraft\n const result = await sqlite.execute(\n `INSERT INTO ${TABLES.AIRCRAFT}\n (registration, type, make, model, year, last_annual, next_annual, total_hours, status, notes)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n RETURNING id`,\n [\n aircraftData.registration,\n aircraftData.type,\n aircraftData.make,\n aircraftData.model,\n aircraftData.year || new Date().getFullYear(),\n aircraftData.lastAnnual || new Date().toISOString().split('T')[0],\n aircraftData.nextAnnual || new Date(new Date().setFullYear(new Date().getFullYear() + 1)).toISOString().split('T')[0],\n aircraftData.totalHours || 0,\n aircraftData.status || \"available\",\n aircraftData.notes || null\n ]\n );\n \n const newAircraftId = result.rows[0].id;\n const newAircraft = await getAircraftById(newAircraftId);\n \n return c.json(newAircraft, 201);\n } catch (error) {\n console.error(\"Error creating aircraft:\", error);\n return c.json({ error: \"Failed to create aircraft\" }, 500);\n }\n});\n\n// Update aircraft\napp.put(\"/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({ error: \"Invalid aircraft ID\" }, 400);\n }\n \n try {\n const aircraftData = await c.req.json();\n const existingAircraft = await getAircraftById(id);\n \n if (!existingAircraft) {\n return c.json({ error: \"Aircraft not found\" }, 404);\n }\n \n // Update aircraft\n await sqlite.execute(\n `UPDATE ${TABLES.AIRCRAFT} SET\n registration = ?, type = ?, make = ?, model = ?, year = ?,\n last_annual = ?, next_annual = ?, total_hours = ?, status = ?, notes = ?,\n updated_at = CURRENT_TIMESTAMP\n WHERE id = ?`,\n [\n aircraftData.registration || existingAircraft.registration,\n aircraftData.type || existingAircraft.type,\n aircraftData.make || existingAircraft.make,\n aircraftData.model || existingAircraft.model,\n aircraftData.year || existingAircraft.year,\n aircraftData.lastAnnual || existingAircraft.lastAnnual,\n aircraftData.nextAnnual || existingAircraft.nextAnnual,\n aircraftData.totalHours !== undefined ? aircraftData.totalHours : existingAircraft.totalHours,\n aircraftData.status || existingAircraft.status,\n aircraftData.notes !== undefined ? aircraftData.notes : existingAircraft.notes,\n id\n ]\n );\n \n const updatedAircraft = await getAircraftById(id);\n return c.json(updatedAircraft);\n } catch (error) {\n console.error(`Error updating aircraft ${id}:`, error);\n return c.json({ error: \"Failed to update aircraft\" }, 500);\n }\n});\n\nexport const aircraftRoutes = app;",[],[19,61,195],["D",1747621696065],[205,206],[19,68],{"_36":215,"_13":216,"_39":217,"_41":69,"_43":44,"_45":70,"_47":48,"_49":218,"_17":51,"_52":53,"_54":219,"_56":57,"_58":-5,"_86":220,"_18":221},{"_36":207,"_13":208,"_39":209,"_41":69,"_43":44,"_45":210,"_47":48,"_49":211,"_17":51,"_52":53,"_54":212,"_56":57,"_58":-5,"_86":213,"_18":214},"019276f8-3459-11f0-b615-9e149126039e","queries.ts","019278ec-3459-11f0-b615-9e149126039e",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}",[],[19,68,208],"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}",[],[19,68,216],"88adccf6-3458-11f0-a04d-9e149126039e",["D",1747621530332],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","edf04d00-e0ac-11ef-b589-bf0d59e1abdf","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","c9388b01-c598-4d0f-bacb-e146aba80959","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_274":270},"org",{"_11":12,"_268":-5,"_269":270,"_231":232,"_271":272,"_273":57},"branch",{"_17":116,"_13":16,"_36":44,"_260":222,"_261":-5,"_262":-5,"_263":-5,"_264":-5,"_265":-5,"_266":14,"_267":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJzUmNXSXVCcGRvd0FvMjlRcGo5aVRvRFppdiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_36":222,"_13":14,"_49":367,"_224":-5,"_225":57,"_226":227,"_228":227,"_229":-5,"_230":-5,"_231":232,"_233":-5,"_234":57,"_235":-5,"_236":-5,"_237":51,"_238":239,"_240":-5,"_241":-5,"_242":-5,"_243":-5,"_244":245,"_246":245,"_247":248,"_249":248,"_250":248,"_251":245,"_252":245,"_253":368,"_255":369,"_257":370,"_259":57},[310,323,326,328],"files",[310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328],"counts",{"_301":51,"_302":83,"_303":51,"_32":304,"_305":306},[295,296,297],{"_36":73,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":70,"_47":48,"_49":74,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_18":294},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":71,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_18":300},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":64,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_18":299},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":298},[19,38],[19,61],[19,68],"pulls","branches","forks",{"_307":51,"_309":51},"connections",{"_307":51,"_308":51},"count","unfilledCount","emptyCount",{"_36":73,"_13":19,"_39":42,"_41":-5,"_43":44,"_45":70,"_47":48,"_49":128,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_86":365,"_18":366},{"_36":67,"_13":68,"_39":69,"_41":42,"_43":44,"_45":70,"_47":48,"_49":202,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_86":363,"_18":364},{"_36":215,"_13":216,"_39":217,"_41":69,"_43":44,"_45":70,"_47":48,"_49":218,"_17":51,"_52":53,"_54":219,"_56":57,"_58":-5,"_86":361,"_18":362},{"_36":207,"_13":208,"_39":209,"_41":69,"_43":44,"_45":210,"_47":48,"_49":211,"_17":51,"_52":53,"_54":212,"_56":57,"_58":-5,"_86":359,"_18":360},{"_36":60,"_13":61,"_39":62,"_41":42,"_43":44,"_45":63,"_47":48,"_49":137,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_86":357,"_18":358},{"_36":194,"_13":195,"_39":196,"_41":62,"_43":44,"_45":197,"_47":48,"_49":198,"_17":51,"_52":53,"_54":199,"_56":57,"_58":-5,"_86":355,"_18":356},{"_36":187,"_13":188,"_39":189,"_41":62,"_43":44,"_45":63,"_47":48,"_49":190,"_17":51,"_52":53,"_54":191,"_56":57,"_58":-5,"_86":353,"_18":354},{"_36":179,"_13":180,"_39":181,"_41":62,"_43":44,"_45":182,"_47":48,"_49":183,"_17":51,"_52":53,"_54":184,"_56":57,"_58":-5,"_86":351,"_18":352},{"_36":171,"_13":172,"_39":173,"_41":62,"_43":44,"_45":174,"_47":48,"_49":175,"_17":51,"_52":53,"_54":176,"_56":57,"_58":-5,"_86":349,"_18":350},{"_36":163,"_13":164,"_39":165,"_41":62,"_43":44,"_45":166,"_47":48,"_49":167,"_17":51,"_52":53,"_54":168,"_56":57,"_58":-5,"_86":347,"_18":348},{"_36":155,"_13":156,"_39":157,"_41":62,"_43":44,"_45":158,"_47":48,"_49":159,"_17":51,"_52":53,"_54":160,"_56":57,"_58":-5,"_86":345,"_18":346},{"_36":147,"_13":148,"_39":149,"_41":62,"_43":44,"_45":150,"_47":48,"_49":151,"_17":51,"_52":53,"_54":152,"_56":57,"_58":-5,"_86":343,"_18":344},{"_36":37,"_13":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":134,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_86":341,"_18":342},{"_36":104,"_13":105,"_39":106,"_41":-5,"_43":44,"_45":107,"_47":48,"_49":108,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_86":339,"_18":340},{"_36":121,"_13":122,"_39":123,"_41":106,"_43":44,"_45":107,"_47":48,"_49":124,"_17":51,"_52":24,"_54":125,"_56":57,"_58":-5,"_86":337,"_18":338},{"_36":113,"_13":114,"_39":115,"_41":106,"_43":44,"_45":116,"_47":48,"_49":117,"_17":51,"_52":53,"_54":118,"_56":57,"_58":-5,"_86":335,"_18":336},{"_36":89,"_13":90,"_39":91,"_41":-5,"_43":44,"_45":92,"_47":48,"_49":93,"_17":51,"_52":65,"_54":-5,"_56":57,"_58":-5,"_86":333,"_18":334},{"_36":97,"_13":98,"_39":99,"_41":91,"_43":44,"_45":92,"_47":48,"_49":100,"_17":51,"_52":53,"_54":101,"_56":57,"_58":-5,"_86":331,"_18":332},{"_36":80,"_13":81,"_39":82,"_41":-5,"_43":44,"_45":83,"_47":48,"_49":84,"_17":51,"_52":24,"_54":85,"_56":57,"_58":-5,"_86":329,"_18":330},[],[81],[],[90,98],[327],[90],[],[105,114],[],[105,122],[324,325],[105],[],[19,38],[],[19,61,148],[],[19,61,156],[],[19,61,164],[],[19,61,172],[],[19,61,180],[],[19,61,188],[],[19,61,195],[315,316,317,318,319,320,321],[19,61],[],[19,68,208],[],[19,68,216],[312,313],[19,68],[311,314,322],[19],["D",1747621530332],{"_11":12,"_274":270},{"_11":12,"_268":-5,"_269":270,"_231":232,"_271":272,"_273":57},{"_17":116,"_13":16,"_36":44,"_260":222,"_261":-5,"_262":-5,"_263":-5,"_264":-5,"_265":-5,"_266":14,"_267":12},"ctx",{"_253":-5,"_291":404,"_405":406,"_407":408,"_409":57,"_410":57,"_411":57,"_412":48,"_413":-5,"_414":-7,"_415":-7,"_416":51,"_417":57,"_418":57,"_419":-5,"_420":57,"_421":57,"_422":57,"_423":-5},"ENV",{"_375":376,"_377":378,"_379":16,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","81405aa0531e90dfbb71a5bf473aaa0cf4c8702f","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"]