Email template functionality with manage content from database

Yii Framework Wiki

Popular Tags

Email template functionality with manage content from database

You are viewing revision #3 of this wiki article.
This is the latest version of this article.
You may want to see the changes made in this revision.
« previous (#2)

Quick view to Admin side ¶

I hadn't specify whole flow as I assume you know yii crud flow well, and Quick understand of my specified admin flow.. :)

I use Mailer Extension for email.

Create table to store email template content as below,

database

Make pre-define entry in database, so admin can edit particular template contant with specific position of replace variables.. Edit page shown as below.

Quick view to Front side ¶

Create template file any where in front side (i.e template/templatecontact) as below,

<table style="width: 100%">
<tr>
		<td>
		<a href="<?php echo $_SERVER['HTTP_HOST']; ?>">
                    <img src="<?php echo $_SERVER['HTTP_HOST']; ?>/img/logo.png"/> <!-- This is site logo image -->
		</a>
		</td>
</tr>
<tr>
	<td>
		<table style="border: solid 2px; border-color: #ADCE97; width: 100%">
	<tr>
		<td>
		<div style="margin: 5px 0px 5px 0px;">
			##CONTENT## <!-- This will be replaced with final $message data -->
		</div>
		</td>
	</tr>
</table>
	</td>
</tr>
</table>

Below code is controller where your template parameters are post (i.e site/contact)

if(isset($_POST['Contact']))
{
    $model->attributes=$_POST['Contact']; // Set this if you save email data OR use direct $_POST data
	$adminEmail = "AdminEmail [AT] xyzcompanyadminemail . com"; //Receiver
	$dbTemplateModel = Template::model()->findByAttributes(array('key'=>'CONTACT-REQ-USER')); // From here you can get template content set by admin CONTACT-REQ-USER is key in db
	$message = $dbTemplateModel->content;
	$message = str_replace("##MESSAGE##", nl2br($model->message), $message); //Replace ##MESSAGE## by user send message
	$message = str_replace("##USERNAME##", $model->name, $message);
	$message = str_replace("##USEREMAIL##", $model->email, $message);
	$emailTemplate = $this->renderPartial('template/templatecontact',array(),true); //Getting email template content
	$message = str_replace("##CONTENT##", $message, $emailTemplate); //Replacing ##CONTENT## in email template by $message data

	$mailer = Yii::createComponent('application.extensions.mailer.EMailer');
	$mailer->IsHTML(true); //HTML format
	$mailer->From = $model->email; //Sender
	$mailer->AddReplyTo($model->email); //Sender
	$mailer->AddAddress($adminEmail); //Receiver
	$mailer->FromName = $model->name;
	$mailer->CharSet = 'UTF-8';
	$mailer->Subject = Yii::t('contact-req', $model->subject);
	$mailer->Body = $message;
	$mailer->Send();

Plz comment for any query or updation.

4 0

12 followers

Viewed: 47 952 times

Version: Unknown (update)

Category: Tutorials

Tags: email, template

Written by: kiran sharma

Last updated by: yugene

Created on: Aug 14, 2013

Last updated: 10 years ago

Update Article

Revisions

View all history

10 years ago by yugene
Yii version is set to 1.1
11 years ago by kiran sharma
code view formatted
11 years ago by kiran sharma

User Contributed Notes 6

#14476

1 0

Neat

Very interesting solution. Thanks for sharing.

trond at Aug 15, 2013, 6:57:57 AM

#14478

0 0

Put send functionality into generic class

I used similar approach
http://radzserg.com/2013/06/06/how-do-i-send-emails-in-my-applications/
But also put that functionality in classes. I.e. the final result should look like this

$emailReset = new \MyApp\email\ResetPassword(array(
    'user' => $userModel,
    'hash' => $hash,
    /* other dynamic data for email */
));
$emailReset->send();

logity at Aug 15, 2013, 1:28:23 PM

#14487

0 0

Generic substitution

I've inverted the substitution which allows any field name in the models being read, thus in the template I can add

{firstname}

first I instatiate the emailTemplate model
$email=emailTemplate::model->find(.....)
//then I load the relevant model, in my case a customer model
$customer=Customer::model()->findByPK($customerID);
//of course, you can always load other models, in this case through a relation
$emails=$customer->emails
//and then I use a function in the emailTemplate model
$email->insertFields($customer);
$email->insertFields($emails);
....

which looks like this

public function insertFields($data) {
            foreach($data as $k=>$field) {
               $j="{".$k."}";
               $this->body=str_replace($j,$field,$this->body);
            }
            return true;
        }

Chris Backhouse at Aug 16, 2013, 2:57:36 PM

#14628

1 0

@kiran sharma

Good work :-)

Rajith R at Aug 30, 2013, 5:58:27 AM

#17765

0 0

suggestion

Hi I have noticed that you can repalce the every varible or I think your way is very long but not bad

$message = $dbTemplateModel->content;
$message = str_replace("##MESSAGE##", nl2br($model->message), $message); //Replace ##MESSAGE## by user send message
$message = str_replace("##USERNAME##", $model->name, $message);
$message = str_replace("##USEREMAIL##", $model->email, $message);
$emailTemplate = $this->renderPartial('template/templatecontact',array(),true); //Getting

Just simple and easy way you can replace the value using key

$message = $dbTemplateModel->content;
$variables=array(
	'##MESSAGE##'=>$model->message,
	'##USERNAME##'=>$model->name,
	'##USEREMAIL##'=>$model->email,
	
);

$final_array = $this->EmailSendArray($message , $variables);//replace the variables
 
 public function EmailSendArray($message,$variables){
        $searchArray=array_keys($variables);
        $replaceArray=array_values($variables);
        return str_replace($searchArray,$replaceArray,$message);
    }

I hope it's help someone,

more details please click here...

Ankit Modi at Jul 21, 2014, 4:37:44 AM

#20040

0 0

good

Great solution, we can use it.
Thanks

rajesh chaurasia at Mar 7, 2017, 9:58:58 AM

Categories

Popular Tags

Recent Comments