You are here

CSVExporter.php in Loft Data Grids 7.2

File

vendor/aklump/loft_data_grids/src/AKlump/LoftDataGrids/CSVExporter.php
View source
<?php

namespace AKlump\LoftDataGrids;


/**
 * Class CSVExporter
 */
class CSVExporter extends Exporter implements ExporterInterface {
  protected $extension = '.csv';
  protected $format;
  protected $page = null;

  /**
   * Constructor
   */
  public function __construct(ExportDataInterface $data = null, $filename = '') {
    parent::__construct($data, $filename);
    $this->format = new \stdClass();
    $this->format->bol = '';
    $this->format->eol = "\r\n";
    $this->format->left = '"';
    $this->format->right = '"';
    $this->format->sep = ',';
    $this->format->escape = '"';
    $this->format->html = false;
  }
  public function getInfo() {
    $info = parent::getInfo();
    $info = array(
      'name' => 'Comma-separated Values Format',
      'shortname' => 'CSV',
      'description' => 'Export data in the .csv file format.  Fields are wrapped with double quotes, separated by commas.  Lines are separated by \\r\\n',
    ) + $info;
    return $info;
  }
  public function compile($page_id = null) {
    $pages = $this
      ->getData()
      ->get();
    if ($page_id === null && count($pages) > 1 || !array_key_exists($page_id, $pages)) {
      reset($pages);
      $page_id = key($pages);
    }
    $data = $this
      ->getData()
      ->getPage($page_id);
    $this->output = '';
    $this->output .= $this
      ->collapseRow($this
      ->getHeader($page_id));

    // Format the rows:
    foreach ($data as $row) {
      $this->output .= $this
        ->collapseRow($row);
    }
    return $this;
  }

  /**
   * Collapse a row
   */
  protected function collapseRow($row) {
    $output = '';

    // Check if we're dealing with a simple or complex row
    if (isset($row['data'])) {
      foreach ($row as $key => $value) {
        if ($key == 'data') {
          $cells = $value;
        }
      }
    }
    else {
      $cells = $row;
    }
    $output = array();
    if (count($cells)) {
      foreach ($cells as $column => $cell) {
        $output[] = $this
          ->collapseCell($cell, $column);
      }
    }
    $output = $this->format->bol . implode($this->format->sep, $output) . $this->format->eol;
    return $output;
  }

  /**
   * Collapse a single cell in a row.
   *
   * @param  array $cell
   *
   * @return string
   */
  protected function collapseCell($cell, $column) {

    //compress a complex cell
    if (is_array($cell)) {
      $cell = isset($cell['data']) ? $cell['data'] : '';
    }
    if (!$this->format->html) {
      $cell = strip_tags($cell);
    }

    // Escape chars that conflice with delimiters
    if (!empty($this->format->escape)) {
      $escapeables = array(
        $this->format->left,
        $this->format->right,
      );
      $escapeables = array_filter(array_unique($escapeables));
      foreach ($escapeables as $find) {
        $cell = str_replace($find, $this->format->escape . $find, $cell);
      }
    }
    return $this->format->left . $cell . $this->format->right;
  }

}

Classes

Namesort descending Description
CSVExporter Class CSVExporter