\n \n \n\n",[],[305,307],"19c6f8cc-3f8d-11f0-9f9b-76b3cceeab13","SearchBar.tsx","ec0d58f6-38ac-41c4-a4ce-fb05553520d6","3136a531-7a21-4545-b0aa-636a71433b00",["D",1748853570330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { SearchFilters } from \"../../shared/types.ts\";\n\ninterface SearchBarProps {\n filters: SearchFilters;\n onFiltersChange: (filters: SearchFilters) => void;\n onSearch: () => void;\n}\n\nexport default function SearchBar({ filters, onFiltersChange, onSearch }: SearchBarProps) {\n const [isExpanded, setIsExpanded] = useState(false);\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n onFiltersChange({\n ...filters,\n [name]: value || undefined\n });\n };\n\n const handleClear = () => {\n onFiltersChange({});\n onSearch();\n };\n\n const handleSubmit = (e: React.FormEvent) => {\n e.preventDefault();\n onSearch();\n };\n\n const hasFilters = Object.values(filters).some(value => value);\n\n return (\n

\n {/* Basic Search Row */}\n

\n \n Make\n \n \n

\n\n

\n \n Model\n \n \n

\n\n

\n \n Color\n \n \n

\n\n

\n \n License Plate\n \n \n

\n\n {/* Advanced Filters (Collapsible) */}\n {isExpanded && (\n

\n \n Report Type\n \n \n \n \n \n \n

\n\n

\n \n Date From\n \n \n

\n\n

\n \n Date To\n \n \n

\n\n

\n \n Location\n \n \n

\n )}\n\n {/* Action Buttons */}\n

\n \n 🔍 Search\n \n\n setIsExpanded(!isExpanded)}\n className=\"bg-gray-100 hover:bg-gray-200 text-gray-700 px-6 py-2 rounded-md font-medium transition-colors\"\n >\n {isExpanded ? '▲ Less Filters' : '▼ More Filters'}\n \n\n {hasFilters && (\n \n ✕ Clear All\n \n )}\n

\n\n {/* Active Filters Display */}\n {hasFilters && (\n

Active filters:

\n {Object.entries(filters).map(([key, value]) => {\n if (!value) return null;\n return (\n \n {key.replace('_', ' ')}: {value}\n onFiltersChange({ ...filters, [key]: undefined })}\n className=\"ml-2 text-blue-600 hover:text-blue-800\"\n >\n ×\n \n \n );\n })}\n

\n )}\n

\n );\n}",[],[305,321,314],"components","19c6f106-3f8d-11f0-9f9b-76b3cceeab13","ReportStolen.tsx","1a7ceda5-83b6-469c-9c8d-86821238b443",["D",1748853570330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { StolenCar } from \"../../shared/types.ts\";\n\ninterface ReportStolenProps {\n onSuccess: () => void;\n onCancel: () => void;\n}\n\nexport default function ReportStolen({ onSuccess, onCancel }: ReportStolenProps) {\n const [formData, setFormData] = useState>({\n status: 'active'\n });\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError(null);\n\n try {\n const response = await fetch('/api/stolen', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(formData),\n });\n\n const data = await response.json();\n\n if (data.success) {\n onSuccess();\n } else {\n setError(data.error || 'Failed to submit report');\n }\n } catch (err) {\n setError('Network error. Please try again.');\n } finally {\n setLoading(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: name === 'year' ? parseInt(value) || undefined : value\n }));\n };\n\n return (\n

Report Stolen Vehicle

\n Please provide as much detail as possible to help identify your stolen vehicle.\n

\n\n {error && (\n

\n ❌\n {error}\n

\n )}\n\n

\n {/* Vehicle Information */}\n

Vehicle Information

\n \n Make *\n \n \n

\n\n

\n \n Model *\n \n \n

\n\n

\n \n Year *\n \n \n

\n\n

\n \n Color *\n \n \n

\n\n

\n \n License Plate *\n \n \n

\n\n

\n \n VIN (Optional)\n \n \n

\n\n

\n \n Additional Description\n \n \n

\n\n {/* Theft Information */}\n

Theft Information

\n \n Date Stolen *\n \n \n

\n\n

\n \n Police Report Number\n \n \n

\n\n

\n \n Location Where Stolen *\n \n \n

\n\n {/* Contact Information */}\n

Contact Information

\n \n Your Name *\n \n \n

\n\n

\n \n Phone Number *\n \n \n

\n\n

\n \n Email Address *\n \n \n

\n\n {/* Safety Notice */}\n

\n ⚠️\n

\n Important: Make sure you have filed a police report before submitting this form. \n This platform is designed to assist, not replace, official police investigations.\n

\n\n {/* Form Actions */}\n

\n \n {loading ? 'Submitting...' : 'Submit Stolen Car Report'}\n \n \n Cancel\n \n

\n );\n}",[],[305,321,323],"19c6e85a-3f8d-11f0-9f9b-76b3cceeab13","ReportFound.tsx","df0e70cf-46f3-4e23-a490-fcb6001c1ea7",["D",1748853570330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { FoundCar } from \"../../shared/types.ts\";\n\ninterface ReportFoundProps {\n onSuccess: () => void;\n onCancel: () => void;\n}\n\nexport default function ReportFound({ onSuccess, onCancel }: ReportFoundProps) {\n const [formData, setFormData] = useState>({\n status: 'active'\n });\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError(null);\n\n try {\n const response = await fetch('/api/found', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(formData),\n });\n\n const data = await response.json();\n\n if (data.success) {\n onSuccess();\n } else {\n setError(data.error || 'Failed to submit report');\n }\n } catch (err) {\n setError('Network error. Please try again.');\n } finally {\n setLoading(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: name === 'year' ? parseInt(value) || undefined : value\n }));\n };\n\n return (\n

