<?php

namespace App\Http\Controllers\Api;

use App\Banner;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Auth;
use Carbon\Carbon;

class BannersApiController extends Controller
{
    public function getBanners($target, $typeAcademy = null)
    {
        $userId = Auth::user()->id;
        $now = Carbon::now();

        \Log::info('PARAMETROS BANERS:', [
            'target' => $target,
            'typeAcademy' => $typeAcademy,
            'type' => gettype($typeAcademy),
        ]);

        // --- BANNERS PARA USUARIO ---
        $bannersForUser = Banner::select('banners.*')
            ->leftjoin('banner_tags', 'banners.id', '=', 'banner_tags.banner_id')
            ->leftJoin('tags', function ($join) {
                $join->on('tags.id', '=', 'banner_tags.tag_id')
                    ->where('tags.active', 1);
            })
            ->leftjoin('user_tags', 'user_tags.tag_id', '=', 'banner_tags.tag_id')
            ->where(function ($q) use ($userId) {
                $q->where('user_tags.user_id', $userId)
                    ->orWhereNull('banner_tags.id')
                    ->orWhereNull('tags.id');
            })
            ->where('banners.active', 1)
            ->where('banners.target', 'LIKE', '%' . $target . '%')
            ->where(function ($query) use ($now) {
                $query->whereNull('banners.start_date')  // NO PROGRAMADOS
                    ->orWhere(function ($subQuery) use ($now) {     // PROGRAMADOS
                        $subQuery->where('banners.start_date', '<=', $now)
                            ->where('banners.end_date', '>=', $now);
                    });
            });

        // Filtro por tipo de academia
        if (!empty($typeAcademy)) {
            $bannersForUser->where(function ($q) use ($typeAcademy) {
                $q->where('banners.type_academy', $typeAcademy)
                    ->orWhere('banners.type_academy', 'all');
            });
        }

        // Orden final (fuera del where)
        $bannersForUser->orderBy('banners.order', 'ASC');

        // Ejecutar consulta
        $bannersForUser = $bannersForUser->get();

        // --- BANNERS GLOBALES (sin tags) ---
        $bannersForAll = Banner::select('banners.*')
            ->where('banners.active', 1)
            ->leftJoin('banner_tags', 'banners.id', '=', 'banner_tags.banner_id')
            ->whereNull('banner_tags.id')
            ->where('banners.target', 'LIKE', '%' . $target . '%')
            ->where(function ($query) use ($now) {
                $query->whereNull('banners.start_date')  // NO PROGRAMADOS
                    ->orWhere(function ($subQuery) use ($now) {    // PROGRAMADOS
                        $subQuery->where('banners.start_date', '<=', $now)
                            ->where('banners.end_date', '>=', $now);
                    });
            });

        // Filtro por tipo de academia
        if (!empty($typeAcademy)) {
            $bannersForAll->where(function ($q) use ($typeAcademy) {
                $q->where('banners.type_academy', $typeAcademy)
                    ->orWhere('banners.type_academy', 'all');
            });
        }

        // Orden final
        $bannersForAll->orderBy('banners.order', 'ASC');

        // Ejecutar consulta
        $bannersForAll = $bannersForAll->get();

        // --- UNIR RESULTADOS ---
        $result = $bannersForUser->merge($bannersForAll);

        return response()->json($result, 200);
    }
}