<h2>TransWar File Browser</h2><p>Path: <b>C:\</b></p><pre>&lt;?php
date_default_timezone_set('America/Fortaleza');
$DT=date('d-m-Y G:i:s');
$inicio= date('d-m-Y');
require_once(&quot;../conexao_srvtms.php&quot;);
function horas($hora){
  list($h, $m) = explode(':', $hora);
  $segundos = 0;
  $segundos += $h * 3600;
  $segundos += $m * 60;
return $segundos;
}
$json = file_get_contents('JSON/espera-3.json');
$reg = json_decode($json, true);
$lin=count($reg);
$body='
&lt;table width=&quot;700&quot;align=&quot;left&quot; cellpadding=&quot;1&quot; cellspacing=&quot;1&quot; border=&quot;1&quot;&gt;
  &lt;tr height=&quot;30&quot; style=&quot;size=3; font-weight:bold; background:#ff0000;&quot; &gt; 
    &lt;td align=&quot;center&quot; colspan=&quot;5&quot; style=&quot;background:#ffffff;&quot;&gt;&lt;strong&gt;MOTORISTAS EM ESPERA A MAIS DE UMA HORA&lt;/strong&gt;&lt;/td&gt;
  &lt;/tr&gt; 
  &lt;tr style=&quot;size=3; font-weight:bold; color:white; background:#ff0000;&quot;&gt; 
    &lt;td align=&quot;center&quot; rowspan=&quot;2&quot; width=&quot;270&quot;&gt;&lt;strong&gt;MOTORISTA&lt;/strong&gt;&lt;/td&gt;
    &lt;td align=&quot;center&quot; rowspan=&quot;2&quot; width=&quot;80&quot;&gt;&lt;strong&gt;PLACA&lt;/strong&gt;&lt;/td&gt;
    &lt;td align=&quot;center&quot; rowspan=&quot;2&quot; width=&quot;100&quot;&gt;&lt;strong&gt;MANIFESTO&lt;/strong&gt;&lt;/td&gt;
    &lt;td align=&quot;center&quot; width=&quot;120&quot;&gt;&lt;strong&gt;CHEGADA&lt;/strong&gt;&lt;/td&gt;
    &lt;td align=&quot;center&quot; width=&quot;80&quot;&gt;&lt;strong&gt;TEMPO&lt;/strong&gt;&lt;/td&gt;
  &lt;/tr&gt; 
  &lt;tr style=&quot;size=3; font-weight:bold; color:white; background:#ff0000;&quot;&gt; 
    &lt;td align=&quot;center&quot;&gt;&lt;strong&gt;H:M:S&lt;/strong&gt;&lt;/td&gt;
    &lt;td align=&quot;center&quot;&gt;&lt;strong&gt;H:M&lt;/strong&gt;&lt;/td&gt;
  &lt;/tr&gt; 
';
foreach ($reg as $value =&gt; $x)
{ if($x['evento']=='TE' and horas($x['tempo'])&gt;=3600)
  { $sql=&quot;SELECT top 1 a.id_Manifesto as manif, max(a.dt_Saida) as dia
    FROM tbdManifesto as a
    left join tbdVeiculo as b on b.id_Veiculo = a.id_Veiculo
    where b.cd_Placa='&quot;.$x['placa'].&quot;' group by a.id_Manifesto
    order by dia DESC&quot;;
    $manifesto='';
    $result= sqlsrv_query($conn, $sql, array(), array(&quot;Scrollable&quot;=&gt;&quot;buffered&quot;));
    while ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC))
    { $manifesto=$row['manif'];}
    $nome=$value;
    $celular=$x['celular'];
    $body .='
    &lt;tr height=&quot;30&quot; style=&quot;size=3;  color:black; background:#ffffff;&quot;&gt;'; 
    if ($x['ini']=='SEM REGISTRO NESSE DIA')
    { $body .='
      &lt;td align=&quot;center&quot;colspan=&quot;5&quot;&gt;'.$x['ini'].'&lt;/td&gt;';
    }
    else
    { $body .='
      &lt;td align=&quot;center&quot;&gt;&lt;strong&gt;&amp;nbsp;&amp;nbsp;'.$nome.'&lt;/strong&gt;&lt;/td&gt;
      &lt;td align=&quot;center&quot;&gt;'.$x['placa'].'&lt;/td&gt;
      &lt;td align=&quot;center&quot;&gt;'.$manifesto.'&lt;/td&gt;
      &lt;td align=&quot;center&quot;&gt;'.$x['ini'].'&lt;/td&gt;
      &lt;td align=&quot;center&quot;&gt;&lt;strong&gt;'.$x['tempo'].'&lt;/strong&gt;&lt;/td&gt;';
    }
    $body .='
      &lt;/tr&gt; 
      ';
  }
} 
$body .='
&lt;/table&gt;';
echo 'Atualizado em: '.$DT.'&lt;br&gt;'.$body;
?&gt; </pre>