| 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\ApplicantType;
use App\Enums\DeadlineStatus;
use App\Enums\DeadlineType;
use App\Enums\FundingType;
use App\Enums\ModerationStatus;
use App\Enums\Purpose;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Casts\AsEnumCollection;
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 FundingProgram extends Model
{
use HasFactory;
/** Days before a fixed deadline where it counts as "closing soon". */
public const CLOSING_SOON_DAYS = 30;
protected $fillable = [
'funder_id',
'title',
'title_en',
'description',
'summary_en',
'original_language',
'purposes',
'applicant_types',
'eligible_countries',
'languages',
'funding_type',
'amount_min_cents',
'amount_max_cents',
'currency',
'deadline_type',
'deadline_date',
'recurrence_note',
'source_url',
'last_verified_at',
'created_by',
'moderation_status',
'moderated_by',
'moderated_at',
'moderation_notes',
];
protected function casts(): array
{
return [
'purposes' => AsEnumCollection::of(Purpose::class),
'applicant_types' => AsEnumCollection::of(ApplicantType::class),
'eligible_countries' => 'array',
'languages' => 'array',
'funding_type' => FundingType::class,
'deadline_type' => DeadlineType::class,
'deadline_date' => 'date',
'last_verified_at' => 'datetime',
'moderation_status' => ModerationStatus::class,
'moderated_at' => 'datetime',
];
}
protected static function booted(): void
{
static::creating(function (FundingProgram $program) {
if (empty($program->slug)) {
$program->slug = static::uniqueSlug($program->title);
}
});
}
public static function uniqueSlug(string $title): string
{
$base = Str::slug($title) ?: 'program';
$slug = $base;
$i = 2;
while (static::where('slug', $slug)->exists()) {
$slug = "{$base}-{$i}";
$i++;
}
return $slug;
}
public function funder(): BelongsTo
{
return $this->belongsTo(Funder::class);
}
public function creator(): BelongsTo
{
return $this->belongsTo(User::class, 'created_by');
}
public function experiences(): HasMany
{
return $this->hasMany(ProgramExperience::class);
}
/** Publicly visible: programme approved AND its funder approved. */
public function scopeApproved(Builder $query): Builder
{
return $query
->where('moderation_status', ModerationStatus::Approved)
->whereHas('funder', fn (Builder $q) => $q->where('moderation_status', ModerationStatus::Approved));
}
/** Rolling/recurring always count as open; fixed deadlines until the date passes. */
public function scopeOpenNow(Builder $query): Builder
{
return $query->where(function (Builder $q) {
$q->where('deadline_type', '!=', DeadlineType::Fixed)
->orWhereDate('deadline_date', '>=', now()->toDateString());
});
}
public function isApproved(): bool
{
return $this->moderation_status === ModerationStatus::Approved;
}
public function deadlineStatus(): DeadlineStatus
{
return match ($this->deadline_type) {
DeadlineType::Rolling => DeadlineStatus::Rolling,
DeadlineType::Recurring => DeadlineStatus::Recurring,
DeadlineType::Fixed => $this->deadline_date === null || $this->deadline_date->isPast()
? DeadlineStatus::Expired
: ($this->deadline_date->lte(now()->addDays(self::CLOSING_SOON_DAYS))
? DeadlineStatus::ClosingSoon
: DeadlineStatus::Open),
};
}
public function displayTitle(): string
{
return $this->title_en ?: $this->title;
}
/** Human-readable funding range, e.g. "€5,000 – €25,000", "up to €25,000". */
public function amountRange(): ?string
{
$min = $this->amount_min_cents;
$max = $this->amount_max_cents;
if ($min === null && $max === null) {
return null;
}
$format = fn (int $cents): string => $this->currencySymbol().number_format(intdiv($cents, 100));
return match (true) {
$min !== null && $max !== null && $min !== $max => $format($min).' – '.$format($max),
$min !== null && $max !== null => $format($min),
$max !== null => __('up to :amount', ['amount' => $format($max)]),
default => __('from :amount', ['amount' => $format($min)]),
};
}
private function currencySymbol(): string
{
return match ($this->currency) {
'EUR' => '€',
'GBP' => '£',
'CHF' => 'CHF ',
default => $this->currency.' ',
};
}
public function getRouteKeyName(): string
{
return 'slug';
}
}