Bus Booking System Project In Flask

Creating an advanced-level Bus Booking System with Flask and Bootstrap 5 involves designing a robust database structure, implementing backend logic, and creating responsive frontend pages. Below is a detailed implementation:

1. Database Structure

The database will be designed using SQLAlchemy (ORM for Flask). Here's the schema:

Tables

• Users: Stores user information.
• Buses: Stores bus details.
• Routes: Stores route information.
• Bookings: Stores booking details.
• Payments: Stores payment details.

SQL Schema

CREATE TABLE Users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) `UNIQUE` NOT NULL,
    password_hash VARCHAR(255) NOT NULL,
    role ENUM('admin', 'manager', 'sales') NOT NULL
);
CREATE TABLE Brands (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) `UNIQUE` NOT NULL
);
CREATE TABLE Models (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    brand_id INT,
    FOREIGN KEY (brand_id) REFERENCES Brands(id)
);
CREATE TABLE Cars (
    id INT PRIMARY KEY AUTO_INCREMENT,
    model_id INT,
    year `INT` NOT NULL,
    color VARCHAR(50),
    price DECIMAL(10, 2) NOT NULL,
    mileage INT,
    FOREIGN KEY (model_id) REFERENCES Models(id)
);
CREATE TABLE Inventory (
    id INT PRIMARY KEY AUTO_INCREMENT,
    car_id INT UNIQUE,
    quantity INT DEFAULT 0,
    FOREIGN KEY (car_id) REFERENCES Cars(id)
);
CREATE TABLE Customers (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) `UNIQUE` NOT NULL,
    phone VARCHAR(15)
);
CREATE TABLE Sales (
    id INT PRIMARY KEY AUTO_INCREMENT,
    car_id INT,
    customer_id INT,
    sale_date `DATE` NOT NULL,
    sale_price DECIMAL(10, 2) NOT NULL,
    FOREIGN KEY (car_id) REFERENCES Cars(id),
    FOREIGN KEY (customer_id) REFERENCES Customers(id)
);

2. Flask Application Structure

The Flask application will have the following structure:

bus_booking_system/
│
├── app.py
├── models.py
├── forms.py
├── templates/
│   ├── base.html
│   ├── index.html
│   ├── login.html
│   ├── register.html
│   ├── search_buses.html
│   ├── booking.html
│   ├── payment.html
│   ├── dashboard.html
│   └── admin/
│       ├── add_bus.html
│       ├── manage_buses.html
│       └── manage_routes.html
├── static/
│   ├── css/
│   │   └── styles.css
│   ├── js/
│   │   └── scripts.js
│   └── images/
└── requirements.txt

3. Flask Application Code

app.py

from flask import Flask, render_template, request, redirect, url_for, flash, session
from flask_sqlalchemy import SQLAlchemy
from models import db, User, Bus, Route, Booking, Payment
from forms import LoginForm, RegistrationForm, BookingForm, PaymentForm
from datetime import datetime
app = Flask(__name__)
app.config['SECRET_KEY'] = 'your_secret_key'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///bus_booking.db'
db.init_app(app)
# Routes
@app.route('/')
def index():
    return render_template('index.html')
@app.route('/register', methods=['GET', 'POST'])
def register():
    form = RegistrationForm()
    if form.validate_on_submit():
        user = User(username=form.username.data, email=form.email.data, password=form.password.data)
        db.session.add(user)
        db.session.commit()
        flash('Registration successful! Please login.', 'success')
        return redirect(url_for('login'))
    return render_template('register.html', form=form)
@app.route('/login', methods=['GET', 'POST'])
def login():
    form = LoginForm()
    if form.validate_on_submit():
        user = User.query.filter_by(email=form.email.data).first()
        if user and user.password == form.password.data:  # Use hashed passwords in production
            session['user_id'] = user.id
            flash('Login successful!', 'success')
            return redirect(url_for('dashboard'))
        flash('Login failed. Check your email and password.', 'danger')
    return render_template('login.html', form=form)
