🏟️ TurfEase

Sports Facility Booking & Management System

A full-stack web platform that bridges the gap between turf owners and sports enthusiasts — enabling real-time slot booking, tournament registration, and equipment rental in one place.

---

📌 Overview

TurfEase automates the traditionally manual process of turf booking — no more phone calls or double bookings. Users can browse turfs, check real-time slot availability, register for tournaments, and rent sports equipment, all from a single platform. Turf owners get a full admin dashboard to manage their operations efficiently.

---

✨ Features

👤 User Side

• Turf Discovery — Browse turfs with images, amenities, location, and ratings
• Real-time Slot Booking — View live availability and book time slots instantly
• Dynamic Pricing Engine — Auto-adjusts price based on peak hours, weekends, and membership tier
• Tournament Registration — Browse and join upcoming tournaments with online payment
• Pro Shop / Equipment Rental — Order sports equipment directly through the platform
• Membership System — Gold/Silver tiers with exclusive discounts
• Weather Forecast — Displays weather for your selected booking date
• Review System — Rate and review turfs after your session
• User Dashboard — Track bookings, orders, tournament registrations, and notifications
• Cancellation & Refund — Cancel bookings with automatic refund processing

🔧 Admin Side

• Manage turfs, time slots, and pricing
• View and update all bookings and orders
• Manage tournament listings and registrations
• Full user management
• Revenue tracking and analytics

---

🛠️ Tech Stack

Layer	Technology
Backend	PHP 8.2, PDO
Database	MySQL / MariaDB
Frontend	HTML5, CSS3, JavaScript
UI Framework	Next.js 14, Tailwind CSS, Radix UI, shadcn/ui
Local Server	XAMPP (Apache + MySQL)
Session Mgmt	PHP Sessions (role-based auth)

---

🗄️ Database Schema

10 tables covering the full application:

users · turfs · time_slots · bookings · tournaments · tournament_registrations · equipment · equipment_orders · reviews · notifications

---

📂 Project Structure

TurfEase/
├── admin/                  # Admin panel (bookings, turfs, users, tournaments, orders)
├── config/
│   └── database.php        # DB config & site settings
├── includes/               # Shared components (header, footer, functions)
├── public/                 # Static assets (images, icons)
├── app/                    # Next.js app directory
├── components/             # Reusable TSX components & shadcn/ui
├── css/                    # Stylesheets
├── js/                     # JavaScript files
├── turfease.sql            # Full MySQL schema + seed data
├── index.php               # Homepage
├── turfs.php               # Browse turfs
├── book.php                # Slot booking
├── dashboard.php           # User dashboard
├── tournament.php          # Tournaments listing
├── membership.php          # Membership plans
├── order_equipment.php     # Equipment rental
└── ...

---

⚙️ Local Setup

Prerequisites

• XAMPP (PHP 8.2+, MySQL, Apache)
• Node.js + npm (for Next.js frontend)

Steps

1. Clone the repository

git clone https://github.com/waniashutosh05/TurfEase.git
cd TurfEase

2. Move to XAMPP's htdocs

# Windows
xcopy /E /I TurfEase C:\xampp\htdocs\TurfEase

# macOS/Linux
cp -r TurfEase /opt/lampp/htdocs/TurfEase

3. Set up the database

• Start Apache and MySQL from XAMPP Control Panel
• Open http://localhost/phpmyadmin
• Create a new database named turfease
• Import turfease.sql

4. Configure DB connection

Open config/database.php and update:

define('DB_HOST', 'localhost');
define('DB_NAME', 'turfease');
define('DB_USER', 'root');       // your MySQL username
define('DB_PASS', '');           // your MySQL password
define('SITE_URL', 'http://localhost/TurfEase');

5. Run the app

URL	Description
http://localhost/TurfEase	User portal
http://localhost/TurfEase/admin	Admin dashboard

(Optional) Install Next.js dependencies for frontend components:

npm install

---

🔐 Default Credentials

Run http://localhost/TurfEase/create_admin.php once to create the admin account.

---

📸 Screenshots

Available in Project Report/Website SS/

---

📄 Project Report

Full documentation available in Project Report/TurfEase_Report.pdf

---

👤 Author

Ashutosh Wani
B.Sc. Computer Science — Nowrosjee Wadia College, Pune