| 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/ajuste/modulos/escola_almox/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 16/10/2015
* Time: 14:45
*/
session_start();
$idusu = $_SESSION['idusu'];
$cod_id = $_GET['cod_id'];
$rs_rema = mysql_query("SELECT * FROM v_lista_escola_saida 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_escola_saida_item WHERE rmi_rms_id=$cod_id");
$rs_esc = mysql_query("SELECT * FROM escolas where esc_id in(select id_entidade from usuarios_ent where usu_id = '$idusu') 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'];
$rs_alu = mysql_query("SELECT DISTINCT prg_id,prg_programa,esc_id,qtd_alunos FROM v_lista_escolas_programas where prg_id=$rs_pid");
$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_car = mysql_query("SELECT * FROM v_lista_escola_rem_cardapio where esc_id in(select id_entidade from usuarios_ent where usu_id = '$idusu') order by cdp_nmcardapio,cdp_dtinic");
$per = $rs_rmav['rms_dtfim'] - $rs_rmav['rms_dtinic'];
?>
<head xmlns="http://www.w3.org/1999/html">
<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": "<<",
"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>
<script type="text/javascript" language="javascript">
function ins_qtd(codCon) {
var Qtd = document.getElementById('vlote' + codCon).value;
$.ajax({
type: "GET", url: './modulos/escola_almox/entrada_insnf.php?var=insqtd&qtd=' + Qtd + '&codcon=' + codCon, dataType: "html", success: function (resultado) {
$('#LicCont').html(resultado);
//alert(resultado)
}
});
}
</script>
<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>
</head>
<div class="container panel panel-primary">
<div class="panel-body">
<button id="#sign-up" name="bt_novo" class="btn" onClick="location.href='?page=escola_almox/saida'"><span class="glyphicon
glyphicon-arrow-left" title="voltar"/></button>
<span style="font-size:20px;"> Saída cardápio | Itens </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.php?id=<?php /*echo $rs_rmav['rms_id'] */ ?>"
target='_blank'>
<img src='img/impvisu.png' width='20' title='Imprimir remessa' align='right'/>
</a>-->
</div>
</div>
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessa_crud&var_acao=editar">
<div class="container panel panel-primary panel-body">
<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" name="txt_data" readonly 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" 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">
<?php while ($_car = mysql_fetch_array($rs_car)) {
if ($rs_rmav['rms_cdp_id']==$_car['cdp_id']) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option
value="<?=$_car['cdp_id']?>" <?php echo $selected; ?>><?=utf8_encode($_car['cdp_nmcardapio'])?></option>?>?>
<?php } ?>
</select>
</div>
<div class="col-md-2 col-xs-2 col-lg-2">
Período inicial
<input type="text" name="txt_perinicial" 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" 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">
<?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">
<?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'] . ' - alunos: ' . $_prg['qtd_alunos']?></option>?>?>
<?php } ?>
</select>
</div>
</div>
</form>
<!--ITENS DA REMESSA-->
<div class="container">
<div class="panel with-nav-tabs panel-primary">
<div class='panel-heading'>Itens da remessa | Alunos atendidos: <?php echo $alunos['qtd_alunos'] . ' | Dias: ' . $per ?></div>
<div class="panel-body">
<div class="tab-content">
<div>
<div class="panel panel-body panel-primary">
<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>Data</th>
<th>Unidade</th>
<th>Natureza</th>
<!--<th>Per capta</th>
<th>Dias</th>-->
<th>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'];
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>" . date('d/m/Y', strtotime($row_rsResult['rmi_data'])) . "</td>";
echo "<td>" . $row_rsResult['und_desc'] . "</td>";
echo "<td>" . $row_rsResult['nat_desc'] . "</td>";
/*echo "<td>" . number_format($row_rsResult['rmi_percapta'], 2, ',', '.') . "</td>";
echo "<td>" . $dias . "</td>";*/
$cod_id = $row_rsResult['rmi_id'];
$tot_qtd = $row_rsResult['rmi_pro_qtd'];
echo "<td width='70px'>
<input type='text' value='$tot_qtd' onblur='ins_qtd($cod_id);' onkeyup='formataValor(this,event);' required name='txt_lote' id='vlote" . $cod_id . "'
class='form-control input-xs'>
</td>";
$v_percapta = $row_rsResult['prd_percapta'];
$v_alunos = $alunos['qtd_alunos'];
$v_dias = $dias;
$totalq = $v_percapta * $v_alunos / $v_dias;
$id_ite = $row_rsResult['rmi_id'];
$id_rem = $rs_rmav['rms_id'];
echo "<td><a href='?page=escola_almox/saida_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>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
<!--<div id="bt_add" class="col-md-7 col-xs-7 col-lg-7">
<a href="?page=escola_almox/saida_crud&id_rem=<?php /*echo $id_rem */ ?>&v_alunos=<?php /*echo $v_alunos */ ?>&v_dias=<?php /*echo $v_dias */ ?>&var_acao=proc_rem"
type="submit" name="bt_novo" class="btn
btn-primary
navbar-right"><i class="fa fa-check" title="salvar"></i> Processar saída de produtos</a>
</div>-->
</div>
</div>
</div>
</div>