public function checkLast() { $WsUsers = new WsUsers(); $WsUsers->Execute()->findAll(); if ($WsUsers->Execute()->getRowCount() == 1) { $WsUsers->setThis($WsUsers->Execute()->getResult()[0]); $WsUsers->setUser_level(3); $WsUsers->Execute()->update(null, "user_id"); $WsUsers->Execute()->findAll(); } return $WsUsers; }
private function getUser() { $this->Senha = md5($this->Senha); $WsUsers = new WsUsers(); $WsUsers->setUser_email($this->Email); $WsUsers->setUser_password($this->Senha); $WsUsers->Execute()->Query("#user_email# AND #user_password#"); if ($WsUsers->Execute()->getResult()) { $this->Result = $WsUsers->Execute()->getResult()[0]; return true; } else { return false; } }
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]; } } }
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]; } } }
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; } }
<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> </div><!--/line-->
<?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);
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(); } }
<?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); ?> </span>
<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; ?> </h1>
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; } }
$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; }
<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"> <label class="label"> <span class="field">User:</span>
<?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: