-
Notifications
You must be signed in to change notification settings - Fork 296
Expand file tree
/
Copy pathPost.php
More file actions
63 lines (50 loc) · 1.71 KB
/
Post.php
File metadata and controls
63 lines (50 loc) · 1.71 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<?php /** @noinspection PhpUnused */
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasMany;
class Post extends Model
{
use HasFactory;
protected $with = ['category', 'author'];
public const DEFAULT_POST_THUMBNAIL_URL = 'post/default.jpg';
public function scopeFilter($query, array $filters)
{
$query->when($filters['search'] ?? false, fn($query, $search) =>
$query->where(fn($query) =>
$query->where('title', 'like', '%' . $search . '%')
->orWhere('body', 'like', '%' . $search . '%')
)
);
$query->when($filters['category'] ?? false, fn($query, $category) =>
$query->whereHas('category', fn ($query) =>
$query->where('slug', $category)
)
);
$query->when($filters['author'] ?? false, fn($query, $author) =>
$query->whereHas('author', fn ($query) =>
$query->where('username', $author)
)
);
}
public function getThumbnailUrl(): string
{
if ($thumbnailPath = $this->getAttribute('thumbnail')) {
return "/storage/$thumbnailPath";
}
return asset('images') . '/' . self::DEFAULT_POST_THUMBNAIL_URL;
}
public function comments(): HasMany
{
return $this->hasMany(Comment::class);
}
public function category(): BelongsTo
{
return $this->belongsTo(Category::class);
}
public function author(): BelongsTo
{
return $this->belongsTo(User::class, 'user_id');
}
}