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: StyleRegistry.php

<?php

declare(strict_types=1);

namespace OpenSpout\Writer\XLSX\Manager\Style;

use OpenSpout\Common\Entity\Style\Style;
use OpenSpout\Writer\Common\Manager\Style\AbstractStyleRegistry as CommonStyleRegistry;

/**
 * @internal
 */
class StyleRegistry extends CommonStyleRegistry
{
    /**
     * Mapping between built-in format and the associated numFmtId.
     *
     * @see https://msdn.microsoft.com/en-us/library/ff529597(v=office.12).aspx
     */
    private const builtinNumFormatToIdMapping = [
        'General' => 0,
        '0' => 1,
        '0.00' => 2,
        '#,##0' => 3,
        '#,##0.00' => 4,
        '$#,##0,\-$#,##0' => 5,
        '$#,##0,[Red]\-$#,##0' => 6,
        '$#,##0.00,\-$#,##0.00' => 7,
        '$#,##0.00,[Red]\-$#,##0.00' => 8,
        '0%' => 9,
        '0.00%' => 10,
        '0.00E+00' => 11,
        '# ?/?' => 12,
        '# ??/??' => 13,
        'mm-dd-yy' => 14,
        'd-mmm-yy' => 15,
        'd-mmm' => 16,
        'mmm-yy' => 17,
        'h:mm AM/PM' => 18,
        'h:mm:ss AM/PM' => 19,
        'h:mm' => 20,
        'h:mm:ss' => 21,
        'm/d/yy h:mm' => 22,

'#,##0 ,(#,##0)' => 37,
        '#,##0 ,[Red](#,##0)' => 38,
        '#,##0.00,(#,##0.00)' => 39,
        '#,##0.00,[Red](#,##0.00)' => 40,

'_("$"* #,##0.00_),_("$"* $#,##0.00$,_("$"* "-"??_),_(@_)' => 44,
        'mm:ss' => 45,
        '[h]:mm:ss' => 46,
        'mm:ss.0' => 47,

'##0.0E+0' => 48,
        '@' => 49,

'[$-404]e/m/d' => 27,
        'm/d/yy' => 30,
        't0' => 59,
        't0.00' => 60,
        't#,##0' => 61,
        't#,##0.00' => 62,
        't0%' => 67,
        't0.00%' => 68,
        't# ?/?' => 69,
        't# ??/??' => 70,
    ];

/** @var array<string, int> */
    private array $registeredFormats = [];

/** @var array<int, int> [STYLE_ID] => [FORMAT_ID] maps a style to a format declaration */
    private array $styleIdToFormatsMappingTable = [];

/**
     * If the numFmtId is lower than 0xA4 (164 in decimal)
     * then it's a built-in number format.
     * Since Excel is the dominant vendor - we play along here.
     *
     * @var int the fill index counter for custom fills
     */
    private int $formatIndex = 164;

/** @var array<string, int> */
    private array $registeredFills = [];

/** @var array<int, int> [STYLE_ID] => [FILL_ID] maps a style to a fill declaration */
    private array $styleIdToFillMappingTable = [];

/**
     * Excel preserves two default fills with index 0 and 1
     * Since Excel is the dominant vendor - we play along here.
     *
     * @var int the fill index counter for custom fills
     */
    private int $fillIndex = 2;

/** @var array<string, int> */
    private array $registeredBorders = [];

/** @var array<int, int> [STYLE_ID] => [BORDER_ID] maps a style to a border declaration */
    private array $styleIdToBorderMappingTable = [];

/**
     * XLSX specific operations on the registered styles.
     */
    public function registerStyle(Style $style): Style
    {
        if ($style->isRegistered()) {
            return $style;
        }

$registeredStyle = parent::registerStyle($style);
        $this->registerFill($registeredStyle);
        $this->registerFormat($registeredStyle);
        $this->registerBorder($registeredStyle);

return $registeredStyle;
    }

/**
     * @return null|int Format ID associated to the given style ID
     */
    public function getFormatIdForStyleId(int $styleId): ?int
    {
        return $this->styleIdToFormatsMappingTable[$styleId] ?? null;
    }

/**
     * @return null|int Fill ID associated to the given style ID
     */
    public function getFillIdForStyleId(int $styleId): ?int
    {
        return $this->styleIdToFillMappingTable[$styleId] ?? null;
    }

/**
     * @return null|int Fill ID associated to the given style ID
     */
    public function getBorderIdForStyleId(int $styleId): ?int
    {
        return $this->styleIdToBorderMappingTable[$styleId] ?? null;
    }

/**
     * @return array<string, int>
     */
    public function getRegisteredFills(): array
    {
        return $this->registeredFills;
    }

/**
     * @return array<string, int>
     */
    public function getRegisteredBorders(): array
    {
        return $this->registeredBorders;
    }

/**
     * @return array<string, int>
     */
    public function getRegisteredFormats(): array
    {
        return $this->registeredFormats;
    }

/**
     * Register a format definition.
     */
    private function registerFormat(Style $style): void
    {
        $styleId = $style->getId();

$format = $style->getFormat();
        if (null !== $format) {
            $isFormatRegistered = isset($this->registeredFormats[$format]);

// We need to track the already registered format definitions
            if ($isFormatRegistered) {
                $registeredStyleId = $this->registeredFormats[$format];
                $registeredFormatId = $this->styleIdToFormatsMappingTable[$registeredStyleId];
                $this->styleIdToFormatsMappingTable[$styleId] = $registeredFormatId;
            } else {
                $this->registeredFormats[$format] = $styleId;

$id = self::builtinNumFormatToIdMapping[$format] ?? $this->formatIndex++;
                $this->styleIdToFormatsMappingTable[$styleId] = $id;
            }
        } else {
            // The formatId maps a style to a format declaration
            // When there is no format definition - we default to 0 ( General )
            $this->styleIdToFormatsMappingTable[$styleId] = 0;
        }
    }

/**
     * Register a fill definition.
     */
    private function registerFill(Style $style): void
    {
        $styleId = $style->getId();

// Currently - only solid backgrounds are supported
        // so $backgroundColor is a scalar value (RGB Color)
        $backgroundColor = $style->getBackgroundColor();

if (null !== $backgroundColor) {
            $isBackgroundColorRegistered = isset($this->registeredFills[$backgroundColor]);

// We need to track the already registered background definitions
            if ($isBackgroundColorRegistered) {
                $registeredStyleId = $this->registeredFills[$backgroundColor];
                $registeredFillId = $this->styleIdToFillMappingTable[$registeredStyleId];
                $this->styleIdToFillMappingTable[$styleId] = $registeredFillId;
            } else {
                $this->registeredFills[$backgroundColor] = $styleId;
                $this->styleIdToFillMappingTable[$styleId] = $this->fillIndex++;
            }
        } else {
            // The fillId maps a style to a fill declaration
            // When there is no background color definition - we default to 0
            $this->styleIdToFillMappingTable[$styleId] = 0;
        }
    }

/**
     * Register a border definition.
     */
    private function registerBorder(Style $style): void
    {
        $styleId = $style->getId();

if (null !== ($border = $style->getBorder())) {
            $serializedBorder = serialize($border);

$isBorderAlreadyRegistered = isset($this->registeredBorders[$serializedBorder]);

if ($isBorderAlreadyRegistered) {
                $registeredStyleId = $this->registeredBorders[$serializedBorder];
                $registeredBorderId = $this->styleIdToBorderMappingTable[$registeredStyleId];
                $this->styleIdToBorderMappingTable[$styleId] = $registeredBorderId;
            } else {
                $this->registeredBorders[$serializedBorder] = $styleId;
                $this->styleIdToBorderMappingTable[$styleId] = \count($this->registeredBorders);
            }
        } else {
            // If no border should be applied - the mapping is the default border: 0
            $this->styleIdToBorderMappingTable[$styleId] = 0;
        }
    }
}

X7ROOT File Manager

Editing: StyleRegistry.php

Upload File

Create Folder