Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement