private function getCatParent() { $rCat = new WsAreaCategory(); $rCat->setCategory_id($this->Data['category_id']); $rCat->Execute()->find(); if ($rCat->Execute()->getResult()) { return $rCat->Execute()->getResult()->category_parent; } else { return null; } }
<label class="label_small"> <span class="field">Data:</span> <input type="text" class="formTimestamp 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 $ReadSet = new WsAreaCategory(); $ReadSet->Execute()->Query("category_parent is NULL ORDER BY category_title ASC"); if (!$ReadSet->Execute()->getResult()) { echo '<option disabled="disable" value="null"> Cadastre antes uma seção! </option>'; } else { foreach ($ReadSet->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>
/** * Encontra o Id da area a partir da descrição. * @param string $TypeName * @return int */ public static function AreaTypeByName($TypeName) { $Read = new WsAreaCategory(); $Read->setCategory_title($TypeName); $query = $Read->Execute()->Query("#category_title#"); if ($Read->Execute()->getResult()) { return (int) $query[0]->category_id; } else { WSErro("O tipo de área <b>{$TypeName}</b> não foi encontrado!", WS_ERROR); return null; } }
<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/AdminAreaCategory.class.php'; $deletar = new AdminAreaCategory(); $deletar->ExeDelete($delCat); WSErro($deletar->getError()[0], $deletar->getError()[1]); } $ReadSes = new WsAreaCategory(); $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); $ReadSes->setCategory_parent($category_id); $ReadSes->Execute()->Query("#category_parent#"); $ContSesCats = $ReadSes->Execute()->getRowCount(); ?> <section> <header> <h1><?php echo $category_title; ?>
" /> </label> <label class="label_small"> <span class="field">Categoria:</span> <select name="category_id"> <option value=""> Selecione a categoria: </option> <?php $ReadSes = new WsAreaCategory(); $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>"; $ReadSet = new WsAreaCategory(); $ReadSet->setCategory_parent($ses->category_id); $ReadSet->Execute()->Query("#category_parent# ORDER BY category_title ASC"); if ($ReadSet->Execute()->getRowCount() >= 1) { foreach ($ReadSet->Execute()->getResult() as $cat) { echo "<option "; if ($data['category_id'] == $cat->category_id) { echo "selected=\"selected\" "; } echo "value=\"{$cat->category_id}\"> »»{$cat->category_title} </option>"; } } } } ?> </select> </label>
private function checkCats() { $Read = new WsAreaCategory(); $Read->setCategory_parent($this->CatId); $Read->Execute()->Query("#category_parent#"); if (!empty($Read->Execute()->getResult()[0])) { return false; } else { return true; } }