We are looking for a developer to work with our company on a web application project.
The project will involve developing a lite weight web application to run on relatively low power hardware such as Raspberry Pi.
We have an embedded Linux product which collects production data from industrial machinery and stores that data in a small SQLite database on a small Linux PC. We now require a web application to be hosted on the same hardware to allow users to connect to the device, setup the device and access the data from a web browser.
The web application must be responsive and operate well on PC or tablet.
There will be at most 3 simultaneous users of the web application.
The web application will require the following ....
1. A simple login form with 'username' and 'password'
2. A Management Console.
The management Console will allow the user to ...
Create new users with username and password and add them to database.
Create a simple list of Machine Operators (people using the machines) and store those names in the Operator Table in the database. Also requires ability to edit or delete Machine Operator names
Create a list of Machine Operating States (eg Running, Setting Up, Breakdown etc) and store that list in the States table in the database. Also requires ability to edit or delete State names.
Manage the database, which will simply involve ...
Show the current database Size
Show the timestamp of the oldest record
Delete all records with timestamp older than a set date
If required, we can provide the subcontractor with the the SQL queries to do all the above database manipulation.
3. A page showing live data from our device. This data will be available to the PHP as a shared memory or Piped FIFO. It simply needs reading and diplaying as a we page every few seconds. Maybe AJAX or some similar technology maybe usfull here.
4. A page showing a Tachograph (Speed Time graph) of the last 1000 speed samples taken by our device.
5. A page where the user can create reports.
This page will be the most involved and require a section tree to select from a list of available reports, a start and end date entrybox to select the data range and a fe checkboxes, or radio button for other filters. We will require nicely formatted professional looking reports with tables and charts on this page. The reports should be printable, exportable to excell and preferably export to PDF also.
All necessary SQL queries for the data can be provided. The subcontractor is mainly required to produce the web pages and nice looking reports
At this stage we are looking fo expression of interest in working on this project. There is additionally a follow up project which takes the same concept but will be Linux server based with data being uploaded to a central database, from many devices all around the world. This will be a bigger project and will follow the successful completion of the smaller project detailed here.
Initially we will require ...
Your suggestion for the technology you will use to create this web application.
Your estimated timescale.
Your estimated price for completion of the small project detailed here.
Your hourly rate for ongoing work.
Before commiting to a firm price we will discuss the project further with shortlisted candidates after which you can confirm your estimated price or change your quote accordingly before taking on the work.
This is a genuine opoortunity to join our company as a subcontractor with regular work of this type.
Only candidates who can work and communicate during normal working hours should apply. No evening / weekend subcontractors.