TrxShell [ woocommerce.addifypro.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
Smarty	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
cache	[ DIR ]	drwxr-xr-x
checkout	[ DIR ]	drwxr-xr-x
container	[ DIR ]	drwxr-xr-x
controller	[ DIR ]	drwxr-xr-x
db	[ DIR ]	drwxr-xr-x
exception	[ DIR ]	drwxr-xr-x
form	[ DIR ]	drwxr-xr-x
helper	[ DIR ]	drwxr-xr-x
lang	[ DIR ]	drwxr-xr-x
log	[ DIR ]	drwxr-xr-x
module	[ DIR ]	drwxr-xr-x
order	[ DIR ]	drwxr-xr-x
pdf	[ DIR ]	drwxr-xr-x
product	[ DIR ]	drwxr-xr-x
proxy	[ DIR ]	drwxr-xr-x
range	[ DIR ]	drwxr-xr-x
shop	[ DIR ]	drwxr-xr-x
stock	[ DIR ]	drwxr-xr-x
tax	[ DIR ]	drwxr-xr-x
tree	[ DIR ]	drwxr-xr-x
webservice	[ DIR ]	drwxr-xr-x
.htaccess	170 B	-rw-r--r--
.mad-root	0 B	-rw-r--r--
Access.php	13.25 KB	-rw-r--r--
Address.php	21.03 KB	-rw-r--r--
AddressChecksumCore.php	1.81 KB	-rw-r--r--
AddressFormat.php	24.54 KB	-rw-r--r--
Alias.php	4.99 KB	-rw-r--r--
Attachment.php	11.27 KB	-rw-r--r--
AttributeGroup.php	13.17 KB	-rw-r--r--
CMS.php	11.45 KB	-rw-r--r--
CMSCategory.php	23.56 KB	-rw-r--r--
CMSRole.php	1.78 KB	-rw-r--r--
CSV.php	3.04 KB	-rw-r--r--
Carrier.php	63.97 KB	-rw-r--r--
Cart.php	211.83 KB	-rw-r--r--
CartRule.php	89.84 KB	-rw-r--r--
Category.php	87 KB	-rw-r--r--
Chart.php	4.08 KB	-rw-r--r--
ChecksumInterface.php	1.22 KB	-rw-r--r--
Combination.php	17.59 KB	-rw-r--r--
Configuration.php	26.5 KB	-rw-r--r--
ConfigurationKPI.php	8.91 KB	-rw-r--r--
ConfigurationTest.php	12.02 KB	-rw-r--r--
Connection.php	10.02 KB	-rw-r--r--
ConnectionsSource.php	4.81 KB	-rw-r--r--
Contact.php	3.83 KB	-rw-r--r--
Context.php	17.94 KB	-rw-r--r--
Cookie.php	17.39 KB	-rw-r--r--
Country.php	16.33 KB	-rw-r--r--
Currency.php	36.3 KB	-rw-r--r--
Curve.php	2.92 KB	-rw-r--r--
Customer.php	52.22 KB	-rw-r--r--
CustomerAddress.php	1.26 KB	-rw-r--r--
CustomerMessage.php	5.75 KB	-rw-r--r--
CustomerSession.php	2.65 KB	-rw-r--r--
CustomerThread.php	9.62 KB	-rw-r--r--
Customization.php	13.43 KB	-rw-r--r--
CustomizationField.php	2.85 KB	-rw-r--r--
DateRange.php	2.47 KB	-rw-r--r--
Delivery.php	3.24 KB	-rw-r--r--
Dispatcher.php	46.94 KB	-rw-r--r--
Employee.php	23.5 KB	-rw-r--r--
EmployeeSession.php	2.65 KB	-rw-r--r--
Feature.php	11.38 KB	-rw-r--r--
FeatureFlag.php	3.15 KB	-rw-r--r--
FeatureValue.php	8.06 KB	-rw-r--r--
FileUploader.php	3.73 KB	-rw-r--r--
Gender.php	2.81 KB	-rw-r--r--
Group.php	14.96 KB	-rw-r--r--
GroupReduction.php	8.81 KB	-rw-r--r--
Guest.php	8.31 KB	-rw-r--r--
Hook.php	46.57 KB	-rw-r--r--
Image.php	31.24 KB	-rw-r--r--
ImageManager.php	31.79 KB	-rw-r--r--
ImageType.php	6.99 KB	-rw-r--r--
Language.php	62.06 KB	-rw-r--r--
Link.php	61.05 KB	-rw-r--r--
LocalizationPack.php	23.05 KB	-rw-r--r--
Mail.php	33.49 KB	-rw-r--r--
Manufacturer.php	21.2 KB	-rw-r--r--
ManufacturerAddress.php	1.28 KB	-rw-r--r--
Media.php	31.43 KB	-rw-r--r--
Message.php	6.47 KB	-rw-r--r--
Meta.php	18.21 KB	-rw-r--r--
Notification.php	8.27 KB	-rw-r--r--
ObjectModel.php	81.56 KB	-rw-r--r--
Pack.php	24.63 KB	-rw-r--r--
Page.php	4.49 KB	-rw-r--r--
PaymentFree.php	1.33 KB	-rw-r--r--
PaymentModule.php	59.49 KB	-rw-r--r--
PhpEncryption.php	3.21 KB	-rw-r--r--
PhpEncryptionEngine.php	3.86 KB	-rw-r--r--
PrestaShopAutoload.php	9.57 KB	-rw-r--r--
PrestaShopBackup.php	11.91 KB	-rw-r--r--
PrestaShopCollection.php	21.28 KB	-rw-r--r--
PrestaShopLogger.php	8.3 KB	-rw-r--r--
Product.php	309.01 KB	-rw-r--r--
ProductAssembler.php	6.73 KB	-rw-r--r--
ProductAttribute.php	13.48 KB	-rw-r--r--
ProductDownload.php	10.05 KB	-rw-r--r--
ProductPresenterFactory.php	3.89 KB	-rw-r--r--
ProductSale.php	12.7 KB	-rw-r--r--
ProductSupplier.php	8.34 KB	-rw-r--r--
Profile.php	8.32 KB	-rw-r--r--
QqUploadedFileForm.php	5.19 KB	-rw-r--r--
QqUploadedFileXhr.php	5.69 KB	-rw-r--r--
QuickAccess.php	6.25 KB	-rw-r--r--
RequestSql.php	20.93 KB	-rw-r--r--
Risk.php	2.36 KB	-rw-r--r--
Search.php	51.86 KB	-rw-r--r--
SearchEngine.php	2.81 KB	-rw-r--r--
SpecificPrice.php	32.43 KB	-rw-r--r--
SpecificPriceRule.php	14.04 KB	-rw-r--r--
State.php	7.77 KB	-rw-r--r--
Store.php	6.24 KB	-rw-r--r--
Supplier.php	17.89 KB	-rw-r--r--
SupplierAddress.php	1.27 KB	-rw-r--r--
Tab.php	21.7 KB	-rw-r--r--
Tag.php	13.24 KB	-rw-r--r--
Tools.php	136.37 KB	-rw-r--r--
Translate.php	11.78 KB	-rw-r--r--
TranslatedConfiguration.php	4.68 KB	-rw-r--r--
Upgrader.php	11.58 KB	-rw-r--r--
Uploader.php	10.84 KB	-rw-r--r--
Validate.php	38.87 KB	-rw-r--r--
ValidateConstraintTranslator.p...	2.55 KB	-rw-r--r--
WarehouseAddress.php	1.27 KB	-rw-r--r--
Zone.php	3.42 KB	-rw-r--r--
index.php	1.34 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : Tag.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)
 */

