Online Ticket Booking System Project In Laravel

Project Introduction

The Online Ticket Booking System is a comprehensive web-based application designed to facilitate the booking of tickets for various events, including concerts, movies, sports, and travel. This system aims to provide users with a seamless and efficient way to search for events, select seats, and purchase tickets online. With the growing demand for convenient ticketing solutions, the Online Ticket Booking System addresses these needs by offering a user-friendly interface and robust functionalities for both customers and event organizers.

The platform features real-time availability of tickets, secure payment processing, and options for ticket management. Users can easily browse upcoming events, view seating arrangements, and receive instant confirmations of their bookings. Additionally, the system includes tools for event organizers to manage ticket sales, track attendance, and generate reports. By automating the ticket booking process, the Online Ticket Booking System aims to enhance the overall experience for users and streamline operations for event organizers.

Project Objectives

To develop an intuitive interface for users to search for and book tickets for various events.
To implement real-time ticket availability and seating selection features.
To provide secure payment processing options for safe transactions.
To enable users to manage their bookings, including cancellations and modifications.
To facilitate notifications and reminders for upcoming events and bookings.
To generate reports on ticket sales, attendance, and user engagement for event organizers.
To ensure data security and privacy for all user information and payment details.
To enhance user engagement through features like user reviews and event recommendations.

Project Modules

User Management Module

User Registration/Login: Allow users to create accounts and log in securely.
Profile Management: Enable users to manage their profiles, including personal information, payment methods, and booking history.
Role Management: Differentiate between user roles (e.g., admin, customer, event organizer) with varying permissions.

Event Management Module

Event Creation: Allow event organizers to create and manage events, including details like date, time, location, and ticket pricing.
Event Listing: Display a list of upcoming events with search and filter options (e.g., by date, category, location).
Seating Arrangement: Manage seating layouts for events that require assigned seating.

Ticket Management Module

Ticket Types: Define different types of tickets (e.g., standard, VIP, early bird) with varying prices and availability.
Inventory Management: Track ticket availability and manage inventory levels in real-time.
Discounts and Promotions: Implement promotional codes and discounts for specific events or ticket types.

Booking Management Module

Booking Process: Facilitate the ticket booking process, including seat selection, ticket quantity, and payment.
Booking Confirmation: Send confirmation emails or messages to users after successful bookings.
Booking History: Allow users to view their past bookings and download tickets.

Payment Processing Module

Payment Gateway Integration: Integrate with payment gateways (e.g., PayPal, Stripe) for secure online transactions.
Multiple Payment Options: Offer various payment methods (credit/debit cards, digital wallets, etc.).
Refund Management: Manage refund requests and processes for canceled events or user-initiated cancellations.

Notification System

Email/SMS Notifications: Send notifications for booking confirmations, reminders, and event updates.
In-app Notifications: Provide real-time notifications within the platform for important updates.

Reporting and Analytics Module

Sales Reports: Generate reports on ticket sales, revenue, and attendance for events.
User Analytics: Track user engagement, booking patterns, and demographics.

Admin Dashboard Module

User Management: Admins can manage users, including banning or promoting users.
Event Management: Admins can oversee all events, including editing, deleting, or archiving events.
System Settings: Manage platform-wide settings, including user roles, permissions, and notifications.

Customer Support Module

Help Center: Provide FAQs and support documentation for common issues.
Live Chat/Support Tickets: Allow users to contact support through live chat or submit support tickets.

Feedback and Review Module

User Reviews: Allow users to leave reviews and ratings for events they attended.
Feedback Collection: Gather feedback on the booking process and user experience.

Security and Access Control Module

Data Security: Ensure that user data is stored securely and access is controlled based on roles.
Fraud Detection: Implement measures to detect and prevent fraudulent transactions.

Project Tables Queries


