Admingenerator\GeneratorBundle\Builder\Admin\ExcelBuilder

Complexity

Total Complexity

22

Size/Duplication

Total Lines	96
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getYamlKey()	0	4	1
A	getFileName()	0	6	2
A	getFileType()	0	11	3
A	getDateTimeFormat()	0	6	2
A	getExport()	0	9	2
B	fillExport()	0	20	6
A	setUserExcelColumnConfiguration()	0	11	5
A	getExportCredentials()	0	4	1

<?php

namespace Admingenerator\GeneratorBundle\Builder\Admin;

use Admingenerator\GeneratorBundle\Generator\Column;

/**
 * This builder generates php for list actions
 *
 * @author cedric Lombardot
 * @author Piotr Gołębiewski <loostro@gmail.com>
 * @author Bob van de Vijver
 */
class ExcelBuilder extends ListBuilder
{
  /**
   * @var array
   */
  protected $export = null;

  /**
   * (non-PHPdoc)
   * @see Admingenerator\GeneratorBundle\Builder.BaseBuilder::getYamlKey()
   */
  public function getYamlKey()
  {
    return 'excel';
  }

  public function getFileName($key = null){
    if(null === ($filename = $this->getVariable('filename'))){
      $filename = 'admin_export_'. str_replace(' ', '_', strtolower($this->getGenerator()->getFromYaml('builders.list.params.title'))). '.xlsx';
    }
    return $this->getExportParamsForKey($key, 'filename', $filename);
  }

  public function getFileType($key = null){
    if(null === ($filetype = $this->getVariable('filetype'))){
      if(class_exists('\PhpOffice\PhpSpreadsheet\Spreadsheet'))
      {
        $filetype = 'Xlsx';
      } else {
        $filetype = 'Excel2007';
      }
    }
    return $this->getExportParamsForKey($key, 'filetype', $filetype);
  }

  public function getDateTimeFormat($key = null){
    if(null === ($dateTimeFormat = $this->getVariable('datetime_format'))){
      $dateTimeFormat = 'Y-m-d H:i:s';
    }
    return $this->getExportParamsForKey($key, 'datetime_format', $dateTimeFormat);
  }

  /**
   * Return a list of columns from excel.export
   * 
   * @return array
   */
  public function getExport()
  {
      if (null === $this->export) {
          $this->export = array();
          $this->fillExport();
      }

      return $this->export;
  }

  protected function fillExport()
  {
      $export = $this->getVariable('export',[]);
      if (!count($export)) return [];

      foreach ($export as $keyName => $columns ) {
          $params = [];
          $this->export[$keyName] = []; 
          if (isset($columns['display'])) {
              $params = isset($columns['fields']) ? $columns['fields'] : [];
              $columns = $columns['display'];
          } 
          foreach ($columns as $columnName) {
              $column = $this->createColumn($columnName, false);
              $this->setUserColumnConfiguration($column);              
              $this->setUserExcelColumnConfiguration($column, $params);              
              $this->export[$keyName][$columnName] = $column;
          }
      }
  }

  protected function setUserExcelColumnConfiguration(Column $column, array $optionsFields)
  {
      if (!count($optionsFields)) return;

      $options = is_array($optionsFields) && array_key_exists($column->getName(), $optionsFields) ?
          $optionsFields[$column->getName()] : array();

      foreach ($options as $option => $value) {
          $column->setProperty($option, $value);
      }
  }

  public function getExportCredentials($key = null)
  {
    return $this->getExportParamsForKey($key, 'credentials', null);
  }

}