@extends('layout.padrao')
@section('title', 'Invoiced Processes')


@section('content')

    <style>
        .mdIcons, .thMini{
            width:100px !important; 
            min-width:100px !important; 
            max-width:100px !important;
        }

        .miniIcons{
            width:50px !important; 
            min-width:50px !important; 
            max-width:50px !important;
        }

        .thInfo{
            width:165px !important; 
            min-width:165px !important; 
            max-width:165px !important;
        }

        .d-flex.justify-content-center{
            margin-top: 10px;
        }

        .ul-inside-table {
            padding-inline-start: 0;
        }
        .ul-inside-table > li {
            list-style: none;
            width: 50%;
            display: inline-block;
            padding-inline-start: 0 !important;
        }

    </style>

    <div class="col col-lg-12 col-sm-12 col-md-12">
        <h5>Search For:</h5>
        <div class="col col-lg-12 col-sm-12 col-md-12" style="margin-bottom:65px;margin-top:33px">
            <form class="form-inline w-100 search-listas-int" method="GET" action="{{ route('InvoicedProcesses','finance') }}">
                {!! Form::text('tipo', 'confirmation', ['class' => 'form-control', 'hidden'=>'hidden']) !!}    
                <label for="from" style="margin-right: 5px !important; font-weight: normal; color:black !important;">From:</label>
                <input type="date" min="2019-01-01" max="2080-01-01" class="form-control start_date" style = 'padding: 6px;width: 220px !important; margin-right: 15px;' type="search" placeholder="BL Date " name="dt_start">   
                <label for="from" style="margin-right: 5px !important; font-weight: normal; color:black !important;">To:</label>
                <input type="date" min="2019-01-01" max="2080-01-01" class="form-control end_date" style = 'padding: 6px;width: 220px !important; margin-right: 15px;' type="search" placeholder="BL Date " name="dt_end">   
                <input class="form-control" style = 'width: 445px !important; margin-right: 15px;' type="search" placeholder="Search by: Fantasy Name, User Name, Booking Number, SAOE or Vessel  " name="finance">   
                <label for="from" style="margin-right: 5px !important; font-weight: normal; color:black !important;">Country:</label>
                {!! Form::select('country', $select['country'], null, ['class' => 'form-control']) !!}
                <label for="from" style="margin-right: 5px !important; margin-left: 5px !important; font-weight: normal; color:black !important;">User:</label>
                {!! Form::select('usuarios_id', $select['usuarios'], null, ['class' => 'form-control']) !!}

                <button class="btn btn-primary " type="submit" style = 'margin-left: 15px;'>Search</button>
            </form> 
        </div>
    </div>

