Edit History

gusman126 · April 19, 2020

Hola a todos, ultimamente estoy migrando algunas tiendas y uno de los problemas que me encuentro es la generación de miniaturas , tarda una eternidad y bloquea el sistema, por lo que he encontrado un fichero php que genera las miniaturas y por lo tanto se puede añadir a un cron

EL fichero original :

https://github.com/dvershinin/prestashop-cli/blob/master/regenerate-thumbnails.php

El fichero cambiado para que funcione desde un fichero en la raiz de la tienda

<?php

/*
 * Its simple class for resizing (all) (products) images in Prestashop
 * There is often a problem with resizing through dummy "Resize button" - PHP has timeout,
 * if not then gateway timeoout ...
 * So here it is, use it with PHP-CLI ( max_exec_time must be set to unlimited ... )
 */

// TODO Only products images
// TODO Regenerating all product images

// !!!! YOU MUST EDIT THIS
$PS_HOME        = dirname(__FILE__);    // directory wheres your PrestaShop installed
require_once dirname(__FILE__) ."/config/settings.inc.php";
$PS_IMG_PATH    = dirname(__FILE__) ."/img/p/";  // directory wheres your images

// DO NOT EDIT THIS BABY, UNLESS YOU KNOW WHAT ARE YOU DOING
require_once dirname(__FILE__) . "/config/config.inc.php";

class psThumbResizer {

    const version = 0.1;

    private $psImgDir;
    private $dbConn;
    private $tablePrefix;

    function __construct() {

    }

    function __destruct() {

    }

   
    private function getImageIds( $afterDate = false) {
        if( !$afterDate ) {
            $sql = "SELECT `id_image` FROM `" . $this->tablePrefix . "image`";
            $result = $this->dbConn->query($sql);

            if ( ( is_object( $result ) ) && ( $result->num_rows > 0 ) ) {
                while($row = $result->fetch_row()) {
                    $rows[] = $row[0];
                }
                return $rows;
            }
            return false;
        }
    }

    private function createPathToImage( $imageId ) {
        $chars = str_split( $imageId );
        foreach($chars as $char){
            $ret[] = '/' . $char;
        }
        return implode( $ret );
    }

   
    public function setPsImgDir( $psImgDir ) {
        if ( !is_dir( $psImgDir ) ) {
            die( $psImgDir . " is not a valid directory" );
        }
        $this->psImgDir = realpath( $psImgDir );
    }

    public function regenerateImages()  {
        // get Ids
        $arrImgIds = $this->getImageIds();
        $realImgPath = realpath($this->psImgDir);

        foreach ( $arrImgIds as $imagePath ) {
            $imgPath = $realImgPath . $this->createPathToImage( $imagePath ) . '/' . str_replace('/','', $imagePath) . ".jpg";
            $types = ImageType::getImagesTypes( "products" );
            if ( file_exists( $imgPath ) && filesize( $imgPath ) )
            {
                foreach ($types as $imageType)
					$thumb = substr($imgPath, 0, strrpos( $imgPath, '.' ) ).'-'.stripslashes($imageType[ 'name' ] ). '.jpg';
					if(file_exists($thumb)){
						continue;
					}
                    if (!ImageManager::resize( $imgPath, substr($imgPath, 0, strrpos( $imgPath, '.' ) ) . '-'
                            . stripslashes($imageType[ 'name' ] ) . '.jpg' ,
                            ( int ) ( $imageType[ 'width' ] ),
                            ( int ) ( $imageType[ 'height' ] ) ) )
                    {
                        echo "ERROR: Original image " . $imagePath . " is corrupt or has bad permission on folder" . PHP_EOL;
                    }
                    else {
                        echo "Regenerated image: " . substr($imgPath, 0, strrpos( $imgPath, '.' ) )
                                                   . '-' . stripslashes($imageType[ 'name' ] ) . '.jpg' . PHP_EOL;
                    }
            }
            else {
                echo "ERROR: Original image: " . $imgPath . " does not exists" . PHP_EOL;
            }
			

        }
    }
    public function dbConnect( $dbUser, $dbPass, $dbHost, $dbName, $tablePrefix ) {
        $this->dbConn = new mysqli($dbHost, $dbUser, $dbPass, $dbName);
        // Check connection
        if ($this->dbConn->connect_error) {
            die( "Connection to database failed: " . $this->dbConn->connect_error );
        }

        $this->tablePrefix = $tablePrefix;
        $this->dbConn->set_charset('utf8');
    }
}

$pstr = new psThumbResizer();
$pstr->setPsImgDir( $PS_IMG_PATH );
$pstr->dbConnect(_DB_USER_, _DB_PASSWD_, _DB_SERVER_, _DB_NAME_, _DB_PREFIX_);
$pstr->regenerateImages();

