<?php

class CategoriesEventHandler extends InpDBEventHandler {

	/**
	 * Goes one level up from current category
	 *
	 * @param kEvent $event
	 */
	function OnCategoryUp(&$event)
	{		
		$category_table = $this->Application->getUnitOption($event->Prefix,'TableName');
		$current_cat = $this->Application->GetVar('m_cat_id');
		
		if($current_cat)
		{
			$sql = 'SELECT ParentId FROM '.$category_table.' WHERE CategoryId = '.$current_cat;
			$cat_to_go = $this->Conn->GetOne($sql);
		}
		else 
		{
			$cat_to_go = 0;
		}
		
		$event->redirect_params = Array('m_cat_id' => $cat_to_go);
	}
	
	/**
	 * Goes to home category
	 *
	 * @param kEvent $event
	 */
	function OnGoHome(&$event)
	{
		$cat_to_go = 0;
		$event->redirect_params = Array('m_cat_id' => $cat_to_go);
	}
	
	/**
	 * Apply system filter to categories list
	 *
	 * @param kEvent $event
	 */
	function SetCustomQuery(&$event)
	{
		parent::SetCustomQuery($event);
		
		$types=$event->getEventParam('types');
		$except_types=$event->getEventParam('except');
		$object =& $event->getObject();
		$type_clauses = Array();
		
		$object =& $event->getObject();
		
		if ( $event->getEventParam('parent_cat_id') ) {
			$parent_cat_id = $event->getEventParam('parent_cat_id');
		}
		else {
			$parent_cat_id = $this->Application->GetVar('c_id');
			if (!$parent_cat_id) {
				$parent_cat_id = $this->Application->GetVar('m_cat_id');
			}
			if (!$parent_cat_id) {
				$parent_cat_id = 0;
			}
		}
		
		if ($parent_cat_id != 'any') {
			if ($event->getEventParam('recursive')) {
				$current_path = $this->Conn->GetOne('SELECT ParentPath FROM '.TABLE_PREFIX.'Category WHERE CategoryId='.$parent_cat_id);
				$subcats = $this->Conn->GetCol('SELECT CategoryId FROM '.TABLE_PREFIX.'Category WHERE ParentPath LIKE "'.$current_path.'%" ');
				$object->addFilter('parent_filter', 'ParentId IN ('.implode(', ', $subcats).')');
			}
			else {
				$object->addFilter('parent_filter', 'ParentId = '.$parent_cat_id);
			}
		}
		
		$object->addFilter('parent_filter', 'ParentId = '.$parent_cat_id);
		
		$view_perm = 1;
		$object->addFilter('perm_filter', 'PermId = '.$view_perm);
		if (!defined('ADMIN')) {
			$groups = explode(',',$this->Application->RecallVar('UserGroups'));
			foreach ($groups as $group) {
				$view_filters[] = 'FIND_IN_SET('.$group.', acl) || ((NOT FIND_IN_SET('.$group.',dacl)) AND acl=\'\')';
			}
			$view_filter = implode(' OR ', $view_filters);
			$object->addFilter('perm_filter2', $view_filter);
		}
		
		if (!defined('ADMIN')) {
			$object->addFilter('status_filter', $object->TableName.'.Status = 1');
		}

		if(strpos($types, 'category_related') !== false)
		{
			$object->removeFilter('parent_filter');
			$resource_id = $this->Conn->GetOne('
							SELECT ResourceId FROM '.$this->Application->getUnitOption($event->Prefix, 'TableName').'
							WHERE CategoryId = '.$parent_cat_id
						);
			
			$sql = 'SELECT DISTINCT(TargetId) FROM '.TABLE_PREFIX.'Relationship
					WHERE SourceId = '.$resource_id.' AND SourceType = 1';
			$related_cats = $this->Conn->GetCol($sql);
			$related_cats = is_array($related_cats) ? $related_cats : Array();
			$sql = 'SELECT DISTINCT(SourceId) FROM '.TABLE_PREFIX.'Relationship
					WHERE TargetId = '.$resource_id.' AND TargetType = 1 AND Type = 1';
			$related_cats2 = $this->Conn->GetCol($sql);
			$related_cats2 = is_array($related_cats2) ? $related_cats2 : Array();
			$related_cats = array_unique( array_merge( $related_cats2, $related_cats ) );
			
			if($related_cats)
			{
				$type_clauses['category_related']['include'] = '%1$s.ResourceId IN ('.implode(',', $related_cats).')';
				$type_clauses['category_related']['except'] = '%1$s.ResourceId NOT IN ('.implode(',', $related_cats).')';
			}
			else 
			{
				$type_clauses['category_related']['include'] = '0';
				$type_clauses['category_related']['except'] = '1';
			}
			$type_clauses['category_related']['having_filter'] = false;
		}
		
		if(strpos($types, 'product_related') !== false)
		{
			$object->removeFilter('parent_filter');
			
			$product_id = $event->getEventParam('product_id') ? $event->getEventParam('product_id') : $this->Application->GetVar('p_id');
			$resource_id = $this->Conn->GetOne('
							SELECT ResourceId FROM '.$this->Application->getUnitOption('p', 'TableName').'
							WHERE ProductId = '.$product_id
						);
			
			$sql = 'SELECT DISTINCT(TargetId) FROM '.TABLE_PREFIX.'Relationship
					WHERE SourceId = '.$resource_id.' AND TargetType = 1';
			$related_cats = $this->Conn->GetCol($sql);
			$related_cats = is_array($related_cats) ? $related_cats : Array();
			$sql = 'SELECT DISTINCT(SourceId) FROM '.TABLE_PREFIX.'Relationship
					WHERE TargetId = '.$resource_id.' AND SourceType = 1 AND Type = 1';
			$related_cats2 = $this->Conn->GetCol($sql);
			$related_cats2 = is_array($related_cats2) ? $related_cats2 : Array();
			$related_cats = array_unique( array_merge( $related_cats2, $related_cats ) );
			
			if($related_cats)
			{
				$type_clauses['product_related']['include'] = '%1$s.ResourceId IN ('.implode(',', $related_cats).')';
				$type_clauses['product_related']['except'] = '%1$s.ResourceId NOT IN ('.implode(',', $related_cats).')';
			}
			else 
			{
				$type_clauses['product_related']['include'] = '0';
				$type_clauses['product_related']['except'] = '1';
			}
			$type_clauses['product_related']['having_filter'] = false;
		}
		
		/********************************************/
		
		$includes_or_filter =& $this->Application->makeClass('kMultipleFilter');
		$includes_or_filter->setType(FLT_TYPE_OR);
		
		$excepts_and_filter =& $this->Application->makeClass('kMultipleFilter');
		$excepts_and_filter->setType(FLT_TYPE_AND);

		$includes_or_filter_h =& $this->Application->makeClass('kMultipleFilter');
		$includes_or_filter_h->setType(FLT_TYPE_OR);
		
		$excepts_and_filter_h =& $this->Application->makeClass('kMultipleFilter');
		$excepts_and_filter_h->setType(FLT_TYPE_AND);

		$except_types_array=explode(',', $types);
		
		if ($types){
			$types_array=explode(',', $types);
			for ($i=0; $i<sizeof($types_array); $i++){
				$type=trim($types_array[$i]);
				if (isset($type_clauses[$type])){
					if ($type_clauses[$type]['having_filter']){
						$includes_or_filter_h->removeFilter('filter_'.$type);
						$includes_or_filter_h->addFilter('filter_'.$type, $type_clauses[$type]['include']);
					}else{
						$includes_or_filter->removeFilter('filter_'.$type);
						$includes_or_filter->addFilter('filter_'.$type, $type_clauses[$type]['include']);
					}
				}
			}
		}
		
		if ($except_types){
			$except_types_array=explode(',', $except_types);
			for ($i=0; $i<sizeof($except_types_array); $i++){
				$type=trim($except_types_array[$i]);
				if (isset($type_clauses[$type])){
					if ($type_clauses[$type]['having_filter']){
						$excepts_and_filter_h->removeFilter('filter_'.$type);
						$excepts_and_filter_h->addFilter('filter_'.$type, $type_clauses[$type]['except']);
					}else{
						$excepts_and_filter->removeFilter('filter_'.$type);
						$excepts_and_filter->addFilter('filter_'.$type, $type_clauses[$type]['except']);
					}
				}
			}
		}
		
		$object->addFilter('includes_filter', $includes_or_filter);
		$object->addFilter('excepts_filter', $excepts_and_filter);
	
		$object->addFilter('includes_filter_h', $includes_or_filter_h, HAVING_FILTER);
		$object->addFilter('excepts_filter_h', $excepts_and_filter_h, HAVING_FILTER);
	}
	
	function GetPassedId(&$event)
	{
		if (defined('ADMIN')) return parent::getPassedID($event);
		
		$ret = $this->Application->GetVar('m_cat_id');
		if($ret) return $ret;
		
		return parent::getPassedID($event);
	}
}

?>