| 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/apuiares/modulos/transferencia/ |
Upload File : |
<?php
/**
* Criado por PhpStorm.
* Projeto: SGAE.
* Arquivo: saidaavulsa_edt.php.
* Usuário: RalpAlves
* Data: 15/10/2015
* Hora: 14:14
*/
session_start();
$idusu = $_SESSION['idusu'];
$treina_escola = $_SESSION['treina_escola'];
$cod_id = $_GET['cod_id'];
$cod_esc = $_GET['cod_esc'];
$rs_rema = mysql_query("SELECT * FROM v_lista_esc_saida_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_esc_saida_avulsa_item WHERE rai_ra_id=$cod_id order by rai_id");
$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_prod WHERE pro_tipo='1' order by pro_produto");
$rs_prd = mysql_query("SELECT * FROM v_lista_produtos_remessa_avulsa_escolas WHERE esc_id=$cod_esc");
$rs_und = mysql_query("SELECT * FROM unidade where und_ativo='1'");
?>
<head xmlns="http://www.w3.org/1999/html">
</head>
<!--FORM DE SOLICITACAO-->
<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=transferencia/saidaavulsa'"><span class="glyphicon
glyphicon-arrow-left" title="voltar"/></button>
<span style="font-size:20px;"> Transferência origem | Edição </span>
<!--<button type="submit" name="bt_novo" class="btn botao_direita"><i class="fa fa-check" title="salvar"></i> Salvar</button>-->
<a href="modulos/transferencia/rel_ficha_transferencia.php?id=<?php echo $rs_rmav['ra_id'] ?>&just=<?php echo $rs_rmav['ra_preparo'] ?>"
target='_blank'>
<img src='img/impvisu.png' width='20' title='Imprimir transferência' align='right' />
</a>
</div>
</div>
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=editar">
<div class="container panel panel-primary panel-body">
<div class="container panel-body">
<div class="col-md-2 col-xs-2 col-lg-2">
<label for="">ID</label>
<input 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">
<label for="">Data</label>
<input type="text" 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">
<label for="">Exercício</label>
<input type="text" name="txt_exercicio" value="<?php echo $rs_rmav['ra_exercicio'] ?>" readonly required class="form-control"
maxlength="4">
</div>
<div class="col-md-4 col-xs-4 col-lg-4">
<label for="">Escola</label>
<select 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-3 col-xs-3 col-lg-3">
<label for="">Programa</label>
<select name="txt_programa" class="form-control">
<?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']?></option>?>?>
<?php } ?>
</select>
</div>
</div>
<div class="container">
<!-- <div class="col-md-2 col-xs-2 col-lg-2">-->
<!-- <label for="">Período inicial</label>-->
<!-- <input 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">-->
<!-- <label for="">Período final</label>-->
<!-- <input type="text" name="txt_perfinal" value="--><?php //echo $rs_rmav['ra_dtfim'] ?><!--" required onKeyup="formataData(this,event);" class="form-control" maxlength="10">-->
<!-- </div>-->
<!-- <div class="col-md-1 col-xs-12 col-lg-1" title="quantidade de alunos atendidos">-->
<!-- <label for="">Alunos</label>-->
<!-- <input type="text" name="txt_alunos" value="--><?php //echo $rs_rmav['ra_alunos_atendidos'] ?><!--" required class="form-control" maxlength="10">-->
<!-- </div>-->
<div class="col-md-7 col-xs-12 col-lg-7">
<label for="">Justificativa:</label>
<textarea rows="2" cols="5" name="txt_preparo" required class="form-control"><?php echo $rs_rmav['ra_preparo'] ?></textarea>
</div>
</div>
</div>
</form>
<!--ITENS DA REMESSA-->
<div class="container">
<div class="panel panel-primary">
<div class="panel-heading">
Itens da transferência
</div>
<div class="panel-body">
<div class="tab-content">
<form id="form1" name="form1" onsubmit="javascript:showCarga();" id="cad_produto" method="post" action="?page=./transferencia/saidaavulsa_crud&var_acao=cad_item">
<div>
<div class="panel panel-body panel-primary">
<div class="col-md-1 col-xs-1 col-lg-1 ">
ID<br>
<input type="text" name="txt_id_rem" readonly class="form-control input-sm" value="<?php echo $rs_rmav['ra_id'] ?>">
</div>
<div class="col-md-1 col-xs-1 col-lg-1 ">
Escola<br>
<input type="text" name="txt_esc_id" readonly class="form-control input-sm" value="<?php echo $rs_rmav['ra_escola'] ?>">
</div>
<div class="col-md-1 col-xs-1 col-lg-1" style="display: none;">
Data<br>
<input type="text" name="txt_data_i" readonly class="form-control input-sm" value="<?php echo $rs_rmav['ra_data'] ?>">
</div>
<div class="col-md-5 col-xs-5 col-lg-5 ">
Produto<br>
<select name="txt_produto" onchange="CarregaUnidade(this.value);" id="txt_produto" class="form-control input-sm select2">
<option value="999" selected>Selecione uma opção</option>
<?php while ($_prd = mysql_fetch_array($rs_prd)) { ?>
<option
value="<?php echo $_prd['pro_id'] ?>|<?php echo $_prd['pro_unid_id'] ?>"><?php echo utf8_encode($_prd['pro_produto']) ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2 col-xs-2 col-lg-2 ">
unidade
<select id="txt_unidade" name="txt_unidade" class="form-control input-sm">
<option value="999" selected>Selecione</option>
<?php while ($_und = mysql_fetch_array($rs_und)) { ?>
<option value="<?=$_und['und_id']?>"><?=utf8_encode($_und['und_desc']) . '-' . $_und['und_id']?></option>
<?php } ?>
</select>
</div>
<div class="col-md-1 col-xs-1 col-lg-1 ">
Quantidade
<input type="text" name="txt_qtd" autofocus class="form-control lm input-sm" required onKeyup="formataValor(this,event);" required>
</div>
<div class="col-md-1 col-xs-1 col-lg-1 ">
<br>
<button type='submit' onsubmit="javascript:showCarga();" name='bt_cad_prod' class='btn input-sm' title="Adiconar produto">
<i class="fa fa-check" title="salvar"></i>
</button>
</div>
</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>Quantidade</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
while ($row_rsResult = mysql_fetch_array($rs_remi)) {
echo "<tr>";
echo "<td>" . $row_rsResult['rai_id'] . "</td>";
echo "<td>" . utf8_encode($row_rsResult['pro_produto']) . "</td>";
echo "<td>" . date('d/m/Y', strtotime($row_rsResult['rai_data'])) . "</td>";
echo "<td>" . $row_rsResult['und_desc'] . "</td>";
echo "<td>" . number_format($row_rsResult['rai_quant'], 2, ',', '.') . "</td>";
$id_ite = $row_rsResult['rai_id'];
$id_rem = $rs_rmav['ra_id'];
$cod_esc = $rs_rmav['ra_escola'];
$prd = utf8_encode($row_rsResult['pro_produto']);
echo "<td><a href='?page=transferencia/saidaavulsa_crud&id_rem=$id_rem&id_ite=$id_ite&cod_esc=$cod_esc&var_acao=exc_item'>
<em class='fa fa-trash text-red text-red' title='Excluir registro' onclick='excluir_registro(event);'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<script type="text/javascript" language="javascript">
function CarregaUnidade(codCon) {
$.ajax({
type: "GET", url: './modulos/transferencia/cb_unidade.php?id_cod=' + codCon,
dataType: "html",
success: function (resultado) {
$('#txt_unidade').html(resultado);
}
});
}
</script><script src="js/select2.full.min.js"></script>
<script>
$(function () {
$(".select2").select2();
});
</script>