| 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/juridico/horizonte/modulos/solicitacao/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 12/04/2016
* Time: 08:09
*/
session_start("3b71c625dfc95ca336cac7f27b3c2b0b");
//ini_set('display_errors', 'off');
//$direito = $_SESSION['admin'];
//$conn = conexao::getInstance();
$varg = $_GET['varg'];
if ($varg=='geral') {
$data = $conn->query("SELECT * FROM v_lista_solicita");
} else {
$data = $conn->query("SELECT * FROM v_lista_solicita where usu_id = $idusu");
}
?>
<!--GRID DA DADOS-->
<head>
</head>
<div id='id_grid' class='container'>
<p style='font-size: 20px;'>Solicitações | Listagem
<a href='?page=solicitacao/solicita_cad'>
<!-- --><?php //if ($varg!='geral') { ?>
<i aling='center' class='fa fa-plus-square fa-2x pull-right' title='Novo registro'></i>
<!-- --><?php //} ?>
</a>
<!-- <a class='pull-right' href='?page=solicitacao/solicita_f'>-->
<!-- <i aling='center' class='fa fa-check-circle-o fa-2x' title='Solicitações finalizadas'></i>-->
<!-- </a>-->
</p>
<div class='panel panel-primary filterable panel-body'>
<form id='frm_pesq' method='post' class="search-form">
<table class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Setor solicitante</th>
<th>Data solicitação</th>
<th>Pedido</th>
<th>Prazo</th>
<th>Usuário</th>
<th>Anexos</th>
<th>Status</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($d = $data->fetch(PDO::FETCH_OBJ)) {
$arq_file = $conn->query("select * from v_lista_solicita_arq where solicita_id=$d->solicita_id");
$qtd_a = $arq_file->rowCount();
echo "<tr>";
echo "<td>" . $d->solicita_id . "</td>";
echo "<td>" . $d->setor . "</td>";
echo "<td>" . date('d/m/Y', strtotime($d->data_solicitacao)) . "</td>";
echo "<td>" . $d->pedido . "</td>";
echo "<td>" . date('d/m/Y', strtotime($d->data_prazo)) . "</td>";
echo "<td>" . $d->usu_usuario . "</td>";
echo "<td>" . $qtd_a . "</td>";
if ($d->status==1) {
echo "<td style='color: #ac0000;'>Pendente</td>";
} else {
echo "<td style='color: #336a49;'>Atendido</td>";
}
$id = $d->solicita_id;
echo "<td><a href='?page=solicitacao/solicita_edt&id=$id&varg=$varg'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</form>
</div>
</div>