| 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/itapipoca19/modulos/movimento/ |
Upload File : |
<?php
/**
* Criado por PhpStorm.
* Projeto: SGAE.
* Arquivo: ordcompra_cad.php.
* Usuário: RalpAlves
* Data: 15/09/2015
* Hora: 13:37
*/
//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_lic = mysql_query("SELECT * FROM proclicitacao ORDER BY cpl_numproc_lic");
$rs_lic = mysql_query("SELECT * FROM v_lista_licitacao_ordem_cad ORDER BY cpl_numproc_lic");
$rs_for = mysql_query("SELECT * FROM pessoas ORDER BY pes_pessoa");
$rs_con = mysql_query("SELECT * FROM proclicforn ORDER BY plf_numcontrato");
$rs_car = mysql_query("SELECT * FROM v_lista_cardapio ORDER BY cdp_nmcardapio");
$rs_prg = mysql_query("SELECT * FROM programa ORDER BY prg_programa");
$data = date("d/m/Y");
$mes = date('m');
$rsSaldo = mysql_query("SELECT sigla, valor, sum(oci_vrusado) as oci_vrusado, valor-sum(oci_vrusado) as oci_vrsaldo FROM v_lista_ordem_compra_valor_real where mes=$mes and SUBSTRING(odc_data,4,2) = $mes");
$saldo = mysql_fetch_array($rsSaldo);
?>
<body style="padding-top: 70px;"/>
<head xmlns="http://www.w3.org/1999/html">
<script type="text/javascript" language="javascript">
function CarregaFornecedor(codLic) {
$.ajax({
type: "GET", url: './modulos/movimento/carregafornecedor.php?&codLic=' + codLic, dataType: "html", success: function (resultado) {
$('#LicForn').html(resultado);
//alert(resultado)
}
});
}
</script>
<script type="text/javascript" language="javascript">
function CarregaContrato(codCon) {
$.ajax({
type: "GET", url: './modulos/movimento/carregacontrato.php?&codcon=' + codCon, dataType: "html", success: function (resultado) {
$('#LicCont').html(resultado);
/*alert(resultado)*/
}
});
}
</script>
<script type="text/javascript" language="javascript">
function CarregaPrograma(codCon) {
$.ajax({
type: "GET", url: './modulos/movimento/carregaprograma.php?&codprg=' + codCon, dataType: "html", success: function (resultado) {
$('#LicPrg').html(resultado);
/*alert(resultado)*/
}
});
}
</script>
<script>
function adiciona() {
document.ordcpr.txt_perini.value = document.ordcpr.txt_perini.value;
document.ordcpr.txt_perfin.value = document.ordcpr.txt_perfin.value;
}
</script>
</head>
<!--FORMULARIO-->
<body style="padding-top: 40px;"/>
<form id="form1" name="ordcpr" id="cad_sol" method="post" action="?page=./movimento/ordcompra_crud&var_acao=cadastrar">
<div class="container panel panel-primary">
<div class="panel-body">
<button type="submit" id="#sign-up" name="bt_novo" class="btn botao_esquerda" onClick="history.go(-1)">
<i class="fa fa-arrow-left" title="voltar"></i>
</button>
<span style="font-size:20px;"> Ordem de compras | Cadastro </span>
<b><span style="font-size:15px;color: #0000CC;">Disponível para <?=$saldo['sigla']?>:
</span>R$ <?=number_format($saldo['valor'], 2, ',', '.')?></b> |
<b><span style="font-size:15px;color: #843534;">utilizado: </span>R$ <?=number_format($saldo['oci_vrusado'], 2, ',', '.')?></b> |
<b><span style="font-size:15px;color: #008000;">Saldo: </span>R$ <?=number_format($saldo['oci_vrsaldo'], 2, ',', '.')?></b>
<button type="submit" name="bt_novo" class="btn botao_direita"><i class="fa fa-check" title="salvar"></i></button>
</div>
</div>
<div class="container form-group">
<div class="col-md-2">
<label for="">ID </label>
<input type="text" name="txt_id" readonly class="form-control" maxlength="10">
</div>
<div class="col-md-2">
<label for="">Nº Ordem compra</label>
<input type="text" readonly name="txt_ordcompra" class="form-control" maxlength="10">
</div>
<div class="col-md-2">
<label for="">Data</label>
<input type="text" value="<? echo $data ?>" name="txt_data" required onKeyup="formataData(this,event);" class="form-control" maxlength="10">
</div>
<div class="col-md-3">
<label for="">Órgão</label>
<select name="txt_orgao" class="form-control" autofocus>
<option value="999" selected>Selecione uma opção</option>
<?php while ($_org = mysql_fetch_array($rs_org)) { ?>
<option value="<?=$_org['org_codigo']?>"><?=$_org['org_nome_orgao']?></option>
<?php } ?>
</select>
</div>
<div class="col-md-3">
<label for="">Unid. Orçamentária</label>
<select name="txt_uo" class="form-control">
<option value="999" selected>Selecione uma opção</option>
<?php while ($_uno = mysql_fetch_array($rs_uno)) { ?>
<option value="<?=$_uno['uo_codigo']?>"><?=$_uno['uo_nome']?></option>
<?php } ?>
</select>
</div>
</div>
<div class="container form-group">
<div class="col-md-4">
<label for="">Nº Proc. Licitatório</label>
<select name="txt_proclicita" class="form-control" id="vnumlic" onchange="CarregaFornecedor(this.value);">
<option value="999" selected>Selecione uma opção</option>
<?php while ($_prj = mysql_fetch_array($rs_lic)) { ?>
<option value="<?=$_prj['cpl_id']?>"><?=utf8_encode($_prj['cpl_numproc_lic']) . ' - ' . $_prj['pes_pessoa']?></option>
<?php } ?>
</select>
</div>
<div class="col-md-5" id="LicForn">
<!--carregar Fornecedor-->
<label for="">Fornecedor</label>
<select name="txt_fornecedor" class="form-control" onchange="CarregaContrato(this.value);"> </select>
</div>
<div class="col-md-3" id="LicCont">
<!--carregar Contrato-->
<label for="">Contrato</label>
<select name="txt_contrato" class="form-control"> </select>
</div>
</div>
<div class="container form-group">
<div class="col-md-6">
<label for="">Cardápio</label>
<select name="txt_cardapio" class="form-control select2" id="idcard">
<option value="999" selected>Selecione uma opção</option>
<?php while ($_car = mysql_fetch_array($rs_car)) { ?>
<option value="<?=$_car['cdp_id']?>"><?=utf8_encode($_car['cdp_nmcardapio'] . ' (' . $_car['tpe_tipoescola'] . ')')?></option>
<?php } ?>
</select>
</div>
<div class="col-md-3">
<label for="">Período inicial</label>
<input type="text" name="txt_perini" required onKeyup="formataData(this,event);"
class="form-control" maxlength="10">
</div>
<div class="col-md-3">
<label for="">Período final</label>
<input type="text" name="txt_perfin" required onKeyup="formataData(this,event);"
class="form-control" maxlength="10">
</div>
</div>
<div class="container form-group">
<div class="col-md-4">
<label for="">Programa</label>
<select id="LicPrg" name="id_programa" class="form-control select2">
<?php while ($_prg1 = mysql_fetch_array($rs_prg)) { ?>
<option value="<?php echo $_prg1['prg_id'] ?>"><?php echo utf8_encode($_prg1['prg_programa'] . ' (' . $_prg1['prg_id'] . ')') ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-2">
<label for="">Repete</label>
<input type="number" name="txt_repete" required class="form-control">
</div>
<div class="col-md-6">
<label for="">Observação</label>
<textarea rows="3" cols="4" name="txt_obs" class="form-control"></textarea>
</div>
</div>
</form>