/** Function used to send email
* $module -- current module
* $to_email -- to email address
* $from_name -- currently loggedin user name
* $from_email -- currently loggedin vtiger_users's email id. you can give as '' if you are not in HelpDesk module
* $subject -- subject of the email you want to send
* $contents -- body of the email you want to send
* $cc -- add email ids with comma seperated. - optional
* $bcc -- add email ids with comma seperated. - optional.
* $attachment -- whether we want to attach the currently selected file or all files.[values = current,all] - optional
* $emailid -- id of the email object which will be used to get the vtiger_attachments
*/
function send_mail($module, $to_email, $from_name, $from_email, $subject, $contents, $cc = '', $bcc = '', $attachment = '', $emailid = '', $logo = '')
{
global $adb, $log;
global $root_directory;
global $HELPDESK_SUPPORT_EMAIL_ID, $HELPDESK_SUPPORT_NAME;
$uploaddir = $root_directory . "/test/upload/";
$adb->println("To id => '" . $to_email . "'\nSubject ==>'" . $subject . "'\nContents ==> '" . $contents . "'");
//Get the email id of assigned_to user -- pass the value and name, name must be "user_name" or "id"(field names of vtiger_users vtiger_table)
//$to_email = getUserEmailId('id',$assigned_user_id);
//if module is HelpDesk then from_email will come based on support email id
if ($from_email == '') {
//if from email is not defined, then use the useremailid as the from address
$from_email = getUserEmailId('user_name', $from_name);
}
//if the newly defined from email field is set, then use this email address as the from address
//and use the username as the reply-to address
$query = "select * from vtiger_systems where server_type=?";
$params = array('email');
$result = $adb->pquery($query, $params);
$from_email_field = $adb->query_result($result, 0, 'from_email_field');
if (isUserInitiated()) {
$replyToEmail = $from_email;
} else {
$replyToEmail = $from_email_field;
}
if (isset($from_email_field) && $from_email_field != '') {
//setting from _email to the defined email address in the outgoing server configuration
$from_email = $from_email_field;
}
if ($module != "Calendar") {
$contents = addSignature($contents, $from_name);
}
$mail = new PHPMailer();
setMailerProperties($mail, $subject, $contents, $from_email, $from_name, trim($to_email, ","), $attachment, $emailid, $module, $logo);
setCCAddress($mail, 'cc', $cc);
setCCAddress($mail, 'bcc', $bcc);
if (!empty($replyToEmail)) {
$mail->AddReplyTo($replyToEmail);
}
$mail->ConfirmReadingTo = $mail->From;
//MSL
// vtmailscanner customization: If Support Reply to is defined use it.
global $HELPDESK_SUPPORT_EMAIL_REPLY_ID;
if ($HELPDESK_SUPPORT_EMAIL_REPLY_ID && $HELPDESK_SUPPORT_EMAIL_ID != $HELPDESK_SUPPORT_EMAIL_REPLY_ID) {
$mail->AddReplyTo($HELPDESK_SUPPORT_EMAIL_REPLY_ID);
}
// END
// Fix: Return immediately if Outgoing server not configured
if (empty($mail->Host)) {
return 0;
}
// END
$mail_status = MailSend($mail);
if ($mail_status != 1) {
$mail_error = getMailError($mail, $mail_status, $mailto);
} else {
$mail_error = $mail_status;
}
return $mail_error;
}
/** Function used to send email
* $module -- current module
* $to_email -- to email address
* $from_name -- currently loggedin user name
* $from_email -- currently loggedin vtiger_users's email id. you can give as '' if you are not in HelpDesk module
* $subject -- subject of the email you want to send
* $contents -- body of the email you want to send
* $cc -- add email ids with comma seperated. - optional
* $bcc -- add email ids with comma seperated. - optional.
* $attachment -- whether we want to attach the currently selected file or all vtiger_files.[values = current,all] - optional
* $emailid -- id of the email object which will be used to get the vtiger_attachments
*/
function send_mail($module, $to_email, $from_name, $from_email, $subject, $contents, $cc = '', $bcc = '', $attachment = '', $emailid = '', $logo = '')
{
global $adb, $log;
global $root_directory;
global $HELPDESK_SUPPORT_EMAIL_ID, $HELPDESK_SUPPORT_NAME;
$uploaddir = $root_directory . "/test/upload/";
$adb->println("To id => '" . $to_email . "'\nSubject ==>'" . $subject . "'\nContents ==> '" . $contents . "'");
//Get the email id of assigned_to user -- pass the value and name, name must be "user_name" or "id"(field names of vtiger_users vtiger_table)
//$to_email = getUserEmailId('id',$assigned_user_id);
//if module is HelpDesk then from_email will come based on support email id
if ($from_email == '') {
//$module != 'HelpDesk')
$from_email = getUserEmailId('user_name', $from_name);
}
if ($module != "Calendar") {
$contents = addSignature($contents, $from_name);
}
$mail = new PHPMailer();
setMailerProperties($mail, $subject, $contents, $from_email, $from_name, trim($to_email, ","), $attachment, $emailid, $module, $logo);
setCCAddress($mail, 'cc', $cc);
setCCAddress($mail, 'bcc', $bcc);
// vtmailscanner customization: If Support Reply to is defined use it.
global $HELPDESK_SUPPORT_EMAIL_REPLY_ID;
if ($HELPDESK_SUPPORT_EMAIL_REPLY_ID && $HELPDESK_SUPPORT_EMAIL_ID != $HELPDESK_SUPPORT_EMAIL_REPLY_ID) {
$mail->AddReplyTo($HELPDESK_SUPPORT_EMAIL_REPLY_ID);
}
// END
// Fix: Return immediately if Outgoing server not configured
if (empty($mail->Host)) {
return 0;
}
// END
$mail_status = MailSend($mail);
if ($mail_status != 1) {
$mail_error = getMailError($mail, $mail_status, $mailto);
} else {
$mail_error = $mail_status;
}
return $mail_error;
}
/** Function used to send email
* $module -- current module
* $to_email -- to email address
* $from_name -- currently loggedin user name
* $from_email -- currently loggedin users's email id. you can give as '' if you are not in HelpDesk module
* $subject -- subject of the email you want to send
* $contents -- body of the email you want to send
* $cc -- add email ids with comma seperated. - optional
* $bcc -- add email ids with comma seperated. - optional.
* $attachment -- whether we want to attach the currently selected file or all files.[values = current,all] - optional
* $emailid -- id of the email object which will be used to get the vtiger_attachments
*/
function send_mail($module, $to_email, $from_name, $from_email, $subject, $contents, $cc = '', $bcc = '', $attachment = '', $emailid = '', $logo = '', $replyto = '')
{
global $adb, $log, $root_directory, $HELPDESK_SUPPORT_EMAIL_ID, $HELPDESK_SUPPORT_NAME;
$uploaddir = $root_directory . "/test/upload/";
$adb->println("To id => '" . $to_email . "'\nSubject ==>'" . $subject . "'\nContents ==> '" . $contents . "'");
$femail = '';
if (substr($from_email, 0, 8) == 'FROM:::>') {
$femail = substr($from_email, 8);
$from_email = '';
}
if (empty($from_name) and !empty($from_email)) {
$sql = "select user_name from vtiger_users where status='Active' and (email1=? or email2=? or secondaryemail=?)";
$result = $adb->pquery($sql, array($from_email, $from_email, $from_email));
if ($result and $adb->num_rows($result) > 0) {
$from_name = $adb->query_result($result, 0, 0);
}
}
//if module is HelpDesk then from_email will come based on support email id
if ($from_email == '') {
//if from email is not defined, then use the useremailid as the from address
$from_email = getUserEmailId('user_name', $from_name);
}
if (empty($from_email)) {
$from_email = $HELPDESK_SUPPORT_EMAIL_ID;
}
//if the newly defined from email field is set, then use this email address as the from address
//and use the username as the reply-to address
$query = "select * from vtiger_systems where server_type=?";
$params = array('email');
$result = $adb->pquery($query, $params);
$from_email_field = $adb->query_result($result, 0, 'from_email_field');
if (empty($replyto)) {
if (isUserInitiated()) {
global $current_user;
$reply_to_secondary = GlobalVariable::getVariable('Users_ReplyTo_SecondEmail', 0, $module, $current_user->id);
if ($reply_to_secondary == 1) {
$sql = "select secondaryemail from vtiger_users where id=?";
$result = $adb->pquery($sql, array($current_user->id));
$second_email = '';
if ($result and $adb->num_rows($result) > 0) {
$second_email = $adb->query_result($result, 0, 'secondaryemail');
}
}
if (!empty($second_email)) {
$replyToEmail = $second_email;
} else {
$replyToEmail = $from_email;
}
} else {
$replyToEmail = $from_email_field;
}
} else {
$replyToEmail = $replyto;
}
if (isset($from_email_field) && $from_email_field != '') {
//setting from _email to the defined email address in the outgoing server configuration
$from_email = $from_email_field;
}
if ($femail != '') {
$from_email = $femail;
}
if ($module != "Calendar") {
$contents = addSignature($contents, $from_name);
}
$mail = new PHPMailer();
setMailerProperties($mail, $subject, $contents, $from_email, $from_name, trim($to_email, ","), $attachment, $emailid, $module, $logo);
setCCAddress($mail, 'cc', $cc);
setCCAddress($mail, 'bcc', $bcc);
if (!empty($replyToEmail)) {
$mail->AddReplyTo($replyToEmail);
}
// vtmailscanner customization: If Support Reply to is defined use it.
global $HELPDESK_SUPPORT_EMAIL_REPLY_ID;
if ($HELPDESK_SUPPORT_EMAIL_REPLY_ID && $HELPDESK_SUPPORT_EMAIL_ID != $HELPDESK_SUPPORT_EMAIL_REPLY_ID) {
$mail->AddReplyTo($HELPDESK_SUPPORT_EMAIL_REPLY_ID);
}
// END
// Fix: Return immediately if Outgoing server not configured
if (empty($mail->Host)) {
return 0;
}
$mail_status = MailSend($mail);
if ($mail_status != 1) {
$mail_error = getMailError($mail, $mail_status, $mailto);
} else {
$mail_error = $mail_status;
}
return $mail_error;
}
/** Function used to send email
* $module -- current module
* $to_email -- to email address
* $from_name -- currently loggedin user name
* $from_email -- currently loggedin vtiger_users's email id. you can give as '' if you are not in HelpDesk module
* $subject -- subject of the email you want to send
* $contents -- body of the email you want to send
* $cc -- add email ids with comma seperated. - optional
* $bcc -- add email ids with comma seperated. - optional.
* $attachment -- whether we want to attach the currently selected file or all vtiger_files.[values = current,all] - optional
* $emailid -- id of the email object which will be used to get the vtiger_attachments
*/
function send_mail($module, $to_email, $from_name, $from_email, $subject, $contents, $cc = '', $bcc = '', $attachment = '', $emailid = '', $logo = '', $useGivenFromEmailAddress = false, $attachmentSrc = array())
{
$adb = PearDatabase::getInstance();
$log = vglobal('log');
$root_directory = vglobal('root_directory');
global $HELPDESK_SUPPORT_EMAIL_ID, $HELPDESK_SUPPORT_NAME;
$uploaddir = $root_directory . "/cache/upload/";
$adb->println("To id => '" . $to_email . "'\nSubject ==>'" . $subject . "'\nContents ==> '" . $contents . "'");
//Get the email id of assigned_to user -- pass the value and name, name must be "user_name" or "id"(field names of vtiger_users vtiger_table)
//$to_email = getUserEmailId('id',$assigned_user_id);
//if module is HelpDesk then from_email will come based on support email id
if ($from_email == '') {
//if from email is not defined, then use the useremailid as the from address
$from_email = getUserEmailId('user_name', $from_name);
}
//if the newly defined from email field is set, then use this email address as the from address
//and use the username as the reply-to address
$cachedFromEmail = VTCacheUtils::getOutgoingMailFromEmailAddress();
if ($cachedFromEmail === null) {
$query = "select from_email_field from vtiger_systems where server_type=?";
$params = array('email');
$result = $adb->pquery($query, $params);
$from_email_field = $adb->query_result($result, 0, 'from_email_field');
VTCacheUtils::setOutgoingMailFromEmailAddress($from_email_field);
}
if (isUserInitiated()) {
$replyToEmail = $from_email;
} else {
$replyToEmail = $from_email_field;
}
if (isset($from_email_field) && $from_email_field != '' && !$useGivenFromEmailAddress) {
//setting from _email to the defined email address in the outgoing server configuration
$from_email = $from_email_field;
}
if ($module != "Calendar") {
//$contents = addSignature($contents,$from_name); //TODO improved during the reconstruction Signature
$mail = new PHPMailer();
}
setMailerProperties($mail, $subject, $contents, $from_email, $from_name, trim($to_email, ","), $attachment, $emailid, $module, $logo);
setCCAddress($mail, 'cc', $cc);
setCCAddress($mail, 'bcc', $bcc);
if (!empty($replyToEmail)) {
$mail->AddReplyTo($replyToEmail);
}
// vtmailscanner customization: If Support Reply to is defined use it.
global $HELPDESK_SUPPORT_EMAIL_REPLY_ID;
if ($HELPDESK_SUPPORT_EMAIL_REPLY_ID && $HELPDESK_SUPPORT_EMAIL_ID != $HELPDESK_SUPPORT_EMAIL_REPLY_ID) {
$mail->AddReplyTo($HELPDESK_SUPPORT_EMAIL_REPLY_ID);
}
// END
// Fix: Return immediately if Outgoing server not configured
if (empty($mail->Host)) {
return 0;
}
// END
if (count($attachmentSrc)) {
foreach ($attachmentSrc as $name => $src) {
if (is_array($src)) {
$mail->AddStringAttachment($src['string'], $src['filename'], $src['encoding'], $src['type']);
} else {
$mail->AddAttachment($src, $name);
}
}
}
$mail_status = MailSend($mail);
if ($mail_status != 1) {
$mail_error = getMailError($mail, $mail_status, $mailto);
} else {
$mail_error = $mail_status;
}
return $mail_error;
}
/**
* @param $context \Workflow\VTEntity
* @return mixed
*/
public function handleTask(&$context)
{
global $adb, $current_user;
global $current_language;
if (defined("WF_DEMO_MODE") && constant("WF_DEMO_MODE") == true) {
return "yes";
}
if (!class_exists("Workflow_PHPMailer")) {
require_once "modules/Workflow2/phpmailer/class.phpmailer.php";
}
#$result = $adb->query("select user_name, email1, email2 from vtiger_users where id=1");
#$from_email = "*****@*****.**";
#$from_name = "Stefan Warnat";
$module = $context->getModuleName();
$et = new \Workflow\VTTemplate($context);
$to_email = $et->render(trim($this->get("recepient")), ",");
#
$connected = $this->getConnectedObjects("Absender");
if (count($connected) > 0) {
$from_name = trim($connected[0]->get("first_name") . " " . $connected[0]->get("last_name"));
$from_email = $connected[0]->get("email1");
} else {
$from_name = $et->render(trim($this->get("from_name")), ",");
#
$from_email = $et->render(trim($this->get("from_mail")), ",");
#
}
$cc = $et->render(trim($this->get("emailcc")), ",");
#
$bcc = $et->render(trim($this->get("emailbcc")), ",");
#
/**
* Connected BCC Objects
* @var $connected
*/
$connected = $this->getConnectedObjects("BCC");
$bccs = $connected->get("email1");
if (count($bccs) > 0) {
$bcc = array($bcc);
foreach ($bccs as $bccTMP) {
$bcc[] = $bccTMP;
}
$bcc = trim(implode(",", $bcc), ",");
}
if (strlen(trim($to_email, " \t\n,")) == 0 && strlen(trim($cc, " \t\n,")) == 0 && strlen(trim($bcc, " \t\n,")) == 0) {
return "yes";
}
$storeid = trim($this->get("storeid", $context));
if (empty($storeid) || $storeid == -1 || !is_numeric($storeid)) {
$storeid = $context->getId();
}
$embeddedImages = array();
$content = $this->get("content");
$subject = $this->get("subject");
#$subject = utf8_decode($subject);
#$content = utf8_encode($content);
$content = html_entity_decode(str_replace(" ", " ", $content), ENT_QUOTES, "UTF-8");
#$subject = html_entity_decode(str_replace(" ", " ", $subject), ENT_QUOTES, "UTF-8");
$subject = $et->render(trim($subject));
$content = $et->render(trim($content));
$mailtemplate = $this->get("mailtemplate");
if (!empty($mailtemplate) && $mailtemplate != -1) {
if (strpos($mailtemplate, 's#') === false) {
$sql = "SELECT * FROM vtiger_emailtemplates WHERE templateid = " . intval($mailtemplate);
$result = $adb->query($sql);
$mailtemplate = $adb->fetchByAssoc($result);
$content = str_replace('$mailtext', $content, html_entity_decode($mailtemplate["body"], ENT_COMPAT, 'UTF-8'));
$content = Vtiger_Functions::getMergedDescription($content, $context->getId(), $context->getModuleName());
} else {
$parts = explode('#', $mailtemplate);
switch ($parts[1]) {
case 'emailmaker':
$templateid = $parts[2];
$sql = 'SELECT body, subject FROM vtiger_emakertemplates WHERE templateid = ?';
$result = $adb->pquery($sql, array($templateid));
$EMAILContentModel = \EMAILMaker_EMAILContent_Model::getInstance($this->getModuleName(), $context->getId(), $current_language, $context->getId(), $this->getModuleName());
$EMAILContentModel->setSubject($adb->query_result($result, 0, 'subject'));
$EMAILContentModel->setBody($adb->query_result($result, 0, 'body'));
$EMAILContentModel->getContent(true);
$embeddedImages = $EMAILContentModel->getEmailImages();
$subject = $EMAILContentModel->getSubject();
$content = $EMAILContentModel->getBody();
break;
}
}
}
#$content = htmlentities($content, ENT_NOQUOTES, "UTF-8");
if (getTabid('Emails') && vtlib_isModuleActive('Emails')) {
require_once 'modules/Emails/Emails.php';
$focus = new Emails();
$focus->column_fields["assigned_user_id"] = \Workflow\VTEntity::getUser()->id;
$focus->column_fields["activitytype"] = "Emails";
$focus->column_fields["date_start"] = date("Y-m-d");
$focus->column_fields["parent_id"] = $storeid;
$focus->column_fields["email_flag"] = "SAVED";
$focus->column_fields["subject"] = $subject;
$focus->column_fields["description"] = $content;
$focus->column_fields["from_email"] = $from_email;
$focus->column_fields["saved_toid"] = '["' . str_replace(',', '","', trim($to_email, ",")) . '"]';
$focus->column_fields["ccmail"] = $cc;
$focus->column_fields["bccmail"] = $bcc;
$focus->save("Emails");
$this->_mailRecord = $focus;
#error_log("eMail:".$emailID);
$emailID = $focus->id;
} else {
$emailID = "";
}
$attachments = json_decode($this->get("attachments"), true);
if (is_array($attachments) && count($attachments) > 0) {
// Module greifen auf Datenbank zurück. Daher vorher speichern!
$context->save();
foreach ($attachments as $key => $value) {
if ($value == false) {
continue;
}
if (is_string($value)) {
$value = array($value, false, array());
}
// legacy check
if (strpos($key, 'document#') === 0) {
$key = 's#' . $key;
}
if (strpos($key, 's#') === 0) {
$tmpParts = explode('#', $key, 2);
$specialAttachments = \Workflow\Attachment::getAttachments($tmpParts[1], $value, $context, \Workflow\Attachment::MODE_NOT_ADD_NEW_ATTACHMENTS);
foreach ($specialAttachments as $attachment) {
if ($attachment[0] === 'ID') {
$this->attachByAttachmentId($attachment[1]);
} elseif ($attachment[0] === 'PATH') {
$this->attachFile($attachment[1], $attachment[2], $attachment[3]);
}
}
} else {
$file = \Workflow\InterfaceFiles::getFile($key, $this->getModuleName(), $context->getId());
$this->attachFile($file['path'], $value[1] != false ? $value[1] : $file['name'], $file['type']);
}
}
}
$receiver = explode(",", $to_email);
foreach ($receiver as $to_email) {
$to_email = trim($to_email);
if (empty($to_email)) {
continue;
}
if (DEMO_MODE == false) {
// Self using
$mail = new Workflow_PHPMailer();
$mail->CharSet = 'utf-8';
$mail->IsSMTP();
foreach ($embeddedImages as $cid => $cdata) {
$mail->AddEmbeddedImage($cdata["path"], $cid, $cdata["name"]);
}
setMailServerProperties($mail);
$to_email = trim($to_email, ",");
#setMailerProperties($mail,$subject, $content, $from_email, $from_name, trim($to_email,","), "all", $emailID);
$mail->Timeout = 60;
$mail->FromName = $from_name;
$mail->From = $from_email;
$this->addStat("From: " . $from_name . " <" . $from_email . ">");
if ($this->get('trackAccess') == '1') {
//Including email tracking details
global $site_URL, $application_unique_key;
$counterUrl = $site_URL . '/modules/Emails/actions/TrackAccess.php?parentId=' . $storeid . '&record=' . $focus->id . '&applicationKey=' . $application_unique_key;
$counterHeight = 1;
$counterWidth = 1;
if (defined('TRACKING_IMG_HEIGHT')) {
$counterHeight = TRACKING_IMG_HEIGHT;
}
if (defined('TRACKING_IMG_WIDTH')) {
$counterWidth = TRACKING_IMG_WIDTH;
}
$content = "<img src='" . $counterUrl . "' alt='' width='" . $counterWidth . "' height='" . $counterHeight . "'>" . $content;
}
$mail->Subject = $subject;
$this->addStat("Subject: " . $subject);
$mail->MsgHTML($content);
$mail->SMTPDebug = 2;
$mail->addAddress($to_email);
$this->addStat("To: " . $to_email);
setCCAddress($mail, 'cc', $cc);
setCCAddress($mail, 'bcc', $bcc);
#$mail->IsHTML(true);
addAllAttachments($mail, $emailID);
try {
ob_start();
$mail_return = MailSend($mail);
$debug = ob_get_clean();
$this->addStat($debug);
} catch (Workflow_phpmailerException $exp) {
Workflow2::error_handler($exp->getCode(), $exp->getMessage(), $exp->getFile(), $exp->getLine());
}
#$mail_return = send_mail($module, $to_email,$from_name,$from_email,$subject,$content, $cc, $bcc,'all',$emailID);
} else {
$mail_return = 1;
}
$this->addStat("Send eMail with following Result:");
$this->addStat($mail_return);
if ($mail_return != 1) {
if (empty($mail->ErrorInfo) && empty($mail_return)) {
$mail_return = 1;
}
}
$context->setEnvironment("sendmail_result", $mail_return, $this);
if ($mail_return != 1) {
if ($this->isContinued()) {
$delay = 180;
} else {
$delay = 60;
}
Workflow2::send_error("Sendmail Task couldn't send an email to " . $to_email . "<br>Error: " . var_export($mail->ErrorInfo, true) . "<br><br>The Task will be rerun after " . $delay . " minutes.", __FILE__, __LINE__);
Workflow2::error_handler(E_NONBREAK_ERROR, "Sendmail Task couldn't send an email to " . $to_email . "<br>Error: " . var_export($mail->ErrorInfo, true) . "<br><br>The Task will be rerun after " . $delay . " minutes.", __FILE__, __LINE__);
return array("delay" => time() + $delay * 60, "checkmode" => "static");
}
}
// Set Mails as Send
$sql = "UPDATE vtiger_emaildetails SET email_flag = 'SENT' WHERE emailid = '" . $emailID . "'";
$adb->query($sql);
return "yes";
}
/** Function used to send email
* $module -- current module
* $to_email -- to email address
* $from_name -- currently loggedin user name
* $from_email -- currently loggedin vtiger_users's email id. you can give as '' if you are not in HelpDesk module
* $subject -- subject of the email you want to send
* $contents -- body of the email you want to send
* $cc -- add email ids with comma seperated. - optional
* $bcc -- add email ids with comma seperated. - optional.
* $attachment -- whether we want to attach the currently selected file or all vtiger_files.[values = current,all] - optional
* $emailid -- id of the email object which will be used to get the vtiger_attachments
*/
function send_mail($module, $to_email, $from_name, $from_email, $subject, $contents, $cc = '', $bcc = '', $attachment = '', $emailid = '', $logo = '', $useGivenFromEmailAddress = false)
{
global $adb, $log;
global $root_directory;
global $HELPDESK_SUPPORT_EMAIL_ID, $HELPDESK_SUPPORT_NAME;
global $WERPASCOPETESTUPLOAD;
$uploaddir = $root_directory . "{$WERPASCOPETESTUPLOAD}/";
$adb->println("To id => '" . $to_email . "'\nSubject ==>'" . $subject . "'\nContents ==> '" . $contents . "'");
//Get the email id of assigned_to user -- pass the value and name, name must be "user_name" or "id"(field names of vtiger_users vtiger_table)
//$to_email = getUserEmailId('id',$assigned_user_id);
//if module is HelpDesk then from_email will come based on support email id
if ($from_email == '') {
//if from email is not defined, then use the useremailid as the from address
$from_email = getUserEmailId('user_name', $from_name);
}
//if the newly defined from email field is set, then use this email address as the from address
//and use the username as the reply-to address
$cachedFromEmail = VTCacheUtils::getOutgoingMailFromEmailAddress();
if ($cachedFromEmail === null) {
$query = "select from_email_field from vtiger_systems where server_type=?";
$params = array('email');
$result = $adb->pquery($query, $params);
$from_email_field = $adb->query_result($result, 0, 'from_email_field');
VTCacheUtils::setOutgoingMailFromEmailAddress($from_email_field);
}
if (isUserInitiated()) {
$replyToEmail = $from_email;
} else {
$replyToEmail = $from_email_field;
}
if (isset($from_email_field) && $from_email_field != '' && !$useGivenFromEmailAddress) {
//setting from _email to the defined email address in the outgoing server configuration
$from_email = $from_email_field;
}
if ($module != "Calendar") {
$contents = addSignature($contents, $from_name);
}
$mail = new PHPMailer();
setMailerProperties($mail, $subject, $contents, $from_email, $from_name, trim($to_email, ","), $attachment, $emailid, $module, $logo);
setCCAddress($mail, 'cc', $cc);
setCCAddress($mail, 'bcc', $bcc);
// SalesPlatform.ru begin
// Duplicated AddReplyTo() call. First into the setMailerProperties()
//if(!empty($replyToEmail)) {
// $mail->AddReplyTo($replyToEmail);
//}
// SalesPlatform.ru end
// vtmailscanner customization: If Support Reply to is defined use it.
global $HELPDESK_SUPPORT_EMAIL_REPLY_ID;
if ($HELPDESK_SUPPORT_EMAIL_REPLY_ID && $HELPDESK_SUPPORT_EMAIL_ID != $HELPDESK_SUPPORT_EMAIL_REPLY_ID) {
$mail->AddReplyTo($HELPDESK_SUPPORT_EMAIL_REPLY_ID);
}
// END
// Fix: Return immediately if Outgoing server not configured
if (empty($mail->Host)) {
return 0;
}
// END
$mail_status = MailSend($mail);
if ($mail_status != 1) {
$mail_error = getMailError($mail, $mail_status, $mailto);
} else {
$mail_error = $mail_status;
// SalesPlatform.ru begin corrected date of sending
$query = 'UPDATE vtiger_emaildetails SET email_flag ="SENT" WHERE emailid=?';
$adb->pquery($query, array($emailid));
// SalesPlatform.ru end
}
return $mail_error;
}