<?
/**
 * product include
 * @author HuyPQ
 * @Created 17/09/2015
 */
 
//default download process type
define('DOWNLOAD_PROCESS_TYPE', 3000000);
//default download object type
define('DOWNLOAD_OBJECT_TYPE', 30000);
//default company
define('SHAREDAT_COMPANY', 34);

/**
 * Get module data
 * @author HuyPQ (150917)
 * @param $module_name {string}	module name
 */
function getModuleData($module_name){
 	require_once(INCLUDEPATH . 'flar/Fibercloud_modules.php');
	require_once(INCLUDEPATH . 'flar/Fibercloud_modules_assigned.php');
 	global $conn;
 	global $_SESSION;
 	
 	$menulabels = Lang::readLanguageFile($_SESSION["MGW"]->spkz, "product");
 	
 	//get module data
	$sql = " SELECT * FROM mgw_modules WHERE modulename = '".$module_name."'".
		   " AND active = 1" ;
	if(!$res = $conn->Execute($sql)) exit(showSQLerror2($sql, $conn->ErrorMsg(), __LINE__, __FILE__));
	
	$data = array();
	if($row = $res->FetchRow()) {
		$title = $row["modulename"];
		if($menulabels[$title]) $title = $menulabels[$title];
	     $data =   array('version'		=> $row["version"],
	     				 'modulename'	=> $row["modulename"],
	     				 'title' 		=> $title,
	     				 'description' 	=> $row["description"]
	     				);
	}
	
	//check active module
	$db_Fibercloud_modules = new Flar_Fibercloud_modules();
	$db_Fibercloud_modules->query("SET NAMES 'utf8'");
	$db_Fibercloud_modules->mgw_modulename = $row["modulename"];
	$db_Fibercloud_modules->find();
	$id_module = 0;
	$title_module = "";
	if($db_Fibercloud_modules->fetch()){
		$id_module = $db_Fibercloud_modules->idfibercloud_modules;
		$title_module = $db_Fibercloud_modules->modulename;
	}
	$db_Fibercloud_modules->free();
	
	$db_Fibercloud_modules_assigned = new Flar_Fibercloud_modules_assigned();
	$db_Fibercloud_modules_assigned->query("SET NAMES 'utf8'");
	$db_Fibercloud_modules_assigned->company_idcompany = $_SESSION["company"]["company_selected"];
	$db_Fibercloud_modules_assigned->fibercloud_modules_idfibercloud_modules =  $id_module;
	$db_Fibercloud_modules_assigned->find();
	$active_module = 0;
	$activate_date = null;
	if($db_Fibercloud_modules_assigned->fetch()){
		$active_module = 1;
		$activate_date = $db_Fibercloud_modules_assigned->activated;
	}
	$db_Fibercloud_modules_assigned->free();
	
	$array_return = array("module_data"		=> $data,
						  "id_module"		=> $id_module,
						  "title_module"	=> $title_module,
						  "active_module"	=> $active_module,
						  "activate_date"	=> $activate_date);
	return $array_return;
}

/**
 * Get download version
 * @author HuyPQ (150917)
 * @param $costcenter_id {int}	assigned costcenter
 */
