Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/old/vendor/mageworx/module-htmlsitemap/Setup/Patch/Data/ |
<?php
/**
* Copyright © MageWorx. All rights reserved.
* See LICENSE.txt for license details.
*/
namespace MageWorx\HtmlSitemap\Setup\Patch\Data;
use Magento\Catalog\Api\Data\CategoryInterface;
use Magento\Catalog\Api\Data\ProductInterface;
use Magento\Catalog\Model\Category;
use Magento\Catalog\Model\Product;
use Magento\Catalog\Model\ResourceModel\Eav\Attribute;
use Magento\Catalog\Setup\CategorySetupFactory;
use Magento\Framework\DB\Select;
use Magento\Framework\Setup\ModuleDataSetupInterface;
use Magento\Framework\Setup\Patch\DataPatchInterface;
use Magento\Framework\Setup\Patch\PatchVersionInterface;
use Magento\Store\Model\Store;
use MageWorx\SeoAll\Helper\LinkFieldResolver;
class AddAttributes implements DataPatchInterface, PatchVersionInterface
{
/**
* @var Default value for "in_html_sitemap" attribute
*/
const IN_SITEMAP_HTML_DEFAULT_VALUE = 1;
/**
* @var CategorySetupFactory
*/
protected $categorySetupFactory;
/**
* @var LinkFieldResolver
*/
protected $linkFieldResolver;
/**
* @var ModuleDataSetupInterface
*/
private $moduleDataSetup;
public function __construct(
ModuleDataSetupInterface $moduleDataSetup,
CategorySetupFactory $categorySetupFactory,
LinkFieldResolver $linkFieldResolver
) {
$this->moduleDataSetup = $moduleDataSetup;
$this->categorySetupFactory = $categorySetupFactory;
$this->linkFieldResolver = $linkFieldResolver;
}
/**
* {@inheritdoc}
*/
public function apply()
{
$catalogSetup = $this->categorySetupFactory->create(['setup' => $this->moduleDataSetup]);
$connection = $this->moduleDataSetup->getConnection();
$attributeTableFieldsProduct = $connection->describeTable(
$this->moduleDataSetup->getTable('catalog_product_entity_int')
);
$attributeTableFieldsCategory = $connection->describeTable(
$this->moduleDataSetup->getTable('catalog_category_entity_int')
);
/** @var \Magento\Catalog\Setup\CategorySetup $catalogSetup */
$attributeCode = 'in_html_sitemap';
$catalogSetup->addAttribute(
Product::ENTITY,
$attributeCode,
[
'group' => 'Search Engine Optimization',
'type' => 'int',
'backend' => \Magento\Catalog\Model\Product\Attribute\Backend\Boolean::class,
'frontend' => '',
'label' => 'Include in HTML Sitemap',
'input' => 'select',
'class' => '',
'source' => \Magento\Eav\Model\Entity\Attribute\Source\Boolean::class,
'global' => \Magento\Catalog\Model\ResourceModel\Eav\Attribute::SCOPE_STORE,
'visible' => true,
'required' => false,
'user_defined' => false,
'default' => self::IN_SITEMAP_HTML_DEFAULT_VALUE,
'apply_to' => '',
'visible_on_front' => false,
'note' => 'This setting was added by MageWorx HTML Sitemap'
]
);
$productTypeId = $catalogSetup->getEntityTypeId(Product::ENTITY);
$selectProductAttribute = $connection->select();
$selectProductAttribute
->from(
['ea' => $this->moduleDataSetup->getTable('eav_attribute')],
['attribute_id']
)
->where("`entity_type_id` = '" . $productTypeId . "'")
->where("attribute_code = ?", $attributeCode);
$linkField = $this->linkFieldResolver->getLinkField(ProductInterface::class, 'entity_id');
$productAttributeId = $connection->fetchOne($selectProductAttribute);
if (is_numeric($productAttributeId)) {
$productAttributeValueInsert =
$this->moduleDataSetup->getConnection()
->select()
->from(
['e1' => $this->moduleDataSetup->getTable('catalog_product_entity')],
array_merge(
$attributeTableFieldsProduct,
[
'value_id' => new \Zend_Db_Expr('NULL'),
'attribute_id' => new \Zend_Db_Expr($productAttributeId),
'store_id' => new \Zend_Db_Expr(Store::DEFAULT_STORE_ID),
$linkField => 'e1.' . $linkField,
'value' => new \Zend_Db_Expr(
self::IN_SITEMAP_HTML_DEFAULT_VALUE
),
]
)
)
->where(
'e1.' . $linkField . ' NOT IN(' . new \Zend_Db_Expr(
"SELECT `" . $linkField . "` FROM " . $this->moduleDataSetup->getTable(
'catalog_product_entity_int'
) .
" WHERE `store_id` = 0 AND `attribute_id` = " . $productAttributeId . ")"
)
)
->order(
['e1.' . $linkField],
\Magento\Framework\DB\Select::SQL_ASC
)
->insertFromSelect(
$this->moduleDataSetup->getTable('catalog_product_entity_int')
);
$this->moduleDataSetup->run($productAttributeValueInsert);
}
$catalogSetup->addAttribute(
Category::ENTITY,
$attributeCode,
[
'group' => 'General Information',
'type' => 'int',
'backend' => \Magento\Catalog\Model\Product\Attribute\Backend\Boolean::class,
'frontend' => '',
'label' => 'Include in HTML Sitemap',
'input' => 'select',
'class' => '',
'source' => \Magento\Eav\Model\Entity\Attribute\Source\Boolean::class,
'global' => \Magento\Catalog\Model\ResourceModel\Eav\Attribute::SCOPE_STORE,
'visible' => true,
'required' => false,
'user_defined' => false,
'default' => self::IN_SITEMAP_HTML_DEFAULT_VALUE,
'apply_to' => '',
'visible_on_front' => false,
'sort_order' => 9,
'note' => 'This setting was added by MageWorx HTML Sitemap'
]
);
$categoryTypeId = $catalogSetup->getEntityTypeId(Category::ENTITY);
$selectCategoryAttribute = $connection->select();
$selectCategoryAttribute
->from(
['ea' => $this->moduleDataSetup->getTable('eav_attribute')],
['attribute_id']
)
->where("`entity_type_id` = '" . $categoryTypeId . "'")
->where("attribute_code = ?", $attributeCode);
$categoryLinkField = $this->linkFieldResolver->getLinkField(CategoryInterface::class, 'entity_id');
$categoryAttributeId = $connection->fetchOne($selectCategoryAttribute);
if (is_numeric($categoryAttributeId)) {
$itemsInsert =
$connection->select()
->from(
['e1' => $this->moduleDataSetup->getTable('catalog_category_entity')],
array_merge(
$attributeTableFieldsCategory,
[
'value_id' => new \Zend_Db_Expr('NULL'),
'attribute_id' => new \Zend_Db_Expr($categoryAttributeId),
'store_id' => new \Zend_Db_Expr(Store::DEFAULT_STORE_ID),
$categoryLinkField => 'e1.' . $categoryLinkField,
'value' => new \Zend_Db_Expr(self::IN_SITEMAP_HTML_DEFAULT_VALUE),
]
)
)
->where(
'e1.' . $categoryLinkField . ' NOT IN(' . new \Zend_Db_Expr(
"SELECT `" . $categoryLinkField . "` FROM " . $this->moduleDataSetup->getTable(
'catalog_category_entity_int'
) .
" WHERE `store_id` = 0 AND `attribute_id` = " . $categoryAttributeId . ")"
)
)
->order(['e1.' . $categoryLinkField], \Magento\Framework\DB\Select::SQL_ASC)
->insertFromSelect(
$this->moduleDataSetup->getTable('catalog_category_entity_int')
);
$this->moduleDataSetup->run($itemsInsert);
}
}
/**
* {@inheritdoc}
*/
public static function getDependencies()
{
return [];
}
/**
* {@inheritdoc}
*/
public function getAliases()
{
return [];
}
public static function getVersion()
{
return '1.0.0';
}
}