Пример #1
0
 public function testRemoveColumn()
 {
     $statsTable = new StatsTable(array(array('a' => 'a', 'b' => 'b'), array('a' => 'A', 'b' => 'B')), array('a' => 'Alpha', 'b' => 'Bravo'));
     $statsTable->removeColumn('b');
     $this->assertEquals(array('a' => 'Alpha'), $statsTable->getHeaders());
     $this->assertEquals(array(array('a' => 'a'), array('a' => 'A')), $statsTable->getData());
 }
Пример #2
0
 /**
  * Dump Data
  * @param StatsTable $statsTable
  * @return string
  */
 public function dump(StatsTable $statsTable)
 {
     $result = array('data' => $statsTable->getData());
     if ($this->enableHeaders) {
         $result['headers'] = $statsTable->getHeaders();
     }
     if ($this->enableAggregation) {
         $result['aggregations'] = $statsTable->getAggregations();
         $result['aggregationsFormats'] = $statsTable->getAggregationsFormats();
     }
     $result['formats'] = $statsTable->getDataFormats();
     // Format value for each line of dataset
     foreach ($result['data'] as &$line) {
         foreach ($line as $id => &$val) {
             if (array_key_exists($id, $result['formats'])) {
                 $val = $this->formatValue($result['formats'][$id], $val);
             }
         }
     }
     // Format value for each value of aggregations
     foreach ($result['aggregations'] as $id => &$val) {
         if (array_key_exists($id, $result['aggregationsFormats'])) {
             $val = $this->formatValue($result['aggregationsFormats'][$id], $val);
         }
     }
     return json_encode($result);
 }
Пример #3
0
 public function dump(StatsTable $statsTable)
 {
     $data = $statsTable->getData();
     $format = $statsTable->getDataFormats();
     $aggregations = $statsTable->getAggregations();
     $aggregationsFormats = $statsTable->getAggregationsFormats();
     $metaData = $statsTable->getMetaData();
     $data = $this->formatData($data, $format);
     $aggregations = $this->formatLine($aggregations, $aggregationsFormats);
     $params = array('headers' => $statsTable->getHeaders(), 'data' => $data, 'aggregations' => $aggregations, 'metaData' => $metaData);
     $params = array_merge($params, $this->templateOptions);
     return $this->twig->render($this->template, $params);
 }
Пример #4
0
 public function dump(StatsTable $statsTable)
 {
     $fileHandler = fopen('php://temp', 'w');
     if ($this->enableHeaders) {
         $this->writeLine($fileHandler, $statsTable->getHeaders());
     }
     foreach ($statsTable->getData() as $line) {
         $this->writeLine($fileHandler, $line, $statsTable->getDataFormats());
     }
     if ($this->enableAggregation) {
         $this->writeLine($fileHandler, $statsTable->getAggregations(), $statsTable->getAggregationsFormats());
     }
     $len = ftell($fileHandler);
     fseek($fileHandler, 0, SEEK_SET);
     return fread($fileHandler, $len);
 }
Пример #5
0
 /**
  * Dumps the stats table
  * @param  StatsTable $statsTable
  * @return string
  */
 public function dump(StatsTable $statsTable)
 {
     $excel = new \PHPExcel();
     $excel->getDefaultStyle()->applyFromArray($this->getDefaultStyleArray());
     $sheet = $excel->getSheet();
     $row = 1;
     $data = $statsTable->getData();
     $width = count(reset($data));
     // HEADERS //
     if ($this->enableHeaders) {
         $headerStyle = new \PHPExcel_Style();
         $headerStyle->applyFromArray($this->getHeadersStyleArray());
         $col = 0;
         foreach ($statsTable->getHeaders() as $header) {
             $sheet->setCellValueByColumnAndRow($col, $row, $header);
             $col++;
         }
         $sheet->duplicateStyle($headerStyle, 'A1:' . \PHPExcel_Cell::stringFromColumnIndex($width - 1) . '1');
         $row++;
     }
     // DATA //
     foreach ($statsTable->getData() as $data) {
         $this->applyValues($sheet, $row, $data, $statsTable->getDataFormats());
         $row++;
     }
     // AGGREGATIONS //
     if ($this->enableAggregation) {
         $this->applyValues($sheet, $row, $statsTable->getAggregations(), $statsTable->getAggregationsFormats(), $this->getAggregationsStyleArray());
     }
     // FINAL FORMATTING //
     for ($col = 0; $col < $width; $col++) {
         $sheet->getColumnDimension(\PHPExcel_Cell::stringFromColumnIndex($col))->setAutoSize(true);
     }
     $xlsDumper = new \PHPExcel_Writer_Excel2007($excel);
     $pFilename = @tempnam(\PHPExcel_Shared_File::sys_get_temp_dir(), 'phpxltmp');
     $xlsDumper->save($pFilename);
     $contents = file_get_contents($pFilename);
     @unlink($pFilename);
     unset($excel);
     unset($xlsDumper);
     return $contents;
 }