/** * <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; } }