PHP DB_DataObject::fetch方法代码示例

 /**
  * @param DB_DataObject $class
  * @param string $label
  * @param string $field
  * @return array
  */
 function getSessionFilterSubTable($class, $label, $field)
 {
     $class->orderBy('value ASC');
     $class->find();
     $filter = array();
     $filter['label'] = $label;
     $filter['field'] = $field;
     $filter['values'] = array();
     $filter['values']['null'] = 'unset';
     while ($class->fetch()) {
         $filter['values'][$class->id] = $class->value;
     }
     natcasesort($filter['values']);
     return $filter;
 }

 function showContent()
 {
     $properties = ['id', 'nickname', 'fullname', 'profileurl', 'homepage', 'bio', 'location', 'lat', 'lon', 'location_id', 'location_ns', 'created', 'modified'];
     // $config['staleaccounts']['inactive_period'] is number of months
     // of inactivity before an account is considered stale.
     // Defaults to 3
     $inactive_period = common_config('staleaccounts', 'inactive_period') ?: 3;
     // Calculate stale date (today - $inactive_period)
     $stale_date = new DateTime();
     $stale_date->modify('-' . $inactive_period . ' month');
     $stale_date = $stale_date->format('Y-m-d');
     $offset = ($this->page - 1) * PROFILES_PER_PAGE;
     $limit = PROFILES_PER_PAGE + 1;
     $dataObj = new DB_DataObject();
     // Custom query because I only want to hit the db once
     $dataObj->query('SELECT * FROM
         (
             SELECT local_profiles.*, MAX(n.created) as latest_activity FROM
             (
                 SELECT p.*
                 FROM profile p
                 JOIN user u ON u.id = p.id
             ) local_profiles
             LEFT JOIN notice n ON local_profiles.id = n.profile_id
             GROUP BY local_profiles.id
             ORDER BY latest_activity
         ) z
         WHERE z.latest_activity < "' . $stale_date . '"
         OR z.latest_activity IS NULL
         LIMIT ' . $offset . ', ' . $limit . ';');
     $cnt = $dataObj->N;
     $this->elementStart('ul');
     while ($dataObj->fetch()) {
         $profile = new Profile();
         foreach ($properties as $property) {
             $profile->{$property} = $dataObj->{$property};
         }
         $profile->latest_activity = $dataObj->latest_activity;
         $pli = new StaleProfileListItem($profile, $this);
         $pli->show();
     }
     $this->elementEnd('ul');
     $this->pagination($this->page > 1, $cnt > PROFILES_PER_PAGE, $this->page, 'staleaccounts', $this->args);
 }

 /**
  * Override the fetch functionality to save related objects
  *
  * @see DB/DB_DataObject::fetch()
  */
 public function fetch()
 {
     $return = parent::fetch();
     if ($return) {
         if (isset($this->showInMainDetails) && is_string($this->showInMainDetails) && !empty($this->showInMainDetails)) {
             // convert to array retrieving from database
             $this->showInMainDetails = unserialize($this->showInMainDetails);
             if (!$this->showInMainDetails) {
                 $this->showInMainDetails = array();
             }
         } elseif (empty($this->showInMainDetails)) {
             // when a value is not set, assume set to show all options, eg null = all
             $default = self::$showInMainDetailsOptions;
             // remove options below that aren't to be part of the default
             unset($default['showISBNs']);
             $default = array_keys($default);
             $this->showInMainDetails = $default;
         }
     }
     return $return;
 }

 function fetch()
 {
     $this->trigger('prefetch');
     if (parent::fetch()) {
         $this->_memoized = array();
         $this->trigger('postfetch');
         return true;
     }
     return false;
 }

 public function fetch()
 {
     // avoid those annoying PEAR::DB strict standards warnings it causes
     $old = error_reporting();
     error_reporting(error_reporting() & ~E_STRICT);
     $res = parent::fetch();
     // reset
     error_reporting($old);
     return $res;
 }