| 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/acarape/modulos/relatorio/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 29/10/2015
* Time: 08:59
*/
session_start();
$prefeitura = $_SESSION['prefeitura'];
$secretaria = $_SESSION['secretaria'];
//ini_set('display_errors', 'off');
include_once("../../includes/conexao.php");
$datai = date('Y-01-01');
$dataf = date('2015-m-t');
$rsResult = mysql_query("call f_saldo_produtos_por_data('$datai', '$dataf')");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="pt-br">
<head>
<link href="../../Styles/Site.css" rel="stylesheet" type="text/css"/>
<link href="../../Styles/bootstrap.css" rel="stylesheet" type="text/css"/>
<style type="text/css">
th {
font-family: monospace;
font-size: 11px;
}
td {
font-family: monospace;
font-size: 11px;
}
th {
page-break-before: always
}
</style>
</head>
<!--GRID DA DADOS-->
<div>
<span style='font-size: 13px; font-family: monospace;'><?php echo $prefeitura ?></span><br>
<span style='font-size: 13px; font-family: monospace;'><?php echo $secretaria ?></span><br>
<span style='font-size: 12px; font-family: monospace;'>Saldo de produtos | Listagem</span>
<div>
<table class='table hover table-bordered'>
<thead>
<tr style="height: auto">
<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;">S. ant.</th>
<th class='direita' style="background:#CDCDB4; border-color: #dcdcdc;">Inv</th>
<th class='direita' style="background:#CDCDB4; border-color: #dcdcdc;">N.F.</th>
<th class='direita' style="background:#CDCDB4; border-color: #dcdcdc;">Total</th>
<th class='direita' style="background:#EEEED1; border-color: #dcdcdc;">Card�pio</th>
<th class='direita' style="background:#EEEED1; border-color: #dcdcdc;">Avulsa</th>
<th class='direita' style="background:#EEEED1; border-color: #dcdcdc;">Total</th>
<th class='direita' style="background:#8FBC8F; border-color: #dcdcdc;">Saldo</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: 10px'>" . $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>
</div>
</div>
<script>
window.print();
</script>
</html>