@extends('admin.layout.app')

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

  <script>
     function exportTableToExcel(tableID, filename = 'field_report'){
    var downloadLink;
    var dataType = 'application/vnd.ms-excel';
    var tableSelect = document.getElementById(tableID);
    var tableHTML = tableSelect.outerHTML.replace(/ /g, '%20');
    
    // Specify file name
    filename = filename?filename+'.xlsx':'excel_data.xls';
    
    // Create download link element
    downloadLink = document.createElement("a");
    
    document.body.appendChild(downloadLink);
    
    if(navigator.msSaveOrOpenBlob){
        var blob = new Blob(['\ufeff', tableHTML], {
            type: dataType
        });
        navigator.msSaveOrOpenBlob( blob, filename);
    }else{
        // Create a link to the file
        downloadLink.href = 'data:' + dataType + ', ' + tableHTML;
    
        // Setting the file name
        downloadLink.download = filename;
        
        //triggering the function
        downloadLink.click();
    }
   }

   
  </script>
  
@endsection

@section('main-content')
<section class="content-header">
	<h1>
		OPERATIONS MANAGEMENT SYSTEM
		
	</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="box-tools pull-right">

        <button onclick="exportTableToExcel('example1')" class="btn btn-warning pull-right"><i class="fa fa-excel-o text-white"></i> Export to Excel</button>

				
			</div>
		</div>
		
			<div class="box-body table-responsive">
			   <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                 <th>No.</th>
                  <th>Invoice No.</th>
                  <th>Consignee</th>
                  <th>MK Number</th>
                  <th>Contract Number</th>
                  <th>Tonnage</th>
                  <th>Bags</th>
                  <th>cif</th>
                  <th>uk_frieght</th>
                  <th>ex_rate_dl</th>
                  <th>buyers_gross</th>
                  <th>bunker_rate</th>
                  <th>insurance_premium</th>
                  <th>retention_amt</th>
                  <th>bank_gross</th>
                  <th>Destination Port</th>
                </tr>
                </thead>
                <tbody>

                @foreach ($invoice_details as $invoice_detail)
                <tr>
                	<td>{{$loop->index + 1}}</td>
                  <td>GC {{$invoice_detail->shipment->id}}</td>
                  <td>{{$invoice_detail->shipment->contract->consignee->name}}</td>
                  <td>{{$invoice_detail->shipment->contract->sales_advice->mk_number}}</td>
                  <td>{{$invoice_detail->shipment->contract->number}}</td>
                 <td>{{$invoice_detail->tonnage}}</td>
                  <td>{{$invoice_detail->bags}}</td>
                  <td>{{$invoice_detail->cif}}</td>
                  <td>{{$invoice_detail->uk_frieght}}</td>
                  <td>{{$invoice_detail->ex_rate_dl}}</td>
                  <td>{{$invoice_detail->buyers_gross}}</td>
                  <td>{{$invoice_detail->bunker_rate}}</td>
                  <td>{{$invoice_detail->insurance_premium}}</td>
                  <td>{{$invoice_detail->retention_amt}}</td>
                  <td>{{$invoice_detail->bank_gross}}</td>
                  <td>{{$invoice_detail->shipment->contract->destinationport->name}}</td>
                 


                	
                </tr>
                @endforeach
                
                </tbody>
                <tfoot>
                <tr>
                  <th>No.</th>
                   <th>Invoice No.</th>
                  <th>Consignee</th>
                  <th>MK Number</th>
                  <th>Contract Number</th>
                  <th>Tonnage</th>
                  <th>Bags</th>
                  <th>cif</th>
                  <th>uk_frieght</th>
                  <th>ex_rate_dl</th>
                  <th>buyers_gross</th>
                  <th>bunker_rate</th>
                  <th>insurance_premium</th>
                  <th>retention_amt</th>
                  <th>bank_gross</th>
                  <th>Destination Port</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