sfp_api_laravel_diarista/app/Models/Provider.php

<?php

namespace App\Models;

use App\Enums\ApprovalStatusEnum;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;
use Illuminate\Database\Eloquent\SoftDeletes;

/**
 * @property int $id
 * @property string $document
 * @property string|null $rg
 * @property int $user_id
 * @property float|null $average_rating
 * @property int $total_services
 * @property string|null $birth_date
 * @property bool $selfie_verified
 * @property bool $document_verified
 * @property string $approval_status
 * @property float|null $daily_price_8h
 * @property float|null $daily_price_6h
 * @property float|null $daily_price_4h
 * @property float|null $daily_price_2h
 * @property int|null $profile_media_id
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property \Illuminate\Support\Carbon|null $deleted_at
 * @property-read \App\Models\User $user
 * @property-read \App\Models\Media|null $profileMedia
 * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider onlyTrashed()
 * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider query()
 * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider withTrashed(bool $withTrashed = true)
 * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider withoutTrashed()
 * @mixin \Eloquent
 */
class Provider extends Model
{
  use HasFactory, SoftDeletes;

  protected $table = "providers";

  protected $guarded = ["id"];

  /**
   * Get the attributes that should be cast.
   *
   * @return array<string, string>
   */
  protected function casts(): array
  {
    return [
      "birth_date" => "date",
      "selfie_verified"   => "boolean",
      "document_verified" => "boolean",
      "approval_status"   => ApprovalStatusEnum::class,
      "average_rating" => "decimal:1",
      "daily_price_8h" => "decimal:2",
      "daily_price_6h" => "decimal:2",
      "daily_price_4h" => "decimal:2",
      "daily_price_2h" => "decimal:2",
      "total_services" => "integer",
    ];
  }

  /**
   * @return BelongsTo
   */
  public function user(): BelongsTo
  {
    return $this->belongsTo(User::class, "user_id");
  }

  /**
   * @return BelongsTo
   */
  public function profileMedia(): BelongsTo
  {
    return $this->belongsTo(Media::class, "profile_media_id");
  }

  /**
   * @return HasMany
     */
    public function addresses(): HasMany
    {
        return $this->hasMany(Address::class, 'source_id')
            ->where('source', 'provider');
    }

    // /**
    //  * @return HasOne
    //  */
    // public function primaryAddress(): HasOne
    // {
    //     return $this->hasOne(Address::class, 'source_id')
    //         ->where('source', 'provider')
    //         ->where('is_primary', true);
    // }

    /**
     * @return HasMany
   */
  public function blockedClients()
  {
    return $this->hasMany(ProviderClientBlock::class);
  }

  /**
   * @return \Illuminate\Database\Eloquent\Relations\HasMany
   */
  public function blockedByClients()
  {
    return $this->hasMany(ClientProviderBlock::class);
  }

  public function updateAverageRating(float $newRating): void
  {
    $totalReviews = Review::where('reviews.origin', 'client')
      ->leftJoin('schedules', 'schedules.id', '=', 'reviews.schedule_id')
      ->where('schedules.provider_id', $this->id)
      ->count();

    if ($totalReviews === 0) {
      $this->average_rating = $newRating;
    } else {
      $currentTotalRating = $this->average_rating * ($totalReviews - 1);
      $newAverage = ($currentTotalRating + $newRating) / $totalReviews;
      $this->average_rating = round($newAverage, 2);
    }

    $this->save();
  }

  public function primaryAddress()
  {
    return $this->hasOne(Address::class, "source_id")
      ->where("source", "provider")
      ->orderBy("is_primary", "desc");
  }
}