You are here

Home » API reference » Loft Data Grids 7.2 » Borders.php

class PHPExcel_Style_Borders in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Style/Borders.php \PHPExcel_Style_Borders

PHPExcel_Style_Borders

@category PHPExcel @package PHPExcel_Style @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

Hierarchy

Expanded class hierarchy of PHPExcel_Style_Borders

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Style/Borders.php, line 36

View source 
class PHPExcel_Style_Borders extends PHPExcel_Style_Supervisor implements PHPExcel_IComparable {

  /* Diagonal directions */
  const DIAGONAL_NONE = 0;
  const DIAGONAL_UP = 1;
  const DIAGONAL_DOWN = 2;
  const DIAGONAL_BOTH = 3;

  /**
   * Left
   *
   * @var PHPExcel_Style_Border
   */
  protected $_left;

  /**
   * Right
   *
   * @var PHPExcel_Style_Border
   */
  protected $_right;

  /**
   * Top
   *
   * @var PHPExcel_Style_Border
   */
  protected $_top;

  /**
   * Bottom
   *
   * @var PHPExcel_Style_Border
   */
  protected $_bottom;

  /**
   * Diagonal
   *
   * @var PHPExcel_Style_Border
   */
  protected $_diagonal;

  /**
   * DiagonalDirection
   *
   * @var int
   */
  protected $_diagonalDirection;

  /**
   * All borders psedo-border. Only applies to supervisor.
   *
   * @var PHPExcel_Style_Border
   */
  protected $_allBorders;

  /**
   * Outline psedo-border. Only applies to supervisor.
   *
   * @var PHPExcel_Style_Border
   */
  protected $_outline;

  /**
   * Inside psedo-border. Only applies to supervisor.
   *
   * @var PHPExcel_Style_Border
   */
  protected $_inside;

  /**
   * Vertical pseudo-border. Only applies to supervisor.
   *
   * @var PHPExcel_Style_Border
   */
  protected $_vertical;

  /**
   * Horizontal pseudo-border. Only applies to supervisor.
   *
   * @var PHPExcel_Style_Border
   */
  protected $_horizontal;

  /**
   * Create a new PHPExcel_Style_Borders
   *
   * @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?
    parent::__construct($isSupervisor);

    // Initialise values
    $this->_left = new PHPExcel_Style_Border($isSupervisor, $isConditional);
    $this->_right = new PHPExcel_Style_Border($isSupervisor, $isConditional);
    $this->_top = new PHPExcel_Style_Border($isSupervisor, $isConditional);
    $this->_bottom = new PHPExcel_Style_Border($isSupervisor, $isConditional);
    $this->_diagonal = new PHPExcel_Style_Border($isSupervisor, $isConditional);
    $this->_diagonalDirection = PHPExcel_Style_Borders::DIAGONAL_NONE;

    // Specially for supervisor
    if ($isSupervisor) {

      // Initialize pseudo-borders
      $this->_allBorders = new PHPExcel_Style_Border(TRUE);
      $this->_outline = new PHPExcel_Style_Border(TRUE);
      $this->_inside = new PHPExcel_Style_Border(TRUE);
      $this->_vertical = new PHPExcel_Style_Border(TRUE);
      $this->_horizontal = new PHPExcel_Style_Border(TRUE);

      // bind parent if we are a supervisor
      $this->_left
        ->bindParent($this, '_left');
      $this->_right
        ->bindParent($this, '_right');
      $this->_top
        ->bindParent($this, '_top');
      $this->_bottom
        ->bindParent($this, '_bottom');
      $this->_diagonal
        ->bindParent($this, '_diagonal');
      $this->_allBorders
        ->bindParent($this, '_allBorders');
      $this->_outline
        ->bindParent($this, '_outline');
      $this->_inside
        ->bindParent($this, '_inside');
      $this->_vertical
        ->bindParent($this, '_vertical');
      $this->_horizontal
        ->bindParent($this, '_horizontal');
    }
  }

  /**
   * Get the shared style component for the currently active cell in currently active sheet.
   * Only used for style supervisor
   *
   * @return PHPExcel_Style_Borders
   */
  public function getSharedComponent() {
    return $this->_parent
      ->getSharedComponent()
      ->getBorders();
  }

  /**
   * Build style array from subcomponents
   *
   * @param array $array
   * @return array
   */
  public function getStyleArray($array) {
    return array(
      'borders' => $array,
    );
  }

