| 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/siac/cmaltosanto/admin/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: ralpb
* Date: 24/08/2017
* Time: 13:54
*/
session_start();
$_cod_usu = $_SESSION['cod_usuario'];
$_login = $_SESSION['login'];
$_idsolicitante = $_SESSION['idsolicitante'];
$solicitacao = $conn->query("select * from v_lista_solicitacao where situacao='A' order by datasolicitacao desc");
// $solicitacao_o = $conn->query("select * from v_lista_solicitacao where id_modulo='2' order by idsolicitacao");
?>
<html>
<header>
<style>
::-webkit-scrollbar {
width: 1px;
height: 1px;
}
::-webkit-scrollbar-track {
background: #2b176f;
}
::-webkit-scrollbar-thumb {
background: #2b176f;
}
.solicitante {
font-size: 13px;
color: #605ca7
}
</style>
</header>
<body onsubmit="javascript:showCarga();">
<?php //echo $a->AlertaOk('Aqui você encontra as informações sobre suas solicitações') ?>
<section class="content-header">
<h1>
SIAC
<small>Área Administrativa</small>
</h1>
</section>
<section class="content">
<!-- INFORMACOES -->
<!-- <a href='?page=relatorio/ficha_sol'><i aling='center' class='fa fa-eye' title='Visualizar Solicitações' style='font-size: 20px;'></i></a>-->
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header" style="background-color: #605CA8; !important;">
<!-- <h4 class="title" style="color: white;">NOVAS SOLICITAÇÕES</h4>-->
<p class="category">NOVAS SOLICITAÇÕES</p>
</div>
<div class="card-content table-responsive">
<table id="" class="table table-bordered table-responsive table-hover">
<thead style="font-size: 12px;">
<tr>
<th style="width: 2%;">ID</th>
<th style="width: 2%;">Módulo</th>
<th class="centro-col">Protocolo</th>
<th class="centro-col">Solicitação</th>
<th style="width: 2%;">Data</th>
<th style="width: 2%;">Situação</th>
<th style="position: center; width: 1%;"></th>
</tr>
</thead>
<tbody style="font-size: 12px;">
<?php
while ($p = $solicitacao->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo '<td class="text-center"><span style="font-size: 13px;">' . $p->idsolicitacao . "</strong></span></td>";
if ($p->modulo=='OUVIDORIA') {
echo "<td class='blocktext' style='background-color: #605ca7; align-content: center;'><strong style='font-size: 13px; color: #fafafa;'>" . $p->modulo . "</strong></td>";
} else {
echo "<td class='blocktext' style='background-color: #e88614;'><strong style='font-size: 13px; color: #fafafa;'>" . $p->modulo . "</strong></td>";
}
echo "<td class='text-center'><span>{$p->numprotocolo}</span></td>";
if ($p->idsolicitante > 0) {
echo "<td class='text-center'><span class='solicitante'><strong>" . $p->razao . '</strong><br>' . '<span>'
. $p->nome . '</span>' . '<span></span>' . ' | CPF: ' . $p->cpfcnpj . '<br>'
. $p->dddtelefone . ' ' . $p->telefone . ' | ' . $p->email . "</span></td>";
}else{
echo "<td class='text-center'><span class='solicitante'><strong>" . $p->razao
. "</strong><br><span class='text-orange'>SOLICITAÇÃO ANÔNIMA</span></td>";
}
echo "<td>" . date('d/m/Y', strtotime($p->datasolicitacao)) . "</td>";
if ($p->situacao=='R') {
echo "<td style='color: #0fc473'><strong>RESPONDIDA</strong></td>";
}
if ($p->situacao=='A') {
echo "<td style='color: #e7a34f'><strong>ABERTA</strong></td>";
}
if ($p->situacao=='T') {
echo "<td style='color: #2d84d2'><strong>TRAMITANDO</strong></td>";
}
if ($p->situacao=='N') {
echo "<td style='color: #d4334b'><strong>NEGADO</strong></td>";
}
if ($p->situacao=='L') {
echo "<td style='color: #b73ad3'><strong>LIDA</strong></td>";
}
if ($p->situacao=='P') {
echo "<td style='color: #cbad1c'><strong>PRORROGADO</strong></td>";
}
$idsolicitacao = $p->idsolicitacao;
$idsolicitante = $p->idsolicitante;
echo "<td class='text-center'><a href='?page=solicitacao/solicitacao_e&idsolicitacao=$idsolicitacao&idsolicitante=$idsolicitante&var=lido' class='botao_editar'><i aling='center' class='fa fa-eye' title='Visualizar Solicitações' style='font-size: 20px;'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<!--TODAS AS SOLICITAÇÕES-->
<div class="card">
<div class="card-header" style="background-color: #605CA8; !important;">
<h4 class="title" style="color: #161616;"></h4>
<p class="category">TODAS AS SOLICITAÇÕES</p>
</div>
<div class="card-content table-responsive">
<table id="impressao" class="table table-bordered table-responsive table-hover">
<thead style="font-size: 12px;">
<tr>
<th style="width: 2%;">ID</th>
<th style="width: 2%;">Módulo</th>
<th class="centro-col">Protocolo</th>
<th class="centro-col">Solicitação</th>
<th style="width: 2%;">Data</th>
<th style="width: 2%;">Situação</th>
<th style="position: center; width: 1%;"></th>
</tr>
</thead>
<tbody style="font-size: 12px;">
<?php
$solicia = $conn->query("select * from v_lista_solicitacao where situacao<>'A' order by datasolicitacao desc");
while ($p = $solicia->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo '<td class="text-center"><span style="font-size: 13px;">' . $p->idsolicitacao . "</strong></span></td>";
if ($p->modulo=='OUVIDORIA') {
echo "<td class='blocktext' style='background-color: #605ca7; align-content: center;'><strong style='font-size: 13px; color: #fafafa;'>" . $p->modulo . "</strong></td>";
} else {
echo "<td class='blocktext' style='background-color: #e88614;'><strong style='font-size: 13px; color: #fafafa;'>" . $p->modulo . "</strong></td>";
}
echo "<td class='text-center'><span>{$p->numprotocolo}</span></td>";
if ($p->sol_solicitacao > 0) {
echo "<td class='text-center'><span class='solicitante'><strong>" . $p->razao . '</strong><br>' . '<span>'
. $p->nome . '</span>' . '<span></span>' . ' | CPF: ' . $p->cpfcnpj . '<br>'
. $p->dddtelefone . ' ' . $p->telefone . ' | ' . $p->email . "</span></td>";
}else{
echo "<td class='text-center'><span class='solicitante'><strong>" . $p->razao
. "</strong><br><span class='text-orange'>SOLICITAÇÃO ANÔNIMA</span></td>";
}
echo "<td>" . date('d/m/Y', strtotime($p->datasolicitacao)) . "</td>";
if ($p->situacao=='R') {
echo "<td style='color: #0fc473'><strong>RESPONDIDA</strong></td>";
}
if ($p->situacao=='A') {
echo "<td style='color: #e7a34f'><strong>ABERTA</strong></td>";
}
if ($p->situacao=='T') {
echo "<td style='color: #2d84d2'><strong>TRAMITANDO</strong></td>";
}
if ($p->situacao=='N') {
echo "<td style='color: #d4334b'><strong>NEGADO</strong></td>";
}
if ($p->situacao=='L') {
echo "<td style='color: #b73ad3'><strong>LIDA</strong></td>";
}
if ($p->situacao=='P') {
echo "<td style='color: #cbad1c'><strong>PRORROGADO</strong></td>";
}
$idsolicitacao = $p->idsolicitacao;
$idsolicitante = $p->idsolicitante;
echo "<td class='text-center'><a href='?page=solicitacao/solicitacao_e&idsolicitacao=$idsolicitacao&idsolicitante=$idsolicitante&var=lido' class='botao_editar'><i aling='center' class='fa fa-eye' title='Visualizar Solicitações' style='font-size: 20px;'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- <div class="container">-->
<!-- <h5 class="pull-right" style="color: #493077; padding-right: 3%;">Plataforma tecnológica --><?php //echo $cfg->nomeremetenteemail ?><!--</h5>-->
<!-- </div>-->
</div>
<!-- END GRAFICO -->
</section>
<!--<script>-->
<!-- $(document).ready(function () {-->
<!-- $('#summernote').summernote();-->
<!-- });-->
<!--</script>-->
</body>
</html>