HEADmaster

1 files changed, 0 insertions, 684 deletions

diff --git a/admin/survey/excel/PHPExcel/Style.php b/admin/survey/excel/PHPExcel/Style.php
deleted file mode 100644
index 269a8cd..0000000
--- a/admin/survey/excel/PHPExcel/Style.php
+++ /dev/null
@@ -1,684 +0,0 @@
-<?php

-/**

- * PHPExcel

- *

- * Copyright (c) 2006 - 2012 PHPExcel

- *

- * This library is free software; you can redistribute it and/or

- * modify it under the terms of the GNU Lesser General Public

- * License as published by the Free Software Foundation; either

- * version 2.1 of the License, or (at your option) any later version.

- *

- * This library is distributed in the hope that it will be useful,

- * but WITHOUT ANY WARRANTY; without even the implied warranty of

- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU

- * Lesser General Public License for more details.

- *

- * You should have received a copy of the GNU Lesser General Public

- * License along with this library; if not, write to the Free Software

- * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA

- *

- * @category   PHPExcel

- * @package    PHPExcel_Style

- * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)

- * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL

- * @version    1.7.8, 2012-10-12

- */

-

-

-/**

- * PHPExcel_Style

- *

- * @category   PHPExcel

- * @package    PHPExcel_Style

- * @copyright  Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)

- */

-class PHPExcel_Style implements PHPExcel_IComparable

