Cargo Tracking software

We are a freight forwarding & logistics company. We need to develop an inhouse software to cater for tracking by our end client for cargo visibility. An example is [login to view URL] Example please key in booking number PHX314944500 as an example We are using In house freight system based on MYSQL database and need update of the tracking system using below methods 1) Manual key in from Thailand office 2) Extraction of data from MYSQL database (if necessary only) The look and feel of the tracking system preferred to be graphical (see example of hanjin website) thereafter two rows of data : first row is ESTIMATED timings and dates second row is ACTUAL timings and dates. Estimated timing should be self populated based on a default value otherwise based on port pair (eg Thailand to Singapore: Cargo ready date DD/MM/YYYY , pick up date = DD +4, gate in date DD+ 7, ocean freight days DD +11) Therefore the moment we key in the cargo ready date the other dates on ESTIMATED ROW can be self populated, then thereafter amended by Manually. The figures on the ATA will be filled in Manually or extract from SQL.