@extends('backEnd.master')
@section('title')
    @lang('student.subject_attendance_report')
@endsection

@section('mainContent')
    @push('css')
        <style>
            #table_id1 {
                border: 1px solid var(--border_color);

            }

            #table_id1 td {
                border: 1px solid var(--border_color);
                text-align: center;
            }

            #table_id1 th {
                border: 1px solid var(--border_color);
                text-align: center;
            }

            .main-wrapper {
                display: block;
                width: auto;
                align-items: stretch;
            }

            .main-wrapper {
                display: block;
                width: auto;
                align-items: stretch;
            }

            #main-content {
                width: auto;
            }

            #table_id1 td {
                border: 1px solid var(--border_color);
                text-align: center;
                padding: 7px;
                flex-wrap: nowrap;
                white-space: nowrap;
                font-size: 11px
            }

            .table-responsive::-webkit-scrollbar-thumb {
                background: #828bb2;
                height: 5px;
                border-radius: 0;
            }

            .table-responsive::-webkit-scrollbar {
                width: 5px;
                height: 5px
            }

            .table-responsive::-webkit-scrollbar-track {
                height: 5px !important;
                background: #ddd;
                border-radius: 0;
                box-shadow: inset 0 0 5px grey
            }

            hr {
                margin: 0px;
            }
        </style>
    @endpush
    <section class="sms-breadcrumb mb-20 up_breadcrumb">
        <div class="container-fluid">
            <div class="row justify-content-between">
                <h1>@lang('student.subject_attendance_report')</h1>
                <div class="bc-pages">
                    <a href="{{ route('dashboard') }}">@lang('common.dashboard')</a>
                    <a href="#">@lang('student.student_information')</a>
                    <a href="#">@lang('student.subject_attendance_report')</a>
                </div>
            </div>
        </div>
    </section>
    <section class="admin-visitor-area up_st_admin_visitor">
        <div class="container-fluid p-0">
            <div class="row">
                <div class="col-lg-12">
                    <div class="white-box">
                        <div class="row">
                            <div class="col-lg-4 col-md-6">
                                <div class="main-title">
                                    <h3 class="mb-15">@lang('common.select_criteria')</h3>
                                </div>
                            </div>
                        </div>
                        {{ Form::open(['class' => 'form-horizontal', 'files' => true, 'route' => 'subject-attendance-report-search', 'method' => 'POST', 'enctype' => 'multipart/form-data', 'id' => 'search_student']) }}
                        <div class="row">
                            <input type="hidden" name="url" id="url" value="{{ URL::to('/') }}">
                            <div class="col-lg-3 mt-30-md">
                                <select class="primary_select form-control {{ $errors->has('class') ? ' is-invalid' : '' }}"
                                    id="select_class" name="class">
                                    <option data-display="@lang('common.select_class')*" value="">@lang('common.select_class') *</option>
                                    @foreach ($classes as $class)
                                        <option value="{{ $class->id }}"
                                            {{ isset($class_id) ? ($class_id == $class->id ? 'selected' : '') : '' }}>
                                            {{ $class->class_name }}</option>
                                    @endforeach
                                </select>
                                @if ($errors->has('class'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('class') }}
                                    </span>
                                @endif
                            </div>
                            <div class="col-lg-3 mt-30-md" id="select_section_div">
                                <select
                                    class="primary_select form-control{{ $errors->has('section') ? ' is-invalid' : '' }} select_section"
                                    id="select_section" name="section">
                                    <option data-display="@lang('common.select_section') *" value="">@lang('common.select_section') *</option>
                                </select>
                                @if ($errors->has('section'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('section') }}
                                    </span>
                                @endif
                            </div>
                            {{-- <div class="col-lg-4 mt-30-md" id="select_subject_div">
                                <select
                                    class="primary_select form-control{{ $errors->has('subject') ? ' is-invalid' : '' }} select_subject"
                                    id="select_subject" name="subject">
                                    <option data-display="Select subject *" value="">@lang('student.select_subject') *</option>
                                </select>
                                @if ($errors->has('subject'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('subject') }}
                                    </span>
                                @endif
                            </div> --}}
                            @php $current_month = date('m'); @endphp
                            <div class="col-lg-3 mt-30-md">
                                <select class="primary_select {{ $errors->has('month') ? ' is-invalid' : '' }}"
                                    name="month">
                                    <option data-display="Select Month *" value="">@lang('student.select_month') *</option>
                                    <option value="01"
                                        {{ isset($month) ? ($month == '01' ? 'selected' : '') : ($current_month == '01' ? 'selected' : '') }}>
                                        @lang('student.january')</option>
                                    <option value="02"
                                        {{ isset($month) ? ($month == '02' ? 'selected' : '') : ($current_month == '02' ? 'selected' : '') }}>
                                        @lang('student.february')</option>
                                    <option value="03"
                                        {{ isset($month) ? ($month == '03' ? 'selected' : '') : ($current_month == '03' ? 'selected' : '') }}>
                                        @lang('student.march')</option>
                                    <option value="04"
                                        {{ isset($month) ? ($month == '04' ? 'selected' : '') : ($current_month == '04' ? 'selected' : '') }}>
                                        @lang('student.april')</option>
                                    <option value="05"
                                        {{ isset($month) ? ($month == '05' ? 'selected' : '') : ($current_month == '05' ? 'selected' : '') }}>
                                        @lang('student.may')</option>
                                    <option value="06"
                                        {{ isset($month) ? ($month == '06' ? 'selected' : '') : ($current_month == '06' ? 'selected' : '') }}>
                                        @lang('student.june')</option>
                                    <option value="07"
                                        {{ isset($month) ? ($month == '07' ? 'selected' : '') : ($current_month == '07' ? 'selected' : '') }}>
                                        @lang('student.july')</option>
                                    <option value="08"
                                        {{ isset($month) ? ($month == '08' ? 'selected' : '') : ($current_month == '08' ? 'selected' : '') }}>
                                        @lang('student.august')</option>
                                    <option value="09"
                                        {{ isset($month) ? ($month == '09' ? 'selected' : '') : ($current_month == '09' ? 'selected' : '') }}>
                                        @lang('student.september')</option>
                                    <option value="10"
                                        {{ isset($month) ? ($month == '10' ? 'selected' : '') : ($current_month == '10' ? 'selected' : '') }}>
                                        @lang('student.october')</option>
                                    <option value="11"
                                        {{ isset($month) ? ($month == '11' ? 'selected' : '') : ($current_month == '11' ? 'selected' : '') }}>
                                        @lang('student.november')</option>
                                    <option value="12"
                                        {{ isset($month) ? ($month == '12' ? 'selected' : '') : ($current_month == '12' ? 'selected' : '') }}>
                                        @lang('student.december')</option>
                                </select>
                                @if ($errors->has('month'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('month') }}
                                    </span>
                                @endif
                            </div>
                            <div class="col-lg-3 mt-30-md  ">
                                <select class="primary_select form-control{{ $errors->has('year') ? ' is-invalid' : '' }}"
                                    name="year">
                                    <option data-display="Select Year *" value="">@lang('student.select_year') *</option>
                                    @php
                                        $current_year = date('Y');
                                        $ini = date('y');
                                        $limit = $ini + 30;
                                    @endphp
                                    @for ($i = $ini; $i <= $limit; $i++)
                                        <option value="{{ $current_year }}"
                                            {{ isset($year) ? ($year == $current_year ? 'selected' : '') : (date('Y') == $current_year ? 'selected' : '') }}>
                                            {{ $current_year-- }}</option>
                                    @endfor
                                </select>
                                @if ($errors->has('year'))
                                    <span class="text-danger invalid-select" role="alert">
                                        {{ $errors->first('year') }}
                                    </span>
                                @endif
                            </div>
                            <div class="col-lg-12 mt-20 text-right">
                                <button type="submit" class="primary-btn small fix-gr-bg">
                                    <span class="ti-search pr-2"></span>
                                    @lang('common.search')
                                </button>
                            </div>
                        </div>
                        {{ Form::close() }}
                    </div>
                </div>
            </div>
        </div>
    </section>
    @if (isset($attendances))
        <section class="student-attendance">
            <div class="container-fluid p-0">
                <div class="white-box mt-40">
                    <div class="row">
                        <div class="col-lg-6 no-gutters">
                            <div class="main-title mb-15">
                                <h3 class="mb-0">@lang('student.subject_attendance_report')
                                    <small> <span class="text-success">P:<span id="total_present"></span></span>
                                        <span class="text-warning">L:<span id="total_late"></span></span>
                                        <span class="text-danger">A:<span id="total_absent"></span></span>
                                        <span class="text-info">F:<span id="total_halfday"></span></span>
                                        <span class="text-dark">H:<span id="total_holiday"></span></span> </small>
                                </h3>
                            </div>
                        </div>
                        <div class="col-lg-6 no-gutters">
                            @if (userPermission(536))
                                <a href="{{ route('subject-attendance/print', [$class_id, $section_id, $month, $year]) }}"
                                    class="primary-btn small fix-gr-bg pull-right" target="_blank"><i class="ti-printer">
                                    </i>@lang('common.print')</a>
                            @endif
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-lg-12">
                            <div class="lateday d-flex flex-wrap">
                                <div class="mr-3 mb-10">@lang('student.present'): <span class="text-success">P</span></div>
                                <div class="mr-3 mb-10">@lang('student.late'): <span class="text-warning">L</span></div>
                                <div class="mr-3 mb-10">@lang('student.absent'): <span class="text-danger">A</span></div>
                                <div class="mr-3 mb-10">@lang('student.half_day'): <span class="text-info">F</span></div>
                                <div>@lang('student.holiday'): <span class="text-dark">H</span></div>
                            </div>
                        </div>
                    </div>
                    <div>
                        <div class="row" style="padding:0 15px">
                            <div class="table-responsive">
                                <table id="table_id1" style="margin-bottom:25px" class="table table-responsive"
                                    cellspacing="0" width="100%">
                                    <thead>
                                        <tr>
                                            <th width="6%">@lang('common.name')</th>
                                            <th width="6%">@lang('student.admission_no')</th>
                                            <th width="3%">P</th>
                                            <th width="3%">L</th>
                                            <th width="3%">A</th>
                                            <th width="3%">F</th>
                                            <th width="3%">H</th>
                                            <th width="2%">%</th>
                                            @for ($i = 1; $i <= $days; $i++)
                                                <th width="3%" class="{{ $i <= 18 ? 'all' : 'none' }}">
                                                    {{ $i }} <br>
                                                    @php
                                                        $date = $year . '-' . $month . '-' . $i;
                                                        $day = date('D', strtotime($date));
                                                        echo $day;
                                                    @endphp
                                                </th>
                                            @endfor
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $total_grand_present = 0;
                                            $total_late = 0;
                                            $total_absent = 0;
                                            $total_holiday = 0;
                                            $total_halfday = 0;
                                        @endphp
                                        @foreach ($attendances as $values)
                                            @php
                                                $last_key_number = array_key_last([$values]);
                                                
                                            @endphp
                                            @php $total_attendance = 0; @endphp
                                            @php $count_absent = 0; @endphp
                                            <tr>
                                                <td>
                                                    @php $student = 0; @endphp
                                                    @foreach ($values as $value)
                                                        @php $student++; @endphp
                                                        @if ($student == 1)
                                                            {{ @$value->student->full_name }}
                                                        @endif
                                                    @endforeach
                                                </td>
                                                <td>
                                                    @php $student = 0; @endphp
                                                    @foreach ($values as $value)
                                                        @php $student++; @endphp
                                                        @if ($student == 1)
                                                            {{ @$value->student->admission_no }}
                                                        @endif
                                                    @endforeach
                                                </td>
                                                <td>
                                                    @php $p = 0; @endphp
                                                    @foreach ($values as $value)
                                                        @if ($value->attendance_type == 'P')
                                                            @php
                                                                $p++;
                                                                $total_attendance++;
                                                                $total_grand_present++;
                                                            @endphp
                                                        @endif
                                                    @endforeach
                                                    {{ $p }}
                                                </td>
                                                <td>
                                                    @php $l = 0; @endphp
                                                    @foreach ($values as $value)
                                                        @if ($value->attendance_type == 'L')
                                                            @php
                                                                $l++;
                                                                $total_attendance++;
                                                                $total_late++;
                                                            @endphp
                                                        @endif
                                                    @endforeach
                                                    {{ $l }}
                                                </td>
                                                <td>
                                                    @php $a = 0; @endphp
                                                    @foreach ($values as $value)
                                                        @if ($value->attendance_type == 'A')
                                                            @php
                                                                $a++;
                                                                $count_absent++;
                                                                $total_attendance++;
                                                                $total_absent++;
                                                            @endphp
                                                        @endif
                                                    @endforeach
                                                    {{ $a }}
                                                </td>
                                                <td>
                                                    @php $f = 0; @endphp
                                                    @foreach ($values as $value)
                                                        @if ($value->attendance_type == 'F')
                                                            @php
                                                                $f++;
                                                                $total_attendance++;
                                                                $total_halfday++;
                                                            @endphp
                                                        @endif
                                                    @endforeach
                                                    {{ $f }}
                                                </td>
                                                <td>
                                                    @php $h = 0; @endphp
                                                    @foreach ($values as $value)
                                                        @if ($value->attendance_type == 'H')
                                                            @php
                                                                $h++;
                                                                $total_attendance++;
                                                                $total_holiday++;
                                                            @endphp
                                                        @endif
                                                    @endforeach
                                                    {{ $h }}
                                                </td>
                                                <td>
                                                    @php
                                                        $total_present = $total_attendance - $count_absent;
                                                    @endphp
                                                    {{ $total_present . '/' . $total_attendance }}
                                                    <hr>
                                                    @php
                                                        if ($count_absent == 0) {
                                                            echo '100%';
                                                        } else {
                                                            $percentage = ($total_present / $total_attendance) * 100;
                                                            echo number_format((float) $percentage, 2, '.', '') . '%';
                                                        }
                                                    @endphp
                                                </td>
                                                @for ($i = 1; $i <= $days; $i++)
                                                    @php
                                                        $date = $year . '-' . $month . '-' . $i;
                                                        $y = 0;
                                                    @endphp
                                                    <td width="3%" class="{{ $i <= 18 ? 'all' : 'none' }}">
                                                        @php
                                                            $date_present = 0;
                                                            $date_absent = 0;
                                                            $date_total_class = 0;
                                                        @endphp
                                                        @foreach ($values as $key => $value)
                                                            @if (strtotime($value->attendance_date) == strtotime($date))
                                                                @php
                                                                    if ($value->attendance_type == 'P' || $value->attendance_type == 'F' || $value->attendance_type == 'L') {
                                                                        $date_present++;
                                                                    } else {
                                                                        $date_absent++;
                                                                    }
                                                                    $date_total_class = $date_present + $date_absent;
                                                                @endphp
                                                            @endif
                                                        @endforeach
                                                        @if ($date_total_class != 0)
                                                            {{ $date_present . '/' . $date_total_class }}
                                                            <hr>
                                                            @php
                                                                if ($date_absent == 0) {
                                                                    echo '100%';
                                                                } else {
                                                                    if ($date_present != 0) {
                                                                        $date_percentage = ($date_present / $date_total_class) * 100;
                                                                        echo @number_format((float) $date_percentage, 2, '.', '') . '%';
                                                                    } else {
                                                                        echo '0%';
                                                                    }
                                                                }
                                                            @endphp
                                                        @endif
                                                    </td>
                                                @endfor
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    @endif
@endsection

@include('backEnd.partials.data_table_js')