<?php
require_once "../config.php";

$numemp = $_GET["numemp"];

$sql = "
SELECT
    * 
FROM
    (
    SELECT
        categoria.id,
        categoria.clave,
        categoria.nombre,
        scormvars.numempl AS numempl,
        insignias.imagen,
        insignias.descripcion,
    CASE
            WHEN ( COUNT( scormvars.varValue ) = ( SELECT COUNT( * ) FROM scormpkg WHERE scormpkg.idcategoria = categoria.id AND scormpkg.habilitado = 1 ) ) THEN
            'Completado' ELSE 'No Completado' 
        END AS estado
    FROM
        scormvars
        INNER JOIN scormpkg ON scormpkg.id = scormvars.SCOInstanceID
        INNER JOIN categoria ON scormpkg.idcategoria = categoria.id
        INNER JOIN insignias ON scormpkg.idcategoria = insignias.idobjetivo
    WHERE
        scormvars.varName = 'cmi.core.lesson_status'
        AND (scormvars.varValue = 'completed' )
        AND scormvars.numempl = '".$numemp."'
        AND insignias.habilitado = 1
        AND scormpkg.habilitado = 1
    GROUP BY
        scormvars.numempl,
        categoria.clave    
    ) AS rs1
    ";


global $link;
dbConnect();


$result = mysqli_query($link, $sql);
$return = new stdClass();

if ( mysqli_num_rows($result) <= 0 ) { 
	$return->code = "0";
	$return->msg="Sin sellos v1";
}else{
	$return->code = "1";
	$return->msg="sellos";
	$return->datos = [];

	while ($row = mysqli_fetch_array ($result)){
		$return->datos[] = $row;
	}
}


echo json_encode($return, JSON_UNESCAPED_UNICODE);
mysqli_free_result($result);

exit;


?>