<?php
require_once __DIR__.'/auth_guard.php';
require_once "../config.php";
$sql="SELECT
cat1.id as id,
CASE 
	WHEN cat1.padre = 0 THEN
		'Raíz'
	ELSE
		(SELECT cat2.nombre FROM categoria as cat2 WHERE cat2.id = cat1.padre)
END AS 'Categoría superior',
cat1.clave as 'Clave',
cat1.nombre as Nombre,
cat1.imagen as 'Imagen',
cat1.descripcion as 'Descripción',
cat1.habilitado as Habilitado,
cat1.order_desc as 'Orden de módulo',
cat1.creado as 'Fecha de creación',
cat1.Actualizacion as 'Última modificación'
FROM
categoria as cat1
ORDER BY cat1.padre ASC";

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","Categoría superior","Clave","Nombre","Imagen","Descripción","Habilitado","Orden de módulo","Fecha de creación","Última modificació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);
	$wwwroot = rtrim($CFG->wwwroot, '/');
	while ($row = mysqli_fetch_row ($result)){
		if (isset($row[4])) {
			$img = trim((string)$row[4]);
			if ($img !== '' && !preg_match('~^(https?:)?//~i', $img)) {
				$img = $wwwroot . '/' . ltrim($img, '/');
			}
			$row[4] = $img;
		}
		$return->datos[] = $row;
	}

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

?>