@app.route('/dashboard')
def dashboard():
    if 'user_id' not in session:
        return redirect(url_for('login'))
    user = User.query.get(session['user_id'])
    return render_template('dashboard.html', user=user)
@app.route('/search_buses', methods=['GET', 'POST'])
def search_buses():
    if request.method == 'POST':
        source = request.form['source']
        destination = request.form['destination']
        buses = Bus.query.join(Route).filter(Route.source == source, Route.destination == destination).all()
        return render_template('search_buses.html', buses=buses)
    return render_template('search_buses.html', buses=[])
@app.route('/book/<int:bus_id>', methods=['GET', 'POST'])
def book(bus_id):
    if 'user_id' not in session:
        return redirect(url_for('login'))
    form = BookingForm()
    bus = Bus.query.get(bus_id)
    if form.validate_on_submit():
        booking = Booking(user_id=session['user_id'], bus_id=bus_id, seats_booked=form.seats_booked.data)
        bus.available_seats -= form.seats_booked.data
        db.session.add(booking)
        db.session.commit()
        flash('Booking successful! Proceed to payment.', 'success')
        return redirect(url_for('payment', booking_id=booking.id))
    return render_template('booking.html', form=form, bus=bus)
@app.route('/payment/<int:booking_id>', methods=['GET', 'POST'])
def payment(booking_id):
    if 'user_id' not in session:
        return redirect(url_for('login'))
    form = PaymentForm()
    booking = Booking.query.get(booking_id)
    if form.validate_on_submit():
        payment = Payment(booking_id=booking.id, amount=form.amount.data, status='Completed')
        db.session.add(payment)
        db.session.commit()
        flash('Payment successful!', 'success')
        return redirect(url_for('dashboard'))
    return render_template('payment.html', form=form, booking=booking)
if __name__ == '__main__':
    with app.app_context():
        db.create_all()
    app.run(debug=True)

models.py

from flask_sqlalchemy import SQLAlchemy
from datetime import datetime
db = SQLAlchemy()
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50), unique=True, nullable=False)
    email = db.Column(db.String(100), unique=True, nullable=False)
    password = db.Column(db.String(200), nullable=False)
    bookings = db.relationship('Booking', backref='user', lazy=True)
class Bus(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False)
    total_seats = db.Column(db.Integer, nullable=False)
    available_seats = db.Column(db.Integer, nullable=False)
    route_id = db.Column(db.Integer, db.ForeignKey('route.id'), nullable=False)
    bookings = db.relationship('Booking', backref='bus', lazy=True)
