Project: Connect MySQL database with ADMINLTE Dashboard.

There are few tables in Database. Table with user accounts, tables with data, etc. If you like, you can make new table for the users. You can make a new table for anything you need except our main TABLE with our data from IoT devices. Now, beside that, we want to use famous AdminLTE3 for our dashboard theme. Get familiar, read documentation and try it out here: [login to view URL] So, we have Devices and Data tables in MySql, and we have a basic Frontend, aka AdminLte3 Dashboard theme. We need somebody to customize the theme, and to connect Data Tables with AdminLte3. You can use PHP, Bootstrap, Laravel etc. Most important, we need documentation for any function that you are making. You can write in form of comments or in PDF/Word. Now, to be more precise, this is exactly what we need in detail: 1. Log-In and Authentication. AdminLTE already have a designed login and registration page. You need to connect it with user data table. You can make user data table based on AdminLte requirements. We also need registration with Facebook and Google. 2. Display Data from our Data Table on AdminLTE graphs. AdminLTE has predefined designs. You can use new one or make if you like, but for us, about design, everything that theme already have it is enough. We need display of 7 different/same (visually) Graph, but separated on Data page: 1. Our Main Data (Long Counter, numbers between 0 and 16 000 000), 2. Temperature, etc. 3. Make Function/Option in Dashboard page for Data Select BY DATE/HOUR. AdminLTE already has calendar, you can use that if you like. Or make you own. Most important thing is: Our database has this main fields: Unique ID, deviceSerialNumber, Counter1, Counter2, Counter3, Counter4, Counter5, Date/time (YYYY-MM-DD HH-MM), Temperature1. For example, for this step you need to make a Calendar/Hour Data Select function, when the user clicks on the calendar, system displays the data in selected Date/Time frame. By Defaults, system displays data from latest descending by date on just ONE serialNumber. In other words, when we want to see data, system display the device with predefined serial number (when User account is opened, in connects the deviceSerialNumber. One User account can have multiple devices on it. ). Every user account must have a page or a list where it can select the device by its unique deviceSerialNumber, and then the system displays the data for that device. After that, user can select the date. 4. You can work on your local machine, or we can make instance on our server for you do to it live. It is all the same for us. Anyway, when you finish on your local machine, YOU HAVE TO upload it on our test server/domain, so that we can test it and work on it. So, if you prefer, we will give you the demo MySql database and you can download AdminLte3 (it is free) and anything you need. You will receive detailed Structure of Dashboard upon accepting the job, but this 4 are main steps. And additional info is in Requirements file.