-{

-	/**

-	 * Font

-	 *

-	 * @var PHPExcel_Style_Font

-	 */

-	private $_font;

-

-	/**

-	 * Fill

-	 *

-	 * @var PHPExcel_Style_Fill

-	 */

-	private $_fill;

-

-	/**

-	 * Borders

-	 *

-	 * @var PHPExcel_Style_Borders

-	 */

-	private $_borders;

-

-	/**

-	 * Alignment

-	 *

-	 * @var PHPExcel_Style_Alignment

-	 */

-	private $_alignment;

-

-	/**

-	 * Number Format

-	 *

-	 * @var PHPExcel_Style_NumberFormat

-	 */

-	private $_numberFormat;

-

-	/**

-	 * Conditional styles

-	 *

-	 * @var PHPExcel_Style_Conditional[]

-	 */

-	private $_conditionalStyles;

-

-	/**

-	 * Protection

-	 *

-	 * @var PHPExcel_Style_Protection

-	 */

-	private $_protection;

-

-	/**

-	 * Style supervisor?

-	 *

-	 * @var boolean

-	 */

-	private $_isSupervisor;

-

-	/**

-	 * Parent. Only used for style supervisor

-	 *

-	 * @var PHPExcel

-	 */

-	private $_parent;

-

-	/**

-	 * Index of style in collection. Only used for real style.

-	 *

-	 * @var int

-	 */

-	private $_index;

-

-    /**

-     * Create a new PHPExcel_Style

-	 *

-	 * @param	boolean	$isSupervisor	Flag indicating if this is a supervisor or not

-	 *									Leave this value at default unless you understand exactly what

-	 *										its ramifications are

-	 * @param	boolean	$isConditional	Flag indicating if this is a conditional style or not

-	 *									Leave this value at default unless you understand exactly what

-	 *										its ramifications are

-     */

-    public function __construct($isSupervisor = false, $isConditional = false)

-    {

-    	// Supervisor?

-		$this->_isSupervisor = $isSupervisor;

-

-		// Initialise values

-    	$this->_conditionalStyles 	= array();

-		$this->_font				= new PHPExcel_Style_Font($isSupervisor, $isConditional);

-		$this->_fill				= new PHPExcel_Style_Fill($isSupervisor, $isConditional);

-		$this->_borders				= new PHPExcel_Style_Borders($isSupervisor, $isConditional);

-		$this->_alignment			= new PHPExcel_Style_Alignment($isSupervisor, $isConditional);

-		$this->_numberFormat		= new PHPExcel_Style_NumberFormat($isSupervisor, $isConditional);

-		$this->_protection			= new PHPExcel_Style_Protection($isSupervisor, $isConditional);

-

-		// bind parent if we are a supervisor

-		if ($isSupervisor) {

-			$this->_font->bindParent($this);

-			$this->_fill->bindParent($this);

-			$this->_borders->bindParent($this);

-			$this->_alignment->bindParent($this);

-			$this->_numberFormat->bindParent($this);

-			$this->_protection->bindParent($this);

-		}

-    }

-

-	/**

-	 * Bind parent. Only used for supervisor

-	 *

-	 * @param PHPExcel $parent

-	 * @return PHPExcel_Style

-	 */

-	public function bindParent($parent)

-	{

-		$this->_parent = $parent;

-		return $this;

-	}

-

-	/**

-	 * Is this a supervisor or a real style component?

-	 *

-	 * @return boolean

-	 */

-	public function getIsSupervisor()

-	{

-		return $this->_isSupervisor;

-	}

-

-	/**

-	 * Get the shared style component for the currently active cell in currently active sheet.

-	 * Only used for style supervisor

-	 *

-	 * @return PHPExcel_Style

-	 */

-	public function getSharedComponent()

-	{

-		$activeSheet = $this->getActiveSheet();

-		$selectedCell = $this->getActiveCell(); // e.g. 'A1'

-

-		if ($activeSheet->cellExists($selectedCell)) {

-			$xfIndex = $activeSheet->getCell($selectedCell)->getXfIndex();

-		} else {

-			$xfIndex = 0;

-		}

-

-		return $this->_parent->getCellXfByIndex($xfIndex);

-	}

-

-	/**

-	 * Get the currently active sheet. Only used for supervisor

-	 *

-	 * @return PHPExcel_Worksheet

-	 */

-	public function getActiveSheet()

-	{

-		return $this->_parent->getActiveSheet();

-	}

-

-	/**

-	 * Get the currently active cell coordinate in currently active sheet.

-	 * Only used for supervisor

-	 *

-	 * @return string E.g. 'A1'

-	 */

-	public function getSelectedCells()

-	{

-		return $this->_parent->getActiveSheet()->getSelectedCells();

-	}

-

-	/**

-	 * Get the currently active cell coordinate in currently active sheet.

-	 * Only used for supervisor

-	 *

-	 * @return string E.g. 'A1'

-	 */

-	public function getActiveCell()

-	{

-		return $this->_parent->getActiveSheet()->getActiveCell();

-	}

-

-	/**

-	 * Get parent. Only used for style supervisor

-	 *

-	 * @return PHPExcel

-	 */

-	public function getParent()

-	{

-		return $this->_parent;

-	}

-

-    /**

-     * Apply styles from array

-     *

-     * <code>

-     * $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray(

-     * 		array(

-     * 			'font'    => array(

-     * 				'name'      => 'Arial',

-     * 				'bold'      => true,

-     * 				'italic'    => false,

-     * 				'underline' => PHPExcel_Style_Font::UNDERLINE_DOUBLE,

-     * 				'strike'    => false,

-     * 				'color'     => array(

-     * 					'rgb' => '808080'

-     * 				)

-     * 			),

-     * 			'borders' => array(

-     * 				'bottom'     => array(

-     * 					'style' => PHPExcel_Style_Border::BORDER_DASHDOT,

-     * 					'color' => array(

-     * 						'rgb' => '808080'

-     * 					)

-     * 				),

-     * 				'top'     => array(

-     * 					'style' => PHPExcel_Style_Border::BORDER_DASHDOT,

-     * 					'color' => array(

-     * 						'rgb' => '808080'

-     * 					)

-     * 				)

-     * 			)

-     * 		)

-     * );

-     * </code>

-     *

-     * @param	array	$pStyles	Array containing style information

-     * @param 	boolean		$pAdvanced	Advanced mode for setting borders.

-     * @throws	Exception

-     * @return PHPExcel_Style

-     */

-	public function applyFromArray($pStyles = null, $pAdvanced = true) {

-		if (is_array($pStyles)) {

-			if ($this->_isSupervisor) {

-

-				$pRange = $this->getSelectedCells();

-

-				// Uppercase coordinate

-				$pRange = strtoupper($pRange);

-

-				// Is it a cell range or a single cell?

-				if (strpos($pRange, ':') === false) {

-					$rangeA = $pRange;

-					$rangeB = $pRange;

-				} else {

-					list($rangeA, $rangeB) = explode(':', $pRange);

-				}

-

-				// Calculate range outer borders

-				$rangeStart = PHPExcel_Cell::coordinateFromString($rangeA);

-				$rangeEnd 	= PHPExcel_Cell::coordinateFromString($rangeB);

-

-				// Translate column into index

-				$rangeStart[0]	= PHPExcel_Cell::columnIndexFromString($rangeStart[0]) - 1;

-				$rangeEnd[0]	= PHPExcel_Cell::columnIndexFromString($rangeEnd[0]) - 1;

-

-				// Make sure we can loop upwards on rows and columns

-				if ($rangeStart[0] > $rangeEnd[0] && $rangeStart[1] > $rangeEnd[1]) {

-					$tmp = $rangeStart;

-					$rangeStart = $rangeEnd;

-					$rangeEnd = $tmp;

-				}

-

-				// ADVANCED MODE:

-

-				if ($pAdvanced && isset($pStyles['borders'])) {

-

-					// 'allborders' is a shorthand property for 'outline' and 'inside' and

-					//		it applies to components that have not been set explicitly

-					if (isset($pStyles['borders']['allborders'])) {

-						foreach (array('outline', 'inside') as $component) {

-							if (!isset($pStyles['borders'][$component])) {

-								$pStyles['borders'][$component] = $pStyles['borders']['allborders'];

-							}

-						}

-						unset($pStyles['borders']['allborders']); // not needed any more

-					}

-

-					// 'outline' is a shorthand property for 'top', 'right', 'bottom', 'left'

-					//		it applies to components that have not been set explicitly

-					if (isset($pStyles['borders']['outline'])) {

-						foreach (array('top', 'right', 'bottom', 'left') as $component) {

-							if (!isset($pStyles['borders'][$component])) {

-								$pStyles['borders'][$component] = $pStyles['borders']['outline'];

-							}

-						}

-						unset($pStyles['borders']['outline']); // not needed any more

-					}

-

-					// 'inside' is a shorthand property for 'vertical' and 'horizontal'

-					//		it applies to components that have not been set explicitly

-					if (isset($pStyles['borders']['inside'])) {

-						foreach (array('vertical', 'horizontal') as $component) {

-							if (!isset($pStyles['borders'][$component])) {

-								$pStyles['borders'][$component] = $pStyles['borders']['inside'];

-							}

-						}

-						unset($pStyles['borders']['inside']); // not needed any more

-					}

-

-					// width and height characteristics of selection, 1, 2, or 3 (for 3 or more)

-					$xMax = min($rangeEnd[0] - $rangeStart[0] + 1, 3);

-					$yMax = min($rangeEnd[1] - $rangeStart[1] + 1, 3);

-

-					// loop through up to 3 x 3 = 9 regions

-					for ($x = 1; $x <= $xMax; ++$x) {

-						// start column index for region

-						$colStart = ($x == 3) ?

-							PHPExcel_Cell::stringFromColumnIndex($rangeEnd[0])

-								: PHPExcel_Cell::stringFromColumnIndex($rangeStart[0] + $x - 1);

-

-						// end column index for region

-						$colEnd = ($x == 1) ?

-							PHPExcel_Cell::stringFromColumnIndex($rangeStart[0])

-								: PHPExcel_Cell::stringFromColumnIndex($rangeEnd[0] - $xMax + $x);

-

-						for ($y = 1; $y <= $yMax; ++$y) {

-

-							// which edges are touching the region

-							$edges = array();

-

-							// are we at left edge

-							if ($x == 1) {

-								$edges[] = 'left';

-							}

-

-							// are we at right edge

-							if ($x == $xMax) {

-								$edges[] = 'right';

-							}

-

-							// are we at top edge?

-							if ($y == 1) {

-								$edges[] = 'top';

-							}

-

-							// are we at bottom edge?

-							if ($y == $yMax) {

-								$edges[] = 'bottom';

-							}

-

-							// start row index for region

-							$rowStart = ($y == 3) ?

-								$rangeEnd[1] : $rangeStart[1] + $y - 1;

-

-							// end row index for region

-							$rowEnd = ($y == 1) ?

-								$rangeStart[1] : $rangeEnd[1] - $yMax + $y;

-

-							// build range for region

-							$range = $colStart . $rowStart . ':' . $colEnd . $rowEnd;

-

-							// retrieve relevant style array for region

-							$regionStyles = $pStyles;

-							unset($regionStyles['borders']['inside']);

-

-							// what are the inner edges of the region when looking at the selection

-							$innerEdges = array_diff( array('top', 'right', 'bottom', 'left'), $edges );

-

-							// inner edges that are not touching the region should take the 'inside' border properties if they have been set

-							foreach ($innerEdges as $innerEdge) {

-								switch ($innerEdge) {

-									case 'top':

-									case 'bottom':

-										// should pick up 'horizontal' border property if set

-										if (isset($pStyles['borders']['horizontal'])) {

-											$regionStyles['borders'][$innerEdge] = $pStyles['borders']['horizontal'];

-										} else {

-											unset($regionStyles['borders'][$innerEdge]);

-										}

-										break;

-									case 'left':

-									case 'right':

-										// should pick up 'vertical' border property if set

-										if (isset($pStyles['borders']['vertical'])) {

-											$regionStyles['borders'][$innerEdge] = $pStyles['borders']['vertical'];

-										} else {

-											unset($regionStyles['borders'][$innerEdge]);

-										}

-										break;

-								}

-							}

-

-							// apply region style to region by calling applyFromArray() in simple mode

-							$this->getActiveSheet()->getStyle($range)->applyFromArray($regionStyles, false);

-						}

-					}

-					return $this;

-				}

-

-				// SIMPLE MODE:

-

-				// Selection type, inspect

-				if (preg_match('/^[A-Z]+1:[A-Z]+1048576$/', $pRange)) {

-					$selectionType = 'COLUMN';

-				} else if (preg_match('/^A[0-9]+:XFD[0-9]+$/', $pRange)) {

-					$selectionType = 'ROW';

-				} else {

-					$selectionType = 'CELL';

-				}

-

-				// First loop through columns, rows, or cells to find out which styles are affected by this operation

-				switch ($selectionType) {

-					case 'COLUMN':

-						$oldXfIndexes = array();

-						for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {

-							$oldXfIndexes[$this->getActiveSheet()->getColumnDimensionByColumn($col)->getXfIndex()] = true;

-						}

-						break;

-

-					case 'ROW':

-						$oldXfIndexes = array();

-						for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {

-							if ($this->getActiveSheet()->getRowDimension($row)->getXfIndex() == null) {

-								$oldXfIndexes[0] = true; // row without explicit style should be formatted based on default style

-							} else {

-								$oldXfIndexes[$this->getActiveSheet()->getRowDimension($row)->getXfIndex()] = true;

-							}

-						}

-						break;

-

-					case 'CELL':

-						$oldXfIndexes = array();

-						for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {

-							for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {

-								$oldXfIndexes[$this->getActiveSheet()->getCellByColumnAndRow($col, $row)->getXfIndex()] = true;

-							}

-						}

-						break;

-				}

-

-				// clone each of the affected styles, apply the style arrray, and add the new styles to the workbook

-				$workbook = $this->getActiveSheet()->getParent();

-				foreach ($oldXfIndexes as $oldXfIndex => $dummy) {

-					$style = $workbook->getCellXfByIndex($oldXfIndex);

-					$newStyle = clone $style;

-					$newStyle->applyFromArray($pStyles);

-

-					if ($existingStyle = $workbook->getCellXfByHashCode($newStyle->getHashCode())) {

-						// there is already such cell Xf in our collection

-						$newXfIndexes[$oldXfIndex] = $existingStyle->getIndex();

-					} else {

-						// we don't have such a cell Xf, need to add

-						$workbook->addCellXf($newStyle);

-						$newXfIndexes[$oldXfIndex] = $newStyle->getIndex();

-					}

-				}

-

-				// Loop through columns, rows, or cells again and update the XF index

-				switch ($selectionType) {

-					case 'COLUMN':

-						for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {

-							$columnDimension = $this->getActiveSheet()->getColumnDimensionByColumn($col);

-							$oldXfIndex = $columnDimension->getXfIndex();

-							$columnDimension->setXfIndex($newXfIndexes[$oldXfIndex]);

-						}

-						break;

-

-					case 'ROW':

-						for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {

-							$rowDimension = $this->getActiveSheet()->getRowDimension($row);

-							$oldXfIndex = $rowDimension->getXfIndex() === null ?

-								0 : $rowDimension->getXfIndex(); // row without explicit style should be formatted based on default style

-							$rowDimension->setXfIndex($newXfIndexes[$oldXfIndex]);

-						}

-						break;

-

-					case 'CELL':

-						for ($col = $rangeStart[0]; $col <= $rangeEnd[0]; ++$col) {

-							for ($row = $rangeStart[1]; $row <= $rangeEnd[1]; ++$row) {

-								$cell = $this->getActiveSheet()->getCellByColumnAndRow($col, $row);

-								$oldXfIndex = $cell->getXfIndex();

-								$cell->setXfIndex($newXfIndexes[$oldXfIndex]);

-							}

-						}

-						break;

-				}

-

-			} else {

-				// not a supervisor, just apply the style array directly on style object

-				if (array_key_exists('fill', $pStyles)) {

-					$this->getFill()->applyFromArray($pStyles['fill']);

-				}

-				if (array_key_exists('font', $pStyles)) {

-					$this->getFont()->applyFromArray($pStyles['font']);

-				}

-				if (array_key_exists('borders', $pStyles)) {

-					$this->getBorders()->applyFromArray($pStyles['borders']);

-				}

-				if (array_key_exists('alignment', $pStyles)) {

-					$this->getAlignment()->applyFromArray($pStyles['alignment']);

-				}

-				if (array_key_exists('numberformat', $pStyles)) {

-					$this->getNumberFormat()->applyFromArray($pStyles['numberformat']);

-				}

-				if (array_key_exists('protection', $pStyles)) {

-					$this->getProtection()->applyFromArray($pStyles['protection']);

-				}

-			}

-		} else {

-			throw new Exception("Invalid style array passed.");

-		}

-		return $this;

-	}

-

-    /**

-     * Get Fill

-     *

-     * @return PHPExcel_Style_Fill

-     */

-    public function getFill() {

-		return $this->_fill;

-    }

-

-    /**

-     * Get Font

-     *

-     * @return PHPExcel_Style_Font

-     */

-    public function getFont() {

-		return $this->_font;

-    }

-

-	/**

-	 * Set font

-	 *

-	 * @param PHPExcel_Style_Font $font

-	 * @return PHPExcel_Style

-	 */

-	public function setFont(PHPExcel_Style_Font $font)

-	{

-		$this->_font = $font;

-		return $this;

-	}

-

-    /**

-     * Get Borders

-     *

-     * @return PHPExcel_Style_Borders

-     */

-    public function getBorders() {

-		return $this->_borders;

-    }

-

-    /**

-     * Get Alignment

-     *

-     * @return PHPExcel_Style_Alignment

-     */

-    public function getAlignment() {

-		return $this->_alignment;

-    }

-

-    /**

-     * Get Number Format

-     *

-     * @return PHPExcel_Style_NumberFormat

-     */

-    public function getNumberFormat() {

-		return $this->_numberFormat;

-    }

-

-    /**

-     * Get Conditional Styles. Only used on supervisor.

-     *

-     * @return PHPExcel_Style_Conditional[]

-     */

-    public function getConditionalStyles() {

-		return $this->getActiveSheet()->getConditionalStyles($this->getActiveCell());

-    }

-

-    /**

-     * Set Conditional Styles. Only used on supervisor.

-     *

-     * @param PHPExcel_Style_Conditional[]	$pValue	Array of condtional styles

-     * @return PHPExcel_Style

-     */

-    public function setConditionalStyles($pValue = null) {

-		if (is_array($pValue)) {

-			$this->getActiveSheet()->setConditionalStyles($this->getSelectedCells(), $pValue);

-		}

-		return $this;

-    }

-

-    /**

-     * Get Protection

-     *

-     * @return PHPExcel_Style_Protection

-     */

-    public function getProtection() {

-		return $this->_protection;

-    }

-

-	/**

-	 * Get hash code

-	 *

-	 * @return string	Hash code

-	 */

-	public function getHashCode() {

-		$hashConditionals = '';

-		foreach ($this->_conditionalStyles as $conditional) {

-			$hashConditionals .= $conditional->getHashCode();

-		}

-

-    	return md5(

-    		  $this->_fill->getHashCode()

-    		. $this->_font->getHashCode()

-    		. $this->_borders->getHashCode()

-    		. $this->_alignment->getHashCode()

-    		. $this->_numberFormat->getHashCode()

-    		. $hashConditionals

-    		. $this->_protection->getHashCode()

-    		. __CLASS__

-    	);

-    }

-

-	/**

-	 * Get own index in style collection

-	 *

-	 * @return int

-	 */

-	public function getIndex()

-	{

-		return $this->_index;

-	}

-

-	/**

-	 * Set own index in style collection

-	 *

-	 * @param int $pValue

-	 */

-	public function setIndex($pValue)

-	{

-		$this->_index = $pValue;

-	}

-

-	/**

-	 * Implement PHP __clone to create a deep clone, not just a shallow copy.

-	 */

-	public function __clone() {

-		$vars = get_object_vars($this);

-		foreach ($vars as $key => $value) {

-			if ((is_object($value)) && ($key != '_parent')) {

-				$this->$key = clone $value;

-			} else {

-				$this->$key = $value;

-			}

-		}

-	}

-}