public function treatAction() { $categoryMapper = new CategoryMapper(); if ($this->getRequest()->getParam('id')) { $this->getLayout()->getAdminHmenu()->add($this->getTranslator()->trans('menuFaqs'), 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('menuFaqs'), 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')); } $title = trim($this->getRequest()->getPost('title')); if (empty($title)) { $this->addMessage('missingTitle', 'danger'); } else { $model->setTitle($title); $categoryMapper->save($model); $this->addMessage('saveSuccess'); $this->redirect(array('action' => 'index')); } } }
/** * Inserts or updates category model. * * @param CategoryModel $category */ public function save(CategoryModel $category) { if ($category->getId()) { $this->db()->update('faq_cats')->values(array('title' => $category->getTitle()))->where(array('id' => $category->getId()))->execute(); } else { $this->db()->insert('faq_cats')->values(array('title' => $category->getTitle()))->execute(); } }