/home/sharedstore/public_html/prestashop.sharedstore.ma/classes
Edit: /home/sharedstore/public_html/prestashop.sharedstore.ma/classes/ProductAssembler.php (6895B)
* @copyright Since 2007 PrestaShop SA and Contributors
* @license https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
*/
use PrestaShop\PrestaShop\Core\Product\Search\ProductSearchContext;
/**
* Class ProductAssemblerCore.
*/
class ProductAssemblerCore
{
private $context;
private $searchContext;
/**
* ProductAssemblerCore constructor.
*
* @param \Context $context
*/
public function __construct(Context $context)
{
$this->context = $context;
$this->searchContext = new ProductSearchContext($context);
}
/**
* Add missing product fields.
*
* @param array $rawProduct
*
* @return array
*
* @throws PrestaShopDatabaseException
*/
private function addMissingProductFields(array $rawProduct): array
{
// If there is no ID product provided, return the original data
if (empty($rawProduct['id_product'])) {
return $rawProduct;
}
$sql = $this->getSqlQueryProductFields([(int) $rawProduct['id_product']]);
$rows = Db::getInstance()->executeS($sql);
if (empty($rows)) {
return $rawProduct;
}
return array_merge($rows[0], $rawProduct);
}
/**
* Add missing product fields to multiple products
*
* @param array $rawProducts
*
* @return array
*
* @throws PrestaShopDatabaseException
*/
private function addMissingProductFieldsForMultipleProducts(array $rawProducts): array
{
// Get product IDs we want to retrieve from database
$productIds = array_column($rawProducts, 'id_product');
// If there were no product IDs provided or somebody passed an empty array,
// return the original data
if (empty($productIds)) {
return $rawProducts;
}
// Retrieve data and reassign them to new array by their key
$productData = [];
$sql = $this->getSqlQueryProductFields($productIds);
$rows = Db::getInstance()->executeS($sql);
foreach ($rows as $row) {
$productData[(int) $row['id_product']] = $row;
}
// Use this data to enrich the products and return it
foreach ($rawProducts as &$rawProduct) {
if (isset($productData[$rawProduct['id_product']])) {
$rawProduct = array_merge($productData[$rawProduct['id_product']], $rawProduct);
}
}
return $rawProducts;
}
/**
* Return the SQL query to get all product fields
*
* @param array $productIds
*
* @return string
*/
private function getSqlQueryProductFields(array $productIds): string
{
// Get basic configuration
$idShop = $this->searchContext->getIdShop();
$idShopGroup = $this->searchContext->getIdShopGroup();
$isStockSharingBetweenShopGroupEnabled = $this->searchContext->isStockSharingBetweenShopGroupEnabled();
$idLang = $this->searchContext->getIdLang();
$prefix = _DB_PREFIX_;
$nbDaysNewProduct = (int) Configuration::get('PS_NB_DAYS_NEW_PRODUCT');
if (!Validate::isUnsignedInt($nbDaysNewProduct)) {
$nbDaysNewProduct = 20;
}
$now = date('Y-m-d') . ' 00:00:00';
$sql = "SELECT
p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'$now',
INTERVAL $nbDaysNewProduct DAY
)
) > 0) as new
FROM {$prefix}product p
LEFT JOIN {$prefix}product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = $idShop
AND pl.id_lang = $idLang
LEFT JOIN {$prefix}stock_available sa ";
if ($isStockSharingBetweenShopGroupEnabled) {
$sql .= " ON sa.id_product = p.id_product
AND sa.id_shop = 0
AND sa.id_product_attribute = 0
AND sa.id_shop_group = $idShopGroup ";
} else {
$sql .= " ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = $idShop ";
}
$sql .= "LEFT JOIN {$prefix}product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = $idShop
WHERE p.id_product IN (" . implode(',', $productIds) . ')';
return $sql;
}
/**
* Get basic product data for single product.
* The only required property is id_product.
*
* @param array $rawProduct
*
* @return mixed
*
* @throws PrestaShopDatabaseException
*/
public function assembleProduct(array $rawProduct)
{
$enrichedProduct = $this->addMissingProductFields($rawProduct);
return Product::getProductProperties(
$this->searchContext->getIdLang(),
$enrichedProduct,
$this->context
);
}
/**
* Get basic product data for multiple products.
* The only required property for each product is id_product.
*
* @param array $rawProducts Array with multiple products
*
* @return mixed
*
* @throws PrestaShopDatabaseException
*/
public function assembleProducts(array $rawProducts)
{
$enrichedProducts = $this->addMissingProductFieldsForMultipleProducts($rawProducts);
foreach ($enrichedProducts as &$product) {
$product = Product::getProductProperties(
$this->searchContext->getIdLang(),
$product,
$this->context
);
}
return $enrichedProducts;
}
}