PHP CriteriaCompo::getSort方法代码示例

 /**
  * Retrieve a list of objects as arrays - DON'T USE WITH JOINT KEYS
  *
  * @param object $criteria {@link CriteriaElement} conditions to be met
  * @param int   $limit      Max number of objects to fetch
  * @param int   $start      Which record to start at
  *
  * @return array
  */
 function getList($criteria = null, $limit = 0, $start = 0)
 {
     $ret = array();
     if ($criteria == null) {
         $criteria = new CriteriaCompo();
     }
     if ($criteria->getSort() == '') {
         $criteria->setSort($this->identifierName);
     }
     $sql = 'SELECT ' . $this->keyName;
     if (!empty($this->identifierName)) {
         $sql .= ', ' . $this->identifierName;
     }
     $sql .= ' FROM ' . $this->table;
     if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
         $sql .= ' ' . $criteria->renderWhere();
         if ($criteria->getSort() != '') {
             $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder();
         }
         $limit = $criteria->getLimit();
         $start = $criteria->getStart();
     }
     $result = $this->db->query($sql, $limit, $start);
     if (!$result) {
         return $ret;
     }
     $myts =& MyTextSanitizer::getInstance();
     while ($myrow = $this->db->fetchArray($result)) {
         //identifiers should be textboxes, so sanitize them like that
         $ret[$myrow[$this->keyName]] = empty($this->identifierName) ? 1 : $myts->htmlSpecialChars($myrow[$this->identifierName]);
     }
     return $ret;
 }

 function getActiveModules()
 {
     //
     // At first, get active module IDs.
     //
     static $ret;
     if (isset($ret)) {
         return $ret;
     }
     $handler =& xoops_gethandler('module');
     $criteria = new CriteriaCompo();
     $criteria->add(new Criteria('isactive', 1));
     $criteria->add(new Criteria('hassearch', 1));
     // shortcut for speedup
     $db = $handler->db;
     $sort = $criteria->getSort();
     $sql = 'SELECT mid,name FROM ' . $db->prefix('modules') . ' ' . $criteria->renderWhere() . ($sort ? ' ORDER BY ' . $sort . ' ' . $criteria->getOrder() : ' ORDER BY weight ' . $criteria->getOrder() . ', mid ASC');
     $result = $db->query($sql);
     $handler =& xoops_gethandler('groupperm');
     $groupArr = Legacy_SearchUtils::getUserGroups();
     $ret = array();
     while (list($mid, $name) = $db->fetchRow($result)) {
         if ($handler->checkRight('module_read', $mid, $groupArr)) {
             $ret[] = array('mid' => $mid, 'name' => $name);
         }
     }
     return $ret;
 }

 /**
  * Get configs from the database
  * 
  * @param	object  $criteria   {@link CriteriaElement}
  * @param	bool    $id_as_key  return the config's id as key?
  *
  * @return	array   Array of {@link XoopsConfigItem} objects
  */
 function getObjects($criteria = null, $id_as_key = false)
 {
     if ($criteria == null) {
         $criteria = new CriteriaCompo();
     }
     if ($criteria->getSort() == "") {
         $criteria->setSort('conf_order');
     }
     return parent::getObjects($criteria, $id_as_key);
 }

 /**
  * Get a list of {@link SmartmediaFolder} objects for the search feature
  *
  * @param array $queryarray list of keywords to look for
  * @param string $andor specify which type of search we are performing : AND or OR
  * @param int $limit maximum number of results to return
  * @param int $offset at which folder shall we start
  * @param int $userid userid related to the creator of the folder
  *
  * @return array array containing information about the folders mathing the search criterias
  */
 function &getObjectsForSearch($queryarray = array(), $andor = 'AND', $limit = 0, $offset = 0, $userid = 0)
 {
     global $xoopsConfig;
     $ret = array();
     $sql = "SELECT item." . $this->_key_field . ", itemtext." . $this->_caption_field . ", itemtext.description, parent.categoryid FROM\r\n                   (\r\n        \t\t\t (" . $this->_db->prefix($this->_dbtable) . " AS item\r\n\t\t\t\t\t   INNER JOIN " . $this->_db->prefix($this->_dbtable) . "_text AS itemtext \r\n        \t\t       ON item." . $this->_key_field . " = itemtext." . $this->_key_field . "\r\n        \t\t     )\r\n        \t\t     INNER JOIN " . $this->_db->prefix($this->_dbtable_parent) . " AS parent\r\n         \t\t     ON parent." . $this->_key_field . " = item." . $this->_key_field . "\r\n                   )";
     if ($queryarray) {
         $criteriaKeywords = new CriteriaCompo();
         for ($i = 0; $i < count($queryarray); $i++) {
             $criteriaKeyword = new CriteriaCompo();
             $criteriaKeyword->add(new Criteria('itemtext.title', '%' . $queryarray[$i] . '%', 'LIKE'), 'OR');
             $criteriaKeyword->add(new Criteria('itemtext.description', '%' . $queryarray[$i] . '%', 'LIKE'), 'OR');
             $criteriaKeywords->add($criteriaKeyword, $andor);
         }
     }
     if ($userid != 0) {
         $criteriaUser = new CriteriaCompo();
         $criteriaUser->add(new Criteria('item.uid', $userid), 'OR');
     }
     $criteria = new CriteriaCompo();
     // Languageid
     $criteriaLanguage = new CriteriaCompo();
     $criteriaLanguage->add(new Criteria('itemtext.languageid', $xoopsConfig['language']));
     $criteria->add($criteriaLanguage);
     if (!empty($criteriaUser)) {
         $criteria->add($criteriaUser, 'AND');
     }
     if (!empty($criteriaKeywords)) {
         $criteria->add($criteriaKeywords, 'AND');
     }
     $criteria->setSort('item.weight');
     $criteria->setOrder('ASC');
     $sql .= ' ' . $criteria->renderWhere();
     //$sql .= "GROUP BY parent." . $this->_key_field . "";
     if ($criteria->getSort() != '') {
         $sql .= ' ORDER BY ' . $criteria->getSort() . '
             ' . $criteria->getOrder();
     }
     //echo "<br />$sql<br />";
     $result = $this->_db->query($sql, $limit, $offset);
     // If no records from db, return empty array
     if (!$result) {
         return $ret;
     }
     // Add each returned record to the result array
     while ($myrow = $this->_db->fetchArray($result)) {
         $item['id'] = $myrow[$this->_key_field];
         $item['title'] = $myrow[$this->_caption_field];
         $item['categoryid'] = $myrow[$this->_parent_field];
         $ret[] = $item;
         unset($item);
     }
     return $ret;
 }