function getDownloadVersion($costcenter_id){
 	require_once(INCLUDEPATH . 'flar/Bo_objects.php');
	require_once(INCLUDEPATH . 'flar/Bo_objects_data.php');
	require_once(INCLUDEPATH . 'flar/Bo_process_data.php');
	require_once(INCLUDEPATH . 'flar/Costcenter_bo_process_data_link.php');
	require_once(INCLUDEPATH . 'flar/functions/db_bp.php');
 	global $_SESSION;
 	
 	$whereAdd = " AND bo_process_data.company_idcompany = ".SHAREDAT_COMPANY;
	$whereAdd .= " AND costcenter_bo_process_data_link.costcenter_COSTCENTER_ID = ".$costcenter_id;
	
	$db_bo_objects_data = new Flar_Bo_objects_data();
	$db_bo_objects_data->query("SET NAMES 'utf8'");
	
	$query = " SELECT bo_objects_data.* FROM ".$db_bo_objects_data->__table." AS bo_objects_data".
			 " LEFT OUTER JOIN bo_process_data ON bo_objects_data.bo_process_data_idbo_process_data = bo_process_data.idbo_process_data".
			 " LEFT OUTER JOIN costcenter_bo_process_data_link ON bo_objects_data.bo_process_data_idbo_process_data = costcenter_bo_process_data_link.bo_process_data_idbo_process_data".
			 " WHERE bo_process_data.bo_process_idbo_process = ".DOWNLOAD_PROCESS_TYPE.
			 " AND bo_objects_data.bo_objects_idbo_objects = ".DOWNLOAD_OBJECT_TYPE.
			 " AND bo_objects_data.erased = 0".
			 $whereAdd.
			 " ORDER BY bo_objects_data.date_1 DESC";
			 
	$db_bo_objects_data->query($query);
	$array_return = array();
	while($db_bo_objects_data->fetch()){
		//get created
		$created = "";
		if($db_bo_objects_data->date_1){
			$created = date($_SESSION["config"]["date_format"], strtotime($db_bo_objects_data->date_1));
		}
		
		//get newest attachment
		$attach_file = null;
		$attachments = getData_Attachments("", $db_bo_objects_data->idbo_objects_data);
		if(count($attachments)){
			$attach_file = $attachments[0];
		}
		
		$array_return[] = array("id"			=> $db_bo_objects_data->idbo_objects_data,
								"version"		=> $db_bo_objects_data->titel,
								"description"	=> $db_bo_objects_data->info,
								"attachment"	=> $attach_file,	 
								"date"			=> $created,
								"url_info"		=> $db_bo_objects_data->text_1);
	}
	$db_bo_objects_data->free();
	return $array_return;
}

/**
 * Get fiberdoc software
 * @author HuyPQ (150918)
 * @param $costcenter_id {int}	assigned costcenter
 */
function getFibercloudDocumentAndHelp($costcenter_id){
 	require_once(INCLUDEPATH . 'flar/Bo_objects.php');
	require_once(INCLUDEPATH . 'flar/Bo_objects_data.php');
	require_once(INCLUDEPATH . 'flar/Bo_process_data.php');
	require_once(INCLUDEPATH . 'flar/Costcenter_bo_process_data_link.php');
	require_once(INCLUDEPATH . 'flar/functions/db_bp.php');
 	global $_SESSION;
 	
 	$whereAdd = " AND bo_process_data.company_idcompany = ".SHAREDAT_COMPANY;
	$whereAdd .= " AND costcenter_bo_process_data_link.costcenter_COSTCENTER_ID = ".$costcenter_id;
	
	$db_bo_objects_data = new Flar_Bo_objects_data();
	$db_bo_objects_data->query("SET NAMES 'utf8'");
	
	$query = " SELECT bo_objects_data.idbo_objects_data, bo_objects_data.titel AS object_title, bo_process_data.idbo_process_data, bo_process_data.titel AS process_title, bo_objects_data.date_1, bo_objects_data.info FROM ".$db_bo_objects_data->__table." AS bo_objects_data".
			 " LEFT OUTER JOIN bo_process_data ON bo_objects_data.bo_process_data_idbo_process_data = bo_process_data.idbo_process_data".
			 " LEFT OUTER JOIN costcenter_bo_process_data_link ON bo_objects_data.bo_process_data_idbo_process_data = costcenter_bo_process_data_link.bo_process_data_idbo_process_data".
			 " WHERE bo_process_data.bo_process_idbo_process = ".DOWNLOAD_PROCESS_TYPE.
			 " AND bo_objects_data.bo_objects_idbo_objects = ".DOWNLOAD_OBJECT_TYPE.
			 " AND bo_objects_data.erased = 0".
			 $whereAdd.
			 " ORDER BY bo_process_data.titel, bo_objects_data.date_1 DESC";
			 
	$db_bo_objects_data->query($query);
	$array_return = array();
	while($db_bo_objects_data->fetch()){
		
		//get attachment
		$attach_file = null;
		$attachments = getData_Attachments("", $db_bo_objects_data->idbo_objects_data);
		if(count($attachments)){
			$attach_file = $attachments[0];
		}
		
		//remove number at begin process title
		$process_title = "";
		if(strlen($db_bo_objects_data->process_title)){
			$array_strTitle = explode(" ", $db_bo_objects_data->process_title);
			array_shift($array_strTitle);
			$process_title = implode(" ", $array_strTitle);
		}
		
		$array_return[$db_bo_objects_data->idbo_process_data][] =  array("process_id"	=> $db_bo_objects_data->idbo_process_data,
																		 "process_title"=> $process_title,
																		 "id"			=> $db_bo_objects_data->idbo_objects_data,
																		 "object_title"	=> $db_bo_objects_data->object_title,
																		 "object_date"	=> date($_SESSION["config"]["date_format"], strtotime($db_bo_objects_data->date_1)),
																		 "attachment"	=> $attach_file);
	}
	$db_bo_objects_data->free();
	return $array_return;
}

