@extends('backend.admin_backend.admin_dashboard')

@section('admin')


<style>


#broadsheetTable{

    border-collapse:separate;

    border-spacing:0;

}

.subjectHeader{

    border-left:3px solid #e0dcdc !important;

}

.subject-start{

    border-left:2px solid #e0dcdc !important;
    width:55px;
    min-width:55px;
    max-width:55px;

}   


#broadsheetTable thead tr:nth-child(2) th{

    min-width:60px;

    width:60px;

}


#broadsheetTable thead tr:first-child th:nth-child(1){

    z-index:600;

}

#broadsheetTable thead tr:first-child th:nth-child(2){

    z-index:599;

}

#broadsheetTable thead tr:first-child th:nth-child(3){

    z-index:598;

}


/*=====================================================
TABLE HEADER
=====================================================*/

#broadsheetTable th{

text-align:center;

vertical-align:middle;

white-space:nowrap;

font-size:14px;

font-weight:bold;

}


/*=====================================================
TABLE BODY
=====================================================*/

#broadsheetTable td{

font-size:13px;

font-weight:600;

color:#222;

vertical-align:middle;

white-space:nowrap;

}


/*=====================================================
STICKY HEADER
=====================================================*/

/* Header */

#broadsheetTable thead tr:first-child th{

    position:sticky;
    top:0;
    z-index:200;

}

#broadsheetTable thead tr:nth-child(2) th{

    position:sticky;
    top:0px;      /* adjust if your first row is taller */
    z-index:199;
    background:#dbeafe;

}

#broadsheetTable td{

    min-width:55px;

}

#broadsheetTable td:nth-child(1){

    min-width:60px;

}

#broadsheetTable td:nth-child(2){

    min-width:120px;

}

#broadsheetTable td:nth-child(3){

    min-width:220px;

}

/* S/N */
/*=====================================================
STICKY FIRST THREE COLUMNS
=====================================================*/

/*------------------------------
S/N
------------------------------*/
#broadsheetTable th:nth-child(1),
#broadsheetTable td:nth-child(1){

    position: sticky;

    left:0;

    width:60px;

    min-width:60px;

    background:inherit;

    z-index:300;

}


/*------------------------------
Student ID
------------------------------*/
#broadsheetTable th:nth-child(2),
#broadsheetTable td:nth-child(2){

    position: sticky;

    left:60px;

    width:120px;

    min-width:120px;

    background:inherit;

    z-index:299;

}


/*------------------------------
Student Name
------------------------------*/
#broadsheetTable th:nth-child(3),
#broadsheetTable td:nth-child(3){

    position: sticky;

    left:180px;

    width:220px;

    min-width:220px;

    background:inherit;

    z-index:298;

}
/*=====================================================
HOVER
=====================================================*/

/*=====================================================
ZEBRA ROWS
=====================================================*/

#broadsheetTable tbody tr:nth-child(odd){

    background: #ffffff;

}

#broadsheetTable tbody tr:nth-child(even){

    background: #bacde0;

}

/*=====================================================
HOVER
=====================================================*/

#broadsheetTable tbody tr:hover td{

    background: #ffeeba !important;

    transition:.2s;

}


#broadsheetTable tbody td{

    background:inherit;

}

.table-responsive{

    overflow:auto;

}

#broadsheetTable{

    font-family:
    "Inter",
    "Segoe UI",
    sans-serif;

}

/*=====================================================
ROW HEIGHT
=====================================================*/

#broadsheetTable td{

    padding:14px 10px !important;

}

#broadsheetTable th{

    padding:14px 10px !important;

}

/*=====================================================
BROADSHEET HEADER
=====================================================*/

