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

PATH: home / beestk / provin / classes

<?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 AttachmentCore.
 */
class AttachmentCore extends ObjectModel
{
    public $file;
    public $file_name;
    public $file_size;
    public $name;
    public $mime;
    public $description;

/** @var int position Position */
    public $position;

/**
     * @see ObjectModel::$definition
     */
    public static $definition = [
        'table' => 'attachment',
        'primary' => 'id_attachment',
        'multilang' => true,
        'fields' => [
            'file' => ['type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'required' => true, 'size' => 40],
            'mime' => ['type' => self::TYPE_STRING, 'validate' => 'isCleanHtml', 'required' => true, 'size' => 128],
            'file_name' => ['type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'size' => 128],
            'file_size' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId'],

/* Lang fields */
            'name' => ['type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'required' => true, 'size' => 32],
            'description' => ['type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isCleanHtml'],
        ],
    ];

/**
     * @see ObjectModel::add()
     */
    public function add($autoDate = true, $nullValues = false)
    {
        $this->file_size = filesize(_PS_DOWNLOAD_DIR_ . $this->file);

return parent::add($autoDate, $nullValues);
    }

/**
     * @see ObjectModel::update()
     */
    public function update($nullValues = false)
    {
        $this->file_size = filesize(_PS_DOWNLOAD_DIR_ . $this->file);

return parent::update($nullValues);
    }

/**
     * @see ObjectModel::delete()
     */
    public function delete()
    {
        @unlink(_PS_DOWNLOAD_DIR_ . $this->file);

$sql = new DbQuery();
        $sql->select('pa.`id_product`');
        $sql->from('product_attachment', 'pa');
        $sql->where('pa.`id_attachment` = ' . (int) $this->id);
        $products = Db::getInstance()->executeS($sql);

Db::getInstance()->delete(
            'product_attachment',
            '`id_attachment` = ' . (int) $this->id
        );

foreach ($products as $product) {
            Product::updateCacheAttachment((int) $product['id_product']);
        }

return parent::delete();
    }

/**
     * Delete selection of attachments.
     *
     * @param array $attachments Attachments
     *
     * @return bool|int Whether the selection has been successfully deleted
     * @todo: Find out if $return can be initialized with true. (breaking change)
     */
    public function deleteSelection($attachments)
    {
        $return = 1;
        foreach ($attachments as $idAttachment) {
            $attachment = new Attachment((int) $idAttachment);
            $return &= $attachment->delete();
        }

return $return;
    }

/**
     * Get attachments.
     *
     * @param int $idLang Language ID
     * @param int $idProduct Product ID
     * @param bool $include Whether the attachments are included or excluded from the Product ID
     *
     * @return array|false|mysqli_result|PDOStatement|resource|null Database query result
     */
    public static function getAttachments($idLang, $idProduct, $include = true)
    {
        return Db::getInstance()->executeS(
            '
			SELECT *
			FROM ' . _DB_PREFIX_ . 'attachment a
			LEFT JOIN ' . _DB_PREFIX_ . 'attachment_lang al
				ON (a.id_attachment = al.id_attachment AND al.id_lang = ' . (int) $idLang . ')
			WHERE a.id_attachment ' . ($include ? 'IN' : 'NOT IN') . ' (
				SELECT pa.id_attachment
				FROM ' . _DB_PREFIX_ . 'product_attachment pa
				WHERE id_product = ' . (int) $idProduct . '
			)'
        );
    }

/**
     * Delete Product attachments for the given Product ID.
     *
     * @param int $idProduct Product ID
     *
     * @return bool
     */
    public static function deleteProductAttachments($idProduct)
    {
        $res = Db::getInstance()->execute('
		DELETE FROM ' . _DB_PREFIX_ . 'product_attachment
		WHERE id_product = ' . (int) $idProduct);

Product::updateCacheAttachment((int) $idProduct);

return $res;
    }

/**
     * Associate $id_product to the current object.
     *
     * @param int $idProduct id of the product to associate
     *
     * @return bool true if success
     */
    public function attachProduct($idProduct)
    {
        $res = Db::getInstance()->execute('
			INSERT INTO ' . _DB_PREFIX_ . 'product_attachment
				(id_attachment, id_product) VALUES
				(' . (int) $this->id . ', ' . (int) $idProduct . ')');

Product::updateCacheAttachment((int) $idProduct);

return $res;
    }

/**
     * Associate an array of id_attachment $array to the product $id_product
     * and remove eventual previous association.
     *
     * @param int $idProduct Product ID
     * @param array $array Attachment IDs
     *
     * @return bool Whether the attachments have been successfully associated with the Product
     */
    public static function attachToProduct($idProduct, $array)
    {
        $result1 = Attachment::deleteProductAttachments($idProduct);

if (is_array($array)) {
            $ids = [];
            foreach ($array as $idAttachment) {
                if ((int) $idAttachment > 0) {
                    $ids[] = ['id_product' => (int) $idProduct, 'id_attachment' => (int) $idAttachment];
                }
            }

if (!empty($ids)) {
                $result2 = Db::getInstance()->insert('product_attachment', $ids);
            }
        }

Product::updateCacheAttachment((int) $idProduct);
        if (is_array($array)) {
            return $result1 && (!isset($result2) || $result2);
        }

return $result1;
    }

/**
     * Get Attachment IDs for the given Product within the given range of attachment IDs.
     *
     * @param int $idLang Language ID
     * @param array $list List of attachment IDs in which to search
     *
     * @return array|bool List of attachment IDs found. False if nothing found.
     */
    public static function getProductAttached($idLang, $list)
    {
        $idsAttachments = [];
        if (is_array($list)) {
            foreach ($list as $attachment) {
                $idsAttachments[] = $attachment['id_attachment'];
            }

$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'product_attachment` pa
					LEFT JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (pa.`id_product` = pl.`id_product`' . Shop::addSqlRestrictionOnLang('pl') . ')
					WHERE `id_attachment` IN (' . implode(',', array_map('intval', $idsAttachments)) . ')
						AND pl.`id_lang` = ' . (int) $idLang;
            $tmp = Db::getInstance()->executeS($sql);
            $productAttachments = [];
            foreach ($tmp as $t) {
                $productAttachments[$t['id_attachment']][] = $t['name'];
            }

return $productAttachments;
        } else {
            return false;
        }
    }
}

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