Consumables Tracker System - Intro

Intro
Where I work, we issue a lot of toners, keyboards and mice, which works out very expensive.  In order to keep track of what is issued, I created a PHP/MySQL driven tracking system in order that we could keep tabs on what was going where, and charge back accordingly.

This series of posts describes how the tracker system works, and how it was put together.


Tasks
The system had to enable the department to record carrying out the following tasks:

• Issue a toner, keyboard(s) and mouse / mice to rooms, and record this.
• View a list of all stock issued, and mark as charged back.
• Add 'on order' stock so that we can track undelivered stock and predict future stock levels
• View and edit 'in stock' quantities, for stock checking.

Part 1 will follow soon....