Integrate Highcharts Column and Line charts for my Javascript PHP application

Job ID: 33732665

Budget: $30 – $250 USD

I am designing a complex PHP Javascript web application that requires Highcharts for Data visualization.
I need an experienced developer that can develop and integrate Highcharts Column charts to update on a real-time basis on my application. Here is the scenario.
I have 3 database tables that are related:
1. asset_table: Contains all information about the asset tracking information, asset name, last update, last idle.

2. asset_user_table: Contains information that links individual assets to different users with user ID as primary key or IMEI as unique key as the case maybe.

3. asset_data_ime_table: This table contains information specific to each asset imei, it contains the real-time update information sent from each GPS device, the coordinates, parameters and all.

I want to develop these two scenarios with above information:
1. Create a chart that shows Online Assets, Offline Assets, Engine Idle for a duration of 7 Days with a filter parameter to select for 1 month or 1 year chart
2. Freelancer is to do the Highchart Integration, PHP/Mysql codes, Javascript/Jquery code and ensure it is functional and satisfactory to me.
3. I will help freelancer with the PHP flow to get when the assets are online, offline and engine idling.
4. Highchart must fetch through ajax and update on real-time as the data changes, not a static information.

See attached screenshots of database tables and already implemented dummy highcharts