@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 - Master Report</h3>
                </div>
                <div class="card-body">
                <form class="needs-validation" novalidate method="post" action="{{ route('facattd.altreport.post') }}">
                @csrf               
                    <div class="row">
                        <div class="col-md-4 mb-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)
                                        <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-4 mb-3">
                            <div class="form-group">
                                <label for="courseid" class="form-label text-muted">Select Course Name: <font style="font-weight: bold; color: red;">**</font></label>
                                <select class="form-control select2-show-search form-select" data-placeholder="Select Course Name" id="courseid" name="courseid" required>
                                    <option value="">Select Course Name</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-4 mb-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-md-4 mb-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 multiple 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)
                                        @if(!empty($coutypeid))
                                            <option value="{{ $ctypenm->papertype }}" {{ in_array($ctypenm->papertype, $coutypeid) ? 'selected' : '' }}>{{ $ctypenm->papertype }}</option>
                                        @else
                                            <option value="{{ $ctypenm->papertype }}" {{ $ctypenm->papertype == $coutypeid ? 'selected' : '' }}>{{ $ctypenm->papertype }}</option>
                                        @endif
                                    @endforeach
                                </select>
                                <div class="invalid-feedback">Please select course type.</div>
                            </div>
                        </div>                        
                        <div class="col-md-4 mb-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-md-4 mb-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-md-12 mb-3">
                            <div class="form-group">
                                <label class="ckbox">
                                    <input type="checkbox" name="chkweight" id="chkweight" value="Yes" 
                                    @if($chkweight == "Yes")
                                    checked
                                    @endif><span class="text-13 text-bold text-danger">Check for Apply Weightage on Attendance otherwise leave empty.</span>
                                </label>
                            </div>
                            <button class="btn btn-success" type="submit"><i class="fe fe-upload-cloud me-2"></i> Click to Get Attendance Record</button>
                        </div>
                    </div>
                    @if(Session::has('success'))
                        <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('success') }}</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>
                </div>
            </div>
        </div>
    </div>  

    @if(!empty($sessionid) && !empty($courseid))
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-header border-bottom">
                        <h3 class="card-title">Students Attendance Master Report</h3>
                        <div class="card-options">
                            <a href="{{ route('facattd.altreport.download', [$sessionid, $courseid, $newattdtype, $newcoutypeid, $percfrom, $percto, $chkweight]) }}" class="btn btn-warning 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 border-bottom w-100">
                                        <thead>
                                            <tr>
                                                <th class="wd-15p border-bottom-0" style="text-align: center; font-weight: bold; " colspan="7">{{ $coursenamedisp }} - {{ $newattdtype }} - {{ $sessionname }} @if($chkweight == "Yes")(Attendance Weightage Applied)@endif</th>
                                            </tr>
                                            <tr>
                                                <th class="wd-15p border-bottom-0" style="text-align: center; font-weight: bold; ">S. No.</th>
                                                <th class="wd-15p border-bottom-0" style="text-align: center; font-weight: bold; ">College Roll No.</th>
                                                <th class="wd-15p border-bottom-0" style="font-weight: bold; ">Student's Name</th>
                                                <th class="wd-15p border-bottom-0" style="font-weight: bold; ">Contact Details</th>
                                                <th class="wd-25p border-bottom-0" style="text-align: center; font-weight: bold; ">Lecture Delivered</th>
                                                <th class="wd-25p border-bottom-0" style="text-align: center; font-weight: bold; ">Lecture Attended</th>
                                                <th class="wd-25p border-bottom-0" style="text-align: center; font-weight: bold; ">(%)</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $intcount = 1;
                                                $grheldtot = 0;
                                                $grattdtot = 0;
                                                $grperctot = 0;
                                            @endphp                                            
                                            @foreach($restData as $keyone => $itemone)
                                                @php
                                                    $cntcount = 1;
                                                @endphp                                             
                                                @php
                                                    $grheldtot = $itemone['grlectheld'];
                                                    $grattdtot = $itemone['grlectattd'];
                                                    if($grheldtot>0 && $grattdtot>0){
                                                        $grperctot = Round(($grattdtot / $grheldtot) * 100,2);
                                                    }else{
                                                        $grperctot = 0;
                                                    }
                                                @endphp
                                                @if($grperctot >= $percfrom && $grperctot <= $percto)
                                                    <tr>
                                                        <td style="font-size: 12px; text-align: center; ">{{ $intcount }}</td>
                                                        <td style="font-size: 12px; text-align: center; ">{{ $itemone['stucollrollno'] }}</td>
                                                        <td style="font-size: 12px; ">{{ $itemone['stufullname'] }}</td>
                                                        <td style="font-size: 12px; ">{{ $itemone['stuemail'] }}<br>{{ $itemone['stumobile'] }}</td>
                                                        <td style="font-size: 12px; " colspan="3">&nbsp;</td>
                                                    </tr>
                                                    @foreach($itemone['finYear'] as $keyone)
                                                        <tr>
                                                            <td style="font-size: 12px; text-align: right; ">{{ $intcount }}.{{ $cntcount }}</td>
                                                            <td style="font-size: 12px; " colspan="3">{{ $keyone['stupapercd'] }} - {{ $keyone['stupapernm'] }} [{{ $keyone['stupapertp'] }}]</td>
                                                            <td style="font-size: 12px; text-align: center; ">{{ Round($keyone['stuheld'],2) }}</td>
                                                            <td style="font-size: 12px; text-align: center; ">{{ Round($keyone['stuattd'],2) }}</td>
                                                            <td style="font-size: 12px; text-align: center; ">{{ Round($keyone['stuperc'],2) }}</td>
                                                        </tr>
                                                        @php
                                                            $cntcount++;
                                                        @endphp                                                     
                                                    @endforeach
                                                    <tr>
                                                        <td style="font-size: 12px; font-weight: bold; text-align: center; " colspan="4">TOTAL IN ALL SUBJECTS</td>
                                                        <td style="font-size: 12px; font-weight: bold; text-align: center; ">{{ Round($grheldtot,2) }}</td>
                                                        <td style="font-size: 12px; font-weight: bold; text-align: center; ">{{ Round($grattdtot,2) }}</td>
                                                        <td style="font-size: 12px; font-weight: bold; text-align: center; ">{{ $grperctot }}</td>
                                                    </tr>
                                                    @php
                                                        $intcount++;
                                                    @endphp
                                                @endif
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    @endif

@endsection