TransWar File Browser

Path: C:\

<?php
ini_set('max_execution_time', 14400);
date_default_timezone_set('America/Sao_Paulo');

$base1 = date("d-m-Y");
$DT = date('Y-m-d_G\hi\m');
$arq = 'Sensorweb-' . $DT . '.json';
$data1 = date("d/m/Y  --  H:i");
echo 'Iniciado em: ' . $data1 . '<br>';

$point = "https://clientes.sensorweb.com.br/transwar/api/point/historicalvalues?";

require_once("conexao_mysql.php");

$it = 0;
$iu = 0;

$sql = "SELECT * FROM veiculos order by id_veic";
$query = $conn->query($sql);

if ($query->num_rows > 0) {
  while ($row = $query->fetch_assoc()) {

    $id_veic = $row['id_veic'];
    $id_temp = "xid=" . $row['id_temp'];
    $id_umid = "xid=" . $row['id_umid'];
    $temp = array();
    $url = $point . $id_temp;

    $curl = curl_init($url);
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);

    $headers = array(
      "Authorization: Basic dHJhbnN3YXI6VHJhbnN3YXIxMjM=",
    );

    curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
    //for debug only!
    curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
    $resp = curl_exec($curl);
    curl_close($curl);

    $temp = json_decode($resp, true);

    $umid = array();
    $url = $point . $id_umid;
    $curl = curl_init($url);
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);

    $headers = array(
      "Authorization: Basic dHJhbnN3YXI6VHJhbnN3YXIxMjM=",
    );

    curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
    //for debug only!
    curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);
    curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
    $resp = curl_exec($curl);

    curl_close($curl);

    $umid = json_decode($resp, true);

    if (isset($temp['values'])) {
      foreach ($temp['values'] as $mov => $x) {
        $data = $x['ts'] / 1000;
        $it++;
        $reg[$id_veic][$data]['temp'] = $x['value'];
      }
    }

    if (isset($umid['values'])) {
      foreach ($umid['values'] as $mov => $x) {
        $data = $x['ts'] / 1000;
        $iu++;
        $reg[$id_veic][$data]['umid'] = $x['value'];
      }
    }

  }

  $json = json_encode($reg);

  $fopen = fopen('arquivos/' . $arq, 'w');
  $fwrite = fwrite($fopen, $json);
  fclose($fopen);
}
$data2 = date("d/m/Y  --  H:i");
echo 'Finalizado em: ' . $data2 . '<br>';
echo 'Temperaturas Incluidas: ' . $it . '<br>';
echo 'Umidades Incluidas: ' . $iu . '<br>';
$dest[1] = 'paulo.faria@transwar.com.br';
//$dest[2] = 'amanda.matos@transwar.com.br';
$corpo = '
  <tr>
    <td align="center"><strong>ATENÇÃO QUALIDADE e TI!</strong></td>
  </tr>
  <tr>
    <td>Gravação das leituras de <strong>Temperatura e Umidade</strong> através</td>
  </tr>
  <tr>
    <td>da API Sensorweb nas últimas <strong>24 horas</strong>.</td>
  </tr>
  <tr>
    <td>Iniciada em: <strong>' . $data1 . '</strong>.</td>
  </tr>
  <tr>
    <td>Finalizada em: <strong>' . $data2 . '</strong>.</td>
  </tr>
  <tr>
    <td>Temperaturas Incluídas: <strong>' . $it . '</strong>.</td>
  </tr>
  <tr>
    <td>Umidades Incluídas: <strong>' . $iu . '</strong>.</td>
  </tr>
  ';
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;

require '../vendor/autoload.php';
$mail = new PHPMailer(true);
$mail->isSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->SMTPAuth = true;
$mail->Username = 'agbeenvioautomatico@gmail.com';
$mail->Password = 'iwhvpzfddcwunqsz';
$mail->SMTPSecure = 'tls';
$mail->Port = 587;
$mail->setFrom('agbeenvioautomatico@gmail.com', 'Transwar');
foreach ($dest as $para) {
  $mail->AddAddress($para, '');
}
$mail->CharSet = 'utf-8';
$mail->isHTML(true);
$mail->setLanguage('pt_br', 'vendor/phpmailer/phpmailer/language');
$mail->Subject = 'API Sensorweb';
$mail->Body = '</br><table style="border-style: groove;font-size: 12px">
      ' . $corpo . '</table></br><b>Esse email foi enviado automaticamente pelo sistema, não é necessário respondê-lo.</b>';
if (!$mail->Send()) {
  echo "Erro: " . $mail->ErrorInfo;
}
echo "<script type='text/javascript'>window.open('sensorweb03.php?arq=" . $arq . "', '_blank');</script>";
?>