| 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/merenda/apuiares/modulos/relatorio/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 19/10/2015
* Time: 14:01
*/
session_start();
$_SESSION['txt_usuario'];
$exercicio = $_SESSION['exercicio'];
$id_usu_ent = $_SESSION['idusu'];
$datai = date($exercicio . '-01-01');
$dataf = date($exercicio . '-m-t');
$rsResult = mysql_query("call f_saldo_produtos_por_data('$datai', '$dataf')");
?>
<head>
<script src="https://cdn.datatables.net/1.10.9/css/jquery.dataTables.min.css" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$('#tabela').DataTable({
"pagingType": "full_numbers", "lengthMenu": [[8, 25, 50, -1], [8, 25, 50, "Todos"]], stateSave: true, "oLanguage": {
"sProcessing": "Processando. Aguarde...",
"sLengthMenu": "Mostrar _MENU_ registros",
"sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
"sInfo": "Mostrando _START_ até _END_ de _TOTAL_ registros",
"sInfoEmpty": "Mostrando 0 até 0 de 0 registros",
"sInfoFiltered": "(de _MAX_ registros no total)",
"sInfoPostFix": "",
"sSearch": "<em class='fa fa-search' title='pesquisar'></em>",
"sUrl": "http://SGAE - Merenda",
"oPaginate": {
"sFirst": "<<",
"sPrevious": "<em class='fa fa-arrow-circle-left' title='registro anterior'></em>",
"sNext": "<img src='img/proximo.png' width='20' title='Pr?ximo registro'/>",
"sLast": ">>"
}
}
});
});
</script>
<style type="text/css">
.tip {
color: #fff;
background: black;
display: none; /*--Hides by default--*/
padding: 5px;
position: absolute;
z-index: 1000;
-webkit-border-radius: 3px;
-moz-border-radius: 3px;
border-radius: 3px;
font-size: 10px;
font-family: tahoma, verdana, arial, sans-serif;
}
a {
color: black;
}
</style>
<script>
$(document).ready(function () {
//Tooltips
$(".tip_trigger").hover(function () {
tip = $(this).find('.tip');
tip.show(); //Show tooltip
}, function () {
tip.hide(); //Hide tooltip
}).mousemove(function () {
var mousex = 400;
var mousey = 0;
tip.css({top: mousey, left: mousex});
});
});
</script>
</head>
<!--GRID DA DADOS-->
<body style="padding-top: 40px;"/>
<div id='print' class='container'>
<p style='font-size: 20px;'>Saldo de produtos | Listagem
<a href="modulos/relatorio/saldo_produtos_data.php?dataini=<? echo $datai ?>&datafim=<? echo $dataf ?>"
target='_blank'>
<i class="glyphicon glyphicon-print text-print navbar-right" title="gerar PDF"></i>
</a>
</p>
<div class='panel panel-body panel-primary filterable'>
<form id='frm_pesq' method='post' action="modulos/relatorio/saldo_produto_prn" target="_blank">
<table class='table hover table-bordered' width="100%">
<thead>
<tr style="font-family: monospace;">
<th colspan="1" style="background:#EEEED1; border: none">Dados do produto</th>
<th colspan="0" style="background:#EEEED1; border: none"></th>
<th colspan="0" style="background:#EEEED1; border: none"></th>
<th colspan="0" style="background:#CDCDB4; border: none">Entradas</th>
<th colspan="0" style="background:#CDCDB4; border: none"></th>
<th colspan="0" style="background:#CDCDB4; border: none"></th>
<th colspan="0" style="background:#CDCDB4; border: none"></th>
<th colspan="0" style="background:#EEEED1; border: none">Saídas</th>
<th colspan="0" style="background:#EEEED1; border: none"></th>
<th colspan="0" style="background:#EEEED1; border: none"></th>
<th colspan="0" style="background:#8FBC8F; border: none">saldo</th>
</tr>
<tr>
<th style="background: #EEEED1; border-color: #dcdcdc;">Item-Cód.</th>
<th style="background: #EEEED1; border-color: #dcdcdc;">Und.</th>
<th style="background: #EEEED1; border-color: #dcdcdc;">Grupo</th>
<th class='direita' style="background:#CDCDB4; border-color: #dcdcdc;"><span class="tip_trigger">S. ant.<span class="tip">Saldo anterior</span></span></th>
<th class='direita' style="background:#CDCDB4; border-color: #dcdcdc;"><span class="tip_trigger">Inv.<span class="tip">Entradas por invetário de estoque</span></span>
</th>
<th class='direita' style="background:#CDCDB4; border-color: #dcdcdc;"><span class="tip_trigger">N.F.<span class="tip">Entradas por nota fiscal</span></span>
</th>
<th class='direita' style="background:#CDCDB4; border-color: #dcdcdc;"><span class="tip_trigger">Total<span class="tip">Total de entradas</span></span></th>
<th class='direita' style="background:#EEEED1; border-color: #dcdcdc;">
<span class="tip_trigger">Cardápio<span class="tip">Saídas por remessa cardápio</span></span></th>
<th class='direita' style="background:#EEEED1; border-color: #dcdcdc;"><span class="tip_trigger">Avulsa<span class="tip">Saídas por remessa avulsa</span></span>
</th>
<th class='direita' style="background:#EEEED1; border-color: #dcdcdc;"><span class="tip_trigger">Total<span class="tip">Total de saídas</span></span></th>
<th class='direita' style="background:#8FBC8F; border-color: #dcdcdc;"><span class=" tip_trigger">Total<span class="tip">Saldo atual do produto</span></span>
</th>
</tr>
</thead>
<tbody>
<?php
while ($row = mysql_fetch_array($rsResult)) {
$cod_id = $row['pro_id'];
$entradas = $row['qtd_entra_nf'] + $row['qtd_entra_implam'];
$saidas = $row['qtd_sai_rem_car'] + $row['qtd_sai_rem_avu'];
$saldo = ($entradas - $saidas);
echo "<tr>";
echo "<td style='color: #191970;'>" . $row['pro_produto'] . '-' . $row['pro_id'] . "</td>";
echo "<td style='font-size: 10px'>" . $row['und_desc'] . "</td>";
echo "<td style='font-size: 9px'>" . $row['grp_grupo'] . "</td>";
$saldo_e = ($row['qtd_entra_implam_sa'] + $row['qtd_entra_nf_sa']) - ($row['qtd_sai_rem_car_sa'] + $row['qtd_sai_rem_avu_sa']);
$saldo_t = ($saldo - $saldo_e);
echo "<td class='direita' style='color: #0000CC;'><b>" . number_format($saldo_t, 2, ',', '.') . "</b></td>";
echo "<td class='direita' style='color: #0000CC;'>" . number_format($row['qtd_entra_implam'], 2, ',', '.') . "</td>";
echo "<td class='direita' style='color: #0000CC;'>" . number_format($row['qtd_entra_nf'], 2, ',', '.') . "</td>";
echo "<td class='direita' style='color: #0000CC; background: #CDCDB4;'><b>" . number_format($entradas, 2, ',', '.') . "</b></td>";
echo "<td class='direita' style='color: #843534;'>" . number_format($row['qtd_sai_rem_car'], 2, ',', '.') . "</td>";
echo "<td class='direita' style='color: #843534;'>" . number_format($row['qtd_sai_rem_avu'], 2, ',', '.') . "</td>";
echo "<td class='direita' style='color: #843534; background: #EEEED1;'><b>" . number_format($saidas, 2, ',', '.') . "</b></td>";
$saldo_g = ($saldo_t + $saldo);
if ($saldo_g < 0) {
echo "<td class='direita' style='color: black; background: #CD5C5C;'><b>" . number_format($saldo_g, 2, ',', '.') . "</b></td>";
} else {
echo "<td class='direita' style='color: black; background: #8FBC8F;'><b>" . number_format($saldo_g, 2, ',', '.') . "</b></td>";
}
echo "</tr>";
}
?>
</tbody>
</table>
<!-- <input class="centro" type="submit" value="Imprimir" />-->
</form>
</div>
</div>
</html>