@extends('dashboard_connect.dash_master')
@section('pagescontents')
<link id="style" href="https://cdn.datatables.net/2.1.8/css/dataTables.dataTables.css" rel="stylesheet" />
<link id="style" href="https://cdn.datatables.net/buttons/3.1.2/css/buttons.dataTables.css" rel="stylesheet" />
	<!-- PAGE-HEADER -->
	<div class="page-header">
		<div>
			<h1 class="page-title">Student Union Election</h1>
		</div>
		<div class="ms-auto pageheader-btn">
			<ol class="breadcrumb">
				<li class="breadcrumb-item"><a href="javascript:void(0);">Student Union Election</a></li>
				<li class="breadcrumb-item active" aria-current="page">Attendance Data</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">Student Union Election - Attendance Report</h3>
                </div>
                <div class="card-body">
                <form class="needs-validation" novalidate method="post" action="{{ route('stuelect.altreport.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="Select 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-2 mb-3">
                            <div class="form-group">
                                <select class="form-control select2-show-search form-select" data-placeholder="Select Semester" id="semesterid" name="semesterid" required>
                                    <option value="">Select Semester</option>
                                    <option value="I+II" {{ $semesterid == "I+II" ? 'selected' : '' }}>Semester I + Semster II</option>
                                    <option value="III+IV" {{ $semesterid == "III+IV" ? 'selected' : '' }}>Semester III + Semster IV</option>
                                    <option value="V+VI" {{ $semesterid == "V+VI" ? 'selected' : '' }}>Semester V + Semster VI</option>
                                </select>
                                <div class="invalid-feedback">Please select semester name.</div>
                            </div>
                        </div>
                        <div class="col-md-2 mb-3">
                            <div class="form-group">
                                <input id="searchtxt" name="searchtxt" type="text" class="form-control text-dark" placeholder="Enter College Roll No. or Exam. Roll No." value="{{ $searchtxt }}" required>
                                <div class="invalid-feedback">Please enter details.</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <button type="submit" class="btn btn-info-gradient"><i class="fe fe-search"></i> Search Record</button>
                        </div>
                    </div>
                    @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>
                </div>
            </div>
        </div>
    </div>

    @if(!empty($sessionid) && !empty($semesterid) && !empty($searchtxt))
        <div class="row row-sm">
            <div class="col-lg-12">
                <div class="card custom-card">
                    <div class="card-header border-bottom">
                        <h3 class="card-title">Attendance Details</h3>
                    </div>
                    <div class="card-body">
                        <div id='printMe'>
                            <div class="table-responsive">
                            @php
                                $intcount = 1;
                                $grtotthheld = 0;
                                $grtotthattd = 0;
                                $grtottutheld = 0;
                                $grtottutattd = 0;
                                $grandheld = 0;
                                $grandattd = 0;
                                $grandperc = 0;
                            @endphp                            
                            @foreach($restData as $keyone => $itemone)
                                <table class="table table-bordered">
                                    @if($intcount<=1)
                                        <thead>
                                            <tr>
                                                <th colspan="8" style="text-align:center;"><img src="{{ asset('colllogo.fw.png') }}" border="0"><br><font style="font-size: 24px; font-weight:bold;">KIRORI MAL COLLEGE</font><br><font style="font-size: 12px; font-weight:bold;">(UNIVERSITY OF DELHI)<br>UNIVERSITY ENCLAVE, DELHI - 110 007<br>(Phone No. - 011-7121 9084 : Email - principal@kmc.du.ac.in)</font></th>
                                            </tr>                                        
                                            <tr>
                                                <th colspan="2" style="text-align: left;">College Roll No. :: <b>{{ $itemone['stucollrollno'] }}</b></th>
                                                <th colspan="2" style="text-align: left;">Student's Name :: <b>{{ $itemone['stuname'] }}</b></th>
                                                <th colspan="2" style="text-align: left;">Session :: <b>{{ getsessionname($itemone['stusessionid']) }}</b></th>
                                                <th colspan="2" style="text-align: right;">Exam. Roll No. :: <b>{{ $itemone['stuexamrollno'] }}<b></th>
                                            </tr>
                                            <tr>
                                                <th colspan="2" style="text-align: left;">Enrolment No. :: <b>{{ $itemone['stuenrolmentno'] }}<b></th>
                                                <th colspan="2" style="text-align: left;">Mobile No. :: <b>{{ $itemone['stumobileno'] }}</b></th>
                                                <th colspan="2" style="text-align: left;">Email 1 :: <b>{{ $itemone['stuemail'] }}</b></th>
                                                <th colspan="2" style="text-align: right;">Email 2 :: <b>{{ $itemone['stuusername'] }}</b></th>
                                            </tr>
                                        </thead>
                                    @endif
                                </table>
                                <table class="table table-bordered">
                                    <thead>
                                        <tr class="table-success">
                                            <th colspan="10" style="text-align: center; font-weight: bold; font-size: 18px;">ATTENDANCE DATA :: {{ Str::upper($itemone['stucoursename']) }} {{ Str::upper($itemone['stucourseyear']) }}</th>
                                        </tr>
                                        <tr>
                                            <th style="text-align: center; font-weight: bold;">Paper Type</th>
                                            <th style="font-weight: bold;">Paper Name</th>
                                            <th class="bg-danger-transparent" colspan="4" style="text-align: center; font-weight: bold;">Theory Attendance</th>
                                            <th class="bg-dark-transparent" colspan="4" style="text-align: center; font-weight: bold;">Tutorial Attendance</th>
                                            <!--th class="bg-success-transparent" colspan="4" style="text-align: center; font-weight: bold;">Practical Attendance</th-->
                                        </tr>
                                        <tr>
                                            <th colspan="2">&nbsp;</th>
                                            <th class="bg-danger-transparent" style="text-align: center; font-weight: bold;">Held</th>
                                            <th class="bg-danger-transparent" style="text-align: center; font-weight: bold;">Attended</th>
                                            <th class="bg-danger-transparent" style="text-align: center; font-weight: bold;">(%)</th>
                                            <th class="bg-danger-transparent" style="text-align: center; font-weight: bold;">Weightage</th>
                                            <th class="bg-dark-transparent" style="text-align: center; font-weight: bold;">Held</th>
                                            <th class="bg-dark-transparent" style="text-align: center; font-weight: bold;">Attended</th>
                                            <th class="bg-dark-transparent" style="text-align: center; font-weight: bold;">(%)</th>
                                            <th class="bg-dark-transparent" class="bg-dark-transparent" style="text-align: center; font-weight: bold;">Weightage</th>
                                            <!--th class="bg-success-transparent" style="text-align: center; font-weight: bold;">Held</th>
                                            <th class="bg-success-transparent" style="text-align: center; font-weight: bold;">Attended</th>
                                            <th class="bg-success-transparent" style="text-align: center; font-weight: bold;">(%)</th>                                        
                                            <th class="bg-success-transparent" style="text-align: center; font-weight: bold;">Weightage</th -->
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php
                                            $intcount = 1;
                                        @endphp
                                        @foreach($itemone['subData'] as $keyone)
                                            <tr>
                                                <td style="text-align: center;">{{ $keyone['stupapertype'] }}</td>
                                                <td>{{ Str::upper($keyone['stupapername']) }} [{{ $keyone['stupapercode'] }}]</td>
                                                <td class="bg-danger-transparent" style="text-align: center;">{{ Round($keyone['attdheldth'],2) }}</td>
                                                <td class="bg-danger-transparent" style="text-align: center;">{{ Round($keyone['attdattdth'],2) }}</td>
                                                <td class="bg-danger-transparent" style="text-align: center;">{{ Round($keyone['dtcountpercth'],3) }}</td>
                                                <td class="bg-danger-transparent" style="text-align: center;">{{ Round($keyone['weightage'],2) }}</td>
                                                <td class="bg-dark-transparent" style="text-align: center;">{{ Round($keyone['attdheldtut'],2) }}</td>
                                                <td class="bg-dark-transparent" style="text-align: center;">{{ Round($keyone['attdattdtut'],2) }}</td>
                                                <td class="bg-dark-transparent" style="text-align: center;">{{ Round($keyone['dtcountperctut'],3) }}</td>
                                                <td class="bg-dark-transparent" style="text-align: center;">{{ Round($keyone['weightage'],2) }}</td>
                                                <!--td class="bg-success-transparent" style="text-align: center;">{{ Round($keyone['attdheldprac'],2) }}</td>
                                                <td class="bg-success-transparent" style="text-align: center;">{{ Round($keyone['attdattdprac'],2) }}</td>
                                                <td class="bg-success-transparent" style="text-align: center;">{{ Round($keyone['dtcountpercprac'],3) }}</td>
                                                <td class="bg-success-transparent" style="text-align: center;">{{ Round($keyone['weightage'],2) }}</td -->
                                            </tr>
                                            @php
                                                $intcount++;
                                            @endphp
                                        @endforeach
                                        @php
                                            $grtotthheld = $grtotthheld + $itemone['thheld'];
                                            $grtotthattd = $grtotthattd + $itemone['thattd'];
                                            $grtottutheld = $grtottutheld + $itemone['tutheld'];
                                            $grtottutattd = $grtottutattd + $itemone['tutattd'];
                                        @endphp
                                        <tr>
                                            <td colspan="2" style="font-weight: bold; text-align: center;">SUB TOTAL ({{ Str::upper($itemone['stucoursename']) }} {{ Str::upper($itemone['stucourseyear']) }})</td>
                                            <td class="bg-danger-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['thheld'],2) }}</td>
                                            <td class="bg-danger-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['thattd'],2) }}</td>
                                            <td class="bg-danger-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['grtheoryper'],2) }}</td>
                                            <td class="bg-danger-transparent">&nbsp;</td>
                                            <td class="bg-dark-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['tutheld'],2) }}</td>
                                            <td class="bg-dark-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['tutattd'],2) }}</td>
                                            <td class="bg-dark-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['grtutper'],2) }}</td>
                                            <td class="bg-dark-transparent">&nbsp;</td>
                                            <!--td class="bg-success-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['practheld'],2) }}</td>
                                            <td class="bg-success-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['practattd'],2) }}</td>
                                            <td class="bg-success-transparent" style="font-weight: bold; text-align: center;">{{ Round($itemone['grpractper'],2) }}</td>
                                            <td class="bg-success-transparent">&nbsp;</td -->
                                        </tr>
                                    </tbody>
                                </table>
                                @php
                                    $intcount++;
                                @endphp                                    
                            @endforeach
                            </div>
                            @php
                                $grandheld = $grtotthheld + $grtottutheld;
                                $grandattd = $grtotthattd + $grtottutattd;
                                if($grandheld>0 && $grandattd>0){
                                    $grandperc = Round(($grandattd / $grandheld) * 100,2);
                                }else{
                                    $grandperc = 0;
                                }
                            @endphp
                            <table class="table table-bordered">
                                <thead>
                                    @if($semesterid == "I+II")
                                        <tr class="table-success">
                                            <th style="text-align: center; font-weight: bold; font-size: 16px;" colspan="4">SUMMARY SEMESTER I AND SEMESTER II :: {{ getsessionname($sessionid) }}</th>
                                        </tr>
                                    @elseif($semesterid == "III+IV")
                                        <tr class="table-success">
                                            <th style="text-align: center; font-weight: bold; font-size: 16px;" colspan="4">SUMMARY SEMESTER III AND SEMESTER IV :: {{ getsessionname($sessionid) }}</th>
                                        </tr>
                                    @elseif($semesterid == "V+VI")
                                        <tr class="table-success">
                                            <th style="text-align: center; font-weight: bold; font-size: 16px;" colspan="4">SUMMARY SEMESTER V AND SEMESTER VI :: {{ getsessionname($sessionid) }}</th>
                                        </tr>
                                    @endif                                                                        
                                    <tr>
                                        <th style="text-align: left;"><b>Total Theory Attendance (Attd./Held)</b></th>
                                        <th style="text-align: left;"><b>{{ Round($grtotthattd,2) }} / {{ Round($grtotthheld,2) }}</b></th>
                                        <th style="text-align: left;"><b>Total Tutorial Attendance (Attd./Held)</b></th>
                                        <th style="text-align: left;"><b>{{ Round($grtottutattd,2) }} / {{ Round($grtottutheld,2) }}</b></th>
                                    </tr>
                                    <tr>
                                        <th style="text-align: left;"><b>Total Theory+Tutorial Attendance (Attd./Held)</b></th>
                                        <th style="text-align: left;"><b>{{ Round($grandattd,2) }} / {{ Round($grandheld,2) }}</b></th>
                                        <th style="text-align: left;"><b>Theory+Tutorial Percentage</b></th>
                                        <th style="text-align: left;"><b>{{ $grandperc }}%</b></th>
                                    </tr>                                    
                                </thead>
                            </table>                            
                        </div>
                    </div>
                    <div class="card-footer">
                        <button type="submit" class="btn btn-danger" onclick="printDiv('printMe')"><i class="fe fe-print"></i> Click to Print</button>
                    </div>                    
                </div>
            </div>
        </div>
    @endif


    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script>
        function printDiv(divName){
            var printContents = document.getElementById(divName).innerHTML;
            var originalContents = document.body.innerHTML;
            document.body.innerHTML = printContents;
            window.print();
            document.body.innerHTML = originalContents;
        }
    </script>
@endsection