class XLSExporterTest in Loft Data Grids 7.2

Hierarchy

• class \AKlump\LoftDataGrids\ExporterBase extends \AKlump\LoftDataGrids\PHPUnit_Framework_TestCase
  • class \AKlump\LoftDataGrids\XLSExporterTest

Related topics

Loft Data Grids

@file Base module file for loft_data_grids

Loft Data Grids

@file Base module file for loft_data_grids

File

vendor/aklump/loft_data_grids/tests/phpunit/XLSXExporterTest.php, line 13

Tests for the XLSExporter class

Namespace

AKlump\LoftDataGrids

class XLSExporterTest extends ExporterBase {

  // TODO Do a save then read and compare contents, can't seem how else to test the xml output as it changes each time, probably based on a date or something.
  public function testOutput() {
    $subject = $this->exporter
      ->export();
    $this
      ->assertInstanceOf('PHPExcel', $subject);
    $this
      ->assertMethodSaveFile();
  }
  public function testInfoValues() {
    $info = $this->exporter
      ->getInfo();
    $this
      ->assertSame('.xlsx', $info['extension']);
  }
  function testColumnNumberFormat() {
    $obj = clone $this->exporter2;
    $currency = 'USD';
    $obj
      ->formatColumn('California Taxed Purchase Amount', $currency);
    $obj
      ->formatColumn('Domestic Purchase Amount', $currency);
    $record = $obj
      ->getData()
      ->setPointer(0);
    $data = $record
      ->getCurrent();
    $this
      ->assertSame('$0.00', $data['California Taxed Purchase Amount']);
    $this
      ->assertSame('$20.00', $data['Domestic Purchase Amount']);
    $obj = clone $this->exporter2;
    $currency = '"$"#,##0.00_-';
    $obj
      ->formatColumn('California Taxed Purchase Amount', $currency);
    $obj
      ->formatColumn('Domestic Purchase Amount', $currency);
    $record = $obj
      ->getData()
      ->setPointer(0);
    $data = $record
      ->getCurrent();
    $this
      ->assertSame('$0.00', $data['California Taxed Purchase Amount']);
    $this
      ->assertSame('$20.00', $data['Domestic Purchase Amount']);
  }
  function testGetPHPExcelColumns() {
    $obj = $this->exporter2;
    $subject = array_fill_keys(array_keys($this->records2[0]), null);
    $current = array(
      65,
    );
    $chr =& $current[count($current) - 1];
    foreach (array_keys($subject) as $header_key) {
      $subject[$header_key] = chr($chr++);
    }
    $this
      ->assertSame($subject, $obj
      ->getPHPExcelColumns());

    // @todo this will not test past L; make it really work!
  }
  function testFilename() {
    $this->exporter2
      ->setFilename('alpha.txt');
    $this
      ->assertSame('alpha.xlsx', $this->exporter2
      ->getFilename());
    $this->exporter2
      ->setFilename('bravo.xlsx');
    $this
      ->assertSame('bravo.xlsx', $this->exporter2
      ->getFilename());
    $obj = new XLSXExporter($this->data2, 'omega.php');
    $this
      ->assertSame('omega.xlsx', $obj
      ->getFilename());
  }
  function testExport() {
    $result = $this->exporter2
      ->export();
    $this
      ->assertInstanceOf('PHPExcel', $result);
  }
  function testGetInfo() {
    $info = $this->exporter2
      ->getInfo();
    $this
      ->assertArrayHasKey('name', $info);
    $this
      ->assertArrayHasKey('description', $info);
    $this
      ->assertSame('.xlsx', $info['extension']);
    $this
      ->assertSame('AKlump\\LoftDataGrids\\XLSXExporter', $info['class']);
  }
  function testPropertiesAndTitle() {
    $obj = $this->exporter2;
    $subject = array(
      'Creator' => 'do',
      'LastModifiedBy' => 're',
      'Title' => 'mi',
      'Description' => 'fa',
      'Keywords' => 'so',
      'Category' => 'la',
    );
    $return = $obj
      ->setProperties($subject);
    $this
      ->assertInstanceOf('AKlump\\LoftDataGrids\\XLSXExporter', $return);
    $this
      ->assertNull($obj
      ->getProperty('BreakfastMenu'));
    $this
      ->assertSame('do', $obj
      ->getProperty('Creator'));
    $this
      ->assertSame('re', $obj
      ->getProperty('LastModifiedBy'));
    $this
      ->assertSame('mi', $obj
      ->getProperty('Title'));
    $this
      ->assertSame('fa', $obj
      ->getProperty('Description'));
    $this
      ->assertSame('so', $obj
      ->getProperty('Keywords'));
    $this
      ->assertSame('la', $obj
      ->getProperty('Category'));
    $obj
      ->setTitle('ti');
    $this
      ->assertSame('ti', $obj
      ->getProperty('Title'));
  }
  function testHeaders() {
    $subject = $this->records2[0];
    $return = $this->exporter2
      ->getHeader();
    $this
      ->assertSame(array_combine(array_keys($subject), array_keys($subject)), $return);
  }
  function setUp() {
    $this->data2 = new ExportData();
    $this->records2[0] = array(
      'Order No.' => '1181',
      'Transaction Date' => '11/6/13',
      'Customer Name' => 'Hope, Bob',
      'Customer Billing Address' => '22255 King Street Apt. 1Z',
      'Customer Billing City' => 'Honolulu',
      'Customer Billing State' => 'HI',
      'Customer Billing Zip' => '96813',
      'Customer Billing Country' => 'US',
      'California Taxed Purchase Amount' => 0,
      'Domestic Purchase Amount' => 20,
      'International Purchase Amount' => 0,
      'Order Status' => 'Completed',
    );
    foreach ($this->records2[0] as $key => $value) {
      $this->data2
        ->add($key, $value);
    }
    $this->data2
      ->next();
    $this->exporter2 = new XLSXExporter($this->data2);
    parent::setUp();
    $this->exporter = new XLSXExporter($this->data);
  }

}

Members

Name	Modifiers	Type	Description	Overrides
ExporterBase::assertDateHandlerWorks	public	function
ExporterBase::assertMethodSaveFile	public	function	Make sure that saveFile creates a file and returns the path.
ExporterBase::assertSandboxFileContents	public	function
ExporterBase::assertSandboxFileEquals	public	function	Compare the sandbox file against it's control file.
ExporterBase::tearDown	public	function
ExporterBase::testCompileReturnsSelf	public	function
ExporterBase::testInfo	public	function
ExporterBase::testSaveFileToUnwriteableDirThrows	public	function	@expectedException RuntimeException
XLSExporterTest::setUp		function	Overrides ExporterBase::setUp
XLSExporterTest::testColumnNumberFormat		function
XLSExporterTest::testExport		function
XLSExporterTest::testFilename		function
XLSExporterTest::testGetInfo		function
XLSExporterTest::testGetPHPExcelColumns		function
XLSExporterTest::testHeaders		function
XLSExporterTest::testInfoValues	public	function
XLSExporterTest::testOutput	public	function
XLSExporterTest::testPropertiesAndTitle		function