65 lines
1.7 KiB
PHP
65 lines
1.7 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use Illuminate\Database\Eloquent\Model;
|
|
use Illuminate\Database\Eloquent\Relations\BelongsTo; // ← Add this
|
|
use Illuminate\Database\Eloquent\Relations\HasMany; // ← Add this
|
|
class MusicCategory extends Model
|
|
{
|
|
protected $table = 'music_categories';
|
|
|
|
protected $fillable = [
|
|
'name', 'slug', 'description', 'image_id', 'order', 'is_active'
|
|
];
|
|
|
|
protected $casts = [
|
|
'is_active' => 'boolean',
|
|
'order' => 'integer',
|
|
];
|
|
|
|
public function playlists(): HasMany
|
|
{
|
|
return $this->hasMany(MusicPlaylist::class, 'category_id');
|
|
}
|
|
|
|
public function subcategories(): HasMany
|
|
{
|
|
return $this->hasMany(MusicSubcategory::class, 'category_id');
|
|
}
|
|
// All playlists (including those in subcategories)
|
|
public function allPlaylists()
|
|
{
|
|
$playlists = collect($this->playlists);
|
|
|
|
foreach ($this->subcategories as $subcategory) {
|
|
$playlists = $playlists->merge($subcategory->playlists);
|
|
}
|
|
|
|
return $playlists;
|
|
}
|
|
public function image(): BelongsTo
|
|
{
|
|
return $this->belongsTo(Image::class);
|
|
}
|
|
|
|
public function getActivePlaylistsAttribute()
|
|
{
|
|
return $this->playlists()->where('is_active', true)->get();
|
|
}
|
|
|
|
// Total music count across all playlists and subcategories
|
|
public function getTotalMusicCountAttribute()
|
|
{
|
|
$count = $this->playlists->sum(function($playlist) {
|
|
return $playlist->musics->count();
|
|
});
|
|
|
|
foreach ($this->subcategories as $subcategory) {
|
|
$count += $subcategory->total_music_count;
|
|
}
|
|
|
|
return $count;
|
|
}
|
|
}
|