Build a mysql server and web application

Task is to create an online server which will regularly receive messages(GPRS/SMS) through remote machines(via TCP/2G). The server should read the messages read and the GPS location of machines, and save the data in mysql database. The server database should also be integrated with a SMS gateway. A web application needs to be created, which can be used by an end user to view reports(based on calculations on data in the mysql database) in form of PDF and XLS. The web application must have integrated Google Maps API with support for layered GIS and trip mapping. The API should be able to show live or past locations of machines as recorded in the database.