public static function &doPivot(Query $query, DataTable &$data) { // If there is no pivot clause specified in the query, // return the source data $pivot = $query->getPivot(); if ($pivot === null) { return $data; } // Generate a pivot description so we know what fields are // used for what. $pivotDescription = new PivotDescription($data); $pivotDescription->setColumnFields($pivot->getAllColumnIds()); $select = $query->getSelect(); if ($select !== null) { $numSelectedFields = $select->getNumberOfColumns(); for ($i = 0; $i < $numSelectedFields; $i++) { $fieldId = $select->getColumnText($i); $func = $select->getColumnFunction($i); // adds a Row field if $func is null, else adds a data field $pivotDescription->addField($fieldId, $func); } } $pivotAction = new PivotAction($pivotDescription); $result =& $pivotAction->execute(); return $result; }