<?php

include_once "common.php";
include_once "encriptar.php";

date_default_timezone_set('America/Mexico_City');

// Conexión a la base de datos
$db_server = '162.240.165.127';
$db_name = 'blocator_monitoreo';            
$db_user = 'blocator_rastreo';
$db_password = 'VD@12Y3v9s[==';

$conn_site = mysqli_connect($db_server, $db_user, $db_password, $db_name);
$conn_site->set_charset("utf8");

/*
$sql="REPLACE INTO Datos_GPS_Resumen (id_vehiculo, max_id)
SELECT id_vehiculo, MAX(ID) AS max_id
FROM Datos_GPS
GROUP BY id_vehiculo;";
$result=mysqli_query($conn_site,$sql);*/


$sql="REPLACE INTO Datos_GPS_Resumen (id_vehiculo, max_id)
SELECT gps.id_vehiculo, MAX(gps.ID) AS max_id
FROM Datos_GPS gps
INNER JOIN 
    Unidades_GPS_Cliente unidades
	ON gps.id_vehiculo = unidades.id_vehiculo
where unidades.autorizado = 1 
GROUP BY id_vehiculo;";
$result=mysqli_query($conn_site,$sql);





?>