<?php
include_once (ROOT . FOLDER_CORE . '/auth.php'); 
if ($auth == 1) {
    $doc_key = ! empty($uri[4]) ? $uri[4] : '';
    if ($doc_key != '') {
        $datos_doc = consultarDocumento($bd_conn, $doc_key);
        if (! empty($datos_doc["NOMBRE"])) {
            $doc_part = $datos_doc["PARTES"];
            $doc_version = 0;
            $doc_file = "";
            for ($i=1; $i<=$doc_part; $i++) {
                $fichero = docContent($bd_conn, $datos_doc["SUFIJO"], $doc_key, $i, $doc_version);
                $doc_file .= base64_encode($fichero["FICHERO"]);
            }
            $data = array();
            $data["document"] = array ( 
                "status" => "success: Document process OK",
                "doc_name" => $datos_doc["NOMBRE"],
                "doc_ext" => $datos_doc["EXTENSION"],
                "doc_date" => $datos_doc["FECHA"],
                "doc_size" => $datos_doc["TAMANO"] . " Kb",
                "doc_file" => $doc_file                
            );
        }else{
            $data = array();
            $data["document"] = array ( 
                "status" => "message: error",
                "message" => "Doc not found"
            );
        }
    }else {
        $data = array();
        $data["document"] = array ( 
            "status" => "message: error",
            "message" => "Doc Key is missing"
        );
    }    
    header("Content-type: application/json; charset=utf-8");
    echo json_encode($data);
}elseif ($auth == 0) {
    $data = array();
    $data[] = array ( 
        "status" => "unauthorized_client",
        "message" => "Invalid authorization token"
    );
    header("Content-type: application/json; charset=utf-8");
    echo json_encode($data);
}
//FUNCIONES=============================================
function consultarDocumento($bd, $doc_key)
{
    $sql =  "   SELECT E.NOMBRE, E.EXTENSION, E.FECHA, E.SUFIJO, E.PARTES, E.TAMANO
                FROM BIBLIOTECA_ELEMENTOS E
                WHERE E.CLAVE = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $doc_key = mysqli_real_escape_string($bd, $doc_key);
    $base->bind_param('s', $doc_key);
    $base->execute();
    $result =mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
}
function docContent($bd, $tabla_sufijo, $doc_key, $doc_part, $doc_version)
{
    $sql =  "  SELECT FICHERO
               FROM FICHEROS_$tabla_sufijo 
               WHERE CLAVE = ? AND PARTE = ? AND VERSION = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $doc_key = mysqli_real_escape_string($bd, $doc_key);
    $base->bind_param('sii', $doc_key, $doc_part, $doc_version);
    $base->execute();
    $result =mysqli_fetch_array($base->get_result());
    $base->close();
    return $result;
   }  
?>