/** * @author DuongNQ * @param \Subject\Model\Subject\Category $cate */ public function isExisted($cate) { if (!$cate->getName()) { return null; } $select = $this->getDbSql()->select(array('d' => self::TABLE_NAME)); $select->where(['name' => $cate->getName()]); if ($cate->getId()) { $select->where(['id != ?' => $cate->getId()]); } $select->limit(1); $query = $this->getDbSql()->buildSqlString($select); $results = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE); if ($results->count()) { $cate->exchangeArray((array) $results->current()); return true; } return false; }
public function listAction() { $categoryId = $this->params()->fromQuery('id'); /** @var \Subject\Model\Subject\CategoryMapper $categoryMapper */ $categoryMapper = $this->getServiceLocator()->get('Subject\\Model\\Subject\\CategoryMapper'); /** @var \Subject\Model\Subject\Category $category */ $category = new Category(); $category->setId($categoryId); if (!$category->getId() || !$categoryMapper->get($category)) { return $this->page404(); } /** @var \Subject\Model\Subject $subject */ $subject = new Subject(); $subject->setCategoryId($category->getId()); /** @var \Subject\Model\SubjectMapper $subjectMapper */ $subjectMapper = $this->getServiceLocator()->get('Subject\\Model\\SubjectMapper'); $subjects = $subjectMapper->featchAll($subject); $this->getViewModel()->setVariables(['subjects' => $subjects]); return $this->getViewModel(); }
public function listAction() { $categoryId = $this->params()->fromQuery('id'); /** @var \Subject\Model\Subject\CategoryMapper $categoryMapper */ $categoryMapper = $this->getServiceLocator()->get('Subject\\Model\\Subject\\CategoryMapper'); /** @var \Subject\Model\Subject\Category $category */ if (!$categoryId) { return $this->page404(); } /** @var \Subject\Model\Subject $subject */ $subject = new Subject(); if (count(explode(',', $categoryId)) > 1) { $count = 0; foreach (explode(',', $categoryId) as $sId) { $category = new Category(); $category->setId($sId); if (!$categoryMapper->get($category)) { $count++; } else { $categoryIds[] = $sId; } } if ($count == count(explode(',', $categoryId))) { return $this->page404(); } $subject->addOption('categoryIds', $categoryIds); } else { $category = new Category(); $category->setId($categoryId); if (!$category->getId() || !$categoryMapper->get($category)) { return $this->page404(); } $subject->setCategoryId($category->getId()); } /** @var \Subject\Model\SubjectMapper $subjectMapper */ $subjectMapper = $this->getServiceLocator()->get('Subject\\Model\\SubjectMapper'); $subjects = $subjectMapper->featchAll($subject); $this->getViewModel()->setVariables(['subjects' => $subjects]); return $this->getViewModel(); }
public function editcategoryAction() { /** @var $categoryMapper \Subject\Model\Subject\CategoryMapper */ $categoryMapper = $this->getServiceLocator()->get('Subject\\Model\\Subject\\CategoryMapper'); $category = new Subject\Category(); $id = $this->params()->fromQuery('id'); $category->setId($id); if (!$category->getId() || !$categoryMapper->get($category)) { return $this->page404(); } $form = new \Admin\Form\Subject\Category($this->getServiceLocator()); $form->remove('afterSubmit'); $form->setData($category->toFormValues()); if ($this->getRequest()->isPost()) { $form->setData($this->getRequest()->getPost()); if ($form->isValid()) { $category->exchangeArray($form->getData()); $categoryMapper->save($category); return $this->redirect()->toUrl('/admin/subject/category'); } } $this->getViewModel()->setVariables(['form' => $form]); return $this->getViewModel(); }