public function indexAction() { $request = Zend_Controller_Front::getInstance()->getRequest(); if ($request->isPost()) { $this->getElement()->removeDecorator('title'); } $numberOfWorks = $this->_getParam('itemCountPerPage'); $workTable = new Book_Model_DbTable_Works(); $workTableName = $workTable->info('name'); $workSelect = $workTable->getSelect(); $workSelect->limit($numberOfWorks); $workSelect->order('RAND()'); $this->view->works = $workTable->fetchAll($workSelect); }
public function indexAction() { $numberOfWorks = $this->_getParam('numberOfWorks', 5); $request = Zend_Controller_Front::getInstance()->getRequest(); if ($request->isPost()) { $this->getElement()->clearDecorators(); } $workTable = new Book_Model_DbTable_Works(); $workTableName = $workTable->info('name'); $workSelect = $workTable->getSelect()->order("{$workTableName}.creation_date DESC"); $workSelect->limit($numberOfWorks); $this->view->works = $works = $workTable->fetchAll($workSelect); $this->view->thumbnailOnly = $this->_getParam('thumbnailOnly', 0); }
public function indexAction() { // Get subject and check auth $subject = Engine_Api::_()->core()->getSubject(); $workTable = new Book_Model_DbTable_Works(); $workTableName = $workTable->info(Zend_Db_Table_Abstract::NAME); $workSelect = $workTable->getSelect(); $workSelect->where("{$workTableName}.user_id = ?", $subject->getIdentity()); $workSelect->order("{$workTableName}.creation_date DESC"); $this->view->works = $works = $workTable->fetchAll($workSelect); // Do not render if nothing to show if (count($works) == 0) { return $this->setNoRender(); } }