Tour and Travel Management Using Python and MySQL

• Admin dashboard for this final year project with KPIs, booking summaries, payment summaries, notifications, and recent activity
• Brand, category, and destination management
• Hotel and transport master data management
• Tour package creation and editing with pricing, images, itinerary JSON, package dates, and seat controls
• User search, profile view, edit, password reset, and delete features
• Booking filters by status, payment status, user, package, and date range
• Booking detail management with status, payment status, travel slot, total, remarks, traveller manifest, and receipts
• Payment ledger with create, edit, delete, filters, notes, and optional receipt
• Enquiry management with reply, status, read flag, and delete options
• Review moderation with approve/hide, edit, and delete controls
• Testimonials, gallery images, offers, and coupons CRUD
• Coupon usage report
• Static page creation and editing
• Homepage section and hero slider management
• Booking, payment, and user CSV exports
• Admin profile and password management

• Customer registration, login, logout, and token-based password reset in this final year project
• Customer dashboard with bookings, wishlist, enquiries, pending payments, and upcoming trip highlight
• Profile update with name, mobile, address, gender, and optional image upload
• Change password with current password verification
• Package booking with date, traveller count, traveller details, and optional coupon
• Booking list and booking detail with travellers, payments, and balance
• Printable booking receipt
• Booking cancellation where allowed, with seat restoration
• Payment submission with amount, mode, reference, and optional proof image
• Wishlist add/remove feature
• Review submission or editing after confirmed or completed bookings
• Logged-in enquiries and package enquiry support

• Public marketing website included in this final year project
• Home page with sliders, featured packages, latest packages, destinations, offers, testimonials, brands, and gallery preview
• Package search and filters by brand, category, destination, price, duration, travel date, and featured flag
• Sorting and pagination for package listings
• Package detail page with pricing, itinerary, inclusions, exclusions, dates, reviews, and booking CTA
• Destination listing and detail pages
• Gallery and offers pages
• Static CMS pages such as About, FAQ, and Terms
• Contact form with admin notification
• File uploads stored under app/static/uploads/
• MySQL default setup with optional SQLite support
• Seed data script for demo content and credentials
• Suitable for final year project demonstration, viva, source code review, and report preparation

• Open the final year project folder and create a Python virtual environment:
  python -m venv venv
• Activate the environment:
  • Windows: venv\Scripts\activate
  • macOS/Linux: source venv/bin/activate
• Install dependencies:
  pip install -r requirements.txt
• Configure the database using either MySQL/MariaDB or SQLite.
• For MySQL, set DATABASE_URL in config.py or .env, for example:
  DATABASE_URL=mysql+pymysql://USER:[email protected]:3306/tour_travel_db?charset=utf8
• Optional: create the database manually:
  CREATE DATABASE tour_travel_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
• Run the app:
  python run.py
• Open the final year Flask project at:
  http://127.0.0.1:5000
• Optional: load demo data using:
  python seed_data.py
  Note: this seed script drops and recreates all tables.

Administrator

• URL: http://127.0.0.1:5000/admin/login
• Username: admin
• Password: admin123
• Email: [email protected]

Demo Customers

• Login URL: /auth/login
• Email: [email protected] through [email protected]
• Password: user123