[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_268":269,"_270":271},"routes/_app.x.$handle.$name",{"_97":96,"_33":46,"_105":87,"_28":37,"_13":14,"_106":-5,"_11":107,"_108":109,"_110":111,"_112":113,"_114":115,"_20":-5,"_116":-5,"_117":-5,"_118":27,"_119":120,"_121":25,"_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",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":25,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":27},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":38,"_36":37,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","new-file-2641.tsx","latestPath","fileId","f41e5aae-3f85-11f0-9da0-76b3cceeab13","name","fileType","script","content","","http","createdAt",["D",1748850511170],"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","pinMigrated","screenshotVersion","likeCount",0,"orgId","d0808b00-181f-4bcb-ac9d-1d1a3c21ac29","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":56,"_101":102,"_103":27},"branch",{"_13":86,"_33":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"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",{"_44":45,"_33":46,"_39":264,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":25,"_60":25,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":265,"_81":266,"_83":267,"_85":27},"tree",[180,187,189,190,191,192],"files",[180,181,182,183,184,185,186,187,188,189,190,191,192],"counts",{"_170":63,"_171":136,"_172":136,"_173":174,"_175":176},"contents",[126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":164,"_33":165,"_31":166,"_133":-5,"_42":43,"_41":167,"_134":25,"_39":168,"_13":63,"_34":162,"_36":-5,"_24":27,"_137":-5,"_28":169},{"_44":157,"_33":158,"_31":159,"_133":-5,"_42":43,"_41":160,"_134":25,"_39":161,"_13":63,"_34":162,"_36":-5,"_24":27,"_137":-5,"_28":163},{"_44":150,"_33":151,"_31":152,"_133":-5,"_42":43,"_41":153,"_134":27,"_39":154,"_13":136,"_34":20,"_36":155,"_24":27,"_137":-5,"_28":156},{"_44":145,"_33":146,"_31":147,"_133":-5,"_42":43,"_41":136,"_134":27,"_39":148,"_13":63,"_34":35,"_36":37,"_24":27,"_137":-5,"_28":149},{"_44":139,"_33":140,"_31":141,"_133":-5,"_42":43,"_41":142,"_134":27,"_39":143,"_13":63,"_34":35,"_36":37,"_24":27,"_137":-5,"_28":144},{"_44":132,"_33":29,"_31":32,"_133":-5,"_42":43,"_41":14,"_134":27,"_39":135,"_13":136,"_34":38,"_36":37,"_24":27,"_137":-5,"_28":138},"fa586b08-3f85-11f0-acef-76b3cceeab13","parentId","latest",["D",1748850511170],1,"label",[29],"f2f9e508-3f85-11f0-a786-76b3cceeab13","new-file-1680.tsx","f2f9e5c6-3f85-11f0-a786-76b3cceeab13",10,["D",1748850498809],[140],"96252172-3f84-11f0-b0be-76b3cceeab13","main.tsx","96252226-3f84-11f0-b0be-76b3cceeab13",["D",1748849913568],[146],"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",[151],"efb773d4-3f84-11f0-a1f4-76b3cceeab13","shared","d0f372b1-a8f7-4978-b98a-109430d74356",3,["D",1748850063838],"directory",[158],"f4bc9b34-3f84-11f0-917f-76b3cceeab13","backend","af436097-5c4b-4ae1-9232-154369ce0aba",4,["D",1748850072260],[165],"pulls","branches","forks","envVars",{"_177":63,"_179":63},"connections",{"_177":63,"_178":63},"count","unfilledCount","emptyCount",{"_44":164,"_33":165,"_31":166,"_133":-5,"_42":43,"_41":167,"_134":25,"_39":261,"_13":63,"_34":162,"_36":-5,"_24":27,"_137":-5,"_194":262,"_28":263},{"_44":257,"_33":248,"_31":242,"_133":166,"_42":43,"_41":167,"_134":25,"_39":258,"_13":63,"_34":162,"_36":-5,"_24":27,"_137":-5,"_194":259,"_28":260},{"_44":249,"_33":250,"_31":251,"_133":242,"_42":43,"_41":252,"_134":27,"_39":253,"_13":136,"_34":35,"_36":254,"_24":27,"_137":-5,"_194":255,"_28":256},{"_44":239,"_33":240,"_31":241,"_133":242,"_42":43,"_41":243,"_134":27,"_39":244,"_13":63,"_34":35,"_36":245,"_24":27,"_137":-5,"_194":246,"_28":247},{"_44":235,"_33":226,"_31":220,"_133":166,"_42":43,"_41":221,"_134":25,"_39":236,"_13":63,"_34":162,"_36":-5,"_24":27,"_137":-5,"_194":237,"_28":238},{"_44":227,"_33":228,"_31":229,"_133":220,"_42":43,"_41":230,"_134":25,"_39":231,"_13":63,"_34":35,"_36":232,"_24":27,"_137":-5,"_194":233,"_28":234},{"_44":217,"_33":218,"_31":219,"_133":220,"_42":43,"_41":221,"_134":25,"_39":222,"_13":63,"_34":35,"_36":223,"_24":27,"_137":-5,"_194":224,"_28":225},{"_44":157,"_33":158,"_31":159,"_133":-5,"_42":43,"_41":160,"_134":25,"_39":214,"_13":63,"_34":162,"_36":-5,"_24":27,"_137":-5,"_194":215,"_28":216},{"_44":206,"_33":207,"_31":208,"_133":159,"_42":43,"_41":209,"_134":25,"_39":210,"_13":136,"_34":35,"_36":211,"_24":27,"_137":-5,"_194":212,"_28":213},{"_44":150,"_33":151,"_31":152,"_133":-5,"_42":43,"_41":153,"_134":27,"_39":203,"_13":136,"_34":20,"_36":155,"_24":27,"_137":-5,"_194":204,"_28":205},{"_44":145,"_33":146,"_31":147,"_133":-5,"_42":43,"_41":136,"_134":27,"_39":200,"_13":63,"_34":35,"_36":37,"_24":27,"_137":-5,"_194":201,"_28":202},{"_44":139,"_33":140,"_31":141,"_133":-5,"_42":43,"_41":142,"_134":27,"_39":197,"_13":63,"_34":35,"_36":37,"_24":27,"_137":-5,"_194":198,"_28":199},{"_44":132,"_33":29,"_31":32,"_133":-5,"_42":43,"_41":14,"_134":27,"_39":193,"_13":136,"_34":38,"_36":37,"_24":27,"_137":-5,"_194":195,"_28":196},["D",1748850511170],"children",[],[29],["D",1748850498809],[],[140],["D",1748849913568],[],[146],["D",1748850244745],[],[151],"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}",[],[158,207],["D",1748850063838],[188],[158],"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;",[],[165,226,218],"routes","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;",[],[165,226,228],"e53b0f14-3f85-11f0-b014-76b3cceeab13",["D",1748850475745],[185,186],[165,226],"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}",[],[165,248,240],"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}",[],[165,248,250],"f4bc9d14-3f84-11f0-917f-76b3cceeab13",["D",1748850072260],[182,183],[165,248],["D",1748850072260],[181,184],[165],["D",1748849913559],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":56,"_101":102,"_103":27},{"_13":86,"_33":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_123":301,"_302":303,"_304":305,"_306":27,"_307":27,"_308":27,"_309":25,"_310":-5,"_311":-7,"_312":-7,"_313":63,"_314":27,"_315":27,"_316":-5,"_317":27,"_318":27,"_319":27,"_320":-5},"ENV",{"_272":273,"_274":275,"_276":87,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300},"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 · v13