<?php
include ("Comun.php");
$db = Conectar();

date_default_timezone_set('America/Santiago');	

$to  = 'daniel@austral3d.com, francisco@austral3d.com, nd0806@gmail.com, tecnologia@austral3d.com';
//$to  = 'nd0806@gmail.com';
$subject = 'Reporte semanal de ingresos a Fourdplan y Avit Mining';
$today = date('Y-m-d');
$start_date = date('Y-m-d', strtotime($today. ' - 7 days'));


$header1 = '<tr>
					<th>Mail</th>
					<th>nombre</th>
					<th>apellido</th>
					<th>ingreso</th>
					<th>IP</th>
					<th>empresa</th>
					<th>tipo</th>
				<tr>';
				
$header2 = '<tr>
					<th>Mail</th>
					<th>nombre</th>
					<th>apellido</th>
					<th>ingreso</th>
					<th>IP</th>
				<tr>';				
				
$header3 = $header2;
$header4 = $header2;

$header5 = '<tr>
					<th>Mail</th>
					<th>ingreso</th>
					<th>IP</th>
					<th>demo</th>
				<tr>';

$header6 = '<tr>
					<th>email</th>
					<th>nombre</th>
					<th>apellido</th>		
					<th>pais</th>
					<th>telefono</th>
					<th>empresa</th>
				<tr>';

$header7 = $header2;
$header8 = $header2;		
$header9 = $header2;
	
$data = ejecutar("SELECT u.mail, u.nombre, u.apellido, s.inicio, s.ip, e.nombre, sof.software FROM Usuario u, Sesion s, Empresa e, Software sof WHERE s.usuario_id = u.id AND e.id = u.empresa_id AND s.software_id = sof.id AND s.inicio >= '$start_date' AND usuario_id != 1 ORDER BY s.inicio DESC");

$tabla1 = '';
$count = mysql_num_rows($data);
for ($i = 0; $i < $count; $i++)
{	
	$tupla = mysql_fetch_row($data);
	$tabla1 .= '<tr><td>' . $tupla[0] . '</td><td>' . $tupla[1] . '</td><td>' . $tupla[2] . '</td><td>' . $tupla[3] . '</td><td>' . $tupla[4] . '</td><td>' . $tupla[5] . '</td><td>' . $tupla[6] . '</td></tr>';
}

if ($count == 0) 
{
	$header1 = '';
	$tabla1 = 'No hay ingresos';
}

mysql_select_db('avit_elec');

$data = ejecutar("SELECT email, tiempo, ip, demo FROM LoginDemos WHERE tiempo >= '$start_date' ORDER BY tiempo DESC");

$tabla5 = '';
$count = mysql_num_rows($data);
for ($i = 0; $i < $count; $i++)
{	
	$tupla = mysql_fetch_row($data);
	$tabla5 .= '<tr><td>' . $tupla[0] . '</td><td>' . $tupla[1] . '</td><td>' . $tupla[2] . '</td><td>' . $tupla[3] . '</td></tr>';
}


if ($count == 0) 
{
	$header5 = '';
	$tabla5 = 'No hay ingresos';
}

$data = ejecutar("SELECT email, nombre, apellido, pais, telefono, empresa FROM UsuarioPagina ORDER BY id DESC LIMIT 10");

$tabla6 = '';
$count = mysql_num_rows($data);
for ($i = 0; $i < $count; $i++)
{	
	$tupla = mysql_fetch_row($data);
	$tabla6 .= '<tr><td>' . $tupla[0] . '</td><td>' . $tupla[1] . '</td><td>' . $tupla[2] . '</td><td>' . $tupla[3] . '</td><td>' . $tupla[4] . '</td><td>'. $tupla[5] . '</td></tr>';
}


if ($count == 0) 
{
	$header6 = '';
	$tabla6 = 'No hay ingresos';
}

mysql_select_db('avit_cl');

$data = ejecutar("SELECT u.mail, u.nombres, u.apellido_paterno, s.tiempo_inicio, s.ip FROM Usuario u, Sesion s WHERE s.usuario_id = u.id AND s.tiempo_inicio >= '$start_date' AND usuario_id != 1 AND usuario_id != 2 ORDER BY s.tiempo_inicio DESC");

$tabla7 = '';
$count = mysql_num_rows($data);
for ($i = 0; $i < $count; $i++)
{	
	$tupla = mysql_fetch_row($data);
	$tabla7 .= '<tr><td>' . $tupla[0] . '</td><td>' . $tupla[1] . '</td><td>' . $tupla[2] . '</td><td>' . $tupla[3] . '</td><td>' . $tupla[4] . '</td></tr>';
}

