TransWar File Browser

Path: C:\

<?php
date_default_timezone_set('America/Fortaleza');
if (isset($_GET['arquivo'])) {
  $arqxlsx = $_GET['arquivo'];
}
else {
  $arqxlsx = 'teste';
}
$host = "192.168.0.201";

$db = "dtbtransporte";
$user = "bi";
$password = "BI@Consult@";

$connectionOptions = array("Database" => $db, "UID" => $user, "PWD" => $password, "CharacterSet" => "UTF-8");
$conn = sqlsrv_connect($host, $connectionOptions);
if (!$conn) {
  $body = $body . "ATENÇÃO!! FALHA NA CONEXÃO BANCO DE DADOS!<br /";
}
$query9 = "SELECT id_Dest
  ,Email  
  ,Alerta
  ,convert(varchar(10),Ultimo,103) as Ultimo
  FROM tbdDestEmail
  ORDER BY Nome ASC";
$consulta = sqlsrv_query($conn, $query9, array(), array("Scrollable" => "buffered"));
$num = sqlsrv_num_rows($consulta);
$z = 0;
if ($num > 0) 
{
  while ($rows = sqlsrv_fetch_array($consulta, SQLSRV_FETCH_ASSOC)) {
    if ($rows["Alerta"] == '3') {
      $z++;
      $id[$z] = $rows["id_Dest"];
      $dest[$z] = trim($rows["Email"]);
    }
  }
}

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->Port = 587;
$mail->FromName = 'Transwar';
$mail->From = 'agbeenvioautomatico@gmail.com';
foreach ($dest as $para) {
  $mail->AddAddress($para, '');
}
$mail->CharSet = 'utf-8';
$mail->isHTML(true);
$mail->setLanguage('pt_br', 'vendor/phpmailer/phpmailer/language');
$mail->Subject = 'Resumo Brainfarma';
$mail->Body = 'Att. Responsável Operação Brainfarma.</br></br>Resumo das agendas em aberto, do período de armazenagem e Horas Paradas.</br></br>
    Atenciosamente,</br></br>';

$mail->addAttachment($arqxlsx);


if (!$mail->Send()) 
{
  echo "Erro: " . $mail->ErrorInfo;
}
else 
{
  $hoje = date("Y-m-d G:i");
  $altera = sqlsrv_query($conn, "UPDATE tbdDestEmail SET 
    Ultimo      = '" . $hoje . "'
  WHERE Alerta='3'");
}
echo "<script language='JavaScript'>location.href='index.php';</script>";
?>