| 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/mnova21/modulos/remessa/ |
Upload File : |
<?php
/**
* Criado por PhpStorm.
* Projeto: SGAE.
* Arquivo: remessaavulsa_edt.php.
* Usuário: RalpAlves
* Data: 28/05/2015
* Hora: 12:23
*/
session_start();
$_SESSION['txt_usuario'];
$id_usu_ent = $_SESSION['idusu'];
$direito = $_SESSION['admin'];
$cod_id = $_GET['cod_id'];
$s_prg = $_GET['s_prg'];
$vprograma = $_GET['vprograma'];
$rs_rema = mysql_query("SELECT * FROM v_lista_remessa_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_remessa_avulsa_item WHERE rai_ra_id='$cod_id' group by pro_id order by pro_produto");
$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_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 order by cdp_dtinic DESC");
$rs_car_s = mysql_query("SELECT * FROM cardapios_s order by cdp_id DESC");
$rs_kit = mysql_query("SELECT * FROM kit_tipo");
?>
<body>
<head>
<title> | Saldo</title>
<script type="text/javascript" language="javascript">
function ins_vali(codDat) {
var Dat = document.getElementById('vvali' + codDat).value;
$.ajax({
type: "GET", url: './modulos/remessa/remessa_muda_qtd.php?var=insvali&dat=' + Dat + '&codcon=' + codDat, dataType: "html", success: function (resultado) {
$('#LicDat').html(resultado);
//alert(resultado)
}
});
location.reload()
}
</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/remessaavulsa'">
<i class="fa fa-arrow-left" title="voltar"></i></button>
<span style="font-size:20px;"> Remessa Avulsa | 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/remessa/rel_ficha_remessa_avulsa.php?id=<?php echo $rs_rmav['ra_id'] ?>"
target='_blank'>
<i class="glyphicon glyphicon-print text-print navbar-right" style="font-size: 30px;" title="gerar PDF"></i>
</a>
<a href="?page=./remessa/remessaavulsa_cad"
target='_self'>
<i class="glyphicon glyphicon-floppy-disk text-print navbar-right" style="color: #e77e19; font-size: 30px;" title="Cadastrar outro cardápio simplificado"></i>
</a>
</div>
</div>
<div class="container">
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=editar">
<div class="col-md-2 col-xs-2 col-lg-2">
ID
<input style="color: black;" 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">
Data
<input style="color: black;" type="text" readonly 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">
Exercício
<input style="color: black;" type="text" name="txt_exercicio" value="<?php echo $rs_rmav['ra_exercicio'] ?>" readonly required class="form-control"
maxlength="4">
</div>
<div class="col-md-7 col-xs-7 col-lg-7">
Escola
<select style="color: black;" 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-2 col-xs-2 col-lg-2">
Período inicial
<input style="color: black;" 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">
Período final
<input style="color: black;" type="text" name="txt_perfinal" value="<?php echo $rs_rmav['ra_dtfim'] ?>" required onKeyup="formataData(this,event);" class="form-control" maxlength="10">
</div>
<!-- <form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=editar">-->
<input type="hidden" name="txt_id" value="<?php echo $rs_rmav['ra_id'] ?>">
<div class="col-md-5 col-xs-5 col-lg-5">
Programa
<select style="color: black;" name="txt_programa" class="form-control select2">
<?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'] . '-' . $_prg['prg_id']?></option>?>?>
<?php } ?>
</select>
</div>
<div class="col-md-3">
Mostrar Saldo
<select style="color: black;" name="txt_saldo_prg" class="form-control">
<?php if ($s_prg==1) { ?>
<option value="1" selected>Programa</option>
<option value="0">Geral</option>
<? } else { ?>
<option value="1">Programa</option>
<option value="0" selected>Geral</option>
<?php } ?>
</select>
</div>
<div class="col-md-11">
<label for="">Observação</label>
<textarea rows="2" cols="5" name="txt_obs" class="form-control"><?php echo $rs_rmav['ra_obs'] ?></textarea>
</div>
<div class="col-md-1">
<label for=""> </label>
<button type='submit' name='bt_cad_prod' class='btn input-sm' title="Alterar programa">
<i class="fa fa-check"></i>
</button>
</div>
</form>
</div>
<br>
<!--ITENS DA REMESSA-->
<div class="container">
<div class="panel with-nav-tabs panel-primary">
<div class="panel-heading">
Itens da remessa
</div>
<div class="container">
<div class="panel-body">
<div class=" panel-body">
<div class="col-md-12">
<!--INCLUIR ITENS DE UM CARDAPIO PADRAO-->
<div class="col-md-6">
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=add_item_cardapio">
<input type="hidden" name="id_rem" value="<?php echo $cod_id ?>">
<input type="hidden" name="e_card" value="1">
<input id="txt_programa" type="hidden" name="txt_programa" value="<?php echo $rs_rmav['ra_programa'] ?>">
<input id="s_prg" type="hidden" name="s_prg" value="<?php echo $rs_rmav['ra_tipo_saldo'] ?>">
<input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['ra_id'] ?>">
<input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['ra_data'] ?>">
<label>Incluir itens do cardápio padrão</label>
<select name="txt_cardapio" class="form-control select2">
<option value="99999" selected>Selecione um cardápio padrão</option>
<?php while ($_car = mysql_fetch_array($rs_car)) { ?>
<option value="<?php echo $_car['cdp_id'] ?>"><?php echo $_car['cdp_id'] . ' - ' . utf8_encode($_car['cdp_nmcardapio']) . ' (' . $_car['cdp_dtinic'] . ' a ' . $_car['cdp_dtfim'] . ')' ?></option>
<?php } ?>
</select>
<div class="col-md-1">
<label> </label>
<button type="submit" name="bt_novo" class="btn"><i class="fa fa-check" title="Incluir itens do cardapio padrão na remessa"></i></button>
</div>
</form>
</div>
<!--INCLUIR ITENS DE UM CARDAPIO SIMPLIFICADO-->
<div class="col-md-6">
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=add_item_cardapio_s">
<input type="hidden" name="id_rem" value="<?php echo $cod_id ?>">
<input type="hidden" name="e_card" value="1">
<input id="txt_programa" type="hidden" name="txt_programa" value="<?php echo $rs_rmav['ra_programa'] ?>">
<input id="s_prg" type="hidden" name="s_prg" value="<?php echo $rs_rmav['ra_tipo_saldo'] ?>">
<input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['ra_id'] ?>">
<input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['ra_data'] ?>">
<label>Incluir itens do cardápio simplificado</label>
<select name="txt_cardapio" class="form-control select2">
<option value="99999" selected>Selecione um cardápio simplificado</option>
<?php while ($_car = mysql_fetch_array($rs_car_s)) { ?>
<option value="<?php echo $_car['cdp_id'] ?>"><?php echo $_car['cdp_id'] . ' - ' . utf8_encode($_car['cdp_nmcardapio']) . ' (' . $_car['cdp_dtinic'] . ' a ' . $_car['cdp_dtfim'] . ')' ?></option>
<?php } ?>
</select>
<div class="col-md-1">
<label> </label>
<button type="submit" name="bt_novo" class="btn"><i class="fa fa-check" title="Incluir itens do cardapio simplificado na remessa"></i></button>
</div>
</form>
</div>
<!--<div class="panel-body"></div>-->
<!--INCLUIR ITENS DE UM KIT-->
<div class="col-md-6" hidden>
<form id="form2" name="ordcpr" id="cad_kit" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=add_item_kit">
<input type="hidden" name="id_rem" value="<?php echo $cod_id ?>">
<input type="hidden" name="e_card" value="1">
<input id="txt_programa" type="hidden" name="txt_programa" value="<?php echo $rs_rmav['ra_programa'] ?>">
<input id="s_prg" type="hidden" name="s_prg" value="<?php echo $rs_rmav['ra_tipo_saldo'] ?>">
<input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['ra_id'] ?>">
<input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['ra_data'] ?>">
<label>Incluir itens de um kit</label>
<select name="txt_kit" class="form-control select2">
<option value="99999" selected>Selecione um kit</option>
<?php while ($_kit = mysql_fetch_array($rs_kit)) { ?>
<option value="<?php echo $_kit['ktipo_id'] ?>"><?php echo $_kit['kit_desc'] ?></option>
<?php } ?>
</select>
<div class="col-md-1">
<label> </label>
<button type="submit" name="bt_novo" class="btn"><i class="fa fa-check" title="Incluir itens na remessa"></i></button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<div class="tab-content">
<form id="form1" name="form1" id="cad_produto" method="post" action="?page=./remessa/remessaavulsa_crud&var_acao=cad_item">
<div class=" panel-body panel-primary filterable">
<input id="txt_programa" type="hidden" name="txt_programa" value="<?php echo $rs_rmav['ra_programa'] ?>">
<input id="s_prg" type="hidden" name="s_prg" value="<?php echo $rs_rmav['ra_tipo_saldo'] ?>">
<input type="hidden" id="txt_id_rem" name="txt_id_rem" readonly class="form-control" value="<?php echo $rs_rmav['ra_id'] ?>">
<input type="hidden" id="txt_data_i" name="txt_data_i" readonly class="form-control" value="<?php echo $rs_rmav['ra_data'] ?>">
<div class="col-md-6">
<label for="">Incluir produtos individualmente</label>
<select name="txt_produto" id="txt_produto" onchange="CarregaUnidade(this.value);" class="form-control select2 select2-container--open">
<!-- <select name="txt_produto" id="txt_produto" class="form-control select2 select2-container--open">-->
<option value="999" selected>Selecione um produto</option>
<?php if ($s_prg==1) { ?>
<?php while ($_prd = mysql_fetch_array($rs_prd)) {
//SALDO POR PROGRAMA
$cod_prd = $_prd['pro_id'];
$rs_saldoe = mysql_query("SELECT * FROM v_l_saldo_entrada_programa_avulso WHERE ent_prg_id=$vprograma and pro_id=$cod_prd");
// $rs_saldoe = mysql_query("SELECT * FROM v_l_saldo_entrada_programa_avulso WHERE pro_id=$cod_prd");
$rs_saldos = mysql_query("SELECT * FROM v_l_saldo_saida_programa_avulso where ra_programa=$vprograma and rai_pro_id=$cod_prd");
$saldoe = mysql_fetch_array($rs_saldoe);
$saldos = mysql_fetch_array($rs_saldos);
$tosaldo = ($saldoe['entrada']) - ($saldos['saida']);
//SALDO POR PROGRAMA
?>
<option value="<?php echo $_prd['pro_id'] ?>|<?php echo $_prd['pro_unid_id'] ?>"><?php echo utf8_encode($_prd['pro_produto']) . ' (Saldo: ' . number_format($tosaldo, 2, ',', '.') . ')' ?></option>
<?php } ?>
<? } else { ?>
<?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 } ?>
<?php } ?>
</select>
</div>
<div class="col-md-2">
<label for="">Unidade</label>
<select id="txt_unidade" name="txt_unidade" class="form-control select2">
<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=""> </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>
</div>
</div>
<div class="panel panel-body panel-primary">
<form class='form-inline' id='frm1' name='frm1' id='cad_produto' method='post' action='?page=./remessa/remessaavulsa_crud&var_acao=edt_item_all'>
<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>Und.</th>
<!--<th class='direita' title="total de entradas NF">Entradas</th>-->
<th class='direita' title="saldo das entrafas NF">Saldo</th>
<!--<th class='direita' title="saldo do item na escola">Escola</th>-->
<th width="5%" title="quantidade da remessa (envio)">Quant.</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$esci = $rs_rmav['ra_escola'];
$w = 0;
while ($row_rsResult = mysql_fetch_array($rs_remi)) {
$desc_prod = $row_rsResult['pro_produto'];
$id_ite = $row_rsResult['rai_id'];
$id_rem = $rs_rmav['ra_id'];
$cod_pd = $row_rsResult['rai_pro_id'];
if ($rs_rmav['ra_tipo_saldo']==1) {
$rs_saldoe = mysql_query("SELECT * FROM v_l_saldo_entrada_programa_avulso WHERE ent_prg_id=$vprograma and pro_id=$cod_pd");
$rs_saldos = mysql_query("SELECT * FROM v_l_saldo_saida_programa_avulso where ra_programa=$vprograma and rai_pro_id=$cod_pd");
$saldoe = mysql_fetch_array($rs_saldoe);
$saldos = mysql_fetch_array($rs_saldos);
$tosal = ($saldoe['entrada']) - ($saldos['saida']);
} else {
$rs_entra = mysql_query("SELECT * FROM v_lista_saldo_entradas where pro_id=$cod_pd");
$entra = mysql_fetch_array($rs_entra);
$rs_perca = mysql_query("SELECT * FROM v_saldo_percas where imi_codprod=$cod_pd");
$s_per = mysql_fetch_array($rs_perca);
$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'] + $s_per['quantidade']);
}
echo "<tr>";
echo "<td>" . $row_rsResult['rai_id'] . "</td>";
echo "<td>" . utf8_encode($row_rsResult['pro_produto']) . '-' . $row_rsResult['rai_pro_id'] . "</td>";
echo "<td>" . $row_rsResult['und_desc'] . "</td>";
//ENTRADAS
// echo "<td class='direita' style='color: darkgreen; font-weight: bold;'>" . number_format($toent, 2, ',', '.') . "</td>";
if ($tosal >= 0) {
echo "<td class='direita' style='color: blue; font-weight: bold;'>" . number_format($tosal, 2, ',', '.') . "</td>";
} else {
echo "<td class='direita danger' style='color: red; font-weight: bold; border-color: darkred;'>" . number_format($tosal, 2, ',', '.') . "</td>";
}
//saldo do item na escola
//echo "<td class='direita' style='color: #a5570f; font-weight: bold;'>" . number_format($saldo_e, 2, ',', '.') . "</td>";
$qtd_e = number_format($row_rsResult['rai_quant'], 2);
//$qtd_e = str_replace('.', ',', $row_rsResult['rai_quant']);
//$qtd_e = $row_rsResult['rai_quant'];
//$qtd_e = $row_rsResult['rai_quant'];
if ($direito=='1') {
$txt_programa = $rs_rmav['ra_programa'];
$s_prg = $rs_rmav['ra_tipo_saldo'];
$id_item = $row_rsResult['rai_id'];
echo "
<input type='hidden' name='txt_id_item$w' value='$id_item'/>
<input type='hidden' name='txt_id_rem$w' value='$id_rem'/>
<input type='hidden' name='txt_programa$w' value='$txt_programa'/>
<input type='hidden' name='s_prg$w' value='$s_prg'/>
<td class='direita input-group-btn'>
<input type='text' title='utilize ponto para informar decimais.' name='txt_qtdrem$w' value='$qtd_e' class='form-control' style='color: black;'>
</td>
";
echo "<td><a href='?page=remessa/remessaavulsa_crud&id_rem=$id_rem&id_ite=$id_ite&var_acao=exc_item&s_prg=$s_prg&txt_programa=$txt_programa'>
<em class='fa fa-trash text-red' title='Excluir registro' onclick='excluir_registro(event);'/></a></td>";
} else {
echo "<td class='direita'>" . $qtd_e . "</td>";
echo "<td><a href='#'><img src='img/not.png' width='17' title='sem permissão para excluir o registro'/></a></td>";
}
$w++;
}
echo "<input type='hidden' name='tamanho' value='$w' />"
?>
</tbody>
</table>
</form>
<!--BOTA SALVAR TODOS OS ITENS DA REMESSA-->
<div class='com-md-12 botao_centro'>
<button type="submit" class="btn-primary input-sm col-md-12" value="Salvar remessa" title="Salvar itens da remessa" onclick="$('#frm1').submit()">
<i class="fa fa-check"></i> Salvar itens da remessa
</button>
</div>
</div>
</div>
<script type="text/javascript" language="javascript">
function CarregaUnidade(codCon) {
$.ajax({
type: "GET", url: './modulos/remessa/cb_unidade.php?id_cod=' + codCon,
dataType: "html",
success: function (resultado) {
$('#txt_unidade').html(resultado);
}
});
}
</script>
</body>