/var/www/clients/client1/web2/web/admin
Edit: /var/www/clients/client1/web2/web/admin/excel_contacto.php (2377B)
0 ";
if($_REQUEST['tipo'] and $_REQUEST['tipo']!='General'){
$query_ventas .= " and tipo = '".escape($_REQUEST['tipo'])."' ";
}
if(isset($_POST['desde']) && $_POST['desde']!=''){
$query_ventas .= " and fecha >= '".ingles($_REQUEST['desde'])."' ";
}
if(isset($_POST['hasta']) && $_POST['hasta']!=''){
$query_ventas .= " and fecha <= '".ingles($_REQUEST['hasta'])."' ";
}
if(isset($_POST['id_sitio']) && intval($_POST['id_sitio'])!='0'){
if(intval($_REQUEST['id_sitio'])==3){
$query_ventas .= " and id_sitio = '".intval($_REQUEST['id_sitio'])."' or id_sitio = 8 ";
} else {
$query_ventas .= " and id_sitio = '".intval($_REQUEST['id_sitio'])."' ";
}
}
$query_ventas .= " order by fecha desc, Id desc ";
$ventas = mysqli_query($latynconexiones, $query_ventas) or die(mysqli_error());
$row_ventas = mysqli_fetch_assoc($ventas);
if(mysqli_num_rows($ventas)){
header('Content-type: application/vnd.ms-excel');
header("Content-Disposition: attachment; filename=".sitio($_POST['id_sitio'])."_".date('d_m_Y').".xls");
header("Pragma: no-cache");
header("Expires: 0");
do {
$data .= utf8_decode(sitio($row_ventas['id_sitio']))."\t";
$data .= espanol($row_ventas['fecha'])."\t";
$data .= utf8_decode($row_ventas['nombre'])."\t";
$data .= utf8_decode($row_ventas['email'])."\t";
$data .= utf8_decode($row_ventas['telefono'])."\t";
$data .= utf8_decode($row_ventas['empresa'])."\t";
$data .= utf8_decode(der($row_ventas['mensaje']))."\t";
$data .= "\n";
} while ($row_ventas = mysqli_fetch_assoc($ventas));
print "Sitio\tFecha\tNombre\tEmail\tTelefono\tEmpresa\tMensaje";
print "\n$data";
} else { echo 'No hay datos'; }
function der($var1) {
$cadena = $var1;
$cadena = str_replace( chr(13), "", $cadena );
$cadena = str_replace( "'", "", $cadena );
$cadena = str_replace( '"', '', $cadena );
$cadena = str_replace( chr(10) & chr(10), "", $cadena);
$cadena = str_replace( chr(10), "", $cadena );
return($cadena) ;
}
function fre($cadena){
$cadena=str_replace(" ","_",$cadena);
return($cadena);
}
mysqli_free_result($ventas);
?>