Personal Project
Inventory Management System – Role-Based, Real-Time, Local Network
A role-based, real-time inventory management system built to streamline material tracking, issuance, and consumption in an industrial environment.








📍 Overview: A role-based, real-time inventory management system hosted on a local network to streamline material tracking, issuance, and consumption. It features separate workflows for store and section users, powerful search tools, and stock visibility controls.
🧰 Key Features:
- Role-Based Access: Full access for store users (add, issue, edit) and limited access for section users (consumption reporting, transfer authorization).
- Material Management: Smart search with autocomplete, add new stock with PO numbers, and issue materials with detailed tracking.
- Stock Control: "Private/Reserved" stock flags to hide sensitive inventory from general view.
- Transaction Auditing: View and filter all transactions by date, type, or area.
🔧 Technical Stack:
- Frontend: HTML, CSS with Bootstrap, JavaScript.
- Backend: PHP.
- Database: MySQL.
- Hosting: IIS on Windows Server.
📚 Key Learnings: Designing complex role-based workflows, implementing dynamic tables with validation, managing partial vs. full stock issuance logic, and building a full material lifecycle tracking system.