95 lines
2.4 KiB
PHP
95 lines
2.4 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Attributes\Fillable;
|
|
use Illuminate\Database\Eloquent\Attributes\Scope;
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
|
|
use Illuminate\Database\Eloquent\Relations\HasMany;
|
|
use Illuminate\Database\Eloquent\SoftDeletes;
|
|
|
|
#[Fillable([
|
|
'source',
|
|
'external_id',
|
|
'remote_url',
|
|
'remote_etag',
|
|
'first_name',
|
|
'last_name',
|
|
'organization',
|
|
'email',
|
|
'notes',
|
|
'sms_opt_out',
|
|
'is_favorite',
|
|
'synced_at',
|
|
])]
|
|
class Contact extends Model
|
|
{
|
|
use SoftDeletes;
|
|
|
|
/**
|
|
* @return HasMany<ContactPhoneNumber, $this>
|
|
*/
|
|
public function phoneNumbers(): HasMany
|
|
{
|
|
return $this->hasMany(ContactPhoneNumber::class);
|
|
}
|
|
|
|
/**
|
|
* @return BelongsToMany<ContactGroup, $this>
|
|
*/
|
|
public function groups(): BelongsToMany
|
|
{
|
|
return $this->belongsToMany(ContactGroup::class, 'contact_contact_group')
|
|
->withTimestamps();
|
|
}
|
|
|
|
public function displayName(): string
|
|
{
|
|
return trim(implode(' ', array_filter([$this->first_name, $this->last_name])));
|
|
}
|
|
|
|
/**
|
|
* @param Builder<Contact> $query
|
|
*/
|
|
#[Scope]
|
|
protected function search(Builder $query, ?string $term): void
|
|
{
|
|
$term = trim((string) $term);
|
|
|
|
if ($term === '') {
|
|
return;
|
|
}
|
|
|
|
$like = '%'.str_replace(['%', '_'], ['\%', '\_'], $term).'%';
|
|
|
|
$query->where(function (Builder $query) use ($like): void {
|
|
$query
|
|
->where('first_name', 'like', $like)
|
|
->orWhere('last_name', 'like', $like)
|
|
->orWhere('organization', 'like', $like)
|
|
->orWhere('email', 'like', $like)
|
|
->orWhereHas('phoneNumbers', function (Builder $query) use ($like): void {
|
|
$query
|
|
->where('raw_number', 'like', $like)
|
|
->orWhere('normalized_number', 'like', $like);
|
|
});
|
|
});
|
|
}
|
|
|
|
/**
|
|
* Get the attributes that should be cast.
|
|
*
|
|
* @return array<string, string>
|
|
*/
|
|
protected function casts(): array
|
|
{
|
|
return [
|
|
'sms_opt_out' => 'boolean',
|
|
'is_favorite' => 'boolean',
|
|
'synced_at' => 'datetime',
|
|
];
|
|
}
|
|
}
|