Ejemplo n.º 1
0
 /**
  * Applies the reduce function to each row and merges rows w/ the same reduce result.
  *
  * @param Piwik_DataTable  $table
  */
 public function filter($table)
 {
     $groupByRows = array();
     $nonGroupByRowIds = array();
     foreach ($table->getRows() as $rowId => $row) {
         // skip the summary row
         if ($rowId == Piwik_DataTable::ID_SUMMARY_ROW) {
             continue;
         }
         // reduce the group by column of this row
         $groupByColumnValue = $row->getColumn($this->groupByColumn);
         $parameters = array_merge(array($groupByColumnValue), $this->parameters);
         $groupByValue = call_user_func_array($this->reduceFunction, $parameters);
         if (!isset($groupByRows[$groupByValue])) {
             // if we haven't encountered this group by value before, we mark this row as a
             // row to keep, and change the group by column to the reduced value.
             $groupByRows[$groupByValue] = $row;
             $row->setColumn($this->groupByColumn, $groupByValue);
         } else {
             // if we have already encountered this group by value, we add this row to the
             // row that will be kept, and mark this one for deletion
             $groupByRows[$groupByValue]->sumRow($row);
             $nonGroupByRowIds[] = $rowId;
         }
     }
     // delete the unneeded rows.
     $table->deleteRows($nonGroupByRowIds);
 }
 /**
  * Filters the given data table
  *
  * @param Piwik_DataTable  $table
  */
 public function filter($table)
 {
     $rowsIdToDelete = array();
     foreach ($table->getRows() as $key => $row) {
         $nbVisits = $this->getColumn($row, Piwik_Archive::INDEX_NB_VISITS);
         $nbActions = $this->getColumn($row, Piwik_Archive::INDEX_NB_ACTIONS);
         if ($nbVisits == 0 && $nbActions == 0 && $this->deleteRowsWithNoVisit) {
             // case of keyword/website/campaign with a conversion for this day,
             // but no visit, we don't show it
             $rowsIdToDelete[] = $key;
             continue;
         }
         $nbVisitsConverted = (int) $this->getColumn($row, Piwik_Archive::INDEX_NB_VISITS_CONVERTED);
         if ($nbVisitsConverted > 0) {
             $conversionRate = round(100 * $nbVisitsConverted / $nbVisits, $this->roundPrecision);
             try {
                 $row->addColumn('conversion_rate', $conversionRate . "%");
             } catch (Exception $e) {
                 // conversion_rate can be defined upstream apparently? FIXME
             }
         }
         if ($nbVisits == 0) {
             $actionsPerVisit = $averageTimeOnSite = $bounceRate = $this->invalidDivision;
         } else {
             // nb_actions / nb_visits => Actions/visit
             // sum_visit_length / nb_visits => Avg. Time on Site
             // bounce_count / nb_visits => Bounce Rate
             $actionsPerVisit = round($nbActions / $nbVisits, $this->roundPrecision);
             $averageTimeOnSite = round($this->getColumn($row, Piwik_Archive::INDEX_SUM_VISIT_LENGTH) / $nbVisits, $rounding = 0);
             $bounceRate = round(100 * $this->getColumn($row, Piwik_Archive::INDEX_BOUNCE_COUNT) / $nbVisits, $this->roundPrecision);
         }
         try {
             $row->addColumn('nb_actions_per_visit', $actionsPerVisit);
             $row->addColumn('avg_time_on_site', $averageTimeOnSite);
         } catch (Exception $e) {
         }
         try {
             $row->addColumn('bounce_rate', $bounceRate . "%");
         } catch (Exception $e) {
         }
         $this->filterSubTable($row);
     }
     $table->deleteRows($rowsIdToDelete);
 }