@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" type="text/css" href="{{ asset('admin/bower_components/select2/dist/css/select2.min.css') }}">
 <link rel="stylesheet" href="{{ asset('admin/dist/css/AdminLTE.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 + '.xls' : '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="">

    <div class=""><button id="printscrn" class="btn btn-success">Print</button>
     <button onclick="exportTableToExcel('example3')" class="btn btn-primary pull-right"><i
       class="fa fa-excel-o text-red"></i>Export to Excel</button>
    </div>
    <div class="showee">
     <img class="col-md-2" style="width: 150px; height: 100px;" src="{{ asset('admin/dist/img/cmclogo.png') }}"
      class="img-circle" alt="User Image">
     <br>
     @if (empty(Auth::user()->shed_id) && $request->shed_id == 0)
      <h3 style="text-align: center;"> {{ strtoupper(Auth::user()->port->name) }} TOC ARRIVAL DESK</h3>
     @elseif (empty(Auth::user()->shed_id) && $request->shed_id > 0)
      <h3 style="text-align: center;"> {{ strtoupper(App\Model\shed::find($request->shed_id)->name) }} SHED</h3>
     @else
      <h3 style="text-align: center;"> {{ strtoupper(Auth::user()->shed->name) }} SHED</h3>
     @endif

     <h2 style="text-align: center;">
      @if ($request->type == '0' or $request->type == 'factory')
       Factory Field Report:
      @else
       Shipment Field Report:
      @endif {{ \Carbon\Carbon::parse($date_from)->format('jS F Y') }} -
      {{ \Carbon\Carbon::parse($date_to)->format('jS F Y') }}
     </h2>
     <br>

    </div>

   </div>

   <div class="box-body table-responsive">

    <table id="example3" class="table-bordered table-striped table">
     <thead>
      <tr>
       <th>No.</th>
       <th style="width: 5%;">FACTORY/BUYER</th>
       <th style="width: 5%;">MK NO.</th>
       <th style="width: 5%;">CONTRACT NO.</th>
       <th style="width: 5%;">WAYBILL NO.</th>
       <th style="width: 5%;">HAULIER/VESSEL</th>
       <th style="width: 5%;">TRANSACTION CODE</th>
       <th style="width: 5%;">TRUCK NO</th>
       <th style="width: 5%;">COCOA TYPE</th>
       <th style="width: 5%;">SPECIALTY</th>
       <th style="width: 5%;">CLIENT</th>
       <th style="width: 3%;">QUANTITY LOADED(BAGS)</th>
       <th style="width: 3%;">QUANTITY LOADED(TONNES)</th>
       <th style="width: 3%;">SEASON UTILIZED</th>
       <th style="width: 5%;">STACK NO</th>
       @if ($request->shed_id == 0)
        <th> SHED ASSIGNED</th>
       @endif
       <th>CLERK</th>
       <th>GANG</th>
       <th>REMARKS</th>
      </tr>
     </thead>
     <tbody>

      @foreach ($shed_waybills as $shed_waybill)
       <tr>
        <td>{{ $loop->index + 1 }}.</td>
        <th>{{ strtoupper($shed_waybill->consignee->name) }}</th>
        <td style="color: indigo; font-weight: bold;">{{ $shed_waybill->wpo_evacuation->sales_advice->mk_number }}</td>
        <th>{{ strtoupper($shed_waybill->contract->number) }}</th>
        <td style="font-weight: bold; color: darkcyan;">{{ $shed_waybill->waybill_no }}</td>
        @if ($shed_waybill->type == 'factory')
         <td>{{ strtoupper($shed_waybill->evac_truck->truck->transporter) }}</td>
        @else
         <td>{{ strtoupper($shed_waybill->wpo_evacuation->fac->vessel->name) }}</td>
        @endif
        @if ($shed_waybill->type == 'factory')
         <td>{{ strtoupper($shed_waybill->evac_truck->transaction_code) }}</td>
         <td>{{ strtoupper($shed_waybill->evac_truck->truck->truck_no) }}</td>
        @else
         <td>N/A</td>
         <td>N/A</td>
        @endif
        <td>
         {{ strtoupper(App\Model\cocoa_type::find($shed_waybill->cocoa_type_id)?->type_name) ?? (strtoupper(optional($shed_waybill->wpo_evacuation->contract->shipping_instruction->cocoa_type)->type_name) ?? 'N/A') }}
        </td>
        <td>
         {{ strtoupper(App\Model\specialty_type::find($shed_waybill->specialty_type_id)?->specialty_name) ?? (strtoupper(optional($shed_waybill->wpo_evacuation->contract->shipping_instruction)->specialty_type) ?? 'N/A') }}
        </td>
        <td>
         {{ strtoupper(App\Model\client_type::find($shed_waybill->client_type_id)?->name) ?? 'N/A' }}
        </td>
        </td>
        <td>{{ $shed_waybill->quantity }}</td>
        <td>{{ $shed_waybill->quantity / 16 }}</td>
        <td>CAT {{ $shed_waybill->category->name }}({{ $shed_waybill->season->name }})</td>
        <th>
         @foreach ($shed_waybill->stack_records as $stack_record)
          {{ strtoupper($stack_record->mini_shed_stack()->withTrashed()->value('mini_name')) }}:
          <b>{{ $stack_record->quantity_evacuated }}</b>
          <br>
         @endforeach
        </th>
        @if ($request->shed_id == 0)
         <td>{{ $shed_waybill->shed->name }}</td>
        @endif
        <td>{{ strtoupper($shed_waybill->clerk) }}</td>
        <td>
         @if ($shed_waybill->gang_name != null)
          {{ strtoupper($shed_waybill->gang_name) }}
         @else
          @foreach ($shed_gang_allocations as $shed_gang_allocation)
           @if ($shed_waybill->id == $shed_gang_allocation->shed_waybill_id)
            {{ strtoupper($shed_gang_allocation->gang->gang_name) }} <br>
           @endif
          @endforeach
         @endif
        </td>
        <td></td>
       </tr>
      @endforeach
      <tr>
       <th colspan="11">TOTAL</th>
       <th> {{ $sbw = $shed_waybills->sum('quantity') }} </th>
       <th>{{ $sbw / 16 }}</th>
       <th colspan="12"></th>
      </tr>

     </tbody>
    </table>
    <table class="table-condensed table">
     <tr>
      <th style="width:30%">TOTAL QUANTITY ASSIGNED(BAGS)</th>
      <th style="width:30%">{{ $shed_evacs->sum('tonnage_assigned') * 16 }}</th>
     <tr>
     <tr>
      <th style="width:30%">TOTAL QUANTITY LOADED(BAGS)</th>
      <th style="width:30%">{{ $sbw }}</th>
     <tr>
      @if ($request->type != 'shipment')
       <th style="width:20%">TOTAL NUMBER OF TRUCKS LOADED</th>
       <th style="width:20%">{{ $shed_waybills->count('evac_truck_id') }}</th>
      @endif
     </tr>
     </tr>
     <tr>
      <th>EXPECTED SAMPLE RESIDUE(KG)</th>
      <th>{{ 0.1 * $sbw }}</th>
     </tr>
     <tr>
      <td style="width: 33%;">ACTUAL SAMPLE RESIDUE REALISED (KG)</td>
      <td style="width: 33%;">OTHER DISCREPANT COCOA (KG)</td>
      <th style="width: 33%"></th>
     </tr>
    </table>
    <table class="table">
     <tr>
      <th style="width:40%">DEPOT KEEPER</th>
      <th style="width:40%">SUPERVISOR</th>
      <th style="width:10%"></th>
      <th style="width:10%"></th>
     </tr>
     <tr>
      <th style="width:40%">NAME</th>
      <th style="width:40%">NAME</th>
      <th style="width:10%"></th>
      <th style="width:10%"></th>
     </tr>
     <tr>
      <th style="width:40%">SIGN</th>
      <th style="width:40%">SIGN</th>
      <th style="width:10%"></th>
      <th style="width:10%"></th>
     </tr>
    </table>
   </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 src="{{ asset('admin/bower_components/select2/dist/js/select2.full.min.js') }}"></script>
 <script>
  $(function() {
   $('.select2').select2();
   $('#example1').DataTable()
   $('#example2').DataTable({
    'paging': true,
    'lengthChange': false,
    'searching': false,
    'ordering': true,
    'info': true,
    'autoWidth': false
   })

   $('#printscrn').on('click', function(event) {
    event.preventDefault();
    $('.hiide').hide();
    $(this).hide();
    window.print();
    $(this).show();
    $('.hiide').show();
    //$('.showee').hide();
   });

  })
 </script>
@endsection