public function categoryAction() { $form = new \Admin\Form\Subject\CategoryFilter($this->getServiceLocator()); $form->setData($this->params()->fromQuery()); $this->getViewModel()->setVariable('form', $form); if ($form->isValid()) { $category = new Subject\Category(); $category->exchangeArray($form->getData()); $categoryMapper = $this->getServiceLocator()->get('Subject\\Model\\Subject\\CategoryMapper'); /*@var $categoryMapper \Subject\Model\Subject\CategoryMapper */ $paginator = $categoryMapper->search($category); $this->getViewModel()->setVariable('paginator', $paginator); } return $this->getViewModel(); }
/** * @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; }
/** * @author DuongNQ * @param \Subject\Model\Subject $sub */ public function search($sub, $options) { $select = $this->getDbSql()->select(array('s' => self::TABLE_NAME)); $select->order(['s.id' => 'DESC']); $paginator = $this->preparePaginator($select, $options, new Subject()); $categoryIds = array(); $categories = array(); /** @var /Subject/Model/Subject $subject */ foreach ($paginator as $subject) { $categoryIds[] = $subject->getCategoryId(); } if ($categoryIds) { $select = $this->getDbSql()->select(['ca' => Subject\CategoryMapper::TABLE_NAME]); $select->where(['ca.id' => $categoryIds]); $query = $this->getDbSql()->buildSqlString($select); $result = $this->getDbAdapter()->query($query, Adapter::QUERY_MODE_EXECUTE); if (count($result)) { $resultArray = $result->toArray(); foreach ($resultArray as $u) { $category = new Subject\Category(); $categories[$u['id']] = $category->exchangeArray($u); } } } /** @var /Subject/Model/Subject $subject */ foreach ($paginator->getCurrentModels() as $subject) { $categoryId = $subject->getCategoryId(); $subject->addOption('category', isset($categories[$categoryId]) ? $categories[$categoryId] : null); } return $paginator; }
/** * @return array|null */ public function fetchAll() { $dbAdapter = $this->getDbAdapter(); $select = $this->getDbSql()->select(['ca' => self::TABLE_NAME]); $select->where(['ca.status' => Subject::STATUS_ACTIVE]); $query = $this->getDbSql()->buildSqlString($select); $results = $dbAdapter->query($query, $dbAdapter::QUERY_MODE_EXECUTE); if ($results) { $categories = array(); foreach ($results as $row) { $ct = new Category(); $ct->exchangeArray((array) $row); $categories[] = $ct; } return $categories; } return null; }