/**
* <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->Query('WHERE category_name = :category_name');
if ($query) {
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->Query("WHERE 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>
<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->Query("WHERE category_parent IS NULL ORDER BY category_title ASC");
if (!$ReadSes->getResult()) {
} else {
foreach ($ReadSes->getResult() as $ses) {
extract((array) $ses);
$ReadPosts = new WsPosts();
$ReadPosts->setPost_cat_parent($category_id);
$ReadPosts->Query("WHERE #post_cat_parent#");
$ContSesPosts = $ReadPosts->getRowCount();
$ReadSes->setCategory_parent($category_id);
$ReadSes->Query("WHERE #category_parent#");
$ContSesCats = $ReadSes->getRowCount();
?>
<section>
<header>
" />
</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->Query("WHERE category_parent IS NULL ORDER BY category_title ASC");
if ($ReadSes->getRowCount() >= 1) {
foreach ($ReadSes->getResult() as $ses) {
echo "<option disabled=\"disabled\" value=\"\"> {$ses->category_title} </option>";
$ReadCat = new WsCategories();
$ReadCat->setCategory_parent($ses->category_id);
$ReadCat->Query("WHERE #category_parent# ORDER BY category_title ASC");
if ($ReadCat->getRowCount() >= 1) {
foreach ($ReadCat->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>
private function checkCats()
{
$Read = new WsCategories();
$Read->setCategory_parent($this->CatId);
$Read->Query("WHERE #category_parent#");
if (isset($Read->getResult()[0])) {
return false;
} else {
return true;
}
}
