Laravel数据库通知的智能管理：实现通知合并与去重

public function toDatabase($notifiable): array
{
    return [
        'content' => '这是一条新通知',
        'type' => 'post_created',
        'post_id' => $this->post->id,
    ];
}

<?php

namespace App\Notifications;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Notifications\Notification;
use Illuminate\Notifications\Messages\DatabaseMessage;
use App\Models\Search; // 假设您的Search模型

class PostMatchedSearchNotification extends Notification
{
    use Queueable;

    protected Search $search;
    protected string $postTitle; // 假设通知中需要展示的帖子标题

    /**
     * 创建一个新的通知实例。
     *
     * @param Search $search 触发通知的搜索条件
     * @param string $postTitle 匹配到的帖子标题
     * @return void
     */
    public function __construct(Search $search, string $postTitle = '新帖子')
    {
        $this->search = $search;
        $this->postTitle = $postTitle;
    }

    /**
     * 获取通知的交付渠道。
     *
     * @param mixed $notifiable
     * @return array
     */
    public function via($notifiable): array
    {
        return ['database'];
    }

    /**
     * 将通知转换为数据库存储的数组。
     *
     * @param mixed $notifiable
     * @return array
     */
    public function toDatabase($notifiable): array
    {
        $timeWindowMinutes = 30; // 定义时间窗口：30分钟
        $searchIdentifier = $this->search->id; // 用于识别相关通知的唯一标识

        // 尝试查找在指定时间窗口内，针对当前搜索条件已存在的通知
        $existingNotification = $notifiable->notifications()
            ->where('data->search_id', $searchIdentifier) // 使用 data->search_id 进行查询
            ->where('created_at', '>=', now()->subMinutes($timeWindowMinutes))
            ->first();

        if ($existingNotification) {
            // 如果找到了现有通知，则更新它
            $currentCount = $existingNotification->data['count'] ?? 0;
            $newCount = $currentCount + 1;

            $existingNotification->update([
                'data' => array_merge($existingNotification->data, [
                    'content' => [
                        'en' => "{$newCount} new posts matched with your saved search '{$this->search->title}' have been posted. Click to view more.",
                        'zh' => "您的保存搜索 '{$this->search->title}' 匹配到 {$newCount} 篇新帖子。点击查看更多。",
                    ],
                    'count' => $newCount,
                    // 可以更新其他相关数据，例如最后更新时间
                    'last_updated_at' => now()->toDateTimeString(),
                    // 确保 search_id 和 parameters 等关键标识符仍然存在
                    'search_id' => $searchIdentifier,
                    'parameters' => $this->search->parameters,
                ])
            ]);

            // 关键：返回一个空数组，阻止Laravel创建新的通知记录
            return [];
        }

        // 如果在时间窗口内没有找到现有通知，则创建一条新的通知
        return [
            'content' => [
                'en' => "1 new post matched with your saved search '{$this->search->title}' has been posted. Click to view more.",
                'zh' => "您的保存搜索 '{$this->search->title}' 匹配到 1 篇新帖子。点击查看更多。",
            ],
            'count' => 1,
            'search_id' => $searchIdentifier, // 用于后续查询的标识符
            'parameters' => $this->search->parameters,
            'first_matched_post_title' => $this->postTitle, // 首次匹配到的帖子标题
            'created_at' => now()->toDateTimeString(), // 记录创建时间
        ];
    }
}