Current path: home/webdevt/www/schtroumpf.fr/modules/ets_superspeed/
?? Go up: /home/webdevt/www/schtroumpf.fr/modules
<?php
/**
* Copyright ETS Software Technology Co., Ltd
*
* NOTICE OF LICENSE
*
* This file is not open source! Each license that you purchased is only available for 1 website only.
* If you want to use this file on more websites (or projects), you need to purchase additional licenses.
* You are not allowed to redistribute, resell, lease, license, sub-license or offer our resources to any third party.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future.
*
* @author ETS Software Technology Co., Ltd
* @copyright ETS Software Technology Co., Ltd
* @license Valid for 1 website (or project) for each purchase of license
*/
// if (!defined('_PS_VERSION_')) { exit; }
class Ets_superspeed_compressor_image
{
protected static $instance;
public $_resmush = 0;
public $_google = 0;
public $_errors = array();
public $is17 = false;
public $is16 = false;
public $isblog = false;
public $isSlide = false;
public $isBanner = false;
public $number_optimize = 1;
public function __construct()
{
$this->name = 'ets_superspeed';
$this->context = Context::getContext();
if (version_compare(_PS_VERSION_, '1.7', '>='))
$this->is17 = true;
if (version_compare(_PS_VERSION_, '1.7', '<'))
$this->is16 = true;
if (Module::isInstalled('ybc_blog') && Module::isEnabled('ybc_blog'))
$this->isblog = true;
if ((Module::isInstalled('ps_imageslider') && Module::isEnabled('ps_imageslider')) || (Module::isInstalled('homeslider') && Module::isEnabled('homeslider')))
$this->isSlide = true;
if ((Module::isInstalled('blockbanner') && Module::isEnabled('blockbanner')) || (Module::isInstalled('ps_banner') && Module::isEnabled('ps_banner')))
$this->isBanner = true;
if (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'google' || Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'php')
$this->number_optimize = 5;
}
public static function getInstance()
{
if (!isset(self::$instance)) {
self::$instance = new Ets_superspeed_compressor_image();
}
return self::$instance;
}
public function compress($path, $type, $quality, $url_image = null, $quality_old = 0, $is_product = false)
{
if (Tools::isSubmit('btnSubmitImageOptimize') || Tools::isSubmit('btnSubmitImageAllOptimize') || Tools::isSubmit('btnSubmitPageCacheDashboard')) {
$script_optimize = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT');
$image = 'old';
} elseif (Tools::isSubmit('submitUploadImageCompress')) {
$script_optimize = Configuration::get('ETS_SPEED_OPTIMIZE_SCRIPT_UPLOAD');
$image = 'upload';
} elseif (Tools::isSubmit('submitBrowseImageOptimize')) {
$script_optimize = Configuration::get('ETS_SPEED_OPTIMIZE_SCRIPT_BROWSE');
$image = 'browse';
} else {
$script_optimize = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT');
$image = 'new';
}
if (!is_array($type)) {
$name = $type;
$source = $path . $name;
$destination = $path . $name;
$temp = $path . 'temp-' . $name;
} else {
$name = Tools::stripslashes($type['name']);
$source = $path . '-' . $name . '.jpg';
$destination = $path . '-' . $name . '.jpg';
$temp = $path . '-' . $name . '-temp.jpg';
}
$file_size_old = Tools::ps_round(@filesize($source) / 1024, 2);
if ($quality >= 100) {
if (Configuration::get('ETS_SPEEP_RESUMSH') != 2)
Configuration::updateValue('ETS_SPEEP_RESUMSH', 2);
if ($is_product) {
$destination_webp = str_replace('.jpg', '.webp', $destination);
if (file_exists($destination_webp))
@unlink($destination_webp);
}
if (file_exists($temp))
@unlink($temp);
return array(
'file_size' => $file_size_old,
'optimize_type' => $script_optimize ? $script_optimize : 'google',
);
}
$continue = (int)Tools::getValue('continue');
if (self::checkOptimizeImageResmush($script_optimize) && $url_image && $quality < 100 && $this->_resmush < 10 && !$continue) {
$this->_errors = array();
if ($file_size = $this->compressByReSmush($url_image, $quality, $temp, $destination, $file_size_old, $is_product)) {
if (file_exists($path . 'fileType'))
@unlink($path . 'fileType');
if (file_exists($temp))
@unlink($temp);
return $file_size;
} else {
$this->_resmush++;
if (file_exists($temp))
@unlink($temp);
return false;
}
}
if ($script_optimize == 'tynypng' && !$continue) {
$tynypng_api_keys = explode(';', Configuration::get('ETS_SPEED_API_TYNY_KEY'));
if (Configuration::get('ETS_SP_ERRORS_TINYPNG'))
$errors_api = json_decode(Configuration::get('ETS_SP_ERRORS_TINYPNG'), true);
else
$errors_api = array();
if ($tynypng_api_keys) {
foreach ($tynypng_api_keys as $api_key) {
if (!isset($errors_api[$api_key]) || (isset($errors_api[$api_key]) && $errors_api[$api_key] <= 5)) {
$this->_errors = array();
if ($file_size = $this->compressByTyNyPNG($source, $api_key, $is_product)) {
if (isset($errors_api[$api_key]) && $errors_api[$api_key] != 1) {
$errors_api[$api_key] = 1;
Configuration::updateValue('ETS_SP_ERRORS_TINYPNG', json_encode($errors_api));
}
if (file_exists($temp))
@unlink($temp);
return $file_size;
} else {
if (isset($errors_api[$api_key]))
$errors_api[$api_key]++;
else
$errors_api[$api_key] = 1;
Configuration::updateValue('ETS_SP_ERRORS_TINYPNG', json_encode($errors_api));
if (file_exists($temp))
@unlink($temp);
return false;
}
}
}
}
}
$continue_webp = (int)Tools::getValue('continue_webp');
if (($script_optimize == 'google' || $continue_webp) && $this->_google <= 5 && !$continue) {
$this->_errors = array();
$mime_type = Tools::strtolower(mime_content_type($source));
if ($mime_type == 'image/jpeg' || $mime_type == 'image/png') //|| $mime_type =='image/gif'
{
$optimized = $this->compressByGoogleScript($source, $destination, $temp, $quality, $is_product);
}
else {
if (file_exists($temp))
@unlink($temp);
return array(
'file_size' => $file_size_old,
'optimize_type' => 'google',
);
}
if ($optimized) {
$this->_google = 0;
if (file_exists($temp))
@unlink($temp);
return $optimized;
} else {
$this->_google++;
if (file_exists($temp))
@unlink($temp);
return false;
}
}
if ($script_optimize != 'php' && (!$continue || $continue_webp) && ($image == 'old' || $image == 'upload' || $image == 'browse')) {
$mime_type = Tools::strtolower(mime_content_type($source));
if ($image == 'upload' && file_exists($source))
@unlink($source);
if (($script_optimize == 'google' || $continue_webp) && ($mime_type == 'image/jpeg' || $mime_type == 'image/png')) {
if (file_exists($temp))
@unlink($temp);
die(
json_encode(
array(
'error' => $this->displayGoogleError($this->_errors, true),
'script_continue' => 'php',
)
)
);
}
if (file_exists($temp))
@unlink($temp);
die(
json_encode(
array(
'error' => $this->_errors ? $this->displayError($this->_errors, true) : $this->displayError($this->l('errors'), true),
'script_continue' => 'php',
)
)
);
}
return $this->compressByPhp($path, $name, $source, $destination, $temp, $quality, $type, $file_size_old, $quality_old, $is_product);
}
public static function checkOptimizeImageResmush($script_optimize = '')
{
if (!$script_optimize)
$script_optimize = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT');
$whitelist = array(
'127.0.0.1',
'::1'
);
if (!in_array(Tools::getRemoteAddr(), $whitelist) && $script_optimize == 'resmush') {
return true;
}
return false;
}
public function compressByReSmush($url_image, $quality, $temp, $destination, $file_size_old, $is_product = false)
{
$optimized_jpg_arr = json_decode(Tools::file_get_contents('http://api.resmush.it/ws.php?img=' . $url_image . ($quality < 80 ? '&qlty=' . (int)$quality : '')), true);
if (isset($optimized_jpg_arr['dest'])) {
$optimized_jpg_url = $optimized_jpg_arr['dest'];
if (Configuration::get('ETS_SPEEP_RESUMSH') != 1)
Configuration::updateValue('ETS_SPEEP_RESUMSH', 1);
file_put_contents($temp, Tools::file_get_contents($optimized_jpg_url));
$file_size = Tools::ps_round(@filesize($temp) / 1024, 2);
if (file_exists($temp)) {
if ($file_size > 0) {
Tools::copy($temp, $destination);
@unlink($temp);
if ($is_product) {
$destination_webp = str_replace('.jpg', '.webp', $destination);
if (file_exists($destination_webp))
@unlink($destination_webp);
}
if ($file_size < $file_size_old)
return array(
'file_size' => $file_size,
'optimize_type' => 'resmush',
);
else
return array(
'file_size' => $file_size_old,
'optimize_type' => 'resmush',
);
} else {
@unlink($temp);
$this->_errors[] = $this->l('Resmush failed to create image');
return false;
}
}
}
$this->_errors[] = $this->l('Resmush failed to create image');
return false;
}
public function compressByTyNyPNG($source, $api_key, $is_product = false)
{
$curl = curl_init();
$curlOptions = array(
CURLOPT_BINARYTRANSFER => 1,
CURLOPT_HEADER => 1,
CURLOPT_POST => 1,
CURLOPT_RETURNTRANSFER => 1,
CURLOPT_URL => 'https://api.tinypng.com/shrink',
CURLOPT_USERAGENT => 'TinyPNG PHP v1',
CURLOPT_USERPWD => 'api:' . $api_key,
);
curl_setopt_array($curl, $curlOptions);
curl_setopt($curl, CURLOPT_POSTFIELDS, Tools::file_get_contents($source));
$response = curl_exec($curl);
$content = json_decode(Tools::substr($response, curl_getinfo($curl, CURLINFO_HEADER_SIZE)), true);
if (isset($content['output']['url']) && $content['output']['url']) {
if ($content['output']['size'] > 0) {
if (file_put_contents($source, Tools::file_get_contents($content['output']['url'])) !== false) {
if ($is_product) {
$destination_webp = str_replace('.jpg', '.webp', $source);
if (file_exists($destination_webp))
@unlink($destination_webp);
}
return array(
'file_size' => Tools::ps_round($content['output']['size'] / 1024, 2),
'optimize_type' => 'tynypng',
);
}
}
}
$this->_errors[] = $this->l('TinyPNG is not working. Your API key(s) is invalid or you may have reached API limit.');
return false;
}
public function compressByGoogleScript($source, $destination, $temp, $quality, $is_product = false)
{
require dirname(__FILE__) . '/classes/rosell-dk/vendor/autoload.php';
$options = array(
'converters' => array('cwebp', 'vips', 'imagick', 'gmagick', 'imagemagick', 'graphicsmagick', 'gd'),
'alpha-quality' => (int)$quality
);
$optimize = WebPConvert\WebPConvert::convert($source, $temp, $options, null);
if ($optimize && $file_size = Tools::ps_round(@filesize($temp) / 1024, 2)) {
$is_webp = Configuration::getGlobalValue('ETS_SPEED_ENABLE_WEBP_FORMAT');
$destination_webp = str_replace('.jpg', '.webp', $destination);
if ($is_webp && $is_product)
Tools::copy($temp, $destination_webp);
else {
Tools::copy($temp, $destination);
if ($is_product && file_exists($destination_webp))
@unlink($destination_webp);
}
if (file_exists($temp))
@unlink($temp);
return array(
'file_size' => $file_size,
'optimize_type' => Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') ? Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') : 'php',
);
} else
return false;
}
public function compressByPhp($path, $name, $source, $destination, $temp, $quality, $type, $file_size_old, $quality_old, $is_product = false)
{
if ($this->png_has_transparency($source))
return array(
'file_size' => $file_size_old,
'optimize_type' => Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') ? Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') : 'php',
);
ini_set('gd.jpeg_ignore_warning', 1);
$temp2 = $path . 'temp2-' . $name;
Tools::copy($source, $temp2);
$image = @getimagesize($source);
$default = false;
if ($quality >= 100 || ($quality <= 80 && is_array($type) && isset($type['width']) && $type['width'] <= 260) || ($name == Configuration::get('PS_LOGO') && $quality <= 80)) {
if ($is_product) {
$destination_webp = str_replace('.jpg', '.webp', $destination);
if (file_exists($destination_webp))
@unlink($destination_webp);
}
if ($quality_old <= 80) {
if (file_exists($temp2))
@unlink($temp2);
if (file_exists($temp))
@unlink($temp);
return array(
'file_size' => $file_size_old,
'optimize_type' => Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') ? Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') : 'php',
);
}
$default = true;
}
if ($image) {
ini_set('gd.jpeg_ignore_warning', 1);
$widthImage = $image[0];
$heightImage = $image[1];
$imageCanves = imagecreatetruecolor($widthImage, $heightImage);
switch (Tools::strtolower($image['mime'])) {
case 'image/jpeg':
$NewImage = imagecreatefromjpeg($source);
break;
case 'image/JPEG':
$NewImage = imagecreatefromjpeg($source);
break;
case 'image/png':
$NewImage = imagecreatefrompng($source);
break;
case 'image/PNG':
$NewImage = imagecreatefrompng($source);
break;
case 'image/gif':
$NewImage = imagecreatefromgif($source);
break;
default:
if (file_exists($temp2))
@unlink($temp2);
return array(
'file_size' => $file_size_old,
'optimize_type' => Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') ? Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') : 'php',
);
}
$white = imagecolorallocate($imageCanves, 255, 255, 255);
imagefill($imageCanves, 0, 0, $white);
// Resize Image
if (imagecopyresampled($imageCanves, $NewImage, 0, 0, 0, 0, $widthImage, $heightImage, $widthImage, $heightImage)) {
// copy file
if (imagejpeg($imageCanves, $destination, $default ? 80 : $quality)) {
imagedestroy($imageCanves);
if (Tools::copy($destination, $temp)) {
$file_size = Tools::ps_round(@filesize($temp) / 1024, 2);
if ($file_size > $file_size_old) {
Tools::copy($temp2, $destination);
$file_size = $file_size_old;
}
if (file_exists($temp))
@unlink($temp);
if (file_exists($temp2))
@unlink($temp2);
if (file_exists($path . 'fileType'))
@unlink($path . 'fileType');
if ($is_product) {
$destination_webp = str_replace('.jpg', '.webp', $destination);
if (file_exists($destination_webp))
@unlink($destination_webp);
}
return array(
'file_size' => $file_size,
'optimize_type' => Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') ? Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') : 'php',
);
}
}
}
}
if (file_exists($temp2))
@unlink($temp2);
if (file_exists($temp))
@unlink($temp);
if (file_exists($path . 'fileType'))
@unlink($path . 'fileType');
return array(
'file_size' => $file_size_old,
'optimize_type' => Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') ? Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') : 'php',
);
}
public function png_has_transparency($filename)
{
if (Tools::strlen($filename) == 0 || !file_exists($filename))
return false;
if (ord(call_user_func('file_get_contents', $filename, false, null, 25, 1)) & 4) {
return true;
}
$contents = Tools::file_get_contents($filename);
if (stripos($contents, 'PLTE') !== false && stripos($contents, 'tRNS') !== false)
return true;
return false;
}
public function displayError($errors, $popup = false)
{
$this->context->smarty->assign(
array(
'errors' => $errors,
'popup' => $popup
)
);
return $this->context->smarty->fetch(_PS_MODULE_DIR_ . $this->name . '/views/templates/hook/error.tpl');
}
public function displayGoogleError()
{
return $this->context->smarty->fetch(_PS_MODULE_DIR_ . $this->name . '/views/templates/hook/google.tpl');
}
public function l($string)
{
return Translate::getModuleTranslation('ets_superspeed', $string, pathinfo(__FILE__, PATHINFO_FILENAME));
}
public function optimizeNewImage($params)
{
if (isset($params['id_image']) && ($id_image = (int)$params['id_image']) && $type_product = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_PRODCUT_TYPE')) {
$quality = ($quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE')) > 0 ? $quality : 90;
$new_image = new Image($id_image);
$path = $new_image->getPathForCreation();
$types = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'image_type` WHERE products=1 AND name IN ("' . implode('","', array_map('pSQL', explode(',', $type_product))) . '")');
if ($types) {
$ETS_SPEED_UPDATE_QUALITY = (int)Ets_superspeed::getQantityOptimize();
foreach ($types as $type) {
if ($ETS_SPEED_UPDATE_QUALITY)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image = ' . (int)$id_image . ' AND type_image="' . pSQL($type['name']) . '" AND quality!=100';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image ="' . (int)$id_image . '" AND type_image ="' . pSQL($type['name']) . '"' . (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') != 'tynypng' || $quality == 100 || !$$ETS_SPEED_UPDATE_QUALITY ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ' AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"';
if (!Db::getInstance()->getRow($sql)) {
$optimizied = (int)Db::getInstance()->getValue('SELECT id_image FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image ="' . (int)$id_image . '" AND type_image ="' . pSQL($type['name']) . '"', false);
if ($size_old = self::createImage($path, $type, $optimizied)) {
if (self::checkOptimizeImageResmush()) {
$product_class = new Product($new_image->id_product, false, $this->context->language->id);
$url_image = $this->context->link->getImageLink($product_class->link_rewrite, $new_image->id, $type['name']);
} else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image ="' . (int)$id_image . '" AND type_image ="' . pSQL($type['name']) . '"');
$compress = $this->compress($path, $type, $quality, $url_image, $quality_old, true);
while ($compress === false) {
$compress = $this->compress($path, $type, $quality, $url_image, $quality_old, true);
}
if (!$optimizied)
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_product_image` (id_image,type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$id_image . '","' . pSQL($type['name']) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQL($compress['optimize_type']) . '")');
else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_product_image` SET quality ="' . (int)$quality . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",size_old="' . (float)$size_old . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_image ="' . (int)$id_image . '" AND type_image ="' . pSQL($type['name']) . '"');
}
}
}
}
}
}
public static function createImage($path, $type, $optimizied = false)
{
$tgt_width = $tgt_height = 0;
$src_width = $src_height = 0;
$error = 0;
if (file_exists($path . '.jpg')) {
if (@file_exists($path . '-' . Tools::stripslashes($type['name']) . '.jpg') && $optimizied) {
@unlink($path . '-' . Tools::stripslashes($type['name']) . '.jpg');
}
if (!@file_exists($path . '-' . Tools::stripslashes($type['name']) . '.jpg')) {
ImageManager::resize(
$path . '.jpg',
$path . '-' . Tools::stripslashes($type['name']) . '.jpg',
$type['width'],
$type['height'],
'jpg',
false,
$error,
$tgt_width,
$tgt_height,
5,
$src_width,
$src_height
);
}
}
if (file_exists($path . '-' . Tools::stripslashes($type['name']) . '.jpg'))
return Tools::ps_round(filesize($path . '-' . Tools::stripslashes($type['name']) . '.jpg') / 1024, 2);
else
return false;
}
public function optimizeProductImage($all_type = false)
{
$quality = ($quality = Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE')) ? $quality : 50;
$optmize_script = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT');
if ($all_type)
$types = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'image_type` WHERE products=1');
else
$types = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'image_type` WHERE products=1 AND name IN ("' . implode('","', array_map('pSQL', explode(',', Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_PRODCUT_TYPE')))) . '")');
$ok = false;
$ETS_SPEED_UPDATE_QUALITY = (int)Ets_superspeed::getQantityOptimize();
if ($types) {
foreach ($types as $type) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$and_quality = ' AND pi.quality!=100';
else
$and_quality = ($optmize_script != 'tynypng' || $quality == 100 || !$ETS_SPEED_UPDATE_QUALITY ? ' AND pi.quality="' . (int)$quality . '"' : ' AND pi.quality!=100') . ($quality != 100 ? ' AND pi.optimize_type = "' . pSQL($optmize_script) . '"' : '');
$images = Db::getInstance()->executeS('
SELECT i.id_image FROM `' . _DB_PREFIX_ . 'image` i
LEFT JOIN `' . _DB_PREFIX_ . 'ets_superspeed_product_image` pi ON i.id_image = pi.id_image AND pi.type_image="' . pSQL($type['name']) . '"' . (string)$and_quality . '
WHERE pi.id_image is NULL LIMIT 0 ,' . (int)$this->number_optimize);
if ($images) {
$ok = true;
foreach ($images as $image) {
$image_obj = new Image($image['id_image']);
$path = $image_obj->getPathForCreation();
foreach ($types as $type) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image = ' . (int)$image['id_image'] . ' AND type_image="' . pSQL($type['name']) . '" AND quality!=100';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image = ' . (int)$image['id_image'] . ' AND type_image="' . pSQL($type['name']) . '"' . ($optmize_script != 'tynypng' || $quality == 100 ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL($optmize_script) . '"' : '');
if (!Db::getInstance()->getRow($sql)) {
$optimizied = (int)Db::getInstance()->getValue('SELECT id_image FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image = "' . (int)$image['id_image'] . '" AND type_image like "' . pSQL($type['name']) . '"', false);
if ($size_old = self::createImage($path, $type, $optimizied)) {
if (self::checkOptimizeImageResmush()) {
$product_class = new Product($image_obj->id_product,false, $this->context->language->id);
$url_image = $this->context->link->getImageLink($product_class->link_rewrite, $image_obj->id, $type['name']);
} else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE id_image = ' . (int)$image['id_image'] . ' AND type_image="' . pSQL($type['name']) . '"');
$compress = $this->compress($path, $type, $quality, $url_image, $quality_old, true);
while ($compress === false) {
$compress = $this->compress($path, $type, $quality, $url_image, $quality_old);
}
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_product_image` (id_image,type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$image['id_image'] . '","' . pSQL($type['name']) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQL($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_product_image` SET quality ="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new ="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_image ="' . (int)$image['id_image'] . '" AND type_image ="' . pSQL($type['name']) . '"');
} else {
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_product_image` (id_image,type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$image['id_image'] . '","' . pSQL($type['name']) . '","' . (int)$quality . '","0","0","' . ($optmize_script ? pSQL($optmize_script) : 'php') . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_product_image` SET quality ="' . (int)$quality . '",size_old="0",size_new ="0",optimize_type="' . ($optmize_script ? pSQL($optmize_script) : 'php') . '" WHERE id_image ="' . (int)$image['id_image'] . '" AND type_image ="' . pSQL($type['name']) . '"');
}
$this->_saveTotalImageOpimized($path . '-' . Tools::stripslashes($type['name']) . '.jpg');
} elseif (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'tynypng' && !Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image` WHERE quality="' . (int)$quality . '" AND id_image ="' . (int)$image['id_image'] . '" AND type_image ="' . pSQL($type['name']) . '"')) {
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_product_image` SET quality ="' . (int)$quality . '" WHERE id_image ="' . (int)$image['id_image'] . '" AND type_image ="' . pSQL($type['name']) . '"');
$this->_saveTotalImageOpimized($path . '-' . Tools::stripslashes($type['name']) . '.jpg');
}
}
}
}
if (Module::isInstalled('ets_multilangimages') && Module::isEnabled('ets_multilangimages')) {
$ets_MultiLangImage = Module::getInstanceByName('ets_multilangimages');
$images = Db::getInstance()->executeS('
SELECT i.id_image_lang FROM `' . _DB_PREFIX_ . 'ets_image_lang` i
LEFT JOIN `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` pi ON i.id_image_lang = pi.id_image_lang AND pi.type_image="' . pSQL($type['name']) . '"' . (string)$and_quality . '
WHERE pi.id_image_lang is NULL LIMIT 0 ,' . (int)$this->number_optimize);
if ($images) {
$ok = true;
foreach ($images as $image) {
$path = $ets_MultiLangImage->getPathForCreation($image['id_image_lang']);
foreach ($types as $type) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` WHERE id_image_lang = ' . (int)$image['id_image_lang'] . ' AND type_image="' . pSQL($type['name']) . '" AND quality!=100';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` WHERE id_image_lang = ' . (int)$image['id_image_lang'] . ' AND type_image="' . pSQL($type['name']) . '"' . ($optmize_script != 'tynypng' || $quality == 100 ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL($optmize_script) . '"' : '');
if (!Db::getInstance()->getRow($sql)) {
$optimizied = (int)Db::getInstance()->getValue('SELECT id_image_lang FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` WHERE id_image_lang = "' . (int)$image['id_image_lang'] . '" AND type_image like "' . pSQL($type['name']) . '"', false);
if ($size_old = self::createImage($path, $type, $optimizied)) {
if (self::checkOptimizeImageResmush()) {
$url_image = $ets_MultiLangImage->getLangImageLink($image['id_image_lang'], $type['name']);
} else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` WHERE id_image_lang = ' . (int)$image['id_image_lang'] . ' AND type_image="' . pSQL($type['name']) . '"');
$compress = $this->compress($path, $type, $quality, $url_image, $quality_old);
while ($compress === false) {
$compress = $this->compress($path, $type, $quality, $url_image, $quality_old);
}
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` (id_image_lang,type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$image['id_image_lang'] . '","' . pSQL($type['name']) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQL($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` SET quality ="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new ="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_image_lang ="' . (int)$image['id_image_lang'] . '" AND type_image ="' . pSQL($type['name']) . '"');
} else {
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` (id_image_lang,type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$image['id_image_lang'] . '","' . pSQL($type['name']) . '","' . (int)$quality . '","0","0","' . ($optmize_script ? pSQL($optmize_script) : 'php') . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` SET quality ="' . (int)$quality . '",size_old="0",size_new ="0",optimize_type="' . ($optmize_script ? pSQL($optmize_script) : 'php') . '" WHERE id_image_lang ="' . (int)$image['id_image_lang'] . '" AND type_image ="' . pSQL($type['name']) . '"');
}
$this->_saveTotalImageOpimized($path . '-' . Tools::stripslashes($type['name']) . '.jpg');
} elseif (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'tynypng' && !Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` WHERE quality="' . (int)$quality . '" AND id_image_lang ="' . (int)$image['id_image_lang'] . '" AND type_image ="' . pSQL($type['name']) . '"')) {
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_product_image_lang` SET quality ="' . (int)$quality . '" WHERE id_image_lang ="' . (int)$image['id_image_lang'] . '" AND type_image ="' . pSQL($type['name']) . '"');
$this->_saveTotalImageOpimized($path . '-' . Tools::stripslashes($type['name']) . '.jpg');
}
}
}
}
}
}
}
if ($ok) {
die(
json_encode(
array(
'resume' => true,
'optimize_type' => 'products',
'limit_optimized' => 0,
)
)
);
} else {
return true;
}
}
public function _saveTotalImageOpimized($image)
{
$total_image_optimized = (int)Configuration::get('ETS_SP_TOTAL_IMAGE_OPTIMIZED') + 1;
$total_optimize_images = (int)Tools::getValue('total_optimize_images');
Configuration::updateValue('ETS_SP_TOTAL_IMAGE_OPTIMIZED', $total_image_optimized);
if ($images = Configuration::get('ETS_SP_LIST_IMAGE_OPTIMIZED')) {
$images = explode(',', $images);
if (count($images) < 5)
$images[] = $image;
else
$images[4] = $image;
Configuration::updateValue('ETS_SP_LIST_IMAGE_OPTIMIZED', implode(',', $images));
} else
Configuration::updateValue('ETS_SP_LIST_IMAGE_OPTIMIZED', $image);
if ($total_image_optimized % $this->number_optimize == 0) {
die(
json_encode(
array_merge(array('restart' => 1), $this->getPercentageImageOptimize($total_optimize_images))
)
);
}
}
public function optimiziObjImage($table, $type_obj, $path, $all_type = false, $next = '')
{
$optmize_script = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT');
$quality = ($quality = Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE')) ? $quality : 90;
if ($all_type)
$types = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'image_type` WHERE ' . pSQL($type_obj) . '=1');
else
$types = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'image_type` WHERE ' . pSQL($type_obj) . '=1 AND name IN ("' . implode('","', array_map('pSQL', explode(',', Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_' . Tools::strtoupper($table) . '_TYPE')))) . '")');
$ok = false;
if ($types) {
if ($types) {
$ETS_SPEED_UPDATE_QUALITY = (int)Ets_superspeed::getQantityOptimize();
foreach ($types as $type) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$and_quality = ' AND pi.quality!=100';
else
$and_quality = ($optmize_script != 'tynypng' || $quality == 100 || !$ETS_SPEED_UPDATE_QUALITY ? ' AND pi.quality="' . (int)$quality . '"' : ' AND pi.quality!=100') . ($quality != 100 ? ' AND pi.optimize_type = "' . pSQL($optmize_script) . '"' : '');
$objects = Db::getInstance()->executeS('
SELECT o.id_' . bqSQL($table) . ' FROM ' . _DB_PREFIX_ . bqSQL($table) . ' o
LEFT JOIN `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` pi ON o.id_' . bqSQL($table) . ' = pi.id_' . bqSQL($table) . ' AND pi.type_image="' . pSQL($type['name']) . '" AND pi.id_' . bqSQL($table) . '!="" ' . (string)$and_quality . '
WHERE pi.id_' . bqSQL($table) . ' is NULL LIMIT 0 ,' . (int)$this->number_optimize);
if ($objects) {
$ok = true;
foreach ($objects as $object) {
$path_image = $path . $object['id_' . $table];
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '" AND quality!=100';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '"' . ($optmize_script != 'tynypng' || $quality == 100 ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL($optmize_script) . '"' : '');
if (!Db::getInstance()->getRow($sql)) {
$optimizied = Db::getInstance()->getValue('SELECT id_' . bqSQL($table) . ' FROM `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '"', false);
if ($size_old = self::createImage($path_image, $type, $optimizied)) {
if (self::checkOptimizeImageResmush())
$url_image = $this->getLinkTable($table) . $object['id_' . $table] . '-' . $type['name'] . '.jpg';
else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '" AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"');
$compress = $this->compress($path_image, $type, $quality, $url_image, $quality_old);
while ($compress === false)
$compress = $this->compress($path_image, $type, $quality, $url_image, $quality_old);
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$object['id_' . $table] . '","' . pSQL($type['name']) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '"');
$this->_saveTotalImageOpimized($path . '-' . Tools::stripslashes($type['name']) . '.jpg');
} else {
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$object['id_' . $table] . '","' . pSQL($type['name']) . '","' . (int)$quality . '","0","0","' . pSQl($optmize_script) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="0",size_new="0",optimize_type="' . pSQL($optmize_script) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '"');
}
} elseif (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'tynypng' && !Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` WHERE quality="' . (int)$quality . '" AND id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '"')) {
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type['name']) . '"');
$this->_saveTotalImageOpimized($path . '-' . Tools::stripslashes($type['name']) . '.jpg');
}
}
}
}
}
}
unset($next);
if ($ok)
die(
json_encode(
array(
'resume' => true,
'optimize_type' => $type_obj,
'limit_optimized' => 0,
)
)
);
else {
return true;
}
}
public function getLinkTable($table, $type = '')
{
$module = Module::getInstanceByName('ets_superspeed');
if ($table == 'category')
return $module->getBaseLink() . '/img/c/';
elseif ($table == 'manufacturer')
return $module->getBaseLink() . '/img/m/';
elseif ($table == 'blog_post') {
$ybc_blog = Module::getInstanceByName('ybc_blog');
if (version_compare($ybc_blog->version, '3.2.1', '>='))
return $module->getBaseLink() . '/img/ybc_blog/post/' . ($type == 'thumb' ? 'thumb/' : '');
else
return $module->getBaseLink() . '/modules/ybc_blog/views/img/post/' . ($type == 'thumb' ? 'thumb/' : '');
} elseif ($table == 'blog_category') {
$ybc_blog = Module::getInstanceByName('ybc_blog');
if (version_compare($ybc_blog->version, '3.2.1', '>='))
return $module->getBaseLink() . '/img/ybc_blog/category/' . ($type == 'thumb' ? 'thumb/' : '');
else
return $module->getBaseLink() . '/modules/ybc_blog/views/img/category/' . ($type == 'thumb' ? 'thumb/' : '');
} elseif ($table == 'blog_gallery') {
$ybc_blog = Module::getInstanceByName('ybc_blog');
if (version_compare($ybc_blog->version, '3.2.1', '>='))
return $module->getBaseLink() . '/img/ybc_blog/gallery/' . ($type == 'thumb' ? 'thumb/' : '');
else
return $module->getBaseLink() . '/modules/ybc_blog/views/img/gallery/' . ($type == 'thumb' ? 'thumb/' : '');
} else
return $module->getBaseLink() . '/img/su/';
}
public function optimiziBlogImage($table, $path, $all_type = false, $next = '')
{
$ybc_blog = Module::getInstanceByName('ybc_blog');
if (version_compare($ybc_blog->version, '3.2.0', '<'))
return $this->optimiziBlogImage_2_1_9($table, $path, $all_type, $next);
$quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE') ?: 90;
$optmize_script = (string)Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT');
if ($all_type)
if ($table == 'slide')
$types = array('image');
else
$types = array('image', 'thumb');
else
$types = explode(',', Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_BLOG_' . Tools::strtoupper($table) . '_TYPE'));
$ok = false;
if ($types) {
foreach ($types as $type) {
if ($type) {
if ($type == 'thumb')
$path .= 'thumb/';
$ETS_SPEED_UPDATE_QUALITY = (int)Ets_superspeed::getQantityOptimize();
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$end_quality = ' AND quality!=100';
else
$end_quality = ($optmize_script != 'tynypng' || $quality == 100 || !$ETS_SPEED_UPDATE_QUALITY ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL($optmize_script) . '"' : '');
$objects = Db::getInstance()->executeS('SELECT bl.* FROM `' . _DB_PREFIX_ . 'ybc_blog_' . bqSQL($table) . '_lang` bl
LEFT JOIN `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` bli ON bl.' . bqSQL($type) . ' = bli.' . pSQL($type) . ' AND type_image="' . pSQL($type) . '" AND bli.id_' . bqSQL($table) . '=bl.id_' . bqSQL($table) . (string)$end_quality . '
WHERE bli.id_' . bqSQL($table) . ' is NULL AND bl.' . bqSQL($type) . '!="" LIMIT 0,' . (int)$this->number_optimize, true, false);
if ($objects) {
$ok = true;
foreach ($objects as $object) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND quality!=100 AND ' . bqSQL($type) . ' = "' . pSQL($object[$type]) . '"';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND ' . bqSQL($type) . ' = "' . pSQL($object[$type]) . '"' . ($optmize_script != 'tynypng' || $quality == 100 ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL($optmize_script) . '"' : '');
if (!Db::getInstance()->getRow($sql, false)) {
$optimizied = Db::getInstance()->getValue('SELECT id_' . bqSQL($table) . ' FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND ' . bqSQL($type) . ' = "' . pSQL($object[$type]) . '"', false);
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $object[$type])) {
if (self::checkOptimizeImageResmush())
$url_image = $this->getLinkTable('blog_' . $table, $type) . $object[$type];
else
$url_image = null;
$compress = $this->compress($path, $object[$type], $quality, $url_image, false);
while ($compress === false)
$compress = $this->compress($path, $object[$type], $quality, $url_image, false);
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type,`' . bqSQL($type) . '`) VALUES("' . (int)$object['id_' . $table] . '","' . pSQL($type) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '","' . pSQL($object[$type]) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND `' . bqSQL($type) . '` = "' . pSQL($object[$type]) . '"');
$this->_saveTotalImageOpimized($path . $object[$type]);
} else {
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type,`' . (pSQL($type)) . '`) VALUES("' . (int)$object['id_' . $table] . '","' . pSQL($type) . '","' . (int)$quality . '","0","0","' . pSQl($optmize_script) . '","' . pSQL($object[$type]) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="0",size_new="0",optimize_type="' . pSQL($optmize_script) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND ' . bqSQL($type) . ' = "' . pSQL($object[$type]) . '" ');
}
} elseif (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'tynypng' && !Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE quality="' . (int)$quality . '" AND id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND ' . bqSQL($type) . ' = "' . pSQL($object[$type]) . '" ')) {
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND ' . bqSQL($type) . ' = "' . pSQL($object[$type]) . '"');
$this->_saveTotalImageOpimized($path . $object[$type]);
}
}
}
}
}
}
unset($next);
if ($ok) {
die(
json_encode(
array(
'resume' => true,
'optimize_type' => $table,
'limit_optimized' => 0,
)
)
);
} else
return true;
}
public function optimiziBlogImage_2_1_9($table, $path, $all_type = false, $next = '')
{
$quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE') ?: 90;
$optmize_script = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT');
if ($all_type)
if ($table == 'slide')
$types = array('image');
else
$types = array('image', 'thumb');
else
$types = explode(',', Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_BLOG_' . Tools::strtoupper($table) . '_TYPE'));
$ok = false;
if ($types) {
foreach ($types as $type) {
if ($type) {
if ($type == 'thumb')
$path .= 'thumb/';
$ETS_SPEED_UPDATE_QUALITY = (int)Ets_superspeed::getQantityOptimize();
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$end_quality = ' AND quality!=100';
else
$end_quality = ($optmize_script != 'tynypng' || $quality == 100 || !$ETS_SPEED_UPDATE_QUALITY ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL($optmize_script) . '"' : '');
$objects = Db::getInstance()->executeS('SELECT bl.* FROM `' . _DB_PREFIX_ . 'ybc_blog_' . bqSQL($table) . '` bl
LEFT JOIN `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` bli ON type_image="' . pSQL($type) . '" AND bli.id_' . bqSQL($table) . '=bl.id_' . bqSQL($table) .(string) $end_quality . '
WHERE bli.id_' . bqSQL($table) . ' is NULL LIMIT 0,' . (int)$this->number_optimize);
if ($objects) {
$ok = true;
foreach ($objects as $object) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '" AND quality!=100';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '"' . ($optmize_script != 'tynypng' || $quality == 100 ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL($optmize_script) . '"' : '');
if (!Db::getInstance()->getRow($sql)) {
$optimizied = Db::getInstance()->getValue('SELECT id_' . bqSQL($table) . ' FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '"', false);
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $object[$type])) {
if (self::checkOptimizeImageResmush())
$url_image = $this->getLinkTable('blog_' . $table, $type) . $object[$type];
else
$url_image = null;
$compress = $this->compress($path, $object[$type], $quality, $url_image, false);
while ($compress === false)
$compress = $this->compress($path, $object[$type], $quality, $url_image, false);
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$object['id_' . $table] . '","' . pSQL($type) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '"');
$this->_saveTotalImageOpimized($path . $object[$type]);
} else {
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$object['id_' . $table] . '","' . pSQL($type) . '","' . (int)$quality . '","0","0","' . pSQl($optmize_script) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="0",size_new="0",optimize_type="' . pSQL($optmize_script) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '"');
}
} elseif (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'tynypng' && !Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE quality="' . (int)$quality . '" AND id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '"')) {
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$object['id_' . $table] . ' AND type_image="' . pSQL($type) . '"');
$this->_saveTotalImageOpimized($path . $object[$type]);
}
}
}
}
}
}
unset($next);
if ($ok)
die(
json_encode(
array(
'resume' => true,
'optimize_type' => $table,
'limit_optimized' => 0,
)
)
);
else
return true;
}
public function optimiziSlideImage($all_type = false)
{
$module = Module::getInstanceByName('ets_superspeed');
if ($all_type || Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_HOME_SLIDE_TYPE')) {
$limit = (int)Tools::getValue('limit_optimized', 0);
$homeSlides = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'homeslider_slides_lang` LIMIT ' . (int)$limit . ',' . (int)$this->number_optimize);
$quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE') ?: 90;
$total_images = Ets_superspeed_defines::getTotalImage('home_slide', true, false, false, $all_type) - Ets_superspeed_defines::getTotalImage('home_slide', true, true, false, $all_type);
if ($homeSlides && $total_images > 0) {
$path = _PS_MODULE_DIR_ . ($this->is17 ? 'ps_imageslider' : 'homeslider') . '/images/';
$ETS_SPEED_UPDATE_QUALITY = (int)Ets_superspeed::getQantityOptimize();
foreach ($homeSlides as $homeSlide) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` WHERE id_homeslider_slides = "' . (int)$homeSlide['id_homeslider_slides'] . '" AND image="' . pSQL($homeSlide['image']) . '" AND quality!=100';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` WHERE id_homeslider_slides ="' . (int)$homeSlide['id_homeslider_slides'] . '" AND image = "' . pSQL($homeSlide['image']) . '"' . (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') != 'tynypng' || $quality == 100 ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"' : '');
if (!Db::getInstance()->getRow($sql)) {
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $homeSlide['image'])) {
if (self::checkOptimizeImageResmush())
$url_image = $module->getBaseLink() . '/modules/' . ($this->is17 ? 'ps_imageslider' : 'homeslider') . '/images/' . $homeSlide['image'];
else
$url_image = null;
$compress = $this->compress($path, $homeSlide['image'], $quality, $url_image, false);
while ($compress === false)
$compress = $this->compress($path, $homeSlide['image'], $quality, $url_image, false);
if (!Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` WHERE id_homeslider_slides="' . (int)$homeSlide['id_homeslider_slides'] . '" AND image="' . pSQL($homeSlide['image']) . '"')) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` (id_homeslider_slides,image,type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$homeSlide['id_homeslider_slides'] . '","' . pSQL($homeSlide['image']) . '", "image","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_homeslider_slides="' . (int)$homeSlide['id_homeslider_slides'] . '" AND image="' . pSQL($homeSlide['image']) . '"');
$this->_saveTotalImageOpimized($path . $homeSlide['image']);
}
} elseif (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'tynypng' && !Db::getInstance()->getRow('SELECT *FROM `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` WHERE quality="' . (int)$quality . '" AND id_homeslider_slides="' . (int)$homeSlide['id_homeslider_slides'] . '" AND image="' . pSQL($homeSlide['image']) . '"')) {
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` SET quality="' . (int)$quality . '" WHERE id_homeslider_slides="' . (int)$homeSlide['id_homeslider_slides'] . '" AND image="' . pSQL($homeSlide['image']) . '"');
$this->_saveTotalImageOpimized($path . $homeSlide['image']);
}
}
die(
json_encode(
array(
'resume' => true,
'optimize_type' => 'home_slide',
'limit_optimized' => $limit + $this->number_optimize,
)
)
);
}
if ($total_images > 0) {
json_encode(
array(
'resume' => true,
'optimize_type' => 'other_image',
'limit_optimized' => 0,
)
);
} else {
$_POST['limit_optimized'] = 0;
return true;
}
} else
json_encode(
array(
'resume' => true,
'optimize_type' => 'other_image',
'limit_optimized' => 0,
)
);
}
public function optimiziOthersImage($all_type)
{
$module = Module::getInstanceByName('ets_superspeed');
$quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE') ?: 90;
if ($all_type)
$types = array('logo', 'banner', 'themeconfig');
else
$types = explode(',', Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_OTHERS_TYPE'));
if ($types && Ets_superspeed_defines::getTotalImage('others', true, false, false, $all_type) - Ets_superspeed_defines::getTotalImage('others', true, true, false, $all_type) > 0) {
foreach ($types as $type) {
$images = array();
if ($type == 'logo') {
if (Configuration::get('PS_LOGO'))
$images[] = Configuration::get('PS_LOGO');
$path = _PS_IMG_DIR_;
} elseif ($type == 'banner') {
$languages = Language::getLanguages(false);
if ($this->is17) {
$path = _PS_MODULE_DIR_ . 'ps_banner/img/';
if (module::isInstalled('ps_banner') && Module::isEnabled('ps_banner')) {
foreach ($languages as $language) {
if (($image = Configuration::get('BANNER_IMG', $language['id_lang'])) && !in_array($image, $images))
$images[] = $image;
}
}
} else {
$path = _PS_MODULE_DIR_ . 'blockbanner/img/';
if (module::isInstalled('blockbanner') && Module::isEnabled('blockbanner')) {
foreach ($languages as $language) {
if (($image = Configuration::get('BLOCKBANNER_IMG', $language['id_lang'])) && !in_array($image, $images))
$images[] = $image;
}
}
}
} elseif ($type == 'themeconfig') {
$path = _PS_MODULE_DIR_ . 'themeconfigurator/img/';
if (Module::isInstalled('themeconfigurator') && Module::isEnabled('themeconfigurator')) {
$themeconfigurators = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'themeconfigurator` WHERE image!="" GROUP BY image');
if ($themeconfigurators) {
foreach ($themeconfigurators as $themeconfigurator)
$images[] = $themeconfigurator['image'];
}
}
}
if ($images) {
$ETS_SPEED_UPDATE_QUALITY = (int)Ets_superspeed::getQantityOptimize();
foreach ($images as $image) {
if ($ETS_SPEED_UPDATE_QUALITY && $quality != 100)
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_others_image` WHERE image = "' . pSQL($image) . '" AND type_image="' . pSQL($type) . '" AND quality!=100';
else
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_others_image` WHERE image="' . pSQL($image) . '" AND type_image="' . pSQL($type) . '"' . (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') != 'tynypng' || $quality == 100 ? ' AND quality="' . (int)$quality . '"' : ' AND quality!=100') . ($quality != 100 ? ' AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"' : '');
if (!Db::getInstance()->getRow($sql)) {
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $image)) {
if (self::checkOptimizeImageResmush()) {
if ($type == 'logo')
$url_image = $module->getBaseLink() . '/' . $image;
elseif ($type == 'banner') {
$url_image = $module->getBaseLink() . '/modules/' . ($this->is17 ? 'ps_banner' : 'blockbanner') . '/img/' . $image;
} elseif ($type == 'themeconfig') {
$url_image = $module->getBaseLink() . '/modules/themeconfigurator/img/' . $image;
} else
$url_image = null;
} else
$url_image = null;
$optimizied = Db::getInstance()->getValue('SELECT image FROM `' . _DB_PREFIX_ . 'ets_superspeed_others_image` WHERE image="' . pSQL($image) . '" AND type_image="' . pSQL($type) . '"', false);
$compress = $this->compress($path, $image, $quality, $url_image, false);
while ($compress === false)
$compress = $this->compress($path, $image, $quality, $url_image, false);
if (!$optimizied) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_others_image` (image,type_image,quality,size_old,size_new,optimize_type) VALUES("' . pSQL($image) . '","' . pSQL($type) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_others_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE image="' . pSQL($image) . '" AND type_image="' . pSQL($type) . '"');
$this->_saveTotalImageOpimized($path . $image);
}
} elseif (Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT') == 'tynypng' && !Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_others_image` WHERE quality="' . (int)$quality . '" AND image="' . pSQL($image) . '" AND type_image="' . pSQL($type) . '"')) {
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_others_image` SET quality="' . (int)$quality . '" WHERE image="' . pSQL($image) . '" AND type_image="' . pSQL($type) . '"');
$this->_saveTotalImageOpimized($path . $image);
}
}
}
}
}
}
public static function createBlogImage($path, $name, $restore = true)
{
$type_image = Tools::strtolower(Tools::substr(strrchr($name, '.'), 1));
if (in_array($type_image, array('jpg', 'gif', 'jpeg', 'png', 'webp'))) {
$name_bk = str_replace('.' . $type_image, '', $name) . '_bk.' . $type_image;
if (file_exists($path . $name_bk) && $restore) {
if (file_exists($path . $name))
unlink($path . $name);
Tools::copy($path . $name_bk, $path . $name);
@unlink($path . $name_bk);
if (file_exists($path . 'fileType'))
@unlink($path . 'fileType');
return Tools::ps_round(filesize($path . $name) / 1024, 2);
} elseif (file_exists($path . $name)) {
if (!file_exists($path . $name_bk))
Tools::copy($path . $name, $path . $name_bk);
if (file_exists($path . 'fileType'))
@unlink($path . 'fileType');
return Tools::ps_round(filesize($path . $name) / 1024, 2);
}
}
return 0;
}
protected function getPercentageSubmitImageOptimize($optimized_images, $total_optimize_images)
{
$module = Module::getInstanceByName('ets_superspeed');
$total_optimizeed = (int)$total_optimizeed = (int)Configuration::get('ETS_SP_TOTAL_IMAGE_OPTIMIZED');
if ($total_optimize_images && $total_optimizeed) {
return array(
'percent' => Tools::ps_round($total_optimizeed * 100 / $total_optimize_images, 2),
'total_optimizeed' => $total_optimizeed,
'optimized_images' => $optimized_images,
'image' => $module->getImageOptimize(true),
'ETS_SPEEP_RESUMSH' => Configuration::get('ETS_SPEEP_RESUMSH'),
);
}
return array(
'percent' => 0,
);
}
protected function getPercentageSubmitImageAllOptimize($optimized_images, $total_optimize_images)
{
$total = 0;
$total_optimizeed = 0;
$total += Ets_superspeed_defines::getTotalImage('product', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('product', true, true, true, true);
$total += Ets_superspeed_defines::getTotalImage('category', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('category', true, true, true, true);
$total += Ets_superspeed_defines::getTotalImage('supplier', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('supplier', true, true, true, true);
$total += Ets_superspeed_defines::getTotalImage('manufacturer', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('manufacturer', true, true, true, true);
if ($this->isblog) {
$total += Ets_superspeed_defines::getTotalImage('blog_post', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('blog_post', true, true, true, true);
$total += Ets_superspeed_defines::getTotalImage('blog_category', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('blog_category', true, true, true, true);
$total += Ets_superspeed_defines::getTotalImage('blog_gallery', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('blog_gallery', true, true, true, true);
$total += Ets_superspeed_defines::getTotalImage('blog_slide', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('blog_slide', true, true, true, true);
}
if ($this->isSlide) {
$total += Ets_superspeed_defines::getTotalImage('home_slide', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('home_slide', true, true, true, true);
}
$total += Ets_superspeed_defines::getTotalImage('others', true, false, false, true);
$total_optimizeed += Ets_superspeed_defines::getTotalImage('others', true, true, true, true);
$total_optimizeed2 = (int)Configuration::get('ETS_SP_TOTAL_IMAGE_OPTIMIZED');
$quality = (int)Tools::getValue('ETS_SPEED_QUALITY_OPTIMIZE', Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE'));
if ($total && $total_optimizeed) {
return array(
'percent' => Tools::ps_round($total_optimizeed * 100 / $total, 2),
'percent2' => Tools::ps_round($total_optimizeed2 * 100 / $total_optimize_images, 2),
'total_optimizeed2' => $total_optimizeed2,
'total_optimizeed' => $total_optimizeed,
'total_unoptimized' => $total - $total_optimizeed,
'optimized_images' => $optimized_images,
'percent_unoptimized' => Tools::ps_round(100 - Tools::ps_round($total_optimizeed * 100 / $total, 2), 2),
'total_size_save' => $this->getTotalSizeSave($quality),
'ETS_SPEEP_RESUMSH' => Configuration::get('ETS_SPEEP_RESUMSH'),
);
}
return array(
'percent' => 0,
);
}
public function getPercentageImageOptimize($total_optimize_images)
{
$optimized_images = array();
$list_image_optimized = Configuration::get('ETS_SP_LIST_IMAGE_OPTIMIZED');
if ($list_image_optimized) {
$list_image_optimized = explode(',', $list_image_optimized);
foreach ($list_image_optimized as $image) {
$optimized_images[] = array(
'image' => str_replace(array('/', '\\', '.'), '', Tools::substr($image, 5)),
'image_cat' => Tools::strlen($image) > 40 ? Tools::substr($image, 0, 20) . ' . . . ' . Tools::substr($image, Tools::strlen($image) - 20) : $image
);
}
}
if (Tools::isSubmit('btnSubmitImageOptimize')) {
return $this->getPercentageSubmitImageOptimize($optimized_images, $total_optimize_images);
}
if (Tools::isSubmit('btnSubmitPageCacheDashboard') || Tools::isSubmit('btnSubmitImageAllOptimize')) {
return $this->getPercentageSubmitImageAllOptimize($optimized_images, $total_optimize_images);
}
return false;
}
public function getTotalSizeSave($quality)
{
$cache_key = 'Ets_imagecompressor_optimize::getTotalSizeSave_'.$quality;
if(!Cache::isStored($cache_key)) {
$controller = Tools::getValue('controller');
if (($controller != 'AdminSuperSpeedImage' || Tools::isSubmit('ajax')) && !Tools::isSubmit('getPercentageAllImageOptimize') && $quality == 100)
$check_quality = false;
else
$check_quality = true;
$total = array(
'old' => 0,
'new' => 0,
);
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_product_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_category_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_supplier_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_manufacturer_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if(Module::isInstalled('ybc_blog'))
{
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_blog_post_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_blog_category_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_blog_slide_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_home_slide_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_others_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
if($result = Db::getInstance()->getRow('SELECT sum(size_old) as total_old,sum(size_new) as total_new FROM `'._DB_PREFIX_.'ets_superspeed_blog_gallery_image` WHERE size_new < size_old'.($check_quality ? ' AND quality="'.(int)$quality.'"' :' AND quality!=100')))
{
$total['old'] +=$result['total_old'];
$total['new'] +=$result['total_new'];
}
}
$total_save = $total['old'] - $total['new'];
$total_old = $total['old'];
if ($total_save)
$percent_save = ($total_save / $total_old) * 100;
if ($total_save < 1024)
$total_text = 'KB';
else {
$total_save = $total_save / 1024;
if ($total_save < 1024)
$total_text = 'Mb';
else {
$total_save = $total_save / 1024;
$total_text = 'Gb';
}
}
$result = $total_save >0 ? $this->l('save').' '.Tools::ps_round($total_save,2).$total_text.' ('.Tools::ps_round($percent_save,2).'%)' :'';
Cache::store($cache_key,$result);
}
return Cache::retrieve($cache_key);
}
public static function getBrowseImages($image_id = '')
{
return Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_browse_image` ' . ($image_id ? ' WHERE image_id = "' . pSQL($image_id) . '"' : '') . ' ORDER BY id_ets_superspeed_browse_image DESC');
}
public static function getUploadImages($image_name_new = '')
{
return Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_upload_image` ' . ($image_name_new ? ' WHERE image_name_new = "' . pSQL($image_name_new) . '"' : '') . ' ORDER BY id_ets_superspeed_upload_image DESC');
}
protected static function getObject($table,$primakey,$id_object)
{
$cache_key = 'Ets_superspeed_compressor_image::getObject_'.$table.'_'.$primakey.'_'.$id_object;
if(!Cache::isStored($cache_key))
{
$result = Db::getInstance()->getRow('SELECT * FROM ' . _DB_PREFIX_ . bqSQL($table) . ' WHERE ' . bqSQL($primakey) . '="' . (int)$id_object . '"');
Cache::store($cache_key,$result);
}
return Cache::retrieve($cache_key);
}
protected static function checkImageType($type,$image_type)
{
$cache_key = 'Ets_superspeed_compressor_image::checkImageType_'.$type.'_'.$image_type;
if(!Cache::isStored($cache_key))
{
$result = Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'image_type` WHERE name ="' . pSQL($type) . '" AND ' . pSQL($image_type) . '=1');
Cache::store($cache_key,$result);
}
return Cache::retrieve($cache_key);
}
public static function getImagesUnUsed($folder = 'c', $table = 'category', $primakey = 'id_category', $image_type = 'categories', $delete = false)
{
$images = glob(_PS_IMG_DIR_ . $folder . '/[1-9]*.jpg');
if ($images) {
foreach ($images as $key => $image) {
if (strpos($image, '_bk.jpg') !== false)
unset($images[$key]);
else {
$image_name = basename($image);
$image_name2 = explode('-', $image_name);
$id_object = str_replace('.jpg', '', $image_name2[0]);
if (self::getObject($table,$primakey,$id_object)) {
$type = str_replace(array($id_object . '-', '.jpg'), '', $image_name);
if ($type == $id_object || self::checkImageType($type,$image_type)) {
unset($images[$key]);
}
}
}
}
}
$total_size = 0;
if ($images) {
foreach ($images as $image) {
if ($delete) {
if (file_exists($image))
@unlink($image);
} else
$total_size += filesize($image);
}
}
$total_size = Tools::ps_round($total_size / 1024, 2);
return array(
'total_image' => Count($images),
'total_size' => $total_size < 1024 ? $total_size . 'KB' : (($total_size = Tools::ps_round($total_size / 1024, 2)) < 1024 ? $total_size . 'MB' : Tools::ps_round($total_size / 1024, 2) . 'GB'),
);
}
public static function getImagesProductUnUsed($delete = false)
{
$images = Db::getInstance()->executeS('SELECT i.id_image FROM `' . _DB_PREFIX_ . 'image` i
INNER JOIN `' . _DB_PREFIX_ . 'image_shop` ims ON (i.id_image= ims.id_image)
LEFT JOIN `' . _DB_PREFIX_ . 'product_shop` ps ON (i.id_product = ps.id_product)
WHERE ps.id_product is null AND ims.id_shop="' . (int)Context::getContext()->shop->id . '"
');
$total_image = 0;
$total_size = 0;
if ($images) {
foreach ($images as $image) {
$image_obj = new Image($image['id_image']);
if ($delete)
$image_obj->delete();
else {
$path = _PS_PROD_IMG_DIR_ . $image_obj->getImgFolder();
$product_images = glob($path . '*.jpg');
if ($product_images) {
$total_image += count($product_images);
foreach ($product_images as $product_image) {
$total_size += filesize($product_image);
}
}
}
}
}
$total_size = Tools::ps_round($total_size / 1024, 2);
return array(
'total_image' => $total_image,
'total_size' => $total_size < 1024 ? $total_size . 'KB' : (($total_size = Tools::ps_round($total_size / 1024, 2)) < 1024 ? $total_size . 'MB' : Tools::ps_round($total_size / 1024, 2) . 'GB'),
);
}
public function actionUpdateBlogImage($params)
{
$ybc_blog = Module::getInstanceByName('ybc_blog');
if (isset($params['id_post'])) {
if (!$type_images = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_BLOG_POST_TYPE'))
return false;
$table = 'post';
if (version_compare($ybc_blog->version, '3.2.1', '<'))
$path = _PS_MODULE_DIR_ . 'ybc_blog/views/img/post/';
else
$path = _PS_YBC_BLOG_IMG_DIR_ . 'post/';
$id_obj = $params['id_post'];
}
if (isset($params['id_category'])) {
if (!$type_images = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_BLOG_CATEGORY_TYPE'))
return false;
$table = 'category';
if (version_compare($ybc_blog->version, '3.2.1', '<'))
$path = _PS_MODULE_DIR_ . 'ybc_blog/views/img/category/';
else
$path = _PS_YBC_BLOG_IMG_DIR_ . 'category/';
$id_obj = $params['id_category'];
}
if (isset($params['id_gallery'])) {
if (!$type_images = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_BLOG_GALLERY_TYPE'))
return false;
$table = 'gallery';
if (version_compare($ybc_blog->version, '3.2.1', '<'))
$path = _PS_MODULE_DIR_ . 'ybc_blog/views/img/gallery/';
else
$path = _PS_YBC_BLOG_IMG_DIR_ . 'gallery/';
$id_obj = $params['id_gallery'];
}
if (isset($params['id_slide'])) {
if (!$type_images = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_BLOG_SLIDE_TYPE'))
return false;
$table = 'slide';
if (version_compare($ybc_blog->version, '3.2.1', '<'))
$path = _PS_MODULE_DIR_ . 'ybc_blog/views/img/slide/';
else
$path = _PS_YBC_BLOG_IMG_DIR_ . 'slide/';
$id_obj = $params['id_slide'];
}
$quality = ($quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE')) > 0 ? $quality : 90;
if (isset($params['image']) && $params['image'] && in_array('image', explode(',', $type_images))) {
$type = 'image';
if (version_compare($ybc_blog->version, '3.2.0', '<')) {
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $params['image'])) {
if (self::checkOptimizeImageResmush())
$url_image = $this->getLinkTable('blog_' . $table, 'image') . $params['image'];
else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '" AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"');
$compress = $this->compress($path, $params['image'], $quality, $url_image, $quality_old);
while ($compress === false) {
$compress = $this->compress($path, $params['image'], $quality, $url_image, $quality_old);
}
if (!Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = "' . (int)$id_obj . '" AND type_image="' . pSQL($type) . '"')) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$id_obj . '","' . pSQL($type) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '"');
}
} else {
$images = array();
foreach ($params['image'] as $image) {
if (!in_array($image, $images)) {
$images[] = $image;
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $image)) {
if (self::checkOptimizeImageResmush())
$url_image = $this->getLinkTable('blog_' . $table, 'image') . $image;
else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '" AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"');
$compress = $this->compress($path, $image, $quality, $url_image, $quality_old);
while ($compress === false) {
$compress = $this->compress($path, $image, $quality, $url_image, $quality_old);
}
if (!Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = "' . (int)$id_obj . '" AND type_image="' . pSQL($type) . '" AND `' . bqSQL($type) . '` = "' . pSQL($image) . '"')) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type,`' . bqSQL($type) . '`) VALUES("' . (int)$id_obj . '","' . pSQL($type) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '","' . pSQL($image) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '" AND `' . bqSQL($type) . '` = "' . pSQL($image) . '"');
}
}
}
}
}
if (isset($params['thumb']) && $params['thumb'] && in_array('thumb', explode(',', $type_images))) {
$type = 'thumb';
$path .= 'thumb/';
if (version_compare($ybc_blog->version, '3.2.0', '<')) {
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $params['thumb'])) {
if (self::checkOptimizeImageResmush())
$url_image = $this->getLinkTable('blog_' . $table, 'thumb') . $params['thumb'];
else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '" AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"');
$compress = $this->compress($path, $params['thumb'], $quality, $url_image, $quality_old);
while ($compress === false) {
$compress = $this->compress($path, $params['thumb'], $quality, $url_image, $quality_old);
}
if (!Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = "' . (int)$id_obj . '" AND type_image="' . pSQL($type) . '"')) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$id_obj . '","' . pSQL($type) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '"');
}
} else {
$thumbs = array();
foreach ($params['thumb'] as $thumb) {
if (!in_array($thumb, $thumbs)) {
if ($size_old = Ets_superspeed_compressor_image::createBlogImage($path, $thumb)) {
if (self::checkOptimizeImageResmush())
$url_image = $this->getLinkTable('blog_' . $table, 'thumb') . $thumb;
else
$url_image = null;
$quality_old = Db::getInstance()->getValue('SELECT quality FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '" AND optimize_type = "' . pSQL(Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_SCRIPT')) . '"');
$compress = $this->compress($path, $thumb, $quality, $url_image, $quality_old);
while ($compress === false) {
$compress = $this->compress($path, $thumb, $quality, $url_image, $quality_old);
}
if (!Db::getInstance()->getRow('SELECT * FROM `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` WHERE id_' . bqSQL($table) . ' = "' . (int)$id_obj . '" AND type_image="' . pSQL($type) . '" AND thumb="' . pSQL($thumb) . '"')) {
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` (id_' . bqSQL($table) . ',type_image,quality,size_old,size_new,optimize_type,thumb) VALUES("' . (int)$id_obj . '","' . pSQL($type) . '","' . (int)$quality . '","' . (float)$size_old . '","' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '","' . pSQl($compress['optimize_type']) . '","' . pSQL($thumb) . '")');
} else
Db::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'ets_superspeed_blog_' . bqSQL($table) . '_image` SET quality="' . (int)$quality . '",size_old="' . (float)$size_old . '",size_new="' . ($compress['file_size'] < $size_old ? (float)$compress['file_size'] : (float)$size_old) . '",optimize_type="' . pSQL($compress['optimize_type']) . '" WHERE id_' . bqSQL($table) . ' = ' . (int)$id_obj . ' AND type_image="' . pSQL($type) . '" AND thumb="' . pSQL($thumb) . '"');
}
$thumbs[] = $thumb;
}
}
}
}
return true;
}
public static function optimizeImageSupplier($id_supplier)
{
$path = _PS_SUPP_IMG_DIR_ . $id_supplier;
$quality = ($quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE')) > 0 ? $quality : 90;
if (isset($_FILES) && count($_FILES) && ($sup_types = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_SUPPLIER_TYPE')) && file_exists($path . '.jpg')) {
$types = Db::getInstance()->executeS('SELECT * FROM `' . _DB_PREFIX_ . 'image_type` WHERE suppliers=1 AND name IN ("' . implode('","', array_map('pSQL', explode(',', $sup_types))) . '")');
if ($types) {
foreach ($types as $type) {
if ($size_old = self::createImage($path, $type)) {
if (self::checkOptimizeImageResmush())
$url_image = Ets_superspeed_compressor_image::getInstance()->getLinkTable('supplier') . $id_supplier . '-' . $type['name'] . '.jpg';
else
$url_image = null;
$compress = Ets_superspeed_compressor_image::getInstance()->compress($path, $type, $quality, $url_image, 0);
if ($compress) {
Db::getInstance()->execute('DELETE FROM `' . _DB_PREFIX_ . 'ets_superspeed_supplier_image` WHERE id_supplier="' . (int)$id_supplier . '" AND type_image="' . pSQL($type['name']) . '"');
Db::getInstance()->execute('INSERT INTO `' . _DB_PREFIX_ . 'ets_superspeed_supplier_image` (id_supplier,type_image,quality,size_old,size_new,optimize_type) VALUES("' . (int)$id_supplier . '","' . pSQL($type['name']) . '","' . (int)$quality . '","' . (float)$size_old . '","' . (float)$compress['file_size'] . '","' . pSQL($compress['optimize_type']) . '")');
}
}
}
}
}
return true;
}
public static function optimizeManufacturerImage($id_manufacturer)
{
$path = _PS_MANU_IMG_DIR_.$id_manufacturer;
$quality = ($quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE')) > 0 ? $quality :90;
if(isset($_FILES) && count($_FILES) && ($manu_types = Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_MANUFACTURER_TYPE')) && file_exists($path.'.jpg'))
{
$types= Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'image_type` WHERE manufacturers=1 AND name IN ("'.implode('","',array_map('pSQL',explode(',',$manu_types))).'")');
if($types)
{
foreach($types as $type)
{
if($size_old = self::createImage($path,$type))
{
if(self::checkOptimizeImageResmush())
$url_image= Ets_superspeed_compressor_image::getInstance()->getLinkTable('manufacturer').$id_manufacturer.'-'.$type['name'].'.jpg';
else
$url_image=null;
$compress = Ets_superspeed_compressor_image::getInstance()->compress($path,$type,$quality,$url_image,0);
if($compress)
{
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'ets_superspeed_manufacturer_image` WHERE id_manufacturer="'.(int)$id_manufacturer.'" AND type_image="'.pSQL($type['name']).'"');
Db::getInstance()->execute('INSERT INTO `'._DB_PREFIX_.'ets_superspeed_manufacturer_image` (id_manufacturer,type_image,quality,size_old,size_new,optimize_type) VALUES("'.(int)$id_manufacturer.'","'.pSQL($type['name']).'","'.(int)$quality.'","'.(float)$size_old.'","'.(float)$compress['file_size'].'","'.pSQL($compress['optimize_type']).'")');
}
}
}
}
}
return true;
}
public static function optimizeCategoryImage($id_category){
$path = _PS_CAT_IMG_DIR_.$id_category;
$quality = ($quality = (int)Configuration::getGlobalValue('ETS_SPEED_QUALITY_OPTIMIZE')) > 0 ? $quality : 90;
if(isset($_FILES) && count($_FILES) && ($category_types= Configuration::getGlobalValue('ETS_SPEED_OPTIMIZE_IMAGE_CATEGORY_TYPE')) && file_exists($path.'.jpg'))
{
$types= Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'image_type` WHERE categories=1 AND name IN ("'.implode('","',array_map('pSQL',explode(',',$category_types))).'")');
if($types)
{
foreach($types as $type)
{
if($size_old = self::createImage($path,$type))
{
if(self::checkOptimizeImageResmush())
$url_image= Ets_superspeed_compressor_image::getInstance()->getLinkTable('category').$id_category.'-'.$type['name'].'.jpg';
else
$url_image=null;
$compress= Ets_superspeed_compressor_image::getInstance()->compress($path,$type,$quality,$url_image,0);
if($compress)
{
Db::getInstance()->execute('DELETE FROM `'._DB_PREFIX_.'ets_superspeed_category_image` WHERE id_category="'.(int)$id_category.'" AND type_image="'.pSQL($type['name']).'"');
Db::getInstance()->execute('INSERT INTO `'._DB_PREFIX_.'ets_superspeed_category_image` (id_category,type_image,quality,size_old,size_new,optimize_type) VALUES("'.(int)$id_category.'","'.pSQL($type['name']).'","'.(int)$quality.'","'.(float)$size_old.'","'.(float)$compress['file_size'].'","'.pSQL($compress['optimize_type']).'")');
}
}
}
}
}
return true;
}
public static function getTotalImageCategories()
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImageCategories';
if(!Cache::isStored($cache_key))
{
$total =0;
$categoies = Db::getInstance()->executeS('SELECT id_category FROM `' . _DB_PREFIX_ . 'category`');
if ($categoies) {
foreach ($categoies as $category) {
if (file_exists(_PS_CAT_IMG_DIR_ . $category['id_category'] . '.jpg'))
$total++;
}
}
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImagemanufacturers()
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImagemanufacturers';
if(!Cache::isStored($cache_key))
{
$total =0;
$manufacturers = Db::getInstance()->executeS('SELECT id_manufacturer FROM `' . _DB_PREFIX_ . 'manufacturer`');
if ($manufacturers) {
foreach ($manufacturers as $manufacturer) {
if (file_exists(_PS_MANU_IMG_DIR_ . $manufacturer['id_manufacturer'] . '.jpg'))
$total++;
}
}
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImagesuppliers()
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImagesuppliers';
if(!Cache::isStored($cache_key))
{
$total =0;
$suppliers = Db::getInstance()->executeS('SELECT id_supplier FROM `' . _DB_PREFIX_ . 'supplier`');
if ($suppliers) {
foreach ($suppliers as $supplier) {
if (file_exists(_PS_SUPP_IMG_DIR_ . $supplier['id_supplier'] . '.jpg'))
$total++;
}
}
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImageProducts()
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImageProducts';
if(!Cache::isStored($cache_key))
{
$total = Db::getInstance()->getValue('SELECT COUNT(*) FROM `' . _DB_PREFIX_ . 'image`');
if (Module::isInstalled('ets_multilangimages') && Module::isEnabled('ets_multilangimages')) {
$total += Db::getInstance()->getValue('SELECT COUNT(*) FROM `' . _DB_PREFIX_ . 'ets_image_lang`');
}
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImageBlogPosts($type_image)
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImageBlogPosts_'.$type_image;
if(!Cache::isStored($cache_key))
{
if ($type_image && in_array($type_image, array('image', 'thumb')))
$total = Db::getInstance()->getValue('SELECT COUNT(DISTINCT ' . bqSQL($type_image) . ') FROM `' . _DB_PREFIX_ . 'ybc_blog_post_lang` WHERE ' . bqSQL($type_image) . '!=""');
else
$total =0;
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImageBlogCategories($type_image)
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImageBlogCategories_'.$type_image;
if(!Cache::isStored($cache_key))
{
if ($type_image && in_array($type_image, array('image', 'thumb')))
$total = Db::getInstance()->getValue('SELECT COUNT(DISTINCT ' . bqSQL($type_image) . ') FROM `' . _DB_PREFIX_ . 'ybc_blog_category_lang` WHERE ' . bqSQL($type_image) . '!=""');
else
$total =0;
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImageBlogSlide()
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImageBlogSlide';
if(!Cache::isStored($cache_key))
{
$total = Db::getInstance()->getValue('SELECT COUNT(DISTINCT image) FROM `' . _DB_PREFIX_ . 'ybc_blog_slide_lang` WHERE image!=""');
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImageBlogGalleries($type_image)
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImageBlogGalleries_'.$type_image;
if(!Cache::isStored($cache_key))
{
if ($type_image && in_array($type_image, array('image', 'thumb')))
$total = Db::getInstance()->getValue('SELECT COUNT(DISTINCT ' . bqSQL($type_image) . ') FROM `' . _DB_PREFIX_ . 'ybc_blog_gallery_lang` WHERE ' . bqSQL($type_image) . '!=""');
else
$total =0;
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImageHomeSlides()
{
$cache_key ='Ets_superspeed_compressor_image::getTotalImageHomeSlides';
if(!Cache::isStored($cache_key))
{
$total = Db::getInstance()->getValue('SELECT COUNT(DISTINCT image) FROM `' . _DB_PREFIX_ . 'homeslider_slides_lang` WHERE image!=""');;
Cache::store($cache_key,$total);
}
return Cache::retrieve($cache_key);
}
public static function getTotalImageOptimizedHomeSlides($check_quality,$quality,$check_optimize_script,$optimize_script)
{
$cache_key = 'Ets_superspeed_compressor_image::getTotalImageOptimizedHomeSlides_'.($check_quality ? $quality: '0').'_'.($check_optimize_script ? $optimize_script:'');
if(!Cache::isStored($cache_key))
{
$result = Db::getInstance()->getValue('SELECT COUNT(shsi.image) FROM `' . _DB_PREFIX_ . 'ets_superspeed_home_slide_image` shsi
INNER JOIN `' . _DB_PREFIX_ . 'homeslider_slides` hs ON (hs.id_homeslider_slides=shsi.id_homeslider_slides)
WHERE 1' . ($check_quality ? ' AND quality = "' . (int)$quality . '"' : ' AND quality!=100') . ($check_optimize_script ? ' AND optimize_type="' . pSQL($optimize_script) . '"' : ''));
Cache::store($cache_key,$result);
return $result;
}
return Cache::retrieve($cache_key);
}
}
