<?php

namespace App\Http\Controllers\Api;

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

class PopupEmbedApiController extends Controller
{
    public function get()
    {
        $userId = Auth::user()->id;
        $popUpsForUser = PopupEmbed::select('popup_embeds.*')
            ->leftjoin('popup_tags', 'popup_embeds.id', '=', 'popup_tags.popup_id')
            ->leftJoin('tags', function ($join) {
                $join->on('tags.id', '=', 'popup_tags.tag_id')
                    ->where('tags.active', 1);
            })
            ->leftjoin('user_tags', 'user_tags.tag_id', '=', 'popup_tags.tag_id')
            ->where(function ($q) use ($userId) {
                $q->where('user_tags.user_id', $userId)
                    ->orWhereNull('popup_tags.id')
                    ->orWhereNull('tags.id');
            })
            ->where('popup_embeds.active', true)
            ->get();

        $popUpsForAll = PopupEmbed::select('popup_embeds.*')
            ->leftjoin('popup_tags', 'popup_embeds.id', '=', 'popup_tags.popup_id')
            ->whereNull('popup_tags.id')
            ->where('popup_embeds.active', true)
            ->get();

        return response()->json($popUpsForUser->merge($popUpsForAll), 200);
    }

    public function getPopups($target, $typeAcademy = null)
    {
        $userId = Auth::user()->id;
        $now = Carbon::now();
        /*\Log::info('PARAMETROS POPUPS:', [
            'target' => $target,
            'typeAcademy' => $typeAcademy,
            'type' => gettype($typeAcademy),
        ]);*/
    //  Popups para el usuario
    $popUpsForUser = PopupEmbed::select('popup_embeds.*')
        ->leftJoin('popup_tags', 'popup_embeds.id', '=', 'popup_tags.popup_id')
        ->leftJoin('tags', function ($join) {
            $join->on('tags.id', '=', 'popup_tags.tag_id')
                 ->where('tags.active', 1);
        })
        ->leftJoin('user_tags', 'user_tags.tag_id', '=', 'popup_tags.tag_id')
        ->where(function ($q) use ($userId) {
            $q->where('user_tags.user_id', $userId)
              ->orWhereNull('popup_tags.id')
              ->orWhereNull('tags.id');
        })
        ->where('popup_embeds.active', true)
        ->where('popup_embeds.target', 'LIKE', '%' . $target . '%')
        ->where(function ($query) use ($now) {
            $query->whereNull('popup_embeds.start_date')
                  ->orWhere(function ($subQuery) use ($now) {
                      $subQuery->where('popup_embeds.start_date', '<=', $now)
                               ->where('popup_embeds.end_date', '>=', $now);
                  });
        });

    // Filtro de tipo de academia
    if (!empty($typeAcademy)) {
        $popUpsForUser->where(function ($q) use ($typeAcademy) {
            $q->where('popup_embeds.type_academy', $typeAcademy)
              ->orWhere('popup_embeds.type_academy', 'all');
        });
    }
    //Ejecuta la consulta
    $popUpsForUser = $popUpsForUser->get();

    // Popups globales (sin tags)
    $popUpsForAll = PopupEmbed::select('popup_embeds.*')
        ->leftJoin('popup_tags', 'popup_embeds.id', '=', 'popup_tags.popup_id')
        ->whereNull('popup_tags.id')
        ->where('popup_embeds.active', true)
        ->where('popup_embeds.target', 'LIKE', '%' . $target . '%')
        ->where(function ($query) use ($now) {
            $query->whereNull('popup_embeds.start_date')
                  ->orWhere(function ($subQuery) use ($now) {
                      $subQuery->where('popup_embeds.start_date', '<=', $now)
                               ->where('popup_embeds.end_date', '>=', $now);
                  });
        });

    if (!empty($typeAcademy)) {
        $popUpsForAll->where(function ($q) use ($typeAcademy) {
            $q->where('popup_embeds.type_academy', $typeAcademy)
              ->orWhere('popup_embeds.type_academy', 'all');
        });
    }
    // Ejecuta la consulta
    $popUpsForAll = $popUpsForAll->get();
    $popups = $popUpsForUser->merge($popUpsForAll);

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