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
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
32 freelancere byder i gennemsnit $433 timen for dette job
Hello I have good experience with highcharts. When I work in your job, Could you provide database? Also I will need php code so that I can run in my side. Please contact me Thank you