addGroupField() public method

Add group field
public addGroupField ( $p_field )
$p_field
示例#1
0
    /**
     * Gets an issues list based on the given parameters.
     *
     * @param array $p_parameters
     *    An array of ComparisonOperation objects
     * @param string $p_order
     *    An array of columns and directions to order by
     * @param integer $p_start
     *    The record number to start the list
     * @param integer $p_limit
     *    The offset. How many records from $p_start will be retrieved.
     * @param integer $p_count
     *    The total count of the elements; this count is computed without
     *    applying the start ($p_start) and limit parameters ($p_limit)
     *
     * @return array $issuesList
     *    An array of Issue objects
     */
    public static function GetList(array $p_parameters, $p_order = null,
                                   $p_start = 0, $p_limit = 0, &$p_count, $p_skipCache = false)
    {
        global $g_ado_db;

        if (!$p_skipCache && CampCache::IsEnabled()) {
        	$paramsArray['parameters'] = serialize($p_parameters);
        	$paramsArray['order'] = (is_null($p_order)) ? 'null' : $p_order;
        	$paramsArray['start'] = $p_start;
        	$paramsArray['limit'] = $p_limit;
        	$cacheListObj = new CampCacheList($paramsArray, __METHOD__);
        	$issuesList = $cacheListObj->fetchFromCache();
        	if ($issuesList !== false && is_array($issuesList)) {
        		return $issuesList;
        	}
        }

        $hasPublicationId = false;
        $selectClauseObj = new SQLSelectClause();
        $countClauseObj = new SQLSelectClause();

        // sets the where conditions
        foreach ($p_parameters as $param) {
            $comparisonOperation = self::ProcessListParameters($param);
            if (empty($comparisonOperation)) {
                break;
            }
            if (strpos($comparisonOperation['left'], 'IdPublication') !== false) {
                $hasPublicationId = true;
            }

            $whereCondition = $comparisonOperation['left'] . ' '
                . $comparisonOperation['symbol'] . " '"
                . $g_ado_db->escape($comparisonOperation['right']) . "' ";
            $selectClauseObj->addWhere($whereCondition);
            $countClauseObj->addWhere($whereCondition);
        }

        // validates whether publication identifier was given
        if ($hasPublicationId == false) {
            CampTemplate::singleton()->trigger_error('missed parameter Publication '
                .'Identifier in statement list_topics');
            return;
        }

        // sets the columns to be fetched
        $tmpIssue = new Issue();
		$columnNames = $tmpIssue->getColumnNames(true);
        foreach ($columnNames as $columnName) {
            $selectClauseObj->addColumn($columnName);
        }
        $countClauseObj->addColumn('COUNT(*)');

        // sets the main table for the query
        $selectClauseObj->setTable($tmpIssue->getDbTableName());
        $countClauseObj->setTable($tmpIssue->getDbTableName());
        unset($tmpIssue);

        if (is_array($p_order)) {
            $order = Issue::ProcessListOrder($p_order);
            // sets the order condition if any
            foreach ($order as $orderDesc) {
                $orderField = $orderDesc['field'];
                $orderDirection = $orderDesc['dir'];
                $selectClauseObj->addOrderBy($orderField . ' ' . $orderDirection);
            }
        }

        $selectClauseObj->addGroupField('Number');
        $selectClauseObj->addGroupField('IdLanguage');

        // sets the limit
        $selectClauseObj->setLimit($p_start, $p_limit);

        // builds the query and executes it
        $selectQuery = $selectClauseObj->buildQuery();
        $countQuery = $countClauseObj->buildQuery();
        $issues = $g_ado_db->GetAll($selectQuery);
        if (is_array($issues)) {
        	$p_count = $g_ado_db->GetOne($countQuery);

        	// builds the array of issue objects
        	$issuesList = array();
        	foreach ($issues as $issue) {
        		$issObj = new Issue($issue['IdPublication'],
        		$issue['IdLanguage'],
        		$issue['Number']);
        		if ($issObj->exists()) {
        			$issuesList[] = $issObj;
        		}
        	}
        } else {
        	$issuesList = array();
        	$p_count = 0;
        }
        if (!$p_skipCache && CampCache::IsEnabled()) {
        	$cacheListObj->storeInCache($issuesList);
        }

        return $issuesList;
    } // fn GetList
示例#2
0
文件: Topic.php 项目: nidzix/Newscoop
 /**
  * Get all the topics in an array, where each element contains the entire
  * path for each topic.  Each topic will be indexed by its ID.
  * For example, if we have the following topic structure (IDs are
  * in brackets):
  *
  * sports (1)
  *  - baseball (2)
  *  - soccer (3)
  *    - player stats (4)
  *    - matches (5)
  * politics (6)
  *  - world (7)
  *  - local (8)
  *
  *  ...then the returned array would look like:
  *  array(array(1 => "sports"),
  *        array(1 => "sports", 2 => "baseball"),
  *        array(1 => "sports", 3 => "soccer"),
  *        array(1 => "sports", 3 => "soccer", 4 => "player stats"),
  *        array(1 => "sports", 3 => "soccer", 5 => "matches"),
  *        array(6 => "politics"),
  *        array(6 => "politics", 7 => "world"),
  *        array(6 => "politics", 8 => "local")
  *  );
  *
  * @param int $p_startingTopicId
  * @return array
  */
 public static function GetTree($p_startingTopicId = 0)
 {
     global $g_ado_db;
     $topicObj = new Topic();
     $query = new SQLSelectClause();
     $query->addColumn('node.id');
     $query->addColumn('(COUNT(parent.id) - 1) AS depth');
     $query->setTable($topicObj->m_dbTableName . ' AS node');
     $query->addTableFrom($topicObj->m_dbTableName . ' AS parent');
     $query->addWhere('node.node_left BETWEEN parent.node_left AND parent.node_right');
     if ($p_startingTopicId > 0) {
         $query->addTableFrom($topicObj->m_dbTableName . ' AS sub_parent');
         $query->addWhere('node.node_left > sub_parent.node_left');
         $query->addWhere('node.node_left < sub_parent.node_right');
         $query->addWhere('sub_parent.id = ' . (int) $p_startingTopicId);
     }
     $query->addGroupField('node.id');
     $query->addOrderBy('node.node_left');
     $rows = $g_ado_db->GetAll($query->buildQuery());
     if (empty($rows)) {
         // empty tree
         return array();
     }
     $p_tree = array();
     $startDepth = null;
     $currentPath = array();
     foreach ($rows as $row) {
         $topicId = $row['id'];
         $depth = $row['depth'] - (int) $startDepth;
         $topic = new Topic($topicId);
         if (is_null($startDepth)) {
             $startDepth = $depth;
             $depth = 0;
             $currentPath[$topicId] = $topic;
         } elseif ($depth > count($currentPath)) {
             $currentPath[$topicId] = $topic;
         } elseif ($depth == 0) {
             $currentPath = array($topicId => $topic);
         } else {
             while ($depth < count($currentPath)) {
                 array_pop($currentPath);
             }
             $currentPath[$topicId] = $topic;
         }
         $p_tree[] = $currentPath;
     }
     return $p_tree;
 }