in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Sun, Aug 17, 4:16 AM

in-portal
View Options

	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 7925)
	+++ branches/unlabeled/unlabeled-1.27.2/core/units/categories/categories_event_handler.php (revision 7926)
	@@ -1,565 +1,611 @@
	<?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);
	}

	/**
	+ * Set's mark, that root category is edited
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnEdit(&$event)
	+ {
	+ $category_id = $this->Application->GetVar($event->getPrefixSpecial().'_id');
	+ $this->Application->StoreVar('IsRootCategory_'.$this->Application->GetVar('m_wid'), $category_id === '0');
	+
	+ parent::OnEdit($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') !== false) {
	$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 cache (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', 'Priority');

	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);
	}

	/**
	+ * Reset root-category flag when new category is created
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnPreCreate(&$event)
	+ {
	+ $this->Application->RemoveVar('IsRootCategory_'.$this->Application->GetVar('m_wid'));
	+
	+ parent::OnPreCreate($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));
	+ $this->RemoveRequiredFields($object);
	}

	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, '_');
	-
	+ $this->Application->RemoveVar('IsRootCategory_'.$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');
	}
	}

	/**
	+ * Creates a new item in temp table and
	+ * stores item id in App vars and Session on succsess
	+ *
	+ * @param kEvent $event
	+ */
	+ function OnPreSaveCreated(&$event)
	+ {
	+ $object =& $event->getObject( Array('skip_autoload' => true) );
	+ /* @var $object CategoriesItem */
	+
	+ if ($object->IsRoot()) {
	+ // don't create root category while saving permissions
	+ return ;
	+ }
	+
	+ parent::OnPreSaveCreated($event);
	+ }
	+
	+ /**
	* 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.2.3
	\ No newline at end of property
	+1.27.2.4
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.12.2/core/units/categories/categories_item.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.12.2/core/units/categories/categories_item.php (revision 7925)
	+++ branches/unlabeled/unlabeled-1.12.2/core/units/categories/categories_item.php (revision 7926)
	@@ -1,234 +1,224 @@
	<?php

	class CategoriesItem extends kDBItem
	{
	function Create($force_id=false, $system_create=false)
	{
	$this->checkFilename();
	$this->generateFilename();

	if (!$this->Validate()) return false;

	$this->SetDBField('ResourceId', $this->Application->NextResourceId());
	$this->SetDBField('CreatedById', $this->Application->RecallVar('user_id') );
	$this->SetDBField('CreatedOn_date', adodb_mktime() );
	$this->SetDBField('CreatedOn_time', adodb_mktime() );

	$parent_category = $this->GetDBField('ParentId') > 0 ? $this->GetDBField('ParentId') : $this->Application->GetVar('m_cat_id');
	$this->SetDBField('ParentId', $parent_category);

	$ret = parent::Create($force_id, $system_create);
	if ($ret) {
	$sql = 'UPDATE %s SET ParentPath = %s WHERE CategoryId = %s';
	$parent_path = $this->buildParentPath();
	$this->Conn->Query( sprintf($sql, $this->TableName, $this->Conn->qstr($parent_path), $this->GetID() ) );

	$this->SetDBField('ParentPath', $parent_path);
	}
	return $ret;

	}

	function Update($id=null, $system_update=false)
	{
	$this->checkFilename();
	$this->generateFilename();

	$ret = parent::Update($id, $system_update);
	return $ret;
	}

	function buildParentPath()
	{
	$parent_id = $this->GetDBField('ParentId');

	if ($parent_id == 0) {
	$parent_path = '\|';
	}
	else {
	$cat_table = $this->Application->getUnitOption($this->Prefix, 'TableName');
	$sql = 'SELECT ParentPath FROM '.$cat_table.' WHERE CategoryId = %s';
	$parent_path = $this->Conn->GetOne( sprintf($sql, $parent_id) );
	}

	return $parent_path.$this->GetID().'\|';
	}

	/**
	* replace not allowed symbols with "_" chars + remove duplicate "_" chars in result
	*
	* @param string $string
	* @return string
	*/
	function stripDisallowed($string)
	{
	$not_allowed = Array( ' ', '\\', '/', ':', '*', '?', '"', '<', '>', '\|', '`',
	'~', '!', '@', '#', '$', '%', '^', '&', '(', ')', '~',
	'+', '=', '-', '{', '}', ']', '[', "'", ';', '.', ',');

	$string = str_replace($not_allowed, '_', $string);
	$string = preg_replace('/(_+)/', '_', $string);
	$string = $this->checkAutoFilename($string);

	return $string;
	}

	function checkFilename()
	{
	// System templates allow any characters in filename, because they may and will contain "/"
	if( !$this->GetDBField('AutomaticFilename') && !$this->GetDBField('IsSystem'))
	{
	$filename = $this->GetDBField('Filename');
	$this->SetDBField('Filename', $this->stripDisallowed($filename) );
	}
	}

	function checkAutoFilename($filename)
	{
	if(!$filename) return $filename;

	$item_id = !$this->GetID() ? 0 : $this->GetID();

	// check temp table
	$sql_temp = 'SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE Filename = '.$this->Conn->qstr($filename);
	$found_temp_ids = $this->Conn->GetCol($sql_temp);

	// check live table
	$sql_live = 'SELECT '.$this->IDField.' FROM '.$this->Application->GetLiveName($this->TableName).' WHERE Filename = '.$this->Conn->qstr($filename);
	$found_live_ids = $this->Conn->GetCol($sql_live);

	$found_item_ids = array_unique( array_merge($found_temp_ids, $found_live_ids) );

	$has_page = preg_match('/(.)_([\d]+)([a-z])$/', $filename, $rets);

	$duplicates_found = (count($found_item_ids) > 1) \|\| ($found_item_ids && $found_item_ids[0] != $item_id);
	if ($duplicates_found \|\| $has_page) // other category has same filename as ours OR we have filename, that ends with _number
	{
	$append = $duplicates_found ? '_a' : '';
	if($has_page)
	{
	$filename = $rets[1].'_'.$rets[2];
	$append = $rets[3] ? $rets[3] : '_a';
	}

	// check live & temp table
	$sql_temp = 'SELECT '.$this->IDField.' FROM '.$this->TableName.' WHERE (Filename = %s) AND ('.$this->IDField.' != '.$item_id.')';
	$sql_live = 'SELECT '.$this->IDField.' FROM '.$this->Application->GetLiveName($this->TableName).' WHERE (Filename = %s) AND ('.$this->IDField.' != '.$item_id.')';
	while ( $this->Conn->GetOne( sprintf($sql_temp, $this->Conn->qstr($filename.$append)) ) > 0 \|\|
	$this->Conn->GetOne( sprintf($sql_live, $this->Conn->qstr($filename.$append)) ) > 0 )
	{
	if (substr($append, -1) == 'z') $append .= 'a';
	$append = substr($append, 0, strlen($append) - 1) . chr( ord( substr($append, -1) ) + 1 );
	}

	return $filename.$append;
	}

	return $filename;
	}

	/**
	* Generate item's filename based on it's title field value
	*
	* @return string
	*/
	function generateFilename()
	{
	if ( !$this->GetDBField('AutomaticFilename') && $this->GetDBField('Filename') ) return false;

	$ml_formatter =& $this->Application->recallObject('kMultiLanguage');
	$name = $this->stripDisallowed( $this->GetDBField( $ml_formatter->LangFieldName('Name', true) ) );

	if ( $name != $this->GetDBField('Filename') ) $this->SetDBField('Filename', $name);
	}

	/**
	* Allows to detect if root category being edited
	*
	* @param Array $params
	*/
	function IsRoot()
	{
	- $category_id = $this->Application->GetVar($this->getPrefixSpecial().'_id');
	- if (is_numeric($category_id) && $category_id == 0 && !$this->Application->GetVar($this->getPrefixSpecial().'_PreCreate')) {
	- $sql = 'SELECT '.$this->IDField.'
	- FROM '.$this->TableName.'
	- WHERE '.$this->IDField.' = '.$category_id;
	- if ($this->Conn->GetOne($sql) === false) {
	- return true;
	- }
	- }
	-
	- return false;
	+ return $this->Application->RecallVar('IsRootCategory_'.$this->Application->GetVar('m_wid'));
	}

	/**
	* Sets correct name to Home category while editing it
	*
	* @return bool
	*/
	function IsNewItem()
	{
	if ($this->IsRoot() && $this->Prefix == 'c') {
	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	$category_name = $this->Application->Phrase( $this->Application->ConfigValue('Root_Name') );
	$this->SetDBField($title_field, $category_name);
	return false;
	}
	return parent::IsNewItem();
	}

	/**
	* Sets new name for item in case if it is beeing copied
	* in same table
	*
	* @param array $master Table data from TempHandler
	* @param int $foreign_key ForeignKey value to filter name check query by
	* @access private
	*/
	function NameCopy($master=null, $foreign_key=null)
	{
	$title_field = $this->Application->getUnitOption($this->Prefix, 'TitleField');
	if (!$title_field \|\| isset($this->CalculatedFields[$title_field]) ) return;

	$new_name = $this->GetDBField($title_field);
	$cat_id = $this->Application->GetVar('m_cat_id');
	$this->SetDBField('ParentId', $cat_id);
	$original_checked = false;
	do {
	if ( preg_match('/Copy ([0-9]) of (.*)/', $new_name, $regs) ) {
	$new_name = 'Copy '.($regs[1]+1).' of '.$regs[2];
	}
	elseif ($original_checked) {
	$new_name = 'Copy of '.$new_name;
	}

	// if we are cloning in temp table this will look for names in temp table,
	// since object' TableName contains correct TableName (for temp also!)
	// if we are cloning live - look in live
	$query = 'SELECT '.$title_field.' FROM '.$this->TableName.'
	WHERE ParentId = '.$cat_id.' AND '.$title_field.' = '.$this->Conn->qstr($new_name);

	$foreign_key_field = getArrayValue($master, 'ForeignKey');
	$foreign_key_field = is_array($foreign_key_field) ? $foreign_key_field[ $master['ParentPrefix'] ] : $foreign_key_field;

	if ($foreign_key_field && isset($foreign_key)) {
	$query .= ' AND '.$foreign_key_field.' = '.$foreign_key;
	}

	$res = $this->Conn->GetOne($query);

	/*// if not found in live table, check in temp table if applicable
	if ($res === false && $object->Special == 'temp') {
	$query = 'SELECT '.$name_field.' FROM '.$this->GetTempName($master['TableName']).'
	WHERE '.$name_field.' = '.$this->Conn->qstr($new_name);
	$res = $this->Conn->GetOne($query);
	}*/

	$original_checked = true;
	} while ($res !== false);
	$this->SetDBField($title_field, $new_name);
	}
	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.12.2/core/units/categories/categories_item.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.12.2.1
	\ No newline at end of property
	+1.12.2.2
	\ 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