-- Create Users Table
CREATE TABLE Users (
    UserId INT PRIMARY KEY IDENTITY(1,1),
    Username NVARCHAR(50) NOT NULL UNIQUE,
    PasswordHash NVARCHAR(256) NOT NULL,
    Email NVARCHAR(100) NOT NULL UNIQUE,
    RoleId INT,
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (RoleId) REFERENCES Roles(RoleId)
);
-- Create Roles Table
CREATE TABLE Roles (
    RoleId INT PRIMARY KEY IDENTITY(1,1),
    RoleName NVARCHAR(50) NOT NULL UNIQUE
);
-- Create Events Table
CREATE TABLE Events (
    EventId INT PRIMARY KEY IDENTITY(1,1),
    Title NVARCHAR(100) NOT NULL,
    Description NVARCHAR(MAX),
    EventDate DATETIME NOT NULL,
    Venue NVARCHAR(100) NOT NULL,
    CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create Tickets Table
CREATE TABLE Tickets (
    TicketId INT PRIMARY KEY IDENTITY(1,1),
    EventId INT,
    Price DECIMAL(18, 2) NOT NULL,
    TotalAvailable INT NOT NULL,
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (EventId) REFERENCES Events(EventId)
);
-- Create Bookings Table
CREATE TABLE Bookings (
    BookingId INT PRIMARY KEY IDENTITY(1,1),
    UserId INT,
    TicketId INT,
    BookingDate DATETIME DEFAULT GETDATE(),
    Quantity INT NOT NULL,
    TotalAmount DECIMAL(18, 2) NOT NULL,
    Status NVARCHAR(50) NOT NULL, -- e.g., Confirmed, Cancelled
    FOREIGN KEY (User Id) REFERENCES Users(UserId),
    FOREIGN KEY (TicketId) REFERENCES Tickets(TicketId)
);
-- Create Payments Table
CREATE TABLE Payments (
    PaymentId INT PRIMARY KEY IDENTITY(1,1),
    BookingId INT,
    PaymentDate DATETIME DEFAULT GETDATE(),
    Amount DECIMAL(18, 2) NOT NULL,
    PaymentMethod NVARCHAR(50) NOT NULL, -- e.g., Credit Card, PayPal
    Status NVARCHAR(50) NOT NULL, -- e.g., Completed, Failed
    FOREIGN KEY (BookingId) REFERENCES Bookings(BookingId)
);
-- Create Notifications Table
CREATE TABLE Notifications (
    NotificationId INT PRIMARY KEY IDENTITY(1,1),
    UserId INT,
    Message NVARCHAR(256) NOT NULL,
    IsRead BIT DEFAULT 0,
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Reports Table
CREATE TABLE Reports (
    ReportId INT PRIMARY KEY IDENTITY(1,1),
    UserId INT,
    ReportDate DATETIME DEFAULT GETDATE(),
    Description NVARCHAR(MAX),
    Status NVARCHAR(50) NOT NULL, -- e.g., Open, Closed
    FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create SupportTickets Table
CREATE TABLE SupportTickets (
    SupportTicketId INT PRIMARY KEY IDENTITY(1,1),
    UserId INT,
    CreatedAt DATETIME DEFAULT GETDATE(),
    Subject NVARCHAR(100) NOT NULL,
    Message NVARCHAR(MAX) NOT NULL,
    Status NVARCHAR(50) NOT NULL, -- e.g., Open, Resolved
    FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Feedback Table
CREATE TABLE Feedback (
    FeedbackId INT PRIMARY KEY IDENTITY(1,1),
    UserId INT,
    Comments NVARCHAR(MAX),
    CreatedAt DATETIME DEFAULT GETDATE(),
    FOREIGN KEY (User Id) REFERENCES Users(UserId)
);

Explanation of the Tables

Users: Stores user information, including username, password hash, email, and role.

Roles: Defines user roles (e.g., Admin, Customer).

Events: Contains event details, including title, description, date, and venue.

Tickets: Manages ticket information for events, including price and availability.

Bookings: Tracks user bookings for tickets, including booking date, quantity, total amount, and status.

Payments: Stores payment information related to bookings, including payment date, amount, method, and status.

Notifications: Manages notifications for users, such as alerts for bookings or events.

Reports: Stores reports submitted by users, including description and status.

SupportTickets: Manages support tickets raised by users, including subject, message, and status.

Feedback: Stores feedback from users regarding the platform or services.

To create the models and migrations for the provided MySQL schema in Laravel 11, you can follow these steps.

Below, I will provide the migration files for each table and the corresponding Eloquent models.

Step 1: Create Migrations

You can create migrations using the Artisan command line tool. For each table, you will create a migration file. Here's how you can do it:

Create Users Table Migration


php artisan make:migration create_users_table

Migration File: database/migrations/2025_02_01_000001_create_users_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateUsersTable extends Migration
{
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id('User Id');
            $table->string('Username', 50)->unique();
            $table->string('PasswordHash', 256);
            $table->string('Email', 100)->unique();
            $table->foreignId('RoleId')->nullable()->constrained('roles', 'RoleId');
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('users');
    }
}

Create Roles Table Migration


php artisan make:migration create_roles_table

Migration File: database/migrations/2025_02_01_000002_create_roles_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateRolesTable extends Migration
{
    public function up()
    {
        Schema::create('roles', function (Blueprint $table) {
            $table->id('RoleId');
            $table->string('RoleName', 50)->unique();
        });
    }
    public function down()
    {
        Schema::dropIfExists('roles');
    }
}

Create Events Table Migration


php artisan make:migration create_events_table

Migration File: database/migrations/2025_02_01_000003_create_events_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateEventsTable extends Migration
{
    public function up()
    {
        Schema::create('events', function (Blueprint $table) {
            $table->id('EventId');
            $table->string('Title', 100);
            $table->text('Description')->nullable();
            $table->dateTime('EventDate');
            $table->string('Venue', 100);
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('events');
    }
}

Create Tickets Table Migration


php artisan make:migration create_tickets_table

Migration File: database/migrations/2025_02_01_000004_create_tickets_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateTicketsTable extends Migration
{
    public function up()
    {
        Schema::create('tickets', function (Blueprint $table) {
            $table->id('TicketId');
            $table->foreignId('EventId')->constrained('events', 'EventId');
            $table->decimal('Price', 18, 2);
            $table->integer('TotalAvailable');
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('tickets');
    }
}

Create Bookings Table Migration


php artisan make:migration create_bookings_table

Migration File: database/migrations/2025_02_01_000005_create_bookings_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateBookingsTable extends Migration
{
    public function up()
    {
        Schema::create('bookings', function (Blueprint $table) {
            $table->id('BookingId');
            $table->foreignId('User Id')->constrained('users', 'User Id');
            $table->foreignId('TicketId')->constrained('tickets', 'TicketId');
            $table->dateTime('BookingDate')->default(now());
            $table->integer('Quantity');
            $table-> decimal('TotalAmount', 18, 2);
            $table->string('Status', 50); // e.g., Confirmed, Cancelled
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('bookings');
    }
}

Create Payments Table Migration


php artisan make:migration create_payments_table

Migration File: database/migrations/2025_02_01_000005_create_payments_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreatePaymentsTable extends Migration
{
    public function up()
    {
        Schema::create('payments', function (Blueprint $table) {
            $table->id('PaymentId');
            $table->foreignId('BookingId')->constrained('bookings', 'BookingId');
            $table->dateTime('PaymentDate')->default(now());
            $table->decimal('Amount', 18, 2);
            $table->string('PaymentMethod', 50); // e.g., Credit Card, PayPal
            $table->string('Status', 50); // e.g., Completed, Failed
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('payments');
    }
}

Create Notifications Table Migration


php artisan make:migration create_notifications_table

Migration File: database/migrations/2025_02_01_000006_create_notifications_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateNotificationsTable extends Migration
{
    public function up()
    {
        Schema::create('notifications', function (Blueprint $table) {
            $table->id('NotificationId');
            $table->foreignId('User  Id')->constrained('users', 'User  Id');
            $table->string('Message', 256);
            $table->boolean('IsRead')->default(0);
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('notifications');
    }
}

Create Reports Table Migration


php artisan make:migration create_reports_table

Migration File: database/migrations/2025_02_01_000007_create_reports_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateReportsTable extends Migration
{
    public function up()
    {
        Schema::create('reports', function (Blueprint $table) {
            $table->id('ReportId');
            $table->foreignId('User  Id')->constrained('users', 'User  Id');
            $table->dateTime('ReportDate')->default(now());
            $table->text('Description')->nullable();
            $table->string('Status', 50); // e.g., Open, Closed
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('reports');
    }
}

Create SupportTickets Table Migration


php artisan make:migration create_support_tickets_table

Migration File: database/migrations/2025_02_01_000008_create_support_tickets_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateSupportTicketsTable extends Migration
{
    public function up()
    {
        Schema::create('support_tickets', function (Blueprint $table) {
            $table->id('SupportTicketId');
            $table->foreignId('User  Id')->constrained('users', 'User  Id');
            $table->dateTime('CreatedAt')->default(now());
            $table->string('Subject', 100);
            $table->text('Message');
            $table->string('Status', 50); // e.g., Open, Resolved
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('support_tickets');
    }
}

Create Feedback Table Migration


php artisan make:migration create_feedback_table

Migration File: database/migrations/2025_02_01_000009_create_feedback_table.php


use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateFeedbackTable extends Migration
{
    public function up()
    {
        Schema::create('feedback', function (Blueprint $table) {
            $table->id('FeedbackId');
            $table->foreignId('User   Id')->constrained('users', 'User   Id');
            $table->text('Comments')->nullable();
            $table->timestamps(0); // CreatedAt and UpdatedAt
        });
    }
    public function down()
    {
        Schema::dropIfExists('feedback');
    }
}

Step 2: Create Eloquent Models

For each table, you will also create a corresponding Eloquent model. Here's how you can create the models:

Create User Model


php artisan make:model User

Model File: app/Models/User.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class User extends Model
{
    use HasFactory;
    protected $table = 'users';
    protected $primaryKey = 'User  Id';
    protected $fillable = ['Username', 'PasswordHash', 'Email', 'RoleId'];
}

Create Role Model


    php artisan make:model Role

Model File: app/Models/Role.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Role extends Model
{
    use HasFactory;
    protected $table = 'roles';
    protected $primaryKey = 'RoleId';
    protected $fillable = ['RoleName'];
}

Create Event Model


    php artisan make:model Event

Model File: app/Models/Event.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Event extends Model
{
    use HasFactory;
    protected $table = 'events';
    protected $primaryKey = 'EventId';
    protected $fillable = ['Title', 'Description', 'EventDate', 'Venue'];
}

Create Ticket Model


    php artisan make:model Ticket

Model File: app/Models/Ticket.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Ticket extends Model
{
    use HasFactory;
    protected $table = 'tickets';
    protected $primaryKey = 'TicketId';
    protected $fillable = ['EventId', 'Price', 'TotalAvailable'];
}

Create Booking Model


    php artisan make:model Booking

Model File: app/Models/Booking.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Booking extends Model
{
    use HasFactory;
    protected $table = 'bookings';
    protected $primaryKey = 'BookingId';
    protected $fillable = ['User  Id', 'TicketId', 'BookingDate', 'Quantity', 'TotalAmount', 'Status'];
}

Create Payment Model


    php artisan make:model Payment

Model File: app/Models/Payment.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Payment extends Model
{
    use HasFactory;
    protected $table = 'payments';
    protected $primaryKey = 'PaymentId';
    protected $fillable = ['BookingId', 'PaymentDate', 'Amount', 'PaymentMethod', 'Status'];
}

Create Notification Model


    php artisan make:model Notification

Model File: app/Models/Notification.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Notification extends Model
{
    use HasFactory;
    protected $table = 'notifications';
    protected $primaryKey = 'NotificationId';
    protected $fillable = ['User   Id', 'Message', 'IsRead'];
}

Create Report Model


    php artisan make:model Report

Model File: app/Models/Report.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Report extends Model
{
    use HasFactory;
    protected $table = 'reports';
    protected $primaryKey = 'ReportId';
    protected $fillable = ['User   Id', 'ReportDate', 'Description', 'Status'];
}

Create SupportTicket Model


    php artisan make:model SupportTicket

Model File: app/Models/SupportTicket.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class SupportTicket extends Model
{
    use HasFactory;
    protected $table = 'support_tickets';
    protected $primaryKey = 'SupportTicketId';
    protected $fillable = ['User   Id', 'CreatedAt', 'Subject', 'Message', 'Status'];
}

Create Feedback Model


    php artisan make:model Feedback

Model File: app/Models/Feedback.php


namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Feedback extends Model
{
    use HasFactory;
    protected $table = 'feedback';
    protected $primaryKey = 'FeedbackId';
    protected $fillable = ['User    Id', 'Comments'];
}

Step 3: Run Migrations

After creating the migration files and models, you can run the migrations to create the tables in your database:


    php artisan migrate

This will set up your database schema according to the defined migrations. You can now use the Eloquent models to interact with the database in your Laravel application.

To create controllers for each model with complete CRUD operations in Laravel, you can use the Artisan command line tool to generate the controllers.

Below, I will provide the commands to create the controllers and the basic structure for each controller, including methods for creating, reading, updating, and deleting records.

Step 1: Create Controllers

You can create a controller for each model using the following commands:

Create UserController


php artisan make:controller UserController --resource

Create RoleController


php artisan make:controller RoleController --resource

Create EventController


php artisan make:controller EventController --resource

Create TicketController


php artisan make:controller TicketController --resource

Create BookingController


php artisan make:controller BookingController --resource

Create PaymentController


php artisan make:controller PaymentController --resource

Create NotificationController


php artisan make:controller NotificationController --resource

Create ReportController


php artisan make:controller ReportController --resource

Create SupportTicketController


php artisan make:controller SupportTicketController --resource

Create FeedbackController


php artisan make:controller FeedbackController --resource

Step 2: Implement CRUD Operations
Below is an example of how to implement the CRUD operations in each controller. I will provide a template for one controller, and you can replicate the structure for the others.
Example: UserController
File: app/Http/Controllers/UserController.php


namespace App\Http\Controllers;
use App\Models\User;
use Illuminate\Http\Request;
class UserController extends Controller
{
    // Display a listing of the resource
    public function index()
    {
        $users = User::all();
        return view('users.index', compact('users'));
    }
    // Show the form for creating a new resource
    public function create()
    {
        return view('users.create');
    }
    // Store a newly created resource in storage
    public function store(Request $request)
    {
        $request->validate([
            'Username' => 'required|unique:users|max:50',
            'PasswordHash' => 'required|max:256',
            'Email' => 'required|email|unique:users|max:100',
            'RoleId' => 'nullable|exists:roles,RoleId',
        ]);
        User::create($request->all());
        return redirect()->route('users.index')->with('success', 'User  created successfully.');
    }
    // Display the specified resource
    public function show(User $user)
    {
        return view('users.show', compact('user'));
    }
    // Show the form for editing the specified resource
    public function edit(User $user)
    {
        return view('users.edit', compact('user'));
    }
    // Update the specified resource in storage
    public function update(Request $request, User $user)
    {
        $request->validate([
            'Username' => 'required|max:50|unique:users,Username,' . $user->User Id,
            'PasswordHash' => 'required|max:256',
            'Email' => 'required|email|max:100|unique:users,Email,' . $user->User Id,
            'RoleId' => 'nullable|exists:roles,RoleId',
        ]);
        $user->update($request->all());
        return redirect()->route('users.index')->with('success', 'User  updated successfully.');
    }
    // Remove the specified resource from storage
    public function destroy(User $user)
    {
        $user->delete();
        return redirect()->route('users.index')->with('success', 'User  deleted successfully.');
    }
}

Step 3: Create Views
You will need to create views for each of the CRUD operations. Here’s a basic structure for the views:
Create a directory for users views:
mkdir resources/views/users
Create the following view files:
index.blade.php
create.blade.php
edit.blade.php
show.blade.php
Example: index.blade.php


@extends('layouts.app')
@section('content')
    <h1>Users</h1>
    <a href="{{ route('users.create') }}">Create User</a>
    <table>
        <thead>
            <tr>
                <th>Username</th>
                <th>Email</th>
                <th >Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($users as $user)
                <tr>
                    <td>{{ $user->Username }}</td>
                    <td>{{ $user->Email }}</td>
                    <td>
                        <a href="{{ route('users.show', $user->User Id) }}">View</a>
                        <a href="{{ route('users.edit', $user->User Id) }}">Edit</a>
                        <form action="{{ route('users.destroy', $user->User Id) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

Example: create.blade.php


@extends('layouts.app')
@section('content')
    <h1>Create User</h1>
    <form action="{{ route('users.store') }}" method="POST">
        @csrf
        <label for="Username">Username:</label>
        <input type="text" name="Username" required>
        
        <label for="PasswordHash">Password:</label>
        <input type="password" name="PasswordHash" required>
        
        <label for="Email">Email:</label>
        <input type="email" name="Email" required>
        
        <label for="RoleId">Role:</label>
        <select name="RoleId">
            @foreach ($roles as $role)
                <option value="{{ $role->RoleId }}">{{ $role->RoleName }}</option>
            @endforeach
        </select>
        
        <button type="submit">Create</button>
    </form>
@endsection

Example: edit.blade.php


@extends('layouts.app')
@section('content')
    <h1>Edit User</h1>
    <form action="{{ route('users.update', $user->User Id) }}" method="POST">
        @csrf
        @method('PUT')
        <label for="Username">Username:</label>
        <input type="text" name="Username" value="{{ $user->Username }}" required>
        
        <label for="PasswordHash">Password:</label>
        <input type="password" name="PasswordHash" value="{{ $user->PasswordHash }}" required>
        
        <label for="Email">Email:</label>
        <input type="email" name="Email" value="{{ $user->Email }}" required>
        
        <label for="RoleId">Role:</label>
        <select name="RoleId">
            @foreach ($roles as $role)
                <option value="{{ $role->RoleId }}" {{ $role->RoleId == $user->RoleId ? 'selected' : '' }}>{{ $role->RoleName }}</option>
            @endforeach
        </select>
        
        <button type="submit">Update</button>
    </form>
@endsection

Example: show.blade.php


@extends('layouts.app')
@section('content')
    <h1>User Details</h1>
    <p>Username: {{ $user->Username }}</p>
    <p>Email: {{ $user->Email }}</p>
    <p>Role: {{ $user->role->RoleName ?? 'No Role' }}</p>
    <a href="{{ route('users.edit', $user->User Id) }}">Edit</a>
    <form action="{{ route('users.destroy', $user->User Id) }}" method="POST" style="display:inline;">
        @csrf
        @method('DELETE')
        <button type="submit">Delete</button>
    </form>
    <a href="{{ route('users.index') }}">Back to Users</a>
@endsection

Step 4: Define Routes

In your routes/web.php, you need to define the routes for the resource controllers:


use App\Http\Controllers\UserController;
use App\Http\Controllers\RoleController;
use App\Http\Controllers\EventController;
use App\Http\Controllers\TicketController;
use App\Http\Controllers\BookingController;
use App\Http\Controllers\PaymentController;
use App\Http\Controllers\NotificationController;
use App\Http\Controllers\ReportController;
use App\Http\Controllers\SupportTicketController;
use App\Http\Controllers\FeedbackController;
Route::resource('users', UserController::class);
Route::resource('roles', RoleController::class);
Route::resource('events', EventController::class);
Route::resource('tickets', TicketController::class);
Route::resource('bookings', BookingController::class);
Route::resource('payments', PaymentController::class);
Route::resource('notifications', NotificationController::class);
Route::resource('reports', ReportController::class);
Route::resource('support-tickets', SupportTicketController::class);
Route::resource('feedback', Feedback Controller::class);

Step 5: Repeat for Other Controllers

You can replicate the structure of the User Controller for the other controllers (e.g., RoleController, EventController, etc.) by following the same pattern for CRUD operations and views. Ensure to adjust the model names and fields accordingly.

Below are the view files for each controller, designed using Bootstrap 5.

Each view will include a basic layout and styling to ensure a consistent look and feel across your application.

Step 1: Create a Layout File

First, create a layout file that will be used by all views. This will help maintain a consistent structure.

File: resources/views/layouts/app.blade.php


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Laravel CRUD</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
    <div class="container mt-4">
        <h1 class="text-center">Laravel CRUD Application</h1>
        @yield('content')
    </div>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

Step 2: Create Views for Each Controller

Now, create the views for each controller. Below are the views for the User Controller. You can replicate the structure for other controllers by changing the model names and fields accordingly.

User Views

File: resources/views/users/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('users.create') }}" class="btn btn-primary">Create User</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Username</th>
                <th>Email</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($users as $user)
                <tr>
                    <td>{{ $user->Username }}</td>
                    <td>{{ $user->Email }}</td>
                    <td>
                        <a href="{{ route('users.show', $user->User Id) }}" class="btn btn-info btn-sm">View</a>
                        <a href="{{ route('users.edit', $user->User Id) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('users.destroy', $user->User Id) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/users/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create User</h2>
    <form action="{{ route('users.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="Username" class="form-label">Username</label>
            <input type="text" name="Username" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="PasswordHash" class="form-label">Password</label>
            <input type="password" name="PasswordHash" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Email" class="form-label">Email</label>
            <input type="email" name="Email" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="RoleId" class="form-label">Role</label>
            <select name="RoleId" class="form-select">
                <option value="">Select Role</option>
                @foreach ($roles as $role)
                    <option value="{{ $role->RoleId }}">{{ $role->RoleName }}</option>
                @endforeach
            </select>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('users.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/users/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit User</h2>
    <form action="{{ route('users.update', $user->User Id) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="Username" class="form-label">Username</label>
            <input type="text" name="Username" class="form -control" value="{{ $user->Username }}" required>
        </div>
        <div class="mb-3">
            <label for="PasswordHash" class="form-label">Password</label>
            <input type="password" name="PasswordHash" class="form-control" value="{{ $user->PasswordHash }}" required>
        </div>
        <div class="mb-3">
            <label for="Email" class="form-label">Email</label>
            <input type="email" name="Email" class="form-control" value="{{ $user->Email }}" required>
        </div>
        <div class="mb-3">
            <label for="RoleId" class="form-label">Role</label>
            <select name="RoleId" class="form-select">
                @foreach ($roles as $role)
                    <option value="{{ $role->RoleId }}" {{ $role->RoleId == $user->RoleId ? 'selected' : '' }}>{{ $role->RoleName }}</option>
                @endforeach
            </select>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('users.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/users/show.blade.php


@extends('layouts.app')
@section('content')
    <h2>User Details</h2>
    <p><strong>Username:</strong> {{ $user->Username }}</p>
    <p><strong>Email:</strong> {{ $user->Email }}</p>
    <p><strong>Role:</strong> {{ $user->role->RoleName ?? 'No Role' }}</p>
    <a href="{{ route('users.edit', $user->User  Id) }}" class="btn btn-warning">Edit</a>
    <form action="{{ route('users.destroy', $user->User  Id) }}" method="POST" style="display:inline;">
        @csrf
        @method('DELETE')
        <button type="submit" class="btn btn-danger">Delete</button>
    </form>
    <a href="{{ route('users.index') }}" class="btn btn-secondary">Back to Users</a>
@endsection

Step 3: Repeat for Other Controllers

You can replicate the structure of the user views for the other controllers (e.g., RoleController, EventController, etc.) by following the same pattern for CRUD operations and views. Ensure to adjust the model names and fields accordingly.

Role Views

File: resources/views/roles/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('roles.create') }}" class="btn btn-primary">Create Role</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Role Name</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($roles as $role)
                <tr>
                    <td>{{ $role->RoleName }}</td>
                    <td>
                        <a href="{{ route('roles.edit', $role->RoleId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('roles.destroy', $role->RoleId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/roles/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Role</h2>
    <form action="{{ route('roles.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="RoleName" class="form-label">Role Name</label>
            <input type="text" name="RoleName" class="form-control" required>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('roles.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/roles/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Role</h2>
    <form action="{{ route('roles.update', $role->RoleId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="RoleName" class="form-label">Role Name</label>
            <input type="text" name="RoleName" class="form-control" value="{{ $role->RoleName }}" required>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('roles.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Event Views

File: resources/views/events/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('events.create') }}" class="btn btn-primary">Create Event</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Title</th>
                <th>Description</th>
                <th>Event Date</th>
                <th>Venue</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($events as $event)
                <tr>
                    <td>{{ $event->Title }}</td>
                    <td>{{ $event->Description }}</td>
                    <td>{{ $event->EventDate }}</td>
                    <td>{{ $event->Venue }}</td>
                    <td>
                        <a href="{{ route('events.edit', $event->EventId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('events.destroy', $event->EventId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/events/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Event</h2>
    <form action="{{ route('events.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="Title" class="form-label">Title</label>
 <input type="text" name="Title" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Description" class="form-label">Description</label>
            <textarea name="Description" class="form-control" required></textarea>
        </div>
        <div class="mb-3">
            <label for="EventDate" class="form-label">Event Date</label>
            <input type="date" name="EventDate" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Venue" class="form-label">Venue</label>
            <input type="text" name="Venue" class="form-control" required>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('events.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/events/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Event</h2>
    <form action="{{ route('events.update', $event->EventId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="Title" class="form-label">Title</label>
            <input type="text" name="Title" class="form-control" value="{{ $event->Title }}" required>
        </div>
        <div class="mb-3">
            <label for="Description" class="form-label">Description</label>
            <textarea name="Description" class="form-control" required>{{ $event->Description }}</textarea>
        </div>
        <div class="mb-3">
            <label for="EventDate" class="form-label">Event Date</label>
            <input type="date" name="EventDate" class="form-control" value="{{ $event->EventDate }}" required>
        </div>
        <div class="mb-3">
            <label for="Venue" class="form-label">Venue</label>
            <input type="text" name="Venue" class="form-control" value="{{ $event->Venue }}" required>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('events.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Ticket Views

File: resources/views/tickets/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('tickets.create') }}" class="btn btn-primary">Create Ticket</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Event</th>
                <th>Price</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($tickets as $ticket)
                <tr>
                    <td>{{ $ticket->event->Title }}</td>
                    <td>{{ $ticket->Price }}</td>
                    <td>
                        <a href="{{ route('tickets.edit', $ticket->TicketId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('tickets.destroy', $ticket->TicketId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/tickets/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Ticket</h2>
    <form action="{{ route('tickets.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="EventId" class="form-label">Event</label>
            <select name="EventId" class="form-select" required>
                <option value="">Select Event</option>
                @foreach ($events as $event)
                    <option value="{{ $event->EventId }}">{{ $event->Title }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Price" class="form-label">Price</label>
            <input type="number" name="Price" class="form-control" required>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('tickets.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/tickets/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Ticket</h2>
    <form action="{{ route('tickets.update', $ticket->TicketId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="EventId" class="form-label">Event</label>
            <select name="EventId" class="form-select" required>
                @foreach ($events as $event)
                    <option value="{{ $event->EventId }}" {{ $event->EventId == $ticket->EventId ? 'selected' : '' }}>{{ $event->Title }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Price" class="form-label">Price</label>
            <input type="number" name="Price" class="form-control" value="{{ $ticket->Price }}" required>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('tickets.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Booking Views

File: resources/views/bookings/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('bookings.create') }}" class="btn btn-primary">Create Booking</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>User</th>
                <th>Event</th>
                <th>Ticket</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($bookings as $booking)
                <tr>
                    <td>{{ $booking->user->Username }}</td>
                    <td>{{ $booking->event->Title }}</td>
                    <td>{{ $booking->ticket->Price }}</td>
                    <td>
                        <a href="{{ route('bookings.edit', $booking->BookingId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('bookings.destroy', $booking->BookingId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/bookings/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Booking</h2>
    <form action="{{ route('bookings.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="User Id" class="form-label">User </label>
            <select name="User Id" class="form-select" required>
                <option value="">Select User</option>
                @foreach ($users as $user)
                    <option value="{{ $user->User Id }}">{{ $user->Username }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="EventId" class="form-label">Event</label>
            <select name="EventId" class="form-select" required>
                <option value="">Select Event</option>
                @foreach ($events as $event)
                    <option value="{{ $event->EventId }}">{{ $event->Title }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="TicketId" class="form-label">Ticket</label>
            <select name="TicketId" class="form-select" required>
                <option value="">Select Ticket</option>
                @foreach ($tickets as $ticket)
                    <option value="{{ $ticket->TicketId }}">{{ $ticket->Price }}</option>
                @endforeach
            </select>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('bookings.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/bookings/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Booking</h2>
    <form action="{{ route('bookings.update', $booking->BookingId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="User  Id" class="form-label">User </label>
            <select name="User  Id" class="form-select" required>
                @foreach ($users as $user)
                    <option value="{{ $user->User  Id }}" {{ $user->User  Id == $booking->User  Id ? 'selected' : '' }}>{{ $user->Username }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="EventId" class="form-label">Event</label>
            <select name="EventId" class="form-select" required>
                @foreach ($events as $event)
                    <option value="{{ $event->EventId }}" {{ $event->EventId == $booking->EventId ? 'selected' : '' }}>{{ $event->Title }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="TicketId" class="form-label">Ticket</label>
            <select name="TicketId" class="form-select" required>
                @foreach ($tickets as $ticket)
                    <option value="{{ $ticket->TicketId }}" {{ $ticket->TicketId == $booking->TicketId ? 'selected' : '' }}>{{ $ticket->Price }}</option>
                @endforeach
            </select>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('bookings.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Payment Views

File: resources/views/payments/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('payments.create') }}" class="btn btn-primary">Create Payment</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Booking</th>
                <th>Amount</th>
                <th>Status</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($payments as $payment)
                <tr>
                    <td>{{ $payment->booking->user->Username }} - {{ $payment->booking->event->Title }}</td>
                    <td>{{ $payment->Amount }}</td>
                    <td>{{ $payment->Status }}</td>
                    <td>
                        <a href="{{ route('payments.edit', $payment->PaymentId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('payments.destroy', $payment->PaymentId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/payments/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Payment</h2>
    <form action="{{ route('payments.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="BookingId" class="form-label">Booking</label>
            <select name="BookingId" class="form-select" required>
                <option value="">Select Booking</option>
                @foreach ($bookings as $booking)
                    <option value="{{ $booking->BookingId }}">{{ $booking->user->Username }} - {{ $booking->event->Title }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Amount" class="form-label">Amount</label>
            <input type="number" name="Amount" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Status" class="form-label">Status</label>
            <select name="Status" class="form-select" required>
                <option value="Pending">Pending</option>
                <option value="Completed">Completed</option>
                <option value="Failed">Failed</option>
            </select>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('payments.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/payments/edit.blade.php


@extends('layouts.app')
@section('content')
 <h2>Edit Payment</h2>
    <form action="{{ route('payments.update', $payment->PaymentId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="BookingId" class="form-label">Booking</label>
            <select name="BookingId" class="form-select" required>
                @foreach ($bookings as $booking)
                    <option value="{{ $booking->BookingId }}" {{ $booking->BookingId == $payment->BookingId ? 'selected' : '' }}>{{ $booking->user->Username }} - {{ $booking->event->Title }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Amount" class="form-label">Amount</label>
            <input type="number" name="Amount" class="form-control" value="{{ $payment->Amount }}" required>
        </div>
        <div class="mb-3">
            <label for="Status" class="form-label">Status</label>
            <select name="Status" class="form-select" required>
                <option value="Pending" {{ $payment->Status == 'Pending' ? 'selected' : '' }}>Pending</option>
                <option value="Completed" {{ $payment->Status == 'Completed' ? 'selected' : '' }}>Completed</option>
                <option value="Failed" {{ $payment->Status == 'Failed' ? 'selected' : '' }}>Failed</option>
            </select>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('payments.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Notification Views

File: resources/views/notifications/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('notifications.create') }}" class="btn btn-primary">Create Notification</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Title</th>
                <th>Message</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($notifications as $notification)
                <tr>
                    <td>{{ $notification->Title }}</td>
                    <td>{{ $notification->Message }}</td>
                    <td>
                        <a href="{{ route('notifications.edit', $notification->NotificationId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('notifications.destroy', $notification->NotificationId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/notifications/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Notification</h2>
    <form action="{{ route('notifications.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="Title" class="form-label">Title</label>
            <input type="text" name="Title" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Message" class="form-label">Message</label>
            <textarea name="Message" class="form-control" required></textarea>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('notifications.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/notifications/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Notification</h2>
    <form action="{{ route('notifications.update', $notification->NotificationId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="Title" class="form-label">Title</label>
            <input type="text" name="Title" class="form-control" value="{{ $notification->Title }}" required>
        </div>
        <div class="mb-3">
            <label for="Message" class="form-label">Message</label>
            <textarea name="Message" class="form-control" required>{{ $notification->Message }}</textarea>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('notifications.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Report Views

File: resources/views/reports/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('reports.create') }}" class="btn btn-primary">Create Report</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>Title</th>
                <th>Description</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($reports as $report)
                <tr>
                    <td>{{ $report->Title }}</td>
                    <td>{{ $report->Description }}</td>
                    <td>
                        <a href="{{ route('reports.edit', $report->ReportId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('reports.destroy', $report->ReportId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/reports/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Report</h2>
    <form action="{{ route('reports.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="Title" class="form-label">Title</label>
            <input type="text" name="Title" class="form-control" required>
        </div>
        <div class="mb-3">
            <label for="Description" class="form-label">Description</label>
            <textarea name="Description" class="form-control" required></textarea>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('reports.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/reports/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Report</h2>
    <form action="{{ route('reports.update', $report->ReportId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="Title" class="form-label">Title</label>
            <input type="text" name="Title" class="form-control" value="{{ $report->Title }}" required>
        </div>
        <div class="mb-3">
            <label for="Description" class="form-label">Description</label>
            <textarea name="Description" class="form-control" required>{{ $report->Description }}</textarea>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('reports.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Support Ticket Views

File: resources/views/support_tickets/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('support_tickets.create') }}" class="btn btn-primary">Create Support Ticket</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>User</th>
                <th>Issue</th>
                <th>Status</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($supportTickets as $ticket)
                <tr>
                    <td>{{ $ticket->user->Username }}</td>
                    <td>{{ $ticket->Issue }}</td>
                    <td>{{ $ticket->Status }}</td>
                    <td>
                        <a href="{{ route('support_tickets.edit', $ticket->TicketId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('support_tickets.destroy', $ticket->TicketId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/support_tickets/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Support Ticket</h2>
    <form action="{{ route('support_tickets.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="User Id" class="form-label">User </label>
            <select name="User Id" class="form-select" required>
                <option value="">Select User</option>
                @foreach ($users as $user)
                    <option value="{{ $user->User Id }}">{{ $user->Username }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Issue" class="form-label">Issue</label>
            <textarea name="Issue" class="form-control" required></textarea>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('support_tickets.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/support_tickets/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Support Ticket</h2>
    <form action="{{ route('support_tickets.update', $ticket->TicketId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="User Id" class="form-label">User </label>
            <select name="User Id" class="form-select" required>
                @foreach ($users as $user)
                    <option value="{{ $user->User Id }}" {{ $user->User Id == $ticket->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Issue" class="form-label">Issue</label>
            <textarea name="Issue" class="form-control" required>{{ $ticket->Issue }}</textarea>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('support_tickets.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Feedback Views

File: resources/views/feedbacks/index.blade.php


@extends('layouts.app')
@section('content')
    <div class="mb-3">
        <a href="{{ route('feedbacks.create') }}" class="btn btn-primary">Create Feedback</a>
    </div>
    <table class="table table-bordered">
        <thead>
            <tr>
                <th>User</th>
                <th>Comment</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            @foreach ($feedbacks as $feedback)
                <tr>
                    <td>{{ $feedback->user->Username }}</td>
                    <td>{{ $feedback->Comment }}</td>
                    <td>
                        <a href="{{ route('feedbacks.edit', $feedback->FeedbackId) }}" class="btn btn-warning btn-sm">Edit</a>
                        <form action="{{ route('feedbacks.destroy', $feedback->FeedbackId) }}" method="POST" style="display:inline;">
                            @csrf
                            @method('DELETE')
                            <button type="submit" class="btn btn-danger btn-sm">Delete</button>
                        </form>
                    </td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection

File: resources/views/feedbacks/create.blade.php


@extends('layouts.app')
@section('content')
    <h2>Create Feedback</h2>
    <form action="{{ route('feedbacks.store') }}" method="POST">
        @csrf
        <div class="mb-3">
            <label for="User Id" class="form-label">User </label>
            <select name="User Id" class="form-select" required>
                <option value="">Select User</option>
                @foreach ($users as $user)
                    <option value="{{ $user->User Id }}">{{ $user->Username }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Comment" class="form-label">Comment</label>
            <textarea name="Comment" class="form-control" required></textarea>
        </div>
        <button type="submit" class="btn btn-primary">Create</button>
        <a href="{{ route('feedbacks.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

File: resources/views/feedbacks/edit.blade.php


@extends('layouts.app')
@section('content')
    <h2>Edit Feedback</h2>
    <form action="{{ route('feedbacks.update', $feedback->FeedbackId) }}" method="POST">
        @csrf
        @method('PUT')
        <div class="mb-3">
            <label for="User  Id" class="form-label">User  </label>
            <select name="User  Id" class="form-select" required>
                @foreach ($users as $user)
                    <option value="{{ $user->User  Id }}" {{ $user->User  Id == $feedback->User  Id ? 'selected' : '' }}>{{ $user->Username }}</option>
                @endforeach
            </select>
        </div>
        <div class="mb-3">
            <label for="Comment" class="form-label">Comment</label>
            <textarea name="Comment" class="form-control" required>{{ $feedback->Comment }}</textarea>
        </div>
        <button type="submit" class="btn btn-warning">Update</button>
        <a href="{{ route('feedbacks.index') }}" class="btn btn-secondary">Back</a>
    </form>
@endsection

Creating a layout file in Laravel allows you to define a common structure for your views, which can help maintain consistency across your application.

Below is an example of a layout file using Bootstrap 5. This layout file will include a navigation bar, a footer, and a section for the main content.

Layout File: resources/views/layouts/app.blade.php


    <!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>@yield('title', 'Laravel CRUD Application')</title>
        <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/css/bootstrap.min.css" rel="stylesheet">
        <link rel="stylesheet" href="{{ asset('css/app.css') }}"> <!-- Optional custom CSS -->
    </head>
    <body>
        <nav class="navbar navbar-expand-lg navbar-light bg-light">
            <div class="container-fluid">
                <a class="navbar-brand" href="{{ url('/') }}">Laravel CRUD</a>
                <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
                    <span class="navbar-toggler-icon"></span>
                </button>
                <div class="collapse navbar-collapse" id="navbarNav">
                    <ul class="navbar-nav">
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('users.index') }}">Users</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('roles.index') }}">Roles</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('events.index') }}">Events</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('tickets.index') }}">Tickets</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('bookings.index ') }}">Bookings</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('payments.index') }}">Payments</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('notifications.index') }}">Notifications</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('reports.index') }}">Reports</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('support_tickets.index') }}">Support Tickets</a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="{{ route('feedbacks.index') }}">Feedback</a>
                        </li>
                    </ul>
                </div>
            </div>
        </nav>
        <div class="container mt-4">
            @yield('content')
        </div>
        <footer class="bg-light text-center text-lg-start mt-4">
            <div class="text-center p-3">
                © {{ date('Y') }} Laravel CRUD Application
            </div>
        </footer>
        <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.bundle.min.js"></script>
    </body>
    </html>

Explanation of the Layout File

HTML Structure: The layout file starts with the standard HTML structure, including the <!DOCTYPE html> declaration and the <html> tag.

Head Section:

The <head> section includes meta tags for character set and viewport settings.

The title of the page can be set using @yield('title', 'Default Title'), allowing individual views to specify their own titles.

The Bootstrap CSS is included via a CDN link, and you can also link to a custom CSS file if needed.

Navigation Bar:

A responsive navigation bar is created using Bootstrap classes. It includes links to different sections of the application (Users, Roles, Events, etc.).

The navigation links use Laravel's route helper functions to generate URLs.

Content Section:

The @yield('content') directive is where the content of individual views will be injected.

Footer:

A simple footer is included at the bottom of the page, displaying the current year.

Scripts:

The Bootstrap JavaScript bundle is included at the end of the body for better performance.

Usage

To use this layout in your views, you can extend it like this:


    @extends('layouts.app')
    @section('title', 'Page Title')
    @section('content')
        <h1>Your Content Here</h1>
        <p>This is where you can add your specific content for this page.</p>
    @endsection

This structure allows you to maintain a consistent look and feel across all your views while only needing to define the unique content for each page. You can further customize the layout and styles as needed to fit your application's requirements.

To create a dashboard page in your Laravel application that displays consolidated data related to your project, you will need to follow these steps:

Step 1: Create a Route for the Dashboard

Add the following route to your routes/web.php file:


    use App\Http\Controllers\DashboardController;
    Route::get('/dashboard', [DashboardController::class, 'index'])->name('dashboard');

Step 2: Create a Controller Method

You can create a new controller for the dashboard or use an existing one. Here, I will create a new Dashboard Controller.

Run the following command to create the controller:


php artisan make:controller DashboardController

Then, add the following method to the DashboardController:
File: app/Http/Controllers/DashboardController.php


namespace App\Http\Controllers;
use App\Models\User;
use App\Models\Role;
use App\Models\Event;
use App\Models\Ticket;
use App\Models\Booking;
use App\Models\Payment;
use App\Models\Notification;
use App\Models\Report;
use App\Models\SupportTicket;
use App\Models\Feedback;
class DashboardController extends Controller
{
    public function index()
    {
        $userCount = User::count();
        $roleCount = Role::count();
        $eventCount = Event::count();
        $ticketCount = Ticket::count();
        $bookingCount = Booking::count();
        $paymentCount = Payment::count();
        $notificationCount = Notification::count();
        $reportCount = Report::count();
        $supportTicketCount = SupportTicket::count();
        $feedbackCount = Feedback::count();
        return view('dashboard.index', compact(
            'userCount',
            'roleCount',
            'eventCount',
            'ticketCount',
            'bookingCount',
            'paymentCount',
            'notificationCount',
            'reportCount',
            'supportTicketCount',
            'feedbackCount'
        ));
    }
}

Step 3: Create a Dashboard View
Create a new view file for the dashboard.
File: resources/views/dashboard/index.blade.php


@extends('layouts.app')
@section('title', 'Dashboard')
@section('content')
    <h2 class="mb-4">Dashboard</h2>
    <div class="row">
        <div class="col-md-3">
            <div class="card text-white bg-primary mb-3">
                <div class="card-header">Users</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $userCount }}</h5>
                    <p class="card-text">Total number of users.</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-success mb-3">
                <div class="card-header">Roles</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $roleCount }}</h5>
                    <p class="card-text">Total number of roles.</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-info mb-3">
                <div class="card-header">Events</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $eventCount }}</h5>
                    <p class="card-text">Total number of events.</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-warning mb-3">
                <div class="card-header">Tickets</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $ticketCount }}</h5>
                    <p class="card-text">Total number of tickets.</p>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-3">
            <div class="card text-white bg-danger mb-3">
                <div class="card-header">Bookings</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $bookingCount }}</h5>
                    <p class="card-text">Total number of bookings.</p>
                </div>
            </div>
        </div>
        <div class="col-md-3 <div class="card text-white bg-secondary mb-3">
                <div class="card-header">Payments</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $paymentCount }}</h5>
                    <p class="card-text">Total number of payments.</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-dark mb-3">
                <div class="card-header">Notifications</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $notificationCount }}</h5>
                    <p class="card-text">Total number of notifications.</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-light mb-3 text-dark">
                <div class="card-header">Reports</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $reportCount }}</h5>
                    <p class="card-text">Total number of reports.</p>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-3">
            <div class="card text-white bg-info mb-3">
                <div class="card-header">Support Tickets</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $supportTicketCount }}</h5>
                    <p class="card-text">Total number of support tickets.</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-white bg-success mb-3">
                <div class="card-header">Feedback</div>
                <div class="card-body">
                    <h5 class="card-title">{{ $feedbackCount }}</h5>
                    <p class="card-text">Total number of feedback entries.</p>
                </div>
            </div>
        </div>
    </div>
@endsection

Summary

This dashboard page provides a consolidated view of various metrics related to your project, such as the total number of users, roles, events, tickets, bookings, payments, notifications, reports, support tickets, and feedback. Each metric is displayed in a Bootstrap card for a clean and organized layout. You can further enhance the dashboard by adding charts or graphs to visualize the data more effectively.