I have some native php newsletters implementation. I[size="2"]t seems to me this extension is a lucking feature of Yii.[/size]
My plan is first time discussing this topic in the forum. After I create the extension.
There are a few points of design:
- minimal capabilities of handling newsletters
- abstract database layer[list]
- mongodb driver
[*]abstract mail sender and protocol layer
- using phpmailer
- smtp and sendmail
[/list]
Data schema:
// master data of newsletter
newsletters: [
[
name_from:'Admin',
mail_from:'admin@teszt.dev',
subject:'a newsletter example',
content_html:'<b>text</b>',
content_plain:'text',
sent:false,
created:date()
]
]
// email adresses
mails [
[
name_to:'Harrison Ford',
mail_to:'harrison.ford@example.dev',
subscribed:true,
created:date()
]
]
// active queue of newsletters
mails_queue: [
[
name_to:'Harrison Ford',
mail_to:'harrison.ford@example.dev',
id_newsletter:newsletters._id
id_mail:mails_id,
created:date()
]
// archive queue of newsletters
mails_log: [
[
name_to:'Harrison Ford',
mail_to:'harrison.ford@example.dev',
id_mail:mails._id
id_newsletter:newsletters._id
created:mails_queue.created,
sent: true
]
]
I’m waiting he feedback. (suggestions, questions, and everithing…)