Project Introduction
The Supply Chain Tracking System is a comprehensive software solution designed to enhance the visibility and efficiency of supply chain operations. This system aims to provide businesses with real-time tracking of goods and materials as they move through the supply chain, from suppliers to manufacturers to distributors and ultimately to customers. With the increasing complexity of global supply chains and the need for transparency, the Supply Chain Tracking System addresses these challenges by offering a user-friendly interface and robust functionalities for all stakeholders involved.
The platform features tools for inventory management, order tracking, and shipment monitoring. Users can easily access information about the status and location of their products, enabling better decision-making and improved operational efficiency. Additionally, the system includes analytics capabilities to identify bottlenecks and optimize supply chain processes. By automating these processes, the Supply Chain Tracking System aims to reduce costs, enhance customer satisfaction, and improve overall supply chain performance.
Project Objectives
- To develop an intuitive interface for users to track and manage supply chain operations easily.
- To implement real-time tracking of goods and materials throughout the supply chain.
- To provide inventory management tools to optimize stock levels and reduce waste.
- To enable order tracking and shipment monitoring for enhanced visibility.
- To facilitate communication and collaboration among suppliers, manufacturers, and distributors.
- To generate reports and analytics on supply chain performance and efficiency.
- To ensure data security and privacy for all user and transaction information.
- To enhance user engagement through features like alerts for delays and inventory thresholds.
Project Modules
User Management Module
- User Registration/Login: Allow users (suppliers, manufacturers, distributors, retailers, and administrators) to create accounts and log in securely.
- Role Management: Differentiate between user roles (e.g., admin, supplier, manufacturer, distributor) with varying permissions and access levels.
- Profile Management: Enable users to manage their profiles, including contact information, company details, and preferences.
Inventory Management Module
- Inventory Tracking: Monitor stock levels of raw materials, work-in-progress, and finished goods across the supply chain.
- Stock Alerts: Set up alerts for low stock levels or expiration dates to prevent stockouts or wastage.
- Inventory Valuation: Calculate the value of inventory using methods like FIFO (First In, First Out) or LIFO (Last In, First Out).
Order Management Module
- Order Creation: Allow users to create and manage purchase orders, sales orders, and work orders.
- Order Tracking: Provide real-time tracking of order status, including processing, shipping, and delivery.
- Order History: Maintain a history of all orders placed, including details such as quantities, prices, and dates.
Supplier Management Module
- Supplier Database: Maintain a database of suppliers, including contact information, product offerings, and performance metrics.
- Supplier Evaluation: Evaluate suppliers based on criteria such as delivery performance, quality, and pricing.
- Supplier Communication: Facilitate communication with suppliers regarding orders, deliveries, and issues.
Logistics and Transportation Module
- Shipment Tracking: Monitor the status and location of shipments in real-time using GPS and RFID technologies.
- Route Optimization: Optimize delivery routes to reduce transportation costs and improve delivery times.
- Carrier Management: Manage relationships with logistics providers and track their performance.
Data Analytics and Reporting Module
- Performance Metrics: Analyze key performance indicators (KPIs) such as order fulfillment rates, inventory turnover, and lead times.
- Custom Reports: Generate reports on various aspects of the supply chain, including inventory levels, order statuses, and supplier performance.
- Forecasting: Use historical data to forecast demand and optimize inventory levels.
Quality Control Module
- Quality Inspections: Implement quality control processes to inspect incoming materials and finished products.
- Defect Tracking: Track defects and issues in products, including root cause analysis and corrective actions.
- Compliance Management: Ensure compliance with industry standards and regulations.
Financial Management Module
- Cost Tracking: Monitor costs associated with procurement, production, and logistics.
- Invoicing and Payments: Manage invoicing and payment processes for suppliers and customers.
- Budgeting and Forecasting: Create budgets and forecasts based on supply chain data.
Security and Access Control Module
- Data Security: Ensure that sensitive supply chain data is stored securely and protected from unauthorized access.
- Access Control: Manage access to different modules and features based on user roles.
Feedback and Support Module
- User Feedback Collection: Allow users to provide feedback on the system and suggest improvements.
- Help Center: Provide FAQs, tutorials, and support documentation to assist users with common issues.
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,
FirstName NVARCHAR(50) NOT NULL,
LastName NVARCHAR(50) NOT NULL,
RoleId INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt 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,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create InventoryItems Table
CREATE TABLE InventoryItems (
InventoryItemId INT PRIMARY KEY IDENTITY(1,1),
ItemName NVARCHAR(100) NOT NULL,
Quantity INT NOT NULL,
ReorderLevel INT NOT NULL,
SupplierId INT NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (SupplierId) REFERENCES Suppliers(SupplierId)
);
-- Create Orders Table
CREATE TABLE Orders (
OrderId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
OrderDate DATETIME NOT NULL,
TotalAmount DECIMAL(18, 2) NOT NULL,
Status NVARCHAR(50) NOT NULL, -- e.g., Pending, Completed, Cancelled
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Suppliers Table
CREATE TABLE Suppliers (
SupplierId INT PRIMARY KEY IDENTITY(1,1),
SupplierName NVARCHAR(100) NOT NULL,
ContactPerson NVARCHAR(100),
Phone NVARCHAR(20),
Email NVARCHAR(100),
Address NVARCHAR(255),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE()
);
-- Create Shipments Table
CREATE TABLE Shipments (
ShipmentId INT PRIMARY KEY IDENTITY(1,1),
OrderId INT NOT NULL,
ShipmentDate DATETIME NOT NULL,
DeliveryDate DATETIME,
Status NVARCHAR(50) NOT NULL, -- e.g., In Transit, Delivered
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (OrderId) REFERENCES Orders(OrderId)
);
-- Create Reports Table
CREATE TABLE Reports (
ReportId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
ReportDate DATETIME NOT NULL,
ReportContent NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create QualityInspections Table
CREATE TABLE QualityInspections (
InspectionId INT PRIMARY KEY IDENTITY(1,1),
ShipmentId INT NOT NULL,
InspectionDate DATETIME NOT NULL,
Status NVARCHAR(50) NOT NULL, -- e.g., Passed, Failed
Comments NVARCHAR(MAX),
CreatedAt DATETIME DEFAULT GETDATE(),
UpdatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (ShipmentId) REFERENCES Shipments(ShipmentId)
);
-- Create CostTracking Table
CREATE TABLE CostTracking (
CostTrackingId INT PRIMARY KEY IDENTITY(1,1),
OrderId INT NOT NULL,
Cost DECIMAL(18, 2) NOT NULL,
CostDate DATETIME NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (OrderId) REFERENCES Orders(OrderId)
);
-- Create Notifications Table
CREATE TABLE Notifications (
NotificationId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
Message NVARCHAR(255) NOT NULL,
IsRead BIT NOT NULL DEFAULT 0,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
-- Create Feedback Table
CREATE TABLE Feedback (
FeedbackId INT PRIMARY KEY IDENTITY(1,1),
UserId INT NOT NULL,
FeedbackContent NVARCHAR(MAX) NOT NULL,
CreatedAt DATETIME DEFAULT GETDATE(),
FOREIGN KEY (User Id) REFERENCES Users(UserId)
);
Explanation of Tables
Users: Stores user information, including their role in the system.
Roles: Defines different roles (e.g., Admin, Manager, Staff) in the system.
InventoryItems: Manages inventory items, including their quantities and associated suppliers.
Orders: Records orders placed by users, including order status and total amount.
Suppliers: Contains information about suppliers, including contact details and address.
Shipments: Tracks shipments related to orders, including shipment and delivery dates.
Reports: Allows users to generate reports related to inventory, orders, and shipments.
QualityInspections: Records quality inspections for shipments, including inspection results and comments.
CostTracking: Monitors costs associated with orders, including cost dates and amounts.
Notifications: Stores notifications for users regarding order updates and other relevant information.
Feedback: Collects user feedback on the Supply Chain Tracking System.
To create the models and migrations for the provided SQL schema in Laravel 11, you can follow these steps.
Below, I will provide the migration files and the corresponding Eloquent model classes for each table.
Step 1: Create Migrations
You can create migrations using the Artisan command. For example, to create a migration for the Users table, you would run:
php artisan make:migration create_users_table
Repeat this for each table. Below are the migration files for each table based on your SQL schema.
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->string('FirstName', 50);
$table->string('LastName', 50);
$table->foreignId('RoleId')->constrained('roles');
$table->timestamps();
});
}
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();
});
}
public function down()
{
Schema::dropIfExists('roles');
}
}
Migration for InventoryItems Table
// database/migrations/2025_02_01_000003_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->string('ItemName', 100);
$table->integer('Quantity');
$table->integer('ReorderLevel');
$table->foreignId('SupplierId')->constrained('suppliers');
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('inventory_items');
}
}
Migration for Orders Table
// database/migrations/2025_02_01_000004_create_orders_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateOrdersTable extends Migration
{
public function up()
{
Schema::create('orders', function (Blueprint $table) {
$table->id('OrderId');
$table->foreignId('User Id')->constrained('users');
$table->dateTime('OrderDate');
$table->decimal('TotalAmount', 18, 2);
$table->string('Status', 50);
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('orders');
}
}
Migration for Suppliers Table
// database/migrations/2025_02_01_000005_create_suppliers_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateSuppliersTable extends Migration
{
public function up()
{
Schema::create('suppliers', function (Blueprint $table) {
$table->id('SupplierId');
$table->string('SupplierName', 100);
$table->string('ContactPerson', 100)->nullable();
$table->string('Phone', 20)->nullable();
$table->string('Email', 100)->nullable();
$table->string('Address', 255)->nullable();
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('suppliers');
}
}
Migration for Shipments Table
// database/migrations/2025_02_01_000006_create_shipments_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateShipmentsTable extends Migration
{
public function up()
{
Schema::create('shipments', function (Blueprint $table) {
$table->id('ShipmentId');
$table->foreignId('OrderId')->constrained('orders');
$table->dateTime('ShipmentDate');
$table->dateTime('DeliveryDate')->nullable();
$table->string('Status', 50);
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('shipments');
}
}
Migration for Reports Table
// 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');
$table->dateTime('ReportDate');
$table->longText('ReportContent')->nullable();
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('reports');
}
}
Migration for QualityInspections Table
// database/migrations/2025_02_01_000008_create_quality_inspections_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateQualityInspectionsTable extends Migration
{
public function up()
{
Schema::create('quality_inspections', function (Blueprint $table) {
$table->id('InspectionId');
$table->foreignId('ShipmentId')->constrained('shipments');
$table->dateTime('InspectionDate');
$table->string('Status', 50);
$table->longText('Comments')->nullable();
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('quality_inspections');
}
}
Migration for CostTracking Table
// database/migrations/2025_02_01_000009_create_cost_tracking_table.php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class CreateCostTrackingTable extends Migration
{
public function up()
{
Schema::create('cost_tracking', function (Blueprint $table) {
$table->id('CostTrackingId');
$table->foreignId('OrderId')->constrained('orders');
$table->decimal('Cost', 18, 2);
$table->dateTime('CostDate');
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('cost_tracking');
}
}
Migration for Notifications Table
// database/migrations/2025_02_01_000010_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');
$table->string('Message', 255);
$table->boolean('IsRead')->default(false);
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('notifications');
}
}
Migration for Feedback Table
// database/migrations/2025_02_01_000011_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');
$table->longText('FeedbackContent');
$table->timestamps();
});
}
public function down()
{
Schema::dropIfExists('feedback');
}
}
Step 2: Create Models
Next, create the corresponding Eloquent models for each table. You can create a model using the Artisan command as well. For example, to create a model for the User table, you would run:
php artisan make:model User
Below are the model classes for each table.
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 $fillable = [
'Username',
'PasswordHash',
'Email',
'FirstName',
'LastName',
'RoleId',
];
public function role()
{
return $this->belongsTo(Role::class, 'RoleId');
}
public function orders()
{
return $this->hasMany(Order::class, 'User Id');
}
public function reports()
{
return $this->hasMany(Report::class, 'User Id');
}
public function notifications()
{
return $this->hasMany(Notification::class, 'User Id');
}
public function feedbacks()
{
return $this->hasMany(Feedback::class, 'User Id');
}
}
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 $fillable = [
'RoleName',
];
public function users()
{
return $this->hasMany(User::class, 'RoleId');
}
}
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 $fillable = [
'ItemName',
'Quantity',
'ReorderLevel',
'SupplierId',
];
public function supplier()
{
return $this->belongsTo(Supplier::class, 'SupplierId');
}
}
Order Model
// app/Models/Order.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Order extends Model
{
use HasFactory;
protected $table = 'orders';
protected $fillable = [
'User Id',
'OrderDate',
'TotalAmount',
'Status',
];
public function user()
{
return $this->belongsTo(User::class, 'User Id');
}
public function shipments()
{
return $this->hasMany(Shipment::class, 'OrderId');
}
public function costTracking()
{
return $this->hasMany(CostTracking::class, 'OrderId');
}
}
Supplier Model
// app/Models/Supplier.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Supplier extends Model
{
use HasFactory;
protected $table = 'suppliers';
protected $fillable = [
'SupplierName',
'ContactPerson',
'Phone',
'Email',
'Address',
];
public function inventoryItems()
{
return $this->hasMany(InventoryItem::class, 'SupplierId');
}
}
Shipment Model
// app/Models/Shipment.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Shipment extends Model
{
use HasFactory;
protected $table = 'shipments';
protected $fillable = [
'OrderId',
'ShipmentDate',
'DeliveryDate',
'Status',
];
public function order()
{
return $this->belongsTo(Order::class, 'OrderId');
}
public function qualityInspections()
{
return $this->hasMany(QualityInspection::class, 'ShipmentId');
}
}
Report Model
// 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 $fillable = [
'User Id',
'ReportDate',
'ReportContent',
];
public function user()
{
return $this->belongsTo(User::class, 'User Id');
}
}
QualityInspection Model
// app/Models/QualityInspection.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class QualityInspection extends Model
{
use HasFactory;
protected $table = 'quality_inspections';
protected $fillable = [
'ShipmentId',
'InspectionDate',
'Status',
'Comments',
];
public function shipment()
{
return $this->belongsTo(Shipment::class, 'ShipmentId');
}
}
CostTracking Model
// app/Models/CostTracking.php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class CostTracking extends Model
{
use HasFactory;
protected $table = 'cost_tracking';
protected $fillable = [
'OrderId',
'Cost',
'CostDate',
];
public function order()
{
return $this->belongsTo(Order::class, 'OrderId');
}
}
Notification Model
// 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 $fillable = [
'User Id',
'Message',
'IsRead',
];
public function user()
{
return $this->belongsTo(User::class, 'User Id');
}
}
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 $fillable = [
'User Id',
'FeedbackContent',
];
public function user()
{
return $this->belongsTo(User::class, 'User Id');
}
}
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 create the tables in your database as defined in the migration files. After running the migrations, you can start using the models to interact with the database in your Laravel application. Make sure to adjust any additional configurations in your .env file for database connections as needed.
To create controllers for each model with complete CRUD operations in Laravel
You can use the Artisan command to generate resource controllers. Each controller will handle the basic CRUD operations: Create, Read, Update, and Delete. Below, I will provide the commands to create the controllers and the basic structure for each controller.
Step 1: Create Resource 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 InventoryItemController --resource
php artisan make:controller OrderController --resource
php artisan make:controller SupplierController --resource
php artisan make:controller ShipmentController --resource
php artisan make:controller ReportController --resource
php artisan make:controller QualityInspectionController --resource
php artisan make:controller CostTrackingController --resource
php artisan make:controller NotificationController --resource
php artisan make:controller FeedbackController --resource
Step 2: Implement CRUD Operations
Below are the basic implementations for each controller. You will need to adjust the views and routes accordingly.
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',
'FirstName' => 'required|max:50',
'LastName' => 'required|max:50',
'RoleId' => 'required|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,
'FirstName' => 'required|max:50',
'LastName' => 'required|max:50',
'RoleId' => 'required|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.');
}
}
InventoryItemController
// app/Http/Controllers/InventoryItemController.php
namespace App\Http\Controllers;
use App\Models\InventoryItem;
use App\Models\Supplier;
use Illuminate\Http\Request;
class InventoryItemController extends Controller
{
public function index()
{
$items = InventoryItem::all();
return view('inventory_items.index', compact('items'));
}
public function create()
{
$suppliers = Supplier::all();
return view('inventory_items.create', compact('suppliers'));
}
public function store(Request $request)
{
$request->validate([
'ItemName' => 'required|max:100',
'Quantity' => 'required|integer',
'ReorderLevel' => 'required|integer',
'SupplierId' => 'required|exists:suppliers,SupplierId',
]);
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)
{
$suppliers = Supplier::all();
return view('inventory_items.edit', compact('inventoryItem', 'suppliers'));
}
public function update(Request $request, InventoryItem $inventoryItem)
{
$request->validate([
'ItemName' => 'required|max:100',
'Quantity' => 'required|integer',
'ReorderLevel' => 'required|integer',
'SupplierId' => 'required|exists:suppliers,SupplierId',
]);
$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.');
}
}
OrderController
// app/Http/Controllers/OrderController.php
namespace App\Http\Controllers;
use App\Models\Order;
use App\Models\User;
use Illuminate\Http\Request;
class OrderController extends Controller
{
public function index()
{
$orders = Order::all();
return view('orders.index', compact('orders'));
}
public function create()
{
$users = User::all();
return view('orders.create', compact('users'));
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'OrderDate' => 'required|date',
'TotalAmount' => 'required|numeric',
'Status' => 'required|max:50',
]);
Order::create($request->all());
return redirect()->route('orders.index')->with('success', 'Order created successfully.');
}
public function show(Order $order)
{
return view('orders.show', compact('order'));
}
public function edit(Order $order)
{
$users = User::all();
return view('orders.edit', compact('order', 'users'));
}
public function update(Request $request, Order $order)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'OrderDate' => 'required|date',
'TotalAmount' => 'required|numeric',
'Status' => 'required|max:50',
]);
$order->update($request->all());
return redirect()->route('orders.index')->with('success', 'Order updated successfully.');
}
public function destroy(Order $order)
{
$order->delete();
return redirect()->route('orders.index')->with('success', 'Order deleted successfully.');
}
}
SupplierController
// app/Http/Controllers/SupplierController.php
namespace App\Http\Controllers;
use App\Models\Supplier;
use Illuminate\Http\Request;
class SupplierController extends Controller
{
public function index()
{
$suppliers = Supplier::all();
return view('suppliers.index', compact('suppliers'));
}
public function create()
{
return view('suppliers.create');
}
public function store(Request $request)
{
$request->validate([
'SupplierName' => 'required|max:100',
'ContactPerson' => 'nullable|max:100',
'Phone' => 'nullable|max:20',
'Email' => 'nullable|email|max:100',
'Address' => 'nullable|max:255',
]);
Supplier::create($request->all());
return redirect()->route('suppliers.index')->with('success', 'Supplier created successfully.');
}
public function show(Supplier $supplier)
{
return view('suppliers.show', compact('supplier'));
}
public function edit(Supplier $supplier)
{
return view('suppliers.edit', compact('supplier'));
}
public function update(Request $request, Supplier $supplier)
{
$request->validate([
'SupplierName' => 'required|max:100',
'ContactPerson' => 'nullable|max:100',
'Phone' => 'nullable|max:20',
'Email' => 'nullable|email|max:100',
'Address' => 'nullable|max:255',
]);
$supplier->update($request->all());
return redirect()->route('suppliers.index')->with('success', 'Supplier updated successfully.');
}
public function destroy(Supplier $supplier)
{
$supplier->delete();
return redirect()->route('suppliers.index')->with('success', 'Supplier deleted successfully.');
}
}
ShipmentController
// app/Http/Controllers/ShipmentController.php
namespace App\Http\Controllers;
use App\Models\Shipment;
use App\Models\Order;
use Illuminate\Http\Request;
class ShipmentController extends Controller
{
public function index()
{
$shipments = Shipment::all();
return view('shipments.index', compact('shipments'));
}
public function create()
{
$orders = Order::all();
return view('shipments.create', compact('orders'));
}
public function store(Request $request)
{
$request->validate([
'OrderId' => 'required|exists:orders,OrderId',
'ShipmentDate' => 'required|date',
'DeliveryDate' => 'nullable|date',
'Status' => 'required|max:50',
]);
Shipment::create($request->all());
return redirect()->route('shipments.index')->with('success', 'Shipment created successfully.');
}
public function show(Shipment $shipment)
{
return view('shipments.show', compact('shipment'));
}
public function edit(Shipment $shipment)
{
$orders = Order::all();
return view('shipments.edit', compact('shipment', 'orders'));
}
public function update(Request $request, Shipment $shipment)
{
$request->validate([
'OrderId' => 'required|exists:orders,OrderId',
'ShipmentDate' => 'required|date',
'DeliveryDate' => 'nullable|date',
'Status' => 'required|max:50',
]);
$shipment->update($request->all());
return redirect()->route('shipments.index')->with('success', 'Shipment updated successfully.');
}
public function destroy(Shipment $shipment)
{
$shipment->delete();
return redirect()->route('shipments.index')->with('success', 'Shipment deleted successfully.');
}
}
ReportController
// app/Http/Controllers/ReportController.php
namespace App\Http\Controllers;
use App\Models\Report;
use App\Models\User;
use Illuminate\Http\Request;
class ReportController extends Controller
{
public function index()
{
$reports = Report::all();
return view('reports.index', compact('reports'));
}
public function create()
{
$users = User::all();
return view('reports.create', compact('users'));
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'ReportDate' => 'required|date',
'ReportContent' => 'nullable',
]);
Report::create($request->all());
return redirect()->route('reports.index')->with('success', 'Report created successfully.');
}
public function show(Report $report)
{
return view('reports.show', compact('report'));
}
public function edit(Report $report)
{
$users = User::all();
return view('reports.edit', compact('report', 'users'));
}
public function update(Request $request, Report $report)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'ReportDate' => 'required|date',
'ReportContent' => 'nullable',
]);
$report->update($request->all());
return redirect()->route('reports.index')->with('success', 'Report updated successfully.');
}
public function destroy(Report $report)
{
$report->delete();
return redirect()->route('reports.index')->with('success', 'Report deleted successfully.');
}
}
QualityInspectionController
// app/Http/Controllers/QualityInspectionController.php
namespace App\Http\Controllers;
use App\Models\QualityInspection;
use App\Models\Shipment;
use Illuminate\Http\Request;
class QualityInspectionController extends Controller
{
public function index()
{
$inspections = QualityInspection::all();
return view('quality_inspections.index', compact('inspections'));
}
public function create()
{
$shipments = Shipment::all();
return view('quality_inspections.create', compact('shipments'));
}
public function store(Request $request)
{
$request->validate([
'ShipmentId' => 'required|exists:shipments,ShipmentId',
'InspectionDate' => 'required|date',
'Status' => 'required|max:50',
'Comments' => 'nullable',
]);
QualityInspection::create($request->all());
return redirect()->route('quality_inspections.index')->with('success', 'Quality inspection created successfully.');
}
public function show(QualityInspection $qualityInspection)
{
return view('quality_inspections.show', compact('qualityInspection'));
}
public function edit(QualityInspection $qualityInspection)
{
$shipments = Shipment::all();
return view('quality_inspections.edit', compact('qualityInspection', 'shipments'));
}
public function update(Request $request, QualityInspection $qualityInspection)
{
$request->validate([
'ShipmentId' => 'required| exists:shipments,ShipmentId',
'InspectionDate' => 'required|date',
'Status' => 'required|max:50',
'Comments' => 'nullable',
]);
$qualityInspection->update($request->all());
return redirect()->route('quality_inspections.index')->with('success', 'Quality inspection updated successfully.');
}
public function destroy(QualityInspection $qualityInspection)
{
$qualityInspection->delete();
return redirect()->route('quality_inspections.index')->with('success', 'Quality inspection deleted successfully.');
}
}
CostTrackingController
// app/Http/Controllers/CostTrackingController.php
namespace App\Http\Controllers;
use App\Models\CostTracking;
use App\Models\Order;
use Illuminate\Http\Request;
class CostTrackingController extends Controller
{
public function index()
{
$costs = CostTracking::all();
return view('cost_tracking.index', compact('costs'));
}
public function create()
{
$orders = Order::all();
return view('cost_tracking.create', compact('orders'));
}
public function store(Request $request)
{
$request->validate([
'OrderId' => 'required|exists:orders,OrderId',
'Cost' => 'required|numeric',
'CostDate' => 'required|date',
]);
CostTracking::create($request->all());
return redirect()->route('cost_tracking.index')->with('success', 'Cost tracking created successfully.');
}
public function show(CostTracking $costTracking)
{
return view('cost_tracking.show', compact('costTracking'));
}
public function edit(CostTracking $costTracking)
{
$orders = Order::all();
return view('cost_tracking.edit', compact('costTracking', 'orders'));
}
public function update(Request $request, CostTracking $costTracking)
{
$request->validate([
'OrderId' => 'required|exists:orders,OrderId',
'Cost' => 'required|numeric',
'CostDate' => 'required|date',
]);
$costTracking->update($request->all());
return redirect()->route('cost_tracking.index')->with('success', 'Cost tracking updated successfully.');
}
public function destroy(CostTracking $costTracking)
{
$costTracking->delete();
return redirect()->route('cost_tracking.index')->with('success', 'Cost tracking deleted successfully.');
}
}
NotificationController
// app/Http/Controllers/NotificationController.php
namespace App\Http\Controllers;
use App\Models\Notification;
use App\Models\User;
use Illuminate\Http\Request;
class NotificationController extends Controller
{
public function index()
{
$notifications = Notification::all();
return view('notifications.index', compact('notifications'));
}
public function create()
{
$users = User::all();
return view('notifications.create', compact('users'));
}
public function store(Request $request)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'Message' => 'required|max:255',
'IsRead' => 'boolean',
]);
Notification::create($request->all());
return redirect()->route('notifications.index')->with('success', 'Notification created successfully.');
}
public function show(Notification $notification)
{
return view('notifications.show', compact('notification'));
}
public function edit(Notification $notification)
{
$users = User::all();
return view('notifications.edit', compact('notification', 'users'));
}
public function update(Request $request, Notification $notification)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'Message' => 'required|max:255',
'IsRead' => 'boolean',
]);
$notification->update($request->all());
return redirect()->route('notifications.index')->with('success', 'Notification updated successfully.');
}
public function destroy(Notification $notification)
{
$notification->delete();
return redirect()->route('notifications.index')->with('success', 'Notification deleted successfully.');
}
}
FeedbackController
// app/Http/Controllers/FeedbackController.php
namespace App\Http\Controllers;
use App\Models\Feedback;
use App\Models\User;
use Illuminate\Http\Request;
class FeedbackController extends Controller
{
public function index()
{
$feedbacks = Feedback::all();
return view('feedback.index', compact('feedbacks'));
}
public function create()
{
$users = User::all();
return view('feedback.create', compact('users'));
}
public function store(Request $request)
{
$request->validate([
'UserId' => 'required|exists:users,UserId',
'FeedbackContent' => 'required',
]);
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)
{
$users = User::all();
return view('feedback.edit', compact('feedback', 'users'));
}
public function update(Request $request, Feedback $feedback)
{
$request->validate([
'User Id' => 'required|exists:users,User Id',
'FeedbackContent' => 'required',
]);
$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.');
}
}
Step 3: Define Routes
You will need to define routes for each of these controllers in your routes/web.php file. Here's an example of how to set up the routes for the User Controller:
use App\Http\Controllers\UserController;
use App\Http\Controllers\RoleController;
use App\Http\Controllers\InventoryItemController;
use App\Http\Controllers\OrderController;
use App\Http\Controllers\SupplierController;
use App\Http\Controllers\ShipmentController;
use App\Http\Controllers\ReportController;
use App\Http\Controllers\QualityInspectionController;
use App\Http\Controllers\CostTrackingController;
use App\Http\Controllers\NotificationController;
use App\Http\Controllers\FeedbackController;
Route::resource('users', UserController::class);
Route::resource('roles', RoleController::class);
Route::resource('inventory_items', InventoryItemController::class);
Route::resource('orders', OrderController::class);
Route::resource('suppliers', SupplierController::class);
Route::resource('shipments', ShipmentController::class);
Route::resource('reports', ReportController::class);
Route::resource('quality_inspections', QualityInspectionController::class);
Route::resource('cost_tracking', CostTrackingController::class);
Route::resource('notifications', NotificationController::class);
Route::resource('feedback', FeedbackController::class);
Step 4: Create Views
You will also need to create the corresponding views for each of the CRUD operations. The views should be placed in the resources/views directory, organized by model. For example, you might have:
resources/views/users/index.blade.php
resources/views/users/create.blade.php
resources/views/users/edit.blade.php
resources/views/users/show.blade.php
Repeat this structure for each model, ensuring that the views correspond to the actions defined in the controllers.
This setup will provide a complete CRUD interface for each model in your Laravel application. You can customize the views and add any additional functionality as needed.
Below are example view files for each controller, designed using Bootstrap 5.
These views will cover the basic CRUD operations: index, create, edit, and show for each model. You can customize them further based on your application's requirements.
User Views
Index View (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>First Name</th>
<th>Last Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($users as $user)
<tr>
<td>{{ $user->Username }}</td>
<td>{{ $user->Email }}</td>
<td>{{ $user->FirstName }}</td>
<td>{{ $user->LastName }}</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>
<a href="{{ route('users.show', $user) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (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="FirstName" class="form-label">First Name</label>
<input type="text" class="form-control" id="FirstName" name="FirstName" required>
</div>
<div class="mb-3">
<label for="LastName" class="form-label">Last Name</label>
<input type="text" class="form-control" id="LastName" name="LastName" required>
</div>
<div class="mb-3">
<label for="RoleId" class="form-label">Role</label>
<select class="form-select" id="RoleId" name="RoleId" required>
@foreach($roles as $role)
<option value="{{ $role->RoleId }}">{{ $role->RoleName }}</option>
@endforeach
</select>
</div>
<button type="submit" class="btn btn-primary">Create User</button>
</form>
</div>
@endsection
Edit View (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="FirstName" class="form-label">First Name</label>
<input type="text" class="form-control" id="FirstName" name="FirstName" value="{{ $user->FirstName }}" required>
</div>
<div class="mb-3">
<label for="LastName" class="form-label">Last Name</label>
<input type="text" class="form-control" id="LastName" name="LastName" value="{{ $user->LastName }}" required>
</div>
<div class="mb-3">
<label for="RoleId" class="form-label">Role</label>
<select class="form-select" id="RoleId" name="RoleId" required>
@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-primary">Update User</button>
</form>
</div>
@endsection
Show View (resources/views/users/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>User Details</h1>
<div class="mb-3">
<strong>Username:</strong> {{ $user->Username }}
</div>
<div class="mb-3">
<strong>Email:</strong> {{ $user->Email }}
</div>
<div class="mb-3">
<strong>First Name:</strong> {{ $user->FirstName }}
</div>
<div class="mb-3">
<strong>Last Name:</strong> {{ $user->LastName }}
</div>
<div class="mb-3">
<strong>Role:</strong> {{ $user->role->RoleName }}
</div>
<a href="{{ route('users.index') }}" class="btn btn-secondary">Back to Users</a>
</div>
@endsection
Role Views
Index View (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>
<a href="{{ route('roles.show', $role) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (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 Role</button>
</form>
</div>
@endsection
Edit View (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 Role</button>
</form>
</div>
@endsection
Show View (resources/views/roles/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Role Details</h1>
<div class="mb-3">
<strong>Role Name:</strong> {{ $role->RoleName }}
</div>
<a href="{{ route('roles.index') }}" class="btn btn-secondary">Back to Roles</a>
</div>
@endsection
Inventory Item Views
Index View (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>Item Name</th>
<th>Quantity</th>
<th>Reorder Level</th>
<th>Supplier</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($items as $item)
<tr>
<td>{{ $item->ItemName }}</td>
<td>{{ $item->Quantity }}</td>
<td>{{ $item->ReorderLevel }}</td>
<td>{{ $item->supplier->SupplierName }}</td>
<td>
<a href="{{ route('inventory_items.edit', $item) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('inventory_items.destroy', $item) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href="{{ route('inventory_items.show', $item) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (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="ItemName" class="form-label">Item Name</label>
<input type="text" class="form-control" id="ItemName" name="ItemName" required>
</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>
<div class="mb-3">
<label for="ReorderLevel" class="form-label">Reorder Level</label>
<input type="number" class="form-control" id="ReorderLevel" name="ReorderLevel" required>
</div>
<div class="mb-3">
<label for="SupplierId" class="form-label">Supplier</label>
<select class="form-select" id="SupplierId" name="SupplierId" required>
@foreach($suppliers as $supplier)
<option value="{{ $supplier->SupplierId }}">{{ $supplier->SupplierName }}</option>
@endforeach
</select>
</div>
<button type="submit" class="btn btn-primary">Create Inventory Item</button>
</form>
</div>
@endsection
Edit View (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="ItemName" class="form-label">Item Name</label>
<input type="text" class="form-control" id="ItemName" name="ItemName" value="{{ $inventoryItem->ItemName }}" required>
</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>
<div class="mb-3">
<label for="ReorderLevel" class="form-label">Reorder Level</label>
<input type="number" class="form-control" id="ReorderLevel" name="ReorderLevel" value="{{ $inventoryItem->ReorderLevel }}" required>
</div>
<div class="mb-3">
<label for="SupplierId" class="form-label">Supplier</label>
<select class="form-select" id="SupplierId" name="SupplierId" required>
@foreach($suppliers as $supplier)
<option value="{{ $supplier->SupplierId }}" {{ $supplier->SupplierId == $inventoryItem->SupplierId ? 'selected' : '' }}>{{ $supplier->SupplierName }}</option>
@endforeach
</select>
</div>
<button type="submit" class="btn btn-primary">Update Inventory Item</button>
</form>
</div>
@endsection
Show View (resources/views/inventory_items/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Inventory Item Details</h1>
<div class="mb-3">
<strong>Item Name:</strong> {{ $inventoryItem->ItemName }}
</div>
<div class="mb-3">
<strong>Quantity:</strong> {{ $inventoryItem->Quantity }}
</div>
<div class="mb-3">
<strong>Reorder Level:</strong> {{ $inventoryItem->ReorderLevel }}
</div>
<div class="mb-3">
<strong>Supplier:</strong> {{ $inventoryItem->supplier->SupplierName }}
</div>
<a href="{{ route('inventory_items.index') }}" class="btn btn-secondary">Back to Inventory Items</a>
</div>
@endsection
Order Views
Index View (resources/views/orders/index.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Orders</h1>
<a href="{{ route('orders.create') }}" class="btn btn-primary mb-3">Create Order</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>User</th>
<th>Order Date</th>
<th>Total Amount</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($orders as $order)
<tr>
<td>{{ $order->user->Username }}</td>
<td>{{ $order->OrderDate }}</td>
<td>{{ $order->TotalAmount }}</td>
<td>{{ $order->Status }}</td>
<td>
<a href="{{ route('orders.edit', $order) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('orders.destroy', $order) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href="{{ route('orders.show', $order) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (resources/views/orders/create.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Order</h1>
<form action="{{ route('orders.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>
@foreach($users as $user)
<option value="{{ $user->User Id }}">{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="OrderDate" class="form-label">Order Date</label>
<input type="date" class="form-control" id="OrderDate" name="OrderDate" required>
</div>
<div class="mb-3">
<label for="TotalAmount" class="form-label">Total Amount</label>
<input type="number" class="form-control" id="TotalAmount" name="TotalAmount" required>
</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 Order</button>
</form>
</div>
@endsection
Edit View (resources/views/orders/edit.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Order</h1>
<form action="{{ route('orders.update', $order) }}" 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>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $user->User Id == $order->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="OrderDate" class="form-label">Order Date</label>
<input type="date" class="form-control" id="OrderDate" name="OrderDate" value="{{ $order->OrderDate }}" required>
</div>
<div class="mb-3">
<label for="TotalAmount" class="form-label">Total Amount</label>
<input type="number" class="form-control" id="TotalAmount" name="TotalAmount" value="{{ $order->TotalAmount }}" required>
</div>
<div class="mb-3">
<label for="Status" class="form-label">Status</label>
<input type="text" class="form-control" id="Status" name="Status" value="{{ $order->Status }}" required>
</div>
<button type="submit" class="btn btn-primary">Update Order</button>
</form>
</div>
@endsection
Show View (resources/views/orders/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Order Details</h1>
<div class="mb-3">
<strong>User:</strong> {{ $order->user->Username }}
</div>
<div class="mb-3">
<strong>Order Date:</strong> {{ $order->OrderDate }}
</div>
<div class="mb-3">
<strong>Total Amount:</strong> {{ $order->TotalAmount }}
</div>
<div class="mb-3">
<strong>Status:</strong> {{ $order->Status }}
</div>
<a href="{{ route('orders.index') }}" class="btn btn-secondary">Back to Orders</a>
</div>
@endsection
Supplier Views
Index View (resources/views/suppliers/index.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Suppliers</h1>
<a href="{{ route('suppliers.create') }}" class="btn btn-primary mb-3">Create Supplier</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Supplier Name</th>
<th>Contact Person</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($suppliers as $supplier)
<tr>
<td>{{ $supplier->SupplierName }}</td>
<td>{{ $supplier->ContactPerson }}</td>
<td>
<a href="{{ route('suppliers.edit', $supplier) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('suppliers.destroy', $supplier) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href="{{ route('suppliers.show', $supplier) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (resources/views/suppliers/create.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Supplier</h1>
<form action="{{ route('suppliers.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="SupplierName" class="form-label">Supplier Name</label>
<input type="text" class="form-control" id="SupplierName" name="SupplierName" required>
</div>
<div class="mb-3">
<label for="ContactPerson" class="form-label">Contact Person</label>
<input type="text" class="form-control" id="ContactPerson" name="ContactPerson">
</div>
<div class="mb-3">
<label for="Phone" class="form-label">Phone</label>
<input type="text" class="form-control" id="Phone" name="Phone">
</div>
<div class="mb-3">
<label for="Email" class="form-label ">Email</label>
<input type="email" class="form-control" id="Email" name="Email">
</div>
<div class="mb-3">
<label for="Address" class="form-label">Address</label>
<input type="text" class="form-control" id="Address" name="Address">
</div>
<button type="submit" class="btn btn-primary">Create Supplier</button>
</form>
</div>
@endsection
Edit View (resources/views/suppliers/edit.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Supplier</h1>
<form action="{{ route('suppliers.update', $supplier) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="SupplierName" class="form-label">Supplier Name</label>
<input type="text" class="form-control" id="SupplierName" name="SupplierName" value="{{ $supplier->SupplierName }}" required>
</div>
<div class="mb-3">
<label for="ContactPerson" class="form-label">Contact Person</label>
<input type="text" class="form-control" id="ContactPerson" name="ContactPerson" value="{{ $supplier->ContactPerson }}">
</div>
<div class="mb-3">
<label for="Phone" class="form-label">Phone</label>
<input type="text" class="form-control" id="Phone" name="Phone" value="{{ $supplier->Phone }}">
</div>
<div class="mb-3">
<label for="Email" class="form-label">Email</label>
<input type="email" class="form-control" id="Email" name="Email" value="{{ $supplier->Email }}">
</div>
<div class="mb-3">
<label for="Address" class="form-label">Address</label>
<input type="text" class="form-control" id="Address" name="Address" value="{{ $supplier->Address }}">
</div>
<button type="submit" class="btn btn-primary">Update Supplier</button>
</form>
</div>
@endsection
Show View (resources/views/suppliers/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Supplier Details</h1>
<div class="mb-3">
<strong>Supplier Name:</strong> {{ $supplier->SupplierName }}
</div>
<div class="mb-3">
<strong>Contact Person:</strong> {{ $supplier->ContactPerson }}
</div>
<div class="mb-3">
<strong>Phone:</strong> {{ $supplier->Phone }}
</div>
<div class="mb-3">
<strong>Email:</strong> {{ $supplier->Email }}
</div>
<div class="mb-3">
<strong>Address:</strong> {{ $supplier->Address }}
</div>
<a href="{{ route('suppliers.index') }}" class="btn btn-secondary">Back to Suppliers</a>
</div>
@endsection
Shipment Views
Index View (resources/views/shipments/index.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Shipments</h1>
<a href="{{ route('shipments.create') }}" class="btn btn-primary mb-3">Create Shipment</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Order</th>
<th>Shipment Date</th>
<th>Delivery Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($shipments as $shipment)
<tr>
<td>{{ $shipment->order->OrderId }}</td>
<td>{{ $shipment->ShipmentDate }}</td>
<td>{{ $shipment->DeliveryDate }}</td>
<td>{{ $shipment->Status }}</td>
<td>
<a href="{{ route('shipments.edit', $shipment) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('shipments.destroy', $shipment) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href ="{{ route('shipments.show', $shipment) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (resources/views/shipments/create.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Shipment</h1>
<form action="{{ route('shipments.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="OrderId" class="form-label">Order</label>
<select class="form-select" id="OrderId" name="OrderId" required>
@foreach($orders as $order)
<option value="{{ $order->OrderId }}">{{ $order->OrderId }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="ShipmentDate" class="form-label">Shipment Date</label>
<input type="date" class="form-control" id="ShipmentDate" name="ShipmentDate" required>
</div>
<div class="mb-3">
<label for="DeliveryDate" class="form-label">Delivery Date</label>
<input type="date" class="form-control" id="DeliveryDate" name="DeliveryDate">
</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 Shipment</button>
</form>
</div>
@endsection
Edit View (resources/views/shipments/edit.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Shipment</h1>
<form action="{{ route('shipments.update', $shipment) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="OrderId" class="form-label">Order</label>
<select class="form-select" id="OrderId" name="OrderId" required>
@foreach($orders as $order)
<option value="{{ $order->OrderId }}" {{ $order->OrderId == $shipment->OrderId ? 'selected' : '' }}>{{ $order->OrderId }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="ShipmentDate" class="form-label">Shipment Date</label>
<input type="date" class="form-control" id="ShipmentDate" name="ShipmentDate" value="{{ $shipment->ShipmentDate }}" required>
</div>
<div class="mb-3">
<label for="DeliveryDate" class="form-label">Delivery Date</label>
<input type="date" class="form-control" id="DeliveryDate" name="DeliveryDate" value="{{ $shipment->DeliveryDate }}">
</div>
<div class="mb-3">
<label for="Status" class="form-label">Status</label>
<input type="text" class="form-control" id="Status" name="Status" value="{{ $shipment->Status }}" required>
</div>
<button type="submit" class="btn btn-primary">Update Shipment</button>
</form>
</div>
@endsection
Show View (resources/views/shipments/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Shipment Details</h1>
<div class="mb-3">
<strong>Order:</strong> {{ $shipment->order->OrderId }}
</div>
<div class="mb-3">
<strong>Shipment Date:</strong> {{ $shipment->ShipmentDate }}
</div>
<div class="mb-3">
<strong>Delivery Date:</strong> {{ $shipment->DeliveryDate }}
</div>
<div class="mb-3">
<strong>Status:</strong> {{ $shipment->Status }}
</div>
<a href="{{ route('shipments.index') }}" class="btn btn-secondary">Back to Shipments</a>
</div>
@endsection
Report Views
Index View (resources/views/reports/index.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Reports</h1>
<a href="{{ route('reports.create') }}" class="btn btn-primary mb-3">Create Report</a>
@ if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>User</th>
<th>Report Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($reports as $report)
<tr>
<td>{{ $report->user->Username }}</td>
<td>{{ $report->ReportDate }}</td>
<td>
<a href="{{ route('reports.edit', $report) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('reports.destroy', $report) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href="{{ route('reports.show', $report) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (resources/views/reports/create.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Report</h1>
<form action="{{ route('reports.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>
@foreach($users as $user)
<option value="{{ $user->User Id }}">{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="ReportDate" class="form-label">Report Date</label>
<input type="date" class="form-control" id="ReportDate" name="ReportDate" required>
</div>
<div class="mb-3">
<label for="ReportContent" class="form-label">Report Content</label>
<textarea class="form-control" id="ReportContent" name="ReportContent"></textarea>
</div>
<button type="submit" class="btn btn-primary">Create Report</button>
</form>
</div>
@endsection
Edit View (resources/views/reports/edit.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Report</h1>
<form action="{{ route('reports.update', $report) }}" 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>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $user->User Id == $report->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="ReportDate" class="form-label">Report Date</label>
<input type="date" class="form-control" id="ReportDate" name="ReportDate" value="{{ $report->ReportDate }}" required>
</div>
<div class="mb-3">
<label for="ReportContent" class="form-label">Report Content</label>
<textarea class="form-control" id="ReportContent" name="ReportContent">{{ $report->ReportContent }}</textarea>
</div>
<button type="submit" class="btn btn-primary">Update Report</button>
</form>
</div>
@endsection
Show View (resources/views/reports/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Report Details</h1>
<div class="mb-3">
<strong>User:</strong> {{ $report->user->Username }}
</div>
<div class="mb-3">
<strong>Report Date:</strong> {{ $report->ReportDate }}
</div>
<div class="mb-3">
<strong>Report Content:</strong> {{ $report->ReportContent }}
</div>
<a href="{{ route('reports.index') }}" class="btn btn-secondary">Back to Reports</a>
</div>
@endsection
Quality Inspection Views
Index View (resources/views/quality_inspections/index.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Quality Inspections</h1>
<a href="{{ route('quality_inspections.create') }}" class="btn btn-primary mb-3">Create Quality Inspection</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Shipment</th>
<th>Inspection Date</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($inspections as $inspection)
<tr>
<td>{{ $inspection->shipment->ShipmentId }}</td>
<td>{{ $inspection->InspectionDate }}</td>
<td>{{ $inspection->Status }}</td>
<td>
<a href="{{ route('quality_inspections.edit', $inspection) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('quality_inspections.destroy', $inspection) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href="{{ route('quality_inspections.show', $inspection) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (resources/views/quality_inspections/create.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Quality Inspection</h1>
<form action="{{ route('quality_inspections.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="ShipmentId" class="form-label">Shipment</label>
<select class="form-select" id="ShipmentId" name="ShipmentId" required>
@foreach($shipments as $shipment)
<option value="{{ $shipment->ShipmentId }}">{{ $shipment->ShipmentId }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="InspectionDate" class="form-label">Inspection Date</label>
<input type="date" class="form-control" id="InspectionDate" name="InspectionDate" required>
</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>
<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 Quality Inspection</button>
</form>
</div>
@endsection
Edit View (resources/views/quality_inspections/edit.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Quality Inspection</h1>
<form action="{{ route('quality_inspections.update', $qualityInspection) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="ShipmentId" class="form-label">Shipment</label>
<select class="form-select" id="ShipmentId" name="ShipmentId" required>
@foreach($shipments as $shipment)
<option value="{{ $shipment->ShipmentId }}" {{ $shipment->ShipmentId == $qualityInspection->ShipmentId ? 'selected' : '' }}>{{ $shipment->ShipmentId }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="InspectionDate" class="form-label">Inspection Date</label>
<input type="date" class="form-control" id="InspectionDate" name="InspectionDate" value="{{ $qualityInspection->InspectionDate }}" required>
</div>
<div class="mb-3">
<label for="Status" class="form-label">Status</label>
<input type="text" class="form-control" id="Status" name="Status" value="{{ $qualityInspection->Status }}" required>
</div>
<div class="mb-3">
<label for="Comments" class="form-label">Comments</label>
<textarea class="form-control" id="Comments" name="Comments">{{ $qualityInspection->Comments }}</textarea>
</div>
<button type="submit" class="btn btn-primary">Update Quality Inspection</button>
</form>
</div>
@endsection
Show View (resources/views/quality_inspections/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Quality Inspection Details</h1>
<div class="mb-3">
<strong>Shipment:</strong> {{ $qualityInspection->shipment->ShipmentId }}
</div>
<div class="mb-3">
<strong>Inspection Date:</strong> {{ $qualityInspection->InspectionDate }}
</div>
<div class="mb-3">
<strong>Status:</strong> {{ $qualityInspection->Status }}
</div>
<div class="mb-3">
<strong>Comments:</strong> {{ $qualityInspection->Comments }}
</div>
<a href="{{ route('quality_inspections.index') }}" class="btn btn-secondary">Back to Quality Inspections</a>
</div>
@endsection
Cost Tracking Views
Index View (resources/views/cost_tracking/index.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Cost Tracking</h1>
<a href="{{ route('cost_tracking.create') }}" class="btn btn-primary mb-3">Create Cost Tracking</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>Order</th>
<th>Cost</th>
<th>Cost Date</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($costs as $cost)
<tr>
<td>{{ $cost->order->OrderId }}</td>
<td>{{ $cost->Cost }}</td>
<td>{{ $cost->CostDate }}</td>
<td>
<a href="{{ route('cost_tracking.edit', $cost) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('cost_tracking.destroy', $cost) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href="{{ route('cost_tracking.show', $cost) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (resources/views/cost_tracking/create.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Cost Tracking</h1>
<form action="{{ route('cost_tracking.store') }}" method="POST">
@csrf
<div class="mb-3">
<label for="OrderId" class="form-label">Order</label>
<select class="form-select" id="OrderId" name="OrderId" required>
@foreach($orders as $order)
<option value="{{ $order->OrderId }}">{{ $order->OrderId }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Cost" class="form-label">Cost</label>
<input type="number" class="form-control" id="Cost" name="Cost" required>
</div>
<div class="mb-3">
<label for="CostDate" class="form-label">Cost Date</label>
<input type="date" class="form-control" id="CostDate" name="CostDate" required>
</div>
<button type="submit" class="btn btn-primary">Create Cost Tracking</button>
</form>
</div>
@endsection
Edit View (resources/views/cost_tracking/edit.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Cost Tracking</h1>
<form action="{{ route('cost_tracking.update', $costTracking) }}" method="POST">
@csrf
@method('PUT')
<div class="mb-3">
<label for="OrderId" class="form-label">Order</label>
<select class="form-select" id="OrderId" name="OrderId" required>
@foreach($orders as $order)
<option value="{{ $order->OrderId }}" {{ $order->OrderId == $costTracking->OrderId ? 'selected' : '' }}>{{ $order->OrderId }}</option>
@endforeach </select>
</div>
<div class="mb-3">
<label for="Cost" class="form-label">Cost</label>
<input type="number" class="form-control" id="Cost" name="Cost" value="{{ $costTracking->Cost }}" required>
</div>
<div class="mb-3">
<label for="CostDate" class="form-label">Cost Date</label>
<input type="date" class="form-control" id="CostDate" name="CostDate" value="{{ $costTracking->CostDate }}" required>
</div>
<button type="submit" class="btn btn-primary">Update Cost Tracking</button>
</form>
</div>
@endsection
Show View (resources/views/cost_tracking/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Cost Tracking Details</h1>
<div class="mb-3">
<strong>Order:</strong> {{ $costTracking->order->OrderId }}
</div>
<div class="mb-3">
<strong>Cost:</strong> {{ $costTracking->Cost }}
</div>
<div class="mb-3">
<strong>Cost Date:</strong> {{ $costTracking->CostDate }}
</div>
<a href="{{ route('cost_tracking.index') }}" class="btn btn-secondary">Back to Cost Tracking</a>
</div>
@endsection
Notification Views
Index View (resources/views/notifications/index.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Notifications</h1>
<a href="{{ route('notifications.create') }}" class="btn btn-primary mb-3">Create Notification</a>
@if(session('success'))
<div class="alert alert-success">{{ session('success') }}</div>
@endif
<table class="table">
<thead>
<tr>
<th>User</th>
<th>Message</th>
<th>Is Read</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($notifications as $notification)
<tr>
<td>{{ $notification->user->Username }}</td>
<td>{{ $notification->Message }}</td>
<td>{{ $notification->IsRead ? 'Yes' : 'No' }}</td>
<td>
<a href="{{ route('notifications.edit', $notification) }}" class="btn btn-warning">Edit</a>
<form action="{{ route('notifications.destroy', $notification) }}" method="POST" style="display:inline;">
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Delete</button>
</form>
<a href="{{ route('notifications.show', $notification) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (resources/views/notifications/create.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Create Notification</h1>
<form action="{{ route('notifications.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>
@foreach($users as $user)
<option value="{{ $user->User Id }}">{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Message" class="form-label">Message</label>
<textarea class="form-control" id="Message" name="Message" required></textarea>
</div>
<div class="mb-3">
<label for="IsRead" class="form-label">Is Read</label>
<select class="form-select" id="IsRead" name="IsRead" required>
<option value="1">Yes</option>
<option value="0">No</option>
</select>
</div>
<button type="submit" class="btn btn-primary">Create Notification</button>
</form>
</div>
@endsection
Edit View (resources/views/notifications/edit.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Edit Notification</h1>
<form action="{{ route('notifications.update', $notification) }}" 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>
@foreach($users as $user)
<option value="{{ $user->User Id }}" {{ $user->User Id == $notification->User Id ? 'selected' : '' }}>{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="Message" class="form-label">Message</label>
<textarea class="form-control" id="Message" name="Message" required>{{ $notification->Message }}</textarea>
</div>
<div class="mb-3">
<label for="IsRead" class="form-label">Is Read</label>
<select class="form-select" id="IsRead" name="IsRead" required>
<option value="1" {{ $notification->IsRead ? 'selected' : '' }}>Yes</option>
<option value="0" {{ !$notification->IsRead ? 'selected' : '' }}>No</option>
</select>
</div>
<button type="submit" class="btn btn-primary">Update Notification</button>
</form>
</div>
@endsection
Show View (resources/views/notifications/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Notification Details</h1>
<div class="mb-3">
<strong>User:</strong> {{ $notification->user->Username }}
</div>
<div class="mb-3">
<strong>Message:</strong> {{ $notification->Message }}
</div>
<div class="mb-3">
<strong>Is Read:</strong> {{ $notification->IsRead ? 'Yes' : 'No' }}
</div>
<a href="{{ route('notifications.index') }}" class="btn btn-secondary">Back to Notifications</a>
</div>
@endsection
Feedback Views
Index View (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>Feedback Content</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
@foreach($feedbacks as $feedback)
<tr>
<td>{{ $feedback->user->Username }}</td>
<td>{{ $feedback->FeedbackContent }}</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>
<a href="{{ route('feedback.show', $feedback) }}" class="btn btn-info">View</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Create View (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>
@foreach($users as $user)
<option value="{{ $user->User Id }}">{{ $user->Username }}</option>
@endforeach
</select>
</div>
<div class="mb-3">
<label for="FeedbackContent" class="form-label">Feedback Content</label>
<textarea class="form-control" id="FeedbackContent" name="FeedbackContent" required></textarea>
</div>
<button type="submit" class="btn btn-primary">Create Feedback</button>
</form>
</div>
@endsection
Edit View (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>
@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="FeedbackContent" class="form-label">Feedback Content</label>
<textarea class="form-control" id="FeedbackContent" name="FeedbackContent" required>{{ $feedback->FeedbackContent }}</textarea>
</div>
<button type="submit" class="btn btn-primary">Update Feedback</button>
</form>
</div>
@endsection
Show View (resources/views/feedback/show.blade.php)
@extends('layouts.app')
@section('content')
<div class="container">
<h1>Feedback Details</h1>
<div class="mb-3">
<strong>User:</strong> {{ $feedback->user->Username }}
</div>
<div class="mb-3">
<strong>Feedback Content:</strong> {{ $feedback->FeedbackContent }}
</div>
<a href="{{ route('feedback.index') }}" class="btn btn-secondary">Back to Feedback</a>
</div>
@endsection
This completes the view files for all controllers, utilizing Bootstrap 5 for styling. Each view is structured to support the CRUD operations for the respective models, ensuring a consistent user interface across the application. You can further customize these views to fit your specific design and functionality needs.
Creating a Layout View File
Creating a layout view file in Laravel allows you to define a common structure for your application's pages, which can include headers, footers, and navigation menus. Below is an example of a layout view file using Bootstrap 5. This layout will be used as a base for all your other views.
Layout View File
Create a new file named app.blade.php in the resources/views/layouts directory:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>@yield('title', 'My 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('/') }}">My Application</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('inventory_items.index') }}">Inventory Items</a>
</li>
<li class="nav-item">
<a class="nav-link" href="{{ route('orders.index') }}">Orders</a>
</li>
<li class="nav-item">
<a class="nav-link" href="{{ route('suppliers.index') }}">Suppliers</a>
</li>
<li class="nav-item">
<a class="nav-link" href="{{ route('shipments.index') }}">Shipments</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('quality_inspections.index') }}">Quality Inspections</a>
</li>
<li class="nav-item">
<a class="nav-link" href="{{ route('cost_tracking.index') }}">Cost Tracking</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('feedback.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') }} My Application. All rights reserved.
</div>
</footer>
<script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.11.6/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha1/dist/js/bootstrap.min.js"></script>
</body>
</html>
Using the Layout in Other Views
To use this layout in your other views, you can extend it at the top of each view file.
@extends('layouts.app')
@section('title', 'User Management')
@section('content')
<!-- Your content here -->
@endsection
This way, all your views will have a consistent layout, and you can easily manage the header, footer, and navigation in one place.
Creating a Dashboard Page
To create a dashboard page in Laravel for displaying consolidated project data, you should start by setting up a route, a controller, and a view. The route will direct users to the dashboard, the controller will fetch the necessary data from your models, and the view will present this data in a user-friendly format.
Consider using libraries like Filament for a user-friendly admin dashboard or integrating Vue.js for interactive elements. You can also explore templates to enhance the visual appeal of your dashboard.
Dashboard Route
First, define a route for the dashboard in your web.php file:
Route::get('/dashboard', [DashboardController::class, 'index'])->name('dashboard');
Dashboard Controller
Next, create a DashboardController to handle the logic for fetching and passing data to the view:
php artisan make:controller DashboardController
In the DashboardController, you can fetch the necessary data:
namespace App\Http\Controllers;
use App\Models\User;
use App\Models\Order;
use App\Models\Product;
use Illuminate\Http\Request;
class DashboardController extends Controller
{
public function index()
{
$totalUsers = User::count();
$totalOrders = Order::count();
$totalProducts = Product::count();
$recentOrders = Order::latest()->take(5)->get();
return view('dashboard.index', compact('totalUsers', 'totalOrders', 'totalProducts', 'recentOrders'));
}
}
Dashboard View
Create a view file for the dashboard at resources/views/dashboard/index.blade.php:
@extends('layouts.app')
@section('title', 'Dashboard')
@section('content')
<div class="container">
<h1 class="mb-4">Dashboard</h1>
<div class="row">
<div class="col-md-4">
<div class="card text-white bg-primary mb-3">
<div class="card-header">Total Users</div>
<div class="card-body">
<h5 class="card-title">{{ $totalUsers }}</h5>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card text-white bg-success mb-3">
<div class="card-header">Total Orders</div>
<div class="card-body">
<h5 class="card-title">{{ $totalOrders }}</h5>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card text-white bg-warning mb-3">
<div class="card-header">Total Products</div>
<div class="card-body">
<h5 class="card-title">{{ $totalProducts }}</h5>
</div>
</div>
</div>
</div>
<h2 class="mt-4">Recent Orders</h2>
<table class="table">
<thead>
<tr>
<th>Order ID</th>
<th>User</th>
<th>Total</th>
<th>Status</th>
<th>Date</th>
</tr>
</thead>
<tbody>
@foreach($recentOrders as $order)
<tr>
<td>{{ $order->id }}</td>
<td>{{ $order->user->name }}</td>
<td>${{ $order->total }}</td>
<td>{{ $order->status }}</td>
<td>{{ $order->created_at->format('d M Y') }}</td>
</tr>
@endforeach
</tbody>
</table>
</div>
@endsection
Explanation of the Dashboard Components
Route: The route directs users to the dashboard page.
Controller: The DashboardController fetches the total number of users, orders, and products, as well as the most recent orders.
View: The view displays the total counts in cards and lists recent orders in a table format.
Final Steps
Ensure you have the necessary models (User , Order, Product) and relationships set up correctly. You can enhance the dashboard further by adding charts or graphs using libraries like Chart.js or integrating Vue.js for a more dynamic experience.
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