/**
 * Get fiberdoc document and help
 * @author HuyPQ (150917)
 * @param $costcenter_id {int}	assigned costcenter
 */
function getFiberdocDocumentAndHelp($costcenter_id){
	require_once(INCLUDEPATH . 'flar/Bo_process_data.php');
	require_once(INCLUDEPATH . 'flar/Costcenter_bo_process_data_link.php');
	require_once(INCLUDEPATH . 'flar/Blog_entry.php');
	require_once(INCLUDEPATH . 'flar/functions/db_bp.php');
	require_once(INCLUDEPATH . 'flar/functions/db_blog.php');
 	global $_SESSION;
 	
 	$whereAdd = " AND bo_process_data.company_idcompany = ".SHAREDAT_COMPANY;
	$whereAdd .= " AND costcenter_bo_process_data_link.costcenter_COSTCENTER_ID = ".$costcenter_id;
	
	$db_bo_process_data = new Flar_Bo_process_data();
	$db_bo_process_data->query("SET NAMES 'utf8'");
	
	$query = " SELECT bo_process_data.* FROM ".$db_bo_process_data->__table." AS bo_process_data".
			 " LEFT OUTER JOIN costcenter_bo_process_data_link ON bo_process_data.idbo_process_data = costcenter_bo_process_data_link.bo_process_data_idbo_process_data".
			 " WHERE bo_process_data.deleted = 0 AND bo_process_data.bo_process_idbo_process = ".DOWNLOAD_PROCESS_TYPE.
			 $whereAdd.
			 " ORDER BY bo_process_data.titel";
			 
	$db_bo_process_data->query($query);
	$array_return = array();
	while($db_bo_process_data->fetch()){
		//remove number at begin process title
		$process_title = "";
		if(strlen($db_bo_process_data->titel)){
			$array_strTitle = explode(" ", $db_bo_process_data->titel);
			array_shift($array_strTitle);
			$process_title = implode(" ", $array_strTitle);
		}
		
		//get description: newest weblog of process
		$description = "";
		$blog_entry = new Flar_Blog_entry();
  		$blog_entry->query("SET NAMES 'utf8'");
  		
  		$query = " SELECT blog_entry.titel FROM ".$blog_entry->__table." AS blog_entry".
  				 " LEFT OUTER JOIN res_personal ON res_personal.PERSON_ID = blog_entry.PERSON_ID".
  				 " WHERE blog_id = ".BLOG_BUSINESS_PROCESS.
  				 " AND id = ".$db_bo_process_data->idbo_process_data.
				 " AND res_personal.company_idcompany = ".SHAREDAT_COMPANY.
  				 " AND blog_entry.PERSON_ID > 0 AND blog_entry_type = 0".
  				 " ORDER BY blog_created DESC LIMIT 1";
  		$blog_entry->query($query);
  		if($blog_entry->fetch()){
  			$description = nl2br($blog_entry->titel);
  		}	
  		$blog_entry->free();	 
  		
		//$blog_data = get_weblog_data_table(BLOG_BUSINESS_PROCESS, $db_bo_process_data->idbo_process_data);
		//if($blog_data) $description = $blog_data[0]["titel_br"];
		if($process_title && $process_title != ""){
			$array_return[] = array("process_id"	=> $db_bo_process_data->idbo_process_data,
									"process_title" => $process_title,
									"description"	=> $description);
		}
	}
	$db_bo_process_data->free();
	return $array_return;
}

