@extends('admin.layout.app')

@section('more-head')
 <link rel="stylesheet" href="{{ asset('admin/bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css') }}">
 <link rel="stylesheet" href="https://cdn.datatables.net/1.13.2/css/jquery.dataTables.min.css">
 <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.3.4/css/buttons.dataTables.min.css">
@endsection

@section('main-content')
 <section class="content-header">
  <h1>
   OPERATIONS MANAGEMENT SYSTEM
  </h1>

 </section>

 <section class="content">
  <div class="box">
   <div class="box-header with-border">
    <h3 class="box-title">INVOICE REPORT</h3>

    <div class="mx-bg-3 col-sm-offset-3 mb-2">
     {{-- <a href="{{route('export.sales_invoice_report') }}" class="btn btn-success" id="batt"><i class="fa fa-excel"></i> Export To Excel </a> --}}
    </div>
    <div class="box-tools pull-right">
     <button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip" title="Collapse">
      <i class="fa fa-minus"></i></button>

    </div>
   </div>
   <div class="box-body table-responsive">
    <table id="example1" class="table-bordered table-striped table">
     <thead>

      <tr>
       <th>No.</th>
       <th>Invoice Date</th>
       <th>Invoice Number</th>
       <th>MK No.</th>
       <th>Contract</th>
       <th>B/L No.</th>
       <th>B/L Date</th>
       <th>Mode of Shipment</th>
       <th>Country of Destination</th>
       <th>Port of Destination</th>
       <th>Buyer</th>
       <th>Shipment Period</th>
       <th>Port of Loading</th>
       <th>Type of Loan</th>
       <th>Bean Type</th>
       <th>Specialty</th>
       <th>Crop Year</th>
       <th>Tonnage Shipped</th>
       <th>Shipping Line</th>
       <th>Vessel</th>
       <th>Basis</th>
       <th>UK CIF PRICE</th>
       <th>UK FREIGHT</th>
       <th>EXCHANGE RATE DECLARED</th>
       <th>DISCOUNT</th>
       <th>C & I</th>
       <th>BUYER'S GROSS</th>
       <th>BUNKER RATE</th>
       <th>ADDITIONAL HANDLING CHARGES</th>
       <th>DESTINATION FREIGHT CHARGE</th>
       <th>TOTAL TONNAGE FREIGHT</th>
       <th>BUNKER SURCHARGE</th>
       <th>GROSS FREIGHT</th>
       <th>BILL OF LADEN RATE</th>
       <th>TOTAL FREIGHT CHARGE (USD)</th>
       <th>ISURANCE PREMIUM</th>
       <th>RETENTION AMOUNT</th>
       <th>BANK GROSS</th>
       <th>CHEMICAL ANALYSIS</th>
       <th>HANDLING CHARGES</th>
       <th>SUM INSURED</th>
       <th>WAREHOUSE CHARGES</th>
       <th>INSURANCE NUMBER</th>

      </tr>
     </thead>
     <tbody>

      @foreach ($invoice_details as $invoice_detail)
       <tr>
        <td>{{ $loop->index + 1 }}.</td>
        <td>{{ $invoice_detail->shipment->invoice_date ? Carbon\Carbon::parse($invoice_detail->shipment->invoice_date)->format('j M Y') : null }}</td>
        <td>{{ $invoice_detail->shipment->invoice_number }}</td>
        <td>
            @if (empty($invoice_detail->shipment->multi_status))
            {{ $invoice_detail->shipment->contract->mk_number }}
             @else
             @foreach ($invoice_detail->shipment->multi_contracts->unique('contract.sales_advice') as $multi_contract)
                 {{$multi_contract->contract->sales_advice->mk_number}} 
             @endforeach
            @endif
        </td>
        <td>
             @if (empty($invoice_detail->shipment->multi_status))
            {{ $invoice_detail->shipment->contract->number }}
             @else
             @foreach ($invoice_detail->shipment->multi_contracts->unique('contract') as $multi_contract)
                 {{$multi_contract->contract->number}} 
             @endforeach
            @endif

        </td>
        <td>{{ $invoice_detail->shipment->bill_of_laden_number }}</td>
        <td>
         {{ $invoice_detail->shipment->bill_of_laden_date ? Carbon\Carbon::parse($invoice_detail->shipment->bill_of_laden_date)->format('j M Y') : null }}
        </td>
        <td>{{ $invoice_detail->shipment->shippingmode->name }}</td>
        <td>
            @if (empty($invoice_detail->shipment->multi_status))
            {{ $invoice_detail->shipment->country->name }}
             @else
                 {{$invoice_detail->shipment->multi_contracts->first()->contract->destinationport->country->name}}
            @endif

        </td>
        <td>
           @if (empty($invoice_detail->shipment->multi_status))
            {{ $invoice_detail->shipment->contract->destinationport->name }}
             @else
                 {{$invoice_detail->shipment->multi_contracts->first()->contract->destinationport->name}}
            @endif
        </td>
        <td>
             @if (empty($invoice_detail->shipment->multi_status))
            {{ $invoice_detail->shipment->contract->consignee->name }}
             @else
                 {{$invoice_detail->shipment->multi_contracts->first()->contract->consignee->name}}
            @endif
        </td>
        <td>
           
            @if (empty($invoice_detail->shipment->multi_status))
            {{ $invoice_detail->shipment->contract->shipping_period }}
             @else
                @foreach ($invoice_detail->shipment->multi_contracts->unique('contract.shipping_period') as $multi_contract)
                 {{$multi_contract->contract->shipping_period}} 
             @endforeach
            @endif
        </td>
        <td>{{ App\Model\port::find($invoice_detail->shipment->loadingport_id)->name }}</td>
        <td>
            @if (empty($invoice_detail->shipment->multi_status))
            {{ optional($invoice_detail->shipment->contract)->type_of_loan }} 
            
             @else
                @foreach ($invoice_detail->shipment->multi_contracts->unique('contract.type_of_loan') as $multi_contract)
                 {{optional($multi_contract->contract)->type_of_loan}} 
             @endforeach
            @endif
        </td>
        <td>
            
            @if (empty($invoice_detail->shipment->multi_status))
            {{ $invoice_detail->shipment->contract->crop->name }} 
            
             @else
                @foreach ($invoice_detail->shipment->multi_contracts->unique('contract.type_of_loan') as $multi_contract)
                 {{ $multi_contract->contract->crop->name }} 
             @endforeach
            @endif

        </td>
        <td>
            @if (empty($invoice_detail->shipment->multi_status))
                @if (
                $invoice_detail->shipment->contract->shipping_instruction->specialty_type != null &&
                    $invoice_detail->shipment->contract->shipping_instruction->specialty_type != 'N/A')
              {{ $invoice_detail->shipment->contract->shipping_instruction->specialty_type }}
             @endif
            
             @else
                @foreach ($invoice_detail->shipment->multi_contracts->unique() as $multi_contract)
                  @if (
                $multi_contract->contract->shipping_instruction->specialty_type != null &&
                    $multi_contract->contract->shipping_instruction->specialty_type != 'N/A')
              {{ $multi_contract->contract->shipping_instruction->specialty_type }}
             @endif
             @endforeach
            @endif
        </td>
        <td>
            @if (empty($invoice_detail->shipment->multi_status))
            
            {{ $invoice_detail->shipment->contract->production_year->year }}
            
             @else
                @foreach ($invoice_detail->shipment->multi_contracts->unique('contract.production_year') as $multi_contract)
                 {{ $multi_contract->contract->production_year->year }}
             @endforeach
            @endif
        </td>
        
        
        <td>
            
            @if (empty($invoice_detail->shipment->multi_status))
            
            {{ $invoice_detail->shipment->tonnage_shipped }}
            
             @else
                
                 {{$invoice_detail->shipment->multi_contracts->sum('tonnage_shipped')}}
             
            @endif
        </td>
        <td>
            {{ optional(optional($invoice_detail->shipment->fac)->shipping_line)->shipping_line }}
         </td>
        <td>{{ $invoice_detail->shipment->vessel->name }}</td>
        <td>
            
            @if (empty($invoice_detail->shipment->multi_status))
            
            {{ $invoice_detail->shipment->contract->base->name }}
            
             @else
                @foreach ($invoice_detail->shipment->multi_contracts->unique('contract.base') as $multi_contract)
                 {{ $multi_contract->contract->base->name }}
             @endforeach
            @endif
        </td>
        <td>{{ number_format($invoice_detail->shipment->invoice_detail->cif, 2) }}</td>
        <td>{{ $invoice_detail->uk_frieght }}</td>
        <td>{{ $invoice_detail->ex_rate_dl }}</td>
        <td>{{ $invoice_detail->discount }}</td>
        <td>{{ $invoice_detail->c_and_i }}</td>
        <td>{{ $invoice_detail->buyers_gross }}</td>
        <td>{{ optional($invoice_detail)->bunker_rate }}</td>
        <td>{{ optional($invoice_detail)->additional_handling_charge }}</td>
        <td>{{ optional($invoice_detail)->dfc }}</td>
        <td>{{ optional($invoice_detail)->total_tonnage_freight }}</td>
        <td>{{ optional($invoice_detail)->bunker_surcharge }}</td>
        <td>{{ optional($invoice_detail)->gross_freight }}</td>
        <td>{{ optional($invoice_detail)->bl_rate }}</td>
        <td>{{ optional($invoice_detail)->total_freight_charge_usd }}</td>
        <td>{{ optional($invoice_detail)->insurance_premium }}</td>
        <td>{{ optional($invoice_detail)->retention_amt }}</td>
        <td>{{ optional($invoice_detail)->bank_gross }}</td>
        <td>{{ optional($invoice_detail)->chemical_analysis }}</td>
        <td>{{ optional($invoice_detail)->payable_handling_charges }}</td>
        <td>{{ optional($invoice_detail)->sum_insured }}</td>
        <td>{{ optional($invoice_detail)->warehouse_charges }}</td>
        <td>{{ $invoice_detail->shipment->insurance_number }}</td>
        
       </tr>
      @endforeach

     </tbody>
    </table>
   
   </div>
  </div>

 </section>
