laravel如何实现一个简单的站内信系统_Laravel简单站内信系统实现方法

Schema::create('messages', function (Blueprint $table) {
    $table->id();
    $table->unsignedBigInteger('sender_id');        // 发送者ID
    $table->unsignedBigInteger('recipient_id');     // 接收者ID
    $table->string('subject')->nullable();         // 标题
    $table->text('body');                          // 内容
    $table->boolean('is_read')->default(false);    // 是否已读
    $table->timestamps();

    $table->foreign('sender_id')->references('id')->on('users')->onDelete('cascade');
    $table->foreign('recipient_id')->references('id')->on('users')->onDelete('cascade');
});

class Message extends Model
{
    protected $fillable = ['sender_id', 'recipient_id', 'subject', 'body', 'is_read'];

    public function sender()
    {
        return $this->belongsTo(User::class, 'sender_id');
    }

    public function recipient()
    {
        return $this->belongsTo(User::class, 'recipient_id');
    }
}

use App\Models\Message;
use Illuminate\Http\Request;

public function store(Request $request)
{
    $request->validate([
        'recipient_id' => 'required|exists:users,id',
        'subject' => 'nullable|string|max:255',
        'body' => 'required|string',
    ]);

    Message::create([
        'sender_id' => auth()->id(),
        'recipient_id' => $request->recipient_id,
        'subject' => $request->subject,
        'body' => $request->body,
        'is_read' => false,
    ]);

    return back()->with('success', '消息已发送！');
}

public function inbox()
{
    $messages = Message::where('recipient_id', auth()->id())
                       ->with('sender')
                       ->latest()
                       ->paginate(10);

    return view('messages.inbox', compact('messages'));
}

public function outbox()
{
    $messages = Message::where('sender_id', auth()->id())
                       ->with('recipient')
                       ->latest()
                       ->paginate(10);

    return view('messages.outbox', compact('messages'));
}

public function show($id)
{
    $message = Message::where('id', $id)
                      ->where('recipient_id', auth()->id())
                      ->firstOrFail();

    if (!$message->is_read) {
        $message->update(['is_read' => true]);
    }

    return view('messages.show', compact('message'));
}

$unreadCount = Message::where('recipient_id', auth()->id())
                      ->where('is_read', false)
                      ->count();