Dinamik İçerik Sistemi — Eksiksiz Rehber

// Şu anki statik sorgular — YENİ SİSTEMDE KALDIRILACAK:
$homePlaylists  = Playlist::active()->system()...limit(10);  // cache 5dk
$newReleases    = Album::active()...limit(10);               // cache 5dk
$popularSongs   = Song::active()...orderBy('play_count')...limit(10);
$newSongs       = Song::active()...orderBy('created_at')...limit(15);
$genres         = Genre::active()...limit(15);
$radios         = Radio::active()...limit(10);
$sectors        = Sector::active()...limit(10);
$userPlaylists  = // kullanıcıya özel, 60s cache

// YENİ SİSTEM:
$smartFeed = app(SmartFeedService::class);
$greeting  = $smartFeed->getGreeting($user);
$feed      = $smartFeed->getFeed($user);
$msUntilNextHour = ((60 - now()->minute) * 60 - now()->second + 60) * 1000;

-- muzibu_content_collections
INSERT INTO muzibu_content_collections
  (collection_id, title, slug, type, icon, priority, display_rules, sector_rules, is_active) VALUES
(1, '{"tr":"Sabah Kafe Mix","en":"Morning Cafe Mix"}',
    '{"tr":"sabah-kafe-mix"}',
    'daypart', 'fas fa-coffee', 100,
    '{"start_hour":6,"end_hour":12,"days":["mon","tue","wed","thu","fri","sat","sun"],"is_always":false}',
    '{"mode":"include","sector_ids":[1,2],"show_to_all":false}',
    1),
(2, '{"tr":"Editörün Seçimi","en":"Editor Picks"}',
    '{"tr":"editorun-secimi"}',
    'curated', 'fas fa-star', 200,
    '{"is_always":true}',
    '{"show_to_all":true}',
    1);

-- muzibu_collection_items (koleksiyon 1 için)
INSERT INTO muzibu_collection_items
  (collection_id, itemable_type, itemable_id, position) VALUES
(1, 'radio',    5, 1),   -- Jazz FM
(1, 'playlist', 12, 2),  -- Sabah Akustik
(1, 'playlist', 45, 3),  -- Kahve Molası
(1, 'album',    8, 4);   -- Cafe Classics albümü

// Sadece anasayfada çalışır. Framework yok. Interval yok.
(function(){
    var el = document.getElementById('feed-container');
    if (!el) return; // iç sayfalarda #feed-container yok → hiçbir şey yapma

    function refresh(){
        fetch('/api/feed-partial')
            .then(function(r){ return r.text() })
            .then(function(html){
                el.innerHTML = html;
                schedule();
            });
    }

    function schedule(){
        var d = new Date();
        var ms = (60 - d.getMinutes()) * 60000 - d.getSeconds() * 1000 + 60000;
        setTimeout(refresh, ms); // saat başı +1dk
    }

    setTimeout(refresh, {{ $msUntilNextHour }}); // ilk timeout (PHP hesaplar)
})();

class ContentCollection extends BaseModel
{
    use HasTranslations, Sluggable, HasMediaManagement, SoftDeletes;

    protected $connection = 'tenant';
    protected $table = 'muzibu_content_collections';
    protected $primaryKey = 'collection_id';

    public $translatable = ['title', 'slug', 'description'];

    protected $fillable = [
        'title', 'slug', 'description', 'type', 'icon', 'color',
        'media_id', 'display_rules', 'sector_rules', 'business_rules',
        'priority', 'is_active', 'is_featured', 'cache_ttl',
    ];

    protected $casts = [
        'display_rules'  => 'array',
        'sector_rules'   => 'array',
        'business_rules' => 'array',
        'priority'       => 'integer',
        'is_active'      => 'boolean',
        'is_featured'    => 'boolean',
        'cache_ttl'      => 'integer',
    ];

    // Koleksiyondaki öğeler (polimorfik)
    public function items(): HasMany
    {
        return $this->hasMany(CollectionItem::class, 'collection_id', 'collection_id')
                    ->orderBy('position');
    }

    // Aktif öğeler
    public function activeItems(): HasMany
    {
        return $this->items()->where('is_active', true);
    }

    // Scope: aktif koleksiyonlar
    public function scopeActive($q) { return $q->where('is_active', true); }
}

class CollectionItem extends Model
{
    protected $connection = 'tenant';
    protected $table = 'muzibu_collection_items';

    protected $fillable = [
        'collection_id', 'itemable_type', 'itemable_id', 'position', 'is_active',
    ];

    protected $casts = [
        'position'  => 'integer',
        'is_active' => 'boolean',
    ];

    // Polimorfik ilişki — Playlist, Album, Radio, Genre veya Sector
    public function itemable(): MorphTo
    {
        return $this->morphTo();
    }

    public function collection(): BelongsTo
    {
        return $this->belongsTo(ContentCollection::class, 'collection_id', 'collection_id');
    }
}

