| Server IP : 20.75.53.88 / Your IP : 216.73.217.138 [ 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/cmdev/admin/paginas/imprensa/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: ralpb
* Date: 24/07/2018
* Time: 08:55
*/
// $noticia = $conn->query("select * from noticias order by data desc");
// $ativo = $conn->query("select * from menu_imprensa where m_cidade_id=8");
// $a = $ativo->fetch(PDO::FETCH_OBJ);
$noticia = $db->select("noticias", '*', '', 'noticia_id DESC')->fetch();
$a = $db->select("menu_imprensa", '*', array('m_cidade_id' => 8))->fetch();
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<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 () {
$('#dnoticias').DataTable({
aaSorting: [[0, 'desc']],
"order": [[0, 'desc']],
//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>
</head>
<body>
<div class="container">
<div class="col-md-12">
<a class="" href="index.php">
<img src="../assets/images/logo/logo.png" width="200px"/>
</a>
</div>
<div class="col-md-12">
<h4>Portal - Administração</h4>
</div>
</div>
<section>
<div class="container">
<div class="row">
<div class="col-md-12 content text-justify">
<div class="col-md-12">
<div class="page-header">
<h3>Imprensa - Noticias</h3>
<ol class="breadcrumb pull-right">
<li><a href="index.php">Voltar</a></li>
</ol>
</div>
<form id="f_ativo" name="f_ativo" method="post" action="?page=imprensa/imprensa_crud&var=edit_ativo_noticia">
<div class='container-fluid'>
<div class="panel-body">
<div class="col-md-12">
<input type="hidden" name="m_cidade_id" value="<?php echo $a->m_cidade_id ?>">
<div class="col-md-3">
<label>Título Menu </label>
<input type="text" required name="nome" value="<?php echo $a->nome ?>" class="form-control">
</div>
<div class="col-md-3">
<label>Link </label>
<input readonly type="text" required name="link" value="<?php echo $a->link ?>" class="form-control">
</div>
<div class="col-md-2">
<label>Ordem </label>
<input type="text" required name="ordem" value="<?php echo $a->ordem ?>" class="form-control">
</div>
<div class="col-md-2">
<label>Ativo </label>
<select name="ativo" class="form-control">
<?php if ($a->ativo==1) { ?>
<option value="1" selected>Ativo</option>
<option value="0">Inativo</option>
<? } else { ?>
<option value="0" selected>Inativo</option>
<option value="1">Ativo</option>
<?php } ?>
</select>
</div>
<div class="col-md-2">
<label> </label><br>
<button type="submit" title="salvar registro" class="btn btn-primary">
<i class="fa fa-check-circle"></i>
</button>
</div>
</div>
</div>
</div>
</form>
<div class="pull-left col-md-12">
<button><a href="?page=imprensa/noticias_add">Cadastrar nova notícia</a></button>
</div>
<div class="table-responsive panel-body col-md-12">
<table id="dnoticias" class="table table-bordered table-responsive table-hover">
<thead>
<tr>
<th width="3%">ID</th>
<th width="2%">Data</th>
<th width="2%">Imagem</th>
<th>Título</th>
<th width="2%" title='Notícia ativa'>A</th>
<th width="2%" title='Notícia em destaque'>D</th>
<th width="2%"></th>
</tr>
</thead>
<tbody style="font-size: 14px;">
<?php
foreach ($db->select('noticias', '*', array('ativo' => 1), 'data')->all() as $p) {
echo "<tr>";
echo "<td>" . $p->noticia_id . "</td>";
echo "<td>" . date('d/m/Y', strtotime($p->data)) . "</td>";
echo "<td>" . "<img src='../$p->imagem' width='100px'>" . "</td>";
echo "<td>" . $p->titulo . "</td>";
echo $p->ativo=='1' ? "<td class='text-green'>SIM</td>" : "<td class='text-danger'>NÃO</td>";
echo $p->destaque=='1' ? "<td class='text-green'>SIM</td>" : "<td class='text-danger'>NÃO</td>";
$id = $p->noticia_id;
echo "<td><a href='?page=imprensa/noticias_edt&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>
<!--INICIO DA BARRA LATERAL ACESSO A INFORMACAO-->
<!-- --><?php //include_once "admin/paginas/menu.php" ?>
<!--FIM DA BARRA LATERAL-->
</div>
</div>
</section>
</body>
</html>