审查视图

simplewind/vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/ReferenceHelperTest.php 1.3 KB
xiaohu authored
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
<?php


class ReferenceHelperTest extends PHPUnit_Framework_TestCase
{

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

	public function testColumnSort()
	{
		$columnBase = $columnExpectedResult = array(
			'A','B','Z',
			'AA','AB','AZ',
			'BA','BB','BZ',
			'ZA','ZB','ZZ',
			'AAA','AAB','AAZ',
			'ABA','ABB','ABZ',
			'AZA','AZB','AZZ',
			'BAA','BAB','BAZ',
			'BBA','BBB','BBZ',
			'BZA','BZB','BZZ'
		);
		shuffle($columnBase);
		usort($columnBase, array('PHPExcel_ReferenceHelper','columnSort'));
		foreach($columnBase as $key => $value) {
			$this->assertEquals($columnExpectedResult[$key], $value);
		}
	}

	public function testColumnReverseSort()
	{
		$columnBase = $columnExpectedResult = array(
			'A','B','Z',
			'AA','AB','AZ',
			'BA','BB','BZ',
			'ZA','ZB','ZZ',
			'AAA','AAB','AAZ',
			'ABA','ABB','ABZ',
			'AZA','AZB','AZZ',
			'BAA','BAB','BAZ',
			'BBA','BBB','BBZ',
			'BZA','BZB','BZZ'
		);
		shuffle($columnBase);
		$columnExpectedResult = array_reverse($columnExpectedResult);
		usort($columnBase, array('PHPExcel_ReferenceHelper','columnReverseSort'));
		foreach($columnBase as $key => $value) {
			$this->assertEquals($columnExpectedResult[$key], $value);
		}
	}

}