We have a client system developed with php, zend 2 and mysql and we need a mailing module to send html emails to my clients database based on different filters.
Some users will have a granted permission to create and send emails to clientes based on some filters.
The users with the permission will enter to a page to create the email (they should be able to use and upload images, tables, text, font and paragraph format, etc. like creating a wordpress new post) user must be able to create directly there and completely the email and the email should be sent as it looks.
After creating and previewing the message to be sent, the user then selects the filters for sending it.
We have the following users: clients, distributors and advisors (so we need option to send email to some or all this kind of users)
distributors and advisors belong to Distributions (so we need to be able to choose if we want to send email to all distributors and advisors or just the ones of one or several distributions, and to select if just distributors or just advisors or both.
Distributions belong to countries, so we need to be able to choose if i want to send the message to all distributions, or select distributions of what countries.
Clients could be teachers, owners or principals (should be able to choose what type of client I want to send the message)
clients belong to schools and schools belong to distributions (should be able to select if i want to send to the schools of one or several distributions)
schools also have state and country (should be able to select if i want to send to schools of a particular location or all locations)
schools have existing products (should be able to select if i want to send the message to schools that have determined existing products)
The module should send the emails in a batch process with maximum 99 destination users per message preferably on CCO
The module should append to all messages an antispam notice with a link to "unsuscribe"
If the user clics on unsuscribe the module should process it and mark it for not sending again mail to that user.
the mail should contain all needed characteristics for not to be considered spam (best practices like having a way to unsuscribe, a valid sender, etc)
All sent messages should be saved on a Blog type page for later viewing.
System admin and sender should be able to delete a saved message from the "message historic" page
Logged in users may consult the "message historic" page but they will only see messages destined to them (according to the above filters).
For example: an advisor of distribuition "X" form Canada, will only see messages destined in general to any advisor, messages destined to anyone in Canada, messages destined to advisors of distribution "X", etc... you get the idea.
The module should be programmed following the standard already used, and should integrate to the already developed system on coding and on visual look and feel.
We will provide you the last snapshot of the developed system, and a script to create the database with sample data for you to implement the module from there.