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;
}
