| 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/merenda/moradanova/ |
Upload File : |
<?php
$qtdp = mysql_num_rows(mysql_query("select * from v_lista_prod"));
$val = mysql_num_rows(mysql_query("SELECT * from v_lista_validade_produto ORDER BY pro_produto"));
$esc_ate = mysql_num_rows(mysql_query("select * from v_lista_total_escolas_atendidas"));
$esc_tot = mysql_num_rows(mysql_query("select * from escolas"));
$esc_sol = mysql_num_rows(mysql_query("SELECT * FROM v_lista_solic_escola where sol_lido=0"));
$esc_msg = mysql_num_rows(mysql_query("SELECT * FROM v_lista_mensagem where msg_esc_id='1' and mse_lida <> '1' ORDER BY msg_data DESC"));
$saídas = mysql_num_rows(mysql_query("SELECT
escolas.esc_id, escolas.esc_nome, escolas.esc_telefone, escolas.esc_diretor_tel, escolas.esc_diretor_email
FROM escolas
WHERE
esc_id NOT IN (SELECT rai_esc_id
FROM esc_saidaavulsa_item
WHERE esc_saidaavulsa_item.rai_data NOT IN(DATE_SUB(CURDATE(), INTERVAL 1 DAY))
)
ORDER BY escolas.esc_nome ASC"));
$q_prep = mysql_num_rows(mysql_query("SELECT * FROM preparacao"));
$q_card = mysql_num_rows(mysql_query("SELECT * FROM cardapio"));
$q_orde = mysql_num_rows(mysql_query("SELECT * FROM ordemcompra"));
$q_nfis = mysql_num_rows(mysql_query("SELECT * FROM v_lista_entrada where ent_situ_ent='1'"));
$q_nfisa = mysql_num_rows(mysql_query("SELECT * FROM v_lista_entrada WHERE ent_situ_ent='3'"));
$q_rcar = mysql_num_rows(mysql_query("SELECT * FROM remessa"));
$q_ravu = mysql_num_rows(mysql_query("SELECT * FROM remavulsa"));
$q_cont = mysql_num_rows(mysql_query("SELECT * FROM proclicforn"));
$q_forn = mysql_num_rows(mysql_query("SELECT * FROM pessoas"));
$q_inve = mysql_num_rows(mysql_query("SELECT * FROM implantacao"));
$q_prod = mysql_num_rows(mysql_query("SELECT * FROM produtos"));
$q_perc = mysql_num_rows(mysql_query("SELECT * FROM v_lista_percas"));
$q_doac = mysql_num_rows(mysql_query("SELECT * FROM doacao"));
?>
<head>
<script>
function MostrarAlerta(msg) {
$("#msg").text(msg)
$("#Alerta").removeClass("in").show();
$("#Alerta").delay(2500).addClass("in").fadeOut(2000);
}
</script>
<div style="display:none;position:fixed;top: 45%;left: 25%;width: 50%;height: 50%;z-index:9999;border-radius:25px" id="Alerta">
<div class="centro panel panel-primary panel-body" id="Alerta">
<div class="panel-heading panel-body">
<div class="panel-heading panel-body" id="msg"></div>
</div>
</div>
</div>
</head>
<div class="container" id="dash">
<div class="row">
<h4 class="centro">Sistema de Gestão da Alimentação Escolar <p><strong style="font-size: 22px;"><?php echo utf8_encode($prefeitura) ?></strong></p></h4>
<div class="col-lg-3 col-md-3 col-xs-12 col-sm-3">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-graduation-cap fa-4x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge" style="font-size: 26px;"><? echo $esc_ate ?><span style="font-size: 14px;"> de </span><? echo $esc_tot ?></div>
<div style="font-size: 17px;">Escolas atendidas</div>
<p></p>
</div>
</div>
</div>
<a href="?page=escola/escolas_atendidas">
<div class="panel-footer">
<span class="pull-left" title="visualizar escolas atendidas">Visualizar</span>
<span class="pull-right"><i class="glyphicon glyphicon-arrow-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-3 col-xs-12 col-sm-3">
<div class="panel panel-green">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<?php
if ($esc_sol > 0) {
echo "<i class='fa fa-truck fa-4x piscar'></i>";
} else {
echo "<i class='fa fa-truck fa-4x'></i>";
}
?>
</div>
<div class="col-xs-9 text-right">
<?php
if ($esc_sol > 0) {
echo "<div class='huge'>$esc_sol</div >";
echo "<div class=''>Solicitações Escolas</div>";
} else {
echo "<div class='huge'>$esc_sol</div >";
echo "<div>Solictações Escolas</div>";
}
?>
</div>
</div>
</div>
<a href="?page=movimento/esc_solicitacao&lido=0">
<div class="panel-footer">
<span class="pull-left" title="visulizar solitações feitas pelas escolas">Visualizar</span>
<span class="pull-right"><i class="glyphicon glyphicon-arrow-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-3 col-xs-12 col-sm-3">
<div class="panel panel-yellow">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<?php
if ($esc_msg > 0) {
echo "<i class='fa fa-archive fa-4x piscar'></i>";
} else {
echo "<i class='fa fa-archive fa-4x'></i>";
}
?>
</div>
<div class="col-xs-9 text-right">
<?php
if ($esc_msg > 0) {
echo "<div class='huge'>$esc_msg</div >";
echo "<div class=''>Caixa de entrada</div>";
} else {
echo "<div class='huge'>$esc_msg</div >";
echo "<div>Caixa de entrada</div>";
}
?>
</div>
</div>
</div>
<a href="?page=escola_almox/mensagem"">
<div class="panel-footer">
<span class="pull-left" title="visualizar caixa de entrada de mensagens">Visualizar</span>
<span class="pull-right"><i class="glyphicon glyphicon-arrow-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-3 col-xs-12 col-sm-3">
<div class="panel panel-red">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class='fa fa-calendar-check-o fa-4x'></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge"><?php echo $val ?></div>
<div>validade produto</div>
</div>
</div>
</div>
<a href="?page=produto/produto_validade">
<div class="panel-footer">
<span class="pull-left" title="visulizar produtos com data de validade a vencer">Visualizar</span>
<span class="pull-right"><i class="glyphicon glyphicon-arrow-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
</div>
</div>
<!--LOGO PREFEITURA-->
<!--INFORMAÇÔES DE CADASTRO-->
<div class='container'>
<div class="row">
<div class="col-md-2" title="produtos cadastrados">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Produtos</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=produto/produto" style="color: #037b08; font-size: 25px;"><?php echo $q_prod ?></a></span>
</div>
</div>
</div>
<div class="col-md-2" title="escolas sem movimentação de saída no estoque em <?php echo date('d/m/Y', strtotime('-1 days')) ?>">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Escolas Saídas</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=movimento/escola_sem_movimento" style="color: #037b08; font-size: 25px;"><?php echo $saídas ?></a></span>
</div>
</div>
</div>
<div class="col-md-4">
<div class="panel-heading">
<div class="centro">
<img src="logo/logo.png" width='300px class=' img-responsive'/>
</div>
</div>
</div>
<div class="col-md-2" title="contratos cadastrados">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Contratos</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=licitacao/licitacao" style="color: #037b08; font-size: 25px;"><?php echo $q_cont ?></a></span>
</div>
</div>
</div>
<div class="col-md-2" title="fornecedores cadastrados">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Fornecedores</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=fornecedor/fornecedor" style="color: #037b08; font-size: 25px;"><?php echo $q_forn ?></a></span>
</div>
</div>
</div>
</div>
</div>
<!--SEGUNDA PARTE DO DASH-->
<!--INFORMAÇÔES DE CADASTRO-->
<style>
.card-header {
background: #3071a9;
padding: 8px 0px;
color: #fff;
border-radius: 5px;
align-content: center;
text-align: center;
}
.card-body {
padding: 5px 0px;
border-radius: 5px;
text-align: center;
}
.card {
/*margin: 12px auto;*/
}
.out {
border: 1px solid #3e1e1e;
border-radius: 5px;
border-color: #3071a9;
text-align: center;
}
.icon i {
/*margin: 4px 4px;*/
font-size: 25px;
color: #ffffff;
text-align: center;
}
</style>
<div class="container">
<div class="row">
<div class="col-md-2" title="preparações cadastradas">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Preparações</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=cardapio/preparacao" style="color: #037b08; font-size: 25px;"><?php echo $q_prep ?></a></span>
</div>
</div>
</div>
<div class="col-md-2" title="cardápios cadastrados">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Cardápios</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=cardapio/cardapio" style="color: #037b08; font-size: 25px;"><?php echo $q_card ?></a></span>
</div>
</div>
</div>
<div class="col-md-2" title="ordens de compra cadastradas">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Ordem Compra</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=movimento/ordcompra" style="color: #037b08; font-size: 25px;"><?php echo $q_orde ?></a></span>
</div>
</div>
</div>
<div class="col-md-2" title="Almoxarifado">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Almoxarifado</div>
<!-- <div class="col-md-9">Inv. | Perca | Doação</div>-->
</div>
</div>
<div class="card-body centro text-green-card">
<span><a title="Inventários" href="?page=almoxarifado/implanta" style="color: #037b08; font-size: 25px;"><?php echo $q_inve . '</a> | <a title="Percas" href="?page=almoxarifado/percas" style="color: #037b08; font-size: 25px;">' . $q_perc . '</a>' . '</a> | <a title="Fiel Depositário" href="?page=almoxarifado/doacao" style="color: #037b08; font-size: 25px;">' . $q_doac . '</a>' ?></span>
</div>
</div>
</div>
<div class="col-md-2" title="Notas fiscais C-cardápio | A-Avulsas cadastradas">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">N.F. C | A</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=remessa/remessa" style="color: #037b08; font-size: 25px;"><?php echo $q_nfis . '</a> | <a href="?page=almoxarifado/entrada_a" style="color: #037b08; font-size: 25px;">' . $q_nfisa . '</a>' ?></span>
</div>
</div>
</div>
<div class="col-md-2" title="remessas C-cardápio | A-Avulsas cadastradas">
<div class="out">
<div class="card-header">
<div class="row">
<!--<div class="icon col-md-3"><i class="fa fa-info"></i></div>-->
<div class="col-md-9">Remessas C | A</div>
</div>
</div>
<div class="card-body centro text-green-card">
<span><a href="?page=remessa/remessa" style="color: #037b08; font-size: 25px;"><?php echo $q_rcar . '</a> | <a href="?page=remessa/remessaavulsa" style="color: #037b08; font-size: 25px;">' . $q_ravu . '</a>' ?></span>
</div>
</div>
</div>
</div>
<!--REDE SOCIAIS-->
<div class="col-md-12 panel-body">
<div class="col-md-4"> </div>
<div class="col-md-4">
<ul class="list-inline text-center">
<li><a href="http://www.facebook.com.br/gtcontroller" target="_blank"><i class="fa fa-facebook"></i></a></li>
<li><a href="http://www.instagram.com.br/gtcontrollerbrasil" target="_blank"><i class="fa fa-instagram"></i></a></li>
<li><a href="https://www.youtube.com/channel/UCZ7RSK8iTHc5t65b-A40AEg" target="_blank"><i class="fa fa-youtube-play"></i></a></li>
<li><a href="mailto:contato@gtcontroller.com.br"><i class="fa fa-envelope-o"></i></a></li>
<li><a href="tel:8599779-0150"><i class="fa fa-whatsapp"></i> (85) 9.9779-0150 </a></li>
</ul>
</div>
<div class="col-md-4"> </div>
</div>
<!--//MOVIMENTACAO DE SAIDA-->
<div class="container" id="dash" hidden>
<div class="col-lg-12 col-md-12 col-xs-12 col-sm-12">
<div class="panel panel-red">
<a href="?page=movimento/escola_sem_movimento" target="_blank">
<div class="panel-footer">
<span class="pull-left"><b><?php echo $saídas ?></b> escolas sem movimentação de saída em <?php echo date('d/m/Y', strtotime('-1 days')) ?></span>
<span class="pull-right"><i class="glyphicon glyphicon-arrow-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
</div>
<!--//\\SEGUNDA LINHA//\\-->
<div class="container" id="dash" hidden>
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-12 text-center">
<div>Últimas mensagens - Caixa de entrada</div>
</div>
</div>
</div>
<div class="panel-footer">
<div class="">
<table id='fresh-table' class='table' cellspacing="0" width="100%">
<thead>
<tr>
<th class='notice notice-warning'>Escola</th>
<th class='notice notice-warning'>Data</th>
<th class='notice notice-warning'>Assunto</th>
</tr>
</thead>
<tbody>
<?php
$rs_prd = mysql_query("SELECT * FROM v_lista_mensagem where msg_esc_id='1' and mse_lida <> '1' ORDER BY msg_id ASC limit 5");
while ($row = mysql_fetch_array($rs_prd)) {
echo "<tr>";
echo "<td class='notice notice-primary'>" . utf8_encode($row['esc_nome']) . "</td>";
echo "<td class='notice notice-primary'>" . date('d/m/y - H:i', strtotime($row['msg_data'])) . "</td>";
echo "<td class='notice notice-primary'>" . $row['msg_assunto'] . "</td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- <div class="col-md-12 text-center">-->
<!-- <div class="panel-heading">-->
<!-- <div class="centro">-->
<!-- <img src="logo/logo.png" width='300px class=' img-responsive'/>-->
<!-- </div>-->
<!-- </div>-->
<!-- </div>-->
<!--//GRAFICO DE BARRAS-->
<!--<style>-->
<!-- #principal{-->
<!-- width:500px;-->
<!-- height:60px;-->
<!-- margin-left:10px;-->
<!-- font-family:Verdana, Helvetica, sans-serif;-->
<!-- font-size:14px;-->
<!-- }-->
<!-- #barras{-->
<!-- width:428px;-->
<!-- height:30px;-->
<!-- float:left;-->
<!-- margin: 2px 0;-->
<!-- }-->
<!-- .barra1, .barra2, .barra3, .barra4{-->
<!-- color:#FFF;-->
<!-- padding-left:10px;-->
<!-- height:30px;-->
<!-- line-height:30px;-->
<!-- }-->
<!-- .barra1{ background-color: #FF0000; }-->
<!-- .barra2{ background-color: #0000FF; }-->
<!-- .barra3{ background-color: #FF6600; }-->
<!-- .barra4{ background-color: #009933; }-->
<!--</style>-->
<!--<div>-->
<!-- --><?php
// // definindo porcentagem
// $width1 = '40%';
// $width2 = '49%';
// $width3 = '33%';
// $width4 = '13%';
// $total = 4; // total de barras
// ?>
<!-- <div id="principal">-->
<!-- <p>Porcentagem de Acessos</p>-->
<!-- --><? //
// for($i=1;$i <= $total;$i++){
// $width = ${'width' . $i};
// ?>
<!-- <div id="barras">-->
<!-- <div class="barra--><? //=$i?><!--" style="width:--><? //=$width ?><!--" >--><? //=$width ?><!--</div>-->
<!-- </div>-->
<!-- --><? // } ?>
<!--</div>-->
<script type="text/javascript" src="js/bootstrap-table.js"></script>
<script type="text/javascript">
var $table = $('#fresh-table'),
$alertBtn = $('#alertBtn'),
full_screen = false;
$().ready(function () {
$table.bootstrapTable({
toolbar: ".toolbar",
showRefresh: true,
search: true,
showToggle: true,
showColumns: true,
pagination: true,
striped: true,
pageSize: 8,
pageList: [8, 10, 25, 50, 100],
formatShowingRows: function (pageFrom, pageTo, totalRows) {
//do nothing here, we don't want to show the text "showing x of y from..."
},
formatRecordsPerPage: function (pageNumber) {
return pageNumber + " rows visible";
},
icons: {
refresh: 'fa fa-refresh',
toggle: 'fa fa-th-list',
columns: 'fa fa-columns',
detailOpen: 'fa fa-plus-circle',
detailClose: 'fa fa-minus-circle'
}
});
$(window).resize(function () {
$table.bootstrapTable('resetView');
});
window.operateEvents = {
'click .like': function (e, value, row, index) {
alert('You click like icon, row: ' + JSON.stringify(row));
console.log(value, row, index);
},
'click .edit': function (e, value, row, index) {
alert('You click edit icon, row: ' + JSON.stringify(row));
console.log(value, row, index);
},
'click .remove': function (e, value, row, index) {
$table.bootstrapTable('remove', {
field: 'id',
values: [row.id]
});
}
};
$alertBtn.click(function () {
alert("You pressed on Alert");
});
});
function operateFormatter(value, row, index) {
return [
'<a rel="tooltip" title="Like" class="table-action like" href="javascript:void(0)" title="Like">',
'<i class="fa fa-heart"></i>',
'</a>',
'<a rel="tooltip" title="Edit" class="table-action edit" href="javascript:void(0)" title="Edit">',
'<i class="fa fa-edit"></i>',
'</a>',
'<a rel="tooltip" title="Remove" class="table-action remove" href="javascript:void(0)" title="Remove">',
'<i class="fa fa-remove"></i>',
'</a>'
].join('');
}
</script>