{# Template For UG Students In SFS
Changes : show percentage in each subject
            Show  Pass status and SGPA #}
<style>
     td, th { padding: 5px; }
    .no-border{
        border-top:1px solid #fff !important;
        border-left:1px solid #fff !important;
        border-right:1px solid #fff !important;
        border-bottom:1px solid #fff !important;
    }
    .consolidated-table thead tr th {

    }
    .border-trl-0{
        border-top:1px solid #fff !important;
        border-left:1px solid #fff !important;
        border-right:1px solid #fff !important;
    }
    .border-rl-0{
        border-left:1px solid #fff !important;
        border-right:1px solid #fff !important;
    }
    .border-b-0{
        border-bottom:1px solid #fff !important;
        border-top:1px solid #000 !important;
    }
    .border-t-0{
        border-top:1px solid #fff !important;
        border-bottom:1px solid #000 !important;
    }
    .noborder-r-0{
       border-right-style: none;
    }
    .border-bt-0{
        border-bottom:1px solid #fff !important;
        border-top:1px solid #fff !important;
    }
    .college_banner{
        width: auto;
        height: 20mm;
    }
</style>
    <div class="page" style="width:100%;">
    {% set subjectLen =  data.examRegistrationData.subjectGroups|length %}
    {% set subjectColSpan =   subjectLen * 5 %}
    {% set trcolSpan =  subjectColSpan + 5 %}
    <table class="table border table-responsive-md"  style='' border="1" role="grid" id="regular-consolidated-exam-report" class="consolidated-table">
        <thead>
            <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
					<div style="width:100%; text-align:center;">
						<div>
							<img id="college_banner" class="college_banner" src="{{ data.collegeData.collegeHeader }}">
						</div>
					</div>
                </td>
            </tr>
            <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <div class="" style='font-size: 20px;'><b>EXAMINATION RESULTS</b></div>
                </td>
            </tr>
            <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <div class="" style='font-size: 20px;'><b>{{data.examRegistrationData.name |upper}}</b></div>
                </td>
            </tr>
            <tr data-exclude="true">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <table style="width: 100%; border: none;" border="0">
                        <tr data-exclude="true">
                            <td style="border: none; text-align: left;"><b>Programme : {{data.examRegistrationData.groupName}}</b></td>
                            <td style="border: none; text-align: right;"><b>Date : {{ "now"|date("d-m-Y") }}</b></td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr style="display: none;">
                <td data-f-bold='true' colspan="6" style="border: none; text-align: left;"><b>Programme : {{data.examRegistrationData.groupName}}</b></td>
                <td data-f-bold='true' style="border: none; text-align: right;"><b>Date : {{ "now"|date("d-m-Y") }}</b></td>
            </tr>
            <tr></tr>
            <tr class="border">
                <th width="5%" rowspan="2" class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Sl.No.</th>
                {% if data.hideExternalOrInternalMark %}
                    <th width="30%" rowspan="2"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Student Name</th>
                    <th width="30%" rowspan="2"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Reg. No</th>
                    {% for subject in data.examRegistrationData.subjectGroups %}
                        <th  width="5%" colspan="5" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>{{subject.code |raw}} <br> {{subject.name |raw}}</th>
                    {% endfor %}
                {% else %}
                    <th width="30%" rowspan="2"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Student Name</th>
                    <th width="30%" rowspan="2"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Reg. No</th>
                    {% for subject in data.examRegistrationData.subjectGroups %}
                        <th width="15%" colspan="5" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>{{subject.code |raw}} <br> {{subject.name |raw}}</th>
                    {% endfor %}
                {% endif %}
                {% if not data.examRegistrationData.hideSemesterResults %}
                <th width="5%" rowspan="2"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>SGPA</th>
                <th width="5%" rowspan="2"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Grade</th>
                {% endif %}
            </tr>
            
            <tr class="border">
                {% for subject in data.examRegistrationData.subjectGroups %}
                    <th width="5%" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>Grade Obtained</th>
                    <th width="5%" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>Grade Point (G)</th>
                    <th width="5%" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>Credit (C)</th>
                    <th width="5%" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>Credit Point (C*G)</th>
                    <th width="5%" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>Status</th>
                {% endfor %} 
            </tr>
        </thead>
        <tbody>
            {% set slno = 0 %}
            {% for student in data.studentData %}
            {% set slno = slno + 1 %}
                <tr>
                    <td class="align-middle text-center border-r-0">{{slno}}</td>
                    <td class="align-middle text-center border-r-0">{{student.name | upper}}</td>
                    <td class="align-middle text-center border-r-0">{{student.registerNo}}</td>
                    {% set updatedPaperSubjectIds = [] %}
                    {% for subject in data.examRegistrationData.subjectGroups %}
                        {% set isEntered = false %}
                        {% set isEnteredGroup = false %}
                        {% for studentSubject in student.subjects %}
                            {% if studentSubject.id in subject.academicPaperSubjectIds and isEnteredGroup == false %}
                                {% if studentSubject.id not in updatedPaperSubjectIds %}
                                    {% set updatedPaperSubjectIds = updatedPaperSubjectIds|merge([studentSubject.id]) %}
                                    {% if studentSubject.failedStatus == "PASSED" %}
                                        <td class="text-center border-r-0">{{ studentSubject.excludeSubjectFromTotal == "1" ? 'P': studentSubject.grade }}</td>
                                    {% else %}
                                    <td class="text-center border-r-0">F</td>
                                    {% endif %}
                                    <td class="text-center noborder-r-0">{{ (not studentSubject.showExcludeSubjectFromTotalWithDetails and studentSubject.excludeSubjectFromTotal == "1") ? "-" : studentSubject.gradePoint }}</td>
                                    <td class="text-center noborder-r-0">{{studentSubject.credit }}</td>
                                    <td class="text-center noborder-r-0">{{studentSubject.subCreditGradePoint }}</td>
                                    <td class="text-center noborder-r-0">{{studentSubject.failedStatus == "PASSED" ? 'Pass' : 'Fail' }}</td>
                                    {% set isEnteredGroup = true %}
                                    {% set isEntered = true %}
                                {% endif %}
                            {% endif %}
                        {% endfor %}
                        {% if isEntered == false %}
                            <td class="text-center noborder-r-0"> * </td>
                            <td class="text-center noborder-r-0"> * </td>
                            <td class="text-center noborder-r-0"> * </td>
                            <td class="text-center noborder-r-0"> * </td>
                            <td class="text-center border-r-0"> * </td>
                        {% endif %}
                    {% endfor %}
                    {% if not data.examRegistrationData.hideSemesterResults %}
                    <td class="align-middle text-center border-r-0">{{ student.failedStatus == 'PASSED' ? student.semesterSgpa|number_format(student.roundOff, '.') : '*'}}</td>
                    <td class="align-middle text-center border-r-0">{{ student.semesterGrade}}</td>
                    {% endif %}
                </tr>
            {% endfor %}
        </tbody>
        {% if data.showFooter %}
            {% set leftColSpan = (trcolSpan / 3)|round(0, 'floor') %}
            {% set rightColSpan = (trcolSpan / 3)|round(0, 'floor') %}
            {% set centerColSpan = trcolSpan - leftColSpan - rightColSpan %}
            <tr style="height:80px;">
                <td colspan="{{ leftColSpan }}" class="no-border" style="border:none; padding-top:60px; white-space:nowrap; text-align:left;" data-a-h='left' data-a-v='bottom'>
                    <strong>Prepared by</strong>
                </td>
                <td colspan="{{ centerColSpan }}" class="no-border" style="border:none; padding-top:60px; white-space:nowrap; text-align:center;" data-a-h='center' data-a-v='bottom'>
                    <strong>Checked By</strong>
                </td>
                <td colspan="{{ rightColSpan }}" class="no-border" style="border:none; padding-top:60px; white-space:nowrap; text-align:right;" data-a-h='right' data-a-v='bottom'>
                    <strong>Deputy Controller of Examinations</strong>
                </td>
            </tr>   
        {% endif %}
    </table>
</div>