File Manager

X7ROOT File Manager

Current Path: /home/cbholdings/pasukulu/lib/openspout/src/Writer/XLSX/Manager/Style

home / cbholdings / pasukulu / lib / openspout / src / Writer / XLSX / Manager / Style /

📁 ..
📄 StyleManager.php(10.67 KB)
📄 StyleRegistry.php(7.77 KB)

Editing: StyleManager.php

<?php

declare(strict_types=1);

namespace OpenSpout\Writer\XLSX\Manager\Style;

use OpenSpout\Common\Entity\Style\BorderPart;
use OpenSpout\Common\Entity\Style\Color;
use OpenSpout\Common\Entity\Style\Style;
use OpenSpout\Writer\Common\Manager\Style\AbstractStyleManager as CommonStyleManager;
use OpenSpout\Writer\XLSX\Helper\BorderHelper;

/**
 * @internal
 *
 * @property StyleRegistry $styleRegistry
 */
final class StyleManager extends CommonStyleManager
{
    public function __construct(StyleRegistry $styleRegistry)
    {
        parent::__construct($styleRegistry);
    }

/**
     * For empty cells, we can specify a style or not. If no style are specified,
     * then the software default will be applied. But sometimes, it may be useful
     * to override this default style, for instance if the cell should have a
     * background color different than the default one or some borders
     * (fonts property don't really matter here).
     *
     * @return bool Whether the cell should define a custom style
     */
    public function shouldApplyStyleOnEmptyCell(?int $styleId): bool
    {
        if (null === $styleId) {
            return false;
        }
        $associatedFillId = $this->styleRegistry->getFillIdForStyleId($styleId);
        $hasStyleCustomFill = (null !== $associatedFillId && 0 !== $associatedFillId);

$associatedBorderId = $this->styleRegistry->getBorderIdForStyleId($styleId);
        $hasStyleCustomBorders = (null !== $associatedBorderId && 0 !== $associatedBorderId);

$associatedFormatId = $this->styleRegistry->getFormatIdForStyleId($styleId);
        $hasStyleCustomFormats = (null !== $associatedFormatId && 0 !== $associatedFormatId);

return $hasStyleCustomFill || $hasStyleCustomBorders || $hasStyleCustomFormats;
    }

/**
 * Returns the content of the "styles.xml" file, given a list of styles.
 */
 public function getStylesXMLFileContent(): string
 {
 $content = <<<'EOD'
 <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
 <styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
 EOD;

$content .= $this->getFormatsSectionContent();
        $content .= $this->getFontsSectionContent();
        $content .= $this->getFillsSectionContent();
        $content .= $this->getBordersSectionContent();
        $content .= $this->getCellStyleXfsSectionContent();
        $content .= $this->getCellXfsSectionContent();
        $content .= $this->getCellStylesSectionContent();

$content .= <<<'EOD'
 </styleSheet>
 EOD;

return $content;
    }

/**
 * Returns the content of the "<numFmts>" section.
 */
 private function getFormatsSectionContent(): string
 {
 $tags = [];
 $registeredFormats = $this->styleRegistry->getRegisteredFormats();
 foreach ($registeredFormats as $styleId) {
 $numFmtId = $this->styleRegistry->getFormatIdForStyleId($styleId);

// Built-in formats do not need to be declared, skip them
 if ($numFmtId < 164) {
 continue;
 }

/** @var Style $style */
 $style = $this->styleRegistry->getStyleFromStyleId($styleId);
 $format = $style->getFormat();
 $tags[] = '<numFmt numFmtId="'.$numFmtId.'" formatCode="'.$format.'"/>';
 }
 $content = '<numFmts count="'.\count($tags).'">';
 $content .= implode('', $tags);
 $content .= '</numFmts>';

return $content;
    }

/**
 * Returns the content of the "<fonts>" section.
 */
 private function getFontsSectionContent(): string
 {
 $registeredStyles = $this->styleRegistry->getRegisteredStyles();

$content = '<fonts count="'.\count($registeredStyles).'">';

/** @var Style $style */
 foreach ($registeredStyles as $style) {
 $content .= '';

$content .= '<sz val="'.$style->getFontSize().'"/>';
 $content .= '<color rgb="'.Color::toARGB($style->getFontColor()).'"/>';
 $content .= '<name val="'.$style->getFontName().'"/>';

if ($style->isFontBold()) {
 $content .= '';
 }
 if ($style->isFontItalic()) {
 $content .= '';
 }
 if ($style->isFontUnderline()) {
 $content .= '';
 }
 if ($style->isFontStrikethrough()) {
 $content .= '<strike/>';
 }

$content .= '';
 }

$content .= '</fonts>';

return $content;
    }

/**
 * Returns the content of the "<fills>" section.
 */
 private function getFillsSectionContent(): string
 {
 $registeredFills = $this->styleRegistry->getRegisteredFills();

// Excel reserves two default fills
 $fillsCount = \count($registeredFills) + 2;
 $content = sprintf('<fills count="%d">', $fillsCount);

$content .= '<fill><patternFill patternType="none"/></fill>';
 $content .= '<fill><patternFill patternType="gray125"/></fill>';

// The other fills are actually registered by setting a background color
        foreach ($registeredFills as $styleId) {
            /** @var Style $style */
            $style = $this->styleRegistry->getStyleFromStyleId($styleId);

$backgroundColor = $style->getBackgroundColor();
 $content .= sprintf(
 '<fill><patternFill patternType="solid"><fgColor rgb="%s"/></patternFill></fill>',
 $backgroundColor
 );
 }

$content .= '</fills>';

return $content;
    }

/**
 * Returns the content of the "<borders>" section.
 */
 private function getBordersSectionContent(): string
 {
 $registeredBorders = $this->styleRegistry->getRegisteredBorders();

// There is one default border with index 0
        $borderCount = \count($registeredBorders) + 1;

$content = '<borders count="'.$borderCount.'">';

// Default border starting at index 0
 $content .= '<border><left/><right/><top/><bottom/></border>';

foreach ($registeredBorders as $styleId) {
 $style = $this->styleRegistry->getStyleFromStyleId($styleId);
 $border = $style->getBorder();
 \assert(null !== $border);
 $content .= '<border>';

// @see https://github.com/box/spout/issues/271
            foreach (BorderPart::allowedNames as $partName) {
                $content .= BorderHelper::serializeBorderPart($border->getPart($partName));
            }

$content .= '</border>';
 }

$content .= '</borders>';

return $content;
    }

/**
 * Returns the content of the "<cellStyleXfs>" section.
 */
 private function getCellStyleXfsSectionContent(): string
 {
 return <<<'EOD'
 <cellStyleXfs count="1">
 <xf borderId="0" fillId="0" fontId="0" numFmtId="0"/>
 </cellStyleXfs>
 EOD;
 }

/**
 * Returns the content of the "<cellXfs>" section.
 */
 private function getCellXfsSectionContent(): string
 {
 $registeredStyles = $this->styleRegistry->getRegisteredStyles();

$content = '<cellXfs count="'.\count($registeredStyles).'">';

foreach ($registeredStyles as $style) {
            $styleId = $style->getId();
            $fillId = $this->getFillIdForStyleId($styleId);
            $borderId = $this->getBorderIdForStyleId($styleId);
            $numFmtId = $this->getFormatIdForStyleId($styleId);

$content .= '<xf numFmtId="'.$numFmtId.'" fontId="'.$styleId.'" fillId="'.$fillId.'" borderId="'.$borderId.'" xfId="0"';

if ($style->shouldApplyFont()) {
                $content .= ' applyFont="1"';
            }

$content .= sprintf(' applyBorder="%d"', (bool) $style->getBorder());

if ($style->shouldApplyCellAlignment() || $style->shouldApplyCellVerticalAlignment() || $style->hasSetWrapText() || $style->shouldShrinkToFit()) {
 $content .= ' applyAlignment="1">';
 $content .= '<alignment';
 if ($style->shouldApplyCellAlignment()) {
 $content .= sprintf(' horizontal="%s"', $style->getCellAlignment());
 }
 if ($style->shouldApplyCellVerticalAlignment()) {
 $content .= sprintf(' vertical="%s"', $style->getCellVerticalAlignment());
 }
 if ($style->hasSetWrapText()) {
 $content .= ' wrapText="'.($style->shouldWrapText() ? '1' : '0').'"';
 }
 if ($style->shouldShrinkToFit()) {
 $content .= ' shrinkToFit="true"';
 }

$content .= '/>';
 $content .= '</xf>';
 } else {
 $content .= '/>';
 }
 }

$content .= '</cellXfs>';

return $content;
    }

/**
 * Returns the content of the "<cellStyles>" section.
 */
 private function getCellStylesSectionContent(): string
 {
 return <<<'EOD'
 <cellStyles count="1">
 <cellStyle builtinId="0" name="Normal" xfId="0"/>
 </cellStyles>
 EOD;
 }

/**
     * Returns the fill ID associated to the given style ID.
     * For the default style, we don't a fill.
     */
    private function getFillIdForStyleId(int $styleId): int
    {
        // For the default style (ID = 0), we don't want to override the fill.
        // Otherwise all cells of the spreadsheet will have a background color.
        $isDefaultStyle = (0 === $styleId);

return $isDefaultStyle ? 0 : ($this->styleRegistry->getFillIdForStyleId($styleId) ?? 0);
    }

/**
     * Returns the fill ID associated to the given style ID.
     * For the default style, we don't a border.
     */
    private function getBorderIdForStyleId(int $styleId): int
    {
        // For the default style (ID = 0), we don't want to override the border.
        // Otherwise all cells of the spreadsheet will have a border.
        $isDefaultStyle = (0 === $styleId);

return $isDefaultStyle ? 0 : ($this->styleRegistry->getBorderIdForStyleId($styleId) ?? 0);
    }

/**
     * Returns the format ID associated to the given style ID.
     * For the default style use general format.
     */
    private function getFormatIdForStyleId(int $styleId): int
    {
        // For the default style (ID = 0), we don't want to override the format.
        // Otherwise all cells of the spreadsheet will have a format.
        $isDefaultStyle = (0 === $styleId);

return $isDefaultStyle ? 0 : ($this->styleRegistry->getFormatIdForStyleId($styleId) ?? 0);
    }
}

X7ROOT File Manager

Editing: StyleManager.php

Upload File

Create Folder