in-portal
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Wed, Jul 23, 10:26 PM

in-portal
View Options

	Index: branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php (revision 7090)
	+++ branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php (revision 7091)
	@@ -1,1746 +1,1748 @@
	<?php

	class kDBTagProcessor extends TagProcessor {

	/**
	* Description
	*
	* @var kDBConnection
	* @access public
	*/
	var $Conn;

	function kDBTagProcessor()
	{
	parent::kBase();
	$this->Conn =& $this->Application->GetADODBConnection();
	}


	/**
	* Returns true if "new" button was pressed in toolbar
	*
	* @param Array $params
	* @return bool
	*/
	function IsNewMode($params)
	{
	$object =& $this->getObject($params);
	return $object->GetID() <= 0;
	}

	/**
	* Returns view menu name for current prefix
	*
	* @param Array $params
	* @return string
	*/
	function GetItemName($params)
	{
	$item_name = $this->Application->getUnitOption($this->Prefix, 'ViewMenuPhrase');
	return $this->Application->Phrase($item_name);
	}

	function ViewMenu($params)
	{
	$block_params = $params;
	unset($block_params['block']);
	$block_params['name'] = $params['block'];

	$list =& $this->GetList($params);
	$block_params['PrefixSpecial'] = $list->getPrefixSpecial();
	return $this->Application->ParseBlock($block_params);
	}

	function SearchKeyword($params)
	{
	$list =& $this->GetList($params);
	return $this->Application->RecallVar($list->getPrefixSpecial().'_search_keyword');
	}

	/**
	* Draw filter menu content (for ViewMenu) based on filters defined in config
	*
	* @param Array $params
	* @return string
	*/
	function DrawFilterMenu($params)
	{
	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $params['spearator_block'];
	$separator = $this->Application->ParseBlock($block_params);
	$filter_menu = $this->Application->getUnitOption($this->Prefix,'FilterMenu');
	if(!$filter_menu)
	{
	trigger_error('<span class="debug_error">no filters defined</span> for prefix <b>'.$this->Prefix.'</b>, but <b>DrawFilterMenu</b> tag used', E_USER_WARNING);
	return '';
	}

	// Params: label, filter_action, filter_status
	$block_params['name'] = $params['item_block'];

	$view_filter = $this->Application->RecallVar($this->getPrefixSpecial().'_view_filter');
	if($view_filter === false)
	{
	$event_params = Array('prefix'=>$this->Prefix,'special'=>$this->Special,'name'=>'OnRemoveFilters');
	$this->Application->HandleEvent( new kEvent($event_params) );
	$view_filter = $this->Application->RecallVar($this->getPrefixSpecial().'_view_filter');
	}
	$view_filter = unserialize($view_filter);

	$filters = Array();
	$prefix_special = $this->getPrefixSpecial();

	foreach ($filter_menu['Filters'] as $filter_key => $filter_params) {
	$group_params = isset($filter_params['group_id']) ? $filter_menu['Groups'][ $filter_params['group_id'] ] : Array();
	if (!isset($group_params['element_type'])) {
	$group_params['element_type'] = 'checkbox';
	}

	if (!$filter_params) {
	$filters[] = $separator;
	continue;
	}

	$block_params['label'] = addslashes( $this->Application->Phrase($filter_params['label']) );
	if (getArrayValue($view_filter,$filter_key)) {
	$submit = 0;
	$status = $group_params['element_type'] == 'checkbox' ? '[\'img/check_on.gif\']' : '[\'img/menu_dot.gif\']';
	}
	else {
	$submit = 1;
	$status = 'null';
	}
	$block_params['filter_action'] = 'set_filter("'.$prefix_special.'","'.$filter_key.'","'.$submit.'",'.$params['ajax'].');';
	$block_params['filter_status'] = $status; // 1 - checkbox, 2 - radio, 0 - no image
	$filters[] = $this->Application->ParseBlock($block_params);
	}


	return implode('', $filters);
	}

	function IterateGridFields($params)
	{
	$mode = $params['mode'];
	$def_block = isset($params['block']) ? $params['block'] : '';
	$force_block = isset($params['force_block']) ? $params['force_block'] : false;

	$grids = $this->Application->getUnitOption($this->Prefix,'Grids');
	$grid_config = $grids[$params['grid']]['Fields'];

	$picker_helper =& $this->Application->RecallObject('ColumnPickerHelper');
	/* @var $picker_helper kColumnPickerHelper */
	$picker_helper->ApplyPicker($this->getPrefixSpecial(), $grid_config, $params['grid']);

	$std_params['pass_params']='true';
	$std_params['PrefixSpecial']=$this->getPrefixSpecial();

	$o = '';
	$i = 0;
	foreach ($grid_config as $field => $options) {
	$i++;
	$block_params = Array();
	$block_params['name'] = $force_block ? $force_block : (isset($options[$mode.'_block']) ? $options[$mode.'_block'] : $def_block);
	$block_params['field'] = $field;
	$block_params['sort_field'] = isset($options['sort_field']) ? $options['sort_field'] : $field;
	$block_params['filter_field'] = isset($options['filter_field']) ? $options['filter_field'] : $field;

	$field_options = $this->Application->getUnitOption($this->Prefix.'.'.$field, 'Fields');
	if (isset($field_options['use_phrases'])) {
	$block_params['use_phrases'] = $field_options['use_phrases'];
	}

	$block_params['is_last'] = ($i == count($grid_config));
	$block_params = array_merge($std_params, $block_params, $options);
	$o.= $this->Application->ParseBlock($block_params, 1);
	}
	return $o;
	}

	function GridFieldsCount($params)
	{
	$grids = $this->Application->getUnitOption($this->Prefix, 'Grids');
	$grid_config = $grids[$params['grid']]['Fields'];

	return count($grid_config);
	}

	/**
	* Prints list content using block specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintList($params)
	{
	$list =& $this->GetList($params);
	$id_field = $this->Application->getUnitOption($this->Prefix,'IDField');

	$list->Query();
	$o = '';
	$list->GoFirst();

	$block_params=$this->prepareTagParams($params);
	$block_params['name'] = $this->SelectParam($params, 'render_as,block');
	$block_params['pass_params'] = 'true';

	while (!$list->EOL())
	{
	$this->Application->SetVar( $this->getPrefixSpecial().'_id', $list->GetDBField($id_field) ); // for edit/delete links using GET
	$o.= $this->Application->ParseBlock($block_params, 1);
	$list->GoNext();
	}

	$this->Application->SetVar( $this->getPrefixSpecial().'_id', '');
	return $o;
	}

	function InitList($params)
	{
	$list_name = isset($params['list_name']) ? $params['list_name'] : '';

	$names_mapping = $this->Application->GetVar('NamesToSpecialMapping');

	if( !getArrayValue($names_mapping, $this->Prefix, $list_name) )
	{
	$list =& $this->GetList($params);
	}
	}

	function BuildListSpecial($params)
	{
	return $this->Special;
	}

	/**
	* Enter description here...
	*
	* @param Array $params
	* @return kDBList
	*/
	function &GetList($params)
	{
	$list_name = $this->SelectParam($params, 'list_name,name');
	if (!$list_name) {
	$list_name = $this->Application->Parser->GetParam('list_name');
	}

	$requery = getArrayValue($params, 'requery');
	if ($list_name && !$requery){
	$names_mapping = $this->Application->GetVar('NamesToSpecialMapping');

	$special = getArrayValue($names_mapping, $this->Prefix, $list_name);
	if(!$special)
	{
	$special = $this->BuildListSpecial($params);
	}
	}
	else
	{
	$special = $this->BuildListSpecial($params);
	}

	$prefix_special = rtrim($this->Prefix.'.'.$special, '.');
	$params['skip_counting'] = true;
	$list =& $this->Application->recallObject( $prefix_special, $this->Prefix.'_List', $params);
	if ($requery) {
	$this->Application->HandleEvent($an_event, $prefix_special.':OnListBuild', $params);
	}
	$list->Query($requery);
	$this->Special = $special;

	if ($list_name) {
	$names_mapping[$this->Prefix][$list_name] = $special;
	$this->Application->SetVar('NamesToSpecialMapping', $names_mapping);
	}

	return $list;
	}

	function ListMarker($params)
	{
	$list =& $this->GetList($params);
	$ret = $list->getPrefixSpecial();
	if( getArrayValue($params, 'as_preg') ) $ret = preg_quote($ret, '/');
	return $ret;
	}

	function SubmitName($params)
	{
	$list =& $this->GetList($params);

	$prefix_special = $list->getPrefixSpecial();

	return 'events['.$prefix_special.']['.$params['event'].']';
	}


	function CombinedSortingDropDownName($params)
	{
	$list =& $this->GetList($params);
	$prefix_special = $list->getPrefixSpecial();

	return $prefix_special.'_CombinedSorting';
	}

	function SortingSelected($params)
	{
	$list =& $this->GetList($params);
	$user_sorting_start = $this->getUserSortIndex();

	$sorting = strtolower($list->GetOrderField($user_sorting_start).'\|'.$list->GetOrderDirection($user_sorting_start));

	if ($sorting == strtolower($params['sorting'])) return $params['selected'];
	}



	/**
	* Prints list content using block specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintList2($params)
	{
	$per_page = $this->SelectParam($params, 'per_page,max_items');
	if ($per_page !== false) $params['per_page'] = $per_page;

	$list =& $this->GetList($params);
	$o = '';

	$direction = (isset($params['direction']) && $params['direction']=="H")?"H":"V";
	$columns = (isset($params['columns'])) ? $params['columns'] : 1;

	$id_field = (isset($params['id_field'])) ? $params['id_field'] : $this->Application->getUnitOption($this->Prefix, 'IDField');

	if ($columns>1 && $direction=="V") {
	$list->Records = $this->LinearToVertical($list->Records, $columns, $list->GetPerPage());
	$list->SelectedCount=count($list->Records);
	ksort($list->Records); // this is issued twice, maybe need to be removed
	}

	$list->GoFirst();

	$block_params=$this->prepareTagParams($params);
	$block_params['name']=$this->SelectParam($params, 'render_as,block');
	$block_params['pass_params']='true';
	$block_params['column_width'] = 100 / $columns;
	$block_start_row_params = $this->prepareTagParams($params);
	$block_start_row_params['name'] = $this->SelectParam($params, 'row_start_render_as,block_row_start,row_start_block');

	$block_end_row_params=$this->prepareTagParams($params);
	$block_end_row_params['name'] = $this->SelectParam($params, 'row_end_render_as,block_row_end,row_end_block');

	$block_empty_cell_params = $this->prepareTagParams($params);
	$block_empty_cell_params['name'] = $this->SelectParam($params, 'empty_cell_render_as,block_empty_cell,empty_cell_block');

	$i=0;

	$backup_id=$this->Application->GetVar($this->Prefix."_id");
	$displayed = array();
	$column_number = 1;

	$cache_mod_rw = $this->Application->getUnitOption($this->Prefix, 'CacheModRewrite') && $this->Application->RewriteURLs();

	while (!$list->EOL())
	{
	$this->Application->SetVar( $this->getPrefixSpecial().'_id', $list->GetDBField($id_field) ); // for edit/delete links using GET
	$this->Application->SetVar( $this->Prefix.'_id', $list->GetDBField($id_field) );
	$block_params['is_last'] = ($i == $list->SelectedCount-1);

	if ($cache_mod_rw) {
	$this->Application->setCache('filenames', $this->Prefix.'_'.$list->GetDBField($id_field), $list->GetDBField('Filename'));
	$this->Application->setCache('filenames', 'c_'.$list->GetDBField('CategoryId'), $list->GetDBField('CategoryFilename'));
	}

	if ($i % $columns == 0) {
	// record in this iteration is first in row, then open row
	$column_number = 1;
	$o.= $block_start_row_params['name'] ?
	$this->Application->ParseBlock($block_start_row_params, 1) :
	(!isset($params['no_table']) ? '<tr>' : '');
	}
	else {
	$column_number++;
	}

	$block_params['column_number'] = $column_number;
	$o.= $this->Application->ParseBlock($block_params, 1);
	array_push($displayed, $list->GetDBField($id_field));

	if (($i+1) % $columns == 0) {
	// record in next iteration is first in row too, then close this row
	$o.= $block_end_row_params['name'] ?
	$this->Application->ParseBlock($block_end_row_params, 1) :
	(!isset($params['no_table']) ? '<tr>' : '');
	}

	$list->GoNext();
	$i++;
	}

	// append empty cells in place of missing cells in last row
	while ($i % $columns != 0) {
	// until next cell will be in new row append empty cells
	$o .= $block_empty_cell_params['name'] ? $this->Application->ParseBlock($block_empty_cell_params, 1) : '<td> </td>';

	if (($i+1) % $columns == 0) {
	// record in next iteration is first in row too, then close this row
	$o .= $block_end_row_params['name'] ? $this->Application->ParseBlock($block_end_row_params, 1) : '</tr>';
	}
	$i++;
	}

	$cur_displayed = $this->Application->GetVar($this->Prefix.'_displayed_ids');
	if (!$cur_displayed) {
	$cur_displayed = Array();
	}
	else {
	$cur_displayed = explode(',', $cur_displayed);
	}

	$displayed = array_unique(array_merge($displayed, $cur_displayed));
	$this->Application->SetVar($this->Prefix.'_displayed_ids', implode(',',$displayed));

	$this->Application->SetVar( $this->Prefix.'_id', $backup_id);
	$this->Application->SetVar( $this->getPrefixSpecial().'_id', '');

	if (isset($params['more_link_render_as'])) {
	$block_params = $params;
	$params['render_as'] = $params['more_link_render_as'];
	$o .= $this->MoreLink($params);
	}

	return $o;
	}

	function MoreLink($params)
	{
	$per_page = $this->SelectParam($params, 'per_page,max_items');
	if ($per_page !== false) $params['per_page'] = $per_page;
	$list =& $this->GetList($params);
	if ($list->PerPage < $list->RecordsCount) {
	$block_params = array();
	$block_params['name'] = $this->SelectParam($params, 'render_as,block');
	return $this->Application->ParseBlock($block_params, 1);
	}
	}

	function NotLastItem($params)
	{
	$object =& $this->getList($params); // maybe we should use $this->GetList($params) instead
	return ($object->CurrentIndex < min($object->PerPage == -1 ? $object->RecordsCount : $object->PerPage, $object->RecordsCount) - 1);
	}

	function PageLink($params)
	{
	$t = isset($params['template']) ? $param['template'] : '';
	if (!$t) $t = $this->Application->GetVar('t');

	if (isset($params['page'])) {
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $params['page']);
	}

	// $http_query =& $this->Application->recallObject('HTTPQuery');
	// $get = $http_query->getRedirectParams();
	$pass = Array('pass' => 'm,'.$this->getPrefixSpecial());
	// $pass = array_merge($get, $pass);

	return $this->Application->HREF($t, '', $pass);
	}

	function ColumnWidth($params)
	{
	$columns = $this->Application->Parser->GetParam('columns');
	return round(100/$columns).'%';
	}

	/**
	* Append prefix and special to tag
	* params (get them from tagname) like
	* they were really passed as params
	*
	* @param Array $tag_params
	* @return Array
	* @access protected
	*/
	function prepareTagParams($tag_params = Array())
	{
	/*if (isset($tag_params['list_name'])) {
	$list =& $this->GetList($tag_params);
	$this->Init($list->Prefix, $list->Special);
	}*/

	$ret = $tag_params;
	$ret['Prefix'] = $this->Prefix;
	$ret['Special'] = $this->Special;
	$ret['PrefixSpecial'] = $this->getPrefixSpecial();
	return $ret;
	}

	function GetISO($currency)
	{
	if ($currency == 'selected') {
	$iso = $this->Application->RecallVar('curr_iso');
	}
	elseif ($currency == 'primary' \|\| $currency == '') {
	$iso = $this->Application->GetPrimaryCurrency();
	}
	else { //explicit currency
	$iso = $currency;
	}
	return $iso;
	}

	function ConvertCurrency($value, $iso)
	{
	$converter =& $this->Application->recallObject('kCurrencyRates');
	// convery primary currency to selected (if they are the same, converter will just return)
	$value = $converter->Convert($value, 'PRIMARY', $iso);
	return $value;
	}

	function AddCurrencySymbol($value, $iso)
	{
	$currency =& $this->Application->recallObject('curr.-'.$iso, null, Array('skip_autoload' => true));
	if( !$currency->isLoaded() ) $currency->Load($iso, 'ISO');

	$symbol = $currency->GetDBField('Symbol');
	if (!$symbol) $symbol = $currency->GetDBField('ISO').' ';
	if ($currency->GetDBField('SymbolPosition') == 0) {
	$value = $symbol.$value;
	}
	if ($currency->GetDBField('SymbolPosition') == 1) {
	$value = $value.$symbol;
	}
	return $value;
	}

	/**
	* Get's requested field value
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function Field($params)
	{
	$field = $this->SelectParam($params, 'name,field');

	if( !$this->Application->IsAdmin() ) $params['no_special'] = 'no_special';

	$object =& $this->getObject($params);

	if ( $this->HasParam($params, 'db') )
	{
	$value = $object->GetDBField($field);
	}
	else
	{
	if( $this->HasParam($params, 'currency') )
	{
	$iso = $this->GetISO($params['currency']);
	$original = $object->GetDBField($field);
	$value = $this->ConvertCurrency($original, $iso);
	$object->SetDBField($field, $value);
	$object->Fields[$field]['converted'] = true;
	}

	$format = getArrayValue($params, 'format');
	if( !$format \|\| $format == '$format' )
	{
	$format = null;
	}
	else
	{
	if(preg_match("/_regional_(.*)/", $format, $regs))
	{
	$lang =& $this->Application->recallObject('lang.current');
	$format = $lang->GetDBField($regs[1]);
	}
	}
	$value = $object->GetField($field, $format);

	if( $this->SelectParam($params, 'negative') )
	{
	if(strpos($value, '-') === 0)
	{
	$value = substr($value, 1);
	}
	else
	{
	$value = '-'.$value;
	}
	}

	if( $this->HasParam($params, 'currency') )
	{
	$value = $this->AddCurrencySymbol($value, $iso);
	$params['no_special'] = 1;
	}
	}

	if( !$this->HasParam($params, 'no_special') ) $value = htmlspecialchars($value);
	if( getArrayValue($params,'checked' ) ) $value = ($value == ( isset($params['value']) ? $params['value'] : 1)) ? 'checked' : '';
	if( isset($params['plus_or_as_label']) ) {
	$value = substr($value, 0,1) == '+' ? substr($value, 1) : $this->Application->Phrase($value);
	}
	elseif( getArrayValue($params,'as_label') ) $value = $this->Application->Phrase($value);

	$first_chars = $this->SelectParam($params,'first_chars,cut_first');
	if($first_chars)
	{
	$needs_cut = strlen($value) > $first_chars;
	$value = substr($value,0,$first_chars);
	if($needs_cut) $value .= ' ...';
	}
	if( getArrayValue($params,'nl2br' ) ) $value = nl2br($value);

	if ($value != '') $this->Application->Parser->DataExists = true;

	if( $this->HasParam($params, 'currency') )
	{
	//restoring value in original currency, for other Field tags to work properly
	$object->SetDBField($field, $original);
	}

	return $value;
	}

	function SetField($params)
	{
	// <inp2:SetField field="Value" src=p:cust_{$custom_name}"/>

	$object =& $this->getObject($params);
	$dst_field = $this->SelectParam($params, 'name,field');

	list($prefix_special, $src_field) = explode(':', $params['src']);
	$src_object =& $this->Application->recallObject($prefix_special);
	$object->SetDBField($dst_field, $src_object->GetDBField($src_field));
	}

	/**
	* Checks if parameter is passed
	* Note: works like Tag and line simple method too
	*
	* @param Array $params
	* @param string $param_name
	* @return bool
	*/
	function HasParam($params, $param_name = null)
	{
	if( !isset($param_name) )
	{
	$param_name = $this->SelectParam($params, 'name');
	$params = $this->Application->Parser->Params;
	}
	$value = getArrayValue($params, $param_name);
	return $value && ($value != '$'.$param_name);
	}

	function PhraseField($params)
	{
	$field_label = $this->Field($params);
	$translation = $this->Application->Phrase( $field_label );
	return $translation;
	}

	function Error($params)
	{
	$field = $this->SelectParam($params, 'name,field');
	$object =& $this->getObject($params);
	$msg = $object->GetErrorMsg($field, false);
	return $msg;
	}

	function HasError($params)
	{
	if ($params['field'] == 'any')
	{
	$object =& $this->getObject($params);

	$skip_fields = getArrayValue($params, 'except');
	$skip_fields = $skip_fields ? explode(',', $skip_fields) : Array();

	return $object->HasErrors($skip_fields);
	}
	else
	{
	$fields = $this->SelectParam($params, 'field,fields');
	$fields = explode(',', $fields);
	$res = false;
	foreach($fields as $field)
	{
	$params['field'] = $field;
	$res = $res \|\| ($this->Error($params) != '');
	}
	return $res;
	}
	}

	function ErrorWarning($params)
	{
	if (!isset($params['field'])) {
	$params['field'] = 'any';
	}
	if ($this->HasError($params)) {
	return $this->Application->ParseBlock($params);
	}
	}

	function IsRequired($params)
	{
	$field = $params['field'];
	$object =& $this->getObject($params);;

	$formatter_class = getArrayValue($object->Fields, $field, 'formatter');
	if ($formatter_class == 'kMultiLanguage')
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$field = $formatter->LangFieldName($field);
	}

	$options = $object->GetFieldOptions($field);
	return getArrayValue($options,'required');
	}

	function PredefinedOptions($params)
	{
	$field = $params['field'];
	$object =& $this->getObject($params);

	$value = $object->GetDBField($field);
	$options = $object->GetFieldOptions($field);
	if( $this->HasParam($params,'has_empty') )
	{
	$empty_value = getArrayValue($params, 'empty_value');
	if($empty_value === false) $empty_value = '';
	$options['options'] = array_merge_recursive2( Array($empty_value => ''), $options['options'] );
	}

	$block_params = $this->prepareTagParams($params);

	$block_params['name'] = $this->SelectParam($params, 'render_as,block');
	$block_params['field'] = $params['field'];
	$block_params['pass_params'] = 'true';
	$block_params['field_name'] = $this->InputName($params);
	$block_params['PrefixSpecial'] = $this->getPrefixSpecial();

	$selected_param_name = getArrayValue($params,'selected_param');
	if(!$selected_param_name) $selected_param_name = $params['selected'];
	$selected = $params['selected'];

	$o = '';
	if( $this->HasParam($params,'no_empty') && !getArrayValue($options['options'],'') ) array_shift($options['options']);

	if( strpos($value, '\|') !== false )
	{
	// multiple selection checkboxes
	$value = explode('\|', substr($value, 1, -1) );
	foreach ($options['options'] as $key => $val)
	{
	$block_params['key'] = $key;
	$block_params['option'] = $val;
	$block_params[$selected_param_name] = ( in_array($key, $value) ? ' '.$selected : '');
	$o .= $this->Application->ParseBlock($block_params, 1);
	}
	}
	else
	{
	// single selection radio or checkboxes
	foreach ($options['options'] as $key => $val)
	{
	$block_params['key'] = $key;
	$block_params['option'] = $val;
	$block_params[$selected_param_name] = (strlen($key) == strlen($value) && ($key == $value) ? ' '.$selected : '');
	$o .= $this->Application->ParseBlock($block_params, 1);
	}
	}
	return $o;
	}

	function PredefinedSearchOptions($params)
	{
	$object =& $this->getObject($params);
	/* @var $object kDBList */

	$field = $params['field'];
	$saved_value = $object->Queried ? $object->GetDBField($field) : null;

	$object->SetDBField($field, $this->SearchField($params));
	$view_name = $this->Application->RecallVar($this->getPrefixSpecial().'_current_view');
	$custom_filter = $this->Application->RecallPersistentVar($this->getPrefixSpecial().'_custom_filter.'.$view_name);

	$ret = $this->PredefinedOptions($params);
	$object->SetDBField($field, $saved_value);
	return $ret;
	}

	function Format($params)
	{
	$field = $this->SelectParam($params, 'name,field');
	$object =& $this->getObject($params);

	$options = $object->GetFieldOptions($field);

	$format = $options[ $this->SelectParam($params, 'input_format') ? 'input_format' : 'format' ];

	$formatter_class = getArrayValue($options,'formatter');
	if($formatter_class)
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$human_format = getArrayValue($params,'human');
	$edit_size = getArrayValue($params,'edit_size');
	$sample = getArrayValue($params,'sample');
	if($sample)
	{
	return $formatter->GetSample($field, $options, $object);
	}
	elseif($human_format \|\| $edit_size)
	{
	$format = $formatter->HumanFormat($format);
	return $edit_size ? strlen($format) : $format;
	}
	}

	return $format;
	}

	/**
	* Print grid pagination using
	* block names specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PrintPages($params)
	{
	$list =& $this->GetList($params);
	$prefix_special = $list->getPrefixSpecial();
	$total_pages = $list->GetTotalPages();

	if ($total_pages > 1) $this->Application->Parser->DataExists = true;

	if($total_pages == 0) $total_pages = 1; // display 1st page as selected in case if we have no pages at all
	$o = '';

	// what are these 2 lines for?
	$this->Application->SetVar($prefix_special.'_event','');
	$this->Application->SetVar($prefix_special.'_id','');

	$current_page = $list->Page; // $this->Application->RecallVar($prefix_special.'_Page');

	$block_params = $this->prepareTagParams($params);

	$split = ( isset($params['split'] ) ? $params['split'] : 10 );

	$split_start = $current_page - ceil($split/2);
	if ($split_start < 1){
	$split_start = 1;
	}
	$split_end = $split_start + $split-1;

	if ($split_end > $total_pages) {
	$split_end = $total_pages;
	$split_start = max($split_end - $split + 1, 1);
	}

	if ($current_page > 1){
	$prev_block_params = $this->prepareTagParams();

	if ($total_pages > $split){
	$prev_block_params['page'] = max($current_page-$split, 1);
	$prev_block_params['name'] = $this->SelectParam($params, 'prev_page_split_render_as,prev_page_split_block');
	if ($prev_block_params['name']){
	$o .= $this->Application->ParseBlock($prev_block_params, 1);
	}
	}

	$prev_block_params['name'] = 'page';
	$prev_block_params['page'] = $current_page-1;
	$prev_block_params['name'] = $this->SelectParam($params, 'prev_page_render_as,block_prev_page,prev_page_block');
	if ($prev_block_params['name']) {
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $current_page-1);
	$o .= $this->Application->ParseBlock($prev_block_params, 1);
	}
	}
	else {
	if ( $no_prev_page_block = $this->SelectParam($params, 'no_prev_page_render_as,block_no_prev_page') ) {
	$block_params['name'] = $no_prev_page_block;
	$o .= $this->Application->ParseBlock($block_params, 1);
	}
	}

	$separator_params['name'] = $this->SelectParam($params, 'separator_render_as,block_separator');
	for ($i = $split_start; $i <= $split_end; $i++)
	{
	if ($i == $current_page) {
	$block = $this->SelectParam($params, 'current_render_as,active_render_as,block_current,active_block');
	}
	else {
	$block = $this->SelectParam($params, 'link_render_as,inactive_render_as,block_link,inactive_block');
	}

	$block_params['name'] = $block;
	$block_params['page'] = $i;
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $i);
	$o .= $this->Application->ParseBlock($block_params, 1);

	if ($this->SelectParam($params, 'separator_render_as,block_separator')
	&& $i < $split_end)
	{
	$o .= $this->Application->ParseBlock($separator_params, 1);
	}
	}

	if ($current_page < $total_pages){
	$next_block_params = $this->prepareTagParams();
	$next_block_params['page']=$current_page+1;
	$next_block_params['name'] = $this->SelectParam($params, 'next_page_render_as,block_next_page,next_page_block');
	if ($next_block_params['name']){
	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $current_page+1);
	$o .= $this->Application->ParseBlock($next_block_params, 1);
	}
	if ($total_pages > $split){
	$next_block_params['page']=min($current_page+$split, $total_pages);
	$next_block_params['name'] = $this->SelectParam($params, 'next_page_split_render_as,next_page_split_block');
	if ($next_block_params['name']){
	$o .= $this->Application->ParseBlock($next_block_params, 1);
	}
	}
	}

	$this->Application->SetVar($this->getPrefixSpecial().'_Page', $current_page);
	return $o;
	}

	/**
	* Print grid pagination using
	* block names specified
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function PaginationBar($params)
	{
	return $this->PrintPages($params);
	}


	/**
	* Returns field name (processed by kMultiLanguage formatter
	* if required) and item's id from it's IDField or field required
	*
	* @param Array $params
	* @return Array (id,field)
	* @access private
	*/
	function prepareInputName($params)
	{
	$field = $this->SelectParam($params, 'name,field');
	$object =& $this->getObject($params);

	$formatter_class = getArrayValue($object->Fields, $field, 'formatter');
	if ($formatter_class == 'kMultiLanguage')
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$field = $formatter->LangFieldName($field);
	}

	$id_field = getArrayValue($params, 'IdField');
	$id = $id_field ? $object->GetDBField($id_field) : $object->GetID();

	return Array($id, $field);
	}


	/**
	* Returns input field name to
	* be placed on form (for correct
	* event processing)
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function InputName($params)
	{
	list($id, $field) = $this->prepareInputName($params);

	$ret = $this->getPrefixSpecial().'['.$id.']['.$field.']';
	if( getArrayValue($params, 'as_preg') ) $ret = preg_quote($ret, '/');
	return $ret;
	}

	/**
	* Allows to override various field options through hidden fields with specific names in submit.
	* This tag generates this special names
	*
	* @param Array $params
	* @return string
	* @author Alex
	*/
	function FieldModifier($params)
	{
	list($id, $field) = $this->prepareInputName($params);

	$ret = 'field_modifiers['.$this->getPrefixSpecial().']['.$field.']['.$params['type'].']';
	if( getArrayValue($params, 'as_preg') ) $ret = preg_quote($ret, '/');
	return $ret;
	}

	/**
	* Returns index where 1st changable sorting field begins
	*
	* @return int
	* @access private
	*/
	function getUserSortIndex()
	{
	$list_sortings = $this->Application->getUnitOption($this->Prefix, 'ListSortings');
	$sorting_prefix = getArrayValue($list_sortings, $this->Special) ? $this->Special : '';

	$user_sorting_start = 0;
	if ( $forced_sorting = getArrayValue($list_sortings, $sorting_prefix, 'ForcedSorting') ) {
	$user_sorting_start = count($forced_sorting);
	}
	return $user_sorting_start;
	}

	/**
	* Returns order direction for given field
	*
	*
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function Order($params)
	{
	$field = $params['field'];
	$user_sorting_start = $this->getUserSortIndex();

	$list =& $this->GetList($params);

	if ($list->GetOrderField($user_sorting_start) == $field)
	{
	return strtolower($list->GetOrderDirection($user_sorting_start));
	}
	elseif($list->GetOrderField($user_sorting_start+1) == $field)
	{
	return '2_'.strtolower($list->GetOrderDirection($user_sorting_start+1));
	}
	else
	{
	return 'no';
	}
	}

	/**
	* Get's information of sorting field at "pos" position,
	* like sorting field name (type="field") or sorting direction (type="direction")
	*
	* @param Array $params
	* @return mixed
	*/
	function OrderInfo($params)
	{
	$user_sorting_start = $this->getUserSortIndex() + --$params['pos'];
	$list =& $this->GetList($params);
	// $object =& $this->Application->recallObject( $this->getPrefixSpecial() );

	if($params['type'] == 'field') return $list->GetOrderField($user_sorting_start);
	if($params['type'] == 'direction') return $list->GetOrderDirection($user_sorting_start);
	}

	/**
	* Checks if sorting field/direction matches passed field/direction parameter
	*
	* @param Array $params
	* @return bool
	*/
	function IsOrder($params)
	{
	$params['type'] = isset($params['field']) ? 'field' : 'direction';
	$value = $this->OrderInfo($params);

	if( isset($params['field']) ) return $params['field'] == $value;
	if( isset($params['direction']) ) return $params['direction'] == $value;
	}

	/**
	* Returns list perpage
	*
	* @param Array $params
	* @return int
	*/
	function PerPage($params)
	{
	$object =& $this->getObject($params);
	return $object->PerPage;
	}

	/**
	* Checks if list perpage matches value specified
	*
	* @param Array $params
	* @return bool
	*/
	function PerPageEquals($params)
	{
	$object =& $this->getObject($params);
	return $object->PerPage == $params['value'];
	}

	function SaveEvent($params)
	{
	// SaveEvent is set during OnItemBuild, but we may need it before any other tag calls OnItemBuild
	$object =& $this->getObject($params);
	return $this->Application->GetVar($this->getPrefixSpecial().'_SaveEvent');
	}

	function NextId($params)
	{
	$object =& $this->getObject($params);

	$wid = $this->Application->GetTopmostWid($this->Prefix);
	$session_name = rtrim($this->getPrefixSpecial().'_selected_ids_'.$wid, '_');
	$ids = explode(',', $this->Application->RecallVar($session_name));

	$cur_id = $object->GetID();

	$i = array_search($cur_id, $ids);
	if ($i !== false) {
	return $i < count($ids) - 1 ? $ids[$i + 1] : '';
	}
	return '';
	}

	function PrevId($params)
	{
	$object =& $this->getObject($params);

	$wid = $this->Application->GetTopmostWid($this->Prefix);
	$session_name = rtrim($this->getPrefixSpecial().'_selected_ids_'.$wid, '_');
	$ids = explode(',', $this->Application->RecallVar($session_name));

	$cur_id = $object->GetID();

	$i = array_search($cur_id, $ids);
	if ($i !== false) {
	return $i > 0 ? $ids[$i - 1] : '';
	}
	return '';
	}

	function IsSingle($params)
	{
	return ($this->NextId($params) === '' && $this->PrevId($params) === '');
	}

	function IsLast($params)
	{
	return ($this->NextId($params) === '');
	}

	function IsFirst($params)
	{
	return ($this->PrevId($params) === '');
	}

	/**
	* Checks if field value is equal to proposed one
	*
	* @param Array $params
	* @return bool
	*/
	function FieldEquals($params)
	{
	$object =& $this->getObject($params);
	$ret = $object->GetDBField($this->SelectParam($params, 'name,field')) == $params['value'];
	// if( getArrayValue($params,'inverse') ) $ret = !$ret;
	return $ret;
	}

	function ItemIcon($params)
	{
	$object =& $this->getObject($params);

	$grids = $this->Application->getUnitOption($this->Prefix,'Grids');
	$icons =& $grids[ $params['grid'] ]['Icons'];

	$key = '';
	$status_fields = $this->Application->getUnitOption($this->Prefix,'StatusField');
	if(!$status_fields) return $icons['default'];

	foreach($status_fields as $status_field)
	{
	$key .= $object->GetDBField($status_field).'_';
	}
	$key = rtrim($key,'_');
	$value = ($key !== false) ? $key : 'default';

	return isset($icons[$value]) ? $icons[$value] : $icons['default'];
	}

	/**
	* Generates bluebar title + initializes prefixes used on page
	*
	* @param Array $params
	* @return string
	*/
	function SectionTitle($params)
	{
	$preset_name = replaceModuleSection($params['title_preset']);
	$title_presets = $this->Application->getUnitOption($this->Prefix,'TitlePresets');
	$title_info = getArrayValue($title_presets, $preset_name);
	if($title_info === false) return str_replace('#preset_name#', $preset_name, $params['title']);

	if( getArrayValue($title_presets,'default') )
	{
	// use default labels + custom labels specified in preset used
	$title_info = array_merge_recursive2($title_presets['default'], $title_info);
	}

	$title = $title_info['format'];

	// 1. get objects in use for title construction
	$objects = Array();
	$object_status = Array();
	$status_labels = Array();

	$prefixes = getArrayValue($title_info,'prefixes');
	$all_tag_params = getArrayValue($title_info,'tag_params');
	if($prefixes)
	{
	// extract tag_perams passed directly to SectionTitle tag for specific prefix
	foreach ($params as $tp_name => $tp_value) {
	if (preg_match('/(.)\[(.)\]/', $tp_name, $regs)) {
	$all_tag_params[ $regs[1] ][ $regs[2] ] = $tp_value;
	unset($params[$tp_name]);
	}
	}

	$tag_params = Array();
	foreach($prefixes as $prefix_special)
	{
	$prefix_data = $this->Application->processPrefix($prefix_special);
	$prefix_data['prefix_special'] = rtrim($prefix_data['prefix_special'],'.');

	if($all_tag_params)
	{
	$tag_params = getArrayValue($all_tag_params, $prefix_data['prefix_special']);
	if(!$tag_params) $tag_params = Array();
	}

	$tag_params = array_merge_recursive2($params, $tag_params);
	$objects[ $prefix_data['prefix_special'] ] =& $this->Application->recallObject($prefix_data['prefix_special'], $prefix_data['prefix'], $tag_params);
	$object_status[ $prefix_data['prefix_special'] ] = $objects[ $prefix_data['prefix_special'] ]->IsNewItem() ? 'new' : 'edit';

	// a. set object's status field (adding item/editing item) for each object in title
	if( getArrayValue($title_info[ $object_status[ $prefix_data['prefix_special'] ].'_status_labels' ],$prefix_data['prefix_special']) )
	{
	$status_labels[ $prefix_data['prefix_special'] ] = $title_info[ $object_status[ $prefix_data['prefix_special'] ].'_status_labels' ][ $prefix_data['prefix_special'] ];
	$title = str_replace('#'.$prefix_data['prefix_special'].'_status#', $status_labels[ $prefix_data['prefix_special'] ], $title);
	}

	// b. setting object's titlefield value (in titlebar ONLY) to default in case if object beeing created with no titlefield filled in
	if( $object_status[ $prefix_data['prefix_special'] ] == 'new' )
	{
	$new_value = $this->getInfo( $objects[ $prefix_data['prefix_special'] ], 'titlefield' );
	if(!$new_value && getArrayValue($title_info['new_titlefield'],$prefix_data['prefix_special']) ) $new_value = $this->Application->Phrase($title_info['new_titlefield'][ $prefix_data['prefix_special'] ]);
	$title = str_replace('#'.$prefix_data['prefix_special'].'_titlefield#', $new_value, $title);
	}
	}
	}

	// 2. replace phrases if any found in format string
	$title = $this->Application->ReplaceLanguageTags($title,false);

	// 3. find and replace any replacement vars
	preg_match_all('/#(._.)#/Uis',$title,$rets);
	if($rets[1])
	{
	$replacement_vars = array_keys( array_flip($rets[1]) );
	foreach($replacement_vars as $replacement_var)
	{
	$var_info = explode('_',$replacement_var,2);
	$object =& $objects[ $var_info[0] ];
	$new_value = $this->getInfo($object,$var_info[1]);
	$title = str_replace('#'.$replacement_var.'#', $new_value, $title);
	}
	}

	$cut_first = getArrayValue($params,'cut_first');
	if( $cut_first && strlen($title) > $cut_first && !preg_match('/<a href="(.)">(.)<\/a>/',$title) ) $title = substr($title, 0, $cut_first).' ...';

	return $title;
	}

	function getInfo(&$object, $info_type)
	{
	switch ($info_type)
	{
	case 'titlefield':
	$field = $this->Application->getUnitOption($object->Prefix,'TitleField');
	return $field !== false ? $object->GetField($field) : 'TitleField Missing';
	break;

	case 'recordcount':
	$of_phrase = $this->Application->Phrase('la_of');
	return $object->NoFilterCount != $object->RecordsCount ? $object->RecordsCount.' '.$of_phrase.' '.$object->NoFilterCount : $object->RecordsCount;
	break;

	default:
	return $object->GetField($info_type);
	break;
	}
	}

	function GridInfo($params) {
	$object =& $this->getObject($params);
	/* @var $object kDBList */
	switch ($params['type'])
	{
	case 'filtered':
	return $object->RecordsCount;
	case 'total':
	return $object->NoFilterCount;
	case 'from':
	return $object->Offset+1; //0-based
	case 'to':
	return min($object->Offset + $object->PerPage, $object->RecordsCount);
	}
	}

	/**
	* Parses block depending on its element type.
	* For radio and select elements values are taken from 'value_list_field' in key1=value1,key2=value2
	* format. key=value can be substituted by <SQL>SELECT f1 AS OptionName, f2 AS OptionValue... FROM <PREFIX>TableName </SQL>
	* where prefix is TABLE_PREFIX
	*
	* @param Array $params
	* @return string
	*/
	function ConfigFormElement($params)
	{
	$object =& $this->getObject($params);
	$field = $params['field'];

	$helper =& $this->Application->recallObject('InpCustomFieldsHelper');

	$element_type = $object->GetDBField($params['element_type_field']);

	if($element_type == 'label') $element_type = 'text';
	$params['name'] = $params['blocks_prefix'].$element_type;

	switch ($element_type) {
	case 'select':
	case 'radio':
	$field_options = $object->GetFieldOptions($field, 'options');
	$field_options['options'] = $helper->GetValuesHash( $object->GetDBField($params['value_list_field']) );
	$object->SetFieldOptions($field, $field_options);
	break;

	case 'text':
	case 'textarea':
	$params['field_params'] = $helper->ParseConfigSQL($object->GetDBField($params['value_list_field']));
	break;

	case 'password':
	case 'checkbox':
	default:
	break;
	}
	return $this->Application->ParseBlock($params, 1);
	}

	/**
	* Get's requested custom field value
	*
	* @param Array $params
	* @return string
	* @access public
	*/
	function CustomField($params)
	{
	$params['name'] = 'cust_'.$this->SelectParam($params, 'name,field');
	return $this->Field($params);
	}

	function CustomFieldLabel($params)
	{
	$object =& $this->getObject($params);

	$field = $this->SelectParam($params, 'name,field');

	$sql = 'SELECT FieldLabel
	FROM '.$this->Application->getUnitOption('cf', 'TableName').'
	WHERE FieldName = '.$this->Conn->qstr($field);
	return $this->Application->Phrase($this->Conn->GetOne($sql));
	}

	/**
	* transposes 1-dimensional array elements for vertical alignment according to given columns and per_page parameters
	*
	* @param array $arr
	* @param int $columns
	* @param int $per_page
	* @return array
	*/
	function LinearToVertical(&$arr, $columns, $per_page)
	{
	$rows = $columns;
	// in case if after applying per_page limit record count less then
	// can fill requrested column count, then fill as much as we can
	$cols = min(ceil($per_page / $columns), ceil(count($arr) / $columns));
	$imatrix = array();
	for ($row = 0; $row < $rows; $row++) {
	for ($col = 0; $col < $cols; $col++) {
	$source_index = $row * $cols + $col;
	if (!isset($arr[$source_index])) {
	// in case if source array element count is less then element count in one row
	continue;
	}
	$imatrix[$col * $rows + $row] = $arr[$source_index];
	}
	}

	ksort($imatrix);
	reset($imatrix);
	return $imatrix;
	}

	/**
	* If data was modfied & is in TempTables mode, then parse block with name passed;
	* remove modification mark if not in TempTables mode
	*
	* @param Array $params
	* @return string
	* @access public
	* @author Alexey
	*/
	function SaveWarning($params)
	{
	$main_prefix = getArrayValue($params, 'main_prefix');
	if ($main_prefix && $main_prefix != '$main_prefix') {
	$top_prefix = $main_prefix;
	}
	else {
	$top_prefix = $this->Application->GetTopmostPrefix($this->Prefix);
	}

	$temp_tables = substr($this->Application->GetVar($top_prefix.'_mode'), 0, 1) == 't';
	$modified = $this->Application->RecallVar($top_prefix.'_modified');

	if ($temp_tables && $modified) {
	$block_params = $this->prepareTagParams($params);
	$block_params['name'] = $this->SelectParam($params, 'render_as,name');
	$block_params['edit_mode'] = $temp_tables ? 1 : 0;
	return $this->Application->ParseBlock($block_params);
	}
	$this->Application->RemoveVar($top_prefix.'_modified');
	return '';
	}

	/**
	* Returns list record count queries (on all pages)
	*
	* @param Array $params
	* @return int
	*/
	function TotalRecords($params)
	{
	$list =& $this->GetList($params);
	if (!$list->Counted) $list->CountRecs();
	return $list->RecordsCount;
	}

	/**
	* Range filter field name
	*
	* @param Array $params
	* @return string
	*/
	function SearchInputName($params)
	{
	$field = $this->SelectParam($params, 'field,name');

	$ret = 'custom_filters['.$this->getPrefixSpecial().']['.$params['grid'].']['.$field.']['.$params['filter_type'].']';

	if (isset($params['type'])) {
	$ret .= '['.$params['type'].']';
	}

	return $ret;
	}

	/**
	* Return range filter field value
	*
	* @param Array $params
	* @return string
	*/
	function SearchField($params) // RangeValue
	{
	$field = $this->SelectParam($params, 'field,name');

	$view_name = $this->Application->RecallVar($this->getPrefixSpecial().'_current_view');
	$custom_filter = $this->Application->RecallPersistentVar($this->getPrefixSpecial().'_custom_filter.'.$view_name);
	$custom_filter = $custom_filter ? unserialize($custom_filter) : Array();

	if (isset($custom_filter[ $params['grid'] ][$field])) {
	$ret = $custom_filter[ $params['grid'] ][$field][ $params['filter_type'] ]['submit_value'];
	if (isset($params['type'])) {
	$ret = $ret[ $params['type'] ];
	}
	+
	+ if( !$this->HasParam($params, 'no_special') ) $ret = htmlspecialchars($ret);
	return $ret;
	}

	return '';
	}

	function SearchFormat($params)
	{
	$field = $params['field'];
	$object =& $this->GetList($params);

	$options = $object->GetFieldOptions($field);

	$format = $options[ $this->SelectParam($params, 'input_format') ? 'input_format' : 'format' ];

	$formatter_class = getArrayValue($options,'formatter');
	if($formatter_class)
	{
	$formatter =& $this->Application->recallObject($formatter_class);
	$human_format = getArrayValue($params,'human');
	$edit_size = getArrayValue($params,'edit_size');
	$sample = getArrayValue($params,'sample');
	if($sample)
	{
	return $formatter->GetSample($field, $options, $object);
	}
	elseif($human_format \|\| $edit_size)
	{
	$format = $formatter->HumanFormat($format);
	return $edit_size ? strlen($format) : $format;
	}
	}

	return $format;
	}

	/**
	* Returns error of range field
	*
	* @param unknown_type $params
	* @return unknown
	*/
	function SearchError($params)
	{
	$field = $this->SelectParam($params, 'field,name');

	$error_var_name = $this->getPrefixSpecial().'_'.$field.'_'.$params['type'].'_error';
	$error_msg = $this->Application->RecallVar($error_var_name);
	if($error_msg)
	{
	$this->Application->StoreVar($error_var_name, '');
	}

	$object =& $this->Application->recallObject($this->Prefix.'.'.$this->Special.'-item', null, Array('skip_autoload' => true));
	return $object->ErrorMsgs[$error_msg];
	}

	/**
	* Returns templates path for module, which is gathered from prefix module
	*
	* @param Array $params
	* @return string
	* @author Alex
	*/
	function ModulePath($params)
	{
	$force_module = getArrayValue($params, 'module');
	if ($force_module) {
	if ($force_module == '#session#') {
	$force_module = $this->Application->RecallVar('module');
	if (!$force_module) $force_module = 'core';
	}
	else {
	$force_module = strtolower($force_module);
	}

	if ($force_module == 'core') {
	$module_folder = 'core';
	}
	else {
	$module_folder = trim( $this->Application->findModule('Name', $force_module, 'Path'), '/');
	}
	}
	else {
	$module_folder = $this->Application->getUnitOption($this->Prefix, 'ModuleFolder');
	}
	return '../../'.$module_folder.'/admin_templates/';
	}

	/**
	* Returns object used in tag processor
	*
	* @access public
	* @return kDBBase
	*/
	function &getObject($params = Array())
	{
	$object =& $this->Application->recallObject($this->getPrefixSpecial(), $this->Prefix, $params);
	return $object;
	}

	/**
	* Checks if object propery value matches value passed
	*
	* @param Array $params
	* @return bool
	*/
	function PropertyEquals($params)
	{
	$object =& $this->getObject($params);
	$property_name = $this->SelectParam($params, 'name,var,property');
	return $object->$property_name == $params['value'];
	}

	/**
	* Group list records by header, saves internal order in group
	*
	* @param Array $records
	* @param string $heading_field
	*/
	function groupRecords(&$records, $heading_field)
	{
	$sorted = Array();
	$i = 0; $record_count = count($records);
	while ($i < $record_count) {
	$sorted[ $records[$i][$heading_field] ][] = $records[$i];
	$i++;
	}

	$records = Array();
	foreach ($sorted as $heading => $heading_records) {
	$records = array_merge_recursive($records, $heading_records);
	}
	}

	function DisplayOriginal($params)
	{
	return false;
	}

	function MultipleEditing($params)
	{
	$wid = $this->Application->GetTopmostWid($this->Prefix);
	$session_name = rtrim($this->getPrefixSpecial().'_selected_ids_'.$wid, '_');
	$selected_ids = explode(',', $this->Application->RecallVar($session_name));

	$ret = '';
	if ($selected_ids) {
	$selected_ids = explode(',', $selected_ids);
	$object =& $this->getObject( array_merge_recursive2($params, Array('skip_autoload' => true)) );
	$params['name'] = $params['render_as'];
	foreach ($selected_ids as $id) {
	$object->Load($id);
	$ret .= $this->Application->ParseBlock($params);
	}
	}

	return $ret;
	}

	function ExportStatus($params)
	{
	$export_object =& $this->Application->recallObject('CatItemExportHelper');

	$event = new kEvent($this->getPrefixSpecial().':OnDummy');

	$action_method = 'perform'.ucfirst($this->Special);
	$field_values = $export_object->$action_method($event);

	// finish code is done from JS now
	if ($field_values['start_from'] >= $field_values['total_records'])
	{
	if ($this->Special == 'import') {
	$this->Application->StoreVar('PermCache_UpdateRequired', 1);
	$this->Application->Redirect('categories/cache_updater', Array('m_opener' => 'r', 'pass' => 'm', 'continue' => 1, 'no_amp' => 1));
	}
	elseif ($this->Special == 'export') {
	$finish_t = $this->Application->RecallVar('export_finish_t');
	$this->Application->Redirect($finish_t, Array('pass' => 'all'));
	$this->Application->RemoveVar('export_finish_t');
	}
	}

	$export_options = $export_object->loadOptions($event);
	return $export_options['start_from'] * 100 / $export_options['total_records'];
	}

	/**
	* Returns path where exported category items should be saved
	*
	* @param Array $params
	*/
	function ExportPath($params)
	{
	$ret = EXPORT_PATH.'/';

	if( getArrayValue($params, 'as_url') )
	{
	$ret = str_replace( FULL_PATH.'/', $this->Application->BaseURL(), $ret);
	}

	$export_options = unserialize($this->Application->RecallVar($this->getPrefixSpecial().'_options'));
	$ret .= $export_options['ExportFilename'].'.'.($export_options['ExportFormat'] == 1 ? 'csv' : 'xml');

	return $ret;
	}

	function FieldTotal($params)
	{
	$list =& $this->GetList($params);

	return $list->GetFormattedTotal($this->SelectParam($params, 'field,name'), $params['function']);
	}


	function FCKEditor($params) {
	$params['no_special'] = 1;
	$value = $this->Field($params);
	$name = $this->InputName($params);

	include_once(FULL_PATH.'/core/cmseditor/fckeditor.php');
	$oFCKeditor = new FCKeditor($name);
	$oFCKeditor->BasePath = BASE_PATH.'/core/cmseditor/';
	$oFCKeditor->Width = $params['width'] ;
	$oFCKeditor->Height = $params['height'] ;
	$oFCKeditor->ToolbarSet = 'Advanced' ;
	$oFCKeditor->Value = $value ;
	$oFCKeditor->Config = Array(
	//'UserFilesPath' => $pathtoroot.'kernel/user_files',
	'ProjectPath' => BASE_PATH.'/',
	'CustomConfigurationsPath' => $this->Application->BaseURL().'core/admin_templates/js/inp_fckconfig.js',
	// 'EditorAreaCSS' => $this->Application->BaseURL().'/themes/inportal_site/inc/inportal.css', //GetThemeCSS(),
	'StylesXmlPath' => $this->Application->BaseURL().'core/admin_templates/js/inp_styles.xml',
	// 'Debug' => 1,
	'Admin' => 1,
	'K4' => 1,
	);
	return $oFCKeditor->CreateHtml();
	}

	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.68.4/core/kernel/db/db_tag_processor.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.68.4.17
	\ No newline at end of property
	+1.68.4.18
	\ No newline at end of property
	Index: branches/unlabeled/unlabeled-1.4.2/core/units/general/helpers/search_helper.php
	===================================================================
	--- branches/unlabeled/unlabeled-1.4.2/core/units/general/helpers/search_helper.php (revision 7090)
	+++ branches/unlabeled/unlabeled-1.4.2/core/units/general/helpers/search_helper.php (revision 7091)
	@@ -1,517 +1,518 @@
	<?php

	class kSearchHelper extends kHelper {


	/**
	* Splits search phrase into keyword using quotes,plus and minus sings and spaces as split criteria
	*
	* @param string $keyword
	* @return string
	*/
	function splitKeyword($keyword)
	{
	$quotes_re = '/([+\-]?)"(.*?)"/';
	$no_quotes_re = '/([+\-]?)([^ ]+)/';

	$quoted_kw = preg_match_all($quotes_re, $keyword, $res);
	foreach ($res[2] as $index => $kw) $final[$kw] = $res[1][$index];
	$keyword = preg_replace($quotes_re, '', $keyword);
	$not_quoted_kw = preg_match_all($no_quotes_re, $keyword, $res);
	foreach ($res[2] as $index => $kw) $final[$kw] = $res[1][$index];

	return $final;
	}

	function getPositiveKeywords($keyword)
	{
	$keywords = $this->splitKeyword($keyword);

	$ret = Array();
	foreach ($keywords as $keyword => $sign) {
	if ($sign == '+' \|\| $sign == '') {
	$ret[] = $keyword;
	}
	}
	return $ret;
	}

	function buildWhereClause($keyword, $fields)
	{
	$keywords = $this->splitKeyword($keyword);

	$normal_conditions = Array();
	$plus_conditions = Array();
	$minus_conditions = Array();

	foreach ($keywords as $keyword => $sign) {
	switch ($sign) {
	case '+':
	$plus_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $fields).' LIKE "%'.$keyword.'%"';
	break;

	case '-':
	foreach ($fields as $field) {
	$condition[] = $field.' NOT LIKE "%'.$keyword.'%" OR '.$field.' IS NULL';
	}
	$minus_conditions[] = '('.implode(') AND (', $condition).')';
	break;

	case '':
	+ $keyword = str_replace('"', '\"', $keyword);
	$normal_conditions[] = implode(' LIKE "%'.$keyword.'%" OR ', $fields).' LIKE "%'.$keyword.'%"';
	break;
	}
	}

	// building where clause
	if ($normal_conditions) {
	$where_clause = '('.implode(') OR (', $normal_conditions).')';
	}
	else {
	$where_clause = '1';
	}

	if ($plus_conditions) {
	$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $plus_conditions).')';
	}

	if ($minus_conditions) {
	$where_clause = '('.$where_clause.') AND ('.implode(') AND (', $minus_conditions).')';
	}

	return $where_clause;
	}

	/**
	* Returns additional information about search field
	*
	* @param kDBList $object
	* @param string $field_name
	* @return Array
	*/
	function getFieldInformation(&$object, $field_name)
	{
	$sql_filter_type = isset($object->VirtualFields[$field_name]) ? 'having' : 'where';
	$field_type = isset($object->Fields[$field_name]['type']) ? $object->Fields[$field_name]['type'] : 'string';

	if (preg_match('/(.)\.(.)/', $field_name, $regs)) {
	$table_name = '`'.$regs[1].'`.'; // field from external table
	$field_name = $regs[2];
	}
	elseif ($sql_filter_type == 'where') {
	$table_name = '`'.$object->TableName.'`.'; // field from local table
	}

	$table_name = ($sql_filter_type == 'where') ? $table_name : '';

	// replace wid inside table name to WID_MARK constant value
	$is_temp_table = preg_match('/(.)'.TABLE_PREFIX.'ses_'.$this->Application->GetSID().'(_[\d]+){0,1}_edit_(.)/', $table_name, $regs);
	if ($is_temp_table) {
	$table_name = $regs[1].TABLE_PREFIX.'ses_'.EDIT_MARK.'_edit_'.$regs[3]; // edit_mark will be replaced with sid[_main_wid] in AddFilters
	}

	return Array ('field_name' => $field_name, 'field_type' => $field_type, 'table_name' => $table_name, 'sql_filter_type' => $sql_filter_type);
	}

	/**
	* Enter description here...
	*
	* @param kEvent $event
	*/
	function performSearch(&$event)
	{
	$object =& $event->getObject();

	// process search keyword
	$search_keyword = $this->Application->GetVar( $event->getPrefixSpecial(true).'_search_keyword');
	$this->Application->StoreVar( $event->getPrefixSpecial().'_search_keyword', $search_keyword);
	$search_keyword = str_replace('*', '%', $search_keyword);

	$custom_filter = $this->processCustomFilters($event);

	if(!$search_keyword && $custom_filter === false) {
	$this->resetSearch($event);
	return true;
	}

	if ($search_keyword) {
	$this->processAutomaticFilters($event, $search_keyword, $custom_filter);
	}
	}


	function processAutomaticFilters(&$event, $search_keyword, $custom_filter)
	{
	$grid_name = $this->Application->GetVar('grid_name');
	$grids = $this->Application->getUnitOption($event->Prefix, 'Grids');
	$search_fields = array_keys($grids[$grid_name]['Fields']);

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

	foreach ($search_fields as $search_field) {
	$custom_search = isset($custom_filter[$search_field]);

	$filter_data = $this->getSearchClause($object, $search_field, $search_keyword, $custom_search);

	if ($filter_data) {
	$search_filter[$search_field] = $filter_data;
	}
	else {
	unset($search_filter[$search_field]);
	}
	}
	$this->Application->StoreVar($event->getPrefixSpecial().'_search_filter', serialize($search_filter) );
	}

	/**
	* Returns search clause for any particular field
	*
	* @param kDBList $object
	* @param string $search_field
	* @param string $search_keyword what we are searching (false, when building custom filter clause)
	* @param string $custom_search already found using custom filter
	* @return Array
	*/
	function getSearchClause(&$object, $field_name, $search_keyword, $custom_search)
	{
	$search_keywords = $this->splitKeyword($search_keyword);

	extract( $this->getFieldInformation($object, $field_name) ); // see getFieldInformation for more details

	$filter_value = '';

	// get field clause by formatter name and/or parameters
	$formatter = getArrayValue($object->Fields[$field_name], 'formatter');
	switch ($formatter) {
	case 'kOptionsFormatter':
	$search_keys = Array();

	if ($custom_search === false) {
	// if keywords passed through simple search filter (on each grid)
	$use_phrases = getArrayValue($object->Fields[$field_name], 'use_phrases');
	$field_options = $object->GetFieldOptions($field_name);
	foreach ($field_options['options'] as $key => $val) {
	foreach ($search_keywords as $keyword => $sign) {
	$pattern = '#'.$keyword.'#i';
	if (!preg_match($pattern, $use_phrases ? $this->Application->Phrase($val) : $val)) {
	if ($sign == '+') {
	$filter_value = $table_name.'`'.$field_name.'` = NULL';
	break;
	}
	else {
	continue;
	}
	}

	if ($sign == '+' \|\| $sign == '') {
	$search_keys[$key] = $this->Conn->qstr($key);
	}
	elseif($sign == '-') {
	// if same value if found as exclusive too, then remove from search result
	unset($search_keys[$key]);
	}
	}
	}
	}

	if ($search_keys) {
	$filter_value = $table_name.'`'.$field_name.'` IN ('.implode(',', $search_keys).')';
	}

	$field_processed = true;
	break;

	case 'kDateFormatter':
	// if date is searched using direct filter, then do nothing here, otherwise search using LIKE clause
	$field_processed = ($custom_search !== false) ? true : false;
	break;

	default:
	$field_processed = false;
	break;
	}

	// if not already processed by formatter, then get clause by field type
	if (!$field_processed && $search_keywords) {
	switch($field_type)
	{
	case 'int':
	case 'integer':
	case 'numeric':
	$search_keys = Array();
	foreach ($search_keywords as $keyword => $sign) {
	if (!is_numeric($keyword) \|\| ($sign == '-')) continue;
	$search_keys[] = $this->Conn->qstr($keyword);
	}

	if ($search_keys) {
	$filter_value = $table_name.'`'.$field_name.'` IN ('.implode(',', $search_keys).')';
	}
	break;

	case 'double':
	case 'float':
	case 'real':
	$search_keys = Array();
	foreach ($search_keywords as $keyword => $sign) {
	$keyword = str_replace(',', '.', $keyword);
	if (!is_numeric($keyword) \|\| ($sign == '-')) continue;
	$search_keys[] = 'ABS('.$table_name.'`'.$field_name.'` - '.$this->Conn->qstr($keyword).') <= 0.0001';
	}

	if ($search_keys) {
	$filter_value = '('.implode(') OR (', $search_keys).')';
	}
	break;

	case 'string':
	$filter_value = $this->buildWhereClause($search_keyword, Array($table_name.'`'.$field_name.'`'));
	break;
	}
	}

	if ($filter_value) {
	return Array('type' => $sql_filter_type, 'value' => $filter_value);
	}

	return false;
	}

	/**
	* Processes custom filters from submit
	*
	* @param KEvent $event
	* @return bool
	*/
	function processCustomFilters(&$event)
	{
	$grid_name = $this->Application->GetVar('grid_name');

	// update "custom filter" with values from submit: begin
	$view_name = $this->Application->RecallVar($event->getPrefixSpecial().'_current_view');
	$custom_filters = $this->Application->RecallPersistentVar($event->getPrefixSpecial().'_custom_filter.'.$view_name);
	if ($custom_filters) {
	$custom_filters = unserialize($custom_filters);
	$custom_filter = isset($custom_filters[$grid_name]) ? $custom_filters[$grid_name] : Array ();
	}
	else {
	$custom_filter = Array ();
	}

	// submit format custom_filters[prefix_special][field]
	$submit_filters = $this->Application->GetVar('custom_filters');
	if ($submit_filters) {
	$submit_filters = getArrayValue($submit_filters, $event->getPrefixSpecial(), $grid_name);
	if ($submit_filters) {
	foreach ($submit_filters as $field_name => $field_options) {
	list ($filter_type, $field_value) = each($field_options);
	$is_empty = strlen(is_array($field_value) ? implode('', $field_value) : $field_value) == 0;
	if ($is_empty) {
	if (isset($custom_filter[$field_name])) {
	// use isset, because non-existing key will cause "php notice"!
	unset($custom_filter[$field_name][$filter_type]); // remove filter

	if (!$custom_filter[$field_name]) {
	// if no filters left for field, then delete record at all
	unset($custom_filter[$field_name]);
	}
	}
	}
	else {
	$custom_filter[$field_name][$filter_type]['submit_value'] = $field_value;
	}
	}
	}
	}

	if ($custom_filter) {
	$custom_filters[$grid_name] = $custom_filter;
	}
	else {
	unset($custom_filters[$grid_name]);
	}
	// update "custom filter" with values from submit: end

	if (!$custom_filter) {
	// in case when no filters specified, there are nothing to process
	$this->Application->StorePersistentVar($event->getPrefixSpecial().'_custom_filter.'.$view_name, serialize($custom_filters) );
	return false;
	}

	$object =& $event->getObject(); // don't recall it each time in getCustomFilterSearchClause
	$grid_info = $this->Application->getUnitOption($event->Prefix.'.'.$grid_name, 'Grids');
	foreach ($custom_filter as $field_name => $field_options) {
	list ($filter_type, $field_options) = each($field_options);
	$field_options['grid_options'] = $grid_info['Fields'][$field_name];
	$field_options = $this->getCustomFilterSearchClause($object, $field_name, $filter_type, $field_options);
	if ($field_options['value']) {
	unset($field_options['grid_options']);
	$custom_filter[$field_name][$filter_type] = $field_options;
	}
	}

	$custom_filters[$grid_name] = $custom_filter;
	$this->Application->StorePersistentVar($event->getPrefixSpecial().'_custom_filter.'.$view_name, serialize($custom_filters) );
	return $custom_filter;
	}

	/**
	* Return numeric range filter value + checking that it's number
	*
	* @param Array $value array containing range filter value
	* @return unknown
	*/
	function getRangeValue($value)
	{
	return strlen($value) && is_numeric($value) ? $this->Conn->qstr($value) : false;
	}

	function getCustomFilterSearchClause(&$object, $field_name, $filter_type, $field_options)
	{
	if ($filter_type == 'date_range') {
	// use timestamp field, not formatted one
	$field_name = $field_options['grid_options']['sort_field'];
	}

	extract( $this->getFieldInformation($object, $field_name) ); // see getFieldInformation for more details

	$filter_value = '';

	switch ($filter_type) {
	case 'range':
	$from = $this->getRangeValue($field_options['submit_value']['from']);
	$to = $this->getRangeValue($field_options['submit_value']['to']);

	if ($from !== false && $to !== false) {
	// add range filter
	$filter_value = $table_name.'`'.$field_name.'` >= '.$from.' AND '.$table_name.'`'.$field_name.'` <= '.$to;
	}
	elseif ($from !== false) {
	// add equals filter on $from
	$filter_value = $table_name.'`'.$field_name.'` = '.$from;
	}
	elseif ($to !== false) {
	// add equals filter on $to
	$filter_value = $table_name.'`'.$field_name.'` = '.$to;
	}
	break;

	case 'float_range':
	// MySQL can't compare values in "float" type columns using "=" operator
	$from = $this->getRangeValue($field_options['submit_value']['from']);
	$to = $this->getRangeValue($field_options['submit_value']['to']);

	if ($from !== false && $to !== false) {
	// add range filter
	$filter_value = $table_name.'`'.$field_name.'` >= '.$from.' AND '.$table_name.'`'.$field_name.'` <= '.$to;
	}
	elseif ($from !== false) {
	// add equals filter on $from
	$filter_value = 'ABS('.$table_name.'`'.$field_name.'` - '.$from.') <= 0.0001';
	}
	elseif ($to !== false) {
	// add equals filter on $to
	$filter_value = 'ABS('.$table_name.'`'.$field_name.'` - '.$to.') <= 0.0001';
	}
	break;

	case 'date_range':
	$from = $this->processRangeField($object, $field_name, $field_options['submit_value'], 'from');
	$to = $this->processRangeField($object, $field_name, $field_options['submit_value'], 'to');

	$day_seconds = 23 * 60 * 60 + 59 * 60 + 59;
	if ($from !== false && $to === false) {
	$from = strtotime(date('Y-m-d', $from).' 00:00:00', $from); // reset to morning
	$to = $from + $day_seconds;
	}
	elseif ($from === false && $to !== false) {
	$to = strtotime(date('Y-m-d', $to).' 23:59:59', $to); // reset to evening
	$from = $to - $day_seconds;
	}

	if ($from !== false && $to !== false) {
	$filter_value = $table_name.'`'.$field_name.'` >= '.$from.' AND '.$table_name.'`'.$field_name.'` <= '.$to;
	}
	break;

	case 'equals':
	case 'options':
	$field_value = strlen($field_options['submit_value']) ? $this->Conn->qstr($field_options['submit_value']) : false;
	if ($field_value) {
	$filter_value = $table_name.'`'.$field_name.'` = '.$field_value;
	}
	break;

	case 'like':
	$filter_value = $this->buildWhereClause($field_options['submit_value'], Array($table_name.'`'.$field_name.'`'));
	break;

	default:
	break;
	}

	$field_options['sql_filter_type'] = $sql_filter_type;
	$field_options['value'] = $filter_value;

	return $field_options;
	}

	/**
	* Enter description here...
	*
	* @param kdbItem $object
	* @param string $search_field
	* @param string $value
	* @param string $type
	*/
	function processRangeField(&$object, $search_field, $value, $type)
	{
	- if (strlen($value[$type]) > 0) {
	+ if (!strlen($value[$type])) {
	return false;
	}

	$lang_current =& $this->Application->recallObject('lang.current');
	$options = $object->GetFieldOptions($search_field);
	$dt_separator = isset($options['date_time_separator']) ? $options['date_time_separator'] : ' ';

	$tmp_value = explode($dt_separator, $value[$type], 2);
	if (count($tmp_value) == 1) {
	// time is missing, then guess it and add to date
	$time = ($type == 'from') ? adodb_mktime(0, 0, 0) : adodb_mktime(23, 59, 59);
	$time = adodb_date($lang_current->GetDBField('InputTimeFormat'), $time);
	$value[$type] .= $dt_separator.$time;
	}

	$formatter =& $this->Application->recallObject($object->Fields[$search_field]['formatter']);

	$value_ts = $formatter->Parse($value[$type], $search_field, $object);
	$pseudo = getArrayValue($object->FieldErrors, $search_field, 'pseudo');
	if ($pseudo) {
	unset($object->FieldErrors[$search_field]); // remove error!
	// invalid format -> ignore this date in search
	return false;
	}
	return $value_ts;
	}

	/**
	* Resets current search
	*
	* @param kEvent $event
	*/
	function resetSearch(&$event)
	{
	$this->Application->RemoveVar($event->getPrefixSpecial().'_search_filter');
	$this->Application->RemoveVar($event->getPrefixSpecial().'_search_keyword');

	$view_name = $this->Application->RecallVar($event->getPrefixSpecial().'_current_view');
	$this->Application->RemovePersistentVar($event->getPrefixSpecial().'_custom_filter.'.$view_name);
	}




	}

	?>
	\ No newline at end of file

	Property changes on: branches/unlabeled/unlabeled-1.4.2/core/units/general/helpers/search_helper.php
	___________________________________________________________________
	Modified: cvs2svn:cvs-rev
	## -1 +1 ##
	-1.4.2.5
	\ No newline at end of property
	+1.4.2.6
	\ 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