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' ) ;
$data2=$data2." 23:59:59";
$cpf1='999999'; $term1='999999';$dia1='9999/99/99';
$json = file_get_contents('JSON/espera-1.json');
$reg = json_decode($json, true);
$reg2=array();
foreach ($reg as $value => $z)
{ $cpf2=$value;
  $reg2[$cpf2]['nome']=$z['nome']; 
  $reg2[$cpf2]['celular']=$z['celular'];
  if(isset($z['dia']))
  { foreach ($z['dia'] as $val => $x)
    { $term2=$x['term'];
      $horainicio=$val;
      $horafim=$x['fim'];
      $dia=Dia105(substr($horainicio, 0, 10));
      echo ("<script>console.log('".$cpf2."-->".$term2."-->".$horainicio."-->".$data2."-->".$dia."');</script>");
      $sql1= "SELECT distinct ltrim(rtrim(a.Texto)) as texto
      ,a.IDTerminal
      ,Convert(varchar(8), a.DataHoraEm,108) as hora
      ,Convert(varchar(10), a.DataHoraEm,120) as ordem
      ,Convert(varchar(19), a.DataHoraEm,120) as classifica
      ,ltrim(rtrim(SUBSTRING(b.cpf,1,6))) as cpf
      ,CASE
        WHEN a.idMacro IS NULL THEN 
          CASE  
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='40' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='41' THEN '36'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='50' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='51' THEN '37'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='0'  THEN '42'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='11' THEN '43'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='12' THEN '44'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='06' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='60' 
              or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='61' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='62' THEN '38'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='07' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='70' 
              or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='71' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='72' THEN '39'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='08' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='80' 
              or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='82' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='8_' 
              or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='8'  THEN '40'
            WHEN ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='09' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='90' 
              or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='91' or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='92' 
              or ltrim(rtrim(SUBSTRING(a.Texto,1,2)))='93' THEN '41'
          END 
        ELSE
          CASE a.idMacro
            WHEN '45' THEN '32'
            WHEN '46' THEN '33'
            WHEN '47' THEN '34'
            WHEN '48' THEN '35'
            WHEN '49' THEN '36'
            WHEN '50' THEN '37'
            WHEN '51' THEN '38'
            WHEN '52' THEN '39'
            WHEN '53' THEN '40'
            WHEN '54' THEN '41'
            WHEN '55' THEN '42'
            WHEN '56' THEN '43'
            WHEN '57' THEN '44'
          ELSE a.idMacro END
        END AS macro
        ,c.Placas as placa
      FROM tMacroRec a 
        LEFT JOIN  dbOmnilink.dbo.tVeiculo c ON a.IDTerminal = c.IdTerminal
        LEFT JOIN  Auxiliar.dbo.tMotoristas b ON ltrim(rtrim(SUBSTRING(a.Texto,1,6))) = ltrim(rtrim(SUBSTRING(b.cpf,1,6)))
      WHERE (Convert(varchar(19), a.DataHoraEm,120) BETWEEN '$horainicio' and '$horafim') AND a.IDTerminal = '$term2'
      ORDER BY  classifica";
      $consulta1= sqlsrv_query($conn, $sql1, array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
      if (!$consulta1){echo "ATENÇÃO!! FALHA NA CONSULTA 2.";}
      while ($row1 = sqlsrv_fetch_array($consulta1, SQLSRV_FETCH_ASSOC)) 
      { $dia=Dia105($row1['ordem']);
        //echo ("<script>console.log('".$dia."');</script>");
        if  ($row1['macro']!==null) { 
          if ($row1['cpf']!=''){$cpf3=$row1['cpf']; if ($cpf3!=$cpf2){ $cpf1=$cpf2; $term1=$term2; $dia1=$dia;CONTINUE 2;}}
          $reg2[$cpf2]['dia'][$row1['ordem']][$row1['hora']]['macro']=$row1['macro']; 
          $reg2[$cpf2]['dia'][$row1['ordem']][$row1['hora']]['placa']=$row1['placa']; }
        if($row1['macro']===35 or $row1['macro']===44){CONTINUE 2;}
      }  
    }
  }$cpf1=$cpf2; $term1=$term2; $dia1=$dia;
}
if(isset($z['dia']))
{ ksort($reg2);
  foreach ($reg2 as $key => $value) {
    ksort($reg2[$key]['dia']);
    foreach ($reg2[$key]['dia'] as $key2 => $value2) {
      ksort($reg2[$key]['dia'][$key2]);
    }
  }
}
foreach ($reg2 as $value => $z)
{ $cpf=$value;
  $espera2[$cpf]['nome']=$z['nome'];
  $espera2[$cpf]['celular']=$z['celular'];
  if(isset($z['dia']))
  { foreach ($z['dia'] as $val => $x)
    { $dia=Dia105($val);
      foreach ($x as $hora => $y)
      {	$espera2[$cpf][$dia][$hora]=$y['macro'];  
        $espera2[$cpf]['placa']=$y['placa'];
      }  
    }
  }
}
$json2=json_encode($espera2);
$fopen2=fopen('JSON/espera-2.json','w');
$fwrite2=fwrite($fopen2,$json2);
fclose($fopen2);
?>