{% set tipoUsuario = app.session.get('rol') %}
<div class="col-lg-6">
    <div class="panel panel-primary">
        <div class="panel-heading">
            ALUMNOS ACTIVOS
            <input type="button" onclick="tableToExcel('tabla-activos', 'W3C Example Table', 'myfile.xls')" value="Export to Excel" class="btn btn-info btn-xs">
        </div>
        <div class="panel-body" style="height: 500px;overflow-y: scroll">
            <table class="table table-bordered table-striped table-hover table-responsive table-condensed" style="font-size: x-small;" id="tabla-activos">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>CVE ALUMNO</th>
                        <th></th>
                        <th>NOMBRE DEL ALUMNO</th>
                        <th>NIVEL</th>
                        <th>ESPECIALIDAD</th>
                        <th>GRADO</th>
                    </tr>
                </thead>
                <tbody>
                    {% for d in datos[0] %}
                        <tr>
                            <td style="vertical-align: middle;">{{loop.index}}</td>
                            <td style="vertical-align: middle;">
                                <a href="{{path('consulta_alumno_dos', {ideAlu: d[0].ideAlu} )}}" target="_blank" style="color: black;">{{d[0].cveCtl}}</a>
                                {% if tipoUsuario == 3 or tipoUsuario == 101 %}
                                    <a href="{{path('vista_pago',{cveCtl:d[0].cveCtl})}}" class="btn btn-xs btn-success" target="_blank" data-toggle="tooltip" title="Ir a Caja..." data-placement="right">$</a>
                                {% endif %}
                            </td>
                            <td style="vertical-align: middle;">
                                {% if d[0].credencial == 1 %}
                                    <img src="{{asset(d[1])}}" style="width: 15px;border-radius: 20px;border: solid 1px blue;" class="zoom">
                                {% else %}
                                    <img src="{{asset(d[1])}}" style="width: 15px;border-radius: 20px;border: solid 1px red;" class="zoom">
                                {% endif %}
                            </td>
                            <td style="vertical-align: middle;">{{d[0].apePat}} {{d[0].apeMat}} <i style="font-weight: bolder;">{{d[0].nomAlu}}</i></td>
                            <td>
                                {% if d[0].tipoAlumno == 1 %}
                                    BACHILLERATO
                                {% elseif d[0].tipoAlumno == 2 %}
                                    E.U.
                                {% elseif d[0].tipoAlumno == 3 %}
                                    LIC.
                                {% elseif d[0].tipoAlumno == 4 %}
                                    MTRÍA.
                                {% elseif d[0].tipoAlumno == 5 %}
                                    DOC.
                                {% elseif d[0].tipoAlumno == 6 %}
                                    OTRA
                                {%endif  %}
                            </td>
                            <td style="vertical-align: middle;">{{d[0].cveLic.nomLic}}</td>
                            <td style="vertical-align: middle;">{{d[0].numero}}</td>
                        </tr>
                    {% else %}
                        <tr class="text-center">
                            <td colspan="5"> NO HAY ALUMNOS ACTIVOS ``(°.°)´´</td>
                        </tr>
                    {% endfor %}
                </tbody>
            </table>
        </div><!-- FIN PANEL BODY -->
        <div class="panel-footer">

        </div><!-- FIN PANEL FOOTER -->
    </div>
