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","children",[],[94],"efb773d4-3f84-11f0-a1f4-76b3cceeab13","shared","d0f372b1-a8f7-4978-b98a-109430d74356",3,["D",1748850063838],[110],[104],{"_37":111,"_13":112,"_40":113,"_42":105,"_44":45,"_46":114,"_48":49,"_50":115,"_17":116,"_53":54,"_55":117,"_57":58,"_59":-5,"_100":118,"_18":119},"765053ca-3f85-11f0-948f-76b3cceeab13","types.ts","efb76b82-3f84-11f0-a1f4-76b3cceeab13",6,["D",1748850289651],1,"// 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}",[],[104,112],"1fcba7e2-3f86-11f0-841e-76b3cceeab13","frontend","73021414-5f1c-4084-8d32-2442eaba72c6",18,["D",1748850573997],[127,128,129,130],[121],{"_37":206,"_13":207,"_40":208,"_42":122,"_44":45,"_46":209,"_48":49,"_50":210,"_17":116,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":211,"_18":212},{"_37":146,"_13":147,"_40":148,"_42":122,"_44":45,"_46":149,"_48":49,"_50":150,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":151,"_18":152},{"_37":139,"_13":140,"_40":141,"_42":122,"_44":45,"_46":123,"_48":49,"_50":142,"_17":52,"_53":24,"_55":143,"_57":58,"_59":-5,"_100":144,"_18":145},{"_37":131,"_13":132,"_40":133,"_42":122,"_44":45,"_46":134,"_48":49,"_50":135,"_17":52,"_53":54,"_55":136,"_57":58,"_59":-5,"_100":137,"_18":138},"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();",[],[121,132],"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",[],[121,140],"3249b99a-3f86-11f0-b8b6-76b3cceeab13","components","704664e4-750c-4a1a-9e28-d06b5ce01ec7",20,["D",1748850605021],[153,154,155,156,157,158],[121,147],{"_37":199,"_13":200,"_40":201,"_42":148,"_44":45,"_46":149,"_48":49,"_50":202,"_17":52,"_53":54,"_55":203,"_57":58,"_59":-5,"_100":204,"_18":205},{"_37":191,"_13":192,"_40":193,"_42":148,"_44":45,"_46":194,"_48":49,"_50":195,"_17":52,"_53":54,"_55":196,"_57":58,"_59":-5,"_100":197,"_18":198},{"_37":183,"_13":184,"_40":185,"_42":148,"_44":45,"_46":186,"_48":49,"_50":187,"_17":52,"_53":54,"_55":188,"_57":58,"_59":-5,"_100":189,"_18":190},{"_37":175,"_13":176,"_40":177,"_42":148,"_44":45,"_46":178,"_48":49,"_50":179,"_17":52,"_53":54,"_55":180,"_57":58,"_59":-5,"_100":181,"_18":182},{"_37":167,"_13":168,"_40":169,"_42":148,"_44":45,"_46":170,"_48":49,"_50":171,"_17":52,"_53":54,"_55":172,"_57":58,"_59":-5,"_100":173,"_18":174},{"_37":159,"_13":160,"_40":161,"_42":148,"_44":45,"_46":162,"_48":49,"_50":163,"_17":52,"_53":54,"_55":164,"_57":58,"_59":-5,"_100":165,"_18":166},"8fc293c6-3f86-11f0-8444-76b3cceeab13","SearchBar.tsx","8fc2947a-3f86-11f0-8444-76b3cceeab13",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}",[],[121,147,160],"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}",[],[121,147,168],"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}",[],[121,147,176],"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}",[],[121,147,184],"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}",[],[121,147,192],"3249adb0-3f86-11f0-b8b6-76b3cceeab13","App.tsx","3249ae78-3f86-11f0-b8b6-76b3cceeab13",["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}",[],[121,147,200],"28b5a7b6-3f9c-11f0-8ca3-76b3cceeab13","Front","1e0b3aba-3f9c-11f0-962f-76b3cceeab13",28,["D",1748860037882],[213,214,215],[121,207],{"_37":233,"_13":234,"_40":235,"_42":208,"_44":45,"_46":236,"_48":49,"_50":237,"_17":98,"_53":54,"_55":238,"_57":58,"_59":-5,"_100":239,"_18":240},{"_37":224,"_13":225,"_40":226,"_42":208,"_44":45,"_46":227,"_48":49,"_50":228,"_17":98,"_53":229,"_55":230,"_57":58,"_59":-5,"_100":231,"_18":232},{"_37":216,"_13":217,"_40":218,"_42":208,"_44":45,"_46":219,"_48":49,"_50":220,"_17":52,"_53":54,"_55":221,"_57":58,"_59":-5,"_100":222,"_18":223},"55e1c1d4-3f9c-11f0-98b8-76b3cceeab13","new-file-3815.tsx","55e1c292-3f9c-11f0-98b8-76b3cceeab13",32,["D",1748860113674],"",[],[121,207,217],"355dc552-3f9c-11f0-a95b-76b3cceeab13","new-file-2298.tsx","2dc95f68-3f9c-11f0-9808-76b3cceeab13",31,["D",1748860059116],"http","export default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}",[],[121,207,225],"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\" } }));",[],[121,207,234],"f4bc9b34-3f84-11f0-917f-76b3cceeab13",4,["D",1748850072260],[246,247],[61],{"_37":267,"_13":268,"_40":269,"_42":85,"_44":45,"_46":242,"_48":49,"_50":270,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":271,"_18":272},{"_37":84,"_13":62,"_40":43,"_42":85,"_44":45,"_46":47,"_48":49,"_50":248,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":249,"_18":250},["D",1748850475745],[251,252,253,254],[61,62],{"_37":77,"_13":78,"_40":79,"_42":43,"_44":45,"_46":80,"_48":49,"_50":264,"_17":52,"_53":54,"_55":82,"_57":58,"_59":-5,"_100":265,"_18":266},{"_37":70,"_13":71,"_40":72,"_42":43,"_44":45,"_46":73,"_48":49,"_50":261,"_17":52,"_53":54,"_55":75,"_57":58,"_59":-5,"_100":262,"_18":263},{"_37":63,"_13":64,"_40":65,"_42":43,"_44":45,"_46":66,"_48":49,"_50":258,"_17":52,"_53":54,"_55":68,"_57":58,"_59":-5,"_100":259,"_18":260},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":255,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_100":256,"_18":257},["D",1748850475745],[],[61,62,39],["D",1748850545599],[],[61,62,64],["D",1748850525906],[],[61,62,71],["D",1748850502763],[],[61,62,78],"f4bc9d14-3f84-11f0-917f-76b3cceeab13","database","15b4017d-7886-4af1-a52e-f6d95b64fdf9",["D",1748850072260],[273],[61,268],{"_37":274,"_13":275,"_40":276,"_42":269,"_44":45,"_46":277,"_48":49,"_50":278,"_17":114,"_53":54,"_55":279,"_57":58,"_59":-5,"_100":280,"_18":281},"431a3f16-3fa3-11f0-a30d-76b3cceeab13","1.tsx","2d11e328-3f9d-11f0-9d63-76b3cceeab13",89,["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",[],[61,268,275],"962348fc-3f84-11f0-b0be-76b3cceeab13",["D",1748849913559],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","VehiclesFinder","imageUrl","userId","defccae0-3f83-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","d0808b00-181f-4bcb-ac9d-1d1a3c21ac29","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_335":331},"org",{"_11":12,"_329":-5,"_330":331,"_292":293,"_332":333,"_334":58},"branch",{"_17":277,"_13":16,"_37":45,"_321":282,"_322":-5,"_323":-5,"_324":-5,"_325":-5,"_326":-5,"_327":14,"_328":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d1dOeGY5REVGZU1uNWZSang1R1hiaFBqVyJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":282,"_13":14,"_50":448,"_284":-5,"_285":58,"_286":287,"_288":287,"_289":290,"_291":-5,"_292":293,"_294":226,"_295":49,"_296":49,"_297":-5,"_298":52,"_299":300,"_301":-5,"_302":-5,"_303":-5,"_304":-5,"_305":306,"_307":306,"_308":309,"_310":309,"_311":309,"_312":306,"_313":306,"_314":449,"_316":450,"_318":451,"_320":58},[373,381,395,397],"files",[373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397],"counts",{"_364":52,"_365":116,"_366":116,"_32":367,"_368":369},[356,357,358,359],{"_37":84,"_13":62,"_40":43,"_42":85,"_44":45,"_46":47,"_48":49,"_50":86,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_18":355},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[61,62],{"_37":77,"_13":78,"_40":79,"_42":43,"_44":45,"_46":80,"_48":49,"_50":81,"_17":52,"_53":54,"_55":82,"_57":58,"_59":-5,"_18":363},{"_37":70,"_13":71,"_40":72,"_42":43,"_44":45,"_46":73,"_48":49,"_50":74,"_17":52,"_53":54,"_55":75,"_57":58,"_59":-5,"_18":362},{"_37":63,"_13":64,"_40":65,"_42":43,"_44":45,"_46":66,"_48":49,"_50":67,"_17":52,"_53":54,"_55":68,"_57":58,"_59":-5,"_18":361},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_18":360},[61,62,39],[61,62,64],[61,62,71],[61,62,78],"pulls","branches","forks",{"_370":52,"_372":52},"connections",{"_370":52,"_371":52},"count","unfilledCount","emptyCount",{"_37":241,"_13":61,"_40":85,"_42":-5,"_44":45,"_46":242,"_48":49,"_50":243,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":446,"_18":447},{"_37":267,"_13":268,"_40":269,"_42":85,"_44":45,"_46":242,"_48":49,"_50":270,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":444,"_18":445},{"_37":274,"_13":275,"_40":276,"_42":269,"_44":45,"_46":277,"_48":49,"_50":278,"_17":114,"_53":54,"_55":279,"_57":58,"_59":-5,"_100":442,"_18":443},{"_37":84,"_13":62,"_40":43,"_42":85,"_44":45,"_46":47,"_48":49,"_50":248,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":440,"_18":441},{"_37":77,"_13":78,"_40":79,"_42":43,"_44":45,"_46":80,"_48":49,"_50":264,"_17":52,"_53":54,"_55":82,"_57":58,"_59":-5,"_100":438,"_18":439},{"_37":70,"_13":71,"_40":72,"_42":43,"_44":45,"_46":73,"_48":49,"_50":261,"_17":52,"_53":54,"_55":75,"_57":58,"_59":-5,"_100":436,"_18":437},{"_37":63,"_13":64,"_40":65,"_42":43,"_44":45,"_46":66,"_48":49,"_50":258,"_17":52,"_53":54,"_55":68,"_57":58,"_59":-5,"_100":434,"_18":435},{"_37":38,"_13":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":255,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_100":432,"_18":433},{"_37":120,"_13":121,"_40":122,"_42":-5,"_44":45,"_46":123,"_48":49,"_50":124,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":430,"_18":431},{"_37":206,"_13":207,"_40":208,"_42":122,"_44":45,"_46":209,"_48":49,"_50":210,"_17":116,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":428,"_18":429},{"_37":233,"_13":234,"_40":235,"_42":208,"_44":45,"_46":236,"_48":49,"_50":237,"_17":98,"_53":54,"_55":238,"_57":58,"_59":-5,"_100":426,"_18":427},{"_37":224,"_13":225,"_40":226,"_42":208,"_44":45,"_46":227,"_48":49,"_50":228,"_17":98,"_53":229,"_55":230,"_57":58,"_59":-5,"_100":424,"_18":425},{"_37":216,"_13":217,"_40":218,"_42":208,"_44":45,"_46":219,"_48":49,"_50":220,"_17":52,"_53":54,"_55":221,"_57":58,"_59":-5,"_100":422,"_18":423},{"_37":146,"_13":147,"_40":148,"_42":122,"_44":45,"_46":149,"_48":49,"_50":150,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":420,"_18":421},{"_37":199,"_13":200,"_40":201,"_42":148,"_44":45,"_46":149,"_48":49,"_50":202,"_17":52,"_53":54,"_55":203,"_57":58,"_59":-5,"_100":418,"_18":419},{"_37":191,"_13":192,"_40":193,"_42":148,"_44":45,"_46":194,"_48":49,"_50":195,"_17":52,"_53":54,"_55":196,"_57":58,"_59":-5,"_100":416,"_18":417},{"_37":183,"_13":184,"_40":185,"_42":148,"_44":45,"_46":186,"_48":49,"_50":187,"_17":52,"_53":54,"_55":188,"_57":58,"_59":-5,"_100":414,"_18":415},{"_37":175,"_13":176,"_40":177,"_42":148,"_44":45,"_46":178,"_48":49,"_50":179,"_17":52,"_53":54,"_55":180,"_57":58,"_59":-5,"_100":412,"_18":413},{"_37":167,"_13":168,"_40":169,"_42":148,"_44":45,"_46":170,"_48":49,"_50":171,"_17":52,"_53":54,"_55":172,"_57":58,"_59":-5,"_100":410,"_18":411},{"_37":159,"_13":160,"_40":161,"_42":148,"_44":45,"_46":162,"_48":49,"_50":163,"_17":52,"_53":54,"_55":164,"_57":58,"_59":-5,"_100":408,"_18":409},{"_37":139,"_13":140,"_40":141,"_42":122,"_44":45,"_46":123,"_48":49,"_50":142,"_17":52,"_53":24,"_55":143,"_57":58,"_59":-5,"_100":406,"_18":407},{"_37":131,"_13":132,"_40":133,"_42":122,"_44":45,"_46":134,"_48":49,"_50":135,"_17":52,"_53":54,"_55":136,"_57":58,"_59":-5,"_100":404,"_18":405},{"_37":103,"_13":104,"_40":105,"_42":-5,"_44":45,"_46":106,"_48":49,"_50":107,"_17":52,"_53":87,"_55":-5,"_57":58,"_59":-5,"_100":402,"_18":403},{"_37":111,"_13":112,"_40":113,"_42":105,"_44":45,"_46":114,"_48":49,"_50":115,"_17":116,"_53":54,"_55":117,"_57":58,"_59":-5,"_100":400,"_18":401},{"_37":93,"_13":94,"_40":95,"_42":-5,"_44":45,"_46":96,"_48":49,"_50":97,"_17":98,"_53":24,"_55":99,"_57":58,"_59":-5,"_100":398,"_18":399},[],[94],[],[104,112],[396],[104],[],[121,132],[],[121,140],[],[121,147,160],[],[121,147,168],[],[121,147,176],[],[121,147,184],[],[121,147,192],[],[121,147,200],[387,388,389,390,391,392],[121,147],[],[121,207,217],[],[121,207,225],[],[121,207,234],[383,384,385],[121,207],[382,386,393,394],[121],[],[61,62,39],[],[61,62,64],[],[61,62,71],[],[61,62,78],[377,378,379,380],[61,62],[],[61,268,275],[375],[61,268],[374,376],[61],["D",1748849913559],{"_11":12,"_335":331},{"_11":12,"_329":-5,"_330":331,"_292":293,"_332":333,"_334":58},{"_17":277,"_13":16,"_37":45,"_321":282,"_322":-5,"_323":-5,"_324":-5,"_325":-5,"_326":-5,"_327":14,"_328":12},"ctx",{"_314":-5,"_352":485,"_486":487,"_488":489,"_490":58,"_491":58,"_492":58,"_493":49,"_494":-5,"_495":-7,"_496":-7,"_497":52,"_498":58,"_499":58,"_500":-5,"_501":58,"_502":58,"_503":58,"_504":-5},"ENV",{"_456":457,"_458":459,"_460":16,"_461":462,"_463":464,"_465":466,"_467":468,"_469":470,"_471":472,"_473":474,"_475":476,"_477":478,"_479":480,"_481":482,"_483":484},"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"]