Project Introduction
The Library Management System is a comprehensive software solution designed to streamline the operations of libraries, enabling efficient management of books, members, and transactions. This system aims to automate various processes such as book cataloging, member registration, borrowing and returning of books, and tracking overdue items. With the increasing volume of library resources and the need for effective management, the Library Management System addresses these challenges by providing a centralized platform for library staff and patrons.
The system features a user-friendly interface that allows librarians to manage inventory, track book availability, and generate reports on library usage. For library members, the system provides tools to search for books, check availability, and manage their borrowing history. By automating these processes, the Library Management System enhances operational efficiency, improves user experience, and ensures that library resources are utilized effectively.
Project Objectives
- To develop an intuitive interface for managing library operations and user interactions.
- To automate the cataloging of books and resources for easy access and management.
- To enable member registration and management, including tracking borrowing history.
- To facilitate the borrowing and returning process, including overdue notifications.
- To provide search functionalities for users to find books and resources quickly.
- To generate reports on book circulation, member activity, and inventory status.
- To ensure data security and privacy for all user and transaction information.
- To enhance user engagement through features like book recommendations and reviews.
Project Modules
1. User Management Module
- User Registration/Login: Allow library staff and patrons to create accounts and log in securely.
- Role Management: Differentiate between user roles (e.g., admin, librarian, member) with varying permissions.
- Profile Management: Enable users to manage their profiles, including personal information and contact details.
2. Catalog Management Module
- Book Acquisition: Manage the process of acquiring new books and resources.
- Cataloging: Organize and categorize library materials using metadata (e.g., title, author, ISBN, genre).
- Search Functionality: Provide a robust search feature to allow users to find books and resources by various criteria (e.g., title, author, subject).
3. Circulation Management Module
- Check-in/Check-out: Facilitate the lending and returning of library materials.
- Renewals: Allow users to renew borrowed items if they are not reserved by others.
- Fines and Fees Management: Track overdue items and calculate fines for late returns.
4. Reservation Management Module
- Hold Requests: Allow users to place holds on checked-out items.
- Notification System: Notify users when reserved items become available.
5. Inventory Management Module
- Stock Management: Track the availability and condition of library materials.
- Inventory Audits: Conduct regular audits to ensure the accuracy of the catalog and inventory.
6. Reporting and Analytics Module
- Usage Reports: Generate reports on library usage, including the number of check-outs, popular titles, and user demographics.
- Inventory Reports: Provide insights into inventory levels and trends.
7. Membership Management Module
- Member Registration: Allow users to register for library membership.
- Membership Types: Manage different types of memberships (e.g., student, faculty, community).
- Membership Renewal: Facilitate the renewal process for library memberships.
8. Digital Resource Management Module
- E-books and Journals: Manage digital resources, including e-books, online journals, and databases.
- Access Control: Control access to digital resources based on user roles and membership types.
9. Interlibrary Loan Management Module
- Loan Requests: Facilitate requests for materials not available in the local library from other libraries.
- Tracking: Track the status of interlibrary loans and manage returns.
10. User Feedback and Support Module
- Feedback Collection: Allow users to provide feedback on library services and resources.
- Support Requests: Enable users to submit support requests or inquiries.
11. Event Management Module
- Event Scheduling: Manage library events, workshops, and programs.
- Registration: Allow users to register for events and track attendance.
12. Security and Access Control Module
- Data Security: Ensure that user data and library resources are stored securely.
- Access Control: Manage access to different modules and features based on user roles.
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 Books Table
CREATE TABLE Books (
BookId INT PRIMARY KEY IDENTITY(1,1),
Title NVARCHAR(200) NOT NULL,
Author NVARCHAR(100) NOT NULL,
ISBN NVARCHAR(20) NOT NULL UNIQUE,
Publisher NVARCHAR(100),
PublishedDate DATE,
Category NVARCHAR(100),
CopiesAvailable INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create CatalogItems Table
CREATE TABLE CatalogItems (
CatalogItemId INT PRIMARY KEY IDENTITY(1,1),
BookId INT,
Location NVARCHAR(100),
Status NVARCHAR(50) NOT NULL, -- e.g., Available, Checked Out
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (BookId) REFERENCES Books(BookId)
);
-- Create CirculationRecords Table
CREATE TABLE CirculationRecords (
CirculationRecordId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CatalogItemId INT,
CheckoutDate DATETIME NOT NULL,
DueDate DATETIME NOT NULL,
ReturnDate DATETIME,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CatalogItemId) REFERENCES CatalogItems(CatalogItemId)
);
-- Create Reservations Table
CREATE TABLE Reservations (
ReservationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
CatalogItemId INT,
ReservationDate DATETIME NOT NULL,
ExpirationDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (CatalogItemId) REFERENCES CatalogItems(CatalogItemId)
);
-- Create InventoryItems Table
CREATE TABLE InventoryItems (
InventoryItemId INT PRIMARY KEY IDENTITY(1,1),
BookId INT,
Quantity INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (BookId) REFERENCES Books(BookId)
);
-- Create Memberships Table
CREATE TABLE Memberships (
MembershipId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
MembershipType NVARCHAR(50) NOT NULL, -- e.g., Regular, Premium
StartDate DATE NOT NULL,
ExpirationDate DATE NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create DigitalResources Table
CREATE TABLE DigitalResources (
DigitalResourceId INT PRIMARY KEY IDENTITY(1,1),
Title NVARCHAR(200) NOT NULL,
ResourceType NVARCHAR(50) NOT NULL, -- e.g., eBook, Audiobook
URL NVARCHAR(256) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE()
);
-- Create InterlibraryLoans Table
CREATE TABLE InterlibraryLoans (
InterlibraryLoanId INT PRIMARY KEY IDENTITY(1,1),
UserId INT,
BookId INT,
LoanDate DATETIME NOT NULL,
DueDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId),
FOREIGN KEY (BookId) REFERENCES Books(BookId)
);
-- 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,
CreatedAt DATETIME DEFAULT GETDATE()
);
-- 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, Librarian, Member).
Books: Contains book details, including title, author, ISBN, publisher, published date, category, and available copies.
CatalogItems: Manages catalog items, linking books to their physical locations and status (e.g., available, checked out).
CirculationRecords: Tracks the checkout and return of catalog items by users, including due dates and return dates.
Reservations: Contains reservation details for catalog items, including user information and expiration dates.
InventoryItems: Manages the inventory of books, tracking the quantity available in the library.
Memberships: Stores membership information for users, including membership type and validity dates.
DigitalResources: Contains information about digital resources available in the library, including type and URL.
InterlibraryLoans: Tracks loans of books from other libraries, including loan and due dates.
Events: Manages events organized by the library, including title, description, and date.
Feedback: Stores feedback from users, allowing them to provide comments on library services.
To create the models and migrations for the provided MySQL schema in Laravel 11, you can follow these steps.
Step 1: Create Migrations
php artisan make:migration create_users_table
Migration for Users Table
// 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');
}
}
Migration for Roles Table
// 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();
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('roles');
}
}
Migration for Books Table
// database/migrations/2025_02_01_000003_create_books_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateBooksTable extends Migration
{
public function up()
{
Schema::create('books', function (Blueprint $table) {
$table->id('BookId');
$table->string('Title', 200);
$table->string('Author', 100);
$table->string('ISBN', 20)->unique();
$table->string('Publisher', 100)->nullable();
$table->date('PublishedDate')->nullable();
$table->string('Category', 100)->nullable();
$table->integer('CopiesAvailable');
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('books');
}
}
Migration for CatalogItems Table
// database/migrations/2025_02_01_000004_create_catalog_items_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateCatalogItemsTable extends Migration
{
public function up()
{
Schema::create('catalog_items', function (Blueprint $table) {
$table->id('CatalogItemId');
$table->foreignId('BookId')->constrained('books', 'BookId');
$table->string('Location', 100)->nullable();
$table->string('Status', 50);
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('catalog_items');
}
}
Migration for CirculationRecords Table
// database/migrations/2025_02_01_000005_create_circulation_records_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateCirculationRecordsTable extends Migration
{
public function up()
{
Schema::create('circulation_records', function (Blueprint $table) {
$table->id('CirculationRecordId');
$table->foreignId('User Id')->constrained('users', 'User Id');
$table->foreignId('CatalogItemId')->constrained('catalog_items', 'CatalogItemId');
$table->dateTime('CheckoutDate');
$table->dateTime('DueDate');
$table->dateTime('ReturnDate')->nullable();
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('circulation_records');
}
}
Migration for Reservations Table
// database/migrations/2025_02_01_000006_create_reservations_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateReservationsTable extends Migration
{
public function up()
{
Schema::create('reservations', function (Blueprint $table) {
$table->id('ReservationId');
$table->foreignId('User Id')->constrained('users', 'User Id');
$table->foreignId('CatalogItemId')->constrained('catalog_items', 'CatalogItemId');
$table->dateTime('ReservationDate');
$table->dateTime('ExpirationDate');
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('reservations');
}
}
Migration for InventoryItems Table
// database/migrations/2025_02_01_000007_create_inventory_items_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateInventoryItemsTable extends Migration
{
public function up()
{
Schema::create('inventory_items', function (Blueprint $table) {
$table->id(' InventoryItemId');
$table->foreignId('BookId')->constrained('books', 'BookId');
$table->integer('Quantity');
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('inventory_items');
}
}
Migration for Memberships Table
// database/migrations/2025_02_01_000008_create_memberships_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateMembershipsTable extends Migration
{
public function up()
{
Schema::create('memberships', function (Blueprint $table) {
$table->id('MembershipId');
$table->foreignId('User Id')->constrained('users', 'User Id');
$table->string('MembershipType', 50);
$table->date('StartDate');
$table->date('ExpirationDate');
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('memberships');
}
}
Migration for DigitalResources Table
// database/migrations/2025_02_01_000009_create_digital_resources_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateDigitalResourcesTable extends Migration
{
public function up()
{
Schema::create('digital_resources', function (Blueprint $table) {
$table->id('DigitalResourceId');
$table->string('Title', 200);
$table->string('ResourceType', 50);
$table->string('URL', 256);
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('digital_resources');
}
}
Migration for InterlibraryLoans Table
// database/migrations/2025_02_01_000010_create_interlibrary_loans_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateInterlibraryLoansTable extends Migration
{
public function up()
{
Schema::create('interlibrary_loans', function (Blueprint $table) {
$table->id('InterlibraryLoanId');
$table->foreignId('User Id')->constrained('users', 'User Id');
$table->foreignId('BookId')->constrained('books', 'BookId');
$table->dateTime('LoanDate');
$table->dateTime('DueDate');
$table->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('interlibrary_loans');
}
}
Migration for Events Table
// database/migrations/2025_02_01_000011_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->timestamps(0);
});
}
public function down()
{
Schema::dropIfExists('events');
}
}
Migration for Feedback Table
// database/migrations/2025_02_01_000012_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);
});
}
public function down()
{
Schema::dropIfExists('feedback');
}
}
Step 2: Create Models
php artisan make:model User
User Model
// 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'];
}
Role Model
// 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'];
}
Book Model
// app/Models/Book.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Book extends Model
{
use HasFactory;
protected $table = 'books';
protected $primaryKey = 'BookId';
protected $fillable = ['Title', 'Author', 'ISBN', 'Publisher', 'PublishedDate', 'Category', 'CopiesAvailable'];
}
CatalogItem Model
// app/Models/CatalogItem.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class CatalogItem extends Model
{
use HasFactory;
protected $table = 'catalog_items';
protected $primaryKey = 'CatalogItemId';
protected $fillable = ['BookId', 'Location', 'Status'];
}
CirculationRecord Model
// app/Models/CirculationRecord.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class CirculationRecord extends Model
{
use HasFactory;
protected $table = 'circulation_records';
protected $primaryKey = 'CirculationRecordId';
protected $fillable = ['User Id', 'CatalogItemId', 'CheckoutDate', 'DueDate', 'ReturnDate'];
}
Reservation Model
// app/Models/Reservation.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Reservation extends Model
{
use HasFactory;
protected $table = 'reservations';
protected $primaryKey = 'ReservationId';
protected $fillable = ['User Id', 'CatalogItemId', 'ReservationDate', 'ExpirationDate'];
}
InventoryItem Model
// app/Models/InventoryItem.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class InventoryItem extends Model
{
use HasFactory;
protected $table = 'inventory_items';
protected $primaryKey = 'InventoryItemId';
protected $fillable = ['BookId', 'Quantity'];
}
Membership Model
// app/Models/Membership.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Membership extends Model
{
use HasFactory;
protected $table = 'memberships';
protected $primaryKey = 'MembershipId';
protected $fillable = ['User Id', 'MembershipType', 'StartDate', 'ExpirationDate'];
}
DigitalResource Model
// app/Models/DigitalResource.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class DigitalResource extends Model
{
use HasFactory;
protected $table = 'digital_resources';
protected $primaryKey = 'DigitalResourceId';
protected $fillable = ['Title', 'ResourceType', 'URL'];
}
InterlibraryLoan Model
// app/Models/InterlibraryLoan.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class InterlibraryLoan extends Model
{
use HasFactory;
protected $table = 'interlibrary_loans';
protected $primaryKey = 'InterlibraryLoanId';
protected $fillable = ['User Id', 'BookId', 'LoanDate', 'DueDate'];
}
Event Model
// 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'];
}
Feedback Model
// 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'];
}
This completes the creation of the migrations and models for your Laravel application based on the provided MySQL schema.
You can now run the migrations using the command:
php artisan migrate
This will create the tables in your database as defined in the migration files.
To create controllers for each model with complete CRUD operations in Laravel, you can use the Artisan command to generate resource controllers.
Step 1: Create Controllers
You can create a resource controller for each model using the following command:
php artisan make:controller UserController --resource
php artisan make:controller RoleController --resource
php artisan make:controller BookController --resource
php artisan make:controller CatalogItemController --resource
php artisan make:controller CirculationRecordController --resource
php artisan make:controller ReservationController --resource
php artisan make:controller InventoryItemController --resource
php artisan make:controller MembershipController --resource
php artisan make:controller DigitalResourceController --resource
php artisan make:controller InterlibraryLoanController --resource
php artisan make:controller EventController --resource
php artisan make:controller FeedbackController --resource
Step 2: Implement CRUD Operations
Below are the implementations for each controller. Each controller will have methods for the CRUD operations.
UserController
// app/Http/Controllers/UserController.php
namespace App\Http\Controllers;
use App\Models\User;
use Illuminate\Http\Request;
class UserController extends Controller
{
public function index()
{
$users = User::all();
return view('users.index', compact('users'));
}
public function create()
{
return view('users.create');
}
public function store(Request $request)
{
$request->validate([
'Username' => 'required|unique:users|max:50',
'PasswordHash' => 'required',
'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.');
}
public function show(User $user)
{
return view('users.show', compact('user'));
}
public function edit(User $user)
{
return view('users.edit', compact('user'));
}
public function update(Request $request, User $user)
{
$request->validate([
'Username' => 'required|max:50|unique:users,Username,' . $user->id,
'PasswordHash' => 'required',
'Email' => 'required|email|max:100|unique:users,Email,' . $user->id,
'RoleId' => 'nullable|exists:roles,RoleId',
]);
$user->update($request->all());
return redirect()->route('users.index')->with('success', 'User updated successfully.');
}
public function destroy(User $user)
{
$user->delete();
return redirect()->route('users.index')->with('success', 'User deleted successfully.');
}
}
RoleController
// app/Http/Controllers/RoleController.php
namespace App\Http\Controllers;
use App\Models\Role;
use Illuminate\Http\Request;
class RoleController extends Controller
{
public function index()
{
$roles = Role::all();
return view('roles.index', compact('roles'));
}
public function create()
{
return view('roles.create');
}
public function store(Request $request)
{
$request->validate([
'RoleName' => 'required|unique:roles|max:50',
]);
Role::create($request->all());
return redirect()->route('roles.index')->with('success', 'Role created successfully.');
}
public function show(Role $role)
{
return view('roles.show', compact('role'));
}
public function edit(Role $role)
{
return view('roles.edit', compact('role'));
}
public function update(Request $request, Role $role)
{
$request->validate([
'RoleName' => 'required|max:50|unique:roles,RoleName,' . $role->id,
]);
$role->update($request->all());
return redirect()->route('roles.index')->with('success', 'Role updated successfully.');
}
public function destroy(Role $role)
{
$role->delete();
return redirect()->route('roles.index')->with('success', 'Role deleted successfully.');
}
}
BookController
// app/Http/Controllers/BookController.php
namespace App\Http\Controllers;
use App\Models\Book;
use Illuminate\Http\Request;
class BookController extends Controller
{
public function index()
{
$books = Book::all();
return view('books.index', compact('books'));
}
public function create()
{
return view('books.create');
}
public function store(Request $request)
{
$request->validate([
'Title' => 'required|max:200',
'Author' => 'required|max:100',
'ISBN' => 'required|unique:books|max:20',
'Publisher' => 'nullable|max:100',
'PublishedDate' => 'nullable|date',
'Category' => 'nullable|max:100',
'CopiesAvailable' => 'required|integer',
]);
Book::create($request->all());
return redirect()->route('books.index')->with('success', 'Book created successfully.');
}
public function show(Book $book)
{
return view('books.show', compact('book'));
}
public function edit(Book $book)
{
return view('books.edit', compact('book'));
}
public function update(Request $request, Book $book)
{
$request->validate([
'Title' => 'required|max:200',
'Author' => 'required|max:100',
'ISBN' => 'required|max:20| unique:books,ISBN,' . $book->id,
'Publisher' => 'nullable|max:100',
'PublishedDate' => 'nullable|date',
'Category' => 'nullable|max:100',
'CopiesAvailable' => 'required|integer',
]);
$book->update($request->all());
return redirect()->route('books.index')->with('success', 'Book updated successfully.');
}
public function destroy(Book $book)
{
$book->delete();
return redirect()->route('books.index')->with('success', 'Book deleted successfully.');
}
}
CatalogItemController
// app/Http/Controllers/CatalogItemController.php
namespace App\Http\Controllers;
use App\Models\CatalogItem;
use Illuminate\Http\Request;
class CatalogItemController extends Controller
{
public function index()
{
$catalogItems = CatalogItem::all();
return view('catalog_items.index', compact('catalogItems'));
}
public function create()
{
return view('catalog_items.create');
}
public function store(Request $request)
{
$request->validate([
'BookId' => 'required|exists:books,BookId',
'Location' => 'nullable|max:100',
'Status' => 'required|max:50',
]);
CatalogItem::create($request->all());
return redirect()->route('catalog_items.index')->with('success', 'Catalog item created successfully.');
}
public function show(CatalogItem $catalogItem)
{
return view('catalog_items.show', compact('catalogItem'));
}
public function edit(CatalogItem $catalogItem)
{
return view('catalog_items.edit', compact('catalogItem'));
}
public function update(Request $request, CatalogItem $catalogItem)
{
$request->validate([
'BookId' => 'required|exists:books,BookId',
'Location' => 'nullable|max:100',
'Status' => 'required|max:50',
]);
$catalogItem->update($request->all());
return redirect()->route('catalog_items.index')->with('success', 'Catalog item updated successfully.');
}
public function destroy(CatalogItem $catalogItem)
{
$catalogItem->delete();
return redirect()->route('catalog_items.index')->with('success', 'Catalog item deleted successfully.');
}
}
CirculationRecordController
// app/Http/Controllers/CirculationRecordController.php
namespace App\Http\Controllers;
use App\Models\CirculationRecord;
use Illuminate\Http\Request;
class CirculationRecordController extends Controller
{
public function index()
{
$circulationRecords = CirculationRecord::all();
return view('circulation_records.index', compact('circulationRecords'));
}
public function create()
{
return view('circulation_records.create');
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'CatalogItemId' => 'required|exists:catalog_items,CatalogItemId',
'CheckoutDate' => 'required|date',
'DueDate' => 'required|date',
]);
CirculationRecord::create($request->all());
return redirect()->route('circulation_records.index')->with('success', 'Circulation record created successfully.');
}
public function show(CirculationRecord $circulationRecord)
{
return view('circulation_records.show', compact('circulationRecord'));
}
public function edit(CirculationRecord $circulationRecord)
{
return view('circulation_records.edit', compact('circulationRecord'));
}
public function update(Request $request, CirculationRecord $circulationRecord)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'CatalogItemId' => 'required|exists:catalog_items,CatalogItemId',
'CheckoutDate' => 'required|date',
'DueDate' => 'required|date',
'ReturnDate' => 'nullable|date',
]);
$circulationRecord->update($request->all());
return redirect()->route('circulation_records.index')->with('success', 'Circulation record updated successfully.');
}
public function destroy(CirculationRecord $circulationRecord)
{
$circulationRecord->delete();
return redirect()->route('circulation_records.index')->with('success', 'Circulation record deleted successfully.');
}
}
ReservationController
// app/Http/Controllers/ReservationController.php
namespace App\Http\Controllers;
use App\Models\Reservation;
use Illuminate\Http\Request;
class ReservationController extends Controller
{
public function index()
{
$reservations = Reservation::all();
return view('reserv ations.index', compact('reservations'));
}
public function create()
{
return view('reservations.create');
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'CatalogItemId' => 'required|exists:catalog_items,CatalogItemId',
'ReservationDate' => 'required|date',
'ExpirationDate' => 'required|date',
]);
Reservation::create($request->all());
return redirect()->route('reservations.index')->with('success', 'Reservation created successfully.');
}
public function show(Reservation $reservation)
{
return view('reservations.show', compact('reservation'));
}
public function edit(Reservation $reservation)
{
return view('reservations.edit', compact('reservation'));
}
public function update(Request $request, Reservation $reservation)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'CatalogItemId' => 'required|exists:catalog_items,CatalogItemId',
'ReservationDate' => 'required|date',
'ExpirationDate' => 'required|date',
]);
$reservation->update($request->all());
return redirect()->route('reservations.index')->with('success', 'Reservation updated successfully.');
}
public function destroy(Reservation $reservation)
{
$reservation->delete();
return redirect()->route('reservations.index')->with('success', 'Reservation deleted successfully.');
}
}
InventoryItemController
// app/Http/Controllers/InventoryItemController.php
namespace App\Http\Controllers;
use App\Models\InventoryItem;
use Illuminate\Http\Request;
class InventoryItemController extends Controller
{
public function index()
{
$inventoryItems = InventoryItem::all();
return view('inventory_items.index', compact('inventoryItems'));
}
public function create()
{
return view('inventory_items.create');
}
public function store(Request $request)
{
$request->validate([
'BookId' => 'required|exists:books,BookId',
'Quantity' => 'required|integer',
]);
InventoryItem::create($request->all());
return redirect()->route('inventory_items.index')->with('success', 'Inventory item created successfully.');
}
public function show(InventoryItem $inventoryItem)
{
return view('inventory_items.show', compact('inventoryItem'));
}
public function edit(InventoryItem $inventoryItem)
{
return view('inventory_items.edit', compact('inventoryItem'));
}
public function update(Request $request, InventoryItem $inventoryItem)
{
$request->validate([
'BookId' => 'required|exists:books,BookId',
'Quantity' => 'required|integer',
]);
$inventoryItem->update($request->all());
return redirect()->route('inventory_items.index')->with('success', 'Inventory item updated successfully.');
}
public function destroy(InventoryItem $inventoryItem)
{
$inventoryItem->delete();
return redirect()->route('inventory_items.index')->with('success', 'Inventory item deleted successfully.');
}
}
MembershipController
// app/Http/Controllers/MembershipController.php
namespace App\Http\Controllers;
use App\Models\Membership;
use Illuminate\Http\Request;
class MembershipController extends Controller
{
public function index()
{
$memberships = Membership::all();
return view('memberships.index', compact('memberships'));
}
public function create()
{
return view('memberships.create');
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'MembershipType' => 'required|max:50',
'StartDate' => 'required|date',
'ExpirationDate' => 'required|date',
]);
Membership::create($request->all());
return redirect()->route('memberships.index')->with('success', 'Membership created successfully.');
}
public function show(Membership $membership)
{
return view('memberships.show', compact('membership'));
}
public function edit(Membership $membership)
{
return view('memberships.edit', compact('membership'));
}
public function update(Request $request, Membership $membership)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'MembershipType' => 'required|max:50',
'StartDate' => 'required|date',
'ExpirationDate' => 'required|date',
]);
$membership->update($request->all());
return redirect()->route('memberships.index')-> with('success', 'Membership updated successfully.');
}
public function destroy(Membership $membership)
{
$membership->delete();
return redirect()->route('memberships.index')->with('success', 'Membership deleted successfully.');
}
}
DigitalResourceController
// app/Http/Controllers/DigitalResourceController.php
namespace App\Http\Controllers;
use App\Models\DigitalResource;
use Illuminate\Http\Request;
class DigitalResourceController extends Controller
{
public function index()
{
$digitalResources = DigitalResource::all();
return view('digital_resources.index', compact('digitalResources'));
}
public function create()
{
return view('digital_resources.create');
}
public function store(Request $request)
{
$request->validate([
'Title' => 'required|max:200',
'ResourceType' => 'required|max:50',
'URL' => 'required|url|max:256',
]);
DigitalResource::create($request->all());
return redirect()->route('digital_resources.index')->with('success', 'Digital resource created successfully.');
}
public function show(DigitalResource $digitalResource)
{
return view('digital_resources.show', compact('digitalResource'));
}
public function edit(DigitalResource $digitalResource)
{
return view('digital_resources.edit', compact('digitalResource'));
}
public function update(Request $request, DigitalResource $digitalResource)
{
$request->validate([
'Title' => 'required|max:200',
'ResourceType' => 'required|max:50',
'URL' => 'required|url|max:256',
]);
$digitalResource->update($request->all());
return redirect()->route('digital_resources.index')->with('success', 'Digital resource updated successfully.');
}
public function destroy(DigitalResource $digitalResource)
{
$digitalResource->delete();
return redirect()->route('digital_resources.index')->with('success', 'Digital resource deleted successfully.');
}
}
InterlibraryLoanController
// app/Http/Controllers/InterlibraryLoanController.php
namespace App\Http\Controllers;
use App\Models\InterlibraryLoan;
use Illuminate\Http\Request;
class InterlibraryLoanController extends Controller
{
public function index()
{
$interlibraryLoans = InterlibraryLoan::all();
return view('interlibrary_loans.index', compact('interlibraryLoans'));
}
public function create()
{
return view('interlibrary_loans.create');
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'BookId' => 'required|exists:books,BookId',
'LoanDate' => 'required|date',
'DueDate' => 'required|date',
]);
InterlibraryLoan::create($request->all());
return redirect()->route('interlibrary_loans.index')->with('success', 'Interlibrary loan created successfully.');
}
public function show(InterlibraryLoan $interlibraryLoan)
{
return view('interlibrary_loans.show', compact('interlibraryLoan'));
}
public function edit(InterlibraryLoan $interlibraryLoan)
{
return view('interlibrary_loans.edit', compact('interlibraryLoan'));
}
public function update(Request $request, InterlibraryLoan $interlibraryLoan)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'BookId' => 'required|exists:books,BookId',
'LoanDate' => 'required|date',
'DueDate' => 'required|date',
]);
$interlibraryLoan->update($request->all());
return redirect()->route('interlibrary_loans.index')->with('success', 'Interlibrary loan updated successfully.');
}
public function destroy(InterlibraryLoan $interlibraryLoan)
{
$interlibraryLoan->delete();
return redirect()->route('interlibrary_loans.index')->with('success', 'Interlibrary loan deleted successfully.');
}
}
EventController
// app/Http/Controllers/EventController.php
namespace App\Http\Controllers;
use App\Models\Event;
use Illuminate\Http\Request;
class EventController extends Controller
{
public function index()
{
$events = Event::all();
return view('events.index', compact('events'));
}
public function create()
{
return view('events.create');
}
public function store(Request $request)
{
$request->validate([
'Title' => 'required|max:100',
'Description' => 'nullable',
'EventDate' => 'required|date',
]);
Event::create($request->all());
return redirect()->route('events .index')->with('success', 'Event created successfully.');
}
public function show(Event $event)
{
return view('events.show', compact('event'));
}
public function edit(Event $event)
{
return view('events.edit', compact('event'));
}
public function update(Request $request, Event $event)
{
$request->validate([
'Title' => 'required|max:100',
'Description' => 'nullable',
'EventDate' => 'required|date',
]);
$event->update($request->all());
return redirect()->route('events.index')->with('success', 'Event updated successfully.');
}
public function destroy(Event $event)
{
$event->delete();
return redirect()->route('events.index')->with('success', 'Event deleted successfully.');
}
}
FeedbackController
// app/Http/Controllers/FeedbackController.php
namespace App\Http\Controllers;
use App\Models\Feedback;
use Illuminate\Http\Request;
class FeedbackController extends Controller
{
public function index()
{
$feedbacks = Feedback::all();
return view('feedback.index', compact('feedbacks'));
}
public function create()
{
return view('feedback.create');
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'Comments' => 'nullable',
]);
Feedback::create($request->all());
return redirect()->route('feedback.index')->with('success', 'Feedback created successfully.');
}
public function show(Feedback $feedback)
{
return view('feedback.show', compact('feedback'));
}
public function edit(Feedback $feedback)
{
return view('feedback.edit', compact('feedback'));
}
public function update(Request $request, Feedback $feedback)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'Comments' => 'nullable',
]);
$feedback->update($request->all());
return redirect()->route('feedback.index')->with('success', 'Feedback updated successfully.');
}
public function destroy(Feedback $feedback)
{
$feedback->delete();
return redirect()->route('feedback.index')->with('success', 'Feedback deleted successfully.');
}
}
This completes the implementation of the controllers for each model with complete CRUD operations.
You can now create views for each of these controllers to handle the display and interaction with the data.
Creating View Files for Each Controller
Creating view files for each controller using Bootstrap 5 involves creating a set of Blade templates in Laravel. Below, I will provide example view files for each model's CRUD operations. These views will include the necessary Bootstrap 5 classes for styling.
Step 1: Create View Files
You can create a directory for each model under resources/views/. For example, create directories like users, roles, books, etc. Inside each directory, create the following view files:
index.blade.php - for listing items
create.blade.php - for creating a new item
edit.blade.php - for editing an existing item
show.blade.php - for showing details of an item
Example View Files
User Views
resources/views/users/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Users</h1>
<a href="{{ route('users.create') }}" class="btn btn-primary mb-3">Create User</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Username</th>
<th>Email</th>
<th>Role</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($users as $user)
<tr>
<td>{{ $user->Username }}</td>
<td>{{ $user->Email }}</td>
<td>{{ $user->role->RoleName ?? 'N/A' }}</td>
<td>
<a href="{{ route('users.edit', $user) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('users.destroy', $user) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/users/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create User</h1>
<form action="{{ route('users.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="Username" class="form-label">Username</label>
<input type="text" class="form-control" id="Username" name="Username" required>
</div>
<div class="mb-3">
<label for="PasswordHash" class="form-label">Password</label>
<input type="password" class="form-control" id="PasswordHash" name="PasswordHash" required>
</div>
<div class="mb-3">
<label for="Email" class="form-label">Email</label>
<input type="email" class="form-control" id="Email" name="Email" required>
</div>
<div class="mb-3">
<label for="RoleId" class="form-label">Role</label>
<select class="form-select" id="RoleId" name="RoleId">
<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>
</form>
</div>
@endsection
resources/views/users/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit User</h1>
<form action="{{ route('users.update', $user) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="Username" class="form-label">Username</label>
<input type="text" class="form-control" id="Username" name="Username" value="{{ $user->Username }}" required>
</div>
<div class="mb-3">
<label for="PasswordHash" class="form-label">Password</label>
<input type="password" class="form-control" id="PasswordHash" name="PasswordHash" required>
</div>
<div class="mb-3">
<label for="Email" class="form-label">Email</label>
<input type="email" class="form-control" id="Email" name="Email" value="{{ $user->Email }}" required>
</div>
<div class="mb-3">
<label for="RoleId" class="form-label">Role</label>
<select class="form-select" id="RoleId" name="RoleId">
<option value="">Select Role</option>
@foreach($roles as $role)
<option value="{{ $role->RoleId }}" {{ $user->RoleId == $role->RoleId ? 'selected' : '' }}>{{ $role->RoleName }}</option>
@endforeach
</select>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/users/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>User Details</h1>
<p><strong>Username:</strong> {{ $user->Username }}</p>
<p><strong>Email:</strong> {{ $user->Email }}</p>
<p><strong>Role:</strong> {{ $user->role->RoleName ?? 'N/A' }}</p>
<a href="{{ route('users.index') }}" class="btn btn-secondary">Back to Users</a>
</div>
@endsection
Role Views
resources/views/roles/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Roles</h1>
<a href="{{ route('roles.create') }}" class="btn btn-primary mb-3">Create Role</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<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) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('roles.destroy', $role) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/roles/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Role</h1>
<form action="{{ route('roles.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="RoleName" class="form-label">Role Name</label>
<input type="text" class="form-control" id="RoleName" name="RoleName" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/roles/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Role</h1>
<form action="{{ route('roles.update', $role) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="RoleName" class="form-label">Role Name</label>
<input type="text" class="form-control" id="RoleName" name="RoleName" value="{{ $role->RoleName }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/roles/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Role Details</h1>
<p><strong>Role Name:</strong> {{ $role->RoleName }}</p>
<a href="{{ route('roles.index') }}" class="btn btn-secondary">Back to Roles</a>
</div>
@endsection
Book Views
resources/views/books/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Books</h1>
<a href="{{ route('books.create') }}" class="btn btn-primary mb-3">Create Book</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Title</th>
<th>Author</th>
<th>ISBN</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($books as $book)
<tr>
<td>{{ $book->Title }}</td>
<td>{{ $book->Author }}</td>
<td>{{ $book->ISBN }}</td>
<td>
<a href="{{ route('books.edit', $book) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('books.destroy', $book) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/books/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Book</h1>
<form action="{{ route('books.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" required>
</div>
<div class="mb-3">
<label for="Author" class="form-label">Author</label>
<input type="text" class="form-control" id="Author" name="Author" required>
</div>
<div class="mb-3">
<label for="ISBN" class="form-label">ISBN</label>
<input type="text" class="form-control" id="ISBN" name="ISBN" required>
</div>
<div class="mb-3">
<label for="Publisher" class="form-label">Publisher</label>
<input type="text" class="form-control" id="Publisher" name="Publisher">
</div>
<div class="mb-3">
<label for="PublishedDate" class="form-label">Published Date</label>
<input type="date" class="form-control" id="PublishedDate" name="PublishedDate">
</div>
<div class="mb-3">
<label for="Category" class="form-label">Category</label>
<input type="text" class="form-control" id="Category" name="Category">
</div>
<div class="mb-3">
<label for="CopiesAvailable" class="form-label">Copies Available</label>
<input type="number" class="form-control" id="CopiesAvailable" name="CopiesAvailable" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/books/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Book</h1>
<form action="{{ route('books.update', $book) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" value="{{ $book->Title }}" required>
</div>
<div class="mb-3">
<label for="Author" class="form-label">Author</label>
<input type="text" class="form-control" id="Author" name="Author" value="{{ $book->Author }}" required>
</div>
<div class="mb-3">
<label for="ISBN" class="form-label">ISBN</label>
<input type="text" class="form-control" id="ISBN" name="ISBN" value="{{ $book->ISBN }}" required>
</div>
<div class="mb-3">
<label for="Publisher" class="form-label">Publisher</label>
<input type="text" class="form-control" id="Publisher" name="Publisher" value="{{ $book->Publisher }}">
</div>
<div class="mb-3">
<label for="PublishedDate" class="form-label">Published Date</label>
<input type="date" class="form-control" id="PublishedDate" name="PublishedDate" value="{{ $book->PublishedDate }}">
</div>
<div class="mb-3">
<label for="Category" class="form-label">Category</label>
<input type="text" class="form-control" id="Category" name="Category" value="{{ $book->Category }}">
</div>
<div class="mb-3">
<label for="CopiesAvailable" class="form-label">Copies Available</label>
<input type="number" class="form-control" id="CopiesAvailable" name="CopiesAvailable" value="{{ $book->CopiesAvailable }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/books/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Book Details</h1>
<p><strong>Title:</strong> {{ $book->Title }}</p>
<p><strong>Author:</strong> {{ $book->Author }}</p>
<p><strong>ISBN:</strong> {{ $book->ISBN }}</p>
<p><strong>Publisher:</strong> {{ $book->Publisher }}</p>
<p><strong>Published Date:</strong> {{ $book->PublishedDate }}</p>
<p><strong>Category:</strong> {{ $book->Category }}</p>
<p><strong>Copies Available:</strong> {{ $book->CopiesAvailable }}</p>
<a href="{{ route('books.index') }}" class="btn btn-secondary">Back to Books</a>
</div>
@endsection
Catalog Item Views
resources/views/catalog_items/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Catalog Items</h1>
<a href="{{ route('catalog_items.create') }}" class="btn btn-primary mb-3">Create Catalog Item</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Book</th>
<th>Location</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($catalogItems as $catalogItem)
<tr>
<td>{{ $catalogItem->book->Title }}</td>
<td>{{ $catalogItem->Location }}</td>
<td>{{ $catalogItem->Status }}</td>
<td>
<a href="{{ route('catalog_items.edit', $catalogItem) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('catalog_items.destroy', $catalogItem) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/catalog_items/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Catalog Item</h1>
<form action="{{ route('catalog_items.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="BookId" class="form-label">Book</label>
<select class="form-select" id="BookId" name="BookId" required>
<option value="">Select Book</option>
@foreach($books as $book)
<option value="{{ $book->BookId }}">{{ $book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Location" class="form-label">Location</label>
<input type="text" class="form-control" id="Location" name="Location">
</div>
<div class="mb-3">
<label for="Status" class="form-label">Status</label>
<input type="text" class="form-control" id="Status" name="Status" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/catalog_items/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Catalog Item</h1>
<form action="{{ route('catalog_items.update', $catalogItem) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="BookId" class="form-label">Book</label>
<select class="form-select" id="BookId" name="BookId" required>
<option value="">Select Book</option>
@foreach($books as $book)
<option value="{{ $book->BookId }}" {{ $catalogItem->BookId == $book->BookId ? 'selected' : '' }}>{{ $book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Location" class="form-label">Location</label>
<input type="text" class="form-control" id="Location" name="Location" value="{{ $catalogItem->Location }}">
</div>
<div class="mb-3">
<label for="Status" class="form-label">Status</label>
<input type="text" class="form-control" id="Status" name="Status" value ="{{ $catalogItem->Status }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/catalog_items/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Catalog Item Details</h1>
<p><strong>Book:</strong> {{ $catalogItem->book->Title }}</p>
<p><strong>Location:</strong> {{ $catalogItem->Location }}</p>
<p><strong>Status:</strong> {{ $catalogItem->Status }}</p>
<a href="{{ route('catalog_items.index') }}" class="btn btn-secondary">Back to Catalog Items</a>
</div>
@endsection
Circulation Record Views
resources/views/circulation_records/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Circulation Records</h1>
<a href="{{ route('circulation_records.create') }}" class="btn btn-primary mb-3">Create Circulation Record</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>User</th>
<th>Catalog Item</th>
<th>Checkout Date</th>
<th>Due Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($circulationRecords as $record)
<tr>
<td>{{ $record->user->Username }}</td>
<td>{{ $record->catalogItem->book->Title }}</td>
<td>{{ $record->CheckoutDate }}</td>
<td>{{ $record->DueDate }}</td>
<td>
<a href="{{ route('circulation_records.edit', $record) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('circulation_records.destroy', $record) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/circulation_records/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Circulation Record</h1>
<form action="{{ route('circulation_records.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" 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="CatalogItemId" class="form-label">Catalog Item</label>
<select class="form-select" id="CatalogItemId" name="CatalogItemId" required>
<option value="">Select Catalog Item</option>
@foreach($catalogItems as $catalogItem)
<option value="{{ $catalogItem->CatalogItemId }}">{{ $catalogItem->book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="CheckoutDate" class="form-label">Checkout Date</label>
<input type="date" class="form-control" id="CheckoutDate" name="CheckoutDate" required>
</div>
<div class="mb-3">
<label for="DueDate" class="form-label">Due Date</label>
<input type="date" class="form-control" id="DueDate" name="DueDate" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/circulation_records/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Circulation Record</h1>
<form action="{{ route('circulation_records.update', $circulationRecord) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="User Id" class="form-label"> User </label>
<select class="form-select" id="User Id" name="User Id" required>
<option value="">Select User</option>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $circulationRecord->User Id == $user->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="CatalogItemId" class="form-label">Catalog Item</label>
<select class="form-select" id="CatalogItemId" name="CatalogItemId" required>
<option value="">Select Catalog Item</option>
@foreach($catalogItems as $catalogItem)
<option value="{{ $catalogItem->CatalogItemId }}" {{ $circulationRecord->CatalogItemId == $catalogItem->CatalogItemId ? 'selected' : '' }}>{{ $catalogItem->book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="CheckoutDate" class="form-label">Checkout Date</label>
<input type="date" class="form-control" id="CheckoutDate" name="CheckoutDate" value="{{ $circulationRecord->CheckoutDate }}" required>
</div>
<div class="mb-3">
<label for="DueDate" class="form-label">Due Date</label>
<input type="date" class="form-control" id="DueDate" name="DueDate" value="{{ $circulationRecord->DueDate }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/circulation_records/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Circulation Record Details</h1>
<p><strong>User:</strong> {{ $circulationRecord->user->Username }}</p>
<p><strong>Catalog Item:</strong> {{ $circulationRecord->catalogItem->book->Title }}</p>
<p><strong>Checkout Date:</strong> {{ $circulationRecord->CheckoutDate }}</p>
<p><strong>Due Date:</strong> {{ $circulationRecord->DueDate }}</p>
<a href="{{ route('circulation_records.index') }}" class="btn btn-secondary">Back to Circulation Records</a>
</div>
@endsection
Reservation Views
resources/views/reservations/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Reservations</h1>
<a href="{{ route('reservations.create') }}" class="btn btn-primary mb-3">Create Reservation</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>User</th>
<th>Catalog Item</th>
<th>Reservation Date</th>
<th>Expiration Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($reservations as $reservation)
<tr>
<td>{{ $reservation->user->Username }}</td>
<td>{{ $reservation->catalogItem->book->Title }}</td>
<td>{{ $reservation->ReservationDate }}</td>
<td>{{ $reservation->ExpirationDate }}</td>
<td>
<a href="{{ route('reservations.edit', $reservation) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('reservations.destroy', $reservation) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/reservations/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Reservation</h1>
<form action="{{ route('reservations.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" 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="CatalogItemId" class="form-label">Catalog Item</label>
<select class="form-select" id="CatalogItemId" name="CatalogItemId" required>
<option value="">Select Catalog Item</option>
@foreach($catalogItems as $catalogItem)
<option value="{{ $catalogItem->CatalogItemId }}">{{ $catalogItem->book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="ReservationDate" class="form-label">Reservation Date</label>
<input type="date" class="form-control" id="ReservationDate" name="ReservationDate" required>
</div>
<div class="mb-3">
<label for="ExpirationDate" class="form-label">Expiration Date</label>
<input type="date" class="form-control" id="ExpirationDate" name="ExpirationDate" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/reservations/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Reservation</h1>
<form action="{{ route('reservations.update', $reservation) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" required>
<option value="">Select User</option>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $reservation->User Id == $user->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="CatalogItemId" class="form-label">Catalog Item</label>
<select class="form-select" id="CatalogItemId" name="CatalogItemId" required>
<option value="">Select Catalog Item</option>
@foreach($catalogItems as $catalogItem)
<option value="{{ $catalogItem->CatalogItemId }}" {{ $reservation->CatalogItemId == $catalogItem->CatalogItemId ? 'selected' : '' }}>{{ $catalogItem->book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="ReservationDate" class="form-label">Reservation Date</label>
<input type="date" class="form-control" id="ReservationDate" name="ReservationDate" value="{{ $reservation->ReservationDate }}" required>
</div>
<div class="mb-3">
<label for="ExpirationDate" class="form-label">Expiration Date</label>
<input type="date" class="form-control" id="ExpirationDate" name="ExpirationDate" value="{{ $reservation->ExpirationDate }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/reservations/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Reservation Details</h1>
<p><strong>User:</strong> {{ $reservation->user->Username }}</p>
<p><strong>Catalog Item:</strong> {{ $reservation->catalogItem->book->Title }}</p>
<p><strong>Reservation Date:</strong> {{ $reservation->ReservationDate }}</p>
<p><strong>Expiration Date:</strong> {{ $reservation->ExpirationDate }}</p>
<a href="{{ route('reservations.index') }}" class="btn btn-secondary">Back to Reservations</a>
</div>
@endsection
Inventory Item Views
resources/views/inventory_items/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Inventory Items</h1>
<a href="{{ route('inventory_items.create') }}" class="btn btn-primary mb-3">Create Inventory Item</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Book</th>
< th>Quantity</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($inventoryItems as $inventoryItem)
<tr>
<td>{{ $inventoryItem->book->Title }}</td>
<td>{{ $inventoryItem->Quantity }}</td>
<td>
<a href="{{ route('inventory_items.edit', $inventoryItem) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('inventory_items.destroy', $inventoryItem) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/inventory_items/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Inventory Item</h1>
<form action="{{ route('inventory_items.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="BookId" class="form-label">Book</label>
<select class="form-select" id="BookId" name="BookId" required>
<option value="">Select Book</option>
@foreach($books as $book)
<option value="{{ $book->BookId }}">{{ $book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Quantity" class="form-label">Quantity</label>
<input type="number" class="form-control" id="Quantity" name="Quantity" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/inventory_items/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Inventory Item</h1>
<form action="{{ route('inventory_items.update', $inventoryItem) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="BookId" class="form-label">Book</label>
<select class="form-select" id="BookId" name="BookId" required>
<option value="">Select Book</option>
@foreach($books as $book)
<option value="{{ $book->BookId }}" {{ $inventoryItem->BookId == $book->BookId ? 'selected' : '' }}>{{ $book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Quantity" class="form-label">Quantity</label>
<input type="number" class="form-control" id="Quantity" name="Quantity" value="{{ $inventoryItem->Quantity }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/inventory_items/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Inventory Item Details</h1>
<p><strong>Book:</strong> {{ $inventoryItem->book->Title }}</p>
<p><strong>Quantity:</strong> {{ $inventoryItem->Quantity }}</p>
<a href="{{ route('inventory_items.index') }}" class="btn btn-secondary">Back to Inventory Items</a>
</div>
@endsection
Membership Views
resources/views/memberships/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Memberships</h1>
<a href="{{ route('memberships.create') }}" class="btn btn-primary mb-3">Create Membership</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>User</th>
<th>Membership Type</th>
<th>Start Date</th>
<th>Expiration Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($memberships as $membership)
<tr>
<td>{{ $membership->user->Username }}</td>
<td>{{ $membership->MembershipType }}</td>
<td>{{ $membership->StartDate }}</td>
<td>{{ $membership->Expiration Date }}</td>
<td>
<a href="{{ route('memberships.edit', $membership) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('memberships.destroy', $membership) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/memberships/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Membership</h1>
<form action="{{ route('memberships.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" 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="MembershipType" class="form-label">Membership Type</label>
<input type="text" class="form-control" id="MembershipType" name="MembershipType" required>
</div>
<div class="mb-3">
<label for="StartDate" class="form-label">Start Date</label>
<input type="date" class="form-control" id="StartDate" name="StartDate" required>
</div>
<div class="mb-3">
<label for="ExpirationDate" class="form-label">Expiration Date</label>
<input type="date" class="form-control" id="ExpirationDate" name="ExpirationDate" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/memberships/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Membership</h1>
<form action="{{ route('memberships.update', $membership) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" required>
<option value="">Select User</option>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $membership->User Id == $user->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="MembershipType" class="form-label">Membership Type</label>
<input type="text" class="form-control" id="MembershipType" name="MembershipType" value="{{ $membership->MembershipType }}" required>
</div>
<div class="mb-3">
<label for="StartDate" class="form-label">Start Date</label>
<input type="date" class="form-control" id="StartDate" name="StartDate" value="{{ $membership->StartDate }}" required>
</div>
<div class="mb-3">
<label for="ExpirationDate" class="form-label">Expiration Date</label>
<input type="date" class="form-control" id="ExpirationDate" name="ExpirationDate" value="{{ $membership->ExpirationDate }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/memberships/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Membership Details</h1>
<p><strong>User:</strong> {{ $membership->user->Username }}</p>
<p><strong>Membership Type:</strong> {{ $membership->MembershipType }}</p>
<p><strong>Start Date:</strong> {{ $membership->StartDate }}</p>
<p><strong>Expiration Date:</strong> {{ $membership->ExpirationDate }}</p>
<a href="{{ route('memberships.index') }}" class="btn btn-secondary">Back to Memberships</a>
</div>
@endsection
Digital Resource Views
resources/views/digital_resources/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Digital Resources</h1>
<a href="{{ route('digital_resources.create') }}" class="btn btn-primary mb-3">Create Digital Resource</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Title</th>
<th>Resource Type</th>
<th>URL</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($digitalResources as $resource)
<tr>
<td>{{ $resource->Title }}</td>
<td>{{ $resource->ResourceType }}</td>
<td><a href="{{ $resource->URL }}" target="_blank">{{ $resource->URL }}</a></td>
<td>
<a href="{{ route('digital_resources.edit', $resource) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('digital_resources.destroy', $resource) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/digital_resources/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Digital Resource</h1>
<form action="{{ route('digital_resources.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" required>
</div>
<div class="mb-3">
<label for="ResourceType" class="form-label">Resource Type</label>
<input type="text" class="form-control" id="ResourceType" name="ResourceType" required>
</div>
<div class="mb-3">
<label for="URL" class="form-label">URL</label>
<input type="url" class="form-control" id="URL" name="URL" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/digital_resources/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Digital Resource</h1>
<form action="{{ route('digital_resources.update', $digitalResource) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" value="{{ $digitalResource->Title }}" required>
</div>
<div class="mb-3">
<label for="ResourceType" class="form-label">Resource Type</label>
<input type="text" class="form-control" id="ResourceType" name="ResourceType" value="{{ $digitalResource->ResourceType }}" required>
</div>
<div class="mb-3">
<label for="URL" class="form-label">URL</label>
<input type="url" class="form-control" id="URL" name="URL" value="{{ $digitalResource->URL }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/digital_resources/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Digital Resource Details</h1>
<p><strong>Title:</strong> {{ $digitalResource->Title }}</p>
<p><strong>Resource Type:</strong> {{ $digitalResource->ResourceType }}</p>
<p><strong>URL:</strong> <a href="{{ $digitalResource->URL }}" target="_blank">{{ $digitalResource->URL }}</a></p>
<a href="{{ route('digital_resources.index') }}" class="btn btn-secondary">Back to Digital Resources</a>
</div>
@endsection
Interlibrary Loan Views
resources/views/interlibrary_loans/index.blade.php
blade blade @extends('layouts.app')
@section('content')
<div class="container"> <h1>Interlibrary Loans</h1> <a href="{{ route('interlibrary_loans.create') }}" class="btn btn-primary mb-3">Create Interlibrary Loan</a> @if(session('success')) <div class="alert alert-success">{{ session('success') }}</div> @endif <table class="table"> <thead> <tr> <th>User</th> <th>Book</th> <th>Loan Date</th> <th>Due Date</th> <th>Actions</th> </tr> </thead> <tbody> @foreach($interlibraryLoans as $loan) <tr> <td>{{ $loan->user->Username }}</td> <td>{{ $loan->book->Title }}</td> <td>{{ $loan->LoanDate }}</td> <td>{{ $loan->DueDate }}</td> <td> <a href="{{ route('interlibrary_loans.edit', $loan) }}" class="btn btn-warning">Edit</a> <form action="{{ route('interlibrary_loans.destroy', $loan) }}" method="POST" style="display:inline;"> @csrf @method('DELETE') <button type="submit" class="btn btn-danger">Delete</button> </form> </td> </tr> @endforeach </tbody> </table> </div>
@endsection
resources/views/interlibrary_loans/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Interlibrary Loan</h1>
<form action="{{ route('interlibrary_loans.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" 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="BookId" class="form-label">Book</label>
<select class="form-select" id="BookId" name="BookId" required>
<option value="">Select Book</option>
@foreach($books as $book)
<option value="{{ $book->BookId }}">{{ $book->Title }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="LoanDate" class="form-label">Loan Date</label>
<input type="date" class="form-control" id="LoanDate" name="LoanDate" required>
</div>
<div class="mb-3">
<label for="DueDate" class="form-label">Due Date</label>
<input type="date" class="form-control" id="DueDate" name="DueDate" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/interlibrary_loans/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Interlibrary Loan</h1>
<form action="{{ route('interlibrary_loans.update', $interlibraryLoan) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" required>
<option value="">Select User</option>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $interlibraryLoan->User Id == $user->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="BookId" class="form-label">Book</label>
<select class="form-select" id="BookId" name="BookId" required>
<option value="">Select Book</option>
@foreach($books as $book)
<option value="{{ $book->BookId }}" {{ $interlibraryLoan->BookId == $book->BookId ? 'selected' : '' }}>{{ $book->Title }}</option>
@endforeach </select>
</div>
<div class="mb-3">
<label for="LoanDate" class="form-label">Loan Date</label>
<input type="date" class="form-control" id="LoanDate" name="LoanDate" value="{{ $interlibraryLoan->LoanDate }}" required>
</div>
<div class="mb-3">
<label for="DueDate" class="form-label">Due Date</label>
<input type="date" class="form-control" id="DueDate" name="DueDate" value="{{ $interlibraryLoan->DueDate }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/interlibrary_loans/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Interlibrary Loan Details</h1>
<p><strong>User:</strong> {{ $interlibraryLoan->user->Username }}</p>
<p><strong>Book:</strong> {{ $interlibraryLoan->book->Title }}</p>
<p><strong>Loan Date:</strong> {{ $interlibraryLoan->LoanDate }}</p>
<p><strong>Due Date:</strong> {{ $interlibraryLoan->DueDate }}</p>
<a href="{{ route('interlibrary_loans.index') }}" class="btn btn-secondary">Back to Interlibrary Loans</a>
</div>
@endsection
Event Views
resources/views/events/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Events</h1>
<a href="{{ route('events.create') }}" class="btn btn-primary mb-3">Create Event</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Title</th>
<th>Description</th>
<th>Event Date</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>
<a href="{{ route('events.edit', $event) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('events.destroy', $event) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/events/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Event</h1>
<form action="{{ route('events.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" required>
</div>
<div class="mb-3">
<label for="Description" class="form-label">Description</label>
<textarea class="form-control" id="Description" name="Description"></textarea>
</div>
<div class="mb-3">
<label for="EventDate" class="form-label">Event Date</label>
<input type="date" class="form-control" id="EventDate" name="EventDate" required>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/events/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Event</h1>
<form action="{{ route('events.update', $event) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="Title" class="form-label">Title</label>
<input type="text" class="form-control" id="Title" name="Title" value="{{ $event->Title }}" required>
</div>
<div class="mb-3">
<label for="Description" class="form-label">Description</label>
<textarea class="form-control" id="Description" name="Description">{{ $event->Description }}</textarea>
</div>
<div class="mb-3">
<label for="EventDate" class="form-label">Event Date</label>
<input type="date" class="form-control" id="EventDate" name="EventDate" value="{{ $event->EventDate }}" required>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/events/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Event Details</h1>
<p><strong>Title:</strong> {{ $event->Title }}</p>
<p><strong>Description:</strong> {{ $event->Description }}</p>
<p><strong>Event Date:</strong> {{ $event->EventDate }}</p>
<a href="{{ route('events.index') }}" class="btn btn-secondary">Back to Events</a>
</div>
@endsection
Feedback Views
resources/views/feedback/index.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Feedback</h1>
<a href="{{ route('feedback.create') }}" class="btn btn-primary mb-3">Create Feedback</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>User</th>
<th>Comments</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($feedbacks as $feedback)
<tr>
<td>{{ $feedback->user->Username }}</td>
<td>{{ $feedback->Comments }}</td>
<td>
<a href="{{ route('feedback.edit', $feedback) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('feedback.destroy', $feedback) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
resources/views/feedback/create.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Feedback</h1>
<form action="{{ route('feedback.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" 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="Comments" class="form-label">Comments</label>
<textarea class="form-control" id="Comments" name="Comments"></textarea>
</div>
<button type="submit" class="btn btn-primary">Create</button>
</form>
</div>
@endsection
resources/views/feedback/edit.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Feedback</h1>
<form action="{{ route('feedback.update', $feedback) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="User Id" class="form-label">User </label>
<select class="form-select" id="User Id" name="User Id" required>
<option value="">Select User</option>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $feedback->User Id == $user->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Comments" class="form-label">Comments</label>
<textarea class="form-control" id="Comments" name="Comments">{{ $feedback->Comments }}</textarea>
</div>
<button type="submit" class="btn btn-primary">Update</button>
</form>
</div>
@endsection
resources/views/feedback/show.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Feedback Details</h1>
<p><strong>User:</strong> {{ $feedback->user->Username }}</p>
<p><strong>Comments:</strong> {{ $feedback->Comments }}</p>
<a href="{{ route('feedback.index') }}" class="btn btn-secondary">Back to Feedback</a>
</div>
@endsection
This completes the creation of view files for each controller with Bootstrap 5 styling.
You can now use these views to manage the respective models in your Laravel application.
To create a dashboard page in Laravel
You can create a new view file and a corresponding controller method to handle the data. Here's an example of how you can create a dashboard page that displays consolidated data related to the project:
Dashboard View
Create a new view file called dashboard.blade.php in the resources/views directory:
resources/views/dashboard.blade.php
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Dashboard</h1>
<div class="row">
<div class="col-md-3">
<div class="card">
<div class="card-body">
<h5 class="card-title">Total Users</h5>
<p class="card-text">{{ $totalUsers }}</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card">
<div class="card-body">
<h5 class="card-title">Total Books</h5>
<p class="card-text">{{ $totalBooks }}</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card">
<div class="card-body">
<h5 class="card-title">Total Catalog Items</h5>
<p class="card-text">{{ $totalCatalogItems }}</p>
</div>
</div>
</div>
<div class="col-md-3">
<div class="card">
<div class="card-body">
<h5 class="card-title">Total Circulation Records</h5>
<p class="card-text">{{ $totalCirculationRecords }}</p>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<div class="card">
<div class="card-body">
<h5 class="card-title">Top 5 Books by Circulation</h5>
<ul>
@foreach($topBooks as $book)
<li>{{ $book->Title }} ({{ $book->circulation_count }})</li>
@endforeach
</ul>
</div>
</div>
</div>
<div class="col-md-6">
<div class="card">
<div class="card-body">
<h5 class="card-title">Top 5 Users by Circulation</h5>
<ul>
@foreach($topUsers as $user)
<li>{{ $user->Username }} ({{ $user->circulation_count }})</li>
@endforeach
</ul>
</div>
</div>
</div>
</div>
</div>
@endsection
Dashboard Controller
Create a new controller method in the DashboardController to handle the data for the dashboard page:
// app/Http/Controllers/DashboardController.php
namespace App\Http\Controllers;
use App\Models\Book;
use App\Models\CatalogItem;
use App\Models\CirculationRecord;
use App\Models\User;
use Illuminate\Http\Request;
class DashboardController extends Controller
{
public function index()
{
$totalUsers = User::count();
$totalBooks = Book::count();
$totalCatalogItems = CatalogItem::count();
$totalCirculationRecords = CirculationRecord::count();
$topBooks = Book::withCount('circulationRecords')
->orderBy('circulation_records_count', 'desc')
->take(5)
->get();
$topUsers = User::withCount('circulationRecords')
->orderBy('circulation_records_count', 'desc')
->take(5)
->get();
return view('dashboard', compact('totalUsers', 'totalBooks', 'totalCatalogItems', 'totalCirculationRecords', 'topBooks', 'topUsers'));
}
}
Route
Add a new route to the web.php file to point to the dashboard page:
// routes/web.php
Route::get('/dashboard', [DashboardController::class, 'index'])->name('dashboard');
This will create a dashboard page that displays consolidated data related to the project, including the total number of users, books, catalog items, and circulation records, as well as the top 5 books and users by circulation.
AI 
ASP.NET API 
ASP.NET CLI 
ASP.NET Core 
ASP.NET MVC 
ASP.NET Projects With Source Code 
ASP.NET Web Forms 
ASP.NET Web Pages 
AWS 
Angular 10 
Bash 
Bitcoin 
Blockchain 
C Tutorial 
C# 
CPP 
Chat GPT 
Cheat Sheet 
Cyber Security 
Dart 
Django 
Docker 
Ether.js 
Ethereum 
Flask 
Flask Projects With Source Code 
GEN AI 
Git 
Go Language 
Google Cloud Platform 
GraphQL 
Hardhat 
INI 
JSON 
Java 
JavaScript 
Kotlin 
Kubernetes 
LaTeX 
Laravel 
Laravel 10 E-Commerce Project 
Laravel 11 E-Commerce Project 
Laravel 9 E-Commerce Project 
Laravel 9 React Tutorial 
Laravel E-Commerce Project 
Laravel Home Services Project 
Laravel Projects With Source Code 
Laravel Tutorial Advanced 
Laravel Tutorial Beginners 
Livewire 
Markdown 
Matlab 
Metamask 
Microsoft Azure 
MongoDB Tutorial Advanced 
MongoDB Tutorial Beginners 
MySql Tutorial Advanced 
MySql Tutorial Beginners 
NextJS 
Node JS 
Node JS Projects With Source Code 
PHP Projects With Source Code 
PHP Tutorial Advanced 
PHP Tutorial Beginners 
Project Database Schema 
Python 
React JS 
Ruby 
Rust 
SQL Server Queries 
SQL Server Tutorial Advanced 
SQL Server Tutorial Beginners 
Sass 
Solidity 
Spring Boot 
Truffle 
TypeScript 
VueJS 
Web3.js 
WordPress Tutorial Advanced 
WordPress Tutorial Beginners 
YAML