@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>

 <style>
  .form-inline .form-group>div.col-xs-8 {
   padding-left: 0;
   padding-right: 0;
  }

  // vertical align label
  .form-inline label {
   line-height: 34px;
  }

  // force inline control to fit container width
  // http://getbootstrap.com/css/#forms-inline
  .form-inline .form-control {
   width: 100%;
  }

  // Reset margin-bottom for our multiline form
  @media (min-width: 768px) {
   .form-inline .form-group {
    margin-bottom: 15px;
   }
  }
 </style>
@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 hiide">
    <h3 class="box-title">FIELD REPORTS</h3>

    <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">

    <form class="form hiide" role="form" action="{{ route('evac.field.results') }}" method="POST">
     @csrf @method('POST')

     <legend> GENERATE FIELD REPORT</legend>

     <div class="form-group col-xs-12 col-sm-6 col-lg-3">
      <label for="date_from" class="col-xs-4">DATE FROM:</label>
      <div class="col-xs-8">
       <input type="date" class="form-control" id="date_from" name="date_from" placeholder="date from" required>
      </div>
     </div>

     <div class="form-group col-xs-12 col-sm-6 col-lg-3">
      <label for="date_to" class="col-xs-4">DATE TO:</label>
      <div class="col-xs-8">
       <input type="date" class="form-control" id="date_to" name="date_to" placeholder="date to" required>
      </div>
     </div>
     @if (empty(Auth::user()->shed_id))
      <div class="form-group col-xs-12 col-sm-6 col-lg-3">
       <label for="shed_id" class="col-xs-4">SHED: </label>
       <div class="col-xs-8">
        <select name="shed_id" id="shed_id" class="form-control select2">
         <option value="0"> All Sheds</option>
         @foreach ($sheds as $shed)
          <option value="{{ $shed->id }}"> {{ $shed->name }}</option>
         @endforeach
        </select>
       </div>
      </div>
     @else
      <div class="form-group col-xs-12 col-sm-6 col-lg-3">
       <label for="shed_id" class="col-xs-4">SHED: </label>
       <div class="col-xs-8">
        <select name="shed_id" id="shed_id" class="form-control select2">
         <option value="{{ Auth::user()->shed->id }}" selected> {{ Auth::user()->shed->name }}</option>
        </select>
       </div>
      </div>
     @endif

     <div class="form-group col-xs-12 col-sm-6 col-lg-3">
      <label for="type" class="col-xs-4">TYPE OF REPORT: </label>
      <div class="col-xs-8">
       <select name="type" id="type" class="form-control select2" required>
        <option value=""> Select Report:</option>
        <option value="factory">Factory Report</option>
        <option value="shipment">Shipment Report</option>
       </select>
      </div>
     </div>

     <div class="form-group col-xs-12 col-sm-6 col-lg-3">
      <label for="season_id" class="col-xs-4">Season: </label>
      <div class="col-xs-8">
       <select name="season_id" id="season_id" class="form-control select2" required>
        <option value=""> Select Season:</option>
        @foreach ($seasons as $season)
         <option value="{{ $season->id }}"> {{ $season->name }}</option>
        @endforeach
       </select>
      </div>
     </div>

     <div class="form-group col-xs-12 col-sm-6 col-lg-3">
      <button type="submit" class="btn btn-primary col-xs-8 col-xs-offset-4">Generate</button>
     </div>

    </form>

    <div class="col-md-12 table-responsive">
     <div class="">

      <div class=""><button id="printscrn" class="btn btn-success">Print</button></div>
      <button onclick="exportTableToExcel('example3')" class="btn btn-warning pull-right"><i
        class="fa fa-excel-o text-white"></i> Export to Excel</button>
      <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))
        <h3 style="text-align: center;"> {{ strtoupper(Auth::user()->port->name) }} TOC ARRIVAL DESK</h3>
       @else
        <h3 style="text-align: center;"> {{ strtoupper(Auth::user()->shed->name) }} SHED</h3>
       @endif

       <h2 style="text-align: center;">Field Report For {{ \Carbon\Carbon::now()->parse()->format('jS F Y') }}</h2>

       <br>

      </div>

     </div>

     <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 (empty(Auth::user()->shed_id))
         <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>{{ $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 (empty(Auth::user()->shed_id))
          <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>
       <th style="width:20%">TOTAL NUMBER OF TRUCKS LOADED</th>
       <th style="width:20%">{{ $shed_waybills->whereNotNull('evac_truck_id')->count() }}</th>
      </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-body -->
   <div class="box-footer">

   </div>
   <!-- /.box-footer-->
  </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