如何在qububed中发送Excel附件

Question

这就是我正在尝试的

$attach是我的excel => c：/xampp/htdocs/project/excel.xlsx

Notification::SendEmail('[e-mail]', '[e-mail]', "Subject","message", $attach);

如果删除了$attach，则电子邮件将进行。但是如果我添加附件

，它会失败

sendemail函数

    public static function SendEmail($mixFrom, $mixTo, $strSubject, $strMessage, $mixAttachment = null, $mixCc = null, $mixBcc = null) {
    // Declaration of Local Variables
    $strSMTPHost = QApplication::getSettingValue(Mssetting::SMTP_HOST);
    $strSMTPPort = QApplication::getSettingValue(Mssetting::SMTP_PORT);
    $objMessage = Swift_Message::newInstance($strSubject, $strMessage, 'text/html');
    // Set the source/destination data
    $objMessage->setFrom($mixFrom);
    $objMessage->setTo($mixTo);
    $objMessage->setCc($mixCc);
    $objMessage->setBcc($mixBcc);
    // Check for attachments
    if(is_array($mixAttachment)) {
        foreach($mixAttachment as $strFilePath)
            $objMessage->attach (Swift_Attachment::fromPath ($strFilePath));
    }
    elseif(is_string($mixAttachment)) {
        $objMessage->attach(Swift_Attachment::fromPath($mixAttachment));
    }
    // Setup the transport
    $objTransport = Swift_SmtpTransport::newInstance();
    if($strSMTPHost) $objTransport->setHost ($strSMTPHost);
    if($strSMTPPort) $objTransport->setPort($strSMTPPort);
    // Setup the mailer
    $objMailer = Swift_Mailer::newInstance($objTransport);
    // Send the message
    $objMailer->send($objMessage, $arrFailures);
    if($arrFailures)
        return $arrFailures;
    return true;
}

Answer 1

我得到了答案，使用此代码：

$Attachment = $file_path;  // path to your excel
Notification::SendEmail('[e-mail]',to@abc,com, "Subject", "Message", $Attachment);

在Notification.php

中

class Notification {
    public static function SendEmail($mixFrom, $mixTo, $strSubject, $strMessage, $mixAttachment, $mixCc = null, $mixBcc = null) {
    // Declaration of Local Variables
    $strSMTPHost = QApplication::getSettingValue(Mssetting::SMTP_HOST);
    $strSMTPPort = QApplication::getSettingValue(Mssetting::SMTP_PORT);
    $objMessage = Swift_Message::newInstance($strSubject, $strMessage, 'text/html');

    // Set the source/destination data
    $objMessage->setFrom($mixFrom);
    $objMessage->setTo($mixTo);
    $objMessage->setCc($mixCc);
    $objMessage->setBcc($mixBcc);
    // Check for attachments
    if(is_array($mixAttachment)) {
        foreach($mixAttachment as $strFilePath)
            $objMessage->attach (Swift_Attachment::fromPath ($strFilePath));
    }
    elseif(is_string($mixAttachment)) {
        $objMessage->attach(Swift_Attachment::fromPath($mixAttachment));
    }
    // Setup the transport
    $objTransport = Swift_SmtpTransport::newInstance();
    if($strSMTPHost) $objTransport->setHost ($strSMTPHost);
    if($strSMTPPort) $objTransport->setPort($strSMTPPort);
    // Setup the mailer
    $objMailer = Swift_Mailer::newInstance($objTransport);
    // Send the message
    $objMailer->send($objMessage, $arrFailures);
    if($arrFailures)
        return $arrFailures;
    return true;
}

这将完成工作。