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;
}
}