@extends('admin.layout.app')

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

@section('main-content')
 <section class="content-header">
  <h1>
   Wpo Evacuation
  </h1>

 </section>

 <section class="content">

  <!-- Default box -->
  <div class="box">
   <div class="box-header with-border">
    <h3 class="box-title">SHED BALANCE SHEET</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 table-responsive">
    <h2>SHED BALANCE SHEET between {{ date('d-M-Y', strtotime($dfrom)) }} and {{ date('d-M-Y', strtotime($dto)) }}<br>
     SEASON
     : {{ $season->name }}</h2>

    <table class="table-bordered table-condensed table-striped table">
     <tr>
      <th colspan="1"></th>
      <th style="text-align: center;"></th>
      <th colspan="1" style="text-align: center;"> OPENING BALANCE</th>
      <th>RECEIPTS</th>
      <th style="text-align: center;">EVACUATIONS</th>
      <th>CLOSING BALANCE</th>

     </tr>
     <tr>
      <th>No.</th>
      <th>Cat</th>
      <th>Opening Balance as at <br> {{ date('d-M-Y', strtotime($dfrom)) }}</th>
      <th>Total offloadings</th>
      <th>Total Evacuations</th>

      <!--<th>Balance</th>-->
      <th>Closing Balance as at <br> {{ date('d-M-Y', strtotime($dto)) }}</th>

     </tr>

     @foreach ($categorys as $category)
      <tr>
       <td>{{ $loop->index + 1 }}</td>
       <td>{{ $category->name }}</td>
       @if (!empty($shed->records))
        <th style="color: purple; font-size: 20px;">
         {{ $shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dfrom))?->where('transaction_type', 'offloading')->sum('quantity_added') -$shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dfrom))->sum('quantity_added') }}
         ({{ $shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dfrom))->where('transaction_type', 'evacuation')->sum('quantity_evacuated') -$shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dfrom))->sum('quantity_evacuated') /16 }}
         tonnes)
        </th>
       @else
        <th style="color: purple; font-size: 20px;"></th>
       @endif
       @if (!empty($records))
        <td style="color: green; font-size: 18px;">
         {{ $ba = $records->where('category_id', $category->id)->where('transaction_type', 'offloading')->sum('quantity_added') }}
         ({{ $records->where('category_id', $category->id)->where('transaction_type', 'offloading')->sum('quantity_added') / 16 }}tonnes)
        </td>
        <td style="color: red; font-size: 18px;">
         {{ $bel = $records->where('category_id', $category->id)->where('transaction_type', 'evacuation')->sum('quantity_evacuated') }}
         ({{ $records->where('category_id', $category->id)->where('transaction_type', 'evacuation')->sum('quantity_evacuated') / 16 }}
         tonnes)</td>
       @else
        <td style="color: green; font-size: 18px;"> </td> {{-- $ba - ($bel + $bef) --}}
        <td style="color: green; font-size: 18px;"> </td> {{-- $ba - ($bel + $bef) --}}
       @endif
       @if (!empty($shed->records))
        <th style="color: purple; font-size: 20px;">
         {{ $shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dto))->where('transaction_type', 'offloading')->sum('quantity_added') -$shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dto))->where('transaction_type', 'evacuation')->sum('quantity_evacuated') }}
         ({{ ($shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dto))->where('transaction_type', 'offloading')->sum('quantity_added') -$shed->records->where('category_id', $category->id)->where('created_at', '<=', date($dto))->where('transaction_type', 'evacuation')->sum('quantity_evacuated')) /16 }}
         tonnes)
        </th>
       @else
        <th style="color: purple; font-size: 20px;"></th>
       @endif
      </tr>
     @endforeach

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