File Metadata

Created: Thu, Oct 29, 9:13 AM

manufacturers_event_handler.php
View Options

	<?php

	class ManufacturersEventHandler extends kDBEventHandler {

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnItemBuild' => Array('self' => true),
	);

	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	if( $this->Application->IsAdmin() ) return true;

	$object =& $event->getObject();

	$sql = 'SELECT DISTINCT '.TABLE_PREFIX.'Manufacturers.ManufacturerId
	FROM '.TABLE_PREFIX.'Manufacturers
	LEFT JOIN '.TABLE_PREFIX.'Products
	ON '.TABLE_PREFIX.'Products.ManufacturerId = '.TABLE_PREFIX.'Manufacturers.ManufacturerId
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems
	ON '.TABLE_PREFIX.'CategoryItems.ItemResourceId = '.TABLE_PREFIX.'Products.ResourceId
	LEFT JOIN '.TABLE_PREFIX.'Category
	ON '.TABLE_PREFIX.'Category.CategoryId = '.TABLE_PREFIX.'CategoryItems.CategoryId
	WHERE '.TABLE_PREFIX.'CategoryItems.PrimaryCat = 1
	';

	$parent = $event->getEventParam('parent_cat_id');

	if ($parent)
	{
	if($parent != 'any' && $parent > 0)
	{
	$sql .= ' AND '.TABLE_PREFIX.'Category.ParentPath LIKE "%\|'.$parent.'\|%"';
	}
	}
	else
	{
	$sql .= ' AND '.TABLE_PREFIX.'Category.ParentPath LIKE "%\|'.$this->Application->GetVar('m_cat_id').'\|%"';
	}
	$manuf_ids = $this->Conn->GetCol($sql);

	if ( count($manuf_ids) > 0 )
	{
	$object->addFilter('manuf_by_category', 'ManufacturerId IN ('.implode(',', $manuf_ids).')');
	}
	else
	{
	$object->addFilter('manuf_by_category', '0'); //display none
	}
	}


	/**
	* Prefill states dropdown with correct values
	*
	* @param kEvent $event
	* @access public
	*/
	function OnPrepareStates(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->PopulateStates($event, 'State', 'Country');

	$object =& $event->getObject();

	if( $object->isRequired('Country') && $cs_helper->CountryHasStates( $object->GetDBField('Country') ) ) $object->setRequired('State', true);
	}

	function OnUpdate(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->CheckStateField($event, 'State', 'Country');

	parent::OnUpdate($event);
	}

	function OnCreate(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->CheckStateField($event, 'State', 'Country');

	parent::OnCreate($event);
	}

	function OnPreSave(&$event)
	{
	$cs_helper =& $this->Application->recallObject('CountryStatesHelper');
	$cs_helper->CheckStateField($event, 'State', 'Country');

	parent::OnPreSave($event);
	}

	}

	?>

manufacturers_event_handler.php
No OneTemporary
Actions

File Metadata

manufacturers_event_handler.php
View Options

Event Timeline

manufacturers_event_handler.phpNo OneTemporaryActions

File Metadata

manufacturers_event_handler.phpView Options

Event Timeline

manufacturers_event_handler.php
No OneTemporary
Actions

manufacturers_event_handler.php
View Options