| 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/vicosa25/modulos/almoxarifado/ |
Upload File : |
<?php
/**
* Criado por PhpStorm.
* Projeto: SGAE.
* Arquivo: entrada_edt.php.
* Usuário: RalpAlves
* Data: 25/09/2015
* Hora: 12:40
*/
$_SESSION['txt_usuario'];
$id_usu_ent = $_SESSION['idusu'];
$direito = $_SESSION['admin'];
$cod_id = $_GET['cod_id'];
$rsResult = mysql_query("SELECT * FROM v_lista_entrada where ent_id=$cod_id");
$row = mysql_fetch_array($rsResult);
$rsItens = mysql_query("SELECT * FROM v_lista_entrada_itens where aei_ent_id=$cod_id");
$ioc = mysql_fetch_array($rsResult);
$rs_prd = mysql_query("SELECT * FROM produtos WHERE pro_tipo=1 order by pro_produto");
$rs_und = mysql_query("SELECT * FROM unidade where und_ativo='1'");
$rs_prg = mysql_query("SELECT * FROM programa order by prg_programa");
$rs_for = mysql_query("SELECT * FROM pessoas order by pes_pessoa");
?>
<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": "<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>
<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" language="javascript">
function ins_lote(codCon) {
var Qtd = document.getElementById('vlote' + codCon).value;
$.ajax({
type: "GET", url: './modulos/almoxarifado/entrada_insnf.php?var=inslote&qtd=' + Qtd + '&codcon=' + codCon, dataType: "html", success: function (resultado) {
$('#LicCont').html(resultado);
//alert(resultado)
}
});
}
</script>
<script type="text/javascript" language="javascript">
function ins_vali(codDat) {
var Dat = document.getElementById('vvali' + codDat).value;
$.ajax({
type: "GET", url: './modulos/almoxarifado/entrada_insnf.php?var=insvali&dat=' + Dat + '&codcon=' + codDat, dataType: "html", success: function (resultado) {
$('#LicDat').html(resultado);
//alert(resultado)
}
});
}
</script>
<script type="text/javascript" language="javascript">
function atu_nf(codDat) {
$.ajax({
type: "GET", url: './modulos/almoxarifado/entrada_insnf.php?var=atunf&codcon=' + codDat, dataType: "html", success: function (resultado) {
$('#Licnf').html(resultado);
//location.reload ();
//alert (resultado)
}
});
}
</script>
<script>
function cont() {
var conteudo = document.getElementById('print').innerHTML;
tela_impressao = window.open('about:blank');
tela_impressao.document.write(conteudo);
tela_impressao.window.print();
tela_impressao.window.close();
}
</script>
</head>
<div id="print" class="container">
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="panel-title">
<a href="?page=almoxarifado/entrada_p" title="voltar"><i class="fa fa-arrow-left fa-2x"></i></a>
<span style="font-size:20px;"> NF Ordem nº: </span><strong style="font-size: 25px;"><?php echo $row['ent_nf'] ?></strong>
<a href="modulos/almoxarifado/rel_entrada_ficha.php?id=<?=$cod_id?>" target='_blank'>
<i class="glyphicon glyphicon-print text-print navbar-right" title="gerar PDF"></i>
</a>
</h3>
</div>
<div class="row">
<div class=" col-md-12 col-lg-12 col-xs-12">
<table class="table table-user-information">
<tbody>
<tr>
<td id="id_num"><b>ID:</b></td>
<?php echo "<td class='text-green'>" . $row['ent_id'] . "</td>" ?>
<td><b>Período:</b></td>
<?php echo "<td class='text-orange' title='período de pesquisa da ordem de compra'>" . $row['per_inicial'] . ' a ' . $row['per_final'] . "</td>" ?>
<!----><?php //echo "<td>" . $row['cpl_numproc_lic'] . "</td>" ?>
</tr>
<tr>
<td><b>Programa:</b></td>
<?php echo "<td class='text-green'>" . $row['prg_programa'] . "
<a hidden href=\"#anda\" onclick=\"Mudarestado('edt_prg')\" class=\"link\" title=\"Alterar programa\">
<i class='fa fa-pencil text-green_grid'></i></a></h4>" ?>
<div id='edt_prg' style="display: none;">
<form id="form2" name="form2" OnSubmit="showCarga()" id="frm_editar_nf" method="post" action="?page=./almoxarifado/entrada_crud&var_acao=editar_prg">
<input type="hidden" name="id_nf" value="<?php echo $row['ent_id'] ?>">
<input type="hidden" name="ent_nf" value="<?php echo $row['ent_nf'] ?>">
<div class='col-xs-6 col-sm-6 com-md-6 col-lg-6'>
<label>Alterar programa</label>
<select name="txt_programa" class="form-control">
<option value="999" selected>Selecione uma opção</option>
<?php while ($_prg = mysql_fetch_array($rs_prg)) { ?>
<option value="<?=$_prg['prg_id']?>"><?=utf8_encode($_prg['prg_programa'])?></option>
<?php } ?>
</select>
</div>
<div class='col-xs-2 col-sm-2 com-md-2 col-lg-2'>
<label> </label>
<button type="submit" name="bt_novo" class="btn form-control">
<i class="fa fa-check"></i>
</button>
</div>
</form>
</div>
<td><b> </b></td>
<td><b> </b></td>
<!-- --><?php //echo "<td>" . $row['odc_numordcomp'] . "</td>" ?>
</tr>
<tr>
<td><b>Fornecedor:</b></td>
<?php echo "<td class='text-green'>" . utf8_encode($row['pes_pessoa']) . "
<a hidden href=\"#anda\" onclick=\"Mudarestado('edt_for')\" class=\"link\" title=\"Alterar fornecedor\">
<i class='fa fa-pencil text-green_grid'></i></a></h4></td>" ?>
<div id='edt_for' style="display: none;">
<form id="form2" name="form2" OnSubmit="showCarga()" id="frm_editar_for" method="post" action="?page=./almoxarifado/entrada_crud&var_acao=editar_for">
<input type="hidden" name="id_nf" value="<?php echo $row['ent_id'] ?>">
<input type="hidden" name="ent_nf" value="<?php echo $row['ent_nf'] ?>">
<div class='col-xs-6 col-sm-6 com-md-6 col-lg-6'>
<label>Alterar fornecedor</label>
<select name="txt_fornecedor" class="form-control" onchange="cb_programa(this.value);">
<option value="999" selected>Selecione uma opção</option>
<?php while ($_for = mysql_fetch_array($rs_for)) { ?>
<option value="<?=$_for['pes_id']?>"><?=utf8_encode($_for['pes_pessoa'])?></option>
<?php } ?>
</select>
</div>
<div class='col-xs-2 col-sm-2 com-md-2 col-lg-2'>
<label> </label>
<button type="submit" name="bt_novo" class="btn form-control">
<i class="fa fa-check"></i>
</button>
</div>
</form>
</div>
<td><b>Emissao:</b></td>
<?php echo "<td class='text-green'>" . utf8_encode($row['ent_nfdtemissao']) . "<a href='#' onclick='Mudarestado(\"edt_emissao\")' class='link' title='editar data de emissão da nota fiscal'>
<i class='fa fa-pencil text-green_grid'></i></a ></h4>
</td>" ?>
<div id='edt_emissao' style="display: none;">
<form id="form2" name="form2" OnSubmit="showCarga()" id="frm_editar_nf" method="post" action="?page=./almoxarifado/entrada_crud&var_acao=editar_emissao_p">
<input type="hidden" name="id_nf" value="<?php echo $row['ent_id'] ?>">
<input type="hidden" name="ent_nf" value="<?php echo $row['ent_nf'] ?>">
<div class='col-xs-2 col-sm-2 com-md-2 col-lg-2'>
<label>Editar emissão</label>
<input type="text" name="ent_nfdtemissao" required class="form-control" value="<?php echo $row['ent_nfdtemissao'] ?>" onkeyup="formataData(this,event);">
</div>
<div class='col-xs-2 col-sm-2 com-md-2 col-lg-2'>
<label> </label><br>
<button type="submit" name="bt_novo" class="btn">
<i class="fa fa-check"></i>
</button>
</div>
</form>
</div>
</tr>
<tr>
<td><b>Data:</b></td>
<?php echo "<td class='text-green'>" . utf8_encode($row['ent_data']) . "<a href='#' onclick='Mudarestado(\"edt_dat_cad\")' class='link' title='editar data de cadastro nota fiscal'>
<i class='fa fa-pencil text-green_grid'></i></a ></h4></td>" ?>
<div id='edt_dat_cad' style="display: none;">
<form id="form2" name="form2" OnSubmit="showCarga()" id="frm_editar_nf" method="post" action="?page=./almoxarifado/entrada_crud&var_acao=editar_data_cad_p">
<input type="hidden" name="id_nf" value="<?php echo $row['ent_id'] ?>">
<input type="hidden" name="ent_nf" value="<?php echo $row['ent_nf'] ?>">
<div class='col-xs-2 col-sm-2 com-md-2 col-lg-2'>
<label>Editar Data</label>
<input type="text" name="ent_data" required class="form-control" value="<?php echo $row['ent_data'] ?>" onkeyup="formataData(this,event);">
</div>
<div class='col-xs-2 col-sm-2 com-md-2 col-lg-2'>
<label> </label><br>
<button type="submit" name="bt_novo" class="btn">
<i class="fa fa-check"></i>
</button>
</div>
</form>
</div>
<td><b>Valor NF:</b></td>
<?php echo "<td class='text-green'>" . number_format($row['ent_vrnf'], 2, ',', '.') . "
<a href=\"#anda\" onclick=\"Mudarestado('edt_nf')\" class=\"link\" title=\"editar valor da nota fiscal\">
<i class='fa fa-pencil text-green_grid'></i></a>" ?>
<div id='edt_nf' style="display: none;">
<form id="form2" name="form2" OnSubmit="showCarga()" id="frm_editar_nf" method="post" action="?page=./almoxarifado/entrada_crud&var_acao=editar_vlr_p">
<input type="hidden" name="id_nf" value="<?php echo $row['ent_id'] ?>">
<input type="hidden" name="ent_nf" value="<?php echo $row['ent_nf'] ?>">
<div class='col-xs-4 col-sm-4 com-md-4 col-lg-4'>
<label>Editar valor</label>
<input type="text" name="ent_nf" required class="form-control" onkeyup="formataValor(this,event);" value="<?php echo number_format($row['ent_vrnf'], 2, ',', '.') ?>">
</div>
<div class='col-xs-2 col-sm-2 com-md-2 col-lg-2'>
<label> </label>
<button type="submit" name="bt_novo" class="btn">
<i class="fa fa-check"></i>
</button>
</div>
</form>
</div>
</tr>
</tbody>
</table>
</div>
</div>
</div>
<!--ITENS DA IMPLANTAÇÃO-->
<div class="panel panel-primary">
<div class="panel-heading">
Itens da NF
</div>
<div class="panel-body">
<form id="form1" name="form1" id="cad_produto" method="post" action="?page=./almoxarifado/entrada_crud&var_acao=cad_item_p">
<div class="panel panel-body panel-primary filterable">
<input type="hidden" name="txt_programa" value="<?php echo $rs_row['imp_programa'] ?>">
<input type="hidden" name="data" value="<?php echo $row['ent_data'] ?>">
<input type="hidden" name="pip_prg" value="<?php echo $row['prg_programa'] ?>">
<input type="hidden" name="nf_ent_id" readonly class="form-control" value="<?php echo $row['ent_id'] ?>">
<div class="col-md-5 col-xs-5 col-lg-5 ">
Selecione o produto<br>
<select name="oci_item_id" id="oci_item_id" class="form-control">
<?php while ($_prd = mysql_fetch_array($rs_prd)) { ?>
<option
value="<?php echo $_prd['pro_id'] ?>"><?php echo utf8_encode($_prd['pro_produto']) . '-' . $_prd['pro_id'] ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2 col-xs-2 col-lg-2 ">
unidade
<select name="oci_unid" class="form-control">
<?php while ($_und = mysql_fetch_array($rs_und)) {
if ($resulta['pro_unid_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 col-xs-2 col-lg-2 ">
Quantidade
<input type="text" name="oci_quant" autofocus class="form-control lm" onkeyup="formataDouble(this,event);" required>
</div>
<div class="col-md-2 col-xs-2 col-lg-2 ">
Vlr. Unitário
<input type="text" name="oci_vrunit" class="form-control lm" required onKeyup="formataValor(this,event);">
</div>
<div class="col-md-1 col-xs-1 col-lg-1 ">
<br>
<button type='submit' name='bt_cad_prod' class='btn' title="Adiconar produto a preparação">
<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>Unid.</th>
<th class="text-right">Quant.</th>
<th class="text-right">Vlr. Unit.</th>
<th class="text-right">Total</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$stotal==0;
while ($r = mysql_fetch_array($rsItens)) {
echo "<tr>";
echo "<td>" . $r['aei_id'] . "</td>";
echo "<td>" . utf8_encode($r['pro_produto'] . '-' . $r['aei_pro_id']) . "</td>";
echo "<td>" . $r['und_desc'] . "</td>";
echo "<td class=\"text-right\">" . number_format($r['aei_pro_qtd'], 0, ',', '.') . "</td>";
echo "<td class=\"text-right\">" . number_format($r['aei_pro_vrunit'], 2, ',', '.') . "</td>";
echo "<td class=\"text-right\">" . number_format($r['total'], 2, ',', '.') . "</td>";
$cod_id = $r['aei_id'];
$cod_nf = $row['ent_id'];
$stotal += $r['total'];
if ($direito=='1') {
echo "<td><a href='?page=almoxarifado/entrada_crud&cod_id=$cod_id&cod_nf=$cod_nf&var_acao=excluir_item_p'>
<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 class='col-xs-12 col-sm-12 com-md-12 col-lg-12'>
<div class="col-xs-4 col-sm-4 com-md-4 col-lg-4">
<h4><span><?php echo 'Total Nota: R$ ' . number_format($row['ent_vrnf'], 2, ',', '.'); ?></span></h4>
</div>
<div class="col-xs-4 col-sm-4 com-md-4 col-lg-4">
<h4><span><?php echo 'Total itens: R$ ' . number_format($stotal, 2, ',', '.'); ?></span></h4>
</div>
<div class="col-xs-4 col-sm-4 com-md-4 col-lg-4">
<?php
$soma = abs($row['ent_vrnf'] - ($stotal));
if (number_format($row['ent_vrnf'], 2, ',', '.')!=number_format($stotal, 2, ',', '.')) { ?>
<h4><span style="color: red;">Verificar totais
<i style="color: black; font-size: 22px;"> ≠ </i>
<?php echo number_format($soma, 2, ',', '.') ?>
</span>
</h4>
<?php } else { ?>
<h4><span style="color: green;">TOTAIS OK</span></h4>
<?php } ?>
</div>
</div>
</div>
</form>
</div>
</div>
</div>