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 : /proc/22665/cwd/html/merenda/dev/modulos/cardapio/
Upload File :
[ HOME ] [ BACKUP SHELL ] [ JUMPING ] [ MASS DEFACE ] [ SCAN ROOT ] [ SYMLINK ]
Current File : /proc/22665/cwd/html/merenda/dev/modulos/cardapio/preparacao_edt.php
<?php
    /**
     * Created by PhpStorm.
     * User: RalpAlves
     * Date: 04/03/15
     * Time: 14:02
     */
    session_start();
    $id_usu  = $_SESSION['idusu'];
    $usuario = $_SESSION['txt_usuario'];
    $direito = $_SESSION['admin'];
    
    $v_cod = $_GET['cod_prep'];
    mysql_select_db($banco, conexao);
    $rs_prep = mysql_query("SELECT * FROM preparacao where pre_id = $v_cod");
    $resulta = mysql_fetch_array($rs_prep);
    $_codigo = $resulta['prd_id'];
    //$rs_prd  = mysql_query("SELECT * FROM v_lista_licitacao_forn_item order by pro_produto");
    
    //VOLTAR A PESQUISA DE PRODUTOS PELO CONTRATO
    $rs_prd = mysql_query("SELECT * FROM produtos WHERE pro_tipo=1 order by pro_produto");
    //$rs_prd  = mysql_query("SELECT * FROM v_lista_produtos_contratos WHERE pro_tipo=1 ORDER BY pro_produto");
    //VOLTAR A PESQUISA DE PRODUTOS PELO CONTRATO
    
    
    $rs_tip  = mysql_query("SELECT * FROM tipoescola");
    $rs_pre  = mysql_query("SELECT * FROM tipopreparacao");
    $rs_med  = mysql_query("SELECT * FROM medidacaseira");
    $rs_prdp = mysql_query("SELECT * FROM v_lista_preparacao_prod where prd_preid = $v_cod");
    $rs_prdt = mysql_query("SELECT * FROM v_lista_preparacao_prod_tot where cod_pre = $v_cod");
?>


<head id="Head1">
    <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">
        $(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": "",
                    "oPaginate": {
                        "sFirst": "<em class='fa fa-angle-double-left' title='primeiro registro'>",
                        "sPrevious": "<em class='fa fa-arrow-circle-left' title='registro anterior'></em>",
                        "sNext": "<em class='fa fa-arrow-circle-right' title='próximo registro'></em>",
                        "sLast": "<em class='fa fa-angle-double-right ' title='último registro'>"
                    }
                }
            });
        });
    </script>
