* @copyright 2007-2011 PrestaShop SA * @version Release: $Revision: 7541 $ * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA */ include_once(_PS_ROOT_DIR_.'/modules/privatesales/Sale.php'); if (!defined('_CAN_LOAD_FILES_')) exit; class BlockPrivateSalesCategories extends Module { public function __construct() { $this->name = 'blockprivatesalescategories'; $this->tab = 'front_office_features'; $this->version = '2.0'; parent::__construct(); $this->displayName = $this->l('Private Sales Categories block'); $this->description = $this->l('Adds a block featuring product categories from a private sale'); } public function install() { if(!Module::isInstalled('privatesales')) { return FALSE; } if (!parent::install() OR !$this->registerHook('leftColumn') OR !$this->registerHook('displayLeftVP') OR // Temporary hooks. Do NOT hook any module on it. Some CRUD hook will replace them as soon as possible. !$this->registerHook('categoryAddition') OR !$this->registerHook('categoryUpdate') OR !$this->registerHook('categoryDeletion') OR !$this->registerHook('afterSaveAdminMeta') OR !Configuration::updateValue('BLOCK_CATEG_MAX_DEPTH', 3) OR !Configuration::updateValue('BLOCK_CATEG_DHTML', 1)) return false; Db::getInstance()->Execute(' INSERT INTO `'._DB_PREFIX_.'privatesale_module` VALUES ( (SELECT `id_module` FROM `'._DB_PREFIX_.'module` WHERE `name` = "blockprivatesalescategories"), "blockprivatesalescategories" ) '); return true; } public function uninstall() { if (!parent::uninstall() OR !Configuration::deleteByName('BLOCK_CATEG_MAX_DEPTH') OR !Configuration::deleteByName('BLOCK_CATEG_DHTML')) return false; Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'privatesale_module` WHERE `modulename` = "blockprivatesalescategories"'); return true; } public function getContent() { $output = '

'.$this->displayName.'

'; if (Tools::isSubmit('submitBlockCategories')) { $maxDepth = (int)(Tools::getValue('maxDepth')); $dhtml = Tools::getValue('dhtml'); $nbrColumns = Tools::getValue('nbrColumns',4); if ($maxDepth < 0) $output .= '
'.$this->l('Maximum depth: Invalid number.').'
'; elseif ($dhtml != 0 AND $dhtml != 1) $output .= '
'.$this->l('Dynamic HTML: Invalid choice.').'
'; else { Configuration::updateValue('BLOCK_CATEG_MAX_DEPTH', (int)($maxDepth)); Configuration::updateValue('BLOCK_CATEG_DHTML', (int)($dhtml)); Configuration::updateValue('BLOCK_CATEG_NBR_COLUMN_FOOTER', $nbrColumns); $this->_clearBlockcategoriesCache(); $output .= '
'.$this->l('Confirmation').''.$this->l('Settings updated').'
'; } } return $output.$this->displayForm(); } public function displayForm() { return '
'.$this->l('Settings').'

'.$this->l('Set the maximum depth of sublevels displayed in this block (0 = infinite)').'

'.$this->l('Activate dynamic (animated) mode for sublevels').'

'.$this->l('Set the number of footer columns').'

'; } public function getTree($resultParents, $resultIds, $maxDepth, $id_category = 1, $currentDepth = 0) { global $link; $children = array(); if (isset($resultParents[$id_category]) AND sizeof($resultParents[$id_category]) AND ($maxDepth == 0 OR $currentDepth < $maxDepth)) foreach ($resultParents[$id_category] as $subcat) $children[] = $this->getTree($resultParents, $resultIds, $maxDepth, $subcat['id_category'], $currentDepth + 1); if (!isset($resultIds[$id_category])) return false; return array('id' => $id_category, 'link' => $link->getCategoryLink($id_category, $resultIds[$id_category]['link_rewrite']), 'name' => $resultIds[$id_category]['name'], 'desc'=> $resultIds[$id_category]['description'], 'children' => $children); } public function hookdisplayLeftVP($params){ return $this->hookLeftColumn($params); } public function hookLeftColumn($params) { global $smarty, $cookie, $link; $id_customer = (int)($params['cookie']->id_customer); // Get all groups for this customer and concatenate them as a string: "1,2,3..." // It is necessary to keep the group query separate from the main select query because it is used for the cache $groups = $id_customer ? implode(', ', Customer::getGroupsStatic($id_customer)) : _PS_DEFAULT_CUSTOMER_GROUP_; $id_product = (int)(Tools::getValue('id_product', 0)); $id_category = (int)(Tools::getValue('id_category', 0)); $id_lang = (int)($params['cookie']->id_lang); $maxdepth = Configuration::get('BLOCK_CATEG_MAX_DEPTH'); if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `'._DB_PREFIX_.'category` c LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.$id_lang.') LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = 1 OR c.`id_category` = 1) '.((int)($maxdepth) != 0 ? ' AND `level_depth` <= '.(int)($maxdepth) : '').' AND cg.`id_group` IN ('.pSQL($groups).') GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC') ) return; $resultParents = array(); $resultIds = array(); foreach ($result as &$row) { $resultParents[$row['id_parent']][] = &$row; $resultIds[$row['id_category']] = &$row; } $blockCategTree = $this->getTree($resultParents, $resultIds, Configuration::get('BLOCK_CATEG_MAX_DEPTH')); unset($resultParents); unset($resultIds); $isDhtml = (Configuration::get('BLOCK_CATEG_DHTML') == 1 ? true : false); $id_category = 0; if($id_product = Tools::getValue('id_product')) { $product = new Product(intval($id_product)); $id_category = $product->id_category_default; } else { $id_category = Tools::getValue('id_category'); } if($id_category !== NULL && $id_category != FALSE) { $sale = Sale::getSaleFromCategory($id_category); if($sale->id_category == Tools::getValue('id_category')){ $smarty->assign('see_all', false); }else{ $smarty->assign('see_all', true); } if($sale) { $salecat = new Category($sale->id_category, $cookie->id_lang); $blockCategTree['id'] = $sale->id_category; $blockCategTree['name'] = $salecat->name; $blockCategTree['link'] = $link->getCategoryLink($salecat->id, $salecat->link_rewrite, $cookie->id_lang); $blockCategTree['desc'] = $salecat->description; for($i=0, $l=count($blockCategTree['children']); $i<$l; $i++) { if($blockCategTree['children'][$i]['id'] == $sale->id_category) { $blockCategTree['children'] = array($blockCategTree['children'][$i]); break; } } $blockCategTree['children'] = $blockCategTree['children'][0]['children']; } else { $blockCategTree = FALSE; } $smarty->assign(array( 'sale' => $sale, )); if (Tools::isSubmit('id_category')) { $cookie->last_visited_category = $id_category; $smarty->assign('currentCategoryId', $cookie->last_visited_category); } if (Tools::isSubmit('id_product')) { if (!isset($cookie->last_visited_category) OR !Product::idIsOnCategoryId($id_product, array('0' => array('id_category' => $cookie->last_visited_category)))) { $product = new Product($id_product); if (isset($product) AND Validate::isLoadedObject($product)) $cookie->last_visited_category = (int)($product->id_category_default); } $smarty->assign('currentCategoryId', (int)($cookie->last_visited_category)); } $smarty->assign('blockCategTree', $blockCategTree); if (file_exists(_PS_THEME_DIR_.'modules/blockcategories/blockcategories.tpl')) $smarty->assign('branche_tpl_path', _PS_THEME_DIR_.'modules/blockcategories/category-tree-branch.tpl'); else $smarty->assign('branche_tpl_path', _PS_MODULE_DIR_.'blockcategories/category-tree-branch.tpl'); $smarty->assign('isDhtml', $isDhtml); $display = $this->display(__FILE__, 'blockcategories.tpl'); return $display; } } public function hookFooter($params) { global $smarty, $cookie; $id_customer = (int)($params['cookie']->id_customer); // Get all groups for this customer and concatenate them as a string: "1,2,3..." $groups = $id_customer ? implode(', ', Customer::getGroupsStatic($id_customer)) : _PS_DEFAULT_CUSTOMER_GROUP_; $id_product = (int)(Tools::getValue('id_product', 0)); $id_category = (int)(Tools::getValue('id_category', 0)); $id_lang = (int)($params['cookie']->id_lang); $smartyCacheId = 'blockcategories|'.$groups.'_'.$id_lang.'_'.$id_product.'_'.$id_category; $maxdepth = Configuration::get('BLOCK_CATEG_MAX_DEPTH'); if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `'._DB_PREFIX_.'category` c LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.$id_lang.') LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = 1 OR c.`id_category` = 1) '.((int)($maxdepth) != 0 ? ' AND `level_depth` <= '.(int)($maxdepth) : '').' AND cg.`id_group` IN ('.pSQL($groups).') ORDER BY `level_depth` ASC, c.`position` ASC') ) return; $resultParents = array(); $resultIds = array(); foreach ($result as &$row) { $resultParents[$row['id_parent']][] = &$row; $resultIds[$row['id_category']] = &$row; } //$nbrColumns = Configuration::get('BLOCK_CATEG_NBR_COLUMNS_FOOTER'); $nbrColumns = Configuration::get('BLOCK_CATEG_NBR_COLUMN_FOOTER'); if (!$nbrColumns) $nbrColumns=3; $numberColumn = abs(sizeof($result)/$nbrColumns); $widthColumn= floor(100/$nbrColumns); $smarty->assign('numberColumn', $numberColumn); $smarty->assign('widthColumn', $widthColumn); $blockCategTree = $this->getTree($resultParents, $resultIds, Configuration::get('BLOCK_CATEG_MAX_DEPTH')); unset($resultParents); unset($resultIds); $isDhtml = (Configuration::get('BLOCK_CATEG_DHTML') == 1 ? true : false); if (Tools::isSubmit('id_category')) { $cookie->last_visited_category = $id_category; $smarty->assign('currentCategoryId', $cookie->last_visited_category); } if (Tools::isSubmit('id_product')) { if (!isset($cookie->last_visited_category) OR !Product::idIsOnCategoryId($id_product, array('0' => array('id_category' => $cookie->last_visited_category)))) { $product = new Product($id_product); if (isset($product) AND Validate::isLoadedObject($product)) $cookie->last_visited_category = (int)($product->id_category_default); } $smarty->assign('currentCategoryId', (int)($cookie->last_visited_category)); } $smarty->assign('blockCategTree', $blockCategTree); if (file_exists(_PS_THEME_DIR_.'modules/blockcategories/blockcategories_footer.tpl')) $smarty->assign('branche_tpl_path', _PS_THEME_DIR_.'modules/blockcategories/category-tree-branch.tpl'); else $smarty->assign('branche_tpl_path', _PS_MODULE_DIR_.'blockcategories/category-tree-branch.tpl'); $smarty->assign('isDhtml', $isDhtml); $display = $this->display(__FILE__, 'blockcategories_footer.tpl'); return $display; } public function hookRightColumn($params) { return $this->hookLeftColumn($params); } public function hookHeader() { Tools::addJS(_THEME_JS_DIR_.'tools/treeManagement.js'); Tools::addCSS(($this->_path).'blockcategories.css', 'all'); } private function _clearBlockcategoriesCache() { $this->_clearCache('blockcategories.tpl'); Tools::restoreCacheSettings(); } public function hookCategoryAddition($params) { $this->_clearBlockcategoriesCache(); } public function hookCategoryUpdate($params) { $this->_clearBlockcategoriesCache(); } public function hookCategoryDeletion($params) { $this->_clearBlockcategoriesCache(); } public function hookAfterSaveAdminMeta($params) { $this->_clearBlockcategoriesCache(); } public function buildSelector($params) { global $smarty, $cookie, $link; $this->quantities = array(); $this->sale = $sale = $params['sale']; $id_customer = (int) $cookie->id_customer; // Get all groups for this customer and concatenate them as a string: "1,2,3..." // It is necessary to keep the group query separate from the main select query because it is used for the cache $groups = $id_customer ? implode(', ', Customer::getGroupsStatic($id_customer)) : _PS_DEFAULT_CUSTOMER_GROUP_; $id_product = (int)(Tools::getValue('id_product', 0)); $id_category = (int)(Tools::getValue('id_category', 0)); $id_lang = (int) $cookie->id_lang; $maxdepth = ($sale->category_depth !== NULL? (int) $sale->category_depth:Configuration::get('BLOCK_CATEG_MAX_DEPTH')); if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite FROM `'._DB_PREFIX_.'category` c LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = '.$id_lang.') LEFT JOIN `'._DB_PREFIX_.'category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = 1 OR c.`id_category` = 1) '.((int)($maxdepth) != 0 ? ' AND `level_depth` <= '.(int)($maxdepth) : '').' AND cg.`id_group` IN ('.pSQL($groups).') GROUP BY id_category ORDER BY `level_depth` ASC, c.`position` ASC') ) return; $resultParents = array(); $resultIds = array(); foreach ($result as &$row) { $resultParents[$row['id_parent']][] = &$row; $resultIds[$row['id_category']] = &$row; } if($sale->avail_only == TRUE) { foreach(Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT c.`id_category`, SUM(p.`quantity`) AS `total` FROM `'._DB_PREFIX_.'product` p LEFT JOIN `'._DB_PREFIX_.'category_product` c ON c.`id_product` = p.`id_product` WHERE c.`id_category` IN ('.implode(', ', array_keys($resultIds)).') AND p.`active` = 1 GROUP BY c.`id_category` ') as $q) { $this->quantities[(int) $q['id_category']] = $q['total']; } } $blockCategTree = $this->getTree($resultParents, $resultIds, ($sale->category_depth !== NULL? (int) $sale->category_depth:Configuration::get('BLOCK_CATEG_MAX_DEPTH'))); unset($resultParents); unset($resultIds); $isDhtml = ($sale->category_dhtml > 0? (bool) ($sale->category_dhtml - 1): (Configuration::get('BLOCK_CATEG_DHTML') == 1 ? true : false)); $salecat = new Category($sale->id_category, $cookie->id_lang); $blockCategTree['id'] = $sale->id_category; $blockCategTree['name'] = $salecat->name; $blockCategTree['link'] = $link->getCategoryLink($salecat->id, $salecat->link_rewrite, $cookie->id_lang); $blockCategTree['desc'] = $salecat->description; for($i=0, $l=count($blockCategTree['children']); $i<$l; $i++) { if($blockCategTree['children'][$i]['id'] == $sale->id_category) { $blockCategTree['children'] = array($blockCategTree['children'][$i]); break; } } $blockCategTree['children'] = $blockCategTree['children'][0]['children']; $smarty->assign(array( 'privatesale_name' => $sale->title[(int) $cookie->id_lang], 'privatesale_link' => $link->getCategoryLink($sale->id_category, $sale->alias[(int) $cookie->id_lang], $cookie->id_lang), 'privatesale_id' => $sale->id_category, )); if (Tools::isSubmit('id_category')) { $cookie->last_visited_category = $id_category; $smarty->assign('currentCategoryId', $cookie->last_visited_category); } if (Tools::isSubmit('id_product')) { if (!isset($cookie->last_visited_category) OR !Product::idIsOnCategoryId($id_product, array('0' => array('id_category' => $cookie->last_visited_category)))) { $product = new Product($id_product); if (isset($product) AND Validate::isLoadedObject($product)) $cookie->last_visited_category = (int)($product->id_category_default); } $smarty->assign('currentCategoryId', (int)($cookie->last_visited_category)); } $smarty->assign('blockCategTree', $blockCategTree); if (file_exists(_PS_THEME_DIR_.'modules/blockprivatesalescategories/category-tree-branch_select.tpl')) $smarty->assign('branche_tpl_path', _PS_THEME_DIR_.'modules/blockprivatesalescategories/category-tree-branch_select.tpl'); else $smarty->assign('branche_tpl_path', _PS_MODULE_DIR_.'blockprivatesalescategories/category-tree-branch_select.tpl'); $display = $this->display(__FILE__, 'blockcategories_select_'.(int) $cookie->id_lang.'.tpl'); return $display; } }