{# Template For UG Students In CHRIST 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: collapse;
    }
    .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-after: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;
	}
	.tabular-table td {
		padding: 2px;
		line-height: 16px !important;
		height: 4mm !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;
	}
    
</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"></th>
        </tr>
        <tr>
            <th data-f-bold='true' class="text-left">Academic Year :  {{data.examRegistrationData.academicExamYear}} </th>
        </tr>
          {% if data.displayContentOptions.rules.EnableBoardMeetingShow %}
        <tr>
            <th data-f-bold='true' class="text-left">Pass Board Meeting Held on : {{data.examRegistrationData.boardMeatingDate}}</th>
            <th data-f-bold='true' class="text-right">&nbsp;</th>
        </tr>
        {% endif %}
        
    </table>
    <table class="primary-table">
        <thead>
            <tr>
                <th data-f-bold='true' style="width:25%" rowspan="2">Course Code</th>
                <th data-f-bold='true' style="width:55%" rowspan="2">Course</th>
                <th data-f-bold='true' style="width:5%" rowspan="2">Credit</th>
                <th data-f-bold='true' style="width:15%" 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>
        </thead>
        <tbody class="text-center">
            {% for subject in data.examRegistrationData.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 %}
        </tbody>
    </table>
    <br>
    <table class="primary-table center" style="width:20%!important;">
        <tr>
            <td>Total Credit :</td>
            <td>{{data.examRegistrationData.totalCredit}}</td>
        </tr>
    </table>
    <br>
    <table class="center outer-border abbr-table" style="width:80%!important;" >
        <tr style="display: none;">
			<td></td>
		</tr>
        <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>
        <tr style="display: none;">
			<td></td>
		</tr>
    </table>
    <br>
    <table style="width:100%!important; page-break-after:always;">
        <tr data-exclude="true">
            {% if data.displayContentOptions.rules.isEnablePreparedBy %}
                <td class="text-left p-20">Prepared by</td>
            {% endif %}
            <td class="text-left p-20">Checked by</td>
            <td class="text-center p-20">Controller of Examinations</td>
            <td class="text-right p-20">Principal</td>
        </tr>
        <tr style="display: none;">
			<td></td>
		</tr>
        <tr data-exclude="true">
            {% if data.displayContentOptions.rules.isShowFooterValue is not empty %}
            <td colspan="100" class="no-border p-t-20 text-center" style="font-size:12px!important;">
                    {{ data.displayContentOptions.rules.isShowFooterValue }}
            </td>
            {% else %}
            <td colspan="100" class="no-border p-t-20 text-center" style="font-size:13px!important;">
                {% set count = 0 %}
                {% for grade in data.gradeSchemes %}
                    {{grade.name}}
                    -
                    {{grade.className}}
                    ({{grade.rangeFrom}}-{{grade.rangeTo}})
                    {% if loop.last %}
                    {% else %}
                    ,{% endif %}
                {% endfor %}
            </td>
             {% endif %}

    </tr>
    <tr style="display: none;">
		<td></td>
	</tr>
    </table>
{# start tabulation register #}
    <!--tag1-->
    {% set updatedPaperSubjectIds = [] %}
    {% for splittedKey, splittedSubjects in data.examRegistrationData.subjectGroups %}
        {% if loop.last %}
            {% set finalLoop = 1%}
        {%else%}
            {% set finalLoop = 0%}
        {% endif %}
        <table class="tabular-table" id="tabulationRegisterReportExcel" style="width:100%!important;">
            <thead>
                {% if data.isPrint %}
                    <tr style="padding-top:300px!important">
                        <th data-f-bold='true' colspan="100" class="text-center"><img src="{{data.collegeData.collegeHeader}}" class="college-header"></th>
                    </tr>
                    <tr>
                        <th data-f-bold='true' colspan="100" class="text-center"><b style="font-size: 18px;">{{data.examRegistrationData.name}}</br></th>
                    </tr>
                    <tr>
                        <th data-f-bold='true' colspan="100" class="text-center"><b style="font-size: 18px;">TABULATION REGISTER</br></th>
                    </tr>
                    <tr>
                        <th data-f-bold='true' class="text-left" colspan="6">Programme :  {{data.examRegistrationData.streamDescription| raw}}</th>
                        <th data-f-bold='true' class="text-right" colspan="100">Semester : S{{data.examRegistrationData.semInSemNumber}}</th>
                    </tr>
                    <tr>
                        <th data-f-bold='true' class="text-left p-b-10" colspan="6">Academic Year : {{data.examRegistrationData.academicExamYear}} </th>
                        <th data-f-bold='true' class="text-right" colspan="100"></th>
                    </tr>
                {% endif %}
                        {# do not change possition of tags #}
        <!--tag1-->
                <tr>
        <!--tag2-->
                    {% if splittedKey == 0 %}
                        {% if data.isPrint == 0 %}
                            <th data-f-bold='true' data-exclude="true" class="tabular-table-border" style="width:2%" rowspan="2">Select</th>
                        {% endif %}
                    {% endif %}
                    <th data-f-bold='true' class="tabular-table-border" style="width:2%" rowspan="2">Register Number</th>
                    <th data-f-bold='true' class="tabular-table-border" style="width:10%" rowspan="2">Name of the Student</th>
                    {% set haslang = 0 %}
                    <!--tag3-->
                    {% for subject in splittedSubjects %}
                        <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" colspan="{{ (subject.isGrouped == true ? 7 : 6) + (data.displayContentOptions.rules.showModerationMark ? 1 : 0) + (data.displayContentOptions.rules.showGraceMark ? 1 : 0) }}" 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' data-a-h="center" class="tabular-table-border text-center" style="width:2%" rowspan="2">Total Credit Points</th>
                        <th data-f-bold='true' data-a-h="center" class="tabular-table-border text-center" style="width:2%" rowspan="2">SGPA</th>
                        <th data-f-bold='true' data-a-h="center" class="tabular-table-border text-center" style="width:1%" rowspan="2">Grade</th>
                    {% endif %}
                    
                <!--tag2-->
                </tr>
                <tr>
                <!--tag2-->
                    {% for subject in splittedSubjects %}
                        {% 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-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">MDN</th>
                        {% endif %}
                        {% if data.displayContentOptions.rules.showGraceMark %}
                            <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">GRM</th>
                        {% endif %}
                        <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">IA</th>
                        <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">ESE</th>
                        <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Tot</th>
                        <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">GP</th>
                        <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">Grade</th>
                        <th data-a-h="center" data-f-bold='true' class="tabular-table-border text-center" style="width:1%">CP</th>
                    {% endfor %} 
                <!--tag2-->
                </tr>
            <!--tag1-->
            </thead>
        <!--tag1-->
            <tbody>
        <!--tag1-->
                {% for student in data.studentData %}
                    <tr>
                    <!--tag2-->
                        {% set academicTerm = student.academicTerms |first %}
                        {% if splittedKey == 0 %}
                            {% if data.isPrint == false %}
                                <td data-exclude="true" class="text-center tabular-table-border"><input type="checkbox" class="studentName" value='{{student.id}}'/></td>
                            {% endif %}
                        {% endif %}
                        <td class="text-center tabular-table-border">{{student.registerNo}}</td>
                        <td class="text-left tabular-table-border" style="font-size:13px !important">{{student.name}}</td>
                        {% set langcount = 0 %}
                        {% set displayHeadCount = 0 %}
                        {% set displayHeadTag3Display = displayHeadCount %}
                    <!--tag3-->
                        {% for subject in splittedSubjects %}
                             {% 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 not studentSubject.isSupplyMark %}
                                            {% 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>
                                        {% elseif studentSubject.attendanceStatus == "ABSENT" %}
                                            {% 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.internalAttendanceStatus == 'ABSENT' ? 'AB' : studentSubject.internalMark}}</td>
                                            <td class="failed tabular-table-border text-center">AB</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>
                                            <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.internalAttendanceStatus == 'ABSENT' ? 'AB' : studentSubject.internalResultStatus == 'FAILED' ? '-' : studentSubject.internalMark |number_format(0)}}</td>
                                            <td class="failed tabular-table-border text-center">{{ studentSubject.attendanceStatus == "MALPRACTICE" ? "MAL" :  studentSubject.attendanceStatus == "ABSENT" ? "AB" : 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.internalAttendanceStatus == 'ABSENT' ? 'AB' : studentSubject.internalMark}}</td>
                                            <td class="tabular-table-border text-center">{{ studentSubject.attendanceStatus == "MALPRACTICE" ? "MAL" :  studentSubject.attendanceStatus == "ABSENT" ? "AB" : 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 %}
                                        {% 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>
                {% endfor %} 
        <!--tag1-->
            </tbody>
            <tfoot>
                <tr data-exclude="true">
                    <td colspan="100" class="no-border p-t-50">
                        <div class="d-flex justify-content-between align-items-center w-100" style="display: flex; justify-content: space-between; align-items: center; width: 100%;">
                            {% if data.displayContentOptions.rules.isEnablePreparedBy %}
                            <span class="text-nowrap" style="white-space: nowrap; margin-right: 300px;">Prepared by</span>
                            {% endif %}
                            <span class="text-nowrap" style="white-space: nowrap; margin-right: 300px;">Checked by</span>
                            <span class="text-nowrap" style="white-space: nowrap; margin-right: 300px;">Controller of Examinations</span>
                            <span class="text-nowrap" style="white-space: nowrap;">Principal</span>
                        </div>
                    </td>
                </tr>
                <tr style="display: none;">
                </tr>
                <tr>
                    {% if data.displayContentOptions.rules.isShowFooterValue is not empty %}
                    <td colspan="100" class="no-border p-t-20 text-center" style="font-size:12px!important;">
                            {{ data.displayContentOptions.rules.isShowFooterValue }}
                    </td>
                    {% else %}
                    <td data-f-bold='true' colspan="100" class="no-border p-t-20 text-center" style="font-size:12px!important;">
                        {% set count = 0 %}
                        {% for grade in data.gradeSchemes %}
                            {{grade.name}}
                            -
                            {{grade.className}}
                            ({{grade.rangeFrom}}-{{grade.rangeTo}})
                            {% if loop.last %}
                            {% else %}
                            ,{% endif %}
                        {% endfor %}
                    </td>
                    {% endif %}
                </tr>
            </tfoot>
        </table>
    {% endfor %}
<!--tag1-->
</div>