/** * <b>Obter categoria:</b> Informe o name (url) de uma categoria para obter o ID da mesma. * @param STRING $category_name = URL da categoria * @return INT $category_id = id da categoria informada */ public static function CatByName($CategoryName) { $Read = new WsCategories(); $Read->setCategory_name($CategoryName); $query = $Read->Execute()->Query('#category_name#'); if ($Read->Execute()->getResult()) { return (int) $query[0]->category_id; } else { WSErro("A categoria <b>{$CategoryName}</b> não foi encontrada!", WS_ERROR); return null; } }
<label class="label_small"> <span class="field">Data:</span> <input type="text" class="formDate center" name="category_date" value="<?php echo date('d/m/Y H:i:s'); ?> " /> </label> <label class="label_small left"> <span class="field">Seção:</span> <select name="category_parent"> <option value="null"> Selecione a Seção: </option> <?php $ReadCat = new WsCategories(); $ReadCat->Execute()->Query("category_parent is NULL ORDER BY category_title ASC"); if (!$ReadCat->Execute()->getResult()) { echo '<option disabled="disable" value="null"> Cadastre antes uma seção! </option>'; } else { foreach ($ReadCat->Execute()->getResult() as $ses) { echo "<option value=\"{$ses->category_id}\" "; if ($ses->category_id == $data['category_parent']) { echo ' selected="seleted" '; } echo "> {$ses->category_title} </option>"; } } ?> </select> </label> </div>
<label class="label_small"> <span class="field">Data:</span> <input type="text" class="formDate center" name="category_date" value="<?php echo date('d/m/Y H:i:s'); ?> " /> </label> <label class="label_small left"> <span class="field">Seção:</span> <select name="category_parent"> <option value="null"> Selecione a Seção: </option> <?php $ReadCat = new WsCategories(); $ReadCat->Execute()->Query("category_parent is NULL ORDER BY category_title ASC"); if (!$ReadCat->getResult()) { echo '<option disabled="disable" value="null"> Cadastre antes uma seção! </option>'; } else { foreach ($ReadCat->getResult() as $ses) { echo "<option value=\"{$ses->category_id}\" "; if ($ses->category_id == $data['category_parent']) { echo ' selected="seleted" '; } echo "> {$ses->category_title} </option>"; } } ?> </select> </label> </div>
/** * <b>Contagem de Views:</b> Realiza uma contagem ao post informado. * @param INT $post_id */ public static function ContCategoryViews($category_id) { $WsCategories = new WsCategories(); $WsCategories->setCategory_id($category_id); extract((array) $WsCategories->Execute()->find()); $WsCategories->setCategory_views($category_views + 1); $WsCategories->setCategory_last_view(date('Y-m-d H:i:s')); $WsCategories->Execute()->update($WsCategories->Execute()->getDados(), 'category_id'); }
private function getCatParent() { $rCat = new WsCategories(); $rCat->setCategory_id($this->Data['post_category']); $rCat->Execute()->find(); if ($rCat->Execute()->getResult()) { return $rCat->Execute()->getResult()->category_parent; } else { return null; } }
" /> </label> <label class="label_small"> <span class="field">Categoria:</span> <select name="post_category"> <option value=""> Selecione a categoria: </option> <?php $ReadSes = new WsCategories(); $ReadSes->Execute()->Query("category_parent IS NULL ORDER BY category_title ASC"); if ($ReadSes->Execute()->getRowCount() >= 1) { foreach ($ReadSes->Execute()->getResult() as $ses) { echo "<option disabled=\"disabled\" value=\"\"> {$ses->category_title} </option>"; $ReadCat = new WsCategories(); $ReadCat->setCategory_parent($ses->category_id); $ReadCat->Execute()->Query("#category_parent# ORDER BY category_title ASC"); if ($ReadCat->Execute()->getRowCount() >= 1) { foreach ($ReadCat->Execute()->getResult() as $cat) { echo "<option "; if ($post['post_category'] == $cat->category_id) { echo "selected=\"selected\" "; } echo "value=\"{$cat->category_id}\"> »»{$cat->category_title} </option>"; } } } } ?> </select> </label>
<h1>Categorias:</h1> <?php $empty = filter_input(INPUT_GET, 'empty', FILTER_VALIDATE_BOOLEAN); if ($empty) { WSErro("Você tentou editar uma categoria que não existe no sistema!", WS_INFOR); } $delCat = filter_input(INPUT_GET, 'delete', FILTER_VALIDATE_INT); if ($delCat) { require '_models/AdminCategory.class.php'; $deletar = new AdminCategory(); $deletar->ExeDelete($delCat); WSErro($deletar->getError()[0], $deletar->getError()[1]); } $ReadSes = new WsCategories(); $ReadSes->Execute()->Query("category_parent IS NULL ORDER BY category_title ASC"); if (!$ReadSes->Execute()->getResult()) { WSErro("Desculpa, ainda não temos categorias cadastrados", WS_INFOR); } else { foreach ($ReadSes->Execute()->getResult() as $ses) { extract((array) $ses); $ReadPosts = new WsPosts(); $ReadPosts->setPost_cat_parent($category_id); $ReadPosts->Execute()->Query("#post_cat_parent#"); $ContSesPosts = $ReadPosts->Execute()->getRowCount(); $ReadSes->setCategory_parent($category_id); $ReadSes->Execute()->Query("#category_parent#"); $ContSesCats = $ReadSes->Execute()->getRowCount(); ?> <section>
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(); } } }
private function checkCats() { $Read = new WsCategories(); $Read->setCategory_parent($this->CatId); $Read->Execute()->Query("#category_parent#"); if (!empty($Read->Execute()->getResult()[0])) { return false; } else { return true; } }