ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / beestk / savons / classes

<?php
/**
 * 2007-2019 PrestaShop and Contributors
 *
 * 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.txt.
 * 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://www.prestashop.com for more information.
 *
 * @author    PrestaShop SA <contact@prestashop.com>
 * @copyright 2007-2019 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 * International Registered Trademark & Property of PrestaShop SA
 */

/**
 * Class FeatureValueCore.
 */
class FeatureValueCore extends ObjectModel
{
    /** @var int Group id which attribute belongs */
    public $id_feature;

/** @var string Name */
    public $value;

/** @var bool Custom */
    public $custom = 0;

/**
     * @see ObjectModel::$definition
     */
    public static $definition = array(
        'table' => 'feature_value',
        'primary' => 'id_feature_value',
        'multilang' => true,
        'fields' => array(
            'id_feature' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
            'custom' => array('type' => self::TYPE_BOOL, 'validate' => 'isBool'),

/* Lang fields */
            'value' => array('type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'required' => true, 'size' => 255),
        ),
    );

protected $webserviceParameters = array(
        'objectsNodeName' => 'product_feature_values',
        'objectNodeName' => 'product_feature_value',
        'fields' => array(
            'id_feature' => array('xlink_resource' => 'product_features'),
        ),
    );

/**
     * Get all values for a given feature.
     *
     * @param bool $idFeature Feature id
     *
     * @return array Array with feature's values
     */
    public static function getFeatureValues($idFeature)
    {
        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(
            '
			SELECT *
			FROM `' . _DB_PREFIX_ . 'feature_value`
			WHERE `id_feature` = ' . (int) $idFeature
        );
    }

/**
     * Get all values for a given feature and language.
     *
     * @param int $idLang Language id
     * @param bool $idFeature Feature id
     *
     * @return array Array with feature's values
     */
    public static function getFeatureValuesWithLang($idLang, $idFeature, $custom = false)
    {
        return Db::getInstance()->executeS('
			SELECT *
			FROM `' . _DB_PREFIX_ . 'feature_value` v
			LEFT JOIN `' . _DB_PREFIX_ . 'feature_value_lang` vl
				ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = ' . (int) $idLang . ')
			WHERE v.`id_feature` = ' . (int) $idFeature . '
				' . (!$custom ? 'AND (v.`custom` IS NULL OR v.`custom` = 0)' : '') . '
			ORDER BY vl.`value` ASC
		');
    }

/**
     * Get all language for a given value.
     *
     * @param bool $idFeatureValue Feature value id
     *
     * @return array Array with value's languages
     */
    public static function getFeatureValueLang($idFeatureValue)
    {
        return Db::getInstance()->executeS('
			SELECT *
			FROM `' . _DB_PREFIX_ . 'feature_value_lang`
			WHERE `id_feature_value` = ' . (int) $idFeatureValue . '
			ORDER BY `id_lang`
		');
    }

/**
     * Select the good lang in tab.
     *
     * @param array $lang Array with all language
     * @param int $idLang Language id
     *
     * @return string String value name selected
     */
    public static function selectLang($lang, $idLang)
    {
        foreach ($lang as $tab) {
            if ($tab['id_lang'] == $idLang) {
                return $tab['value'];
            }
        }
    }

/**
     * Add FeatureValue from import.
     *
     * @param int $idFeature
     * @param string $value
     * @param null $idProduct
     * @param null $idLang
     * @param bool $custom
     *
     * @return int
     */
    public static function addFeatureValueImport($idFeature, $value, $idProduct = null, $idLang = null, $custom = false)
    {
        $idFeatureValue = false;
        if (null !== $idProduct && $idProduct) {
            $idFeatureValue = Db::getInstance()->getValue('
				SELECT fp.`id_feature_value`
				FROM ' . _DB_PREFIX_ . 'feature_product fp
				INNER JOIN ' . _DB_PREFIX_ . 'feature_value fv USING (`id_feature_value`)
				WHERE fp.`id_feature` = ' . (int) $idFeature . '
				AND fv.`custom` = ' . (int) $custom . '
				AND fp.`id_product` = ' . (int) $idProduct);

if ($custom && $idFeatureValue && null !== $idLang && $idLang) {
                Db::getInstance()->execute('
				UPDATE ' . _DB_PREFIX_ . 'feature_value_lang
				SET `value` = \'' . pSQL($value) . '\'
				WHERE `id_feature_value` = ' . (int) $idFeatureValue . '
				AND `value` != \'' . pSQL($value) . '\'
				AND `id_lang` = ' . (int) $idLang);
            }
        }

if (!$custom) {
            $idFeatureValue = Db::getInstance()->getValue('
				SELECT fv.`id_feature_value`
				FROM ' . _DB_PREFIX_ . 'feature_value fv
				LEFT JOIN ' . _DB_PREFIX_ . 'feature_value_lang fvl ON (fvl.`id_feature_value` = fv.`id_feature_value` AND fvl.`id_lang` = ' . (int) $idLang . ')
				WHERE `value` = \'' . pSQL($value) . '\'
				AND fv.`id_feature` = ' . (int) $idFeature . '
				AND fv.`custom` = 0
				GROUP BY fv.`id_feature_value`');
        }

if ($idFeatureValue) {
            return (int) $idFeatureValue;
        }

// Feature doesn't exist, create it
        $feature_value = new FeatureValue();
        $feature_value->id_feature = (int) $idFeature;
        $feature_value->custom = (bool) $custom;
        $feature_value->value = array_fill_keys(Language::getIDs(false), $value);
        $feature_value->add();

return (int) $feature_value->id;
    }

/**
     * Adds current FeatureValue as a new Object to the database.
     *
     * @param bool $autoDate Automatically set `date_upd` and `date_add` columns
     * @param bool $nullValues Whether we want to use NULL values instead of empty quotes values
     *
     * @return bool Indicates whether the FeatureValue has been successfully added
     *
     * @throws PrestaShopDatabaseException
     * @throws PrestaShopException
     */
    public function add($autoDate = true, $nullValues = false)
    {
        $return = parent::add($autoDate, $nullValues);
        if ($return) {
            Hook::exec('actionFeatureValueSave', array('id_feature_value' => $this->id));
        }

return $return;
    }

/**
     * Updates the current FeatureValue in the database.
     *
     * @param bool $nullValues Whether we want to use NULL values instead of empty quotes values
     *
     * @return bool Indicates whether the FeatureValue has been successfully updated
     *
     * @throws PrestaShopDatabaseException
     * @throws PrestaShopException
     */
    public function update($nullValues = false)
    {
        $return = parent::update($nullValues);
        if ($return) {
            Hook::exec('actionFeatureValueSave', array('id_feature_value' => $this->id));
        }

return $return;
    }

/**
     * Deletes current FeatureValue from the database.
     *
     * @return bool `true` if delete was successful
     *
     * @throws PrestaShopException
     */
    public function delete()
    {
        /* Also delete related products */
        Db::getInstance()->execute(
            '
			DELETE FROM `' . _DB_PREFIX_ . 'feature_product`
			WHERE `id_feature_value` = ' . (int) $this->id
        );
        $return = parent::delete();

if ($return) {
            Hook::exec('actionFeatureValueDelete', array('id_feature_value' => $this->id));
        }

return $return;
    }
}

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