Symfony Profiler

<?php
/**
* Pimcore
*
* This source file is available under two different licenses:
* - GNU General Public License version 3 (GPLv3)
* - Pimcore Commercial License (PCL)
* Full copyright and license information is available in
* LICENSE.md which is distributed with this source code.
*
* @copyright Copyright (c) Pimcore GmbH (http://www.pimcore.org)
* @license http://www.pimcore.org/license GPLv3 and PCL
*/
namespace Pimcore\Bundle\EcommerceFrameworkBundle\IndexService\ProductList;
use Monolog\Logger;
use Pimcore\Bundle\EcommerceFrameworkBundle\CoreExtensions\ObjectData\IndexFieldSelection;
use Pimcore\Bundle\EcommerceFrameworkBundle\Factory;
use Pimcore\Bundle\EcommerceFrameworkBundle\IndexService\Config\MysqlConfigInterface;
use Pimcore\Bundle\EcommerceFrameworkBundle\Model\AbstractCategory;
use Pimcore\Bundle\EcommerceFrameworkBundle\Model\IndexableInterface;
/**
* Implementation of product list which works based on the product index of the online shop framework
*/
class DefaultMysql implements ProductListInterface
{
/**
* @var null|IndexableInterface[]
*/
protected $products = null;
/**
* @var string
*/
protected $tenantName;
/**
* @var MysqlConfigInterface
*/
protected $tenantConfig;
/**
* @var null|int
*/
protected $totalCount = null;
/**
* @var string
*/
protected $variantMode = ProductListInterface::VARIANT_MODE_INCLUDE;
/**
* @var int
*/
protected $limit;
/**
* @var int
*/
protected $offset;
/**
* @var AbstractCategory
*/
protected $category;
/**
* @var DefaultMysql\Dao|null
*/
protected $resource;
/**
* @var bool
*/
protected $inProductList = true;
/**
* @var Logger
*/
protected $logger;
public function __construct(MysqlConfigInterface $tenantConfig)
{
$this->tenantName = $tenantConfig->getTenantName();
$this->tenantConfig = $tenantConfig;
$this->logger = \Pimcore::getContainer()->get('monolog.logger.pimcore_ecommerce_sql');
$this->resource = new DefaultMysql\Dao($this, $this->logger);
}
/** @inheritDoc */
public function getProducts()
{
if ($this->products === null) {
$this->load();
}
return $this->products;
}
/**
* @var array
*/
protected $conditions = [];
/**
* @var array<string[]>
*/
protected $relationConditions = [];
/**
* @var string[][]
*/
protected $queryConditions = [];
/**
* @var float|null
*/
protected $conditionPriceFrom = null;
/**
* @var float|null
*/
protected $conditionPriceTo = null;
/**
* @param array|string $condition
* @param string $fieldname
*/
public function addCondition($condition, $fieldname = '')
{
$this->products = null;
$this->conditions[$fieldname][] = $condition;
}
public function resetCondition($fieldname)
{
$this->products = null;
unset($this->conditions[$fieldname]);
}
/**
* @param string $fieldname
* @param string $condition
*/
public function addRelationCondition($fieldname, $condition)
{
$this->products = null;
$this->relationConditions[$fieldname][] = '`fieldname` = ' . $this->quote($fieldname) . ' AND ' . $condition;
}
/**
* resets all conditions of product list
*/
public function resetConditions()
{
$this->conditions = [];
$this->relationConditions = [];
$this->queryConditions = [];
$this->conditionPriceFrom = null;
$this->conditionPriceTo = null;
$this->products = null;
}
/**
* Adds query condition to product list for fulltext search
* Fieldname is optional but highly recommended - needed for resetting condition based on fieldname
* and exclude functionality in group by results
*
* @param string $condition
* @param string $fieldname
*/
public function addQueryCondition($condition, $fieldname = '')
{
$this->products = null;
$this->queryConditions[$fieldname][] = $condition;
}
/**
* Reset query condition for fieldname
*
* @param string $fieldname
*/
public function resetQueryCondition($fieldname)
{
$this->products = null;
unset($this->queryConditions[$fieldname]);
}
/**
* @param null|float $from
* @param null|float $to
*/
public function addPriceCondition($from = null, $to = null)
{
$this->products = null;
$this->conditionPriceFrom = $from;
$this->conditionPriceTo = $to;
}
/**
* @param bool $inProductList
*/
public function setInProductList($inProductList)
{
$this->products = null;
$this->inProductList = $inProductList;
}
/**
* @return bool
*/
public function getInProductList()
{
return $this->inProductList;
}
protected $order;
/**
* @var string | array
*/
protected $orderKey;
protected $orderByPrice = false;
public function setOrder($order)
{
$this->products = null;
$this->order = $order;
}
public function getOrder()
{
return $this->order;
}
/**
* @param string|array $orderKey either single field name, or array of field names or array of arrays (field name, direction)
*/
public function setOrderKey($orderKey)
{
$this->products = null;
if ($orderKey == ProductListInterface::ORDERKEY_PRICE) {
$this->orderByPrice = true;
} else {
$this->orderByPrice = false;
}
$this->orderKey = $orderKey;
}
public function getOrderKey()
{
return $this->orderKey;
}
public function setLimit($limit)
{
if ($this->limit != $limit) {
$this->products = null;
}
$this->limit = $limit;
}
public function getLimit()
{
return $this->limit;
}
public function setOffset($offset)
{
if ($this->offset != $offset) {
$this->products = null;
}
$this->offset = $offset;
}
public function getOffset()
{
return $this->offset;
}
public function setCategory(AbstractCategory $category)
{
$this->products = null;
$this->category = $category;
}
public function getCategory()
{
return $this->category;
}
public function setVariantMode($variantMode)
{
$this->products = null;
$this->variantMode = $variantMode;
}
public function getVariantMode()
{
return $this->variantMode;
}
public function load()
{
$objectRaws = [];
//First case: no price filtering and no price sorting
if (!$this->orderByPrice && $this->conditionPriceFrom === null && $this->conditionPriceTo === null) {
$objectRaws = $this->loadWithoutPriceFilterWithoutPriceSorting();
}
//Second case: no price filtering but price sorting
elseif ($this->orderByPrice && $this->conditionPriceFrom === null && $this->conditionPriceTo === null) {
$objectRaws = $this->loadWithoutPriceFilterWithPriceSorting();
}
//Third case: price filtering but no price sorting
elseif (!$this->orderByPrice && ($this->conditionPriceFrom !== null || $this->conditionPriceTo !== null)) {
$objectRaws = $this->loadWithPriceFilterWithoutPriceSorting();
}
//Forth case: price filtering and price sorting
elseif ($this->orderByPrice && ($this->conditionPriceFrom !== null || $this->conditionPriceTo !== null)) {
$objectRaws = $this->loadWithPriceFilterWithPriceSorting();
}
$this->products = [];
foreach ($objectRaws as $raw) {
$product = $this->loadElementById($raw['o_id']);
if ($product) {
$this->products[] = $product;
}
}
return $this->products;
}
/**
* First case: no price filtering and no price sorting
*
* @return array
*/
protected function loadWithoutPriceFilterWithoutPriceSorting()
{
$objectRaws = $this->resource->load($this->buildQueryFromConditions(), $this->buildOrderBy(), $this->getLimit(), $this->getOffset());
$this->totalCount = $this->resource->getLastRecordCount();
return $objectRaws;
}
/**
* Second case: no price filtering but price sorting
*
* @return array
*
* @throws \Exception
*
* @todo Not implemented yet
*/
protected function loadWithoutPriceFilterWithPriceSorting()
{
$objectRaws = $this->resource->load($this->buildQueryFromConditions());
$this->totalCount = $this->resource->getLastRecordCount();
$priceSystemArrays = [];
foreach ($objectRaws as $raw) {
$priceSystemArrays[$raw['priceSystemName']][] = $raw['o_id'];
}
if (count($priceSystemArrays) == 1) {
$priceSystemName = key($priceSystemArrays);
$priceSystem = Factory::getInstance()->getPriceSystem($priceSystemName);
$objectRaws = $priceSystem->filterProductIds($priceSystemArrays[$priceSystemName], null, null, $this->order, $this->getOffset(), $this->getLimit());
} elseif (count($priceSystemArrays) == 0) {
//nothing to do
} else {
throw new \Exception('Not implemented yet - multiple pricing systems are not supported yet');
}
return $objectRaws;
}
/**
* Third case: price filtering but no price sorting
*
* @return array
*
* @throws \Exception
*
* @todo Not implemented yet
*/
protected function loadWithPriceFilterWithoutPriceSorting()
{
//check number of price systems
//set $this->totalCount
throw new \Exception('Not implemented yet');
}
/**
* Forth case: price filtering and price sorting
*
* @return array
*
* @throws \Exception
*
* @todo Not implemented yet
*/
protected function loadWithPriceFilterWithPriceSorting()
{
//check number of price systems
//set $this->totalCount
throw new \Exception('Not implemented yet');
}
/**
* loads element by id
*
* @param int $elementId
*
* @return IndexableInterface|null
*/
protected function loadElementById($elementId)
{
return $this->getCurrentTenantConfig()->getObjectMockupById($elementId);
}
/**
* prepares all group by values for given field names and cache them in local variable
* considers both - normal values and relation values
*
* @param string $fieldname
*
* @return void
*/
public function prepareGroupByValues($fieldname, $countValues = false, $fieldnameShouldBeExcluded = true)
{
// not supported with mysql tables
}
/**
* resets all set prepared group by values
*
* @return void
*/
public function resetPreparedGroupByValues()
{
// not supported with mysql tables
}
/**
* prepares all group by values for given field names and cache them in local variable
* considers both - normal values and relation values
*
* @param string $fieldname
*
* @return void
*/
public function prepareGroupByRelationValues($fieldname, $countValues = false, $fieldnameShouldBeExcluded = true)
{
// not supported with mysql tables
}
/**
* prepares all group by values for given field names and cache them in local variable
* considers both - normal values and relation values
*
* @param string $fieldname
*
* @return void
*/
public function prepareGroupBySystemValues($fieldname, $countValues = false, $fieldnameShouldBeExcluded = true)
{
// not supported with mysql tables
}
/**
* loads group by values based on relation fieldname either from local variable if prepared or directly from product index
*
* @param string $fieldname
* @param bool $countValues
* @param bool $fieldnameShouldBeExcluded => set to false for and-conditions
*
* @return array
*
* @throws \Exception
*/
public function getGroupBySystemValues($fieldname, $countValues = false, $fieldnameShouldBeExcluded = true)
{
// not supported with mysql tables
return [];
}
/**
* @param string $fieldname
* @param bool $countValues
* @param bool $fieldnameShouldBeExcluded => set to false for and-conditions
*
* @return array
*
* @throws \Exception
*/
public function getGroupByValues($fieldname, $countValues = false, $fieldnameShouldBeExcluded = true)
{
$excludedFieldName = $fieldname;
if (!$fieldnameShouldBeExcluded) {
$excludedFieldName = null;
}
if ($this->conditionPriceFrom === null && $this->conditionPriceTo === null) {
return $this->resource->loadGroupByValues($fieldname, $this->buildQueryFromConditions(false, $excludedFieldName, $this->getVariantMode()), $countValues);
} else {
throw new \Exception('Not supported yet');
}
}
/**
* @param string $fieldname
* @param bool $countValues
* @param bool $fieldnameShouldBeExcluded => set to false for and-conditions
*
* @return array
*
* @throws \Exception
*/
public function getGroupByRelationValues($fieldname, $countValues = false, $fieldnameShouldBeExcluded = true)
{
$excludedFieldName = $fieldname;
if (!$fieldnameShouldBeExcluded) {
$excludedFieldName = null;
}
if ($this->conditionPriceFrom === null && $this->conditionPriceTo === null) {
return $this->resource->loadGroupByRelationValues($fieldname, $this->buildQueryFromConditions(false, $excludedFieldName), $countValues);
} else {
throw new \Exception('Not supported yet');
}
}
protected function buildQueryFromConditions($excludeConditions = false, $excludedFieldname = null, $variantMode = null)
{
if ($variantMode == null) {
$variantMode = $this->getVariantMode();
}
$preCondition = 'active = 1 AND o_virtualProductActive = 1';
if ($this->inProductList) {
$preCondition .= ' AND inProductList = 1';
}
$tenantCondition = $this->getCurrentTenantConfig()->getCondition();
if ($tenantCondition) {
$preCondition .= ' AND ' . $tenantCondition;
}
if ($this->getCategory()) {
$preCondition .= " AND parentCategoryIds LIKE '%," . $this->getCategory()->getId() . ",%'";
}
$condition = $preCondition;
//variant handling and userspecific conditions
switch ($variantMode) {
case ProductListInterface::VARIANT_MODE_INCLUDE_PARENT_OBJECT:
//make sure, that only variant objects are considered
$condition .= ' AND a.o_id != o_virtualProductId ';
break;
case ProductListInterface::VARIANT_MODE_HIDE:
$condition .= " AND o_type != 'variant'";
break;
case ProductListInterface::VARIANT_MODE_VARIANTS_ONLY:
$condition .= " AND o_type = 'variant'";
break;
}
if (!$excludeConditions) {
$userspecific = $this->buildUserspecificConditions($excludedFieldname);
if ($userspecific) {
$condition .= ' AND ' . $userspecific;
}
}
if ($this->queryConditions) {
$searchstring = '';
foreach ($this->queryConditions as $queryConditionPartArray) {
foreach ($queryConditionPartArray as $queryConditionPart) {
//check if there are any mysql special characters in query condition - if so, then quote condition
if (str_replace(['+', '-', '<', '>', '(', ')', '~', '*'], '', $queryConditionPart) != $queryConditionPart) {
$searchstring .= '+"' . $queryConditionPart . '" ';
} else {
$searchstring .= '+' . $queryConditionPart . '* ';
}
}
}
$condition .= ' AND ' . $this->resource->buildFulltextSearchWhere($this->tenantConfig->getSearchAttributes(), $searchstring);
}
$this->logger->info('Total Condition: ' . $condition);
return $condition;
}
protected function buildUserspecificConditions($excludedFieldname = null)
{
$condition = '';
foreach ($this->relationConditions as $fieldname => $condArray) {
if ($fieldname !== $excludedFieldname) {
foreach ($condArray as $cond) {
if ($condition) {
$condition .= ' AND ';
}
$condition .= 'a.o_id IN (SELECT DISTINCT src FROM ' . $this->getCurrentTenantConfig()->getRelationTablename() . ' WHERE ' . $cond . ')';
}
}
}
foreach ($this->conditions as $fieldname => $condArray) {
if ($fieldname !== $excludedFieldname) {
foreach ($condArray as $cond) {
if ($condition) {
$condition .= ' AND ';
}
$condition .= is_array($cond)
? sprintf(' ( %1$s IN (%2$s) )', $fieldname, implode(',', array_map(function ($value) {
return $this->quote($value);
}, $cond)))
: '(' . $cond . ')'
;
}
}
}
$this->logger->info('User specific Condition Part: ' . $condition);
return $condition;
}
protected function buildOrderBy()
{
if (!empty($this->orderKey) && $this->orderKey !== ProductListInterface::ORDERKEY_PRICE) {
$orderKeys = $this->orderKey;
if (!is_array($orderKeys)) {
$orderKeys = [$orderKeys];
}
// add sorting for primary id to prevent mysql paging problem...
$orderKeys[] = 'a.o_id';
$directionOrderKeys = [];
foreach ($orderKeys as $key) {
if (is_array($key)) {
$directionOrderKeys[] = $key;
} else {
$directionOrderKeys[] = [$key, $this->order];
}
}
$orderByStringArray = [];
foreach ($directionOrderKeys as $keyDirection) {
$key = $keyDirection[0];
if ($key instanceof IndexFieldSelection) {
$key = $key->getField();
}
$direction = $keyDirection[1];
if ($this->getVariantMode() == ProductListInterface::VARIANT_MODE_INCLUDE_PARENT_OBJECT) {
if (strtoupper($this->order) == 'DESC') {
$orderByStringArray[] = 'max(' . $key . ') ' . $direction;
} else {
$orderByStringArray[] = 'min(' . $key . ') ' . $direction;
}
} else {
$orderByStringArray[] = $key . ' ' . $direction;
}
}
return implode(',', $orderByStringArray);
}
return null;
}
public function quote($value)
{
return $this->resource->quote($value);
}
/**
* @return MysqlConfigInterface
*/
public function getCurrentTenantConfig()
{
return $this->tenantConfig;
}
/**
* returns order by statement for simularity calculations based on given fields and object ids
* returns cosine simularity calculation
*
* @param array $fields
* @param int $objectId
*
* @return string
*/
public function buildSimularityOrderBy($fields, $objectId)
{
return $this->resource->buildSimularityOrderBy($fields, $objectId);
}
/**
* returns where statement for fulltext search index
*
* @param array $fields
* @param string $searchstring
*
* @return string
*/
public function buildFulltextSearchWhere($fields, $searchstring)
{
return $this->resource->buildFulltextSearchWhere($fields, $searchstring);
}
/**
* -----------------------------------------------------------------------------------------
* Methods for Iterator
* -----------------------------------------------------------------------------------------
*/
/**
* @return int
*/
#[\ReturnTypeWillChange]
public function count()// : int
{
if ($this->totalCount === null) {
$this->totalCount = $this->resource->getCount($this->buildQueryFromConditions());
}
return $this->totalCount;
}
/**
* @return IndexableInterface|false
*/
#[\ReturnTypeWillChange]
public function current()// : IndexableInterface|false
{
$this->getProducts();
return current($this->products);
}
/**
* Returns an collection of items for a page.
*
* @param int $offset Page offset
* @param int $itemCountPerPage Number of items per page
*
* @return array
*/
public function getItems($offset, $itemCountPerPage)
{
$this->setOffset($offset);
$this->setLimit($itemCountPerPage);
return $this->getProducts();
}
/**
* @return int|null
*/
#[\ReturnTypeWillChange]
public function key()// : int|null
{
$this->getProducts();
return key($this->products);
}
/**
* @return void
*/
#[\ReturnTypeWillChange]
public function next()// : void
{
$this->getProducts();
next($this->products);
}
/**
* @return void
*/
#[\ReturnTypeWillChange]
public function rewind()// : void
{
$this->getProducts();
reset($this->products);
}
/**
* @return bool
*/
#[\ReturnTypeWillChange]
public function valid()// : bool
{
return $this->current() !== false;
}
/**
* @return array
*
* @internal
*/
public function __sleep()
{
$vars = get_object_vars($this);
unset($vars['resource']);
unset($vars['products']);
return array_keys($vars);
}
/**
* @internal
*/
public function __wakeup()
{
if (empty($this->resource)) {
$this->logger = \Pimcore::getContainer()->get('monolog.logger.pimcore_ecommerce_sql');
$this->resource = new DefaultMysql\Dao($this, $this->logger);
}
}
/**
* this is needed for ZF1 Paginator
*
* @return string
*/
public function getCacheIdentifier()
{
return uniqid();
}
}

vendor/pimcore/pimcore/bundles/EcommerceFrameworkBundle/IndexService/ProductList/DefaultMysql.php line 780