RFID Based Equipment Management in PHP and MySQL

RFID Based Equipment Management in PHP and MySQL

The project entitled RFID Based Equipment Management is a capstone project designed and developed in PH and MySQL, which means that the said project will work online if it will be uploaded to a live server (hosting and domain name) and it can also work as a stand-alone or in local area network provided that you will install the necessary software tools such as PHP, MySQL server and Apache. In this case the researchers used uWAMP, it is a software package with PHP, MySQL/MariaDB and Apache web server.

RFID Based Equipment Management View Transaction

The researchers decide to choose this system because the department has requested as to develop a project that will solve their issues on equipment tracking and inventory. It is the reason that we came up with the idea to design an information system that can monitor the whereabouts of the borrowed items and provides a real-time inventory report.

The core features of our project was focused on borrowing, monitoring of borrowed items, report generation such as the inventory report and on top of that we have incorporated the RFID technology for easy tracking and monitoring of items and equipment.

Beneficiaries of the project

Department Head – It is easy for the administrator to search the ongoing and outgoing properties that is already recorded on the system. The department head could use the system to trace the equipment that has been borrowed and track the borrower.

Laboratory Technician – they are the persons in-charge of the cleanliness, repairs and perform hardware and software maintenance. It is also their duty to properly monitor the equipment and the one who performs the inventory of items. With the implementation of the system, they will be able to properly monitor and provide inventory reports.

Property Custodian – Easy for the property custodian to keep and organized all the property records.

Researchers – this will be a challenge for the researchers’ to design, develop and implement an information system.

Future Researchers – the output of this study will serve as a reference for future researchers to enhance and develop a system related to our project.

Literature

Walmart’s Inventory Management System

According to Brittany Parker, (2013) Walmart’s Inventory Management System is used to track all of the items that are kept in a Walmart store using technology. It is an invaluable tool at keeping so many stores running efficiently. By keeping track of their inventory, Walmart has been able to save money maintaining stock and increase sales through the use of collected data. (prezi.com)

An equipment tracking system is a system which traces all the equipment, assets, inventory, and containers. The system also can determine who’s responsible for the borrowed materials. As this system works, your assets are secured when it comes to monitoring. It makes the system more accurate of insuring that the materials that being borrowed are returned.

Administrator / Staff

Login, logout, change password, upload profile picture
Can add, edit, and delete users
RFID scanning
Can view the transaction history of the borrowed and returned equipments
Can add, edit and delete room /venue
Can add, edit, search and delete department
Can add, edit, search and delete section
Can add, edit, search and delete item category
Can add, edit, search and delete item information
Can reserve equipment
Can view reports for reserved equipment
Can view reports for damage equipment
Can view reports for returned equipment
System has an advance reservation system
Can view the overdue borrowed equipment
System has a capable of charging 50 pesos for overdue items
System has a capability of charging 100 pesos for damage Items
System has a notification for overdue and advance reservation

How the system will work

The administrator is the one who will first to access the system to create a user for the laboratory technician, in this case the department head serves as the administrator. After the account creation of laboratory technician, they can now login to the system to encode the list of items and equipment to the system. Record of property details and information will automatically store on the system database. The laboratory technician can viewed the property they recorded to the list of properties and user can also delete, update, or edit the property records as needed. Faculty and students can now borrow an item and such transaction is stored in the system for monitoring purposes, this function is the same with the flow of library system wherein books can be borrowed and returned, but instead of books the equipment and items are being monitored. Most of the equipment has an RFID tags attached to them for scanning purposes. With these features, it will be easy to track the whereabouts of the equipment. Report generation will also be more accurate, easy and fast.

Screenshots of the RFID Based Equipment Management