{# Template For PG Students In MES  STJOSEPH Collagees   
Changes : No show percentage in each subject
            Show semester grade and SGPA #}
<style>
   .bold-text{
    font-weight: bold !important;
    }

    .footer{
        width: 90%;
        position: absolute;
        bottom: 10px;
    }

    .fontFamily{
        font-family: "St.JIFont" !important;
    }

    .page {
        position: relative;
        width: 100%;
        min-height: 29.7cm;
        box-shadow: none;
        background:no-repeat;
        -webkit-background-size: contain;
        -moz-background-size: contain;
        -o-background-size: contain;
        background-size: contain;
        color:#000;
        page-break-after:always;
    }

    th {
        padding: 1px;
        font:bold 13px "Times new roman" !important;
        text-align:center;
    }
    td {
        padding: 1px;
        font:10px "Times new roman" !important;
    }
    #head td {
        padding: 1px;
        font:12px "Times new roman" !important;
    }
    .inner-tr {
        height:15px;
    }
    .inner-tr td {
        border-top: none;
        border-bottom: none;
        padding: 1px 1px;
    }
    .caps {
        text-transform: uppercase;
        font-size: 13px;
    }
    .small {
        font-size: 13px;
    }
    .calculationtable {	
        margin:20px 0 0 0;
        width:90%;
        border:1px solid #000;
        border-collapse:collapse;
    }
    .calculationtable td {
        padding:5px;
        font-size:16px;
        border:1px solid #000;
        border-collapse:collapse;
    }

