@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="row">
        <div class="col-md-12">
            <div class="card">
                <div class="card-header border-bottom">
                    <h3 class="card-title">Monthly Attendance - Paper-wise</h3>
                </div>
                <div class="card-body">
                @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                    
                <form class="needs-validation" novalidate method="post" action="{{ route('facattd.pwise.post') }}">
                @csrf
                    <div class="row p-5">
                        <div class="col-sm-12 col-md-12 col-xl-3">
                            <div class="form-group">
                                <label for="sessionid" class="form-label text-muted">Select Year: <font style="font-weight: bold; color: red;">**</font></label>
                                <select class="form-control select2-show-search form-select" id="sessionid" name="sessionid" data-placeholder="Select Year" required>
                                    <option value="">Select Year</option>
                                    @foreach($actsession as $sessnm)
                                        <option value={{ $sessnm->id }} {{ $sessnm->id == $sessionid ? 'selected' : '' }}>{{ $sessnm->sessionid }}</option>
                                    @endforeach
                                </select>
                                <div class="invalid-feedback">Please select session.</div>
                            </div>
                        </div>
                        <div class="col-sm-12 col-md-12 col-xl-3">
                            <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-3">
                            <div class="form-group">
                                <label for="coutypeid" class="form-label text-muted">Select Paper Type: <font style="font-weight: bold; color: red;">**</font></label>
                                <select class="form-control select2-show-search form-select" data-placeholder="Select Paper Type" id="coutypeid" name="coutypeid" required>
                                    <option value="">Select Paper Type</option>
                                    @foreach($coutypemaster as $ctypenm)
                                        <option value="{{ $ctypenm->papertype }}" {{ $ctypenm->papertype == $coutypeid ? 'selected' : '' }}>{{ $ctypenm->papertype }}</option>
                                    @endforeach
                                </select>
                                <div class="invalid-feedback">Please select course type.</div>
                            </div>
                        </div>
                        <div class="col-sm-12 col-md-12 col-xl-3">
                            <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-3">
                            <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 multiple class="form-control select2-show-search form-select" data-placeholder="Select Attendance Type" id="attdtype" name="attdtype[]" required>
                                    <option value="">Select Attendance Type</option>
                                    @if(!empty($attdtype))
                                        <option value="Theory" {{ in_array('Theory', $attdtype) ? 'selected' : '' }}>Theory</option>
                                        <option value="Tutorial" {{ in_array('Tutorial', $attdtype) ? 'selected' : '' }}>Tutorial</option>
                                        <option value="Practical" {{ in_array('Practical', $attdtype) ? 'selected' : '' }}>Practical</option>
                                        <option value="Practice" {{ in_array('Practice', $attdtype) ? 'selected' : '' }}>Practice</option>
                                    @else
                                        <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>
                                    @endif
                                </select>                                
                                <div class="invalid-feedback">Please select attendance type.</div>
                            </div>
                        </div>                        
                        <div class="col-sm-12 col-md-12 col-xl-9">
                            <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->papercode }} {{ $subjectnm->papercode == $subjectid ? 'selected' : '' }}>{{ $subjectnm->papercode }} - {{ $subjectnm->papername }} - {{ $subjectnm->papertype }} - {{ $subjectnm->courseyear }}</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> Click to Get Attendance Record</button>
                        </div>
                    </div>                                                        
                </form>
                </div>
            </div>
        </div>
    </div>

    @if(!empty($sessionid) && !empty($semesterid) && !empty($coutypeid) && !empty($attdmonth) && !empty($attdtype) && !empty($subjectid))

        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header border-bottom">
                        <h3 class="card-title">Students Attendance Data : <b>{{ getcodebypaper($subjectid) }} - {{ $coutypeid }} - {{ $newattdtype }} - 
                            @if($attdmonth == "All")
                                All Months
                            @else
                                {{ getmonthmaster($attdmonth) }}
                            @endif
                        </b></h3>                        
                    </div>
                    <div class="card-body">          
                        <div class="row">
                            <div class="col-lg-12">
                                <div class="table-responsive">
                                    <table id="file-datatable" class="table table-bordered border-bottom">
                                        <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-15p border-bottom-0" style="font-size: 14px; font-weight: bold; text-align: center;">Exam. 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
                                                    $stucollrollno = "";
                                                    $stucollrollno = $itemone->collrollno;
                                                    $stuexamrollno = $itemone->examrollno;
                                                    $lectheld = $itemone->totlectheld;
                                                    $lectattd = $itemone->totlectattd;
                                                    $coursename = getstucourse($sessionid, $itemone->subjectid, $itemone->studentid);
                                                    $coursenewid = getstucourseid($sessionid, $semesterid, $itemone->studentid);
                                                    $weightage = getweightage($sessionid, $coursenewid, $itemone->studentid, "VALUES");
                                                    $weighton = getweightage($sessionid, $coursenewid, $itemone->studentid, "VALON");
                                                    $weighttpe = getweightage($sessionid, $coursenewid, $itemone->studentid, "VATYPE");
                                                    
                                                    if($weightage>0){
                                                        if($weighton == "LectHeld"){
                                                            if($weighttpe == "Percentage"){
                                                                $lectnewheld = (($lectheld * $weightage) / 100);
                                                                $lectheld = $lectheld - $lectnewheld;
                                                                if($lectattd > $lectheld){
                                                                    $lectheld = $lectattd;
                                                                }else{
                                                                    $lectheld = $lectheld;
                                                                }
                                                                if($lectheld>0 && $lectattd>0){
                                                                    $lectperc = Round(($lectattd / $lectheld) * 100, 2);
                                                                }else{
                                                                    $lectperc = 0;
                                                                }
                                                            }elseif($weighttpe == "Numbers"){
                                                                $lectheld = $lectheld - $weightage;
                                                                if($lectattd > $lectheld){
                                                                    $lectheld = $lectattd;
                                                                }else{
                                                                    $lectheld = $lectheld;
                                                                }                                                                
                                                                if($lectheld>0 && $lectattd>0){
                                                                    $lectperc = Round(($lectattd / $lectheld) * 100, 2);
                                                                }else{
                                                                    $lectperc = 0;
                                                                }
                                                            }
                                                        }elseif($weighton == "LectAttd"){
                                                            if($weighttpe == "Percentage"){
                                                                $lectnewattd = (($lectattd * $weightage) / 100);
                                                                $lectattd = $lectattd - $lectnewattd;
                                                                if($lectattd > $lectheld){
                                                                    $lectheld = $lectattd;
                                                                }else{
                                                                    $lectheld = $lectheld;
                                                                }                                                                 
                                                                if($lectheld>0 && $lectattd>0){
                                                                    $lectperc = Round(($lectattd / $lectheld) * 100, 2);
                                                                }else{
                                                                    $lectperc = 0;
                                                                }
                                                            }elseif($weighttpe == "Numbers"){
                                                                $lectattd = $lectattd - $weighttpe;
                                                                if($lectattd > $lectheld){
                                                                    $lectheld = $lectattd;
                                                                }else{
                                                                    $lectheld = $lectheld;
                                                                }                                                                 
                                                                if($lectheld>0 && $lectattd>0){
                                                                    $lectperc = Round(($lectattd / $lectheld) * 100, 2);
                                                                }else{
                                                                    $lectperc = 0;
                                                                }
                                                            }
                                                        }
                                                    }else{
                                                        if($lectattd > $lectheld){
                                                            $lectheld = $lectattd;
                                                        }else{
                                                            $lectheld = $lectheld;
                                                        }                                                         
                                                        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;">{{ $stucollrollno }}</td>
                                                    <td style="font-size: 12px; text-align: center;">{{ $stuexamrollno }}</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>
            </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>

    @endif

    <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;
                var idCoutp = $("#coutypeid").val();
                $("#subjectid").html('');
                $.ajax({
                    url: "{{url('api/fetchpaperwisenm')}}",
                    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
                                .papercode + '">' + value.papercode + ' - ' + value.papername + ' - ' + value.papertype + ' - ' + value.courseyear + '</option>');
                        });
                    }
                });
            });

            $('#coutypeid').on('change', function () {
                var idCoutp = this.value;
                var idSemester = $("#semesterid").val();
                $("#subjectid").html('');
                $.ajax({
                    url: "{{url('api/fetchpaperwisenm')}}",
                    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
                                .papercode + '">' + value.papercode + ' - ' + value.papername + ' - ' + value.papertype + ' - ' + value.courseyear + '</option>');
                        });
                    }
                });
            });
        });
    </script>
    @if(!empty($sessionid) && !empty($semesterid) && !empty($coutypeid) && !empty($attdmonth) && !empty($attdtype) && !empty($subjectid))
        <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: ["<40%", "40-54.99%", "55-66.65%", "66.66-69.99%", "70-74.99%", "75-79.99%", "80-84.99%", ">=85%"],
                    datasets: [{
                        label: "No. of Students in Attendance Range",
                        data: [{{ $twocnt }}, {{ $threecnt }}, {{ $fourcnt }}, {{ $fivecnt }}, {{ $sixcnt }}, {{ $sevencnt }}, {{ $eightcnt }}, {{ $ninecnt }}],
                        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>
    @endif

@endsection