/** * Gets links. * * @param array $where * @return LinkModel[]|null */ public function getLinks($where = array()) { $linkArray = $this->db()->select('*')->from('links')->where($where)->execute()->fetchRows(); if (empty($linkArray)) { return null; } $links = array(); foreach ($linkArray as $linkRow) { $linkModel = new LinkModel(); $linkModel->setId($linkRow['id']); $linkModel->setCatId($linkRow['cat_id']); $linkModel->setName($linkRow['name']); $linkModel->setDesc($linkRow['desc']); $linkModel->setLink($linkRow['link']); $linkModel->setBanner($linkRow['banner']); $linkModel->setHits($linkRow['hits']); $links[] = $linkModel; } return $links; }
public function treatLinkAction() { $this->getLayout()->getAdminHmenu()->add($this->getTranslator()->trans('menuLinks'), array('action' => 'index'))->add($this->getTranslator()->trans('menuActionNewLink'), array('action' => 'treat')); $categoryMapper = new CategoryMapper(); $linkMapper = new LinkMapper(); $this->getView()->set('cats', $categoryMapper->getCategories()); if ($this->getRequest()->getParam('id')) { $this->getView()->set('link', $linkMapper->getLinkById($this->getRequest()->getParam('id'))); } if ($this->getRequest()->isPost()) { $model = new LinkModel(); if ($this->getRequest()->getParam('id')) { $model->setId($this->getRequest()->getParam('id')); } $name = $this->getRequest()->getPost('name'); $link = trim($this->getRequest()->getPost('link')); if (empty($name)) { $this->addMessage('missingName', 'danger'); } elseif (empty($link)) { $this->addMessage('missingLink', 'danger'); } else { $model->setName($this->getRequest()->getPost('name')); $model->setLink($this->getRequest()->getPost('link')); $model->setBanner($this->getRequest()->getPost('banner')); $model->setDesc($this->getRequest()->getPost('desc')); $model->setCatId($this->getRequest()->getPost('catId')); $linkMapper->save($model); $this->addMessage('saveSuccess'); $this->redirect(array('action' => 'index')); } } }