* @copyright 2007-2014 PrestAddon * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA */ if (!class_exists('VtemFooterCustomParams', false)) { class VtemFooterCustomParams { public $name = ''; protected $data = array(); private $languages = null; private $default_form_language = null; public $hook_assign = array(); public $context; public function __construct($name, $hook_assign = array()) { $this->context = Context::getContext(); $id_shop = $this->context->shop->id; $id_shop_group = $this->context->shop->id_shop_group; $this->name = $name; $this->hook_assign = $hook_assign; $id_lang = (int)$this->context->language->id; $result = Db::getInstance()->ExecuteS(' SELECT c.name,IFNULL('.($id_lang ? 'cl' : 'c').'.`value`, c.`value`) AS value FROM `'._DB_PREFIX_.'configuration` c '.($id_lang ? ('LEFT JOIN `'._DB_PREFIX_.'configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration` AND cl.`id_lang` = '.(int)$id_lang.')') : '').' WHERE `name` LIKE \''.pSQL($name).'%\' AND (`id_shop_group` = NULL OR `id_shop_group` = '.(int)$id_shop_group.') AND (`id_shop` = NULL OR `id_shop` = '.(int)$id_shop.')'); foreach ($result as $row) $this->data[$row['name']] = $row['value']; $this->languages(); } public function get($name, $default = '') { if (isset($this->data[$this->name.'_'.$name])) return $this->data[$this->name.'_'.$name]; else { if (Configuration::get($this->name.'_'.$name) != '') { $this->data[$this->name.'_'.$name] = Configuration::get($this->name.'_'.$name); return Configuration::get($this->name.'_'.$name); } elseif (isset($this->data[$name])) return $this->data[$name]; } return $default; } public function set($key, $value) { $this->data[$key] = $value; } public function update($name) { Configuration::updateValue($this->name.'_'.$name, Tools::getValue($name), true); } public function batchUpdate($configurations = array()) { foreach ($configurations as $config) Configuration::updateValue($this->name.'_'.$config, Tools::getValue($config), true); } public function fileTag($name, $file_option, $file_values, $file_lang_arr, $title, $attr, $li_atrr = '', $ul_attr = '') { $id = 'params_'.$name; $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public function inputTag($name, $value, $title, $attr, $li_atrr = '', $ul_attr = '', $tooltip = '') { $id = 'params_'.$name; $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public function inputTagLang($div_lang_name, $name, $arrvalue, $title, $attr, $li_atrr = '', $ul_attr = '', $tooltip = '') { self::languages(); $str_value = ''; foreach ($this->languages as $language) $str_value .= '
    '; $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public function getCategory($name, $value, $title, $attr, $li_atrr = '', $ul_attr = '', $tooltip = '', $text_all_cat = '') { $children = $this->getIndexedCategories(); $list = array(); $this->treeCategory(1, $list, $children); $cat_array = explode(',', $value); $id = 'params_'.$name; $id = str_replace('[]', '', $id); $is_selected = (in_array('', $cat_array)) ? 'selected="selected"' : ''; $options = ''; foreach ($list as $cat) { $is_selected = (in_array($cat['id_category'], $cat_array) || in_array('', $cat_array)) ? 'selected="selected"' : ''; $options .= ''; } $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public function radioBooleanTag($name, $yes_no_lang, $value, $title, $attr, $li_atrr = '', $ul_attr = '', $tooltip = '') { $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public function vtemGroupTag($title, $class, $li_atrr = '', $ul_attr = '') { $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public function vtemOverrideLinksTag($value, $title, $add_row_text, $li_atrr = '', $ul_attr = '', $tooltip = '') { $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public function selectTag($name, $values = array(), $value, $title, $attr, $li_atrr = '', $ul_attr = '', $tooltip = '') { $id = 'params_'.$name; $options = ''; foreach ($values as $val => $text) { $is_selected = ($val == $value) ? 'selected="selected"' : ''; $options .= ''; } $str = ''; if ($li_atrr) $str = '
  • '.$str.'
    • '; return $str; } public static function treeCategory($id, &$list, $children, $tree = '') { if (isset($children[$id])) { if ($id != 0) $tree = $tree.' - '; foreach ($children[$id] as $v) { $v['tree'] = $tree; $list[] = $v; self::treeCategory($v['id_category'], $list, $children, $tree); } } } public function getIndexedCategories() { $id_lang = (int)$this->context->language->id; $join = 'JOIN `'._DB_PREFIX_.'category_shop` cs ON(c.`id_category` = cs.`id_category` AND cs.`id_shop` = '.(int)Context::getContext()->shop->id.')'; $all_cat = Db::getInstance()->ExecuteS(' SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `'._DB_PREFIX_.'category` c '.$join.' LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.(int)$id_lang.') LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `active` = 1 GROUP BY c.`id_category` ORDER BY `id_category` ASC'); $children = array(); if ($all_cat) { foreach ($all_cat as $v) { $pt = $v['id_parent']; $list = isset($children[$pt]) ? $children[$pt] : array(); array_push($list, $v); $children[$pt] = $list; } return $children; } return array(); } public function getIndexedCMSCategories() { $id_lang = (int)$this->context->language->id; $all_cat = Db::getInstance()->ExecuteS(' SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `'._DB_PREFIX_.'cms_category` c LEFT JOIN `'._DB_PREFIX_.'cms_category_lang` cl ON (c.`id_cms_category` = cl.`id_cms_category` AND `id_lang` = '.(int)$id_lang.') WHERE `active` = 1 GROUP BY c.`id_cms_category` ORDER BY `name` ASC'); $children = array(); if ($all_cat) { foreach ($all_cat as $v) { $pt = $v['id_parent']; $list = $children[$pt] ? $children[$pt] : array(); array_push($list, $v); $children[$pt] = $list; } return $children; } return array(); } public static function treeCMSCategory($id, &$list, $children, $tree = '') { if (isset($children[$id])) { if ($id != 0) $tree = $tree.' - '; foreach ($children[$id] as $v) { $v['tree'] = $tree; $list[] = $v; self::treeCMSCategory($v['id_cms_category'], $list, $children, $tree); } } } public function getModules() { $not_module = array($this->name); $where = ''; if (count($not_module) == 1) $where = 'WHERE m.`name` <> \''.$not_module[0].'\''; elseif (count($not_module) > 1) $where = 'WHERE m.`name` NOT IN (\''.implode("','", $not_module).'\')'; $id_shop = $this->context->shop->id; return Db::getInstance()->ExecuteS(' SELECT m.* FROM `'._DB_PREFIX_.'module` m JOIN `'._DB_PREFIX_.'module_shop` ms ON (m.`id_module` = ms.`id_module` AND ms.`id_shop` = '.(int)$id_shop.') '.$where ); } public function getModulById($id_module) { return Db::getInstance()->getRow(' SELECT m.* FROM `'._DB_PREFIX_.'module` m JOIN `'._DB_PREFIX_.'module_shop` ms ON (m.`id_module` = ms.`id_module` AND ms.`id_shop` = '.(int)$this->context->shop->id.') WHERE m.`id_module` = '.$id_module); } public function getHooksByModuleId($id_module) { $module = self::getModulById($id_module); $module_instance = Module::getInstanceByName($module['name']); $hooks = array(); if ($this->hook_assign) foreach ($this->hook_assign as $hook) { $retro_hook_name = Hook::getRetroHookName($hook); if (is_callable(array($module_instance, 'hook'.$hook)) || is_callable(array($module_instance, 'hook'.$retro_hook_name))) $hooks[] = $retro_hook_name; } $results = self::getHookByArrName($hooks); return $results; } public static function getHookById($id_hook) { return Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow(' SELECT * FROM `'._DB_PREFIX_.'hook` WHERE `id_hook` = '.$id_hook); } public static function getHookByArrName($arr_name) { $result = Db::getInstance()->ExecuteS(' SELECT `id_hook`, `name` FROM `'._DB_PREFIX_.'hook` WHERE `name` IN (\''.implode("','", $arr_name).'\')'); return $result; } public function languages() { $allow_employee_form_lang = Configuration::get('PS_BO_ALLOW_EMPLOYEE_FORM_LANG') ? Configuration::get('PS_BO_ALLOW_EMPLOYEE_FORM_LANG') : 0; if ($allow_employee_form_lang && !$this->context->cookie->employee_form_lang) $this->context->cookie->employee_form_lang = (int)Configuration::get('PS_LANG_DEFAULT'); $use_lang_from_cookie = false; $this->languages = Language::getLanguages(false); if ($allow_employee_form_lang) foreach ($this->languages as $lang) if ($this->context->cookie->employee_form_lang == $lang['id_lang']) $use_lang_from_cookie = true; if (!$use_lang_from_cookie) $this->default_form_language = (int)Configuration::get('PS_LANG_DEFAULT'); else $this->default_form_language = (int)$this->context->cookie->employee_form_lang; } public function displayFlags($languages, $default_language, $ids, $id) { if (count($languages) == 1) return false; $output = '
    '.$this->l('Choose language:').''; foreach ($languages as $language) $output .= ''.$language['name'].' '; $output .= '
    '; return $output; } public function getStrHook($module_name, $hook_name) { $module = Module::getInstanceByName($module_name); if (!$module->id) return ''; $hooks = self::getHooksByModuleId($module->id); $options = ''; if (!empty($hooks)) { foreach ($hooks as $hook) $options .= ''; } return $options; } public function vtemGetCategories() { $children = $this->getIndexedCategories(); $array_keys = array_keys($children); $first_key = array_shift($array_keys); $list = array(); $this->treeCategory($first_key, $list, $children); return $list; } } } ?>