| 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/vicosa23/modulos/cardapio/ |
Upload File : |
<?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;"> 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">
<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
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'], 4, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_energia'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_carboidrato'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_proteinas'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_lipidios'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_fibras'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_vitamina_a'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_vitamina_c'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_calcio'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_ferro'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_magnesio'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_zinco'], 2, ',', '.') . "</td>";
echo "<td style='font-size: 10px;'>" . number_format($row_rsResult['prd_sodio'], 2, ',', '.') . "</td>";
$cod_preprod = $row_rsResult['prd_id'];
$cod_prepara = $row_rsResult['prd_preid'];
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" hidden>
<div class="panel panel-primary">
<div class="panel-heading">
Totais da preparação
</div>
<div class="">
<table class='tabe1 table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr>
<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>
</tr>
</thead>
<tbody>
<?php
while ($row_totais = mysql_fetch_array($rs_prdt)) {
echo "<tr>";
echo "<td>" . number_format($row_totais['energia'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['carboidrato'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['proteina'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['lipidio'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['fibra'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['vit_a'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['vit_c'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['calcio'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['ferro'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['magnesio'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['zinco'], 2, ',', '.') . "</td>";
echo "<td>" . number_format($row_totais['sodio'], 2, ',', '.') . "</td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
<script src="js/select2.full.min.js"></script>
<script>
$(function () {
$(".select2").select2();
});
</script>
</html>