/**
 * Get fiberdoc software
 * @author HuyPQ (150917)
 * @param $costcenter_id {int}	assigned costcenter
 */
function getFiberdocSoftware($costcenter_id){
 	require_once(INCLUDEPATH . 'flar/Bo_objects.php');
	require_once(INCLUDEPATH . 'flar/Bo_objects_data.php');
	require_once(INCLUDEPATH . 'flar/Bo_process_data.php');
	require_once(INCLUDEPATH . 'flar/Costcenter_bo_process_data_link.php');
	require_once(INCLUDEPATH . 'flar/functions/db_bp.php');
 	global $_SESSION;
 	
 	$whereAdd = " AND bo_process_data.company_idcompany = ".SHAREDAT_COMPANY;
	$whereAdd .= " AND costcenter_bo_process_data_link.costcenter_COSTCENTER_ID = ".$costcenter_id;
	
	$db_bo_objects_data = new Flar_Bo_objects_data();
	$db_bo_objects_data->query("SET NAMES 'utf8'");
	
	$query = " SELECT bo_objects_data.idbo_objects_data, bo_objects_data.titel AS object_title, bo_process_data.idbo_process_data, bo_process_data.titel AS process_title, bo_objects_data.date_1, bo_objects_data.info FROM ".$db_bo_objects_data->__table." AS bo_objects_data".
			 " LEFT OUTER JOIN bo_process_data ON bo_objects_data.bo_process_data_idbo_process_data = bo_process_data.idbo_process_data".
			 " LEFT OUTER JOIN costcenter_bo_process_data_link ON bo_objects_data.bo_process_data_idbo_process_data = costcenter_bo_process_data_link.bo_process_data_idbo_process_data".
			 " WHERE bo_process_data.bo_process_idbo_process = ".DOWNLOAD_PROCESS_TYPE.
			 " AND bo_objects_data.bo_objects_idbo_objects = ".DOWNLOAD_OBJECT_TYPE.
			 " AND bo_objects_data.erased = 0".
			 $whereAdd.
			 " ORDER BY bo_process_data.titel, bo_objects_data.date_1 DESC";
			 
	$db_bo_objects_data->query($query);
	$array_return = array();
	while($db_bo_objects_data->fetch()){
		
		//get attachment
		$attach_file = null;
		$attachments = getData_Attachments("", $db_bo_objects_data->idbo_objects_data);
		if(count($attachments)){
			$attach_file = $attachments[0];
		}
		
		//remove number at begin process title
		$process_title = "";
		if(strlen($db_bo_objects_data->process_title)){
			$array_strTitle = explode(" ", $db_bo_objects_data->process_title);
			array_shift($array_strTitle);
			$process_title = implode(" ", $array_strTitle);
		}
		
		$array_return[$db_bo_objects_data->idbo_process_data][] =  array("process_id"	=> $db_bo_objects_data->idbo_process_data,
																		 "process_title"=> $process_title,
																		 "id"			=> $db_bo_objects_data->idbo_objects_data,
																		 "object_title"	=> $db_bo_objects_data->object_title,
																		 "object_date"	=> date($_SESSION["config"]["date_format"], strtotime($db_bo_objects_data->date_1)),
																		 "attachment"	=> $attach_file);
	}
	$db_bo_objects_data->free();
	return $array_return;
}

/**
 * Get fiberdoc document and link
 * @author HuyPQ (150917)
 * @param $costcenter_id {int}	assigned costcenter
 */