class Route(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    source = db.Column(db.String(100), nullable=False)
    destination = db.Column(db.String(100), nullable=False)
    distance = db.Column(db.Float, nullable=False)
    buses = db.relationship('Bus', backref='route', lazy=True)
class Booking(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
    bus_id = db.Column(db.Integer, db.ForeignKey('bus.id'), nullable=False)
    seats_booked = db.Column(db.Integer, nullable=False)
    booking_date = db.Column(db.DateTime, default=datetime.utcnow)
    payment = db.relationship('Payment', backref='booking', uselist=False)
class Payment(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    booking_id = db.Column(db.Integer, db.ForeignKey('booking.id'), nullable=False)
    amount = db.Column(db.Float, nullable=False)
    payment_date = db.Column(db.DateTime, default=datetime.utcnow)
    status = db.Column(db.String(20), default='Pending')

forms.py

from flask_wtf import FlaskForm
from wtforms import StringField, PasswordField, IntegerField, FloatField, SubmitField
from wtforms.validators import DataRequired, Email, Length, NumberRange
class RegistrationForm(FlaskForm):
    username = StringField('Username', validators=[DataRequired(), Length(min=2, max=50)])
    email = StringField('Email', validators=[DataRequired(), Email()])
    password = PasswordField('Password', validators=[DataRequired(), Length(min=6, max=200)])
    submit = SubmitField('Register')
class LoginForm(FlaskForm):
    email = StringField('Email', validators=[DataRequired(), Email()])
    password = PasswordField('Password', validators=[DataRequired()])
    submit = SubmitField('Login')
class BookingForm(FlaskForm):
    seats_booked = IntegerField('Seats to Book', validators=[DataRequired(), NumberRange(min=1)])
    submit = SubmitField('Book Now')
class PaymentForm(FlaskForm):
    amount = FloatField('Amount', validators=[DataRequired(), NumberRange(min=0.01)])
    submit = SubmitField('Pay Now')

templates/base.html

<!DOCTYPE html>
<html lang=`en`>
<head>
    <meta charset=`UTF-8`>
    <meta name=`viewport` content=`width=device-width, initial-scale=1.0`>
    <link href=`https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css` rel=`stylesheet`>
    <link rel=`stylesheet` href=`{{ url_for('static', filename='css/styles.css') }}`>
    <title>{% block title %}Bus Booking System{% endblock %}</title>
</head>
<body>
    <nav class=`navbar navbar-expand-lg navbar-light bg-light`>
        <div class=`container-fluid`>
            <a class=`navbar-brand` href=`{{ url_for('index') }}`>Bus Booking</a>
            <div class=`collapse navbar-collapse`>
                <ul class=`navbar-nav me-auto`>
                    <li class=`nav-item`>
                        <a class=`nav-link` href=`{{ url_for('search_buses') }}`>Search Buses</a>
                    </li>
                    {% if 'user_id' in session %}
                    <li class=`nav-item`>
                        <a class=`nav-link` href=`{{ url_for('dashboard') }}`>Dashboard</a>
                    </li>
                    <li class=`nav-item`>
                        <a class=`nav-link` href=`{{ url_for('logout') }}`>Logout</a>
                    </li>
                    {% else %}
                    <li class=`nav-item`>
                        <a class=`nav-link` href=`{{ url_for('login') }}`>Login</a>
                    </li>
                    <li class=`nav-item`>
                        <a class=`nav-link` href=`{{ url_for('register') }}`>Register</a>
                    </li>
                    {% endif %}
                </ul>
            </div>
        </div>
    </nav>
    <div class=`container mt-4`>
        {% with messages = get_flashed_messages() %}
            {% if messages %}
                <div class=`alert alert-info`>
                    {% for message in messages %}
                        {{ message }}<br>
                    {% endfor %}
                </div>
            {% endif %}
        {% endwith %}
        {% block content %}{% endblock %}
    </div>
    <script src=`https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js`></script>
</body>
</html>

templates/index.html

{% extends 'base.html' %}
{% block content %}
<h1>Welcome to the Bus Booking System</h1>
<p>Find and book your bus tickets easily!</p>
<a href=`{{ url_for('search_buses') }}` class=`btn btn-primary`>Search Buses</a>
{% endblock %}

templates/search_buses.html

{% extends 'base.html' %}
{% block content %}
<h2>Search Buses</h2>
<form method=`POST`>
    <div class=`mb-3`>
        <label for=`source` class=`form-label`>Source</label>
        <input type=`text` class=`form-control` name=`source` required>
    </div>
    <div class=`mb-3`>
        <label for=`destination` class=`form-label`>Destination</label>
        <input type=`text` class=`form-control` name=`destination` required>
    </div>
    <button type=`submit` class=`btn btn-primary`>Search</button>
</form>
{% if buses %}
<h3>Available Buses</h3>
<ul class=`list-group mt-3`>
    {% for bus in buses %}
    <li class=`list-group-item`>
        {{ bus.name }} - Available Seats: {{ bus.available_seats }}
        <a href=`{{ url_for('book', bus_id=bus.id) }}` class=`btn btn-success btn-sm float-end`>Book Now</a>
    </li>
    {% endfor %}
</ul>
{% endif %}
{% endblock %}

templates/booking.html

{% extends 'base.html' %}
{% block content %}
<h2>Booking for {{ bus.name }}</h2>
<form method=`POST`>
    {{ form.hidden_tag() }}
    <div class=`mb-3`>
        {{ form.seats_booked.label(class=`form-label`) }}
        {{ form.seats_booked(class=`form-control`) }}
    </div>
    {{ form.submit(class=`btn btn-primary`) }}
</form>
{% endblock %}

templates/payment.html

{% extends 'base.html' %}
{% block content %}
<h2>Payment for Booking ID: {{ booking.id }}</h2>
<p>Amount: ${{ booking.seats_booked * 10 }} (Assuming $10 per seat)</p>
<form method=`POST`>
    {{ form.hidden_tag() }}
    <div class=`mb-3`>
        {{ form.amount.label(class=`form-label`) }}
        {{ form.amount(class=`form-control`) }}
    </div>
    {{ form.submit(class=`btn btn-primary`) }}
</form>
{% endblock %}

templates/dashboard.html

{% extends 'base.html' %}
{% block content %}
<h2>Dashboard</h2>
<p>Welcome, {{ user.username }}!</p>
<h3>Your Bookings</h3>
<ul class=`list-group`>
    {% for booking in user.bookings %}
    <li class=`list-group-item`>
        Booking ID: {{ booking.id }} - Bus: {{ booking.bus.name }} - Seats: {{ booking.seats_booked }}
    </li>
    {% endfor %}
</ul>
{% endblock %}

templates/admin/add_bus.html

{% extends 'base.html' %}
{% block content %}
<h2>Add New Bus</h2>
<form method=`POST`>
    <div class=`mb-3`>
        <label for=`name` class=`form-label`>Bus Name</label>
        <input type=`text` class=`form-control` name=`name` required>
    </div>
    <div class=`mb-3`>
        <label for=`total_seats` class=`form-label`>Total Seats</label>
        <input type=`number` class=`form-control` name=`total_seats` required>
    </div>
    <div class=`mb-3`>
        <label for=`route_id` class=`form-label`>Route ID</label>
        <input type=`number` class=`form-control` name=`route_id` required>
    </div>
    <button type=`submit` class=`btn btn-primary`>Add Bus</button>
</form>
{% endblock %}

templates/admin/manage_buses.html

{% extends 'base.html' %}
{% block content %}
<h2>Manage Buses</h2>
<table class=`table`>
    <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
            <th>Total Seats</th>
            <th>Available Seats</th>
            <th>Route</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for bus in buses %}
        <tr>
            <td>{{ bus.id }}</td>
            <td>{{ bus.name }}</td>
            <td>{{ bus.total_seats }}</td>
            <td>{{ bus.available_seats }}</td>
            <td>{{ bus.route.source }} to {{ bus.route.destination }}</td>
            <td>
                <a href=`{{ url_for('edit_bus', bus_id=bus.id) }}` class=`btn btn-warning btn-sm`>Edit</a>
                <a href=`{{ url_for('delete_bus', bus_id=bus.id) }}` class=`btn btn-danger btn-sm`>Delete</a>
            </td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{% endblock %}

templates/admin/manage_routes.html

{% extends 'base.html' %}
{% block content %}
<h2>Manage Routes</h2>
<table class=`table`>
    <thead>
        <tr>
            <th>ID</th>
            <th>Source</th>
            <th>Destination</th>
            <th>Distance (km)</th>
            <th>Actions</th>
        </tr>
    </thead>
    <tbody>
        {% for route in routes %}
        <tr>
            <td>{{ route.id }}</td>
            <td>{{ route.source }}</td>
            <td>{{ route.destination }}</td>
            <td>{{ route.distance }}</td>
            <td>
                <a href=`{{ url_for('edit_route', route_id=route.id) }}` class=`btn btn-warning btn-sm`>Edit</a>
                <a href=`{{ url_for('delete_route', route_id=route.id) }}` class=`btn btn-danger btn-sm`>Delete</a>
            </td>
        </tr>
        {% endfor %}
    </tbody>
</table>
{% endblock %}

Conclusion

This structure provides a comprehensive foundation for a Car Sales and Inventory Store project using Flask and Bootstrap 5. You can expand upon this by adding features such as search functionality, user permissions, and more advanced reporting.