</head>
<body style="padding-top: 40px;"/>
<form id="form1" name="form1" method="post" action="?page=./cardapio/preparacao_crud&var_acao=editar">
    <div class="container">
        <div class="panel panel-info">
            <div class="panel-heading">
                <div class="panel-title">
                    <button type="button" name="bt_novo" class="btn botao_esquerda" onclick=location.href='?page=./cardapio/preparacao'>
                        <i class="fa fa-arrow-left" title="voltar"></i></button>
                    <span style="font-size:20px;">&nbsp;Preparação | Edição</span>
                    <button type="submit" name="bt_novo" class="btn botao_direita" title="salvar"><i class="fa fa-check"></i></button>
                    <a href="modulos/cardapio/rel_preparacao_ficha.php?id=<?=$v_cod?>" target='_blank'>
                        <img src='img/impvisu.png' width='20' title='listar preparações' class="botao_centro"/>
                    </a>
                </div>
            </div>
        </div>
        <!--
        EDICAO DE ESCOLAS
        -->
        <div id="id_form" class="container">
            <div class="col-md-2 col-xs-12">
                ID<br>
                <input type="text" name="txt_id" readonly class="form-control" value="<?php echo $v_cod ?>">
            </div>
            <div class="col-md-2 col-xs-12" style="display: none;">
                Tipo cardápio<br>
                <select name="txt_cardapio" class="form-control">
                    <?php while ($_tip = mysql_fetch_array($rs_tip)) {
                        if ($resulta['pre_tpescola']==$_tip['tpe_id']) {
                            $selected = 'selected';
                        } else {
                            $selected = '';
                        }
                        ?>
                        <option value="<?=$_tip['tpe_id']?>" <?php echo $selected; ?>><?=$_tip['tpe_tipoescola']?></option>
                    <?php } ?>
                </select>
            </div>
            <div class="col-md-2 col-xs-12">
                Data<br>
                <input type="date" name="txt_data" class="form-control" value="<?php echo $resulta['pre_data'] ?>">
            </div>
            <div class="col-md-2 col-xs-12">
                Tipo prepação<br>
                <select name="txt_tipo_prep" class="form-control">
                    <?php while ($_pre = mysql_fetch_array($rs_pre)) {
                        if ($resulta['pre_tppre']==$_pre['tpr_id']) {
                            $selected = 'selected';
                        } else {
                            $selected = '';
                        }
                        ?>
                        <option value="<?=$_pre['tpr_id']?>" <?php echo $selected; ?>><?=$_pre['tpr_tipo']?></option>
                    <?php } ?>
                </select>
            </div>
            <div class="col-md-6 col-xs-12">
                Nome preparação<br>
                <input type="text" name="txt_preparacao" id="txt_preparacao" class="form-control slm" value="<?php echo $resulta['pre_nmpreparacao'] ?>">
            </div>
            <div class="col-md-4 col-xs-12">
                Medida<br>
                <select name="txt_medida" class="form-control select2">
                    <?php while ($_med = mysql_fetch_array($rs_med)) {
                        if ($resulta['pre_medida_caseira']==$_med['med_id']) {
                            $selected = 'selected';
                        } else {
                            $selected = '';
                        }
                        ?>
                        <option value="<?=$_med['med_id']?>" <?php echo $selected; ?>><?=$_med['med_desc']?></option>
                    <?php } ?>
                </select>
            </div>
            <div class="col-md-4 col-xs-12">
                Modo de preparo
                <textarea rows="4" cols="5" name="txt_modo" class="form-control"><?php echo $resulta['pre_modopreparo'] ?></textarea>
            </div>
            <div class="col-md-4 col-xs-12">
                Observações
                <textarea rows="4" cols="5" name="txt_obs" class="form-control"><?php echo $resulta['pre_obs'] ?></textarea>
            </div>
        </div>
    </div>
</form>
<br>

