/**
* @inheritdoc
*/
public function attributeLabels()
{
$attributeLabels = parent::attributeLabels();
$attributeLabels['mail_template_group_i18n_title'] = Yii::t('kalibao', 'mail_template:mail_template_group_id');
$attributeLabels['mail_template_i18n_object'] = Yii::t('kalibao', 'mail_template_i18n:object');
$attributeLabels['mail_template_i18n_message'] = Yii::t('kalibao', 'mail_template_i18n:message');
return $attributeLabels;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMailTemplate()
{
return $this->hasOne(MailTemplate::className(), ['id' => 'mail_template_id']);
}
/**
* Send an email using a specific mail template
*
* @param int $id mail template ID
* @param string $language i18n ID
* @throws Exception
* @return bool return true if message is correctly sent else false
*/
public function sendMailTemplate($id, $language)
{
$mailMessage = $this->getMailer()->compose();
// get mail template
$mailTemplate = ModelMailTemplate::find()->with(['mailTemplateI18ns' => function ($query) use($language) {
$query->select(['mail_template_id', 'object', 'message'])->onCondition(['mail_template_i18n.i18n_id' => $language]);
}])->where(['id' => $id])->one();
if ($mailTemplate === null) {
throw new Exception('Mail template does not exists');
} elseif (!isset($mailTemplate->mailTemplateI18ns[0])) {
throw new Exception('Translate of mail template does not exists');
}
// get sending roles
$sendingRoles = MailSendingRole::find()->with('person')->where(['mail_template_id' => $mailTemplate->id])->all();
$mailObject = $mailTemplate->mailTemplateI18ns[0]->object;
$mailBody = $mailTemplate->mailTemplateI18ns[0]->message;
// replace static parameters
foreach ($this->staticParams as $param => $value) {
$mailObject = str_replace('{' . $param . '}', $value, $mailObject);
$mailBody = str_replace('{' . $param . '}', $value, $mailBody);
}
if ($mailTemplate->sql_request != '') {
// build sql parameters
$params = empty($this->sqlParams) ? $this->buildSqlParams($mailTemplate->sql_param) : $this->sqlParams;
if (empty($params)) {
throw new Exception('Sql parameters are empty');
}
// execute query
$command = Yii::$app->db->createCommand($mailTemplate->sql_request);
foreach ($params as $param => $value) {
$command->bindParam(':' . $param, $value);
}
$results = $command->queryOne();
if (empty($results)) {
throw new Exception(Yii::t('kalibao', 'mail_template_request_error'));
}
// exception
foreach ($results as $attributeName => $attributeValue) {
$mailObject = str_replace('{' . $attributeName . '}', $attributeValue, $mailObject);
$mailBody = str_replace('{' . $attributeName . '}', $attributeValue, $mailBody);
if ($attributeName === Yii::$app->variable->get('kalibao', 'mail_template_sql_alias_mailto') && $attributeValue != '') {
$this->sending['to'][] = [$attributeValue];
} elseif ($attributeName === Yii::$app->variable->get('kalibao', 'mail_template_sql_alias_mailfrom') && $attributeValue != '') {
$this->sending['from'][0] = $attributeValue;
} elseif ($attributeName === Yii::$app->variable->get('kalibao', 'mail_template_sql_alias_sender') && $attributeValue != '') {
$this->sending['from'][1] = $attributeValue;
}
}
}
if (!empty($this->replyTo)) {
$mailMessage->setReplyTo($this->replyTo[0], isset($this->replyTo[1]) ? $this->replyTo[1] : null);
}
if ($this->parseToExecute) {
$mailBody = self::parseMailFunction($mailBody, $this->classFunction);
}
$mailBodyHtml = '';
if ($mailTemplate->html_mode == 1) {
$mailBodyHtml = $mailBody;
}
// add attachment
foreach ($this->filesPath as $path) {
$mailMessage->attach($path);
}
$mailMessage->setSubject($mailObject);
if ($mailBodyHtml != '') {
$mailMessage->setHtmlBody(utf8_decode($mailBodyHtml));
$mailMessage->setTextBody(strip_tags(html_entity_decode($mailBodyHtml)));
} else {
$mailMessage->setTextBody(utf8_decode($mailBody));
}
$variable = Yii::$app->variable;
foreach ($sendingRoles as $sendingRole) {
switch ($sendingRole->mail_send_role_id) {
case $variable->get('kalibao', 'send_role_id:from'):
$this->sending['from'][0] = $sendingRole->person->email;
break;
case $variable->get('kalibao', 'send_role_id:to'):
$this->sending['to'][] = [$sendingRole->person->email];
break;
case $variable->get('kalibao', 'send_role_id:cc'):
$this->sending['cc'][] = [$sendingRole->person->email];
break;
case $variable->get('kalibao', 'send_role_id:bcc'):
$this->sending['bcc'][] = [$sendingRole->person->email];
break;
}
}
$mailMessage->setFrom($this->sending['from'][0], isset($this->sending['from'][1]) ? $this->sending['from'][1] : null);
if (!empty($this->sending['to'])) {
foreach ($this->sending['to'] as $to) {
$mailMessage->setTo($to[0], isset($to[1]) ? $to[1] : null);
}
}
if (!empty($this->sending['cc'])) {
foreach ($this->sending['cc'] as $cc) {
$mailMessage->setCc($cc[0], isset($cc[1]) ? $cc[1] : null);
}
}
if (!empty($this->sending['bcc'])) {
foreach ($this->sending['bcc'] as $bcc) {
$mailMessage->setBcc($bcc[0], isset($bcc[1]) ? $bcc[1] : null);
}
}
return $mailMessage->Send();
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMailTemplates()
{
return $this->hasMany(MailTemplate::className(), ['mail_template_group_id' => 'id']);
}
