HazPro Tools

Quick Prototype of a Tool Tracking SystemUpdated 6 years ago

Status	Item Name	Check Out	Employee	Check In:
IN	Hammer	10:31am	Crosby	5:05pm
IN	Wrench	7:27am	Godwin	6:27pm
IN	Nailgun	8:21am	Sibyl	2:12pm
IN	Screwdriver	10:19am	Daniel	8:54pm
IN	Dolly	8:37am	Lorraine	1:31pm
OUT	Face Mask	8:13am	Dwayne
OUT	Air Filter	9:32am	Bernard
OUT	Drop Screens	10:52am	Chatwin
OUT	Reflector	9:34am	Ambrose
OUT	12 Foot Ladder	10:32am	Baldwin
OUT	8 Foot Ladder	10:18am	Eliza
LOST	Air Compressor	9:27am	Clyde

Add Item Add RFID Add Employee Daily Alert Manual Check In Sort By Priority

DB Tables:

RFIDs:ID, ItemID, Tag
Items:ID, Name
Records:ID, ItemID, CheckOutTS, CheckInTS, EmployeeID
Employee:ID, Name, PhoneNum
Images:ID, TimeStamp

End of Day Email:

EOD Alert Sends an email to show all Items (or just Priority Items) not in the warehouse. Email can be auto sent at a specified time each day. EG: 7:00PM - These Items arenât returned to the warehouse