diff options
Diffstat (limited to 'core/DataTable/Filter/ReplaceColumnNames.php')
| -rw-r--r-- | core/DataTable/Filter/ReplaceColumnNames.php | 167 |
1 files changed, 78 insertions, 89 deletions
diff --git a/core/DataTable/Filter/ReplaceColumnNames.php b/core/DataTable/Filter/ReplaceColumnNames.php index a4ff0d9baf..18942f70c1 100644 --- a/core/DataTable/Filter/ReplaceColumnNames.php +++ b/core/DataTable/Filter/ReplaceColumnNames.php @@ -1,115 +1,104 @@ <?php /** * Piwik - Open source web analytics - * + * * @link http://piwik.org * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later - * + * * @category Piwik * @package Piwik */ /** * This filter replaces column names using a mapping table that maps from the old name to the new name. - * + * * Why this filter? * For saving bytes in the database, you can change all the columns labels by an integer value. * Exemple instead of saving 10000 rows with the column name 'nb_uniq_visitors' which would cost a lot of memory, * we map it to the integer 1 before saving in the DB. * After selecting the DataTable from the DB though, you need to restore back the real names so that * it shows nicely in the report (XML for example). - * + * * You can specify the mapping array to apply in the constructor. - * + * * @package Piwik * @subpackage Piwik_DataTable */ class Piwik_DataTable_Filter_ReplaceColumnNames extends Piwik_DataTable_Filter { - protected $mappingToApply; - - /** - * @param Piwik_DataTable $table Table - * @param array $mappingToApply Mapping to apply. Must have the format - * array( OLD_COLUMN_NAME => NEW_COLUMN NAME, - * OLD_COLUMN_NAME2 => NEW_COLUMN NAME2, - * ) - */ - public function __construct( $table, $mappingToApply = null ) - { - parent::__construct($table); - $this->mappingToApply = Piwik_Archive::$mappingFromIdToName; - if(!is_null($mappingToApply)) - { - $this->mappingToApply = $mappingToApply; - } - } + protected $mappingToApply; - /** - * Executes the filter and renames the defined columns - * - * @param Piwik_DataTable $table - */ - public function filter($table) - { - foreach($table->getRows() as $key => $row) - { - $oldColumns = $row->getColumns(); - $newColumns = $this->getRenamedColumns($oldColumns); - $row->setColumns( $newColumns ); - $this->filterSubTable($row); - } - } + /** + * @param Piwik_DataTable $table Table + * @param array $mappingToApply Mapping to apply. Must have the format + * array( OLD_COLUMN_NAME => NEW_COLUMN NAME, + * OLD_COLUMN_NAME2 => NEW_COLUMN NAME2, + * ) + */ + public function __construct($table, $mappingToApply = null) + { + parent::__construct($table); + $this->mappingToApply = Piwik_Archive::$mappingFromIdToName; + if (!is_null($mappingToApply)) { + $this->mappingToApply = $mappingToApply; + } + } - /** - * Checks the given columns and renames them if required - * - * @param array $columns - * @return array - */ - protected function getRenamedColumns($columns) - { - $newColumns = array(); - foreach($columns as $columnName => $columnValue) - { - if(isset($this->mappingToApply[$columnName])) - { - $columnName = $this->mappingToApply[$columnName]; - - if($columnName == 'goals') - { - $newSubColumns = array(); - foreach($columnValue as $idGoal => $goalValues) - { - $mapping = Piwik_Archive::$mappingFromIdToNameGoal; - if($idGoal == Piwik_Tracker_GoalManager::IDGOAL_CART) - { - $idGoal = Piwik_Archive::LABEL_ECOMMERCE_CART; - } - elseif($idGoal == Piwik_Tracker_GoalManager::IDGOAL_ORDER) - { - $idGoal = Piwik_Archive::LABEL_ECOMMERCE_ORDER; - } - foreach($goalValues as $id => $goalValue) - { - $subColumnName = $mapping[$id]; - $newSubColumns['idgoal='.$idGoal][$subColumnName] = $goalValue; - } - } - $columnValue = $newSubColumns; - } - // If we happen to rename a column to a name that already exists, - // sum both values in the column. This should really not happen, but - // we introduced in 1.1 a new dataTable indexing scheme for Actions table, and - // could end up with both strings and their int indexes counterpart in a monthly/yearly dataTable - // built from DataTable with both formats - if(isset($newColumns[$columnName])) - { - $columnValue += $newColumns[$columnName]; - } - } - $newColumns[$columnName] = $columnValue; - } - return $newColumns; - } + /** + * Executes the filter and renames the defined columns + * + * @param Piwik_DataTable $table + */ + public function filter($table) + { + foreach ($table->getRows() as $key => $row) { + $oldColumns = $row->getColumns(); + $newColumns = $this->getRenamedColumns($oldColumns); + $row->setColumns($newColumns); + $this->filterSubTable($row); + } + } + + /** + * Checks the given columns and renames them if required + * + * @param array $columns + * @return array + */ + protected function getRenamedColumns($columns) + { + $newColumns = array(); + foreach ($columns as $columnName => $columnValue) { + if (isset($this->mappingToApply[$columnName])) { + $columnName = $this->mappingToApply[$columnName]; + + if ($columnName == 'goals') { + $newSubColumns = array(); + foreach ($columnValue as $idGoal => $goalValues) { + $mapping = Piwik_Archive::$mappingFromIdToNameGoal; + if ($idGoal == Piwik_Tracker_GoalManager::IDGOAL_CART) { + $idGoal = Piwik_Archive::LABEL_ECOMMERCE_CART; + } elseif ($idGoal == Piwik_Tracker_GoalManager::IDGOAL_ORDER) { + $idGoal = Piwik_Archive::LABEL_ECOMMERCE_ORDER; + } + foreach ($goalValues as $id => $goalValue) { + $subColumnName = $mapping[$id]; + $newSubColumns['idgoal=' . $idGoal][$subColumnName] = $goalValue; + } + } + $columnValue = $newSubColumns; + } + // If we happen to rename a column to a name that already exists, + // sum both values in the column. This should really not happen, but + // we introduced in 1.1 a new dataTable indexing scheme for Actions table, and + // could end up with both strings and their int indexes counterpart in a monthly/yearly dataTable + // built from DataTable with both formats + if (isset($newColumns[$columnName])) { + $columnValue += $newColumns[$columnName]; + } + } + $newColumns[$columnName] = $columnValue; + } + return $newColumns; + } } |