File Metadata

Created: Fri, Feb 7, 5:57 PM

category_items_event_handler.php
View Options

	<?php
	/**
	* @version $Id: category_items_event_handler.php 16513 2017-01-20 14:10:53Z alex $
	* @package In-Portal
	* @copyright Copyright (C) 1997 - 2009 Intechnic. All rights reserved.
	* @license GNU/GPL
	* In-Portal is Open Source software.
	* This means that this software may have been modified pursuant
	* the GNU General Public License, and as distributed it includes
	* or is derivative of works licensed under the GNU General Public License
	* or other free or open source software licenses.
	* See http://www.in-portal.org/license for copyright notices and details.
	*/

	defined('FULL_PATH') or die('restricted access!');

	class CategoryItemsEventHandler extends kDBEventHandler
	{
	/**
	* Setting language dependant navigation bar as calculated field
	*
	* @param kEvent $event
	* @return void
	* @access protected
	* @see kDBEventHandler::OnListBuild()
	*/
	protected function SetCustomQuery(kEvent $event)
	{
	parent::SetCustomQuery($event);

	/** @var kDBList $object */
	$object = $event->getObject();

	/** @var kMultiLanguage $ml_formatter */
	$ml_formatter = $this->Application->recallObject('kMultiLanguage');

	$object->addCalculatedField('CategoryName', 'c.' . $ml_formatter->LangFieldName('CachedNavbar'));
	}

	/**
	* Set's new category as primary for product
	*
	* @param kEvent $event
	*/
	function OnSetPrimary($event)
	{
	/** @var kDBItem $object */
	$object = $event->getObject(Array ('skip_autoload' => true));

	$ids = $this->StoreSelectedIDs($event);

	if ( $ids ) {
	$id = array_shift($ids);
	$table_info = $object->getLinkedInfo();

	$this->Conn->Query('UPDATE ' . $object->TableName . ' SET PrimaryCat = 0 WHERE ' . $table_info['ForeignKey'] . ' = ' . $table_info['ParentId']);
	$this->Conn->Query('UPDATE ' . $object->TableName . ' SET PrimaryCat = 1 WHERE (' . $table_info['ForeignKey'] . ' = ' . $table_info['ParentId'] . ') AND (CategoryId = ' . $id . ')');
	}

	$event->SetRedirectParam('opener', 's');
	}

	/**
	* Apply custom processing to item
	*
	* @param kEvent $event
	* @param string $type
	* @return void
	* @access protected
	*/
	protected function customProcessing(kEvent $event, $type)
	{
	if ( $event->Name == 'OnMassDelete' ) {
	$object = $event->getObject();
	$table_info = $object->getLinkedInfo();

	switch ($type) {
	case 'before':
	$ids = $event->getEventParam('ids');

	if ( $ids ) {
	$sql = 'SELECT CategoryId
	FROM ' . $object->TableName . '
	WHERE (PrimaryCat = 0) AND (' . $table_info['ForeignKey'] . '=' . $table_info['ParentId'] . ') AND CategoryId IN (' . implode(',', $ids) . ')';
	$event->setEventParam('ids', $this->Conn->GetCol($sql));
	}
	break;

	// not needed because 'before' does not allow to delete primary cat!
	/*case 'after':
	// set 1st not deleted category as primary
	$sql = 'SELECT COUNT(*)
	FROM ' . $object->TableName . '
	WHERE (PrimaryCat = 1) AND (' . $table_info['ForeignKey'] . ' = ' . $table_info['ParentId'] . ')';
	$has_primary = $this->Conn->GetOne($sql);

	if ( !$has_primary ) {
	$sql = 'SELECT CategoryId
	FROM ' . $object->TableName . '
	WHERE ' . $table_info['ForeignKey'] . ' = ' . $table_info['ParentId'];
	$cat_id = $this->Conn->GetOne($sql);

	$sql = 'UPDATE ' . $object->TableName . '
	SET PrimaryCat = 1
	WHERE (' . $table_info['ForeignKey'] . ' = ' . $table_info['ParentId'] . ') AND (CategoryId = ' . $cat_id . ')';
	$this->Conn->Query($sql);
	}
	break;*/
	}
	}
	}

	/**
	* Removes primary mark from cloned category items record
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnAfterClone(kEvent $event)
	{
	parent::OnAfterClone($event);

	$id = $event->getEventParam('id');
	$table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');

	$sql = 'UPDATE %s
	SET PrimaryCat = 0
	WHERE %s = %s';
	$this->Conn->Query(sprintf($sql, $table, $id_field, $id));
	}

	/**
	* Deletes items of requested type from requested categories.
	* In case if item is deleted from it's last category, then delete item too.
	*
	* @param kEvent $event
	* @return void
	* @access protected
	*/
	protected function OnDeleteFromCategory($event)
	{
	$category_ids = $event->getEventParam('category_ids');

	if ( !$category_ids ) {
	return ;
	}

	$item_prefix = $event->getEventParam('item_prefix');

	/** @var kCatDBItem $item */
	$item = $this->Application->recallObject($item_prefix . '.-item', null, Array ('skip_autoload' => true));

	$ci_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$item_table = $this->Application->getUnitOption($item_prefix, 'TableName');

	$sql = 'SELECT ItemResourceId, CategoryId
	FROM %1$s
	INNER JOIN %2$s ON (%1$s.ResourceId = %2$s.ItemResourceId)
	WHERE CategoryId IN (%3$s)';
	$category_items = $this->Conn->Query( sprintf($sql, $item_table, $ci_table, implode(',', $category_ids)) );

	$item_hash = Array ();
	foreach ($category_items as $ci_row) {
	$item_hash[ $ci_row['ItemResourceId'] ][] = $ci_row['CategoryId'];
	}

	foreach ($item_hash as $item_resource_id => $delete_category_ids) {
	$item->Load($item_resource_id, 'ResourceId');
	$item->DeleteFromCategories($delete_category_ids);
	}
	}

	/**
	* Makes sure, that parent category item is loaded when coping back from temp table
	*
	* @param kEvent $event
	*
	* @return void
	* @see CategoryItems_DBItem::GetKeyClause()
	*/
	protected function OnAfterCopyToLive(kEvent $event)
	{
	// don't call parent, because it's unclear how from here we can get parent item's ID here
	}

	}

category_items_event_handler.php
No OneTemporary
Actions

File Metadata

category_items_event_handler.php
View Options

Event Timeline

category_items_event_handler.phpNo OneTemporaryActions

File Metadata

category_items_event_handler.phpView Options

Event Timeline

category_items_event_handler.php
No OneTemporary
Actions

category_items_event_handler.php
View Options