{# Template For PG Students In MES VIMALA STJOSEPH Collagees  #}
<style>
     td, th { padding: 5px; }
     body{
        font-family: \"Times New Roman\", Times, serif; 
    }
    .border-0{
        border:1px solid #fff !important;
    }
    .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;
    }
    .markTab{
        width:100%;
        margin:20px auto;
        font-size: 17px;
        padding:0;
        text-align:center;
        border-collapse: collapse;
    }
    .markTab td{
        margin: 0;
        font-size: 17px;
        padding:3px;
        color: #000;
        text-align: center;
        border-collapse: collapse;
    }
    .rotate{
        transform: rotate(270deg);
        text-align:center;
        line-height: 13px;
        height: 70px;
        width: 70px;
        margin: 0px -43px 0px 5px;
        text-align: center;
    }
    .failed{
		background-color:#c0c0c0 !important;
	}
    @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: 45px;
        max-width: 45px;
    }
    .sticky-column-3 { 
        left: 65px;
        min-width: 150px;
        max-width: 150px;
    }
    .stickytab {
        border-collapse: separate !important;
        border-spacing: 0 !important;
    }
    .stickytab td {
        border-bottom: 1px solid #000 !important;
    }

    .stickytab 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;
        }
    }
    .stud-row td{
		font-size: 18px !important;
	}
    
