<?php
/**
* 2012 - 2020 HiPresta
*
* MODULE Gallery
*
* @author    HiPresta <support@hipresta.com>
* @copyright HiPresta 2020
* @license   Addons PrestaShop license limitation
* @link      https://hipresta.com
*
* NOTICE OF LICENSE
*
* Don't use this module on several shops. The license provided by PrestaShop Addons
* for all its modules is valid only once for a single shop.
*/

class HiPrestaGalleryModule
{

    public function __construct($module)
    {
        $this->module = $module;
        $this->context = Context::getContext();
    }

    public function searchMetaByPage($page, $id_lang)
    {
        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
        SELECT *
        FROM '._DB_PREFIX_.'meta m
        LEFT JOIN '._DB_PREFIX_.'meta_lang ml ON m.id_meta = ml.id_meta
        WHERE  m.page LIKE \''.pSQL($page).'%\'
        AND ml.id_lang = '.(int)$id_lang.'
        '.Shop::addSqlRestrictionOnLang('ml'));
    }

    /**
    * isSelectedShopGroup "Check selected ShopGroup or no"
    * @return bool
    */
    public function isSelectedShopGroup()
    {
        if (Shop::getContext() == Shop::CONTEXT_GROUP || Shop::getContext() == Shop::CONTEXT_ALL) {
            return true;
        } else {
            return false;
        }
    }

     /**
    * createTabs "Create module admin tabe"
    * @param array $sql_select (db select)
    * @param int $page (page number)
    * @param int $pagination (pagination number)
    * @return array()
    */
    public function pagination($sql_select, $page = 1, $pagination = 50)
    {
        if (count($sql_select) > $pagination) {
            $sql_select = array_slice($sql_select, $pagination * ($page - 1), $pagination);
        }
        return $sql_select;
    }

    /**
    * createTabs "Create module admin tabe"
    * @param int $active (active or inactive tabe)
    * @param string $class_name (Admin class name)
    * @param string $class_title (Admin class title)
    * @param string $configuration (Configuration name)
    * @return bool
    */
    public function createTabs($class_name, $class_title, $configuration, $active = 0)
    {
        $langs = Language::getLanguages();
        $tab = new Tab();
        $tab->active = $active;
        $tab->class_name = $class_name;
        $tab->id_parent = 0;
        foreach ($langs as $lang) {
             $tab->name[$lang['id_lang']] = $class_title;
        }
        $tab->id_parent = 0;
        $tab->module = $this->module->name;
        $tab->add();
        Configuration::updateValue($configuration, $tab->id);
        return true;
    }

    /**
    * deleteTabs "Delete module admin tabes"
    * @param string $configuration (Configuration name)
    * @return bool
    */

    public function deleteTabs($configuration)
    {
        $tab = new Tab(Configuration::get($configuration));
        $tab->delete();
        return true;
    }

    /**
    * getModuleUrl get module url
    * @param string $prefix (adding in url parameter name)
    * @return string url
    */
    public function getModuleUrl($prefix = '')
    {
        $module_token = $this->context->link->getAdminLink(
            'AdminModules',
            true
        ).'&configure='.$this->module->name.'&tab_module='.$this->module->tab.'&module_name='.$this->module->name.$prefix;
        if ($this->module->psv >= 1.7) {
            return $module_token;
        }
        if ($this->module->psv == 1.6) {
            $host_webpath = Tools::getAdminUrl().$this->context->controller->admin_webpath;
        } else {
            $host_webpath = Tools::getHttpHost(true).__PS_BASE_URI__
            .Tools::substr(str_ireplace(_PS_ROOT_DIR_, '', getcwd()), 1);
        }
        $module_url = $host_webpath.'/'.$module_token;
        return $module_url;
    }

    /**
    * createEmailLangFiles "Automatically create language files for emails"
    * @return bool
    */

