@php
  
  $registers = \App\LoadingRequest::withoutGlobalScope('userControler')
                                      ->select( 'loading_requests.clients_id', 'clients.fantasyName', 'loading_requests.booking', 
                                                'loading_requests.usuarios_id', 'usuarios.nome' , 'loading_requests.etaPol', 
                                                'loading_requests.incoterm', 'incoterms.description', 'loading_requests.freeTimeDestination')
                                      ->join('incoterms', 'incoterms.id', '=', 'loading_requests.incoterm')
                                      ->join('usuarios', 'usuarios.id', '=', 'loading_requests.usuarios_id')
                                      ->join('clients', 'clients.id', '=', 'loading_requests.clients_id')
                                      ->where('loading_requests.etaPol','>=', \Carbon\Carbon::now()->subDays(7)->format("Y-m-d"))
                                      ->whereIn('loading_requests.incoterm', [4,5])
                                      ->where('loading_requests.container_types_id', '<>',  8)
                                      ->where(function($q1) {
                                          $q1->whereIn('loading_requests.status', ['On Hold', 'Shipped'])
                                                  ->orWhere(function($q2) {
                                                          $q2->whereIn('loading_requests.status', ['Pending'])
                                                              ->where('loading_requests.clients_id', '<>', 41);
                                              });
                                      })
                                      ->where('loading_requests.SAOE', 'not like', "SAOI%")
                                      ->whereNull('loading_requests.freeTimeDestination')
                                      ->orderBy('loading_requests.clients_id')
                                      ->orderBy('loading_requests.booking')
                                      ->get();

@endphp


@component('mail::message', ['registers' => $registers])
# Relatório Semanal - Ausência de Free Time

@if( isset($registers[0]) )

@component('mail::table')
| Client    | Booking       | User      | Incoterm  | Etd Pol   |
|:------    |:-----------   |:--------  |:--------: |:--------: |
@foreach($registers as $register)
| {{$register->fantasyName ?? ''}}     | {{$register->booking ?? ''}} |        {{$register->nome ?? ''}} |        {{$register->description ?? ''}} |        {{(isset($register->etaPol) ? \Carbon\Carbon::parse($register->etaPol)->format('d/m/Y') : '')}} |
@endforeach
@endcomponent

@else
<br>Não há bookings sem registro do Free Time!
@endif



<br>

Esta é uma mensagem automática. Por favor, não responda.

@endcomponent