{# Template For UG Students In MES VIMALA STJOSEPH Collagees  #}
<style>
     td, th { padding: 5px; }
     body{
        font-family: \"Times New Roman\", Times, serif; 
    }
     @media print {
        #printBtnDiv { display : none !important; }
    }
	.primary-table {
		border-collapse: collapse !important;
		page-break-inside: auto;
		width: 100% !important;
	}

	.primary-table th {
		text-align: center;
		background: none !important;
		height: 4mm !important;
		border: 1px solid #000 !important;
		padding: 1mm !important;
	}
	.primary-table td {
		padding: 3px;
		line-height: 20px !important;
		height: 4mm !important;
		border: 1px solid #000;
		text-align: center;
		vertical-align: middle !important;
	}
	#subjectHeader {
		width: 100% !important;
	}
	#subjectHeader td {
		padding: 2mm;
		line-height: 15px !important;
		height: 4mm !important;
		vertical-align: middle !important;
		text-align: center !important;
	}
	.no-border {
		border-left: 1px solid #fff !important;
		border-right: 1px solid #fff !important;
		border-top: 1px solid #fff !important;
        border-bottom: 1px solid #fff !important;
	}
    .college-header {
		height: 35mm;
		width: auto;
		margin: 0 10%;
	}
    .text-left{
        text-align:left!important;
    }
    .text-center{
        text-align:center!important;
    }
    .text-right{
        text-align:right!important;
    }
    .p-t-20{
        padding-top:10px!important;
    }
	.p-t-50{
        padding-top:50px!important;
    }
	
    .p-b-10p-b-10{
        padding-bottom:10px!important;
    }
    .p-20{
        padding:20px!important;
    }
    .outer-border {
        border: 1px solid black;
        border-collapse: separate !important; 
    }
    .center {
        margin-left: auto;
        margin-right: auto;
    }
    .abbr-table td{
        padding: 2mm 10mm 2mm 10mm;
		line-height: 14px !important;
		margin-top:5mm;
    }
	.tabular-table {
		border-collapse: collapse !important;
		page-break-inside: auto;
		page-break-before:always;
		width: 100% !important;
	}

	.tabular-table th {
		text-align: center;
		background: none !important;
		height: 3mm !important;
		/* border: 1px solid #000 !important; */
		padding: 1mm !important;
		font-size:13px !important;
	}
	.tabular-table-border{
		border: 1px solid #000 !important;
        font-size: 13pt!important;
	}
	.tabular-table td {
        padding: 5px 2px; /* Added extra vertical padding */
        line-height: 18px !important;
        height: 5mm !important;
		border: 1px solid #000;
		text-align: center;
		vertical-align: middle !important;
		/* page-break-after:always; */
	}
	.tabular-table tr{
		/* page-break-after:always; */
		height: 6mm !important;
	}
	.small-font{
		font-weight: normal !important;
		font-size: 15px !important;
	}
	.failed{
		background-color:#c0c0c0 !important;
	}
    .footer-table td{
        font-size: 13pt!important;
    }


/* 1. Base sticky column styling */
@media screen {
.sticky-column {
    position: sticky;
    left: 0;
    background-color: white !important;
    z-index: 3; 
    border: 1px solid #000 !important;

}

/* 2. Specific column adjustments */
.sticky-column-1 { 
    left: 0;
    min-width: 30px;
    max-width: 30px;
}
.sticky-column-2 { 
    left: 30px;
    min-width: 35px;
    max-width: 35px;
}
.sticky-column-3 { 
    left: 65px;
    min-width: 100px;
    max-width: 100px;
}
.sticky-column-4 { 
    left: 165px;
    min-width: 150px;
    max-width: 150px;
}
.tabular-table {
    border-collapse: separate !important;
    border-spacing: 0 !important;
}
.tabular-table td {
    border-bottom: 1px solid #000 !important;
}

.tabular-table thead th.sticky-header {
    position: sticky;
    top: 0;
    z-index: 4; 
    background-color: white !important;
    border: 1px solid #000 !important;
    box-shadow: 0 1px 0 #000;
    }
}