/**
 * Class TagCore.
 */
class TagCore extends ObjectModel
{
    /** @var int Language id */
    public $id_lang;

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

/**
     * @see ObjectModel::$definition
     */
    public static $definition = [
        'table' => 'tag',
        'primary' => 'id_tag',
        'fields' => [
            'id_lang' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true],
            'name' => ['type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'required' => true, 'size' => 32],
        ],
    ];

protected $webserviceParameters = [
        'fields' => [
            'id_lang' => ['xlink_resource' => 'languages'],
        ],
    ];

public function __construct($id = null, $name = null, $idLang = null)
    {
        $this->def = Tag::getDefinition($this);
        $this->setDefinitionRetrocompatibility();

if ($id) {
            parent::__construct($id);
        } elseif ($name && Validate::isGenericName($name) && $idLang && Validate::isUnsignedId($idLang)) {
            $row = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
            SELECT *
            FROM `' . _DB_PREFIX_ . 'tag` t
            WHERE `name` = \'' . pSQL($name) . '\' AND `id_lang` = ' . (int) $idLang);

if ($row) {
                $this->id = (int) $row['id_tag'];
                $this->id_lang = (int) $row['id_lang'];
                $this->name = $row['name'];
            }
        }
    }

public function add($autoDate = true, $nullValues = false)
    {
        if (!parent::add($autoDate, $nullValues)) {
            return false;
        } elseif (isset($_POST['products'])) {
            return $this->setProducts(Tools::getValue('products'));
        }

return true;
    }

