| 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/mnovaajuste2019/modulos/secretaria/ |
Upload File : |
<?PHP
ini_set('display_errors', 'off');
if (isset($_POST['txt_pesq'])) {
$ntb = $_POST['txt_pesq'];
}
mysql_select_db($banco, $conexao);
$rs_orgao = mysql_query("SELECT * FROM und_gest_orgao order by org_nome_orgao");
$rsResult = mysql_query("SELECT * FROM v_lista_und_orc WHERE uo_nome LIKE '%$ntb%'");
$rsResult_totalRows = mysql_num_rows($rsResult);
?>
<head>
<title>SGAE | Merenda</title>
<link href="Styles/Site.css" rel="stylesheet" type="text/css"/>
<link rel="icon" href="img/favicon.png"/>
<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"/>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.22/jquery-ui.min.js"
type="text/javascript"></script>
<link href="Styles/bootstrap.css" rel="stylesheet" type="text/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>
</head>
<!--GRID DA DADOS-->
<?php
{
if ($rsResult_totalRows=="0") {
echo
"
<div class='container text-center'>
<p class='alert alert-danger' style='font-size: 15px;'>Nenhum U.O. encontrada!</p>
</div>
";
}
}
?>
<body style="padding-top: 85px;"/>
<div id='id_grid' class='container'>
<p style='font-size: 20px;'>Unidade Orçamentária | Listagem </p>
<div class='panel panel-primary filterable'>
<table class='tabe1 table table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<!--PESQUISAR REGISTRO-->
<form id='frm_pesq' method='post'>
<div class='panel'>
<div class="panel-body">
<div class='panel'>
<div class="col-md-5">
<input type='text' class='form-control' name='txt_pesq' id='txt_pesq'
placeholder='Entre com a U.O. a localizar' style='text-transform: uppercase;'>
</div>
<div class="col-md-1">
<button type='submit' name='bt_novo' class='btn' onclick=''>✔</button>
</div>
</div>
</div>
</div>
</form>
<!--INCLUIR REGISTRO-->
<form id="form1" name="form1" id="cad_orgao" method="post" action="?page=./secretaria/uo_crud&var_acao=cadastrar">
<div class='panel panel-primary'>
<div class="panel-body">
<div class="col-md-5">
Órgão<br>
<select name="txt_orgao" id="txt_orgao" class="form-control">
<?php while ($_org = mysql_fetch_array($rs_orgao)) { ?>
<option
value="<?php echo $_org['org_codigo'] ?>"><?php echo $_org['org_nome_orgao'] ?></option>
<?php } ?>
</select>
</div>
<div class="col-md-5">
Unidade orçamentária<br>
<input type="text" name="txt_uo" class="form-control lm" required>
</div>
<div class="col-md-1">
Exercício
<input type="text" name="txt_exercicio" class="form-control lm" required maxlength="4">
</div>
<div class="col-md-1">
<br>
<button type='submit' name='bt_cad_prod' class='btn' title="Adicionar registro">
<i class="fa fa-check" title="salvar"></i>
</button>
</div>
</div>
</div>
</form>
<!--/*********************/-->
<tr>
<th>ID</th>
<th>Unidade orçamentária</th>
<th>ID</th>
<th>Órgão</th>
<th>Exercício</th>
<th></th>
</tr>
<?php
while ($row_rsResult = mysql_fetch_array($rsResult)) {
echo "<tr>";
echo "<td>" . $row_rsResult['uo_codigo'] . "</td>";
echo "<td>" . $row_rsResult['uo_nome'] . "</td>";
echo "<td>" . $row_rsResult['org_codigo'] . "</td>";
echo "<td>" . $row_rsResult['org_nome_orgao'] . "</td>";
echo "<td>" . $row_rsResult['uo_exercicio'] . "</td>";
$id_uo = $row_rsResult['uo_codigo'];
echo "<td><a href='?page=secretaria/uo_crud&cod_uo=$id_uo&var_acao=excluir'> <em class='fa fa-trash text-red' title='Excluir registro' onclick='excluir_registro(event);'/></a></td>";
echo "</tr>";
}
?>
</table>
</div>
</div>
</html>