function getFiberdocDocumentAndLink($costcenter_id){
 	require_once(INCLUDEPATH . 'flar/Bo_objects.php');
	require_once(INCLUDEPATH . 'flar/Bo_objects_data.php');
	require_once(INCLUDEPATH . 'flar/Bo_process_data.php');
	require_once(INCLUDEPATH . 'flar/Costcenter_bo_process_data_link.php');
	require_once(INCLUDEPATH . 'flar/functions/db_bp.php');
 	global $_SESSION;
 	
 	$whereAdd = " AND bo_process_data.company_idcompany = ".SHAREDAT_COMPANY;
	$whereAdd .= " AND costcenter_bo_process_data_link.costcenter_COSTCENTER_ID = ".$costcenter_id;
	
	$db_bo_objects_data = new Flar_Bo_objects_data();
	$db_bo_objects_data->query("SET NAMES 'utf8'");
	
	$query = " SELECT bo_objects_data.idbo_objects_data, bo_objects_data.titel AS object_title, bo_process_data.idbo_process_data, bo_process_data.titel AS process_title, bo_objects_data.date_1, bo_objects_data.text_1, bo_objects_data.info FROM ".$db_bo_objects_data->__table." AS bo_objects_data".
			 " LEFT OUTER JOIN bo_process_data ON bo_objects_data.bo_process_data_idbo_process_data = bo_process_data.idbo_process_data".
			 " LEFT OUTER JOIN costcenter_bo_process_data_link ON bo_objects_data.bo_process_data_idbo_process_data = costcenter_bo_process_data_link.bo_process_data_idbo_process_data".
			 " WHERE bo_process_data.bo_process_idbo_process = ".DOWNLOAD_PROCESS_TYPE.
			 " AND bo_objects_data.bo_objects_idbo_objects = ".DOWNLOAD_OBJECT_TYPE.
			 " AND bo_objects_data.erased = 0".
			 $whereAdd.
			 " ORDER BY bo_objects_data.date_1 DESC, bo_objects_data.created DESC";
			 
	$db_bo_objects_data->query($query);
	$documentandlink_objects_data = array();
	while($db_bo_objects_data->fetch()){
		//remove one character at  begin object title
		$object_title = "";
		if(strlen($db_bo_objects_data->object_title)){
			$array_strTitle = explode(":", $db_bo_objects_data->object_title);
			$char = $array_strTitle[0];
			array_shift($array_strTitle);
			$object_title = implode(":", $array_strTitle);
		}
		
		$attach_file = null;
		$link = "";
		if($char == "D"){
			//get attachment
			$attachments = getData_Attachments("", $db_bo_objects_data->idbo_objects_data);
			if(count($attachments)){
				$attach_file = $attachments[0];
			}
		}
		else if($char == "L"){
			$link = $db_bo_objects_data->text_1;
		}
		
		$array_return[] =  array("id"			=> $db_bo_objects_data->idbo_objects_data,
								 "object_title"	=> $object_title,
								 "object_date"	=> date($_SESSION["config"]["date_format"], strtotime($db_bo_objects_data->date_1)),
								 "attachment"	=> $attach_file,
								 "type"			=> $char,
								 "link"			=> $link,
								 "description"	=> $db_bo_objects_data->info);
	}
	$db_bo_objects_data->free();
	return $array_return;
}

/**
 * Get product news
 * @author HuyPQ (150917)
 */
function getProductNews($joomlaserver, $joomladb, $rootpathURL, $user, $pw, $catid){
 	$joomla_conn = mysql_connect($joomlaserver, $user, $pw);
	$array_return = array();
	if ($joomla_conn) {
		$joomla_db = mysql_select_db($joomladb, $joomla_conn);
		if($joomla_db){
			
			$query = " SELECT * FROM jos_content".
					 " WHERE catid = ".$catid." and state = 1 ".
					 " ORDER BY created DESC LIMIT 10";
			$query_return = mysql_db_query ( $joomladb, $query, $joomla_conn);
			
			while($row_data = mysql_fetch_array($query_return)){
				$created = date($_SESSION["config"]["date_format"], strtotime($row_data["created"]));
				
				$array_return[] = 		array("id"			=> $row_data["id"],
				  		 				 	  "title"		=> $row_data["title"],
				  		 				 	  "created"		=> $created,
				  		 				 	  "catid"		=> $row_data["catid"],
				  		 				 	  "sectionid"	=> $row_data["sectionid"]);
			}
		}
	}
	return $array_return;
}
?>