<?php $Read = new Controle('ws_perfil_has_ws_acesso'); switch ($method) { case "GET": //retorna todos os itens if ($id) { $sql = "SELECT * FROM ws_perfil_has_ws_acesso pa " . "JOIN ws_perfil p ON(p.perfil_id = pa.perfil_id) " . "JOIN ws_acesso a ON(a.acesso_id = pa.acesso_id) " . "WHERE pa.perfil_id = :perfil_id"; $Read->FullRead($sql, "perfil_id={$id}", true); Check::JsonReturn($Read->getResult(), 'Perfil sem acessos cadastrados', 204); } else { $Read->findAll(); Check::JsonReturn($Read->getResult(), 'Nenhum perfil cadastrado!', 204); } break; case "POST": if ($request->id) { $message = ['message' => 'Salvo com sucesso!', 'status' => 200]; //deleta todos os dados deste pefil $Read->delete("perfil_id={$request->id}"); foreach ($request->list as $value) { $Read->insert("perfil_id={$request->id}&acesso_id={$value->acesso_id}"); } echo json_encode($message); } break; case "DELETE": //deleta arquivo break; default: break;
private function getRow() { $Read = new Controle($this->Tabela); if (!empty($this->Places)) { $Read->Query($this->Termos, $this->Places, $this->BindParam); } else { $Read->findAll(); } return $Read->getRowCount(); }
<?php //Objeto READ $read = new Controle(); //VISITAS DO SITE $read->FullRead("SELECT SUM(siteviews_views) AS views FROM ws_siteviews"); $Views = $read->getResult()[0]->views; //USUÁRIOS $read->FullRead("SELECT SUM(siteviews_users) AS users FROM ws_siteviews"); $Users = $read->getResult()[0]->users; //MÉDIA DE PAGEVIEWS $read->FullRead("SELECT SUM(siteviews_pages) AS pages FROM ws_siteviews"); $ResPages = $read->getResult()[0]->pages; $Pages = substr($ResPages / ($Users == 0 ? 1 : $Users), 0, 5); //POSTS $read->setTable("ws_posts"); $read->findAll(); $Posts = $read->getRowCount(); // //EMPRESAS // $read->setTable("app_empresas"); // $read->findAll(); // $Empresas = $read->getRowCount(); ?> <ul> <li class="view"><span><?php echo $Views; ?> </span> visitas</li> <li class="user"><span><?php echo $Users; ?>
public function findAll() { $this->Result = parent::findAll(); return $this->Result; }