Symfony Profiler

<?php declare(strict_types=1);
namespace H1web\MegaMenu;
use Doctrine\DBAL\Connection;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Filter\EqualsFilter;
use Shopware\Core\Framework\Uuid\Uuid;
use Shopware\Core\Framework\Plugin;
use Shopware\Core\Framework\Plugin\Context\InstallContext;
use Shopware\Core\Framework\Plugin\Context\UninstallContext;
use Shopware\Core\Framework\Plugin\Context\UpdateContext;
use Shopware\Core\Framework\Context;
use Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryInterface;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Criteria;
use Shopware\Core\Framework\DataAbstractionLayer\Search\Filter\ContainsFilter;
use Shopware\Core\System\CustomField\Aggregate\CustomFieldSet\CustomFieldSetEntity;
use Shopware\Core\System\CustomField\Aggregate\CustomFieldSetRelation\CustomFieldSetRelationEntity;
use Shopware\Core\System\CustomField\CustomFieldEntity;
class H1webMegaMenu extends Plugin
{
public const SYSTEM_CONFIG_DOMAIN = 'H1webMegaMenu.config.';
public function install(InstallContext $context): void
{
$this->createCustomFields($context);
}
public function update(UpdateContext $context): void
{
$this->createCustomFields($context);
}
private function createCustomFields($context)
{
/** @var EntityRepositoryInterface $systemConfigRepository */
$customFieldSetRepository = $this->container->get('custom_field_set.repository');
foreach ($this->getCustomFields() as $customFieldSet) {
$criteria = new Criteria();
$criteria->addFilter(new EqualsFilter('name', $customFieldSet['name']));
$criteria->addAssociation('relations');
$criteria->addAssociation('customFields');
$existingCustomFieldSet = $customFieldSetRepository->search($criteria, $context->getContext())->first();
if ($existingCustomFieldSet) {
/** @var CustomFieldSetEntity $existingCustomFieldSet */
$customFieldSet['id'] = $existingCustomFieldSet->getId();
if (!empty($customFieldSet['relations'])) {
$existingRelations = [];
foreach ($existingCustomFieldSet->getRelations() as $field) {
/** @var CustomFieldSetRelationEntity $field */
$existingRelations[$field->getId()] = $field->getEntityName();
}
$relations = [];
foreach ($customFieldSet['relations'] as $relation) {
if (array_search($relation['entityName'], $existingRelations)) {
$relation['id'] = array_search($relation['entityName'], $existingRelations);
}
$relations[] = $relation;
}
$customFieldSet['relations'] = $relations;
}
if (!empty($customFieldSet['customFields'])) {
$existingCustomFields = [];
foreach ($existingCustomFieldSet->getCustomFields() as $field) {
/** @var CustomFieldEntity $field */
$existingCustomFields[$field->getId()] = $field->getName();
}
$customFields = [];
foreach ($customFieldSet['customFields'] as $customField) {
if (array_search($customField['name'], $existingCustomFields)) {
$customField['id'] = array_search($customField['name'], $existingCustomFields);
}
$customFields[] = $customField;
}
$customFieldSet['customFields'] = $customFields;
}
}
$customFieldSetRepository->upsert([$customFieldSet], $context->getContext());
}
}
private function getCustomFields()
{
$customFields = [
'h1_mega_menu' => [
'name' => 'h1_mega_menu',
'config' => [
'label' => [
'en-GB' => 'Mega menu options',
'de-DE' => 'Mega menu options',
'nl-NL' => 'Mega menu options'
]
],
'relations' => [['entityName' => 'category']],
'customFields' => [
[
'name' => 'h1_mega_menu_category_level',
'type' => 'select',
'config' => [
'label' => [
'en-GB' => 'Select folout menu layout',
'de-DE' => 'Wählen Sie das Layout des Folout-Menüs',
'nl-NL' => 'Selecteer foldout layout'
],
'placeholder' => 'Foldout layout with left sidebar',
'options' => [
[
'label' => [
'en-GB' => 'Foldout layout without left sidebar',
'de-DE' => 'Nur Haupt- + Unterkategorie',
'nl-NL' => 'Foldout layout zonder linker sidebar'
],
'value' => 'h1_mega_menu_category_level_2'
],
[
'label' => [
'en-GB' => 'Foldout layout with left sidebar',
'de-DE' => 'Alle Unterkategorien',
'nl-NL' => 'Foldout layout met linker sidebar'
],
'value' => 'h1_mega_menu_category_level_more'
]
],
'helpText' => [
'en-GB' => 'If you choose the option "Foldout layout with left sidebar" it will show in the folout a left section with in the subcategories, its like a extra "foldout" for the sub sub catgories. Recommanded it you have a lot of categories.',
'de-DE' => 'Wenn Sie die Option "Ausklappbares Layout mit linker Seitenleiste" wählen, wird im Folout ein linker Abschnitt mit in den Unterkategorien angezeigt, ähnlich wie bei einem zusätzlichen "Ausklappen" für die Unterunterkategorien. Empfohlen haben Sie viele Kategorien.',
'nl-NL' => 'Als je de optie "Uitvouwbare lay-out met linkerzijbalk" kiest, wordt in de volgende sectie een linkergedeelte weergegeven met in de subcategorieën, het is als een extra "uitvouwbare" voor de sub-subcategorieën. Aanbevolen, je hebt veel categorieën.'
],
'componentName' => 'sw-single-select',
'customFieldType' => 'select',
'customFieldPosition' => 1
]
],
[
'name' => 'h1_mega_menu_category_parent',
'type' => 'bool',
'config' => [
'type' => 'checkbox',
'label' => [
'en-GB' => 'Put main category in placeholder',
'de-DE' => 'Setzen Sie die Hauptkategorie in den Platzhalter',
'nl-NL' => 'Plaats hoofdcategorie in placeholder'
],
'helpText' => [
'en-GB' => 'You can put the main category in a placeholder, the default is "Products". In your navigation you see "Products" and when u click on it you will see the subcategories. Its also posible to change the text, you can do this in the snippets.',
'de-DE' => 'Sie können die Hauptkategorie in einen Platzhalter einfügen. Die Standardeinstellung ist "Produkte". In Ihrer Navigation sehen Sie "Produkte" und wenn Sie darauf klicken, sehen Sie die Unterkategorien. Es ist auch möglich, den Text zu ändern. Sie können dies in den Snippets tun.',
'nl-NL' => 'U kunt de hoofdcategorie in een tijdelijke aanduiding plaatsen, de standaard is "Producten". In uw navigatie ziet u "Producten" en als u erop klikt, ziet u de subcategorieën. Het is ook mogelijk om de tekst te wijzigen, u kunt dit doen in de fragmenten.'
],
'componentName' => 'sw-field',
'customFieldType' => 'checkbox',
'customFieldPosition' => 2
]
],
[
'name' => 'h1_mega_menu_category_icon',
'type' => 'text',
'config' => [
'label' => [
'en-GB' => 'Category icon',
'de-DE' => 'Kategoriesymbol',
'nl-NL' => 'Category icon'
],
'helpText' => [
'en-GB' => 'Check the plugin configuration, as default it will use the category image. In the config you can select use the custom field instead of the category image.',
'de-DE' => 'Überprüfen Sie die Plugin-Konfiguration. Standardmäßig wird das Kategorie-Image verwendet. In der Konfiguration können Sie das benutzerdefinierte Feld anstelle des Kategoriebilds verwenden auswählen.',
'nl-NL' => 'Controleer de configuratie van de plug-in, deze zal standaard de categorie-afbeelding gebruiken. In de configuratie kunt u ervoor kiezen om het aangepaste veld te gebruiken in plaats van de categorieafbeelding.'
],
'componentName' => 'sw-media-field',
'customFieldType' => 'media',
'customFieldPosition' => 3
]
]
]
]
];
return $customFields;
}
public function uninstall(UninstallContext $uninstallContext): void
{
parent::uninstall($uninstallContext);
if ($uninstallContext->keepUserData()) {
return;
}
$this->removeCustomFields($uninstallContext->getContext());
$this->removeConfiguration($uninstallContext->getContext());
}
private function removeCustomFields(Context $context): void
{
/** @var EntityRepositoryInterface $customFieldSetRepository */
$customFieldSetRepository = $this->container->get('custom_field_set.repository');
$criteria = (new Criteria())
->addFilter(new ContainsFilter('name', 'h1_mega_menu'));
$idSearchResult = $customFieldSetRepository->searchIds($criteria, $context);
if (0 === $idSearchResult->getTotal()) {
return;
}
$ids = array_map(static function ($id) {
return ['id' => $id];
}, $idSearchResult->getIds());
$customFieldSetRepository->delete($ids, $context);
$connection = $this->container->get(Connection::class);
$data = $connection->executeQuery("SELECT `category_id`, `language_id`, `custom_fields` FROM `category_translation` WHERE `custom_fields` IS NOT NULL")->fetchAll();
foreach ($data as $index => $elements) {
$id = Uuid::fromBytesToHex($elements['category_id']);
$languageId = Uuid::fromBytesToHex($elements['language_id']);
$customFields = json_decode($elements['custom_fields'], true);
if (!isset($customFields['h1_mega_menu_category_level']) && !isset($customFields['h1_mega_menu_category_parent']) && !isset($customFields['h1_mega_menu_category_icon'] )) {
continue;
}
unset($customFields['h1_mega_menu_category_level'], $customFields['h1_mega_menu_category_parent'], $customFields['h1_mega_menu_category_icon']);
if (empty($customFields)) {
$connection->executeQuery("UPDATE `category_translation` SET `custom_fields` = NULL WHERE `category_id` = UNHEX('". $id ."') AND `language_id` = UNHEX('". $languageId ."')");
} else {
$connection->executeQuery("UPDATE `category_translation` SET `custom_fields` = '".json_encode($customFields, JSON_PRESERVE_ZERO_FRACTION | JSON_UNESCAPED_UNICODE)."' WHERE `category_id` = UNHEX('". $id ."') AND `language_id` = UNHEX('". $languageId ."')");
}
}
}
private function removeConfiguration(Context $context): void
{
/** @var EntityRepositoryInterface $systemConfigRepository */
$systemConfigRepository = $this->container->get('system_config.repository');
$criteria = (new Criteria())
->addFilter(new ContainsFilter('configurationKey', self::SYSTEM_CONFIG_DOMAIN));
$idSearchResult = $systemConfigRepository->searchIds($criteria, $context);
if($idSearchResult->getTotal() > 0) {
$ids = array_map(static function ($id) {
return ['id' => $id];
}, $idSearchResult->getIds());
$systemConfigRepository->delete(array_values($ids), $context);
}
}
}

custom/plugins/H1webMegaMenu/src/H1webMegaMenu.php line 20