I am needing someone to create a website for me to manage some inventory. Our company has equipment that we use on jobs, and I need to track where the equipment currently is and how it performed on that job. For this, I will need a database and also a web frontend.
There are two types of equipment that we use, a cable and a "pod". We own about 200 cables and about 180 pods. Each job requires about 30-80 cables and pods. Every day that our cables and pods are on a job, we create a file that shows statistics such as the temperature, voltage, etc that the cable and pod are using. Then at the end of the job, each cable and each pod is tested and refurbished.
We are needing a couple of web interfaces. First, we need an interface that allows people to to select which pods and which cables are used on a job. After those cables and pods are allocated, every day the user should be able to upload this "[login to view URL]" file. This will happen once per day because things like temperature or voltage can change day to day. CSV format.
Second, we need a page that can show the history and statistics for each cable and pod. For example, I may want to see which cables were exposed to the highest temperatures, or which cable is the oldest cable.
And third, we need a page to track the maintenance of the cables and pods. After every job, the cable is tested and the test results need to be saved. I need the ability to look at the test results and look at the history of the cables and pods.
Looking for an estimate for something like this.