<?php 
//-----------------------------------------------------------------------------------------
//-----------------------------EJECUTO LA ACCION SELECIONADA DEL WF-----------------------
//----------------------------------------------------------------------------------------- 
session_start();
//-----------VARIABLES-------------------------------------------------------------------
$doc = "20".$_POST['id'];
$wf = $_POST['wf'];

//-----------CONEXION-------------------------------------------------------------------
require_once '../conexion/conexion.php';
$bd = new connexion();
$bd->query("SET NAMES 'utf8'");
//----------------------------------------------------------------------------------------- 
//-----------------------------QRY ID  DOC -------------------------------------------------
//----------------------------------------------------------------------------------------- 
$sql =  " 	SELECT BE.NOMBRE, BE.EXTENSION, BE.CLAVE
			FROM BIBLIOTECA_ELEMENTOS BE
			WHERE BE.CLAVE = '$doc'";

$base = $bd->query($sql);

$doc_desc = mysqli_fetch_array($base);
$id_doc = $doc_desc['CLAVE'];

$base->close();
//-----------------------------------------------------------------------------------------
//-----------------------------QRY ID  WF -------------------------------------------------
//----------------------------------------------------------------------------------------- 
$sql =  " 	SELECT e.CODIGO AS ID_WF, es.CODIGO AS ID_EST
			FROM WF_ELEMENTOS e INNER JOIN WF_ESTADOS es
			ON e.CODIGO = es.WORKFLOW
			WHERE e.DESCRIPCION = '$wf' AND es.INICIAL = 1";

$base = $bd->query($sql);

$row_wf = mysqli_fetch_array($base);

$base->close();

$id_wf = $row_wf["ID_WF"];
//-----------------------------------------------------------------------------------------
//--------------INICIO DE NUEVO WF---------------------------------------------------------
//----------------------------------------------------------------------------------------- 
$sql =  " 	SELECT DISTINCT WH.ACTUAL
			FROM WF_HISTORIAL WH
			WHERE WH.WORKFLOW = '$id_wf' AND WH.DOCUMENTO = '$doc' AND WH.ACTUAL = 1";

$base = $bd->query($sql);

$result = mysqli_fetch_array($base);
$exist = $result['ACTUAL'];

$base->close();

echo $exist;

mysqli_close($bd);
unset($bd, $exist, $result, $sql, $row_wf, $id_doc, $id_wf, $doc_desc, $doc, $wf);
?>