Untitled

<?php
//metodo usado a partir do PHP 5.1.2
$sql = "SELECT *
  FROM (SELECT P.PES_NUMERO AS MATRICULA,
               P.PES_NOME AS NOME,
               DECODE(P.PESSIT_NUMERO, 9, 'DEMITIDO', 8, 'ADMITIDO') AS SITUACAO,
               C.ADMISSAO AS ADMISSAO,
               C.RESCISAO AS RESCISAO,
               (SELECT MAX(CP.CRED_NUMERO)
                  FROM DEFAULT_ACESSO.CRED_PESSOAS CP
                 WHERE CP.PES_NUMERO = P.PES_NUMERO
                   AND SUBSTR(CP.CRED_NUMERO, 1, 1) = '1') AS CREDENCIAL
          FROM DEFAULT_ACESSO.PESSOAS P, FOLHA.COLABORADORESADM C
         WHERE P.PES_NUMERO = C.MATRICULA
           AND C.ID_EMPRESAS = 1
           AND C.ID_NEGOCIOS = 1
           AND C.RESCISAO >= trunc(sysdate - 1)) A
 ORDER BY A.SITUACAO, A.MATRICULA";

$sql2 = "SELECT *
  FROM (
        SELECT A.MATRICULA
          FROM (SELECT P.PES_NUMERO AS MATRICULA,
                        P.PES_NOME AS NOME,
                        DECODE(P.PESSIT_NUMERO, 9, 'DEMITIDO', 8, 'ADMITIDO') AS SITUACAO,
                        C.ADMISSAO AS ADMISSAO,
                        C.RESCISAO AS RESCISAO,
                        (SELECT MAX(CP.CRED_NUMERO)
                           FROM DEFAULT_ACESSO.CRED_PESSOAS CP
                          WHERE CP.PES_NUMERO = P.PES_NUMERO
                            AND SUBSTR(CP.CRED_NUMERO, 1, 1) = '1') AS CREDENCIAL
                   FROM DEFAULT_ACESSO.PESSOAS P, FOLHA.COLABORADORESADM C
                  WHERE P.PES_NUMERO = C.MATRICULA
                    AND C.ID_EMPRESAS = 1
                    AND C.ID_NEGOCIOS = 1
                    AND P.PES_PIS IS NOT NULL
                    AND (C.ADMISSAO >= trunc(sysdate - 1))) A)
UNION

 (
  SELECT CP.PES_NUMERO MATRICULA
    FROM DEFAULT_ACESSO.CRED_PESSOAS CP
   WHERE TRUNC(CP.CRPES_DATAENTRADA) >= trunc(sysdate - 1)
     AND SUBSTR(CP.CRED_NUMERO, 1, 1) = '1'
     AND CP.CRPES_DATAENTRADA =
         (SELECT MAX(CR.CRPES_DATAENTRADA)
            FROM DEFAULT_ACESSO.CRED_PESSOAS CR
           WHERE CR.PES_NUMERO = CP.PES_NUMERO)
     AND CP.CRED_NUMERO NOT LIKE '100%')
UNION

 (
  SELECT DISTINCT TT.PES_NUMERO_OLD MATRICULA
    FROM DEFAULT_ACESSO.LOG_TEMPLATE_PESSOA TT
   WHERE TT.TPL_TEMPLATE_OLD = TT.TPL_TEMPLATE_NEW
     AND TRUNC(TT.DATA_ATU) >= trunc(sysdate - 1))";

echo "<html>
<head>
    <meta http-equiv='content-type' content='text/html; charset=utf-8' />
    <title>Atualizar relógios</title>

    <link rel='stylesheet' type='text/css' href='sources/css/jquery-ui.css'>
    <link rel='stylesheet' type='text/css' href='sources/css/dataTables.jqueryui.css'>
    <script type='text/javascript' language='javascript' src='sources/js/jquery-1.10.2.min.js'></script>
    <script type='text/javascript' language='javascript' src='sources/js/jquery.dataTables.min.js'></script>
    <script type='text/javascript' language='javascript' src='sources/js/dataTables.jqueryui.js'></script>
    <script type='text/javascript' charset='utf-8'>
      $(document).ready(function() {
        $('#example').dataTable();
      } );
      $(document).ready(function() {
        $('#example2').dataTable();
      } );
    </script>
</head>";

echo "<body>";
echo "<div align='center'>";
echo "<img src='http://srv-cpf/assets/images/03_logo1.png'>";
echo "<h2><font color=#00b38b> Atualização diária do relógios UAM</font></h2>";
echo "</div>";
echo "<div class='container'>";

$conn = oci_connect('xxx', 'xxx', '172.16.20.61/DBUAM');
$dados = oci_parse($conn, $sql);
if (oci_execute($dados, OCI_DEFAULT)){
  echo "<table cellpadding='0' cellspacing='0' border='0' class='display' id='example'>";
  echo "<thead>";
  echo "<th>Colaboradores demitidos</th>";
  echo "</thead>";
  echo "<tbody>";
  echo "<tr class='even gradeA'>";
  while (oci_fetch($dados)){
  echo "<td>";
  echo oci_result($dados, "MATRICULA");
  echo "</td>";
  echo "</tr>";
  }
  echo "</tbody>";
  echo "</table>";
  oci_close($conn);
}else{
  echo "Nenhum dado";
};

echo "<br>";

$conn1 = oci_connect('xxx', 'xxx', '172.16.20.61/DBUAM');
$dados2 = oci_parse($conn1, $sql2);
if (oci_execute($dados2, OCI_DEFAULT)){
  echo "<table cellpadding='0' cellspacing='0' border='0' class='display' id='example2'>";
  echo "<thead>";
  echo "<th>Colaboradores admitidos ou alteração de crachá</th>";
  echo "</thead>";
  echo "<tbody>";
  echo "<tr class='even gradA'>";
  while (oci_fetch($dados2)){
  echo "<td>";
  echo oci_result($dados2, "MATRICULA");
  echo "</td>";
  echo "</tr>";
  }
  echo "</tbody>";
  echo "</table>";
}else{
  echo "Nenhum dado";
};

echo "</div>";
echo "</body>";
echo "</html>";
oci_close($conn1);
?>