@endsection

@section('more-scripts')
 <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
 <script src="https://cdn.datatables.net/1.13.2/js/jquery.dataTables.min.js"></script>
 
{{-- <script src="{{asset('admin/bower_components/datatables.net/js/jquery.dataTables.min.js')}}"></script>
<script src="{{asset('admin/bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js')}}"></script> --}}
<script src="https://cdn.datatables.net/buttons/2.3.4/js/dataTables.buttons.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/2.3.4/js/buttons.html5.min.js"></script>
 <script>
  $('#batt').click(function() {
   var button = $(this);
   button.attr('disabled', 'disabled');
  });
  //  $('#batt').click(function(){
  //   var button = $(this);
  //   button.html("Downloading...").attr('disabled', 'disabled');
  //   setTimeout(function() {
  //    button.removeAttr('disabled');
  //  },200000);
  // });

  $(function() {
   $('.showee').hide();
   $('#example3').DataTable()
   $('#example1').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copyHtml5',
            'excelHtml5',
            //'csvHtml5',
            //'pdfHtml5'
        ],
        'pageLength': 50,
        'lengthChange': true,
    } );
    // $('#example2').DataTable({
    //   'paging'      : true,
    //   'lengthChange': false,
    //   'searching'   : false,
    //   'ordering'    : true,
    //   'info'        : true,
    //   'autoWidth'   : false
    // })
   

  })
 </script>
@endsection