<div class="container">
    <div class="panel with-nav-tabs panel-primary">
        <div class="panel-heading">
            Produtos da preparação
        </div>
        <div class="panel-body">
            <div class="tab-content">
                <!--ABA DOS PRODUTOS-->
                <form id="form1" name="form1" id="cad_produto" method="post" action="?page=./cardapio/prep_prod_crud&var_acao=cadastrar">
                    <div class="tab-pane" id="produtos">
                        <div class="panel panel-body panel-primary filterable">
                            <div class="col-md-2 col-xs-12">
                                ID Prep.<br>
                                <input type="text" name="txt_id_prep" readonly class="form-control" value="<?php echo $v_cod ?>">
                            </div>
                            <div class="col-md-5 col-xs-12">
                                Selecione o produto<br>
                                <select name="txt_produto" id="txt_produto" class="form-control select2">

                                    <option value="999" selected>Selecione uma opção</option>
                                    <?php while ($_prd = mysql_fetch_array($rs_prd)) {
                                        //SALDO PRODUTO
                                        $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 PRODUTO
                                        ?>
                                        <option
                                                value="<?php echo $_prd['pro_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 col-xs-12">
                                Per Capita
                                <input type="text" name="txt_percapta" class="form-control lm" required>
                            </div>
                            <div class="col-md-1 col-xs-12">
                                &nbsp;<br>
                                <button type='submit' name='bt_cad_prod' class='btn' title="Adiconar produto a preparação">
                                    <i class="fa fa-plus"></i>
                                </button>
                            </div>
                        </div>
                        <div class="">
                            <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>P.Cap.</th>
                                    <th>Kcal</th>
                                    <th>Carb.</th>
                                    <th>Prot.</th>
                                    <th>Lip.</th>
                                    <th>Fib.</th>
                                    <th>V.A</th>
                                    <th>V.C</th>
                                    <th>Cál.</th>
                                    <th>Fer.</th>
                                    <th>Mag.</th>
                                    <th>Zin.</th>
                                    <th>Sód.</th>
                                    <th></th>
                                </tr>
                                </thead>
                                <tbody>
                                <?php
                                    $vkcal = 0;
                                    $vcarb = 0;
                                    $vprot = 0;
                                    $vlipi = 0;
                                    $vfibr = 0;
                                    $vvita = 0;
                                    $vvitc = 0;
                                    $vcalc = 0;
                                    $vferr = 0;
                                    $vmagn = 0;
                                    $vzinc = 0;
                                    $vsodi = 0;
                                    
                                    while ($row_rsResult = mysql_fetch_array($rs_prdp)) {
                                        echo "<tr>";
                                        echo "<td>" . $row_rsResult['prd_id'] . "</td>";
                                        echo "<td>" . utf8_encode($row_rsResult['pro_produto']) . ' (' . $row_rsResult['prd_proid'] . ')' . "</td>";
                                        echo "<td>" . number_format($row_rsResult['prd_percapta'], 2, ',', '.') . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_energia'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_carboidrato'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_proteinas'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_lipidios'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_fibras'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_vitamina_a'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_vitamina_c'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_calcio'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_ferro'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_magnesio'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_zinco'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_sodio'], 2, ',', '.') * $row_rsResult['prd_percapta'] / 100 . "</td>";
                                        $cod_preprod = $row_rsResult['prd_id'];
                                        $cod_prepara = $row_rsResult['prd_preid'];

                                        //CALCULO DOS TOTAIS CENTESIMAIS
                                        $vkcal += $row_rsResult['prd_energia'] * $row_rsResult['prd_percapta']/100;
                                        $vcarb += $row_rsResult['prd_carboidrato'] * $row_rsResult['prd_percapta']/100;
                                        $vprot += $row_rsResult['prd_proteinas'] * $row_rsResult['prd_percapta']/100;
                                        $vlipi += $row_rsResult['prd_lipidios'] * $row_rsResult['prd_percapta']/100;
                                        $vfibr += $row_rsResult['prd_fibras'] * $row_rsResult['prd_percapta']/100;
                                        $vvita += $row_rsResult['prd_vitamina_a'] * $row_rsResult['prd_percapta']/100;
                                        $vvitc += $row_rsResult['prd_vitamina_c'] * $row_rsResult['prd_percapta']/100;
                                        $vcalc += $row_rsResult['prd_calcio'] * $row_rsResult['prd_percapta']/100;
                                        $vferr += $row_rsResult['prd_ferro'] * $row_rsResult['prd_percapta']/100;
                                        $vmagn += $row_rsResult['prd_magnesio'] * $row_rsResult['prd_percapta']/100;
                                        $vzinc += $row_rsResult['prd_zinco'] * $row_rsResult['prd_percapta']/100;
                                        $vsodi += $row_rsResult['prd_sodio'] * $row_rsResult['prd_percapta']/100;
                                        
                                        if ($direito=='1') {
                                            echo "<td><a href='?page=cardapio/prep_prod_crud&cod_preprod=$cod_preprod&cod_prep=$cod_prepara&var_acao=excluir'> <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 registro'/></a></td>";
                                        }
                                        echo "</tr>";
                                        
                                    }
                                
                                ?>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>
</div>
<!--TOTAIS-->
<div class="container panel-body">
    <div class="panel panel-primary">
        <div class="panel-heading">
            Totais da preparação
        </div>
        <div class="">
            <table class='table table-striped table-hover dt-responsive text-center' cellspacing='0' width='100%' border='0'>
                <thead>
                <tr>
                    <th class="text-center">Kcal</th>
                    <th class="text-center">Carb.</th>
                    <th class="text-center">Prot.</th>
                    <th class="text-center">Lip.</th>
                    <th class="text-center">Fib.</th>
                    <th class="text-center">V.A</th>
                    <th class="text-center">V.C</th>
                    <th class="text-center">Cál.</th>
                    <th class="text-center">Fer.</th>
                    <th class="text-center">Mag.</th>
                    <th class="text-center">Zin.</th>
                    <th class="text-center">Sód.</th>
                </tr>
                </thead>
                <tbody>
                <?php
                    while ($row_totais = mysql_fetch_array($rs_prdt)) {
                        echo "<tr>";
                        echo "<td>" . number_format($vkcal, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vcarb, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vprot, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vlipi, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vfibr, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vvita, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vvitc, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vcalc, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vferr, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vmagn, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vzinc, 2, ',', '.') . "</td>";
                        echo "<td>" . number_format($vsodi, 2, ',', '.') . "</td>";
                        echo "</tr>";
                    }
                ?>
                </tbody>
            </table>
        </div>
    </div>
</div>
<script src="js/select2.full.min.js"></script>
<script>
    $(function () {
        $(".select2").select2();
    });
</script>
</html>
Anon7 - 2022
AnonSec Team