Shuttle Service Management System

A complete web-based shuttle service management platform with a public-facing website and an admin panel for managing services, vehicles, and customer inquiries.

Features

Public Website

• Responsive Design - Mobile-friendly interface with smooth animations
• Service Listings - Dynamically managed service offerings
• Fleet Display - Vehicle showcase with images and specifications
• Contact Forms - Separate forms for inquiries and feedback
• About Section - Company information and service areas

Admin Panel

• Dashboard - Overview of services, vehicles, and recent queries
• Service Management - Add, edit, and delete service offerings
• Vehicle Management - Manage fleet with images, descriptions, and capacity details
• Query Management - View and respond to customer inquiries with status tracking
• Content Editor - Update homepage text and contact information

Technology Stack

• Frontend: HTML5, CSS3, JavaScript
• Backend: PHP
• Database: SQLite3
• Assets: Font Awesome icons, custom CSS animations

Database Schema

The SQLite database includes the following tables:

• services - Service offerings
• vehicles - Fleet information
• contact_queries - Customer inquiries and feedback
• settings - Site configuration and editable text
• social_links - Social media links

Admin Panel Usage

Login

Access the admin panel at /admin with your credentials.

Managing Services

1. Navigate to "Manage Services"
2. Add new services with name and description
3. Edit or delete existing services

Managing Vehicles

1. Navigate to "Manage Vehicles"
2. Upload vehicle images and add details:
   • Vehicle name and class
   • Number of vehicles
   • Passenger capacity
   • Description
3. Edit or remove vehicles as needed

Handling Queries

1. View all customer inquiries in "User Queries"
2. Queries are categorized as:
   • Unchecked - New inquiries
   • Done - Processed inquiries
   • Discarded - Dismissed inquiries
3. Respond directly via email integration
4. Mark queries as done or discard them

Modifying Social Media Links

Update social media links in the database social_links table or through the admin panel.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Author

Created with ❤️ by Aromal