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
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

RFID Based Equipment Management Dashboard
RFID Based Equipment Management Dashboard
RFID Based Equipment Management Account List
RFID Based Equipment Management Account List
RFID Based Equipment Management Account Encoding
RFID Based Equipment Management Account Encoding
RFID Based Equipment Management RFID Scanning of Student
RFID Based Equipment Management RFID Scanning of Student
RFID Based Equipment Management Transaction History
RFID Based Equipment Management Transaction History
RFID Based Equipment Management View Transaction
RFID Based Equipment Management View Transaction
RFID Based Equipment Management Room Management
RFID Based Equipment Management Room Management
RFID Based Equipment Management Department Management
RFID Based Equipment Management Department Management
RFID Based Equipment Management Class Section Management
RFID Based Equipment Management Class Section Management
RFID Based Equipment Management Item Category Management
RFID Based Equipment Management Item Category Management
RFID Based Equipment Management Item Bulk Upload
RFID Based Equipment Management Item Bulk Upload
RFID Based Equipment Management Item Encoding
RFID Based Equipment Management Item Encoding
RFID Based Equipment Management Item Management
RFID Based Equipment Management Item Management
RFID Based Equipment Management Damage Item Report
RFID Based Equipment Management Damage Item Report
RFID Based Equipment Management Reserved Item Report
RFID Based Equipment Management Reserved Item Report
RFID Based Equipment Management Returned Item Report
RFID Based Equipment Management Returned Item Report

Complete documentation is available and we can also revised it based on your preferred format.

visit our facebook page for more information.

for the sourcecode and documentation you may contact the developer of the system

Patrick Tandoc Sarmiento
09999637980
https://web.facebook.com/ptsarmiento

Comments

comments

, , , , , , , , , , , , , , , , , , , , ,

Post navigation