@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>
@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="convert()" 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;">Field Report: {{ \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%;">LEFTOVER STATUS</th>
       <th style="width: 4%;">LBC</th>
       <th style="width: 4%;">TRANS. <br> CODE</th>
       <th style="width: 4%;">TRUCK</th>
       <th style="width: 5%;">STATION</th>
       <th style="width: 2%;">BUSH <br> WAYBILL</th>
       <th style="width: 2%;">INTERNAL <br> WAYBILL</th>
       <th style="width: 2%;">CAT</th>
       <th>BUSH QTY</th>
       <th>PORT QTY</th>
       <th style="width: 2%;">REGION</th>
       <th style="width: 4%;">COCOA TYPE</th>
       <th style="width: 4%;">SPECIALTY</th>
       <th style="width: 4%;">CLIENT</th>
       @if ($request->shed_id == 0)
        <th> SHED ASSIGNED</th>
       @endif

       <th style="width: 3%;">PURITY CAT.</th>
       <th>STACK</th>
       <th style="width: 5%;">REMARKS</th>
       <th style="width: 5%;">GANG</th>
       <th style="width: 5%;">CLERK </th>
       <th style="width: 5%;">EXCESS OR SHORT</th>
       <th style="width: 5%;">REJEC.</th>
       <th style="width: 5%;">CAT. CHG. REMARKS</th>
       <th style="width: 5%;">WEIGHT 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->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>{{ $internal_waybill->cocoa_type->type_name }}</td>
        @if ($internal_waybill->specialty_type_id != null)
         <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>
        @else
         <td>{{ $internal_waybill->specialty_type }}</td>
         <td>{{ $internal_waybill->client_name }}</td>
        @endif
        @if ($request->shed_id == 0)
         <td>{{ $internal_waybill->shed->name }}</td>
        @endif
        <td>
         @foreach ($categorys as $category)
          @if ($internal_waybill->purity_category_id == $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

         </td>
        @else
         <td>N/A</td>
        @endif
        <td>
         @if ($internal_waybill->gang_name != null)
          {{ strtoupper($internal_waybill->gang_name) }}
         @elseif(!$shed_gang_allocations->isEmpty())
          @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
          {{-- expr --}}
         @else
          @php
           $ished_id = $internal_waybill->shed_id;
           $ished_gang_allocations = App\Model\shed_gang_allocation::where('shed_id', $ished_id)->get();
          @endphp

          @foreach ($ished_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>{{ $internal_waybill->excess }}</td>
        <td>{{ $internal_waybill->rejections }}</td>
        <td>{{ strtoupper($internal_waybill->cat_change_remarks) }}</td>
        <td>
         @if ($internal_waybill->excess < 0)
          Short: {{ abs($internal_waybill->excess) }}
         @elseif ($internal_waybill->excess > 0)
          Excess: {{ abs($internal_waybill->excess) }}
         @else
         @endif
         <br>
         @if ($internal_waybill->bag_average == null)
         @elseif($internal_waybill->bag_average < 63.0)
          Short weight
         @else
          Normal Weight
         @endif
        </td>
       </tr>
      @endforeach
      <tr>
       <th colspan="9">TOTAL</th>
       <th> {{-- $sbw = array_sum($bush_qtys) --}} {{ $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>

   <!-- /.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 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