<?php
require_once __DIR__.'/auth_guard.php';
require_once "../config.php";
$sql="
SELECT
insignias.id,
insignias.idobjetivo as 'Id objetivo',
CASE 
	WHEN insignias.objetivo = 'categoria' THEN
		(SELECT nombre FROM categoria WHERE categoria.id = insignias.idobjetivo)
	ELSE
		(SELECT nombre FROM scormpkg WHERE scormpkg.id = insignias.idobjetivo)
END AS 'Recurso',
insignias.objetivo as 'Tipo',
insignias.nombre as 'Nombre',
insignias.descripcion as 'Descripción',
insignias.imagen as 'Imagen',
insignias.habilitado as 'Habilitado',
insignias.creado as 'Creado',
insignias.actualizacion as 'Actualización'
FROM
insignias";

global $link;
dbConnect();
$result = mysqli_query($link, $sql);
$return = new stdClass();
if ( mysqli_num_rows($result) <= 0 ) { 
	$return->code = "0";
	$return->msg="Sin categorías";
	$return->columns = ["id","Id objetivo","Recurso","Tipo","Nombre","Descripción","Imagen","Habilitado","Creado","Actualización"];

}else{
	$return->code = "1";
	$return->msg="categorías";
	$return->datos = [];
	$return->columns = [];
	while ($row = mysqli_fetch_assoc ($result)){
		$return->columns = array_keys($row);
	}
	mysqli_data_seek($result, 0);
	while ($row = mysqli_fetch_row ($result)){
		$return->datos[] = $row;
	}

}
echo json_encode($return, JSON_UNESCAPED_UNICODE);
exit;

?>