| Server IP : 74.208.127.88 / Your IP : 3.139.239.16 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/t/sae/appsae/core/controller/ |
Upload File : |
<?php
//Include Functions
include('includes/Functions.php');
//Include Notifications
include ('includes/notification.php');
//delete account
if(isset($_POST['submitin'])){
$CategoryIds = $_POST['categoryid'];
$Delete = "UPDATE user SET kind = 20 WHERE UserId = $CategoryIds";
$DeleteI = mysqli_query($mysqli,$Delete);
$msgBox = alertBox("Registro deshabilitado");
}
if(isset($_POST['habilitar'])){
$CategoryIds = $_POST['categoryid'];
$Delete = "UPDATE user SET kind = 2 WHERE UserId = $CategoryIds";
$DeleteI = mysqli_query($mysqli,$Delete);
$msgBox = alertBox("Registro habilitado");
}
//Edit account
if(isset($_POST['edit'])){
$CategoryIds = $_POST['CategoryIds'];
$FirstName = $_POST['FirstName'];
$LastName = $_POST['LastName'];
$Email = $_POST['Email'];
$sql="UPDATE user SET FirstName = ?, LastName = ?, Email = ? WHERE UserId = $CategoryIds";
if($statement = $mysqli->prepare($sql)){
//bind parameters for markers, where (s = string, i = integer, d = double, b = blob)
$statement->bind_param('sss', $FirstName,$LastName,$Email);
$statement->execute();
}
$msgBox = alertBox($UpdateMsgHouse);
}
// add new category
if (isset($_POST['submit'])) {
$FirstName = $mysqli->real_escape_string($_POST["FirstName"]);
$LastName = $mysqli->real_escape_string($_POST["LastName"]);
$Email = $mysqli->real_escape_string($_POST["Email"]);
$pass = $mysqli->real_escape_string("827ccb0eea8a706c4c34a16891f84e7b");
$currency = $mysqli->real_escape_string("$");
$category = $mysqli->real_escape_string($_POST["account"]);
//add new category
$sql="INSERT INTO user (FirstName,LastName,Email,Password,Currency) VALUES (?,?,?,?,?)";
if($statement = $mysqli->prepare($sql)){
//bind parameters for markers, where (s = string, i = integer, d = double, b = blob)
$statement->bind_param('sssss', $FirstName,$LastName,$Email,$pass,$currency);
$statement->execute();
}
$msgBox = alertBox($SaveMsgHouse);
}
//Get list category
$GetList = "SELECT * FROM user WHERE kind > 0 ORDER BY FirstName ASC";
$GetListCategory = mysqli_query($mysqli,$GetList);
//print_r($GetListCategory);
//die;
// Search category
if (isset($_POST['searchbtn'])) {
$SearchTerm = $_POST['search'];
//$GetList = "SELECT * FROM `tags` WHERE name like '%".$SearchTerm."%' ORDER BY street ASC";
$GetList = "SELECT * FROM user WHERE FirstName like '%".$SearchTerm."%' ORDER BY FirstName ASC";
$GetListCategory = mysqli_query($mysqli,$GetList);
//print_r($GetListCategory);
//echo "buscando...";
}
//Include Global page
include ('includes/global.php');
?>
<div id="page-wrapper">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header"><?php echo "Administracion de usuarios del Sistema"; ?> </h1>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<?php if ($msgBox) { echo $msgBox; } ?>
<a href="#new" class="btn white btn-black " style=" background: linear-gradient(to bottom right, white, black, green);" data-toggle="modal"><i class="fa fa-plus"></i> <?php echo "Agregar Usuarios"; ?></a>
<a href="https://phathomexico.club/cerradas/index.php?page=ManageUsersDes" class="btn white btn-black " style=" background: linear-gradient(to bottom right, blue, black, red);" data-toggle="modal"><i class="fa fa-plus"></i> <?php echo "Agregar Usuarios"; ?></a>
<div class="row">
<div class="col-lg-12">
<!-- /.panel -->
<div class="panel panel-info">
<div class="panel-heading" style=" background: linear-gradient(to bottom right, white, black, green); ">
<i class="fa fa-tags"></i> <?php echo "Lista"; ?>
</div>
<div class="panel-body">
<div class="pull-right">
<form action="" method="post">
<div class="form-group input-group col-lg-5 pull-right">
<input type="text" name="search" id="search" placeholder="<?php echo $Search; ?>" class="form-control">
<span class="input-group-btn" style="background: linear-gradient(to bottom right, white, black, green);">
<button class="btn btn-black" name="searchbtn" type="input"><i class="fa fa-search"></i>
</button>
</span>
</div>
</form>
</div>
<div class="">
<table class="table table-bordered table-hover table-striped" id="assetsdata">
<thead>
<tr>
<th class="text-left"><?php echo "id"; ?></th>
<th class="text-left"><?php echo "Nombre"; ?></th>
<th class="text-left"><?php echo "Correo"; ?></th>
<th class="text-left"><?php echo $Action; ?></th>
</tr>
</thead>
<tbody>
<?php while($col = mysqli_fetch_assoc($GetListCategory)){ ?>
<tr>
<td><?php echo $col['UserId'];?></td>
<td class="text-left"><?php echo $col['FirstName']." ".$col['LastName'] ; ?></td>
<td class="text-left"><?php echo $col['Email'] ; ?></td>
<td class="notification">
<a href="#EditCat<?php echo $col['UserId'];?>" class="" data-toggle="modal"><span class="btn btn-primary btn-xs glyphicon glyphicon-edit" data-toggle="tooltip" data-placement="left" title="" data-original-title="<?php echo "Editar Registro"; ?>"></span></a>
<a href="#DeleteCat<?php echo $col['UserId'];?>" data-toggle="modal"><span class=" glyphicon glyphicon-ban-circle btn btn-warning btn-xs" data-toggle="tooltip" data-placement="right" title="" data-original-title="<?php echo "Deshabilitar"; ?>"></span></a>
<a href="#Habilitar<?php echo $col['UserId'];?>" data-toggle="modal"><span class=" glyphicon glyphicon-home btn btn-success btn-xs" data-toggle="tooltip" data-placement="right" title="" data-original-title="<?php echo "habilitar"; ?>"></span></a>
</td>
</tr>
</tbody>
<div class="modal fade" id="DeleteCat<?php echo $col['UserId'];?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<form action="" method="post">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel"><?php echo $AreYouSure; ?></h4>
</div>
<div class="modal-body">
<?php echo "Usuarios"; ?>
</div>
<div class="modal-footer">
<input type="hidden" id="categoryid" name="categoryid" value="<?php echo $col['UserId']; ?>" />
<button type="input" id="submit" name="submitin" class="btn btn-primary"><?php echo $Yes; ?></button>
<button type="button" class="btn btn-default" data-dismiss="modal"><?php echo $Cancel; ?></button>
</form>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<div class="modal fade" id="Habilitar<?php echo $col['UserId'];?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<form action="" method="post">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel"><?php echo "Desea Habilitar a este usuario"; ?></h4>
</div>
<div class="modal-body">
<?php echo "Usuarios"; ?>
</div>
<div class="modal-footer">
<input type="hidden" id="categoryid" name="categoryid" value="<?php echo $col['UserId']; ?>" />
<button type="input" id="submit" name="habilitar" class="btn btn-primary"><?php echo $Yes; ?></button>
<button type="button" class="btn btn-default" data-dismiss="modal"><?php echo $Cancel; ?></button>
</form>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!-- /.modal -->
<!-- /.edit category -->
<div class="modal fade" id="EditCat<?php echo $col['UserId'];?>" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<form action="" method="post">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel"><?php echo "Editar Usuario"; ?></h4>
</div>
<div class="modal-body">
<div class="form-group">
<label for="category"><?php echo "Nombre"; ?></label>
<input class="form-control" required name="FirstName" value="<?php echo $col['FirstName']; ?>" type="text" autofocus>
</div>
</div>
<div class="modal-body">
<div class="form-group">
<label for="category"><?php echo "Apellido"; ?></label>
<input class="form-control" required name="LastName" value="<?php echo $col['LastName']; ?>" type="text" autofocus>
</div>
</div>
<div class="modal-body">
<div class="form-group">
<label for="category"><?php echo "Correo"; ?></label>
<input class="form-control" required name="Email" value="<?php echo $col['Email']; ?>" type="text" autofocus>
</div>
</div>
<div class="modal-footer">
<input type="hidden" id="CategoryIds" name="CategoryIds" value="<?php echo $col['UserId']; ?>" />
<button type="input" id="submit" name="edit" class="btn btn-primary"><?php echo $Save; ?></button>
<button type="button" class="btn btn-default" data-dismiss="modal"><?php echo $Cancel; ?></button>
</form>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
<!-- /.modal -->
<?php } ?>
<tfoot>
<tr>
<th class="text-left"><?php echo "id"; ?></th>
<th class="text-left"><?php echo "Nombre"; ?></th>
<th class="text-left"><?php echo "Correo"; ?></th>
<th class="text-left"><?php echo $Action; ?></th>
</tr>
</tfoot>
</table>
</div>
<!-- /.table-responsive -->
</div>
</div>
</div>
<!-- /.col-lg-4 -->
</div>
<!-- /.row -->
</div>
<!-- /#page-wrapper -->
<div class="modal fade" id="new" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<form action="" method="post">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="myModalLabel"><?php echo "Agregar Usuario"; ?></h4>
</div>
<div class="modal-body">
<div class="form-group">
<label for="category"><?php echo "Nombre"; ?></label>
<input class="form-control" required placeholder="<?php echo "Nombre"; ?>" name="account" type="text" autofocus>
</div>
</div>
<div class="modal-body">
<div class="form-group">
<label for="category"><?php echo "Apellido"; ?></label>
<input class="form-control" required placeholder="<?php echo "Apellidos"; ?>" name="account" type="text" autofocus>
</div>
</div>
<div class="modal-body">
<div class="form-group">
<label for="category"><?php echo "Correo"; ?></label>
<input class="form-control" required placeholder="<?php echo "Correo"; ?>" name="account" type="text" autofocus>
</div>
</div>
<div class="modal-footer">
<button type="submit" name="submit" class="btn btn-success"><span class=""></span> <?php echo $Save; ?></button>
<button type="button" class="btn btn-default" data-dismiss="modal"><?php echo $Cancel; ?></button>
</form>
</div>
</div>
<!-- /.modal-content -->
</div>
<script>
$(function() {
$('.notification').tooltip({
selector: "[data-toggle=tooltip]",
container: "body"
})
});
</script>