public function checkLast()
{
$WsUsers = new WsUsers();
$WsUsers->findAll();
if ($WsUsers->getRowCount() == 1) {
$WsUsers->setThis($WsUsers->getResult()[0]);
$WsUsers->setUser_level(3);
$WsUsers->update();
$WsUsers->findAll();
}
return $WsUsers;
}
function FindUser($User)
{
//remove ZZ de usuarios desativados
$User = str_replace('ZZ ', '', $User);
//separa o primeiro nome do sobrenome
$name_complete = explode(' ', $User);
$user_name = array_shift($name_complete);
$user_lastname = implode(' ', $name_complete);
$Read = new WsUsers();
$Read->setUser_name($user_name);
$Read->setUser_lastname($user_lastname);
$Result = $Read->Execute()->Query("user_name like '%{$user_name}%' AND user_lastname like '%{$user_lastname}%'");
if (!empty($Result)) {
return $Result[0]->user_id;
}
}
function ExeDelete($area_id)
{
$this->Read->setArea_id($area_id);
$this->Read->Execute()->find();
if (!$this->Read->Execute()->getResult()) {
$this->Error = ['A Área que você tentou deletar não existe no sistema!', WS_ERROR];
$this->Result = false;
} else {
$WsUsers = new WsUsers();
$WsUsers->setArea_id($area_id);
$WsUsers->Execute()->find();
$area = $this->Read->Execute()->getResult();
$this->Read->setThis($area);
if ($WsUsers->Execute()->getResult()) {
$this->Error = ["<b>{$this->Read->getArea_title()}</b> não pode ser deletado, pois esta sendo utilizado!", WS_ERROR];
$this->Result = false;
} else {
$this->Read->Execute()->delete();
$this->Error = ["<b>{$area->area_title}</b> foi deletado do sistema!", WS_ACCEPT];
}
}
}
private function getUser()
{
$this->Senha = md5($this->Senha);
$WsUsers = new WsUsers();
if (Check::Email($this->Email)) {
$WsUsers->setUser_email($this->Email);
$login = '******';
} else {
$WsUsers->setUser_nickname($this->Email);
$login = '******';
}
$WsUsers->setUser_password($this->Senha);
$WsUsers->Execute()->Query("{$login} AND #user_password# AND user_status = 1");
if ($WsUsers->Execute()->getResult()) {
$this->Result = $WsUsers->Execute()->getResult()[0];
$this->Result->area_trabalho = $this->getAreaTrabalho($this->Result->area_id);
$this->Result->perfil = $this->getPerfil($this->Result->perfil_id);
return true;
} else {
return false;
}
}
public function ExeDelete($PerfilId)
{
$this->Perfil = (int) $PerfilId;
$ReadPerfil = new WsPerfil();
$ReadPerfil->setPerfil_id($this->Perfil);
$ReadPerfil->Execute()->find();
if (!$ReadPerfil->Execute()->getResult()) {
$this->Error = ['O perfil que você tentou deletar não existe no sistema!', WS_ERROR];
$this->Result = false;
} else {
$WsUsers = new WsUsers();
$WsUsers->setPerfil_id($this->Perfil);
$WsUsers->Execute()->find();
$PerfilDelete = $ReadPerfil->Execute()->getResult();
$ReadPerfil->setThis($PerfilDelete);
if ($WsUsers->Execute()->getResult()) {
$this->Error = ["<b>{$ReadPerfil->getPerfil_title()}</b> não pode ser deletado, pois esta sendo utilizado!", WS_ERROR];
$this->Result = false;
} else {
$ReadPerfil->Execute()->delete();
$this->Error = ["<b>{$PerfilDelete->perfil_title}</b> foi removido com sucesso do sistema!", WS_ACCEPT];
}
}
}
private function getUser()
{
$this->Senha = md5($this->Senha);
$WsUsers = new WsUsers();
$WsUsers->setUser_email($this->Email);
$WsUsers->setUser_password($this->Senha);
$WsUsers->Query("WHERE #user_email# AND #user_password#");
if ($WsUsers->getResult()) {
$this->Result = $WsUsers->getResult()[0];
return true;
} else {
return false;
}
}
?>
</select>
</label>
<label class="label_small">
<span class="field">Author:</span>
<select name="post_author">
<option value="<?php
echo $_SESSION['userlogin']['user_id'];
?>
"> <?php
echo "{$_SESSION['userlogin']['user_name']} {$_SESSION['userlogin']['user_lastname']}";
?>
</option>
<?php
$ReadAut = new WsUsers();
$ReadAut->setUser_id($_SESSION['userlogin']['user_id']);
$ReadAut->setUser_level(2);
$ReadAut->Execute()->Query("user_id != :user_id AND user_level >= :user_level ORDER BY user_name ASC");
if ($ReadAut->Execute()->getRowCount() >= 1) {
foreach ($ReadAut->Execute()->getResult() as $aut) {
echo "<option ";
if ($post['post_author'] == $aut->user_id) {
echo "selected = \"selected\" ";
}
echo "value=\"{$aut->user_id}\"> {$aut->user_name} {$aut->user_lastname} </option>";
}
}
?>
</select>
</label>
<?php
$WsUsers = new WsUsers();
$Termos = "SELECT * FROM ws_users u " . "WHERE MONTH(u.user_birthday) = MOD(MONTH(CURDATE()), 12) " . "AND DAY(u.user_birthday) = DAY(CURDATE())";
$WsUsers->Execute()->FullRead($Termos);
if ($WsUsers->Execute()->getResult()) {
?>
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-body">
<div class="section">
<div class="container">
<div class="row">
<div class="col-md-12">
<h1 class="text-center">Parabéns</h1>
<p class="text-center">Feliz aniversário aos colaboradores.</p>
</div>
</div>
<div class="row">
<?php
foreach ($WsUsers->Execute()->getResult() as $user) {
extract((array) $user);
?>
<div class="col-md-6" id="niver-card">
<?php
<?php
$WsUsers = new WsUsers();
$Termos = "SELECT u.user_id, u.user_nickname, u.user_name, u.user_lastname, u.area_id, u.user_birthday, u.user_cover " . "FROM ws_users u " . "WHERE MONTH(u.user_birthday) = MONTH(CURDATE()) AND u.user_status = 1 ORDER By DAY(u.user_birthday)";
$WsUsers->Execute()->FullRead($Termos);
$export = filter_input(INPUT_GET, "export");
if (!empty($export)) {
$file = $WsUsers->Execute()->getResult();
$dados = [];
$header = array_keys((array) $file[0]);
$dados[] = implode(';', $header);
foreach ($file as $row) {
$array = (array) $row;
$dados[] = implode(";", $array);
}
$texto = implode('\\n', $dados);
?>
<script>
var uri = 'data:text/csv;charset=utf-8,' + escape("<?php
echo $texto;
?>
");
var downloadLink = document.createElement("a");
downloadLink.href = uri;
downloadLink.download = "data.csv";
document.body.appendChild(downloadLink);
downloadLink.click();
document.body.removeChild(downloadLink);
<?php
$Read = new WsUsers();
switch ($method) {
case "GET":
//retorna todos os itens
if (isset($id)) {
$Read->setUser_id($id);
$Read->Execute()->find();
if ($Read->Execute()->getResult()) {
echo json_encode($Read->Execute()->getResult());
} else {
http_response_code(404);
}
} elseif (!empty($query) && $query == 'ativos') {
$Read->Execute()->Query("user_status=1");
Check::JsonReturn($Read->Execute()->getResult(), 'Nenhum atendente cadastrado!', '204');
} else {
$Read->Execute()->findAll();
Check::JsonReturn($Read->Execute()->getResult(), 'Nenhum atendente cadastrado!', '204');
}
break;
case "POST":
if (!empty($request->user_id)) {
//update
$Read->setThis($request);
$Read->Execute()->update(NULL, 'user_id');
echo json_encode($request);
} else {
//salvar
$Read->setThis($request);
<ul class="ultable">
<li class="t_title">
<span class="ui center">User:</span>
<span class="un">Nome:</span>
<span class="ue">E-mail:</span>
<span class="ur center">Nascimento:</span>
<span class="ua center">Atualização:</span>
<span class="ul center">Nível:</span>
<span class="ed center">-</span>
</li>
<?php
$search = filter_input(INPUT_POST, 'search', FILTER_DEFAULT);
if ($search) {
$WsUsers = new WsUsers();
$WsUsers->Execute()->Query("user_nickname like '%{$search}%' OR user_name like '%{$search}%'");
} else {
$WsUsers = $AdminUsers->checkLast();
}
if ($WsUsers->Execute()->getResult()) {
foreach ($WsUsers->Execute()->getResult() as $users) {
extract((array) $users);
$user_lastupdate = $user_lastupdate ? date('d/m/Y H:i', strtotime($user_lastupdate)) . ' hs' : '-';
$nivel = ['', 'Admin', 'Editor', 'Exec', 'Solic', 'User'];
?>
<li>
<span class="ui center"><?php
echo strtoupper($user_nickname);
?>
<div class="trigger-box"></div>
<input class="noclear" type="text" name="action" value="create"/>
<input type="text" name="user_name" placeholder="Nome:"/>
<input type="text" name="user_lastname" placeholder="Sobrenome:"/>
<input type="email" name="user_email" placeholder="Email:"/>
<input type="password" name="user_password" placeholder="Senha:"/>
<input type="number" name="user_level" min="1" max="3" placeholder="Nível de Acesso:"/>
<button>Cadastrar Usuário!</button>
<img class="form_load" src="img/load.gif" alt="[CARREGANDO...]" title="CARREGANDO..."/>
</form>
<div class="j_list">
<?php
require './_app/Config.inc.php';
$WsUsers = new WsUsers();
$WsUsers->Execute()->FullRead("SELECT * FROM ws_users ORDER BY user_id DESC LIMIT 2");
if ($WsUsers->Execute()->getResult()) {
foreach ($WsUsers->Execute()->getResult() as $Users) {
extract((array) $Users);
?>
<article class="user_box" id="<?php
echo $user_id;
?>
">
<h1> <?php
echo $user_name;
?>
<?php
echo $user_lastname;
?>
$jSon['error'] = "<b>OPPPSSS:</b> Sua Senha deve ter entre 5 e 10 caracteres!";
} else {
$WsUsers->setUser_email($post['user_email']);
$WsUsers->Execute()->FullRead("SELECT user_id FROM ws_users WHERE #user_email#");
if ($WsUsers->Execute()->getResult()) {
$jSon['error'] = "<b>OPPPSSS:</b> O email {$post['user_email']} ja esta em uso!";
} else {
$WsUsers->setThis((object) $post);
$WsUsers->Execute()->insert();
$jSon['success'] = "Cadastro com sucesso!";
$jSon['result'] = "<article style='display: none' class='user_box j_register' id='{$WsUsers->Execute()->MaxFild('user_id')}'><h1> {$post['user_name']} {$post['user_lastname']} </h1><p>{$post['user_email']} (Nível {$post['user_level']})</p><a class='action edit j_edit' rel='{$WsUsers->Execute()->MaxFild('user_id')}'>Editar</a><a class='action del' rel='{$WsUsers->Execute()->MaxFild('user_id')}'>Deletar</a></article>";
}
}
break;
case 'loadmore':
$jSon['result'] = null;
$WsUsers = new WsUsers();
$WsUsers->Execute()->FullRead("SELECT * FROM ws_users ORDER BY user_id DESC LIMIT :limit OFFSET :offset", "limit=2&offset={$post['offset']}", true);
if ($WsUsers->Execute()->getResult()) {
foreach ($WsUsers->Execute()->getResult() as $Users) {
extract((array) $Users);
$jSon['result'] .= "<article style='display: none' class='user_box' id='{$user_id}'><h1> {$user_name} {$user_lastname} </h1><p>{$user_email} (Nível {$user_level})</p><a class='action edit j_edit' rel='{$user_id}'>Editar</a><a class='action del' rel='{$user_id}'>Deletar</a></article>";
}
} else {
$jSon['result'] = "<div style='margin: 15px 0 0 0' class='trigger trigger-error'>Não existem resultados</div>";
}
break;
default:
$jSon['error'] = "Erro ao selecionar ação!";
}
echo json_encode($jSon);
<?php
$Read = new WsUsers();
switch ($method) {
case "GET":
//retorna todos os itens
$Read->Execute()->findAll();
Check::JsonReturn($Read->Execute()->getResult(), 'Nenhum usuario cadastrado!', '204');
break;
case "POST":
//update não implementado
echo json_encode($request);
break;
case "DELETE":
//deleta não implementado
echo json_encode($delete);
break;
default:
break;
}
private function UpdateImage()
{
if (is_array($this->Data['user_cover'])) {
$WsUsers = new WsUsers();
$WsUsers->setUser_id($this->Users);
$WsUsers->Execute()->find();
$this->deletaArquivo('../uploads/' . $WsUsers->Execute()->getResult()->user_cover);
$upload = new Upload();
$upload->Image($this->Data['user_cover'], $this->Data['user_name']);
}
if (isset($upload) && $upload->getResult()) {
$this->Data['user_cover'] = $upload->getResult();
$this->Update();
} else {
unset($this->Data['user_cover']);
if (!empty($upload) && $upload->getError()) {
WSErro("<b>ERRO AO ENVIAR CAPA: </b>" . $upload->getError(), E_USER_WARNING);
}
$this->Update();
}
}
<article>
<h1>Atualizar Usuário!</h1>
<?php
$ClienteData = filter_input_array(INPUT_POST, FILTER_DEFAULT);
$User = filter_input(INPUT_GET, 'users', FILTER_VALIDATE_INT);
if ($ClienteData && $ClienteData['SendPostForm']) {
unset($ClienteData['SendPostForm']);
require_once '_models/AdminUsers.class.php';
$AdminUsers = new AdminUsers();
$AdminUsers->ExeUpdate($User, $ClienteData);
WSErro($AdminUsers->getError()[0], $AdminUsers->getError()[1]);
} else {
$Read = new WsUsers();
$Read->setUser_id($User);
$Read->Execute()->Query("#user_id#");
if ($Read->Execute()->getResult()) {
$ClienteData = (array) $Read->Execute()->getResult()[0];
unset($ClienteData['user_password']);
}
}
$checkCreate = filter_input(INPUT_GET, 'create', FILTER_VALIDATE_BOOLEAN);
if ($checkCreate && empty($AdminUsers)) {
WSErro("O Usuário <b>{$ClienteData['user_name']}</b> foi cadastrado com sucesso no sistema!", WS_ACCEPT);
}
?>
<form action = "" method = "post" name = "UserCreateForm">
<?php
$Read = new WsUsers();
switch ($method) {
case "GET":
//retorna todos os itens
if (isset($id)) {
$Read->setUser_id($id);
$Read->Execute()->find();
if ($Read->Execute()->getResult()) {
echo json_encode($Read->Execute()->getResult());
} else {
http_response_code(404);
}
} elseif (!empty($query) && $query == 'ativos') {
$Read->Execute()->Query("user_status=1");
Check::JsonReturn($Read->Execute()->getResult(), 'Nenhuma meta cadastrada!', '204');
} else {
$Read->Execute()->findAll();
Check::JsonReturn($Read->Execute()->getResult(), 'Nenhuma meta cadastrada!', '204');
}
break;
case "POST":
//update não implementado
echo json_encode($request);
break;
case "DELETE":
//deleta não implementado
echo json_encode($delete);
break;
default:
