<?php
/**
* modules tools Class for workflow
*
*  Contains all the functions to load modules tables for workflow
*
* @package  maarch
* @version 3.0
* @since 10/2005
* @license GPL v3
* @author  Laurent Giovannoni  <dev@maarch.org>
*
*/

class indexing_searching_app extends dbquery
{
	function __construct()
	{
		parent::__construct();
	}

	public function is_filetype_allowed($ext)
	{
		if(file_exists($_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml"))
		{
			$path = $_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		else
		{
			$path = 'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		$xmlconfig = simplexml_load_file($path);

		$ext_list = array();
		$i = 0;
		foreach($xmlconfig->FORMAT as $FORMAT)
		{
			$ext_list[$i] = array("name" => (string) $FORMAT->name, "mime" => (string) $FORMAT->mime);
			$i++;
		}

		$type_state = false;
		for($i=0;$i<count($ext_list);$i++)
		{
			if($ext_list[$i]['name'] == strtoupper($ext))
			{
				$mime_type = $ext_list[$i]['mime'];
				$type_state = true;
			//	$i = count($ext_list);
				break;
			}
		}
		return $type_state;
	}

	public function show_index_frame($ext)
	{
		if(empty($ext))
		{
			return false;
		}
		if(file_exists($_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml"))
		{
			$path = $_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		else
		{
			$path = 'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		$xmlconfig = simplexml_load_file($path);
		foreach($xmlconfig->FORMAT as $FORMAT)
		{
			if(strtoupper($ext) == (string) $FORMAT->name)
			{
				if( $FORMAT->index_frame_show == "true")
				{
					return true;
				}
				else
				{
					return false;
				}
			}
		}
		return false;
	}
	public function filetypes_showed_indexation()
	{
		if(file_exists($_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml"))
		{
			$path = $_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		else
		{
			$path = 'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		$xmlconfig = simplexml_load_file($path);
		$ext_list = array();
		foreach($xmlconfig->FORMAT as $FORMAT)
		{
			if((string) $FORMAT->index_frame_show == "true")
			{
				array_push($ext_list,(string) $FORMAT->name);
			}
		}

		return $ext_list;
	}

	public function get_mime_type($ext)
	{
		if(file_exists($_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml"))
		{
			$path = $_SESSION['config']['corepath'].'custom'.DIRECTORY_SEPARATOR.$_SESSION['custom_override_id'].DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		else
		{
			$path = 'apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."xml".DIRECTORY_SEPARATOR."extensions.xml";
		}
		$xmlconfig = simplexml_load_file($path);
		$ext_list = array();
		$i = 0;
		foreach($xmlconfig->FORMAT as $FORMAT)
		{
			$ext_list[$i] = array("name" => (string) $FORMAT->name, "mime" => (string) $FORMAT->mime);
			$i++;
		}
		for($i=0;$i<count($ext_list);$i++)
		{
			if($ext_list[$i]['name'] == strtoupper($ext))
			{
				$mime_type = $ext_list[$i]['mime'];
				$type_state = true;
				$i = count($ext_list);
				return $mime_type;
				break;
			}
		}
		return false;
	}


	public function update_mail($post, $typeform, $id_to_update, $coll_id)
	{
		require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php");
		require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php");
		require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
		$hist = new history();
		$func = new functions();
		$sec = new security();
		$data_res = array();
		$data_ext = array();
		$request = new request();
		$core = new core_tools();

		$table = $sec->retrieve_table_from_coll($coll_id);
		$view = $sec->retrieve_view_from_coll_id($coll_id);
		$ind_coll = $sec->get_ind_collection($coll_id);
		$table_ext = $_SESSION['collections'][$ind_coll]['extensions'][0];
		if(!$table)
		{
			$_SESSION['error'] .= _COLL_HAS_NO_TABLE;
		}
		if(!empty($_SESSION['error']))
		{
			//$_SESSION['error_page'] = $_SESSION['error'];
			$error = $_SESSION['error'];
			$_SESSION['error']= '';
			?>
			<script language="javascript" type="text/javascript">
               // window.opener.reload();
              	var error_div = $('main_error');
               	if(error_div)
               	{
				 	error_div.innerHTML = '<?php echo $error;?>';
				}
            </script>
			<?php
			exit();
		}
		$where = "res_id = ".$id_to_update;
		$request->connect();
		$request->query("select category_id from ".$view." where ".$where);
		$res = $request->fetch_object();
		$cat_id = $res->category_id;
		if(empty($cat_id) || !isset($cat_id))
		{
			$cat_id = 'empty';
		}
		// Simple cases
		foreach(array_keys($post) as $key)
		{
			if($_ENV['categories'][$cat_id][$key]['modify'] == true)
			{
				if($_ENV['categories'][$cat_id][$key]['mandatory'] == true  && $post[$key] == '' )
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id][$key]['label'].' '._IS_EMPTY.'<br/>';
				}
				if($_ENV['categories'][$cat_id][$key]['type_form'] == 'date' && !empty($post[$key]) && preg_match($_ENV['date_pattern'],$post[$key])== 0)
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id][$key]['label']." "._WRONG_FORMAT." <br/>";
				}
				else if($_ENV['categories'][$cat_id][$key]['type_field'] == 'date' && $_ENV['categories'][$cat_id][$key]['table'] <> 'none' && !empty($post[$key]))
				{
					if($_ENV['categories'][$cat_id][$key]['table'] == 'res')
					{
						array_push($data_res, array('column' => $key, 'value' => $func->format_date_db($post[$key]), 'type' => "date"));
					}
					else if($_ENV['categories'][$cat_id][$key]['table'] == 'coll_ext')
					{
						array_push($data_ext, array('column' => $key, 'value' => $func->format_date_db($post[$key]), 'type' => "date"));
					}
				}
				if($_ENV['categories'][$cat_id][$key]['type_form'] == 'integer'  && preg_match("/^[0-9]+$/",$post[$key])== 0)
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id][$key]['label']." "._WRONG_FORMAT." <br/>";
				}
				else if($_ENV['categories'][$cat_id][$key]['type_field'] == 'integer' && $_ENV['categories'][$cat_id][$key]['table'] <> 'none' && $post[$key] != '')
				{
					if($_ENV['categories'][$cat_id][$key]['table'] == 'res')
					{
						array_push($data_res, array('column' => $key, 'value' => $post[$key], 'type' => "integer"));
					}
					else if($_ENV['categories'][$cat_id][$key]['table'] == 'coll_ext')
					{
						array_push($data_ext, array('column' => $key, 'value' => $post[$key], 'type' => "integer"));
					}
				}
				if($_ENV['categories'][$cat_id][$key]['type_form'] == 'radio' && !empty($post[$key]) && !in_array($post[$key], $_ENV['categories'][$cat_id][$key]['values']))
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id][$key]['label']." "._WRONG_FORMAT." <br/>";
				}
				if($_ENV['categories'][$cat_id][$key]['type_field'] == 'string' && $_ENV['categories'][$cat_id][$key]['table'] <> 'none' && !empty($post[$key]))
				{
					if($_ENV['categories'][$cat_id][$key]['table'] == 'res')
					{
						array_push($data_res, array('column' => $key, 'value' => $func->protect_string_db($post[$key]), 'type' => "string"));
					}
					else if($_ENV['categories'][$cat_id][$key]['table'] == 'coll_ext')
					{
						array_push($data_ext, array('column' => $key, 'value' => $func->protect_string_db($post[$key]), 'type' => "string"));
					}
				}
			}
		}

		require_once('apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR.'class'.DIRECTORY_SEPARATOR.'class_types.php');
		$type = new types();
		
		$type_id =  $post['type_id'];
		$indexes = $type->get_indexes($type_id,$coll_id, 'minimal');
		$val_indexes = array();
		for($i=0; $i<count($indexes);$i++)
		{
			$val_indexes[$indexes[$i]] = $post[$indexes[$i]];
		}
		$test_type = $type->check_indexes($type_id, $coll_id,$val_indexes );
		if($test_type)
		{
			$data_res = $type->fill_data_array($type_id, $coll_id, $val_indexes, $data_res);
		}

		///////////////////////// Other cases
		if($core->is_module_loaded('folder'))
		{
			$request->connect();
			$request->query("select folders_system_id from ".$table." where res_id = ".$id_to_update);
			$res = $request->fetch_object();
			$old_folder_id = $res->folders_system_id;
			$market = '';
			if(isset($post['market']))
			{
				$market = $post['market'];
			}
			$project_id = '';
			$market_id = '';
			if(isset($_ENV['categories'][$cat_id]['other_cases']['market']) && $_ENV['categories'][$cat_id]['other_cases']['market']['mandatory'] == true )
			{
				if(empty($market) )
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id]['other_cases']['market']['label'].' '._IS_EMPTY.'<br/>';
				}
			}
			if(!empty($market) )
			{
				if(!preg_match('/\([0-9]+\)$/', $market))
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id]['other_cases']['market']['label']." "._WRONG_FORMAT." <br/>";
				}
				$market_id = str_replace(')', '', substr($market, strrpos($market,'(')+1));
				$request->query("select folders_system_id from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$market_id);
				if($request->nb_result() == 0)
				{
					$_SESSION['error'] .= _MARKET.' '.$market_id.' '._UNKNOWN.'<br/>';
				}
			}
			$project = '';
			if(isset($post['project']))
			{
				$project = $post['project'];
			}
			if(isset($_ENV['categories'][$cat_id]['other_cases']['project']) && $_ENV['categories'][$cat_id]['other_cases']['project']['mandatory'] == true)
			{
				if(empty($project))
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id]['other_cases']['project']['label'].' '._IS_EMPTY.'<br/>';
				}
			}
			if(!empty($project) )
			{
				if(!preg_match('/\([0-9]+\)$/', $project))
				{
					$_SESSION['error'] .= $_ENV['categories'][$cat_id]['other_cases']['project']['label']." "._WRONG_FORMAT." <br/>";
				}
				$project_id = str_replace(')', '', substr($project, strrpos($project,'(')+1));
				$request->query("select folders_system_id from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$project_id);
				if($request->nb_result() == 0)
				{
					$_SESSION['error'] .= _MARKET.' '.$project_id.' '._UNKNOWN.'<br/>';
				}
			}
			if(!empty($project_id) && !empty($market_id))
			{
				$request->query("select folders_system_id from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$market_id." and parent_id = ".$project_id);
				if($request->nb_result() == 0)
				{
					$_SESSION['error'] .= _INCOMPATIBILITY_MARKET_PROJECT.'<br/>';
				}
			}

			if(empty($_SESSION['error']))
			{
				$folder_id = '';
				if(!empty($market_id))
				{
					$folder_id = $market_id;
				}
				else if(!empty($project_id))
				{
					$folder_id = $project_id;
				}
				if(!empty($folder_id))
				{
					array_push($data_res, array('column' => 'folders_system_id', 'value' => $folder_id, 'type' => "integer"));
				}
				else
				{
					array_push($data_res, array('column' => 'folders_system_id', 'value' => 'NULL', 'type' => "integer"));
				}
				if($folder_id <> $old_folder_id && $_SESSION['history']['folderup'])
				{
					require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php");
					$hist = new history();
					$hist->add($_SESSION['tablename']['fold_folders'], $folder_id, "UP", _DOC_NUM.$id_to_update._ADDED_TO_FOLDER, $_SESSION['config']['databasetype'],'apps');
					if(isset($old_folder_id) && !empty($old_folder_id))
					{
						$hist->add($_SESSION['tablename']['fold_folders'], $old_folder_id, "UP", _DOC_NUM.$id_to_update._DELETED_FROM_FOLDER, $_SESSION['config']['databasetype'],'apps');
					}
				}
			}
		}

		if($core->is_module_loaded('physical_archive'))
		{
			// Arbox id
			$box_id = '';
			if(isset($post['arbox_id']))
			{
				$box_id = $post['arbox_id'];
			}

			if(isset($_ENV['categories'][$cat_id]['other_cases']['arbox_id']) && $_ENV['categories'][$cat_id]['other_cases']['arbox_id']['mandatory'] == true)
			{
				if($box_id == false)
				{
					$_SESSION['error'] .= _NO_BOX_SELECTED.' <br/>';
				}
			}
			if($box_id != false && preg_match('/^[0-9]+$/', $box_id))
			{
				require_once('modules'.DIRECTORY_SEPARATOR.'physical_archive'.DIRECTORY_SEPARATOR.'class'.DIRECTORY_SEPARATOR.'class_modules_tools.php');
				$physical_archive = new physical_archive();
				$pa_return_value = $physical_archive->load_box_db($box_id, $cat_id, $_SESSION['user']['UserId']);
				if ($pa_return_value == false)
				{
					$_SESSION['error'] .= _ERROR_TO_INDEX_NEW_BATCH_WITH_PHYSICAL_ARCHIVE.'<br/>';
				}
				else
				{
					array_push($data_res, array('column' => 'arbox_id', 'value' => $box_id, 'type' => "integer"));
					array_push($data_res, array('column' => 'arbatch_id', 'value' => $pa_return_value, 'type' => "integer"));
				}
			}
		}

		//$this->show_array($post);
		if(empty($_SESSION['error']))
		{
			$type->inits_opt_indexes($coll_id, $id_to_update);
			//$request->show_array($data_res);
			//exit();		
			$request->update($table, $data_res, $where, $_SESSION['config']['databasetype']);
			if(count($data_ext) > 0)
			{
				$request->update($table_ext, $data_ext, $where, $_SESSION['config']['databasetype']);
			}
			$_SESSION['error'] = _INDEX_UPDATED." (".strtolower(_NUM).$id_to_update.")";

			$hist->add($table, $id_to_update, "UP", $_SESSION['error'], $_SESSION['config']['databasetype'],'apps');
		}
		//$_SESSION['error_page'] = $_SESSION['error'];
		$error = $_SESSION['error'];
		$_SESSION['error']= '';
		?>
		<script language="javascript" type="text/javascript">
			//window.opener.reload();
			var error_div = $('main_error');
			if(error_div)
			{
				error_div.innerHTML = '<?php echo $error;?>';
			}
		</script>
		<?php
	}

	public function delete_doc( $id_to_delete, $coll_id)
	{
		require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
		$sec = new security();
		$table = $sec->retrieve_table_from_coll($coll_id);

		if(!$table)
		{
			$_SESSION['error'] .= _COLL_HAS_NO_TABLE;
		}
		if(!empty($_SESSION['error']))
		{
			//$_SESSION['error_page'] = $_SESSION['error'];
			?>
			<script language="javascript" type="text/javascript">
                window.opener.reload();
            </script>
			<?php
		}
		else
		{
			require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php");
			$request = new request();
			$data = array();
			array_push($data, array('column' => 'status', 'value' => 'DEL', 'type' => 'string'));
			$where = "res_id = ".$id_to_delete;
			$request->update($table, $data, $where, $_SESSION['config']['databasetype']);
			$_SESSION['error'] = _DOC_DELETED." ("._NUM." : ".$id_to_delete.")";
			if($_SESSION['history']['res_del'])
			{
				require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php");
				$hist = new history();
				$hist->add($table, $id_to_delete, "DEL", $_SESSION['error'], $_SESSION['config']['databasetype'],'indexing_searching');
			}
		}
	}
	
	public function update_doc_status($idDoc, $coll_id, $status)
	{
		require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
		$sec = new security();
		$table = $sec->retrieve_table_from_coll($coll_id);
		if(!$table)
		{
			$_SESSION['error'] .= _COLL_HAS_NO_TABLE;
		}
		if(!empty($_SESSION['error']))
		{
			?>
			<script language="javascript" type="text/javascript">
                window.opener.reload();
            </script>
			<?php
		}
		else
		{
			require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php");
			$request = new request();
			$data = array();
			array_push($data, array('column' => 'status', 'value' => $status, 'type' => 'string'));
			$where = "res_id = ".$idDoc;
			$request->update($table, $data, $where, $_SESSION['config']['databasetype']);
			$_SESSION['error'] = _UPDATE_DOC_STATUS." ("._NUM." : ".$idDoc.") "._TO." ".$status;
			require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php");
			$hist = new history();
			$hist->add($table, $idDoc, $status, $_SESSION['error'], $_SESSION['config']['databasetype'],'indexing_searching');
		}
	}

	public function send_criteria_data($param)
	{
		/*list_criteres = Array ("num_courrier" => Array (label => "reference courrier',
											 parametres => Array ( ...),
											 type => "text",
											 ),
					   "date courrier" => array*/
		//$this->show_array($param);
		$options_criteria_list = '<option id="default" value="">'._CHOOSE_PARAMETERS.'</option>';
		$json_tab = '';
		foreach($param as $key => $value)
		{
			$json_tab .= "'".$key."' : {";
			//echo 'key '.$key."<br/>val ";
			//$this->show_array($value);
			$options_criteria_list .= '<option id="option_'.$key.'" value="'.$value['label'].'"> '.$value['label'].'</option>';
			$json_tab .= $this->json_line($key,$value['type'],$value['param']);
			$json_tab .= '}
			,';
		}
		$json_tab = preg_replace("/,$/", '', $json_tab);

		$tab = array($options_criteria_list, $json_tab );

		return $tab;
	}

	private function json_line($id, $field_type, $param)
	{
		$str = '';
		$init = "'label' : '".addslashes($param['field_label'])."', 'value' :'";
		$end = "'";
		//$hidden = '<input type="hidden" name="meta[]" value="" />';
		if($field_type == 'input_text')
		{
			$str = $init.'<input type="hidden" name="meta[]" value="'.$id.'#'.$id.'#input_text" /><input name="'.$id.'"  id="'.$id.'" type="text" '.$param['other'].' value="" />'.$end;
		}
		/*elseif($field_type == 'contact')
		{
			$str = '<table align="center" border="0" width="100%" ><tr>';
			$str .='<td><input type="radio"  class="check" name="type_contact_'.$id.'" id="type_contact_internal_'.$id.'" value="internal" onchange="change_contact_type(\''.$_SESSION['config']['businessappurl'].'indexing_searching/autocomplete_contacts.php\');" />'._INTERNAL.'<input type="radio"  class="check" name="type_contact_'.$id.'" id="type_contact_external_'.$id.'" value="external" onchange="change_contact_type(\''.$_SESSION['config']['businessappurl'].'indexing_searching/autocomplete_contacts.php\');"/>'._EXTERNAL.'<br/></td></tr>';
			$str .='<tr><td><input type="text" name="contact" id="contact"  /><div id="show_contacts" class="autocomplete"></div></td>';
			$str .= '</tr></table>';
			$str = addslashes($str);
			$str = $init.$str.'<input type="hidden" name="meta[]" value="'.$id.'#'.$id.'#contact" />'.$end;
		}*/
		else if($field_type == 'textarea')
		{
			$str = $init.'<input type="hidden" name="meta[]" value="'.$id.'#'.$id.'#textarea" /><textarea name="'.$id.'"  id="'.$id.'" '.$param['other'].' rows="2" style="display:block;width:530px;"></textarea>'.$end;
		}
		elseif($field_type == 'date_range')
		{
			$str = $init.addslashes(_SINCE).' : <input type="text" name="'.$param['id1'].'" id="'.$param['id1'].'" value="" onclick="showCalender(this);" /> '
			.addslashes(_FOR).' : <input type="text" name="'.$param['id2'].'" id="'.$param['id2'].'" value=""  onclick="showCalender(this);" />';
			$str .= '<input type="hidden" name="meta[]" value="'.$id.'#'.$param['id1'].','.$param['id2'].'#date_range" />'.$end;
		}
		elseif($field_type == 'num_range')
		{
			$str = $init.addslashes(_NUM_BETWEEN).' : <input type="text" name="'.$param['id1'].'" id="'.$param['id1'].'" value=""/ > '
			.addslashes(_AND).' : <input type="text" name="'.$param['id2'].'" id="'.$param['id2'].'" value="" / >';
			$str .= '<input type="hidden" name="meta[]" value="'.$id.'#'.$param['id1'].','.$param['id2'].'#num_range" />'.$end;
		}
		elseif($field_type == 'select_simple')
		{
			$str = $init.'<select name="'.$id.'" id="'.$id.'">';
			if(isset($param['default_label']) && !empty($param['default_label']))
			{
				$str .='<option value="">'.$param['default_label'].'</option>';
			}
			for($i=0; $i<count($param['options']);$i++)
			{
				$str .= '<option value="'.addslashes($param['options'][$i]['VALUE']).'" alt="'.addslashes($param['options'][$i]['LABEL']).'" title="'.addslashes($param['options'][$i]['LABEL']).'">'.addslashes($param['options'][$i]['LABEL']).'</option>';
			}
			$str .= '</select>';
			$str .= '<input type="hidden" name="meta[]" value="'.$id.'#'.$id.'#select_simple" />'.$end;
		}
		elseif($field_type == 'select_multiple')
		{
			$str .= '<tr><td colspan="3">'.$param['label_title'].' :</td></tr>';
			$str .= '<tr>';
				$str .= '<td width="150" align="left">';
					$str .= '<select name="'.$param['id'].'_available[]" id="'.$param['id'].'_available" size="10" ondblclick="moveclick_ext('." '".$param['id']."_available', '".$param['id']."_chosen'".');" multiple="multiple" >';
						for($i=0; $i<count($param['options']);$i++)
						{
							$str .= '<option value="'.$param['options'][$i]['VALUE'].'"  alt="'.addslashes($param['options'][$i]['LABEL']).'" title="'.addslashes($param['options'][$i]['LABEL']).'">'.$param['options'][$i]['LABEL'].'</option>';
						}
					$str .='</select>';
					$str .= "<br/><em><a href=\"javascript:selectall_ext( '".$param['id']."_available');\" >"._SELECT_ALL.'</a></em>';
				$str .= '</td>';
			    $str .= '<td width="135" align="center">';
					$str .= '<input type="button" class="button" value="'._ADD.'" onclick="Move_ext('."'".$param['id']."_available', '".$param['id']."_chosen'".');" /><br />';
					$str .= '<br /><input type="button" class="button" value="'._REMOVE.'" onclick="Move_ext('." '".$param['id']."_chosen', '".$param['id']."_available'".');" />';
				$str .= '</td>';
				$str .= '<td width="150" align="left">';
							$str .= '<select name="'.$param['id'].'_chosen[]" id="'.$param['id'].'_chosen" size="10" ondblclick="moveclick_ext('." '".$param['id']."_chosen', '".$param['id']."_available'".');" multiple="multiple" " >';
							$str .= '</select>';
							$str .= "<br/><em><a href=\"javascript:selectall_ext( '".$param['id']."_chosen');\" >"._SELECT_ALL.'</a></em>';
				$str .= '</td>';
			$str .= '</tr>';
			$str = addslashes($str);
			$str = $init.'<table align="center" border="0" width="100%" >'.$str.'<input type="hidden" name="meta[]" value="'.$id.'#'.$param['id'].'_chosen#select_multiple" /></table>'.$end;
		}
		elseif($field_type == 'checkbox')
		{
			$str = $init.'<table align="center" border="0" width="100%" >';

			$tmp_ids = '';
			for($i=0; $i < count($param['checkbox_data']);$i=$i+2)
			{
				$tmp_ids .= $param['checkbox_data'][$i]['ID'].',';
				$str .= '<tr>';
				if(isset($param['checkbox_data'][$i+1]['ID']))
				{
					$tmp_ids .= $param['checkbox_data'][$i+1]['ID'].',';
					$str .= '<td><input type="checkbox" class="check" name="'.$param['checkbox_data'][$i]['ID'].'" id="'.$param['checkbox_data'][$i]['ID'].'" value="'.addslashes($param['checkbox_data'][$i]['VALUE']).'" />'.addslashes($param['checkbox_data'][$i]['LABEL']).'</td>';
					$str .= '<td><input type="checkbox"  class="check" name="'.$param['checkbox_data'][$i+1]['ID'].'" id="'.$param['checkbox_data'][$i+1]['ID'].'" value="'.addslashes($param['checkbox_data'][$i+1]['VALUE']).'" />'.addslashes($param['checkbox_data'][$i+1]['LABEL']).'</td>';

				}
				else
				{
					$str .= '<td colspan="2"><input type="checkbox"  class="check" name="'.$param['checkbox_data'][$i]['ID'].'" id="'.$param['checkbox_data'][$i]['ID'].'" value="'.addslashes($param['checkbox_data'][$i]['VALUE']).'" />'.addslashes($param['checkbox_data'][$i]['LABEL']).'</td>';
				}
				$str .= '</tr>';
			}
			$tmp_ids = preg_replace('/,$/', '', $tmp_ids );
			$str .= '</table>';
			$str .= '<input type="hidden" name="meta[]" value="'.$id.'#'.$tmp_ids.'#checkbox" />'.$end;
		}
		elseif($field_type == 'address')
		{
			$str = $init.'<input type="hidden" name="meta[]" value="'.$id.'#'.$param['address_data']['NUM']['ID'].','.$param['address_data']['ROAD']['ID'].','.$param['address_data']['CP']['ID'].','.$param['address_data']['CITY']['ID'].','.$param['address_data']['DISTRICTS']['ID'].'#address" />';
			$str .= '<table align="center" border="0" width="100%" >';
			$str .= '<tr>';
				$str .= '<td>'.$param['address_data']['NUM']['LABEL'].'</td><td><input type="text" name="'.$param['address_data']['NUM']['ID'].'" id="'.$param['address_data']['NUM']['ID'].'" class="small"/></td>';
				$str .= '<td>'.$param['address_data']['ROAD']['LABEL'].'</td><td><input type="text" name="'.$param['address_data']['ROAD']['ID'].'" id="'.$param['address_data']['ROAD']['ID'].'" /></td>';
			$str .= '</tr>';
			$str .= '<tr>';
				$str .= '<td>'.$param['address_data']['CP']['LABEL'].'</td><td><input type="text" name="'.$param['address_data']['CP']['ID'].'" id="'.$param['address_data']['CP']['ID'].'" class="medium" maxlength="5"/></td>';
				$str .= '<td>'.$param['address_data']['CITY']['LABEL'].'</td><td><input type="text" name="'.$param['address_data']['CITY']['ID'].'" id="'.$param['address_data']['CITY']['ID'].'" /></td>';
			$str .= '</tr>';
			if(isset($param['address_data']['DISTRICTS']))
			{
				$str .= '<tr>';
					$str .= '<td>'.$param['address_data']['DISTRICTS']['LABEL'].'</td><td colspan="3">';
						$str .= '<select name="'.$param['address_data']['DISTRICTS']['ID'].'" id="'.$param['address_data']['DISTRICTS']['ID'].'">';
							$str .= '<option value="">'.$param['address_data']['DISTRICTS']['default_label'].'</option>';
							for($i=0; $i < count($param['address_data']['DISTRICTS']['options']); $i++)
							{
								$str .= '<option value="'.$param['address_data']['DISTRICTS']['options'][$i]['VALUE'].'" >'.$param['address_data']['DISTRICTS']['options'][$i]['LABEL'].'</option>';
							}
						$str .= '</select>';
					$str .= '</td>';
				$str .= '</tr>';
			}
			$str .= '</table>'.$end;
		}
		elseif($field_type == 'simple_list_or_input_text')
		{
			// td open in the showing function (js)
				$str .= '<input type="hidden" name="meta[]" value="'.$id.'#select_'.$param['id'].',input_'.$param['id'].'#simple_list_or_input_text" />';
				$str .= '<select name="select_'.$param['id'].'" id="select_'.$param['id'].'" onchange="start_action_list('."'".'div_'.$param['id']."', 'select_".$param['id']."', this.selectedIndex".')">';
					$str .= '<option value="">'.$param['default_label_select'].'</option>';
					$str .= '<option value="SHOW_DATA">'.$param['label_define_option']."</option>";
					for($i=0; $i<count($param['options']);$i++)
					{
						$str .= '<option value="'.addslashes($param['options'][$i]['VALUE']).'">'.addslashes($param['options'][$i]['LABEL']).'</option>';
					}
				$str .= '</select>';
			$str .= '</td>';
			$str .= '<td>';
				$str .= '<div id="div_'.$param['id'].'" style="visibility:hidden">';
					$str .= '<table width="100%" border="0">';
						$str .= '<tr>';
							$str .= '<td>'.$param['label_input'].' : <input type="text" name="input_'.$param['id'].'" id="input_'.$param['id'].'" '.$param['other'].' value="" /></td>';
						$str .= '</tr>';
					$str .= '</table>';
				$str .= '</div>';
			// td close in the showing function (js)
			$str = addslashes($str);
			$str =  $init.$str.$end;
		}
		elseif($field_type == 'inputs_in_2_col')
		{
			$str = $init.'<table align="center" border="0" width="100%" >';
			$tmp = "";

			for($i=0; $i<count($param['input_ids']) ;$i++)
			{
				$tmp .= $param['input_ids'][$i]['ID'].',';

				if ($i%2 != 1 || $i==0) // pair
				{
					$str .= '<tr>';
				}
				$str .= '<td >'.addslashes($param['input_ids'][$i]['LABEL']).'</td><td><input type="text" name="'.$param['input_ids'][$i]['ID'].'" id="'.$param['input_ids'][$i]['ID'].'" value="" /></td>';
				if ($i%2 == 1 && $i!=0) // impair
				{
   					echo '</tr>'	;
				}
				else
				{
					if($i+1 == count($param['input_ids']))
					{
						echo '<td  colspan="3">&nbsp;</td></tr>';
					}
				}
			}
			$tmp = preg_replace('/,$/', '', $tmp);
			$str .= '</table>';
			$str .= '<input type="hidden" name="meta[]" value="'.$id.'#'.$tmp.'#inputs_in_2_col" />'.$end;
		}
		elseif($field_type == 'select_or_other_data')
		{
			// td open in the showing function (js)
			$str .= '<table align="center" border="0" width="100%" >';
				$str .= '<tr>';
						$str .= '<td>';
							$str .= '<select name="select_'.$param['id'].'" id="select_'.$param['id'].'" onchange="start_action_list('."'".'div_'.$param['id']."', 'select_".$param['id']."', this.selectedIndex".')">';
								$str .= '<option value="">'.$param['default_label_select'].'</option>';
								$str .= '<option value="SHOW_DATA">'.$param['label_define_option']."</option>";
								for($i=0; $i<count($param['options']);$i++)
								{
									$str .= '<option value="'.$param['options'][$i]['VALUE'].'">'.$param['options'][$i]['LABEL'].'</option>';
								}
							$str .= '</select>';
						$str .= '</td>';
				$str .= '</tr>';
				$str .= '<tr>';
						$str .= '<td>';
							$str .= '<div id="div_'.$param['id'].'" style="display:none;">';
								$str .= '<table align="center" border="0" width="100%" >';
							$tmp = "select_".$param['id'].",";
								for($i=0; $i<count($param['input_ids']) ;$i++)
								{
									$tmp .= $param['input_ids'][$i]['ID'].',';
									if ($i%2 != 1 || $i==0) // pair
									{
										$str .= '<tr>';
									}
									$str .= '<td >'.$param['input_ids'][$i]['LABEL'].' :</td><td><input type="text" name="'.$param['input_ids'][$i]['ID'].'" id="'.$param['input_ids'][$i]['ID'].'" value="" /></td>';
									if ($i%2 == 1 && $i!=0) // impair
									{
					   					echo '</tr>'	;
									}
									else
									{
										if($i+1 == count($param['input_ids']))
										{
											echo '<td  colspan="3">&nbsp;</td></tr>';
										}
									}
								}
							$tmp = preg_replace('/,$/', '', $tmp);
								$str .= '</table>';
							$str .= '</div>';
							$str .= '<input type="hidden" name="meta[]" value="'.$id.'#'.$tmp.'#select_or_other_data" />';
						$str .= '</td>';
				$str .= '</tr>';
			$str .= '</table>';
			// td close in the showing function (js)
			$str = addslashes($str);
			$str =  $init.$str.$end;
		}
		else
		{

		}
		return $str;
	}

	public function get_process_data($coll_id, $res_id)
	{
		require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
		$sec =new security();
		$view = $sec->retrieve_view_from_coll_id($coll_id);
		if(empty($view))
		{
			$view = $sec->retrieve_table_from_coll($coll_id);
		}
		$db = new dbquery();
		$db->connect();
		$db->query("select answer_type_bitmask, process_notes, other_answer_desc from ".$view." where res_id = ".$res_id);
		$res = $db->fetch_object();
		$bitmask = $res->answer_type_bitmask;
		$process_notes = $db->show_string($res->process_notes);
		$other_answer_desc = $db->show_string($res->other_answer_desc);
		$contact = false;
		$mail = false;
		$AR = false;
		$fax = false;
		$email = false;
		$other = false;
		$no_answer = false;
		if($bitmask == '000000' || $bitmask == '')
		{
			$no_answer = true;
		}
		else
		{
			/**
		 * Answer type bitmask
		 * 0 0 0 0 0 0
		 * | | | | | |_ Simple Mail
		 * | | | | |___ Registered mail
		 * | | | |_____ Direct Contact
		 * | | |_______ Email
		 * | |_________ Fax
		 * |___________ Other Answer
		 **/

			if($bitmask[0] == '1')
			{
				$other = true;
			}
			if($bitmask[1] == '1')
			{
				$fax = true;
			}
			if($bitmask[2] == '1')
			{
				$email = true;
			}
			if($bitmask[3] == '1')
			{
				$contact = true;
			}
			if($bitmask[4] == '1')
			{
				$AR = true;
			}
			if($bitmask[5] == '1')
			{
				$mail = true;
			}
		}
		return array('process_notes' => $process_notes, 'direct_contact' => $contact, 'simple_mail' => $mail, 'registered_mail' => $AR, 'fax' => $fax, 'email' => $email, 'no_answer' => $no_answer, 'other' => $other, 'other_answer_desc' => $other_answer_desc);
	}

}
?>