TransWar File Browser

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;
  }
  function inverteDt($e){
    $edt = date('d-m-Y H:i:s', strtotime($e));
    return $edt;
  }
  $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>';

  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.'&timestamp='.$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.'&timestamp='.$dia_hora.'&speed='.$nos;
    }
  }
  require_once("includes/Request_Autotrac.php");
  foreach($dados_autotrac as $row5 => $col5){
    $dia_hora=strtotime($col5['PositionTime']);
    $vel=$col5['Velocity'];
    if(intval($vel)>0){$nos=intval($vel/1.852);}else{$nos=0;}
    $lat=$col5['Latitude'];
    $lon=$col5['Longitude'];
    $deviceid=$row5;
    echo "<script>console.log('Nº device ➔".$deviceid."');</script>";
    $urls[]='http://central.logitower.com.br:5055/?id='.$deviceid.'&lat='.$lat.'&lon='.$lon.'&timestamp='.$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:
  echo $log0;
  echo $log1;
  echo $log2;
  echo $log3;
  echo $log4;
  echo '*******************************<br>'; 
  echo '****** '.$DT1.' *******<br>'; 
  echo '*******************************<br>'; 
  echo "<script language='JavaScript'>location.href='grid.php';</script>";
?>