@php  
$document = new \DOMDocument('1.0', 'UTF-8');

$internalErrors = libxml_use_internal_errors(true); 

$key_total = 0;
@endphp
<div class="table-responsive folha-interna3-financeDesign">
    <link href="{{ asset('app/coreui-icons-master/css/all.css') }}" rel="stylesheet" type="text/css" >
            <table class="table table-striped table-sm text-center" style="font-size: 10px;"  data-toggle="table">
                <thead>
                    <tr class="aling-th" >
                        <th class="icon-action"></th>
                        <th>Payment Type</th>
                        <th data-sortable="true">Process Number</th>
                        <th> Extra Payment</th>
                        <th>User</th>
                        <th>Client</th>
                        <th>Carrier</th>
                        <th>Booking</th>
                        <th>POL</th>
                        <th>POD</th>
                        <th>Incoterm</th>
                        <th>BL Date</th>
                        <th>Request Date</th>
                        <th colspan='{{ ($count_column!=0 ? $count_column : '')}}'>Fee And Rates Description    </th>                                                
                        <th> Correction Fee </th>
                        <th> Amount USD </th>
                        <th> Amount BRL</th>
                        <th> Dollar Rate</th>
                        <th> Total Amount</th>
                        <th> Status </th>

    
                    </tr>
                </thead>
                <tbody>
                    @foreach($registers as $item)
                        <tr>
                            <td>
                                @if($item->payment_type == 'Local Charges')
                                    @if($item->status == 'Extra Payment')
                                        <a class="icone-padding" href="{{route('editPaymentRequest',['id' => $item->id, 'extraPayment'=>'Yes'])}}" alt="Edit"  data-placement="top" title="View"><i alt="Edit" class="fas fa-eye"></i></a>       
                                    @else
                                        <a class="icone-padding" href="{{route('editPaymentRequest',$item->id)}}" alt="Edit"  data-placement="top" title="View"><i alt="Edit" class="fas fa-eye"></i></a>       
                                    @endif
                                    @if ($item->status == 'Extra Payment')
                                        <a class="icone-padding" href="{{route('previouslyEmailPaymentRequest', ['id' => $item->id, 'extraPayment'=>'Yes'])}}" alt="Email"  data-placement="top" title="Send"><i alt="Email" class="fas fa-paper-plane"></i></a>                    
                                    @else
                                        <a class="icone-padding" href="{{route('previouslyEmailPaymentRequest',$item->id)}}" alt="Email"  data-placement="top" title="Send"><i alt="Email" class="fas fa-paper-plane"></i></a>
                                    @endif
                                @elseif($item->payment_type == 'Hauling')
                                    @if($item->status == 'Extra Payment')
                                        <a class="icone-padding" href="{{route('editHaulingPaymentRequest',['id' => $item->id, 'extraPayment'=>'Yes'])}}" alt="Edit"  data-placement="top" title="View"><i alt="Edit" class="fas fa-eye"></i></a>       
                                    @else
                                        <a class="icone-padding" href="{{route('editHaulingPaymentRequest',$item->id)}}" alt="Edit"  data-placement="top" title="View"><i alt="Edit" class="fas fa-eye"></i></a>       
                                    @endif
                                    <a class="icone-padding" href="{{route('previouslyEmailHaulingPaymentRequest',$item->id)}}" alt="Email"  data-placement="top" title="Send"><i alt="Email" class="fas fa-paper-plane"></i></a>
                                @endif
                                
                            </td>
    
                            <td>{{ $item->payment_type }}</td>
                            <td>{{ $item->SAOE }}</td>
                            <td>
                                @if ($item->status == 'Extra Payment')
                                    -
                                @else
                                    @if($item->payment_type == 'Local Charges')
                                        <a class="icone-padding" href="{{ route('createPaymentRequest', ['id' => $item->loading_requests_id, 'extraPayment'=>'Yes']) }}">
                                        <i class="cib-cashapp"></i>
                                        </a>
                                    @elseif($item->payment_type == 'Hauling')
                                        <a class="icone-padding" href="{{ route('createHaulingPaymentRequest', ['id' => $item->loading_requests_id, 'extraPayment'=>'Yes']) }}">
                                        <i class="cib-cashapp"></i>
                                        </a>
                                    @endif
                                @endif
                            </td>
                            <td>{{ isset($item->usuarios->nome) ? str_limit($item->usuarios->nome, $limit = 10, $end = '...') : '-' }}</td>
                            <td>{{ isset($item->loading_requests->clients->fantasyName) ? str_limit($item->loading_requests->clients->fantasyName, $limit = 10, $end = '...') : str_limit($item->loading_requests->clients->name, $limit = 10, $end = '...') }}</td>
                            <td>{{ $item->loading_requests->carriers->descricao ? $item->loading_requests->carriers->descricao : '-' }}</td>
                            <td>{{ $item->loading_requests->booking ? $item->loading_requests->booking : '-'}}</td>
                            <td>{{ $item->loading_requests->loading_ports->descricao }}</td>
                            <td>{{ $item->loading_requests->code_of_ports1->place .', '. $item->loading_requests->code_of_ports1->country }}</td>
                            <td>{{ $item->loading_requests->incoterm ? $item->loading_requests->incoterms->description : '-'}}</td>
                            <td>{{ $item->loading_requests->loading_confirmations->pluck('BlDate') ? date( 'd-m-Y' , strtotime($item->loading_requests->loading_confirmations->pluck('BlDate')->implode(' '))) : '-' }}</td>
                            <td>{{ $item->emailRequestDate ? date( 'd-m-Y' , strtotime($item->emailRequestDate)) : '-' }}</td>
                           
                                @php
                                
                                if( $item->payment_type == 'Local Charges'){
                                    $key_total = 0;
                                    foreach($item->payment_fee as $key => $value){                                    
                                            $price = 
    
                                            ( $value->currencies_id == 148 ? 
                                                        number_format((($value->price) * ($value->PaymentType == 'BL' ? $item->blQty: $item->containerQty)),2,'.','') : 
                                                        number_format($value->price * ($value->PaymentType == 'BL' ? $item->blQty: $item->containerQty),2,'.','')
                                            );
    
    
    
                                                echo '<td>' . $price . ' (' . ($value->currencies_id == 148 ? 'USD' : 'BRL') . ') - ' . $value->descricao . ' </td>';
                                            $key_total++;
                                    }
                                    
                                }
                                if( $item->payment_type == 'Hauling'){
                                    
                                    $key_total = 0;
                                    foreach($item->payment_fee as  $value){
                                        $line =  '<td>' ;
                                        $line .=  ' Route: ' . $value->cities .'->'. $value->cities2 .'->'. $value->cities3 .'(';
                                        $line .=   ($value->qty_truckingCost != 0 &&  $value->qty_truckingCost != null ? 'QTY:' . $value->qty_truckingCost. '-TRUCK COST ' . 'PRICE: ' . number_format(($value->truckingCost  / $value->qty_truckingCost),2,',','.').'|' : '');
                                        $line .=   ($value->qty_toll != 0 &&  $value->qty_toll != null ?   'QTY:'. $value->qty_toll.'-TOLL ' . 'PRICE: ' . number_format(($value->toll  / $value->qty_toll),2,',','.').'|': '');
                                        $line .=   ($value->qty_truck_laytime != 0 &&  $value->qty_truck_laytime != null  ? 'QTY:' .  $value->qty_truck_laytime.'-TRUCK LAYTIME ' . 'PRICE: ' . number_format(($value->truck_laytime  / $value->qty_truck_laytime),2,',','.') .'|': '');
                                        $line .=   ($value->qty_flexitank_instalation != 0 &&  $value->qty_flexitank_instalation != null ? 'QTY:' . $value->qty_flexitank_instalation.'-FLEXITANK INSTALATION ' . 'PRICE: ' . number_format(($value->flexitank_instalation  / $value->qty_flexitank_instalation),2,',','.') : '');
                                        $line .= ')</td>';
                                        echo $line;
                                        $key_total++; 
                                    }
                                   
                                }
                                for ($i=($key_total); $i < $count_column; $i++){
                                    echo '<td> - </td>';
                                }
                                $amountBRL = number_format(($item->amountBRL), 2, ',', '.');
                                $correctionPrice = number_format(($item->correctionPrice * $item->correctionQty), 2, ',', '.');
                                $totalAmountBRL = number_format(($item->amountBRL + ($item->correctionPrice * $item->correctionQty)), 2, ',', '.');
                                @endphp
                            <td>{!! $correctionPrice ? $correctionPrice : '-' !!}</td>
                            <td>{!! number_format(($item->amount ? $item->amount : 0),2,',','.') !!}</td>
                            <td>{!! $amountBRL ? $totalAmountBRL : 0 !!}</td>
                            <td>{!! number_format(($item->dollarRate ? $item->dollarRate : 0),5,',','.') !!}</td>
                            
                            <td>{!! number_format(( $item->dollarRate ? (($item->amount * $item->dollarRate) + ($item->amountBRL + ($item->correctionPrice * $item->correctionQty))) : 0) ,2,',','.') !!}</td>
                           
                            <td>{{ $item->status ? $item->status : '-'}}</td>
                        </tr>
                        
                    @endforeach
                    
                </tbody>
            </table>