<small id="total" class="form-text text-info">Showing last {{$total['processos']}} Invoiced Processes</small>
    @include('include.filtro_result')       
    
    <div class="table-responsive" style="overflow:clip; white-space: nowrap; height:950px">
        <table class="table table-striped text-center" style="font-size: 1.0rem;" 
        id="table"
        data-toggle="table"
        data-show-columns="true"
        data-show-fullscreen="true"
        data-search="true"
        data-show-export="true"
        data-export-data-type="all"
        data-pagination="false"
        data-click-to-select="true"
        data-toolbar="#toolbar"
        data-height="900"
        data-show-toggle="true"
        data-show-columns="true" >
            <thead>
                <tr class="aling-th" style="font-size: 1.0rem;">
                    {{-- data-force-hide="true" remove a coluna do export pdf --}}
                    {{-- data-force-export="true" adiciona a coluna hidden do export pdf --}}
                    <th class="icon-action miniIcons" data-force-hide="true"></th>
                    <th class="icon-action miniIcons" data-force-hide="true"></th>
                    <th class="thMini" data-field="SAOE" data-sortable="true">Process <br> Number</th>
                    <th class="thMini" data-sortable="true">Booking</th>
                    <th data-force-hide="true" class="icon-action mdIcons">Brazilian<br>Invoicing</th>
                    <th data-force-export="true" data-visible="false">Brazilian Invoicing</th>
                    <th data-force-hide="true" class="icon-action mdIcons">CSA Swiss<br>Invoicing</th>
                    <th data-force-export="true" data-visible="false">CSA Swiss Invoicing</th>
                    <th data-force-hide="true" class="icon-action mdIcons">Spot<br>Sales</th>  
                    <th data-force-export="true" data-visible="false">Spot Sales</th>                      
                    <th class="thMini" data-field="clients_id" data-sortable="true">Client</th>
                    <th class="thMini" data-sortable="true">Product</th>
                    <th class="thInfo" data-sortable="true">Carrier</th>
                    <th class="thInfo" data-sortable="true">Vessel</th>
                    <th class="thInfo" nowrap>Qty - Equipment</th>
                    <th class="thInfo" data-sortable="true">POL</th>
                    <th class="thInfo" data-sortable="true">POD</th>
                    <th class="thInfo" data-sortable="true">Flexi</th>
                    <th class="thInfo" data-sortable="true">BL Date</th>
                    <th data-force-hide="true" class="thInfo" data-sortable="true">Pricing Date</th>
                    <th class="thInfo" data-sortable="true">Loading Confirmation <br> Sent</th>
                    <th class="thInfo" data-sortable="true">Incoterm</th>
                    <th class="thInfo">Gross Weight</th>

                    <th data-force-export="true" data-visible="false" class="thInfo">BL Number</th>
                    <th data-force-export="true" data-visible="false" class="thInfo">ETD Inicial</th>
                    <th data-force-export="true" data-visible="false">Message</th>
                    <th data-force-hide="true" class="thMini">Freight  <br>Invoicing</th>
                    <th data-force-export="true" data-visible="false">Freight Invoicing</th>
                    <th data-force-hide="true" class="thMini">Local<br>Charges</th>
                    <th data-force-export="true" data-visible="false">Local Charges</th>
                    <th data-force-hide="true" class="thMini">Hauling<br>Invoicing</th>
                    <th data-force-export="true" data-visible="false">Hauling Invoicing</th>
                    <th data-force-hide="true" class="thMini">Stuffing<br>Invoicing</th>
                    <th data-force-export="true" data-visible="false">Stuffing Invoicing</th>
                    <th data-force-hide="true" class="thMini">Iso/Flexi<br>Invoicing</th>
                    <th data-force-export="true" data-visible="false">Iso/Flexi Invoicing</th>
                    <th data-force-hide="true" class="thMini">Insurance</th>
                    <th data-force-export="true" data-visible="false">Insurance</th>
                    <th data-force-hide="true" class="thMini">Box Fee</th>
                    <th data-force-export="true" data-visible="false">Box Fee</th>
                    <th class="thInfo" data-sortable="true">User finance Responsible</th>
                </tr>
            </thead>
            <tbody>
                @foreach($registers as $key => $item)

                    @if(!$loop->first && $item->id == $registers[$loop->index - 1]->id)
                        @continue
                    @endif
                    <tr>
                        <td>
                            <a href="#" onclick="show('<br />
