@extends('admin.include.master')

@section('content')
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 id="page-title">Group wise Abstract</h1>
                </div>
            </div>
        </div><!-- /.container-fluid -->
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="container-fluid">
            {{-- Country List --}}
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        {{-- <div class="card-header">
                        </div> --}}
                        <!-- /.card-header -->
                        <div class="card-body">
                            <table id="Group" class="table table-bordered table-striped table-sm">
                                <thead>
                                    <tr>
                                        <th class="text-center">Group</th>
                                        <th class="text-center">Sanction</th>
                                        <th class="text-center">Filled</th>
                                        <th class="text-center">Vacant</th>
                                    </tr>
                                </thead>
                                <tbody>
                                 <?php $TotalGroupSanctionPost = 0; $TotalGroupFilledPost=0;?>
                               @foreach ($groupData as $report)                                        
                                    <tr class="text-center">
                                        <td>{{ $report["GroupName"] }}</td>

                                        <td>{{ $report["TotalGroupSanctionPost"] }}</td> 

                                      <?php 
                                      $TotalPost = isset($report["TotalGroupSanctionPost"]) ? $report["TotalGroupSanctionPost"] : '';
                                         $TotalGroupSanctionPost  = $TotalGroupSanctionPost + $TotalPost;
                                         ?>

                                        <td>{{ $report["TotalGroupFilledPost"] }}</td>

                                       <?php 
                                      $TotalFilled = isset($report["TotalGroupFilledPost"]) ? $report["TotalGroupFilledPost"] : '';
                                         $TotalGroupFilledPost  = $TotalGroupFilledPost + $TotalFilled;
                                         ?>

                                        <td>
                                        @if($report["TotalGroupSanctionPost"] > $report["TotalGroupFilledPost"])
                                        {{ $report["TotalGroupSanctionPost"] - $report["TotalGroupFilledPost"] }}
                                        @else
                                        {{'0'}}
                                        @endif
                                        </td>   
                                    </tr>
                                 @endforeach
                                 <tr>
                                    <th rowspan="3" class="text-center">Total</th>
                                    <th class="text-center">{{ $TotalGroupSanctionPost }}</th>
                                    <th class="text-center">{{ $TotalGroupFilledPost }}</th>
                                    <th class="text-center">
                                    @if($TotalGroupSanctionPost > $TotalGroupFilledPost)
                                        {{ $TotalGroupSanctionPost - $TotalGroupFilledPost }}
                                        @else
                                        {{'0'}}
                                    @endif
                                    </th>
                                 </tr>
                                </tbody>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                    </form>
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->

        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>

{{-- JS Start Here --}}
<script>
    $(function() {
        $("#Group").DataTable({
            "responsive": true,
            "ordering": false,
            // "paging": false,
            // "lengthChange": true,
            // "autoWidth": false,
            // "lengthMenu": [10, 20, 50, 100, 250, 500],
            // "columnDefs": [{ "orderable": false, "targets": 0 }],
            "buttons": ["csv", "excel", "pdf", "print"]
        }).buttons().container().appendTo('#Group_wrapper .col-md-6:eq(0)');
    });
</script>
<!-- /.content-wrapper -->
@endsection