| 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/portais/icece/admin/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: ralpb
* Date: 24/07/2020
* Time: 08:53
*/
session_start();
$noticias = $db->select("noticias")->fetch();
$qtd_noticia = $db->count();
?>
<header>
<style>
/* Tablet and bigger */
@media ( min-width: 768px ) {
.grid-divider {
position: relative;
padding: 10px;
border-top: 1px solid #3c73ac;
border-bottom: 1px solid #3c73ac;
border-left: 1px solid #3c73ac;;
border-right: 1px solid #3c73ac;
}
.grid-divider > [class*='col-'] {
position: static;
}
.grid-divider > [class*='col-']:nth-child(n+2):before {
content: "";
border-left: 1px solid #3c73ac;
position: absolute;
top: 0;
bottom: 0;
}
.col-padding {
padding: 0 15px;
}
}
</style>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.18/css/jquery.dataTables.min.css">
<script type="text/javascript" src="https://cdn.datatables.net/1.10.18/js/jquery.dataTables.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$('#dtabela').DataTable({
stateSave: true,
"processing": true,
responsive: true,
"oLanguage": {
"sProcessing": "Processando. Aguarde...",
"sLengthMenu": "Mostrar _MENU_ registros",
"sZeroRecords": "<span class='text-orange text-bold'>NENHUM REGISTRO ENCONTRADO!</span>",
"sInfo": "Registro _END_ de _TOTAL_",
"sInfoEmpty": "Sem registros",
"sInfoFiltered": "(de _MAX_ registros)",
"sInfoPostFix": "",
"sSearch": "<em class='fa fa-search' title='pesquisar'></em>",
"sUrl": "",
"oPaginate": {
"sFirst": "primeiro registro",
"sPrevious": "registro anterior",
"sNext": "próximo registro",
"sLast": "último registro"
},
"language": {
"decimal": ",",
"thousands": "."
}
}
});
});
</script>
</header>
<body style="background-color: #0d5e06;">
<section id="page-content-wrapper">
<div class="col-md-12">
<button type="button" class="hamburger is-closed" data-toggle="offcanvas">
<span class="hamb-top"></span>
<span class="hamb-middle"></span>
<span class="hamb-bottom"></span>
</button>
</div>
<section>
<div class="container">
<div class="col-md-12">
<div class="col-md-12">
<div class='panel-body'>
<a class="navbar-brand" href="index.php">
<img src="./assets/logo/logo.png" width="412px"/>
</a>
</div>
<div class='container'>
<div class='panel-body'>
<br>
<h4>Instituto Cearense de Educação, Cultura e Ecologia</h4>
</div>
</div>
<div class='container'>
<div class='panel-body'>
<h2>Área Administrativa</h2>
<h4>Usuário logado: <?php echo $_nome ?></h4>
<h4>E-Mail Usuário: <?php echo $_email ?></h4>
</div>
</div>
</div>
<!--COLUNA DADOS CONTATOS-->
<div class="col-md-6">
<!-- <div class='panel-body'>-->
<!-- <a class="navbar-brand" href="index.php">-->
<!---->
<!-- </a>-->
<!-- </div>-->
<!-- <div class='container'>-->
<!-- <div class='panel-body'>-->
<!-- <br>-->
<!-- <h4> </h4>-->
<!-- </div>-->
<!-- </div>-->
<div class='container'>
<div class='panel-body'>
<h2>Contatos enviados do portal</h2>
<div class="table-responsive panel-body col-md-12">
<table id="dtabela" class="table dtabela table-bordered table-responsive table-hover">
<thead>
<tr>
<th width="3%">ID</th>
<th width="10%">Data</th>
<th width="10%">Nome</th>
<th width="2%">Curso</th>
<th>Mensagem</th>
<th>E-Mail</th>
<th>Telefone</th>
<th>Lido</th>
<th></th>
</tr>
</thead>
<tbody style="font-size: 14px;">
<?php
foreach ($db->select('v_contato','*')->all() as $p) {
echo "<tr>";
if ($p->lido<>1) {
echo "<td style='background-color: darkred; color: white;'>" . $p->contato_id . "</td>";
} else {
echo "<td style='background-color: green; color: white;'>" . $p->contato_id . "</td>";
}
echo "<td>" . date('d/m/Y') . "</td>";
echo "<td>" . $p->nome . ' ' . $p->sobrenome . "</td>";
echo "<td>" . $p->curso . "</td>";
echo "<td>" . $p->mensagem . "</td>";
echo "<td>" . $p->email . "</td>";
echo "<td>" . $p->telefone . "</td>";
echo $p->lido=='1' ? "<td class='text-green'>SIM</td>" : "<td class='text-danger'>NÃO</td>";
$contato_id = $p->contato_id;
echo "<td><a href='?page=contato/contato_crud&contato_id=$contato_id&var=edit_contato' class='botao_editar'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</section>
</body>