| 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/europiastories/app/Models/ |
Upload File : |
<?php
namespace App\Models;
use App\Enums\ModerationStatus;
use App\Enums\WorkType;
use Illuminate\Database\Eloquent\Attributes\Fillable;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
#[Fillable([
'title_original', 'original_language', 'year_first_published', 'type',
'genres', 'tags', 'synopsis', 'synopsis_en', 'credited_author_name',
'external_ids', 'source_id', 'source_record_url', 'source_retrieved_at', 'import_batch_id', 'created_by',
])]
class Work extends Model
{
protected function casts(): array
{
return [
'type' => WorkType::class,
'moderation_status' => ModerationStatus::class,
'genres' => 'array',
'tags' => 'array',
'external_ids' => 'array',
'source_retrieved_at' => 'datetime',
'locally_modified' => 'boolean',
];
}
public function source(): BelongsTo
{
return $this->belongsTo(Source::class);
}
public function editions(): HasMany
{
return $this->hasMany(Edition::class);
}
public function creator(): BelongsTo
{
return $this->belongsTo(User::class, 'created_by');
}
public function scopeApproved($query)
{
return $query->where('moderation_status', ModerationStatus::Approved);
}
/** Languages this work exists in (original + all approved editions). */
public function availableLanguages(): array
{
return collect([$this->original_language])
->merge($this->editions->pluck('language'))
->unique()
->values()
->all();
}
/**
* The edition whose cover represents this work: prefer the original-
* language edition (the work as written), latest first; fall back to
* the latest cover in any language; null → typographic placeholder.
*/
public function displayCover(): ?Edition
{
$covered = $this->editions
->whereNotNull('cover_path')
->sortByDesc(fn (Edition $edition) => [$edition->year ?? 0, $edition->id]);
return $covered->firstWhere('language', $this->original_language)
?? $covered->first();
}
/**
* Fuzzy duplicate candidates by title (and author when given) — the
* futuresfunder "did you mean" pattern.
*/
public static function similarTo(string $title, ?string $author = null, ?int $excludeId = null)
{
$needle = mb_strtolower(trim($title));
if (mb_strlen($needle) < 3) {
return collect();
}
return static::query()
->when($excludeId, fn ($q) => $q->where('id', '!=', $excludeId))
->get(['id', 'title_original', 'credited_author_name', 'original_language', 'year_first_published'])
->filter(function (Work $work) use ($needle, $author) {
$hay = mb_strtolower($work->title_original);
$titleMatch = str_contains($hay, $needle) || str_contains($needle, $hay);
if (! $titleMatch) {
similar_text($needle, $hay, $percent);
$titleMatch = $percent >= 80;
}
if (! $titleMatch) {
return false;
}
if ($author === null || trim($author) === '') {
return true;
}
similar_text(
mb_strtolower(trim($author)),
mb_strtolower($work->credited_author_name),
$authorPercent,
);
return $authorPercent >= 60;
})
->take(5)
->values();
}
}