</div>
<div class="col-lg-6">
    <div class="col-lg-12" style="padding-left: 0px; padding-right: 0px;">
        <div class="panel panel-red">
            <div class="panel-heading">
                EN BAJA o NO HAN HECHO SU REINSCRIPCIÓN
            </div>
            <div class="panel-body" style="height: 250px;overflow-y: scroll;">
                <table class="table table-bordered table-striped table-hover table-responsive table-condensed" style="font-size: x-small;" id="tabla-bajas">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>CVE ALUMNO</th>
                            <th></th>
                            <th>NOMBRE DEL ALUMNO</th>
                            <th>NIVEL</th>
                            <td>ESPECIALIDAD</td>
                            <th>GRADO</th>
                            <th>ESTATUS</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for d in datos[1] %}
                            <tr>
                                <td style="vertical-align: middle;">{{loop.index}}</td>
                                <td style="vertical-align: middle;">
                                    <a href="{{path('consulta_alumno_dos', {ideAlu: d[0].ideAlu} )}}" target="_blank" style="color: black;">{{d[0].cveCtl}}</a>
                                    {% if tipoUsuario == 3 %}
                                        <a href="{{path('vista_pago',{cveCtl:d[0].cveCtl})}}" class="btn btn-xs btn-success" target="_blank" data-toggle="tooltip" title="Ir a Caja..." data-placement="right">$</a>
                                    {% endif %}
                                </td>
                                <td style="vertical-align: middle;">
                                    {% if d[0].credencial == 1 %}
                                        <img src="{{asset(d[1])}}" style="width: 15px;border-radius: 20px;border: solid 1px blue;" class="zoom">
                                    {% else %}
                                        <img src="{{asset(d[1])}}" style="width: 15px;border-radius: 20px;border: solid 1px red;" class="zoom">
                                    {% endif %}
                                </td>
                                <td style="vertical-align: middle;">{{d[0].apePat}} {{d[0].apeMat}} <i style="font-weight: bolder;">{{d[0].nomAlu}}</i></td>
                                <td style="vertical-align: middle;">
                                    {% if d[0].tipoAlumno == 1 %}
                                        BACHILLERATO
                                    {% elseif d[0].tipoAlumno == 2 %}
                                        E.U.
                                    {% elseif d[0].tipoAlumno == 3 %}
                                        LIC.
                                    {% elseif d[0].tipoAlumno == 4 %}
                                        MTRÍA.
                                    {% elseif d[0].tipoAlumno == 5 %}
                                        DOC.
                                    {% elseif d[0].tipoAlumno == 6 %}
                                        OTRA ^(°o°)^
                                    {%endif  %}
                                </td>
                                <td style="vertical-align: middle;">{{d[0].cveLic.nomLic}}</td>
                                <td style="vertical-align: middle;">{{d[0].numero}}</td>
                                <td style="vertical-align: middle;">{{d[0].estatus.desEst}}</td>
                            </tr>
                        {% else %}
                            <tr class="text-center">
                                <td colspan="5"> NO HAY ALUMNOS EN ALGUNA SITUACIÓN DE BAJA ``(°.°)´´</td>
                            </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div><!-- FIN PANEL BODY -->
            <div class="panel-footer">

            </div>
        </div>
    </div>
    <div class="col-lg-12" style="padding-left: 0px; padding-right: 0px;">
        <div class="panel panel-green">
            <div class="panel-heading">
                EGRESADOS
            </div>
            <div class="panel-body" style="height: 250px;overflow-y: scroll;">
                <table class="table table-bordered table-striped table-hover table-responsive table-condensed" style="font-size: x-small;" id="tabla-egresados">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>CVE ALUMNO</th>
                            <th></th>
                            <th>NOMBRE DEL ALUMNO</th>
                            <th>NIVEL</th>
                            <td>ESPECIALIDAD</td>
                            <th>GRADO</th>
                            <th>ESTATUS</th>
                        </tr>
                    </thead>
                    <tbody>
                        {% for d in datos[2] %}
                            <tr>
                                <td style="vertical-align: middle;">{{loop.index}}</td>
                                <td style="vertical-align: middle;">
                                    <a href="{{path('consulta_alumno_dos', {ideAlu: d[0].ideAlu} )}}" target="_blank" style="color: black;">{{d[0].cveCtl}}</a>
                                    {% if tipoUsuario == 3 %}
                                        <a href="{{path('vista_pago',{cveCtl:d[0].cveCtl})}}" class="btn btn-xs btn-success" target="_blank" data-toggle="tooltip" title="Ir a Caja..." data-placement="right">$</a>
                                    {% endif %}
                                </td>
                                <td style="vertical-align: middle;">
                                    {% if d[0].credencial == 1 %}
                                        <img src="{{asset(d[1])}}" style="width: 15px;border-radius: 20px;border: solid 1px blue;" class="zoom">
                                    {% else %}
                                        <img src="{{asset(d[1])}}" style="width: 15px;border-radius: 20px;border: solid 1px red;" class="zoom">
                                    {% endif %}
                                </td>
                                <td style="vertical-align: middle;">{{d[0].apePat}} {{d[0].apeMat}} <i style="font-weight: bolder;">{{d[0].nomAlu}}</i></td>
                                <td style="vertical-align: middle;">
                                    {% if d[0].tipoAlumno == 1 %}
                                        BACHILLERATO
                                    {% elseif d[0].tipoAlumno == 2 %}
                                        E.U.
                                    {% elseif d[0].tipoAlumno == 3 %}
                                        LIC.
                                    {% elseif d[0].tipoAlumno == 4 %}
                                        MTRÍA.
                                    {% elseif d[0].tipoAlumno == 5 %}
                                        DOC.
                                    {% elseif d[0].tipoAlumno == 6 %}
                                        OTRA ^(°o°)^
                                    {%endif  %}
                                </td>
                                <td style="vertical-align: middle;">{{d[0].cveLic.nomLic}}</td>
                                <td style="vertical-align: middle;">{{d[0].numero}}</td>
                                <td style="vertical-align: middle;">{{d[0].estatus.desEst}}</td>
                            </tr>
                        {% else %}
                            <tr class="text-center">
                                <td colspan="5"> NO HAY ALUMNOS EGRESADOS ``(°.°)´´</td>
                            </tr>
                        {% endfor %}
                    </tbody>
                </table>
            </div>
            <div class="panel-footer">

            </div>
        </div>
    </div>
</div>

