<?php 
//=====================================================================================
//INICIO LA SESION---------------------------------------------------------------------
//=====================================================================================
session_start();
//=====================================================================================
//CONEXION-----------------------------------------------------------------------------
//=====================================================================================
require_once '../conn/conn.php';
$bd_conn = new connexion();
$bd_conn->query("SET NAMES 'utf8'");
setlocale(LC_TIME,"es_ES");
define('COD_ACC_OPEN_DUWA', '58');
define('ORDENADOR_EXT', 'ORD_EXTERNO');
define('AMBITO', 'PUB');
//=====================================================================================
//VARIABLES----------------------------------------------------------------------------
//=====================================================================================
require_once '../core/config.php';
$vinculo_id = $_POST["vinculo_id"];
$pin = trim($_POST["pin"]);
$pin_sha1 = sha1($pin);
//=====================================================================================
//CODE---------------------------------------------------------------------------------
//=====================================================================================
$base = consultarValidesVinculo($bd_conn, $vinculo_id, $pin_sha1);
$vinculo = array();
$i = 0;
while ($row = $base->fetch_object()){
    if ($row->VALIDO == 1) {
        historialLog($bd_conn, $row->CLAVE, $row->CONTACTO, COD_ACC_OPEN_DUWA, ORDENADOR_EXT, AMBITO);
    }
    $vinculo[$i] = array ( 
        "vinculo_valido" => $row->VALIDO,
        'clave_exp' => $row->CLAVE
    );
    $i++;
}
//DATA
$data = array();
$data["data"] = array ( 
    "vinculo" => $vinculo
);
header("Content-type: application/json; charset=utf-8");
mysqli_close($bd_conn);
echo json_encode($data);
//=====================================================================================
//FUNCIONES----------------------------------------------------------------------------
//=====================================================================================
function historialLog($bd, $clave, $user, $accion, $ordenador, $ambito) {
	mysqli_query($bd, "INSERT INTO BIBLIOTECA_HISTORIAL 
						(CLAVE, USUARIO, FECHA, ACCION, ORDENADOR, AMBITO, TIPO, CREADOR, CONTROL, AWA) 
						VALUES 
						('$clave', '$user', now(), $accion, '$ordenador', '$ambito', 'D', '$user', 0, 1)") ;
}
function consultarValidesVinculo($bd, $vinculo_id, $pin_sha1)
{
    $sql =  "   SELECT COUNT(V.VINCULO) AS VALIDO, V.CLAVE, V.CONTACTO
                FROM BIBLIOTECA_VINCULOS V
                WHERE V.VINCULO = ? AND V.ACTIVO = 1 AND V.CLAVE_DESCARGA = ? LIMIT 1";
    $base = $bd->prepare($sql);
    $vinculo_id = mysqli_real_escape_string($bd, $vinculo_id);
    $pin_sha1 = mysqli_real_escape_string($bd, $pin_sha1);
    $base->bind_param('ss', $vinculo_id, $pin_sha1);
    $base->execute();
    $result = $base->get_result();
    $base->close();
    return $result;
}
?>