Report Found Vehicle

\n Help reunite a found or suspicious vehicle with its owner. Provide as much detail as possible.\n

\n\n {error && (\n

\n ❌\n {error}\n

\n )}\n\n

\n {/* Vehicle Information */}\n

Vehicle Information

\n \n Make (if known)\n \n \n

\n\n

\n \n Model (if known)\n \n \n

\n\n

\n \n Year (if known)\n \n \n

\n\n

\n \n Color *\n \n \n

\n\n

\n \n License Plate (if visible)\n \n \n

\n\n

\n \n Detailed Description *\n \n \n

\n\n

\n \n Photo URL (Optional)\n \n \n

\n If you have photos, upload them to a service like Imgur and paste the link here.\n

\n\n {/* Location Information */}\n

Location Information

\n \n Date Found *\n \n \n

\n\n

\n \n Time Found (Optional)\n \n \n

\n\n

\n \n Location Where Found *\n \n \n

\n Be as specific as possible about the location.\n

\n\n {/* Contact Information */}\n

Your Contact Information

\n \n Your Name *\n \n \n

\n\n

\n \n Phone Number *\n \n \n

\n\n

\n \n Email Address *\n \n \n

\n\n {/* Safety Notice */}\n

\n ⚠️\n

\n Safety First: If you suspect the vehicle is stolen or involved in criminal activity, \n contact local law enforcement immediately. Do not approach the vehicle or attempt to investigate yourself.\n

\n\n {/* Form Actions */}\n

\n \n {loading ? 'Submitting...' : 'Submit Found Car Report'}\n \n \n Cancel\n \n

\n );\n}",[],[305,321,330],"19c6e2ce-3f8d-11f0-9f9b-76b3cceeab13","Hero.tsx","5f37b004-5398-4f5b-a6c1-d20720659ae2",["D",1748853570330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\n\ninterface HeroProps {\n onNavigate: (view: string) => void;\n}\n\nexport default function Hero({ onNavigate }: HeroProps) {\n return (\n

\n 🚗 Lost Cars Finder\n

\n Help reunite stolen vehicles with their owners through community cooperation\n

