Parse emails and update database via API + PHP

We use a reservation system to manage a car rental business. We receive a lot of email confirmations from several websites, and until now we need to manually add the new customer data and the reservation/booking one by one. We need a PHP code that read the emails from a pop3 account and parse/read the content and add the customer data to the customers table (if customer does not exist). Then add the reservation to the system. The current reservation system provides a clear API that will be used. In case of any failure to add customers or to add the reservations/bookings for any reason, an email must be sent to the appropiate address to inform about the issue for manual addition and later script fixing. The script must be done in PHP and runs via a cron in one of our servers. Must be coded in a strong and clear modular way, with clear functions/procedures and further easy to modify and add new reservation sites. This is the API doc: [login to view URL] Work must be done in 1 week ----- ADDITIONAL INFORMATION FOR CLARIFY -------- Emails come from several websites where final customers book cars (named OTAs) like rentalcars.com. All emails with booking information from same website/OTA have same format. It is necessary to parse the email to obtain the most data as possible: driver name, phone, email, pick up date, drop off date, car type.... It is necessary a table for OTAs: OTA name, email, commission, subject in email, km/day First step is to check if driver exists. If not, must be added. If yes, create the reservation for the client. It seems it is possible to create driver and booking in one shot with /car-rental/reservations/confirm (see API) To create a reservation it is not trivial, since sometimes customer request extras like additional km, or child seats that must be added. May be a table will be needed here to connect text in the email with a extra in the API The requested car model name not always has exact correspondence, We need a table with text file with 2 fields: car model as indicated in the email and car model code in our booking system. For example: "C3 Aircross" and "22" being 22 the car model code in our reservation system. Some times the client cancels the reservation, then we must be able to cancel it (client can remain): /car-rental​/reservations​/{reservation_id}​/cancelled in API. There is a field with OTA reservation code. Then it is necessary to retrieve the reservation_id by searching by the OTA reservation code. If a OTA reservation code is not present, then we must locate the reservation for such client with same dates. When a new OTA appear, must be easy to add a new one, and script must warn via email if unable to process an email due to unknown OTA or unknown format. A lot of emails regarding a reservation are sent, then only the email with specific subject must be processed for each OTA (OTAs send a lot of emails, not only reservations, but we must to process only the email with bookings and with bookings cancelations. We can start with 4 milestones: 1) Setup tables and 1 OTAs and read emails+assign fields to vars inside PHP. 2) Use API to create customers/bookings and cancel bookings 3) Setup the rest of OTAs 4) Final tests Mysql database that can be maintained via phpmyadmin in first version (we will need future improvements, OTA adding...) that will be covered in next project. For example a future improvement will be to send an SMS+email to the customer via smtp and twilio API with some instructions to the customer (arrival instructions, create a form to request data to complete the customer data to avoid loosing time in the office). Now customers come to the office and our employees and they lost time requesting more data that the OTAs do not collect. We can send an SMS/email with a link to a form in our server to fill the customer data that is left blank by the OTA.