/** * Get SQL for get record count * * @return Varien_Db_Select */ public function getSelectCountSql() { $this->_renderFilters(); $paginatorAdapter = new Zend_Paginator_Adapter_DbSelect($this->getSelect()); return $paginatorAdapter->getCountSelect(); }
/** * @group ZF-7127 */ public function testMultipleGroupSelect() { $select = $this->_db->select()->from('test')->group('testgroup')->group('number')->where('number > 250'); $adapter = new Zend_Paginator_Adapter_DbSelect($select); $expected = 'SELECT COUNT(1) AS "zend_paginator_row_count" FROM (SELECT "test".* FROM "test" WHERE (number > 250) GROUP BY "testgroup"' . ",\n\t" . '"number") AS "t"'; $this->assertEquals($expected, $adapter->getCountSelect()->__toString()); $this->assertEquals(250, $adapter->count()); }
/** * Returns the recordcount for a given filter * * @param array $filter filter array * @param int $surveyId Gems Survey Id * @param string $sourceSurveyId Optional Survey Id used by source * @return int */ public function getRawTokenAnswerRowsCount(array $filter, $surveyId, $sourceSurveyId = null) { $select = $this->getRawTokenAnswerRowsSelect($filter, $surveyId, $sourceSurveyId); $p = new \Zend_Paginator_Adapter_DbSelect($select); $count = $p->getCountSelect()->query()->fetchColumn(); return $count; }