public function getDocumentPaginator($page_num) { $hydrator = new ObjectPropertyHydrator(); $objectPrototype = new Document(); $resultSet = new \Zend\Db\ResultSet\HydratingResultSet($hydrator, $objectPrototype); $query = new \Zend\Db\Sql\Select(); $query->from('document'); $adapter = new \Zend\Paginator\Adapter\DbSelect($query, $this->adapter, $resultSet); $paginator = new \Zend\Paginator\Paginator($adapter); $paginator->setCurrentPageNumber($page_num); return $paginator; }
/** * 显示所有已收集的Email地址 */ public function indexAction() { $hydrator = new \Zend\Stdlib\Hydrator\ObjectProperty(); $objectPrototype = new \Console\Model\Address(); $resultSet = new \Zend\Db\ResultSet\HydratingResultSet($hydrator, $objectPrototype); $query = new \Zend\Db\Sql\Select(); $query->from('address'); $adapter = new \Zend\Paginator\Adapter\DbSelect($query, $this->dbAdapter, $resultSet); $paginator = new \Zend\Paginator\Paginator($adapter); $paginator->setCurrentPageNumber($this->params()->fromRoute('page')); return new ViewModel(array('paginator' => $paginator)); }
public function getQueue($task_id, $page_num) { $hydrator = new ObjectPropertyHydrator(); $objectPrototype = new Queue(); $resultSet = new \Zend\Db\ResultSet\HydratingResultSet($hydrator, $objectPrototype); $query = new \Zend\Db\Sql\Select(); $query->from('queue')->where(array('task_id' => $task_id)); $adapter = new \Zend\Paginator\Adapter\DbSelect($query, $this->adapter, $resultSet); $paginator = new \Zend\Paginator\Paginator($adapter); $paginator->setCurrentPageNumber($page_num); $paginator->setDefaultItemCountPerPage(100); return $paginator; }
public function withdrawAction() { $this->appendTitle($this->translate('Withdraw list')); $dbAdapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $select = new \Zend\Db\Sql\Select(); $select->from('withdraw')->order(array('create_time' => 'desc')); $dbselect = new DbSelect($select, $dbAdapter); $paginator = new Paginator($dbselect); $paginator->setCurrentPageNumber($this->params()->fromRoute('page')); $vars = array('paginator' => $paginator, 'sl' => $this->serviceLocator); $view_page = new ViewModel($vars); $view_page = $this->setChildViews($view_page); return $view_page; }
/** * The default action - show the home page */ public function indexAction() { $this->appendTitle($this->translate('Trade query')); $dbAdapter = $this->getServiceLocator()->get('Zend\\Db\\Adapter\\Adapter'); $select = new \Zend\Db\Sql\Select(); $select->from('trade')->where(array('merchant_id' => $this->getMerchantId()))->order(array('create_time' => 'desc')); $dbselect = new DbSelect($select, $dbAdapter); $paginator = new Paginator($dbselect); $paginator->setCurrentPageNumber($this->params()->fromRoute('page')); $vars = array('paginator' => $paginator); $view_page = new ViewModel($vars); $view_page = $this->setChildViews($view_page); return $view_page; }
public function getAll() { $select = new \Zend\Db\Sql\Select(); $select->from($this->tableGateway->getTable()); return $select; }
/** * Get the most searched queries * * @param $from begin time * @param $to end time * * @return associative array */ public function getMostSearchedQueries($from = null, $to = null, $limit = 20) { $subSelect = $this->sql->select(); $subSelect->columns(array('phrase' => 'value')); $subSelect->join(array('noresults' => 'user_stats_fields'), 'user_stats_fields.id = noresults.id', array()); $subSelect->join(array('user_stats' => 'user_stats'), 'user_stats.id = user_stats_fields.id', array('session' => 'session')); if ($from && $to) { $format = "Y-m-d H:i:s"; $from = date($format, $from); $to = date($format, $to); $subSelect->where->greaterThan('user_stats.datestamp', $from); $subSelect->where->lessThan('user_stats.datestamp', $to); } $subSelect->where->equalTo('user_stats_fields.field', 'phrase'); $subSelect->where->equalTo('noresults.field', 'noresults'); $subSelect->where->EqualTo('noresults.value', 'false'); $subSelect->where->notEqualTo('user_stats_fields.value', ''); $subSelect->group(array('phrase', 'session')); $select = new \Zend\Db\Sql\Select(); $select->columns(array('query' => 'phrase', 'count' => new Expression("COUNT(*)"))); $select->from(array('phrase' => $subSelect)); $select->group(array('phrase')); $select->order('count desc'); $select->limit($limit); $statement = $this->sql->prepareStatementForSqlObject($select); $result = $statement->execute(); return $result; }
public function index10Action() { $adapter = $this->getServiceLocator()->get("dbConfig"); $selectObj = new \Zend\Db\Sql\Select(); $selectObj->from(array("p" => "products"))->columns(array("id", "name", "cat_id"))->order(array("cat_id ASC", "id ASC")); $stringSql = $selectObj->getSqlString($adapter->getPlatForm()); $result = $adapter->query($stringSql)->execute(); foreach ($result as $row) { echo "<pre style='font-weight:bold'>"; print_r($row); echo "</pre>"; } return false; }
public static function ListaWszystkieKolumnyLimit($nazwaSlownika, $limit = null, $offset = null) { $aKolumny = \My\Tools\Lista::KolumnyNazwy($nazwaSlownika); $select = new \Zend\Db\Sql\Select(); $select->from($nazwaSlownika); if (in_array('deleted', $aKolumny)) { $select->where('deleted=0'); } if (in_array('is_active', $aKolumny)) { $select->where('is_active=1'); } if (!is_null($limit) && $limit > 0) { $select->limit((int) $limit); } if (!is_null($offset) && $offset >= 0) { $select->offset((int) $offset); } $projectTable = new TableGateway($nazwaSlownika, \Zend\Db\TableGateway\Feature\GlobalAdapterFeature::getStaticAdapter()); $rowset = $projectTable->selectWith($select); if ($rowset) { return $rowset->toArray(); } return array(); }
/** * get ZF2 Zend Db Select * @return Zend\Db\Sql\Select */ protected function getDbSelect($isSetDefaultValue = true) { $select = new Zend\Db\Sql\Select(); if ($isSetDefaultValue) { $select->columns(array($this->pk)); $select->from($this->tableName); } return $select; }