| 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/siac/dev/admin/pages/usuario/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: ralpb
* Date: 29/08/2017
* Time: 09:36
*/
ini_set('display_errors', 'off');
session_start();
$_login = $_SESSION['login'];
$_idsolicitante = $_SESSION['idsolicitante'];
$_usuario = $_SESSION['usuario'];
$_cod_usuario = $_SESSION['cod_usuario'];
$_usu_admin = $_SESSION['usu_admin'];
$tp = $conn->query("select * from v_lista_usuarios WHERE cod_usuario > 1");
$uf = $conn->query("select * from ocupacoes ORDER by ocupacao_nome");
$entidade_o = $conn->query("select * from entidades ORDER BY uo_nome");
$departamento_o = $conn->query("select * from departamentos ORDER by depto_nome");
$entidade_e = $conn->query("select * from entidades ORDER BY uo_nome");
$departamento_e = $conn->query("select * from departamentos ORDER by depto_nome");
if (isset($_GET['cod_usuario'])) {
$id_uo = $_GET['cod_usuario'];
$edit = $conn->query("select * from v_lista_usuarios where cod_usuario=$id_uo");
$uf2 = $conn->query("select * from ocupacoes ORDER by ocupacao_nome");
$ed = $edit->fetch(PDO::FETCH_OBJ);
}
?>
<html>
<head>
<script type="text/javascript">
function lista_entidades_e_o() {
var codigo = $('#id_entidade_e_o').val();
if (codigo) {
var url = 'pages/protocolo/lista_entidade.php?id_cod=' + codigo + '&var=origem_e_o';
$.get(url, function (dataReturn) {
$('#load_departamento_e_o').html(dataReturn);
});
}
}
</script>
<script type="text/javascript">
function lista_entidades_e_d() {
var codigo = $('#id_entidade_e_d').val();
if (codigo) {
var url = 'pages/protocolo/lista_entidade.php?id_cod=' + codigo + '&var=origem_e_d';
$.get(url, function (dataReturn) {
$('#load_departamento_e_d').html(dataReturn);
});
}
}
</script>
<script>
//mostrar div
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>
</head>
<body body onsubmit="javascript:showCarga();">
<section class="content-header">
<h1>
<a href="index.php" title="voltar"><i class="fa fa-reply"><span> </span></i></a>
<span class="text-bold text-blue">Usuários</span>
<small class="text-orange text-bold"><strong>(LISTAGEM)</strong></small>
<?php if ($_usu_admin=='1') { ?>
<a href="#" title="Novo registro" onclick="m_div('id_cad_usuario')" class="pull-right"><i class="fa fa-plus-square text-green"></i></a>
<?php } ?>
</h1>
<ol class="breadcrumb"></ol>
</section>
<!--CADASTRO DE NOVO USUARIO-->
<section class="content-header">
<div id="id_cad_usuario" class="box box-primary" style="display: none;">
<div id="id_cad_usuarios">
<div class="box-header with-border">
<h3 class="box-title text-bold text-blue titulo">Novo usuário</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse">
<i class="fa fa-minus"></i>
</button>
</div>
</div>
<div class="box-body">
<div class="row">
<form id="f_usuario_e" name="f_usuario_e" onsubmit="javascript:showCarga();" method="post" action="?page=usuario/usuario_a&var=cadastrar">
<div class="col-md-12">
<div class="col-md-7">
<h5 class="text-bold text-lbl-campo">Nome</h5>
<div>
<input type="text" name="nome" maxlength="80" required class="form-control">
</div>
</div>
<div class="col-md-5">
<h5 class="text-bold text-lbl-campo">CPF</h5>
<div>
<input type="text" onkeyup="formataCPF(this,event)" name="cpf" required maxlength="14" class="form-control">
</div>
</div>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Telefone</h5>
<div>
<input type="text" name="fone" maxlength="14" onkeyup="mascara(this,celular);" required class="form-control">
</div>
</div>
<div class="col-md-5">
<h5 class="text-bold text-lbl-campo">E-mail</h5>
<div>
<input type="email" name="email" maxlength="80" required class="form-control text-lowercase">
</div>
</div>
<div class="col-md-5">
<h5 class="text-bold text-lbl-campo">Ocupação</h5>
<div>
<select name="cod_ocupacao" class="form-control select2">
<option value="99">Selecione</option>
<?php while ($u = $uf->fetch(PDO::FETCH_OBJ)) { ?>
<option value="<?php echo $u->cod_ocupacao ?>"><?php echo $u->ocupacao_nome . '-' . $u->cod_cbo ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-7">
<h5 class="text-bold text-lbl-campo">Entidade</h5>
<div>
<select id="id_entidade_e_o" onchange="lista_entidades_e_o();" name="cod_uo" class="form-control select2">
<option value="99">Selecione</option>
<?php while ($ent_o = $entidade_o->fetch(PDO::FETCH_OBJ)) {
if ($ent_o->cod_uo==$prot->ori_entidade) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $ent_o->cod_uo ?>"<?php echo $selected; ?>><?php echo strtoupper($ent_o->uo_nome) ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-5">
<h5 class="text-bold text-lbl-campo">Departamento</h5>
<div>
<select id="load_departamento_e_o" name="cod_depto" class="form-control select2">
<option value="99">Selecione</option>
<?php while ($dep_o = $departamento_o->fetch(PDO::FETCH_OBJ)) {
if ($dep_o->cod_depto==$prot->ori_departamento) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $dep_o->cod_depto ?>"<?php echo $selected; ?>><?php echo strtoupper($dep_o->depto_nome) ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Login</h5>
<div>
<input type="text" name="login" maxlength="45" required class="form-control">
</div>
</div>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Senha</h5>
<div>
<input type="password" id="password" name="password" maxlength="45" required class="form-control">
</div>
</div>
<div class="col-md-3">
<h5 class="text-bold text-lbl-campo">Repetir a Senha</h5>
<div>
<input type="password" oninput="validaSenha(this)" name="password1" maxlength="45" required class="form-control">
</div>
</div>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Chave</h5>
<div>
<input type="password" id="chave" name="chave" maxlength="50" required class="form-control">
</div>
</div>
<div class="col-md-3">
<h5 class="text-bold text-lbl-campo">Repetir a Chave</h5>
<div>
<input type="password" oninput="validaChave(this)" name="chave1" maxlength="50" required class="form-control">
</div>
</div>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Ativo</h5>
<div>
<select class="selectpicker form-control" name="ativo">
<option value="S" selected>SIM</option>
<option value="N">NÃO</option>
</select>
</div>
</div>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Administrador</h5>
<div>
<select class="selectpicker form-control" name="usu_admin">
<option value="1">SIM</option>
<option value="0" selected>NÃO</option>
</select>
</div>
</div>
<div class="col-md-2" hidden>
<h5 class="text-bold text-lbl-campo">Centralizador</h5>
<div>
<select class="selectpicker form-control" name="usu_centralizador">
<option value="1">SIM</option>
<option value="0" selected>NÃO</option>
</select>
</div>
</div>
<div class="col-md-12">
<h5 class="text-bold text-lbl-campo"> </h5>
<div>
<button type="submit" class="btn btn-box-tool form-control text-blue titulo" title="salvar registro">
<i class="fa fa-check-circle fa-2x text-blue"></i> Salvar
</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</section>
<!--END CADASTRO DE NOVO USUARIO-->
<!--EDITAR USUARIO-->
<?php if (isset($_GET['cod_usuario'])) { ?>
<section class="content-header">
<div id="id_usuario_edit" class="box box-primary">
<div id="id_usuarios_edit">
<div class="box-header with-border">
<h3 class="box-title text-bold text-blue titulo">Editar usuário</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse">
<i class="fa fa-minus"></i>
</button>
</div>
</div>
<div class="box-body">
<div class="row">
<form id="f_empresas" name="f_empresas" onsubmit="javascript:showCarga();" method="post" action="?page=usuario/usuario_a&var=editar">
<div class="col-md-12">
<div class="col-md-7">
<h5 class="text-bold text-lbl-campo">Nome</h5>
<div>
<input type="hidden" name="cod_usuario" value="<?php echo $ed->cod_usuario ?>">
<input type="text" name="nome" value="<?php echo $ed->nome ?>" maxlength="80" required class="form-control">
</div>
</div>
<?php if ($_usu_admin==1) { ?>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Ativo</h5>
<div>
<select class="selectpicker form-control" name="ativo">
<?php if ($ed->ativo=='S') { ?>
<option value="S" selected>SIM</option>
<option value="N">NÃO</option>
<?php } else { ?>
<option value="N" selected>NÃO</option>
<option value="S">SIM</option>
<?php } ?>
</select>
</div>
</div>
<? } ?>
<div class="col-md-3">
<h5 class="text-bold text-lbl-campo">CPF</h5>
<div>
<input type="text" onkeyup="formataCPF(this,event)" value="<?php echo $ed->cpf ?>" name="cpf" required maxlength="14" class="form-control">
</div>
</div>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Telefone</h5>
<div>
<input type="text" name="fone" value="<?php echo $ed->fone ?>" maxlength="14" onkeyup="mascara(this,celular);" required class="form-control">
</div>
</div>
<div class="col-md-7">
<h5 class="text-bold text-lbl-campo">E-mail</h5>
<div>
<input type="email" name="email" value="<?php echo $ed->email ?>" maxlength="80" required class="form-control text-lowercase">
</div>
</div>
<div class="col-md-5">
<h5 class="text-bold text-lbl-campo">Ocupação</h5>
<div>
<select name="cod_ocupacao" class="form-control select2">
<option value="99">Selecione</option>
<?php while ($u = $uf2->fetch(PDO::FETCH_OBJ)) {
if ($ed->cod_ocupacao==$u->cod_ocupacao) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $u->cod_ocupacao ?>"<?php echo $selected; ?>><?php echo $u->ocupacao_nome ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-7">
<h5 class="text-bold text-lbl-campo">Entidade</h5>
<div>
<select id="id_entidade_e_d" onchange="lista_entidades_e_d();" name="cod_uo" class="form-control select2">
<option value="99">Selecione</option>
<?php while ($ent_o = $entidade_e->fetch(PDO::FETCH_OBJ)) {
if ($ed->cod_uo==$ent_o->cod_uo) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $ent_o->cod_uo ?>"<?php echo $selected; ?>><?php echo strtoupper($ent_o->uo_nome) ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-5">
<h5 class="text-bold text-lbl-campo">Departamento</h5>
<div>
<select id="load_departamento_e_d" name="cod_depto" class="form-control select2">
<option value="99">Selecione</option>
<?php while ($dep_e = $departamento_e->fetch(PDO::FETCH_OBJ)) {
if ($ed->cod_depto==$dep_e->cod_depto) {
$selected = 'selected';
} else {
$selected = '';
} ?>
<option value="<?php echo $dep_e->cod_depto ?>"<?php echo $selected; ?>><?php echo strtoupper($dep_e->depto_nome) ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-7">
<h5 class="text-bold text-lbl-campo">Login</h5>
<div>
<input type="text" name="login" value="<?php echo $ed->login ?>" maxlength="45" required class="form-control">
</div>
</div>
<?php if ($_usu_admin==1) { ?>
<div class="col-md-2">
<h5 class="text-bold text-lbl-campo">Administrador</h5>
<div>
<select class="selectpicker form-control" value="<?php echo $ed->usu_admin ?>" name="usu_admin">
<?php if ($ed->usu_admin=='1') { ?>
<option value="1" selected>SIM</option>
<option value="0">NÃO</option>
<?php } else { ?>
<option value="1">SIM</option>
<option value="0" selected>NÃO</option>
<?php } ?>
</select>
</div>
</div>
<? } ?>
<?php if ($_usu_admin==1) { ?>
<div class="col-md-2" hidden>
<h5 class="text-bold text-lbl-campo">Centralizador</h5>
<div>
<select class="selectpicker form-control" value="<?php echo $ed->usu_centralizador ?>" name="usu_centralizador">
<?php if ($ed->usu_centralizador=='1') { ?>
<option value="1" selected>SIM</option>
<option value="0">NÃO</option>
<?php } else { ?>
<option value="1">SIM</option>
<option value="0" selected>NÃO</option>
<?php } ?>
</select>
</div>
</div>
<? } ?>
<div class="col-md-1">
<h5 class="text-bold text-lbl-campo"> </h5>
<div>
<button type="submit" class="btn btn-box-tool btn-block form-control text-blue titulo" title="salvar registro">
<i class="fa fa-check-circle fa-2x text-blue"></i>
</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</section>
<!--END EDITAR DEPARTAMENTO-->
<!--ALTERAR SENHA-->
<section class="content-header">
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title text-bold text-blue titulo">Alterar senha</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse">
<i class="fa fa-minus"></i>
</button>
</div>
</div>
<div class="box-body">
<div class="row">
<form id="f_usuario_e" name="f_usuario_e" onsubmit="javascript:showCarga();" method="post" action="?page=usuario/usuario_a&var=altera_senha">
<input type="hidden" name="cod_usuario" value="<?php echo $ed->cod_usuario ?>">
<input type="hidden" name="email" value="<?php echo $ed->email ?>">
<input type="hidden" name="login" value="<?php echo $ed->login ?>">
<div class="col-md-4">
<h5 class="text-bold text-lbl-campo">Senha</h5>
<div>
<input type="password" id="password2" name="password" maxlength="45" required class="form-control">
</div>
</div>
<div class="col-md-3">
<h5 class="text-bold text-lbl-campo">Repetir a Senha</h5>
<div>
<input type="password" oninput="validaSenha2(this)" name="password3" maxlength="45" required class="form-control">
</div>
</div>
<div class="col-md-5">
<h5 class="text-bold text-lbl-campo"> </h5>
<div>
<button type="submit" class="btn btn-box-tool btn-block form-control text-blue titulo" title="salvar registro">
<i class="fa fa-check-circle fa-2x text-blue"></i> Salvar
</button>
</div>
</div>
</form>
</div>
</div>
</div>
</section>
<!--END ALTERAR SENHA-->
<!--ADICIONAR FOTO-->
<div id="id_cad_empresas" class="box box-primary">
<div id="id_cad_empresa">
<div class="box-header with-border">
<h3 class="box-title text-bold text-blue titulo">Adicionar foto</h3>
<div class="box-tools pull-right">
<button type="button" class="btn btn-box-tool" data-widget="collapse">
<i class="fa fa-minus"></i>
</button>
</div>
</div>
<div class="box-body">
<div class="row">
<form id="f_add_foto" name="f_add_foto" enctype="multipart/form-data" method="post" action="?page=usuario/usuario_a&var=add_foto">
<div class="col-md-12">
<input type="hidden" name="cod_usuario" value="<?php echo $ed->cod_usuario ?>">
<div class="col-md-7">
<h5 class="text-bold text-lbl-campo">Selecione uma foto</h5>
<div>
<div>
<input type="file" id="foto_usuario" name="foto_usuario" class="form-control" required data-min-file-count="1" accept="image/jpeg">
</div>
</div>
</div>
<div class="col-md-2">
<div class="center-block">
<?php if ($ed->foto=='') { ?>
<img src="dist/img/user_add.png" class="img-responsive img-circle" width="130px">
<?php } else { ?>
<img src="<?php echo $ed->foto ?>" class="img-responsive img-circle" width="140px">
<?php } ?>
</div>
</div>
<div class="col-md-1">
<h5 class="text-bold text-lbl-campo"> </h5>
<div>
<button type="submit" class="btn btn-box-tool btn-block form-control text-blue titulo" title="salvar registro">
<i class="fa fa-check-circle fa-2x text-blue"></i> Salvar
</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</section>
<?php } ?>
<!--END ADICIONAR FOTO-->
<?php if ($_usu_admin=='1') { ?>
<!-- TABELA -->
<section class="content">
<div class="card">
<div class="box-header with-border">
<h3 class="box-title text-bold text-blue">Exportação</h3>
<!-- <div class="box-tools pull-right">-->
<!-- <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button>-->
<!-- </div>-->
</div>
<!-- /.box-header -->
<div class="card-content table-responsive">
<table id="impressao" class="table table-bordered table-responsive table-hover">
<thead>
<tr>
<th>ID</th>
<th>Nome</th>
<th class="hidden-xs">Telefone</th>
<th class="hidden-xs">Departamento</th>
<th class="hidden-xs">Secretaria</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
while ($d = $tp->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $d->cod_usuario . "</td>";
echo "<td>" . $d->nome . "</td>";
echo "<td class=\"hidden-xs\">" . $d->fone . "</td>";
echo "<td class=\"hidden-xs\">" . $d->depto_nome . "</td>";
echo "<td class=\"hidden-xs\">" . $d->uo_nome . "</td>";
$id = $d->cod_usuario;
echo "<td><a href='?page=usuario/usuario_g&cod_usuario=$d->cod_usuario' class='botao_editar'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</section>
<?php } ?>
<script>
function validaSenha(input) {
if (input.value != document.getElementById('password').value) {
input.setCustomValidity('A senha digitada não confere! Tente novamente.');
} else {
input.setCustomValidity('');
}
}
</script>
<script>
function validaSenha2(input) {
if (input.value != document.getElementById('password2').value) {
input.setCustomValidity('A senha digitada não confere! Tente novamente.');
} else {
input.setCustomValidity('');
}
}
</script>
<script>
function validaChave(input) {
if (input.value != document.getElementById('chave').value) {
input.setCustomValidity('A chave digitada não confere! Tente novamente.');
} else {
input.setCustomValidity('');
}
}
</script>
</body>
</html>