Editado. tenia un problema y era que siempre generaba los ficheros, no comprobaba si existía o no , solucionado

$thumb = substr($imgPath, 0, strrpos( $imgPath, '.' ) ).'-'.stripslashes($imageType[ 'name' ] ). '.jpg';
                   if(file_exists($thumb)){
                       continue;
                   }

gusman126 · April 17, 2020

Hola a todos, ultimamente estoy migrando algunas tiendas y uno de los problemas que me encuentro es la generación de miniaturas , tarda una eternidad y bloquea el sistema, por lo que he encontrado un fichero php que genera las miniaturas y por lo tanto se puede añadir a un cron

EL fichero original :

https://github.com/dvershinin/prestashop-cli/blob/master/regenerate-thumbnails.php

El fichero cambiado para que funcione desde un fichero en la raiz de la tienda

<?php

/*
 * Its simple class for resizing (all) (products) images in Prestashop
 * There is often a problem with resizing through dummy "Resize button" - PHP has timeout,
 * if not then gateway timeoout ...
 * So here it is, use it with PHP-CLI ( max_exec_time must be set to unlimited ... )
 */

// TODO Only products images
// TODO Regenerating all product images

// !!!! YOU MUST EDIT THIS
$PS_HOME        = dirname(__FILE__);    // directory wheres your PrestaShop installed
require_once dirname(__FILE__) ."/config/settings.inc.php";
$PS_IMG_PATH    = dirname(__FILE__) ."/img/p/";  // directory wheres your images

// DO NOT EDIT THIS BABY, UNLESS YOU KNOW WHAT ARE YOU DOING
require_once dirname(__FILE__) . "/config/config.inc.php";

class psThumbResizer {

    const version = 0.1;

    private $psImgDir;
    private $dbConn;
    private $tablePrefix;

    function __construct() {

    }

    function __destruct() {

    }

   
    private function getImageIds( $afterDate = false) {
        if( !$afterDate ) {
            $sql = "SELECT `id_image` FROM `" . $this->tablePrefix . "image`";
            $result = $this->dbConn->query($sql);

            if ( ( is_object( $result ) ) && ( $result->num_rows > 0 ) ) {
                while($row = $result->fetch_row()) {
                    $rows[] = $row[0];
                }
                return $rows;
            }
            return false;
        }
    }

    private function createPathToImage( $imageId ) {
        $chars = str_split( $imageId );
        foreach($chars as $char){
            $ret[] = '/' . $char;
        }
        return implode( $ret );
    }

   
    public function setPsImgDir( $psImgDir ) {
        if ( !is_dir( $psImgDir ) ) {
            die( $psImgDir . " is not a valid directory" );
        }
        $this->psImgDir = realpath( $psImgDir );
    }

    public function regenerateImages()  {
        // get Ids
        $arrImgIds = $this->getImageIds();
        $realImgPath = realpath($this->psImgDir);

        foreach ( $arrImgIds as $imagePath ) {
            $imgPath = $realImgPath . $this->createPathToImage( $imagePath ) . '/' . str_replace('/','', $imagePath) . ".jpg";
            $types = ImageType::getImagesTypes( "products" );
            if ( file_exists( $imgPath ) && filesize( $imgPath ) )
            {
                foreach ($types as $imageType)
                    if (!ImageManager::resize( $imgPath, substr($imgPath, 0, strrpos( $imgPath, '.' ) ) . '-'
                            . stripslashes($imageType[ 'name' ] ) . '.jpg' ,
                            ( int ) ( $imageType[ 'width' ] ),
                            ( int ) ( $imageType[ 'height' ] ) ) )
                    {
                        echo "ERROR: Original image " . $imagePath . " is corrupt or has bad permission on folder" . PHP_EOL;
                    }
                    else {
                        echo "Regenerated image: " . substr($imgPath, 0, strrpos( $imgPath, '.' ) )
                                                   . '-' . stripslashes($imageType[ 'name' ] ) . '.jpg' . PHP_EOL;
                    }
            }
            else {
                echo "ERROR: Original image: " . $imgPath . " does not exists" . PHP_EOL;
            }
			

        }
    }
    public function dbConnect( $dbUser, $dbPass, $dbHost, $dbName, $tablePrefix ) {
        $this->dbConn = new mysqli($dbHost, $dbUser, $dbPass, $dbName);
        // Check connection
        if ($this->dbConn->connect_error) {
            die( "Connection to database failed: " . $this->dbConn->connect_error );
        }

        $this->tablePrefix = $tablePrefix;
        $this->dbConn->set_charset('utf8');
    }
}

$pstr = new psThumbResizer();
$pstr->setPsImgDir( $PS_IMG_PATH );
$pstr->dbConnect(_DB_USER_, _DB_PASSWD_, _DB_SERVER_, _DB_NAME_, _DB_PREFIX_);
$pstr->regenerateImages();

