<?
######################################################################################
##
##    Program     : 
##    Description :
##    Programmer  : ไชยรัตน์  สุนทรวิภาต
##    Email       : webmaster@sixhead.com
##                : webmaster@todaysoftware.com
##    Website     : http://www.sixhead.com
##                : http://www.todaysoftware.com
##    Date        : 
##    Modify log  : 
##     
######################################################################################

#####################################################################
#### start setup ####

$tp_training_category_list	=	"_tp_training_category_Board_list_v41.html";

#### end of setup ####
#####################################################################

#####################################################################
#### start program ####

require "module/_config.php";
require "module/_module.php";

ob_start();


$db = mysql_connect($db_host,$db_user,$db_pass); 
mysql_select_db($db_name);
if (!$db) { echo "Error connect to Database: " . mysql_error(); ob_end_flush(); exit; }

$category_id_sql = "%";
if ($category_id) { 
	$sql = "SELECT * FROM $db_table_training_category WHERE CATEGORY_ID = '$category_id'";
	$result = mysql_query($sql);
	while($row = mysql_fetch_array($result)) {
		$category_name = $row[CATEGORY_NAME];
	}
	mysql_free_result($result);

}
if ($trainer_id) { 
	$sql = "SELECT * FROM $db_table_trainer WHERE ID = '$trainer_id'";
	$result = mysql_query($sql);
	while($row = mysql_fetch_array($result)) {
		$category_name = "วิทยากร $row[FNAME] $row[LNAME] ";
	}
	mysql_free_result($result);
}
if ($training_date_start) { 
	$training_date_start_show = Convert_YMD_2_DMY($training_date_start);
	$category_name = "การจัดอบรมในวันที่ $training_date_start_show";
}
if ($keyword) { 
	$category_name = "การจัดอบรมที่เกี่ยวกับ \"$keyword\"";
}

#หัวข้ออบรม - สัมมนา / by date / by traniner
if ($sort == 1) { $order_by = "$db_table_training.TRAINING_TOPIC"; }
else if ($sort == 2) { $order_by = "$db_table_training.TRAINING_DATE_START DESC"; }
else if ($sort == 3) { $order_by = "$db_table_trainer.FNAME"; }
else { $order_by = "$db_table_training.TRAINING_ID DESC"; }


$category_id_sql = "%";
if ($category_id) {
	$category_id_sql = $category_id;
}
$keyword_sql = "%";
if ($keyword) {
	$keyword_sql = "%$keyword%";
}
$training_date_start_sql = "%";
if ($training_date_start) {
	$training_date_start_sql = "$training_date_start%";
}
$trainer_id_sql = "%";
if ($trainer_id) {
	$trainer_id_sql = $trainer_id;
}

$cfg_list_per_page = $cfg_list_per_page_global;
$other_sql		=	" WHERE (($db_table_training.TRAINING_TOPIC LIKE '$keyword_sql' OR $db_table_training.TRAINING_DETAIL LIKE '$keyword_sql') AND $db_table_training.CATEGORY_ID LIKE '$category_id_sql' AND $db_table_training.TRAINER_ID LIKE '$trainer_id_sql' AND $db_table_training.TRAINING_ACTIVE = 'Y' AND $db_table_training.TRAINING_DATE_START LIKE '$training_date_start_sql')";
$link_parameter	=	"&category_id=$category_id&keyword=$keyword&$training_date_start=$training_date_start&trainer_id=$trainer_id&sort=$sort";
Split_Page($db_table_training,$other_sql,$p,$cfg_list_per_page,$link_parameter);


$tp = new Template($tp_training_category_list);
$tp->Block("DATA");

	$sql = "SELECT $db_table_training.*,$db_table_trainer.FNAME,$db_table_trainer.LNAME FROM $db_table_training LEFT JOIN $db_table_trainer ON ($db_table_training.TRAINER_ID = $db_table_trainer.ID) $other_sql ORDER BY $order_by limit $start_loop,$cfg_list_per_page";
	#echo "$sql";
	$result = mysql_query($sql);
	while($row = mysql_fetch_array($result)) {

		list ($training_date_start,$training_date_start_hr,$training_date_start_min) = Convert_YMDHMS_2_DateHrMin($row[TRAINING_DATE_START]);
		list ($training_date_end,$training_date_end_hr,$training_date_end_min) = Convert_YMDHMS_2_DateHrMin($row[TRAINING_DATE_END]);
		$training_date_start = Convert_YMD_2_DMY_Training_Month($training_date_start);
		$training_date_end = Convert_YMD_2_DMY_Training_Month($training_date_end);

		$open_img = "";
		if ($row[TRAINING_OPEN] == "Y") { 
			$open_img	=	"<img src='images/icon/training.open.gif' align='absmiddle'>";
		}
		else if ($row[TRAINING_OPEN] == "N") { 
			$open_img	=	"<img src='images/icon/training.close.gif' align='absmiddle'>";
		}
		else if ($row[TRAINING_OPEN] == "F") { 
			$open_img	=	"<img src='images/icon/training.finish.gif' align='absmiddle'>";
		}

		$img_free = "";
		if ($row[TRAINING_FREE] == "Y") { 
			$img_free	=	"<img src='images/icon/training.free.gif' align='absmiddle'>";
		}

		$training_id = $row[TRAINING_ID];
		$training_topic = $row[TRAINING_TOPIC];
		$training_code = $row[TRAINING_CODE];

		
		$strImgTrainingBoardIcon	=	"<img src='images/icon/training_board_no.gif' align='absmiddle'> ";
		if (checkAccessTrainingBoard($training_id,"Y")) { 
			$strImgTrainingBoardIcon	=	"<img src='images/icon/training_board_yes.gif' align='absmiddle'> ";	
		}


		if ($bgcolor == "#F2FFF2") { $bgcolor = "#FFFFFF"; }
		else { $bgcolor = "#F2FFF2"; }

		$data = array(
			'bgcolor'	=>	$bgcolor,	
			'training_id'	=>	$training_id,
			'training_code'	=>	$training_code,
			'training_topic'	=>	$training_topic,
			'training_date_start'	=>	$training_date_start,
			'training_date_end'	=>	$training_date_end,
			'trainer'	=>	"$row[FNAME] $row[LNAME]",
			'strImgTrainingBoardIcon'	=>	$strImgTrainingBoardIcon,
			'open_img'	=>	$open_img,
			'img_free'	=>	$img_free,
		);
		$tp->Apply($data);
	}
	mysql_free_result($result);
	#mysql_close($db);
	$tp->Mix();


	#หัวข้ออบรม - สัมมนา / by date / by traniner
	$select_sort = "
	<option value='training_category_Boardlist.php?category_id=$category_id&keyword=$keyword&sort=4'> - รายการล่าสุด</option>
	<option value='training_category_Boardlist.php?category_id=$category_id&keyword=$keyword&sort=1'> - หัวข้ออบรม - สัมมนา</option>
	<option value='training_category_Boardlist.php?category_id=$category_id&keyword=$keyword&sort=2'> - วันที่อบรม</option>
	<option value='training_category_Boardlist.php?category_id=$category_id&keyword=$keyword&sort=3'> - วิทยากร</option>
	";
	$select_sort = preg_replace("/&sort=$sort'/", "&sort=$sort'selected", $select_sort);


	$HTML = $tp->Data();
	$HTML = preg_replace("/\\$(\w+)/e","$$1",$HTML); 
	echo $HTML;
	exit;


ob_end_flush();

#### end of program ####
#####################################################################


#### Start sub program. Don't touch anything below ####


?>