📦LogiSync: A Supply Chain Management System

LogiSync is a website designed to manage suppliers, products, and purchase orders efficiently. This system provides different access levels for Admins, Managers, and Guests, ensuring a streamlined and secure workflow.

This project is built using PHP for the backend and MySQL for the database.

Features

• Authentication

  • Signup: Create a new account.
  • Login: Access your account based on your role (Admin, Manager, Guest).

• User Roles

  • Admin: Full CRUD operations on Suppliers, Products, and Purchase Orders
  • Manager: Create and Read operations on Suppliers, Products, and Purchase Orders
  • Guest: View the Dashboard

Database Schema

Supplier	Product	Purchase Order
Column Name Data Type SupplierID INT SupplierName VARCHAR ContactPerson VARCHAR ContactNumber VARCHAR	Column Name Data Type ProductID VARCHAR ProductName VARCHAR SupplierID INT Price DECIMAL Quantity INT	Column Name Data Type OrderID VARCHAR SupplierID INT OrderDate DATE DeliveryDate DATE

Screenshots

Home Page

Login/Signup Page

 

Dashboard

Suppliers Management

Admin View

Manager View

Products Management

Admin View

Manager View

Purchase Orders Management

Admin View

Manager View

Guest View

---

Database Project by Vashti Karmelli V. Camu