Overview
A web application that gives a food business operating in the UAE, KSA, Lebanon and Syria daily control of its stock. Each employee opens a shift by counting opening stock, records every item that leaves (sold to a customer or handed to another employee) and closes the shift with a closing count. Admins manage accounts and monitor items that fall below their minimum level.
The problem
The business needed a simple, reliable record of the stock each shift started with, what left and why, and what remained at close.
What I built
Key features
- 01Daily shift sessions with opening and closing stock counts
- 02Stock removal log by type (customer sale or transfer to an employee), refused when stock is insufficient
- 03Employee dashboard with shift status, number of movements, quantity removed, total value and low-stock items
- 04Admin dashboard for creating and removing accounts and monitoring low-stock items
- 05Separate employee and admin sign-in, with each role restricted to its own pages
Architecture
- Browser
- PHP pages
- MySQL (PDO)
Performance & security
Security
- Passwords hashed with bcrypt, prepared statements and escaped output
- Multi-step stock updates wrapped in database transactions