@extends('admin.layout.app')

@section('more-head')
 <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') }}">
 <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>
   CMC OPERATIONS MANAGEMENT SYSTEM

  </h1>

 </section>

 <section class="content">

  <!-- Default box -->
  <div class="box">
   <div class="box-header with-border">
    <h3 class="box-title"> <b style="color: red;"> {{ strtoupper($shed->name) }} SHED </b> </h3>

    <div class="box-tools pull-right">

    </div>
   </div>
   @include('includes.messages')

   <div class="box-body">
    <div class="nav-tabs-custom">
     <ul class="nav nav-tabs">
      <li class="active"><a href="#tab_5" data-toggle="tab" aria-expanded="false"
        style="color:darkcyan; font-weight:  bolder;">SHED BALANCE SHEET</a></li>
     </ul>
     <div class="tab-content">

      <div class="tab-pane active" id="tab_5">
       <div class="table-responsive">

        <br>
        <div class="col-md-offset-1 col-md-6">
         <form method="post" action="{{ route('shed.balance.sheet') }}" class="form-horizontal">
          {{ csrf_field() }} {{ method_field('POST') }}
          <div class="form-group">
           <label for="dfrom">Date From:</label>
           <input type="date" class="form-control" name="dfrom" required>
          </div>
          <div class="form-group">
           <label for="dto">Date To:</label>
           <input type="date" class="form-control" name="dto" required>
          </div>
          <div class="form-group">
           <label for="season_id">Select Season:</label> <br>
           <select name="season_id" class="select2 form-control" style="width:100%;">
            <option value="0" selected disabled>Select Season</option>
            @foreach ($seasons as $season)
             <option value="{{ $season->id }}">{{ $season->name }}</option>
            @endforeach
           </select>
           <br> <br>
          </div>

          <input type="hidden" value="{{ $shed->id }}" name="shed_id">

          <div class="form-group">
           <button type="submit" class="btn btn-success">Submit</button>
          </div>

         </form>

        </div>
        <table class="table-bordered table-condensed table-striped table">
         <tr>
          <th colspan="2"></th>
          <th style="text-align: center;">RECEIPTS</th>
          <th style="text-align: center;"> EVACUATIONS</th>
          <th>BALANCE</th>
         </tr>
         <tr>
          <th>No.</th>
          <th>Cat</th>
          <th>Total offloadings</th>
          <th>Total Evacuations</th>
          <th></th>
         </tr>

         @foreach ($categorys as $category)
          <tr>
           <td>{{ $loop->index + 1 }}</td>
           <td>{{ $category->name }}</td>
           <td style="color: green; font-size: 18px;">
            {{ $ba = $records->where('category_id', $category->id)->whereIn('transaction_type', ['offloading', 'both'])->sum('quantity_added') }}
            ({{ $records->where('category_id', $category->id)->whereIn('transaction_type', ['offloading', 'both'])->sum('quantity_added') / 16 }}
            tonnes)
           </td>
           <td style="color: red; font-size: 18px;">
            {{ $bel = $records->where('category_id', $category->id)->whereIn('transaction_type', ['evacuation', 'both'])->sum('quantity_evacuated') }}
            ({{ $records->where('category_id', $category->id)->whereIn('transaction_type', ['evacuation', 'both'])->sum('quantity_evacuated') / 16 }}
            tonnes)</td>
           <th style="color: black; font-size: 18px;">
            {{ $ba - $bel }} ({{ ($ba - $bel) / 16 }} tonnes)
           </th>

          </tr>
         @endforeach

        </table>

       </div>

      </div>
     </div>
     <!-- /.tab-content -->
    </div>

   </div>

   <!-- /.box-body -->
   <div class="box-footer">

   </div>

   <!-- /.box-footer-->
  </div>

 </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/dist/js/forwardonly.js') --}}"></script>
 <script>
  $(function() {

   $('#example1').DataTable();
   $('.example2').DataTable();
   $('#example3').DataTable();
   $('.select2').select2();

   $('#submit_form').on('click', function(event) {
    bush_grade = $('#bush_grade').val();
    if (warehouse_id == '0') {
     event.preventDefault();
     alert('Kindly select a Warehouse');
     return false;
    } else {
     return true;
    }


   });

  })
 </script>
@endsection