class SmartFeedService
{
    // Greeting (yukarıda detaylı açıklandı)
    public function getGreeting(User $user): array { /* ... */ }

    // Ana feed — filtrelenmiş koleksiyonlar
    public function getFeed(User $user): Collection
    {
        $hour     = now()->hour;
        $sectorId = $user->sector_id;
        $cacheKey = "smart_feed:{$user->id}:{$sectorId}:{$hour}";

        return Cache::remember($cacheKey, 300, function() use ($user, $hour) {
            return ContentCollection::active()
                ->with(['activeItems.itemable'])   // eager load
                ->orderByDesc('priority')
                ->get()
                ->filter(fn($c) => $this->matchesTimeRules($c, $hour))
                ->filter(fn($c) => $this->matchesSectorRules($c, $user))
                ->filter(fn($c) => $this->matchesBusinessRules($c, $user));
        });
    }

    // Filtre 1: Zaman kuralı
    private function matchesTimeRules(ContentCollection $c, int $hour): bool
    {
        $rules = $c->display_rules;
        if (empty($rules) || ($rules['is_always'] ?? true)) return true;

        $start = $rules['start_hour'] ?? 0;
        $end   = $rules['end_hour'] ?? 23;

        // Gece geçişi: start=22, end=6 → 22,23,0,1,2,3,4,5
        if ($start <= $end) {
            return $hour >= $start && $hour < $end;
        }
        return $hour >= $start || $hour < $end;
    }

    // Filtre 2: Sektör kuralı
    private function matchesSectorRules(ContentCollection $c, User $user): bool
    {
        $rules = $c->sector_rules;
        if (empty($rules) || ($rules['show_to_all'] ?? true)) return true;

        $sectorId  = $user->sector_id;
        $sectorIds = $rules['sector_ids'] ?? [];
        $mode      = $rules['mode'] ?? 'include';

        if ($mode === 'include') return in_array($sectorId, $sectorIds);
        if ($mode === 'exclude') return !in_array($sectorId, $sectorIds);
        return true;
    }

    // Filtre 3: İş kuralı
    private function matchesBusinessRules(ContentCollection $c, User $user): bool
    {
        $rules = $c->business_rules;
        if (empty($rules)) return true;

        $sub = $rules['subscription'] ?? 'all';
        if ($sub !== 'all') {
            // premium/corporate kontrol
            if ($sub === 'premium' && !$user->isPremium()) return false;
            if ($sub === 'corporate' && !$user->isCorporateMember()) return false;
        }
        return true;
    }
}

// routes/web.php (Muzibu domain group içinde)
Route::get('/api/feed-partial', function () {
    $user = auth()->user();
    if (!$user) abort(401);

    $service  = app(SmartFeedService::class);
    $greeting = $service->getGreeting($user);
    $feed     = $service->getFeed($user);

    return view('themes.muzibu.partials.feed-collections', compact('greeting', 'feed'));
})->middleware(['auth'])->name('muzibu.feed.partial');

<!-- Greeting -->
<div class="mb-6">
    <h2 class="text-2xl font-bold text-white">{{ $greeting['title'] }}</h2>
    <p class="text-slate-400">{{ $greeting['subtitle'] }}</p>
</div>

<!-- Koleksiyonlar -->
@foreach($feed as $collection)
    <div class="mb-8">
        <div class="flex justify-between items-center mb-3">
            <h3 class="text-lg font-bold text-white">
                @if($collection->icon)
                    <i class="{{ $collection->icon }} mr-2"></i>
                @endif
                {{ $collection->title }}
            </h3>
            @if($collection->activeItems->count() > 6)
                <a href="/koleksiyon/{{ $collection->slug }}" class="text-blue-400">
                    Tümü &rsaquo;
                </a>
            @endif
        </div>
        <div class="flex gap-4 overflow-x-auto pb-2">
            @foreach($collection->activeItems as $item)
                {{-- Her itemable_type'a göre farklı kart --}}
                @include('themes.muzibu.partials.collection-item-card', [
                    'item' => $item->itemable,
                    'type' => $item->itemable_type
                ])
            @endforeach
        </div>
    </div>
@endforeach

<!-- Mevcut statik içerik KALDIRILACAK -->
<!-- Yerine: -->

<div id="feed-container">
    @include('themes.muzibu.partials.feed-collections', [
        'greeting' => $greeting,
        'feed'     => $feed,
    ])
</div>

@push('scripts')
<script>
(function(){
    var el = document.getElementById('feed-container');
    if (!el) return;
    function refresh(){
        fetch('/api/feed-partial')
            .then(function(r){ return r.text() })
            .then(function(html){ el.innerHTML = html; schedule(); });
    }
    function schedule(){
        var d = new Date();
        var ms = (60 - d.getMinutes()) * 60000 - d.getSeconds() * 1000 + 60000;
        setTimeout(refresh, ms);
    }
    setTimeout(refresh, {{ $msUntilNextHour }});
})();
</script>
@endpush