[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_359":360,"_361":362},"routes/_app.x.$handle.$name",{"_96":95,"_31":44,"_104":86,"_26":105,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":24,"_119":120,"_121":58,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":24},"version",22,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/Hero.tsx","latestPath","fileId","4b3c53b8-3f86-11f0-9218-76b3cceeab13","name","Hero.tsx","fileType","script","content","/** @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}","createdAt",["D",1748850646884],"branchVersion","branchId","96238d58-3f84-11f0-b0be-76b3cceeab13","id","962348fc-3f84-11f0-b0be-76b3cceeab13","FindMyCar",["D",1748849913559],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","VehiclesFinder","imageUrl","defccae0-3f83-11f0-ad5b-814c56c8abb0","pinnedFileId","2dc95f68-3f9c-11f0-9808-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d0808b00-181f-4bcb-ac9d-1d1a3c21ac29","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_96":95,"_103":99},"org",{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},"branch",{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"isOwned",89,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Sarax201","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d1dOeGY5REVGZU1uNWZSang1R1hiaFBqVyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":355,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":356,"_80":357,"_82":358,"_84":24},"tree",[193,203,210,212,213,214,215],"files",[193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215],"counts",{"_183":62,"_184":154,"_185":154,"_186":187,"_188":189},"contents",[126,127,128,129,130,131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":177,"_31":178,"_29":179,"_136":-5,"_40":41,"_39":180,"_138":58,"_37":181,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_26":182},{"_42":171,"_31":172,"_29":173,"_136":-5,"_40":41,"_39":174,"_138":58,"_37":175,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_26":176},{"_42":164,"_31":165,"_29":166,"_136":-5,"_40":41,"_39":167,"_138":58,"_37":168,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_26":170},{"_42":157,"_31":158,"_29":159,"_136":-5,"_40":41,"_39":160,"_138":24,"_37":161,"_13":154,"_33":20,"_35":162,"_23":24,"_143":-5,"_26":163},{"_42":151,"_31":152,"_29":153,"_136":-5,"_40":41,"_39":154,"_138":24,"_37":155,"_13":62,"_33":34,"_35":105,"_23":24,"_143":-5,"_26":156},{"_42":145,"_31":146,"_29":147,"_136":-5,"_40":41,"_39":148,"_138":24,"_37":149,"_13":62,"_33":34,"_35":105,"_23":24,"_143":-5,"_26":150},{"_42":133,"_31":134,"_29":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":139,"_13":140,"_33":141,"_35":142,"_23":24,"_143":-5,"_26":144},"fa874612-3f85-11f0-923d-76b3cceeab13","new-file-2641.tsx","f41e5aae-3f85-11f0-9da0-76b3cceeab13","parentId",14,"latest",["D",1748850511477],2,"http","export default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","label",[134],"f2f9e508-3f85-11f0-a786-76b3cceeab13","new-file-1680.tsx","f2f9e5c6-3f85-11f0-a786-76b3cceeab13",10,["D",1748850498809],[146],"96252172-3f84-11f0-b0be-76b3cceeab13","main.tsx","96252226-3f84-11f0-b0be-76b3cceeab13",1,["D",1748849913568],[152],"5b8c154c-3f85-11f0-b83d-76b3cceeab13","README.md","eb5327ca-3f84-11f0-af7d-76b3cceeab13",5,["D",1748850244745],"# Lost Cars Finder App\n\nA comprehensive app to help reunite stolen vehicles with their owners.\n\n## Features\n\n### For Car Owners\n- Report stolen vehicles with detailed information\n- View reports of found cars that might match\n- Contact system when someone finds their car\n\n### For Good Samaritans\n- Report found/suspicious vehicles with photos\n- Add location, license plate, and vehicle details\n- Help reunite cars with owners\n\n### Core Functionality\n- Photo upload for found vehicles\n- Location tracking with maps\n- Search and filter system\n- Secure contact system\n- Mobile-responsive design\n\n## Project Structure\n\n```\n├── backend/\n│ ├── index.ts # Main Hono server\n│ ├── database/\n│ │ ├── schema.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ └── routes/\n│ ├── stolen.ts # Stolen car reports\n│ ├── found.ts # Found car reports\n│ └── matches.ts # Matching system\n├── frontend/\n│ ├── index.html # Main page\n│ ├── components/\n│ │ ├── App.tsx # Main React app\n│ │ ├── ReportStolen.tsx\n│ │ ├── ReportFound.tsx\n│ │ ├── CarList.tsx\n│ │ └── CarMap.tsx\n│ └── style.css\n└── shared/\n └── types.ts # Shared 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",[158],"efb773d4-3f84-11f0-a1f4-76b3cceeab13","shared","d0f372b1-a8f7-4978-b98a-109430d74356",3,["D",1748850063838],"directory",[165],"1fcba7e2-3f86-11f0-841e-76b3cceeab13","frontend","73021414-5f1c-4084-8d32-2442eaba72c6",18,["D",1748850573997],[172],"f4bc9b34-3f84-11f0-917f-76b3cceeab13","backend","af436097-5c4b-4ae1-9232-154369ce0aba",4,["D",1748850072260],[178],"pulls","branches","forks","envVars",{"_190":62,"_192":62},"connections",{"_190":62,"_191":62},"count","unfilledCount","emptyCount",{"_42":177,"_31":178,"_29":179,"_136":-5,"_40":41,"_39":180,"_138":58,"_37":352,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_217":353,"_26":354},{"_42":348,"_31":339,"_29":333,"_136":179,"_40":41,"_39":180,"_138":58,"_37":349,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_217":350,"_26":351},{"_42":340,"_31":341,"_29":342,"_136":333,"_40":41,"_39":343,"_138":24,"_37":344,"_13":154,"_33":34,"_35":345,"_23":24,"_143":-5,"_217":346,"_26":347},{"_42":330,"_31":331,"_29":332,"_136":333,"_40":41,"_39":334,"_138":24,"_37":335,"_13":62,"_33":34,"_35":336,"_23":24,"_143":-5,"_217":337,"_26":338},{"_42":326,"_31":301,"_29":295,"_136":179,"_40":41,"_39":296,"_138":58,"_37":327,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_217":328,"_26":329},{"_42":318,"_31":319,"_29":320,"_136":295,"_40":41,"_39":321,"_138":58,"_37":322,"_13":62,"_33":34,"_35":323,"_23":24,"_143":-5,"_217":324,"_26":325},{"_42":310,"_31":311,"_29":312,"_136":295,"_40":41,"_39":313,"_138":58,"_37":314,"_13":62,"_33":34,"_35":315,"_23":24,"_143":-5,"_217":316,"_26":317},{"_42":302,"_31":303,"_29":304,"_136":295,"_40":41,"_39":305,"_138":58,"_37":306,"_13":62,"_33":34,"_35":307,"_23":24,"_143":-5,"_217":308,"_26":309},{"_42":292,"_31":293,"_29":294,"_136":295,"_40":41,"_39":296,"_138":58,"_37":297,"_13":62,"_33":34,"_35":298,"_23":24,"_143":-5,"_217":299,"_26":300},{"_42":284,"_31":285,"_29":286,"_136":179,"_40":41,"_39":287,"_138":24,"_37":288,"_13":62,"_33":34,"_35":289,"_23":24,"_143":-5,"_217":290,"_26":291},{"_42":171,"_31":172,"_29":173,"_136":-5,"_40":41,"_39":174,"_138":58,"_37":281,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_217":282,"_26":283},{"_42":277,"_31":260,"_29":256,"_136":173,"_40":41,"_39":272,"_138":58,"_37":278,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_217":279,"_26":280},{"_42":269,"_31":270,"_29":271,"_136":256,"_40":41,"_39":272,"_138":58,"_37":273,"_13":62,"_33":34,"_35":274,"_23":24,"_143":-5,"_217":275,"_26":276},{"_42":261,"_31":262,"_29":263,"_136":256,"_40":41,"_39":264,"_138":58,"_37":265,"_13":62,"_33":34,"_35":266,"_23":24,"_143":-5,"_217":267,"_26":268},{"_42":255,"_31":32,"_29":30,"_136":256,"_40":41,"_39":14,"_138":58,"_37":257,"_13":62,"_33":34,"_35":36,"_23":24,"_143":-5,"_217":258,"_26":259},{"_42":248,"_31":249,"_29":250,"_136":173,"_40":41,"_39":174,"_138":58,"_37":251,"_13":62,"_33":20,"_35":252,"_23":24,"_143":-5,"_217":253,"_26":254},{"_42":240,"_31":241,"_29":242,"_136":173,"_40":41,"_39":243,"_138":58,"_37":244,"_13":62,"_33":34,"_35":245,"_23":24,"_143":-5,"_217":246,"_26":247},{"_42":164,"_31":165,"_29":166,"_136":-5,"_40":41,"_39":167,"_138":58,"_37":237,"_13":62,"_33":169,"_35":-5,"_23":24,"_143":-5,"_217":238,"_26":239},{"_42":229,"_31":230,"_29":231,"_136":166,"_40":41,"_39":232,"_138":58,"_37":233,"_13":154,"_33":34,"_35":234,"_23":24,"_143":-5,"_217":235,"_26":236},{"_42":157,"_31":158,"_29":159,"_136":-5,"_40":41,"_39":160,"_138":24,"_37":226,"_13":154,"_33":20,"_35":162,"_23":24,"_143":-5,"_217":227,"_26":228},{"_42":151,"_31":152,"_29":153,"_136":-5,"_40":41,"_39":154,"_138":24,"_37":223,"_13":62,"_33":34,"_35":105,"_23":24,"_143":-5,"_217":224,"_26":225},{"_42":145,"_31":146,"_29":147,"_136":-5,"_40":41,"_39":148,"_138":24,"_37":220,"_13":62,"_33":34,"_35":105,"_23":24,"_143":-5,"_217":221,"_26":222},{"_42":133,"_31":134,"_29":135,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":216,"_13":140,"_33":141,"_35":142,"_23":24,"_143":-5,"_217":218,"_26":219},["D",1748850511477],"children",[],[134],["D",1748850498809],[],[146],["D",1748849913568],[],[152],["D",1748850244745],[],[158],"765053ca-3f85-11f0-948f-76b3cceeab13","types.ts","efb76b82-3f84-11f0-a1f4-76b3cceeab13",6,["D",1748850289651],"// 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}",[],[165,230],["D",1748850063838],[211],[165],"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();",[],[172,241],"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",[],[172,249],"4b3c532c-3f86-11f0-9218-76b3cceeab13","704664e4-750c-4a1a-9e28-d06b5ce01ec7",["D",1748850646884],[],[172,260,32],"components","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}",[],[172,260,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}",[],[172,260,270],"3249b99a-3f86-11f0-b8b6-76b3cceeab13",["D",1748850605021],[205,206,207],[172,260],["D",1748850573997],[204,208,209],[172],"19ad4e7e-3f86-11f0-84dc-76b3cceeab13","index.ts","19ad4f96-3f86-11f0-84dc-76b3cceeab13",17,["D",1748850563737],"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;",[],[178,285],"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;",[],[178,301,293],"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;",[],[178,301,303],"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;",[],[178,301,311],"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;",[],[178,301,319],"e53b0f14-3f85-11f0-b014-76b3cceeab13",["D",1748850475745],[198,199,200,201],[178,301],"d93303ca-3f85-11f0-ad4a-76b3cceeab13","queries.ts","d9330492-3f85-11f0-ad4a-76b3cceeab13","15b4017d-7886-4af1-a52e-f6d95b64fdf9",8,["D",1748850455562],"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}",[],[178,339,331],"database","8443c4da-3f85-11f0-9a31-76b3cceeab13","migrations.ts","f4bc8c84-3f84-11f0-917f-76b3cceeab13",7,["D",1748850313057],"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}",[],[178,339,341],"f4bc9d14-3f84-11f0-917f-76b3cceeab13",["D",1748850072260],[195,196],[178,339],["D",1748850072260],[194,197,202],[178],["D",1748849913559],{"_96":95,"_103":99},{"_96":95,"_97":-5,"_98":99,"_18":54,"_100":101,"_102":24},{"_13":85,"_31":86,"_42":41,"_87":43,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":44,"_94":95},"ctx",{"_78":-5,"_123":392,"_393":394,"_395":396,"_397":24,"_398":24,"_399":24,"_400":58,"_401":-5,"_402":-7,"_403":-7,"_404":62,"_405":24,"_406":24,"_407":-5,"_408":24,"_409":24,"_410":24,"_411":-5},"ENV",{"_363":364,"_365":366,"_367":86,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391},"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"]

Diff · v22