{# Hierarchical Export Template for KPI Student Lifecycle #} {# Renders hierarchical data with proper indentation, styling, and subtotals #} {# Pre-calculate colspan for all header tables - ensures consistent, clean HTML #} {% set dataTableColspan = showDetails ? 8 : 6 %}
{# Common Header (Institution Banner) #} {% if commonHeader %}
{{ commonHeader|replace({"colspan=''": "colspan='" ~ dataTableColspan ~ "' style='width: 100%;'"})|raw }}
{% endif %} {# Report Title as Table (for Excel export compatibility) #}
{% if listType == 'SCHOOL' %} Schools Student Info Report {% elseif listType == 'DEPARTMENT' %} Departments Wise Student Info Report {% elseif listType == 'PROGRAM' %} Programs Wise Student Info Report {% elseif listType == 'BATCH' %} Batch/Section Wise Student Info Report {% elseif listType == 'STUDENT' %} Students Information Report {% else %} Student Info Report {% endif %}
{# Filter Information #} {% if kpiHeader and (kpiHeader.schoolName or kpiHeader.deptName or kpiHeader.programName or kpiHeader.termName or kpiHeader.batchName) %}
{% if kpiHeader.schoolName %} School: {{ kpiHeader.schoolName }} {% endif %} {% if kpiHeader.deptName %} | Department: {{ kpiHeader.deptName }} {% endif %} {% if kpiHeader.programName %} | Program: {{ kpiHeader.programName }} {% endif %} {% if kpiHeader.termName %} | Term: {{ kpiHeader.termName }} {% endif %} {% if kpiHeader.batchName %} | Batch/Section: {{ kpiHeader.batchName }} {% endif %}
{% endif %} {# Main Data Table #} {% if showDetails %} {% endif %} {% for item in studentListData %} {# School/Department Header Row #} {% if showDetails %} {% endif %} {% if showAdmissionYear and item.admission_years %} {% for yearData in item.admission_years %} {% if not showProgramLevel %} {# Year-only view: show year rows #} {% if showDetails %} {% endif %} {% else %} {# Full hierarchy view: show year + programs #} {% if showDetails %} {% endif %} {# Program Level Rows #} {% if yearData.programs %} {% for progData in yearData.programs %} {% if showDetails %} {% endif %} {% endfor %} {% endif %} {% endif %} {% endfor %} {% endif %} {% endfor %}
Si.No {% if listType == 'SCHOOL' %} School {% elseif listType == 'DEPARTMENT' %} Department {% elseif listType == 'PROGRAM' %} Program {% elseif listType == 'BATCH' %} Batch/Section {% elseif listType == 'STUDENT' %} Student {% else %} Item {% endif %} Active Dormant FailedDiscontinued CompletedTotal
{{ loop.index }} {{ item.name|default('') }} {{ (item.totals.active_student|default(0))|number_format(0, '.', ',') }} {{ (item.totals.dormant_student|default(0))|number_format(0, '.', ',') }} {{ (item.totals.failed_student|default(0))|number_format(0, '.', ',') }}{{ (item.totals.discontinue_student|default(0))|number_format(0, '.', ',') }} {{ (item.totals.completed_student|default(0))|number_format(0, '.', ',') }}{{ (item.totals.total_student_count|default(0))|number_format(0, '.', ',') }}
Admission Year: {{ yearData.admission_year == 9999 ? 'Unknown' : yearData.admission_year }} {{ (yearData.active_student|default(0))|number_format(0, '.', ',') }} {{ (yearData.dormant_student|default(0))|number_format(0, '.', ',') }} {{ (yearData.failed_student|default(0))|number_format(0, '.', ',') }}{{ (yearData.discontinue_student|default(0))|number_format(0, '.', ',') }} {{ (yearData.completed_student|default(0))|number_format(0, '.', ',') }}{{ (yearData.total_student_count|default(0))|number_format(0, '.', ',') }}
Admission Year: {{ yearData.admission_year == 9999 ? 'Unknown' : yearData.admission_year }} {{ (yearData.active_student|default(0))|number_format(0, '.', ',') }} {{ (yearData.dormant_student|default(0))|number_format(0, '.', ',') }} {{ (yearData.failed_student|default(0))|number_format(0, '.', ',') }}{{ (yearData.discontinue_student|default(0))|number_format(0, '.', ',') }} {{ (yearData.completed_student|default(0))|number_format(0, '.', ',') }}{{ (yearData.total_student_count|default(0))|number_format(0, '.', ',') }}
Program Level: {{ progData.level|default('') }} {{ (progData.active_student|default(0))|number_format(0, '.', ',') }} {{ (progData.dormant_student|default(0))|number_format(0, '.', ',') }} {{ (progData.failed_student|default(0))|number_format(0, '.', ',') }}{{ (progData.discontinue_student|default(0))|number_format(0, '.', ',') }} {{ (progData.completed_student|default(0))|number_format(0, '.', ',') }}{{ (progData.total_student_count|default(0))|number_format(0, '.', ',') }}
{# Footer #}
Generated on: {{ 'now'|date('d/m/Y H:i A') }}