<?php

namespace App\Http\Controllers\Api;

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

class CarnetApiController extends Controller
{
    public function getCarnets($show_in)
    {
        $user_id = Auth::user()->id;
        $now = Carbon::now();
        $carnetsForAll = Carnet::select('carnets.*')
            ->leftjoin('carnet_tags', 'carnets.id', '=', 'carnet_tags.carnet_id')
            ->leftjoin('user_tags', 'user_tags.tag_id', '=', 'carnet_tags.tag_id')
            ->where(function ($query) use ($user_id) {
                $query->where('user_tags.user_id', '=', $user_id)->orWhereNull('carnet_tags.id');
            })
            ->where('carnets.active', true)
            ->whereIn('carnets.show_in', ['all', $show_in])
            ->where(function ($query) use ($now) {
                $query->whereNull('carnets.start_date')  // NO PROGRAMADOS
                    ->orWhere(function ($subQuery) use ($now) {    // PROGRAMADOS
                        $subQuery->where('carnets.start_date', '<=', $now)
                            ->where('carnets.end_date', '>=', $now);
                    });
            })
            ->orderBy('created_at', 'desc')
            ->get();

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