@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 convert() {
   let tbl1 = document.getElementsByTagName("table")[0]
   let tbl2 = document.getElementsByTagName("table")[1]

   let worksheet_tmp1 = XLSX.utils.table_to_sheet(tbl1, {
    raw: true
   });
   let worksheet_tmp2 = XLSX.utils.table_to_sheet(tbl2, {
    raw: true
   });

   let a = XLSX.utils.sheet_to_json(worksheet_tmp1, {
    header: 1
   })
   let b = XLSX.utils.sheet_to_json(worksheet_tmp2, {
    header: 1
   })

   a = a.concat(['']).concat(b)

   let worksheet = XLSX.utils.json_to_sheet(a, {
    skipHeader: true
   })

   const new_workbook = XLSX.utils.book_new()
   XLSX.utils.book_append_sheet(new_workbook, worksheet, "worksheet")
   XLSX.writeFile(new_workbook, 'field report.xlsx')
  }
 </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('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">
      </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">
      </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 Type:</option>
        <option value="field_report" selected>Field Report</option>
        <option value="truck_list">Truck List</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="convert()" 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%;">LEFTOVER STATUS</th>
        <th style="width: 5%;">LBC</th>
        <th style="width: 5%;">TRANS. <br> CODE</th>
        <th style="width: 5%;">SEASON</th>
        <th style="width: 5%;">TRUCK</th>
        <th style="width: 5%;">STATION</th>
        <th style="width: 3%;">BUSH <br> WAYBILL</th>
        <th style="width: 3%;">INTERNAL <br> WAYBILL</th>
        <th style="width: 3%;">CAT</th>
        <th>BUSH QTY</th>
        <th>PORT QTY</th>
        <th style="width: 3%;">REGION</th>
        <th style="width: 5%;">COCOA TYPE</th>
        <th style="width: 5%;">SPECIALTY</th>
        <th style="width: 5%;">CLIENT</th>
        @if (empty(Auth::user()->shed_id))
         <th> SHED ASSIGNED</th>
        @endif

        <th style="width: 3%;">PURITY CAT.</th>
        <th>STACK</th>
        <th style="width: 7%;">REMARKS</th>
        <th style="width: 10%;">GANG</th>
        <th style="width: 7%;">CLERK </th>
        <th style="width: 7%;">WEIGHT REMARKS </th>
        <th>EXCESS/SHORT</th>
        <th>CAT. CHG. REMARKS</th>
       </tr>
      </thead>
      <tbody>

       @foreach ($internal_waybills as $internal_waybill)
        <tr>
         <td>{{ $loop->index + 1 }}.</td>
         @if ($internal_waybill->left_over_status == 'reprogrammed' || $internal_waybill->left_over_status == 'leftover')
          <td style="font-weight: bold; color: red;">
           YES</td>
         @else
          <td style="font-weight: bold; color: red;">
          </td>
         @endif
         <td style="font-weight: bold; color: darkcyan;">{{ $internal_waybill->bush_waybill->lbc->name }}</td>
         <td style="color: indigo; font-weight: bold;">{{ $internal_waybill->bush_delivery->transaction_code }}</td>
         <th>{{ strtoupper($internal_waybill->bush_delivery->season->name) }}</th>
         <th>{{ strtoupper($internal_waybill->bush_delivery->truck_no) }}</th>
         <td>{{ strtoupper($internal_waybill->bush_waybill->station->station_name) }}</td>
         <td style="font-weight: bold;">{{ $internal_waybill->bush_waybill->bush_waybill_no }}</td>
         <td>{{ $internal_waybill->internal_waybill_no }}</td>
         <td>{{ $internal_waybill->category->name }}</td>
         <td style="font-weight: bold; color: red">{{ $internal_waybill->internal_no_of_bags }}</td>
         <td>{{ $internal_waybill->purity_no_of_bags_ok }}</td>
         <th>{{ $internal_waybill->bush_waybill->station->district->region->region_code }}</th>
         <td>{{ optional($internal_waybill->cocoa_type)->type_name }}</td>
         @if ($internal_waybill->specialty_type_id == null)
          <td>{{ $internal_waybill->specialty }}</td>
          <td>{{ $internal_waybill->client_name }}</td>
         @else
          <td>{{ App\Model\specialty_type::find($internal_waybill->specialty_type_id)->specialty_name }}</td>
          <td>{{ App\Model\client_type::find($internal_waybill->client_type_id)?->name }}</td>
         @endif
         @if (empty(Auth::user()->shed_id))
          <td>{{ $internal_waybill->shed->name }}</td>
         @endif
         <td>
          @foreach ($categorys as $category)
           @if ($category->id == $internal_waybill->purity_category_id)
            {{ $category->name }}
           @endif
          @endforeach
         </td>
         <td>
          @foreach ($internal_waybill->stack_records as $stack_record)
           {{-- @if ($internal_waybill->id == $waybill_stack->internal_waybill_id) --}}
           {{ strtoupper($stack_record->mini_shed_stack()->withTrashed()->value('mini_name')) }}:
           <b>{{ $stack_record->quantity_added }}</b>
           <br>
           {{-- @endif --}}
          @endforeach
         </td>
         @if ($irs = $internal_waybill->rejection_details->count() > 0)
          <td>
           @foreach ($internal_waybill->rejection_details as $rj)
            {{ $rj->rejected_no_of_bags }}: {{ $rj->type_of_rejection }} <br>
           @endforeach
           <br>

          </td>
         @else
          <td>N/A</td>
         @endif
         <td>
          @if ($internal_waybill->gang_name != null)
           {{ strtoupper($internal_waybill->gang_name) }}
          @else
           @foreach ($shed_gang_allocations as $shed_gang_allocation)
            @if ($internal_waybill->id == $shed_gang_allocation->internal_waybill_id)
             {{ strtoupper($shed_gang_allocation->gang->gang_name) }} <br>
            @endif
           @endforeach
          @endif
         </td>
         <td>{{ strtoupper($internal_waybill->clerk_name) }}</td>
         <td>
          @if ($internal_waybill->bag_average == null)
           N/A
          @elseif($internal_waybill->bag_average < 63.0)
           Short weight
          @else
           Normal Weight
          @endif
         </td>
         <td>
          @if ($internal_waybill->excess < 0)
           Short: {{ abs($internal_waybill->excess) }}
          @elseif ($internal_waybill->excess > 0)
           Excess: {{ abs($internal_waybill->excess) }}
          @else
           N/A
          @endif
         </td>
         <td>{{ $internal_waybill->cat_change_remarks }}</td>
        </tr>
       @endforeach
       <tr>
        <th colspan="10">TOTAL</th>
        <th> {{ $sbw = $internal_waybills->sum('internal_no_of_bags') }} </th>
        <th>{{ $siw = $internal_waybills->sum('purity_no_of_bags_ok') }}</th>
        <th colspan="11"></th>
       </tr>

      </tbody>
     </table>
     <table class="table-condensed table">
      <tr>
       <th style="width:30%">NO. OF POINTS</th>
       <th style="width:30%">{{ $p = $sbw / 1600 }}</th>
       <th style="width:20%">COCOA SWEEPINGS REALISED (KG)</th>
       <th style="width:20%"></th>
      </tr>
      <tr>
       <th>EXPECTED SAMPLE RESIDUE(KG)</th>
       <th>{{ 0.2 * $sbw }}</th>
       <td>COCOA CUTTINGS REALISED (KG)</td>
      </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 src="{{ asset('admin/bower_components/select2/dist/js/xlsx.mini.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