Intranet page showing mysql data as charts and tables

Introduction We have a linux machine running LAMP stack. This machine already has an application that automatically populates the MySQL database with data. We require a web page hosted on this machine to display the data in graphs and tables on a single web page This contract is for the design of a web page hosted on said machine to display data from the MySQL database. Database is running but only has a small amount of data. Programmer will also have to populate some test data into database. We prefer HighCharts and the Highcharts JS files are already installed on the machine. Server will not normally be connected to the internet so all content must be locally hosted. Items required on page are as follows. Details of the database tables are at the end of the document. 0) General look and feel -Gloss black theme similar to the ‘[login to view URL]’ home page 1)Place for a company logo TopTop left corner Any image will be fine. 2)Formatted text containing data from the only row in ‘Current Status’ Located Top Top right corner To be automatically refreshed at 30s interval. Formatting of the ‘Actual’ time item so that it is shown Green when it is <= ‘Planned’, otherwise coloured RED. Operator name to be looked up from the ‘operators’ table using the ‘Operator’ integer in the CurrentStatus Table. ‘Status’ text to be looked up from the ‘Status’ table, each state has a different color, also taken from the ‘Status’ table 3)Date/time Picker ‘From’ and ‘to’ values for the queries 3) Pie chart -Located top left (below 1 &2) -Displays collated data from HistStatus (for chosen time period) -One segment for each machine state. -Color, and text as per ‘status’ table, -Data collation might need to be done server side?? 4) Stacked bar chart Located middle middle, -Displays contents of the ‘histstatus’ table as a single stacked bar (for chosen time period) Colored according to ‘status’table 5) Production table -Located bottom middle, -Displays all items from the ‘HistProd’ table within selected time period -Scrollable