| Server IP : 167.235.224.122 / Your IP : 216.73.216.110 Web Server : Apache/2.4.58 (Ubuntu) System : Linux newplayground 6.8.0-136-generic #136-Ubuntu SMP PREEMPT_DYNAMIC Wed Jul 1 21:33:11 UTC 2026 aarch64 User : deploy ( 1000) PHP Version : 8.4.23 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /var/www/html/futuresfunder/app/Models/ |
Upload File : |
<?php
namespace App\Models;
use App\Enums\FunderLevel;
use App\Enums\ModerationStatus;
use Illuminate\Database\Eloquent\Builder;
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\Support\Str;
class Funder extends Model
{
use HasFactory;
protected $fillable = [
'name',
'country',
'level',
'website',
'description',
'created_by',
'moderation_status',
'moderated_by',
'moderated_at',
'moderation_notes',
];
protected function casts(): array
{
return [
'level' => FunderLevel::class,
'moderation_status' => ModerationStatus::class,
'moderated_at' => 'datetime',
];
}
protected static function booted(): void
{
static::creating(function (Funder $funder) {
if (empty($funder->slug)) {
$funder->slug = static::uniqueSlug($funder->name);
}
});
}
public static function uniqueSlug(string $name): string
{
$base = Str::slug($name) ?: 'funder';
$slug = $base;
$i = 2;
while (static::where('slug', $slug)->exists()) {
$slug = "{$base}-{$i}";
$i++;
}
return $slug;
}
public function programs(): HasMany
{
return $this->hasMany(FundingProgram::class);
}
public function creator(): BelongsTo
{
return $this->belongsTo(User::class, 'created_by');
}
public function scopeApproved(Builder $query): Builder
{
return $query->where('moderation_status', ModerationStatus::Approved);
}
public function isApproved(): bool
{
return $this->moderation_status === ModerationStatus::Approved;
}
public function countryName(): ?string
{
return $this->country ? config('countries')[$this->country] ?? $this->country : null;
}
/**
* Funders whose name resembles the given one — substring either way or
* high textual similarity. Computed in PHP (DB-agnostic; the funders
* table stays directory-scale small).
*
* @return \Illuminate\Support\Collection<int, static>
*/
public static function similarTo(string $name, ?int $excludeId = null)
{
$needle = mb_strtolower(trim($name));
if (mb_strlen($needle) < 3) {
return collect();
}
return static::query()
->when($excludeId, fn ($q) => $q->where('id', '!=', $excludeId))
->get(['id', 'name', 'country', 'slug'])
->filter(function (Funder $funder) use ($needle) {
$hay = mb_strtolower($funder->name);
if (str_contains($hay, $needle) || str_contains($needle, $hay)) {
return true;
}
similar_text($needle, $hay, $percent);
return $percent >= 80;
})
->take(5)
->values();
}
public static function nameExists(string $name, ?int $excludeId = null): bool
{
$needle = mb_strtolower(trim($name));
return static::query()
->when($excludeId, fn ($q) => $q->where('id', '!=', $excludeId))
->get(['id', 'name'])
->contains(fn (Funder $funder) => mb_strtolower(trim($funder->name)) === $needle);
}
public function getRouteKeyName(): string
{
return 'slug';
}
}