123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. <?php
  2. namespace App\Models;
  3. use Carbon\Carbon;
  4. use Illuminate\Database\Eloquent\Casts\Attribute;
  5. use Illuminate\Database\Eloquent\Factories\HasFactory;
  6. use Illuminate\Database\Eloquent\Model;
  7. class Member extends Model
  8. {
  9. use HasFactory;
  10. protected $fillable = [
  11. 'name',
  12. 'phone',
  13. 'exp_date',
  14. 'type_member_id',
  15. ];
  16. protected function updatedAt(): Attribute
  17. {
  18. return Attribute::make(
  19. get:fn($value) => Carbon::parse($value)->translatedFormat('l d/m/Y')
  20. );
  21. }
  22. protected function expDate(): Attribute
  23. {
  24. return Attribute::make(
  25. get:fn($value) => Carbon::parse($value)->translatedFormat('l d/m/Y')
  26. );
  27. }
  28. public function typeMember()
  29. {
  30. return $this->belongsTo(TypeMember::class);
  31. }
  32. public function vehicles()
  33. {
  34. return $this->hasMany(Vehicle::class);
  35. }
  36. public function topUps()
  37. {
  38. return $this->hasMany(TopUp::class);
  39. }
  40. public function vehicleDetail()
  41. {
  42. $detailVehicle = $this->vehicles->transform(fn($vehicle) => $vehicle->typeVehicle->type . ': ' . $vehicle->plat_number)->toArray();
  43. return implode(', ', $detailVehicle);
  44. }
  45. public function scopeFilter($query, array $filters)
  46. {
  47. $query->when($filters['search'] ?? null, function ($query, $search) {
  48. $query->where(function ($query) use ($search) {
  49. $query->where('name', 'like', '%' . $search . '%');
  50. });
  51. });
  52. }
  53. }