'. $this->l('You have to configure this module for each shop'). '
'; $this->context->controller->addJqueryUI('ui.sortable'); $this->context->controller->addCSS($this->_path.'views/css/back.css'); $this->context->controller->addJS($this->_path.'views/js/jquery.colorpicker.js'); $languages = $this->context->controller->getLanguages(); $id_shop = (int)$this->context->shop->id; $id_lang = (int)$this->context->language->id; $info_menus = $this->getMenuInfo(); foreach ($info_menus as $key => $info_menu) { $info_menus[$key]['status'] = $this->displayStatus($info_menu['id_posvegamenu_item'], $info_menu['active']); } $menu_config = $this->getMenuConfig(); //echo ''; print_r($menu_config);die;
$this->context->smarty->assign(
array(
'link' => $this->context->link,
'info_menus' => $info_menus,
'url_base' => $this->context->shop->physical_uri.$this->context->shop->virtual_uri,
'secure_key' => $this->secure_key,
'menu_config' => $menu_config,
'languages' => $languages,
'id_language' =>$id_lang
)
);
return $this->display(__FILE__, 'views/templates/admin/list.tpl');
}
public function displayStatus($id_posvegamenu_item, $active)
{
$title = ((int)$active == 0 ? $this->l('Disabled') : $this->l('Enabled'));
$icon = ((int)$active == 0 ? 'icon-remove' : 'icon-check');
$class = ((int)$active == 0 ? 'btn-danger' : 'btn-success');
$html = ' '.$title.'';
return $html;
}
public function getMenuInfo($active = null)
{
$this->context = Context::getContext();
$id_shop = (int)$this->context->shop->id;
$id_lang = (int)$this->context->language->id;
return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT pi.*, pil.*
FROM '._DB_PREFIX_.'posvegamenu_item pi
LEFT JOIN '._DB_PREFIX_.'posvegamenu_item_lang pil ON pi.id_posvegamenu_item = pil.id_posvegamenu_item
LEFT JOIN '._DB_PREFIX_.'posvegamenu_item_shop pis ON pi.id_posvegamenu_item = pis.id_posvegamenu_item
WHERE pis.id_shop = '.$id_shop.' AND pil.id_lang = '.$id_lang.($active ? ' AND pi.`active` = 1' : ' ').' ORDER BY pi.position ASC, pi.id_posvegamenu_item ASC'
);
}
public function getMenuConfig(){
$languages = Language::getLanguages(false);
$fields = array(
'posvegamenu_behaviour' => Configuration::get('posvegamenu_behaviour'),
'posvegamenu_bg' => Configuration::get('posvegamenu_bg'),
'posvegamenu_bg_color' => Configuration::get('posvegamenu_bg_color'),
'posvegamenu_bg_image' => Configuration::get('posvegamenu_bg_image'),
'posvegamenu_bg_repeat' => Configuration::get('posvegamenu_bg_repeat'),
'posvegamenu_sub_animation' => Configuration::get('posvegamenu_sub_animation'),
'posvegamenu_css' => Configuration::get('posvegamenu_css'),
'posvegamenu_more_less' => Configuration::get('posvegamenu_more_less'),
);
foreach ($languages as $lang)
{
$fields['posvegamenu_title'][$lang['id_lang']] = Tools::getValue('posvegamenu_title_'.$lang['id_lang'], Configuration::get('posvegamenu_title', $lang['id_lang']));
}
return $fields;
}
protected function _postProcess()
{
$errors = array();
if(Tools::isSubmit('submitMenu')){
$languages = Language::getLanguages(false);
$values = array();
foreach ($languages as $lang){
$values['posvegamenu_title'][$lang['id_lang']] = Tools::getValue('posvegamenu_title_'.$lang['id_lang']);
}
Configuration::updateValue('posvegamenu_title', $values['posvegamenu_title']);
Configuration::updateValue('posvegamenu_behaviour', Tools::getValue('posvegamenu_behaviour'));
Configuration::updateValue('posvegamenu_bg', Tools::getValue('posvegamenu_bg'));
Configuration::updateValue('posvegamenu_bg_color', Tools::getValue('posvegamenu_bg_color'));
Configuration::updateValue('posvegamenu_bg_image', Tools::getValue('posvegamenu_bg_image'));
Configuration::updateValue('posvegamenu_bg_repeat', Tools::getValue('posvegamenu_bg_repeat'));
Configuration::updateValue('posvegamenu_sub_animation', Tools::getValue('posvegamenu_sub_animation'));
Configuration::updateValue('posvegamenu_css', Tools::getValue('posvegamenu_css'));
Configuration::updateValue('posvegamenu_more_less', Tools::getValue('posvegamenu_more_less'));
}
elseif (Tools::isSubmit('submitMenuItem'))
{
$this->_clearCache('posvegamenu.tpl');
if (Tools::getValue('id_posvegamenu_item'))
{
$menu_item = new PosVegamenuClass((int)Tools::getValue('id_posvegamenu_item'));
if (!Validate::isLoadedObject($menu_item))
{
$this->html .= $this->displayError($this->l('Invalid id_posvegamenu_item'));
return false;
}
}
else{
$menu_item = new PosVegamenuClass();
}
$menu_item->active = (int)Tools::getValue('active');
$menu_item->type_link = Tools::getValue('type_link');
$menu_item->link = Tools::getValue('link');
$menu_item->type_icon = Tools::getValue('type_icon');
$menu_item->icon_class = Tools::getValue('icon_class');
$menu_item->icon = Tools::getValue('icon_img');
$menu_item->item_class = Tools::getValue('item_class');
$menu_item->new_window = Tools::getValue('new_window');
$menu_item->submenu_type = Tools::getValue('submenu_type');
$menu_item->item_bg_color = Tools::getValue('bgcolor');
$menu_item->item_bg_colorh = Tools::getValue('bgcolor_hover');
$menu_item->item_color = Tools::getValue('link_color');
$menu_item->item_colorh = Tools::getValue('color_hover');
$menu_item->item_fontsize = Tools::getValue('fontsize');
$menu_item->item_lineheight = Tools::getValue('lineheight');
$menu_item->item_transform = Tools::getValue('transform');
$menu_item->subtitle_bg_color = Tools::getValue('subtitle_bgcolor');
$menu_item->subtitle_color = Tools::getValue('subtitle_color');
$menu_item->subtitle_fontsize = Tools::getValue('subtitle_fontsize');
$menu_item->subtitle_lineheight = Tools::getValue('subtitle_lineheight');
$menu_item->subtitle_transform = Tools::getValue('subtitle_transform');
$languages = Language::getLanguages(false);
foreach ($languages as $language)
{
$menu_item->title[$language['id_lang']] = Tools::getValue('title_'.$language['id_lang']);
$menu_item->custom_link[$language['id_lang']] = Tools::getValue('custom_link_'.$language['id_lang']);
$menu_item->subtitle[$language['id_lang']] = Tools::getValue('subtitle_'.$language['id_lang']);
}
if (!$errors)
{
if (!Tools::getValue('id_posvegamenu_item'))
{
$menu_item->position = PosVegamenuClass::getLastPosition()+1;
if (!$menu_item->add())
{
$errors[] = $this->displayError($this->l('The menu_item could not be added.'));
Tools::redirectAdmin($this->context->link->getAdminLink('AdminModules', true).'&conf=1&configure='.$this->name.'&tab_module='.$this->tab.'&module_name='.$this->name);
}
$this->generateCss();
}
else
{
if (!$menu_item->update())
{
$errors[] = $this->displayError($this->l('The menu_item could not be updated.'));
Tools::redirectAdmin($this->context->link->getAdminLink('AdminModules', true).'&conf=1&configure='.$this->name.'&tab_module='.$this->tab.'&module_name='.$this->name);
}
$this->generateCss();
}
}
return $errors;
}
elseif (Tools::isSubmit('changeStatus') && Tools::isSubmit('id_posvegamenu_item'))
{
$this->_clearCache('posvegamenu.tpl');
$menu = new PosVegamenuClass((int)Tools::getValue('id_posvegamenu_item'));
if ($menu->active == 0)
$menu->active = 1;
else
$menu->active = 0;
$res = $menu->update();
$this->html .= ($res ? $this->displayConfirmation($this->l('Configuration updated')) : $this->displayError($this->l('The configuration could not be updated.')));
Tools::redirectAdmin($this->context->link->getAdminLink('AdminModules', true).'&conf=6&configure='.$this->name.'&tab_module='.$this->tab.'&module_name='.$this->name);
}
elseif (Tools::isSubmit('delete_id_menu'))
{
$this->_clearCache('posvegamenu.tpl');
$menu_item = new PosVegamenuClass((int)Tools::getValue('delete_id_menu'));
$res = $menu_item->delete();
if (!$res)
$this->html .= $this->displayError('Could not delete.');
else{
Tools::redirectAdmin($this->context->link->getAdminLink('AdminModules', true).'&conf=1&configure='.$this->name.'&tab_module='.$this->tab.'&module_name='.$this->name.'&id_posvegamenu_item='.Tools::getValue('id_posvegamenu_item'));
$this->generateCss();
}
}
elseif(Tools::isSubmit('submitSubmenu')){
$submenu_item = new PosVegamenuSubmenuClass((int)Tools::getValue('id_posvegamenu_item'));
$submenu_item->id_posvegamenu_item = (int)Tools::getValue('id_posvegamenu_item');
$submenu_item->submenu_width = (int)Tools::getValue('submenu_width');
$submenu_item->submenu_class = Tools::getValue('submenu_class');
$submenu_item->submenu_bg = Tools::getValue('submenu_bg');
$submenu_item->submenu_bg_color = Tools::getValue('submenu_bg_color');
$submenu_item->submenu_bg_image = Tools::getValue('submenu_bg_image');
$submenu_item->submenu_bg_repeat = (int)Tools::getValue('submenu_bg_repeat');
$submenu_item->submenu_bg_position = (int)Tools::getValue('submenu_bg_position');
$submenu_item->submenu_title_color = Tools::getValue('submenu_title_color');
$submenu_item->submenu_title_colorh = Tools::getValue('submenu_title_colorh');
$submenu_item->submenu_title_fontsize = (int)Tools::getValue('submenu_title_fontsize');
$submenu_item->submenu_title_lineheight = (int)Tools::getValue('submenu_title_lineheight');
$submenu_item->submenu_title_transform = (int)Tools::getValue('submenu_title_transform');
$submenu_item->submenu_link_color = Tools::getValue('submenu_link_color');
$submenu_item->submenu_link_colorh = Tools::getValue('submenu_link_colorh');
$submenu_item->submenu_link_fontsize = (int)Tools::getValue('submenu_link_fontsize');
$submenu_item->submenu_link_lineheight = (int)Tools::getValue('submenu_link_lineheight');
$submenu_item->submenu_link_transform = (int)Tools::getValue('submenu_link_transform');
if (!$errors)
{
$submenu_item->update();
$this->generateCss();
}
return $errors;
}
}
public function renderAddForm()
{
$this->context->controller->addJS($this->_path.'views/js/jquery.colorpicker.js');
$this->context->controller->addJS($this->_path.'views/js/admin.js');
$this->context->controller->addCSS($this->_path.'views/css/back.css');
$id_posvegamenu_item = Tools::getValue('id_posvegamenu_item');
if (isset($id_posvegamenu_item))
$menu = new PosVegamenuClass($id_posvegamenu_item);
else
$menu = new PosVegamenuClass();
//echo ''; print_r($menu);die;
$languages = $this->context->controller->getLanguages();
$this->context->smarty->assign(
array(
'languages' => $languages,
'id_language' => (int)$this->context->language->id,
'token' => Tools::getAdminTokenLite('AdminModules'),
'all_options' => $this->getAllDefaultLink(),
'menu' => $menu,
'image_baseurl' => $this->_path.'views/img/icons/',
)
);
return $this->display(__FILE__, 'views/templates/admin/menu_item.tpl');
}
public function renderBuildMenu()
{
$this->context->controller->addJqueryUI('ui.sortable');
$this->context->controller->addJS(__PS_BASE_URI__.'js/tiny_mce/tiny_mce.js');
$this->context->controller->addJS(__PS_BASE_URI__.'js/admin/tinymce.inc.js');
$this->context->controller->addJS($this->_path.'views/js/jquery.colorpicker.js');
$this->context->controller->addJS($this->_path.'views/js/back.js');
$this->context->controller->addJS($this->_path.'views/js/admin.js');
$this->context->controller->addCSS($this->_path.'views/css/back.css');
$languages = $this->context->controller->getLanguages();
$id_posvegamenu_item = Tools::getValue('id_posvegamenu_item', 1);
$submenu_info = $this->getSubmenuInfo($id_posvegamenu_item);
$info_rows = $this->getRowInfo($id_posvegamenu_item);
foreach ($info_rows as $key => $info_row)
{
$info_rows[$key]['list_col'] = $this->getColInfo($info_row['id_row']);
}
//echo ''; print_r($info_rows);die;
$this->context->smarty->assign(
array(
'id_posvegamenu_item' => $id_posvegamenu_item,
'token' => Tools::getAdminTokenLite('AdminModules'),
'info_rows' => $info_rows,
'submenu_info' => $submenu_info,
'link' => $this->context->link,
'url_base' => $this->context->shop->physical_uri.$this->context->shop->virtual_uri,
'secure_key' => $this->secure_key,
'ps_links' => $this->getAllDefaultLink(),
'manufacturers' => $this->getManufacturers(),
'category_links' => $this->getCategoryOption(1, (int)$this->context->language->id, false, true, false),
'languages' => $languages,
'id_language' => (int)$this->context->language->id,
)
);
return $this->display(__FILE__, 'views/templates/admin/build_menu.tpl').$this->display(__FILE__, 'views/templates/admin/menu_submenu_config.tpl');
}
// this function is used for ajax reload
public function renderSubmenu()
{
$id_posvegamenu_item = Tools::getValue('id_posvegamenu_item', 1);
$info_rows = $this->getRowInfo($id_posvegamenu_item);
$languages = $this->context->controller->getLanguages();
foreach ($info_rows as $key => $info_row)
{
$info_rows[$key]['list_col'] = $this->getColInfo($info_row['id_row']);
}
return $this->render('views/templates/admin/build_menu.tpl', array(
'id_posvegamenu_item' => $id_posvegamenu_item,
'token' => Tools::getAdminTokenLite('AdminModules'),
'info_rows' => $info_rows,
'link' => $this->context->link,
'url_base' => $this->context->shop->physical_uri.$this->context->shop->virtual_uri,
'secure_key' => $this->secure_key,
'ps_links' => $this->getAllDefaultLink(),
'category_links' => $this->getCategoryOption(1, (int)$this->context->language->id, false, true, false),
'manufacturers' => $this->getManufacturers(),
'languages' => $languages,
'id_language' => (int)$this->context->language->id,
));
}
public function render($template, $params = array())
{
$this->smarty->assign($params);
return $this->display(__FILE__, $template);
}
public function getSubmenuInfo($id_menu, $active = null)
{
$id_shop = (int)$this->context->shop->id;
$row_infos = array();
$row_infos_rs = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
SELECT ps.*
FROM '._DB_PREFIX_.'posvegamenu_submenu ps
WHERE ps.id_posvegamenu_item = '.$id_menu.($active ? ' AND ps.`active` = 1' : ' ')
);
if (is_array($row_infos_rs) && count($row_infos_rs) > 0)
$row_infos = $row_infos_rs;
return $row_infos;
}
public function getRowInfo($id_menu, $active = null)
{
$row_infos = array();
$row_infos_rs = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT sr.*
FROM '._DB_PREFIX_.'posvegamenu_submenu_row sr
WHERE sr.id_posvegamenu_item = '.$id_menu.($active ? ' AND sr.`active` = 1' : '').' ORDER BY sr.position ASC'
);
if (is_array($row_infos_rs) && count($row_infos_rs) > 0)
$row_infos = $row_infos_rs;
return $row_infos;
}
public function getColInfo($id_row, $active = null, $is_backend = true)
{
$id_shop = (int)$this->context->shop->id;
$id_lang = (int)$this->context->language->id;
$col_infos = array();
$cols_result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT sc.*, scl.title, scl.custom_link
FROM '._DB_PREFIX_.'posvegamenu_submenu_column sc
LEFT JOIN '._DB_PREFIX_.'posvegamenu_submenu_column_lang scl ON (sc.id_posvegamenu_submenu_column = scl.id_posvegamenu_submenu_column)
WHERE sc.id_row = '.$id_row.' AND scl.`id_lang` = '.$id_lang.' AND sc.`active` = 1
ORDER BY sc.position ASC, sc.id_posvegamenu_submenu_column ASC'
);
if (is_array($cols_result) && count($cols_result) > 0)
$col_infos = $cols_result;
if (is_array($col_infos) && count($col_infos) > 0)
foreach ($col_infos as $key => $col_info)
{
$sub_menu_infos = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT psi.*,psil.*
FROM '._DB_PREFIX_.'posvegamenu_submenu_item psi
LEFT JOIN '._DB_PREFIX_.'posvegamenu_submenu_item_lang psil ON psi.id_posvegamenu_submenu_item = psil.id_posvegamenu_submenu_item
WHERE psi.id_posvegamenu_submenu_column = '.$col_info['id_posvegamenu_submenu_column'].' AND psil.id_lang = '.$id_lang.($active ? ' AND psi.`active` = 1' : '').' ORDER BY psi.position ASC, psi.id_posvegamenu_submenu_item ASC');
if (is_array($sub_menu_infos) && count($sub_menu_infos) > 0)
{
foreach ($sub_menu_infos as $key1 => $sub_menu_info)
{
$id_posvegamenu_item = Tools::getValue('id_posvegamenu_item', 1);
//if (isset($id_posvegamenu_item) && $id_posvegamenu_item > 0 && $is_backend)
$sub_menu_infos[$key1]['active'] = $sub_menu_info['active'];
switch ($sub_menu_info['type_link']) {
case 1: // category tree
$id_category = Tools::substr($sub_menu_info['category_tree'], 3, Tools::strlen($sub_menu_info['category_tree']) - 3);
$category = new Category($id_category, $this->context->language->id);
$sub_menu_infos[$key1]['categories'] = $this->getCategories($category);
//echo ''; print_r($sub_menu_infos[$key1]['categories']);die;
$sub_menu_infos[$key1]['title'] = 'Category tree: '.$category->name;
break;
case 2: // ps links
$menu_info = $this->fomartLink($sub_menu_info, $id_lang, true);
$sub_menu_infos[$key1]['link'] = $menu_info['link'];
$sub_menu_infos[$key1]['title'] = $menu_info['title'];
break;
case 3: // custom link
$sub_menu_infos[$key1]['title'] = $sub_menu_info['customlink_title'];
break;
case 4: // product
$id_prod = (int)$sub_menu_info['id_product'];
if (isset($id_prod) && $id_prod > 0)
{
$productName = Product::getProductName($id_prod);
}
$sub_menu_infos[$key1]['title'] = 'Product: '.$productName.' - ID: '.$id_prod;
break;
case 5: // banner image
$sub_menu_infos[$key1]['title'] = 'Banner image';
break;
case 6: // html
$sub_menu_infos[$key1]['title'] = 'HTML content';
break;
case 7: // manufacturer
$sub_menu_infos[$key1]['title'] = 'Manufacturer logo - ID: '.(int)$sub_menu_info['id_manufacturer'];
$sub_menu_infos[$key1]['manufacturer_logo'] = $this->context->link->getManufacturerImageLink((int)$sub_menu_info['id_manufacturer']);
$sub_menu_infos[$key1]['link'] = $this->context->link->getManufacturerLink((int)$sub_menu_info['id_manufacturer']);
break;
}
}
$col_infos[$key]['list_menu_item'] = $sub_menu_infos;
}
else
$col_infos[$key]['list_menu_item'] = array();
}
return $col_infos;
}
public function getColInfoFront($id_row, $active = null, $is_backend = true)
{
$id_shop = (int)$this->context->shop->id;
$id_lang = (int)$this->context->language->id;
$col_infos = array();
$cols_result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT sc.*, scl.title, scl.custom_link
FROM '._DB_PREFIX_.'posvegamenu_submenu_column sc
LEFT JOIN '._DB_PREFIX_.'posvegamenu_submenu_column_lang scl ON (sc.id_posvegamenu_submenu_column = scl.id_posvegamenu_submenu_column)
WHERE sc.id_row = '.$id_row.' AND scl.`id_lang` = '.$id_lang.' AND sc.`active` = 1
ORDER BY sc.position ASC, sc.id_posvegamenu_submenu_column ASC'
);
if (is_array($cols_result) && count($cols_result) > 0)
$col_infos = $cols_result;
if (is_array($col_infos) && count($col_infos) > 0)
foreach ($col_infos as $key => $col_info)
{
// echo ''; print_r($col_info);die;
if($col_info['type_link'] == 0){
$col_title_link = $this->fomartLink($col_info, $id_lang);
$col_infos[$key]['link']= $col_title_link['link'];
}
$sub_menu_infos = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT psi.*,psil.*
FROM '._DB_PREFIX_.'posvegamenu_submenu_item psi
LEFT JOIN '._DB_PREFIX_.'posvegamenu_submenu_item_lang psil ON psi.id_posvegamenu_submenu_item = psil.id_posvegamenu_submenu_item
WHERE psi.id_posvegamenu_submenu_column = '.$col_info['id_posvegamenu_submenu_column'].' AND psil.id_lang = '.$id_lang.($active ? ' AND psi.`active` = 1' : '').' ORDER BY psi.position ASC, psi.id_posvegamenu_submenu_item ASC');
if (is_array($sub_menu_infos) && count($sub_menu_infos) > 0)
{
foreach ($sub_menu_infos as $key1 => $sub_menu_info)
{
$id_posvegamenu_item = Tools::getValue('id_posvegamenu_item', 1);
$sub_menu_infos[$key1]['active'] = $sub_menu_info['active'];
switch ($sub_menu_info['type_link']) {
case 1: // category tree
$id_category = Tools::substr($sub_menu_info['category_tree'], 3, Tools::strlen($sub_menu_info['category_tree']) - 3);
$category = new Category($id_category, $this->context->language->id);
$sub_menu_infos[$key1]['categories'] = $this->getCategories($category);
break;
case 2: // ps links
$menu_info = $this->fomartLink($sub_menu_info, $id_lang, true);
$sub_menu_infos[$key1]['link'] = $menu_info['link'];
$sub_menu_infos[$key1]['title'] = $menu_info['title'];
break;
case 3: // custom link
break;
case 4: // product
$id_prod = (int)$sub_menu_info['id_product'];
if (isset($id_prod) && $id_prod > 0)
{
$productInfo = $this->getProducts($id_prod);
}
$sub_menu_infos[$key1]['product'] = $productInfo[0];
break;
case 5: // banner image
$sub_menu_infos[$key1]['image']= str_replace('/pos_ecolife/',__PS_BASE_URI__,$sub_menu_infos[$key1]['image']);
break;
case 6: // html
$sub_menu_infos[$key1]['htmlcontent']= str_replace('/pos_ecolife/',__PS_BASE_URI__,$sub_menu_infos[$key1]['htmlcontent']);
break;
case 7: // manufacturer
$sub_menu_infos[$key1]['manufacturer_logo'] = $this->context->link->getManufacturerImageLink((int)$sub_menu_info['id_manufacturer']);
$sub_menu_infos[$key1]['link'] = $this->context->link->getManufacturerLink((int)$sub_menu_info['id_manufacturer']);
break;
}
}
$col_infos[$key]['list_menu_item'] = $sub_menu_infos;
}
else
$col_infos[$key]['list_menu_item'] = array();
}
return $col_infos;
}
public function getProducts($id_product)
{
$product_info = $this->getProductByID($id_product);
if($product_info)
$result = $product_info;
$assembler = new ProductAssembler($this->context);
$presenterFactory = new ProductPresenterFactory($this->context);
$presentationSettings = $presenterFactory->getPresentationSettings();
$presenter = new ProductListingPresenter(
new ImageRetriever(
$this->context->link
),
$this->context->link,
new PriceFormatter(),
new ProductColorsRetriever(),
$this->context->getTranslator()
);
$products_for_template = [];
foreach ($result as $rawProduct) {
$products_for_template[] = $presenter->present(
$presentationSettings,
$assembler->assembleProduct($rawProduct),
$this->context->language
);
}
return $products_for_template;
}
public function getProductByID($id_product){
$nb_days_new_product = Configuration::get('PS_NB_DAYS_NEW_PRODUCT');
$id_lang =(int) Context::getContext()->language->id;
$id_shop = (int) Context::getContext()->shop->id;
$sql = 'SELECT p.*, product_shop.*, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name,
DATEDIFF(product_shop.`date_add`, DATE_SUB("'.date('Y-m-d').' 00:00:00",
INTERVAL '.(int)$nb_days_new_product.' DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl
ON (pl.`id_product` = '.$id_product.'
AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').')
LEFT JOIN `'._DB_PREFIX_.'product_shop` product_shop
ON product_shop.`id_product` = '.$id_product.'
LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop='.$id_shop.')
LEFT JOIN `'._DB_PREFIX_.'image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = '.(int)$id_lang.')
LEFT JOIN `'._DB_PREFIX_.'manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = '.$id_shop.'
AND p.`id_product` = '.(int)$id_product;
//echo ''; print_r($sql); die;
$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql, true, false);
if($result){
return Product::getProductsProperties($id_lang, $result);
}else{
return false;
}
}
public function getSubMenu($id_posvegamenu_item)
{
$submenu_info = array();
$info_rows = array();
$submenu_config = $this->getSubmenuInfo($id_posvegamenu_item, true);
if (is_array($this->getRowInfo($id_posvegamenu_item, true)) && count($this->getRowInfo($id_posvegamenu_item, true)) > 0)
{
$info_rows = $this->getRowInfo($id_posvegamenu_item, true);
foreach ($info_rows as $key => $info_row){
$info_rows[$key]['list_col'] = $this->getColInfoFront($info_row['id_row'], true, false);
}
}
$submenu_info =array(
'info_rows' => $info_rows,
'submenu_config' => $submenu_config
);
return $submenu_info;
}
public function menuExists($id)
{
$req = 'SELECT pi.`id_posvegamenu_item` as id_posvegamenu_item
FROM `'._DB_PREFIX_.'posvegamenu_item` pi
WHERE pi.`id_posvegamenu_item` = '.(int)$id;
$row = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($req);
return ($row);
}
public function hookDisplayHeader()
{
$this->context->controller->addJS($this->_path.'/views/js/front.js');
//$this->context->controller->addCSS($this->_path.'/views/css/front.css');
if (Shop::getContext() == Shop::CONTEXT_SHOP)
$this->context->controller->addCSS(($this->_path).'views/css/posvegamenu_s_'.(int)$this->context->shop->getContextShopID().'.css', 'all');
Media::addJsDef(
array(
'MORE' => $this->l('More Categories'),
'CLOSE' => $this->l('Close Categories'),
)
);
}
public function hookDisplayVegamenu()
{
$test = $this->generateCss();
$id_lang = (int)$this->context->language->id;
$id_shop = (int)Context::getContext()->shop->id;
$menu_config = $this->getMenuConfig();
$menu_config['posvegamenu_title'] = $menu_config['posvegamenu_title'][$id_lang];
$menu_config['posvegamenu_more_less'] = $menu_config['posvegamenu_more_less'];
$group_cat_result = array();
$menu_obj = new PosVegamenuClass();
$menus = $menu_obj->getMenus();
$languages = Language::getLanguages();
$new_menus = array();
foreach ($menus as $menu)
{
$menu['icon'] = str_replace('/pos_ecolife/',__PS_BASE_URI__,$menu['icon']);
$type = Tools::substr($menu['link'], 0, 3);
$id = (int)Tools::substr($menu['link'], 3, Tools::strlen($menu['link']) - 3);
if ($menu['type_link'] == 0)
{
$menu_info = $this->fomartLink($menu);
$menu['link'] = $menu_info['link'];
$menu['title'] = $menu_info['title'];
$menu['selected_item'] = $menu_info['selected_item'];
}
if($menu['submenu_type'] == 0){
$sub_menu = $this->getSubMenu($menu['id_posvegamenu_item']);
if (is_array($sub_menu) && count($sub_menu) > 0)
$menu['sub_menu'] = $sub_menu;
else
$menu['sub_menu'] = array();
}elseif($menu['submenu_type']==1 && $type == 'CAT'){
$this->respMenu = '';
$category = new Category((int)$id, $id_lang, $id_shop);
$menu['sub_menu'] = $this->getRespCategories($id, false, false, $category->level_depth, $menu_config['posvegamenu_sub_animation']);
}else{
$menu['sub_menu'] = array();
}
$new_menus[] = $menu;
}
$this->context->smarty->assign(array(
'menus' => $new_menus,
'menu_config' => $menu_config
));
return $this->display(__FILE__, 'posvegamenu.tpl', $this->getCacheId('posvegamenu'));
}
public function hookDisplayVegamenuMobile()
{
$id_lang = (int)$this->context->language->id;
$id_shop = (int)Context::getContext()->shop->id;
$menu_config = $this->getMenuConfig();
$menu_config['posvegamenu_title'] = $menu_config['posvegamenu_title'][$id_lang];
$menu_config['posvegamenu_more_less'] = $menu_config['posvegamenu_more_less'];
$group_cat_result = array();
$menu_obj = new PosVegamenuClass();
$menus = $menu_obj->getMenus();
$languages = Language::getLanguages();
$new_menus = array();
foreach ($menus as $menu)
{
$menu['icon'] = str_replace('/pos_ecolife/',__PS_BASE_URI__,$menu['icon']);
$type = Tools::substr($menu['link'], 0, 3);
$id = (int)Tools::substr($menu['link'], 3, Tools::strlen($menu['link']) - 3);
if ($menu['type_link'] == 0)
{
$menu_info = $this->fomartLink($menu);
$menu['link'] = $menu_info['link'];
$menu['title'] = $menu_info['title'];
$menu['selected_item'] = $menu_info['selected_item'];
}
if($menu['submenu_type'] == 0){
$sub_menu = $this->getSubMenu($menu['id_posvegamenu_item']);
if (is_array($sub_menu) && count($sub_menu) > 0)
$menu['sub_menu'] = $sub_menu;
else
$menu['sub_menu'] = array();
}elseif($menu['submenu_type']==1 && $type == 'CAT'){
$this->respMenu = '';
$category = new Category((int)$id, $id_lang, $id_shop);
$menu['sub_menu'] = $this->getRespCategories($id, false, false, $category->level_depth, $menu_config['posvegamenu_sub_animation']);
}else{
$menu['sub_menu'] = array();
}
$new_menus[] = $menu;
}
$this->context->smarty->assign(array(
'menus' => $new_menus,
'menu_config' => $menu_config
));
return $this->display(__FILE__, 'posvegamenu-mobile.tpl', $this->getCacheId('posvegamenu-mobile'));
}
public function fomartLink($item = null, $id_lang = null, $submenu_selection = null)
{
if (is_null($item)) return;
if (!empty($this->context->controller->php_self)) $page_name = $this->context->controller->php_self;
else
{
$page_name = Dispatcher::getInstance()->getController();
$page_name = (preg_match('/^[0-9]/', $page_name) ? 'page_'.$page_name : $page_name);
}
$link = '';
$selected_item = false;
if (is_null($id_lang)) $id_lang = (int)$this->context->language->id;
if(isset($submenu_selection)){
$type = Tools::substr($item['ps_link'], 0, 3);
$key = Tools::substr($item['ps_link'], 3, Tools::strlen($item['ps_link']) - 3);
}else{
$type = Tools::substr($item['link'], 0, 3);
$key = Tools::substr($item['link'], 3, Tools::strlen($item['link']) - 3);
}
//echo '';print_r($item);die;
$title = '';
switch ($type)
{
case 'CAT':
if ($page_name == 'category' && (int)Tools::getValue('id_category') == (int)$key) $selected_item = true;
$link = $this->context->link->getCategoryLink((int)$key, null, $id_lang);
$category = new Category($key, $id_lang);
if(!isset($submenu_selection) && $item['title']){
$title = $item['title'];
}else{
$title = $category->name;
}
break;
case 'CMS':
if ($page_name == 'cms' && (int)Tools::getValue('id_cms') == (int)$key) $selected_item = true;
$id_shop = (int)Context::getContext()->shop->id;
$link = $this->context->link->getCMSLink((int)$key, null, $id_lang, $id_shop);
$cms = new CMS($key, $id_lang, $id_shop);
//echo ''; print_r($item['title']);die;
if(!isset($submenu_selection) && $item['title']){
$title = $item['title'];
}else{
$title = $cms->meta_title;
}
break;
case 'MAN':
if ($page_name == 'manufacturer' && (int)Tools::getValue('id_manufacturer') == (int)$key) $selected_item = true;
$man = new Manufacturer((int)$key, $id_lang);
$link = $this->context->link->getManufacturerLink($man->id, $man->link_rewrite, $id_lang);
if(!isset($submenu_selection) && $item['title']){
$title = $item['title'];
}else{
$title = $man->name;
}
break;
case 'SUP':
if ($page_name == 'supplier' && (int)Tools::getValue('id_supplier') == (int)$key) $selected_item = true;
$sup = new Supplier((int)$key, $id_lang);
$link = $this->context->link->getSupplierLink($sup->id, $sup->link_rewrite, $id_lang);
if(!isset($submenu_selection) && $item['title']){
$title = $item['title'];
}else{
$title = $sup->name;
}
break;
case 'PAG':
if($key == 'homepage'){
$pag = Meta::getMetaByPage('index', $id_lang);
}else{
$pag = Meta::getMetaByPage($key, $id_lang);
}
$link = $this->context->link->getPageLink($pag['page'], true, $id_lang);
if ($page_name == $pag['page']) $selected_item = true;
if(!isset($submenu_selection) && $item['title']){
$title = $item['title'];
}else{
if ($pag['page'] == 'index')
$title = $this->l('Home');
elseif($pag['page'] == 'homepage'){
$title = $this->l('Home');
$link = $this->context->link->getPageLink('index', true, $id_lang);
}else{
$title = $pag['title'];
}
}
break;
case 'SHO':
$shop = new Shop((int)$key);
$link = $shop->getBaseURL();
$title = $shop->name;
break;
default:
$link = $item['link'];
break;
}
return array('title' => $title, 'link' => $link, 'selected_item' => $selected_item);
}
private function getManufacturers(){
$html = '';
$manufacturers = Manufacturer::getManufacturers(false, (int)$this->context->language->id, true);
//echo ''; print_r($manufacturers);die;
foreach ($manufacturers as $manufacturer){
$html .= '';
}
return $html;
}
private function getAllDefaultLink($id_lang = null, $link = false)
{
if (is_null($id_lang)) $id_lang = (int)$this->context->language->id;
$html = '';
$html .= '';
$html .= '';
$html .= '';
$html .= '';
$html .= '