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

    }
    .border-trl-0{
        border-top:1px solid #fff !important;
        border-left:1px solid #fff !important;
        border-right:1px solid #fff !important;
    }
    .border-rl-0{
        border-left:1px solid #fff !important;
        border-right:1px solid #fff !important;
    }
    .border-b-0{
        border-bottom:1px solid #fff !important;
        border-top:1px solid #000 !important;
    }
    .border-t-0{
        border-top:1px solid #fff !important;
        border-bottom:1px solid #000 !important;
    }
    .noborder-r-0{
       border-right-style: none;
    }
    .border-bt-0{
        border-bottom:1px solid #fff !important;
        border-top:1px solid #fff !important;
    }
    .college-head{
        padding: 2px !important;
    }
</style>
    <div class="page" style="width:100%;">
    {% set subjectLen =  data.examRegistrationData.subjectGroups|length %}
    {% set subjectColSpan =   data.examRegistrationData.totalColSpanGrouped %}
    {% set showStudentIds = data.showUucmsId or data.showAbcId %}
    {% set leadingColSpan = 3 + (showStudentIds ? 1 : 0) + (data.showGender ? 1 : 0) %}
    {% set trailingColSpan = 4 + (data.showTotalCreditsEarned ? 1 : 0) %}
    {% set trcolSpan =  subjectLen + leadingColSpan + trailingColSpan %}
    {% set addedAttribute =  data.hideExternalOrInternalMark ? ' data-exclude = true ' : '' %}
    <table class="table border table-responsive-md"  style='' border="1" role="grid" id="regular-consolidated-exam-report" class="consolidated-table">
        <thead>
            <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <div style="text-align:center;margin-top:10px; ">
                        <img  src = '{{data.collegeAndOtherData.collageLogo}}' style = 'width: 85px; height: 115px;'>
                            <div align="center">
                            <div style='font-size:24px; margin-top:10px;'><b>{{data.collegeAndOtherData.collegeName}}</b></div>
                            <div><b>{{data.collegeAndOtherData.collegeAddress}}</b></div>
                            <div>{{data.collegeAndOtherData.collegeAddress2 |escape}}</div>
                            {# <font size="4">
                                <b style='font-size: 19px;'>{{data.collegeAndOtherData.collegeName}}</b>
                            </font><br /> #}
                        </div>
                    </div>
                </td>
            </tr>
            
             <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <div class="" style='font-size: 20px;'><b>Exam Registration Name : {{data.examRegistrationData.name |upper}}</b></div>
                {# <div style='font-size: 15px; line-height:15px;'><b>Exam Registration Name : {{data.examRegistrationData.name}}</b></div></td> #}
                </td>
            </tr>
            <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <div class="" style='font-size: 20px;text-align:center;'><b>Department : {{data.examRegistrationData.deptName |upper}}</b></div>
                </td>
            </tr>
            <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <div class="" style='font-size: 20px;text-align:center;'><b>Semester : {{data.examRegistrationData.academicTermName |upper}}</b></div>
                </td>
            </tr>
            <tr class="">
                <td class="removeTdBorder college-head no-border" style="text-align:center;" data-f-bold='true' data-a-h='center' colspan="{{trcolSpan}}" >
                    <div class="" style='font-size: 20px;text-align:center;'><b>Exam Result Sheet - Faculty Side</b></div>                
                </td>
            </tr>
                           

            <tr></tr>
            <tr class="border">
                <th width="5%" rowspan="1" class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Sl.No.</th>
                <th width="30%" rowspan="1"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Student Name</th>
                <th width="30%" rowspan="1"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Reg. No</th>
                <th width="5%" rowspan="1" class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Gender</th>
                {% for subject in data.examRegistrationData.subjects %}
                    <th width="15%" colspan="1" class='text-center border-r-0' data-a-h='center' data-a-v='middle'>{{subject.code |raw}} <br> {{subject.name |raw}}</th>
                {% endfor %}
                <th width="5%" rowspan="1"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Total</th>
                <th width="5%" rowspan="1"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Status</th>
                <th width="5%" rowspan="1"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>SGPA</th>
                <th width="5%" rowspan="1"class='text-center bold border-r-0' data-a-h='center' data-a-v='middle'>Grade</th>
            </tr>
        </thead>
        <tbody>
            {% set slno = 0 %}
            {% for student in data.studentData %}
                {% for academicTerm in student.academicTerms %}
                {% set slno = slno + 1 %}
                    <tr>
                        <td class="align-middle text-center border-r-0">{{slno}}</td>
                        <td class="align-middle text-center border-r-0">{{student.name | upper}}</td>
                        <td class="align-middle text-center border-r-0">{{student.registerNo}}</td>
                        <td class="align-middle text-center border-r-0">{{student.genderFirstLetter}}</td>
                        {% for subject in data.examRegistrationData.subjects %}
                            {% set isEntered = false %}
                            {% for studentSubject in academicTerm.subjects %}
                                {% if studentSubject.id == subject.id %}
                                    {% set showGradeSubjectMarks = data.showMarksForGradeSubjects or studentSubject.showExcludeSubjectFromTotalWithDetails %}
                                    {% if studentSubject.failedStatus == 'NOT_REGISTRED' %}
                                        <td class="text-center border-r-0"> - </td>
                                    {% else %}
                                        <td class="text-center border-r-0">{{ studentSubject.markObtained }}</td>
                                    {% endif %}
                                    {% set isEntered = true %}
                                {% endif %}
                            {% endfor %}
                            {% if isEntered == false %}
                                <td class="text-center border-r-0"> * </td>
                            {% endif %}
                        {% endfor %}
                        <td class="align-middle text-center border-r-0">{{academicTerm.semesterMarkObtained}}</td>
                        {% if academicTerm.examRegistrationWiseFailedStatus == 'PASSED' %}
                            <td class="align-middle text-center border-r-0">Pass</td>
                        {% else %}
                            <td class="align-middle text-center border-r-0"> Fail</td>
                        {% endif %}  
                        {% if academicTerm.examRegistrationWiseFailedStatus == 'PASSED' %}
                            <td class="align-middle text-center border-r-0">{{academicTerm.semesterSgpa|number_format(2, '.')}}</td>
                        {% else %}
                            <td class="align-middle text-center border-r-0"> - </td>
                        {% endif %}  
                        <td class="align-middle text-center border-r-0">{{academicTerm.semesterGrade}}</td>
                    </tr>
                {% endfor %}
            {% endfor %}
        </tbody>
    </table>
</div>