/**
     * @return bool
     */
    public function delete()
    {
        if (!parent::delete()) {
            return false;
        }

Search::removeProductsSearchIndex(array_column($this->getProducts(), 'id_product'));

return true;
    }

/**
     * Add several tags in database and link it to a product.
     *
     * @param int $idLang Language id
     * @param int $idProduct Product id to link tags with
     * @param string|array $tagList List of tags, as array or as a string with comas
     *
     * @return bool Operation success
     */
    public static function addTags($idLang, $idProduct, $tagList, $separator = ',')
    {
        if (!Validate::isUnsignedId($idLang)) {
            return false;
        }

if (!is_array($tagList)) {
            $tagList = array_filter(array_unique(array_map('trim', preg_split('#\\' . $separator . '#', $tagList, 0, PREG_SPLIT_NO_EMPTY))));
        }

$list = [];
        if (is_array($tagList)) {
            foreach ($tagList as $tag) {
                if (!Validate::isGenericName($tag)) {
                    return false;
                }
                $tagMaxLength = self::$definition['fields']['name']['size'];
                $tag = trim(Tools::substr(trim($tag), 0, $tagMaxLength));
                $tagObj = new Tag(null, $tag, (int) $idLang);

/* Tag does not exist in database */
                if (!Validate::isLoadedObject($tagObj)) {
                    $tagObj->name = $tag;
                    $tagObj->id_lang = (int) $idLang;
                    $tagObj->add();
                }
                if (!in_array($tagObj->id, $list)) {
                    $list[] = $tagObj->id;
                }
            }
        }

$data = [];
        foreach ($list as $tag) {
            $data[] = [
                'id_tag' => (int) $tag,
                'id_product' => (int) $idProduct,
                'id_lang' => (int) $idLang,
            ];
        }
        $result = Db::getInstance()->insert('product_tag', $data);

if ($list != []) {
            self::updateTagCount($list);
        }

return $result;
    }

