/** * API method that returns number of visits based on hour parity. * @param int $idSite * @param string $period * @param string $date * @param bool|string $segment * @return DataTable */ public function getEvenUnevenTimes($idSite, $period, $date, $segment = false) { $archive = Archive::build($idSite, $period, $date); $oddHoursCount = $archive->getNumeric(Archiver::ODD_HOURS_COUNT_RECORD_NAME); $evenHoursCount = $archive->getNumeric(Archiver::EVEN_HOURS_COUNT_RECORD_NAME); $table = new DataTable(); $table->setTableSortedBy('times'); $table->addRowFromArray(array(Row::COLUMNS => array('times' => Piwik::translate('HourParity_Oddhours'), 'nb_visits' => $oddHoursCount))); $table->addRowFromArray(array(Row::COLUMNS => array('times' => Piwik::translate('HourParity_Evenhours'), 'nb_visits' => $evenHoursCount))); return $table; }
/** * Sorts the DataTable rows using the supplied callback function. * * @param DataTable $table The table to sort. */ public function sort(DataTable $table) { // all that code is in here and not in separate methods for best performance. It does make a difference once // php has to copy many (eg 50k) rows otherwise. $table->setTableSortedBy($this->config->primaryColumnToSort); $rows = $table->getRowsWithoutSummaryRow(); // we need to sort rows that have a value separately from rows that do not have a value since we always want // to append rows that do not have a value at the end. $rowsWithValues = array(); $rowsWithoutValues = array(); $valuesToSort = array(); foreach ($rows as $key => $row) { $value = $this->getColumnValue($row); if (isset($value)) { $valuesToSort[] = $value; $rowsWithValues[] = $row; } else { $rowsWithoutValues[] = $row; } } unset($rows); if ($this->config->isSecondaryColumnSortEnabled && $this->config->secondaryColumnToSort) { $secondaryValues = array(); foreach ($rowsWithValues as $key => $row) { $secondaryValues[$key] = $row->getColumn($this->config->secondaryColumnToSort); } array_multisort($valuesToSort, $this->config->primarySortOrder, $this->config->primarySortFlags, $secondaryValues, $this->config->secondarySortOrder, $this->config->secondarySortFlags, $rowsWithValues); } else { array_multisort($valuesToSort, $this->config->primarySortOrder, $this->config->primarySortFlags, $rowsWithValues); } if (!empty($rowsWithoutValues) && $this->config->secondaryColumnToSort) { $secondaryValues = array(); foreach ($rowsWithoutValues as $key => $row) { $secondaryValues[$key] = $row->getColumn($this->config->secondaryColumnToSort); } array_multisort($secondaryValues, $this->config->secondarySortOrder, $this->config->secondarySortFlags, $rowsWithoutValues); } unset($secondaryValues); foreach ($rowsWithoutValues as $row) { $rowsWithValues[] = $row; } $table->setRows(array_values($rowsWithValues)); }
/** * Sorts the DataTable rows using the supplied callback function. * * @param string $functionCallback A comparison callback compatible with {@link usort}. * @param string $columnSortedBy The column name `$functionCallback` sorts by. This is stored * so we can determine how the DataTable was sorted in the future. */ private function sort(DataTable $table, $functionCallback) { $table->setTableSortedBy($this->columnToSort); $rows = $table->getRowsWithoutSummaryRow(); // get column value and label only once for performance tweak $values = array(); if ($functionCallback === 'numberSort') { foreach ($rows as $key => $row) { $values[$key] = array($this->getColumnValue($row), $row->getColumn('label')); } } else { foreach ($rows as $key => $row) { $values[$key] = $this->getColumnValue($row); } } uasort($values, array($this, $functionCallback)); $sortedRows = array(); foreach ($values as $key => $value) { $sortedRows[] = $rows[$key]; } $table->setRows($sortedRows); unset($rows); unset($sortedRows); if ($table->isSortRecursiveEnabled()) { foreach ($table->getRowsWithoutSummaryRow() as $row) { $subTable = $row->getSubtable(); if ($subTable) { $subTable->enableRecursiveSort(); $this->sort($subTable, $functionCallback); } } } }