</style>
<div id="sem-wise-result-sheet" data-cols-width="10,40">
    {% for splittedKey, subjectSplitted in data.examRegistrationData.subjectSplitted %}
        <div class="page" style="width:100%; page-break-before:always !important">
        
        {% set subjectColSpan =   subjectLen * 5 %}
        {% set trcolSpan =  subjectColSpan + 5  %}
        {% set colspan =  7  %}
        {% set subjectLen =  data.examRegistrationData.subjects|length   %}
        {% set colspan = colspan + subjectLen * 8  %}
        {% set widthtr =  80 / subjectLen %}
        {% set extraColspan =  colspan - 4 %}
        {% if data.isPrint == 1 or  splittedKey == 0  %}
            <table class="markTab" border="0" cellpadding="0" cellspacing="0">
                <tr align = 'center'>
                    <td data-f-bold='true'  colspan = "{{colspan}}" style = "text-align:center">
                        <div style = "width:100%; text-align:center !important; display:inline-block; vertical-align:top">
                            <div style="text-align:center;">
                                <img style='height:40mm !important; width:auto;' src="{{data.collegeData.collegeHeader}}" class="college-header">
                            </div>
                        </div>
                    </td>
                    <td colspan = "{{colspan}}">
                    
                    </td>
                </tr>
                <tr align = 'center'>
                    <td data-f-bold='true'  colspan = "{{colspan}}" style = "text-align:center ">
                        <div style = "font-size: 16px; text-align:center !important; display:inline-block;">
                            <b style = "font-size: 19px;\">PROGRAMME : {{data.examRegistrationData.programName}} </b>
                        </div>
                    </td>
                </tr>
                <tr align = 'center'>
                    <td data-f-bold='true'  colspan = "{{colspan}}" style = "text-align:center ">
                        <div style = "font-size: 16px; text-align:center !important; display:inline-block;">
                            <b style = "font-size: 19px;\">{{data.examRegistrationData.name}}</b>
                        </div>
                    </td>
                </tr>
                <tr align = 'center' data-exclude="true">
                    <td data-f-bold='true'  colspan = "{{colspan}}" style = "text-align:center ; padding:0px !important">
                        <div style = "width:30%; text-align:left !important; display:inline-block; vertical-align:top;line-height: 22px; float:left;     margin-top: 70px;">
                            <table class="markTab" border="0" cellpadding="0" cellspacing="0">
                                <tr style="display: none;">
                                    <td></td>
                                </tr>
                                <tr>
                                    <td style="text-align:left !important">
                                        <b>Month & Year of Examination : </b>
                                        <b style="text-transform:uppercase">{{data.examRegistrationData.examMonthName}} {{data.examRegistrationData.examYear}}</b>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="text-align:left !important">
                                        <b>Year of Admission : </b>
                                        <b>{{data.examRegistrationData.batchStartYear}}</b>
                                    </td>
                                </tr>
                                <tr>
                                    <td style="text-align:left !important">
                                        <b>Semester : </b>
                                        <b>{{data.examRegistrationData.academicTermName}}</b>
                                    </td>
                                </tr>
                                <tr style="display: none;">
                                    <td></td>
                                </tr>
                            </table>
                        </div>
                        <div style = "width:20%; text-align:center !important; display:inline-block; vertical-align:top;line-height: 22px;margin-top: 0px; float:right; padding:0px">
                            <table class="markTab" border="1" cellpadding="0" cellspacing="0" style = "">
                                <tr style="padding: 0px">
                                    <th style="text-align:center !important" class="tabular-table-border">Credit Point Calculation</th>
                                </tr>
                                <tr style="padding: 0px">
                                    <th style="text-align:left !important" class="tabular-table-border">Extwt = (Ewgp) * 4</th>
                                </tr>
                                <tr style="padding: 0px">
                                    <th style="text-align:left !important" class="tabular-table-border">Wgpa = (Extwt + Iwgpa) / 5</th>
                                </tr>
                                <tr style="padding: 0px">
                                    <th style="text-align:left !important" class="tabular-table-border">Crpt = Wgpa * Credit</th>
                                </tr>
                                <tr style="padding: 0px">
                                    <th style="text-align:left !important" class="tabular-table-border">Minimum SGPA - 2.00 (P)</th>
                                </tr>
                                <tr style="padding: 0px">
                                    <th style="text-align:left !important" class="tabular-table-border">Minimum WGPA - 2.00 (P)</th>
                                </tr>
                                <tr style="display: none;">
                                    <td></td>
                                </tr>
                            </table>
                        </div>
                    </td>
                </tr>
            </table>
        {% endif %}
        {% 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 %}
        <table class="markTab stickytab" border="1" cellpadding="0" cellspacing="0" style = "">
            <thead>
                <tr>
                    {% if data.isPrint == 0 %}
                    <th data-exclude='true'  data-f-bold='true'  rowspan="3" class='text-center bold sticky-column sticky-column-1 sticky-header ' data-a-h='center' data-a-v='middle' style="width:2%">
                        <svg width='5mm' height='30mm'>
                            <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Select</text>
                        </svg>
                    </th>
                    {% endif %}
                    <th data-f-bold='true'  rowspan="3" class='text-center bold sticky-column sticky-column-2 sticky-header ' data-a-h='center' data-a-v='middle'>
                        <svg width='5mm' height='30mm'>
                            <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Sl.No</text>
                        </svg>
                    </th>
                    <th data-f-bold='true'  rowspan="3"class='text-center bold sticky-column sticky-column-3 sticky-header' data-a-h='center' data-a-v='middle'>
                        <svg width='5mm' height='30mm'>
                            <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Register</text>
                        </svg>
                        <svg width='5mm' height='30mm'>
                            <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>No /</text>
                        </svg>
                        <svg width='5mm' height='30mm'>
                            <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Name</text>
                        </svg>
                    </th>
                    {% set subHeadColspan = 9 %}
                    {% if data.displayContentOptions.rules.showModerationMark %}
                    {% set subHeadColspan = subHeadColspan + 1 %}
                    {% endif %}
                    {% if data.displayContentOptions.rules.showGraceMark %}
                    {% set subHeadColspan = subHeadColspan + 1 %}
                    {% endif %}
                    {% for subject in subjectSplitted %}
                        <th  data-f-bold='true' colspan="{{subHeadColspan}}" width='{{widthtr}}'  class='text-center' data-a-h='center' data-a-v='middle'>{{subject.code}} <br> {{subject.name}}</th>
                    {% endfor %}
                    {% if (splittedKey + 1 ) == data.examRegistrationData.subjectSplittedCount %}
                        <th  data-f-bold='true' rowspan="3"class='text-center bold' data-a-h='center' data-a-v='middle'>
                            <div style="width: 66px;">
                                <svg width='5mm' height='30mm'>
                                    <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Total</text>
                                </svg>
                                <svg width='5mm' height='30mm'>
                                    <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Credit</text>
                                </svg>
                                <svg width='5mm' height='30mm'>
                                    <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Points</text>
                                </svg>
                            </div>
                        </th>
                        <th  data-f-bold='true' rowspan="3"class='text-center bold' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>SGPA</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' rowspan="3"class='text-center bold ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Grade</text>
                            </svg>
                        </th>
                        <th rowspan="3"class='text-center bold ' data-a-h='center' data-a-v='middle'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>
                        <th rowspan="3"class='text-center bold ' data-a-h='center' data-a-v='middle'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</th>
                    {% endif %}
                </tr>
                <tr>
                    {% for subject in subjectSplitted %}
                        <th  data-f-bold='true' colspan="{{subHeadColspan}}" class='text-center ' data-a-h='center' data-a-v='middle'>Credit : {{subject.credit}}</th>
                    {% endfor %} 
                </tr>
                <tr>
                    {% for subject in subjectSplitted %}
                    {% if data.displayContentOptions.rules.showModerationMark %}
                    <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                        <svg width='5mm' height='30mm'>
                            <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>MDN</text>
                        </svg>
                    </th>
                    {% endif %}
                    {% if data.displayContentOptions.rules.showGraceMark %}
                    <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                        <svg width='5mm' height='30mm'>
                            <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>GRM</text>
                        </svg>
                    </th>
                    {% endif %}
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>IWGP</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>IGrade</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>EWGP</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>EWCPA</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>EGrade</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>WGPA</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Grade</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Cr Pt</text>
                            </svg>
                        </th>
                        <th  data-f-bold='true' class='text-center ' data-a-h='center' data-a-v='middle'>
                            <svg width='5mm' height='30mm'>
                                <text transform='rotate(180)' y='-50%' x='-50%' style='writing-mode: tb;text-anchor: middle;'>Status</text>
                            </svg>
                        </th>
                    {% endfor %} 
                </tr>
            </thead>
            <tbody>
                {% set slno = 0 %}
                {% for student in data.studentData %}
                {% for academicTerm in student.academicTerms %}
                    {% set slno = slno + 1 %}
                    <tr class="stud-row">
                        {% if data.isPrint == false %}
                        <td data-exclude="true" class="text-center sticky-column sticky-column-1"><input type="checkbox" class="studentName" value='{{student.id}}'/></td>
                        {% endif %}
                        <td class="align-middle text-center sticky-column sticky-column-2 ">{{slno}}</td>
                        <td style="text-align:left;padding: 4px; " class="sticky-column sticky-column-3">({{student.registerNo}}) <br/>{{student.name}} </td>
                            {% for subject in subjectSplitted %}
                                {% set isEntered = false %}
                                {% for studentSubject in academicTerm.subjects %}
                                    {% if studentSubject.id == subject.id %}
                                        {% if data.displayContentOptions.rules.showModerationMark %}
                                            <td class="text-center">{{studentSubject.moderationMark ? studentSubject.moderationMark | round:'0' }}</td>
                                        {% endif %}
                                        {% if data.displayContentOptions.rules.showGraceMark %}
                                            <td class="text-center">{{studentSubject.graceMark ? studentSubject.graceMark | round:'0'}}</td>
                                        {% endif %}
                                        {% if studentSubject.isInternal %}
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">{{ studentSubject.internalNotEntered == 1 ? '*' :  studentSubject.internalAttendanceStatus == 'ABSENT' ? 'AB' : studentSubject.percentageObtainedInternal|number_format(2, '.') }}</td>
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">{{ studentSubject.internalGrade }}</td>
                                        {% else %}
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">-</td>
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">-</td>
                                        {% endif %}
                                        {% if studentSubject.isExternal %}
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}} noborder-r-0">
                                                {% if studentSubject.attendanceStatus == "PRESENT" %}
                                                    {{  studentSubject.percentageObtainedExternal|number_format(2, '.') }}
                                                {% elseif studentSubject.attendanceStatus == "MALPRACTICE" %}
                                                    <span style="">MAL </span> 
                                                {% else %}
                                                    <span style=""> AB </span> 
                                                {% endif %}
                                            </td>
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}} noborder-r-0">
                                                {% if studentSubject.attendanceStatus == "PRESENT" %}
                                                    {{  studentSubject.externalMark|round(2) }}
                                                {% elseif studentSubject.attendanceStatus == "MALPRACTICE" %}
                                                    <span style="">MAL </span> 
                                                {% else %}
                                                    <span style=""> AB </span> 
                                                {% endif %}
                                            </td>
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}} noborder-r-0">{{ studentSubject.externalGrade }}</td>
                                        {% else %}
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">-</td>
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">-</td>
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">-</td>
                                        {% endif %}
                                        <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}} ">{{ studentSubject.wgpa|number_format(2, '.') }}</td>
                                        <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}} ">{{ studentSubject.grade }}</td>
                                        <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">{{ studentSubject.creditGradePoint }}</td>
                                        {% if studentSubject.failedStatus == 'PASSED' %}
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">Pass</td>
                                        {% else %}
                                            <td class="text-center {{ studentSubject.failedStatus == "PASSED" ? '' : 'failed'}}">Fail</td>
                                        {% endif %}
                                        {% set isEntered = true %}
                                    {% endif %}
                                {% endfor %}
                                {% if isEntered == false %}
                                    {% if data.displayContentOptions.rules.showModerationMark %}
                                        <td class="text-center"></td>
                                    {% endif %}
                                    {% if data.displayContentOptions.rules.showGraceMark %}
                                        <td class="text-center"></td>
                                    {% endif %}
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                    <td class="text-center"> * </td>
                                {% endif %}
                            {% endfor %}
                            {% if (splittedKey + 1 ) == data.examRegistrationData.subjectSplittedCount %}
                                
                                {% if academicTerm.failedStatus == 'PASSED' %}
                                    <td class="align-middle text-center">{{academicTerm.semesterCreditGradePoint}}</td>
                                    <td class="align-middle text-center">{{academicTerm.semesterSgpa}}</td>
                                    <td class="align-middle text-center">{{academicTerm.semesterGrade}}</td>
                                {% else %}
                                    <td>-</td>
                                    <td>-</td>
                                    <td>-</td>
                                {% endif %}
                                <td></td>
                                <td></td>
                            {% endif %}
                    </tr>
                {% endfor %} 
                {% endfor %}
            </tbody>
        </table>
        {% if data.isPrint == 1 or  (splittedKey + 1 ) == data.examRegistrationData.subjectSplittedCount   %}
            <div style="margin: 100px 0 0 0; width: 100%; font-size: 17px">
                <div style = "width:25%;margin:0 auto; text-align:center;float:left;"><b>Prepared by</b></div>
                <div style = "width:25%;margin:0 auto; text-align:center;float:left;"><b>Checked by</b></div>
                <div style = "width:25%;margin:0 auto; text-align:center;float:left;"><b>Controller of Examination</b></div>
                <div style = "width:25%;margin:0 auto; text-align:center;float:left;"><b>Principal</b></div>
            </div>
        {% endif %}
    </div>
{% endfor%}
</div>