@extends('website.layouts.master')

@section('content')

@include('website.layouts.title', ['simple'=>true])

<section>
    <div class="container">
        <div class="row">
            <div class="col-lg-12">
                <br>
                <h3>Total Applicants per Faculty</h3>
                <br>
                <div>
                    <table border="1" cellpadding="8" class="display" style="width:100%">
                        <thead>
                            <tr>
                                <th>Faculty Name</th>
                                <th>Total Applicants</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($results as $faculty => $majors)
                                <tr>
                                    <td>{{ $faculty }}</td>
                                    <td>{{ $majors->sum('total') }}</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
                <br>


                <h3>Total Applicants per Program</h3>
                <div>
                <br>
                    <table border="1" cellpadding="8" class="display" style="width:100%">
                        <thead>
                            <tr>
                                <th>Faculty Name</th>
                                <th>Program</th>
                                <th>Applicants Count</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($results as $faculty => $majors)
                                @foreach ($majors as $index => $row)
                                    <tr>
                                        @if ($index === 0)
                                            <td rowspan="{{ count($majors) }}">{{ $faculty }}</td>
                                        @endif
                                        <td>{{ $row->major }}</td>
                                        <td>{{ $row->total }}</td>
                                    </tr>
                                @endforeach
                            @endforeach
                        </tbody>
                    </table>
                </div>
                <br>
                <h3>Applicants Percentage Distribution</h3>
                <br>
                <div>
                <table border="1" cellpadding="8" class="display" style="width:100%">
                    <thead>
                        <tr>
                            <th>Faculty Name</th>
                            <th>> 95%</th>
                            <th>> 90%</th>
                            <th>> 85%</th>
                            <th>> 80%</th>
                            <th>> 75%</th>
                            <th>> 70%</th>
                            <th>> 65%</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach ($summary as $row)
                            <tr>
                                <td>{{ $row->faculty_name }}</td>
                                <td>{{ $row->above_95 }}</td>
                                <td>{{ $row->above_90 }}</td>
                                <td>{{ $row->above_85 }}</td>
                                <td>{{ $row->above_80 }}</td>
                                <td>{{ $row->above_75 }}</td>
                                <td>{{ $row->above_70 }}</td>
                                <td>{{ $row->above_65 }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
                </div>
                <br>   
                
                <h3>Higher Grade Applicant Transfer per Faculty</h3>
                <br>
                <div>                
                <table border="1" cellpadding="8" class="display" style="width:100%">
                    <thead>
                        <tr>
                            <th>Faculty Name</th>
                            <th>Transfer Count</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse ($transferStats as $row)
                            <tr>
                                <td>{{ $row->faculty_name }}</td>
                                <td>{{ $row->transfer_count }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="2">No records found</td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
                </div>
                <br>  

            </div>
        </div>
    </div>
</section>

@endsection

@section('pagejs')
@endsection