| 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/vicosa23/modulos/licitacao/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 04/03/15
* Time: 14:02
*/
ini_set('display_errors', 'off');
include_once("../../includes/conexao.php");
include_once("../../includes/funcoes.php");
$id_lic = $_GET['cod_lic'];
$id_for = $_GET['cod_for'];
$forn = $_GET['forn'];
$fam = $_GET['fam'];
$idreg = $_GET['id'];
mysql_select_db($banco, conexao);
$ano = date('Y');
$rs_sql = mysql_query("select * from v_lista_licitacao_forn_item where pli_plf_id=$idreg and pli_exercicio=$ano");
$rs_produto = mysql_query("SELECT * FROM produtos WHERE pro_tipo=1 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_marca");
?>
<head id="Head1">
<meta charset="utf-8"/>
<title>SGAE | Merenda</title>
<link href="../../Styles/Site.css" rel="stylesheet" type="text/css"/>
<link href="../../Styles/smoothness/jquery-ui-1.8.24.custom.css" rel="stylesheet" type="text/css"/>
<script src="../../Scripts/jquery-1.8.2.js" type="text/javascript"></script>
<script src="../../Scripts/jquery-1.8.2.min.js" type="text/javascript"></script>
<link href="http://code.jquery.com/ui/1.10.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
<link href="../../Styles/bootstrap.css" rel="stylesheet" type="text/css"/>
<script src="../../js/mascara.js" type="text/javascript"></script>
<script src="../../datatables/media/js/jquery.js" type="text/javascript"></script>
<link href="../../datatables/media/css/jquery.dataTables.css" rel="stylesheet" type="text/css"/>
<script src="../../datatables/media/js/jquery.dataTables.js" type="text/javascript"></script>
<link href="http://ironsummitmedia.github.io/startbootstrap-sb-admin/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">
<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>
<!--MOSTRAR / ESCONDER DIV-->
<script>
function m_div(el) {
var display = document.getElementById(el).style.display;
if (display == "none")
document.getElementById(el).style.display = 'none'; else
document.getElementById(el).style.display = 'block';
}
</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>-->
<!--MOSTRAR / ESCONDER DIV-->
<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": "<img src='../../img/btPesquisar.png' width='20' title='Pesquisar'/>",
"sUrl": "",
"oPaginate": {
"sFirst": "<<",
"sPrevious": "<img src='../../img/anterior.png' width='20' title='Registro anterior'/>",
"sNext": "<img src='../../img/proximo.png' width='20' title='Próximo registro'/>",
"sLast": ">>"
}
}
});
});
</script>
<script>
function combo(id, acao, valor) {
$.ajax({
type: "GET",
url: '../../ajax.php?a=' + acao + '&valor=' + valor,
dataType: "html",
success: function (resultado) {
//alert(resultado);
$('#' + id).html(resultado);
//$('#resposta').html(resultado);
}
});
}
</script>
<script src="js/select2.full.min.js"></script>
<script>
$(function () {
$(".select2").select2();
});
</script>
</head>
<body style="padding-top: 1px;">
<form id="form1" name="form1" method="post" action="licitacao_crud.php?var_acao=cadastrar_prod_forn">
<div id="id_form" class="oculto">
<div class="panel-body">
<input type="hidden" name="txt_fam" value="<?php echo $fam ?>">
<input type="hidden" name="txt_id" value="<?php echo $idreg ?>">
<div class="col-xs-2 oculto">
<label for="">ID Licitação</label>
<input type="text" name="txt_id_lic" readonly class="form-control" value="<?php echo $id_lic ?>">
</div>
<div class="col-xs-2 oculto">
<label for="">ID Forn.</label>
<input type="text" name="txt_id_for" readonly class="form-control" value="<?php echo $id_for ?>">
</div>
<div class="col-xs-2 oculto">
<label for="">Forn.</label>
<input type="text" name="txt_forn" readonly class="form-control" value="<?php echo $forn ?>">
</div>
<div class="col-md-5">
<label for="">Selecione o produto<br></label>
<select name="txt_produto" id="txt_produto" class="form-control select2" autofocus>
<option value="999" selected>Selecione uma opção</option>
<?php while ($_prd = mysql_fetch_array($rs_produto)) { ?>
<option value="<?php echo $_prd['pro_id'] ?>|<?php echo utf8_encode($_prd['pro_produto']) ?>"><?php echo utf8_encode($_prd['pro_produto']) ?></option>
<?php } ?>
</select>
</div>
<div class="col-xs-3">
<label for="">Unidade<br></label>
<select name="txt_unidade" id="txt_unidade" class="form-control select2">
<?php while ($_und = mysql_fetch_array($rs_und)) { ?>
<option value="<?php echo $_und['und_id'] ?>"><?php echo utf8_encode($_und['und_desc']) ?></option>
<?php } ?>
</select>
</div>
<div class="col-xs-3">
<label for="">Marca</label>
<!--ADD DE OUTRO MÓDULO-->
<a class='janela70 text-black' href="../../index2.php?page=produto/marca" target="_blank"> <i class='glyphicon glyphicon-plus'></i></a>
<i class='glyphicon glyphicon-refresh' onclick="combo('marca_produto','sel_marcaProduto','0')" style="cursor: hand;"></i>
<!--ADD DE OUTRO MÓDULO-->
<div id='marca_produto'>
<select name="txt_marca_prod" id="txt_marca_prod" class="form-control select2">
<?php while ($_mrc = mysql_fetch_array($rs_mrc)) { ?>
<option value="<?php echo $_mrc['mrc_id'] ?>"><?php echo utf8_encode($_mrc['mrc_marca']) ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-xs-2">
<label for="">Quant.</label>
<input type="text" name="txt_quant" id="txt_quant" class="form-control" required onkeyup="formataDouble(this,event)">
</div>
<div class="col-xs-2">
<label for="">Vlr. unit.</label>
<input type="text" name="txt_val_unit" class="form-control" required onkeyup="formataValor(this,event);">
</div>
<div class="col-xs-1">
<button type="submit" id="id_bt_salvar" name="id_bt_salvar" class="btn" title="Adicionar produto"><i class="fa fa-check" title="Adicionar produto"></i></button>
</div>
<!-- <div class="col-xs-1">-->
<!-- -->
<!-- <button id="id_bt_cancelar" name="id_bt_cancelar" class="btn" onclick="window.close()" title="Voltar"><i class="fa fa-arrow-left" title="Voltar"></i></button>-->
<!-- </div>-->
</div>
</div>
</form>
<div class="panel-primary panel-body">
<div class="panel-heading">
Itens do fornecedor: <kbd style="font-size: 18px;"><?php echo $forn ?></kbd>
<button type="submit" name="bt_novo" title="Adicionar item" class="btn" onclick="m_div('id_form')"><i class="fa fa-plus" title="salvar"></i></button>
</div>
<div class='panel'>
<table class='tabe1 table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr>
<th>ID</th>
<!-- <th>ID For.</th>-->
<th>Produto</th>
<th class="meio">Und.</th>
<th class="direita">Qtd.</th>
<th class="direita">Vl.Unit.</th>
<th class="direita">Total</th>
<th></th>
<th></th>
</tr>
</thead>
<tbody>
<?php
$tot_g = 0;
while ($linha = mysql_fetch_array($rs_sql)) {
echo "<tr>";
echo "<td>" . $linha['pli_id'] . "</td>";
// echo "<td>" . $linha['plf_id'] . "</td>";
echo "<td>" . utf8_encode($linha['pro_produto']) . ' (' . $linha['pli_pro_id'] . ')' . "</td>";
echo "<td class='meio'>" . utf8_encode($linha['und_desc']) . "</td>";
echo "<td class='direita'>" . number_format($linha['pli_pro_qtd'], 0, ',', '.') . "</td>";
echo "<td class='direita'>" . number_format($linha['pli_pro_vrunit'], 2, ',', '.') . "</td>";
echo "<td class='direita'>" . number_format($linha['pli_pro_total'], 2, ',', '.') . "</td>";
$valor = $linha['pli_pro_qtd'];
$cod_for = $linha['pli_plf_id'];
$cod_prd = $linha['pli_id'];
$id_prd = $linha['pli_pro_id'];
$tot_g += $linha['pli_pro_total'];
echo "<td><a class='janela40' href='dist_prg.php?cod_prd=$cod_prd&cod_for=$cod_for&forn=$forn&id_prd=$id_prd&valor=$valor'>
<img src='../../img/bullet04.png' width='16' title='Distribuir por programas'/></a></td>";
echo "<td><a href='licitacao_crud.php?cod_prd=$cod_prd&cod_for=$cod_for&forn=$forn&id_prod=$id_prd&var_acao=excluir_prod'>
<span class='glyphicon glyphicon-trash text-red' onclick='excluir_registro(event);'></span></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
<div class="direita label-info" style="font-size: 15px;font-weight: bold;">
Total R$ <?=number_format($tot_g, 2, ',', '.')?>
</div>
</div>
</body>
</html>