private function getSeo()
{
$ReadSeo = new WsPosts();
switch ($this->File) {
case 'artigo':
$Admin = isset($_SESSION['userlogin']['user_level']) && $_SESSION['userlogin']['user_level'] == 3 ? true : false;
$Check = $Admin ? '' : 'post_status = 1 AND ';
$ReadSeo->setPost_name($this->Link);
$ReadSeo->Query("WHERE {$Check} #post_name#");
if (!$ReadSeo->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->getResult()[0]);
$this->seoData = (array) $ReadSeo->getResult()[0];
$this->Data = [$post_title . ' - ' . SITENAME, $post_content, HOME . "/artigo/{$post_name}", HOME . "/uploads/{$post_cover}"];
//post:: post_views
$ReadSeo->setPost_id($post_id);
$ReadSeo->setPost_views($post_views + 1);
$ReadSeo->setPost_last_views(date('Y-m-d H:i:s'));
$ReadSeo->update();
}
break;
case 'index':
$this->Data = [SITENAME . ' - Seu Guia de empresas, eventos e baladas!', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
default:
$this->Data = ['404 Oppss, Nada encontrado!', SITEDESC, HOME . '/404', INCLUDE_PATH . '/images/site.png'];
break;
}
if ($this->Data) {
$this->setTags();
}
}
/**
* <b>Obter post:</b> Informe o name (url) de uma categoria para obter o ID da mesma.
* @param STRING $post_name = URL da postagem
* @return INT $post_id = id do post informada
*/
public static function PostByName($PostByName)
{
$Read = new WsPosts();
$Read->setPost_name($PostByName);
$query = $Read->Execute()->Query('#post_name#');
if ($Read->Execute()->getResult()) {
return (int) $query[0]->post_id;
} else {
WSErro("O post <b>{$PostByName}</b> não foi encontrado!", WS_ERROR);
return null;
}
}
private function getSeo()
{
switch ($this->File) {
//SEO:: ARTIGO
case 'artigo':
$Admin = isset($_SESSION['userlogin']['user_level']) && $_SESSION['userlogin']['user_level'] == 3 ? true : false;
$Check = $Admin ? '' : 'post_status = 1 AND ';
$ReadSeo = new WsPosts();
$ReadSeo->setPost_name($this->Link);
$ReadSeo->Execute()->Query("{$Check} #post_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$post_title . ' - ' . SITENAME, $post_content, HOME . "/artigo/{$post_name}", HOME . "/uploads/{$post_cover}"];
//post:: conta viws do post
$ReadSeo->setPost_id($post_id);
$ReadSeo->setPost_views($post_views + 1);
$ReadSeo->setPost_last_views(date('Y-m-d H:i:s'));
$ReadSeo->Execute()->update($ReadSeo->Execute()->getDados(), 'post_id');
}
break;
//SEO:: CATEGORIA
//SEO:: CATEGORIA
case 'categoria':
$ReadSeo = new WsCategories();
$ReadSeo->setCategory_name($this->Link);
$ReadSeo->Execute()->Query("#category_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$category_title . ' - ' . SITENAME, $category_content, HOME . "/categoria/{$category_name}", INCLUDE_PATH . '/images/site.png'];
//categories:: conta views da categoria
$ReadSeo->setCategory_id($category_id);
$ReadSeo->setCategory_views($category_views + 1);
$ReadSeo->setCategory_last_view(date('Y-m-d H:i:s'));
$ReadSeo->Execute()->update($ReadSeo->Execute()->getDados(), 'category_id');
}
break;
//SEO::PESQUISA
//SEO::PESQUISA
case 'pesquisa':
$ReadSeo = new WsPosts();
$ReadSeo->Execute()->Query("post_status = 1 AND (post_title LIKE '%' :link '%' OR post_content LIKE '%' :link '%')", "link={$this->Link}");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
$this->seoData['count'] = $ReadSeo->Execute()->getRowCount();
$this->Data = ["Pesquisa por: \"{$this->Link}\"" . ' - ' . SITENAME, "Sua pesquisa por {$this->Link} retornou {$this->seoData['count']} resultados!", HOME . "/pesquisa/{$this->Link}", INCLUDE_PATH . '/images/site.png'];
}
break;
//SEO:: EMPRESAS
//SEO:: EMPRESAS
case 'empresas':
$Name = ucwords(str_replace("-", " ", $this->Link));
$this->seoData = ['empresa_link' => $this->Link, 'empresa_cat' => $Name];
$this->Data = ["Empresas {$this->Link}" . SITENAME, "Confira o guia completo de sua cidade, e encontra empresas {$this->Link}", HOME . '/empresas/' . $this->Link, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: EMPRESA SINGLE
//SEO:: EMPRESA SINGLE
case 'empresa':
$Admin = isset($_SESSION['userlogin']['user_level']) && $_SESSION['userlogin']['user_level'] == 3 ? true : false;
$Check = $Admin ? '' : 'empresa_status = 1 AND ';
$ReadSeo = new AppEmpresas();
$ReadSeo->setEmpresa_name($this->Link);
$ReadSeo->Execute()->Query("{$Check} #empresa_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$empresa_title . ' - ' . SITENAME, $empresa_sobre, HOME . "/empresa/{$empresa_name}", HOME . "/uploads/{$empresa_capa}"];
//empresa:: conta views da empresa
$ReadSeo->setEmpresa_id($empresa_id);
$ReadSeo->setEmpresa_views($empresa_views + 1);
$ReadSeo->setEmpresa_last_view(date('Y-m-d H:i:s'));
$ReadSeo->Execute()->update($ReadSeo->Execute()->getDados(), 'empresa_id');
}
break;
//SEO:: CADASTRA EMPRESA
//SEO:: CADASTRA EMPRESA
case 'cadastra-empresa':
$this->Data = ["Cadastre sua Empresa - " . SITENAME, "Página modelo para cadastro de empresas via Front-End do curso Work Series - PHP Orientado a Objetos!", HOME . '/cadastra-empresa/' . $this->Link, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: INDEX
//SEO:: INDEX
case 'index':
$this->Data = [SITENAME . ' - Seu Guia de empresas, eventos e baladas!', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: 404
//SEO:: 404
default:
$this->Data = ['404 Oppss, Nada encontrado!', SITEDESC, HOME . '/404', INCLUDE_PATH . '/images/site.png'];
break;
}
if ($this->Data) {
$this->setTags();
}
}
private function getSeo()
{
switch ($this->File) {
//SEO:: ARTIGO
case 'artigo':
$Admin = isset($_SESSION['userlogin']['user_level']) && $_SESSION['userlogin']['user_level'] == 3 ? true : false;
$Check = $Admin ? '' : 'post_status = 1 AND ';
$ReadSeo = new WsPosts();
$ReadSeo->setPost_name($this->Link);
$ReadSeo->Execute()->Query("{$Check} #post_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$post_title . ' - ' . SITENAME, $post_content, HOME . "/artigo/{$post_name}", HOME . "/uploads/{$post_cover}"];
//post:: conta viws do post
$ReadSeo->setPost_id($post_id);
$ReadSeo->setPost_views($post_views + 1);
$ReadSeo->setPost_last_views(date('Y-m-d H:i:s'));
$ReadSeo->Execute()->update($ReadSeo->Execute()->getDados(), 'post_id');
}
break;
//SEO:: NOTICIAS
//SEO:: NOTICIAS
case 'noticias':
$ReadSeo = new WsPosts();
$ReadSeo->setPost_type($this->Link);
$ReadSeo->Execute()->Query("#post_type#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult();
$this->Data = [$post_type . ' - ' . SITENAME, $post_content, HOME . "/noticias/{$post_type}", INCLUDE_PATH . '/images/site.png'];
}
break;
//SEO:: CATEGORIA
//SEO:: CATEGORIA
case 'categoria':
$ReadSeo = new WsCategories();
$ReadSeo->setCategory_name($this->Link);
$ReadSeo->Execute()->Query("#category_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$category_title . ' - ' . SITENAME, $category_content, HOME . "/categoria/{$category_name}", INCLUDE_PATH . '/images/site.png'];
//categories:: conta views da categoria
$ReadSeo->setCategory_id($category_id);
$ReadSeo->setCategory_views($category_views + 1);
$ReadSeo->setCategory_last_view(date('Y-m-d H:i:s'));
$ReadSeo->Execute()->update($ReadSeo->Execute()->getDados(), 'category_id');
}
break;
//SEO::PESQUISA
//SEO::PESQUISA
case 'pesquisa':
$ReadSeo = new WsPosts();
$ReadSeo->Execute()->Query("post_status = 1 AND (post_title LIKE '%' :link '%' OR post_content LIKE '%' :link '%')", "link={$this->Link}");
if (!$ReadSeo->Execute()->getResult()) {
$this->Data = ["Pesquisa por: \"{$this->Link}\"" . ' - ' . SITENAME, "Sua pesquisa por {$this->Link} retornou {$this->seoData['count']} resultados!", HOME . "/pesquisa/{$this->Link}", INCLUDE_PATH . '/images/site.png'];
$this->seoTags = null;
} else {
$this->seoData['count'] = $ReadSeo->Execute()->getRowCount();
$this->Data = ["Pesquisa por: \"{$this->Link}\"" . ' - ' . SITENAME, "Sua pesquisa por {$this->Link} retornou {$this->seoData['count']} resultados!", HOME . "/pesquisa/{$this->Link}", INCLUDE_PATH . '/images/site.png'];
}
break;
//SEO:: INDEX
//SEO:: INDEX
case 'index':
$this->Data = [SITENAME . ' - ' . SITEDESC, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
case 'pages':
switch ($this->Link) {
//SEO:: Contato
case 'contato':
$this->Data = [SITENAME . ' - Fale conosco', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: membros
//SEO:: membros
case 'membros':
$this->Data = [SITENAME . ' - Parceiros da causa.', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: institucional
//SEO:: institucional
case 'institucional':
$this->Data = [SITENAME . ' - Institucional.', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: 404
//SEO:: 404
default:
$this->Data = ['404 Oppss, Nada encontrado!', SITEDESC, HOME . '/404', INCLUDE_PATH . '/images/site.png'];
break;
}
break;
//SEO:: 404
//SEO:: 404
default:
$this->Data = ['404 Oppss, Nada encontrado!', SITEDESC, HOME . '/404', INCLUDE_PATH . '/images/site.png'];
break;
}
if ($this->Data) {
$this->setTags();
}
}
private function getSeo()
{
switch ($this->File) {
//SEO:: Indicadores
case 'indicadores':
$this->Data = ['Indicadores de qualidade - ' . SITENAME . ' - ' . SITEDESC, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
case 'profile':
$this->Data = ['Dados cadastrais - ' . SITENAME . ' - ' . SITEDESC, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: ARTIGO
//SEO:: ARTIGO
case 'artigo':
$Admin = isset($_SESSION['userlogin']['user_level']) && $_SESSION['userlogin']['user_level'] == 3 ? true : false;
$Check = $Admin ? '' : 'post_status = 1 AND ';
$ReadSeo = new WsPosts();
$ReadSeo->setPost_name($this->Link);
$ReadSeo->Execute()->Query("{$Check} #post_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$post_title . ' - ' . SITENAME, $post_content, HOME . "/artigo/{$post_name}", HOME . "/uploads/{$post_cover}"];
//post:: conta viws do post
Check::ContPostViews($post_id);
}
break;
//SEO:: NOTICIAS
//SEO:: NOTICIAS
case 'noticias':
$ReadSeo = new WsPosts();
$ReadSeo->setPost_type($this->Link);
$ReadSeo->Execute()->Query("#post_type#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult();
$this->Data = [$post_type . ' - ' . SITENAME, $post_content, HOME . "/noticias/{$post_type}", INCLUDE_PATH . '/images/site.png'];
}
break;
//SEO:: CATEGORIA
//SEO:: CATEGORIA
case 'categoria':
$ReadSeo = new WsCategories();
$ReadSeo->setCategory_name($this->Link);
$ReadSeo->Execute()->Query("#category_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$category_title . ' - ' . SITENAME, $category_content, HOME . "/categoria/{$category_name}", INCLUDE_PATH . '/images/site.png'];
//categories:: conta views da categoria
Check::ContCategoryViews($category_id);
}
break;
//SEO:: Grupo
//SEO:: Grupo
case 'grupo':
$ReadSeo = new WsCategories();
$ReadSeo->setCategory_name($this->Link);
$ReadSeo->Execute()->Query("#category_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$category_title . ' - ' . SITENAME, $category_content, HOME . "/categoria/{$category_name}", INCLUDE_PATH . '/images/site.png'];
//categories:: conta views da categoria
Check::ContCategoryViews($category_id);
}
break;
//SEO:: membros
//SEO:: membros
case 'membros':
$ReadSeo = new WsCategories();
$ReadSeo->setCategory_name($this->Link);
$ReadSeo->Execute()->Query("#category_name#");
if (!$ReadSeo->Execute()->getResult()) {
$this->seoData = null;
$this->seoTags = null;
} else {
extract((array) $ReadSeo->Execute()->getResult()[0]);
$this->seoData = (array) $ReadSeo->Execute()->getResult()[0];
$this->Data = [$category_title . ' - ' . SITENAME, $category_content, HOME . "/membros/{$category_name}", INCLUDE_PATH . '/images/site.png'];
//categories:: conta views da categoria
Check::ContCategoryViews($category_id);
}
break;
//SEO::PESQUISA
//SEO::PESQUISA
case 'pesquisa':
$ReadSeo = new WsPosts();
$ReadSeo->Execute()->Query("post_status = 1 AND (post_title LIKE '%' :link '%' OR post_content LIKE '%' :link '%')", "link={$this->Link}");
if (!$ReadSeo->Execute()->getResult()) {
$this->Data = ["Pesquisa por: \"{$this->Link}\"" . ' - ' . SITENAME, "Sua pesquisa por {$this->Link} retornou {$this->seoData['count']} resultados!", HOME . "/pesquisa/{$this->Link}", INCLUDE_PATH . '/images/site.png'];
$this->seoTags = null;
} else {
$this->seoData['count'] = $ReadSeo->Execute()->getRowCount();
$this->Data = ["Pesquisa por: \"{$this->Link}\"" . ' - ' . SITENAME, "Sua pesquisa por {$this->Link} retornou {$this->seoData['count']} resultados!", HOME . "/pesquisa/{$this->Link}", INCLUDE_PATH . '/images/site.png'];
}
break;
//SEO:: INDEX
//SEO:: INDEX
case 'index':
$this->Data = [SITENAME . ' - ' . SITEDESC, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: PAGES
//SEO:: PAGES
case 'pages':
switch ($this->Link) {
//SEO:: Contato
case 'contato':
$this->Data = ['Fale conosco - ' . SITENAME, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: Contato
//SEO:: Contato
case 'aniversarios':
$this->Data = ['Parabéns colegas - ' . SITENAME, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: Qualidade
//SEO:: Qualidade
case 'qualidade':
$this->Data = ['Formularios da Qualidade - ' . SITENAME, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: SOBRE
//SEO:: SOBRE
case 'sobre':
$this->Data = ['Sobre a Intranet - ' . SITENAME, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: INSTITUCIONAL
//SEO:: INSTITUCIONAL
case 'institucional':
$this->Data = ['Instituição Tommasi - ' . SITENAME, SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: 404
//SEO:: 404
default:
$this->Data = ['404 Oppss, Nada encontrado!', SITEDESC, HOME . '/404', INCLUDE_PATH . '/images/site.png'];
break;
}
break;
//SEO:: PLUGIN
//SEO:: PLUGIN
case 'plugin':
switch ($this->Link) {
//SEO:: Contadores de Impresão
case 'contadores-de-impressao':
$this->Data = ['Contadores de impressão - Registra os contadores de cada Mês', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: Fast Exames
//SEO:: Fast Exames
case 'fast-exames':
$this->Data = ['Fast Exames Tommasi - Formulario de alteração de exames', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: Agenda
//SEO:: Agenda
case 'agenda':
$this->Data = ['Agenda telefonica - Lista Telefonica Tommasi', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: Aniversarios
//SEO:: Aniversarios
case 'aniversarios':
$this->Data = ['Aniversariantes do mês - ' . SITENAME . '| Parabéns a todos do grupo tommasi.', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
//SEO:: 404
//SEO:: 404
default:
$this->Data = [SITENAME . ' - Plugin', SITEDESC, HOME, INCLUDE_PATH . '/images/site.png'];
break;
}
break;
//SEO:: 404
//SEO:: 404
default:
$this->Data = ['404 Oppss, Nada encontrado!', SITEDESC, HOME . '/404', INCLUDE_PATH . '/images/site.png'];
break;
}
if ($this->Data) {
$this->setTags();
//importa as bibliotecas corretas de acordo com a versão do sistema
if (PRODUCAO) {
$this->setProd();
} else {
$this->setLib();
}
}
}
