Honors the Zend_Db_Adapter fetch mode.
public fetchAll ( string | array | Zend_Db_Table_Select $where = null, string | array $order = null, integer $count = null, integer $offset = null ) : Zend_Db_Table_Rowset_Abstract | ||
$where | string | array | Zend_Db_Table_Select | OPTIONAL An SQL WHERE clause or Zend_Db_Table_Select object. |
$order | string | array | OPTIONAL An SQL ORDER clause. |
$count | integer | OPTIONAL An SQL LIMIT count. |
$offset | integer | OPTIONAL An SQL LIMIT offset. |
return | Zend_Db_Table_Rowset_Abstract | The row results per the Zend_Db_Adapter fetch mode. |
public function fetchAll() { $resultSet = $this->dbTable->fetchAll(); $entries = array(); foreach ($resultSet as $row) { $entries[] = array('id' => $row->id, 'state' => $row->state, 'info' => $row->info, 'lastupdate' => $row->lastupdate, 'sticked' => $row->sticked); } return $entries; }
public function getAll() { $resultSet = $this->dbTable->fetchAll(); $resultTab = array(); foreach ($resultSet as $enreg) { $modelClassName = 'Application_Model_' . $this->className; $result = new $modelClassName(); $result->fromArray($enreg); $resultTab[] = $result; } return $resultTab; }
/** * Find admin * * @param int $applicationId * @param string $username * @param Admin_Model_Admin $admin * @return boolean */ public function find($applicationId, $username, Admin_Model_Admin $admin) { $select = $this->_dbTable->select(); $select->setIntegrityCheck(false)->from(array('a' => 'admin'), array('a.*'))->joinLeft(array("aa" => "admin_application"), "aa.admin_id = a.id")->where('a.username = ?', $username)->where('aa.application_id = ?', $applicationId); $resultSet = $this->_dbTable->fetchAll($select); if (0 == count($resultSet)) { return false; } //get first row from resultSet $row = $resultSet->current(); $admin->setOptions($row->toArray()); return true; }
public function isValid($value) { $db = $this->_model->getAdapter(); $where = $db->quoteInto($this->_field . ' = ?', $value); if (null !== $this->_where) { $where .= " AND {$this->_where}"; } $rows = $this->_model->fetchAll($where); if (count($rows)) { $this->_messages[] = Axis::translate('core')->__("Record %s already exist", $value); return $this->_not; } $this->_messages[] = Axis::translate('core')->__("Record %s doesn't found", $value); return !$this->_not; }
/** * Load ACL rules from DB and load them in a Zend_Acl instance. * * @return Zend_Acl */ protected function _loadAcl() { $this->_roles = $this->_roleTable->fetchAll(); $this->_rules = $this->_ruleTable->fetchAll(); $this->_resources = $this->_resourceTable->fetchAll(); foreach ($this->_roles as $role) { $this->_loadRole($role); } foreach ($this->_resources as $resource) { $resourceID = null; $module = $resource->module; $controller = $resource->controller; if ($module != null && $controller != null) { $resourceID = $module . '.' . $controller; } if ($resourceID != null && !$this->has($resourceID)) { $this->add(new Zend_Acl_Resource($resourceID)); } } foreach ($this->_rules as $rule) { $resourceID = null; $module = $rule->module; $controller = $rule->controller; if ($module != null && $controller != null) { $resourceID = $module . '.' . $controller; } if ((bool) $rule->allow) { $this->allow($rule->role, $resourceID, $rule->action); } else { $this->deny($rule->role, $resourceID, $rule->action); } } return $this; }
public function fetchAll($where = null, $order = null, $count = null, $offset = null) { $select = $this->getQueryAll(); if ($where) { $select->where($where); } return parent::fetchAll($select); }
/** * Lazy load data via table fetchAll() method. * * @return void */ protected function loadData() { if ($this->data === null) { $this->data = $this->_table->fetchAll($this->_where, $this->_order, $this->_count, $this->_offset); if ($this->data instanceof Zend_Db_Table_Rowset_Abstract) { $this->data = $this->data->toArray(); } } }
/** * This is overridden to handle cache * * (non-PHPdoc) * @see library_Zend/Db/Table/Zend_Db_Table_Abstract#fetchAll($where, $order, $count, $offset) */ public function fetchAll($where = null, $order = null, $count = null, $offset = null) { $name = $this->_name . '_' . md5($where); $data = $this->loadCache($name); if (!$data) { $data = parent::fetchAll($where, $order, $count, $offset); $this->saveCache($data, $name); } return $data; }
/** * get enabled or disabled applications * * @param int $_state can be Tinebase_Application::ENABLED or Tinebase_Application::DISABLED * @return Tinebase_Record_RecordSet list of applications */ public function getApplicationsByState($_status) { if ($_status !== Tinebase_Application::ENABLED && $_status !== Tinebase_Application::DISABLED) { throw new Tinebase_Exception_InvalidArgument('$_status can be only Tinebase_Application::ENABLED or Tinebase_Application::DISABLED'); } $where[] = $this->_db->quoteInto($this->_db->quoteIdentifier('status') . ' = ?', $_status); $rowSet = $this->_applicationTable->fetchAll($where); $result = new Tinebase_Record_RecordSet('Tinebase_Model_Application', $rowSet->toArray(), TRUE); return $result; }
/** * wrapper around Zend_Db_Table_Abstract::fetchAll * * @param strin|array $_where OPTIONAL * @param string $_order OPTIONAL * @param string $_dir OPTIONAL * @param int $_count OPTIONAL * @param int $_offset OPTIONAL * @throws Tinebase_Exception_InvalidArgument if $_dir is not ASC or DESC * @return the row results per the Zend_Db_Adapter fetch mode. */ public function fetchAll($_where = NULL, $_order = NULL, $_dir = 'ASC', $_count = NULL, $_offset = NULL) { if ($_dir != 'ASC' && $_dir != 'DESC') { throw new Tinebase_Exception_InvalidArgument('$_dir can be only ASC or DESC'); } $order = NULL; if ($_order !== NULL) { $order = $_order . ' ' . $_dir; } $rowSet = parent::fetchAll($_where, $order, $_count, $_offset); return $rowSet; }
function fetchAll($where = null, $order = null, $count = null, $offset = null) { if (!is_object($where) || $where instanceof Zend_Db_Table_Select) { return parent::fetchAll($where, $order, $count, $offset); } else { if (!$where instanceof Zend_Db_Select) { throw new Exception("Mauvais type de requête"); } else { throw new Exception("Qui sait traiter ça ? " . gettype($where)); } } }
/** * (non-PHPdoc) * @see Zend_Db_Table_Abstract::fetchAll() */ public function fetchAll($where = null, $order = null, $count = null, $offset = null) { if (empty($where)) { $tableName = $this->getTableName(); if (false == ($rows = App_Cache::load($tableName))) { $rows = parent::fetchAll($where, $order, $count, $offset); App_Cache::save($rows, $tableName); } } else { $rows = parent::fetchAll($where, $order, $count, $offset); } $rows = parent::fetchAll($where, $order, $count, $offset); return $rows; }
/** * wrapper around Zend_Db_Table_Abstract::fetchAll * * @param string|array $_where OPTIONAL * @param string $_order OPTIONAL * @param string $_dir OPTIONAL * @param int $_count OPTIONAL * @param int $_offset OPTIONAL * @throws Tinebase_Exception_InvalidArgument if $_dir is not ASC or DESC * @return array the row results per the Zend_Db_Adapter fetch mode. */ public function fetchAll($_where = NULL, $_order = NULL, $_dir = 'ASC', $_count = NULL, $_offset = NULL) { if ($_dir != 'ASC' && $_dir != 'DESC') { throw new Tinebase_Exception_InvalidArgument('$_dir can be only ASC or DESC'); } $order = NULL; if ($_order !== NULL) { $order = $_order . ' ' . $_dir; } // possibility to tracing queries if (Tinebase_Core::isLogLevel(Zend_Log::TRACE) && ($config = Tinebase_Core::getConfig()->logger)) { if ($config->traceQueryOrigins) { $e = new Exception(); Tinebase_Core::getLogger()->trace(__METHOD__ . '::' . __LINE__ . "\n" . "BACKTRACE: \n" . $e->getTraceAsString() . "\n" . "SQL QUERY: \n" . $this->select()->assemble()); } } $rowSet = parent::fetchAll($_where, $order, $_count, $_offset); return $rowSet; }
/** * loadDestinationData * @author Thomas Schedler <*****@*****.**> * @version 1.0 */ private function loadDestinationData() { try { $objSelect = $this->objTable->select(); $objSelect->setIntegrityCheck(false); $arrFields = array($this->strDBFLft, $this->strDBFRgt, $this->strDBFDepth); if (!is_null($this->strDBFParent)) { $arrFields[] = $this->strDBFParent; } if (!is_null($this->strDBFRoot)) { $arrFields[] = $this->strDBFRoot; } $objSelect->from($this->objTable->info(Zend_Db_Table_Abstract::NAME), $arrFields); $objSelect->where('id = ?', $this->intDestinationId); $this->objDestinationData = $this->objTable->fetchAll($objSelect); } catch (Exception $exc) { $this->core->logger->err($exc); } }
/** Fetch all data * @access public * @param array $where * @param string $order * @param string $count * @param integer $offset * @return array */ public function fetchAll($where = null, $order = null, $count = null, $offset = null) { $id = md5($where->__toString()); if (!$this->_cache->test($id) || !$this->cache_result) { $result = parent::fetchAll($where, $order, $count, $offset); $this->_cache->save($result); return $result; } else { return $this->_cache->load($id); } }
/** * */ public function get_sort_categories_children($parentId, $levels, $cur_level = 0) { $res_ar = array(); $Product = new Product(); if ($levels > 0) { //$sel = $this->select()->from(array('a' => $this->_name,)->where('parentId='.$parentId); $children = parent::fetchAll('parentId=' . $parentId)->toArray(); //$children = parent::fetchAll($sel)->toArray(); //$children = $this->getAll(array('where' => 'a.parentId='.$parentId)); //print_r($children);exit; foreach ($children as $key => $child) { $child['level'] = $cur_level; $ar_children = $this->get_sort_categories_children($child['id'], $levels - 1, $cur_level + 1); if (count($ar_children) <= 0) { $product_count = $Product->getProductCount($child['children']); $child['c_count'] = $product_count; } else { $c = 0; foreach ($ar_children as $one_child) { $c += $one_child['c_count']; } $child['c_count'] = $c; } if ($child['c_count'] > 0) { $res_ar[] = $child; } $res_ar = array_merge($res_ar, $ar_children); } } return $res_ar; }
public function execute($select) { return parent::fetchAll($select); }
/** * (non-PHPdoc) * @see Zend_Db_Table_Abstract::fetchAll() */ public function fetchAll($where = null, $order = null, $count = null, $offset = null) { $rows = parent::fetchAll($where, $order, $count, $offset); return $rows; }
/** @brief FetchAll. * Permet d'obtenir un tableau BIDIMENTIONNEL pour chaque ligne de résultat de la forme : * array(array('key_1' => "Valeur 1", 'key_2' => "Valeur 2", ... , 'key_Z => "Valeur Z")). * * @li La clé est l'occurence de la ligne de résultat. * @li La valeur est un tableau associatif entre le nom du champ et sa valeur en base. * @li Aucune ligne de résultat n'est écrasée par une autre : les données sont brutes. * * @param object|string $pSelect : objet Zend_Db_Select ou string Sql. * @throws lève une exception de type Zend_Exception en cas d'erreur de requete. * @return array retourne tableau représentant chaque ligne de résultat sous forme array('key'=>"value"). */ public function fetchAll($pSelect) { try { return parent::fetchAll($pSelect)->toArray(); } catch (Exception $e) { throw new Zend_Exception("BAD_QUERY", __METHOD__, $e); } }
/** * Get a page * * @var int $page * @return Zend_Db_Table_Rowset_Abstract */ public function getPage($page) { $this->_select->limitPage((int) $page, $this->getRowLimit()); return $this->_table->fetchAll($this->_select); }
/** * Switch fetch method to support hasManyAndBelongsToMany relationship. * * @param string|array $where Where clause. * @param string|array $order Order clause. * @param string|array $count Limit. * @param string|array $offset Offset. * * @return Zend_Db_Table_Rowset The rowset with the results. */ protected function _fetchWithOutJoin($where = null, $order = null, $count = null, $offset = null) { if (array_key_exists('hasManyAndBelongsToMany', $this->_relations) && is_array($this->_relations['hasManyAndBelongsToMany'])) { return $this->_fetchHasManyAndBelongsToMany($where); } else { // Collect all the fields for prevent select * $select = $this->select()->from($this->_name, $this->_cols); if (null !== $where) { $select->where($where); } if (null !== $order) { $select->order($order); } if ($count !== null || $offset !== null) { $select->limit($count, $offset); } return parent::fetchAll($select); } }
public function fetchAll($where = null, $order = null, $count = null, $offset = null) { $where = $this->_appendProtectedCondition($where); return parent::fetchAll($where, $order, $count, $offset); }
/** * Count. * ! NOTE we call the fetchAll of the parent here. * So this might not performe good at the moment * * @return integer Count of results. */ public function count() { return parent::fetchAll()->count(); }