\n Whether you've had your car stolen or found a suspicious vehicle, \n our platform connects car owners with good Samaritans to help recover stolen vehicles.\n

\n\n {/* Action Cards */}\n

\n {/* Report Stolen Card */}\n

onNavigate('report-stolen')}>\n

🚨

Report Stolen Car

\n Had your car stolen? Report it here with detailed information \n to help the community identify and locate your vehicle.\n

\n Report Stolen Vehicle →\n

\n\n {/* Report Found Card */}\n

onNavigate('report-found')}>\n

✅

Report Found Car

\n Found a suspicious or abandoned vehicle? Report it to help \n reunite it with its rightful owner.\n

\n Report Found Vehicle →\n

\n\n {/* Secondary Actions */}\n

\n onNavigate('search')}\n className=\"bg-white/20 hover:bg-white/30 text-white px-8 py-3 rounded-lg font-semibold transition-colors backdrop-blur-sm\"\n >\n 🔍 Search All Reports\n \n onNavigate('matches')}\n className=\"bg-white/20 hover:bg-white/30 text-white px-8 py-3 rounded-lg font-semibold transition-colors backdrop-blur-sm\"\n >\n 🤝 View Matches\n \n

\n\n {/* Features Section */}\n

\n How It Works\n

\n \n

📝

Report

\n Car owners report stolen vehicles with detailed descriptions, \n photos, and location information.\n

\n \n

🔍

Search

\n Good Samaritans report found or suspicious vehicles, \n and our system automatically matches them with stolen car reports.\n

\n \n

🤝

Reunite

\n When matches are found, we connect car owners with finders \n to help recover stolen vehicles safely.\n

\n\n {/* Safety Notice */}\n

⚠️

Important Safety Notice

\n Always contact local law enforcement when dealing with stolen vehicles. \n This platform is designed to assist, not replace, official police reports and investigations.\n Never attempt to recover a stolen vehicle yourself - contact authorities immediately.\n

\n );\n}",[],[305,321,337],"19c6dfcc-3f8d-11f0-9f9b-76b3cceeab13","Header.tsx","c6600590-0fc9-4b89-b2a5-65c4e8855c42",["D",1748853570330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\n\ninterface HeaderProps {\n currentView: string;\n onNavigate: (view: any) => void;\n}\n\nexport default function Header({ currentView, onNavigate }: HeaderProps) {\n const navItems = [\n { id: 'home', label: 'Home', icon: '🏠' },\n { id: 'search', label: 'Search Cars', icon: '🔍' },\n { id: 'matches', label: 'Matches', icon: '🤝' },\n { id: 'report-stolen', label: 'Report Stolen', icon: '🚨' },\n { id: 'report-found', label: 'Report Found', icon: '✅' },\n ];\n\n return (\n

\n {/* Logo */}\n

onNavigate('home')}\n >\n 🚗\n Lost Cars Finder\n

\n\n {/* Navigation */}\n \n\n {/* Mobile menu button */}\n

\n {\n const menu = document.getElementById('mobile-menu');\n menu?.classList.toggle('hidden');\n }}\n >\n ☰\n \n

\n\n {/* Mobile menu */}\n

\n {navItems.map((item) => (\n {\n onNavigate(item.id);\n document.getElementById('mobile-menu')?.classList.add('hidden');\n }}\n className={`block w-full text-left px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n currentView === item.id\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-600 hover:text-gray-900 hover:bg-gray-100'\n }`}\n >\n {item.icon}\n {item.label}\n \n ))}\n

