TransWar File Browser

Path: C:\

<?php
  ini_set('max_execution_time',259200); 
  ini_set ( 'memory_limit' , '4095M' ) ;
  date_default_timezone_set('America/Sao_Paulo');
  $reg_autotrac=$dados_autotrac=array();
      echo '<pre>';
  foreach($autotrac as $plc => $code){
    echo "<script>console.log('numero da placa ➔".$plc."código ➔".$code."');</script>";
    
    $url_autotrac = URL_AUTOTRAC."vehicles/".$code."/positions?_limit=1";
    $curl_autotrac = curl_init($url_autotrac);
    curl_setopt($curl_autotrac, CURLOPT_URL, $url_autotrac);
    curl_setopt($curl_autotrac, CURLOPT_RETURNTRANSFER, true);
    $headers_autotrac = array(
       "accept: application/json",
       "Ocp-Apim-Subscription-Key: ".KEY_AUTOTRAC,
       "Authorization: ".AUTHORIZATION_AUTOTRAC,
    );
    curl_setopt($curl_autotrac, CURLOPT_HTTPHEADER, $headers_autotrac);
    curl_setopt($curl_autotrac, CURLOPT_SSL_VERIFYHOST, false);
    curl_setopt($curl_autotrac, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($curl_autotrac, CURLOPT_HEADER, 1);
    $resp_autotrac = curl_exec($curl_autotrac);
    $info_autotrac = curl_getinfo($curl_autotrac, CURLINFO_HTTP_CODE);
    curl_close($curl_autotrac);
    if($info_autotrac==200){
      $out = preg_split('/(\r?\n){2}/', $resp_autotrac, 2);
      $headers = $out[0];
      $headersArray = preg_split('/\r?\n/', $headers);
      $headersArray = array_map(function($h) {
        return preg_split('/:\s{1,}/', $h, 2);
      }, $headersArray);
      $tmp = [];
      foreach($headersArray as $h) {
        $tmp[strtolower($h[0])] = isset($h[1]) ? $h[1] : $h[0];
      }
      $headersArray = $tmp; $tmp = null;
      $body['headers']=$headersArray;
      $body['body']=json_decode($out[1], true);
      if(count($body['body']['Data'])==0){
        echo "Placa: ".$plc." sem posição!<br>";
        echo "<script>console.log('Placa ➔ ".$plc." SEM posição!');</script>";
      }else{
        $dados_autotrac[$plc]=$body['body']['Data'][0];
        $reg_autotrac[$plc]=$body['body']['Data'][0];
        echo "<script>console.log('Placa ➔ ".$plc." COM posição!');</script>";
        $placa=$plc;
        $diahora=inverteDt($reg_autotrac[$plc]['PositionTime']);
        $evento=intval('99999');
        $lat=floatval($reg_autotrac[$plc]['Latitude']);
        $long=floatval($reg_autotrac[$plc]['Longitude']);
        $local=$reg_autotrac[$plc]['Landmark'];

        $sql1 = "SELECT * FROM positron where placa = '$plc'";
        $query1 = $conn->query($sql1);
        if ($query1->num_rows == 0){ 
          $sql2 = "INSERT INTO positron (placa, dia, evento, latitude, longitude, localizacao) VALUES ('".$placa."', STR_TO_DATE('$diahora','%d-%m-%Y %H:%i:%s'),".$evento.", ".$lat.", ".$long.", '".$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=".$evento.", latitude=".$lat.", longitude=".$long.", localizacao='".$local."' WHERE placa = '$plc'");
          $alt++;
        }
        $logs="datetime: ".$DT1."; Incluídas: ".$incl."; Alteradas: ".$alt;
      }
    }else{
      $logs="datetime: ".$DT1."; Fim SEM ocorrências!";
    }
  }
?>