Then I need to:
- create a page for administrator, redirected by joomla login that can add and remove records from database.
- create a customer page, always redirected from joomla with charts (with threshold panel and export), digitals input status and ability to export in xls and create pdf reports. An idea could be be to use the current datapicker (php) and add this actions for the period selected.
PDF report instead can have the company logo, charts,
maybe something about the values out of range and obviously the table.
Now give an example in xls report then you send it.
for digital inputs if present should display the description, status (for example, a "led" green when on, red when off) and the date and time of the last status change.