Viewing File: /home/cienp/public_html/portal/res_user.php
<?php
if ($_POST[passa] == 'yes') {
require "$this->include_dir/conecta.php";
if ($_POST[v_nm_user] != "")
$selnome = "AND UPPER(u.nm_user) LIKE UPPER('%$_POST[v_nm_user]%')";
if ($_POST[v_lg_user] != "")
$sellogin = "AND UPPER(u.lg_user) LIKE UPPER('$_POST[v_lg_user]')";
if ($_POST[v_fl_atvo] != "")
$selatvo = "AND u.fl_atvo = '$_POST[v_fl_atvo]'";
if ($_POST[v_fl_solc] != "")
$selsolc = "AND u.fl_solc = '$_POST[v_fl_solc]'";
if ($_POST[v_fl_anim] != "")
$selanim = "AND u.fl_anim = '$_POST[v_fl_anim]'";
$sql = "SELECT DISTINCT(u.id_user), u.nm_user, u.lg_user, u.fl_atvo, u.fl_solc, u.fl_anim, u.fl_extr, u.de_mail ";
$sql .= "FROM ".$pref_tabl."user u ";
$sql .= "WHERE u.id_user = u.id_user ";
$sql .= "$selnome $sellogin $selatvo $selsolc $selanim ";
$sql .= "ORDER BY u.nm_user ";
#echo $sql."<br>";
$res = mysqli_query($conn, $sql);
if (mysqli_num_rows($res) > 0){
?>
<div class="right_col" role="main">
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Resultado da Busca - Usuários<small>Gerenciador de Usuários</small></h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12 text-center">
<ul class="pagination pagination-split">
<!--<li><a href="#">A</a></li>
<li><a href="#">B</a></li>
<li><a href="#">C</a></li>
<li><a href="#">D</a></li>
<li><a href="#">E</a></li>
<li>...</li>
<li><a href="#">W</a></li>
<li><a href="#">X</a></li>
<li><a href="#">Y</a></li>
<li><a href="#">Z</a></li>-->
</ul>
</div>
<div class="clearfix"></div>
<?php
while ($linha = mysqli_fetch_array($res)){
if (file_exists("img_user/user_$linha[id_user].jpg"))
$de_imag = "<img src='$this->site_root/img_user/user_user_$linha[id_user].jpg' class='img-circle profile_img' alt='$linha[nm_user]' title='$linha[nm_user]'/>";
else
$de_imag = "<img src='$this->site_root/img_user/user-default.png' class='img-circle profile_img' alt='$linha[nm_user]' title='$linha[nm_user]'/>";
switch($linha[fl_atvo]) {
case 'S':
$fl_atvo = '<span style="color:#26B99A;"><i class="fa fa-check" aria-hidden="true"></i> Sim</span>';
break;
case 'N':
$fl_atvo = '<span style="color:#d9534f;"><i class="fa fa-close" aria-hidden="true"></i> Não</span>';
break;
}
switch($linha[fl_solc]) {
case 'D':
$fl_solc = 'Direção';
break;
case 'P':
$fl_solc = 'Compras';
break;
case 'C':
$fl_solc = 'Comum';
break;
}
switch($linha[fl_anim]) {
case 'D':
$fl_anim = 'Direção';
break;
case 'A':
$fl_anim = 'Administrador';
break;
case 'B':
$fl_anim = 'Biotério';
break;
case 'C':
$fl_anim = 'Comum';
break;
}
switch($linha[fl_extr]) {
case 'N':
$fl_extr = 'CIEnP';
break;
case 'S':
$fl_extr = 'Externo';
break;
}
?>
<div class="col-lg-4 col-md-6 col-sm-12 col-xs-12 profile_details">
<div class="well profile_view">
<div class="col-sm-12">
<h4 class="brief"><i>Usuário CIEnP</i></h4>
<div class="left col-xs-7">
<h2><?php echo $linha['nm_user'] ?></h2>
<p><i class="fa fa-edit" aria-hidden="true"></i> <strong>Login: </strong> <?php echo $linha['lg_user'] ?> </p>
<p><i class="fa fa-envelope" aria-hidden="true"></i> <strong>E-mail: </strong> <?php echo $linha['de_mail'] ?> </p>
<p><i class="fa fa-user" aria-hidden="true"></i> <strong>Ativo: </strong> <?php echo $fl_atvo?> </p>
<p><i class="fa fa-users" aria-hidden="true"></i> <strong>Tipo: </strong> <?php echo $fl_solc?> </p>
<p><i class="fa fa-users" aria-hidden="true"></i> <strong>SA: </strong> <?php echo $fl_anim?> </p>
<p><i class="fa fa-users" aria-hidden="true"></i> <strong>Acesso: </strong> <?php echo $fl_extr?> </p>
</div>
<div class="right col-xs-5 text-center">
<?=$de_imag?>
</div>
</div>
<div class="col-xs-12 bottom">
<div class="col-xs-12">
<a href="javascript:alt_user('<?php echo $linha['id_user'] ?>')" class="btn btn-info btn-xs">
<i class="fa fa-pencil" aria-hidden="true"></i> Alterar
</a>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12" style="padding:0px; margin-bottom:10px;">
<a href="javascript:voltar();"><button class="btn btn-primary" type="button">Voltar</button></a>
</div>
</div>
</div>
</div>
</div>
<?php
} else {
?>
<div class="right_col" role="main">
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Resultado da Busca - Usuários<small>Subtítulo da página</small></h2>
<div class="clearfix"></div>
</div>
<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Alerta!</strong> Nenhum usuário com estas caracteristicas foi encontrado!
</div>
<div class="form-group">
<div class="col-md-6 col-sm-6 col-xs-12" style="padding:0px; margin-bottom:10px;">
<a href="javascript:voltar();"><button class="btn btn-primary" type="button">Voltar</button></a>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
<SCRIPT LANGUAGE="javascript">
function alt_user(xb){
document.acidente.action = "index1.php?pg=alt_user";
document.acidente.id_user.value = xb;
document.acidente.submit();
}
function voltar(){
document.acidente.action = "index1.php?pg=pesq_user";
document.acidente.submit();
}
</script>
<form name="acidente" method="post" action="" style="margin:0px !important;">
<input type="hidden" name="id_user">
<input type="hidden" name="v_nm_user" id="v_nm_user" value="<?=$_POST[v_nm_user]?>">
<input type="hidden" name="v_lg_user" id="v_lg_user" value="<?=$_POST[v_lg_user]?>">
<input type="hidden" name="v_fl_atvo" id="v_fl_atvo" value="<?=$_POST[v_fl_atvo]?>">
<input type="hidden" name="v_fl_solc" id="v_fl_solc" value="<?=$_POST[v_fl_solc]?>">
<input type="hidden" name="v_fl_anim" id="v_fl_anim" value="<?=$_POST[v_fl_anim]?>">
<input type="hidden" name="passa" id="passa" value="yes">
</form>
<?php
} else {
require "erro.php";
}
?>
Back to Directory
File Manager