language php 5.3
frameworks - NONE
database - mysql 5
reference: [login to view URL]
## A - List of functions
#1 "get clientids" function will need to grab the "clientids". use this page with the api key as the username and a blank password and it spits out the listids. The function should return a simple success or FAIL with some debug data.
#2 "get lists" function will need to grab the "lists" available to all of the clientids then we need to grab the lists, potentially in a little loop to get them all check out "Getting subscriber lists" (under clients) to retrieve the listids. The function should return a simple success or FAIL with some debug data.
#3 "add email to list" function will need to add an email to a "list" using the "Adding a subscriber" api function. The input should be clientid, listid, and email address.
#4 "get history" function will need to use the "Getting a subscriber’s history" api function.
#5 "insert history into mysql function" This should do a simple insert into a "history" table that is essentially a simple historical log of all calls made to the API, and all of the returns. One row should contain both the call and the return, and timestamp.
#6 "unsubscribe email" function. use the "Unsubscribing a subscriber" api function. This function should take an email address, and listid as an input and trigger an unsubscribe call.
#7 "retreive all Active subscribers" function. use the "Active subscribers" api function. This function should be a standalone php script which will be run from a cronjob, once a day to update/insert all returned data into two simple mysql tables - "email_subscriber". the customfields can be dropped.
## B - Note about potential local storage of clientid and list data
Depending on how long it takes for the API to return the clientid and lists, we may have to store them locally in mysql. If it takes less than 1 second, we do not need to store them locally. If we have to store them locally, we need one simple php script which will be run in a cronjob to handle this every hour, by inserting them into two simple mysql tables, which will then be used in another function.
## C - front end gui to tie the functions together
## D - front gui function
On page load, it should present several buttons, accross the top, that stay permanently. It should also present a simple list of all of the names of the listid this particular email address is subscribed to according to the "email_subscriber" table.
#1 "add to list" button (show at the top permanently)
This button should present a display of the clientid and lists inside of the div. When you click on one of the lists, it should run the "add email to list" function.
#2 "show history" button (show at the top permanently)
This button should use the "get history" function and present the results inside of the div.
#3 "unsubscribe all" button (show at the top permanently)
This button should use the "unsubscribe email" function, against ALL of the listids and present a simple success of fail inside of the div.
#4 "unsubscribe from XX list" button
This button should use the "unsubscribe email" function, with only that one particular listid and present a simple success or fail inside of the div. It should be located next to each of the list names to which they are subscribed, unless they are not subscribed to any.
Hello, This is Ricky. I can do your project PHP 5.3 & cURL, MySQL 5. About cronjob part, we can do it in server. So I hope we can discuss your project in more detail via chat. Thank you.
29 freelancere byder i gennemsnit $314 på dette job
Hello. I can start work today. Will you provide your host to create the application, or I should have to make it on my development host? --- Thank you. Alexey
Hello, I have checked The requirement and understand that as well. I have created SIMILAR in past. Do you want to see the DEMO ??? Can will send you ?? Thanks.