@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" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.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">OFFLOADINGS 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 table-responsive">
			   <table class="table table-bordered" id="example2">
          <thead>
             <tr>
               <th> TAKE OVER CENTER </th>
               <th style="text-transform: uppercase;">Bush Trucks registered</th>
               <th style="text-transform: uppercase;">Discrepant Trucks Registered</th>

             </tr>
            
          </thead>
          <tbody>
                @foreach ($bush_trucks_registed as $port_id => $trucks)

                 @foreach ($ports as $port)

                      @if ($port_id == $port->id)

                            <tr>
                              <td><b style="color: red">{{strtoupper($port->name)}} TOC</b></td>
                              <th style="color: green;">{{$trucks->where('port_id', $port->id)->where('type', 'bush delivery')->count()}}</th>
                              <td style="font-weight: bold; color: purple;">
                                @php
                                  $de = $trucks->where('port_id', $port->id)->where('type', 'discrepant')->count();
                                  $di = $trucks->where('port_id', $port->id)->where('type', 'descrepant')->count();
                                @endphp
                                {{$de + $di}}
                              </td>
                            </tr>
                              

                              
                               @foreach ($trucks_grouped = $trucks->groupBy('lbc_id') as $lbc_id => $trucksgrouped)
                                 @foreach ($lbcs as $lbc)
                                 @if ($lbc->id == $lbc_id)
                                     <tr>
                                        <td><b>{{strtoupper($lbc->name)}}</b></td>
                                        <td>{{$trucksgrouped->where('lbc_id',$lbc_id)->where('type', 'bush delivery')->count()}}</td>
                                        <td>
                                          @php
                                            $ltb = $trucksgrouped->where('lbc_id',$lbc_id)->where('type', 'discrepant')->count();
                                            $ltd = $trucksgrouped->where('lbc_id',$lbc_id)->where('type', 'descrepant')->count();
                                           @endphp
                                           {{$ltb + $ltd}}
                                        </td>
                                        
                                     </tr>
                                 @endif
                                 @endforeach
                               @endforeach
                                
                              
                            
                       
                       
                            
                        @endif

                  @endforeach
                @endforeach
            </tbody>
            
             
            


           
         </table>
            <hr><hr>

         <table class="table table-bordered" id="example1">
          <thead>
              <tr>
                   <th>LBC</th>
                   <th>EXPECTED QTY</th>
                   <th>EXPECTED QTY (Tonnes.)</th>
                   <th>PORT QTY</th>
                    <th>PORT QTY (Tonnes.)</th>
                    <th>WPO SUMMMARY TONNAGES</th>
                    <th>TOC AUDITED SUMMARY TONNAGES</th>
                    <th>WAYBILLS WITH CLAIMS(Tonnes)</th>
                   
              </tr>
            
          </thead>
          <tbody>
            
        
              @foreach ($internal_waybills as $lbc_id => $waybills)

                 @foreach ($lbcs as $lbc)

                        @if ($lbc_id == $lbc->id)
                            <tr>
                              <td><b style="color: darkcyan;">{{strtoupper($lbc->name)}}</b></td>
                              <td>
                                {{number_format($waybills->sum('internal_no_of_bags'))}}
                              </td>
                              <td>
                                {{number_format(($waybills->sum('internal_no_of_bags')/16),2)}}
                              </td>
                              <td>
                                {{number_format($waybills->sum('purity_no_of_bags_ok'),2)}}
                              </td>
                              <td>
                                {{number_format(($waybills->sum('purity_no_of_bags_ok')/16),2)}}
                              </td>
                              <td>{{ number_format(($waybills->where('summary_sheet_status',3)->sum('actual_tonnage')),2) }}</td>
                              <td>{{number_format(($waybills->where('summary_sheet_status',3)->sum('audited_actual_tonnage')),2)}}</td>
                              <td>{{number_format(($waybills->whereNotNull('claim_id')->sum('audited_actual_tonnage')),2)}}</td>
                              
                            </tr>
                        @endif
                 @endforeach
              @endforeach
            

          </tbody>

         </table>


         <hr><hr>
         <table class="table table-bordered" id="example4">
          <thead>
            <tr>
                 <th>TOC</th>
                 <th>N0. OF CLAIMS </th>
                 <th>TOTAL TONNAGE</th>
                 <th>TOTAL CLAIM</th>
                  <th>AUDITED CLAIMS</th>
                  <th>TOTAL AUDITED TONNAGE</th>
                  <th>TOTAL AUDITED CLAIM</th>
                
            </tr>
            
          </thead>
          <tbody>
             @foreach ($claims as $port_id => $acclaims)

                   @foreach ($ports as $port)

                          @if ($port_id == $port->id)
                           
                           <tr>
                                <td><b style="color: red">{{strtoupper($port->name)}} TOC</b></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                
                            </tr>

                                
                                 @foreach ($lbcclaims = $acclaims->groupBy('lbc_id') as $lbc_id => $acclbcs)
                                   @foreach ($lbcs as $lbc)
                                   @if ($lbc->id == $lbc_id)
                                       <tr>
                                          <td><b>{{strtoupper($lbc->name)}}</b></td>
                                          <td>{{$acclbcs->where('lbc_id',$lbc_id)->count()}}</td>
                                          <td>
                                            {{$acclbcs->where('lbc_id',$lbc_id)->sum('total_tonnage')}}
                                          </td>
                                          <td>
                                            @php
                                              $tc = array();
                                              $item = $acclbcs->where('lbc_id',$lbc_id)->pluck('total_claim');
                                              foreach ($item as $val) {
                                               $val = str_replace(',', '', $val);
                                              array_push($tc,$val);
                                              }
                                              $sum = array_sum($tc);
                                            @endphp
                                            {{number_format($sum,2)}}
                                          </td>
                                          <td>{{$acclbcs->where('lbc_id',$lbc_id)->whereNotNull('certified_by')->count()}}</td>
                                          <td>
                                            {{$acclbcs->where('lbc_id',$lbc_id)->whereNotNull('certified_by')->sum('total_tonnage')}}
                                          </td>
                                          <td>
                                            @php
                                              $tc = array();
                                              $item = $acclbcs->where('lbc_id',$lbc_id)->whereNotNull('certified_by')->pluck('total_claim');
                                              foreach ($item as $val) {
                                               $val = str_replace(',', '', $val);
                                              array_push($tc,$val);
                                              }
                                              $sum = array_sum($tc);
                                            @endphp
                                            {{number_format($sum,2)}}
                                          </td>
                                          
                                       </tr>
                                   @endif
                                   @endforeach
                                 @endforeach
                                  
                                
                              
                                
                          @endif

                    @endforeach
                  @endforeach
           </tr>
          </tbody>
       </table>
       <hr> <hr>
       <table class="table table-bordered" id="example3">
        <thead>
          <tr>
                 <th>TOC</th>
                 <th>NO. OF SUMMARIES </th> 
                 <th>NO. OF AUDITED SUMMARIES</th>
                
            </tr>
        </thead>
        <tbody>
          
           @foreach ($summary_sheets as $port_id => $sheets)

                   @foreach ($ports as $port)

                          @if ($port_id == $port->id)
                           
                           <tr>
                                <td><b style="color: red">{{strtoupper($port->name)}} TOC</b></td>
                                <td></td>
                                <td></td>
                                
                            </tr>
                                

                                
                                 @foreach ($accsheets = $sheets->groupBy('lbc_id') as $lbc_id => $lbc_sheets)
                                   @foreach ($lbcs as $lbc)
                                       @if ($lbc->id == $lbc_id)
                                           <tr>
                                              <td><b>{{strtoupper($lbc->name)}}</b></td>
                                              <td>{{$lbc_sheets->where('lbc_id',$lbc_id)->count()}}</td>
                                             <!-- <td>
                                                {{--$lbc_sheets->where('lbc_id',$lbc_id)->sum('total_tonnage')--}}
                                              </td> -->
                                               <td>{{$lbc_sheets->where('lbc_id',$lbc_id)->where('audit_status','certified')->count()}}</td>
                                           </tr>
                                       @endif
                                   @endforeach
                                @endforeach
                             
                              @endif
                    @endforeach
                @endforeach
        </tbody>
        
       </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="https://code.jquery.com/jquery-3.3.1.js">
   
 </script>

 <script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js">
   
 </script>

 <script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js">
   
 </script>

 <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js">
   
 </script>

 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js">
   
 </script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js">
   
 </script>

 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js">
   
 </script>

 <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js">
   
 </script>

<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js">
   
 </script>

    <script>
  $(function () {
    /*$('#example1').DataTable({

      'paging': true, 
       'searching'   : true,
       dom: 'Bfrtip',
       

  })

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

    $('#example1').DataTable( {
        'searching'   : true,
        'paging'      : true,
        'ordering'    : false,
        "pageLength": 50,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );

    $('#example2').DataTable( {
        'searching'   : true,
        'paging'      : true,
        'ordering'    : false,
        "pageLength": 50,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );

    $('#example3').DataTable( {
        'searching'   : true,
        'paging'      : true,
        'ordering'    : false,
        "pageLength": 50,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );

    $('#example4').DataTable( {
        'searching'   : true,
        'paging'      : true,
        'ordering'    : false,
        "pageLength": 50,
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );


  })
</script>

@endsection