<b>Warning</b>:  Undefined variable $item in <b>/home/tabexc29/qa.tabex.com.br/resources/views/finance/invoicedProcesses.blade.php</b> on line <b>136</b><br />
<br />
<b>Warning</b>:  Attempt to read property "id" on null in <b>/home/tabexc29/qa.tabex.com.br/resources/views/finance/invoicedProcesses.blade.php</b> on line <b>136</b><br />
');" class="icone-padding"  data-toggle="modal" data-target="#invoicingModal" >
                                <i class="fas fa-eye fa-lg"></i>
                            </a>
                        </td>
                        <td>
                            <a class="icone-padding" href="{{ route('loadingConfirmation', ['id' => $item->id, 'loadingType'=>'BL']) }}">
                                <i class="fas fa-anchor fa-lg" style="color:green;"></i>
                            </a>
                        </td>
                      
                        <td>{{ $item->SAOE }}</td>
                        <td>{{ $item->booking }}</td>
                        <td>
                            <a class="icone-padding" href="{{ route('brazillianInvoice', ['id' => $item->id, 'loadingType'=>'FNCB']) }}"> 
                                <i class="fas fa-dollar-sign fa-lg" style="color:{{$item->finance_controls->pluck('brazilianInvoice')->implode(' ') == 'Done' ? 'green' :( $item->finance_controls->pluck('brazilianInvoice')->implode(' ') == 'N/A' ? 'red':'#007bff')}};"></i>
                            </a>
                        </td>
                        <td>
                            {{$item->finance_controls->pluck('brazilianInvoice')->implode(' ') ?: 'ﾠ-ﾠ'}}
                        </td>
                        <td>
                            <ul class="ul-inside-table">
                                <li class="list-inside-table">
                                    <a class="icone-padding" href="{{ route('suisseInvoice', ['id' => $item->id, 'loadingType'=>'FNCI']) }}">    
                                        <i class="fas fa-file-invoice-dollar fa-lg" style="color:{{$item->finance_controls->pluck('suisseInvoice')->implode(' ') == 'Done' ? 'green' :( $item->finance_controls->pluck('suisseInvoice')->implode(' ') == 'N/A' ? 'red':'#007bff')}};"></i>
                                    </a>
                                </li>
                                <li class="list-inside-table">
                                    @if (isset($item->finance_controls[0]->pricing_message) && $item->finance_controls[0]->pricing_message != null)
                                        <a class="icone-padding tool-information" data-toggle="tooltipDetail" data-placement="right" rel="tooltip"
                                            data-html="true" 
                                            title="Additional Information <br> <br> <p> {!!utf8_encode($item->finance_controls[0]->pricing_message)!!}</p>">
                                            <i class="fas fa-exclamation-triangle" style="min-width:1px; color:{{$item->finance_controls[0]->pricing_color}};"></i>
                                        </a>
                                    @endif       
                                       
                                </li>
                            </ul>
                        </td>
                        <td>
                            {{$item->finance_controls->pluck('suisseInvoice')->implode(' ') ?: 'ﾠ-ﾠ'}}
                        </td>
                        <td>
                            @isset ($item->spotSales[0])
                                <a class="icone-padding" href="{{ route('spotSales.show', $item->id) }}">
                                    <i class="fas fa-map-marker-alt" style="color:green;"></i>
                                </a> 
                            @endisset
                        </td>   
                        <td>
                            @if(isset($item->spotSales[0]))
                                Yes
                            @else
                                No
                            @endif
                        </td>                      
                        <td nowrap class="icone-padding tool-information" data-toggle="tooltipDetail" data-placement="top" data-html="true" data-caitd="{{$item->id}}"> {{ str_limit($item->clients->fantasyName, $limit = 11, $end = '...')  }}</td>
                        <td>{{ $item->platforms->descricao }}</td>                        
                        <td>{{ $item->carriers->descricao }}</td>
                        <td>{{ $item->vessel->descricao }}</td>
                        <td>{{ $item->containerQty}} x {{ $item->container_types->descricao }}</td>
                        <td>{{ str_replace(', BRAZIL', '', $item->loading_ports->descricao) }}</td>                        
                        <td nowrap class="icone-padding tool-information" data-toggle="tooltipDetail" data-placement="top" data-html="true" data-caitd="{{$item->id}}"> {{ str_limit($item->code_of_ports1->place, $limit = 8, $end = '...')  }} </td>
                        <td>{{ $item->has_flexitank ?? 'ﾠ-ﾠ' }} </td>
                        <td nowrap>{{ date( 'd-m-Y' , strtotime($item->loading_confirmations[0]->BlDate)) }}</td>
                        <td nowrap>{{ (isset($item->finance_controls[0]->pricing_date) && $item->finance_controls[0]->pricing_date != null ? date( 'd-m-Y' , strtotime($item->finance_controls[0]->pricing_date)) : 'ﾠ-ﾠ') }}</td>
                        <td nowrap>{{ date( 'd-m-Y' , strtotime($item->loading_confirmations[0]->created_at)) }}</td>
                        <td style="width:3%"> {{$item->incoterm ? $item->incoterms->description : 'ﾠ-ﾠ'}} </td>
                        <td style="width:3%"> {{$item->grossweight}} </td>

                        <td> 
                            @if (isset($item->loading_confirmations[0]))
                                @foreach ( $item->loading_confirmations as $key_bl => $bl)
                                    @if ($key_bl == 0)
                                        {{$bl->BlNumber}}ﾠ
                                    @else
                                      //  {{$bl->BlNumber}}ﾠ
                                    @endif
                                        
                                @endforeach
                            @else
                                ﾠ-ﾠ
                            @endif 
                        </td>
                        <td style="width:3%">{{$item->finance_controls[0]->pricing_date ?? 'ﾠ-ﾠ' }}</td>
                        <td>
                          @if (isset($item->finance_controls[0]->pricing_message) && $item->finance_controls[0]->pricing_message != null)
                            {{$item->finance_controls[0]->pricing_message}}
                          @else
                            ﾠ-ﾠ
                          @endif
                        </td>

                        <td>
                            <i class="fas fa-check fa-lg" style="color:{{ (App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,4,$item->id)) }};"></i>  
                        </td>
                        <td>
                            @php
                                $result = App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id, 4, $item->id);
                            @endphp

                            @if ($result === '#cccccc')
                                No
                            @else
                                Yes
                            @endif
                        </td> 
                        <td>
                            <i class="fas fa-check fa-lg" style="color:{{ (App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,7,$item->id)) }};"></i>    
                        </td>
                        <td>
                            @php
                                $result = App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,7,$item->id);
                            @endphp

                            @if ($result === '#cccccc')
                                No
                            @else
                                Yes
                            @endif
                        </td>
                        <td>
                            <i class="fas fa-check fa-lg" style="color:{{ (App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,3,$item->id)) }};"></i>    
                        </td>
                        <td>
                            @php
                                $result = App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,3,$item->id);
                            @endphp

                            @if ($result === '#cccccc')
                                No
                            @else
                                Yes
                            @endif
                        </td>
                        <td>
                            <i class="fas fa-check fa-lg" style="color:{{ (App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,8,$item->id)) }};"></i>  
                        </td>
                        <td>
                            @php
                                $result = App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,8,$item->id);
                            @endphp

                            @if ($result === '#cccccc')
                                No
                            @else
                                Yes
                            @endif
                        </td>
                        <td>
                            <i class="fas fa-check fa-lg" style="color:{{ (($item->container_types_id == 7 || $item->container_types_id == 1) ? 
                                                                          (App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,9,$item->id)) : '#ccc') }};"></i>  
                        </td>
                        <td>
                            <br />
