Fetch a single record from the database for the given key.
public fetch ( array $p_recordSet = null, boolean $p_forceExists = false ) : boolean | ||
$p_recordSet | array | If the record has already been fetched and we just need to assign the data to the object's internal member variable. |
$p_forceExists | boolean | prevents to check for the object existence in the database, a performance thing for situations where we know it exists. |
return | boolean | TRUE on success, FALSE on failure |
/** * Fetch the topic and all its translations. * * The values array may have the following keys: * - id - topic identifier; if not supplied generated automatically * - node_left * - node_right * - names - array of topic translations of the form: language_id => name * * @return void */ public function fetch($p_columns = null, $p_forceExists = false) { global $g_ado_db; if (!is_null($p_columns)) { if (!isset($p_columns['names'])) { return false; } if ($this->readFromCache($p_columns) !== false) { return true; } foreach ($p_columns as $columnName => $value) { if (in_array($columnName, $this->m_columnNames)) { $this->m_data[$columnName] = $value; } } $this->m_names = $p_columns['names']; $this->m_exists = true; } else { if ($this->readFromCache() !== false) { return true; } parent::fetch(); if ($this->exists()) { $this->m_names = TopicName::GetTopicNames($this->getTopicId()); } } if ($this->m_exists) { // Write the object to cache $this->writeCache(); } return $this->m_exists; }
/** * Fetch a single record from the database for the given key. * * @param array $p_arg * If the record has already been fetched and we just need to * assign the data to the object's internal member variable. * * @return boolean * TRUE on success, FALSE on failure */ public function fetch($arg = null) { global $g_ado_db; if (is_array($arg)) { return parent::fetch($arg); } if (!$this->keyValuesExist()) { return false; } if ($this->readFromCache() !== false) { return true; } $queryStr = 'SELECT *, X(poi_location) as latitude, Y(poi_location) as longitude FROM ' . self::TABLE . ' WHERE id = ' . $this->getId(); $this->m_data = $g_ado_db->GetRow($queryStr); $this->m_exists = count($this->m_data) > 0; if ($this->m_exists) { // Write the object to cache $this->writeCache(); } return $this->m_exists; }
/** * Fetch a single record from the database for the given key. * * @param array $p_recordSet * If the record has already been fetched and we just need to * assign the data to the object's internal member variable. * * @return boolean * TRUE on success, FALSE on failure */ public function fetch($p_recordSet = null) { $res = parent::fetch($p_recordSet); if (!is_array($this->m_data['meta']) && $res) { // convert meta field if (empty($this->m_data["meta"])){ $this->m_data["meta"] = array(); } else { $this->m_data["meta"] = unserialize($this->m_data["meta"]); } } return $res; }
/** * Fetch a single record from the database for the given key. * * @param array $p_recordSet * If the record has already been fetched and we just need to * assign the data to the object's internal member variable. * * @return boolean * TRUE on success, FALSE on failure */ public function fetch($p_recordSet = null) { $res = parent::fetch($p_recordSet); if ($this->exists()) { settype($this->m_data['IdPublication'], 'integer'); settype($this->m_data['NrIssue'], 'integer'); settype($this->m_data['NrSection'], 'integer'); settype($this->m_data['IdLanguage'], 'integer'); settype($this->m_data['Number'], 'integer'); settype($this->m_data['IdUser'], 'integer'); settype($this->m_data['LockUser'], 'integer'); settype($this->m_data['ArticleOrder'], 'integer'); } return $res; }
/** * Fetch a single record from the database for the given key. * * @param array $p_recordSet * If the record has already been fetched and we just need to * assign the data to the object's internal member variable. * * @return boolean * TRUE on success, FALSE on failure */ public function fetch($p_recordSet = null, $p_forceExists = false) { $success = parent::fetch($p_recordSet); if ($success && $this->getType() == self::TYPE_NUMERIC) { $params = explode('=', $this->m_data['field_type_param']); if (isset($params[0]) && $params[0] == 'precision') { $this->m_precision = (int) $params[1]; } } if ($success && $this->getType() == self::TYPE_BODY) { $params = explode('=', $this->m_data['field_type_param']); if (isset($params[0]) && $params[0] == 'editor_size') { $this->m_editorSize = (int) $params[1]; } } if ($success && $this->getType() == self::TYPE_COMPLEX_DATE) { $params = explode(';', $this->m_data['field_type_param']); foreach ($params as $one_param) { $one_param_parts = explode('=', $one_param); if (isset($one_param_parts[1]) && $one_param_parts[0] == 'color') { $this->m_colorValue = '' . $one_param_parts[1]; } } } if ($success && !$this->getType()) { $params = explode(';', $this->m_data['field_type_param']); foreach ($params as $one_param) { $one_param_parts = explode('=', $one_param); if (isset($one_param_parts[1]) && $one_param_parts[0] == 'filter') { $this->m_filterOut = (bool) ('' . $one_param_parts[1]); } } } return $success; }
/** * Get the user from the database. * * @param array $p_recordSet * * @return void */ public function fetch($p_recordSet = null) { global $g_ado_db, $LiveUserAdmin; $success = parent::fetch($p_recordSet); if ($success) { // find out LiveUser perm and auth identifiers $param = array('filters' => array('handle' => $this->m_data['UName'])); $liveUserData = $LiveUserAdmin->auth->getUsers($param); if (is_array($liveUserData) && sizeof($liveUserData) > 0) { $this->m_liveUserData['auth_user_id'] = $liveUserData[0]['auth_user_id']; $params = array('filters' => array('auth_user_id' => $this->m_liveUserData['auth_user_id'])); $permData = $LiveUserAdmin->perm->getUsers($params); if (is_array($permData) && sizeof($permData) > 0) { $this->m_liveUserData['perm_user_id'] = $permData[0]['perm_user_id']; } } // fetch the permissions for this user if ($this->getUserType()) { $userType = new UserType($this->getUserType()); if ($userType) { $this->m_config = $userType->getConfig(); $this->m_exists = true; } } elseif ($this->getPermUserId()) { $queryStr = 'SELECT r.right_id as value, ' .'r.right_define_name as varname ' .'FROM liveuser_users as u, ' .'liveuser_rights as r, ' .'liveuser_perm_users p, ' .'liveuser_userrights as l ' .'WHERE u.Id=p.auth_user_id AND ' .'p.perm_user_id=l.perm_user_id AND ' .'r.right_id=l.right_id AND ' .'p.perm_user_id='.$this->getPermUserId(); $config = $g_ado_db->GetAll($queryStr); if ($config) { // make m_config an associative array foreach ($config as $value) { $this->m_config[$value['varname']] = $value['value']; } } $this->m_exists = true; } } } // fn fetch
/** * Get the user from the database. * * @param array $p_recordSet * * @return void */ public function fetch($p_recordSet = null, $p_forceExists = false) { global $g_ado_db; $success = parent::fetch($p_recordSet); if ($success) { $this->m_exists = true; } }
/** * Fetch a single record from the database for the given key. * * @param array $p_recordSet * If the record has already been fetched and we just need to * assign the data to the object's internal member variable. * * @return boolean * TRUE on success, FALSE on failure */ public function fetch($p_recordSet = null) { $success = parent::fetch($p_recordSet); if ($success && $this->getType() == self::TYPE_NUMERIC) { $params = explode('=', $this->m_data['field_type_param']); if (isset($params[0]) && $params[0] == 'precision') { $this->m_precision = (int) $params[1]; } } return $success; }