.broadsheetHeader{

    background:linear-gradient(135deg,#0d6efd,#0b5ed7);

    color:#fff;

    padding:18px;

    border-bottom:4px solid #ffc107;

    box-shadow:0 3px 10px rgba(0,0,0,.15);

}

.broadsheetHeader h4{

    margin:0;

    font-size:24px;

    font-weight:700;

    letter-spacing:.5px;

}

.broadsheet-info{

    display:flex;

    justify-content:center;

    align-items:center;

    flex-wrap:wrap;

    gap:20px;

    margin:20px 0;

}

.broadsheet-info span{

    background:#eef6ff;

    border:1px solid #cfdff5;

    border-radius:30px;

    padding:10px 22px;

    font-size:14px;

    font-weight:700;

    color:#003366;

    box-shadow:0 2px 8px rgba(0,0,0,.08);

}

.broadsheet-info i{

    color:#0d6efd;

    margin-right:6px;

}


.gradeHeader{

    min-width:80px !important;

    width:80px !important;

}

/*=====================================================
PRINT SETTINGS
=====================================================*/

@page{

    size:A0 landscape;

    margin:8mm;

}

@media print{

    .btn,
    .no-print{

        display:none !important;

    }

}



/* Total */
#broadsheetTable th:last-child,
#broadsheetTable td:last-child{

    width:55px;
    min-width:55px;
    max-width:55px;

}

/* Average */
#broadsheetTable th:nth-last-child(2),
#broadsheetTable td:nth-last-child(2){

    width:60px;
    min-width:60px;
    max-width:60px;

}

/* Total */
#broadsheetTable th:nth-last-child(3),
#broadsheetTable td:nth-last-child(3){

    width:60px;
    min-width:60px;
    max-width:60px;

}

</style>

<div id="printArea">

    <!-- Everything from Student Broadsheet down to the table -->




<div class="container-fluid">

<div class="card shadow">

<!-- ==========================================================
CARD HEADER
========================================================== -->

<div class="card-header broadsheetHeader" style="text-align:center;">


<div class="float-end no-print">

    {{-- Print --}}

    <button

        onclick="window.print()"

        class="btn btn-primary">

        <i class="fas fa-print"></i>

        Print

    </button>




    {{-- Excel --}}

    <a

        href="{{ route('broadsheet.export.excel', request()->all()) }}"

        class="btn btn-success">

        <i class="fas fa-file-excel"></i>

        Excel

    </a>


    {{-- PDF --}}

    <a

        href="{{ route('broadsheet.export.pdf', request()->all()) }}"

        class="btn btn-danger">

        <i class="fas fa-file-pdf"></i>

        PDF

    </a>

</div>

<h4>

<i class="fas fa-table"></i>

Student Broadsheet

</h4>

</div>


<div class="broadsheet-info">

    <span>

        <i class="fas fa-school"></i>

        <strong>Class</strong>

        {{ strtoupper($class->class_name) }}

    </span>

    <span>

        <i class="fas fa-calendar-alt"></i>

        <strong>Session</strong>

        {{ request('session') }}

    </span>

    <span>

        <i class="fas fa-list"></i>

        <strong>Term(s)</strong>

        {{ implode(', ', $selectedTerms) }}

    </span>

</div>


<!-- ==========================================================
CARD BODY
========================================================== -->

<div class="card-body p-0">

<div class="table-responsive">

<table

class="table table-bordered table-sm mb-0"

id="broadsheetTable">


<thead>

<tr style="background: #0d6efd;color:white;">

<th rowspan="2">

S/N

</th>

<th rowspan="2">

Student ID

</th>

<th rowspan="2">

Student Name

</th>

@foreach($subjects as $subject)


<th colspan="6" class="subjectHeader">

{{ strtoupper($subject->subject_name) }}

</th>

@endforeach

<th rowspan="2">

TOTAL

</th>  


<th rowspan="2">

AVERAGE

</th>

<th rowspan="2">

POSITION

</th>

</tr>


<tr style="background: #dbeafe;">

@foreach($subjects as $subject)

<th>

1ST

</th>

<th>

2ND

</th>

<th>

3RD

</th>

<th>

TOTAL

</th>

<th>

%

</th>

<th class="gradeHeader">

GRADE

</th>

@endforeach

</tr>

</thead>


<tbody>

@foreach($students as $student)

@php

/*
|--------------------------------------------------------------------------
| STUDENT GRAND TOTAL
|--------------------------------------------------------------------------
|
| Total of all Subject Percentages
|
*/

$grandTotal = 0;


/*
|--------------------------------------------------------------------------
| Subject Counter
|--------------------------------------------------------------------------
|
| Number of Subjects Offered
|
*/

$subjectCount = 0;

@endphp


<tr>

<td>

{{ $loop->iteration }}

</td>

<td>

{{ strtoupper($student->user->user_name) }}

