Path: C:\
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
ini_set('max_execution_time',259200);
ini_set('memory_limit' , '-1' ) ;
date_default_timezone_set('America/Sao_Paulo');
$DT1=date('d-m-Y G:i:s');
$DT2=date('d-m-Y_G\hi\ms\s');
define('URL_POSITRON', 'http://mensageria-integracao.positronrt.com.br:12353');
define('USER_POSITRON', 'transwar');
define('KEY_POSITRON', 'WpH9nGyW');
define('FILA_POSITRON', 'fila_trans_war');
define('URL_OMNILINK', 'https://api.showtecnologia.com/api');
define('USER_OMNILINK', 'paulo.faria@transwar.com.br');
define('KEY_OMNILINK', '51443c94b475df141edce4c6a478c134');//Senha em hash MD5
define('URL_SIIMP', 'https://transwar.lannister.emitir.me');
define('KEY_SIIMP', '75594207-b5d7-43bf-a7c2-571b3030308d');
define('HOST_LOGITOWER', '104.237.11.226:3306');
define('NAME_LOGITOWER', 'traccar');
define('USER_LOGITOWER', 'fariapaulo');
define('KEY_LOGITOWER', 'adm2278');
define('URL_AUTOTRAC', 'https://aapi3.autotrac-online.com.br/aticapi/v1/accounts/20599/');
define('KEY_AUTOTRAC', '8ccac654f10e4cc382907134b091733a');
define('AUTHORIZATION_AUTOTRAC', 'Basic paulofaria@transwar:adm!@#$3412');
function mudaData($dt){
$dt1=str_replace('/', '-', $dt);
$dt1=str_replace('T', ' ', $dt1);
return $dt1;
}
$batt['Normal']='&batt=100';
$batt['Baixa']='&batt=20';
$batt['Sem informação']='';
$grupo['Truck']=1;
$grupo['Carretas']=2;
$grupo['Carreta']=2;
$grupo['CARRETA']=2;
$grupo['Toco']=3;
$grupo['Cavalo Mecânico']=4;
$grupo['VAN']=5;
$grupo['Utilitário']=6;
$grupo['Outros']=7;
$grupo['Não Aplicável']=8;
echo '<pre>';
require_once("includes/Request_Veiculos.php");
if(!$log){$log1='Request_Veiculos c/ERRO!!!<br>';goto z;}
$log1='Request_Veiculos OK!!!<br>';
echo count($reg_veiculo).'<br>';
print_r($reg_veiculo);
require_once("includes/Request_Veiculos_Autotrac.php");
if(!$log){$log0='Request_Veiculos_Autotrac c/ERRO!!!<br>';goto z;}
$log0='Request_Veiculos_Autotrac OK!!!<br>';
echo count($reg_veiculo).'<br>';
print_r($reg_veiculo);
require_once("includes/Conecta_BdLogiTower.php");
if(!$log){$log2='Conecta_BdLogiTower c/ERRO!!!<br>';goto z;}
$log2='Conecta_BdLogiTower OK!!!<br>';
foreach($reg_veiculo as $row3 => $col3){
$sql1 = "SELECT * FROM tc_devices where uniqueid = '$row3'";
$result1 = $conn->query($sql1);
if ($result1->num_rows == 0){
//echo 'placa: '.$row3.'<br>';
//echo 'groupid: '.$grupo[$col3['tipo']].'<br>';
//echo 'model: '.$col3['modelo'].'<br>';
//echo 'category: '.$col3['tipo'].'<br><hr>';
$sql2 = "INSERT INTO tc_devices (name, uniqueid, groupid, attributes, model, category, status) VALUES ('".$row3."','".$row3."',".$grupo[$col3['tipo']].",'{}','".$col3['modelo']."','".$col3['tipo']."','unknown')";
if (!mysqli_query($conn, $sql2)) {
$log="datetime: ".$DT1."; Erro Incluindo Veículo Placa: ".$row3."==> Erro: ".$sql2." ==> ".mysqli_error($conn);
echo $log."<br>";
}else{
$log="datetime: ".$DT1."; Incluido Veículo Placa: ".$row3;
}
$fopen = fopen('logs/veiculos.txt','a');
$fwrite = fwrite($fopen,$log.PHP_EOL);
fclose($fopen);
}
}
require_once('includes/Request_Login.php');
if(!$log){$log3='Request_Login c/ERRO!!!<br>';goto y;}
$log3='Request_Login OK!!!<br>';
/*
echo '<pre>';
print_r($reg_login);
*/
require_once('includes/Request_Grid.php');
if(!$log){$log4='Request_Grid c/ERRO!!!<br>';goto y;}
$log4='Request_Grid OK!!!<br>';
$json_grid = json_encode($reg_grid);
$fopen_grid = fopen('json/Grid.json','w');
$fwrite_grid = fwrite($fopen_grid,$json_grid);
fclose($fopen_grid);
//
echo '<pre>';
print_r($reg_grid);
//
$urls=array();
$alt=$incl=0;
foreach($reg_grid as $row4 => $col4){
$diahora=mudaData($col4['data']);
$dia_hora=strtotime($diahora);
$vel=explode(',',$col4['velocidade']);
if(intval($vel[0])>0){$nos=intval($vel[0]/1.852);}else{$nos=0;}
$lat=$col4['localizacao']['latitude'];
$lon=$col4['localizacao']['longitude'];
$deviceid=trim($col4['veiculo']['placa']);
$bat=$batt[$col4['bateriaBackup']];
$local=$col4['localizacao']['endereco'];
$urls[]='http://central.logitower.com.br:5055/?id='.$deviceid.'&lat='.$lat.'&lon='.$lon.'×tamp='.$dia_hora.'&speed='.$nos.$bat;
$sql1 = "SELECT * FROM positron where placa = '$deviceid'";
$query1 = $conn->query($sql1);
if ($query1->num_rows == 0){
$sql2 = "INSERT INTO positron (placa, dia, evento, latitude, longitude, localizacao) VALUES ('".$deviceid."', STR_TO_DATE('$diahora','%d-%m-%Y %H:%i:%s'), 99999, ".$lat.", ".$lon.", '".$local."')";
if (!mysqli_query($conn, $sql2)) {
echo "Error: " . $sql2 . "<br>" . mysqli_error($conn);
}else{$incl++;}
}else{
$sql3 = mysqli_query($conn,"UPDATE positron SET dia=STR_TO_DATE('$diahora','%d-%m-%Y %H:%i:%s'), evento=99999, latitude=".$lat.", longitude=".$lon.", localizacao='".$local."' WHERE placa = '$deviceid'");
$alt++;
}
}
$logs="datetime: ".$DT1."; Incluídas: ".$incl."; Alteradas: ".$alt;
$fopen = fopen('logs/omnilink.txt','a');
$fwrite = fwrite($fopen,$logs.PHP_EOL);
fclose($fopen);
y:
require_once("includes/Request_Positron.php");
foreach($dados_positron as $row5 => $col5){
if (intval(trim($row5))==0){
$diahora=mudaData($col5['data']);
$dia_hora=strtotime($diahora);
$vel=$col5['velocidade'];
if(intval($vel)>0){$nos=intval($vel/1.852);}else{$nos=0;}
$lat=$col5['lat'];
$lon=$col5['lng'];
$deviceid=trim($row5);
$urls[]='http://central.logitower.com.br:5055/?id='.$deviceid.'&lat='.$lat.'&lon='.$lon.'×tamp='.$dia_hora.'&speed='.$nos;
}
}
//
foreach ($urls as $i => $url) {
echo $url.'<br>';
}
//
$json_urls = json_encode($urls);
$fopen_urls = fopen('json/urls.json','w');
$fwrite_urls = fwrite($fopen_urls,$json_urls);
fclose($fopen_urls);
//echo "<script language='JavaScript'>location.href='includes/Envia_URLs.php?lg0=".$log0."&lg1=".$log1."&lg2=".$log2."&lg3=".$log3."&lg4=".$log4."';</script>";
z:
if(isset($log0)){echo $log0;}
if(isset($log1)){echo $log1;}
if(isset($log2)){echo $log2;}
if(isset($log3)){echo $log3;}
if(isset($log4)){echo $log4;}
echo '*******************************<br>';
echo '****** '.$DT1.' *******<br>';
echo '*******************************<br>';
//echo "<script language='JavaScript'>location.href='grid.php';</script>";
?>