  /**
   * Apply styles from array
   *
   * <code>
   * $objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->applyFromArray(
   * 		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>
   * <code>
   * $objPHPExcel->getActiveSheet()->getStyle('B2')->getBorders()->applyFromArray(
   * 		array(
   * 			'allborders' => array(
   * 				'style' => PHPExcel_Style_Border::BORDER_DASHDOT,
   * 				'color' => array(
   * 					'rgb' => '808080'
   * 				)
   * 			)
   * 		)
   * );
   * </code>
   *
   * @param	array	$pStyles	Array containing style information
   * @throws	PHPExcel_Exception
   * @return PHPExcel_Style_Borders
   */
  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('left', $pStyles)) {
          $this
            ->getLeft()
            ->applyFromArray($pStyles['left']);
        }
        if (array_key_exists('right', $pStyles)) {
          $this
            ->getRight()
            ->applyFromArray($pStyles['right']);
        }
        if (array_key_exists('top', $pStyles)) {
          $this
            ->getTop()
            ->applyFromArray($pStyles['top']);
        }
        if (array_key_exists('bottom', $pStyles)) {
          $this
            ->getBottom()
            ->applyFromArray($pStyles['bottom']);
        }
        if (array_key_exists('diagonal', $pStyles)) {
          $this
            ->getDiagonal()
            ->applyFromArray($pStyles['diagonal']);
        }
        if (array_key_exists('diagonaldirection', $pStyles)) {
          $this
            ->setDiagonalDirection($pStyles['diagonaldirection']);
        }
        if (array_key_exists('allborders', $pStyles)) {
          $this
            ->getLeft()
            ->applyFromArray($pStyles['allborders']);
          $this
            ->getRight()
            ->applyFromArray($pStyles['allborders']);
          $this
            ->getTop()
            ->applyFromArray($pStyles['allborders']);
          $this
            ->getBottom()
            ->applyFromArray($pStyles['allborders']);
        }
      }
    }
    else {
      throw new PHPExcel_Exception("Invalid style array passed.");
    }
    return $this;
  }

  /**
   * Get Left
   *
   * @return PHPExcel_Style_Border
   */
  public function getLeft() {
    return $this->_left;
  }

  /**
   * Get Right
   *
   * @return PHPExcel_Style_Border
   */
  public function getRight() {
    return $this->_right;
  }

  /**
   * Get Top
   *
   * @return PHPExcel_Style_Border
   */
  public function getTop() {
    return $this->_top;
  }

  /**
   * Get Bottom
   *
   * @return PHPExcel_Style_Border
   */
  public function getBottom() {
    return $this->_bottom;
  }

  /**
   * Get Diagonal
   *
   * @return PHPExcel_Style_Border
   */
  public function getDiagonal() {
    return $this->_diagonal;
  }

  /**
   * Get AllBorders (pseudo-border). Only applies to supervisor.
   *
   * @return PHPExcel_Style_Border
   * @throws PHPExcel_Exception
   */
  public function getAllBorders() {
    if (!$this->_isSupervisor) {
      throw new PHPExcel_Exception('Can only get pseudo-border for supervisor.');
    }
    return $this->_allBorders;
  }

  /**
   * Get Outline (pseudo-border). Only applies to supervisor.
   *
   * @return boolean
   * @throws PHPExcel_Exception
   */
  public function getOutline() {
    if (!$this->_isSupervisor) {
      throw new PHPExcel_Exception('Can only get pseudo-border for supervisor.');
    }
    return $this->_outline;
  }

  /**
   * Get Inside (pseudo-border). Only applies to supervisor.
   *
   * @return boolean
   * @throws PHPExcel_Exception
   */
  public function getInside() {
    if (!$this->_isSupervisor) {
      throw new PHPExcel_Exception('Can only get pseudo-border for supervisor.');
    }
    return $this->_inside;
  }

  /**
   * Get Vertical (pseudo-border). Only applies to supervisor.
   *
   * @return PHPExcel_Style_Border
   * @throws PHPExcel_Exception
   */
  public function getVertical() {
    if (!$this->_isSupervisor) {
      throw new PHPExcel_Exception('Can only get pseudo-border for supervisor.');
    }
    return $this->_vertical;
  }

  /**
   * Get Horizontal (pseudo-border). Only applies to supervisor.
   *
   * @return PHPExcel_Style_Border
   * @throws PHPExcel_Exception
   */
  public function getHorizontal() {
    if (!$this->_isSupervisor) {
      throw new PHPExcel_Exception('Can only get pseudo-border for supervisor.');
    }
    return $this->_horizontal;
  }

  /**
   * Get DiagonalDirection
   *
   * @return int
   */
  public function getDiagonalDirection() {
    if ($this->_isSupervisor) {
      return $this
        ->getSharedComponent()
        ->getDiagonalDirection();
    }
    return $this->_diagonalDirection;
  }

  /**
   * Set DiagonalDirection
   *
   * @param int $pValue
   * @return PHPExcel_Style_Borders
   */
  public function setDiagonalDirection($pValue = PHPExcel_Style_Borders::DIAGONAL_NONE) {
    if ($pValue == '') {
      $pValue = PHPExcel_Style_Borders::DIAGONAL_NONE;
    }
    if ($this->_isSupervisor) {
      $styleArray = $this
        ->getStyleArray(array(
        'diagonaldirection' => $pValue,
      ));
      $this
        ->getActiveSheet()
        ->getStyle($this
        ->getSelectedCells())
        ->applyFromArray($styleArray);
    }
    else {
      $this->_diagonalDirection = $pValue;
    }
    return $this;
  }

  /**
   * Get hash code
   *
   * @return string	Hash code
   */
  public function getHashCode() {
    if ($this->_isSupervisor) {
      return $this
        ->getSharedComponent()
        ->getHashcode();
    }
    return md5($this
      ->getLeft()
      ->getHashCode() . $this
      ->getRight()
      ->getHashCode() . $this
      ->getTop()
      ->getHashCode() . $this
      ->getBottom()
      ->getHashCode() . $this
      ->getDiagonal()
      ->getHashCode() . $this
      ->getDiagonalDirection() . __CLASS__);
  }

}

