@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 - Send Message</h3>
                </div>
                <div class="card-body">
                <form class="needs-validation" novalidate method="post" action="{{ route('stuattd.email.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-3">
                            <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-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="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 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-3">
                            <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.</div>
                            </div>
                        </div>
                        <div class="col-sm-12 col-md-12 col-xl-3">
                            <div class="form-group">
                                <label for="percfrom" class="form-label text-muted">Percentage From: <font style="font-weight: bold; color: red;">**</font></label>
                                <input id="percfrom" name="percfrom" type="text" class="form-control text-dark" placeholder="Enter Percentage From (In Numbers)" value="{{ $percfrom }}" onkeypress="return isNumberKey(event,this)" required>
                                <div class="invalid-feedback">Enter percentage from (in numbers).</div>
                            </div>
                        </div>
                        <div class="col-sm-12 col-md-12 col-xl-3">
                            <div class="form-group">
                                <label for="percfrom" class="form-label text-muted">Percentage To: <font style="font-weight: bold; color: red;">**</font></label>
                                <input id="percto" name="percto" type="text" class="form-control text-dark" placeholder="Enter Percentage To (In Numbers)" value="{{ $percto }}" onkeypress="return isNumberKey(event,this)" required>
                                <div class="invalid-feedback">Enter percentage to (in numbers).</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>
    </div>

    @if(!empty($subjectid) && !empty($sessionid) && $percfrom>=0 && $percto>=0)
        <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>{{ getpapername($subjectid) }} - {{ $attdtype }}</b></h3>
                    </div>
                    <div class="card-body">
                        <form class="needs-validation" novalidate method="post" action="{{ route('stuattd.email.send') }}">
                        @csrf
                        <div class="row">
                            <div class="col-md-12 mb-3">
                                <div class="form-group">
                                    <label for="emailtostudents" class="form-label text-muted">Email Send To Student(s):</label>
                                    <select multiple class="form-control select2-show-search form-select" data-placeholder="To Student(s)" id="oldstudentid" name="oldstudentid[]" required>
                                        @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, "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;
                                                    }
                                                }
                                            if($lectperc >= $percfrom && $lectperc <= $percto){
                                            @endphp
                                                <option value="{{ $itemone->studentid }}" selected>{{ $itemone->email }} ({{ $itemone->name }} {{ $itemone->lname }})</option>
                                            @php
                                                }
                                                $intcount++;
                                            @endphp                                                
                                        @endforeach
                                    </select>
                                    <div class="invalid-feedback">Please select atleast one student.</div>
                                </div>
                            </div>
                            <div class="col-md-12 mb-3">
                                <div class="form-group">
                                    <label for="emailconts" class="form-label text-muted">Enter Email Message Contents:</label>
                                    <textarea id="summernote" id="emailconts" name="emailconts" required>{{ $htmlmsg }}</textarea>
                                    <div class="invalid-feedback">Please enter some text.</div>
                                </div>
                            </div>                                                
                            <div class="col-md-12 mb-3" style="text-align: right;">
                                <input type="hidden" id="dtsessionid" name="dtsessionid" value="{{ $sessionid }}">
                                <input type="hidden" id="dtsubjectid" name="dtsubjectid" value="{{ $subjectid }}">
                                <input type="hidden" id="dtattdtype" name="dtattdtype" value="{{ $attdtype }}">
                                <button class="btn btn-info-gradient" type="submit"><i class="fe fe-send me-2"></i> Send Email to Student(s)</button>
                            </div>
                        </div>
                    </div>                    
                </div>
            </div>
        </div>
    @endif

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

	<SCRIPT language=Javascript>
		<!--
        function isNumberKey(evt, element){

            var charCode = (evt.which) ? evt.which : event.keyCode
            if (charCode > 31 && (charCode < 48 || charCode > 57) && !(charCode == 46 || charCode == 8 || charCode == 45))
                return false;
            else {
                var len = $(element).val().length;

                // Validation Point
                var index = $(element).val().indexOf('.');
                if ((index > 0 && charCode == 46) || len == 0 && charCode == 46) {
                    return false;
                }
                if (index > 0) {
                    var CharAfterdot = (len + 1) - index;
                    if (CharAfterdot > 6) {
                        return false;
                    }
                }

                // Validating Negative sign
                index = $(element).val().indexOf('-');
                if ((index > 0 && charCode == 45) || (len > 0 && charCode == 45)) {
                    return false;
                }
            }
            return true;
        }
		//-->
	</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