/**
     * Update tag count.
     *
     * @param array|null $tagList
     */
    public static function updateTagCount($tagList = null)
    {
        if (!Module::getBatchMode()) {
            if ($tagList != null) {
                $tagListQuery = ' AND pt.id_tag IN (' . implode(',', array_map('intval', $tagList)) . ')';
                Db::getInstance()->execute('DELETE pt FROM `' . _DB_PREFIX_ . 'tag_count` pt WHERE 1=1 ' . $tagListQuery);
            } else {
                $tagListQuery = '';
            }

Db::getInstance()->execute('REPLACE INTO `' . _DB_PREFIX_ . 'tag_count` (id_group, id_tag, id_lang, id_shop, counter)
            SELECT cg.id_group, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times
                FROM `' . _DB_PREFIX_ . 'product_tag` pt
                INNER JOIN `' . _DB_PREFIX_ . 'product_shop` product_shop
                    USING (id_product)
                JOIN (SELECT DISTINCT id_group FROM `' . _DB_PREFIX_ . 'category_group`) cg
                WHERE product_shop.`active` = 1
                AND EXISTS(SELECT 1 FROM `' . _DB_PREFIX_ . 'category_product` cp
                                LEFT JOIN `' . _DB_PREFIX_ . 'category_group` cgo ON (cp.`id_category` = cgo.`id_category`)
                                WHERE cgo.`id_group` = cg.id_group AND product_shop.`id_product` = cp.`id_product`)
                ' . $tagListQuery . '
                GROUP BY pt.id_tag, pt.id_lang, cg.id_group, id_shop ORDER BY NULL');
            Db::getInstance()->execute('REPLACE INTO `' . _DB_PREFIX_ . 'tag_count` (id_group, id_tag, id_lang, id_shop, counter)
            SELECT 0, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times
                FROM `' . _DB_PREFIX_ . 'product_tag` pt
                INNER JOIN `' . _DB_PREFIX_ . 'product_shop` product_shop
                    USING (id_product)
                WHERE product_shop.`active` = 1
                ' . $tagListQuery . '
                GROUP BY pt.id_tag, pt.id_lang, id_shop ORDER BY NULL');
        }
    }

/**
     * Get main tags.
     *
     * @param int $idLang Language ID
     * @param int $nb number
     *
     * @return array|false|mysqli_result|PDOStatement|resource|null
     */
    public static function getMainTags($idLang, $nb = 10)
    {
        $context = Context::getContext();
        if (Group::isFeatureActive()) {
            $groups = FrontController::getCurrentCustomerGroups();

return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
            SELECT t.name, counter AS times
            FROM `' . _DB_PREFIX_ . 'tag_count` pt
            LEFT JOIN `' . _DB_PREFIX_ . 'tag` t ON (t.id_tag = pt.id_tag)
            WHERE pt.`id_group` ' . (count($groups) ? 'IN (' . implode(',', $groups) . ')' : '=' . (int) Group::getCurrent()->id) . '
            AND pt.`id_lang` = ' . (int) $idLang . ' AND pt.`id_shop` = ' . (int) $context->shop->id . '
            ORDER BY times DESC
            LIMIT ' . (int) $nb);
        } else {
            return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
            SELECT t.name, counter AS times
            FROM `' . _DB_PREFIX_ . 'tag_count` pt
            LEFT JOIN `' . _DB_PREFIX_ . 'tag` t ON (t.id_tag = pt.id_tag)
            WHERE pt.id_group = 0 AND pt.`id_lang` = ' . (int) $idLang . ' AND pt.`id_shop` = ' . (int) $context->shop->id . '
            ORDER BY times DESC
            LIMIT ' . (int) $nb);
        }
    }

/**
     * Get Product Tags.
     *
     * @param int $idProduct Product ID
     *
     * @return array|bool
     */
    public static function getProductTags($idProduct)
    {
        if (!$tmp = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
        SELECT t.`id_lang`, t.`name`
        FROM ' . _DB_PREFIX_ . 'tag t
        LEFT JOIN ' . _DB_PREFIX_ . 'product_tag pt ON (pt.id_tag = t.id_tag)
        WHERE pt.`id_product`=' . (int) $idProduct)) {
            return false;
        }
        $result = [];
        foreach ($tmp as $tag) {
            $result[$tag['id_lang']][] = $tag['name'];
        }

return $result;
    }

/**
     * Get Products.
     *
     * @param bool $associated
     * @param Context|null $context
     *
     * @return array|false|mysqli_result|PDOStatement|resource|null
     */
    public function getProducts($associated = true, Context $context = null)
    {
        if (!$context) {
            $context = Context::getContext();
        }
        $idLang = $this->id_lang ? $this->id_lang : $context->language->id;

if (!$this->id && $associated) {
            return [];
        }

$in = $associated ? 'IN' : 'NOT IN';
        // select not only active products when we are getting list of already associated products
        // to avoid confusion when product is disabled, but still has the tag assigned
        $onlyActive = $associated ? '' : 'AND product_shop.active = 1';

return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
        SELECT pl.name, pl.id_product
        FROM `' . _DB_PREFIX_ . 'product` p
        LEFT JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON p.id_product = pl.id_product' . Shop::addSqlRestrictionOnLang('pl') . '
        ' . Shop::addSqlAssociation('product', 'p') . '
        WHERE pl.id_lang = ' . (int) $idLang .
        ' ' . $onlyActive . ' ' .
        ($this->id ? ('AND p.id_product ' . $in . ' (SELECT pt.id_product FROM `' . _DB_PREFIX_ . 'product_tag` pt WHERE pt.id_tag = ' . (int) $this->id . ')') : '') . '
        ORDER BY pl.name');
    }

/**
     * Set products.
     *
     * @param array $array
     *
     * @return bool
     */
    public function setProducts($array)
    {
        $result = Db::getInstance()->delete('product_tag', 'id_tag = ' . (int) $this->id);
        if (is_array($array)) {
            $array = array_map('intval', $array);
            $result = $result && ObjectModel::updateMultishopTable('Product', ['indexed' => 0], 'a.id_product IN (' . implode(',', $array) . ')');

if ($result) {
                $ids = [];
                foreach ($array as $idProduct) {
                    $ids[] = '(' . (int) $idProduct . ',' . (int) $this->id . ',' . (int) $this->id_lang . ')';
                }
                $result = Db::getInstance()->execute('INSERT INTO ' . _DB_PREFIX_ . 'product_tag (id_product, id_tag, id_lang) VALUES ' . implode(',', $ids));
                if (Configuration::get('PS_SEARCH_INDEXATION')) {
                    $result = $result && Search::indexation(false);
                }
            }
        }
        self::updateTagCount([(int) $this->id]);

return $result;
    }

/**
     * Delete tags for product.
     *
     * @param int $idProduct Product ID
     *
     * @return bool
     *
     * @throws PrestaShopDatabaseException
     */
    public static function deleteTagsForProduct($idProduct)
    {
        return self::deleteProductTags($idProduct);
    }

/**
     * Delete tags for product in specific language
     *
     * @param int $productId
     * @param int $langId
     *
     * @return bool
     */
    public static function deleteProductTagsInLang(int $productId, int $langId)
    {
        return self::deleteProductTags($productId, $langId);
    }

/**
     * Deletes product tags.
     *
     * @param int $idProduct
     * @param int|null $langId if provided, only deletes tags in specific language
     *
     * @return bool
     *
     * @throws PrestaShopDatabaseException
     */
    private static function deleteProductTags($idProduct, int $langId = null)
    {
        $removeWhere = 'id_product = ' . (int) $idProduct;
        $selectTagsToRemove = '
            SELECT id_tag FROM ' . _DB_PREFIX_ . 'product_tag
            WHERE id_product=' . (int) $idProduct
        ;
        if ($langId) {
            $removeWhere .= ' AND id_lang =' . $langId;
            $selectTagsToRemove .= ' AND id_lang =' . $langId;
        }

$tagsRemoved = Db::getInstance()->executeS($selectTagsToRemove);
        $result = Db::getInstance()->delete('product_tag', $removeWhere);
        Db::getInstance()->delete('tag', 'NOT EXISTS (SELECT 1 FROM ' . _DB_PREFIX_ . 'product_tag
        												WHERE ' . _DB_PREFIX_ . 'product_tag.id_tag = ' . _DB_PREFIX_ . 'tag.id_tag)');
        $tagList = [];
        foreach ($tagsRemoved as $tagRemoved) {
            $tagList[] = $tagRemoved['id_tag'];
        }
        if ($tagList != []) {
            self::updateTagCount($tagList);
        }

return $result;
    }
}

${this.title}

Code Editor : Tag.php