<?php

$listRol = array();
$consulta = "SELECT * FROM format AS formato INNER JOIN rolpermissionsformat AS permiso ON formato.idFormat = permiso.idFormat WHERE formato.idFormat = $idFormat";
$resultado  = mysqli_query($conexion, $consulta);
if (!empty($resultado)) {
    $listRol = getListRol($conexion, $idFormat);
    $dataEnd  = getInformation($resultado, $listRol);
    echo json_encode(array("code" => CODE_SUCCESS, "message" => $dataEnd));
} else {
    echo json_encode(array("code" => CODE_FAILED, "message" => 'Formato no encontrado'));
}


function getListRol($conexion, $idFormat)
{
    $dataList = array();
    $consulta = "SELECT * FROM format AS formato INNER JOIN rolpermissionsformat AS permiso ON formato.idFormat = permiso.idFormat WHERE formato.idFormat = $idFormat";
    $resultado  = mysqli_query($conexion, $consulta);
    while ($row = mysqli_fetch_array($resultado)) {
        array_push($dataList, (int)$row['idRol']);
    }
    return $dataList;
}

function getInformation($data, $listRol)
{
    $row = mysqli_fetch_array($data);
    return array(
        "idFormat" => (int)$row['idFormat'],
        "nameFormat" => $row['nameFormat'],
        "description" => $row['description'],
        "documentId" => (int)$row['documentId'],
        "typeDocument" => $row['typeDocument'],
        "idUser" => (int)$row['idUser'],
        "idRol" =>  $listRol
    );
}