Jump to content

Edit History

JavierP

JavierP

hace 2 horas, 4you.software dijo:

Hi.

You can add two conditions to the beginning of the code.
If you do not want to display the module in certain categories, you will create an array of categories, if you do not want to display the module on certain pages, you will create an array of pages.


For example, I don't want to display the module in categories 2 and 6.
Enter this part of the code: 


class PartsFilter extends Module
{
	private $disabled_categories = array('2', '6');
	
	public function __construct()
	{
    .....

For example, I don't want the module to appear on the index pages and on the product detail page.
Enter this part of the code: 


class PartsFilter extends Module
{
	private $disabled_pages = array('index', 'product');
	
	public function __construct()
	{
	.....

For both options, the code will be: 


class PartsFilter extends Module
{
	private $disabled_categories = array('2', '6');
	private $disabled_pages = array('index', 'product');
	
	public function __construct()
	{
     .....

And now the most important part.
You will find a hook and add a condition until the end of the function.
For example, for hookDisplayTop, the code snippet will be: 


public function hookDisplayTop($params)
{
	...
	...
	$page_name = Dispatcher::getInstance()->getController();
	if (!in_array($page_name, $this->disabled_pages) && !in_array(Tools::getValue('id_category'), $this->disabled_categories))
	{
		return $this->display(__FILE__, 'views/templates/front/filterbox_top.tpl');
	}
}

 

For example, for hookDisplayLeftColumn, the code snippet will be: 


public function hookDisplayLeftColumn($params)
{
	...
	...
	$page_name = Dispatcher::getInstance()->getController();
	if (!in_array($page_name, $this->disabled_pages) && !in_array(Tools::getValue('id_category'), $this->disabled_categories))
	{
		return $this->display(__FILE__, 'views/templates/front/filterbox.tpl');
	}
}

 

etc.

Thank you for your quick response. I do not know, if I am making a mistake when implementing the code, but it does not work for me, it is shown in all categories. I am attaching the code, so that you can verify if I am including it correctly.😓

JavierP

JavierP

hace 57 minutos, 4you.software dijo:

Hi.

You can add two conditions to the beginning of the code.
If you do not want to display the module in certain categories, you will create an array of categories, if you do not want to display the module on certain pages, you will create an array of pages.


For example, I don't want to display the module in categories 2 and 6.
Enter this part of the code: 


class PartsFilter extends Module
{
	private $disabled_categories = array('2', '6');
	
	public function __construct()
	{
    .....

For example, I don't want the module to appear on the index pages and on the product detail page.
Enter this part of the code: 


class PartsFilter extends Module
{
	private $disabled_pages = array('index', 'product');
	
	public function __construct()
	{
	.....

For both options, the code will be: 


class PartsFilter extends Module
{
	private $disabled_categories = array('2', '6');
	private $disabled_pages = array('index', 'product');
	
	public function __construct()
	{
     .....

And now the most important part.
You will find a hook and add a condition until the end of the function.
For example, for hookDisplayTop, the code snippet will be: 


public function hookDisplayTop($params)
{
	...
	...
	$page_name = Dispatcher::getInstance()->getController();
	if (!in_array($page_name, $this->disabled_pages) && !in_array(Tools::getValue('id_category'), $this->disabled_categories))
	{
		return $this->display(__FILE__, 'views/templates/front/filterbox_top.tpl');
	}
}

 

For example, for hookDisplayLeftColumn, the code snippet will be: 


public function hookDisplayLeftColumn($params)
{
	...
	...
	$page_name = Dispatcher::getInstance()->getController();
	if (!in_array($page_name, $this->disabled_pages) && !in_array(Tools::getValue('id_category'), $this->disabled_categories))
	{
		return $this->display(__FILE__, 'views/templates/front/filterbox.tpl');
	}
}

 

etc. 

<?php
/**
* DISCLAIMER
*
*  @author    Sakosys

*  @copyright 2014-2017 SolverCircle
*  @license   http://opensource.org/licenses/LGPL-2.1
*  International Registered Trademark & Property of Sakosys
*/

if (!defined('_PS_VERSION_'))
	exit;

class PartsFilter extends Module
{
	private $active_categories = array('2', '6');

	public function __construct()
	{
	    $this->name = 'partsfilter';
		$this->tab = 'front_office_features';
		$this->version = '3.0.0';
		$this->author = 'SakoSys';
		$this->need_instance = 0;

		$this->bootstrap = true;
		parent::__construct();

		$this->displayName = $this->l('Vehicle Parts Finder');
		$this->description = $this->l('Find Your Auto Parts Based On Make Model Year');
		$this->ps_versions_compliancy = array('min' => '1.5.6.1', 'max' => _PS_VERSION_);

		$this->tabParentClassName = 'AdminCarMakeNoNeed';
        $this->parentTabName = 'Vehicle Parts Finder';
        $this->tabFirstChildName = 'Manage Make';
        $this->tabChildFirstClassName = 'AdminCarMake';
        $this->tabSecoendChildName = 'Manage Model';
        $this->tabChildSecoendClassName = 'AdminCarModel';

        $this->tabNuevoChildName = 'Manage Nuevo';
        $this->tabChildNuevoClassName = 'AdminCarNuevo';

		$this->tabChildThirdName = 'Manage Year';
        $this->tabChildThirdClassName = 'AdminCarYear';
		$this->tabChildFourthName = 'CSV Import';
        $this->tabChildFourthClassName = 'AdminMMYCSV';
		$this->tabChildFifthName = 'Product Map With Filter';
        $this->tabChildFifthClassName = 'AdminFilterAssign';
	}

	public function install()
	{
		if (!parent::install()) {
            return false;
        }
        //here add admin tab
        $tab = new Tab();
        $tab->class_name = $this->tabParentClassName;
        $tab->module = $this->name;
        $languages = Language::getLanguages();
        foreach ($languages as $language) {
            $tab->name[$language['id_lang']] = $this->parentTabName;
        }
        $tab->add();
        //here we create first child TAB
        $tab_first_child = new Tab();
        foreach ($languages as $language) {
            $tab_first_child->name[$language['id_lang']] = $this->tabFirstChildName;
        }
        $tab_first_child->class_name = $this->tabChildFirstClassName;
        $tab_first_child->id_parent = $tab->id;
        $tab_first_child->module = $this->name;
        $tab_first_child->add();
        //here we create secoend child TAB
        $tab_secoend_child = new Tab();
        foreach ($languages as $language) {
            $tab_secoend_child->name[$language['id_lang']] = $this->tabSecoendChildName;
        }
        $tab_secoend_child->class_name = $this->tabChildSecoendClassName;
        $tab_secoend_child->id_parent = $tab->id;
        $tab_secoend_child->module = $this->name;
        $tab_secoend_child->add();


        $tab_nuevo_child = new Tab();
        foreach ($languages as $language) {
            $tab_nuevo_child->name[$language['id_lang']] = $this->tabNuevoChildName;
        }
        $tab_nuevo_child->class_name = $this->tabChildNuevoClassName;
        $tab_nuevo_child->id_parent = $tab->id;
        $tab_nuevo_child->module = $this->name;
        $tab_nuevo_child->add();


		//here we create third child TAB
        $tab_third_child = new Tab();
        foreach ($languages as $language) {
            $tab_third_child->name[$language['id_lang']] = $this->tabChildThirdName;
        }
        $tab_third_child->class_name = $this->tabChildThirdClassName;
        $tab_third_child->id_parent = $tab->id;
        $tab_third_child->module = $this->name;
        $tab_third_child->add();
		//here we create fifth child TAB
        $tab_fifth_child = new Tab();
        foreach ($languages as $language) {
            $tab_fifth_child->name[$language['id_lang']] = $this->tabChildFifthName;
        }
        $tab_fifth_child->class_name = $this->tabChildFifthClassName;
        $tab_fifth_child->id_parent = $tab->id;
        $tab_fifth_child->module = $this->name;
        $tab_fifth_child->add();
		//here we create fourth child TAB
        $tab_fourth_child = new Tab();
        foreach ($languages as $language) {
            $tab_fourth_child->name[$language['id_lang']] = $this->tabChildFourthName;
        }
        $tab_fourth_child->class_name = $this->tabChildFourthClassName;
        $tab_fourth_child->id_parent = $tab->id;
        $tab_fourth_child->module = $this->name;
        $tab_fourth_child->add();
		//copy override controller
		copy(__DIR__.'/override/controllers/front/SearchController.php', _PS_ROOT_DIR_.'/override/controllers/front/SearchController.php');
		return $this->alterTable('add') && $this->registerHook('backOfficeHeader') && $this->registerHook('displayLeftColumn') && $this->registerHook('displayTop') && $this->registerHook('header') && $this->registerHook('footer') && $this->registerHook('displayFooter') && Configuration::updateValue('SSMAKEMODELYEAR', 'Find Your Parts By Make Model and Year');
	}

	public function uninstall()
	{
		 $moduleTabs = Tab::getCollectionFromModule($this->name);
        if (!empty($moduleTabs)) {
            foreach ($moduleTabs as $moduleTab) {
                $moduleTab->delete();
            }
        }
		//remove override controller
		if(file_exists(_PS_ROOT_DIR_.'/override/controllers/front/SearchController.php')){
		  unlink(_PS_ROOT_DIR_.'/override/controllers/front/SearchController.php');
		}
		//remove override class
		if(file_exists(_PS_ROOT_DIR_.'/override/classes/Search.php')){
		  unlink(_PS_ROOT_DIR_.'/override/classes/Search.php');
		}
		return parent::uninstall() && $this->alterTable('remove') && Configuration::deleteByName('SSMAKEMODELYEAR');
	}
	public function hookBackOfficeHeader($params)
    {
        $this->context->controller->addCSS($this->getPathUri(). 'views/css/admin_menu_icon.css');
    }
	/*Admin Settings Page*/
	public function getContent()
	{
		$html = '';
		if (Tools::isSubmit('SubmitCarMMYFilterSettings'))
		{
			Configuration::updateValue('PS_MMY_TOP_TEXT', (string)Tools::getValue('PS_MMY_TOP_TEXT'));
			Configuration::updateValue('PS_MMY_BOX_HEADER', (string)Tools::getValue('PS_MMY_BOX_HEADER'));
			Configuration::updateValue('PS_MMY_MAKE_DEFAULT_TEXT', (string)Tools::getValue('PS_MMY_MAKE_DEFAULT_TEXT'));
			Configuration::updateValue('PS_MMY_MODEL_DEFAULT_TEXT', (string)Tools::getValue('PS_MMY_MODEL_DEFAULT_TEXT'));
            Configuration::updateValue('PS_MMY_NUEVO_DEFAULT_TEXT', (string)Tools::getValue('PS_MMY_NUEVO_DEFAULT_TEXT'));
			Configuration::updateValue('PS_MMY_YEAR_DEFAULT_TEXT', (string)Tools::getValue('PS_MMY_YEAR_DEFAULT_TEXT'));
			Configuration::updateValue('PS_MMY_MAKE_TEXT', (string)Tools::getValue('PS_MMY_MAKE_TEXT'));
			Configuration::updateValue('PS_MMY_MODEL_TEXT', (string)Tools::getValue('PS_MMY_MODEL_TEXT'));
			Configuration::updateValue('PS_MMY_YEAR_TEXT', (string)Tools::getValue('PS_MMY_YEAR_TEXT'));
			Configuration::updateValue('PS_MMY_MAKE_REQUIRED_TEXT', (string)Tools::getValue('PS_MMY_MAKE_REQUIRED_TEXT'));
			Configuration::updateValue('PS_MMY_MODEL_REQUIRED_TEXT', (string)Tools::getValue('PS_MMY_MODEL_REQUIRED_TEXT'));
            Configuration::updateValue('PS_MMY_NUEVO_REQUIRED_TEXT', (string)Tools::getValue('PS_MMY_NUEVO_REQUIRED_TEXT'));
			Configuration::updateValue('PS_MMY_YEAR_REQUIRED_TEXT', (string)Tools::getValue('PS_MMY_YEAR_REQUIRED_TEXT'));
			Configuration::updateValue('PS_MMY_FILTER_BUTTON_TEXT', (string)Tools::getValue('PS_MMY_FILTER_BUTTON_TEXT'));
			Configuration::updateValue('PS_MMY_FILTER_BOX_LABEL', (int)Tools::getValue('PS_MMY_FILTER_BOX_LABEL'));
			Configuration::updateValue('PS_MMY_FILTER_VALIDATE_REQURED', (int)Tools::getValue('PS_MMY_FILTER_VALIDATE_REQURED'));
			$html .= $this->displayConfirmation($this->l('Car Parts Filter Configaration Save Successfully'));
		}
		return $html.$this->renderForm();
	}
	public function renderForm()
	{
		$fields_form = array(
			'form' => array(
				'legend' => array(
					'title' => $this->l('Settings'),
					'icon' => 'icon-cogs'
				),
				'input' => array(
					array(
						'type' => 'text',
						'label' => $this->l('Search Page Top Text:'),
						'name' => 'PS_MMY_TOP_TEXT',
						'suffix' => $this->l('Filter Page Header Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Filter Box Header Text:'),
						'name' => 'PS_MMY_BOX_HEADER',
						'suffix' => $this->l('Filter Box Header Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Make Dropdown Default Text:'),
						'name' => 'PS_MMY_MAKE_DEFAULT_TEXT',
						'suffix' => $this->l('Make Dropdownlist Default Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Model Dropdown Default Text:'),
						'name' => 'PS_MMY_MODEL_DEFAULT_TEXT',
						'suffix' => $this->l('Model Dropdownlist Default Text')
					),
                    array(
                        'type' => 'text',
                        'label' => $this->l('Nuevo Dropdown Default Text:'),
                        'name' => 'PS_MMY_NUEVO_DEFAULT_TEXT',
                        'suffix' => $this->l('Nuevo Dropdownlist Default Text')
                    ),
					array(
						'type' => 'text',
						'label' => $this->l('Year Dropdown Default Text:'),
						'name' => 'PS_MMY_YEAR_DEFAULT_TEXT',
						'suffix' => $this->l('Year Dropdownlist Default Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Make Text:'),
						'name' => 'PS_MMY_MAKE_TEXT',
						'suffix' => $this->l('Make Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Model Text:'),
						'name' => 'PS_MMY_MODEL_TEXT',
						'suffix' => $this->l('Model Text')
					),
                    array(
                        'type' => 'text',
                        'label' => $this->l('Nuevo Text:'),
                        'name' => 'PS_MMY_NUEVO_TEXT',
                        'suffix' => $this->l('Nuevo Text')
                    ),
					array(
						'type' => 'text',
						'label' => $this->l('Year Text:'),
						'name' => 'PS_MMY_YEAR_TEXT',
						'suffix' => $this->l('Year Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Make Required Text:'),
						'name' => 'PS_MMY_MAKE_REQUIRED_TEXT',
						'suffix' => $this->l('Required Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Model Required Text:'),
						'name' => 'PS_MMY_MODEL_REQUIRED_TEXT',
						'suffix' => $this->l('Required Text')
					),
                    array(
                        'type' => 'text',
                        'label' => $this->l('Nuevo Required Text:'),
                        'name' => 'PS_MMY_NUEVO_REQUIRED_TEXT',
                        'suffix' => $this->l('Required Text')
                    ),
					array(
						'type' => 'text',
						'label' => $this->l('Year Required Text:'),
						'name' => 'PS_MMY_YEAR_REQUIRED_TEXT',
						'suffix' => $this->l('Required Text')
					),
					array(
						'type' => 'text',
						'label' => $this->l('Filter Button Text:'),
						'name' => 'PS_MMY_FILTER_BUTTON_TEXT',
						'suffix' => $this->l('Filter Button Text')
					),
					array(
						'type' => 'switch',
						'label' => $this->l('Hide Filter Box Label ? '),
						'desc' => $this->l('If yes hide filter box label'),
						'name' => 'PS_MMY_FILTER_BOX_LABEL',
						'values' => array(
							array(
								'id' => 'active_on',
								'value' => 1,
								'label' => $this->l('Enabled')
							),
							array(
								'id' => 'active_off',
								'value' => 0,
								'label' => $this->l('Disabled')
							)
						),
					),
					array(
						'type' => 'switch',
						'label' => $this->l('Validate Required ? '),
						'desc' => $this->l('If yes customer need to select all'),
						'name' => 'PS_MMY_FILTER_VALIDATE_REQURED',
						'values' => array(
							array(
								'id' => 'active_on',
								'value' => 1,
								'label' => $this->l('Enabled')
							),
							array(
								'id' => 'active_off',
								'value' => 0,
								'label' => $this->l('Disabled')
							)
						),
					),
				),
				'submit' => array(
					'title' => $this->trans('Save', array(), 'Admin.Actions')
				)
			),
		);

		$helper = new HelperForm();
		$helper->show_toolbar = false;
		$helper->table = $this->table;
		$lang = new Language((int)Configuration::get('PS_LANG_DEFAULT'));
		$helper->default_form_language = $lang->id;
		$helper->allow_employee_form_lang = Configuration::get('PS_BO_ALLOW_EMPLOYEE_FORM_LANG') ? Configuration::get('PS_BO_ALLOW_EMPLOYEE_FORM_LANG') : 0;
		$this->fields_form = array();

		$helper->identifier = $this->identifier;
		$helper->submit_action = 'SubmitCarMMYFilterSettings';
		$helper->currentIndex = $this->context->link->getAdminLink('AdminModules', false).'&configure='.$this->name.'&tab_module='.$this->tab.'&module_name='.$this->name;
		$helper->token = Tools::getAdminTokenLite('AdminModules');
		$helper->tpl_vars = array(
			'fields_value' => $this->getConfigFieldsValues(),
			'languages' => $this->context->controller->getLanguages(),
			'id_language' => $this->context->language->id
		);

		return $helper->generateForm(array($fields_form));
	}


	public function getConfigFieldsValues()
	{
		$top_text = "Make Model Year Filter Result";
		$header_text = "Find Your Parts";
		$make_ddl_default_text = "--Select Make--";
		$model_ddl_default_text = "--Select Model--";
        $nuevo_ddl_default_text = "--Select Nuevo--";
		$year_ddl_default_text = "--Select Year--";
		$make_text = 'Make';
		$model_text = 'Model';
		$year_text = 'Year';
		$make_required = 'Make Required';
		$model_required = 'Model Required';
		$year_required = 'Year Required';
		$filter_button_text = 'Filter';
		$hide_filter_label = 0;
		$validate_required = 1;

		if(Configuration::get('PS_MMY_TOP_TEXT') != ''){
			$top_text = Configuration::get('PS_MMY_TOP_TEXT');
		}
		if(Configuration::get('PS_MMY_BOX_HEADER') != ''){
			$header_text = Configuration::get('PS_MMY_BOX_HEADER');
		}
		if(Configuration::get('PS_MMY_MAKE_DEFAULT_TEXT') != ''){
			$make_ddl_default_text = Configuration::get('PS_MMY_MAKE_DEFAULT_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_DEFAULT_TEXT') != ''){
			$model_ddl_default_text = Configuration::get('PS_MMY_MODEL_DEFAULT_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_DEFAULT_TEXT') != ''){
            $nuevo_ddl_default_text = Configuration::get('PS_MMY_NUEVO_DEFAULT_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_DEFAULT_TEXT') != ''){
			$year_ddl_default_text = Configuration::get('PS_MMY_YEAR_DEFAULT_TEXT');
		}
		if(Configuration::get('PS_MMY_MAKE_TEXT') != ''){
			$make_text = Configuration::get('PS_MMY_MAKE_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_TEXT') != ''){
			$model_text = Configuration::get('PS_MMY_MODEL_TEXT');
		}
		if(Configuration::get('PS_MMY_YEAR_TEXT') != ''){
			$year_text = Configuration::get('PS_MMY_YEAR_TEXT');
		}
		if(Configuration::get('PS_MMY_MAKE_REQUIRED_TEXT') != ''){
			$make_required = Configuration::get('PS_MMY_MAKE_REQUIRED_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_REQUIRED_TEXT') != ''){
			$model_required = Configuration::get('PS_MMY_MODEL_REQUIRED_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_REQUIRED_TEXT') != ''){
            $nuevo_required = Configuration::get('PS_MMY_NUEVO_REQUIRED_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_REQUIRED_TEXT') != ''){
			$year_required = Configuration::get('PS_MMY_YEAR_REQUIRED_TEXT');
		}
		if(Configuration::get('PS_MMY_FILTER_BUTTON_TEXT') != ''){
			$filter_button_text = Configuration::get('PS_MMY_FILTER_BUTTON_TEXT');
		}
		if(Configuration::get('PS_MMY_FILTER_VALIDATE_REQURED') != ''){
			$validate_required = Configuration::get('PS_MMY_FILTER_VALIDATE_REQURED');
		}
		return array(
			'PS_MMY_TOP_TEXT' 					=> Tools::getValue('PS_MMY_TOP_TEXT', $top_text),
			'PS_MMY_BOX_HEADER' 				=> Tools::getValue('PS_MMY_BOX_HEADER', $header_text),
			'PS_MMY_MAKE_DEFAULT_TEXT' 			=> Tools::getValue('PS_MMY_MAKE_DEFAULT_TEXT', $make_ddl_default_text),
			'PS_MMY_MODEL_DEFAULT_TEXT' 		=> Tools::getValue('PS_MMY_MODEL_DEFAULT_TEXT', $model_ddl_default_text),
			'PS_MMY_NUEVO_DEFAULT_TEXT' 		=> Tools::getValue('PS_MMY_NUEVO_DEFAULT_TEXT', $nuevo_ddl_default_text),
			'PS_MMY_YEAR_DEFAULT_TEXT' 			=> Tools::getValue('PS_MMY_YEAR_DEFAULT_TEXT', $year_ddl_default_text),
			'PS_MMY_MAKE_TEXT'	 				=> Tools::getValue('PS_MMY_MAKE_TEXT', $make_text),
			'PS_MMY_MODEL_TEXT' 				=> Tools::getValue('PS_MMY_MODEL_TEXT', $model_text),
            'PS_MMY_NUEVO_TEXT' 				=> Tools::getValue('PS_MMY_NUEVO_TEXT', $model_text),
			'PS_MMY_YEAR_TEXT' 					=> Tools::getValue('PS_MMY_YEAR_TEXT', $year_text),
			'PS_MMY_MAKE_REQUIRED_TEXT' 		=> Tools::getValue('PS_MMY_MAKE_REQUIRED_TEXT', $make_required),
			'PS_MMY_MODEL_REQUIRED_TEXT' 		=> Tools::getValue('PS_MMY_MODEL_REQUIRED_TEXT', $model_required),
            'PS_MMY_NUEVO_REQUIRED_TEXT' 		=> Tools::getValue('PS_MMY_NUEVO_REQUIRED_TEXT', $model_required),
			'PS_MMY_YEAR_REQUIRED_TEXT' 		=> Tools::getValue('PS_MMY_YEAR_REQUIRED_TEXT', $year_required),
			'PS_MMY_FILTER_BUTTON_TEXT' 		=> Tools::getValue('PS_MMY_FILTER_BUTTON_TEXT', $filter_button_text),
			'PS_MMY_FILTER_BOX_LABEL' 			=> Tools::getValue('PS_MMY_FILTER_BOX_LABEL', $hide_filter_label),
			'PS_MMY_FILTER_VALIDATE_REQURED' 	=> Tools::getValue('PS_MMY_FILTER_VALIDATE_REQURED', $validate_required)
		);
	}
	public function alterTable($method)
	{
		switch ($method) {
			case 'add':
				$sql = 'CREATE TABLE IF NOT EXISTS ' . _DB_PREFIX_ . 'car_filter_data(`id_product` int(11),`make` VARCHAR(100) collate utf8_bin,`model` VARCHAR(100) collate utf8_bin, `nuevo` VARCHAR(100) collate utf8_bin,`year` VARCHAR(100) collate utf8_bin)';
				if(!Db::getInstance()->Execute($sql)){
					return false;
				}
				$sql_make = 'CREATE TABLE IF NOT EXISTS ' . _DB_PREFIX_ . 'carmake(`makeid` int(10) NOT NULL AUTO_INCREMENT,`makename` varchar(200) collate utf8_bin,PRIMARY KEY (`makeid`))';
				if(!Db::getInstance()->Execute($sql_make)){
					return false;
				}
				$sql_model = 'CREATE TABLE IF NOT EXISTS ' . _DB_PREFIX_ . 'carmodel(`modelid` int(10) NOT NULL AUTO_INCREMENT,`makeid` int(10) NOT NULL DEFAULT 0,`modelname` varchar(200) collate utf8_bin,PRIMARY KEY (`modelid`))';
				if(!Db::getInstance()->Execute($sql_model)){
					return false;
				}
                $sql_model = 'CREATE TABLE IF NOT EXISTS ' . _DB_PREFIX_ . 'carnuevo(`nuevoid` int(10) NOT NULL AUTO_INCREMENT,`makeid` int(10) NOT NULL DEFAULT 0,`modelid` int(10) NOT NULL DEFAULT 0,`nuevoname` varchar(200) collate utf8_bin,PRIMARY KEY (`nuevoid`))';
                if(!Db::getInstance()->Execute($sql_model)){
                    return false;
                }
                $sql_year = 'CREATE TABLE IF NOT EXISTS ' . _DB_PREFIX_ . 'caryear(`yearid` int(10) NOT NULL AUTO_INCREMENT,`makeid` int(10) NOT NULL DEFAULT 0,`modelid` int(10) NOT NULL DEFAULT 0,`nuevoid` int(10) NOT NULL DEFAULT 0 , `year` varchar(200) collate utf8_bin,PRIMARY KEY (`yearid`))';
				if(!Db::getInstance()->Execute($sql_year)){
					return false;
				}
				break;

			case 'remove':
				Db::getInstance()->Execute("DROP TABLE IF EXISTS " . _DB_PREFIX_ . "car_filter_data");
				Db::getInstance()->Execute("DROP TABLE IF EXISTS " . _DB_PREFIX_ . "carmake");
				Db::getInstance()->Execute("DROP TABLE IF EXISTS " . _DB_PREFIX_ . "carmodel");
                Db::getInstance()->Execute("DROP TABLE IF EXISTS " . _DB_PREFIX_ . "carnuevo");
				Db::getInstance()->Execute("DROP TABLE IF EXISTS " . _DB_PREFIX_ . "caryear");
				break;
		}
		return true;
	}

	public function hookDisplayTop($params){
		$top_text = "Make Model Year Filter Result";
		$header_text = "Find Your Parts";
		$make_ddl_default_text = "--Select Make--";
		$model_ddl_default_text = "--Select Model--";
        $nuevo_ddl_default_text = "--Select Nuevo--";
		$year_ddl_default_text = "--Select Year--";
		$make_text = 'Make';
		$model_text = 'Model';
        $nuevo_text = 'Nuevo';
		$year_text = 'Year';
		$make_required = 'Make Required';
		$model_required = 'Model Required';
        $nuevo_required = 'Nuevo Required';
		$year_required = 'Year Required';
		$filter_button_text = 'Filter';
		$hide_filter_label = 0;
		$validate_required = 1;

		if(Configuration::get('PS_MMY_TOP_TEXT') != ''){
			$top_text = Configuration::get('PS_MMY_TOP_TEXT');
		}
		if(Configuration::get('PS_MMY_BOX_HEADER') != ''){
			$header_text = Configuration::get('PS_MMY_BOX_HEADER');
		}
		if(Configuration::get('PS_MMY_MAKE_DEFAULT_TEXT') != ''){
			$make_ddl_default_text = Configuration::get('PS_MMY_MAKE_DEFAULT_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_DEFAULT_TEXT') != ''){
			$model_ddl_default_text = Configuration::get('PS_MMY_MODEL_DEFAULT_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_DEFAULT_TEXT') != ''){
            $nuevo_ddl_default_text = Configuration::get('PS_MMY_NUEVO_DEFAULT_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_DEFAULT_TEXT') != ''){
			$year_ddl_default_text = Configuration::get('PS_MMY_YEAR_DEFAULT_TEXT');
		}
		if(Configuration::get('PS_MMY_MAKE_TEXT') != ''){
			$make_text = Configuration::get('PS_MMY_MAKE_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_TEXT') != ''){
			$model_text = Configuration::get('PS_MMY_MODEL_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_TEXT') != ''){
            $nuevo_text = Configuration::get('PS_MMY_NUEVO_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_TEXT') != ''){
			$year_text = Configuration::get('PS_MMY_YEAR_TEXT');
		}
		if(Configuration::get('PS_MMY_MAKE_REQUIRED_TEXT') != ''){
			$make_required = Configuration::get('PS_MMY_MAKE_REQUIRED_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_REQUIRED_TEXT') != ''){
			$model_required = Configuration::get('PS_MMY_MODEL_REQUIRED_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_REQUIRED_TEXT') != ''){
            $nuevo_required = Configuration::get('PS_MMY_NUEVO_REQUIRED_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_REQUIRED_TEXT') != ''){
			$year_required = Configuration::get('PS_MMY_YEAR_REQUIRED_TEXT');
		}
		if(Configuration::get('PS_MMY_FILTER_BUTTON_TEXT') != ''){
			$filter_button_text = Configuration::get('PS_MMY_FILTER_BUTTON_TEXT');
		}
		if(Configuration::get('PS_MMY_FILTER_BOX_LABEL') != ''){
			$hide_filter_label = Configuration::get('PS_MMY_FILTER_BOX_LABEL');
		}
		if(Configuration::get('PS_MMY_FILTER_VALIDATE_REQURED') != ''){
			$validate_required = Configuration::get('PS_MMY_FILTER_VALIDATE_REQURED');
		}

		/*Filter values*/
		$make_id = 0;
		$model_id = 0;
        $nuevo_id = 0;
		$year_id = 0;
		$model_html = '';
        $nuevo_html = '';
		$year_html = '';


		/****    AQUI     ****/

		if(Tools::getValue('make') && Tools::getValue('make') != '') {
			$make_id = Tools::getValue('make');
		}
		if(Tools::getValue('model') && Tools::getValue('model') != '') {
			$model_id = Tools::getValue('model');
		}
        if(Tools::getValue('nuevo') && Tools::getValue('nuevo') != '') {
            $nuevo_id = Tools::getValue('nuevo');
        }
		if(Tools::getValue('year') && Tools::getValue('year') != '') {
			$year_id = Tools::getValue('year');
		}
		if(Tools::getValue('make') && Tools::getValue('make') != '' && Tools::getValue('model') && Tools::getValue('model') != '') {
			$model_html = $this->getFilterBoxModelHtml(Tools::getValue('make'), Tools::getValue('model'));
		}
        if(Tools::getValue('make') && Tools::getValue('make') != '' && Tools::getValue('model') && Tools::getValue('model') != '' && Tools::getValue('nuevo') && Tools::getValue('nuevo') != '') {
            $nuevo_html = $this->getFilterBoxNuevoHtml(Tools::getValue('make'), Tools::getValue('model') , Tools::getValue('nuevo'));
        }
		if(Tools::getValue('make') && Tools::getValue('make') != '' && Tools::getValue('model') && Tools::getValue('model') != '' && Tools::getValue('year') && Tools::getValue('year') != '' && Tools::getValue('nuevo') != '') {
			$year_html = $this->getFilterBoxYearHtml(Tools::getValue('make'), Tools::getValue('model'), Tools::getValue('nuevo'), Tools::getValue('year'));
		}

		$ps__base_url = Context::getContext()->shop->getBaseURL(true);
		$base_url_module = $ps__base_url . 'modules/partsfilter/';
		$filter_url = $this->context->link->getPagelink('search').'?controller=search&s=apf';
		$make_data = $this->getAllMakeData();
		$this->context->smarty->assign(array(
			'base_url_module'			=> $base_url_module,
			'header_text'				=> $header_text,
			'make_text'					=> $make_text,
			'model_text'				=> $model_text,
            'nuevo_text'				=> $nuevo_text,
			'year_text'					=> $year_text,
			'make_ddl_default_text'		=> $make_ddl_default_text,
			'model_ddl_default_text'	=> $model_ddl_default_text,
            'nuevo_ddl_default_text'	=> $nuevo_ddl_default_text,
			'year_ddl_default_text'		=> $year_ddl_default_text,
			'filter_button_text'		=> $filter_button_text,
			'hide_filter_label'			=> $hide_filter_label,
			'validate_required'			=> $validate_required,
			'make_data'					=> $make_data,
			'make_required'				=> $make_required,
			'model_required'			=> $model_required,
            'nuevo_required'			=> $nuevo_required,
			'year_required'				=> $year_required,
			'filter_url'				=> $filter_url,
			'make_id'					=> $make_id,
			'model_id'					=> $model_id,
			'year_id'					=> $year_id,
            'nuevo_id'					=> $nuevo_id,
			'model_xhtml'				=> $model_html,
            'nuevo_xhtml'				=> $nuevo_html,
			'year_html'					=> $year_html
		));
		$page_name = Dispatcher::getInstance()->getController();
	if (!in_array($page_name, $this->disabled_pages) && !in_array(Tools::getValue('id_category'), $this->disabled_categories))
	{
		return $this->display(__FILE__, 'views/templates/front/filterbox_top.tpl');
	}
}

	private function getFilterBoxModelHtml($makeId, $modelId) {
		$model_html = '';
		if(!empty($makeId) && $makeId > 0){
			$sql = "select * from " ._DB_PREFIX_. "carmodel where makeid = '" . (int)$makeId . "'";
			if ($results = Db::getInstance()->ExecuteS($sql)){
				foreach($results as $row){
					if($row['modelid'] == $modelId){
						$model_html .= "<option selected='selected' value='".$row['modelid']."'>".$row['modelname']."</option>";
					}
					else{
						$model_html .= "<option value='".$row['modelid']."'>".$row['modelname']."</option>";
					}
				}
			}
		}
		return $model_html;
	}
    private function getFilterBoxNuevoHtml($makeId, $modelId , $nuevoId) {
        $nuevo_html = '';
        if(!empty($makeId) && $makeId > 0){
            $sql = "select * from " ._DB_PREFIX_. "carnuevo where makeid = '" . (int)$makeId . "' and modelid = '" . (int)$modelId . "'";
            if ($results = Db::getInstance()->ExecuteS($sql)){
                foreach($results as $row){
                    if($row['nuevoid'] == $nuevoId){
                        $nuevo_html .= "<option selected='selected' value='".$row['nuevoid']."'>".$row['nuevoname']."</option>";
                    }
                    else{
                        $nuevo_html .= "<option value='".$row['nuevoid']."'>".$row['nuevoname']."</option>";
                    }
                }
            }
        }
        return $nuevo_html;
    }
	private function getFilterBoxYearHtml($makeId, $modelId, $nuevoId, $yearId) {
		$year_html = '';
		if(!empty($makeId) && $makeId > 0 && !empty($modelId) && $modelId > 0 && !empty($nuevoId) && $nuevoId > 0  && !empty($yearId) && $yearId > 0){
			$sql = "select * from " ._DB_PREFIX_. "caryear where makeid = '" . (int)$makeId . "' and modelid = '" . (int)$modelId . "'and nuevoid = '" . (int)$nuevoId . "'";
			if ($results = Db::getInstance()->ExecuteS($sql)){
				foreach($results as $row){
					if($row['yearid'] == $yearId){
						$year_html .= "<option selected='selected' value='".$row['yearid']."'>".$row['year']."</option>";
					}
					else{
						$year_html .= "<option value='".$row['yearid']."'>".$row['year']."</option>";
					}
				}
			}
		}
		return $year_html;
	}

	public function hookDisplayLeftColumn($params){
		$top_text = "Make Model Year Filter Result";
		$header_text = "Find Your Parts";
		$make_ddl_default_text = "--Select Make--";
		$model_ddl_default_text = "--Select Model--";
		$year_ddl_default_text = "--Select Year--";
		$make_text = 'Make';
		$model_text = 'Model';
        $nuevo_text = 'Nuevo';
		$year_text = 'Year';
		$make_required = 'Make Required';
		$model_required = 'Model Required';
        $nuevo_required = 'Nuevo Required';
		$year_required = 'Year Required';
		$filter_button_text = 'Filter';
		$hide_filter_label = 0;
		$validate_required = 1;

		if(Configuration::get('PS_MMY_TOP_TEXT') != ''){
			$top_text = Configuration::get('PS_MMY_TOP_TEXT');
		}
		if(Configuration::get('PS_MMY_BOX_HEADER') != ''){
			$header_text = Configuration::get('PS_MMY_BOX_HEADER');
		}
		if(Configuration::get('PS_MMY_MAKE_DEFAULT_TEXT') != ''){
			$make_ddl_default_text = Configuration::get('PS_MMY_MAKE_DEFAULT_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_DEFAULT_TEXT') != ''){
			$model_ddl_default_text = Configuration::get('PS_MMY_MODEL_DEFAULT_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_DEFAULT_TEXT') != ''){
            $nuevo_ddl_default_text = Configuration::get('PS_MMY_NUEVO_DEFAULT_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_DEFAULT_TEXT') != ''){
			$year_ddl_default_text = Configuration::get('PS_MMY_YEAR_DEFAULT_TEXT');
		}
		if(Configuration::get('PS_MMY_MAKE_TEXT') != ''){
			$make_text = Configuration::get('PS_MMY_MAKE_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_TEXT') != ''){
			$model_text = Configuration::get('PS_MMY_MODEL_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_TEXT') != ''){
            $nuevo_text = Configuration::get('PS_MMY_NUEVO_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_TEXT') != ''){
			$year_text = Configuration::get('PS_MMY_YEAR_TEXT');
		}
		if(Configuration::get('PS_MMY_MAKE_REQUIRED_TEXT') != ''){
			$make_required = Configuration::get('PS_MMY_MAKE_REQUIRED_TEXT');
		}
		if(Configuration::get('PS_MMY_MODEL_REQUIRED_TEXT') != ''){
			$model_required = Configuration::get('PS_MMY_MODEL_REQUIRED_TEXT');
		}
        if(Configuration::get('PS_MMY_NUEVO_REQUIRED_TEXT') != ''){
            $nuevo_required = Configuration::get('PS_MMY_NUEVO_REQUIRED_TEXT');
        }
		if(Configuration::get('PS_MMY_YEAR_REQUIRED_TEXT') != ''){
			$year_required = Configuration::get('PS_MMY_YEAR_REQUIRED_TEXT');
		}
		if(Configuration::get('PS_MMY_FILTER_BUTTON_TEXT') != ''){
			$filter_button_text = Configuration::get('PS_MMY_FILTER_BUTTON_TEXT');
		}
		if(Configuration::get('PS_MMY_FILTER_BOX_LABEL') != ''){
			$hide_filter_label = Configuration::get('PS_MMY_FILTER_BOX_LABEL');
		}
		if(Configuration::get('PS_MMY_FILTER_VALIDATE_REQURED') != ''){
			$validate_required = Configuration::get('PS_MMY_FILTER_VALIDATE_REQURED');
		}

		/*Filter values*/
		$make_id = 0;
		$model_id = 0;
        $nuevo_id = 0;
		$year_id = 0;
        $model_html = '';
        $nuevo_html = '';
		$year_html = '';

		if(Tools::getValue('make') && Tools::getValue('make') != '') {
			$make_id = Tools::getValue('make');
		}
		if(Tools::getValue('model') && Tools::getValue('model') != '') {
			$model_id = Tools::getValue('model');
		}
        if(Tools::getValue('nuevo') && Tools::getValue('nuevo') != '') {
            $nuevo_id = Tools::getValue('nuevo');
        }
		if(Tools::getValue('year') && Tools::getValue('year') != '') {
			$year_id = Tools::getValue('year');
		}

		if(Tools::getValue('make') && Tools::getValue('make') != '' && Tools::getValue('model') && Tools::getValue('model') != '') {
			$model_html = $this->getFilterBoxModelHtml(Tools::getValue('make'), Tools::getValue('model'));
		}
        if(Tools::getValue('make') && Tools::getValue('make') != '' && Tools::getValue('model') && Tools::getValue('model') != ''  && Tools::getValue('nuevo') && Tools::getValue('nuevo') != '') {
            $nuevo_html = $this->getFilterBoxNuevoHtml(Tools::getValue('make'), Tools::getValue('model') , Tools::getValue('nuevo'));
        }
		if(Tools::getValue('make') && Tools::getValue('make') != '' && Tools::getValue('model') && Tools::getValue('model') != ''  && Tools::getValue('nuevo') && Tools::getValue('nuevo') != '' && Tools::getValue('year') && Tools::getValue('year') != '') {
			$year_html = $this->getFilterBoxYearHtml(Tools::getValue('make'), Tools::getValue('model'), Tools::getValue('nuevo'), Tools::getValue('year'));
		}

		$ps__base_url = Context::getContext()->shop->getBaseURL(true);
		$base_url_module = $ps__base_url.'modules/partsfilter/';
		$filter_url = $this->context->link->getPagelink('search').'?controller=search&s=apf';
		$make_data = $this->getAllMakeData();
		$this->context->smarty->assign(array(
			'base_url_module'			=> $base_url_module,
			'header_text'				=> $header_text,
			'make_text'					=> $make_text,
			'model_text'				=> $model_text,
            'nuevo_text'				=> $nuevo_text,
			'year_text'					=> $year_text,
			'make_ddl_default_text'		=> $make_ddl_default_text,
			'model_ddl_default_text'	=> $model_ddl_default_text,
            'nuevo_ddl_default_text'	=> $nuevo_ddl_default_text,
			'year_ddl_default_text'		=> $year_ddl_default_text,
			'filter_button_text'		=> $filter_button_text,
			'hide_filter_label'			=> $hide_filter_label,
			'validate_required'			=> $validate_required,
			'make_data'					=> $make_data,
			'make_required'				=> $make_required,
			'model_required'			=> $model_required,
            'nuevo_required'			=> $nuevo_required,
			'year_required'				=> $year_required,
			'filter_url'				=> $filter_url,
			'make_id'					=> $make_id,
			'model_id'					=> $model_id,
            'nuevo_id'					=> $nuevo_id,
			'year_id'					=> $year_id,
			'model_xhtml'				=> $model_html,
            'nuevo_xhtml'				=> $nuevo_html,
			'year_html'					=> $year_html
		));
		return $this->display(__FILE__, 'views/templates/front/filterbox.tpl');
	}

	public function getAllMakeData(){
		$make_list = array();
		$sql = 'SELECT * FROM '._DB_PREFIX_.'carmake ORDER BY makename ASC';
		if ($results = Db::getInstance()->ExecuteS($sql)){
			foreach($results as $row){
				$make_list[] = array(
					'mid'			=> $row['makeid'],
					'name'			=> $row['makename']
				);
			}
		}
		return $make_list;
	}
}

Thank you for your quick response. I do not know, if I am making a mistake when implementing the code, but it does not work for me, it is shown in all categories. I am attaching the code, so that you can verify if I am including it correctly.😓

×
×
  • Create New...