ColumnTest.php

Go to the documentation of this file.

<?php


class AutofilterColumnTest extends PHPUnit_Framework_TestCase
{
        private $_testInitialColumn = 'H';

        private $_testAutoFilterColumnObject;

        private $_mockAutoFilterObject;

    public function setUp()
    {
        if (!defined('PHPEXCEL_ROOT')) {
            define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
        }
        require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');

        $this->_mockAutoFilterObject = $this->getMockBuilder('PHPExcel_Worksheet_AutoFilter')
                ->disableOriginalConstructor()
                ->getMock();

        $this->_mockAutoFilterObject->expects($this->any())
                ->method('testColumnInRange')
                ->will($this->returnValue(3));

                $this->_testAutoFilterColumnObject = new PHPExcel_Worksheet_AutoFilter_Column(
                        $this->_testInitialColumn,
                        $this->_mockAutoFilterObject
                );
    }

        public function testGetColumnIndex()
        {
                $result = $this->_testAutoFilterColumnObject->getColumnIndex();
                $this->assertEquals($this->_testInitialColumn, $result);
        }

        public function testSetColumnIndex()
        {
                $expectedResult = 'L';

                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterColumnObject->setColumnIndex($expectedResult);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);

                $result = $this->_testAutoFilterColumnObject->getColumnIndex();
                $this->assertEquals($expectedResult, $result);
        }

        public function testGetParent()
        {
                $result = $this->_testAutoFilterColumnObject->getParent();
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);
        }

        public function testSetParent()
        {
                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterColumnObject->setParent($this->_mockAutoFilterObject);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);
        }

        public function testGetFilterType()
        {
                $result = $this->_testAutoFilterColumnObject->getFilterType();
                $this->assertEquals(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_FILTER, $result);
        }

        public function testSetFilterType()
        {
                $result = $this->_testAutoFilterColumnObject->setFilterType(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_DYNAMICFILTER);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);

                $result = $this->_testAutoFilterColumnObject->getFilterType();
                $this->assertEquals(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_FILTERTYPE_DYNAMICFILTER, $result);
        }

        public function testSetInvalidFilterTypeThrowsException()
        {
                $expectedResult = 'Unfiltered';

                $result = $this->_testAutoFilterColumnObject->setFilterType($expectedResult);
        }

        public function testGetJoin()
        {
                $result = $this->_testAutoFilterColumnObject->getJoin();
                $this->assertEquals(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_COLUMN_JOIN_OR, $result);
        }

        public function testSetJoin()
        {
                $result = $this->_testAutoFilterColumnObject->setJoin(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_COLUMN_JOIN_AND);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);

                $result = $this->_testAutoFilterColumnObject->getJoin();
                $this->assertEquals(PHPExcel_Worksheet_AutoFilter_Column::AUTOFILTER_COLUMN_JOIN_AND, $result);
        }

        public function testSetInvalidJoinThrowsException()
        {
                $expectedResult = 'Neither';

                $result = $this->_testAutoFilterColumnObject->setJoin($expectedResult);
        }

        public function testSetAttributes()
        {
                $attributeSet = array(  'val' => 100,
                                                                'maxVal' => 200
                                                         );

                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterColumnObject->setAttributes($attributeSet);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);
        }

        public function testGetAttributes()
        {
                $attributeSet = array(  'val' => 100,
                                                                'maxVal' => 200
                                                         );

                $this->_testAutoFilterColumnObject->setAttributes($attributeSet);

                $result = $this->_testAutoFilterColumnObject->getAttributes();
                $this->assertTrue(is_array($result));
                $this->assertEquals(count($attributeSet), count($result));
        }

        public function testSetAttribute()
        {
                $attributeSet = array(  'val' => 100,
                                                                'maxVal' => 200
                                                         );

                foreach($attributeSet as $attributeName => $attributeValue) {
                        //      Setters return the instance to implement the fluent interface
                        $result = $this->_testAutoFilterColumnObject->setAttribute($attributeName,$attributeValue);
                        $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);
                }
        }

        public function testGetAttribute()
        {
                $attributeSet = array(  'val' => 100,
                                                                'maxVal' => 200
                                                         );

                $this->_testAutoFilterColumnObject->setAttributes($attributeSet);

                foreach($attributeSet as $attributeName => $attributeValue) {
                        $result = $this->_testAutoFilterColumnObject->getAttribute($attributeName);
                        $this->assertEquals($attributeValue, $result);
                }
                $result = $this->_testAutoFilterColumnObject->getAttribute('nonExistentAttribute');
                $this->assertNull($result);
        }

        public function testClone()
        {
                $result = clone $this->_testAutoFilterColumnObject;
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);
        }

}