Members

Namesort descending Modifiers Type Description Overrides
PHPExcel_Style_Borders::$_allBorders protected property * All borders psedo-border. Only applies to supervisor. * *
PHPExcel_Style_Borders::$_bottom protected property * Bottom * *
PHPExcel_Style_Borders::$_diagonal protected property * Diagonal * *
PHPExcel_Style_Borders::$_diagonalDirection protected property * DiagonalDirection * *
PHPExcel_Style_Borders::$_horizontal protected property * Horizontal pseudo-border. Only applies to supervisor. * *
PHPExcel_Style_Borders::$_inside protected property * Inside psedo-border. Only applies to supervisor. * *
PHPExcel_Style_Borders::$_left protected property * Left * *
PHPExcel_Style_Borders::$_outline protected property * Outline psedo-border. Only applies to supervisor. * *
PHPExcel_Style_Borders::$_right protected property * Right * *
PHPExcel_Style_Borders::$_top protected property * Top * *
PHPExcel_Style_Borders::$_vertical protected property * Vertical pseudo-border. Only applies to supervisor. * *
PHPExcel_Style_Borders::applyFromArray public function Apply styles from array
PHPExcel_Style_Borders::DIAGONAL_BOTH constant
PHPExcel_Style_Borders::DIAGONAL_DOWN constant
PHPExcel_Style_Borders::DIAGONAL_NONE constant
PHPExcel_Style_Borders::DIAGONAL_UP constant
PHPExcel_Style_Borders::getAllBorders public function Get AllBorders (pseudo-border). Only applies to supervisor.
PHPExcel_Style_Borders::getBottom public function Get Bottom
PHPExcel_Style_Borders::getDiagonal public function Get Diagonal
PHPExcel_Style_Borders::getDiagonalDirection public function Get DiagonalDirection
PHPExcel_Style_Borders::getHashCode public function * Get hash code * * Overrides PHPExcel_IComparable::getHashCode
PHPExcel_Style_Borders::getHorizontal public function Get Horizontal (pseudo-border). Only applies to supervisor.
PHPExcel_Style_Borders::getInside public function Get Inside (pseudo-border). Only applies to supervisor.
PHPExcel_Style_Borders::getLeft public function Get Left
PHPExcel_Style_Borders::getOutline public function Get Outline (pseudo-border). Only applies to supervisor.
PHPExcel_Style_Borders::getRight public function Get Right
PHPExcel_Style_Borders::getSharedComponent public function * Get the shared style component for the currently active cell in currently active sheet. * Only used for style supervisor * *
PHPExcel_Style_Borders::getStyleArray public function * Build style array from subcomponents * *
PHPExcel_Style_Borders::getTop public function Get Top
PHPExcel_Style_Borders::getVertical public function Get Vertical (pseudo-border). Only applies to supervisor.
PHPExcel_Style_Borders::setDiagonalDirection public function Set DiagonalDirection
PHPExcel_Style_Borders::__construct public function Create a new PHPExcel_Style_Borders * * Overrides PHPExcel_Style_Supervisor::__construct
PHPExcel_Style_Supervisor::$_isSupervisor protected property * Supervisor? * *
PHPExcel_Style_Supervisor::$_parent protected property * Parent. Only used for supervisor * *
PHPExcel_Style_Supervisor::bindParent public function * Bind parent. Only used for supervisor * * 2
PHPExcel_Style_Supervisor::getActiveCell public function * Get the currently active cell coordinate in currently active sheet. * Only used for supervisor * *
PHPExcel_Style_Supervisor::getActiveSheet public function * Get the currently active sheet. Only used for supervisor * *
PHPExcel_Style_Supervisor::getIsSupervisor public function * Is this a supervisor or a cell style component? * *
PHPExcel_Style_Supervisor::getSelectedCells public function * Get the currently active cell coordinate in currently active sheet. * Only used for supervisor * *
PHPExcel_Style_Supervisor::__clone public function * Implement PHP __clone to create a deep clone, not just a shallow copy.