/* Page break control for limiting students per printed page */
@media print {
    .page-break { page-break-after: always; }
}
.stud-row td{
	font-size: 18px !important;
}

    
</style>
    <div class="page" style="width:100%;" id="sem-wise-result-sheet" data-cols-width="30,40">
    <table id="subjectHeader">
        <tr style="padding-top:300px!important">
			<td><img src="{{data.collegeData.collegeHeader}}" class="college-header"></td>
		</tr>
        <tr>
			<td><b style="font-size: 18px;">{{data.examRegistrationData.name}}</br></td>
		</tr>
        <tr>
			<td><b style="font-size: 18px;">TABULATION REGISTER</br></td>
		</tr>
    </table>
    <table style="width:100%!important;">
        <tr>
            <th data-f-bold='true' class="text-left">Programme : {{data.examRegistrationData.streamDescription| raw}}</th>
            <th data-f-bold='true' class="text-right">&nbsp;</th>
        </tr>
        <tr>
            <th data-f-bold='true' class="text-left">Academic Year :  {{data.examRegistrationData.academicExamYear}} </th>
            <th data-f-bold='true' class="text-right">Semester : {{data.examRegistrationData.academicTermName}}</th>
        </tr>
        
    </table>
    <br>
    <!-- start index tables   -->
    {% set subject_count = data.examRegistrationData.subjects|length %}
    {% set split_table = subject_count > 20 %}
    {% set mid_index = (subject_count // 2) + (subject_count is odd ? 1 : 0) %}
    
    {% macro render_subjects(subjects) %}
        {% for subject in subjects %}
            <tr>
                <td class="text-left">{{ subject.code | raw }}</td>
                <td class="text-left">{{ subject.name | raw }}</td>
                <td>{{ subject.credit }}</td>
                <td>{{ subject.internalMaxMark }}</td>
                <td>{{ subject.externalMaxMark }}</td>
                <td>{{ subject.totalMarks }}</td>
            </tr>
        {% endfor %}
    {% endmacro %}
    
    {% macro render_table(subjects) %}
        <table class="primary-table" style="width: 100%;">
            <tr>
                <th data-f-bold='true' style="width:15%" rowspan="2">Course Code</th>
                <th data-f-bold='true' style="width:45%" rowspan="2">Course</th>
                <th data-f-bold='true' style="width:10%" rowspan="2">Credit</th>
                <th data-f-bold='true' style="width:30%" colspan="3">Max Marks</th>
            </tr>
            <tr>
                <th data-f-bold='true' style="width:5%">IA</th>
                <th data-f-bold='true' style="width:5%">ESE</th>
                <th data-f-bold='true' style="width:5%">Total</th>
            </tr>
            {{ _self.render_subjects(subjects) }}
        </table>
    {% endmacro %}
    
    {% if split_table %}
        <div style="width: 100%; overflow: hidden;">
            <div style="float: left; width: 48%;">
                {{ _self.render_table(data.examRegistrationData.subjects[:mid_index]) }}
            </div>
            <div style="float: right; width: 48%;">
                {{ _self.render_table(data.examRegistrationData.subjects[mid_index:]) }}
            </div>
        </div>
    {% else %}
        {{ _self.render_table(data.examRegistrationData.subjects) }}
    {% endif %}
    
    <!-- end index table -->

    <br>
    <table class="primary-table center" style="width:20%!important;">
        <tr>
            <td><b>Total Credit :</b></td>
            <td><b>{{data.examRegistrationData.totalCredit}}</b></td>
        </tr>
    </table>
    <br>
    <table class="center outer-border abbr-table" style="width:60%!important;">

        <tr>
            <td class="text-center" colspan="3"><b>Abbreviations :</b></td>
        </tr>
        <tr>
            <td class="text-left">C => Credit</td>
            <td class="text-left">P => Practical</td>
            <td class="text-left">AB => ABSENT</td>
        </tr>
        <tr>
            <td class="text-left">T => Theory</td>
            <td class="text-left">D => Project / Dissertation</td>
            <td class="text-left">V => Viva</td>
        </tr>
        <tr>
            <td class="text-left">IA => Internal Mark</td>
            <td class="text-left">G => Grade</td>
            <td class="text-left">IC => Incomplete</td>
        </tr>
        <tr>
            <td class="text-left">Tot => Total Marks</td>
            <td class="text-left">ESE => External Mark</td>
            <td class="text-left">EC => Exam Cancelled</td>
        </tr>
        <tr>    
            <td class="text-left">CP => Credit Point</td> 
            <td class="text-left">GP => Grade Point</td>  
            <td></td>
        </tr>
    </table>
    <br>
    {% if data.isPrint == 1 %}
        <table style="width:100%!important; page-break:before: avoid !important" class="footer-table">
            <tr>
                <td colspan="100" class="no-border p-t-50" style="font-weight: bold !important; padding-top:85px !important">
                    <span style="float:left!important; width:15%">&nbsp;</span>
                    <span style="float:left!important; width:25%">Checked by</span>
                    <span style="float:center!important; width:30%">Controller of Examinations</span>
                    <span style="float:right!important; width:30%">Principal</span>
                </td>
            </tr>
            <tr>
                <td colspan="100" class="no-border p-t-20 text-center" style="font-weight: bold !important">
                    {% set count = 0 %}
                    {% for grade in data.gradeSchemes %}
                        {{grade.name}}
                        -
                        {{grade.className}}
                        ({{grade.rangeFrom|number_format(2, '.', '')}}-{{grade.rangeTo|number_format(2, '.', '')}})
                        {% if loop.last %}
                        {% else %}
                        ,{% endif %}
                    {% endfor %}
                </td>
            </tr>
        </table>
    {% endif %}
{# start tabulation register #}
    <table id="subjectHeader" style="page-break-before: always">
        <tr style="padding-top:300px!important">
            <td><img src="{{data.collegeData.collegeHeader}}" class="college-header"></td>
        </tr>
        <tr>
            <td><b style="font-size: 18px;">{{data.examRegistrationData.name}}</br></td>
        </tr>
        <tr>
            <td><b style="font-size: 18px;">TABULATION REGISTER</br></td>
        </tr>
    </table>
    <table style="width:100%!important;">
        <tr>
            <th data-f-bold='true' class="text-left">Programme : {{data.examRegistrationData.streamDescription| raw}}</th>
            <th data-f-bold='true' class="text-right">&nbsp;</th>
        </tr>
        <tr>
            <th data-f-bold='true' class="text-left">Academic Year :  {{data.examRegistrationData.academicExamYear}} </th>
            <th data-f-bold='true' class="text-right">Semester : {{data.examRegistrationData.academicTermName}}</th>
        </tr>
        
    </table>
    {% if data.examRegistrationData.hasInternalMarkNotEnteredScenario == 1 %}
        <div style = 'text-align:left'><b>Note:</b> * Indicates that internal marks have not been entered for the student.</div>
    {% endif %}
    {% set updatedPaperSubjectIds = [] %}
    {% for subjectGroups in data.examRegistrationData.subjectGroups %}
        {% if loop.last %}
            {% set finalLoop = 1%}
        {%else%}
            {% set finalLoop = 0%}
        {% endif %}
        {% if loop.first %}
            <table class="tabular-table" id="tabulationRegisterReportExcel" style="width:100%!important; page-break-before: avoid !important">
        {%else%}
            </table>
            {% if data.isPrint == 1 %}
                <table style="width:100%!important; page-break:before: avoid !important" class="footer-table">
                    <tr>
                        <td colspan="100" class="no-border p-t-50" style="font-weight: bold !important; padding-top:85px !important">
                            <span style="float:left!important; width:15%">&nbsp;</span>
                            <span style="float:left!important; width:25%">Checked by</span>
                            <span style="float:center!important; width:30%">Controller of Examinations</span>
                            <span style="float:right!important; width:30%">Principal</span>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="100" class="no-border p-t-20 text-center" style="font-weight: bold !important">
                            {% set count = 0 %}
                            {% for grade in data.gradeSchemes %}
                                {{grade.name}}
                                -
                                {{grade.className}}
                                ({{grade.rangeFrom|number_format(2, '.', '')}}-{{grade.rangeTo|number_format(2, '.', '')}})
                                {% if loop.last %}
                                {% else %}
                                ,{% endif %}
                            {% endfor %}
                        </td>
                    </tr>
                </table>
                <table id="subjectHeader" style="page-break-before: always">
                    <tr style="padding-top:300px!important">
                        <td><img src="{{data.collegeData.collegeHeader}}" class="college-header"></td>
                    </tr>
                    <tr>
                        <td><b style="font-size: 18px;">{{data.examRegistrationData.name}}</br></td>
                    </tr>
                    <tr>
                        <td><b style="font-size: 18px;">TABULATION REGISTER</br></td>
                    </tr>
                </table>
                <table style="width:100%!important;">
                    <tr>
                        <th data-f-bold='true' class="text-left">Programme : {{data.examRegistrationData.streamDescription| raw}}</th>
                        <th data-f-bold='true' class="text-right">&nbsp;</th>
                    </tr>
                    <tr>
                        <th data-f-bold='true' class="text-left">Academic Year :  {{data.examRegistrationData.academicExamYear}} </th>
                        <th data-f-bold='true' class="text-right">Semester : {{data.examRegistrationData.academicTermName}}</th>
                    </tr>
                    
                </table>
            {% endif %}
          <div class="table-container">
            <table class="tabular-table" id="tabulationRegisterReportExcel" style="width:100%!important;page-break-before: avoid !important">
        {% endif %}
    <colgroup>
            {% if data.isPrint == 0 %}
            <col style="width:30px"> <!-- Select column -->
            {% endif %}
            <col style="width:35px"> <!-- Sl No. column -->
            <col style="width:85px"> <!-- Register Number column -->
            <col style="width:150px"> <!-- Student Name column -->
            <!-- Rest of your columns -->
        </colgroup>
            <thead>
                <tr>
                    {% if data.isPrint == 0 %}
                    <th data-f-bold='true' data-exclude="true" class="tabular-table-border sticky-column sticky-column-1 sticky-header" style="width:2%" rowspan="2">Select</th>
                    {% endif %}
                    <th data-f-bold='true' data-exclude="true" class="tabular-table-border sticky-column sticky-column-2 sticky-header" style="width:2%" rowspan="2">Sl No.</th>
                    <th data-f-bold='true' class="tabular-table-border sticky-column sticky-column-3 sticky-header" style="width:2%" rowspan="2">Register Number</th>
                    <th data-f-bold='true' class="tabular-table-border sticky-column sticky-column-4 sticky-header" style="width:10%" rowspan="2">Name of the Student</th>
                    {% set haslang = 0 %}
                    <!--tag3-->
                    {% for subject in subjectGroups %}
                        {% set colspan = subject.isGrouped == true ? 7 : 6 %}
                        {% if data.displayContentOptions.rules.showModerationMark %}
                        {% set colspan = colspan + 1 %}
                        {% endif %}
                        {% if data.displayContentOptions.rules.showGraceMark %}
                        {% set colspan = colspan + 1 %}
                        {% endif %}
                        <th data-f-bold='true' data-a-h='center' class="tabular-table-border text-center" colspan="{{colspan}}" style="width:20%">
                        {% if subject.isGrouped == true %}{{subject.name |raw}}{%else%} {{subject.code | raw}} {% endif %}
                            <br><span class="small-font">Credit : {{subject.credit}}</span><!--subject_tag--> <!--subjectHead_tag-->
                            <br><span class="small-font" style="float:left;">IA Max - {{subject.internalMaxMark}}</span>
                            <span class="small-font" style="float:right;">ESE Max - {{subject.externalMaxMark}}</span>
                        </th> 
                    {% endfor %}
                    {% if finalLoop == 1 %}
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:2%" rowspan="2">Total Credit Points</th>
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:2%" rowspan="2">SGPA </th>
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%" rowspan="2">Grade </th>
                    {% endif %}
                </tr>
                <tr>
                    {% for subject in subjectGroups %}
                        {% if subject.isGrouped == true %}  <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Course Code</th> {% endif %}
                        {% if data.displayContentOptions.rules.showModerationMark %}
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">MDN</th>
                        {% endif %}
                        {% if data.displayContentOptions.rules.showGraceMark %}
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">GRM</th>
                        {% endif %}
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">IA</th>
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">ESE</th>
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Tot</th>
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">GP</th>
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Grade</th>
                        <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">CP</th>
                    {% endfor %} 
                <!--tag2-->
                </tr>
            <!--tag1-->
            </thead>
            <!--tag1-->
            <!--tag1-->
                {% set slno = 0 %}
                {% for student in data.studentData %}
                    <tr class="stud-row">
                    <!--tag2-->
                        {% set academicTerm = student.academicTerms |first %}
                        {% if data.isPrint == false %}
                        <td data-exclude="true" class="text-center tabular-table-border text-center tabular-table-border sticky-column sticky-column-1"><input type="checkbox" class="studentName" value='{{student.id}}'/></td>
                        {% endif %}
                        {% set slno = slno + 1 %}
                        <td data-exclude="true" class="text-center tabular-table-border sticky-column sticky-column-2">{{slno}}</td>
                        <td class="text-center tabular-table-border sticky-column sticky-column-3">{{student.registerNo}}</td>
                        <td class="text-left tabular-table-border sticky-column sticky-column-4">{{student.name}}</td>
                        {% set langcount = 0 %}
                        {% set displayHeadCount = 0 %}
                        {% set displayHeadTag3Display = displayHeadCount %}
                    <!--tag3-->
                        {% for subject in subjectGroups %}
                            {% set isEntered = false %}
                            {% set isEnteredGroup = false %}
                            {% for studentSubject in academicTerm.subjects %}
                                {% if studentSubject.id in subject.academicPaperSubjectIds and isEnteredGroup == false %}
                                    {% set subjectKey = studentSubject.id ~ '-' ~ student.id %}
                                    {% if subjectKey not in updatedPaperSubjectIds %}
                                        {% set updatedPaperSubjectIds = updatedPaperSubjectIds|merge([subjectKey]) %}
                                        <!--subject_tag-->
                                        {% set displayHeadCount = displayHeadCount + 1 %}
                                        {% if data.displayContentOptions.rules.disableFailedStudentHighligthing %}
                                            {% if studentSubject.attendanceStatus != "PRESENT" and studentSubject.isExternal %}
                                                {% if subject.isGrouped == true %} <td class="failed tabular-table-border text-center">{{studentSubject.code}}</td> {% endif %}
                                                {% if data.displayContentOptions.rules.showModerationMark %}
                                                <td class="failed tabular-table-border text-center">{{studentSubject.moderationMark ? studentSubject.moderationMark | round:'0' }}</td>
                                                {% endif %}
                                                {% if data.displayContentOptions.rules.showGraceMark %}
                                                <td class="failed tabular-table-border text-center">{{studentSubject.graceMark ? studentSubject.graceMark | round:'0'}}</td>
                                                {% endif %}
                                                <td class="failed tabular-table-border text-center">{{studentSubject.isInternal? studentSubject.internalAttendanceStatus == 'ABSENT' ? 'AB' : studentSubject.internalMark : '-'}}</td>
                                                <td class="failed tabular-table-border text-center">{{ studentSubject.attendanceStatus == "MALPRACTICE" ? "MAL" : "AB"}}</td>
                                                <td class="failed tabular-table-border text-center">{{studentSubject.markObtained}}</td>
                                                <td class="failed tabular-table-border text-center">-</td>
                                                <td class="failed tabular-table-border text-center">-</td>
                                                <td class="failed tabular-table-border text-center">-</td>
                                            {% elseif studentSubject.failedStatus == 'FAILED' %}
                                                {% if subject.isGrouped == true %} <td class="failed tabular-table-border text-center">{{studentSubject.code}}</td> {% endif %}
                                                {% if data.displayContentOptions.rules.showModerationMark %}
                                                <td class="failed tabular-table-border text-center">{{studentSubject.moderationMark ? studentSubject.moderationMark | round:'0' }}</td>
                                                {% endif %}
                                                {% if data.displayContentOptions.rules.showGraceMark %}
                                                <td class="failed tabular-table-border text-center">{{studentSubject.graceMark ? studentSubject.graceMark | round:'0'}}</td>
                                                {% endif %}
                                                <td class="failed tabular-table-border text-center">{{studentSubject.isInternal?  studentSubject.internalAttendanceStatus == 'ABSENT' ? 'AB' : studentSubject.internalMark : '-'}}</td>
                                                <td class="failed tabular-table-border text-center">{{studentSubject.isExternal? studentSubject.externalMark |number_format(0) : '-'}}</td>
                                                {% if studentSubject.internalAbsentStatus == "ABSENT" or studentSubject.internalResultStatus == 'FAILED' %}
                                                    <td class="failed tabular-table-border text-center">-</td>
                                                {% else %}
                                                    <td class="failed tabular-table-border text-center">{{studentSubject.markObtained}}</td>
                                                {% endif %}
                                                <td class="failed tabular-table-border text-center">-</td>
                                                <td class="failed tabular-table-border text-center">-</td>
                                                <td class="failed tabular-table-border text-center">-</td>
                                            {% else %}
                                                {% if subject.isGrouped == true %} <td class="tabular-table-border text-center">{{studentSubject.code}}</td> {% endif %}
                                                {% if data.displayContentOptions.rules.showModerationMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.moderationMark ? studentSubject.moderationMark | round:'0' }}</td>
                                                {% endif %}
                                                {% if data.displayContentOptions.rules.showGraceMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.graceMark ? studentSubject.graceMark | round:'0'}}</td>
                                                {% endif %}
                                                <td class="tabular-table-border text-center">{{studentSubject.isInternal?  studentSubject.internalAttendanceStatus == 'ABSENT' ? 'AB' : studentSubject.internalMark : '-'}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.isExternal? studentSubject.externalMark |number_format(0) : '-'}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.markObtained}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.gradePoint}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.grade}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.creditGradePoint}}</td>
                                            {% endif %}
                                        {% elseif not data.displayContentOptions.rules.disableFailedStudentHighligthing %}
                                            {% if studentSubject.attendanceStatus != "PRESENT" and studentSubject.isExternal %}
                                                {% if subject.isGrouped == true %} <td class="tabular-table-border text-center">{{studentSubject.code}}</td> {% endif %}
                                                {% if data.displayContentOptions.rules.showModerationMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.moderationMark ? studentSubject.moderationMark | round:'0' }}</td>
                                                {% endif %}
                                                {% if data.displayContentOptions.rules.showGraceMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.graceMark ? studentSubject.graceMark | round:'0'}}</td>
                                                {% endif %}
                                                <td class="tabular-table-border text-center">{{studentSubject.isInternal? studentSubject.internalMark : '-'}}</td>
                                                <td class="tabular-table-border text-center">{{ studentSubject.attendanceStatus == "MALPRACTICE" ? "MAL" : "AB"}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.markObtained}}</td>
                                                <td class="tabular-table-border text-center">-</td>
                                                <td class="tabular-table-border text-center">-</td>
                                                <td class="tabular-table-border text-center">-</td>
                                            {% elseif studentSubject.failedStatus == 'FAILED' and data.displayContentOptions.rules.disableFailedStudentHighligthing %}
                                                {% if subject.isGrouped == true %} <td class="tabular-table-border text-center">{{studentSubject.code}}</td> {% endif %}
                                                {% if data.displayContentOptions.rules.showModerationMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.moderationMark ? studentSubject.moderationMark | round:'0' }}</td>
                                                {% endif %}
                                                {% if data.displayContentOptions.rules.showGraceMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.graceMark ? studentSubject.graceMark | round:'0'}}</td>
                                                {% endif %}
                                                <td class="tabular-table-border text-center">{{studentSubject.isInternal? studentSubject.internalMark : '-'}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.isExternal? studentSubject.externalMark |number_format(0) : '-'}}</td>
                                                {% if studentSubject.internalAbsentStatus == "ABSENT" or studentSubject.internalResultStatus == 'FAILED' %}
                                                    <td class="tabular-table-border text-center">-</td>
                                                {% else %}
                                                    <td class="tabular-table-border text-center">{{studentSubject.markObtained}}</td>
                                                {% endif %}
                                                <td class="tabular-table-border text-center">-</td>
                                                <td class="tabular-table-border text-center">-</td>
                                                <td class="tabular-table-border text-center">-</td>
                                            {% else %}
                                                {% if subject.isGrouped == true %} <td class="tabular-table-border text-center">{{studentSubject.code}}</td> {% endif %}
                                                {% if data.displayContentOptions.rules.showModerationMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.moderationMark ? studentSubject.moderationMark | round:'0' }}</td>
                                                {% endif %}
                                                {% if data.displayContentOptions.rules.showGraceMark %}
                                                <td class="tabular-table-border text-center">{{studentSubject.graceMark ? studentSubject.graceMark | round:'0'}}</td>
                                                {% endif %}
                                                <td class="tabular-table-border text-center">{{studentSubject.isInternal? studentSubject.internalMark : '-'}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.isExternal? studentSubject.externalMark |number_format(0) : '-'}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.markObtained}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.gradePoint}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.grade}}</td>
                                                <td class="tabular-table-border text-center">{{studentSubject.creditGradePoint}}</td>
                                            {% endif %}
                                        {% endif %}
                                        {% set isEnteredGroup = true %}
                                        {% set isEntered = true %}
                                    {% endif %}
                                {% endif %}
                            {% endfor %}
                            {% if isEntered == false %}
                                <!--subject_tag-->
                                {% if subject.isGrouped == true %} <td class="tabular-table-border text-center"></td> {% endif %}
                                {% if data.displayContentOptions.rules.showModerationMark %}
                                <td class="tabular-table-border text-center"></td>
                                {% endif %}
                                {% if data.displayContentOptions.rules.showGraceMark %}
                                <td class="tabular-table-border text-center"></td>
                                {% endif %}
                                <td class="tabular-table-border text-center"></td>
                                <td class="tabular-table-border text-center"></td>
                                <td class="tabular-table-border text-center"></td>
                                <td class="tabular-table-border text-center"></td>
                                <td class="tabular-table-border text-center"></td>
                                <td class="tabular-table-border text-center"></td>
                            {% endif %}
                            {% if displayHeadCount  is divisible by(4) and  displayHeadTag3Display != displayHeadCount %}
                            <!--tag3--> {% set displayHeadTag3Display = displayHeadCount %} 
                            {% endif %}
                        {% endfor %}
                        {% if finalLoop == 1 %}
                            <td class="tabular-table-border text-center">{{academicTerm.failedStatus == 'PASSED' ? academicTerm.semesterCreditGradePoint : '-'}}</td>
                            <td class="tabular-table-border text-center">{{academicTerm.failedStatus == 'PASSED' ?  academicTerm.semesterSgpa|number_format(student.roundOff, '.') : '-' }}</td>
                            <td class="tabular-table-border text-center">{{academicTerm.failedStatus == 'PASSED' ?  academicTerm.semesterGrade : '-' }}</td>
                        {% endif %}
                <!--tag2-->
                    </tr>
                    {% if (slno is divisible by(30)) and not loop.last %}
                        </table>
                        {% if data.isPrint == 1 %}
                        <table style="width:100%!important; page-break:before: avoid !important" class="footer-table">
                            <tr>
                                <td colspan="100" class="no-border p-t-50" style="font-weight: bold !important; padding-top:85px !important">
                                    <span style="float:left!important; width:15%">&nbsp;</span>
                                    <span style="float:left!important; width:25%">Checked by</span>
                                    <span style="float:center!important; width:30%">Controller of Examinations</span>
                                    <span style="float:right!important; width:30%">Principal</span>
                                </td>
                            </tr>
                            <tr>
                                <td colspan="100" class="no-border p-t-20 text-center" style="font-weight: bold !important">
                                    {% for grade in data.gradeSchemes %}
                                        {{grade.name}} - {{grade.className}} ({{grade.rangeFrom|number_format(2, '.', '')}}-{{grade.rangeTo|number_format(2, '.', '')}}){% if loop.last %}{% else %}, {% endif %}
                                    {% endfor %}
                                </td>
                            </tr>
                        </table>
                        <table id="subjectHeader" style="page-break-before: always">
                            <tr style="padding-top:300px!important">
                                <td><img src="{{data.collegeData.collegeHeader}}" class="college-header"></td>
                            </tr>
                            <tr>
                                <td><b style="font-size: 18px;">{{data.examRegistrationData.name}}</br></td>
                            </tr>
                            <tr>
                                <td><b style="font-size: 18px;">TABULATION REGISTER</br></td>
                            </tr>
                        </table>
                        <table style="width:100%!important;">
                            <tr>
                                <th data-f-bold='true' class="text-left">Programme : {{data.examRegistrationData.streamDescription| raw}}</th>
                                <th data-f-bold='true' class="text-right">&nbsp;</th>
                            </tr>
                            <tr>
                                <th data-f-bold='true' class="text-left">Academic Year :  {{data.examRegistrationData.academicExamYear}} </th>
                                <th data-f-bold='true' class="text-right">Semester : {{data.examRegistrationData.academicTermName}}</th>
                            </tr>
                        </table>
                        {% endif %}
                        <table class="tabular-table" id="tabulationRegisterReportExcel" style="width:100%!important; page-break-before: avoid !important">
                        <colgroup>
                            {% if data.isPrint == 0 %}
                            <col style="width:30px">
                            {% endif %}
                            <col style="width:35px">
                            <col style="width:85px">
                            <col style="width:150px">
                        </colgroup>
                        <thead>
                            <tr>
                                {% if data.isPrint == 0 %}
                                <th data-f-bold='true' data-exclude="true" class="tabular-table-border sticky-column sticky-column-1 sticky-header" style="width:2%" rowspan="2">Select</th>
                                {% endif %}
                                <th data-f-bold='true' data-exclude="true" class="tabular-table-border sticky-column sticky-column-2 sticky-header" style="width:2%" rowspan="2">Sl No.</th>
                                <th data-f-bold='true' class="tabular-table-border sticky-column sticky-column-3 sticky-header" style="width:2%" rowspan="2">Register Number</th>
                                <th data-f-bold='true' class="tabular-table-border sticky-column sticky-column-4 sticky-header" style="width:10%" rowspan="2">Name of the Student</th>
                                {% for subject in subjectGroups %}
                                    {% set colspan = subject.isGrouped == true ? 7 : 6 %}
                                    {% if data.displayContentOptions.rules.showModerationMark %}
                                        {% set colspan = colspan + 1 %}
                                    {% endif %}
                                    {% if data.displayContentOptions.rules.showGraceMark %}
                                        {% set colspan = colspan + 1 %}
                                    {% endif %}
                                    <th data-f-bold='true' data-a-h='center' class="tabular-table-border text-center" colspan="{{colspan}}" style="width:20%">
                                        {% if subject.isGrouped == true %}{{subject.name |raw}}{%else%} {{subject.code | raw}} {% endif %}
                                        <br><span class="small-font">Credit : {{subject.credit}}</span>
                                        <br><span class="small-font" style="float:left;">IA Max - {{subject.internalMaxMark}}</span>
                                        <span class="small-font" style="float:right;">ESE Max - {{subject.externalMaxMark}}</span>
                                    </th>
                                {% endfor %}
                                {% if finalLoop == 1 %}
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:2%" rowspan="2">Total Credit Points</th>
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:2%" rowspan="2">SGPA </th>
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%" rowspan="2">Grade </th>
                                {% endif %}
                            </tr>
                            <tr>
                                {% for subject in subjectGroups %}
                                    {% if subject.isGrouped == true %}<th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Course Code</th>{% endif %}
                                    {% if data.displayContentOptions.rules.showModerationMark %}
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">MDN</th>
                                    {% endif %}
                                    {% if data.displayContentOptions.rules.showGraceMark %}
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">GRM</th>
                                    {% endif %}
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">IA</th>
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">ESE</th>
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Tot</th>
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">GP</th>
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Grade</th>
                                    <th data-f-bold='true' class="tabular-table-border text-center" style="width:1%">CP</th>
                                {% endfor %}
                            </tr>
                        </thead>
                    {% endif %}
                {% endfor %} 
            <!--tag1-->
            <tr style="display:none;">
            </tr>
        <tr style="display:none;">
            <td data-f-bold='true' colspan="100" class="no-border p-t-20 text-center" style="font-weight: bold !important">
                {% set count = 0 %}
                {% for grade in data.gradeSchemes %}
                    {{grade.name}}
                    -
                    {{grade.className}}
                    ({{grade.rangeFrom|number_format(2, '.', '')}}-{{grade.rangeTo|number_format(2, '.', '')}})
                    {% if loop.last %}
                    {% else %}
                    ,{% endif %}
                {% endfor %}
            </td>
        </tr>
        </table>
        </div>
    {% endfor %}
    </br></br>
    <table style="width:100%!important; page-break:before: avoid !important" class="footer-table">
        <tr>
            <td colspan="100" class="no-border p-t-50" style="font-weight: bold !important; padding-top:85px !important">
                <span style="float:left!important; width:15%">&nbsp;</span>
                <span style="float:left!important; width:25%">Checked by</span>
                <span style="float:center!important; width:30%">Controller of Examinations</span>
                <span style="float:right!important; width:30%">Principal</span>
            </td>
        </tr>
        <tr data-exclude="true">
            <td colspan="100" class="no-border p-t-20 text-center" style="font-weight: bold !important">
                {% set count = 0 %}
                {% for grade in data.gradeSchemes %}
                    {{grade.name}}
                    -
                    {{grade.className}}
                    ({{grade.rangeFrom|number_format(2, '.', '')}}-{{grade.rangeTo|number_format(2, '.', '')}})
                    {% if loop.last %}
                    {% else %}
                    ,{% endif %}
                {% endfor %}
            </td>
        </tr>
    </table>
<!--tag1-->
</div>