\n );\n}",[],[305,321,344],"19c6dbee-3f8d-11f0-9f9b-76b3cceeab13","App.tsx","cc8df4a8-3a42-4f80-a908-007e9fa45731",["D",1748853570330],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { StolenCar, FoundCar, SearchFilters } from \"../../shared/types.ts\";\nimport Header from \"./Header.tsx\";\nimport Hero from \"./Hero.tsx\";\nimport ReportStolen from \"./ReportStolen.tsx\";\nimport ReportFound from \"./ReportFound.tsx\";\nimport CarList from \"./CarList.tsx\";\nimport SearchBar from \"./SearchBar.tsx\";\nimport MatchesList from \"./MatchesList.tsx\";\n\ntype View = 'home' | 'report-stolen' | 'report-found' | 'search' | 'matches';\n\nexport default function App() {\n const [currentView, setCurrentView] = useState('home');\n const [stolenCars, setStolenCars] = useState([]);\n const [foundCars, setFoundCars] = useState([]);\n const [loading, setLoading] = useState(false);\n const [searchFilters, setSearchFilters] = useState({});\n\n // Load initial data\n useEffect(() => {\n if (currentView === 'search') {\n loadCars();\n }\n }, [currentView, searchFilters]);\n\n const loadCars = async () => {\n setLoading(true);\n try {\n const params = new URLSearchParams();\n Object.entries(searchFilters).forEach(([key, value]) => {\n if (value) params.append(key, value.toString());\n });\n\n const response = await fetch(`/api/search?${params}`);\n const data = await response.json();\n \n if (data.success) {\n setStolenCars(data.data.stolen || []);\n setFoundCars(data.data.found || []);\n }\n } catch (error) {\n console.error('Error loading cars:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleReportSuccess = () => {\n setCurrentView('home');\n // Show success message\n alert('Report submitted successfully! Thank you for helping reunite cars with their owners.');\n };\n\n const renderView = () => {\n switch (currentView) {\n case 'report-stolen':\n return (\n setCurrentView('home')}\n />\n );\n \n case 'report-found':\n return (\n setCurrentView('home')}\n />\n );\n \n case 'search':\n return (\n

Search Cars

\n \n

\n \n \n

\n );\n \n case 'matches':\n return (\n

\n \n

\n );\n \n default:\n return ;\n }\n };\n\n return (\n

\n {renderView()}\n \n {/* Footer */}\n \n

\n );\n}",[],[305,321,351],"19c6ff52-3f8d-11f0-9f9b-76b3cceeab13",["D",1748853570330],[235,236,237,238,239,240],[305,321],"19c70916-3f8d-11f0-9f9b-76b3cceeab13",["D",1748853570330],[234,241,242],[305],"19c6d608-3f8d-11f0-9f9b-76b3cceeab13","index.ts","5a7cd6d6-ed09-4025-929b-c74e3486174d",["D",1748853570330],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createTables } from \"./database/migrations.ts\";\n\n// Import route modules\nimport stolenRoutes from \"./routes/stolen.ts\";\nimport foundRoutes from \"./routes/found.ts\";\nimport matchRoutes from \"./routes/matches.ts\";\nimport searchRoutes from \"./routes/search.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nawait createTables();\n\n// API Routes\napp.route(\"/api/stolen\", stolenRoutes);\napp.route(\"/api/found\", foundRoutes);\napp.route(\"/api/matches\", matchRoutes);\napp.route(\"/api/search\", searchRoutes);\n\n// Health check endpoint\napp.get(\"/api/health\", (c) => {\n return c.json({ \n status: \"healthy\", \n timestamp: new Date().toISOString(),\n service: \"Lost Cars Finder API\"\n });\n});\n\n// Serve static 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 main page with initial data\napp.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial data to avoid extra round-trips\n const initialData = {\n timestamp: new Date().toISOString(),\n apiBase: \"/api\"\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.html(`\n \n \n \n Lost Cars Finder\n \n \n \n \n \n

🚗 Lost Cars Finder

Help reunite stolen vehicles with their owners

Frontend not found

The frontend files are being created. Please refresh in a moment.

\n API is running at /api - \n Check health\n