if ($count == 0) 
{
	$header7 = '';
	$tabla7 = 'No hay ingresos';
}

mysql_select_db('kaufmann');

$data = ejecutar("SELECT u.mail, u.nombre, u.apellido, s.inicio, s.ip FROM Usuario u, Sesion s WHERE s.usuario_id = u.id AND s.inicio >= '$start_date' AND usuario_id != 1 ORDER BY s.inicio DESC");

$tabla8 = '';
$count = mysql_num_rows($data);
for ($i = 0; $i < $count; $i++)
{	
	$tupla = mysql_fetch_row($data);
	$tabla8 .= '<tr><td>' . $tupla[0] . '</td><td>' . $tupla[1] . '</td><td>' . $tupla[2] . '</td><td>' . $tupla[3] . '</td><td>' . $tupla[4] . '</td></tr>';
}

if ($count == 0) 
{
	$header8 = '';
	$tabla8 = 'No hay ingresos';
}

mysql_select_db('falck');

$data = ejecutar("SELECT u.mail, u.nombre, u.apellido, s.inicio, s.ip FROM Usuario u, Sesion s WHERE s.usuario_id = u.id AND s.inicio >= '$start_date' AND usuario_id != 1 ORDER BY s.inicio DESC");

$tabla9 = '';
$count = mysql_num_rows($data);
for ($i = 0; $i < $count; $i++)
{	
	$tupla = mysql_fetch_row($data);
	$tabla9 .= '<tr><td>' . $tupla[0] . '</td><td>' . $tupla[1] . '</td><td>' . $tupla[2] . '</td><td>' . $tupla[3] . '</td><td>' . $tupla[4] . '</td></tr>';
}

if ($count == 0) 
{
	$header9 = '';
	$tabla9 = 'No hay ingresos';
}
// $message = '
// <html>
// <head>
// </head>
// <body>  
// 	<div>
// 		<center>
// 			<img src="http://www.fourdplan.com/webservices/banner2.jpg" height="107" width="765">
// 			<br style = "color: white;">.</br>
// 			<table style="width:100%;">
// 				<tr>
// 					<th style = "border: 1px solid black;">FOURDPLAN</th>
// 					<th style = "border: 1px solid black; font-size:22px;">Reporte semanal de ingresos a Fourdplan y Avit Mining</th> 
// 					<th style = "border: 1px solid black;">AUSTRAL3D</th>
// 				</tr>
// 			</table>
			
// 			<table style="width:100%;">
// 				<tr>
// 					<td style = "border: 1px solid black; font-weight: bold;">Desde:</td>
// 					<td style = "border: 1px solid black;">' . $start_date . '</td>
// 					<td style = "border: 1px solid black; font-weight: bold;">Hasta:</td>
// 					<td style = "border: 1px solid black;">' . $today . '</td>
// 				</tr>
// 				<tr>
// 					<td colspan="4" style = "border: 1px solid black;"><center>Se excluye al administrador</center></td>
// 				</tr>
// 			</table>
			
// 			<br>
			
// 			<p><b>FOURDPLAN</b></p>
// 			<table border="1">'
// 				. $header1 . $tabla1 . 
// 			'</table>
			
// 			<p><b>AUSTRAL3D DEMOS</b></p>
// 			<table border="1">'
// 				. $header5 . $tabla5 . 
// 			'</table>
			
// 			<p><b>AUSTRAL3D REGISTRO DE USUARIOS</b></p>
// 			<p>Como no hay registro de fechas se muestran las ultimas 10 filas.</p>
// 			<table border="1">'
// 				. $header6 . $tabla6 . 
// 			'</table>
			
// 			<p><b>CRYSTAL LAGOONS</b></p>
// 			<table border="1">'
// 				. $header7 . $tabla7 . 
// 			'</table>
			
// 			<p><b>KAUFMANN</b></p>
// 			<table border="1">'
// 				. $header8 . $tabla8 . 
// 			'</table>
			
// 			<p><b>FALCK</b></p>
// 			<table border="1">'
// 				. $header9 . $tabla9 . 
// 			'</table>
		
// 		</center>;
			
		
	
// 	</div>
  
// </body>
// </html>';

// $headers  = 'MIME-Version: 1.0' . "\r\n";
// $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
// $headers .= 'From: Austral3D <tecnologia@austral3d.com>' . "\r\n";

// $mail_sent = mail($to, $subject, $message, $headers);

 ?>