</style>
{% for student in data.studentData %}
    <div class="page" style="border:none;">
        <div class="subpage" style='min-height: 27.6cm;'>
            <table id = "printTable" style="width:100%;"><tr><td style="width:100%;">
                <tr>
                    <td>
                        <table id="head" style="width: 100%;" cellpadding="0" cellspacing="0" border="0">
                            <tr>
                                <td>
                                    <p>
                                    <img style = 'width: 100px; height: 115px; position: absolute; right: 19px; margin-top: 19px;margin-right: 0%;' src = '{{student.myImage}}'>
                                    </p>						
                                </td>
                            </tr>
                            <tr>
                                <td colspan="2">
                                    <table style="width: 102%; margin: 0; padding: 0; margin-top: 140px;" cellpadding="0" cellspacing="0" border="0">
                                        <tr>
                                            <td rowspan="2" style="width: 15%;">
                                                <div style="margin: 20px 0 0 0;" id="folio-number">
                                                    Folio No. : &nbsp;<b class = 'fontFamily'>{{student.folioNumber}}</b>
                                                </div>
                                                <div id="barcode">
                                                    <div class="container" style="padding: 0; margin: 0; font-size: 12px; text-align: left; float: left;"></div>
                                                </div>
                                            </td>
                                            <td rowspan="2" style="width: 71%;">
                                                <p style="font-size: 17px; text-decoration: underline; text-align: center;">
                                                    <b>CONSOLIDATED GRADE SHEET</b>
                                                </p>
                                            </td>
                                            <td style="width: 15%;">
                                                <div style="height: 85px; margin: 0; padding: 0;">
                                                    <img style="margin: -10px 0 0 0;" src="{{student.qrCodeLink}}" />
                                                </div>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td style="width: 15%;">Dated: {{data.dateOfIssue}}</td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                            <tr>
                                <td width='66%'>
                                    <div style="display: inline-block; width: 33%">
                                        <span class="caps">Name of Programme </span> <span
                                        style="float: right;">:</span>
                                    </div>
                                    <div style="display: inline-block; width: 65%">&nbsp; <b>
                                        <span class="small">{{student.programName}}</span></b>
                                    </div>
                                </td>
                                <td width='34%' style='text-align:right;'>
                                    <div style="width: 47%;display: inline-block; text-align:left;">
                                        <span class="caps">Register No&nbsp;</span>
                                        <span style="float: right;">:&nbsp;</span>
                                    </div>
                                    <div style="text-align: right;display: inline-block;" id='reg-no-display'>
                                        <b><span class='caps fontFamily'>{{student.regNo}}</span></b>
                                    </div>
                                </td>
                            </tr>
                            <tr>
                                <td>
                                    <div style="display: inline-block; width: 33%">
                                        <span class="caps">Name of Candidate</span><span
                                            style="float: right;">:</span>
                                    </div>
                                    <div style="display: inline-block; width: 65%;">
                                        &nbsp;
                                        <b><span class='caps fontFamily'>{{student.name}}</span></b>
                                    </div>
                                </td>
                                <td style='text-align:right;'>
                                    <div style="width: 47%;display: inline-block; text-align:left;">
                                        <span class="caps">Month &amp; Year&nbsp;</span>
                                        <span style="float: right;">:&nbsp;</span>
                                    </div>
                                    <div style="text-align: right;display: inline-block;" id="month-year">
                                        <b><span class="caps" id="correctdate" style='white-space: nowrap;'>{{student.examMonthYear}}</span></b>
                                    </div>
                                </td>
                            </tr>
                        </table>
                        <table border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;width: 100%;height:100%;border:2px solid #000;">
                            <col width="2.5%">
                            <col width="7%">
                            <col width="30.5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="2.5%">
                            <col width="5%">
                            <col width="2.5%">
                            <tr>
                                <th rowspan = '2' style="text-align:center;">C<br>-<br>T</th>
                                <th rowspan = '2' style="text-align:center;">Course Code </th>
                                <th rowspan = '2' style="text-align:center;">Course Title </th>
                                <th rowspan = '2'><div>Credit</div> </th>
                                <th colspan = '3'>Marks Awarded</th>
                                <th colspan = '3'>Max Marks</th>
                                <th rowspan = '2'><div>Grade Point</div> </th>
                                <th rowspan = '2'><div>Grade</div> </th>
                                <th rowspan = '2'><div>Credit Point</div> </th>
                                <th rowspan = '2'><div>R<br />S<br />I</div> </th>
                                <th rowspan = '2'><div>Month &amp; Year</div> </th>
                                <th rowspan = '2'><div>P<br>/<br>F</div></th>
                            </tr>
                            <tr>
                                <th><div>IA</div></th>
                                <th><div>ESE</div></th>
                                <th><div>Total</div></th>
                                <th><div>IA</div></th>
                                <th><div>ESE</div></th>
                                <th><div>Total</div></th>
                            </tr>
                            {% for term in student.academicTerms %}
                            {% if term.termOrder is divisible by(5) %}
                        </table>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div class="" style="border:none;">
        <div class="subpage" style='min-height: 27.6cm;'>
            <table id = "printTable" style="width:100%;"><tr><td style="width:100%;">
                <tr>
                    <td>
                        <table border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;width: 100%;height:100%;border:2px solid #000;">
                            <col width="2.5%">
                            <col width="5%">
                            <col width="32.5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="5%">
                            <col width="2.5%">
                            <col width="5%">
                            <col width="2.5%">
                            {% endif %}
                            <tr>
                                <td colspan = "16"><b style = "text-align:left;font-size:13px;padding: 5px;">SEMESTER - {{term.romanNumber}}</b></td>
                            </tr>
                            {% for subject in term.subjects %}
                            <tr class="inner-tr">
                                <td style="text-align:center; white-space: nowrap; " valign = 'top'>
                                    <p style = 'font-size: 11px;'>{{subject.categoryCode}}</p>
                                </td>
                                <td style="text-align:left; " valign = 'top'>
                                    <p style = 'font-size: 11px;'>{{subject.code}}</p>
                                </td>
                                <td style="text-align:left;padding:1px 3px;" valign = 'top'>
                                    <p style = 'font-size: 11px;'>{{subject.name}}</p>
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.hideGrade ? '--' : subject.markDetails.credit}}</p>
                                </td>

                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.markDetails.isInternal ? subject.markDetails.internalMark : '--'}}</p>
                                </td>
                                <td style='text-align:center; '>
                                {% if subject.markDetails.attendanceStatus == 'PRESENT' %}
                                    <p style = 'font-size: 11px;'>{{subject.markDetails.isExternal ? subject.markDetails.externalMark : '--'}}</p>
                                {% else %}
                                    <span style='color:red;'><p style = 'font-size: 11px;'>
                                        {% if subject.markDetails.attendanceStatus == 'ABSENT' %}
                                        AB
                                        {% elseif subject.markDetails.attendanceStatus == 'MAL' %}
                                        MAL
                                        {% else %}
                                        --
                                        {% endif %}
                                    </p></span>
                                {% endif %}
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.markDetails.excludeSubjectFromTotal == 1 ? '--' : subject.markDetails.markObtained}}</p>
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.markDetails.isInternal ? subject.markDetails.internalMaxMark : '--'}}</p>
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.markDetails.isExternal ? subject.markDetails.externalMaxMark : '--'}}</p>
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.markDetails.totalMarks}}</p>
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.markDetails.excludeSubjectFromTotal == 1 ? '--' : subject.markDetails.gradePoint}}</p>
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.hideGrade ? '--' : subject.markDetails.excludeSubjectFromTotal == 1 ? '--' : subject.grade}}</p>
                                </td>
                                <td style="text-align:center; ">
                                    <p style = 'font-size: 11px;'>{{subject.hideGrade ? '--' : subject.markDetails.excludeSubjectFromTotal == 1 ? '--' : subject.creditPoint}}</p>
                                </td>
                                <td style="text-align:center; white-space:nowrap;">
                                    <p style = 'font-size: 11px;'>{{subject.hideGrade ? '--' : subject.RSI}}</p>
                                </td>
                                <td style="text-align:center; white-space:nowrap;">
                                    <p style = 'font-size: 11px;'>{{subject.hideGrade ? '--' : subject.examMonthYear}}</p>
                                </td>
                                <td style="text-align:center; white-space:nowrap;">
                                    <p style = 'font-size: 11px;'>{{subject.hideGrade ? '--' : (subject.failedStatus == 'PASSED' ? 'P' : 'F' ) }}</p>
                                </td>
                            </tr>
                            {% endfor %}
                            <tr>
                                <td colspan = "3"><b style = "margin-left: 62%;">Total</b></td>
                                <td colspan = "1" style = 'width: 1%;text-align: center;'><b>
                                {% if term.failedStatus == 'PASSED' %}
                                    {{term.markDetails.credit}}
                                {% else %}
                                    -
                                {% endif %}
                                </b></td>
                                <td colspan = "8">&nbsp;</td>
                                <td colspan = "1" style = 'width: 1%;text-align: center;'><b>
                                {% if term.failedStatus == 'PASSED' %}
                                    {{term.creditPoint}}
                                {% else %}
                                    -
                                {% endif %}
                                <b></td>
                                <td colspan = "3">&nbsp;</td>
                            </tr>
                            <tr>
                                <td colspan = "8">
                                    <b style = "margin-left: 44%;font-size: 12px;">Semester Grade Point Average SGPA {{term.romanName}} : 
                                    {% if term.failedStatus == 'PASSED' %}
                                        {{term.markDetails.sgpa|number_format(student.roundOff, '.')}}
                                    {% else %}
                                        -
                                    {% endif %}
                                    </b>
                                </td>
                                <td colspan = "8">
                                    <b style = "margin-left: 44%;font-size: 12px;">Grade : 
                                    {% if term.failedStatus == 'PASSED' %}
                                        {{term.grade}}
                                    {% else %}
                                        -
                                    {% endif %}
                                    </b>
                                </td>
                            </tr>
                            {% endfor %}
                            <tr>
                                <td colspan="3" style="text-align:center;border-right:0px;">
                                    <b style = "font-size: 12px;">Total Credits Acquired</b>
                                </td>
                                <td style="text-align:center;">
                                    <b style = "font-size: 12px;">{{student.markDetails.credit}}</b>
                                </td>
                                <td style="text-align:center;" colspan = '8'><b style = "font-size: 12px;">Total Credit Points Obtained</b></td>
                                <td style="text-align:center;">
                                    <b style = "font-size: 12px;">{{student.creditPoint}}</b>
                                </td>
                                <td colspan="3"></td>
						  	</tr>
                            <tr>
								<td  style="text-align:center;" colspan = '11'>
                                    <b style = "font-size: 17px;">Cumulative Grade Point Average (CGPA) :&nbsp; 
                                    {% if student.failedStatus == 'PASSED' %}
                                        {{student.cgpa|number_format(student.roundOff, '.')}} (<span style="text-transform:capitalize;">{{student.cgpaInWords}}</span>)
                                    {% else %}
                                        -
                                    {% endif %}
                                    </b>
								</td>
								<td  style="text-align:center;" colspan = '5'>
                                    <b style = "font-size: 17px;">Letter Grade : 
                                {% if student.failedStatus == 'PASSED' %}
                                    {{student.grade}}
                                {% else %}
                                    -
                                {% endif %}
                                    </b>
								</td>
							</tr>
							<tr>
                                <td  style='text-align:center;' colspan = '16'>
                                    <b style = "font-size: 17px;">CGPA in Percentage : 
                                    {% if student.failedStatus == 'PASSED' %}
                                        {{student.cgpaPercentage|number_format(2, '.')}}% 
                                    {% else %}
                                        -
                                    {% endif %}
                                    </b>
                                </td>
                            </tr>
                            <tr>
                                <td  style="text-align:center; padding-top:5px" colspan = '16'>
                                    <span style = 'font-size: 12px;'>Formulae for CGPA% :</span>
                                    
                                    <span style = 'margin-left: 2%;font-size: 12px;'>If 0.5 &lt; CGPA ≤ 5.5, % = 40 + (CGPA - 0.5) x 10</span>
                                    <span style = 'margin-left: 2%;font-size: 12px;'>If CGPA &gt; 5.5, % = 90 + (CGPA - 5.5) x 20</span>
                                </td>
                            </tr>
                            <tr>
                                <td colspan = '16' style="text-align:center;">
                                    <b style = "font-size: 15px;">
                                    {% if student.failedStatus == 'PASSED' %}
                                        Eligibility for Higher Studies : CGPA 'E' and above
                                    {% else %}
                                        Not Eligible for Higher Studies
                                    {% endif %}
                                    </b>
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
            </table>
            <table class = "new" border="1"  cellpadding="0" cellspacing="0" style="width: 100%;margin-top: 1%;">
                <tr>
                    <th>Category</th>
                    <th>CGPA</th>
                    <th>Grade</th>
                    <th>CGPA %</th>
                    <th>Credits</th>
                </tr>
                {% for category in data.markListSubjectCategories %}
                <tr>
                    <td align='left' style='width: 50%;'>
                        <span style='font-size: 13px;'>{{category.name}}&nbsp;:&nbsp;{{category.displayName}}</span>
                    </td>
                    <td align='center' style='width: 10%;'>
                        <span style='font-size: 13px;'>{{category.cgpa|number_format(student.roundOff, '.')}}</span>
                    </td>
					<td align='center' style='width: 10%;'>
                        <span style='font-size: 13px;'>{{category.grade}}</span>
                    </td>
                    <td align='center' style='width: 10%;'>
                        <span style='font-size: 13px;'>{{category.cgpaPercentage|number_format(2, '.')}}</span>
                    </td>
                    <td align='center' style='width: 10%;'>
                        <span style='font-size: 13px;'>{{category.credit}}</span>
                    </td>
                </tr>
                {% endfor %}
            </table>
            <br />
            <br />
            
            <table class = "new" border="0"  cellpadding="0" cellspacing="0" style="width: 100%;margin-top: 1px;">
                
                <tr>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">IA : Internal Assessment</p>
                    </td>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">ESE : End Semester Evaluation</p>
                    </td>
                    <td style="text-align:left;"><p style="font-size: 13px;">P : Passed</p></td>
                    <td style="text-align:left;"><p style="font-size: 13px;">Ab : Absent</p></td>
                    
                </tr>
                <tr>
                    <td style="text-align:left;"><p style="font-size: 13px;">F : Failed</p></td>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">R : Regular</p>
                    </td>
                    <td style="text-align:left;"><p style="font-size: 13px;">S : Supplementary</p></td>
                    <td style="text-align:left;"><p style="font-size: 13px;">I : Improvement</p></td>
                    
                </tr>
                </table>
                <table class = "new" border="0"  cellpadding="0" cellspacing="0" style="width: 100%;margin-top: 1%;">
                <tr>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">Credit Point = Credit x Grade Point</p>
                    </td>
                </tr>
                <tr>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">SGPA = Total Credit Points in Semester / Total Credits</p>
                    </td>
                </tr>
                <tr>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">CGPA = Total Credit Points Obtained in Six Semesters / Total Credits Acquired (120)</p>
                    </td>
                </tr>
            </table>
            <table class = "new" border="0"  cellpadding="0" cellspacing="0" style="width: 100%;margin-top: 1%;">
                <tr>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">CT : Course Type</p>
                    </td>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">A : Common</p>
                    </td>
                    <td style="text-align:left;"><p style="font-size: 13px;">B : Core</p></td>
                    <td style="text-align:left;"><p style="font-size: 13px;">C : Complementary</p></td>
                    <td style="text-align:left;"><p style="font-size: 13px;">D : Open</p></td>
                    
                </tr>
            </table>
            <br />
            <br />
					
            <table class="calculationtable" cellpadding="0" cellspacing="0" style="margin:0px auto;text-align:center;font-size:12px;width:100%;margin-top: -5%;">
                <tr>
                    <td>Marks(%)</td>
                    <td>Below 40</td>
                    <td>40 to below 50</td>
                    <td>50 to below 60</td>
                    <td>60 to below 70</td>
                    <td>70 to below 80</td>
                    <td>80 to below 90</td>
                    <td>90 and above</td>
                    
                </tr>
                <tr>
                    <td>Grade</td>
                    <td>F</td>
                    <td>E</td>
                    <td>D</td>
                    <td>C</td>
                    <td>B</td>
                    <td>A</td>
                    <td>A+</td>
                    
                </tr>
                <tr>
                    <td>Grade Point</td>
                    <td>0</td>
                    <td>1</td>
                    <td>2</td>
                    <td>3</td>
                    <td>4</td>
                    <td>5</td>
                    <td>6</td>
                    
                </tr>
                <tr>
                    <td>Grade Range</td>
                    <td>0.00 - 0.49</td>
                    <td>0.50 - 1.49</td>
                    <td>1.50 - 2.49</td>
                    <td>2.50 - 3.49</td>
                    <td>3.50 - 4.49</td>
                    <td>4.50 - 5.49</td>
                    <td>5.50 - 6.00</td>
                    
                </tr>
                <tr>
                    <td>Class</td>
                    <td>Fail</td>
                    <td>Third class</td>
                    <td>Second class</td>
                    <td>First class</td>
                    <td>First class</td>
                    <td>First class with distinction</td>
                    <td>First class with distinction</td>
                    
                </tr>
            </table>
            
            <table class = "new" border="0"  cellpadding="0" cellspacing="0" style="width: 100%;margin-top: 1%;">
                <tr>
                    <td style="text-align:left;">
                        <p style="font-size: 13px;">Pass Requirements : Minimum 40% marks / 'E' Grade in each course, Appearance for IA &amp; ESE</p>
                    </td>
                    
                </tr>						
                
            </table>
            <div style="width:100%;display:block;float:left;"><br /></div>					
            <div style="margin: 50px 0 0 0; width: 100%; font-size: 11px">
                <div style = 'width:20%;margin:16px auto; text-align:center;float:left;'>Seal</div>
                <div style = 'width:25%;margin:16px auto; text-align:center;float:left;'>Checked by</div>
                <div style = 'width:25%;margin:0 auto; text-align:center;float:left;' class='small'>
                    <b>{{college.examControllerName}}</b> <br />Controller of Examinations
                </div>
                <div style = 'width:23%;margin:0 auto; text-align:center;float:left;' class='small'>
                    <b>{{college.principalName}}</b> <br />Principal
                </div>
                <table class = "new footer" border="0"  cellpadding="0" cellspacing="0">
                    <tr>
                        <td style="text-align:center;">
                            <p style="font-size: 13px;margin-bottom: 2%;">{{footer}}</p>
                        </td>
                        
                    </tr>						
                                    
                </table>
            </div>
        </div>

        {# <span style="margin-left: 30px; margin-top:15px;"><b> {{data.collegeAndOtherData.collageName}}</b></span>
        {% set trcolSpan =  10 %}
        {% if data.displayContentOptions.principalSignFlag == '1' or data.displayContentOptions.examControllerSignFlag == '1' or data.displayContentOptions.collegeSealFlag == '1' %}
            <img src='{{data.collegeAndOtherData.principalSign}}' style='width:90px;padding-left:10px;'/> <br/>
            <b style='padding-left: 16px;padding-right: 1px;'>{{data.collegeAndOtherData.principalName}}</b> <br>Principal
        {% endif %}
        {% if data.displayContentOptions.collegeSealFlag == '1' %}
            <img src='{{data.collegeAndOtherData.collegeSeal}}' style='width:90px;padding-left:10px;'/> <br/>
            Seal
        {% endif %}
        {% if data.displayContentOptions.examControllerSignFlag == '1' %}
            <img src='{{data.collegeAndOtherData.examControllerSign}}' style='width:90px;padding-left:10px;'/> <br/>
        {% endif %}
        {% if data.displayContentOptions.examControllerNameFlag == '1' %}
            <b style='padding-left: 16px;padding-right: 1px;'>{{data.collegeAndOtherData.examControllerName}}</b> <br>Controller of Examinations
        {% endif %}
    </div> #}
{% endfor %}
