FindMyCar - Lost Car Reporting

\n\n

Report Stolen Vehicle

\n \n\n \n\n\n`; TypeScript types\n```\n\n## Getting Started\n\n1. The app runs on `/backend/index.ts` as an HTTP val\n2. Visit the main page to start reporting or searching for cars\n3. Use the map view to see locations of reported vehicles\n\n## Database\n\nUses SQLite with tables for:\n- `stolen_cars` - Reports from car owners\n- `found_cars` - Reports from people who found vehicles\n- `matches` - Potential matches between stolen and found cars","deleted","label",[127],"efb773d4-3f84-11f0-a1f4-76b3cceeab13","shared","d0f372b1-a8f7-4978-b98a-109430d74356",3,["D",1748850063838],"directory",[144],"1fcba7e2-3f86-11f0-841e-76b3cceeab13","frontend","73021414-5f1c-4084-8d32-2442eaba72c6",18,["D",1748850573997],[151],"f4bc9b34-3f84-11f0-917f-76b3cceeab13","backend","af436097-5c4b-4ae1-9232-154369ce0aba",4,["D",1748850072260],[157],"pulls","branches","envVars",{"_168":22,"_170":22},"connections",{"_168":22,"_169":22},"count","unfilledCount","emptyCount",{"_27":156,"_13":157,"_128":158,"_130":-5,"_131":88,"_132":159,"_134":46,"_47":365,"_85":22,"_137":148,"_138":-5,"_140":20,"_141":-5,"_197":366,"_99":367},{"_27":361,"_13":360,"_128":355,"_130":158,"_131":88,"_132":159,"_134":46,"_47":362,"_85":22,"_137":148,"_138":-5,"_140":20,"_141":-5,"_197":363,"_99":364},{"_27":352,"_13":353,"_128":354,"_130":355,"_131":88,"_132":86,"_134":46,"_47":356,"_85":203,"_137":205,"_138":357,"_140":20,"_141":-5,"_197":358,"_99":359},{"_27":348,"_13":323,"_128":317,"_130":158,"_131":88,"_132":318,"_134":46,"_47":349,"_85":22,"_137":148,"_138":-5,"_140":20,"_141":-5,"_197":350,"_99":351},{"_27":340,"_13":341,"_128":342,"_130":317,"_131":88,"_132":343,"_134":46,"_47":344,"_85":22,"_137":205,"_138":345,"_140":20,"_141":-5,"_197":346,"_99":347},{"_27":332,"_13":333,"_128":334,"_130":317,"_131":88,"_132":335,"_134":46,"_47":336,"_85":22,"_137":205,"_138":337,"_140":20,"_141":-5,"_197":338,"_99":339},{"_27":324,"_13":325,"_128":326,"_130":317,"_131":88,"_132":327,"_134":46,"_47":328,"_85":22,"_137":205,"_138":329,"_140":20,"_141":-5,"_197":330,"_99":331},{"_27":314,"_13":315,"_128":316,"_130":317,"_131":88,"_132":318,"_134":46,"_47":319,"_85":22,"_137":205,"_138":320,"_140":20,"_141":-5,"_197":321,"_99":322},{"_27":150,"_13":151,"_128":152,"_130":-5,"_131":88,"_132":153,"_134":46,"_47":311,"_85":22,"_137":148,"_138":-5,"_140":20,"_141":-5,"_197":312,"_99":313},{"_27":306,"_13":289,"_128":284,"_130":152,"_131":88,"_132":307,"_134":46,"_47":308,"_85":24,"_137":148,"_138":-5,"_140":20,"_141":-5,"_197":309,"_99":310},{"_27":298,"_13":299,"_128":300,"_130":284,"_131":88,"_132":301,"_134":46,"_47":302,"_85":136,"_137":205,"_138":303,"_140":20,"_141":-5,"_197":304,"_99":305},{"_27":290,"_13":291,"_128":64,"_130":284,"_131":88,"_132":292,"_134":46,"_47":293,"_85":136,"_137":294,"_138":295,"_140":20,"_141":-5,"_197":296,"_99":297},{"_27":281,"_13":282,"_128":283,"_130":284,"_131":88,"_132":285,"_134":46,"_47":286,"_85":22,"_137":205,"_138":100,"_140":20,"_141":-5,"_197":287,"_99":288},{"_27":277,"_13":236,"_128":230,"_130":152,"_131":88,"_132":272,"_134":46,"_47":278,"_85":22,"_137":148,"_138":-5,"_140":20,"_141":-5,"_197":279,"_99":280},{"_27":269,"_13":270,"_128":271,"_130":230,"_131":88,"_132":272,"_134":46,"_47":273,"_85":22,"_137":205,"_138":274,"_140":20,"_141":-5,"_197":275,"_99":276},{"_27":261,"_13":262,"_128":263,"_130":230,"_131":88,"_132":264,"_134":46,"_47":265,"_85":22,"_137":205,"_138":266,"_140":20,"_141":-5,"_197":267,"_99":268},{"_27":253,"_13":254,"_128":255,"_130":230,"_131":88,"_132":256,"_134":46,"_47":257,"_85":22,"_137":205,"_138":258,"_140":20,"_141":-5,"_197":259,"_99":260},{"_27":245,"_13":246,"_128":247,"_130":230,"_131":88,"_132":248,"_134":46,"_47":249,"_85":22,"_137":205,"_138":250,"_140":20,"_141":-5,"_197":251,"_99":252},{"_27":237,"_13":238,"_128":239,"_130":230,"_131":88,"_132":240,"_134":46,"_47":241,"_85":22,"_137":205,"_138":242,"_140":20,"_141":-5,"_197":243,"_99":244},{"_27":227,"_13":228,"_128":229,"_130":230,"_131":88,"_132":231,"_134":46,"_47":232,"_85":22,"_137":205,"_138":233,"_140":20,"_141":-5,"_197":234,"_99":235},{"_27":220,"_13":221,"_128":222,"_130":152,"_131":88,"_132":153,"_134":46,"_47":223,"_85":22,"_137":111,"_138":224,"_140":20,"_141":-5,"_197":225,"_99":226},{"_27":212,"_13":213,"_128":214,"_130":152,"_131":88,"_132":215,"_134":46,"_47":216,"_85":22,"_137":205,"_138":217,"_140":20,"_141":-5,"_197":218,"_99":219},{"_27":143,"_13":144,"_128":145,"_130":-5,"_131":88,"_132":146,"_134":46,"_47":209,"_85":22,"_137":148,"_138":-5,"_140":20,"_141":-5,"_197":210,"_99":211},{"_27":200,"_13":201,"_128":202,"_130":145,"_131":88,"_132":203,"_134":46,"_47":204,"_85":24,"_137":205,"_138":206,"_140":20,"_141":-5,"_197":207,"_99":208},{"_27":126,"_13":127,"_128":129,"_130":-5,"_131":88,"_132":133,"_134":46,"_47":196,"_85":136,"_137":111,"_138":139,"_140":20,"_141":-5,"_197":198,"_99":199},["D",1748861639795],"children",[],[127],"765053ca-3f85-11f0-948f-76b3cceeab13","types.ts","efb76b82-3f84-11f0-a1f4-76b3cceeab13",6,["D",1748850289651],"script","// Shared types for the Lost Cars Finder app\n\nexport interface StolenCar {\n id?: number;\n make: string;\n model: string;\n year: number;\n color: string;\n license_plate: string;\n vin?: string;\n description?: string;\n stolen_date: string;\n stolen_location: string;\n stolen_lat?: number;\n stolen_lng?: number;\n owner_name: string;\n owner_phone: string;\n owner_email: string;\n police_report_number?: string;\n created_at?: string;\n status: 'active' | 'found' | 'resolved';\n}\n\nexport interface FoundCar {\n id?: number;\n make?: string;\n model?: string;\n year?: number;\n color: string;\n license_plate?: string;\n description: string;\n found_date: string;\n found_location: string;\n found_lat?: number;\n found_lng?: number;\n photo_url?: string;\n reporter_name: string;\n reporter_phone: string;\n reporter_email: string;\n created_at?: string;\n status: 'active' | 'matched' | 'resolved';\n}\n\nexport interface CarMatch {\n id?: number;\n stolen_car_id: number;\n found_car_id: number;\n match_score: number;\n match_reasons: string[];\n created_at?: string;\n status: 'pending' | 'confirmed' | 'rejected';\n}\n\nexport interface Location {\n lat: number;\n lng: number;\n address?: string;\n}\n\nexport interface SearchFilters {\n make?: string;\n model?: string;\n color?: string;\n license_plate?: string;\n location?: string;\n date_from?: string;\n date_to?: string;\n type?: 'stolen' | 'found' | 'all';\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n message?: string;\n}",[],[144,201],["D",1748850063838],[194],[144],"25d16adc-3f86-11f0-b1f4-76b3cceeab13","index.tsx","25d16ba4-3f86-11f0-b1f4-76b3cceeab13",19,["D",1748850584106],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[151,213],"1fcb9e00-3f86-11f0-841e-76b3cceeab13","index.html","1fcb9ff4-3f86-11f0-841e-76b3cceeab13",["D",1748850573997],"\n\n\n \n \n Lost Cars Finder - Help Reunite Stolen Vehicles\n \n \n \n\n\n

