public function treatAction()
{
$categoryMapper = new CategoryMapper();
if ($this->getRequest()->getParam('id')) {
$this->getLayout()->getAdminHmenu()->add($this->getTranslator()->trans('menuArticle'), array('action' => 'index'))->add($this->getTranslator()->trans('menuCats'), array('action' => 'index'))->add($this->getTranslator()->trans('edit'), array('action' => 'treat'));
$this->getView()->set('cat', $categoryMapper->getCategoryById($this->getRequest()->getParam('id')));
} else {
$this->getLayout()->getAdminHmenu()->add($this->getTranslator()->trans('menuArticle'), array('action' => 'index'))->add($this->getTranslator()->trans('menuCats'), array('action' => 'index'))->add($this->getTranslator()->trans('add'), array('action' => 'treat'));
}
if ($this->getRequest()->isPost()) {
$model = new CategoryModel();
if ($this->getRequest()->getParam('id')) {
$model->setId($this->getRequest()->getParam('id'));
}
$name = trim($this->getRequest()->getPost('name'));
if (empty($name)) {
$this->addMessage('missingName', 'danger');
} else {
$model->setName($name);
$categoryMapper->save($model);
$this->addMessage('saveSuccess');
$this->redirect(array('action' => 'index'));
}
}
}
/**
* Gets categorys.
*
* @param array $where
* @return CategoryModel[]|null
*/
public function getCategories($where = array())
{
$categoryArray = $this->db()->select('*')->from('articles_cats')->where($where)->order(array('id' => 'ASC'))->execute()->fetchRows();
if (empty($categoryArray)) {
return null;
}
$categorys = array();
foreach ($categoryArray as $categoryRow) {
$categoryModel = new CategoryModel();
$categoryModel->setId($categoryRow['id']);
$categoryModel->setName($categoryRow['name']);
$categorys[] = $categoryModel;
}
return $categorys;
}