A comprehensive, secure, and scalable car dealership website with user and admin functionality.

• Browse and search cars by brand, model, year, price, mileage, fuel type
• View detailed car specifications with image galleries
• User registration and authentication (JWT-based)
• Wishlist and car comparison functionality
• Contact dealership and request test drives
• Responsive mobile-first design

• Complete admin dashboard for car inventory management
• User account and inquiry management
• Analytics and reporting on car views and leads
• Role-based access control
• Bulk operations and advanced filtering

• RESTful API with comprehensive endpoints
• JWT authentication with refresh tokens
• Role-based authorization (user/admin)
• Image upload and management
• Advanced search and filtering
• Responsive UI with Tailwind CSS
• SQLite database (easily upgradeable to PostgreSQL)

├── backend/
│   ├── database/
│   │   ├── migrations.ts    # Database schema and migrations
│   │   ├── queries.ts       # Database query functions
│   │   └── README.md
│   ├── routes/
│   │   ├── auth.ts         # Authentication routes
│   │   ├── cars.ts         # Car management routes
│   │   ├── users.ts        # User management routes
│   │   ├── admin.ts        # Admin-specific routes
│   │   └── static.ts       # Static file serving
│   ├── middleware/
│   │   ├── auth.ts         # JWT authentication middleware
│   │   └── validation.ts   # Request validation
│   ├── utils/
│   │   ├── jwt.ts          # JWT utilities
│   │   └── security.ts     # Security utilities
│   ├── index.ts            # Main backend entry point
│   └── README.md
├── frontend/
│   ├── components/
│   │   ├── App.tsx         # Main app component
│   │   ├── Layout/         # Layout components
│   │   ├── Auth/           # Authentication components
│   │   ├── Cars/           # Car-related components
│   │   ├── Admin/          # Admin dashboard components
│   │   └── Common/         # Shared components
│   ├── hooks/              # Custom React hooks
│   ├── services/           # API service functions
│   ├── types/              # TypeScript type definitions
│   ├── utils/              # Frontend utilities
│   ├── index.html          # Main HTML template
│   ├── index.tsx           # Frontend entry point
│   ├── style.css           # Global styles
│   └── README.md
├── shared/
│   ├── types.ts            # Shared TypeScript types
│   ├── constants.ts        # Shared constants
│   └── utils.ts            # Shared utility functions
└── README.md

1. The backend runs on Hono framework with TypeScript
2. Frontend uses React 18 with TypeScript and Tailwind CSS
3. Database uses SQLite with comprehensive schema
4. Authentication uses JWT with role-based access control

• JWT authentication with refresh tokens
• Role-based access control (user/admin)
• Password hashing with bcrypt
• Request validation and sanitization
• CORS handling
• Rate limiting protection
• SQL injection prevention

• users: User accounts with roles and profiles
• cars: Vehicle inventory with specifications
• car_images: Multiple images per vehicle
• wishlists: User saved cars
• inquiries: Contact requests and test drive bookings
• analytics: Page views and user interactions

• Mobile-first responsive design
• Advanced search and filtering
• Image galleries with zoom
• Comparison tools
• Real-time updates
• Loading states and error handling
• Accessibility compliance

• Car inventory management (CRUD operations)
• User account management
• Inquiry and lead tracking
• Analytics and reporting
• Bulk operations
• Role management

• POST /api/auth/register - User registration
• POST /api/auth/login - User login
• POST /api/auth/refresh - Token refresh
• POST /api/auth/logout - User logout

• GET /api/cars - List cars with filtering
• GET /api/cars/:id - Get car details
• POST /api/cars - Add new car (admin)
• PUT /api/cars/:id - Update car (admin)
• DELETE /api/cars/:id - Delete car (admin)

• GET /api/users/profile - Get user profile
• PUT /api/users/profile - Update profile
• GET /api/users/wishlist - Get user wishlist
• POST /api/users/wishlist/:carId - Add to wishlist

• GET /api/admin/users - List all users
• GET /api/admin/analytics - Get analytics data
• GET /api/admin/inquiries - List inquiries

The application is designed to be deployed on Val Town with:

• Backend API serving on HTTP trigger
• Frontend served as static files
• SQLite database for data persistence
• Environment variables for configuration