in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Aug 17, 3:06 AM

in-portal
View Options

	Index: branches/unlabeled/unlabeled-1.30.2/core/units/languages/languages_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.30.2/core/units/languages/languages_event_handler.php (revision 7742)
	+++ branches/unlabeled/unlabeled-1.30.2/core/units/languages/languages_event_handler.php (revision 7743)
	@@ -1,460 +1,461 @@
	<?php

	class LanguagesEventHandler extends kDBEventHandler
	{
	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnChangeLanguage' => Array('self' => true),
	'OnSetPrimary' => Array('self' => 'advanced:set_primary\|add\|edit'),
	'OnImportLanguage' => Array('self' => 'advanced:import'),
	'OnImportProgress' => Array('self' => 'advanced:import'),
	'OnExportLanguage' => Array('self' => 'advanced:export'),
	'OnExportProgress' => Array('self' => 'advanced:export'),

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

	/**
	* Updates table structure on new language adding/removing language
	*
	* @param kEvent $event
	*/
	function OnReflectMultiLingualFields($event)
	{
	$ml_helper =& $this->Application->recallObject('kMultiLanguageHelper');

	$this->Application->UnitConfigReader->includeConfigFiles(MODULES_PATH); //make sure to re-read all configs
	$this->Application->UnitConfigReader->AfterConfigRead();
	foreach ($this->Application->UnitConfigReader->configData as $prefix => $config_data) {
	$ml_helper->createFields($prefix);
	}
	}

	/**
	* Allows to set selected language as primary
	*
	* @param kEvent $event
	*/
	function OnSetPrimary(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

	$this->StoreSelectedIDs($event);
	$ids = $this->getSelectedIDs($event);
	if ($ids) {
	$id = array_shift($ids);
	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->Load($id);
	$object->setPrimary();
	}
	}

	/**
	* [HOOK] Reset primary status of other languages if we are saving primary language
	*
	* @param kEvent $event
	*/
	function OnUpdatePrimary(&$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );
	$object->SwitchToLive();

	// set primary for each languages, that have this checkbox checked
	$ids = explode(',', $event->MasterEvent->getEventParam('ids'));
	foreach ($ids as $id) {
	$object->Load($id);
	if ($object->GetDBField('PrimaryLang')) {
	$object->setPrimary();
	}

	}

	// if no primary language left, then set primary last language (not to load again) from edited list
	$sql = 'SELECT '.$object->IDField.'
	FROM '.$object->TableName.'
	WHERE PrimaryLang = 1';
	$primary_language = $this->Conn->GetOne($sql);

	if (!$primary_language) {
	$object->setPrimary(false);
	}
	}


	/**
	* Occurse before updating item
	*
	* @param kEvent $event
	* @access public
	*/
	function OnBeforeItemUpdate(&$event)
	{
	$object =& $event->getObject();
	$status_field = array_shift( $this->Application->getUnitOption($event->Prefix, 'StatusField') );

	if ($object->GetDBField('PrimaryLang') == 1 && $object->GetDBField($status_field) == 0) {
	$object->SetDBField($status_field, 1);
	}
	}

	/**
	* Shows only enabled languages on front
	*
	* @param kEvent $event
	*/
	function SetCustomQuery(&$event)
	{
	if($event->Special == 'enabled')
	{
	$object =& $event->getObject();
	$object->addFilter('enabled_filter', '%1$s.Enabled = 1');
	}
	}

	/**
	* Copy labels from another language
	*
	* @param kEvent $event
	*/
	function OnCopyLabels(&$event)
	{
	$object =& $event->getObject();
	$from_lang_id = $object->GetDBField('CopyFromLanguage');

	if( ($event->MasterEvent->status == erSUCCESS) && $object->GetDBField('CopyLabels') == 1 && ($from_lang_id > 0) )
	{
	$lang_id = $object->GetID();

	// 1. phrases import
	$phrases_live = $this->Application->getUnitOption('phrases','TableName');
	$phrases_temp = $this->Application->GetTempName($phrases_live, 'prefix:phrases');
	$sql = 'INSERT INTO '.$phrases_temp.'
	SELECT Phrase, Translation, PhraseType, 0-PhraseId, '.$lang_id.', '.adodb_mktime().', "", Module
	FROM '.$phrases_live.'
	WHERE LanguageId='.$from_lang_id;
	$this->Conn->Query($sql);

	// 2. events import
	$em_table_live = $this->Application->getUnitOption('emailmessages','TableName');
	$em_table_temp = $this->Application->GetTempName($em_table_live, 'prefix:emailmessages');

	$sql = 'SELECT * FROM '.$em_table_live.' WHERE LanguageId = '.$from_lang_id;
	$email_messages = $this->Conn->Query($sql);
	if($email_messages)
	{
	$id = $this->Conn->GetOne('SELECT MIN(EmailMessageId) FROM '.$em_table_live);
	if($id > 0) $id = 0;
	$id--;

	$sqls = Array();
	foreach($email_messages as $email_message)
	{
	$sqls[] = $id.','.$this->Conn->qstr($email_message['Template']).','.$this->Conn->qstr($email_message['MessageType']).','.$lang_id.','.$email_message['EventId'];
	$id--;
	}
	$sql = 'INSERT INTO '.$em_table_temp.'(EmailMessageId,Template,MessageType,LanguageId,EventId) VALUES ('.implode('),(',$sqls).')';
	$this->Conn->Query($sql);
	}

	$object->SetDBField('CopyLabels', 0);
	}
	}

	/**
	* Prepare temp tables for creating new item
	* but does not create it. Actual create is
	* done in OnPreSaveCreated
	*
	* @param kEvent $event
	*/
	function OnPreCreate(&$event)
	{
	parent::OnPreCreate($event);

	$object =& $event->getObject();
	$object->SetDBField('CopyLabels', 1);

	$live_table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$primary_lang_id = $this->Conn->GetOne('SELECT '.$object->IDField.' FROM '.$live_table.' WHERE PrimaryLang = 1');

	$object->SetDBField('CopyFromLanguage', $primary_lang_id);
	}


	function OnChangeLanguage(&$event)
	{
	$this->Application->SetVar('m_lang', $this->Application->GetVar('language'));

	//$this->Application->LinkVar('language', 'm_lang');
	}

	/**
	* Parse language XML file into temp tables and redirect to progress bar screen
	*
	* @param kEvent $event
	*/
	function OnImportLanguage(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

	$items_info = $this->Application->GetVar('phrases_import');
	if($items_info)
	{
	list($id,$field_values) = each($items_info);
	$object =& $this->Application->recallObject('phrases.import', 'phrases', Array('skip_autoload' => true) );
	$object->SetFieldsFromHash($field_values);

	$filename = getArrayValue($field_values, 'LangFile', 'tmp_name');
	if( filesize($filename) )
	{
	$modules = getArrayValue($field_values,'Module');
	$lang_xml =& $this->Application->recallObject('LangXML');
	+ /* @var $lang_xml LangXML_Parser */
	$lang_xml->Parse($filename, $field_values['PhraseType'], $modules, $field_values['ImportOverwrite']);

	$event->redirect = true;
	$event->SetRedirectParams( Array('lang_event' => 'OnImportProgress', 'pass' => 'all,lang', 'mode'=>$field_values['ImportOverwrite']) );
	}
	else
	{
	$object =& $this->Application->recallObject('phrases.import');
	$object->SetError('LangFile', 'la_empty_file', 'la_EmptyFile');
	$event->redirect = false;
	}
	}
	}

	/**
	* Copies imported from xml file from temp table to live table
	*
	* @param kEvent $event
	*/
	function OnImportProgress(&$event)
	{
	define('IMPORT_BY', 300); // import this much records per step
	$template_name = 'regional/languages_import_step2';

	$import_mode = (int)$this->Application->GetVar('mode'); // 1 - overwrite existing phrases, 0 - don't overwrite existing phrases
	$import_source = (int)$this->Application->GetVar('source');
	$import_steps = Array(0 => 'lang', 1 => 'phrases', 2 => 'emailmessages', 3 => 'finish');

	$key_fields = Array(0 => 'PackName', 1 => 'Phrase', 2 => 'EventId'); // by what field should we search record match

	$import_titles = Array(0 => 'la_ImportingLanguages', 1 => 'la_ImportingPhrases', 2 => 'la_ImportingEmailEvents', 3 => 'la_Done');

	// --- BEFORE ---
	$import_prefix = $import_steps[$import_source];
	$import_start = (int)$this->Application->GetVar('start');
	$id_field = $this->Application->getUnitOption($import_prefix,'IDField');
	$dst_table = $this->Application->getUnitOption($import_prefix,'TableName');
	$src_table = $this->Application->GetTempName($dst_table);

	$import_total = $this->Application->GetVar('total');
	if(!$import_total) $import_total = $this->Conn->GetOne('SELECT COUNT(*) FROM '.$src_table);
	// --- AFTER ---

	if($import_start == $import_total)
	{
	$import_source++;
	$import_prefix = $import_steps[$import_source];
	if($import_prefix == 'finish')
	{
	$event->SetRedirectParam('opener','u');
	return true;
	}

	$import_start = 0;
	$id_field = $this->Application->getUnitOption($import_prefix,'IDField');
	$dst_table = $this->Application->getUnitOption($import_prefix,'TableName');
	$src_table = $this->Application->GetTempName($dst_table);
	$import_total = $this->Conn->GetOne('SELECT COUNT(*) FROM '.$src_table);
	}

	if($import_total > 0)
	{
	$done_percent = ($import_start * 100) / $import_total;
	}
	else
	{
	$done_percent = 100;
	}

	$block_params = Array( 'name' => $template_name,
	'title' => $import_titles[$import_source],
	'percent_done' => $done_percent,
	'percent_left' => 100 - $done_percent);

	$this->Application->InitParser();
	$this->Application->setUnitOption('phrases','AutoLoad',false);
	echo $this->Application->ParseBlock($block_params);

	//break out of buffering
	$buffer_content = Array();
	while (ob_get_level()) {
	$buffer_content[] = ob_get_clean();
	}
	$ret = implode('', array_reverse($buffer_content));
	echo $ret;
	flush();


	$sql = 'SELECT * FROM %s LIMIT %s,%s';
	$rows = $this->Conn->Query( sprintf($sql,$src_table,$import_start,IMPORT_BY) );

	$values_sql = '';

	// if found and mode = 1 (overwrite)
	$search_sql = 'SELECT '.$id_field.' FROM '.$dst_table.' WHERE '.$key_fields[$import_source].' = %s AND LanguageId = %s';
	$update_sql = 'UPDATE '.$dst_table.' SET %s WHERE '.$id_field.' = %s';

	foreach($rows as $row)
	{
	$tmp_sql = sprintf($search_sql, $this->Conn->qstr($row[ $key_fields[$import_source] ]), $row['LanguageId'] );
	$tmp_id = $this->Conn->GetOne($tmp_sql);
	if($tmp_id > 0 && $import_mode == 1)
	{
	// update
	$update_fields = '';
	foreach($row as $field_name => $field_value)
	{
	if($field_name == $id_field) continue;
	$update_fields .= '`'.$field_name.'` = '.$this->Conn->qstr($field_value).',';
	}
	$update_fields = preg_replace('/(.*),$/', '\\1', $update_fields);
	$this->Conn->Query( sprintf($update_sql, $update_fields, $tmp_id) );
	}
	elseif(!$tmp_id)
	{
	$values_sql .= '(';
	foreach($row as $field_value)
	{
	$values_sql .= $this->Conn->qstr($field_value).',';
	}
	$values_sql = preg_replace('/(.*),$/', '\\1', $values_sql).'),';
	}
	}

	if($values_sql)
	{
	$fields_sql = '';
	$fields = array_keys( $this->Application->getUnitOption($import_prefix,'Fields') );
	foreach($fields as $field_name)
	{
	$fields_sql .= '`'.$field_name.'`,';
	}
	$fields_sql = preg_replace('/(.*),$/', '\\1', $fields_sql);

	$values_sql = preg_replace('/(.*),$/', '\\1', $values_sql);
	$sql = sprintf('INSERT INTO %s (%s) VALUES %s', $dst_table, $fields_sql, $values_sql);
	$this->Conn->Query($sql);
	}
	$event->setRedirectParams( Array('lang_event' => 'OnImportProgress', 'pass' => 'all,lang', 'start' => $import_start += count($rows), 'total' => $import_total, 'source' => $import_source, 'mode' => $import_mode) );
	}

	/**
	* Stores ids of selected languages and redirects to export language step 1
	*
	* @param kEvent $event
	*/
	function OnExportLanguage(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

	$this->Application->setUnitOption('phrases','AutoLoad',false);

	$this->StoreSelectedIDs($event);
	$this->Application->StoreVar('export_language_ids', implode(',', $this->getSelectedIDs($event)) );

	$event->setRedirectParams( Array('m_opener'=>'d','phrases.export_event'=>'OnNew','pass'=>'all,phrases.export') );
	$event->redirect = 'regional/languages_export';
	}

	/**
	* Saves selected languages to xml file passed
	*
	* @param kEvent $event
	*/
	function OnExportProgress(&$event)
	{
	$items_info = $this->Application->GetVar('phrases_export');
	if($items_info)
	{
	list($id,$field_values) = each($items_info);
	$object =& $this->Application->recallObject('phrases.export', 'phrases', Array('skip_autoload' => true) );
	$object->SetFieldsFromHash($field_values);

	$lang_ids = explode(',', $this->Application->RecallVar('export_language_ids') );

	if( !getArrayValue($field_values,'LangFile') )
	{
	$object->SetError('LangFile', 'required');
	$event->redirect = false;
	return false;
	}
	if( !is_writable(EXPORT_PATH) )
	{
	$object->SetError('LangFile', 'write_error', 'la_ExportFolderNotWritable');
	$event->redirect = false;
	return false;
	}
	if( substr($field_values['LangFile'], -5) != '.lang' ) $field_values['LangFile'] .= '.lang';
	$filename = EXPORT_PATH.'/'.$field_values['LangFile'];

	$lang_xml =& $this->Application->recallObject('LangXML');
	if ($object->GetDBField('DoNotEncode')) {
	$lang_xml->SetEncoding('plain');
	}
	$lang_xml->Create($filename, $field_values['PhraseType'], $lang_ids, $field_values['Module']);

	}

	$event->redirect = 'regional/languages_export_step2';
	$event->SetRedirectParam('export_file', $field_values['LangFile']);
	}

	/**
	* Returns to previous template in opener stack
	*
	* @param kEvent $event
	*/
	function OnGoBack(&$event)
	{
	$event->redirect_params['opener'] = 'u';
	}

	function OnScheduleTopFrameReload(&$event)
	{
	$this->Application->StoreVar('RefreshTopFrame',1);
	}

	/**
	* Do now allow deleting current language
	*
	* @param kEvent $event
	*/
	function OnBeforeItemDelete(&$event)
	{
	$del_id = $event->getEventParam('id');
	$object =& $event->getObject(array('skip_autload' => true));
	$object->Load($del_id);

	if ($object->GetDBField('PrimaryLang') \|\| $del_id == $this->Application->GetVar('m_lang')) {
	$event->status = erFAIL;
	}
	}

	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.30.2/core/units/languages/languages_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.30
	\ No newline at end of property
	+1.30.2.1
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.27.2/core/units/categories/categories_event_handler.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.27.2/core/units/categories/categories_event_handler.php (revision 7742)
	+++ branches/unlabeled/unlabeled-1.27.2/core/units/categories/categories_event_handler.php (revision 7743)
	@@ -1,563 +1,565 @@
	<?php

	class CategoriesEventHandler extends kDBEventHandler {

	/**
	* Allows to override standart permission mapping
	*
	*/
	function mapPermissions()
	{
	parent::mapPermissions();
	$permissions = Array(
	'OnRebuildCache' => Array('self' => 'add\|edit'),
	+ 'OnPasteClipboard' => Array('self' => 'add\|edit'),
	+ 'OnPaste' => array('self'=>'add\|edit', 'subitem' => 'edit'),
	// 'OnSave' => Array('self' => 'add\|edit')
	);
	$this->permMapping = array_merge($this->permMapping, $permissions);
	}

	/**
	* Checks permissions of user
	*
	* @param kEvent $event
	*/
	function CheckPermission(&$event)
	{
	if (!$this->Application->IsAdmin()) {
	if ($event->Name == 'OnSetSortingDirect') {
	// allow sorting on front event without view permission
	return true;
	}
	}

	if ($event->Name == 'OnEdit' \|\| $event->Name == 'OnSave') {
	// check each id from selected individually and only if all are allowed proceed next
	if ($event->Name == 'OnEdit') {
	$selected_ids = implode(',', $this->StoreSelectedIDs($event));
	}
	else {
	$selected_ids = implode(',', $this->getSelectedIDs($event, true));
	}

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

	if (strlen($selected_ids) > 0) {
	$table_name = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$sql = 'SELECT '.$id_field.', CreatedById
	FROM '.$table_name.' item_table
	WHERE '.$id_field.' IN ('.$selected_ids.')';
	$items = $this->Conn->Query($sql, $id_field);
	}
	else {
	// when creating new category, then no IDs are stored in session
	$parent_cat = $this->Application->RecallVar('m_cat_id');
	$items[$parent_cat] = Array (
	$id_field => $parent_cat,
	'CreatedById' => $this->Application->RecallVar('user_id'),
	);
	}
	$perm_value = true;
	$perm_helper =& $this->Application->recallObject('PermissionsHelper');
	/* @var $perm_helper kPermissionsHelper */

	foreach ($items as $item_id => $item_data) {
	if ($perm_helper->ModifyCheckPermission($item_data['CreatedById'], $item_data[$id_field], $event->Prefix) == 0) {
	// one of items selected has no permission
	$perm_value = false;
	break;
	}
	}

	if (!$perm_value) {
	$event->status = erPERM_FAIL;
	}

	return $perm_value;
	}

	return parent::CheckPermission($event);
	}

	/**
	* 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();
	/* @var $object kDBList */

	// hide categories with status = 4 (system categories)
	$object->addFilter('system_categories', '%1$s.Status <> 4');

	if ( $event->getEventParam('parent_cat_id') ) {
	$parent_cat_id = $event->getEventParam('parent_cat_id');

	if ($parent_cat_id == 'Root') {
	$module_name = $event->getEventParam('module') ? $event->getEventParam('module') : 'In-Commerce';
	$module =& $this->Application->recallObject('mod.'.$module_name);
	$parent_cat_id = $module->GetDBField('RootCat');
	}

	}
	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('perm_filter', 'PermId = 1'); // check for CATEGORY.VIEW permission
	if ($this->Application->RecallVar('user_id') != -1) {
	// apply permission filters to all users except "root"
	$groups = explode(',',$this->Application->RecallVar('UserGroups'));
	foreach ($groups as $group) {
	$view_filters[] = 'FIND_IN_SET('.$group.', acl)';
	}
	$view_filter = implode(' OR ', $view_filters);
	$object->addFilter('perm_filter2', $view_filter);
	}

	if (!$this->Application->IsAdmin()) {
	// apply status filter only on front
	$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);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	* @return int
	*/
	function GetPassedId(&$event)
	{
	if ( $this->Application->IsAdmin()) {
	return parent::getPassedID($event);
	}

	return $this->Application->GetVar('m_cat_id');
	}

	function ParentGetPassedId(&$event)
	{
	return parent::GetPassedId($event);
	}

	/**
	* Adds calculates fields for item statuses
	*
	* @param kCatDBItem $object
	* @param kEvent $event
	*/
	function prepareObject(&$object, &$event)
	{
	$object =& $event->getObject( Array('skip_autoload' => true) );

	$object->addCalculatedField(
	'IsNew',
	' IF(%1$s.NewItem = 2,
	IF(%1$s.CreatedOn >= (UNIX_TIMESTAMP() - '.
	$this->Application->ConfigValue('Category_DaysNew').
	'360024), 1, 0),
	%1$s.NewItem
	)');
	}

	/**
	* Set correct parent path for newly created categories
	*
	* @param kEvent $event
	*/
	function OnAfterCopyToLive(&$event)
	{
	$parent_path = false;
	$object =& $this->Application->recallObject($event->Prefix.'.-item', null, Array('skip_autoload' => true, 'live_table' => true));
	$object->Load($event->getEventParam('id'));
	if ($event->getEventParam('temp_id') == 0) {
	if ($object->isLoaded()) {
	// update path only for real categories (not including "Home" root category)
	$fields_hash = Array('ParentPath' => $object->buildParentPath());
	$this->Conn->doUpdate($fields_hash, $object->TableName, 'CategoryId = '.$object->GetID());
	$parent_path = $fields_hash['ParentPath'];
	}
	}
	else {
	$parent_path = $object->GetDBField('ParentPath');
	}
	if ($parent_path) {
	$cache_updater =& $this->Application->recallObject('kPermCacheUpdater', null, array('strict_path' => $parent_path));
	$cache_updater->OneStepRun();
	$cache_updater->StrictPath = false;
	}
	}

	/**
	* Set cache modification mark if needed
	*
	* @param kEvent $event
	*/
	function OnBeforeDeleteFromLive(&$event)
	{
	$id = $event->getEventParam('id');

	// loding anyway, because this object is needed by "c-perm:OnBeforeDeleteFromLive" event
	$temp_object =& $event->getObject( Array('skip_autoload' => true) );
	$temp_object->Load($id);

	if ($id == 0) {
	if ($temp_object->isLoaded()) {
	// new category -> update chache (not loaded when "Home" category)
	$this->Application->StoreVar('PermCache_UpdateRequired', 1);
	}
	return ;
	}

	// existing category was edited, check if in-cache fields are modified
	$live_object =& $this->Application->recallObject($event->Prefix.'.-item', null, Array('live_table' => true, 'skip_autoload' => true));
	$live_object->Load($id);

	$cached_fields = Array('Name', 'Filename', 'CategoryTemplate', 'ParentId');

	foreach ($cached_fields as $cached_field) {
	if ($live_object->GetDBField($cached_field) != $temp_object->GetDBField($cached_field)) {
	// use session instead of REQUEST because of permission editing in category can contain
	// multiple submits, that changes data before OnSave event occurs
	$this->Application->StoreVar('PermCache_UpdateRequired', 1);
	break;
	}
	}
	}

	/**
	* Calls kDBEventHandler::OnSave original event
	* Used in proj-cms:StructureEventHandler->OnSave
	*
	* @param kEvent $event
	*/
	function parentOnSave(&$event)
	{
	parent::OnSave($event);
	}

	/**
	* Checks cache update mark and redirect to cache if needed
	*
	* @param kEvent $event
	*/
	function OnSave(&$event)
	{
	$object =& $event->getObject();
	if ($object->IsRoot()) {
	$event->setEventParam('master_ids', Array(0));
	}

	parent::OnSave($event);
	if ($event->status == erSUCCESS && $this->Application->RecallVar('PermCache_UpdateRequired')) {
	// "catalog" should be in opener stack by now
	$wid = $this->Application->GetVar('m_wid');
	$stack_name = rtrim('opener_stack_'.$wid, '_');

	$opener_stack = unserialize($this->Application->RecallVar($stack_name));
	$opener_stack[0] = str_replace('catalog', 'categories/cache_updater', $opener_stack[0]);
	$this->Application->StoreVar($stack_name, serialize($opener_stack));
	$this->Application->RemoveVar('PermCache_UpdateRequired');
	}
	}

	/**
	* Deletes all selected items.
	* Automatically recurse into sub-items using temp handler, and deletes sub-items
	* by calling its Delete method if sub-item has AutoDelete set to true in its config file
	*
	* @param kEvent $event
	*/
	function OnMassDelete(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

	// $event->status = erSUCCESS;

	$ids = $this->StoreSelectedIDs($event);
	if ($ids) {
	$recursive_helper =& $this->Application->recallObject('RecursiveHelper');
	/* @var $recursive_helper kRecursiveHelper */

	foreach ($ids as $id) {
	$recursive_helper->DeleteCategory($id, $event->Prefix);
	}
	}
	$this->clearSelectedIDs($event);
	}

	/**
	* Add selected items to clipboard with mode = COPY (CLONE)
	*
	* @param kEvent $event
	*/
	function OnCopy(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	$clipboard_helper->setClipboard($event, 'copy', $this->StoreSelectedIDs($event));
	$this->clearSelectedIDs($event);
	}

	/**
	* Add selected items to clipboard with mode = CUT
	*
	* @param kEvent $event
	*/
	function OnCut(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	$clipboard_helper =& $this->Application->recallObject('ClipboardHelper');
	$clipboard_helper->setClipboard($event, 'cut', $this->StoreSelectedIDs($event));
	$this->clearSelectedIDs($event);
	}

	/**
	* Controls all item paste operations. Can occur only with filled clipbord.
	*
	* @param kEvent $event
	*/
	function OnPasteClipboard(&$event)
	{
	$clipboard = unserialize( $this->Application->RecallVar('clipboard') );
	foreach ($clipboard as $prefix => $clipboard_data) {
	$paste_event = new kEvent($prefix.':OnPaste', Array('clipboard_data' => $clipboard_data));
	$this->Application->HandleEvent($paste_event);

	$event->redirect = $paste_event->redirect;
	$event->redirect_params = $paste_event->redirect_params;
	$event->status = $paste_event->status;
	}
	}

	/**
	* Paste categories with subitems from clipboard
	*
	* @param kEvent $event
	*/
	function OnPaste(&$event)
	{
	if ($this->Application->CheckPermission('SYSTEM_ACCESS.READONLY', 1)) {
	return;
	}

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

	if (!$clipboard_data['cut'] && !$clipboard_data['copy']) {
	return false;
	}

	$recursive_helper =& $this->Application->recallObject('RecursiveHelper');
	/* @var $recursive_helper kRecursiveHelper */

	if ($clipboard_data['cut']) {
	$recursive_helper->MoveCategories($clipboard_data['cut'], $this->Application->GetVar('m_cat_id'));
	}

	if ($clipboard_data['copy']) {
	foreach ($clipboard_data['copy'] as $id) {
	$recursive_helper->PasteCategory($id, $event->Prefix);
	}
	}

	if ($clipboard_data['cut'] \|\| $clipboard_data['copy']) {
	$event->redirect = 'in-portal/categories/cache_updater';
	}
	}

	/**
	* Occurs when pasting category
	*
	* @param kEvent $event
	*/
	/*function OnCatPaste(&$event)
	{
	$inp_clipboard = $this->Application->RecallVar('ClipBoard');
	$inp_clipboard = explode('-', $inp_clipboard, 2);

	if($inp_clipboard[0] == 'COPY')
	{
	$saved_cat_id = $this->Application->GetVar('m_cat_id');
	$cat_ids = $event->getEventParam('cat_ids');

	$id_field = $this->Application->getUnitOption($event->Prefix, 'IDField');
	$table = $this->Application->getUnitOption($event->Prefix, 'TableName');
	$ids_sql = 'SELECT '.$id_field.' FROM '.$table.' WHERE ResourceId IN (%s)';
	$resource_ids_sql = 'SELECT ItemResourceId FROM '.TABLE_PREFIX.'CategoryItems WHERE CategoryId = %s AND PrimaryCat = 1';

	$object =& $this->Application->recallObject($event->Prefix.'.item', $event->Prefix, Array('skip_autoload' => true));

	foreach($cat_ids as $source_cat => $dest_cat)
	{
	$item_resource_ids = $this->Conn->GetCol( sprintf($resource_ids_sql, $source_cat) );
	if(!$item_resource_ids) continue;

	$this->Application->SetVar('m_cat_id', $dest_cat);
	$item_ids = $this->Conn->GetCol( sprintf($ids_sql, implode(',', $item_resource_ids) ) );

	$temp =& $this->Application->recallObject($event->getPrefixSpecial().'_TempHandler', 'kTempTablesHandler');
	if($item_ids) $temp->CloneItems($event->Prefix, $event->Special, $item_ids);
	}

	$this->Application->SetVar('m_cat_id', $saved_cat_id);
	}
	}*/

	/**
	* Cleares clipboard content
	*
	* @param kEvent $event
	*/
	function OnClearClipboard(&$event)
	{
	$this->Application->RemoveVar('clipboard');
	}
	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.27.2/core/units/categories/categories_event_handler.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.27
	\ No newline at end of property
	+1.27.2.1
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.4.2/themes/default/register/register_form.tpl
	===================================================================
	--- branches/unlabeled/unlabeled-1.4.2/themes/default/register/register_form.tpl (revision 7742)
	+++ branches/unlabeled/unlabeled-1.4.2/themes/default/register/register_form.tpl (revision 7743)
	@@ -1,178 +1,180 @@
	<!-- profile content -->
	<FORM method="POST" NAME="register" ACTION="<inp:m_form_action _Form="m_register" _ConfirmTemplate="register/register_confirm.tpl" _NotAllowedTemplate="register/register_notallowed.tpl" _PendingTemplate="register/register_pending.tpl" _LoginTemplate="my_account.tpl"/>">
	<table border="0" cellspacing="0" cellpadding="0">
	<tr>
	<td colspan="4">
	<table border="0" cellspacing="0" cellpadding="0">
	<tr>
	<td><h2><inp:m_language _Phrase="lu_login_information" /></h2></td>
	<td><img src="img/s.gif" width="10" height="1" alt="" /><br /></td>
	<td class="tips">(<span class="error">*</span><inp:m_language _Phrase="lu_required_field" />)</td>
	</tr>
	</table>
	</td>
	</tr>
	<tr>
	<td colspan="4" class="error"><inp:m_form_has_errors _Form="m_register" /></td>
	</tr>
	<tr>
	<td colspan="4" class="bgr-updatefill"><img src="img/s.gif" width="300" height="1" alt="" /><br /></td>
	</tr>
	<tr>
	<td colspan="4"><img src="img/s.gif" width="1" height="5" alt="" /><br /></td>
	</tr>
	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="username" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" _langtext="lu_username" /> <span class="error">*</span></td>
	<td><img src="img/s.gif" width="5" height="1" alt="" /><br /></td>
	<td><inp:m_form_input type="text" class="input" style="width:135px;" _field="username" _Form="m_register" _Required="1" /><br /></td>
	</tr>
	<inp:m_autopassword _Value="false">
	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="password" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" _langtext="lu_password" /> <span class="error">*</span></td>
	<td> </td>
	<td><inp:m_form_input type="password" class="input" _field="password" _Form="m_register" _Required="1" style="width:135px;" /><br /></td>
	</tr>
	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="passwordverify" _langtext="lu_password_again" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /> <span class="error">*</span></td>
	<td> </td>
	<td><inp:m_form_input type="password" class="input" _field="passwordverify" _Form="m_register" _Required="1" style="width:135px;" /><br /></td>
	</tr>
	</inp>
	<tr>
	<td colspan=4><!-- <inp:m_autopassword _Value="true" _LangText="lu_register_autopasswd" /> --></td>
	</tr>
	<tr>
	<td colspan="4"><img src="img/s.gif" width="1" height="20" alt="" /><br /></td>
	</tr>
	<tr>
	<td colspan="4"><h2><inp:m_language _Phrase="lu_contact_information" /></h2></td>
	<tr>
	<tr>
	<td colspan="4" class="error"><img src="img/s.gif" width="1" height="3" alt="" /><br /></td>
	</tr>
	<tr>
	<td colspan="4" class="bgr-updatefill"><img src="img/s.gif" width="300" height="1" alt="" /><br /></td>
	</tr>
	<tr>
	<td colspan="4"><img src="img/s.gif" width="1" height="5" alt="" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="firstname" _langtext="lu_pp_firstname" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /> <span class="error">*</span></td>
	<td><img src="img/s.gif" width="5" height="1" alt="" /><br /></td>
	<td><inp:m_form_input _field="firstname" _Form="m_register" _Required="1" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="lastname" _langtext="lu_pp_lastname" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /></td>
	<td> </td>
	<td><inp:m_form_input _field="lastname" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="company" _langtext="lu_pp_company" _Template="misc/form_prompt" _ErrorTemplate="misc/form_prompt_error" /></td>
	<td> </td>
	<td><inp:m_form_input _field="company" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="phone" _langtext="lu_pp_phone" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /></td>
	<td> </td>
	<td><inp:m_form_input _field="phone" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="fax" _langtext="lu_pp_fax" _Template="misc/form_prompt" _ErrorTemplate="misc/form_prompt_error" /></td>
	<td> </td>
	<td><inp:m_form_input _field="fax" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="email" _langtext="lu_pp_email" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /> <span class="error">*</span></td>
	<td> </td>
	<td><inp:m_form_input _field="email" _Required="1" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="dob" _langtext="lu_pp_dob" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /> <span class="error">*</span> (<inp:m_lang_dateformat />)</td>
	<td> </td>
	<td><inp:include _Template="register/register_dob.tpl" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="street" _langtext="lu_pp_street" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt.tpl" /></td>
	<td><img src="img/s.gif" width="5" height="1" alt="" /><br /></td>
	<td><inp:m_form_input _field="street" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="street2" _langtext="lu_pp_street2" _Template="misc/form_prompt" _ErrorTemplate="misc/form_prompt" /></td>
	<td><img src="img/s.gif" width="5" height="1" alt="" /><br /></td>
	<td><inp:m_form_input _field="street2" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="phone" _langtext="lu_pp_city" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /></td>
	<td> </td>
	<td><inp:m_form_input _field="city" _Form="m_register" type="text" class="input" style="width:135px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="state" _langtext="lu_pp_state" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /></td>
	<td> </td>
	<td><inp:m_form_input _field="state" _Form="m_register" type="text" class="input" style="width:50px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="zip" _langtext="lu_pp_zip" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /></td>
	<td> </td>
	<td><inp:m_form_input _field="zip" _Form="m_register" type="text" class="input" style="width:50px;" /><br /></td>
	</tr>

	<tr>
	<td><img src="img/s.gif" width="16" height="1" alt="" /><br /></td>
	<td><inp:m_form_prompt _Form="m_register" _Field="zip" _langtext="lu_pp_country" _Template="misc/form_prompt.tpl" _ErrorTemplate="misc/form_prompt_error.tpl" /></td>
	<td> </td>
	<td><SELECT name="country" class="input" style="width:135px;">
	<inp:lang_include _Language="english" _Template="register/english_countries.tpl" />
	</SELECT>
	</td>
	</tr>

	<tr>
	<td colspan="4"><img src="img/s.gif" width="1" height="20" alt="" /><br /></td>
	</tr>

	<!-- buttons -->
	<tr>
	<td colspan="4"><img src="img/s.gif" width="1" height="3" alt="" /><br /></td>
	</tr>
	<tr>
	<td colspan="4" class="bgr-updatefill"><img src="img/s.gif" width="300" height="1" alt="" /><br /></td>
	</tr>
	<tr>
	<td colspan="4">
	+
	+
	<img src="img/s.gif" width="1" height="3" alt="" /><br />
	<INPUT type="submit" name="buttons[]" value="<inp:m_language _Phrase="lu_register" />" class="button">
	<INPUT type="submit" name="buttons[]" value="<inp:m_language _Phrase="la_cancel" />" class="button">
	</td>
	</tr>
	<!-- end buttons -->
	</table>
	</FORM>
	<!-- end profile content -->
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.4.2/themes/default/register/register_form.tpl
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4
	\ No newline at end of property
	+1.4.2.1
	\ No newline at end of property

in-portalNo OneTemporaryActions

File Metadata

in-portalView Options

Event Timeline

in-portal
No OneTemporary
Actions

in-portal
View Options