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/aheadworks/module-csblock/Model/Rule/Condition/Product/ |
<?php
namespace Aheadworks\Csblock\Model\Rule\Condition\Product;
use Magento\Catalog\Api\Data\CategoryInterface;
use Magento\Store\Model\ScopeInterface;
/**
* Class Attributes
* @package Aheadworks\Csblock\Model\Rule\Condition\Product
*/
class Attributes extends \Magento\Rule\Model\Condition\Product\AbstractProduct
{
protected $_multiselectOverwrite = [
'eq' => 'mEq',
'neq' => 'mNeq',
'in' => 'finset',
'nin' => 'nfinset',
];
protected $_categoryOverwrite = [
'eq' => 'finset',
'neq' => 'nfinset',
'in' => 'finset',
'nin' => 'nfinset',
];
protected $_storeManager;
/**
* @var \Magento\Framework\EntityManager\MetadataPool
*/
protected $metadataPool;
/**
* @var \Magento\Framework\App\Config\ScopeConfigInterface
*/
protected $scopeConfig;
/**
* @param \Magento\Rule\Model\Condition\Context $context
* @param \Magento\Backend\Helper\Data $backendData
* @param \Magento\Eav\Model\Config $config
* @param \Magento\Catalog\Model\ProductFactory $productFactory
* @param \Magento\Catalog\Api\ProductRepositoryInterface $productRepository
* @param \Magento\Catalog\Model\ResourceModel\Product $productResource
* @param \Magento\Eav\Model\ResourceModel\Entity\Attribute\Set\Collection $attrSetCollection
* @param \Magento\Framework\Locale\FormatInterface $localeFormat
* @param \Magento\Framework\EntityManager\MetadataPool $metadataPool
* @param \Magento\Framework\App\Config\ScopeConfigInterface $scopeConfig
* @param array $data
*/
public function __construct(
\Magento\Rule\Model\Condition\Context $context,
\Magento\Backend\Helper\Data $backendData,
\Magento\Eav\Model\Config $config,
\Magento\Catalog\Model\ProductFactory $productFactory,
\Magento\Catalog\Api\ProductRepositoryInterface $productRepository,
\Magento\Catalog\Model\ResourceModel\Product $productResource,
\Magento\Eav\Model\ResourceModel\Entity\Attribute\Set\Collection $attrSetCollection,
\Magento\Framework\Locale\FormatInterface $localeFormat,
\Magento\Store\Model\StoreManager $storeManager,
\Magento\Framework\EntityManager\MetadataPool $metadataPool,
\Magento\Framework\App\Config\ScopeConfigInterface $scopeConfig,
array $data = []
) {
parent::__construct(
$context,
$backendData,
$config,
$productFactory,
$productRepository,
$productResource,
$attrSetCollection,
$localeFormat,
$data
);
$this->_storeManager = $storeManager;
$this->metadataPool = $metadataPool;
$this->scopeConfig = $scopeConfig;
$this->setType(\Aheadworks\Csblock\Model\Rule\Condition\Product\Attributes::class);
$this->setValue(null);
}
/**
* Prepare child rules option list
*
* @return array
*/
public function getNewChildSelectOptions()
{
$attributes = $this->loadAttributeOptions()->getAttributeOption();
$conditions = [];
foreach ($attributes as $code => $label) {
$conditions[] = ['value' => $this->getType() . '|' . $code, 'label' => $label];
}
return ['value' => $conditions, 'label' => __('Product Attributes')];
}
/**
* @param array $productCollection
* @return $this
*/
public function collectValidatedAttributes($productCollection)
{
$linkField = 'entity_id';
$aliasLinkField = $this->metadataPool->getMetadata(CategoryInterface::class)->getLinkField();
$configPath = \Magento\Config\Model\Config\Backend\Admin\Custom::XML_PATH_CATALOG_FRONTEND_FLAT_CATALOG_PRODUCT;
if (!$this->scopeConfig->getValue($configPath, ScopeInterface::SCOPE_STORE)) {
$linkField = $aliasLinkField;
}
$attribute = $this->getAttributeObject();
$attributeCode = $attribute->getAttributeCode();
if ($attribute->getAttributeCode() == 'category_ids') {
if (!$productCollection->getFlag('aw_csblock_collection_category_joined')) {
$catProductTable = $this->_productResource->getTable('catalog_category_product');
$productCollection
->getSelect()
->joinLeft(
['cat_product' => $catProductTable],
'e.entity_id = cat_product.product_id',
[]
)
->group('e.entity_id')
;
$condition = $this->_prepareSqlCondition("GROUP_CONCAT(cat_product.category_id)", $this->getValue());
$productCollection->getSelect()->having($condition);
$productCollection->setFlag('aw_csblock_collection_category_joined', true);
}
} else {
if ($attribute->isStatic()) {
$condition = $this->_prepareSqlCondition("e.{$attributeCode}", $this->getValue());
$this->_addWhereConditionToCollection($productCollection, $condition);
} else {
$table = $attribute->getBackendTable();
$tableAlias = 'attr_table_' .$attribute->getId();
if (!$productCollection->getFlag("aw_csblock_{$tableAlias}_joined")) {
$productCollection
->getSelect()
->joinLeft(
[$tableAlias => $table],
"e.entity_id = {$tableAlias}.{$linkField}",
null
)
;
$productCollection->setFlag("aw_csblock_{$tableAlias}_joined", true);
}
$conditions = [];
$conditions[] = $this->_productResource->getConnection()->prepareSqlCondition(
"{$tableAlias}.attribute_id",
['eq' => $attribute->getId()]
);
if ($attribute->isScopeGlobal()) {
$conditions[] = $this->_productResource->getConnection()->prepareSqlCondition(
"{$tableAlias}.store_id",
['eq' => 0]
);
} else {
$conditions[] = $this->_productResource->getConnection()->prepareSqlCondition(
"{$tableAlias}.store_id",
[['eq' => $this->_storeManager->getStore()->getId()], ['eq' => 0]]
);
}
$conditions[] = $this->_prepareSqlCondition("{$tableAlias}.value", $this->getValue());
$condition = join(' AND ', $conditions);
$this->_addWhereConditionToCollection($productCollection, $condition);
}
}
return $this;
}
/**
* @param $field
* @param $value
* @return string
* phpcs:disable Magento2.Functions.DiscouragedFunction.Discouraged
*/
protected function _prepareSqlCondition($field, $value)
{
$method = $this->_getMethod();
$callback = $this->_getPrepareValueCallback();
if ($callback) {
$value = call_user_func([$this, $callback], $value);
}
if ($this->getAttributeObject()->getAttributeCode() == 'category_ids'
&& array_key_exists($method, $this->_categoryOverwrite)
) {
$method = $this->_categoryOverwrite[$method];
}
if ($this->getAttributeObject()->getFrontendInput() == 'multiselect'
&& array_key_exists($method, $this->_multiselectOverwrite)
) {
$method = $this->_multiselectOverwrite[$method];
}
if ($method =='in' || $method =='nin' || !is_array($value)) {
$condition = $this->_productResource->getConnection()->prepareSqlCondition(
$field,
[$method => $value]
);
return $condition;
}
if ($method == 'mEq' || $method == 'mNeq') {
$count = 0;
if (is_array($value)) {
$count = count($value);
$value = implode('|', $value);
}
if ($count <= 1) {
$condition = "REGEXP '^{$value}$'";
} else {
/*remove from count value first and last position for regexp */
$centerElementCount = $count - 2;
$centerValue = str_repeat(",*({$value})", $centerElementCount);
$condition = "REGEXP '^({$value}){$centerValue},*({$value})$'";
}
if ($method == 'mNeq') {
$condition = 'NOT ' . $condition;
}
return $field . ' ' . $condition;
}
$conditions = [];
foreach ($value as $item) {
if ($method == 'nfinset') {
$conditions[] = "NOT FIND_IN_SET('{$item}', {$field})";
continue;
}
$conditions[] = $this->_productResource->getConnection()->prepareSqlCondition(
$field,
[$method => $item]
);
}
if ($method == 'nlike' || $method == 'nfinset') {
$condition = join(' AND ', $conditions);
} else {
$condition = join(' OR ', $conditions);
}
return $condition;
}
/**
* Get method for sql condition
*
* @return string
*/
protected function _getMethod()
{
$oppositeOperators = [
'<' => '>=',
'>' => '<=',
'==' => '!=',
'<=' => '>',
'>=' => '<',
'!=' => '==',
'{}' => '!{}',
'!{}' => '{}',
'()' => '!()',
'!()' => '()',
'[]' => '![]',
'![]' => '[]',
];
$operator = $this->getOperator();
if (true !== $this->getTrue()) {
$operator = $oppositeOperators[$operator];
}
$methods = [
'<' => 'lt',
'>' => 'gt',
'==' => 'eq',
'<=' => 'lteq',
'>=' => 'gteq',
'!=' => 'neq',
'{}' => 'like',
'!{}' => 'nlike',
'()' => 'in',
'!()' => 'nin',
'[]' => 'finset',
'![]' => 'nfinset',
];
$method = 'eq';
if (array_key_exists($operator, $methods)) {
$method = $methods[$operator];
}
return $method;
}
/**
* Get callback for prepare values for sql conditions
*
* @return null|string
*/
protected function _getPrepareValueCallback()
{
$callbacks = [
'==' => '_prepareValue',
'<' => '_prepareValue',
'>' => '_prepareValue',
'<=' => '_prepareValue',
'>=' => '_prepareValue',
'!=' => '_prepareValue',
'{}' => '_prepareLikeValue',
'!{}' => '_prepareLikeValue',
'()' => '_prepareValue',
'!()' => '_prepareValue',
'[]' => '_prepareValue',
'![]' => '_prepareValue',
'between' => '_prepareBetweenValue'
];
$operator = $this->getOperator();
$callback = null;
if (array_key_exists($operator, $callbacks)) {
$callback = $callbacks[$operator];
}
return $callback;
}
protected function _prepareValue($value)
{
if (is_string($value)) {
$value = explode(',', $value);
}
if (!is_array($value)) {
$value = [$value];
}
$value = array_map('trim', $value);
return $value;
}
protected function _prepareLikeValue($value)
{
if (is_string($value)) {
$value = explode(',', $value);
}
if (!is_array($value)) {
$value = [$value];
}
$value = array_map('trim', $value);
foreach ($value as $key => $item) {
$value[$key] = '%' . $item . '%';
}
return $value;
}
protected function _addWhereConditionToCollection(&$collection, $condition)
{
if ($this->getAggregator() && $this->getAggregator() === 'all') {
$collection->getSelect()->where($condition);
} else {
$collection->getSelect()->orWhere($condition);
}
}
public function getDefaultOperatorInputByType()
{
if (null === $this->_defaultOperatorInputByType) {
parent::getDefaultOperatorInputByType();
$this->_defaultOperatorInputByType['multiselect'] = ['==', '!=', '()', '!()'];
}
return $this->_defaultOperatorInputByType;
}
}