@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>
		OPERATIONS MANAGEMENT SYSTEM
		
	</h1>

</section>

<section class="content">

	<!-- Default box -->
	<div class="box">
		<div class="box-header with-border">
			<h3 class="box-title">INTERNAL WAYBILLS</h3>
          
			<div class="box-tools pull-right">
				<a class="btn btn-info" href="{{ route('generate.waybill.summary',$summary_sheet) }}">Generate Summary </a>

			</div>
		</div>
		
			<div class="box-body table-responsive">

        <div class="col-md-offset-1 col-md-9"> 
          <table class="table table-bordered">
            <tr>
              <th>SUMMARY REF.</th>
              <th>LBC</th>
              <th>TOC</th>
              <th>CATEGORY</th>
              <th>COCOA TYPE</th>
              <th>SEASON</th>
              <th>GRADE</th>
            </tr>
            <tr>
              <td>{{$summary_sheet->ref_no}}</td>
              <td>{{$summary_sheet->lbc->name}}</td>
              <td>{{$summary_sheet->port->name}}</td>
              <td>{{$summary_sheet->category->name}}</td>
              <td>{{$summary_sheet->cocoa_type->type_name}}</td>
              <td>{{$summary_sheet->season->name}}</td>
              <td>{{$summary_sheet->grade}}</td>
            </tr>
          </table>
        </div>

        <div class="col-md-offset-1 col-md-9">
          
        
          <table  class="table table-bordered table-striped table-condensed">
            <thead>
              <tr>
                <th>No.</th>
                <th>Transaction Code</th>
                <th>Region</th>
                <th>District</th>
                <th>Station</th>
                <th>LBC Company</th>
                <th>Bush Waybill No.</th>
                <th>Internal Waybill No.</th>
                <th>Internal Waybill Date</th>
                <th>Purity Date</th>
                <th>Purity Number</th>
                <th>Purity No. of Bags</th>
                <th>Purity Grade</th>
                <th>Purity Category</th>
                <th>Net Weight</th>
                <th>Av. Weight per Bag</th>
                <th>Actual Tonnage</th>
                <th>Shed</th>
                <th>Add To Summary</th>
                      <!--<th>EDIT</th>
                        <th>DELETE</th> -->
                      </tr>
                    </thead>
                    <tbody>

                  @foreach ($regions  as $region)
                     @foreach ($internal_waybills as $internal_waybill)

                        @if ($region->id == $internal_waybill->bush_waybill->station->district->region->id)
                          
                           <tr>
                            <td>{{$loop->index + 1}}. <input type="hidden" value="{{$rid = $internal_waybill->bush_waybill->station->district->region->id}}"></td>
                            <td style="color: indigo; font-weight:bold;">{{$internal_waybill->bush_delivery->transaction_code}}</td>
                            <td style="color: indigo; font-weight:bold;">{{$internal_waybill->bush_waybill->station->district->region->name}}</td>
                            <td style="color: brown; font-weight:bold;">{{$internal_waybill->bush_waybill->station->district->district_name}}</td>
                            <td style="color: darkcyan; font-weight:bold;">{{$internal_waybill->bush_waybill->station->station_name}}</td>
                            <td style="font-weight:bolder;">{{$internal_waybill->bush_waybill->lbc->name}}</td>
                            <td style="font-weight: bold;">{{$internal_waybill->bush_waybill->bush_waybill_no}}</td>
                            <td style="color: purple; font-weight:bold;">{{$internal_waybill->internal_waybill_no}}</td>
                            <td>{{$internal_waybill->internal_waybill_date}}</td>
                            <td>{{$internal_waybill->purity_date}}</td>
                            <td>{{$internal_waybill->purity_number}}</td>
                            <td>{{$internal_waybill->purity_no_of_bags_ok}}</td>
                            <td>{{$internal_waybill->purity_grade}}</td>
                            <td>
                             @foreach ($categorys as $category)
                               @if ($category->id == $internal_waybill->purity_category_id)
                                {{$category->name}}
                               @endif
                             @endforeach
                             </td>
                             <td>{{number_format($internal_waybill->naked_tonnage_ok,2)}}</td>
                             <td>{{number_format($internal_waybill->bag_average,4)}}</td>
                             <td>{{number_format($internal_waybill->actual_tonnage,4)}}</td>
                            <td>{{$internal_waybill->shed->name}}</td>
                                <!--
                                <td><a href="" class="btn btn-primary">EDIT</a></td>
                                <td><a href="" class="btn btn-danger">DELETE</a></td>-->

                             </tr>
                             
                        @endif
                       @endforeach
                    @endforeach
                    @foreach ($regions as $region)
                      @if (($region->id == $internal_waybill->bush_waybill->station->district->region->id))
                        <tr>
                               <td colspan="17">Bags</td>
                               <td>{{ $internal_waybill->whereHas('bush_waybill.lbc',function ($query) use ($lbc_id){ return $query->where('id', '=', $lbc_id);})
                                    ->whereHas('bush_waybill',function ($query) use ($season_id) { return $query->where('season_id', '=', $season_id);})
                                    ->whereHas('bush_waybill.cocoa_type',function ($query) use ($cocoa_type_id) { return $query->where('id', '=', $cocoa_type_id);})
                                    ->whereHas('bush_delivery.port',function ($query) use ($port_id) { return $query->where('id', '=', $port_id);})
                                    ->whereHas('bush_waybill.station.district.region',function ($query) use ($rid) { return $query->where('id', '=', $rid);})
                                    ->where('summary_sheet_status',2)
                                    ->sum('purity_no_of_bags_ok') }}</td>
                             </tr>
                      @endif
                    @endforeach
                     </tbody>
                   </table>
                 </div>
                
               
				
      </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 () {
    
    $.ajaxSetup({

        headers: {

            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

        }

    });

    $('#example1').DataTable()
    $('#example2').DataTable({
      'paging'      : true,
      'lengthChange': false,
      'searching'   : false,
      'ordering'    : true,
      'info'        : true,
      'autoWidth'   : false
    })
  })
</script>

@endsection