@extends('admin.layout.app')

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

@section('main-content')
<section class="content-header">
	<h1>
		INVOICE DETAILS
	</h1>

</section>

<section class="content">

	<!-- Default box -->
	<div class="box">
		<div class="box-header with-border">
			<h3 class="box-title">Invoice Details</h3>
         
            {{-- <div class="col-lg-offset-5"><a href="{{ route('invoice_detail.upload_form') }}" class="btn btn-success">Upload Received Proceeds</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>
    @php
      use Carbon\Carbon;
      use App\Model\production_year;
    @endphp
		
			<div class="box-body table-responsive">
			   <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>No.</th>
                  <th>GC Number</th>
                  <th>Shipping Line</th>
                  <th>Consignee</th>
                  <th>Collection Date</th>
                  <th>MK</th>
                  <th>Contract Number</th>
                  <th>Type of Payment</th>
                  <th>Bill Of Laden Date</th>
                  <th>Bill of Laden  Month</th>
                  <th>Contract Date</th>
                  <th>Crop Year</th>
                  <th>Value Date Proceeds</th>
                  <th>Collection Date</th>
                  <th>Type of Proceed</th>
                  <th>Bags</th>
                  <th>Tonnage</th>
                  <th>CIF</th>
                  <th>UK Freight</th>
                  <th>C & I</th>
                  <th>CIF Value</th>
                  <th>C&I Value</th>
                  <th>Basis</th>
                  <th>Insurance Premium</th>
                  <th>2% Retention</th> 
                  <th>Net Invoice Amount</th>
                  <th>Net Payment (USD)</th>
                  <th>Freight</th>
                  <th>Chemical Analysis</th>
                  <th>Bunker Surcharge</th>
                  <th>Gross</th>
                  <th>Commission (0.5% * C&I Value)</th>
                  <th>CMC Commission Received</th>
                </tr>
                </thead>
                <tbody>

                @foreach ($invoice_details as $invoice_detail)
                <tr>
                	<td>{{$loop->index + 1}}</td>
                	<td>{{strtoupper(optional($invoice_detail->shipment)->invoice_number)}}</td>
                	<td>{{optional(optional(optional($invoice_detail->shipment)->fac)->shipping_line)->shipping_line}}</td>
                  <td>{{strtoupper(optional(optional(optional($invoice_detail->shipment)->contract)->consignee)->name)}}</td>
                  <td>{{--Carbon::parse($invoice_detail->collection_date)->format('d M Y')--}}</td>
                  <td>{{strtoupper(optional(optional($invoice_detail->contract)->sales_advice)->mk_number)}}</td>
                   <td>{{strtoupper(optional($invoice_detail->contract)->number)}}</td>
                  <td>{{strtoupper(optional($invoice_detail->contract)->type_of_loan)}}</td>
                  <td>{{(Carbon::parse(optional($invoice_detail->shipment)->bill_of_laden_date)->format('dS M Y'))}}</td>
                  <td>{{(Carbon::parse(optional($invoice_detail->shipment)->bill_of_laden_date)->format('F'))}}</td>
                  <td>{{Carbon::parse(optional($invoice_detail->contract)->contract_date)->format('dS M Y')}}</td>
                  <td>{{strtoupper(optional(optional(optional($invoice_detail->contract)->sales_advice)->production_year)->year)  }}</td>
                  <td>value proceed date</td>
                  <td>collection date</td>
                  <td>type of proceed</td>
                  <td>{{ optional($invoice_detail->shipment)->tonnage_shipped * 16}}</td>
                  <td>{{ optional($invoice_detail->shipment)->tonnage_shipped}}</td>
                  <td>US ${{ number_format($invoice_detail->cif,2)}}</td>
                  <td>GBP £{{ number_format($invoice_detail->uk_frieght,2)}}</td>
                  <td>US ${{ number_format($invoice_detail->c_and_i,2)}}</td>
                  <td>
                    @php
                     $cif_value = $invoice_detail->cif * optional($invoice_detail->shipment)->tonnage_shipped
                    @endphp
                    US ${{number_format($cif_value, 2)}}
                  </td>
                  <td>
                    @php
                     $c_and_i_value = $invoice_detail->c_and_i * optional($invoice_detail->shipment)->tonnage_shipped
                    @endphp
                  US ${{number_format($c_and_i_value, 2)}}
                </td>
                  <td>{{strtoupper(App\Model\base::find($invoice_detail->base_id)->name) }} </td>
                  <td>US ${{ number_format($invoice_detail->insurance_premium,2)}}</td>
                	<td>US ${{ number_format($invoice_detail->retention_amt,2)}}</td>
                  <td>US ${{ number_format($invoice_detail->bank_gross,2)}}</td>
                  <td>US $ net_payment_usd</td>
                  <td>US ${{ number_format($invoice_detail->total_freight_charge_usd,2)}}</td>
                  <td>US ${{ number_format($invoice_detail->chemical_analysis,2)}}</td>
                  <td>US ${{ number_format($invoice_detail->bunker_surcharge,2)}}</td>
                  <td>gross</td>
                  <td>US ${{ number_format(0.5/100 * $cif_value,2) }}</td>
                  <td>Commission received</td>
                  <!--<td><a href="{{-- route('invoice_detail.edit',$invoice_detail) --}}" class="btn btn-primary">EDIT</a></td>
                 
                  
                	<td><form style="display: none;" id="form-data-{{$invoice_detail->id}}" action="{{-- route('invoice_detail.destroy',$invoice_detail) --}}" method="post">{{csrf_field()}} {{method_field('DELETE')}}</form><button class="btn btn-danger" onclick="if(confirm('wanna delete?')){event.preventDefault(); document.getElementById('form-data-{{$invoice_detail->id}}').submit();} else{ event.preventDefault();}">DELETE</button></td> -->
                  
                </tr>
                @endforeach
                
                </tbody>
                <tfoot>
                <tr>
                  <th>No.</th>
                  <th>GC Number</th>
                  <th>Shipping Line</th>
                  <th>Consignee</th>
                  <th>Collection Date</th>
                  <th>MK</th>
                  <th>Contract Number</th>
                  <th>Type of Payment</th>
                  <th>Bill Of Laden Date</th>
                  <th>Bill of Laden  Month</th>
                  <th>Contract Date</th>
                  <th>Crop Year</th>
                  <th>Value Date Proceeds</th>
                  <th>Collection Date</th>
                  <th>Type of Proceed</th>
                  <th>Bags</th>
                  <th>Tonnage</th>
                  <th>CIF</th>
                  <th>UK Freight</th>
                  <th>C & I</th>
                  <th>CIF Value</th>
                  <th>C&I Value</th>
                  <th>Basis</th>
                  <th>Insurance Premium</th>
                  <th>2% Retention</th> 
                  <th>Net Invoice Amount</th>
                  <th>Net Payment (USD)</th>
                  <th>Freight</th>
                  <th>Chemical Analysis</th>
                  <th>Bunker Surcharge</th>
                  <th>Gross</th>
                  <th>Commission (0.5% * C&I Value)</th>
                  <th>CMC Commission Received</th>
                </tr>
                </tfoot>
              </table>
				
             </div>
				
			<!-- /.box-body -->
			<div class="box-footer">
				
			</div>
	
		
	</div>
	<!-- /.box -->

</section>

@endsection

@section('more-scripts')
	<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>
  $(function () {
    $('#example1').DataTable()
    $('#example2').DataTable({
      'paging'      : true,
      'lengthChange': false,
      'searching'   : false,
      'ordering'    : true,
      'info'        : true,
      'autoWidth'   : false
    })
  })
</script>

@endsection