public function testGetAggregationTypeReturnsNullForUnknownFieldId() { $pivot = new PivotDescription($this->dataTable); $pivot->setColumnFields(array('country', 'region')); $expected = null; $actual = $pivot->getAggregationType('not-a-data-field'); $this->assertSame($expected, $actual, "Expect null for non-data fields"); }
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; }