The problem Un-Inventory Manager solves

As students of S.P.I.T., we have seen that it is difficult for a University as a whole to efficiently manage its inventory using traditional pen and paper methods. Hence, to overcome this problem, we designed this inventory maintenance system that simplifies day to day tasks by using the latest technologies such as QR Code Scanning and Google Sheets. We designed this system keeping in mind three different types of users, namely; the admin, the managers(Heads of Departments) and the employees(Lab assistants and other non-teaching staff). The admin is responsible for adding managers and the managers are responsible for adding employees. The employees can scan respective items in the inventory, update their service records, add new service records and even add new items. All the activities that pertain to scanning are stored in particular logs that are helpful for tracking purposes. All the service records of an employee can be exported in the form of a PDF if a manager wants to have a check on the records of the employee in a document format.

Challenges we ran into

The most troublesome bug that we ran into was that the speed of a particular request sent to the database was very high per minute as we wrote the code using a controller which was listening continuously at every instant and sending requests. We solved this by making a function and called it in the controller so that the request was sent only once. Another problem was the PDF Generation of the service records of an employee. We solved this problem by accessing the service records from Firebase by passing his ID. Once the service records were rendered, the list was passed through a PDF creator which outputted the PDF document by displaying it in a PDF Viewer.