<?php
////////////////////////FUNCIONES//////////////////////////////////////////////
function curlPost($url,$xml,$headers) {
    $curl = curl_init();
    curl_setopt_array($curl, array(
      CURLOPT_URL => $url,
      CURLOPT_RETURNTRANSFER => true,
      CURLOPT_CUSTOMREQUEST => 'POST',
      CURLOPT_FOLLOWLOCATION => true,
      CURLOPT_MAXREDIRS => 10,
      CURLOPT_TIMEOUT => 90,
      CURLOPT_CONNECTTIMEOUT=> 30,
      CURLOPT_SSL_VERIFYHOST=> false,
      CURLOPT_SSL_VERIFYPEER=> false,
      CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
      CURLOPT_POSTFIELDS => $xml,
      CURLOPT_HTTPHEADER => $headers, 
    ));
    $response = curl_exec($curl);
    $err = curl_error($curl);
    curl_close($curl);
    if ($err) {
      echo "cURL Error #:" . $err;
    } else {
      $response = str_replace('soap:', '', $response);
      return $response;
    } 
  }
  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;
}  
function creaRegistroTablaInter($bd, $clave_doc, $worksteepid)
{
    $query = "  INSERT INTO INTER_ESIGNANYWHERE_FIRMADOS (CLAVE, ID_SERBAN)
                VALUES ( '$clave_doc', '$worksteepid')";
    mysqli_query($bd, $query);
}
function consultarParametro($bd, $cod_parametro) {
	$sql =  " 	SELECT P.VALOR
              FROM PARAMETROS P 
              WHERE P.CODIGO = '$cod_parametro' LIMIT 1";
  	$base = $bd->query($sql);
  	$row = mysqli_fetch_array($base);
  	$result = $row['VALOR'];
  	return $result;
  	$base->close();
}
?>