| 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/vicosa19/modulos/usuario/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: RalpAlves
* Date: 04/03/15
* Time: 14:02
*/
session_start();
$direito = $_SESSION['admin'];
$usu_escola = $_SESSION['usu_escola'];
$cod_usu = $_GET['cod_usu'];
mysql_select_db($banco, $conexao);
$rs_sql = mysql_query("select * from usuarios where usu_id = $cod_usu") or die('Erro ao consultar a base de dados (usuario_edt.php #11) ' . mysql_error());
$rs_esc = mysql_query("SELECT * FROM escolas order by esc_nome") or die('Erro ao consultar a base de dados (usuario_edt.php #11) ' . mysql_error());
$resulta = mysql_fetch_array($rs_sql);
$rs_ent = mysql_query("select * from v_lista_usuario_escola where usu_id = $cod_usu") or die('Erro ao consultar UG dos usuários (usuario_edt.php #12) ' . mysql_error());
$cargo = mysql_query("SELECT * FROM assinatura ORDER BY ass_assin_cargo");
?>
<head id="Head1">
<meta charset="utf-8"/>
<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 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>
<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>
</head>
<!--FORM DE PRODUTOS-->
<div class="container">
<button type="submit" name="bt_novo" class="btn" onclick=location.href='?page=./usuario/usuario'>
<i class="fa fa-arrow-left" title="voltar"></i>
</button>
</div>
<form id="form1" name="form1" id="cad_forn_edt" method="post" action="?page=./usuario/usuario_crud&var_acao=editar">
<div class="container panel-body">
<div class="panel panel-primary">
<div class="panel-heading">
<div><span style="font-size:20px;"> Usuário | Edição</span>
<button type="submit" name="bt_novo" class="btn botao_direita" style="color: #2255a4; background: white;">
<i class="fa fa-check" title="salvar"></i>
</button>
</div>
</div>
<!--
USUARIO
-->
<div class="panel-body">
<div id="id_form" class="container">
<div class="col-md-2">
ID
<input type="text" name="txt_ID" readonly value="<?php echo $cod_usu ?>" class="form-control">
</div>
<div class="col-md-2">
Nome do usuário
<input type="text"
name="txt_usuario"
required
autofocus
style="text-transform: uppercase;"
value="<?php echo $resulta['usu_usuario'] ?>"
class="form-control">
</div>
<div class="col-md-3">
E-mail
<input type="text"
name="txt_mail"
required
style="text-transform: lowercase;"
value="<?php echo $resulta['usu_mail'] ?>"
class="form-control">
</div>
<div class="col-md-3">
Cargo
<select name="txt_cargo" class="form-control">
<?php while ($_car = mysql_fetch_array($cargo)) {
if ($resulta['usu_ass_codigo']==$_car['ass_codigo']) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option
value="<?=$_car['ass_codigo']?>" <?php echo $selected; ?>><?=utf8_encode($_car['ass_assin_cargo'])?></option>?>?>
<?php } ?>
</select>
</div>
</div>
<div id="id_form" class="container">
<div class="col-md-2">
Administrador
<?php if ($direito==1) { ?>
<input type="checkbox" name="txt_admin" checked value="1" class="checkbox">
<? } else { ?>
<input type="checkbox" name="txt_admin" value="1" class="checkbox">
<?php } ?>
<!-- <select name="txt_admin" id="txt_admin" class="form-control">-->
<!-- <option value="0">NÃO</option>-->
<!-- <option value="1">SIM</option>-->
<!-- </select>-->
</div>
<div class="col-md-2">
Escola
<?php if ($resulta['usu_escola']) { ?>
<input type="checkbox" name="txt_escola" checked value="1" class="checkbox">
<? } else { ?>
<input type="checkbox" name="txt_escola" value="1" class="checkbox">
<?php } ?>
<!-- <select name="txt_escola" id="txt_escola" class="form-control">-->
<!-- <option value="0">NÃO</option>-->
<!-- <option value="1">SIM</option>-->
<!-- </select>-->
</div>
</div>
</div>
<div id="id_form">
<div id="id_form" class="panel panel-primary">
<label class="col-md-5" class="form-control">
Alterar senha | <span>deixar em branco para não alterar</span>
</label>
</div>
</div>
<div id="id_form" class="container panel-body">
<div class="col-md-2">
Senha atual
<input type="password" name="txt_senha_atu" size="20" id="txt_senha_atu" class="form-control">
</div>
<div class="col-md-2">
Nova senha
<input type="password" name="txt_senha" size="20" id="txt_senha" class="form-control">
</div>
<div class="col-md-2">
Repetir senha
<input type="password" name="txt_senhar" size="20" oninput="validaSenha(this)" class="form-control">
</div>
</div>
</div>
</div>
</form>
<!--ESCOLAS-->
<div class="container panel-body">
<div class="panel panel-primary">
<div class="panel-heading">
Escola(s) | Usuário: <?php echo $resulta['usu_usuario'] ?>
</div>
<div class="panel-body">
<div class="tab-content panel-body">
<form id="form2" name="form2" id="cad_usuario" method="post" action="?page=./usuario/usuario_crud&var_acao=cadastrar_ug">
<div class="col-md-1">
ID<br>
<input type="text" name="txt_id_usu" readonly class="form-control input-sm" value="<?php echo $cod_usu ?>">
</div>
<div class="col-md-6">
Escola<br>
<select name="txt_ug" id="txt_ug" class="form-control select2">
<option value="999" selected>Selecione uma escola</option>
<?php while ($_ref = mysql_fetch_array($rs_esc)) { ?>
<option
value="<?php echo $_ref['esc_id'] ?>"><?php echo utf8_encode($_ref['esc_nome']) ?></option>
<?php } ?>
</select>
</div>
<!--verifica se usuário tem permissão de administrador-->
<?php
if ($direito=="1") {
echo("
<div class='col-md-1'>
<br>
<button type='submit' name='bt_cad_ug' class='btn' title='Adiconar escola'>
<i class='fa fa-check' title='salvar'></i>
</button>
</div>
");
}
?>
</form>
</div>
<div class="panel-body">
<table class='table table-responsive table-striped'>
<thead>
<tr class="success">
<th width="4%">ID</th>
<th>Escola</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($row_rsResult = mysql_fetch_array($rs_ent)) {
echo "<tr>";
echo "<td>" . $row_rsResult['usu_id'] . "</td>";
echo "<td>" . utf8_encode($row_rsResult['esc_nome']) . "</td>";
$cod_usu = $row_rsResult['usu_id'];
$cod_ent = $row_rsResult['esc_id'];
echo "<td><a href='?page=/usuario/usuario_crud&cod_usu=$cod_usu&cod_ent=$cod_ent&var_acao=excluir_ug'>
<em class='fa fa-trash text-red' title='Excluir escola' onclick='excluir_registro(event);'/></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</html>
<script>
function validaSenha(input) {
if (input.value != document.getElementById('txt_senha').value) {
input.setCustomValidity('A senha digitada na confere! Tente novamente.');
} else {
input.setCustomValidity('');
}
}
</script>
<script src="js/select2.full.min.js"></script>
<script>
$(function () {
$(".select2").select2();
});
</script>