_isSupervisor = $isSupervisor; // Initialise values $this->_startColor = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_WHITE, $isSupervisor); $this->_endColor = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK, $isSupervisor); // bind parent if we are a supervisor if ($isSupervisor) { $this->_startColor->bindParent($this, '_startColor'); $this->_endColor->bindParent($this, '_endColor'); } } /** * Bind parent. Only used for supervisor * * @param PHPExcel_Style $parent * @return PHPExcel_Style_Fill */ 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_Fill */ public function getSharedComponent() { return $this->_parent->getSharedComponent()->getFill(); } /** * 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->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->getActiveSheet()->getActiveCell(); } /** * Build style array from subcomponents * * @param array $array * @return array */ public function getStyleArray($array) { return array('fill' => $array); } /** * Apply styles from array * * * $objPHPExcel->getActiveSheet()->getStyle('B2')->getFill()->applyFromArray( * array( * 'type' => PHPExcel_Style_Fill::FILL_GRADIENT_LINEAR, * 'rotation' => 0, * 'startcolor' => array( * 'rgb' => '000000' * ), * 'endcolor' => array( * 'argb' => 'FFFFFFFF' * ) * ) * ); * * * @param array $pStyles Array containing style information * @throws Exception * @return PHPExcel_Style_Fill */ public function applyFromArray($pStyles = null) { if (is_array($pStyles)) { if ($this->_isSupervisor) { $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles)); } else { if (array_key_exists('type', $pStyles)) { $this->setFillType($pStyles['type']); } if (array_key_exists('rotation', $pStyles)) { $this->setRotation($pStyles['rotation']); } if (array_key_exists('startcolor', $pStyles)) { $this->getStartColor()->applyFromArray($pStyles['startcolor']); } if (array_key_exists('endcolor', $pStyles)) { $this->getEndColor()->applyFromArray($pStyles['endcolor']); } if (array_key_exists('color', $pStyles)) { $this->getStartColor()->applyFromArray($pStyles['color']); } } } else { throw new Exception("Invalid style array passed."); } return $this; } /** * Get Fill Type * * @return string */ public function getFillType() { if ($this->_isSupervisor) { return $this->getSharedComponent()->getFillType(); } return $this->_fillType; } /** * Set Fill Type * * @param string $pValue PHPExcel_Style_Fill fill type * @return PHPExcel_Style_Fill */ public function setFillType($pValue = PHPExcel_Style_Fill::FILL_NONE) { if ($this->_isSupervisor) { $styleArray = $this->getStyleArray(array('type' => $pValue)); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->_fillType = $pValue; } return $this; } /** * Get Rotation * * @return double */ public function getRotation() { if ($this->_isSupervisor) { return $this->getSharedComponent()->getRotation(); } return $this->_rotation; } /** * Set Rotation * * @param double $pValue * @return PHPExcel_Style_Fill */ public function setRotation($pValue = 0) { if ($this->_isSupervisor) { $styleArray = $this->getStyleArray(array('rotation' => $pValue)); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->_rotation = $pValue; } return $this; } /** * Get Start Color * * @return PHPExcel_Style_Color */ public function getStartColor() { return $this->_startColor; } /** * Set Start Color * * @param PHPExcel_Style_Color $pValue * @throws Exception * @return PHPExcel_Style_Fill */ public function setStartColor(PHPExcel_Style_Color $pValue = null) { // make sure parameter is a real color and not a supervisor $color = $pValue->getIsSupervisor() ? $pValue->getSharedComponent() : $pValue; if ($this->_isSupervisor) { $styleArray = $this->getStartColor()->getStyleArray(array('argb' => $color->getARGB())); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->_startColor = $color; } return $this; } /** * Get End Color * * @return PHPExcel_Style_Color */ public function getEndColor() { return $this->_endColor; } /** * Set End Color * * @param PHPExcel_Style_Color $pValue * @throws Exception * @return PHPExcel_Style_Fill */ public function setEndColor(PHPExcel_Style_Color $pValue = null) { // make sure parameter is a real color and not a supervisor $color = $pValue->getIsSupervisor() ? $pValue->getSharedComponent() : $pValue; if ($this->_isSupervisor) { $styleArray = $this->getEndColor()->getStyleArray(array('argb' => $color->getARGB())); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->_endColor = $color; } return $this; } /** * Get hash code * * @return string Hash code */ public function getHashCode() { if ($this->_isSupervisor) { return $this->getSharedComponent()->getHashCode(); } return md5( $this->getFillType() . $this->getRotation() . $this->getStartColor()->getHashCode() . $this->getEndColor()->getHashCode() . __CLASS__ ); } /** * 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; } } } }