gusman126 · April 17, 2020

Hola a todos, ultimamente estoy migrando algunas tiendas y uno de los problemas que me encuentro es la generación de miniaturas , tarda una eternidad y bloquea el sistema, por lo que he encontrado un fichero php que genera las miniaturas y por lo tanto se puede añadir a un cron

EL fichero original :

https://github.com/dvershinin/prestashop-cli/blob/master/regenerate-thumbnails.php

El fichero cambiado para que funcione desde un fichero en la raiz de la tienda

<?php

/*
 * Its simple class for resizing (all) (products) images in Prestashop
 * There is often a problem with resizing through dummy "Resize button" - PHP has timeout,
 * if not then gateway timeoout ...
 * So here it is, use it with PHP-CLI ( max_exec_time must be set to unlimited ... )
 */

// TODO Only products images
// TODO Regenerating all product images

// !!!! YOU MUST EDIT THIS
$PS_HOME        = dirname(__FILE__);    // directory wheres your PrestaShop installed
require_once dirname(__FILE__) ."/config/settings.inc.php";
$PS_IMG_PATH    = dirname(__FILE__) ."/img/p/";  // directory wheres your images

// DO NOT EDIT THIS BABY, UNLESS YOU KNOW WHAT ARE YOU DOING
require_once dirname(__FILE__) . "/config/config.inc.php";

class psThumbResizer {

    const version = 0.1;

    private $psImgDir;
    private $dbConn;
    private $tablePrefix;

    function __construct() {

    }

    function __destruct() {

    }

   
    private function getImageIds( $afterDate = false) {
        if( !$afterDate ) {
            $sql = "SELECT `id_image` FROM `" . $this->tablePrefix . "image`";
            $result = $this->dbConn->query($sql);

            if ( ( is_object( $result ) ) && ( $result->num_rows > 0 ) ) {
                while($row = $result->fetch_row()) {
                    $rows[] = $row[0];
                }
                return $rows;
            }
            return false;
        }
    }

    private function createPathToImage( $imageId ) {
        $chars = str_split( $imageId );
        foreach($chars as $char){
            $ret[] = '/' . $char;
        }
        return implode( $ret );
    }

   
    public function setPsImgDir( $psImgDir ) {
        if ( !is_dir( $psImgDir ) ) {
            die( $psImgDir . " is not a valid directory" );
        }
        $this->psImgDir = realpath( $psImgDir );
    }

    public function regenerateImages()  {
        // get Ids
        $arrImgIds = $this->getImageIds();
        $realImgPath = realpath($this->psImgDir);

        foreach ( $arrImgIds as $imagePath ) {
            $imgPath = $realImgPath . $this->createPathToImage( $imagePath ) . '/' . str_replace('/','', $imagePath) . ".jpg";
            $types = ImageType::getImagesTypes( "products" );
            if ( file_exists( $imgPath ) && filesize( $imgPath ) )
            {
                foreach ($types as $imageType)
                    if (!ImageManager::resize( $imgPath, substr($imgPath, 0, strrpos( $imgPath, '.' ) ) . '-'
                            . stripslashes($imageType[ 'name' ] ) . '.jpg' ,
                            ( int ) ( $imageType[ 'width' ] ),
                            ( int ) ( $imageType[ 'height' ] ) ) )
                    {
                        echo "ERROR: Original image " . $imagePath . " is corrupt or has bad permission on folder" . PHP_EOL;
                    }
                    else {
                        echo "Regenerated image: " . substr($imgPath, 0, strrpos( $imgPath, '.' ) )
                                                   . '-' . stripslashes($imageType[ 'name' ] ) . '.jpg' . PHP_EOL;
                    }
            }
            else {
                echo "ERROR: Original image: " . $imgPath . " does not exists" . PHP_EOL;
            }
			echo imgPath;
			die;

        }
    }
    public function dbConnect( $dbUser, $dbPass, $dbHost, $dbName, $tablePrefix ) {
        $this->dbConn = new mysqli($dbHost, $dbUser, $dbPass, $dbName);
        // Check connection
        if ($this->dbConn->connect_error) {
            die( "Connection to database failed: " . $this->dbConn->connect_error );
        }

        $this->tablePrefix = $tablePrefix;
        $this->dbConn->set_charset('utf8');
    }
}

$pstr = new psThumbResizer();
$pstr->setPsImgDir( $PS_IMG_PATH );
$pstr->dbConnect(_DB_USER_, _DB_PASSWD_, _DB_SERVER_, _DB_NAME_, _DB_PREFIX_);
$pstr->regenerateImages();

Sign In

Edit History

gusman126

gusman126

gusman126

Browse

Activity

Go back to prestashop.com