\n \n \n `);\n }\n});\n\n// 404 handler\napp.notFound((c) => {\n return c.json({ \n success: false, \n error: \"Endpoint not found\",\n available_endpoints: [\n \"GET /api/health\",\n \"GET /api/stolen\",\n \"POST /api/stolen\",\n \"GET /api/found\", \n \"POST /api/found\",\n \"GET /api/matches\",\n \"GET /api/search\"\n ]\n }, 404);\n});\n\nexport default app;",[],[193,366],["D",1748853570330],[],[193,101,88],["D",1748853570330],[],[193,101,76],["D",1748853570330],[],[193,101,94],["D",1748853570330],[],[193,101,99],["D",1748853570330],[228,229,230,231],[193,101],"19c6b772-3f8d-11f0-9f9b-76b3cceeab13","queries.ts","3da39e4d-e973-4563-93ad-8a454b97b2c1","0115e15a-b324-4718-967f-6a6a90727425",["D",1748853570330],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { STOLEN_CARS_TABLE, FOUND_CARS_TABLE, MATCHES_TABLE } from \"./migrations.ts\";\nimport type { StolenCar, FoundCar, CarMatch, SearchFilters } from \"../../shared/types.ts\";\n\n// Stolen Cars Queries\nexport async function createStolenCarReport(car: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${STOLEN_CARS_TABLE} (\n make, model, year, color, license_plate, vin, description,\n stolen_date, stolen_location, stolen_lat, stolen_lng,\n owner_name, owner_phone, owner_email, police_report_number, status\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n car.make, car.model, car.year, car.color, car.license_plate, car.vin, car.description,\n car.stolen_date, car.stolen_location, car.stolen_lat, car.stolen_lng,\n car.owner_name, car.owner_phone, car.owner_email, car.police_report_number, car.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getStolenCars(filters?: SearchFilters): Promise {\n let query = `SELECT * FROM ${STOLEN_CARS_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (filters?.make) {\n query += ` AND LOWER(make) LIKE LOWER(?)`;\n params.push(`%${filters.make}%`);\n }\n if (filters?.model) {\n query += ` AND LOWER(model) LIKE LOWER(?)`;\n params.push(`%${filters.model}%`);\n }\n if (filters?.color) {\n query += ` AND LOWER(color) LIKE LOWER(?)`;\n params.push(`%${filters.color}%`);\n }\n if (filters?.license_plate) {\n query += ` AND LOWER(license_plate) LIKE LOWER(?)`;\n params.push(`%${filters.license_plate}%`);\n }\n if (filters?.date_from) {\n query += ` AND stolen_date >= ?`;\n params.push(filters.date_from);\n }\n if (filters?.date_to) {\n query += ` AND stolen_date <= ?`;\n params.push(filters.date_to);\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as StolenCar[];\n}\n\nexport async function getStolenCarById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${STOLEN_CARS_TABLE} WHERE id = ?`, [id]);\n return result.rows[0] as StolenCar || null;\n}\n\nexport async function updateStolenCarStatus(id: number, status: 'active' | 'found' | 'resolved'): Promise {\n await sqlite.execute(`UPDATE ${STOLEN_CARS_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Found Cars Queries\nexport async function createFoundCarReport(car: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${FOUND_CARS_TABLE} (\n make, model, year, color, license_plate, description,\n found_date, found_location, found_lat, found_lng, photo_url,\n reporter_name, reporter_phone, reporter_email, status\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n car.make, car.model, car.year, car.color, car.license_plate, car.description,\n car.found_date, car.found_location, car.found_lat, car.found_lng, car.photo_url,\n car.reporter_name, car.reporter_phone, car.reporter_email, car.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getFoundCars(filters?: SearchFilters): Promise {\n let query = `SELECT * FROM ${FOUND_CARS_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (filters?.make) {\n query += ` AND LOWER(make) LIKE LOWER(?)`;\n params.push(`%${filters.make}%`);\n }\n if (filters?.model) {\n query += ` AND LOWER(model) LIKE LOWER(?)`;\n params.push(`%${filters.model}%`);\n }\n if (filters?.color) {\n query += ` AND LOWER(color) LIKE LOWER(?)`;\n params.push(`%${filters.color}%`);\n }\n if (filters?.license_plate) {\n query += ` AND LOWER(license_plate) LIKE LOWER(?)`;\n params.push(`%${filters.license_plate}%`);\n }\n if (filters?.date_from) {\n query += ` AND found_date >= ?`;\n params.push(filters.date_from);\n }\n if (filters?.date_to) {\n query += ` AND found_date <= ?`;\n params.push(filters.date_to);\n }\n\n query += ` ORDER BY created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as FoundCar[];\n}\n\nexport async function getFoundCarById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${FOUND_CARS_TABLE} WHERE id = ?`, [id]);\n return result.rows[0] as FoundCar || null;\n}\n\nexport async function updateFoundCarStatus(id: number, status: 'active' | 'matched' | 'resolved'): Promise {\n await sqlite.execute(`UPDATE ${FOUND_CARS_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Matching System\nexport async function findPotentialMatches(foundCarId: number): Promise {\n const foundCar = await getFoundCarById(foundCarId);\n if (!foundCar) return [];\n\n let query = `SELECT * FROM ${STOLEN_CARS_TABLE} WHERE status = 'active'`;\n const params: any[] = [];\n\n // Exact license plate match (highest priority)\n if (foundCar.license_plate) {\n query += ` AND license_plate = ?`;\n params.push(foundCar.license_plate);\n } else {\n // Match by make, model, color if no license plate\n const conditions: string[] = [];\n \n if (foundCar.make) {\n conditions.push(`LOWER(make) = LOWER(?)`);\n params.push(foundCar.make);\n }\n if (foundCar.model) {\n conditions.push(`LOWER(model) = LOWER(?)`);\n params.push(foundCar.model);\n }\n if (foundCar.color) {\n conditions.push(`LOWER(color) = LOWER(?)`);\n params.push(foundCar.color);\n }\n if (foundCar.year) {\n conditions.push(`year = ?`);\n params.push(foundCar.year);\n }\n\n if (conditions.length > 0) {\n query += ` AND (${conditions.join(' OR ')})`;\n }\n }\n\n const result = await sqlite.execute(query, params);\n return result.rows as StolenCar[];\n}\n\nexport async function createMatch(match: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${MATCHES_TABLE} (stolen_car_id, found_car_id, match_score, match_reasons, status)\n VALUES (?, ?, ?, ?, ?)\n `, [\n match.stolen_car_id, \n match.found_car_id, \n match.match_score, \n JSON.stringify(match.match_reasons), \n match.status\n ]);\n \n return result.lastInsertRowId as number;\n}\n\nexport async function getMatches(stolenCarId?: number, foundCarId?: number): Promise {\n let query = `SELECT * FROM ${MATCHES_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (stolenCarId) {\n query += ` AND stolen_car_id = ?`;\n params.push(stolenCarId);\n }\n if (foundCarId) {\n query += ` AND found_car_id = ?`;\n params.push(foundCarId);\n }\n\n query += ` ORDER BY match_score DESC, created_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows.map(row => ({\n ...row,\n match_reasons: JSON.parse(row.match_reasons as string)\n })) as CarMatch[];\n}\n\nexport async function updateMatchStatus(id: number, status: 'pending' | 'confirmed' | 'rejected'): Promise {\n await sqlite.execute(`UPDATE ${MATCHES_TABLE} SET status = ? WHERE id = ?`, [status, id]);\n}\n\n// Search across both tables\nexport async function searchAllCars(filters: SearchFilters) {\n const results = {\n stolen: [] as StolenCar[],\n found: [] as FoundCar[]\n };\n\n if (filters.type === 'stolen' || filters.type === 'all' || !filters.type) {\n results.stolen = await getStolenCars(filters);\n }\n\n if (filters.type === 'found' || filters.type === 'all' || !filters.type) {\n results.found = await getFoundCars(filters);\n }\n\n return results;\n}",[],[193,395,388],"database","19c69b98-3f8d-11f0-9f9b-76b3cceeab13","migrations.ts","5fcc9de4-c22d-46c0-95f8-fec86f25ad33",["D",1748853570330],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport const STOLEN_CARS_TABLE = 'stolen_cars_v1';\nexport const FOUND_CARS_TABLE = 'found_cars_v1';\nexport const MATCHES_TABLE = 'car_matches_v1';\n\nexport async function createTables() {\n // Create stolen cars table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${STOLEN_CARS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n make TEXT NOT NULL,\n model TEXT NOT NULL,\n year INTEGER NOT NULL,\n color TEXT NOT NULL,\n license_plate TEXT NOT NULL,\n vin TEXT,\n description TEXT,\n stolen_date TEXT NOT NULL,\n stolen_location TEXT NOT NULL,\n stolen_lat REAL,\n stolen_lng REAL,\n owner_name TEXT NOT NULL,\n owner_phone TEXT NOT NULL,\n owner_email TEXT NOT NULL,\n police_report_number TEXT,\n status TEXT NOT NULL DEFAULT 'active' CHECK (status IN ('active', 'found', 'resolved')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Create found cars table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${FOUND_CARS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n make TEXT,\n model TEXT,\n year INTEGER,\n color TEXT NOT NULL,\n license_plate TEXT,\n description TEXT NOT NULL,\n found_date TEXT NOT NULL,\n found_location TEXT NOT NULL,\n found_lat REAL,\n found_lng REAL,\n photo_url TEXT,\n reporter_name TEXT NOT NULL,\n reporter_phone TEXT NOT NULL,\n reporter_email TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'active' CHECK (status IN ('active', 'matched', 'resolved')),\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )\n `);\n\n // Create matches table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${MATCHES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n stolen_car_id INTEGER NOT NULL,\n found_car_id INTEGER NOT NULL,\n match_score REAL NOT NULL,\n match_reasons TEXT NOT NULL,\n status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN ('pending', 'confirmed', 'rejected')),\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (stolen_car_id) REFERENCES ${STOLEN_CARS_TABLE}(id),\n FOREIGN KEY (found_car_id) REFERENCES ${FOUND_CARS_TABLE}(id)\n )\n `);\n\n // Create indexes for better search performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_make ON ${STOLEN_CARS_TABLE}(make);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_model ON ${STOLEN_CARS_TABLE}(model);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_license ON ${STOLEN_CARS_TABLE}(license_plate);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_stolen_status ON ${STOLEN_CARS_TABLE}(status);`);\n \n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_color ON ${FOUND_CARS_TABLE}(color);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_license ON ${FOUND_CARS_TABLE}(license_plate);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_found_status ON ${FOUND_CARS_TABLE}(status);`);\n \n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_stolen ON ${MATCHES_TABLE}(stolen_car_id);`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_found ON ${MATCHES_TABLE}(found_car_id);`);\n\n console.log('Database tables created successfully');\n}",[],[193,395,397],"19c6c046-3f8d-11f0-9f9b-76b3cceeab13",["D",1748853570330],[225,226],[193,395],"19c6da90-3f8d-11f0-9f9b-76b3cceeab13",["D",1748853570330],[224,227,232],[193],["D",1748853570330],{"_11":12,"_152":82},{"_11":12,"_148":-5,"_81":82,"_31":80,"_149":150,"_151":30},{"_39":40,"_13":16,"_33":36,"_137":104,"_138":71,"_139":140,"_141":108,"_142":143,"_144":145,"_146":14,"_147":12},"ctx",{"_52":-5,"_173":448,"_449":450,"_451":452,"_453":30,"_454":30,"_455":30,"_456":24,"_457":-5,"_458":-7,"_459":-7,"_460":26,"_461":30,"_462":30,"_463":-5,"_464":30,"_465":30,"_466":30,"_467":-5},"ENV",{"_419":420,"_421":422,"_423":16,"_424":425,"_426":427,"_428":429,"_430":431,"_432":433,"_434":435,"_436":437,"_438":439,"_440":441,"_442":443,"_444":445,"_446":447},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

History · routes