@extends('layout.padrao')
@section('title', 'Delivery Control')
@section('content')

@if($errors->any())
    <div class="alert alert-danger" role="alert">
        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
            <span aria-hidden="true">×</span>
        </button>
        @foreach($errors->all() as $error)
            {{ $error }}<br/>
        @endforeach
    </div>
@endif



<form method="GET" action="{{route('fullemptydeliverycontrol.index')}}">
    <div class="row folha-interna shadow col col-lg-12 col-sm-12 col-md-12 p-3 mb-5 rounded folha-branca-contornada" id="folha-interna-white">

        <!-- Inputs -->

        <div class="col-2" style="position:absolute">
            <h5>Select a Plan:</h5>
            <input type="radio" id="bookingRadio" onclick="javascript:planCheck();" name="loadingType" value="BKP" checked>
            <label class="noBold" for="bookingRadio" style="font-weight: normal">Booking Plan</label><br>
            <input type="radio" id="logisticsRadio" onclick="javascript:planCheck();" name="loadingType" value="LGP" {{ old('loadingType', app('request')->input('loadingType')) == 'LGP' ? 'checked' : ''  }}>
            <label class="noBold" for="logisticsRadio" style="font-weight: normal">Logistics Plan</label><br>
        </div>


        <div class="col-2" style="margin-left:8%">
            <div class="col @error('etaPolFromInput') has-error @enderror">
                <label for="etaPolFromInput" class="w-100 control-label">ETD Pol From</label>
                <input class="form-control" type="date" min="2019-01-01" max="2080-01-01" id="etaPolFromInput" name="etaPolFromInput" value="{{ old('etaPolFromInput', app('request')->input('etaPolFromInput')) }}">
            </div>
            <div class="col">
                <label for="clientSelect" class="w-100 control-label">Client</label>
                {{-- {{ old('clientSelect') != null ? dd(old('clientSelect')) : '' }} --}}
                <select class="js-client-Select form-control" name="clientSelect[]" multiple="multiple" style="min-width:300px;">
                    @foreach($select['clientTypes2'] as $Key_client => $value_client)
                        <option value="{{$Key_client}}"   {{ (in_array($Key_client,  old('clientSelect', app('request')->input('clientSelect')) ?? []  )) ? 'selected' : ''}}   >{{ $value_client }}</option>
                    @endforeach
                </select>
            </div>
        </div>
        <div class="col-2">
            <div class="col @error('etaPolFromInput') has-error @enderror">
                <label for="etaPolToInput" class="w-100 control-label">ETD Pol To</label>
                <input class="form-control" type="date" min="2019-01-01" max="2080-01-01" id="etaPolToInput" name="etaPolToInput"  value="{{ old('etaPolToInput', app('request')->input('etaPolToInput')) }}">
            </div>
            <div class="col">
                <label for="carrierSelect" class="w-100 control-label">Carrier</label>
                <select class="js-carrier-Select form-control" name="carrierSelect[]" multiple="multiple" style="min-width:300px;">
                    @foreach($select['carriers2'] as $Key_carrier => $value_carrier)
                    <option value="{{$Key_carrier}}"  {{ (in_array($Key_carrier,  old('carrierSelect', app('request')->input('carrierSelect')) ?? []  )) ? 'selected' : ''}}  >{{ $value_carrier }}</option>
                    @endforeach
                </select>
            </div>
        </div>
        <div class="col-2">
            <div class="col display-invisivel" id="haulingDisplay">
                <label for="haulingSelect" class="w-100 control-label">Hauling </label>
                <select class="js-hauling-Select form-control" name="haulingSelect[]" multiple="multiple" style="min-width:300px;">
                    @foreach($select['haulings2'] as $Key_hauling => $value_hauling)
                    <option value="{{$Key_hauling}}"   {{ (in_array($Key_hauling,  old('haulingSelect', app('request')->input('haulingSelect')) ?? []  )) ? 'selected' : ''}}  >{{ $value_hauling }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col">
                <label for="loadingTerminalSelect" class="w-100 control-label">Loading Terminal</label>
                <select class="js-loadingTerminal-Select form-control" name="loadingTerminalSelect[]" multiple="multiple" style="min-width:300px;">
                    @foreach($select['loadingTerminals2'] as $Key_loading => $value_loading)
                    <option value="{{$Key_loading}}"  {{ (in_array($Key_loading,  old('loadingTerminalSelect', app('request')->input('loadingTerminalSelect')) ?? []  )) ? 'selected' : ''}} >{{ $value_loading }}</option>
                    @endforeach
                </select>
            </div>
        </div>
        <div class="col-2">
            <div class="col display-invisivel" id="stuffingDisplay">
                <label for="stuffingTerminalSelect" class="w-100 control-label">Stuffing Terminal</label>
                <select class="js-stuffingTerminal-Select form-control" name="stuffingTerminalSelect[]" multiple="multiple">
                    @foreach($select['stuffingTerminal2'] as $Key_stuffing => $value_stuffing)
                    <option value="{{$Key_stuffing}}"  {{ (in_array($Key_stuffing,  old('stuffingTerminalSelect', app('request')->input('stuffingTerminalSelect')) ?? []  )) ? 'selected' : ''}} >{{ $value_stuffing }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col display-invisivel" id="tankDisplay">
                <label for="tankOwnerSelect" class="w-100 control-label">Tank Owner</label>
                <select class="js-tankOwner-Select form-control" name="tankOwnerSelect[]" multiple="multiple">
                    @foreach($select['tankOwners2'] as $Key_tankOwners => $value_tankOwners)
                    <option value="{{$Key_tankOwners}}"  {{ (in_array($Key_tankOwners,  old('tankOwnerSelect', app('request')->input('tankOwnerSelect')) ?? []  )) ? 'selected' : ''}} >{{ $value_tankOwners }}</option>
                    @endforeach
                </select>
            </div>
        </div>

        <!-- Search, cancel and icon -->
        <div class="col-2" style="text-align: right; margin-top:2%">
        <div class="col" style="height:40px;"></div>
            <button class="btn btn-style" type="submit" style="margin-right: 2%;">Search</button>
            <button class="btn btn-style" type="button"  onClick="reload()" style="margin-right: 1%;">Cancel</button>
             {{-- <button title="Export" name="btnExport" value="all" style='width:50px;' class="btn">
                <i class="fas fa-download icon-style" style="font-size: 25px; margin-right: 2%"></i>
            </button>             --}}
        </div>

        <div class="col" style="text-align: right; margin-top:1%; margin-rigth:1%">
            <div>
                <img src="{!! asset('/image/csa_Logo.png') !!}" style="height: 78px; width: 85px;" alt="">
            </div>
        </div>
    </div>


    <h2 id="bookingTitle" class="">Equipment & Delivery Control - Booking Plan</h2>
    <h2 id="logisticsTitle" class="display-invisivel">Equipment & Delivery Control - Logistics Plan</h2>


    @forelse ($loadingRequestsGroupByClients as $lrGroupByClient)

        <div class="row folha-interna shadow col col-lg-12 col-sm-12 col-md-12 p-3 mb-5 rounded folha-branca-contornada"
            id="clientTable" style="margin-bottom: 1%;">
            <div class="row folha-interna shadow col col-lg-12 col-sm-12 col-md-12 p-3 mb-5 rounded  "
                style="background: #fff !important;">
                <div class="col" style="margin-top:10px; margin-left: 10px">
                    CLIENT:
                    <label id="clientLabel">{{$lrGroupByClient->clients_id}} - {{$lrGroupByClient->clients->fantasyName ?? $lrGroupByClient->clients->name }}</label>
                </div>
                <div class="col" style="text-align: right">
                    TOTAL QTY

                    <div class="btn btn-style" id="numberQtyLabel" name="numberQtyLabel[]"
                        style="width: 50px; margin-right: 10px; margin-left: 10px">{{$lrGroupByClient->total}}</div>

                    <button title="Export" name="btnExport" value="client:{{$lrGroupByClient->clients_id}}" style='width:50px;' class="btn">
                        <i class="fas fa-download icon-style" style="font-size: 25px; margin-right: 6%"></i>
                    </button>
                </div>
            </div>

            <!-- Tabela de clientes -->

            <table class="table table-responsive-md bg-white table-striped table-hover"
                style="box-shadow: 3px 3px 15px #e6e6e6; margin-left: 1%; margin-right: 1%">
                <thead>
                    <tr style="border-top: 5px solid #3686ef">
                        <th scope="col" style="text-align: center;">Booking</th>
                        <th scope="col" style="text-align: center;">Shipper Ref.</th>
                        <th scope="col" style="text-align: center;">Product</th>
                        <th scope="col" style="text-align: center;">Vessel</th>
                        <th scope="col" style="text-align: center;">Carrier</th>
                        <th scope="col" style="text-align: center;">POL</th>
                        <th scope="col" style="text-align: center;">ETD POL</th>
                        <th scope="col" style="text-align: center;">Cargo Cut off Date</th>
                        <th scope="col" style="text-align: center;">Cargo Cut off Time</th>
                        <th scope="col" style="text-align: center;">Loading Terminal</th>
                        <th scope="col" style="text-align: center;">Equipment Type</th>
                        <th scope="col" style="text-align: center;">Equipment Qty</th>                        
                        <th scope="col" style="text-align: center;">Tank Owner</th>
                        <th scope="col" style="text-align: center;">Qty</th>
                        <th scope="col" style="text-align: center;">Empty Release Date</th>                                                
                    </tr>
                </thead>
                <tbody>
                    @foreach ($loadingRequestsAll->where('clients_id', $lrGroupByClient->clients_id) as $loadingrequest)

                        <tr class="centralizedObject">
                            <td scope="row" class="centralizedObject">{{$loadingrequest->booking ?? ''}}</td>
                            <td>{{$loadingrequest->shipperReference ?? ''}}</td>
                            <td>{{$loadingrequest->platforms->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->vessel->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->carriers->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->loading_ports->descricao ?? ''}}</td>
                            <td>{{ (isset($loadingrequest->etaPol) ? \Carbon\Carbon::parse($loadingrequest->etaPol)->format('d/m/Y') : '') }}</td>
                            <td>{{ (isset($loadingrequest->cargoCutoffDate) ? \Carbon\Carbon::parse($loadingrequest->cargoCutoffDate)->format('d/m/Y') : '') }}</td>
                            <td>{{$loadingrequest->cargoCutofftime ?? ''}}</td>
                            <td>{{$loadingrequest->loading_terminals->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->container_types->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->containerQty ?? ''}}</td>                            

                            <td>{{$loadingrequest->loading_empties_tank[0]->descricao ?? ''}}</td>                            
                            <td>{{$loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseQty ?? ''}} </td>                                                  
                            <td>{{ (isset($loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseDate) ? \Carbon\Carbon::parse($loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseDate)->format('d/m/Y') : '') }}</td>
                        </tr>        
                        
                        @if ($loadingrequest->loading_empties_tank->count() > 1)
                            
                            @foreach ($loadingrequest->loading_empties_tank as $key => $tankOwner )
                                @if ($key == 0) @continue @endif
                                
                                <tr class="centralizedObject">
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
        
                                    <td>{{$tankOwner->descricao ?? ''}}</td>                            
                                    <td>{{$tankOwner->pivot->emptyReleaseQty ?? ''}} </td>                                                  
                                    <td>{{ (isset($tankOwner->pivot->emptyReleaseDate) ? \Carbon\Carbon::parse($tankOwner->pivot->emptyReleaseDate)->format('d/m/Y') : '') }}</td>
                                </tr>   


                            @endforeach
                        @endif


                    @endforeach
                </tbody>
            </table>
        </div>

    @empty

    @endforelse

    @forelse ($loadingRequestsGroupByHaulings as $lrGroupByHauling)

        @php if (!isset($lrGroupByHauling->hauling_id)) continue;  @endphp

        <!-- Hauling -->
        <div class="row folha-interna shadow col col-lg-12 col-sm-12 col-md-12 p-3 mb-5 rounded folha-branca-contornada"  id="haulingTable" style="margin-bottom: 1%;">
            <div class="row folha-interna shadow col col-lg-12 col-sm-12 col-md-12 p-3 mb-5 rounded  " id="folha-interna-white"
                style="background: #fff !important;">
                <div class="col" style="margin-top:10px; margin-left: 10px;">
                    HAULING:
                    <label>{{$lrGroupByHauling->hauling_id}} - 
                        {{$lrGroupByHauling->hauling->fantasyName ?? $lrGroupByHauling->hauling->name }}
                    </label>
                </div>
                <div class="col" style="text-align: right">
                    TOTAL QTY
                    <div class="btn btn-style" id="numberQtyLabel" name="numberQtyLabel[]">{{$lrGroupByHauling->total}}</div>
                    <button title="Export" name="btnExport" value="hauling:{{$lrGroupByHauling->hauling_id}}" style='width:50px;' class="btn">
                        <i class="fas fa-download icon-style" style="font-size: 25px; margin-right: 6%"></i>
                    </button>
                </div>
            </div>

            <table class="table table-responsive-md bg-white table-striped table-hover"
                style="box-shadow: 3px 3px 15px #e6e6e6; margin-left: 1%; margin-right: 1%">
                <thead>
                    <tr style="border-top: 5px solid #3686ef">
                        <th scope="col" style="text-align: center;">Client</th>
                        <th scope="col" style="text-align: center;">Booking</th>
                        <th scope="col" style="text-align: center;">Product</th>
                        <th scope="col" style="text-align: center;">Vessel</th>
                        <th scope="col" style="text-align: center;">Carrier</th>
                        <th scope="col" style="text-align: center;">POL</th>
                        <th scope="col" style="text-align: center;">ETD POL</th>
                        <th scope="col" style="text-align: center;">Cargo Cut off Date</th>
                        <th scope="col" style="text-align: center;">Cargo Cut off Time</th>
                        <th scope="col" style="text-align: center;">Loading Terminal</th>
                        <th scope="col" style="text-align: center;">Equipment Type</th>
                        <th scope="col" style="text-align: center;">Equipment Qty</th>                        
                        <th scope="col" style="text-align: center;">Tank Owner</th>
                        <th scope="col" style="text-align: center;">Qty</th>
                        <th scope="col" style="text-align: center;">Empty Release Date</th>    
                    </tr>
                </thead>
                <tbody>
                    @foreach ($loadingRequestsAll->where('hauling_id', $lrGroupByHauling->hauling_id) as $loadingrequest)
                        <tr class="centralizedObject">
                            <td scope="row" class="centralizedObject">{{$loadingrequest->clients->fantasyName ?? ''}}</td>
                            <td>{{$loadingrequest->booking ?? ''}}</td>
                            <td>{{$loadingrequest->platforms->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->vessel->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->carriers->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->loading_ports->descricao ?? ''}}</td>
                            <td>{{ (isset($loadingrequest->etaPol) ? \Carbon\Carbon::parse($loadingrequest->etaPol)->format('d/m/Y') : '') }}</td>
                            <td>{{ (isset($loadingrequest->cargoCutoffDate) ? \Carbon\Carbon::parse($loadingrequest->cargoCutoffDate)->format('d/m/Y') : '') }}</td>
                            <td>{{$loadingrequest->cargoCutofftime ?? ''}}</td>
                            <td>{{$loadingrequest->loading_terminals->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->container_types->descricao ?? ''}}</td>
                            <td>{{$loadingrequest->containerQty ?? ''}}</td>                            

                            <td>{{$loadingrequest->loading_empties_tank[0]->descricao ?? ''}}</td>                            
                            <td>{{$loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseQty ?? ''}} </td>                                                  
                            <td>{{ (isset($loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseDate) ? \Carbon\Carbon::parse($loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseDate)->format('d/m/Y') : '') }}</td>
                        </tr>        
                        
                        @if ($loadingrequest->loading_empties_tank->count() > 1)
                            
                            @foreach ($loadingrequest->loading_empties_tank as $key => $tankOwner )
                                @if ($key == 0) @continue @endif
                                
                                <tr class="centralizedObject">
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
        
                                    <td>{{$tankOwner->descricao ?? ''}}</td>                            
                                    <td>{{$tankOwner->pivot->emptyReleaseQty ?? ''}} </td>                                                  
                                    <td>{{ (isset($tankOwner->pivot->emptyReleaseDate) ? \Carbon\Carbon::parse($tankOwner->pivot->emptyReleaseDate)->format('d/m/Y') : '') }}</td>
                                </tr>   


                            @endforeach
                        @endif

                    @endforeach
                </tbody>
            </table>
        </div>
    @empty
    @endforelse

    @forelse ($loadingRequestsGroupByStuffingTerminal as $lrGroupByStuffingTerminal)
        <!-- Stuffing Terminal -->
        <div class="row folha-interna shadow col col-lg-12 col-sm-12 col-md-12 p-3 mb-5 rounded folha-branca-contornada"
            id="stuffingTable" style="margin-bottom: 1%; ">
            <div class="row folha-interna shadow col col-lg-12 col-sm-12 col-md-12 p-3 mb-5 rounded  " id="folha-interna-white"
                style="background: #fff !important;">
                <div class="col" style="margin-top:10px; margin-left: 10px;">
                    STUFFING TERMINAL:
                    <label id="clientLabel" name="clientLabel[]">{{$lrGroupByStuffingTerminal->stuffing_terminals_id}} - {{ ($lrGroupByStuffingTerminal->fantasyName ?? ($lrGroupByStuffingTerminal->name ?? '' ))}}</label>
                </div>

                @php $total = 0; @endphp
                @foreach ($loadingRequestsStuffingTerminal->where('stuffing_terminals_id', $lrGroupByStuffingTerminal->stuffing_terminals_id) as $stuffingTerminals)
                    @foreach ($loadingRequestsAll->where('id', $stuffingTerminals->loading_requests_id) as $loadingrequest)
                        @php $total++; @endphp
                    @endforeach
                @endforeach                    

                <div class="col" style="text-align: right">
                    TOTAL QTY
                    <div class="btn btn-style" id="numberQtyLabel" name="numberQtyLabel[]"
                        style="width: 50px; margin-right: 10px; margin-left: 10px">{{ $total ?? '0'  }}</div>

                    <button title="Export" name="btnExport" value="stuffingTerminal:{{$lrGroupByStuffingTerminal->stuffing_terminals_id}}" style='width:50px;' class="btn">
                        <i class="fas fa-download icon-style" style="font-size: 25px; margin-right: 6%"></i>
                    </button>
                </div>
            </div>

            <table class="table table-responsive-md bg-white table-striped table-hover"
                style="box-shadow: 3px 3px 15px #e6e6e6; margin-left: 1%; margin-right: 1%">
                <thead>
                    <tr style="border-top: 5px solid #3686ef">
                        <th scope="col" style="text-align: center;">Client</th>
                        <th scope="col" style="text-align: center;">Booking</th>
                        <th scope="col" style="text-align: center;">Product</th>
                        <th scope="col" style="text-align: center;">Vessel</th>
                        <th scope="col" style="text-align: center;">Carrier</th>
                        <th scope="col" style="text-align: center;">POL</th>
                        <th scope="col" style="text-align: center;">ETD POL</th>
                        <th scope="col" style="text-align: center;">Cargo Cut off Date</th>
                        <th scope="col" style="text-align: center;">Cargo Cut off Time</th>
                        <th scope="col" style="text-align: center;">Loading Terminal</th>
                        <th scope="col" style="text-align: center;">Equipment Type</th>
                        <th scope="col" style="text-align: center;">Equipment Qty</th>                        
                        <th scope="col" style="text-align: center;">Tank Owner</th>
                        <th scope="col" style="text-align: center;">Qty</th>
                        <th scope="col" style="text-align: center;">Empty Release Date</th> 
                    </tr>
                </thead>
                <tbody>
                    
                    @foreach ($loadingRequestsStuffingTerminal->where('stuffing_terminals_id', $lrGroupByStuffingTerminal->stuffing_terminals_id) as $stuffingTerminals)
                    
                        @foreach ($loadingRequestsAll->where('id', $stuffingTerminals->loading_requests_id) as $loadingrequest)

                            <tr class="centralizedObject">
                                <td scope="row" class="centralizedObject">{{$loadingrequest->clients->fantasyName ?? ''}}</td>
                                <td>{{$loadingrequest->booking ?? ''}}</td>
                                <td>{{$loadingrequest->platforms->descricao ?? ''}}</td>
                                <td>{{$loadingrequest->vessel->descricao ?? ''}}</td>
                                <td>{{$loadingrequest->carriers->descricao ?? ''}}</td>
                                <td>{{$loadingrequest->loading_ports->descricao ?? ''}}</td>
                                <td>{{ (isset($loadingrequest->etaPol) ? \Carbon\Carbon::parse($loadingrequest->etaPol)->format('d/m/Y') : '') }}</td>
                                <td>{{ (isset($loadingrequest->cargoCutoffDate) ? \Carbon\Carbon::parse($loadingrequest->cargoCutoffDate)->format('d/m/Y') : '') }}</td>
                                <td>{{$loadingrequest->cargoCutofftime ?? ''}}</td>
                                <td>{{$loadingrequest->loading_terminals->descricao ?? ''}}</td>
                                <td>{{$loadingrequest->container_types->descricao ?? ''}}</td>
                                <td>{{$loadingrequest->containerQty ?? ''}}</td>                            
    
                                <td>{{$loadingrequest->loading_empties_tank[0]->descricao ?? ''}}</td>                            
                                <td>{{$loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseQty ?? ''}} </td>                                                  
                                <td>{{ (isset($loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseDate) ? \Carbon\Carbon::parse($loadingrequest->loading_empties_tank[0]->pivot->emptyReleaseDate)->format('d/m/Y') : '') }}</td>
                            </tr>        
                            
                            @if ($loadingrequest->loading_empties_tank->count() > 1)
                                
                                @foreach ($loadingrequest->loading_empties_tank as $key => $tankOwner )
                                    @if ($key == 0) @continue @endif
                                    
                                    <tr class="centralizedObject">
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
                                        <td></td>
            
                                        <td>{{$tankOwner->descricao ?? ''}}</td>                            
                                        <td>{{$tankOwner->pivot->emptyReleaseQty ?? ''}} </td>                                                  
                                        <td>{{ (isset($tankOwner->pivot->emptyReleaseDate) ? \Carbon\Carbon::parse($tankOwner->pivot->emptyReleaseDate)->format('d/m/Y') : '') }}</td>
                                    </tr>   
    
    
                                @endforeach
                            @endif



                        @endforeach
                    @endforeach
                </tbody>
            </table>
        </div>


    @empty

    @endforelse


</form>



@include('fullEmptyDeliveryControl.script')

@endsection