    public function createEmailLangFiles()
    {
        $languages = Language::getLanguages(false);
        $path = _PS_MODULE_DIR_.$this->module->name.'/mails/en';
        foreach ($languages as $lang) {
            if (is_dir($path)) {
                $dir = opendir($path);
                $new_path = _PS_MODULE_DIR_.$this->module->name.'/mails/'.$lang['iso_code'];
                if (!file_exists($new_path)) {
                    mkdir($new_path);
                    while (($file = readdir($dir)) !== false) {
                        if (($file != '.') && ($file != '..')) {
                            copy($path.'/'.$file, $new_path.'/'.$file);
                        }
                    }
                }
                closedir($dir);
            }
        }
        return true;
    }

    /**
     * autoRegisterHook register or un registr hooks
     * @param int $module_id (Module id)
     * @param array() $custom_hooks (if you want add others hooks)
     * @param string $module_select_hook can be array (In module selected hook name)
     * @return bool true or false
     */
    public function autoRegisterHook($module_id, $module_select_hook, $custom_hooks = array())
    {
        $hooks = $this->module->module_hooks;
        if (empty($hooks)) {
            return false;
        }
        if ($custom_hooks != null && is_array($custom_hooks)) {
            foreach ($custom_hooks as $c_hook) {
                array_push($hooks, $c_hook);
            }
        }
        if (is_array($module_select_hook)) {
            $selected_hooks = $module_select_hook;
        } else {
            $selected_hooks = array($module_select_hook);
        }
        foreach ($hooks as $hook) {
            $module_hook = Hook::getModulesFromHook(Hook::getIdByName($hook), $module_id);
            if (in_array($hook, $selected_hooks)) {
                if (empty($module_hook)) {
                    $this->module->registerHook($hook);
                }
            } else {
                if (!empty($module_hook)) {
                    $this->module->unregisterHook($hook);
                }
            }
        }
    }

    /**
     * removeDirAndFile remove folder and file
     * @param url $path (delete folder path)
     * @return bool
     */

    public function removeDirAndFile($path)
    {
        if (is_dir($path) && file_exists($path)) {
            $directorys  = array_diff(scandir($path), array('.', '..'));
            foreach ($directorys as $directory) {
                if (is_dir($path."/".$directory)) {
                    $this->module->removeDirAndFile($path."/".$directory);
                } else {
                    if (file_exists($path."/".$directory) && is_file($path."/".$directory)) {
                        unlink($path."/".$directory);
                    }
                }
            }
            rmdir($path);
        } else {
            if (file_exists($path) && is_file($path)) {
                unlink($path);
            }
        }
    }

