| 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/aracoiaba21/modulos/licitacao/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 04/03/15
* Time: 14:02
*/
$cod_lic = $_GET['cod_lic'];
mysql_select_db($banco, $conexao);
$rs_sql = mysql_query("select * from v_lista_licitacao where cpl_id = $cod_lic") or die('Erro ao selecionar (licitacao_edt.php #12)' . mysql_error());
$resulta = mysql_fetch_array($rs_sql);
//Lista fornecedores da licitação
$rsforn = mysql_query("SELECT * from v_lista_licitacao_forn where plf_cpl_id = $cod_lic ");
$rsLinhas = mysql_num_rows($rsforn);
//tabelas auxiliares
$rs_org = mysql_query("SELECT * FROM und_gest_orgao order by org_nome_orgao");
$rs_uno = mysql_query("SELECT * FROM und_gest_uo order by uo_nome");
$rs_tlic = mysql_query("SELECT * FROM tipolicitacao order by tpl_id");
$rs_mod = mysql_query("SELECT * FROM modalidade order by mod_id");
$rs_for = mysql_query("SELECT * FROM pessoas order by pes_pessoa");
$rs_prd = mysql_query("SELECT * FROM produtos order by pro_produto");
$rs_und = mysql_query("SELECT * FROM unidade order by und_desc");
$rs_mrc = mysql_query("SELECT * FROM marca order by mrc_id");
$rs_sim = mysql_query("SELECT * FROM confirma order by sn_confirma");
$rs_adt = mysql_query("SELECT * FROM tipoaditivo order by adt_desc");
?>
<head id="Head1">
<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>
function m_div(el) {
var display = document.getElementById(el).style.display;
if (display == "none")
document.getElementById(el).style.display = 'block'; else
document.getElementById(el).style.display = 'none';
}
</script>
<!--USO: <button type="submit" name="bt_novo" title="Adicionar item" class="btn btn-primary btn-xs" onclick="m_div('id_form')"><i class="fa fa-check" title="salvar"></i></button>-->
</head>
<!--FORM DE LICITACAO-->
<form id="form1" name="form1" id="cad_sol" method="post" action="?page=./licitacao/licitacao_crud&var_acao=editar">
<div class="container">
<div class="label-primary cfb">
<button type="button" name="bt_novo" class="btn" onclick=location.href='?page=./licitacao/licitacao'>
<i class="fa fa-arrow-left" title="voltar"></i></button>
<span style="font-size:20px;"> Licitação | Aditivo</span>
<button type="submit" name="bt_novo" class="btn botao_direita" title="salvar"><i class="fa fa-check"></i></button>
</div>
</div>
<!--
ADITIVO DE LICITAÇOES
-->
<div id="id_form" class="container">
<div class="col-md-2">
ID
<input type="text" name="txt_id" size="4px" style="text-align: center;" readonly="readonly"
value="<?php echo $resulta['cpl_id'] ?>" class="form-control" id="txt_id">
</div>
<div class="col-md-2">
Exercício
<input type="text" name="txt_exercicio" value="<?php echo substr($resulta['cpl_dtlicit'], 6, 4) ?>" class="form-control" readonly>
</div>
<div class="col-md-4">
Órgão
<select name="txt_orgao" class="form-control">
<?php while ($_org = mysql_fetch_array($rs_org)) {
if ($resulta['sol_orgao_id']==$_org['org_codigo']) {
$selected = 'selected';
} else {
$selected = '';
}
?>
<option
value="<?=$_org['org_codigo']?>" <?php echo $selected; ?>><?=$_org['org_nome_orgao']?></option>
<?php } ?>
</select>
</div>
<div class="col-md-4">
Unid. Orçamentária
<select name="txt_uo" class="form-control">
<?php while ($_uno = mysql_fetch_array($rs_uno)) {
if ($resulta['sol_unid_id']==$_uno['uo_codigo']) {
$selected = 'selected';
} else {
$selected = '';
}
?>
<option
value="<?=$_uno['uo_codigo']?>" <?php echo $selected; ?>><?=$_uno['uo_nome']?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2">
Data
<input type="text" name="txt_data" required value="<?php echo $resulta['cpl_dtlicit'] ?>"
class="form-control" maxlength="10" onKeyup="formataData(this,event);">
</div>
<div class="col-md-2">
N° Proc. Licitatório
<input type="text" name="txt_num_lic" value="<?php echo $resulta['cpl_numproc_lic'] ?>" class="form-control" readonly>
</div>
<div class="col-md-2">
Valor total
<input type="text"
name="txt_total"
value="<?php echo number_format($resulta['cpl_vrtotal'], 2, ',', '.') ?>"
class="form-control"
onkeyup="formataValor(this,event);" readonly>
</div>
<div class="col-md-2">
Tipo Licitação
<select name="txt_tipo_lic" class="form-control">
<?php while ($_tlic = mysql_fetch_array($rs_tlic)) {
if ($resulta['cpl_tipo_licitacao']==$_tlic['tpl_id']) {
$selected = 'selected';
} else {
$selected = '';
}
?>
<option
value="<?=$_tlic['tpl_id']?>" <?php echo $selected; ?>><?=$_tlic['tpl_tipolicitacao']?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2">
Modalidade
<select name="txt_modalidade" class="form-control">
<?php while ($_mod = mysql_fetch_array($rs_mod)) {
if ($resulta['cpl_modalidade']==$_mod['mod_id']) {
$selected = 'selected';
} else {
$selected = '';
}
?>
<option
value="<?=$_mod['mod_id']?>" <?php echo $selected; ?>><?=$_mod['mod_desc']?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2">
Agricultura familiar
<select name="txt_familiar" class="form-control">
<?php while ($_sim = mysql_fetch_array($rs_sim)) {
if ($resulta['cpl_agrfam']==$_sim['sn_id']) {
$selected = 'selected';
} else {
$selected = '';
}
?>
<option
value="<?=$_sim['sn_id']?>" <?php echo $selected; ?>><?=utf8_encode($_sim['sn_confirma'])?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2">
Valor aditivo
<input type="text" name="txt_val_aditivo" required autofocus class="form-control" onKeyup="formataValor(this,event);">
</div>
<div class="col-md-2">
% aditivo
<input type="text" name="txt_perc_aditivo" class="form-control" onkeyup="formataInteiro(this,event);">
</div>
<div class="col-md-2">
Tipo aditivo
<select name="txt_tipo_aditivo" class="form-control">
<?php while ($_adt = mysql_fetch_array($rs_adt)) {
if ($resulta['cpl_adt_id']==$_adt['adt_id']) {
$selected = 'selected';
} else {
$selected = '';
}
?>
<option
value="<?=$_adt['adt_id']?>" <?php echo $selected; ?>><?=utf8_encode($_adt['adt_desc'])?></option>
<?php } ?>
</select>
</div>
</div>
</form>
<br>
<!--FORNECEDOR-->
<div class="container">
<div class="panel with-nav-tabs panel-primary">
<div class="panel-heading">
Fornecedor(es) da licitação nº <kbd> <?php echo $resulta['cpl_id'] ?> </kbd>
<button type="submit" name="bt_novo" title="Adicionar fornecedor" class="btn btn-primary btn-xs" onclick="m_div('mostra')"><i class="fa fa-check" title="salvar"></i></button>
</div>
<div class="panel-body">
<div class="tab-content">
<form id="form1" name="form1" id="cad_forn" method="post" action="?page=./licitacao/licitacao_crud&var_acao=cadastrar_forn">
<div class="tab-pane" id="produtos">
<div id="mostra" class="oculto panel panel-body panel-primary filterable">
<div class="panel-body">
<div class="col-md-1">
ID Lic.<br>
<input type="text" name="txt_id_lic" readonly class="form-control" value="<?php echo $resulta['cpl_id'] ?>">
</div>
<div class="col-md-5">
Selecione o Fornecedor<br>
<select name="txt_fornecedor" id="txt_fornecedor" class="form-control">
<?php while ($_for = mysql_fetch_array($rs_for)) { ?>
<option
value="<?php echo $_for['pes_id'] ?>"><?php echo utf8_encode($_for['pes_pessoa']) ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2">
Data contrato
<input type="text" name="txt_data_contrato" required autofocus class="form-control" maxlength="10" onKeyup="formataData(this,event);">
</div>
<div class="col-md-2">
Nº contrato
<input type="text" name="txt_num_contrato_for" required autofocus class="form-control" maxlength="10">
</div>
</div>
<div class="panel-body">
<div class="col-md-2">
Data início vigência
<input type="text" name="txt_data_inicio" required autofocus class="form-control" maxlength="10" onKeyup="formataData(this,event);">
</div>
<div class="col-md-2">
Data fim vigência
<input type="text" name="txt_data_fim" required autofocus class="form-control" maxlength="10" onKeyup="formataData(this,event);">
</div>
<div class="col-md-2">
Valor contrato
<input type="text" name="txt_val_contrato" class="form-control" onkeyup="formataValor(this,event);" required>
</div>
<div class="col-md-4">
Objetivo do contrato
<textarea rows="3" cols="5" name="txt_objetivo_contrato" class="form-control" required></textarea>
</div>
<div class="col-md-1">
<br>
<button type='submit' name='bt_cad_prod' class='btn' title="Adiconar produto a solicitação">
<i class="fa fa-check" title="salvar"></i>
</button>
</div>
</div>
</div>
<div class='panel panel-body panel-primary filterable'>
<table class='tabe1 table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0''>
<thead>
<tr>
<th>ID Lic.</th>
<th>ID Forn.</th>
<th>Fornecedor</th>
<th>N° contrato</th>
<th>Valor contrato</th>
<th></th>
<th></th>
</tr>
</thead>
<tbody>
<?php
while ($row_rsResult = mysql_fetch_array($rsforn)) {
echo "<tr>";
echo "<td>" . $row_rsResult['plf_cpl_id'] . "</td>";
echo "<td>" . $row_rsResult['plf_forn_id'] . "</td>";
echo "<td>" . utf8_encode($row_rsResult['pes_pessoa']) . "</td>";
echo "<td><b>" . $row_rsResult['plf_numcontrato'] . "</b></td>";
echo "<td><b>" . number_format($row_rsResult['plf_valor_cont'], 2, ',', '.') . "</b></td>";
$cod_lic = $row_rsResult['plf_cpl_id'];
$cod_for = $row_rsResult['plf_forn_id'];
$id_for = $row_rsResult['plf_id'];
$forn = utf8_encode($row_rsResult['pes_pessoa']);
/*echo "<td><b><input type='checkbox' name='txt_aditivo[]' value=.$cod_for.></input></b></td>";*/
echo "<td>
<a
href=\"javascript: window.open('modulos/licitacao/licitacao_forn_prd.php?cod_lic=$cod_lic&cod_for=$cod_for&forn=$forn&var_acao=incluir_item_forn',
'Itens','menubar=no,status=no,resizable=no,width=650,height=420,location=no,toolbar=no,top=150,directories=no,fullscreen=no,left=150,titlebar=no')\">
<img src='img/cons32.png' width='16' title='Itens do fornecedor: $forn' /></a>
</td>";
echo "<td><a href='?page=licitacao/licitacao_crud&cod_lic=$cod_lic&cod_for=$cod_for&forn=$forn&forn_id=$id_for&var_acao=excluir_forn'> <em class='fa fa-trash text-red' title='Excluir fornecedor: $forn' onclick='excluir_registro(event);'/></a></td>";
echo "</tr>";
}
$registros = mysql_num_rows($rsforn);
echo "<table>";
echo "<tr>";
echo "<td>Fornecedor(es): $registros</td>";
echo "</tr>";
echo "</table>";
?>
</tbody>
</table>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</html>