sgi/gema/export/pdf_alumnocardex.php

<?php
/* AJAX
 * Genera nombramientos en pdf
 * Recibe:
 *  grupo
 * Return:
 *  imprime pdf
 */

setlocale(LC_TIME, 'es_MX.UTF-8');
require_once("../../include/nocache.php");
require_once("../../include/constantes.php");
require_once("../../include/bd_pdo.php");
require_once("../../include/util.php");
require_once("../../classes/ValidaSesion.php");
include_once('../../include/xTemplate/xtemplate.class.php'); // including mpdf.php
include_once('../../include/mpdf/autoload.php'); // including mpdf.php


$pag = "../reporte_alumnoscardex.php";

//--- Objeto para validar usuario. El id de usuario lo lee desde sesión
$objSesion = new ValidaSesion($pdo, array(102, 122), GEMA);
if(!$objSesion->tieneAcceso()){
    header("Location: ".$pag."?error=3");
    exit();
}

unset($objValida);
/*
if(!isset($_POST["id"]) || !isset($_POST["fecha"])){
    header("Location: ".$pag."?error=0");
    exit();
}

$id = filter_input(INPUT_POST, "id", FILTER_SANITIZE_NUMBER_INT);//limpia texto
$fecha = trim(filter_input(INPUT_POST, "fecha", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW)));//limpia texto*/


if(!isset($_GET["clave"])){
    header("Location: ".$pag."?error=0");
    exit();
}
$clave = filter_input(INPUT_GET, "clave", FILTER_SANITIZE_NUMBER_INT);//limpia texto

//Obtiene horario del salon

$stmt = $pdo->prepare('Select * from fs_alumno(NULL, :clave)');
$stmt->bindParam(":clave", $clave);
if(!$stmt->execute()){
    header("Location: materias.php?error=2");
    //$errorDesc = "Error al cargar los datos del alumno";
    //print_r($stmt->errorInfo());
    exit();
}
$alumno_rs = $stmt->fetch();
$stmt->closeCursor();

$stmt = $pdo->prepare('SELECT * FROM fs_alumnomaterias_cardex(:clave, :plan)');
$stmt->bindParam(":clave", $clave);
$stmt->bindParam(":plan", $alumno_rs["PlanEstudio_id"]);
if(!$stmt->execute()){
    header("Location: ".$pag."?error=1");
    //$errorDesc = "Ocurrió un error al cargar las materias.";
    //print_r($stmt->errorInfo());
    exit();
}
$materias_rs = $stmt->fetchAll();
$stmt->closeCursor();

//formato al RS de materias
$materiasArr = Array();

$m = 0;
$mat_last = -1;
foreach($materias_rs as $mat){
    if($mat_last != $mat["Materia_id"]){
        if($mat_last != -1){
            $materiasArr[$m]["califArr"]=$califArr;
            $m++;
        }
        $mat_last = $mat["Materia_id"];
        $califArr = array();
    }
    $materiasArr[$m] = array("id" => $mat["Materia_id"], "desc" => $mat["Materia_desc"], "clave"=>$mat["Materia_clave"],
                "sem"=> $mat["Materia_semestre"], "califArr"=>array());
    if($mat["Calificacion_calif"] != null && $mat["Calificacion_calif"] != ""){
        $califArr[] = array("calif"=>$mat["Calificacion_calif"], "fecha"=>$mat["Calificacion_fecha"], "calif_tipo"=>$mat["TipoCalificacion_id"], "calif_tipo_desc"=>$mat["TipoCalificacion_desc"], "calif_tipo_corta"=>$mat["TipoCalificacion_desc_corta"],
                "revalidada"=>$mat["TipoCalificacion_esEquivalencia"], "reprobada"=>($mat["Calificacion_calif"] <=5)?true:false);
    }
}
if($mat_last != -1){
    $materiasArr[$m]["califArr"]=$califArr;
}


//-----
$defaultConfig = (new Mpdf\Config\ConfigVariables())->getDefaults();
$fontDirs = $defaultConfig['fontDir'];

