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

</section>

<section class="content">

	<!-- Default box -->
	<div class="box">
		<div class="box-header with-border">
			<h3 class="box-title">CTOR SUMMARY</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">

				@foreach ($ports as $port)
					
				<table class="table table-bordered table-condensed table-striped">
					<tr>
						<th colspan="4" style="color: red;">{{strtoupper($port->name)}} TOC</th>
					</tr>
                 	<tr>
                 		<th colspan="2"></th>
                 		<th style="text-align: center;">RECEIPTS</th>
                 		<th colspan="2" style="text-align: center;"> EVACUATIONS</th>
                 		 <th>BALANCE</th>
                 	</tr>
                 	<tr>
                 		<th>No.</th>
                 		<th>Cat</th>
                 		<th>Total offloadings (Bags)</th>
                 		<th>Total Evacs (Factories)</th>
                 		<th>Total Evacs (Foreign)</th>
                 		<th></th>
                 	</tr>

                 	@foreach ($categorys as $category)
                 		<tr>
                 			<td>{{$loop->index + 1}}</td>
                 			<td>{{$category->name}} ({{$category->season->name}})</td>
                 			<td style="color: green; font-size: 18px;">{{$ba = $port->waybill_stacks->where('category_id',$category->id)->sum('bags_quantity_added')}} ({{$port->waybill_stacks->where('category_id',$category->id)->sum('bags_quantity_added')/16}} tonnes)</td>
                 			<td style="color: red; font-size: 18px;">{{$bel = $port->waybill_stacks->where('category_id',$category->id)->where('location','local')->sum('bags_quantity_evacuated')}} ({{$port->waybill_stacks->where('category_id',$category->id)->where('location','local')->sum('bags_quantity_evacuated')/16}} tonnes)</td>
                 			<td style="color: red; font-size: 18px;">{{$bef = $port->waybill_stacks->where('category_id',$category->id)->where('location','foreign')->sum('bags_quantity_evacuated')}} ({{$port->waybill_stacks->where('category_id',$category->id)->where('location','foreign')->sum('bags_quantity_evacuated')/16}} tonnes)</td>
                 			<th style="color: black; font-size: 18px;">
                 				{{$ba - ($bel + $bef)}} ({{($ba - ($bel + $bef))/16}} tonnes)
                 			</th>
                 			
                 		</tr>
                 	@endforeach

                 </table>
			     <br><br><br>
				@endforeach
			</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/dist/js/forwardonly.js')--}}"></script>
 <script>
  $(function () {
   //tta = $('#tta').val();
   //alert(tta);
    $('#example1').DataTable();
    $('.select2').select2();

   
    

</script>

@endsection