color = new Color(Color::COLOR_BLACK, $isSupervisor); // bind parent if we are a supervisor if ($isSupervisor) { $this->color->bindParent($this, 'color'); } } /** * Bind parent. Only used for supervisor. * * @param Borders $parent * @param string $parentPropertyName * * @return Border */ public function bindParent($parent, $parentPropertyName = null) { $this->parent = $parent; $this->parentPropertyName = $parentPropertyName; return $this; } /** * Get the shared style component for the currently active cell in currently active sheet. * Only used for style supervisor. * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Border */ public function getSharedComponent() { switch ($this->parentPropertyName) { case 'allBorders': case 'horizontal': case 'inside': case 'outline': case 'vertical': throw new \PhpOffice\PhpSpreadsheet\Exception('Cannot get shared component for a pseudo-border.'); break; case 'bottom': return $this->parent->getSharedComponent()->getBottom(); case 'diagonal': return $this->parent->getSharedComponent()->getDiagonal(); case 'left': return $this->parent->getSharedComponent()->getLeft(); case 'right': return $this->parent->getSharedComponent()->getRight(); case 'top': return $this->parent->getSharedComponent()->getTop(); } } /** * Build style array from subcomponents. * * @param array $array * * @return array */ public function getStyleArray($array) { switch ($this->parentPropertyName) { case 'allborders': case 'bottom': case 'diagonal': case 'horizontal': case 'inside': case 'left': case 'outline': case 'right': case 'top': case 'vertical': $key = strtolower($this->parentPropertyName); break; } return $this->parent->getStyleArray([$key => $array]); } /** * Apply styles from array. * * * $spreadsheet->getActiveSheet()->getStyle('B2')->getBorders()->getTop()->applyFromArray( * array( * 'style' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOT, * 'color' => array( * 'rgb' => '808080' * ) * ) * ); * * * @param array $pStyles Array containing style information * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Border */ public function applyFromArray($pStyles = null) { if (is_array($pStyles)) { if ($this->isSupervisor) { $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles)); } else { if (isset($pStyles['style'])) { $this->setBorderStyle($pStyles['style']); } if (isset($pStyles['color'])) { $this->getColor()->applyFromArray($pStyles['color']); } } } else { throw new \PhpOffice\PhpSpreadsheet\Exception('Invalid style array passed.'); } return $this; } /** * Get Border style. * * @return string */ public function getBorderStyle() { if ($this->isSupervisor) { return $this->getSharedComponent()->getBorderStyle(); } return $this->borderStyle; } /** * Set Border style. * * @param string|bool $pValue * When passing a boolean, FALSE equates Border::BORDER_NONE * and TRUE to Border::BORDER_MEDIUM * * @return Border */ public function setBorderStyle($pValue = self::BORDER_NONE) { if (empty($pValue)) { $pValue = self::BORDER_NONE; } elseif (is_bool($pValue) && $pValue) { $pValue = self::BORDER_MEDIUM; } if ($this->isSupervisor) { $styleArray = $this->getStyleArray(['style' => $pValue]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->borderStyle = $pValue; } return $this; } /** * Get Border Color. * * @return Color */ public function getColor() { return $this->color; } /** * Set Border Color. * * @param Color $pValue * * @throws \PhpOffice\PhpSpreadsheet\Exception * * @return Border */ public function setColor(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->getColor()->getStyleArray(['argb' => $color->getARGB()]); $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); } else { $this->color = $color; } return $this; } /** * Get hash code. * * @return string Hash code */ public function getHashCode() { if ($this->isSupervisor) { return $this->getSharedComponent()->getHashCode(); } return md5( $this->borderStyle . $this->color->getHashCode() . __CLASS__ ); } }