PHP DataTable::setTableSortedBy方法代码示例

 /**
  * 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);
             }
         }
     }
 }