</td>

<td>

{{ strtoupper($student->name) }}

</td>


{{-- ===============================================================
LOOP THROUGH EVERY SUBJECT
=============================================================== --}}

@foreach($subjects as $subject)

@php

/*
|--------------------------------------------------------------------------
| First Term Result
|--------------------------------------------------------------------------
*/

$first = $sheet[$student->id][$subject->id]['First Term'] ?? null;


/*
|--------------------------------------------------------------------------
| Second Term Result
|--------------------------------------------------------------------------
*/

$second = $sheet[$student->id][$subject->id]['Second Term'] ?? null;


/*
|--------------------------------------------------------------------------
| Third Term Result
|--------------------------------------------------------------------------
*/

$third = $sheet[$student->id][$subject->id]['Third Term'] ?? null;


/*
|--------------------------------------------------------------------------
| Display Values
|--------------------------------------------------------------------------
|
| Only display selected terms.
|
*/

$firstCum = in_array('First Term',$selectedTerms)
            ? ($first->total ?? '-')
            : '-';

$secondCum = in_array('Second Term',$selectedTerms)
            ? ($second->total ?? '-')
            : '-';

$thirdCum = in_array('Third Term',$selectedTerms)
            ? ($third->total ?? '-')
            : '-';


/*
|--------------------------------------------------------------------------
| Subject Total Cum
|--------------------------------------------------------------------------
*/

$totalCum = 0;

$termUsed = 0;

if($first){

    if(in_array('First Term',$selectedTerms)){

        $totalCum += $first->total;

        $termUsed++;

    }

}

if($second){

    if(in_array('Second Term',$selectedTerms)){

        $totalCum += $second->total;

        $termUsed++;

    }

}

if($third){

    if(in_array('Third Term',$selectedTerms)){

        $totalCum += $third->total;

        $termUsed++;

    }

}


/*
|--------------------------------------------------------------------------
| Subject Percentage
|--------------------------------------------------------------------------
*/

$percentage = $termUsed
            ? round($totalCum/$termUsed,2)
            : 0;


/*
|--------------------------------------------------------------------------
| Grade
|--------------------------------------------------------------------------
*/

if($percentage>=70){

    $grade="A";

}elseif($percentage>=60){

    $grade="B";

}elseif($percentage>=50){

    $grade="C";

}elseif($percentage>=45){

    $grade="D";

}elseif($percentage>=40){

    $grade="E";

}else{

    $grade="F";

}


/*
|--------------------------------------------------------------------------
| Grand Total
|--------------------------------------------------------------------------
*/

if($termUsed){

    $grandTotal += $percentage;

    $subjectCount++;

}

@endphp


<td class="text-center subject-start">
{{ $firstCum }}
</td>

<td class="text-center">

{{ $secondCum }}

</td>

<td class="text-center">

{{ $thirdCum }}

</td>

<td class="text-center">

{{ $termUsed ? round($totalCum,2) : '-' }}

</td>

<td class="text-center">

{{ $termUsed ? round($percentage,2) : '-' }}

</td>

<td class="text-center">

{{ $termUsed ? $grade : '-' }}

</td>

@endforeach


@php

/*
|--------------------------------------------------------------------------
| Overall Average
|--------------------------------------------------------------------------
*/

$average = $subjectCount
        ? round($grandTotal/$subjectCount,2)
        : 0;

@endphp


<td class="text-center fw-bold">

{{ round($grandTotal,2) }}

</td>

<td class="text-center fw-bold">

{{ $average }}

</td>


<td class="text-center fw-bold">

@php

$position = $studentPositions[$student->id] ?? '-';

/*
|--------------------------------------------------------------------------
| Position Suffix
|--------------------------------------------------------------------------
*/

if(is_numeric($position)){

    if($position % 10 == 1 && $position != 11){

        $suffix = "st";

    }elseif($position % 10 == 2 && $position != 12){

        $suffix = "nd";

    }elseif($position % 10 == 3 && $position != 13){

        $suffix = "rd";

    }else{

        $suffix = "th";

    }

    echo $position.$suffix;

}else{

    echo "-";

}

@endphp

</td>

</tr>

@endforeach

</tbody>
</table>

</div>

</div>

</div>

</div>



</div>

@endsection