    public function addTableColumn($table, $column, $type, $after = null)
    {
        $result = Db::getInstance()->executeS('DESCRIBE '._DB_PREFIX_.pSQL($table));
        $isset = false;
        foreach ($result as $col) {
            if ($col['Field'] == $column) {
                $isset = true;
            }
        }
        if (!$isset) {
            Db::getInstance()->execute('
                ALTER TABLE `'._DB_PREFIX_.pSQL($table).'`
                ADD '.pSQL($column).' '.pSQL($type).'
                NOT NULL
                '.($after ? 'AFTER '.pSQL($after) : ''));
        }
    }
    /**
     * deleteTableColumn remove column from tabel
     * @param string $tabel (table name)
     * @param string $columt (table  column name)
     * @return bool
     */

    public function deleteTableColumn($table, $column)
    {
        $result = Db::getInstance()->executeS('DESCRIBE '._DB_PREFIX_.pSQL($table));
        $isset = false;
        foreach ($result as $col) {
            if ($col['Field'] == $column) {
                $isset = true;
            }
        }
        if ($isset) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.pSQL($table).'` DROP '.pSQL($column));
        }
    }

    /**
     * renameTableColumn rename column from tabel
     * @param string $tabel (table name)
     * @param string $column_old_name (table  column name)
     * @param string $column_new_name (table  column new name)
     * @param string $type (table  column type)
     * @return bool
     */

    public function renameTableColumn($table, $column_old_name, $column_new_name, $type)
    {
        $result = Db::getInstance()->executeS('DESCRIBE '._DB_PREFIX_.pSQL($table));
        $isset = false;
        foreach ($result as $col) {
            if ($col['Field'] == $column_old_name) {
                $isset = true;
            }
        }
        if ($isset) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.pSQL($table).'` CHANGE  `'.pSQL($column_old_name).'` `'.pSQL($column_new_name).'` '.pSQL($type).' NOT NULL');
        }
    }

    /**
     * getImageType get image type
     * @param string $type (type)
     * @return string
     */

    public function getImageType($type)
    {
        if ($this->MODULE->psv >= 1.7) {
            $image_type = ImageType::getFormattedName($type);
        } else {
            $image_type = ImageType::getFormatedName($type);
        }
        return $image_type;
    }

    /**
     * changeTableColumnType chaneg table colum type
     * @param string $tabel (table name)
     * @param string $column (table  column name)
     * @param string $type (table  column type)
     * @return bool
     */
    public function changeTableColumnType($table, $column, $type)
    {
        $result = Db::getInstance()->executeS('DESCRIBE '._DB_PREFIX_.pSQL($table));
        $isset = false;
        foreach ($result as $col) {
            if ($col['Field'] == $column) {
                $isset = true;
            }
        }
        if ($isset) {
            Db::getInstance()->execute('ALTER TABLE `'._DB_PREFIX_.pSQL($table).'` MODIFY COLUMN `'.pSQL($column).'` '.pSQL($type).' NOT NULL');
        }
    }

    public function getDashboardModule($module_name, $free_module = false, $random = '')
    {
        $url = 'https://hipresta.com/module/hiprestashopapi/prestashopapi?secure_key=6db77b878f95ee7cb56d970e4f52f095&random='.$random.'&free_module='.$free_module.'&module_name='.$module_name;
        $headers = @get_headers($url);

        if(!isset($headers[0]) || strpos($headers[0], '404') !== false) {
            return array();
        }

        $modules = Tools::jsonDecode(Tools::file_get_contents($url, false, null, 5));
        $isset_modules = Tools::strlen(serialize($modules)) > 19 ? true : false;
        if ($isset_modules) {
            foreach ($modules as $key => $module) {
                if ($this->module->isInstalled($module->name)) {
                    unset($modules->$key);
                }
            }
        }
        if (Tools::strlen(serialize($modules)) <= 19) {
            return $this->getDashboardModule($module_name, $free_module, $random);
        }
        return $modules;
    }

    public function getModuleContent($module_name, $free_module = false, $random = '', $show_tab = false)
    {
        if ($random) {
            $modules = $this->getDashboardModule($module_name, $free_module, $random);
            $isset_modules = true;
        } else {
            $url = 'https://hipresta.com/module/hiprestashopapi/prestashopapi?secure_key=6db77b878f95ee7cb56d970e4f52f095&random='.$random.'&free_module='.$free_module.'&module_name='.$module_name;
            $headers = @get_headers($url);

            if(!isset($headers[0]) || strpos($headers[0], '404') !== false) {
                return '';
            }
            $modules = Tools::jsonDecode(Tools::file_get_contents($url, false, null, 5));
            $isset_modules = Tools::strlen(serialize($modules)) > 19 ? true : false;
            if ($isset_modules) {
                foreach ($modules as $key => $module) {
                    if ($this->module->isInstalled($module->name)) {
                        unset($modules->$key);
                    }
                }
            }
        }
        if ($show_tab) {
            return Tools::strlen(serialize($modules)) > 19 ? true : false;
        }
        $this->context->smarty->assign(
            array(
                'psv' => $this->module->psv,
                'show_module' => $isset_modules,
                'modules' => $modules,
                'free_module' => $free_module
            )
        );
    }
}