HEX
Server: Apache/2.4.41 (Ubuntu)
System: Linux ip-172-31-42-149 5.15.0-1084-aws #91~20.04.1-Ubuntu SMP Fri May 2 07:00:04 UTC 2025 aarch64
User: ubuntu (1000)
PHP: 7.4.33
Disabled: pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
Upload Files
File: /var/www/vhost/disk-apps/qas.sports-crowd.com/app/Core/Carnet/Application/CarnetService.php
<?php

declare(strict_types=1);

namespace App\Core\Carnet\Application;

use App\Carnet;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;

class CarnetService
{
    public function getCarnets(Request $request, $show_in = null, $user_id = null, $academyUserId = null)
    {
        $now = Carbon::now();
        if (!$show_in) {
            $show_in = $request->input('show_in');
        }
        if (!$user_id) {
            $user_id = Auth::user()->id;
        }
        if (!$academyUserId && $request->has('academy_user_id')) {
            $academyUserId = $request->input('academy_user_id');
        }

        $carnetsForAll = Carnet::select('carnets.*')
            ->leftjoin('carnet_tags', 'carnets.id', '=', 'carnet_tags.carnet_id')
            ->leftjoin('user_tags', 'user_tags.tag_id', '=', 'carnet_tags.tag_id')
            ->leftjoin('tags', function ($join) {
                $join->on('tags.id', '=', 'carnet_tags.tag_id')->where('tags.active', 1);
            })
            ->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);
                    });
            })
            ->when($academyUserId, function ($query) use ($academyUserId) {
                $query->where(function ($q) use ($academyUserId) {
                    $q->where('user_tags.academy_user_id', $academyUserId)->orWhereNull('user_tags.academy_user_id');
                });
            })
            ->groupBy('carnets.id')
            ->orderBy('created_at', 'desc')
            ->get();

        return $carnetsForAll;
    }
}