Overview:
I have a lead capture page that collects names, emails, phone numbers, etc. through an Aweber capture form. I have, say 10, clients that want these leads. I want to create a system that will give the leads out evenly to my clients as the leads come in. client #1 gets the first lead; Client #2 gets the second lead; and so on... The system just rotates through my clients.
A bit more specific:
The lead goes to Aweber. Aweber determines if it is a new lead (email) or an old already subscribed lead. If new I an direct to one url and if not I can direct to another. Example: [login to view URL] or [login to view URL] Aweber will also send along in the url the variables of the lead; email, name, etc.
This is just a simple rotation picking system. An email lead is passed from Aweber, with up to 6 variables to one of two php programs and each of the two programs will update a MySql database. A new email will go to one php program and an already subscribed email will go to a different php program. The new email php program will maintain a rotational order of the users and as a new email comes in it will pass that email on to the url of the next in line user, with a new/old variable set to “y”, update the log, and update the pointer to the next in line user. The already subscribed email will go to a php program that checks the database for the user associated with that email, and pass the email and associated variables to that email's user with the new/old variable set to “n”, and update the log file. (An already subscribed email does not trigger the next user in line to be changed.) I need the ability to export and download the log file to a csv file by date range.
I have created a mind map of the logic and database layout. If you feel you have better logic or a better database structure to accomplish this simple task, then go for it. The attachment is only to suggest and clarify..