Complete This Simple: API to MySQL project

***** IMPORTANT BIDDING INFORMATION: This project is to finish the work that another developer already started. You WILL NOT be building this from scratch. It should be a simple project for any developer that knows how to work with, PHP, get/post APIs, and MySQL. The vast majority of the work is already done, you will be coming in to finalize the code, check that it all works properly, install the script on my server, go through the bug fixing/QA process with me until the script is working properly. The only original work you will have to do is create a very simple HTML front end to use during QA for checking the status of the database. Please bid accordingly ****** _____________________________________________________________________________ Here is a description of the overall project so you understand what the script I have does: I use an email platform with an API that enables stats to be read from other applications. This project is to use that API to create a database of various metrics from the email platform over time. The basic database schema is outlined below. The script is designed to fetch data from the email platform via the API at regular intervals. That data is stored in the database and certain data points will need to be related to each other. Additionally the script should calculate some metrics from the raw data provided by the API. The calculations are all very simple (mostly dealing with averages over time). Once these computed stats are derived they should also be stored in the database. It is key to understand that this Database is going to be used in a future project (not included in the scope of this project) to create charts and other visualizations of the data over time. So it is key that all the data be stored in well named and well organized tables for easy access and use in the future. This is one of the key areas where you will be working to optimize the current script as I think the naming and organization of the tables is lacking, particularly the time metrics are not present across all tables. When you bid please send me a pm with the first word being "optimize" to indicate you have read and understood this part of the task. Your task in this project is limited to finishing the script that connects to the API, extracts the data, stores it in the local database, calculates the computed metrics I am looking for, and stores them in the database. The only part that you will need to build from scratch is a front end development task to create simple HTML pages that display the data from the Database for easy debugging and quality assurance. The current code is attached. I will provide you with detailed info on the API once you bid but it is very simple. If you need any further information please do not hesitate to ask detailed questions via PM and I will respond accordingly. *** BONUS: Successful completion of this project on time and on budget will lead to significant amounts of additional work! This project is only phase 1 of a larger project I have planned and I am looking for a partner to move forward with the other phases as soon as this project is done. Consider this an audition and bid accordingly! Thank you for your time, I look forward to answering your questions via PM, and potentially working with you! -Bobby