<b>Warning</b>:  Undefined variable $item in <b>/home/tabexc29/qa.tabex.com.br/resources/views/finance/invoicedProcesses.blade.php</b> on line <b>291</b><br />
<br />
<b>Warning</b>:  Attempt to read property "container_types_id" on null in <b>/home/tabexc29/qa.tabex.com.br/resources/views/finance/invoicedProcesses.blade.php</b> on line <b>291</b><br />
<br />
<b>Warning</b>:  Undefined variable $item in <b>/home/tabexc29/qa.tabex.com.br/resources/views/finance/invoicedProcesses.blade.php</b> on line <b>291</b><br />
<br />
<b>Warning</b>:  Attempt to read property "container_types_id" on null in <b>/home/tabexc29/qa.tabex.com.br/resources/views/finance/invoicedProcesses.blade.php</b> on line <b>291</b><br />
No                        </td>
                        <td>
                            <i class="fas fa-check fa-lg" style="color:{{ (App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,5,$item->id)) }};"></i>  
                        </td>
                        <td>
                            @php
                                $result = App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,5,$item->id);
                            @endphp

                            @if ($result === '#cccccc')
                                No
                            @else
                                Yes
                            @endif
                        </td>
                        <td>
                            <i class="fas fa-check fa-lg" style="color:{{ (App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,6,$item->id)) }};"></i>  
                        </td>
                        <td>
                            @php
                                $result = App\Http\Controllers\ClientProfileChecksController::check_request_DN_color_icon($item->clients_id, $item->platforms_id,6,$item->id);
                            @endphp
                        
                            @if ($result === '#cccccc')
                                No
                            @else
                                Yes
                            @endif
                        </td>
                        <td>{{$item->clients->userFinanceResponsable->nome ?? 'ﾠ-ﾠ'}}</td>
                    </tr>
                    
                @endforeach
                
            </tbody>
        </table>
    </div>
    <div align="center"  class="d-flex justify-content-center teste">
        {{ $registers->links() }}
    </div>
    <!-- Delete Model -->
    @include('include.modal_deletar', ["rota" => "loadingConfirmation"])
    @include('bibliotecas.bootstrapExport')
    @include('include.modal_invoicing_details', ["registers" => "Invoicing"])
    <script>
        $(function() {
          $('#table').bootstrapTable();
          $(".tool-information").tooltip({
            placement: 'right'
          });
        })
        $(document).ready(function () {
        $('#example').tooltip({ boundary: 'window' })
          $('li[id^="tooltipTransfer-"]').each(function(){
            var rowid = $(this).attr('id').split('ﾠ-ﾠ')[1];
            var oTd = this;
            $.ajax({
              url: "/finance/getTooltipTranferInfo/" + rowid,
              type:     'get',
              dataType: 'json',
              success: function(data) {
                if(data.retorno){
                  $(oTd).html(data.retorno);
                  $(".tool-information").tooltip({
                    placement: 'right'
                  });
                }
              }
            });
          });

          $(".tool-information-aux").tooltip({placement: 'right'});
        });
        $('#table').on('load-success.bs.table', function (data) {
            console.log(data);
                    
        });

    </script>
@endSection