@extends('dashboard_connect.dash_master')
@section('pagescontents')
	<!-- PAGE-HEADER -->
	<div class="page-header">
		<div>
			<h1 class="page-title">Dashboard</h1>
		</div>
		<div class="ms-auto pageheader-btn">
			<ol class="breadcrumb">
				<li class="breadcrumb-item"><a href="javascript:void(0);">College Result</a></li>
				<li class="breadcrumb-item active" aria-current="page">College Result View</li>
			</ol>
		</div>
	</div>
	<!-- PAGE-HEADER END -->

	<!-- ROW-1 OPEN -->
    <div class="row">
        <div class="col-md-12">
            <div  class="card">
                <div class="card-header border-bottom">
                    <h3 class="card-title"><b>College Result Details</b></h3>
                </div>
                <div class="card-body">
                    <form class="needs-validation" novalidate method="post" action="{{ route('staff.result.post') }}">
                    @csrf
                        <div class="row">
                            <div class="col-md-2 mb-3">
                                <div class="form-group">
                                    <select class="form-control select2-show-search form-select" id="sessionid" name="sessionid" data-placeholder="Choose Session...">
                                        <option label="Choose one"></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-md-3 mb-3">
                                <div class="form-group">
                                    <select class="form-control select2-show-search form-select" data-placeholder="Select Course Name" id="courseid" name="courseid">
                                        <option label="Choose one"></option>
                                        @foreach($coursemaster as $coursenm)
                                            <option value={{ $coursenm->id }} {{ $coursenm->id == $courseid ? 'selected' : '' }}>{{ $coursenm->coursename }} {{ $coursenm->courseyear }}</option>
                                        @endforeach
                                    </select>
                                    <div class="invalid-feedback">Please select course name.</div>
                                </div>
                            </div>
                            <div class="col-md-2 mb-3">
                                <div class="form-group">
                                    <select class="form-control select2-show-search form-select" data-placeholder="Select Result Type" id="resulttp" name="resulttp">
                                        <option label="Choose one"></option>
                                        <option value="Grade" {{ $resulttp == "Grade" ? 'selected' : '' }}>Grade-wise</option>
                                        <option value="Marks" {{ $resulttp == "Marks" ? 'selected' : '' }}>Marks-wise</option>
                                        <option value="Both" {{ $resulttp == "Both" ? 'selected' : '' }}>Both</option>
                                    </select>
                                    <div class="invalid-feedback">Please select result type.</div>
                                </div>
                            </div>
                            @php
                                if($maxmarksall>0){
                                    $maxmarksall = $maxmarksall;
                                }else{
                                    $maxmarksall = 0;
                                }
                                if($resulttp == "Marks" || $resulttp == "Both"){
                                    $msgtext = "";
                                }else{
                                    $msgtext = "disabled";
                                }
                            @endphp
                            <div class="col-md-2 mb-3">
                                <div class="form-group">
                                    <input id="maxmarksall" name="maxmarksall" type="text" placeholder="Enter Max Marks" value="{{ $maxmarksall }}" class="form-control text-dark" {{ $msgtext }}>
                                    <div class="invalid-feedback">Please enter max marks.</div>
                                </div>
                            </div>
                            <div class="col-md-2">
                                <button class="btn btn-secondary"><i class="fe fe-list"></i> View Students List</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            @if(!empty($sessionid) && !empty($courseid) && !empty($resulttp))
                @php
                    $courseyear = getcourseyear($courseid);
                @endphp
                <div class="card">
                    <div class="card-header border-bottom">
                        <h3 class="card-title">{{ getcoursename($courseid) }} Students List - Add/Update Results</h3>
                    </div>
                    <form class="needs-validation" novalidate method="post" action="{{ route('staff.result.save') }}">
                    @csrf
                        <input type="hidden" id="sessionidext" name="sessionidext" value="{{ $sessionid }}">
                        <input type="hidden" id="courseidext" name="courseidext" value="{{ $courseid }}">
                        <input type="hidden" id="resulttpext" name="resulttpext" value="{{ $resulttp }}">
                        <input type="hidden" id="maxmarksallext" name="maxmarksallext" value="{{ $maxmarksall }}">
                        <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>
                                                    <th class="wd-15p border-bottom-0" style="font-size: 11px;">S. No.</th>
                                                    <th class="wd-15p border-bottom-0" style="font-size: 11px;">Student Details</th>
                                                    @if($resulttp == "Grade")
                                                        <th class="wd-10p border-bottom-0" style="font-size: 11px;">Grand CGPA</th>
                                                    @elseif($resulttp == "Marks")
                                                        <th class="wd-10p border-bottom-0" style="font-size: 11px;">Max. Marks</th>
                                                        <th class="wd-10p border-bottom-0" style="font-size: 11px;">Marks Obtained</th>
                                                    @elseif($resulttp == "Both")
                                                        <th class="wd-10p border-bottom-0" style="font-size: 11px;">Max. Marks</th>
                                                        <th class="wd-10p border-bottom-0" style="font-size: 11px;">Marks Obtained</th>
                                                        <th class="wd-10p border-bottom-0" style="font-size: 11px;">Grand CGPA</th>
                                                    @endif
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Division</th>
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Result</th>
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Remarks (If any)</th>
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Student Type</th>
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Studying From</th>
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Studying To</th>
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Exam Held In</th>
                                                    <th class="wd-25p border-bottom-0" style="font-size: 11px;">Dues Paid Upto</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @php
                                                    $intcount = 1;
                                                    $displmessage = "";
                                                    $curryear = \Carbon\Carbon::now()->year;
                                                @endphp
                                                @foreach($studentdata as $keyone => $itemone)
                                                    @php
                                                        $displmessage = getdisciplineact($itemone->studentid, $courseyear);
                                                        $getresultid = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "IFEXISTS");
                                                        if($getresultid>0){
                                                            $getmaxmarks = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "MAXMARKS");
                                                            $getobtmarks = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "OBTMARKS");
                                                            $getgrcgpa = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "GRCGPA");
                                                            $getresult = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "RESULT");
                                                            $stutype = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "STUTYPE");
                                                            $studfrom = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "STUDYFRM");
                                                            $studto = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "STUDYTO");
                                                            $examheld = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "EXAMHELD");
                                                            $duespaid = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "DUESPAID");
                                                            $finaldiv = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "FINADIV");
                                                            $extremarks = getresultall($itemone->sessionid, $itemone->courseid, $courseyear, $itemone->studentid, "EXTREMARKS");
                                                        }else{
                                                            $firsttwo = substr($itemone->collrollno,0,2);
                                                            $coursesub = substr(getcoursename($courseid), 0, 1);
                                                            if($coursesub == "B"){
                                                                $lasttwo = $firsttwo + 3;
                                                            }elseif($coursesub == "M"){
                                                                $lasttwo = $firsttwo + 2;
                                                            }
                                                            $strsess = "20" . $firsttwo;
                                                            $endsess = "20" . $lasttwo;
                                                            $getmaxmarks = $maxmarksall;
                                                            $getobtmarks = "0";
                                                            $getgrcgpa = "0";
                                                            $getresult = "";
                                                            $stutype = "";
                                                            $studfrom = $strsess;
                                                            $studto = $endsess;
                                                            $examheld = $endsess;
                                                            $duespaid = $endsess;
                                                            $finaldiv = "";
                                                            $extremarks = "NA";
                                                        }
                                                    @endphp
                                                    <tr>
                                                        <td style="font-size: 11px;">
                                                            {{ $intcount }}.
                                                            <input type="hidden" id="rowcourseid" name="rowcourseid[]" value="{{ $itemone->courseid }}">
                                                            <input type="hidden" id="rowcourseyear" name="rowcourseyear[]" value="{{ $courseyear }}">
                                                            <input type="hidden" id="rowsessionid" name="rowsessionid[]" value="{{ $itemone->sessionid }}">
                                                            <input type="hidden" id="rowstudentid" name="rowstudentid[]" value="{{ $itemone->studentid }}">
                                                            <input type="hidden" id="rowresulttp" name="rowresulttp[]" value="{{ $resulttp }}">
                                                        </td>
                                                        <td style="font-size: 11px;">
                                                            {{ $itemone->collrollno }}
                                                            <br>{{ $itemone->stuname }}<br>{{ $itemone->email }}<br>{{ $itemone->mobileno }}
                                                            @if($displmessage !== "NA")
                                                                <br><font class="text-danger" style="font-weight: bold; font-size: 11px;">{{ $displmessage }}</font>
                                                            @endif
                                                        </td>
                                                        @if($resulttp == "Grade")
                                                            <td>
                                                                <input id="grcgpa" name="grcgpa[]" type="text" class="form-control text-dark" value="{{ Round($getgrcgpa,7) }}" style="width: 80px; height: 30px;" required>
                                                                <input id="maxmarks" name="maxmarks[]" type="hidden" value="{{ Round($getmaxmarks,7) }}">
                                                                <input id="marksobt" name="marksobt[]" type="hidden" value="{{ Round($getobtmarks,7) }}">
                                                            </td>
                                                        @elseif($resulttp == "Marks")
                                                            <td><input id="maxmarks" name="maxmarks[]" type="text" class="form-control text-dark" value="{{ Round($getmaxmarks,7) }}" style="width: 80px; height: 30px;" tabindex="0" required></td>
                                                            <td>
                                                                <input id="marksobt" name="marksobt[]" type="text" class="form-control text-dark" value="{{ Round($getobtmarks,7) }}" style="width: 80px; height: 30px;" tabindex="1" required>
                                                                <input id="grcgpa" name="grcgpa[]" type="hidden" value="{{ Round($getgrcgpa,7) }}">
                                                            </td>
                                                        @elseif($resulttp == "Both")
                                                            <td><input id="maxmarks" name="maxmarks[]" type="text" class="form-control text-dark" value="{{ Round($getmaxmarks,7) }}" style="width: 80px; height: 30px;" tabindex="0" required></td>
                                                            <td><input id="marksobt" name="marksobt[]" type="text" class="form-control text-dark" value="{{ Round($getobtmarks,7) }}" style="width: 80px; height: 30px;" tabindex="1" required></td>
                                                            <td><input id="grcgpa" name="grcgpa[]" type="text" class="form-control text-dark" value="{{ Round($getgrcgpa,7) }}" tabindex="2" required></td>
                                                        @endif
                                                        <td>
                                                            <div class="form-group">
                                                                <select class="form-control select2-show-search form-select" id="finaldiv" name="finaldiv[]" style="width: 80px; height: 30px;" required>
                                                                    <option value="FIRST DIVISION" {{ $finaldiv == "FIRST DIVISION" ? 'selected' : '' }}>FIRST DIVISION</option>
                                                                    <option value="SECOND DIVISION" {{ $finaldiv == "SECOND DIVISION" ? 'selected' : '' }}>SECOND DIVISION</option>
                                                                    <option value="THIRD DIVISION" {{ $finaldiv == "THIRD DIVISION" ? 'selected' : '' }}>THIRD DIVISION</option>
                                                                    <option value="FAILED" {{ $finaldiv == "FAILED" ? 'selected' : '' }}>FAILED</option>
                                                                </select>
                                                                <div class="invalid-feedback">Please select result.</div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="form-group">
                                                                <select class="form-control select2-show-search form-select" id="finalresult" name="finalresult[]" style="width: 80px; height: 30px;" required>
                                                                    <option value="PASSED" {{ $getresult == "PASSED" ? 'selected' : '' }}>PASSED</option>
                                                                    <option value="FAILED" {{ $getresult == "FAILED" ? 'selected' : '' }}>FAILED</option>
                                                                    <option value="ER" {{ $getresult == "ER" ? 'selected' : '' }}>ESSENTIAL REAPPEAR</option>
                                                                    <option value="UFM" {{ $getresult == "UFM" ? 'selected' : '' }}>UFM</option>
                                                                </select>
                                                                <div class="invalid-feedback">Please select result.</div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="form-group">
                                                                <input id="extremarks" name="extremarks[]" type="text" class="form-control text-dark" value="{{ $extremarks }}" style="width: 80px; height: 30px;" required>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="form-group">
                                                                <select class="form-control select2-show-search form-select" id="stutype" name="stutype[]" style="width: 80px; height: 30px;" required>
                                                                    <option value="REGULAR" {{ $stutype == "REGULAR" ? 'selected' : '' }}>REGULAR</option>
                                                                    <option value="EX-STUDENT" {{ $stutype == "EX-STUDENT" ? 'selected' : '' }}>EX-STUDENT</option>
                                                                </select>
                                                                <div class="invalid-feedback">Please select student type.</div>
                                                            </div>                                                            
                                                        </td>
                                                        <td>
                                                            <div class="form-group">
                                                                <select class="form-control select2-show-search form-select" id="studyfrom" name="studyfrom[]" style="width: 80px; height: 30px;" required>
                                                                    @php
                                                                        getyear($studfrom);
                                                                    @endphp
                                                                </select>
                                                                <div class="invalid-feedback">Please select study from (year).</div>
                                                            </div>                                                            
                                                        </td>
                                                        <td>
                                                            <div class="form-group">
                                                                <select class="form-control select2-show-search form-select" id="studyto" name="studyto[]" style="width: 80px; height: 30px;" required>
                                                                    @php
                                                                        getyear($studto);
                                                                    @endphp
                                                                </select>
                                                                <div class="invalid-feedback">Please select study to (year).</div>
                                                            </div>                                                            
                                                        </td>
                                                        <td>
                                                            <div class="form-group">
                                                                <select class="form-control select2-show-search form-select" id="examheld" name="examheld[]" style="width: 80px; height: 30px;" required>
                                                                    @php
                                                                        getyear($examheld);
                                                                    @endphp
                                                                </select>
                                                                <div class="invalid-feedback">Please select exam held.</div>
                                                            </div>                                                            
                                                        </td>
                                                        <td>
                                                            <div class="form-group">
                                                                <select class="form-control select2-show-search form-select" id="duespaid" name="duespaid[]" style="width: 80px; height: 30px;" required>
                                                                    @php
                                                                        getyear($duespaid);
                                                                    @endphp
                                                                </select>
                                                                <div class="invalid-feedback">Please select dues paid upto.</div>
                                                            </div>                                                            
                                                        </td>
                                                    </tr>
                                                @php
                                                    $intcount++;
                                                @endphp                                                
                                                @endforeach
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="card-header float-end">
                            <button class="btn btn-success"><i class="fe fe-save"></i> Click to Save Student's Result</button>
                        </div>
                    </form>
                </div>
            @endif            
        </div>
    </div>

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

    <script>
        $(document).ready(function () {
            $('#resulttp').on('change', function () {
                var idResultTp = this.value;
                if(idResultTp == "Marks" || idResultTp == "Both"){
                    $('#maxmarksall').attr("disabled", false);
                }else{
                    $('#maxmarksall').attr("disabled", true);
                }
            });
  
        });
    </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>
@endsection