$defaultFontConfig = (new Mpdf\Config\FontVariables())->getDefaults();
$fontData = $defaultFontConfig['fontdata'];

$mpdf = new \Mpdf\Mpdf([
    'mode' => 'utf-8',
    'format' => [215, 279],
    'orientation' => 'L',
    'margin_top' => 7,
    'margin_bottom' => 7,
    'fontDir' => array_merge($fontDirs, [
        __DIR__ . '/../../fonts/indivisaFont/ttf',
    ]),
    'fontdata' => $fontData + [
        'indivisa-display' => [
            'R' => 'IndivisaDisplaySans-Regular.ttf',
        ],
        'indivisa-title' => [
            'R' => 'IndivisaDisplaySerif-RegularItalic.ttf',
        ],
        'indivisa-text' => [
            'R' => 'IndivisaTextSans-Regular.ttf',
        ]
    ],
    'default_font' => 'indivisa-text',
]);
//$mpdf->SetDisplayMode('fullpage');

$stylesheet = "<style>";
$stylesheet .= file_get_contents('../../css/indivisa.css'); // external css
$stylesheet .= file_get_contents('../css/alumnocardex.css'); // external css
$stylesheet .= "</style>";


$xtpl = new XTemplate('../tpl/alumnocardex.tpl.html');

$xtpl->assign("CLAVE", $clave);     
$xtpl->assign("NOMBRE", $alumno_rs["Usuario_apellidos"]." ".$alumno_rs["Usuario_nombre"]);
$xtpl->assign("CARRERA", $alumno_rs["Carrera_desc"]." ".$alumno_rs["PlanEstudio_desc"]);
$xtpl->parse("main.top");

$maxCol = 5;
$semEnCol = 5;
$sem = -1;
if($alumno_rs["Nivel_id"] == 1)
    $xtpl->assign("SEMESTRE", "Semestre");
else
    $xtpl->assign("SEMESTRE", "Cuatrimestre");

$xtpl->assign("COL_SIZE", "50");
foreach($materiasArr as $mat){
    if($sem != intval($mat["sem"])){
        if($sem != -1){
            $xtpl->parse("main.col.semestre");
        }
        $sem = intval($mat["sem"]);
        if(($sem)%$semEnCol == 0){
            $xtpl->parse("main.col");
        }
        $xtpl->assign("COLS", $maxCol+1);
        $xtpl->assign("NUM", $sem);
    }
    
    $xtpl->assign("MATERIA", $mat["desc"]);
    for($c=0; $c < $maxCol; $c++){
        if($c < count($mat["califArr"])){
            if($mat["califArr"][$c]["calif"] >0)
                $xtpl->assign("CALIF", $mat["califArr"][$c]["calif"]);
            else{
                if($mat["califArr"][$c]["calif_tipo"] == 2)//ordinario
                    $xtpl->assign("CALIF", "SD");
                else
                    $xtpl->assign("CALIF", "NP");
            }
            
            switch($mat["califArr"][$c]["calif_tipo"]){
                case 1: $xtpl->assign("COLOR", "calif-equivalencia"); break;
                case 2: $xtpl->assign("COLOR", ""); break;
                default: $xtpl->assign("COLOR", "calif-extraordinario"); break;
            }

        }else{//no hay mas intentos
            $xtpl->assign("CALIF", "&nbsp;");
        }
        $xtpl->parse("main.col.semestre.table_row.intento");
    }
    $xtpl->parse("main.col.semestre.table_row");
}
$xtpl->parse("main.col.semestre");
$xtpl->parse("main.col");
$xtpl->parse("main");

/*echo $stylesheet;
$xtpl->out("main");*/

$mpdf->WriteHTML($stylesheet);
if(!isset($errorDesc))
    $mpdf->WriteHTML($xtpl->text("main"));
else
    $mpdf->WriteHTML($errorDesc);
$mpdf->Output("cardexAlumno_".$clave.".pdf", 'I');
?>