| 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/pmapuiares/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: ralpb
* Date: 04/07/2020
* Time: 08:35
*/
ini_set('display_errors', 'on');
$p = $db->select("noticias", '*', array('ativo' => 1, 'destaque' => 1), 'noticia_id desc')->fetch();
$cfg = $db->select("configuracao", '*')->fetch();
$slide = $db->select("slide", '*')->fetch();
$covid = $db->select("covid", '*')->fetch();
$vacina = $db->select("vacina", '*')->fetch();
// $link_ss = $db->select("links_ss", '*')->fetch();
?>
<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<style>
.divLeft {
float: left;
position: relative;
}
#spaceText {
padding-right: 16px;
text-shadow: 1px 1px 1px black, 0 0 1em #6B9F8C, 0 0 0.1em #6B9F8C;
color: white;
font-size: 35px;
}
.textDiv {
position: absolute;
top: 20px;
left: 10px;
right: 10px;
}
</style>
<style>
.card {
font-size: 1em;
overflow: hidden;
padding: 0;
border: none;
border-radius: .28571429rem;
/*box-shadow: 0 1px 3px 0 #d4d4d5, 0 0 0 1px #d4d4d5;*/
background-color: #ffffff;
}
.card-video {
font-size: 8px;
overflow: hidden;
padding: 0;
border: none;
border-radius: .28571429rem;
box-shadow: 0 1px 3px 0 #d4d4d5, 0 0 0 1px #d4d4d5;
background-color: #ffffff;
}
.card-block {
font-size: 1em;
position: relative;
margin: 0;
padding: 1em;
border: none;
/*border-top: 1px solid rgba(34, 36, 38, .1);*/
box-shadow: none;
height: 100px;
}
.card-block-video {
font-size: 8px;
position: relative;
margin: 0;
padding: 1em;
border: none;
border-top: 1px solid rgba(34, 36, 38, .1);
box-shadow: none;
height: 60px;
}
.card-img-top {
display: block;
width: 100%;
height: 30%;
/*height: auto;*/
}
.card-inverse .btn {
/*border: 1px solid rgba(0, 0, 0, .05);*/
}
.profile-inline ~ .card-title {
display: inline-block;
margin-left: 4px;
vertical-align: top;
}
.text-bold {
font-weight: 700;
text-align: center;
}
.meta a {
text-decoration: none;
color: rgba(0, 0, 0, .4);
}
.meta a:hover {
color: rgba(0, 0, 0, .87);
}
</style>
<ToDO Colobox>
<!--ABRIR JANELA COLORBOX-->
<link rel="stylesheet" href="admin/assets/colorbox/example5/colorbox.css"/>
<script src="admin/assets/colorbox/jquery.colorbox.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$(".janela80").colorbox({
iframe: true, title: "Portal - <?php echo $c->tag_title ?>", width: "90%", height: "90%",
overlayClose: false,
fixed: true,
fadeOut: 300,
scrolling: true,
opacity: 0,
overlayClose: false,
scalePhotos: true,
close: "<i class='fa fa-times-circle fa-2x text-orange' title='voltar'></i>",
//onClosed: function () {
// location.reload(true);
//}
});
$(".janela90").colorbox({
iframe: true, title: "Portal - <?php echo $c->tag_title ?>", width: "90%", height: "90%",
overlayClose: false,
fixed: true,
fadeOut: 300,
scrolling: true,
overlayClose: false,
opacity: 0,
scalePhotos: true,
photo: true,
close: "<i class='fa fa-times-circle fa-2x' style='color: black;' title='voltar'></i>",
//onClosed: function () {
// location.reload(true);
//}
});
});
</script>
</ToDO>
</head>
<body style="font-family: Roboto; background-color: #ffffff">
<link rel="stylesheet" href="https://pro.fontawesome.com/releases/v5.10.0/css/all.css" integrity="sha384-AYmEC3Yw5cVb3ZcuHtOA93w35dYTsvhLPVnYs9eStHfGJvOvKxVfELGroGkvsg+p" crossorigin="anonymous"/>
<section>
<div class="container-fluid" style="background-color:white;">
<div class="row">
<div class="col-md-16 text-center">
<div class="carousel slide" id="sldCarousel" data-ride="carousel" data-interval="5000">
<div class="carousel-inner">
<div class="item active">
<div class="col-md-16"><a href="#"><img class="img-rounded" src="<?php echo $slide->imagem1 ?>" width="100%"></a></div>
</div>
<div class="item">
<div class="col-md-16"><a href="#"><img class="img-rounded" src="<?php echo $slide->imagem2 ?>" width="100%"></a></div>
</div>
<div class="item">
<div class="col-md-16"><a href="#"><img class="img-rounded" src="<?php echo $slide->imagem3 ?>" width="100%"></a></div>
</div>
</div>
<a class="left carousel-control" href="#sldCarousel" data-slide="prev"><i class="glyphicon glyphicon-chevron-left"></i></a>
<a class="right carousel-control" href="#sldCarousel" data-slide="next"><i class="glyphicon glyphicon-chevron-right"></i></a>
</div>
</div>
</div>
</div>
</section>
<!--BOTOES TOPO-->
<style>
.btn-topo {
width: 20%;
margin-bottom: 8px;
text-align: left;
margin-right: 8px;
}
</style>
<!--<div class="container panel-body hidden-xs"></div>-->
<section class="content hidden-xs">
<div class="container-fluid">
<div class="row">
<div class="table-responsive panel-body col-md-20">
<!-- <a href="--><?php //echo $link_ss->desp_orc_empenho ?><!--" class="btn btn-lg btn-success btn-topo janela90"><span class="glyphicon glyphicon-folder-open"></span> CORONAVÍRUS (COVID-19)</a>-->
<a href="http://www.sstransparenciamunicipal.net/api/receitaorc.php?entcod=27&dataini=01/01/2021&datafim=31-08-2021" target="_blank" class="btn btn-lg btn-success btn-topo"><span class="glyphicon glyphicon-folder-open"></span> TRANSPARÊNCIA</a>
<a href="#lrf" class="btn btn-lg btn-success btn-topo"><span class="glyphicon glyphicon-folder-open"></span> LRF</a>
<a href="?page=publicacao/veiculos" class="btn btn-lg btn-success btn-topo"><span class="glyphicon glyphicon-folder-open"></span> VEÍCULOS</a>
<a href="#" class="btn btn-lg btn-success btn-topo"><span class="glyphicon glyphicon-folder-open"></span> OUVIDORIA | E-SIC</a>
<!-- <a href="#" class="btn btn-lg btn-success btn-topo"><span class="glyphicon glyphicon-folder-open"></span> OBRAS</a>-->
<!-- <a href="#" class="btn btn-lg btn-success btn-topo"><span class="glyphicon glyphicon-folder-open"></span> PESSOAL</a>-->
</div>
</div>
</div>
</section>
<!--BOTOES TOPO-->
<!-- BOLETIM CORONA VÍRUS -->
<!--<div class="container panel-body"></div>-->
<section class="content">
<div class="col-md-16">
<div class="main-title-outer pull-left">
<div class="main-title">BOLETIM CORONAVÍRUS (COVID-19)</div>
</div>
<div class="jumbotron">
<div class="table-responsive panel-body col-md-16">
<h3>Atualizado <?php echo date('d/m/Y', strtotime($covid->data_atualizada)) ?> às <?php echo date('H:i', strtotime($covid->hora_atualizada)); ?></h3>
</div>
<div class="row w-100">
<div class="col-md-4">
<div class="card border-info mx-sm-1 p-3">
<div class="text-info text-center mt-3 panel-body"><h4>SUSPEITOS</h4></div>
<div class="text-info text-center mt-2" style="color: #E67E22"><h1><?php echo $covid->suspeitos ?></h1></div>
</div>
</div>
<div class="col-md-4">
<div class="card border-success mx-sm-1 p-3">
<div class="text-success text-center mt-3 panel-body"><h4>CONFIRMADOS</h4></div>
<div class="text-success text-center mt-2" style="color: #E64C3C"><h1><?php echo $covid->confirmados ?></h1></div>
</div>
</div>
<div class="col-md-4">
<div class="card border-danger mx-sm-1 p-3">
<div class="text-danger text-center mt-3 panel-body"><h4>DESCARTADOS</h4></div>
<div class="text-danger text-center mt-2" style="color: #27AE60"><h1><?php echo $covid->descartados ?></h1></div>
</div>
</div>
<div class="col-md-4">
<div class="card border-warning mx-sm-1 p-3">
<div class="text-warning text-center mt-3 panel-body"><h4>ÓBITOS</h4></div>
<div class="text-warning text-center mt-2" style="color: #2D3436"><h1><?php echo $covid->obitos ?></h1></div>
</div>
</div>
</div>
<div class="container panel-body"></div>
<div class="row w-100">
<div class="col-md-4">
<div class="card border-info mx-sm-1 p-3">
<div class="text-info text-center mt-3 panel-body"><h4>INTERNADOS</h4></div>
<div class="text-info text-center mt-2" style="color: #8E44AD"><h1><?php echo $covid->internados ?></h1></div>
</div>
</div>
<div class="col-md-4">
<div class="card border-success mx-sm-1 p-3">
<div class="text-success text-center mt-3 panel-body"><h4>CURADOS</h4></div>
<div class="text-success text-center mt-2" style="color: #2980B9"><h1><?php echo $covid->curados ?></h1></div>
</div>
</div>
<div class="col-md-4">
<div class="card border-danger mx-sm-1 p-3">
<div class="text-danger text-center mt-3 panel-body"><h4>NOTIFICADOS</h4></div>
<div class="text-danger text-center mt-2" style="color: #1ABC9D"><h1><?php echo $covid->notificados ?></h1></div>
</div>
</div>
<div class="col-md-4">
<div class="card border-warning mx-sm-1 p-3">
<div class="text-warning text-center mt-3 panel-body"><h4>ISOLAMENTO</h4></div>
<div class="text-warning text-center mt-2" style="color: #808C8D"><h1><?php echo $covid->isolamento ?></h1></div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- BOLETIM CORONA VÍRUS -->
<!-- BOLETIM VACINA COVID -->
<div class="container panel-body"></div>
<section class="content">
<div class="col-md-16">
<div class="main-title-outer pull-left">
<div class="main-title">BOLETIM VACINAÇÃO (COVID-19)</div>
</div>
<div class="jumbotron">
<div class="table-responsive panel-body col-md-16">
<img src="assets/images/vacinometro.png" width="150px;"/>
<h3>Atualizado <?php echo date('d/m/Y', strtotime($vacina->data_atualizada)) ?> às <?php echo date('H:i', strtotime($vacina->hora_atualizada)); ?></h3>
</div>
<div class="row w-100">
<div class="col-md-5">
<div class="card border-info mx-sm-1 p-3">
<div class="text-info text-center mt-3" style="margin-top: 10px;"><h4 style="font-size: 18px;">PRIMEIRA DOSE</h4></div>
<div class="text-info text-center mt-2" style="color: #1ABC9D"><h1><?php echo $vacina->d_1_aplicadas ?></h1></div>
<div class="text-info text-center mt-3"><h4>Recebidas <?php echo $vacina->d_1_recebidas ?></h4></div>
<div class="text-info text-center mt-3"><h4>Excedentes <?php echo $vacina->d_1_excedente ?></h4></div>
<div class="text-info text-center mt-3" style="margin-bottom: 10px;"><h4>Aplicadas <?php echo $vacina->d_1_percentual ?>%</h4></div>
</div>
</div>
<div class="col-md-5">
<div class="card border-success mx-sm-1 p-3">
<div class="text-success text-center mt-3" style="margin-top: 10px;"><h4 style="font-size: 18px;">SEGUNDA DOSE</h4></div>
<div class="text-info text-center mt-2" style="color: #1ABC9D"><h1><?php echo $vacina->d_2_aplicadas ?></h1></div>
<div class="text-info text-center mt-3"><h4>Recebidas <?php echo $vacina->d_2_recebidas ?></h4></div>
<div class="text-info text-center mt-3"><h4>Excedentes <?php echo $vacina->d_2_excedente ?></h4></div>
<div class="text-info text-center mt-3" style="margin-bottom: 10px;"><h4>Aplicadas <?php echo $vacina->d_2_percentual ?>%</h4></div>
</div>
</div>
<div class="col-md-6">
<div class="card border-danger mx-sm-1 p-3">
<div class="text-danger text-center mt-3" style="margin-top: 10px;"><h4 style="font-size: 18px;">DOSES APLICADAS</h4></div>
<div class="text-info text-center mt-2" style="color: #1ABC9D"><h1><?php echo $vacina->total_aplicada ?></h1></div>
<div class="text-info text-center mt-3"><h4>Doses recebidas <?php echo $vacina->total_recebidas ?></h4></div>
<div class="text-info text-center mt-3"><h4>Excedentes <?php echo $vacina->total_excedente ?></h4></div>
<div class="text-info text-center mt-3" style="margin-bottom: 10px;"><h4>doses aplicadas <?php echo $vacina->percentual_aplicadas ?>%</h4></div>
</div>
</div>
</div>
</div>
</div>
</section>
<!-- BOLETIM VACINA COVID -->
<div class="container panel-body"></div>
<section class="content">
<div class="container">
<div class="row">
<div class="col-md-16 content text-justify">
<div class="main-title-outer pull-left">
<div class="main-title">Notícias</div>
</div>
<div class="col-lg-8" style="margin-bottom: 30px;">
<!--NOTICIAS EM DESTAQUE-->
<!--CAROUSEL-->
<div id="myCarousel" class="carousel slide" data-ride="carousel">
<div class="carousel-inner">
<?php
$primeiroActive = true;
foreach ($db->select('noticias', '*', array('ativo' => 1), 'data desc', '8')->all() as $pall) {
?>
<div class="item <? echo $primeiroActive ? ' active' : ''; ?>">
<img src="<?php echo $pall->imagem ?>">
<p></p>
<p>
<a style="text-align: center; font-size: 12px; color: #44927a; background-color: white; margin-left: 7px;" href='?page=imprensa/noticias&id=<?php echo $pall->noticia_id ?>' title='visualizar notícia'>
<?php echo $pall->sub_titulo ?>
</a>
</p>
</div>
<?php
$primeiroActive = false;
}
?>
</div>
<a class="left carousel-control" href="#myCarousel" data-slide="prev">
<span class="glyphicon glyphicon-chevron-left"></span>
<span class="sr-only">Previous</span>
</a>
<a class="right carousel-control" href="#myCarousel" data-slide="next">
<span class="glyphicon glyphicon-chevron-right"></span>
<span class="sr-only">Next</span>
</a>
</div>
<!--CAROUSEL-->
</div>
<div class="col-lg-1"></div>
<div class="col-lg-8" style="margin-bottom: 30px;">
<h3>Últimas notícias.</h3>
<table class="table table-bordered table-responsive table-hover">
<tbody style="font-size: 13px;color: #478B51;">
<?php
foreach ($db->select('noticias', '*', array('ativo' => 1), 'data desc', '8')->all() as $uall) {
$data_inicial = $uall->data;
$data_final = date('Y/m/d');
$diferenca = strtotime($data_final) - strtotime($data_inicial);
$dias = floor($diferenca / (60 * 60 * 24));
echo "<tr>";
echo "<td style='text-align: left;'>" . date('d/m/Y', strtotime($uall->data)) . ' <br><span aria-hidden="true" class="glyphicon glyphicon-time" style="font-size: 10px;"> ' . abs(trim($dias)) . " dias</span></td>";
echo "<td style='text-align: left;'>" . mb_strimwidth($uall->sub_titulo, 0, 90, ' [...]') . "</span></td>";
echo "<td><a href='?page=imprensa/noticias&id=$uall->noticia_id' style='font-size: 18px;' title='visualizar notícia'>+</a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
<!--ULTIMAS NOTICIAS-->
<?php if ($cfg->ultimas_noticias==1) { ?>
<div class="container">
<div class="col-lg-16 content text-justify">
<div class="col-lg-16" style="margin-bottom: 20px;">
<?php
foreach ($db->select('noticias', '*', array('ativo' => 1), 'data desc', '8')->all() as $pall) { ?>
<div class="col-md-4 mt-4">
<div class="card">
<img class="card-img-top" src="<?php echo $pall->imagem ?>" width="">
<div class="card-block">
<a href="?page=imprensa/noticias&id=<?php echo $pall->noticia_id ?>">
<span style="font-size: 12px; text-align: justify; color: #478B51;"><?php echo mb_strimwidth($pall->titulo, 0, 90, ' [...]') ?></span>
</a>
</div>
</div>
</div>
<?php } ?>
</div>
<div class="col-lg-16 text-center">
<p><a class="btn btn-danger" href="?page=imprensa/noticias_listar">Todas as Notícias</a></p>
</div>
</div>
</div>
<? } ?>
<!--ULTIMAS NOTICIAS-->
<!--GALERIA DE FOTOS *******INATIVO*******-->
<?php if ($cfg->galeria_fotos==1) { ?>
<div class="col-lg-16" hidden>
<div class="main-title-outer pull-left">
<div class="main-title">Galeria</div>
</div>
<div class="col-lg-16" style="margin-bottom: 25px;">
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP1.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP1.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP2.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP2.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP3.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP3.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
</div>
<div class="col-lg-16" style="margin-bottom: 25px;">
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP4.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP4.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP5.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP5.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP6.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP6.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
</div>
<div class="col-lg-16" style="margin-bottom: 25px;">
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP7.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP7.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP8.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP8.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<a class="janela90" href="imagens/fotos/FMP9.jpg">
<img class="card-img-top img-thumbnail" src="imagens/fotos/FMP9.jpg">
</a>
<div class="card-block">
<h5 class="text-bold"><?php echo $c->tag_title ?></h5>
</div>
</div>
</div>
</div>
<div class="col-lg-16" style="margin-bottom: 25px;"></div>
</div>
<? } ?>
<!--PUBLICAÇÔES-->
<?php if ($cfg->publicacoes==1) { ?>
<div class="container">
<div class="row">
<div class="col-lg-20">
<div class="main-title-outer pull-left" id="lrf">
<div class="main-title">Publicações</div>
</div>
</div>
<div class="col-lg-20">
<div id="exTab3" class="container">
<ul class="nav nav-pills">
<li>
<a href="#rreo" class="btn btn-lg btn-success" data-toggle="tab">RREO</a>
</li>
<li>
<a href="#rgf" class="btn btn-lg btn-success" data-toggle="tab">RGF</a>
</li>
<li>
<a href="#prgfin" class="btn btn-lg btn-success" data-toggle="tab">PRGFIN</a>
</li>
<li>
<a href="#ppa" class="btn btn-lg btn-success" data-toggle="tab">PPA</a>
</li>
<li>
<a href="#loa" class="btn btn-lg btn-success" data-toggle="tab">LOA</a>
</li>
<li>
<a href="#ldo" class="btn btn-lg btn-success" data-toggle="tab">LDO</a>
</li>
</ul>
<div class="tab-content clearfix">
<div class="tab-pane active" id="rreo">
<!--RREO - RELATÓRIO RESUMIDO DA EXECUÇÃO ORÇAMENTÁRIA-->
<div class="table-responsive panel-body col-md-16">
<h3>RREO - RELATÓRIO RESUMIDO DA EXECUÇÃO ORÇAMENTÁRIA</h3>
<table class="table table-bordered table-responsive table-hover">
<tbody style="font-size: 13px;">
<?php
foreach ($db->select('v_publicacao', '*', array('tipodoc_id' => "2"), 'tipodoc_id desc')->all() as $rreo) {
echo "<tr>";
echo "<td style='text-align: left;'>" . $rreo->descricao . "</td>";
echo "<td>" . $rreo->numero_doc . "</span></td>";
echo "<td>" . date('d/m/Y', strtotime($rreo->data_doc)) . "</td>";
$id
= $rreo->pub_id;
$tipo
= $rreo->tipo_id;
echo "<td><a href='$rreo->imagem' target='_blank'><img width='20' src='imagens/pdf.png'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="rgf">
<!--RGF - RELATÓRIO DE GESTÃO FISCAL-->
<div class="table-responsive panel-body col-md-16">
<h3>RGF - RELATÓRIO DE GESTÃO FISCAL</h3>
<table class="table table-bordered table-responsive table-hover">
<tbody style="font-size: 13px;">
<?php
foreach ($db->select('v_publicacao', '*', array('tipodoc_id' => "1"), '')->all() as $rgf) {
echo "<tr>";
echo "<td style='text-align: left;'>" . $rgf->descricao . "</td>";
echo "<td>" . $rgf->numero_doc . "</span></td>";
echo "<td>" . date('d/m/Y', strtotime($rgf->data_doc)) . "</td>";
$id
= $rgf->pub_id;
$tipo
= $rgf->tipo_id;
echo "<td><a href='$rgf->imagem' target='_blank'><img width='20' src='imagens/pdf.png'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="prgfin">
<!--PRGFIN - PROGRAMAÇÃO FINANCEIRA E CMED - CRONOGRAMA DA EXECUÇÃO MENSAL DE DESEMBOLSO-->
<div class="table-responsive panel-body col-md-16">
<h3>PRGFIN - PROGRAMAÇÃO FINANCEIRA E CMED</h3>
<table class="table table-bordered table-responsive table-hover">
<tbody style="font-size: 13px;">
<?php
foreach ($db->select('v_publicacao', '*', array('tipodoc_id' => "69"), '')->all() as $prgfin) {
echo "<tr>";
echo "<td style='text-align: left;'>" . $prgfin->descricao . "</td>";
echo "<td>" . $prgfin->numero_doc . "</span></td>";
echo "<td>" . date('d/m/Y', strtotime($prgfin->data_doc)) . "</td>";
$id
= $prgfin->pub_id;
$tipo
= $prgfin->tipo_id;
echo "<td><a href='$prgfin->imagem' target='_blank'><img width='20' src='imagens/pdf.png'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="ppa">
<!--PPA - PLANO PLURIANUAL-->
<div class="table-responsive panel-body col-md-16">
<h3>PPA - PLANO PLURIANUAL</h3>
<table class="table table-bordered table-responsive table-hover">
<tbody style="font-size: 13px;">
<?php
foreach ($db->select('v_publicacao', '*', array('tipodoc_id' => "5"), '')->all() as $ppa) {
echo "<tr>";
echo "<td style='text-align: left;'>" . $ppa->descricao . "</td>";
echo "<td>" . $ppa->numero_doc . "</span></td>";
echo "<td>" . date('d/m/Y', strtotime($ppa->data_doc)) . "</td>";
$id
= $ppa->pub_id;
$tipo
= $ppa->tipo_id;
echo "<td><a href='$ppa->imagem' target='_blank'><img width='20' src='imagens/pdf.png'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="loa">
<!--LOA - LEI ORÇAMENTÁRIA ANUAL-->
<div class="table-responsive panel-body col-md-16">
<h3>LOA - LEI ORÇAMENTÁRIA ANUAL</h3>
<table class="table table-bordered table-responsive table-hover">
<tbody style="font-size: 13px;">
<?php
foreach ($db->select('v_publicacao', '*', array('tipodoc_id' => "3"), '')->all() as $loa) {
echo "<tr>";
echo "<td style='text-align: left;'>" . $loa->descricao . "</td>";
echo "<td>" . $loa->numero_doc . "</span></td>";
echo "<td>" . date('d/m/Y', strtotime($loa->data_doc)) . "</td>";
$id
= $loa->pub_id;
$tipo
= $loa->tipo_id;
echo "<td><a href='$loa->imagem' target='_blank'><img width='20' src='imagens/pdf.png'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<div class="tab-pane" id="ldo">
<!--LDO - LEI DE DIRETRIZES ORÇAMENTÁRIA-->
<div class="table-responsive panel-body col-md-16">
<h3>LDO - LEI DE DIRETRIZES ORÇAMENTÁRIA</h3>
<table class="table table-bordered table-responsive table-hover">
<tbody style="font-size: 13px;">
<?php
foreach ($db->select('v_publicacao', '*', array('tipodoc_id' => "4"), '')->all() as $ldo) {
echo "<tr>";
echo "<td style='text-align: left;'>" . $ldo->descricao . "</td>";
echo "<td>" . $ldo->numero_doc . "</span></td>";
echo "<td>" . date('d/m/Y', strtotime($ldo->data_doc)) . "</td>";
$id
= $ldo->pub_id;
$tipo
= $ldo->tipo_id;
echo "<td><a href='$ldo->imagem' target='_blank'><img width='20' src='imagens/pdf.png'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-5" style="background-color: white;">
<span style="font-size: 14px;"><strong>LICITAÇÔES</strong></span>
<div class="cards">
<table class='table table-responsive table-hover' style="height:375px;">
<?php
foreach ($db->select('v_licitacao', '*', array('ativo' => 1), 'data_cadastro desc', '3')->all() as $lic) { ?>
<tr style="font-size: 12px; text-align: left;">
<?php $id
= $lic->id_lic ?>
<td><a href='?page=publicacao/licitacao_dados&id=<?php echo $id ?>'><img width='35' src='imagens/pdf.png'/></a>
</td>
<td>
<a href='?page=publicacao/licitacao_dados&id=<?php echo $id ?>'><?php echo $lic->modalidade . ' ' . $lic->numero_licitacao ?></a>
<br><span style="font-size: 11px;"><?php echo mb_strimwidth($lic->objeto_licitacao, 0, 195, '...') ?></span><br>
<span style="font-size: 12px; color: #890f0f;">Valor Estimado R$ <?php echo $lic->valor_estimado ?></span>
</td>
</tr>
<?php } ?>
</table>
<?php if ($db->count() > 0) { ?>
<a class="btn btn-danger" style='width:100%; margin-bottom:10px;' href="?page=publicacao/licitacao">TODAS AS LICITAÇÕES</a>
<? } else {
echo "<strong>Nenhum documento cadastrado!</strong>";
} ?>
</div>
</div>
<div class="col-lg-5" style="background-color: white;">
<span style="font-size: 14px;"><strong>PORTARIAS</strong></span>
<div class="cards">
<table class='table table-responsive table-hover' style="height:375px;">
<?php
foreach ($db->select('v_publicacao', '*', array('ativo' => 1, 'tipo_id' => 3), 'numero_doc desc', '3')->all() as $lrf) { ?>
<tr style="font-size: 12px; text-align: left;">
<td><a class="janela90" href='<?php echo $lrf->imagem ?>'><img width='35' src='imagens/pdf.png'/></a></td>
<td>
<a class="janela90" href='<?php echo $lrf->imagem ?>'><?php echo $lrf->tipo . ' ' . $lrf->numero_doc . '/' . $lrf->exercicio ?></a>
<br><?php echo mb_strimwidth($lrf->descricao, 0, 200, '...') ?>
</td>
</tr>
<?php } ?>
</table>
<?php if ($db->count() > 0) { ?>
<a class="btn btn-danger" style='width:100%; margin-bottom:10px;' href="?page=publicacao/publicacao&tipo=3">TODAS AS
PORTARIAS</a>
<? } else {
echo "<strong>Nenhum documento cadastrado!</strong>";
} ?>
</div>
</div>
<div class="col-lg-6" style="background-color: white;">
<span style="font-size: 14px;"><strong>DECRETOS</strong></span>
<div class="cards">
<table class='table table-responsive table-hover' style="height:375px;">
<?php
foreach ($db->select('v_publicacao', '*', array('ativo' => 1, 'tipo_id' => 7), 'tipo_id desc', '3')->all() as $lrf) { ?>
<tr style="font-size: 12px; text-align: left;">
<td><a class="janela80" href='<?php echo $lrf->imagem ?>'><img width='35' src='imagens/pdf.png'/></a></td>
<td>
<a class="janela80" href='<?php echo $lrf->imagem ?>'><?php echo $lrf->tipo_doc . ' ' . $lrf->numero_doc ?></a>
<br><span style="font-size: 11px;"><?php echo mb_strimwidth($lrf->descricao, 0, 300, '...') ?></span>
</td>
</tr>
<?php } ?>
</table>
<?php if ($db->count() > 0) { ?>
<a class="btn btn-danger" style='width:100%; margin-bottom:10px;' href="?page=publicacao/publicacao&tipo=7">TODOS OS
DECRETOS</a>
<? } else {
echo "<strong>Nenhum documento cadastrado!</strong>";
} ?>
</div>
</div>
<!--SEGUNDA COLUNA-->
<p class="panel-body"></p>
<div class="col-lg-6" style="background-color: white;">
<span style="font-size: 14px;"><strong>CONTRATOS</strong></span>
<div class="cards">
<table class='table table-responsive table-hover' style="height:375px;">
<?php
foreach ($db->select('v_publicacao', '*', array('ativo' => 1, 'tipo_id' => 4), 'data desc', '3')->all() as $lrf) { ?>
<tr style="font-size: 12px; text-align: left;">
<td><a class="janela80" href='<?php echo $lrf->imagem ?>'><img width='35' src='imagens/pdf.png'/></a></td>
<td><a class="janela80" href='<?php echo $lrf->imagem ?>'>
<?php echo '<span style="color: darkred;">' . $lrf->aviso . ' </span>' . 'Nº: ' . $lrf->numero_doc . ' | R$ ' . $lrf->valor_doc . ' | Data: ' . date('d/m/Y', strtotime($lrf->data_doc)) ?></a>
<br><span style="font-size: 11px;"><?php echo mb_strimwidth($lrf->descricao, 0, 300, '...') ?></span>
</td>
</tr>
<?php } ?>
</table>
<?php if ($db->count() > 0) { ?>
<a class="btn btn-danger" style='width:100%; margin-bottom:10px;' href="?page=publicacao/publicacao&tipo=4">TODOS OS
CONTRATOS</a>
<? } else {
echo "<strong>Nenhum documento cadastrado!</strong>";
} ?>
</div>
</div>
<div class="col-lg-5" style="background-color: white;">
<span style="font-size: 14px;"><strong>LEIS</strong></span>
<div class="cards">
<table class='table table-responsive table-hover' style="height:375px;">
<?php
foreach ($db->select('v_publicacao', '*', array('ativo' => 1, 'tipo_id' => 5), 'numero_doc desc', '3')->all() as $lrf) { ?>
<tr style="font-size: 12px; text-align: left;">
<td><a class="janela80" href='<?php echo $lrf->imagem ?>'><img width='35' src='imagens/pdf.png'/></a></td>
<td>
<a class="janela80" href='<?php echo $lrf->imagem ?>'><?php echo $lrf->tipo_doc . ' ' . $lrf->numero_doc ?></a>
<br><span style="font-size: 11px;"><?php echo mb_strimwidth($lrf->descricao, 0, 300, '...') ?></span>
</td>
</tr>
<?php } ?>
</table>
<?php if ($db->count() > 0) { ?>
<a class="btn btn-danger" style='width:100%; margin-bottom:10px;' href="?page=publicacao/publicacao&tipo=5">TODAS AS
LEIS</a>
<? } else {
echo "<strong>Nenhum documento cadastrado!</strong>";
} ?>
</div>
</div>
<div class="col-lg-5" style="background-color: white;">
<span style="font-size: 14px;"><strong>DIÁRIAS</strong></span>
<div class="cards">
<table class='table table-responsive table-hover' style="height:375px;">
<?php
foreach ($db->select('publicacao', '*', array('ativo' => 1, 'tipo_id' => 6), 'data desc', '3')->all() as $lrf) { ?>
<tr style="font-size: 12px; text-align: left;">
<td><a class="janela80" href='<?php echo $lrf->imagem ?>'><img width='35' src='imagens/pdf.png'/></a></td>
<td>
<a class="janela80" href='<?php echo $lrf->imagem ?>'><?php echo $lrf->tipo_documento . ' ' . $lrf->numero_doc ?></a>
<br><?php echo mb_strimwidth($lrf->descricao, 0, 200, '...') ?>
</td>
</tr>
<?php } ?>
</table>
<?php if ($db->count() > 0) { ?>
<a class="btn btn-danger" style='width:100%; margin-bottom:10px;' href="?page=publicacao/publicacao&tipo=6">TODAS AS
DIÁRIAS</a>
<? } else {
echo "<strong>Nenhum documento cadastrado!</strong>";
} ?>
</div>
</div>
</div>
</div>
<!--FIM PUBLICAÇÔES-->
</div>
<? } ?>
<p></p>
<!--GALERIA DE VIDEOS *******INATIVO*******-->
<?php if ($cfg->galeria_video==1) { ?>
<div class="container panel-body" hidden>
<div class="row">
<div class="col-lg-20">
<div class="main-title-outer pull-left">
<div class="main-title">Galeria de Vídeos</div>
</div>
<div class="col-lg-16" style="margin-bottom: 25px;">
<div class="col-md-5 mt-4">
<div class="card">
<iframe src="https://www.youtube.com/embed/LYYbRzEBDpw" frameborder="0" width="350px" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<div class="card-block-video">
<p><h5 style="font-size: 14px;">Comunidade Igarapé-Açú é contemplada com uma nova UBS</h5></p>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<iframe src="https://www.youtube.com/embed/SoeaDewQl1w" frameborder="0" width="350px" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<div class="card-block-video">
<p><h5 style="font-size: 14px;">Caminhada Faça Bonito 18 de Maio.</h5></p>
</div>
</div>
</div>
<div class="col-md-5 mt-4">
<div class="card">
<iframe src="https://www.youtube.com/embed/A6lWK84sfl8" frameborder="0" width="350px" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
<div class="card-block-video">
<p><h5 style="font-size: 14px;">Semana da Saúde Visual é realizado em Barbalha</h5></p>
</div>
</div>
</div>
<div class="col-lg-16 text-center">
<p></p>
<p>
<a class="btn btn-danger" href="javascript:abreJanela('https://www.youtube.com/channel/UC86tPazctVi71tnnZ_q4IgQ/videos')" target="_blank">
Visitar Canal no Youtube
</a>
</p>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
<!--MAPA-->
<?php if ($cfg->mapa==1) { ?>
<div class="container-fluid">
<div class="row">
<div class="col-lg-20">
<div class="main-title-outer pull-left">
<div class="main-title">Mapa</div>
</div>
<div class="col-lg-20" style="margin-bottom: 25px;">
<!--<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3987.585755431935!2d-55.517659685245185!3d-1.9168289986025056!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x927d57be1c400dfb%3A0x155ea08863782c72!2sPrefeitura+Municipal+de+%C3%93bidos!5e0!3m2!1spt-BR!2sbr!4v1550254721775" width="100%" height="250" frameborder="0" style="border:0" allowfullscreen></iframe>-->
<!--<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3957.374223884176!2d-39.30354508579514!3d-7.311788973919003!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x7a177b40459e0d9%3A0x2f1082da6645665a!2sPrefeitura%20Municipal%20de%20Barbalha!5e0!3m2!1spt-BR!2sbr!4v1611233139414!5m2!1spt-BR!2sbr" width="100%" height="250" frameborder="0" style="border:0;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>-->
<iframe src="https://www.google.com/maps/embed?pb=!1m10!1m8!1m3!1d3980.360430369222!2d-39.4287775!3d-3.9458814!3m2!1i1024!2i768!4f13.1!5e0!3m2!1spt-BR!2sbr!4v1623844539075!5m2!1spt-BR!2sbr" width="100%" height="250" style="border:0;" allowfullscreen="" loading="lazy"></iframe>
</div>
</div>
</div>
</div>
<? } ?>
</div>
<!--INICIO DA BARRA LATERAL-->
<!-- --><?php //include "menu_lateral.php" ?>
<!--FIM DA BARRA LATERAL-->
</div>
</div>
</section>
</body>
</html>