View Code - 20260721

Properties.php | 20260721_154034.php Initial Bulk Import

<?php

namespace PhpOffice\PhpSpreadsheet\Reader\Ods;

use PhpOffice\PhpSpreadsheet\Document\Properties as DocumentProperties;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use SimpleXMLElement;

class Properties
{
    private Spreadsheet $spreadsheet;

public function __construct(Spreadsheet $spreadsheet)
    {
        $this->spreadsheet = $spreadsheet;
    }

/** @param array{meta?: string, office?: string, dc?: string} $namespacesMeta */
    public function load(SimpleXMLElement $xml, array $namespacesMeta): void
    {
        $docProps = $this->spreadsheet->getProperties();
        $officeProperty = $xml->children($namespacesMeta['office'] ?? '');
        foreach ($officeProperty as $officePropertyData) {
            if (isset($namespacesMeta['dc'])) {
                $officePropertiesDC = $officePropertyData->children($namespacesMeta['dc']);
                $this->setCoreProperties($docProps, $officePropertiesDC);
            }

$officePropertyMeta = null;
            if (isset($namespacesMeta['dc'])) {
                $officePropertyMeta = $officePropertyData->children($namespacesMeta['meta'] ?? '');
            }
            $officePropertyMeta = $officePropertyMeta ?? [];
            foreach ($officePropertyMeta as $propertyName => $propertyValue) {
                $this->setMetaProperties($namespacesMeta, $propertyValue, $propertyName, $docProps);
            }
        }
    }

private function setCoreProperties(DocumentProperties $docProps, SimpleXMLElement $officePropertyDC): void
    {
        foreach ($officePropertyDC as $propertyName => $propertyValue) {
            $propertyValue = (string) $propertyValue;
            switch ($propertyName) {
                case 'title':
                    $docProps->setTitle($propertyValue);

break;
                case 'subject':
                    $docProps->setSubject($propertyValue);

break;
                case 'creator':
                    $docProps->setCreator($propertyValue);
                    $docProps->setLastModifiedBy($propertyValue);

break;
                case 'date':
                    $docProps->setModified($propertyValue);

break;
                case 'description':
                    $docProps->setDescription($propertyValue);

break;
            }
        }
    }

/** @param array{meta?: string, office?: mixed, dc?: mixed} $namespacesMeta */
    private function setMetaProperties(
        array $namespacesMeta,
        SimpleXMLElement $propertyValue,
        string $propertyName,
        DocumentProperties $docProps
    ): void {
        $propertyValueAttributes = $propertyValue->attributes($namespacesMeta['meta'] ?? '');
        $propertyValue = (string) $propertyValue;
        switch ($propertyName) {
            case 'initial-creator':
                $docProps->setCreator($propertyValue);

break;
            case 'keyword':
                $docProps->setKeywords($propertyValue);

break;
            case 'creation-date':
                $docProps->setCreated($propertyValue);

break;
            case 'user-defined':
                $name2 = (string) ($propertyValueAttributes['name'] ?? '');
                if ($name2 === 'Company') {
                    $docProps->setCompany($propertyValue);
                } elseif ($name2 === 'category') {
                    $docProps->setCategory($propertyValue);
                } else {
                    $this->setUserDefinedProperty($propertyValueAttributes, $propertyValue, $docProps);
                }

break;
        }
    }

/** @param iterable<string> $propertyValueAttributes */
    private function setUserDefinedProperty(iterable $propertyValueAttributes, string $propertyValue, DocumentProperties $docProps): void
    {
        $propertyValueName = '';
        $propertyValueType = DocumentProperties::PROPERTY_TYPE_STRING;
        foreach ($propertyValueAttributes as $key => $value) {
            if ($key == 'name') {
                /** @var scalar $value */
                $propertyValueName = (string) $value;
            } elseif ($key == 'value-type') {
                /** @var string $value */
                switch ($value) {
                    case 'date':
                        $propertyValue = DocumentProperties::convertProperty($propertyValue, 'date');
                        $propertyValueType = DocumentProperties::PROPERTY_TYPE_DATE;

break;
                    case 'boolean':
                        $propertyValue = DocumentProperties::convertProperty($propertyValue, 'bool');
                        $propertyValueType = DocumentProperties::PROPERTY_TYPE_BOOLEAN;

break;
                    case 'float':
                        $propertyValue = DocumentProperties::convertProperty($propertyValue, 'r4');
                        $propertyValueType = DocumentProperties::PROPERTY_TYPE_FLOAT;

break;
                    default:
                        $propertyValueType = DocumentProperties::PROPERTY_TYPE_STRING;
                }
            }
        }

$docProps->setCustomProperty($propertyValueName, $propertyValue, $propertyValueType);
    }
}