Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php /* * 2007-2017 PrestaShop * * NOTICE OF LICENSE * * This source file is subject to t..
Decoded Output download
<?php
/*
* 2007-2017 PrestaShop
*
* 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:
* http://opensource.org/licenses/osl-3.0.php
* 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 [email protected] 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 http://www.prestashop.com for more information.
*
* @author PrestaShop SA <[email protected]>
* @copyright 2007-2017 PrestaShop SA
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
class ImageCore extends ObjectModel
{
public $id;
/** @var int Image ID */
public $id_image;
/** @var int Product ID */
public $id_product;
/** @var int Position used to order images of the same product */
public $position;
/** @var bool Image is cover */
public $cover;
/** @var string Legend */
public $legend;
/** @var string image extension */
public $image_format = 'jpg';
/** @var string path to index.php file to be copied to new image folders */
public $source_index;
/** @var string image folder */
protected $folder;
/** @var string image path without extension */
protected $existing_path;
/** @var int access rights of created folders (octal) */
protected static $access_rights = 0775;
/**
* @see ObjectModel::$definition
*/
public static $definition = array(
'table' => 'image',
'primary' => 'id_image',
'multilang' => true,
'fields' => array(
'id_product' => array('type' => self::TYPE_INT, 'shop' => 'both', 'validate' => 'isUnsignedId', 'required' => true),
'position' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
'cover' => array('type' => self::TYPE_BOOL, 'allow_null' => true, 'validate' => 'isBool', 'shop' => true),
'legend' => array('type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'size' => 128),
),
);
protected static $_cacheGetSize = array();
public function __construct($id = null, $id_lang = null)
{
parent::__construct($id, $id_lang);
$this->image_dir = _PS_PROD_IMG_DIR_;
$this->source_index = _PS_PROD_IMG_DIR_.'index.php';
}
public function add($autodate = true, $null_values = false)
{
if ($this->position <= 0) {
$this->position = Image::getHighestPosition($this->id_product) + 1;
}
if ($this->cover) {
$this->cover = 1;
} else {
$this->cover = null;
}
return parent::add($autodate, $null_values);
}
public function update($null_values = false)
{
if ($this->cover) {
$this->cover = 1;
} else {
$this->cover = null;
}
return parent::update($null_values);
}
public function delete()
{
if (!parent::delete()) {
return false;
}
if ($this->hasMultishopEntries()) {
return true;
}
if (!$this->deleteProductAttributeImage() || !$this->deleteImage()) {
return false;
}
// update positions
Db::getInstance()->execute('SET @position:=0', false);
Db::getInstance()->execute('UPDATE `'._DB_PREFIX_.'image` SET position=(@position:=@position+1)
WHERE `id_product` = '.(int)$this->id_product.' ORDER BY position ASC');
return true;
}
/**
* Return first image (by position) associated with a product attribute
*
* @param int $id_shop Shop ID
* @param int $id_lang Language ID
* @param int $id_product Product ID
* @param int $id_product_attribute Product Attribute ID
* @return array
*/
public static function getBestImageAttribute($id_shop, $id_lang, $id_product, $id_product_attribute)
{
$cache_id = 'Image::getBestImageAttribute'.'-'.(int)$id_product.'-'.(int)$id_product_attribute.'-'.(int)$id_lang.'-'.(int)$id_shop;
if (!Cache::isStored($cache_id)) {
$row = Db::getInstance()->getRow('
SELECT image_shop.`id_image` id_image, il.`legend`
FROM `'._DB_PREFIX_.'image` i
INNER JOIN `'._DB_PREFIX_.'image_shop` image_shop
ON (i.id_image = image_shop.id_image AND image_shop.id_shop = '.(int)$id_shop.')
INNER JOIN `'._DB_PREFIX_.'product_attribute_image` pai
ON (pai.`id_image` = i.`id_image` AND pai.`id_product_attribute` = '.(int)$id_product_attribute.')
LEFT JOIN `'._DB_PREFIX_.'image_lang` il
ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')
WHERE i.`id_product` = '.(int)$id_product.' ORDER BY i.`position` ASC');
Cache::store($cache_id, $row);
} else {
$row = Cache::retrieve($cache_id);
}
return $row;
}
/**
* Return available images for a product
*
* @param int $id_lang Language ID
* @param int $id_product Product ID
* @param int $id_product_attribute Product Attribute ID
* @return array Images
*/
public static function getImages($id_lang, $id_product, $id_product_attribute = null)
{
$attribute_filter = ($id_product_attribute ? ' AND ai.`id_product_attribute` = '.(int)$id_product_attribute : '');
$sql = 'SELECT *
FROM `'._DB_PREFIX_.'image` i
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image`)';
if ($id_product_attribute) {
$sql .= ' LEFT JOIN `'._DB_PREFIX_.'product_attribute_image` ai ON (i.`id_image` = ai.`id_image`)';
}
$sql .= ' WHERE i.`id_product` = '.(int)$id_product.' AND il.`id_lang` = '.(int)$id_lang.$attribute_filter.'
ORDER BY i.`position` ASC';
return Db::getInstance()->executeS($sql);
}
/**
* Check if a product has an image available
*
* @param int $id_lang Language ID
* @param int $id_product Product ID
* @param int $id_product_attribute Product Attribute ID
* @return bool
*/
public static function hasImages($id_lang, $id_product, $id_product_attribute = null)
{
$attribute_filter = ($id_product_attribute ? ' AND ai.`id_product_attribute` = '.(int)$id_product_attribute : '');
$sql = 'SELECT 1
FROM `'._DB_PREFIX_.'image` i
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image`)';
if ($id_product_attribute) {
$sql .= ' LEFT JOIN `'._DB_PREFIX_.'product_attribute_image` ai ON (i.`id_image` = ai.`id_image`)';
}
$sql .= ' WHERE i.`id_product` = '.(int)$id_product.' AND il.`id_lang` = '.(int)$id_lang.$attribute_filter;
return (bool)Db::getInstance()->getValue($sql);
}
/**
* Return Images
*
* @return array Images
*/
public static function getAllImages()
{
return Db::getInstance()->executeS('
SELECT `id_image`, `id_product`
FROM `'._DB_PREFIX_.'image`
ORDER BY `id_image` ASC');
}
/**
* Return number of images for a product
*
* @param int $id_product Product ID
* @return int number of images
*/
public static function getImagesTotal($id_product)
{
$result = Db::getInstance()->getRow('
SELECT COUNT(`id_image`) AS total
FROM `'._DB_PREFIX_.'image`
WHERE `id_product` = '.(int)$id_product);
return $result['total'];
}
/**
* Return highest position of images for a product
*
* @param int $id_product Product ID
* @return int highest position of images
*/
public static function getHighestPosition($id_product)
{
$result = Db::getInstance()->getRow('
SELECT MAX(`position`) AS max
FROM `'._DB_PREFIX_.'image`
WHERE `id_product` = '.(int)$id_product);
return $result['max'];
}
/**
* Delete product cover
*
* @param int $id_product Product ID
* @return bool result
*/
public static function deleteCover($id_product)
{
if (!Validate::isUnsignedId($id_product)) {
die(Tools::displayError());
}
if (file_exists(_PS_TMP_IMG_DIR_.'product_'.$id_product.'.jpg')) {
unlink(_PS_TMP_IMG_DIR_.'product_'.$id_product.'.jpg');
}
return (Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `cover` = NULL
WHERE `id_product` = '.(int)$id_product
) &&
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image_shop` image_shop
SET image_shop.`cover` = NULL
WHERE image_shop.id_shop IN ('.implode(',', array_map('intval', Shop::getContextListShopID())).') AND image_shop.`id_product` = '.(int)$id_product
));
}
/**
*Get product cover
*
* @param int $id_product Product ID
* @return bool result
*/
public static function getCover($id_product)
{
return Db::getInstance()->getRow('
SELECT * FROM `'._DB_PREFIX_.'image_shop` image_shop
WHERE image_shop.`id_product` = '.(int)$id_product.'
AND image_shop.`cover`= 1');
}
/**
*Get global product cover
*
* @param int $id_product Product ID
* @return bool result
*/
public static function getGlobalCover($id_product)
{
return Db::getInstance()->getRow('
SELECT * FROM `'._DB_PREFIX_.'image` i
WHERE i.`id_product` = '.(int)$id_product.'
AND i.`cover`= 1');
}
/**
* Copy images from a product to another
*
* @param int $id_product_old Source product ID
* @param bool $id_product_new Destination product ID
*/
public static function duplicateProductImages($id_product_old, $id_product_new, $combination_images)
{
$images_types = ImageType::getImagesTypes('products');
$result = Db::getInstance()->executeS('
SELECT `id_image`
FROM `'._DB_PREFIX_.'image`
WHERE `id_product` = '.(int)$id_product_old);
foreach ($result as $row) {
$image_old = new Image($row['id_image']);
$image_new = clone $image_old;
unset($image_new->id);
$image_new->id_product = (int)$id_product_new;
// A new id is generated for the cloned image when calling add()
if ($image_new->add()) {
$new_path = $image_new->getPathForCreation();
foreach ($images_types as $image_type) {
if (file_exists(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'-'.$image_type['name'].'.jpg')) {
if (!Configuration::get('PS_LEGACY_IMAGES')) {
$image_new->createImgFolder();
}
copy(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'-'.$image_type['name'].'.jpg',
$new_path.'-'.$image_type['name'].'.jpg');
if (Configuration::get('WATERMARK_HASH')) {
$old_image_path = _PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'-'.$image_type['name'].'-'.Configuration::get('WATERMARK_HASH').'.jpg';
if (file_exists($old_image_path)) {
copy($old_image_path, $new_path.'-'.$image_type['name'].'-'.Configuration::get('WATERMARK_HASH').'.jpg');
}
}
}
}
if (file_exists(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'.jpg')) {
copy(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'.jpg', $new_path.'.jpg');
}
Image::replaceAttributeImageAssociationId($combination_images, (int)$image_old->id, (int)$image_new->id);
// Duplicate shop associations for images
$image_new->duplicateShops($id_product_old);
} else {
return false;
}
}
return Image::duplicateAttributeImageAssociations($combination_images);
}
protected static function replaceAttributeImageAssociationId(&$combination_images, $saved_id, $id_image)
{
if (!isset($combination_images['new']) || !is_array($combination_images['new'])) {
return;
}
foreach ($combination_images['new'] as $id_product_attribute => $image_ids) {
foreach ($image_ids as $key => $image_id) {
if ((int)$image_id == (int)$saved_id) {
$combination_images['new'][$id_product_attribute][$key] = (int)$id_image;
}
}
}
}
/**
* Duplicate product attribute image associations
* @param int $id_product_attribute_old
* @return bool
*/
public static function duplicateAttributeImageAssociations($combination_images)
{
if (!isset($combination_images['new']) || !is_array($combination_images['new'])) {
return true;
}
$query = 'INSERT INTO `'._DB_PREFIX_.'product_attribute_image` (`id_product_attribute`, `id_image`) VALUES ';
foreach ($combination_images['new'] as $id_product_attribute => $image_ids) {
foreach ($image_ids as $image_id) {
$query .= '('.(int)$id_product_attribute.', '.(int)$image_id.'), ';
}
}
$query = rtrim($query, ', ');
return DB::getInstance()->execute($query);
}
/**
* Reposition image
*
* @param int $position Position
* @param bool $direction Direction
* @deprecated since version 1.5.0.1 use Image::updatePosition() instead
*/
public function positionImage($position, $direction)
{
Tools::displayAsDeprecated();
$position = (int)$position;
$direction = (int)$direction;
// temporary position
$high_position = Image::getHighestPosition($this->id_product) + 1;
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = '.(int)$high_position.'
WHERE `id_product` = '.(int)$this->id_product.'
AND `position` = '.($direction ? $position - 1 : $position + 1));
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = `position`'.($direction ? '-1' : '+1').'
WHERE `id_image` = '.(int)$this->id);
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = '.$this->position.'
WHERE `id_product` = '.(int)$this->id_product.'
AND `position` = '.(int)$high_position);
}
/**
* Change an image position and update relative positions
*
* @param int $way position is moved up if 0, moved down if 1
* @param int $position new position of the moved image
* @return int success
*/
public function updatePosition($way, $position)
{
if (!isset($this->id) || !$position) {
return false;
}
// < and > statements rather than BETWEEN operator
// since BETWEEN is treated differently according to databases
$result = (Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position`= `position` '.($way ? '- 1' : '+ 1').'
WHERE `position`
'.($way
? '> '.(int)$this->position.' AND `position` <= '.(int)$position
: '< '.(int)$this->position.' AND `position` >= '.(int)$position).'
AND `id_product`='.(int)$this->id_product)
&& Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = '.(int)$position.'
WHERE `id_image` = '.(int)$this->id_image));
return $result;
}
public static function getSize($type)
{
if (!isset(self::$_cacheGetSize[$type]) || self::$_cacheGetSize[$type] === null) {
self::$_cacheGetSize[$type] = Db::getInstance()->getRow('
SELECT `width`, `height`
FROM '._DB_PREFIX_.'image_type
WHERE `name` = \''.pSQL($type).'\'
');
}
return self::$_cacheGetSize[$type];
}
public static function getWidth($params, &$smarty)
{
$result = self::getSize($params['type']);
return $result['width'];
}
public static function getHeight($params, &$smarty)
{
$result = self::getSize($params['type']);
return $result['height'];
}
/**
* Clear all images in tmp dir
*/
public static function clearTmpDir()
{
foreach (scandir(_PS_TMP_IMG_DIR_) as $d) {
if (preg_match('/(.*)\.jpg$/', $d)) {
unlink(_PS_TMP_IMG_DIR_.$d);
}
}
}
/**
* Delete Image - Product attribute associations for this image
*/
public function deleteProductAttributeImage()
{
return Db::getInstance()->execute('
DELETE
FROM `'._DB_PREFIX_.'product_attribute_image`
WHERE `id_image` = '.(int)$this->id
);
}
/**
* Delete the product image from disk and remove the containing folder if empty
* Handles both legacy and new image filesystems
*/
public function deleteImage($force_delete = false)
{
if (!$this->id) {
return false;
}
// Delete base image
if (file_exists($this->image_dir.$this->getExistingImgPath().'.'.$this->image_format)) {
unlink($this->image_dir.$this->getExistingImgPath().'.'.$this->image_format);
} else {
return false;
}
$files_to_delete = array();
// Delete auto-generated images
$image_types = ImageType::getImagesTypes();
foreach ($image_types as $image_type) {
$files_to_delete[] = $this->image_dir.$this->getExistingImgPath().'-'.$image_type['name'].'.'.$this->image_format;
if (Configuration::get('WATERMARK_HASH')) {
$files_to_delete[] = $this->image_dir.$this->getExistingImgPath().'-'.$image_type['name'].'-'.Configuration::get('WATERMARK_HASH').'.'.$this->image_format;
}
}
// Delete watermark image
$files_to_delete[] = $this->image_dir.$this->getExistingImgPath().'-watermark.'.$this->image_format;
// delete index.php
$files_to_delete[] = $this->image_dir.$this->getImgFolder().'index.php';
// Delete tmp images
$files_to_delete[] = _PS_TMP_IMG_DIR_.'product_'.$this->id_product.'.'.$this->image_format;
$files_to_delete[] = _PS_TMP_IMG_DIR_.'product_mini_'.$this->id_product.'.'.$this->image_format;
foreach ($files_to_delete as $file) {
if (file_exists($file) && !@unlink($file)) {
return false;
}
}
// Can we delete the image folder?
if (is_dir($this->image_dir.$this->getImgFolder())) {
$delete_folder = true;
foreach (scandir($this->image_dir.$this->getImgFolder()) as $file) {
if (($file != '.' && $file != '..')) {
$delete_folder = false;
break;
}
}
}
if (isset($delete_folder) && $delete_folder) {
@rmdir($this->image_dir.$this->getImgFolder());
}
return true;
}
/**
* Recursively deletes all product images in the given folder tree and removes empty folders.
*
* @param string $path folder containing the product images to delete
* @param string $format image format
* @return bool success
*/
public static function deleteAllImages($path, $format = 'jpg')
{
if (!$path || !$format || !is_dir($path)) {
return false;
}
foreach (scandir($path) as $file) {
if (preg_match('/^[0-9]+(\-(.*))?\.'.$format.'$/', $file)) {
unlink($path.$file);
} elseif (is_dir($path.$file) && (preg_match('/^[0-9]$/', $file))) {
Image::deleteAllImages($path.$file.'/', $format);
}
}
// Can we remove the image folder?
if (is_numeric(basename($path))) {
$remove_folder = true;
foreach (scandir($path) as $file) {
if (($file != '.' && $file != '..' && $file != 'index.php')) {
$remove_folder = false;
break;
}
}
if ($remove_folder) {
// we're only removing index.php if it's a folder we want to delete
if (file_exists($path.'index.php')) {
@unlink($path.'index.php');
}
@rmdir($path);
}
}
return true;
}
/**
* Returns image path in the old or in the new filesystem
*
* @ returns string image path
*/
public function getExistingImgPath()
{
if (!$this->id) {
return false;
}
if (!$this->existing_path) {
if (Configuration::get('PS_LEGACY_IMAGES') && file_exists(_PS_PROD_IMG_DIR_.$this->id_product.'-'.$this->id.'.'.$this->image_format)) {
$this->existing_path = $this->id_product.'-'.$this->id;
} else {
$this->existing_path = $this->getImgPath();
}
}
return $this->existing_path;
}
/**
* Returns the path to the folder containing the image in the new filesystem
*
* @return string path to folder
*/
public function getImgFolder()
{
if (!$this->id) {
return false;
}
if (!$this->folder) {
$this->folder = Image::getImgFolderStatic($this->id);
}
return $this->folder;
}
/**
* Create parent folders for the image in the new filesystem
*
* @return bool success
*/
public function createImgFolder()
{
if (!$this->id) {
return false;
}
if (!file_exists(_PS_PROD_IMG_DIR_.$this->getImgFolder())) {
// Apparently sometimes mkdir cannot set the rights, and sometimes chmod can't. Trying both.
$success = @mkdir(_PS_PROD_IMG_DIR_.$this->getImgFolder(), self::$access_rights, true);
$chmod = @chmod(_PS_PROD_IMG_DIR_.$this->getImgFolder(), self::$access_rights);
// Create an index.php file in the new folder
if (($success || $chmod)
&& !file_exists(_PS_PROD_IMG_DIR_.$this->getImgFolder().'index.php')
&& file_exists($this->source_index)) {
return @copy($this->source_index, _PS_PROD_IMG_DIR_.$this->getImgFolder().'index.php');
}
}
return true;
}
/**
* Returns the path to the image without file extension
*
* @return string path
*/
public function getImgPath()
{
if (!$this->id) {
return false;
}
$path = $this->getImgFolder().$this->id;
return $path;
}
/**
* Returns the path to the folder containing the image in the new filesystem
*
* @param mixed $id_image
* @return string path to folder
*/
public static function getImgFolderStatic($id_image)
{
if (!is_numeric($id_image)) {
return false;
}
$folders = str_split((string)$id_image);
return implode('/', $folders).'/';
}
/**
* Move all legacy product image files from the image folder root to their subfolder in the new filesystem.
* If max_execution_time is provided, stops before timeout and returns string "timeout".
* If any image cannot be moved, stops and returns "false"
*
* @param int $max_execution_time
* @return mixed success or timeout
*/
public static function moveToNewFileSystem($max_execution_time = 0)
{
$start_time = time();
$image = null;
$tmp_folder = 'duplicates/';
foreach (scandir(_PS_PROD_IMG_DIR_) as $file) {
// matches the base product image or the thumbnails
if (preg_match('/^([0-9]+\-)([0-9]+)(\-(.*))?\.jpg$/', $file, $matches)) {
// don't recreate an image object for each image type
if (!$image || $image->id !== (int)$matches[2]) {
$image = new Image((int)$matches[2]);
}
// image exists in DB and with the correct product?
if (Validate::isLoadedObject($image) && $image->id_product == (int)rtrim($matches[1], '-')) {
// create the new folder if it does not exist
if (!$image->createImgFolder()) {
return false;
}
// if there's already a file at the new image path, move it to a dump folder
// most likely the preexisting image is a demo image not linked to a product and it's ok to replace it
$new_path = _PS_PROD_IMG_DIR_.$image->getImgPath().(isset($matches[3]) ? $matches[3] : '').'.jpg';
if (file_exists($new_path)) {
if (!file_exists(_PS_PROD_IMG_DIR_.$tmp_folder)) {
@mkdir(_PS_PROD_IMG_DIR_.$tmp_folder, self::$access_rights);
@chmod(_PS_PROD_IMG_DIR_.$tmp_folder, self::$access_rights);
}
$tmp_path = _PS_PROD_IMG_DIR_.$tmp_folder.basename($file);
if (!@rename($new_path, $tmp_path) || !file_exists($tmp_path)) {
return false;
}
}
// move the image
if (!@rename(_PS_PROD_IMG_DIR_.$file, $new_path) || !file_exists($new_path)) {
return false;
}
}
}
if ((int)$max_execution_time != 0 && (time() - $start_time > (int)$max_execution_time - 4)) {
return 'timeout';
}
}
return true;
}
/**
* Try to create and delete some folders to check if moving images to new file system will be possible
*
* @return bool success
*/
public static function testFileSystem()
{
$safe_mode = Tools::getSafeModeStatus();
if ($safe_mode) {
return false;
}
$folder1 = _PS_PROD_IMG_DIR_.'testfilesystem/';
$test_folder = $folder1.'testsubfolder/';
// check if folders are already existing from previous failed test
if (file_exists($test_folder)) {
@rmdir($test_folder);
@rmdir($folder1);
}
if (file_exists($test_folder)) {
return false;
}
@mkdir($test_folder, self::$access_rights, true);
@chmod($test_folder, self::$access_rights);
if (!is_writeable($test_folder)) {
return false;
}
@rmdir($test_folder);
@rmdir($folder1);
if (file_exists($folder1)) {
return false;
}
return true;
}
/**
* Returns the path where a product image should be created (without file format)
*
* @return string path
*/
public function getPathForCreation()
{
if (!$this->id) {
return false;
}
if (Configuration::get('PS_LEGACY_IMAGES')) {
if (!$this->id_product) {
return false;
}
$path = $this->id_product.'-'.$this->id;
} else {
$path = $this->getImgPath();
$this->createImgFolder();
}
return _PS_PROD_IMG_DIR_.$path;
}
}
?>
Did this file decode correctly?
Original Code
<?php
/*
* 2007-2017 PrestaShop
*
* 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:
* http://opensource.org/licenses/osl-3.0.php
* 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 [email protected] 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 http://www.prestashop.com for more information.
*
* @author PrestaShop SA <[email protected]>
* @copyright 2007-2017 PrestaShop SA
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
class ImageCore extends ObjectModel
{
public $id;
/** @var int Image ID */
public $id_image;
/** @var int Product ID */
public $id_product;
/** @var int Position used to order images of the same product */
public $position;
/** @var bool Image is cover */
public $cover;
/** @var string Legend */
public $legend;
/** @var string image extension */
public $image_format = 'jpg';
/** @var string path to index.php file to be copied to new image folders */
public $source_index;
/** @var string image folder */
protected $folder;
/** @var string image path without extension */
protected $existing_path;
/** @var int access rights of created folders (octal) */
protected static $access_rights = 0775;
/**
* @see ObjectModel::$definition
*/
public static $definition = array(
'table' => 'image',
'primary' => 'id_image',
'multilang' => true,
'fields' => array(
'id_product' => array('type' => self::TYPE_INT, 'shop' => 'both', 'validate' => 'isUnsignedId', 'required' => true),
'position' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'),
'cover' => array('type' => self::TYPE_BOOL, 'allow_null' => true, 'validate' => 'isBool', 'shop' => true),
'legend' => array('type' => self::TYPE_STRING, 'lang' => true, 'validate' => 'isGenericName', 'size' => 128),
),
);
protected static $_cacheGetSize = array();
public function __construct($id = null, $id_lang = null)
{
parent::__construct($id, $id_lang);
$this->image_dir = _PS_PROD_IMG_DIR_;
$this->source_index = _PS_PROD_IMG_DIR_.'index.php';
}
public function add($autodate = true, $null_values = false)
{
if ($this->position <= 0) {
$this->position = Image::getHighestPosition($this->id_product) + 1;
}
if ($this->cover) {
$this->cover = 1;
} else {
$this->cover = null;
}
return parent::add($autodate, $null_values);
}
public function update($null_values = false)
{
if ($this->cover) {
$this->cover = 1;
} else {
$this->cover = null;
}
return parent::update($null_values);
}
public function delete()
{
if (!parent::delete()) {
return false;
}
if ($this->hasMultishopEntries()) {
return true;
}
if (!$this->deleteProductAttributeImage() || !$this->deleteImage()) {
return false;
}
// update positions
Db::getInstance()->execute('SET @position:=0', false);
Db::getInstance()->execute('UPDATE `'._DB_PREFIX_.'image` SET position=(@position:=@position+1)
WHERE `id_product` = '.(int)$this->id_product.' ORDER BY position ASC');
return true;
}
/**
* Return first image (by position) associated with a product attribute
*
* @param int $id_shop Shop ID
* @param int $id_lang Language ID
* @param int $id_product Product ID
* @param int $id_product_attribute Product Attribute ID
* @return array
*/
public static function getBestImageAttribute($id_shop, $id_lang, $id_product, $id_product_attribute)
{
$cache_id = 'Image::getBestImageAttribute'.'-'.(int)$id_product.'-'.(int)$id_product_attribute.'-'.(int)$id_lang.'-'.(int)$id_shop;
if (!Cache::isStored($cache_id)) {
$row = Db::getInstance()->getRow('
SELECT image_shop.`id_image` id_image, il.`legend`
FROM `'._DB_PREFIX_.'image` i
INNER JOIN `'._DB_PREFIX_.'image_shop` image_shop
ON (i.id_image = image_shop.id_image AND image_shop.id_shop = '.(int)$id_shop.')
INNER JOIN `'._DB_PREFIX_.'product_attribute_image` pai
ON (pai.`id_image` = i.`id_image` AND pai.`id_product_attribute` = '.(int)$id_product_attribute.')
LEFT JOIN `'._DB_PREFIX_.'image_lang` il
ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.')
WHERE i.`id_product` = '.(int)$id_product.' ORDER BY i.`position` ASC');
Cache::store($cache_id, $row);
} else {
$row = Cache::retrieve($cache_id);
}
return $row;
}
/**
* Return available images for a product
*
* @param int $id_lang Language ID
* @param int $id_product Product ID
* @param int $id_product_attribute Product Attribute ID
* @return array Images
*/
public static function getImages($id_lang, $id_product, $id_product_attribute = null)
{
$attribute_filter = ($id_product_attribute ? ' AND ai.`id_product_attribute` = '.(int)$id_product_attribute : '');
$sql = 'SELECT *
FROM `'._DB_PREFIX_.'image` i
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image`)';
if ($id_product_attribute) {
$sql .= ' LEFT JOIN `'._DB_PREFIX_.'product_attribute_image` ai ON (i.`id_image` = ai.`id_image`)';
}
$sql .= ' WHERE i.`id_product` = '.(int)$id_product.' AND il.`id_lang` = '.(int)$id_lang.$attribute_filter.'
ORDER BY i.`position` ASC';
return Db::getInstance()->executeS($sql);
}
/**
* Check if a product has an image available
*
* @param int $id_lang Language ID
* @param int $id_product Product ID
* @param int $id_product_attribute Product Attribute ID
* @return bool
*/
public static function hasImages($id_lang, $id_product, $id_product_attribute = null)
{
$attribute_filter = ($id_product_attribute ? ' AND ai.`id_product_attribute` = '.(int)$id_product_attribute : '');
$sql = 'SELECT 1
FROM `'._DB_PREFIX_.'image` i
LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (i.`id_image` = il.`id_image`)';
if ($id_product_attribute) {
$sql .= ' LEFT JOIN `'._DB_PREFIX_.'product_attribute_image` ai ON (i.`id_image` = ai.`id_image`)';
}
$sql .= ' WHERE i.`id_product` = '.(int)$id_product.' AND il.`id_lang` = '.(int)$id_lang.$attribute_filter;
return (bool)Db::getInstance()->getValue($sql);
}
/**
* Return Images
*
* @return array Images
*/
public static function getAllImages()
{
return Db::getInstance()->executeS('
SELECT `id_image`, `id_product`
FROM `'._DB_PREFIX_.'image`
ORDER BY `id_image` ASC');
}
/**
* Return number of images for a product
*
* @param int $id_product Product ID
* @return int number of images
*/
public static function getImagesTotal($id_product)
{
$result = Db::getInstance()->getRow('
SELECT COUNT(`id_image`) AS total
FROM `'._DB_PREFIX_.'image`
WHERE `id_product` = '.(int)$id_product);
return $result['total'];
}
/**
* Return highest position of images for a product
*
* @param int $id_product Product ID
* @return int highest position of images
*/
public static function getHighestPosition($id_product)
{
$result = Db::getInstance()->getRow('
SELECT MAX(`position`) AS max
FROM `'._DB_PREFIX_.'image`
WHERE `id_product` = '.(int)$id_product);
return $result['max'];
}
/**
* Delete product cover
*
* @param int $id_product Product ID
* @return bool result
*/
public static function deleteCover($id_product)
{
if (!Validate::isUnsignedId($id_product)) {
die(Tools::displayError());
}
if (file_exists(_PS_TMP_IMG_DIR_.'product_'.$id_product.'.jpg')) {
unlink(_PS_TMP_IMG_DIR_.'product_'.$id_product.'.jpg');
}
return (Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `cover` = NULL
WHERE `id_product` = '.(int)$id_product
) &&
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image_shop` image_shop
SET image_shop.`cover` = NULL
WHERE image_shop.id_shop IN ('.implode(',', array_map('intval', Shop::getContextListShopID())).') AND image_shop.`id_product` = '.(int)$id_product
));
}
/**
*Get product cover
*
* @param int $id_product Product ID
* @return bool result
*/
public static function getCover($id_product)
{
return Db::getInstance()->getRow('
SELECT * FROM `'._DB_PREFIX_.'image_shop` image_shop
WHERE image_shop.`id_product` = '.(int)$id_product.'
AND image_shop.`cover`= 1');
}
/**
*Get global product cover
*
* @param int $id_product Product ID
* @return bool result
*/
public static function getGlobalCover($id_product)
{
return Db::getInstance()->getRow('
SELECT * FROM `'._DB_PREFIX_.'image` i
WHERE i.`id_product` = '.(int)$id_product.'
AND i.`cover`= 1');
}
/**
* Copy images from a product to another
*
* @param int $id_product_old Source product ID
* @param bool $id_product_new Destination product ID
*/
public static function duplicateProductImages($id_product_old, $id_product_new, $combination_images)
{
$images_types = ImageType::getImagesTypes('products');
$result = Db::getInstance()->executeS('
SELECT `id_image`
FROM `'._DB_PREFIX_.'image`
WHERE `id_product` = '.(int)$id_product_old);
foreach ($result as $row) {
$image_old = new Image($row['id_image']);
$image_new = clone $image_old;
unset($image_new->id);
$image_new->id_product = (int)$id_product_new;
// A new id is generated for the cloned image when calling add()
if ($image_new->add()) {
$new_path = $image_new->getPathForCreation();
foreach ($images_types as $image_type) {
if (file_exists(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'-'.$image_type['name'].'.jpg')) {
if (!Configuration::get('PS_LEGACY_IMAGES')) {
$image_new->createImgFolder();
}
copy(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'-'.$image_type['name'].'.jpg',
$new_path.'-'.$image_type['name'].'.jpg');
if (Configuration::get('WATERMARK_HASH')) {
$old_image_path = _PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'-'.$image_type['name'].'-'.Configuration::get('WATERMARK_HASH').'.jpg';
if (file_exists($old_image_path)) {
copy($old_image_path, $new_path.'-'.$image_type['name'].'-'.Configuration::get('WATERMARK_HASH').'.jpg');
}
}
}
}
if (file_exists(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'.jpg')) {
copy(_PS_PROD_IMG_DIR_.$image_old->getExistingImgPath().'.jpg', $new_path.'.jpg');
}
Image::replaceAttributeImageAssociationId($combination_images, (int)$image_old->id, (int)$image_new->id);
// Duplicate shop associations for images
$image_new->duplicateShops($id_product_old);
} else {
return false;
}
}
return Image::duplicateAttributeImageAssociations($combination_images);
}
protected static function replaceAttributeImageAssociationId(&$combination_images, $saved_id, $id_image)
{
if (!isset($combination_images['new']) || !is_array($combination_images['new'])) {
return;
}
foreach ($combination_images['new'] as $id_product_attribute => $image_ids) {
foreach ($image_ids as $key => $image_id) {
if ((int)$image_id == (int)$saved_id) {
$combination_images['new'][$id_product_attribute][$key] = (int)$id_image;
}
}
}
}
/**
* Duplicate product attribute image associations
* @param int $id_product_attribute_old
* @return bool
*/
public static function duplicateAttributeImageAssociations($combination_images)
{
if (!isset($combination_images['new']) || !is_array($combination_images['new'])) {
return true;
}
$query = 'INSERT INTO `'._DB_PREFIX_.'product_attribute_image` (`id_product_attribute`, `id_image`) VALUES ';
foreach ($combination_images['new'] as $id_product_attribute => $image_ids) {
foreach ($image_ids as $image_id) {
$query .= '('.(int)$id_product_attribute.', '.(int)$image_id.'), ';
}
}
$query = rtrim($query, ', ');
return DB::getInstance()->execute($query);
}
/**
* Reposition image
*
* @param int $position Position
* @param bool $direction Direction
* @deprecated since version 1.5.0.1 use Image::updatePosition() instead
*/
public function positionImage($position, $direction)
{
Tools::displayAsDeprecated();
$position = (int)$position;
$direction = (int)$direction;
// temporary position
$high_position = Image::getHighestPosition($this->id_product) + 1;
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = '.(int)$high_position.'
WHERE `id_product` = '.(int)$this->id_product.'
AND `position` = '.($direction ? $position - 1 : $position + 1));
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = `position`'.($direction ? '-1' : '+1').'
WHERE `id_image` = '.(int)$this->id);
Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = '.$this->position.'
WHERE `id_product` = '.(int)$this->id_product.'
AND `position` = '.(int)$high_position);
}
/**
* Change an image position and update relative positions
*
* @param int $way position is moved up if 0, moved down if 1
* @param int $position new position of the moved image
* @return int success
*/
public function updatePosition($way, $position)
{
if (!isset($this->id) || !$position) {
return false;
}
// < and > statements rather than BETWEEN operator
// since BETWEEN is treated differently according to databases
$result = (Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position`= `position` '.($way ? '- 1' : '+ 1').'
WHERE `position`
'.($way
? '> '.(int)$this->position.' AND `position` <= '.(int)$position
: '< '.(int)$this->position.' AND `position` >= '.(int)$position).'
AND `id_product`='.(int)$this->id_product)
&& Db::getInstance()->execute('
UPDATE `'._DB_PREFIX_.'image`
SET `position` = '.(int)$position.'
WHERE `id_image` = '.(int)$this->id_image));
return $result;
}
public static function getSize($type)
{
if (!isset(self::$_cacheGetSize[$type]) || self::$_cacheGetSize[$type] === null) {
self::$_cacheGetSize[$type] = Db::getInstance()->getRow('
SELECT `width`, `height`
FROM '._DB_PREFIX_.'image_type
WHERE `name` = \''.pSQL($type).'\'
');
}
return self::$_cacheGetSize[$type];
}
public static function getWidth($params, &$smarty)
{
$result = self::getSize($params['type']);
return $result['width'];
}
public static function getHeight($params, &$smarty)
{
$result = self::getSize($params['type']);
return $result['height'];
}
/**
* Clear all images in tmp dir
*/
public static function clearTmpDir()
{
foreach (scandir(_PS_TMP_IMG_DIR_) as $d) {
if (preg_match('/(.*)\.jpg$/', $d)) {
unlink(_PS_TMP_IMG_DIR_.$d);
}
}
}
/**
* Delete Image - Product attribute associations for this image
*/
public function deleteProductAttributeImage()
{
return Db::getInstance()->execute('
DELETE
FROM `'._DB_PREFIX_.'product_attribute_image`
WHERE `id_image` = '.(int)$this->id
);
}
/**
* Delete the product image from disk and remove the containing folder if empty
* Handles both legacy and new image filesystems
*/
public function deleteImage($force_delete = false)
{
if (!$this->id) {
return false;
}
// Delete base image
if (file_exists($this->image_dir.$this->getExistingImgPath().'.'.$this->image_format)) {
unlink($this->image_dir.$this->getExistingImgPath().'.'.$this->image_format);
} else {
return false;
}
$files_to_delete = array();
// Delete auto-generated images
$image_types = ImageType::getImagesTypes();
foreach ($image_types as $image_type) {
$files_to_delete[] = $this->image_dir.$this->getExistingImgPath().'-'.$image_type['name'].'.'.$this->image_format;
if (Configuration::get('WATERMARK_HASH')) {
$files_to_delete[] = $this->image_dir.$this->getExistingImgPath().'-'.$image_type['name'].'-'.Configuration::get('WATERMARK_HASH').'.'.$this->image_format;
}
}
// Delete watermark image
$files_to_delete[] = $this->image_dir.$this->getExistingImgPath().'-watermark.'.$this->image_format;
// delete index.php
$files_to_delete[] = $this->image_dir.$this->getImgFolder().'index.php';
// Delete tmp images
$files_to_delete[] = _PS_TMP_IMG_DIR_.'product_'.$this->id_product.'.'.$this->image_format;
$files_to_delete[] = _PS_TMP_IMG_DIR_.'product_mini_'.$this->id_product.'.'.$this->image_format;
foreach ($files_to_delete as $file) {
if (file_exists($file) && !@unlink($file)) {
return false;
}
}
// Can we delete the image folder?
if (is_dir($this->image_dir.$this->getImgFolder())) {
$delete_folder = true;
foreach (scandir($this->image_dir.$this->getImgFolder()) as $file) {
if (($file != '.' && $file != '..')) {
$delete_folder = false;
break;
}
}
}
if (isset($delete_folder) && $delete_folder) {
@rmdir($this->image_dir.$this->getImgFolder());
}
return true;
}
/**
* Recursively deletes all product images in the given folder tree and removes empty folders.
*
* @param string $path folder containing the product images to delete
* @param string $format image format
* @return bool success
*/
public static function deleteAllImages($path, $format = 'jpg')
{
if (!$path || !$format || !is_dir($path)) {
return false;
}
foreach (scandir($path) as $file) {
if (preg_match('/^[0-9]+(\-(.*))?\.'.$format.'$/', $file)) {
unlink($path.$file);
} elseif (is_dir($path.$file) && (preg_match('/^[0-9]$/', $file))) {
Image::deleteAllImages($path.$file.'/', $format);
}
}
// Can we remove the image folder?
if (is_numeric(basename($path))) {
$remove_folder = true;
foreach (scandir($path) as $file) {
if (($file != '.' && $file != '..' && $file != 'index.php')) {
$remove_folder = false;
break;
}
}
if ($remove_folder) {
// we're only removing index.php if it's a folder we want to delete
if (file_exists($path.'index.php')) {
@unlink($path.'index.php');
}
@rmdir($path);
}
}
return true;
}
/**
* Returns image path in the old or in the new filesystem
*
* @ returns string image path
*/
public function getExistingImgPath()
{
if (!$this->id) {
return false;
}
if (!$this->existing_path) {
if (Configuration::get('PS_LEGACY_IMAGES') && file_exists(_PS_PROD_IMG_DIR_.$this->id_product.'-'.$this->id.'.'.$this->image_format)) {
$this->existing_path = $this->id_product.'-'.$this->id;
} else {
$this->existing_path = $this->getImgPath();
}
}
return $this->existing_path;
}
/**
* Returns the path to the folder containing the image in the new filesystem
*
* @return string path to folder
*/
public function getImgFolder()
{
if (!$this->id) {
return false;
}
if (!$this->folder) {
$this->folder = Image::getImgFolderStatic($this->id);
}
return $this->folder;
}
/**
* Create parent folders for the image in the new filesystem
*
* @return bool success
*/
public function createImgFolder()
{
if (!$this->id) {
return false;
}
if (!file_exists(_PS_PROD_IMG_DIR_.$this->getImgFolder())) {
// Apparently sometimes mkdir cannot set the rights, and sometimes chmod can't. Trying both.
$success = @mkdir(_PS_PROD_IMG_DIR_.$this->getImgFolder(), self::$access_rights, true);
$chmod = @chmod(_PS_PROD_IMG_DIR_.$this->getImgFolder(), self::$access_rights);
// Create an index.php file in the new folder
if (($success || $chmod)
&& !file_exists(_PS_PROD_IMG_DIR_.$this->getImgFolder().'index.php')
&& file_exists($this->source_index)) {
return @copy($this->source_index, _PS_PROD_IMG_DIR_.$this->getImgFolder().'index.php');
}
}
return true;
}
/**
* Returns the path to the image without file extension
*
* @return string path
*/
public function getImgPath()
{
if (!$this->id) {
return false;
}
$path = $this->getImgFolder().$this->id;
return $path;
}
/**
* Returns the path to the folder containing the image in the new filesystem
*
* @param mixed $id_image
* @return string path to folder
*/
public static function getImgFolderStatic($id_image)
{
if (!is_numeric($id_image)) {
return false;
}
$folders = str_split((string)$id_image);
return implode('/', $folders).'/';
}
/**
* Move all legacy product image files from the image folder root to their subfolder in the new filesystem.
* If max_execution_time is provided, stops before timeout and returns string "timeout".
* If any image cannot be moved, stops and returns "false"
*
* @param int $max_execution_time
* @return mixed success or timeout
*/
public static function moveToNewFileSystem($max_execution_time = 0)
{
$start_time = time();
$image = null;
$tmp_folder = 'duplicates/';
foreach (scandir(_PS_PROD_IMG_DIR_) as $file) {
// matches the base product image or the thumbnails
if (preg_match('/^([0-9]+\-)([0-9]+)(\-(.*))?\.jpg$/', $file, $matches)) {
// don't recreate an image object for each image type
if (!$image || $image->id !== (int)$matches[2]) {
$image = new Image((int)$matches[2]);
}
// image exists in DB and with the correct product?
if (Validate::isLoadedObject($image) && $image->id_product == (int)rtrim($matches[1], '-')) {
// create the new folder if it does not exist
if (!$image->createImgFolder()) {
return false;
}
// if there's already a file at the new image path, move it to a dump folder
// most likely the preexisting image is a demo image not linked to a product and it's ok to replace it
$new_path = _PS_PROD_IMG_DIR_.$image->getImgPath().(isset($matches[3]) ? $matches[3] : '').'.jpg';
if (file_exists($new_path)) {
if (!file_exists(_PS_PROD_IMG_DIR_.$tmp_folder)) {
@mkdir(_PS_PROD_IMG_DIR_.$tmp_folder, self::$access_rights);
@chmod(_PS_PROD_IMG_DIR_.$tmp_folder, self::$access_rights);
}
$tmp_path = _PS_PROD_IMG_DIR_.$tmp_folder.basename($file);
if (!@rename($new_path, $tmp_path) || !file_exists($tmp_path)) {
return false;
}
}
// move the image
if (!@rename(_PS_PROD_IMG_DIR_.$file, $new_path) || !file_exists($new_path)) {
return false;
}
}
}
if ((int)$max_execution_time != 0 && (time() - $start_time > (int)$max_execution_time - 4)) {
return 'timeout';
}
}
return true;
}
/**
* Try to create and delete some folders to check if moving images to new file system will be possible
*
* @return bool success
*/
public static function testFileSystem()
{
$safe_mode = Tools::getSafeModeStatus();
if ($safe_mode) {
return false;
}
$folder1 = _PS_PROD_IMG_DIR_.'testfilesystem/';
$test_folder = $folder1.'testsubfolder/';
// check if folders are already existing from previous failed test
if (file_exists($test_folder)) {
@rmdir($test_folder);
@rmdir($folder1);
}
if (file_exists($test_folder)) {
return false;
}
@mkdir($test_folder, self::$access_rights, true);
@chmod($test_folder, self::$access_rights);
if (!is_writeable($test_folder)) {
return false;
}
@rmdir($test_folder);
@rmdir($folder1);
if (file_exists($folder1)) {
return false;
}
return true;
}
/**
* Returns the path where a product image should be created (without file format)
*
* @return string path
*/
public function getPathForCreation()
{
if (!$this->id) {
return false;
}
if (Configuration::get('PS_LEGACY_IMAGES')) {
if (!$this->id_product) {
return false;
}
$path = $this->id_product.'-'.$this->id;
} else {
$path = $this->getImgPath();
$this->createImgFolder();
}
return _PS_PROD_IMG_DIR_.$path;
}
}
Function Calls
None |
Stats
MD5 | 7af11189443f22cb22df9d8fdb44fab9 |
Eval Count | 0 |
Decode Time | 120 ms |