\n \n \n\n",[],[151,221],"8fc293c6-3f86-11f0-8444-76b3cceeab13","SearchBar.tsx","8fc2947a-3f86-11f0-8444-76b3cceeab13","704664e4-750c-4a1a-9e28-d06b5ce01ec7",25,["D",1748850761837],"/** @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}",[],[151,236,228],"components","64b86ae8-3f86-11f0-97d4-76b3cceeab13","ReportStolen.tsx","64b86b92-3f86-11f0-97d4-76b3cceeab13",23,["D",1748850689640],"/** @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}",[],[151,236,238],"7dd2e5e4-3f86-11f0-8bf6-76b3cceeab13","ReportFound.tsx","7dd2e6d4-3f86-11f0-8bf6-76b3cceeab13",24,["D",1748850731756],"/** @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}",[],[151,236,246],"4b3c532c-3f86-11f0-9218-76b3cceeab13","Hero.tsx","4b3c53b8-3f86-11f0-9218-76b3cceeab13",22,["D",1748850646884],"/** @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}",[],[151,236,254],"3cc6ee38-3f86-11f0-b159-76b3cceeab13","Header.tsx","3cc6eed8-3f86-11f0-b159-76b3cceeab13",21,["D",1748850622624],"/** @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}",[],[151,236,262],"3249adb0-3f86-11f0-b8b6-76b3cceeab13","App.tsx","3249ae78-3f86-11f0-b8b6-76b3cceeab13",20,["D",1748850605021],"/** @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}",[],[151,236,270],"3249b99a-3f86-11f0-b8b6-76b3cceeab13",["D",1748850605021],[185,186,187,188,189,190],[151,236],"55e1c1d4-3f9c-11f0-98b8-76b3cceeab13","new-file-3815.tsx","55e1c292-3f9c-11f0-98b8-76b3cceeab13","1e0b3aba-3f9c-11f0-962f-76b3cceeab13",32,["D",1748860113674],[],[151,289,282],"Front","355dc552-3f9c-11f0-a95b-76b3cceeab13","new-file-2298.tsx",31,["D",1748860059116],"http","export default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}",[],[151,289,291],"5c96b26e-3f9c-11f0-bb30-76b3cceeab13","2.tsx","56d91c04-3f9c-11f0-be27-76b3cceeab13",35,["D",1748860124922],"export default createServer((req) => new Response(`\n \n \n \n

FindMyCar

تطبيق لتتبع السيارات المسروقة.

\n \n \n`, { headers: { \"Content-Type\": \"text/html\" } }));",[],[151,289,299],"28b5a7b6-3f9c-11f0-8ca3-76b3cceeab13",28,["D",1748860037882],[181,182,183],[151,289],["D",1748850573997],[180,184,191,192],[151],"e53b04f6-3f85-11f0-b014-76b3cceeab13","stolen.ts","e53b058c-3f85-11f0-b014-76b3cceeab13","3504feee-a91e-470b-a5ed-d57a41f7ab5c",9,["D",1748850475745],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { StolenCar, ApiResponse } from \"../../shared/types.ts\";\nimport { \n createStolenCarReport, \n getStolenCars, \n getStolenCarById, \n updateStolenCarStatus \n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all stolen cars with optional filters\napp.get(\"/\", async (c) => {\n try {\n const filters = {\n make: c.req.query(\"make\"),\n model: c.req.query(\"model\"),\n color: c.req.query(\"color\"),\n license_plate: c.req.query(\"license_plate\"),\n date_from: c.req.query(\"date_from\"),\n date_to: c.req.query(\"date_to\"),\n };\n\n // Remove undefined values\n const cleanFilters = Object.fromEntries(\n Object.entries(filters).filter(([_, value]) => value !== undefined)\n );\n\n const cars = await getStolenCars(Object.keys(cleanFilters).length > 0 ? cleanFilters : undefined);\n \n const response: ApiResponse = {\n success: true,\n data: cars\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get specific stolen car by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const car = await getStolenCarById(id);\n if (!car) {\n const response: ApiResponse = {\n success: false,\n error: \"Stolen car not found\"\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse = {\n success: true,\n data: car\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create new stolen car report\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as StolenCar;\n \n // Validate required fields\n const requiredFields = ['make', 'model', 'year', 'color', 'license_plate', 'stolen_date', 'stolen_location', 'owner_name', 'owner_phone', 'owner_email'];\n const missingFields = requiredFields.filter(field => !body[field as keyof StolenCar]);\n \n if (missingFields.length > 0) {\n const response: ApiResponse = {\n success: false,\n error: `Missing required fields: ${missingFields.join(', ')}`\n };\n return c.json(response, 400);\n }\n\n // Set default status if not provided\n if (!body.status) {\n body.status = 'active';\n }\n\n const carId = await createStolenCarReport(body);\n const createdCar = await getStolenCarById(carId);\n \n const response: ApiResponse = {\n success: true,\n data: createdCar!,\n message: \"Stolen car report created successfully\"\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update stolen car status\napp.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const { status } = await c.req.json();\n if (!['active', 'found', 'resolved'].includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status. Must be 'active', 'found', or 'resolved'\"\n };\n return c.json(response, 400);\n }\n\n // Check if car exists\n const existingCar = await getStolenCarById(id);\n if (!existingCar) {\n const response: ApiResponse = {\n success: false,\n error: \"Stolen car not found\"\n };\n return c.json(response, 404);\n }\n\n await updateStolenCarStatus(id, status);\n const updatedCar = await getStolenCarById(id);\n \n const response: ApiResponse = {\n success: true,\n data: updatedCar!,\n message: \"Status updated successfully\"\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[157,323,315],"routes","0edd9738-3f86-11f0-ad8b-76b3cceeab13","search.ts","0edd9814-3f86-11f0-ad8b-76b3cceeab13",16,["D",1748850545599],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { SearchFilters, ApiResponse } from \"../../shared/types.ts\";\nimport { searchAllCars } from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Search across both stolen and found cars\napp.get(\"/\", async (c) => {\n try {\n const filters: SearchFilters = {\n make: c.req.query(\"make\"),\n model: c.req.query(\"model\"),\n color: c.req.query(\"color\"),\n license_plate: c.req.query(\"license_plate\"),\n location: c.req.query(\"location\"),\n date_from: c.req.query(\"date_from\"),\n date_to: c.req.query(\"date_to\"),\n type: c.req.query(\"type\") as 'stolen' | 'found' | 'all' | undefined,\n };\n\n // Remove undefined values\n const cleanFilters = Object.fromEntries(\n Object.entries(filters).filter(([_, value]) => value !== undefined)\n ) as SearchFilters;\n\n const results = await searchAllCars(cleanFilters);\n \n const response: ApiResponse = {\n success: true,\n data: {\n ...results,\n total_stolen: results.stolen.length,\n total_found: results.found.length,\n total_results: results.stolen.length + results.found.length\n }\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get search suggestions based on existing data\napp.get(\"/suggestions\", async (c) => {\n try {\n const field = c.req.query(\"field\");\n const query = c.req.query(\"q\")?.toLowerCase() || \"\";\n\n if (!field || !['make', 'model', 'color'].includes(field)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid field. Must be 'make', 'model', or 'color'\"\n };\n return c.json(response, 400);\n }\n\n // This is a simplified suggestion system\n // In a real app, you'd query the database for unique values\n const suggestions: Record = {\n make: [\n 'Toyota', 'Honda', 'Ford', 'Chevrolet', 'Nissan', 'BMW', 'Mercedes-Benz',\n 'Audi', 'Volkswagen', 'Hyundai', 'Kia', 'Mazda', 'Subaru', 'Lexus',\n 'Acura', 'Infiniti', 'Cadillac', 'Lincoln', 'Buick', 'GMC'\n ],\n model: [\n 'Camry', 'Corolla', 'Civic', 'Accord', 'F-150', 'Silverado', 'Altima',\n 'Sentra', 'Malibu', 'Cruze', 'Elantra', 'Sonata', 'Optima', 'CX-5',\n 'Outback', 'Forester', 'ES', 'RX', 'TLX', 'Q50'\n ],\n color: [\n 'White', 'Black', 'Silver', 'Gray', 'Red', 'Blue', 'Green', 'Yellow',\n 'Orange', 'Purple', 'Brown', 'Gold', 'Beige', 'Maroon', 'Navy'\n ]\n };\n\n const filtered = suggestions[field].filter(item => \n item.toLowerCase().includes(query)\n ).slice(0, 10);\n \n const response: ApiResponse = {\n success: true,\n data: filtered\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[157,323,325],"0320cfc8-3f86-11f0-989c-76b3cceeab13","matches.ts","0320d068-3f86-11f0-989c-76b3cceeab13",15,["D",1748850525906],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { CarMatch, ApiResponse } from \"../../shared/types.ts\";\nimport { \n getMatches, \n updateMatchStatus,\n getStolenCarById,\n getFoundCarById,\n updateStolenCarStatus,\n updateFoundCarStatus\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all matches with optional filters\napp.get(\"/\", async (c) => {\n try {\n const stolenCarId = c.req.query(\"stolen_car_id\");\n const foundCarId = c.req.query(\"found_car_id\");\n\n const matches = await getMatches(\n stolenCarId ? parseInt(stolenCarId) : undefined,\n foundCarId ? parseInt(foundCarId) : undefined\n );\n \n // Enrich matches with car details\n const enrichedMatches = await Promise.all(\n matches.map(async (match) => {\n const [stolenCar, foundCar] = await Promise.all([\n getStolenCarById(match.stolen_car_id),\n getFoundCarById(match.found_car_id)\n ]);\n \n return {\n ...match,\n stolen_car: stolenCar,\n found_car: foundCar\n };\n })\n );\n \n const response: ApiResponse = {\n success: true,\n data: enrichedMatches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update match status\napp.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid match ID\"\n };\n return c.json(response, 400);\n }\n\n const { status } = await c.req.json();\n if (!['pending', 'confirmed', 'rejected'].includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status. Must be 'pending', 'confirmed', or 'rejected'\"\n };\n return c.json(response, 400);\n }\n\n // Get the match to update related cars\n const matches = await getMatches();\n const match = matches.find(m => m.id === id);\n \n if (!match) {\n const response: ApiResponse = {\n success: false,\n error: \"Match not found\"\n };\n return c.json(response, 404);\n }\n\n await updateMatchStatus(id, status);\n \n // If confirmed, update both car statuses\n if (status === 'confirmed') {\n await updateStolenCarStatus(match.stolen_car_id, 'found');\n await updateFoundCarStatus(match.found_car_id, 'matched');\n }\n \n const response: ApiResponse = {\n success: true,\n message: `Match status updated to ${status}${status === 'confirmed' ? '. Car owners have been notified.' : ''}`\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get matches for a specific stolen car\napp.get(\"/stolen/:stolenCarId\", async (c) => {\n try {\n const stolenCarId = parseInt(c.req.param(\"stolenCarId\"));\n if (isNaN(stolenCarId)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid stolen car ID\"\n };\n return c.json(response, 400);\n }\n\n const matches = await getMatches(stolenCarId);\n \n // Enrich with found car details\n const enrichedMatches = await Promise.all(\n matches.map(async (match) => {\n const foundCar = await getFoundCarById(match.found_car_id);\n return {\n ...match,\n found_car: foundCar\n };\n })\n );\n \n const response: ApiResponse = {\n success: true,\n data: enrichedMatches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get matches for a specific found car\napp.get(\"/found/:foundCarId\", async (c) => {\n try {\n const foundCarId = parseInt(c.req.param(\"foundCarId\"));\n if (isNaN(foundCarId)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid found car ID\"\n };\n return c.json(response, 400);\n }\n\n const matches = await getMatches(undefined, foundCarId);\n \n // Enrich with stolen car details\n const enrichedMatches = await Promise.all(\n matches.map(async (match) => {\n const stolenCar = await getStolenCarById(match.stolen_car_id);\n return {\n ...match,\n stolen_car: stolenCar\n };\n })\n );\n \n const response: ApiResponse = {\n success: true,\n data: enrichedMatches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[157,323,333],"f555d956-3f85-11f0-958a-76b3cceeab13","found.ts","f555da00-3f85-11f0-958a-76b3cceeab13",12,["D",1748850502763],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport type { FoundCar, ApiResponse } from \"../../shared/types.ts\";\nimport { \n createFoundCarReport, \n getFoundCars, \n getFoundCarById, \n updateFoundCarStatus,\n findPotentialMatches,\n createMatch\n} from \"../database/queries.ts\";\n\nconst app = new Hono();\n\n// Get all found cars with optional filters\napp.get(\"/\", async (c) => {\n try {\n const filters = {\n make: c.req.query(\"make\"),\n model: c.req.query(\"model\"),\n color: c.req.query(\"color\"),\n license_plate: c.req.query(\"license_plate\"),\n date_from: c.req.query(\"date_from\"),\n date_to: c.req.query(\"date_to\"),\n };\n\n // Remove undefined values\n const cleanFilters = Object.fromEntries(\n Object.entries(filters).filter(([_, value]) => value !== undefined)\n );\n\n const cars = await getFoundCars(Object.keys(cleanFilters).length > 0 ? cleanFilters : undefined);\n \n const response: ApiResponse = {\n success: true,\n data: cars\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get specific found car by ID\napp.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const car = await getFoundCarById(id);\n if (!car) {\n const response: ApiResponse = {\n success: false,\n error: \"Found car not found\"\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse = {\n success: true,\n data: car\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create new found car report\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as FoundCar;\n \n // Validate required fields\n const requiredFields = ['color', 'description', 'found_date', 'found_location', 'reporter_name', 'reporter_phone', 'reporter_email'];\n const missingFields = requiredFields.filter(field => !body[field as keyof FoundCar]);\n \n if (missingFields.length > 0) {\n const response: ApiResponse = {\n success: false,\n error: `Missing required fields: ${missingFields.join(', ')}`\n };\n return c.json(response, 400);\n }\n\n // Set default status if not provided\n if (!body.status) {\n body.status = 'active';\n }\n\n const carId = await createFoundCarReport(body);\n const createdCar = await getFoundCarById(carId);\n \n // Automatically check for potential matches\n const potentialMatches = await findPotentialMatches(carId);\n \n // Create match records for potential matches\n for (const match of potentialMatches) {\n const matchReasons: string[] = [];\n let matchScore = 0;\n\n // Calculate match score and reasons\n if (body.license_plate && body.license_plate.toLowerCase() === match.license_plate.toLowerCase()) {\n matchReasons.push(\"Exact license plate match\");\n matchScore += 100;\n }\n \n if (body.make && body.make.toLowerCase() === match.make.toLowerCase()) {\n matchReasons.push(\"Make matches\");\n matchScore += 20;\n }\n \n if (body.model && body.model.toLowerCase() === match.model.toLowerCase()) {\n matchReasons.push(\"Model matches\");\n matchScore += 20;\n }\n \n if (body.color && body.color.toLowerCase() === match.color.toLowerCase()) {\n matchReasons.push(\"Color matches\");\n matchScore += 15;\n }\n \n if (body.year && body.year === match.year) {\n matchReasons.push(\"Year matches\");\n matchScore += 10;\n }\n\n if (matchScore > 0) {\n await createMatch({\n stolen_car_id: match.id!,\n found_car_id: carId,\n match_score: matchScore,\n match_reasons: matchReasons,\n status: 'pending'\n });\n }\n }\n \n const response: ApiResponse = {\n success: true,\n data: createdCar!,\n message: `Found car report created successfully. ${potentialMatches.length} potential matches found.`\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update found car status\napp.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const { status } = await c.req.json();\n if (!['active', 'matched', 'resolved'].includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status. Must be 'active', 'matched', or 'resolved'\"\n };\n return c.json(response, 400);\n }\n\n // Check if car exists\n const existingCar = await getFoundCarById(id);\n if (!existingCar) {\n const response: ApiResponse = {\n success: false,\n error: \"Found car not found\"\n };\n return c.json(response, 404);\n }\n\n await updateFoundCarStatus(id, status);\n const updatedCar = await getFoundCarById(id);\n \n const response: ApiResponse = {\n success: true,\n data: updatedCar!,\n message: \"Status updated successfully\"\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get potential matches for a found car\napp.get(\"/:id/matches\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid car ID\"\n };\n return c.json(response, 400);\n }\n\n const matches = await findPotentialMatches(id);\n \n const response: ApiResponse = {\n success: true,\n data: matches\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : \"Unknown error occurred\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default app;",[],[157,323,341],"e53b0f14-3f85-11f0-b014-76b3cceeab13",["D",1748850475745],[175,176,177,178],[157,323],"431a3f16-3fa3-11f0-a30d-76b3cceeab13","1.tsx","2d11e328-3f9d-11f0-9d63-76b3cceeab13","15b4017d-7886-4af1-a52e-f6d95b64fdf9",["D",1748863088636],"// val type=script\n\nimport { Database } from \"https://deno.land/x/sqlite/mod.ts\";\n\nexport const db = new Database();\n\ndb.execute(`\n CREATE TABLE IF NOT EXISTS stolen_cars (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n owner_name TEXT,\n license_plate TEXT,\n make TEXT,\n model TEXT,\n color TEXT,\n description TEXT,\n location TEXT,\n photo_url TEXT,\n contact_info TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n );\n`);\n\ndb.execute(`\n CREATE TABLE IF NOT EXISTS found_cars (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n finder_name TEXT,\n license_plate TEXT,\n make TEXT,\n model TEXT,\n color TEXT,\n description TEXT,\n location TEXT,\n photo_url TEXT,\n contact_info TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n );\n`);\n\ndb.execute(`\n CREATE TABLE IF NOT EXISTS matches (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n stolen_car_id INTEGER,\n found_car_id INTEGER,\n match_score REAL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (stolen_car_id) REFERENCES stolen_cars(id),\n FOREIGN KEY (found_car_id) REFERENCES found_cars(id)\n );\n`);\n\n```16\n\n---\n\n## 2. **Database Operations (`backend/database/queries.ts`)**\n\n1843-1Implement functions to interact with the database: 20\n\n```ts\n// val type=script\n\nimport { db } from \"./schema.ts\";\n\n// Function to add a stolen car report\nexport function addStolenCar(report: {\n owner_name: string;\n license_plate: string;\n make: string;\n model: string;\n color: string;\n description: string;\n location: string;\n photo_url: string;\n contact_info: string;\n}) {\n db.query(\n `INSERT INTO stolen_cars (owner_name, license_plate, make, model, color, description, location, photo_url, contact_info)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n report.owner_name,\n report.license_plate,\n report.make,\n report.model,\n report.color,\n report.description,\n report.location,\n report.photo_url,\n report.contact_info,\n ]\n );\n}\n\n// Function to add a found car report\nexport function addFoundCar(report: {\n finder_name: string;\n license_plate: string;\n make: string;\n model: string;\n color: string;\n description: string;\n location: string;\n photo_url: string;\n contact_info: string;\n}) {\n db.query(\n `INSERT INTO found_cars (finder_name, license_plate, make, model, color, description, location, photo_url, contact_info)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [\n report.finder_name,\n report.license_plate,\n report.make,\n report.model,\n report.color,\n report.description,\n report.location,\n report.photo_url,\n report.contact_info,\n ]\n );\n}\n\n// Function to retrieve all stolen car reports\nexport function getAllStolenCars() {\n return [...db.query(\"SELECT * FROM stolen_cars\")];\n}\n\n// Function to retrieve all found car reports\nexport function getAllFoundCars() {\n return [...db.query(\"SELECT * FROM found_cars\")];\n}\n\n```23\n\n---\n\n## 3. **Routes**\n\n### a. **Stolen Car Reports (`backend/routes/stolen.ts`)**\n\n3670-2Handle reporting and retrieving stolen car reports: 27\n\n```ts\n// val type=script\n\nimport { Hono } from \"https://deno.land/x/hono/mod.ts\";\nimport { addStolenCar, getAllStolenCars } from \"../database/queries.ts\";\n\nconst stolen = new Hono();\n\n// Endpoint to report a stolen car\nstolen.post(\"/\", async (c) => {\n const report = await c.req.json();\n addStolenCar(report);\n return c.json({ message: \"Stolen car report added.\" });\n});\n\n// Endpoint to get all stolen car reports\nstolen.get(\"/\", (c) => {\n const reports = getAllStolenCars();\n return c.json(reports);\n});\n\nexport default stolen;\n\n```30\n\n### b. **Found Car Reports (`backend/routes/found.ts`)**\n\n4352-1Handle reporting and retrieving found car reports: 34\n\n```ts\n// val type=script\n\nimport { Hono } from \"https://deno.land/x/hono/mod.ts\";\nimport { addFoundCar, getAllFoundCars } from \"../database/queries.ts\";\n\nconst found = new Hono();\n\n// Endpoint to report a found car\nfound.post(\"/\", async (c) => {\n const report = await c.req.json();\n addFoundCar(report);\n return c.json({ message: \"Found car report added.\" });\n});\n\n// Endpoint to get all found car reports\nfound.get(\"/\", (c) => {\n const reports = getAllFoundCars();\n return c.json(reports);\n});\n\nexport default found;\n\n```37\n\n### c. **Matches (`backend/routes/matches.ts`)**\n\n4997-1Implement logic to match found cars with stolen car reports. This can be based on license plate, make, model, color, etc. For simplicity, here's a placeholder: 41\n\n```ts\n// val type=script\n\nimport { Hono } from \"https://deno.land/x/hono/mod.ts\";\n\nconst matches = new Hono();\n\n// Endpoint to get potential matches\nmatches.get(\"/\", (c) => {\n // Implement matching logic here\n return c.json({ message: \"Matching logic not yet implemented.\" });\n});\n\nexport default matches;\n\n```44\n\n---\n\n## 4. **Main Server (`backend/index.ts`)**\n\n5528-1Set up the Hono server and register routes: 48\n\n```ts\n// val type=http\n\nimport { Hono } from \"https://deno.land/x/hono/mod.ts\";\nimport stolen from \"./routes/stolen.ts\";\nimport found from \"./routes/found.ts\";\nimport matches from \"./routes/matches.ts\";\n\nconst app = new Hono();\n\napp.route(\"/stolen\", stolen);\napp.route(\"/found\", found);\napp.route(\"/matches\", matches);\n\nexport default app;\n\n```51\n\n---\n\n## ✅ Deployment on Val Town\n\n5974-1To deploy this backend on Val Town: 55\n\n1. 6048-0Create a new val for each of the files above, ensuring the correct `val type` is specified (`script` for modules, `http` for the main server). \n2. 6048-1Ensure that the `backend/index.ts` val is of type `http` so it can handle HTTP requests. \n3. 6048-2Use the Val Town interface to test the endpoints or integrate them with your frontend. 65\n\n6384-0Val Town provides a collaborative environment to build and deploy serverless applications with ease. 70\n\n---\n\nIf you need assistance with the frontend integration or implementing the matching logic, feel free to ask!71",[],[157,360,353],"database","f4bc9d14-3f84-11f0-917f-76b3cceeab13",["D",1748850072260],[173],[157,360],["D",1748850072260],[172,174],[157],["D",1748849913559],{"_11":12,"_57":97},{"_11":12,"_51":-5,"_52":97,"_34":63,"_54":55,"_56":20},{"_85":86,"_13":87,"_27":88,"_89":58,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":14,"_96":12},"ctx",{"_39":-5,"_119":405,"_406":407,"_408":409,"_410":20,"_411":20,"_412":20,"_413":46,"_414":-5,"_415":-7,"_416":-7,"_417":22,"_418":20,"_419":20,"_420":-5,"_421":20,"_422":20,"_423":20,"_424":-5},"ENV",{"_376":377,"_378":379,"_380":87,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404},"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"]

Remixes1

Remixes
1