<script>
function resetear() {
jQuery(':input','#atc-busca-docs')
.not(':button, :submit, :reset, :hidden')
.val('')
.removeAttr('checked')
.removeAttr('selected');
}
</script>
<?php
global $user;
$tabla='';
if (in_array('Gestores de compras', array_values($user->roles))) {
$enviadoR=0;
if(isset($_POST["enviado"]) && ($_POST["enviado"]==1 || $_POST["enviado"]=="1")) {
$enviadoR=1;
}
$empresaR="";
if(isset($_POST["empresaF"]) && $_POST["empresaF"]!="") {
$empresaR=$_POST["empresaF"];
}
$paisR="";
if(isset($_POST["paisF"]) && $_POST["paisF"]!="") {
$paisR=$_POST["paisF"];
}
$regionR="";
if(isset($_POST["regionF"]) && $_POST["regionF"]!="") {
$regionR=$_POST["regionF"];
}
$fechaR="";
if(isset($_POST["fechaF"]) && $_POST["fechaF"]!="") {
$fechaR=$_POST["fechaF"];
}
$asuntoR="";
if(isset($_POST["asuntoF"]) && $_POST["asuntoF"]!="") {
$asuntoR=$_POST["asuntoF"];
}
$destinatariosR="";
if(isset($_POST["destinatariosF"]) && $_POST["destinatariosF"]!="") {
$destinatariosR=$_POST["destinatariosF"];
}
$nombreR="";
if(isset($_POST["nombreF"]) && $_POST["nombreF"]!="") {
$nombreR=$_POST["nombreF"];
}
$mailR="";
if(isset($_POST["mailF"]) && $_POST["mailF"]!="") {
$mailR=$_POST["mailF"];
}
$cargoR="";
if(isset($_POST["cargoF"]) && $_POST["cargoF"]!="") {
$cargoR=$_POST["cargoF"];
}

?>

<div class="id-documentos-descargados container">
<div class="node-type-webform ">
<div class="main-container">
<div class="buscador node-webform">
<form action="" method="post" id="atc-busca-docs">

<div class="empresaF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Empresa</label>
<input class="form-control form-text" type="text" name="empresaF" id="empresaF" value="<?php echo $empresaR; ?>">
</div>

<div class="paisF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">País</label>
<select class="form-control form-text" name="paisF" id="paisF">
<option value="">Todos</option>
<?php
$sql="SELECT tid, name FROM taxonomy_term_data WHERE vid=2";
$query = db_query($sql);

foreach($query as $item) {
if($paisR==$item->tid) {
echo "<option value='".$item->tid."' selected>".$item->name."</option>";
} else {
echo "<option value='".$item->tid."'>".$item->name."</option>";
}
}

?>
</select>
</div>

<div class="regionF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Región</label>
<select class="form-control form-text" name="regionF" id="regionF">
<option value="">Todos</option>
<?php
$sql="SELECT tid, name FROM taxonomy_term_data WHERE vid=8";
$query = db_query($sql);

foreach($query as $item) {
if($regionR==$item->tid) {
echo "<option value='".$item->tid."' selected>".$item->name."</option>";
} else {
echo "<option value='".$item->tid."'>".$item->name."</option>";
}
}

?>
</select>
<!--<input class="form-control form-text" type="text" name="regionF" id="regionF" value="<?php //echo $regionR; ?>">-->
</div>

<div class="fechaF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Fecha de descarga (dd/mm/YYYY)</label>
<input class="form-control form-text" type="text" name="fechaF" id="fechaF" value="<?php echo $fechaR; ?>">
</div>

<div class="asuntoF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Asunto</label>
<input class="form-control form-text" type="text" name="asuntoF" id="asuntoF" value="<?php echo $asuntoR; ?>">
</div>

<div class="destinatariosF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Destinatarios</label>
<input class="form-control form-text" type="text" name="destinatariosF" id="destinatariosF" value="<?php echo $destinatariosR; ?>">
</div>

<div class="nombreF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Nombre de usuario</label>
<input class="form-control form-text" type="text" name="nombreF" id="nombreF" value="<?php echo $nombreR; ?>">
</div>

<div class="mailF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Mail</label>
<input class="form-control form-text" type="text" name="mailF" id="mailF" value="<?php echo $mailR; ?>">
</div>

<div class="cargoF form-item webform-component webform-component-textfield form-group col-xs-6 col-sm-3">
<label class="control-label">Cargo</label>
<input class="form-control form-text" type="text" name="cargoF" id="cargoF" value="<?php echo $cargoR; ?>">
</div>

<div class="buscar form-actions col-md-12">
<input type="hidden" name="enviado" value="1">
<input type="button" value="Resetear formulario" class="btn btn-default" id="reset" onclick="resetear()">
<input type="submit" value="Buscar" class="webform-submit btn btn-default form-submit">
</div>

</form>
</div>
</div>
</div>
</div>

<?php
if($enviadoR==1) {
$tabla.= "<table id='atc-download-docs' class='datatable table-bordered'>";
$tabla.= "<thead>";
$tabla.= "<tr>";
$tabla.= "<th scope='col'>Nombre</th>";
$tabla.= "<th scope='col'>Mail</th>";
$tabla.= "<th scope='col'>Cargo</th>";
$tabla.= "<th scope='col'>Empresa</th>";
$tabla.= "<th scope='col'>País</th>";
$tabla.= "<th scope='col'>Región</th>";
$tabla.= "<th scope='col'>Fecha</th>";
$tabla.= "<th scope='col'>Asunto</th>";
$tabla.= "<th scope='col'>Destinatarios</th>";
$tabla.= "</tr>";
$tabla.= "</thead>";
$tabla.= "<tbody>";

//nid son los identificativos de los formularios en los distintos idiomas
$sql="SELECT DATE_FORMAT(FROM_UNIXTIME(submitted), '%d/%m/%Y') as submitted,nombre,empresa,cargo,pais,region,mail,asunto,destinatarios FROM historicoProveedores WHERE 1=1 ";

//si hay criterios de búsqueda en el formulario que los tenga en cuenta
if($empresaR!="") {
$sql=$sql." AND empresa like '%".$empresaR."%'";
}
/*if($paisR!="") {
$sql=$sql." AND idPais=".$paisR;
}
*/
/*if($regionR!="") {
$sql=$sql." AND region like '%".$regionR."%'";
}*/
if($paisR!="") {
//Obtener el id del pais en los 4 idiomas
$taxpais = taxonomy_term_load($paisR);
$namede = $taxpais->name_field['de'][0]['value'];
$namees = $taxpais->name_field['es'][0]['value'];
$namefr = $taxpais->name_field['fr'][0]['value'];
$namept = $taxpais->name_field['pt-pt'][0]['value'];
$nameen = $taxpais->name_field['en'][0]['value'];

$sql=$sql." AND (idPais =".$paisR ." or Pais in ('".$namede."','".$namees."','".$namefr."','".$namept."','".$nameen."'))";

}

if($regionR!="") {
$taxregion = taxonomy_term_load($regionR);
$regionR = $taxregion->name;
$sql=$sql." AND region like '%".$regionR."%'";
}
if($fechaR!="") {
$fecha1=$fechaR." 00:00:00";
$fecha2=$fechaR." 23:59:59";
$sql=$sql." AND DATE(FROM_UNIXTIME(submitted)) BETWEEN STR_TO_DATE('".$fecha1."','%d/%m/%Y %H:%i:%S') AND STR_TO_DATE('".$fecha2."','%d/%m/%Y %H:%i:%S')";
}
if($asuntoR!="") {
$sql=$sql." AND asunto like '%".$asuntoR."%'";
}
if($nombreR!="") {
$sql=$sql." AND nombre like '%".$nombreR."%'";
}
if($mailR!="") {
$sql=$sql." AND mail like '%".$mailR."%'";
}
if($destinatariosR!="") {
$sql=$sql." AND destinatarios like '%".$destinatariosR."%'";
}
if($cargoR!="") {
$sql=$sql." AND cargo like '%".$cargoR."%'";
}

$sql=$sql." ORDER BY nid"; //esas nid son los formularios en los distintos idiomas
//echo $sql;
$query = db_query($sql);
foreach($query as $item) {
$tabla.= "<tr>";
$tabla.= "<td>".$item->nombre."</td>";
$tabla.= "<td>".$item->mail."</td>";
$tabla.= "<td>".$item->cargo."</td>";
$tabla.= "<td>".$item->empresa."</td>";
$tabla.= "<td>".$item->pais."</td>";
$tabla.= "<td>".$item->region."</td>";
$tabla.= "<td>".$item->submitted."</td>";
$tabla.= "<td>".$item->asunto."</td>";
$tabla.= "<td>".$item->destinatarios."</td>";
$tabla.= "</tr>";
}
$tabla.= "</tbody>";
$tabla.= "</table>";
echo "<div class='container container-contenido-defecto contenedor-download-docs'>".$tabla."<div/>";
global $base_url;
?>
<form action="<?php echo $base_url;?>/generar_excel_listados.php" method="post">
<input type="hidden" name="tabla" value="<?php echo str_replace('"',"'",$tabla); ?>">
<input type="submit" class="btn btn-default" value="Generar Excel">
</form>

</div>
<?php
} //if formulario ha sido enviado
} //if es admin
?>
<!- Datatables ->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.10/css/dataTables.bootstrap.min.css"&gt;
<script type="text/javascript" src="https://cdn.datatables.net/1.10.10/js/jquery.dataTables.min.js"></scrip…;
<script type="text/javascript" src="https://cdn.datatables.net/1.10.10/js/dataTables.bootstrap.min.js"></sc…;

<!- Responsive ->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/responsive/2.0.0/css/responsive.bootstrap.mi…;
<script type="text/javascript" src="https://cdn.datatables.net/responsive/2.0.0/js/dataTables.responsive.mi…;
<script type="text/javascript" src="https://cdn.datatables.net/responsive/2.0.0/js/responsive.bootstrap.min…;

<script>
jQuery(document).ready(function() {
jQuery('#atc-download-docs').DataTable({
searching: false,
paging: false
});
});
</script>