PHP DataObjectSet::sort方法代码示例

 function Tables()
 {
     $tables = new DataObjectSet();
     foreach (DB::tableList() as $table) {
         $tables->push(new DBP_Table($table));
     }
     $tables->sort('LowerCaseName');
     return $tables;
 }

 /**
  * Get members who have BLOGMANAGEMENT and ADMIN permission
  */
 function blogOwners($sort = 'Name', $direction = "ASC")
 {
     $adminMembers = Permission::get_members_by_permission('ADMIN');
     $blogOwners = Permission::get_members_by_permission('BLOGMANAGEMENT');
     if (!$adminMembers) {
         $adminMembers = new DataObjectSet();
     }
     if (!$blogOwners) {
         $blogOwners = new DataObjectSet();
     }
     $blogOwners->merge($adminMembers);
     $blogOwners->sort($sort, $direction);
     $this->extend('extendBlogOwners', $blogOwners);
     return $blogOwners;
 }

 function sourceRecords($params, $sort, $limit)
 {
     increase_time_limit_to(120);
     $res = WorkflowThreeStepRequest::get_by_publisher('WorkflowDeletionRequest', Member::currentUser(), array('Approved'));
     $doSet = new DataObjectSet();
     foreach ($res as $result) {
         if ($wf = $result->openWorkflowRequest()) {
             if (!$result->canDeleteFromLive()) {
                 continue;
             }
             $result->WFAuthorID = $wf->AuthorID;
             $result->WFApproverTitle = $wf->Approver()->Title;
             $result->WFAuthorTitle = $wf->Author()->Title;
             $result->WFApprovedWhen = $wf->ApprovalDate();
             $result->WFRequestedWhen = $wf->Created;
             $result->WFApproverID = $wf->ApproverID;
             $result->WFPublisherID = $wf->PublisherID;
             if (isset($_REQUEST['OnlyMine']) && $result->WFApproverID != Member::currentUserID()) {
                 continue;
             }
             $result->BacklinkCount = $result->BackLinkTracking()->Count();
             $doSet->push($result);
         }
     }
     if ($sort) {
         $parts = explode(' ', $sort);
         $field = $parts[0];
         $direction = $parts[1];
         if ($field == 'AbsoluteLink') {
             $sort = 'URLSegment ' . $direction;
         }
         if ($field == 'Subsite.Title') {
             $sort = 'SubsiteID ' . $direction;
         }
         $doSet->sort($sort);
     }
     if ($limit && $limit['limit']) {
         return $doSet->getRange($limit['start'], $limit['limit']);
     } else {
         return $doSet;
     }
 }

 function getEstimates()
 {
     if ($this->calculated) {
         return $this->estimates;
     }
     $output = new DataObjectSet();
     if ($options = $this->getShippingMethods()) {
         foreach ($options as $option) {
             $option->CalculatedRate = $option->calculateRate($this->package, $this->address);
             if ($option->CalculatedRate !== null) {
                 $output->push($option);
             }
         }
     }
     $output->sort("CalculatedRate", "ASC");
     //sort by rate, lowest to highest
     // cache estimates
     $this->estimates = $output;
     $this->calculated = true;
     return $output;
 }

 function sourceRecords($params, $sort, $limit)
 {
     increase_time_limit_to(120);
     $res = WorkflowTwoStepRequest::get_by_publisher('WorkflowPublicationRequest', Member::currentUser(), array('AwaitingApproval'));
     $doSet = new DataObjectSet();
     if ($res) {
         foreach ($res as $result) {
             if (!$result->canPublish()) {
                 continue;
             }
             if ($wf = $result->openWorkflowRequest()) {
                 if (ClassInfo::exists('Subsite')) {
                     $result->SubsiteTitle = $result->Subsite()->Title;
                 }
                 $result->RequestedAt = $wf->Created;
                 $result->WFAuthorTitle = $wf->Author()->Title;
                 $result->HasEmbargo = $wf->getEmbargoDate() ? date('j M Y g:ia', strtotime($wf->getEmbargoDate())) : 'no';
                 $doSet->push($result);
             }
         }
     }
     if ($sort) {
         $parts = explode(' ', $sort);
         $field = $parts[0];
         $direction = $parts[1];
         if ($field == 'AbsoluteLink') {
             $sort = 'URLSegment ' . $direction;
         }
         if ($field == 'Subsite.Title') {
             $sort = 'SubsiteID ' . $direction;
         }
         $doSet->sort($sort);
     }
     if ($limit && $limit['limit']) {
         return $doSet->getRange($limit['start'], $limit['limit']);
     } else {
         return $doSet;
     }
 }

 /**
  * Populates an array of classes in the CMS
  * which allows the user to change the page type.
  *
  * @return DataObjectSet
  */
 public function PageTypes()
 {
     $classes = SiteTree::page_type_classes();
     $result = new DataObjectSet();
     foreach ($classes as $class) {
         $instance = singleton($class);
         if ($instance instanceof HiddenClass) {
             continue;
         }
         if (!$instance->canCreate()) {
             continue;
         }
         // skip this type if it is restricted
         if ($instance->stat('need_permission') && !$this->can(singleton($class)->stat('need_permission'))) {
             continue;
         }
         $addAction = $instance->i18n_singular_name();
         // if we're in translation mode, the link between the translated pagetype
         // title and the actual classname might not be obvious, so we add it in parantheses
         // Example: class "RedirectorPage" has the title "Weiterleitung" in German,
         // so it shows up as "Weiterleitung (RedirectorPage)"
         if (i18n::get_locale() != 'en_US') {
             $addAction .= " ({$class})";
         }
         $result->push(new ArrayData(array('ClassName' => $class, 'AddAction' => $addAction)));
     }
     $result->sort('AddAction');
     return $result;
 }

 /**
  * Populates an array of classes in the CMS which allows the
  * user to change the page type.
  */
 public function PageTypes()
 {
     $classes = ClassInfo::getValidSubClasses();
     array_shift($classes);
     $result = new DataObjectSet();
     $kill_ancestors = array();
     // figure out if there are any classes we don't want to appear
     foreach ($classes as $class) {
         $instance = singleton($class);
         // do any of the progeny want to hide an ancestor?
         if ($ancestor_to_hide = $instance->stat('hide_ancestor')) {
             // note for killing later
             $kill_ancestors[] = $ancestor_to_hide;
         }
     }
     // If any of the descendents don't want any of the elders to show up, cruelly render the elders surplus to requirements.
     if ($kill_ancestors) {
         foreach ($kill_ancestors as $mark) {
             // unset from $classes
             $idx = array_search($mark, $classes);
             unset($classes[$idx]);
         }
     }
     foreach ($classes as $class) {
         $instance = singleton($class);
         if ($instance instanceof HiddenClass) {
             continue;
         }
         if (!$instance->canCreate()) {
             continue;
         }
         // skip this type if it is restricted
         if ($instance->stat('need_permission') && !$this->can(singleton($class)->stat('need_permission'))) {
             continue;
         }
         /*
          * Since i18n_singular_name() this is not necessary
         $addAction = $instance->uninherited('add_action', true);
         if($addAction) {
         	// backwards compatibility for actions like "a page" (instead of "page")
         	$addAction = preg_replace('/^a /','',$addAction);				
         	$addAction = ucfirst($addAction);
         } else {
         	$addAction = $instance->i18n_singular_name();
         }
         */
         $addAction = $instance->i18n_singular_name();
         $result->push(new ArrayData(array("ClassName" => $class, "AddAction" => $addAction)));
     }
     $result->sort('AddAction');
     return $result;
 }

 function getCMSFields()
 {
     if ($this->FolderID) {
         // New token - select file:
         $folder = DataObject::get_by_id('Folder', $this->FolderID);
         $files = new DataObjectSet();
         if ($folder->myChildren()) {
             foreach ($folder->myChildren() as $file) {
                 if (!$file instanceof Folder) {
                     $files->push($file);
                 }
             }
             $files->sort('Name');
         }
         $fileField = new DropdownField('FileID', 'File', $files->map('ID', 'Name'));
     } else {
         // Existing token:
         $fileField = new ReadonlyField('FileDummy', 'File', $this->File()->Name);
     }
     $fields = new FieldSet();
     $fields->push($root = new TabSet('Root'));
     $root->push($main = new Tab('Main'));
     $main->push($fileField);
     if (ClassInfo::exists('DatetimeField')) {
         // 2.4.x
         $main->push($expiry_field = new DatetimeField('Expiry', 'Expiry'));
         $expiry_field->getDateField()->setConfig('showcalendar', true);
         $expiry_field->getTimeField()->setConfig('showdropdown', true);
     } else {
         // 2.3.x
         $main->push($expiry_field = new PopupDateTimeField('Expiry', 'Expiry'));
     }
     $main->push(new ReadonlyField('MemberDummyField', 'Member', $this->MemberNice()));
     if ($this->ID) {
         $main->push(new ReadonlyField('Token', 'Token'));
     }
     $this->extend('updateCMSFields', $fields);
     return $fields;
 }

 function sourceRecords($params, $sort, $limit)
 {
     $join = '';
     $sortBrokenReason = false;
     if ($sort) {
         $parts = explode(' ', $sort);
         $field = $parts[0];
         $direction = $parts[1];
         if ($field == 'AbsoluteLink') {
             $sort = 'URLSegment ' . $direction;
         } elseif ($field == 'Subsite.Title') {
             $join = 'LEFT JOIN "Subsite" ON "Subsite"."ID" = "SiteTree"."SubsiteID"';
         } elseif ($field == 'BrokenReason') {
             $sortBrokenReason = true;
             $sort = '';
         }
     }
     $q = DB::USE_ANSI_SQL ? '"' : '`';
     if (!isset($_REQUEST['CheckSite']) || $params['CheckSite'] == 'Published') {
         $ret = Versioned::get_by_stage('SiteTree', 'Live', "({$q}SiteTree{$q}.{$q}HasBrokenLink{$q} = 1 OR {$q}SiteTree{$q}.{$q}HasBrokenFile{$q} = 1)", $sort, $join, $limit);
     } else {
         $ret = DataObject::get('SiteTree', "({$q}SiteTree{$q}.{$q}HasBrokenFile{$q} = 1 OR {$q}HasBrokenLink{$q} = 1)", $sort, $join, $limit);
     }
     $returnSet = new DataObjectSet();
     if ($ret) {
         foreach ($ret as $record) {
             $reason = false;
             $isRedirectorPage = in_array($record->ClassName, ClassInfo::subclassesFor('RedirectorPage'));
             $isVirtualPage = in_array($record->ClassName, ClassInfo::subclassesFor('VirtualPage'));
             if ($isVirtualPage) {
                 if ($record->HasBrokenLink) {
                     $reason = _t('BrokenLinksReport.VirtualPageNonExistent', "virtual page pointing to non-existent page");
                     $reasonCodes = array("VPBROKENLINK");
                 }
             } else {
                 if ($isRedirectorPage) {
                     if ($record->HasBrokenLink) {
                         $reason = _t('BrokenLinksReport.RedirectorNonExistent', "redirector page pointing to non-existent page");
                         $reasonCodes = array("RPBROKENLINK");
                     }
                 } else {
                     if ($record->HasBrokenLink && $record->HasBrokenFile) {
                         $reason = _t('BrokenLinksReport.HasBrokenLinkAndFile', "has broken link and file");
                         $reasonCodes = array("BROKENFILE", "BROKENLINK");
                     } else {
                         if ($record->HasBrokenLink && !$record->HasBrokenFile) {
                             $reason = _t('BrokenLinksReport.HasBrokenLink', "has broken link");
                             $reasonCodes = array("BROKENLINK");
                         } else {
                             if (!$record->HasBrokenLink && $record->HasBrokenFile) {
                                 $reason = _t('BrokenLinksReport.HasBrokenFile', "has broken file");
                                 $reasonCodes = array("BROKENFILE");
                             }
                         }
                     }
                 }
             }
             if ($reason) {
                 if (isset($params['Reason']) && $params['Reason'] && !in_array($params['Reason'], $reasonCodes)) {
                     continue;
                 }
                 $record->BrokenReason = $reason;
                 $returnSet->push($record);
             }
         }
     }
     if ($sortBrokenReason) {
         $returnSet->sort('BrokenReason', $direction);
     }
     return $returnSet;
 }

 /**
  * Retrieves a Videos Feed - generic method
  *
  * @param method - video function, actually the sub url of the feed eg:/playlists
  * @param params - params to pass
  * @param max_results - maximum results to return
  * @param start_index - start index of the video feed
  * @param orderby - Sorting method. The possible valus are relevance, updated, published, viewCount, rating
  * @return DataObjectSet
  */
 function getVideosFeed($method = NULL, $params = array(), $max_results = NULL, $start_index = NULL, $orderby = NULL)
 {
     if (array_key_exists($orderby, self::$sortby_processing)) {
         $default_params = array('max-results' => 50);
     } else {
         $default_params = array('max-results' => $max_results, 'start-index' => $start_index, 'orderby' => $orderby);
     }
     $params = array_merge($params, $default_params);
     $this->baseURL = self::$api_base_url . $method;
     $this->setQueryString($params);
     $response = $this->request();
     //have to make a custom XML object
     try {
         $xml = @new SimpleXMLElement($response->getBody());
         $videos = $xml->entry;
         $results = new DataObjectSet();
         foreach ($videos as $video) {
             $data = $this->extractVideoInfo($video);
             // Get the data requested
             if (array_key_exists($orderby, self::$sortby_processing)) {
                 $customSortObj = $video->xpath(self::$sortby_processing[$orderby]);
                 $data['customsortby'] = count($customSortObj) ? (string) $customSortObj[0] : null;
             }
             $results->push(new ArrayData($data));
         }
         if (array_key_exists($orderby, self::$sortby_processing)) {
             $results->sort('customsortby', 'DESC');
             $results = $results->getRange(0, $max_results);
             // we can't allow paging on custom filters
             $this->videoCount = $results->Count();
             $this->pageCount = 1;
         } else {
             //get total number of videos
             $this->videoCount = $this->searchValue($response->getBody(), 'openSearch:totalResults');
             $this->pageCount = (int) ($this->videoCount / $max_results);
         }
         return $results;
     } catch (Exception $e) {
         user_error("Error occurred in processing YouTube response");
         return false;
     }
 }

 /**
  * Returns a list of valid languages from GeSHi
  * @return DatObjectSet
  */
 static function get_valid_languages()
 {
     require_once dirname(__DIR__) . '/thirdparty/geshi/geshi.php';
     $g = new GeSHi();
     $languages = new DataObjectSet();
     foreach ($g->get_supported_languages(false) as $language) {
         $languages->push(new ArrayData(array('ID' => $language, 'Name' => $language)));
     }
     $languages->sort('Name');
     return $languages;
 }

 /**
  * Test {@link DataObjectSet->sort()}
  */
 function testSort()
 {
     $set = new DataObjectSet(array(array('Name' => 'Object1', 'F1' => 1, 'F2' => 2, 'F3' => 3), array('Name' => 'Object2', 'F1' => 2, 'F2' => 1, 'F3' => 4), array('Name' => 'Object3', 'F1' => 5, 'F2' => 2, 'F3' => 2)));
     // test a single sort ASC
     $set->sort('F3', 'ASC');
     $this->assertEquals($set->First()->Name, 'Object3', 'Object3 should be first in the set');
     // test a single sort DESC
     $set->sort('F3', 'DESC');
     $this->assertEquals($set->First()->Name, 'Object2', 'Object2 should be first in the set');
     // test a multi sort
     $set->sort(array('F2' => 'ASC', 'F1' => 'ASC'));
     $this->assertEquals($set->Last()->Name, 'Object3', 'Object3 should be last in the set');
     // test a multi sort
     $set->sort(array('F2' => 'ASC', 'F1' => 'DESC'));
     $this->assertEquals($set->Last()->Name, 'Object1', 'Object1 should be last in the set');
 }

 /**
  * Populates an array of classes in the CMS
  * which allows the user to change the page type.
  *
  * @return DataObjectSet
  */
 public function PageTypes()
 {
     $classes = SiteTree::page_type_classes();
     $result = new DataObjectSet();
     foreach ($classes as $class) {
         $instance = singleton($class);
         if ($instance instanceof HiddenClass) {
             continue;
         }
         if (!$instance->canCreate()) {
             continue;
         }
         // skip this type if it is restricted
         if ($instance->stat('need_permission') && !$this->can(singleton($class)->stat('need_permission'))) {
             continue;
         }
         $addAction = $instance->i18n_singular_name();
         // Get description
         $description = _t($class . 'DESCRIPTION');
         if (!$description) {
             $description = $instance->uninherited('description');
         }
         if ($class == 'Page' && !$description) {
             $description = singleton('SiteTree')->uninherited('description');
         }
         $result->push(new ArrayData(array('ClassName' => $class, 'AddAction' => $addAction, 'Description' => $description, 'IconURL' => $instance->stat('icon'))));
     }
     $result->sort('AddAction');
     return $result;
 }

 /**
  * Return the Sticky Threads
  * @return DataObjectSet
  */
 function getStickyTopics($include_global = true)
 {
     $standard = DataObject::get("ForumThread", "\"ForumThread\".\"ForumID\" = {$this->ID} AND \"ForumThread\".\"IsSticky\" = 1", "MAX(\"PostList\".\"Created\") DESC", "INNER JOIN \"Post\" AS \"PostList\" ON \"PostList\".\"ThreadID\" = \"ForumThread\".\"ID\"");
     if (!$standard || !$standard->count()) {
         $standard = new DataObjectSet();
     }
     if ($include_global) {
         // We have to join posts through their forums to their holders, and then restrict the holders to just the parent of this forum.
         $global = DataObject::get("ForumThread", "\"ForumThread\".\"IsGlobalSticky\" = 1", "MAX(\"PostList\".\"Created\") DESC", "INNER JOIN \"Post\" AS \"PostList\" ON \"PostList\".\"ThreadID\" = \"ForumThread\".\"ID\"");
         if (!$global || !$global->count()) {
             $global = new DataObjectSet();
         }
         $standard->merge($global);
         $standard->removeDuplicates();
     }
     if ($standard->count()) {
         $standard->sort('PostList.Created');
     }
     return $standard;
 }