芝麻web文件管理V1.00

编辑当前文件:/home/c7lekhnath/silverray.com.au/app/Models/User.php

<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;

use App\Enums\UserStatus;
use Laravel\Sanctum\HasApiTokens;
use Illuminate\Notifications\Notifiable;
use Modules\LiveChat\app\Models\Message;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Modules\Subscription\app\Models\SubscriptionHistory;

class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable;

/**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'user_name',
        'email',
        'password',
        'email_verified_at',
        'status',
        'is_banned',
        'verification_token',
        'forget_password_token',
    ];

/**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

/**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];

public function messagesSent()
    {
        return $this->hasMany(Message::class, 'sender_id');
    }

public function messagesReceived()
    {
        return $this->hasMany(Message::class, 'receiver_id');
    }

public function contactUsers()
    {
        return User::whereIn('id', $this->messagesSent()->pluck('receiver_id'))
            ->orWhereIn('id', $this->messagesReceived()->pluck('sender_id'))
            ->get();
    }

public function contactUsersWithUnseenMessages()
    {
        $contactUsers = User::whereIn('id', $this->messagesSent()->pluck('receiver_id'))
            ->orWhereIn('id', $this->messagesReceived()->pluck('sender_id'))
            ->select('id', 'name', 'email', 'image')
            ->get();

$contactUsersWithUnseenMessages = [];

foreach ($contactUsers as $contactUser) {
            $unseenMessagesCount = Message::where('sender_id', $contactUser->id)
                ->where('receiver_id', $this->id)
                ->where('seen', 'no')
                ->count();

$lastMessage = Message::where(function ($query) use ($contactUser) {
                $query->where('sender_id', $this->id)->where('receiver_id', $contactUser->id);
            })->orWhere(function ($query) use ($contactUser) {
                $query->where('sender_id', $contactUser->id)->where('receiver_id', $this->id);
            })->latest('created_at')->first();

$contactUsersWithUnseenMessages[] = (object) [
                'id' => $contactUser->id,
                'name' => $contactUser->name,
                'email' => $contactUser->email,
                'image' => $contactUser->image,
                'new_message' => $unseenMessagesCount,
                'last_message' => $lastMessage->created_at,
            ];
        }

usort($contactUsersWithUnseenMessages, function ($a, $b) {
            return $b->last_message <=> $a->last_message;
        });

return $contactUsersWithUnseenMessages;
    }

public function scopeActive($query)
    {
        return $query->where('status', UserStatus::ACTIVE);
    }

public function scopeInactive($query)
    {
        return $query->where('status', UserStatus::DEACTIVE);
    }

public function scopeBanned($query)
    {
        return $query->where('is_banned', UserStatus::BANNED);
    }

public function scopeUnbanned($query)
    {
        return $query->where('is_banned', UserStatus::UNBANNED);
    }

public function socialite()
    {
        return $this->hasMany(SocialiteCredential::class, 'user_id');
    }

public function hasActiveSubscription()
    {
        return $this->hasMany(SubscriptionHistory::class, 'user_id', 'id')
                    ->where('status', 'active');
    }
}