@extends('dashboard_connect.dash_master')
@section('pagescontents')
<script src="https://cdn.jsdelivr.net/npm/chart.js@3.7.0/dist/chart.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/chartjs-plugin-datalabels@2.0.0/dist/chartjs-plugin-datalabels.min.js"></script>
	<!-- PAGE-HEADER -->
	<div class="page-header">
		<div>
			<h1 class="page-title">Faculty Master</h1>
		</div>
		<div class="ms-auto pageheader-btn">
			<ol class="breadcrumb">
				<li class="breadcrumb-item"><a href="javascript:void(0);">Faculty Master</a></li>
				<li class="breadcrumb-item active" aria-current="page">Monthly Attendance</li>
			</ol>
		</div>
	</div>
	<!-- PAGE-HEADER END -->
    <div class="card">
        <div class="card-header border-bottom">
            <h3 class="card-title">Monthly Attendance - Report</h3>
        </div>
        <div class="card-body">
        <form class="needs-validation" novalidate method="post" action="{{ route('facattd.report.post') }}">
        @csrf
            @if(Session::has('status'))
                <div class="row">
                    <div class="col-12">
                        <div class="alert alert-success" role="alert">
                            <span class="alert-inner--icon me-2"><i class="fe fe-user-check"></i></span>
                            <span class="alert-inner--text" style="font-weight: bold;">{{ session('status') }}</span>
                        </div>
                    </div>
                </div>
            @endif
            @if(Session::has('wrong'))
                <div class="row">
                    <div class="col-12">
                        <div class="alert alert-danger" role="alert">
                            <span class="alert-inner--icon me-2"><i class="fe fe-user-x"></i></span>
                            <span class="alert-inner--text" style="font-weight: bold;">{{ session('wrong') }}</span>
                        </div>
                    </div>
                </div>
            @endif        
            <div class="row p-5">
                <div class="col-sm-12 col-md-12 col-xl-4">
                    <div class="form-group">
                        <label for="sessionid" class="form-label text-muted">Select Session: <font style="font-weight: bold; color: red;">**</font></label>
                        <select class="form-control select2-show-search form-select" id="sessionid" name="sessionid" data-placeholder="Choose Session..." required>
                            <option value="">Select Session</option>
                            @foreach($actsession as $sessnm)
                                @if($sessnm->sessaction == "Current")
                                    <option value="{{ $sessnm->id }}" selected>{{ $sessnm->sessionid }}</option>
                                @else
                                    <option value="{{ $sessnm->id }}">{{ $sessnm->sessionid }}</option>
                                @endif
                            @endforeach
                        </select>
                        <div class="invalid-feedback">Please select session.</div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-12 col-xl-4">
                    <div class="form-group">
                        <label for="semesterid" class="form-label text-muted">Select Semester: <font style="font-weight: bold; color: red;">**</font></label>
                        <select class="form-control select2-show-search form-select" data-placeholder="Select Semester" id="semesterid" name="semesterid" required>
                            <option value="">Select Semester</option>
                            @foreach($semestermaster as $semesternm)
                                <option value="{{ $semesternm->courseyear }}" {{ $semesternm->courseyear == $semesterid ? 'selected' : '' }}>{{ $semesternm->courseyear }}</option>
                            @endforeach
                        </select>
                        <div class="invalid-feedback">Please select semester name.</div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-12 col-xl-4">
                    <div class="form-group">
                        <label for="attdmonth" class="form-label text-muted">Select Attendance Month: <font style="font-weight: bold; color: red;">**</font></label>
                        <select class="form-control select2-show-search form-select" data-placeholder="Select Attendance Month" id="attdmonth" name="attdmonth" required>
                            <option value="">Select Attendance Month</option>
                            <option value="All" {{ $attdmonth == "All" ? 'selected' : '' }}>All Months</option>
                            @foreach($monthmaster as $monthnm)
                                <option value={{ $monthnm->id }} {{ $monthnm->id == $attdmonth ? 'selected' : '' }}>{{ $monthnm->monthname }}</option>
                            @endforeach                                    
                        </select>
                        <div class="invalid-feedback">Please select attendance month.</div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-12 col-xl-4">
                    <div class="form-group">
                        <label for="attdtype" class="form-label text-muted">Select Attendance Type: <font style="font-weight: bold; color: red;">**</font></label>
                        <select class="form-control select2-show-search form-select" data-placeholder="Select Attendance Type" id="attdtype" name="attdtype" required>
                            <option value="">Select Attendance Type</option>
                            <option value="Theory" {{ $attdtype == "Theory" ? 'selected' : '' }}>Theory</option>
                            <option value="Tutorial" {{ $attdtype == "Tutorial" ? 'selected' : '' }}>Tutorial</option>
                            <option value="Practical" {{ $attdtype == "Practical" ? 'selected' : '' }}>Practical</option>
                            <option value="Practice" {{ $attdtype == "Practice" ? 'selected' : '' }}>Practice</option>
                        </select>
                        <div class="invalid-feedback">Please select attendance type.</div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-12 col-xl-4">
                    <div class="form-group">
                        <label for="stusection" class="form-label text-muted">Select Section/Group: <font style="font-weight: bold; color: red;">**</font></label>
                        <select class="form-control select2-show-search form-select" data-placeholder="Select Section/Group" id="stusection" name="stusection" required>
                            <option value="">Select Section/Group</option>
                            @foreach($sectionmaster as $sectionnm)
                                <option value="{{ $sectionnm->stusection }}" {{ $sectionnm->stusection == $stusection ? 'selected' : '' }}>{{ $sectionnm->stusection }}</option>
                            @endforeach                                    
                        </select>
                        <div class="invalid-feedback">Please select section/group.</div>
                    </div>
                </div>                
                <div class="col-sm-12 col-md-12 col-xl-4">
                    <div class="form-group">
                        <label for="attdusers" class="form-label text-muted">Select Show By: <font style="font-weight: bold; color: red;">**</font></label>
                        <select class="form-control select2-show-search form-select" data-placeholder="Select Show By" id="attdusers" name="attdusers" required>
                            <option value="">Select Show By</option>
                            <option value="MyAttd" {{ $attdusers == "MyAttd" ? 'selected' : '' }}>Show My Attendance</option>
                            <option value="AllAttd" {{ $attdusers == "AllAttd" ? 'selected' : '' }}>Show All Attendance</option>
                        </select>
                        <div class="invalid-feedback">Please select attendance type.</div>
                    </div>
                </div>
                <div class="col-sm-12 col-md-12 col-xl-12">
                    <div class="form-group">
                        <label for="subjectid" class="form-label text-muted">Select Paper Name: <font style="font-weight: bold; color: red;">**</font></label>
                        <select class="form-control select2-show-search form-select" data-placeholder="Select Paper Name" id="subjectid" name="subjectid" required>
                            <option value="">Select Paper Name</option>
                            @foreach($subjectmaster as $subjectnm)
                                <option value={{ $subjectnm->id }} {{ $subjectnm->id == $subjectid ? 'selected' : '' }}>{{ $subjectnm->papercode }} - {{ $subjectnm->papername }} - {{ $subjectnm->papertype }} [{{ $subjectnm->course_name }}]</option>
                            @endforeach
                        </select>
                        <div class="invalid-feedback">Please select paper name.</div>
                    </div>
                </div>
            </div>
            <div class="row p-5">
                <div class="btn-list text-end" style="margin-top: -40px;">
                    <button class="btn btn-info-gradient" type="submit"><i class="fe fe-list me-2"></i> Get Attendance Record</button>
                </div>
            </div>
        </form>
        </div>
    </div>


    <div class="row">
        <div class="col-md-12">
            @if(!empty($subjectid) && !empty($sessionid))
                <div class="card">
                    <div class="card-header border-bottom">
                        <h3 class="card-title">Students Attendance Data : <b>{{ getpapername($subjectid) }} - {{ $attdtype }} - {{ $stusection }} - 
                            @if($attdmonth == "All")
                                All Months
                            @else
                                {{ getmonthmaster($attdmonth) }}
                            @endif
                        </b></h3>
                        <div class="card-options">
                            <a href="{{ route('facattd.coursereport.download', [$sessionid, $subjectid, $attdmonth, $attdtype, $stusection, $attdusers]) }}" class="btn btn-danger btn-sm ms-2"><i class="fa fa-file-excel-o" aria-hidden="true"></i> Download in Excel</a>
                        </div>                        
                    </div>
                    <div class="card-body">                   
                        <div class="row">
                            <div class="col-lg-12">
                                <div class="table-responsive">
                                    <table class="table table-bordered text-nowrap border-bottom w-100" id="responsive-datatable-2">
                                        <thead>
                                            <tr class="bg-dark-transparent">
                                                <th class="wd-15p border-bottom-0" style="font-size: 14px; font-weight: bold;">S. No.</th>
                                                <th class="wd-15p border-bottom-0" style="font-size: 14px; font-weight: bold;">Course Name</th>
                                                <th class="wd-15p border-bottom-0" style="font-size: 14px; font-weight: bold; text-align: center;">College Roll No.</th>
                                                <th class="wd-25p border-bottom-0" style="font-size: 14px; font-weight: bold;">Student's Name</th>
                                                <th class="wd-25p border-bottom-0" style="font-size: 14px; font-weight: bold; text-align: center;">Leture Delivered</th>
                                                <th class="wd-25p border-bottom-0" style="font-size: 14px; font-weight: bold; text-align: center;">Lecture Attended</th>
                                                <th class="wd-25p border-bottom-0" style="font-size: 14px; font-weight: bold; text-align: center;">Percentage(%)</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $intcount = 1;
                                                $lectperc = 0;
                                                $lectheld = 0;
                                                $lectnewheld = 0;
                                                $lectnewattd = 0;
                                            @endphp
                                            @foreach($monthattddata as $keyone => $itemone)
                                                @php
                                                    $lectheld = $itemone->totlectheld;
                                                    $lectattd = $itemone->totlectattd;
                                                    $coursename = getstucourse($sessionid, $subjectid, $itemone->studentid);
                                                    $coursenewid = getstucourseid($sessionid, $subjectid, $itemone->studentid);
                                                    $weightage = getweightage($sessionid, $coursenewid, $itemone->studentid);
                                                    if($weightage>0){
                                                        $lectnewheld = (($lectheld * $weightage) / 100);
                                                        $lectheld = $lectheld - $lectnewheld;
                                                        if($lectheld>0 && $lectattd>0){
                                                            $lectperc = Round(($lectattd / $lectheld) * 100, 2);
                                                        }else{
                                                            $lectperc = 0;
                                                        }
                                                    }else{
                                                        if($lectheld>0 && $lectattd>0){
                                                            $lectperc = Round(($lectattd / $lectheld) * 100, 2);
                                                        }else{
                                                            $lectperc = 0;
                                                        }
                                                    }
                                                @endphp
                                                <tr>
                                                    <td style="font-size: 12px;">{{ $intcount }}</td>
                                                    <td style="font-size: 12px;">{{ $coursename }}</td>
                                                    <td style="font-size: 12px; text-align: center;">{{ $itemone->username }}</td>
                                                    <td style="font-size: 12px;">{{ $itemone->name }} {{ $itemone->lname }}</td>
                                                    <td style="font-size: 12px; text-align: center;">{{ Round($lectheld,2) }}</td>
                                                    <td style="font-size: 12px; text-align: center;">{{ Round($lectattd,2) }}</td>
                                                    <td style="font-size: 12px; text-align: center;">{{ Round($lectperc,2) }}</td>
                                                </tr>
                                            @php
                                                $intcount++;
                                            @endphp                                                
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>                    
                </div>
            @endif
        </div>
    </div>

	<div class="row">
		<div class="col-sm-12 col-md-12 col-lg-12 col-xl-12">
            <div aria-multiselectable="true" class="accordion-success mb-2" id="accordion5" role="tablist">
                <div class="card mb-0">
                    <div class="card-header border-bottom-0" id="heading5" role="tab">
                        <a class="accor-style2 collapsed" aria-controls="collapse5" aria-expanded="false" data-bs-toggle="collapse" href="#collapse5"><i class="fe fe-trending-up me-2"></i>Student's Attendance Percentage - Chart Presentation</a>
                    </div>
                    <div aria-labelledby="heading5" class="collapse" data-bs-parent="#accordion5" id="collapse5" role="tabpanel">
                        <div class="card-body">
                            <div class="chart-container">
                                <canvas id="percntchart"></canvas>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>   

    <script>
        function getRandomColor() {
            var letters = '0123456789ABCDEF'.split('');
            var color = '#';
            for (var i = 0; i < 6; i++ ) {
                color += letters[Math.floor(Math.random() * 16)];
            }
            return color;
        };

        Chart.register(ChartDataLabels);
        const ctx = document.getElementById('percntchart').getContext('2d');
        const myChart = new Chart(ctx, {
            type: 'bar',
            data: {
                labels: ["91-100%", "81-90%", "71-80%", "61-70%", "51-60%", "41-50%", "31-40%", "0-30%"],
                datasets: [{
                    label: "Percentage Count on Students",
                    data: [{{ $ninecnt }}, {{ $eightcnt }}, {{ $sevencnt }}, {{ $sixcnt }}, {{ $fivecnt }}, {{ $fourcnt }}, {{ $threecnt }}, {{ $twocnt }}],
                    borderColor: "#ffb0c1",
                    borderWidth: "0",
                    backgroundColor: [getRandomColor(), getRandomColor(), getRandomColor(), getRandomColor(), getRandomColor(), getRandomColor(), getRandomColor(), getRandomColor()]
                }]
            },
            options: {
            //indexAxis: 'y', // <-- here
            maintainAspectRatio: true,
            responsive: true,
            /*scales: {
                x: {
                    stacked: true,
                },
                y: {
                    stacked: true
                }
            },*/		
            plugins: {
                datalabels: { // This code is used to display data values
                    anchor: 'end',
                    align: 'top',
                    formatter: Math.round,
                    font: {
                        weight: 'bold',
                        size: 12
                    }
                }
            }
            }
        });
    </script>

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script>
        $(document).ready(function () {
            $('#semesterid').on('change', function () {
                var idSemester = this.value;
                if(idSemester != ""){
                    $('#subjectid').attr("disabled", false);
                }else{
                    $('#subjectid').attr("disabled", true);
                }
                var idCoutp = $("#coutypeid").val();
                $("#subjectid").html('');
                $.ajax({
                    url: "{{url('api/fetchstusubjects')}}",
                    type: "POST",
                    data: {
                        semester_id: idSemester,
                        paper_tp: idCoutp,
                        _token: '{{csrf_token()}}'
                    },
                    dataType: 'json',
                    success: function (result) {
                        $('#subjectid').html('<option value="">-- Select Paper Name --</option>');
                        $.each(result.subjects, function (key, value) {
                            $("#subjectid").append('<option value="' + value
                                .id + '">' + value.papercode + ' - ' + value.papername + ' - ' + value.papertype + ' [' + value.course_name + ']</option>');
                        });
                    }
                });
            });

        });
    </script>

@endsection