<?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;
}
