In regards to our mobile application, we have progressed by creating new pages that can be connected to the data in our database. New items that we have nearly finished creating this month include the pages for forgot password, inventory, orders, and the pop-up message for loading. Currently, we are also working on the pages for the user profile and the blue subsidiary. On the API side, we finished the generator for order IDs and transfer IDs. In addition, we added many simple query operations.
Our label maker did come in, but as the semester is coming to an end, we will not be able to touch this. The goal is for next semester to test out what looks good on labels and what doesn’t. The printer is there for them to use along with an extra roll of XL shipping labels.
On the database side, we have added more data models to more accurately reflect customers, items, packages, suppliers, etc. We have made some progress on the QR code in terms of what we are going to use and what that QR code will contain. An item mapping utility is going to be created to map codes in the format XXX-XX-XXX to an actual item in the warehouses.
Earlier this month, we volunteered at Trusted World for hurricane Harvey disaster relief. We had a great time contributing to an organization that provides for the victims of the hurricane. By volunteering, we gained some insight into Trusted World’s operations. Although disaster relief can be considered quite a bit outside of normal operations, we saw that maybe we could design something that is capable of being used not only for day to day operations, but also for disaster relief.
We have very basic sketches of the system we designed. Essentially, what we have is a fully customized system that uses smart phone cameras to scan items into inventory. Whereas Trusted World’s current system relies heavily on 3rd party proprietary scanners and inventory tracking system, ours relies on free and open-source software (FOSS), for the most part. The advantage of FOSS is little to no cost for development and a large community of developers that provides documentation and resources. The preliminary design of our system is provided below, along with a photo of us volunteering with Trusted World. A few things are missing from the diagram, but we will continue to add paths and objects as we discover them.