在 Laravel Nova 中通过邮件发送文件附件的教程

// app/Nova/NewsletterMail.php
<?php

namespace App\Nova;

use Laravel\Nova\Fields\ID;
use Illuminate\Http\Request;
use Laravel\Nova\Fields\Date;
use Laravel\Nova\Fields\File;
use Laravel\Nova\Fields\Markdown;
use Laravel\Nova\Http\Requests\NovaRequest;

class NewsletterMail extends Resource
{
    public static $model = \App\Models\NewsletterMail::class;

    public static $title = 'id';

    public static $search = [
        'id',
    ];

    public function fields(Request $request)
    {
        return [
            ID::make(__('ID'), 'id')->sortable(),
            Date::make('创建日期', 'created_at')->sortable(),
            Markdown::make('邮件内容', 'content')->alwaysShow(),
            // 假设文件路径存储在数据库表的 'file_path' 字段
            // 文件将存储在 'public' 存储盘
            File::make('附件文件', 'file_path')->disk('public'),
        ];
    }

    public function actions(Request $request)
    {
        return [
            Actions\SendNewsletterMail::make()->standalone(),
        ];
    }
}

// app/Mail/NewsletterMail.php
<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;
use Illuminate\Mail\Mailable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Support\Facades\Storage;
use Illuminate\Contracts\Queue\ShouldQueue;

class NewsletterMail extends Mailable implements ShouldQueue // 如果需要队列发送，实现 ShouldQueue
{
    use Queueable, SerializesModels;

    public $content;
    protected $newsletterMailRecord;

    /**
     * 创建一个新的消息实例。
     *
     * @param object $newsletterMailRecord 包含邮件内容和文件路径的记录
     * @return void
     */
    public function __construct(object $newsletterMailRecord)
    {
        $this->newsletterMailRecord = $newsletterMailRecord;
    }

    /**
     * 构建邮件消息。
     *
     * @return $this
     */
    public function build()
    {
        $this->content = $this->newsletterMailRecord->content;

        $mailable = $this->markdown('emails.newsletter')->with('content', $this->content);

        // 检查是否存在文件路径字段，并尝试附加文件
        // 假设数据库中存储文件路径的字段名为 'file_path'
        if (isset($this->newsletterMailRecord->file_path) && $this->newsletterMailRecord->file_path) {
            $disk = 'public'; // 对应 Nova Resource 中定义的 disk
            $relativePath = $this->newsletterMailRecord->file_path;

            // 获取文件的完整物理路径
            $filePath = Storage::disk($disk)->path($relativePath);

            // 确保文件存在且可读
            if (file_exists($filePath) && is_readable($filePath)) {
                // 提取文件名作为附件名称
                $fileName = basename($relativePath);
                // 尝试获取 MIME 类型，如果失败则使用通用类型
                $mimeType = Storage::disk($disk)->mimeType($relativePath) ?? 'application/octet-stream';

                $mailable->attach($filePath, [
                    'as' => $fileName, // 附件在邮件中显示的文件名
                    'mime' => $mimeType, // 附件的 MIME 类型
                ]);
            } else {
                // 文件不存在或不可读的日志记录
                \Log::warning("邮件附件文件不存在或不可读，路径: " . $filePath);
            }
        }

        return $mailable;
    }
}

// app/Http/Controllers/NewsletterMailController.php
<?php

namespace App\Http\Controllers;

use App\Mail\NewsletterMail;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Mail;
use Illuminate\Http\Request;

class NewsletterMailController extends Controller
{
    public function send()
    {
        // 提前获取最新的邮件记录，避免在循环中重复查询
        $newsletterMailRecord = DB::table('newsletter_mails')
                                ->orderByDesc('id')
                                ->first();

        if (!$newsletterMailRecord) {
            \Log::error("尝试发送通讯邮件时未找到邮件内容。");
            return response()->json(['message' => '未找到邮件内容，无法发送。'], 400);
        }

        $emailRecipients = DB::table('newsletter_recipients')->orderByDesc('id')->get();

        foreach ($emailRecipients as $emailRecipient) {
            // 将邮件记录传递给 Mailable 的构造函数
            Mail::to($emailRecipient->email)->send(new NewsletterMail($newsletterMailRecord));
        }

        return response()->json(['message' => '通讯邮件已发送。']);
    }
}

// app/Nova/Actions/SendNewsletterMail.php
<?php

namespace App\Nova\Actions;

use App\Http\Controllers\NewsletterMailController;
use Illuminate\Bus\Queueable;
use Laravel\Nova\Actions\Action;
use Illuminate\Support\Collection;
use Laravel\Nova\Fields\ActionFields;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;

class SendNewsletterMail extends Action
{
    use InteractsWithQueue, Queueable;

    public $standalone = true; // 允许独立运行

    /**
     * 执行操作。
     *
     * @param  \Laravel\Nova\Fields\ActionFields  $fields
     * @param  \Illuminate\Support\Collection  $models
     * @return array
     */
    public function handle(ActionFields $fields, Collection $models)
    {
        try {
            app(NewsletterMailController::class)->send();
            return Action::message('通讯邮件已成功发送！');
        } catch (\Exception $e) {
            \Log::error("发送通讯邮件失败: " . $e->getMessage());
            return Action::danger('发送通讯邮件失败，请检查日志。');
        }
    }
}