Provider.php 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181
  1. <?php
  2. namespace App\Models;
  3. use App\Enums\ApprovalStatusEnum;
  4. use Illuminate\Database\Eloquent\Factories\HasFactory;
  5. use Illuminate\Database\Eloquent\Model;
  6. use Illuminate\Database\Eloquent\Relations\BelongsTo;
  7. use Illuminate\Database\Eloquent\Relations\HasMany;
  8. use Illuminate\Database\Eloquent\Relations\HasOne;
  9. use Illuminate\Database\Eloquent\SoftDeletes;
  10. /**
  11. * @property int $id
  12. * @property string $document
  13. * @property string|null $rg
  14. * @property int $user_id
  15. * @property numeric|null $average_rating
  16. * @property int $total_services
  17. * @property \Illuminate\Support\Carbon|null $birth_date
  18. * @property bool $selfie_verified
  19. * @property bool $document_verified
  20. * @property numeric|null $daily_price_8h
  21. * @property numeric|null $daily_price_6h
  22. * @property numeric|null $daily_price_4h
  23. * @property numeric|null $daily_price_2h
  24. * @property int|null $profile_media_id
  25. * @property \Illuminate\Support\Carbon|null $created_at
  26. * @property \Illuminate\Support\Carbon|null $updated_at
  27. * @property \Illuminate\Support\Carbon|null $deleted_at
  28. * @property string|null $selfie_media_base64
  29. * @property string|null $document_front_media_base64
  30. * @property string|null $document_back_media_base64
  31. * @property ApprovalStatusEnum $approval_status
  32. * @property-read \Illuminate\Database\Eloquent\Collection<int, \App\Models\Address> $addresses
  33. * @property-read int|null $addresses_count
  34. * @property-read \Illuminate\Database\Eloquent\Collection<int, \App\Models\ClientProviderBlock> $blockedByClients
  35. * @property-read int|null $blocked_by_clients_count
  36. * @property-read \Illuminate\Database\Eloquent\Collection<int, \App\Models\ProviderClientBlock> $blockedClients
  37. * @property-read int|null $blocked_clients_count
  38. * @property-read \App\Models\Address|null $primaryAddress
  39. * @property-read \App\Models\Media|null $profileMedia
  40. * @property-read \App\Models\User $user
  41. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider newModelQuery()
  42. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider newQuery()
  43. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider onlyTrashed()
  44. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider query()
  45. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereApprovalStatus($value)
  46. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereAverageRating($value)
  47. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereBirthDate($value)
  48. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereCreatedAt($value)
  49. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDailyPrice2h($value)
  50. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDailyPrice4h($value)
  51. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDailyPrice6h($value)
  52. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDailyPrice8h($value)
  53. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDeletedAt($value)
  54. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDocument($value)
  55. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDocumentBackMediaBase64($value)
  56. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDocumentFrontMediaBase64($value)
  57. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereDocumentVerified($value)
  58. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereId($value)
  59. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereProfileMediaId($value)
  60. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereRg($value)
  61. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereSelfieMediaBase64($value)
  62. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereSelfieVerified($value)
  63. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereTotalServices($value)
  64. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereUpdatedAt($value)
  65. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider whereUserId($value)
  66. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider withTrashed(bool $withTrashed = true)
  67. * @method static \Illuminate\Database\Eloquent\Builder<static>|Provider withoutTrashed()
  68. * @mixin \Eloquent
  69. */
  70. class Provider extends Model
  71. {
  72. use HasFactory, SoftDeletes;
  73. protected $table = "providers";
  74. protected $guarded = ["id"];
  75. /**
  76. * Get the attributes that should be cast.
  77. *
  78. * @return array<string, string>
  79. */
  80. protected function casts(): array
  81. {
  82. return [
  83. "birth_date" => "date",
  84. "selfie_verified" => "boolean",
  85. "document_verified" => "boolean",
  86. "approval_status" => ApprovalStatusEnum::class,
  87. "average_rating" => "decimal:1",
  88. "daily_price_8h" => "decimal:2",
  89. "daily_price_6h" => "decimal:2",
  90. "daily_price_4h" => "decimal:2",
  91. "daily_price_2h" => "decimal:2",
  92. "total_services" => "integer",
  93. "recipient_default_bank_account" => "array",
  94. "recipient_transfer_settings" => "array",
  95. "recipient_automatic_anticipation_settings" => "array",
  96. "recipient_metadata" => "array",
  97. ];
  98. }
  99. /**
  100. * @return BelongsTo
  101. */
  102. public function user(): BelongsTo
  103. {
  104. return $this->belongsTo(User::class, "user_id");
  105. }
  106. /**
  107. * @return BelongsTo
  108. */
  109. public function profileMedia(): BelongsTo
  110. {
  111. return $this->belongsTo(Media::class, "profile_media_id");
  112. }
  113. /**
  114. * @return HasMany
  115. */
  116. public function addresses(): HasMany
  117. {
  118. return $this->hasMany(Address::class, 'source_id')
  119. ->where('source', 'provider');
  120. }
  121. // /**
  122. // * @return HasOne
  123. // */
  124. // public function primaryAddress(): HasOne
  125. // {
  126. // return $this->hasOne(Address::class, 'source_id')
  127. // ->where('source', 'provider')
  128. // ->where('is_primary', true);
  129. // }
  130. /**
  131. * @return HasMany
  132. */
  133. public function blockedClients()
  134. {
  135. return $this->hasMany(ProviderClientBlock::class);
  136. }
  137. /**
  138. * @return \Illuminate\Database\Eloquent\Relations\HasMany
  139. */
  140. public function blockedByClients()
  141. {
  142. return $this->hasMany(ClientProviderBlock::class);
  143. }
  144. public function updateAverageRating(float $newRating): void
  145. {
  146. $totalReviews = Review::where('reviews.origin', 'client')
  147. ->leftJoin('schedules', 'schedules.id', '=', 'reviews.schedule_id')
  148. ->where('schedules.provider_id', $this->id)
  149. ->count();
  150. if ($totalReviews === 0) {
  151. $this->average_rating = $newRating;
  152. } else {
  153. $currentTotalRating = $this->average_rating * ($totalReviews - 1);
  154. $newAverage = ($currentTotalRating + $newRating) / $totalReviews;
  155. $this->average_rating = round($newAverage, 2);
  156. }
  157. $this->save();
  158. }
  159. public function primaryAddress()
  160. {
  161. return $this->hasOne(Address::class, "source_id")
  162. ->where("source", "provider")
  163. ->orderBy("is_primary", "desc");
  164. }
  165. }