We have an website that receives 40 quotes on average per day from customers wanting to buy our products. This quotes are sent to our email, and we forward each quote to the closest reseller to the customer.
1: We need an script that will automatically send the quotes that we receive on the website, on the email of the closest reseller. This would be done using Postal code that the customer needs to fill for sending a quote. We would have an sheet for this so Postal code xxx-xxx = Reseller A.
2: To be able to track what resellers are reading the quotes or not, we would send together with the quotes, an LINK "Click here to confirm you read the quote". And we would need to track what quotes were confirmed or not, by each reseller.
3: After 48 hours from the quote being sent to the reseller, we would send an email directly to the client, with a link "Click here to confirm that you was contacted by one of our resellers".
4: I would need to have an report of the tracking status of the quotes. For example: Reseller A, received 100 quotes, Confirmed 60 quotes unconfirmed 40 quotes. Clients from reseller A 30 confirmed contact 30 unconfirmed contact.
We already had started to build this system with an local employ but he does not work with the company anymore. But attached you can check the images of what was done. I need you to either create it all from scratch, or use his script that is on php.