| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/protocolo/dev/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: ralpb
* Date: 24/08/2017
* Time: 13:54
*/
// if ($_usu_centralizador==1) {
// $pendente = $conn->query("select * from v_lista_protocolo WHERE cod_status=1 ORDER BY cod_protocolo DESC");
// $pen = $pendente->rowCount();
// $andamento = $conn->query("select * from v_lista_protocolo WHERE cod_status=2 ORDER BY cod_protocolo DESC");
// $and = $andamento->rowCount();
// $concluida = $conn->query("select * from v_lista_protocolo WHERE cod_status=4 ORDER BY cod_protocolo DESC");
// $con = $concluida->rowCount();
// $cancelado = $conn->query("select * from v_lista_protocolo WHERE cod_status=5 ORDER BY cod_protocolo DESC");
// $can = $cancelado->rowCount();
// } else {
$pendente = $conn->query("select * from v_lista_protocolo WHERE cod_status=1 and cod_usuario=$_cod_usuario ORDER BY cod_protocolo DESC");
$pen = $pendente->rowCount();
$andamento = $conn->query("select * from v_lista_protocolo WHERE cod_status=2 and cod_usuario=$_cod_usuario ORDER BY cod_protocolo DESC");
$and = $andamento->rowCount();
$concluida = $conn->query("select * from v_lista_protocolo WHERE cod_status=4 and cod_usuario=$_cod_usuario ORDER BY cod_protocolo DESC");
$con = $concluida->rowCount();
$cancelado = $conn->query("select * from v_lista_protocolo WHERE cod_status=5 and cod_usuario=$_cod_usuario ORDER BY cod_protocolo DESC");
$can = $cancelado->rowCount();
$encaminha = $conn->query("select * from v_lista_protocolo_encaminhado WHERE lido='S' AND cod_usuario_destino=$_cod_usuario ORDER BY cod_protocolo DESC limit 3");
$enc = $encaminha->rowCount();
// }
// if ($_usu_centralizador==1) {
$pendente_l = $conn->query("select * from v_lista_protocolo WHERE cod_status=1 and cod_usuario=$_cod_usuario ORDER BY cod_protocolo DESC LIMIT 3");
$andamento_l = $conn->query("select * from v_lista_protocolo WHERE cod_status=2 and cod_usuario=$_cod_usuario ORDER BY cod_protocolo DESC LIMIT 3");
$andamento_e = $conn->query("select * from v_lista_protocolo_encaminhado WHERE lido='S' AND cod_usuario_destino=$_cod_usuario ORDER BY cod_protocolo DESC limit 3");
// } else {
// $pendente_l = $conn->query("select * from v_lista_protocolo_encaminhado WHERE cod_status=1 and lido='S' and cod_usuario_destino=$_cod_usuario ORDER BY cod_protocolo DESC LIMIT 4");
// $andamento_l = $conn->query("select * from v_lista_protocolo_encaminhado WHERE cod_status=2 and lido='S' and cod_usuario_destino=$_cod_usuario ORDER BY cod_protocolo DESC LIMIT 4");
// }
$pendente2 = $conn->query("select * from v_lista_protocolo_encaminhado WHERE lido='N' AND cod_usuario_destino=$_cod_usuario ORDER BY cod_protocolo DESC");
$caixa = $pendente2->rowCount();
if ($caixa > 0) {
$a->AlertaErro('ATENÇÃO! VOCÊ TEM <strong style="color: yellow; font-size: 20px;">' . $caixa . '</strong> MENSAGENS EM SUA CAIXA DE ENTRADA!');
}
?>
<html>
<header>
</header>
<body onsubmit="javascript:showCarga();">
<section class="content-header">
<h1>
Protocolo
<small>Painel de controle</small>
<a href='#' class="text-center" style="font-size: 23px;" onclick="startIntro();" title="mostrar dicas"><i class="fa fa-question text-gray"></i></a>
</h1>
<ol class="breadcrumb" id="d_da_inicio">
<li><i class="fa fa-dashboard"></i> Início</li>
<li class="active">Informações</li>
</ol>
</section>
<section class="content">
<div class="row">
<div class="col-lg-3 col-md-6 col-sm-6" id="d_pendentes">
<div class="card card-stats">
<div class="card-header" data-background-color="blue" style="width: 85px; height: 85px;">
<i class="fa fa-hourglass-half"></i></span>
</div>
<div class="card-content">
<i class="category">Pendentes</i>
<h3 class="title"><?php echo $pen ?></h3>
</div>
</div>
</div>
<div class="col-lg-2 col-md-6 col-sm-6" id="d_encaminha">
<div class="card card-stats">
<div class="card-header" data-background-color="orange" style="width: 85px; height: 85px;">
<i class="fa fa-star-half-o"></i>
</div>
<div class="card-content">
<p class="category">Andamento</p>
<h3 class="title"><?php echo $and ?></h3>
</div>
</div>
</div>
<div class="col-lg-2 col-md-6 col-sm-6" id="d_andamento">
<div class="card card-stats">
<div class="card-header" data-background-color="blue-light" style="width: 85px; height: 85px;">
<i class="fa fa-cloud-upload"></i>
</div>
<div class="card-content">
<p class="category">Encaminhado</p>
<h3 class="title"><?php echo $enc ?></h3>
</div>
</div>
</div>
<div class="col-lg-2 col-md-6 col-sm-6" id="d_concluido">
<div class="card card-stats">
<div class="card-header" data-background-color="green" style="width: 85px; height: 85px;">
<i class="fa fa-thumbs-o-up"></i>
</div>
<div class="card-content">
<p class="category">Concluídos</p>
<h3 class="title"><?php echo $con ?></h3>
</div>
</div>
</div>
<div class="col-lg-3 col-md-6 col-sm-6" id="d_cancelado">
<div class="card card-stats">
<div class="card-header" data-background-color="red" style="width: 85px; height: 85px;">
<i class="fa fa-ban"></i>
</div>
<div class="card-content">
<p class="category">Cancelados</p>
<h3 class="title"><?php echo $can ?></h3>
</div>
</div>
</div>
</div>
<!-- INFORMACOES -->
<div class="row">
<!--LISTA PROTOCOLOS CONCLUIDOS-->
<div class="col-lg-4 col-md-4">
<div class="card" style="height: 255px;">
<div class="card-header" data-background-color="blue" id="d_l_pendentes">
<h4 class="title">Pendentes</h4>
<p class="category">Aguardando execução</p>
</div>
<div class="card-content table-responsive">
<table class="table table-hover table-responsive" style="font-size: 12px;">
<thead class="text-warning">
<th>Protocolo</th>
<th>Data/Hora</th>
<th></th>
</thead>
<tbody>
<?php
while ($pl = $pendente_l->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $pl->cod_protocolo . "</td>";
echo "<td>" . date('d/m/Y H:i:s', strtotime($pl->data_cadastro)) . "</td>";
$id = $pl->cod_protocolo;
echo "<td><a href='?page=protocolo/protocolo_e&id=$id' class='botao_editar'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
<!--LISTA PROTOCOLOS ANDAMENTO-->
<div class="col-lg-4 col-md-4">
<div class="card" style="height: 255px;">
<div class="card-header" data-background-color="orange" id="d_l_andamento">
<h4 class="title">Andamento</h4>
<p class="category">Protocolos em andamento</p>
</div>
<div class="card-content table-responsive">
<table class="table table-hover table-responsive" style="font-size: 12px;">
<thead class="text-warning">
<th>Protocolo</th>
<th>Data/Hora</th>
<th></th>
</thead>
<tbody>
<?php
while ($al = $andamento_l->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $al->cod_protocolo . "</td>";
echo "<td>" . date('d/m/Y H:i:s', strtotime($al->data_cadastro)) . "</td>";
$id = $al->cod_protocolo;
echo "<td><a href='?page=protocolo/protocolo_e&id=$id' class='botao_editar'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</tbody>
</table>
</div>
</div>
</div>
<!--LISTA PROTOCOLOS ENCAMINHADOS-->
<div class="col-lg-4 col-md-4">
<div class="card" style="height: 255px;">
<div class="card-header" data-background-color="blue-light" id="d_l_andamento">
<h4 class="title">Encaminhados</h4>
<p class="category">Protocolos Encaminhados</p>
</div>
<div class="card-content table-responsive">
<table class="table table-hover table-responsive" style="font-size: 12px;">
<thead class="text-warning">
<th>Protocolo</th>
<th>Data/Hora</th>
<th></th>
</thead>
<tbody>
<?php
while ($ae = $andamento_e->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $ae->cod_protocolo . "</td>";
echo "<td>" . date('d/m/Y H:i:s', strtotime($ae->data_cadastro)) . "</td>";
$id = $ae->cod_protocolo;
echo "<td><a href='?page=protocolo/protocolo_e&id=$id' class='botao_editar'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- END GRAFICO -->
<!-- SUPORTE -->
<!-- <section class="hidden-sm hidden-md hidden-lg">-->
<!-- <h4>Suporte</h4>-->
<!-- <div>-->
<!-- <label>Ralp Alves Bezerra</label>-->
<!-- </div>-->
<!-- <div>-->
<!-- <label>E-Mail</label>-->
<!-- <a href="mailto:tnssolucoes@gmail.com">tnssolucoes@gmail.com</a>-->
<!-- </div>-->
<!-- <div>-->
<!-- <label>TIM/Wapp:</label>-->
<!-- <a href="tel:85997790150">(85) 9.9779-0150</a>-->
<!-- </div>-->
<!-- <div>-->
<!-- <label>Claro:</label>-->
<!-- <a href="tel:85994447024">(85) 9.9444-7024</a>-->
<!-- </div>-->
<!-- </section>-->
<!-- END SUPORTE -->
</section>
<script>
$(document).ready(function () {
$('#summernote').summernote();
});
</script>
</body>
</html>