<?
######################################################################################
##
##    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_register_confirm	=	"_tp_training_register_confirm_v4.html";
$tp_training_register_complete	=	"_tp_training_register_complete_v4.html";

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

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

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


# check session ÇèÒä´é·Ó¡ÒÃ login áÅéÇËÃ×ÍÂÑ§
if (!$_SESSION['s_user_username']) {
	#$go = urlencode("$cfg_main_url/training_register.php?training_id=$training_id");
	$error	=	$cfg_text_error_session;
	$go		=	urlencode($_SERVER["REQUEST_URI"]);
	header("Location: $cfg_main_url/user/index.php?error=$error&go=$go");
	exit;
}
else { 

	if (!$confirm) { 

		@$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; }
		
		$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) WHERE TRAINING_ID = '$training_id' AND TRAINING_ACTIVE = 'Y'";
		$result = mysql_query($sql);
		while($row = mysql_fetch_array($result)) {
			$training_date_detail=	nl2br($row[TRAINING_DATE_DETAIL]);
			$training_date_info	=	$row[TRAINING_DATE_INFO];
			$training_quota		=	$row[TRAINING_QUOTA];
			$training_cost		=	$row[TRAINING_COST];
			$training_code		=	$row[TRAINING_CODE];
			$training_topic		=	$row[TRAINING_TOPIC];
			$training_detail	=	$row[TRAINING_DETAIL];
			$training_place		=	nl2br($row[TRAINING_PLACE]);
			$training_map		=	$row[TRAINING_MAP];
			$trainer_id			=	$row[TRAINER_ID];
			$trainer_helper		=	$row[TRAINER_HELPER];
			$training_open		=	$row[TRAINING_OPEN];
			$training_privilege	=	$row[TRAINING_PRIVILEGE];
			$training_level		=	$row[TRAINING_LEVEL];


			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);
			$training_date_start_show = "$training_date_start àÇÅÒ $training_date_start_hr:$training_date_start_min ¹.";
			$training_date_end_show = "$training_date_end àÇÅÒ $training_date_end_hr:$training_date_end_min ¹.";


			if ($row[TRAINING_REGISTER_DATE_START] != "0000-00-00 00:00:00") { 
				list ($training_register_date_start,$training_register_date_start_hr,$training_register_date_start_min) = Convert_YMDHMS_2_DateHrMin($row[TRAINING_REGISTER_DATE_START]);
				$training_register_date_start = Convert_YMD_2_DMY_Training_Month($training_register_date_start);
				$training_register_date_start_show = "$training_register_date_start àÇÅÒ $training_register_date_start_hr:$training_register_date_start_min ¹.";
			}
			if ($row[TRAINING_REGISTER_DATE_END] != "0000-00-00 00:00:00") { 
				list ($training_register_date_end,$training_register_date_end_hr,$training_register_date_end_min) = Convert_YMDHMS_2_DateHrMin($row[TRAINING_REGISTER_DATE_END]);
				$training_register_date_end = Convert_YMD_2_DMY_Training_Month($training_register_date_end);
				$training_register_date_end_show = "$training_register_date_end àÇÅÒ $training_register_date_start_hr:$training_register_date_start_min ¹.";
			}

			$fname		=	$row[FNAME];
			$lname		=	$row[LNAME];


			$strTrainingCostAndIcon = GenTrainingCostAndIcon($row[TRAINING_COST],$row[TRAINING_COST2],$row[TRAINING_FREE]);

		}	
		mysql_free_result($result);

		if ($training_map) { 
			$training_map_link = "&nbsp;<a href='javascript:TrainingMap(\"$training_map\");'>(ï¿½ï¿½Ô¡ï¿½ï¿½á¼¹ï¿½ï¿½ï¿½)</a>";
		}

		$training_privileges=	preg_split("/,/", $training_privilege, -1, PREG_SPLIT_NO_EMPTY);
		foreach ($training_privileges as $temp) { 
				if ($temp == "vdo") { $strCheckPrivilege .= "<img src='images/icon/training.vdo.gif' align='absmiddle'> "; }
				else if ($temp == "doc") { $strCheckPrivilege .= "<img src='images/icon/training.doc.gif' align='absmiddle'> "; }
				else if ($temp == "software") { $strCheckPrivilege .= "<img src='images/icon/training.software.gif' align='absmiddle'> "; }
				else if ($temp == "point") { $strCheckPrivilege .= "<img src='images/icon/training.point.gif' align='absmiddle'> "; }
				else if ($temp == "friend") { $strCheckPrivilege .= "<img src='images/icon/training.friend.gif' align='absmiddle'> "; }
				else if ($temp == "student") { $strCheckPrivilege .= "<img src='images/icon/training.student.gif' align='absmiddle'> "; }
				else if ($temp == "food") { $strCheckPrivilege .= "<img src='images/icon/training.food.gif' align='absmiddle'> "; }
				else if ($temp == "certificate") { $strCheckPrivilege .= "<img src='images/icon/training.certificate.gif' align='absmiddle'> "; }			
		}
		$training_levels=	preg_split("/,/", $training_level, -1, PREG_SPLIT_NO_EMPTY);
		foreach ($training_levels as $temp) { 
				if ($temp == "1") { $strCheckLevel1 = "checked"; }
				else if ($temp == "2") { $strCheckLevel2 = "checked"; }
				else if ($temp == "3") { $strCheckLevel3 = "checked"; }
		}

		$count_Y = 0;
		$sql = "SELECT * FROM $db_table_training_register WHERE TRAINING_ID = '$training_id' AND ACTIVE = 'Y'";
		$result = mysql_query($sql);
		$count_Y = mysql_num_rows($result);
		mysql_free_result($result);

		$available_quota = $training_quota - $count_Y;


# Ticket Reserve #
$sql = "SELECT TICKET_RC FROM $db_table_training WHERE TRAINING_ID = $training_id";
$result = mysql_query($sql);
if (!$result) { echo "$sql\n"; die('Invalid query: ' . mysql_error()); }
while($row = mysql_fetch_array($result)) {
	$ticket_rc	=	$row[TICKET_RC];
}
mysql_free_result($result);


$sql = "SELECT * FROM $db_table_training_ticket WHERE TRAINING_ID = $training_id";
$result = mysql_query($sql);
if (!$result) { echo "$sql\n"; die('Invalid query: ' . mysql_error()); }
while($row = mysql_fetch_array($result)) {
	$ticket_id		=	$row[TICKET_ID];
	$ticket_name	=	$row[TICKET_NAME];
	$ticket_reserve	=	$row[TICKET_RESERVE];
	$arr_ticket_name[$ticket_name]			=	$ticket_name;
	$arr_ticket_name_reserve[$ticket_name]	=	$ticket_reserve;
}
mysql_free_result($result);


list($row,$column) = split ("x",$ticket_rc);
$ticket_row = $row;

$strTicketReserve = <<<SiXhEaD
<table border="0" cellpadding="2" cellspacing="1">
SiXhEaD;
for ($intI=1;$intI<=$row;$intI++) {	
	if ($strBgColor == "#F9F9F9") { $strBgColor = "#E9E9E9"; }
	else { $strBgColor = "#F9F9F9"; }

	$strColumnName = GetColumnName($intI);
	$strTicketReserve .= "\n<tr bgcolor='$strBgColor'>";
	for ($intJ=1;$intJ<=$column;$intJ++) {
	
		$strImgSeatS	=	"images/seats.gif";
		$strImgSeatE	=	"images/seate.gif";
		$strImgSeatR	=	"images/seatr.gif";
		
		$strRadioOrImg = "<input name='ticket' type='radio' value='$strColumnName$intJ' style='border: 1px solid #FF9900'>";
		$strImgSeat = "";
		$checked = "checked";
		if ("$strColumnName$intJ" == $arr_ticket_name["$strColumnName$intJ"]) { 
			$checked = "";
			if ($arr_ticket_name_reserve["$strColumnName$intJ"] == "Y") { 
				$strImgSeat	=	$strImgSeatS;
				$strRadioOrImg = "<img src='$strImgSeat' alt='Seat No. = $strColumnName$intJ'>";
			}
		}
		if ($checked == "checked") { 
			$strImgSeat = $strImgSeatR;
			$strRadioOrImg = "<img src='$strImgSeat'alt='Seat No. = $strColumnName$intJ'>";
		}
		
		
$strTicketReserve .= <<<SiXhEaD
\n<td align="center">$strColumnName$intJ<br>$strRadioOrImg</td>
SiXhEaD;
	}
	$strTicketReserve .= "\n</tr>";
}
$strTicketReserve .= <<<SiXhEaD
</table>
SiXhEaD;
# /Ticket Reserve #


		mysql_close($db);

		$tp = new SiXTemplate($tp_training_register_confirm);
		if (!$ticket_rc) { 
			$tp->Block("SeatYJs");
			$tp->Block("SeatY");		
		}
		$tp->Mix();
		$tp->Display();
	
	}
	else {
		@$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; }
		
		$CODE = sprintf("%05d",$training_id) . Rand_Code();
		$sql = "
			INSERT INTO $db_table_training_register
			(TRAINING_ID,USER_ID,ACTIVE,CODE,TICKET,DATE_ADD) VALUES 
			('$training_id','$s_user_id','N','$CODE','$ticket',NOW())
		";
		mysql_query($sql);
		$intNewRecord = mysql_insert_id();
		
		#$sql = "UPDATE $db_table_training_ticket SET TICKET_RESERVE = 'Y' WHERE TICKET_NAME = '$ticket' AND TRAINING_ID = $training_id";
		#mysql_query($sql);

		
		$sql = "SELECT * FROM $db_table_training WHERE TRAINING_ID = '$training_id' AND TRAINING_ACTIVE = 'Y'";
		$result = mysql_query($sql);
		while($row = mysql_fetch_array($result)) {
			$training_code		=	$row[TRAINING_CODE];
			$training_topic		=	$row[TRAINING_TOPIC];
			$training_place		=	$row[TRAINING_PLACE];

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

			$strTrainingCost = GenTrainingCostAndIcon($row[TRAINING_COST],$row[TRAINING_COST2],$row[TRAINING_FREE],"Text");
			$strTrainingCostP = GenTrainingCostAndIcon($row[TRAINING_COST],$row[TRAINING_COST2],$row[TRAINING_FREE],"Text");
			$strTrainingCostP1 = GenTrainingCostAndIcon($row[TRAINING_COST],$row[TRAINING_COST2],$row[TRAINING_FREE],"Text");
			$intTrainingCostP = GenTrainingCostAndIcon($row[TRAINING_COST],$row[TRAINING_COST2],$row[TRAINING_FREE],"Number");
			$intTrainingCost = GenTrainingCostAndIcon($row[TRAINING_COST],$row[TRAINING_COST2],$row[TRAINING_FREE],"Number");
		}	
		mysql_free_result($result);

		
		$sql = "SELECT FNAME,LNAME,USERNAME,MOBILE1,MOBILE2 FROM $db_table_user WHERE ID = $s_user_id";
		$result = mysql_query($sql);
		while($row = mysql_fetch_array($result)) {
			$strUsername	=	$row[USERNAME];
			$strUserFname	=	$row[FNAME];
			$strUserLname 	=	$row[LNAME];
			$strUserMobile	=	$row[MOBILE1].$row[MOBILE2];
		}		
		mysql_free_result($result);


		$sql = "SELECT DATE_ADD FROM $db_table_training_register WHERE REGISTER_ID = $intNewRecord";
		$result = mysql_query($sql);
		while($row = mysql_fetch_array($result)) {
			$date_add	=	$row[DATE_ADD];
		}	
		mysql_free_result($result);


		mysql_close($db);
			

		$strRegistDate			=	Convert_YMDHMS_2_DMYHM($date_add);
		$strTrainingCostShow	=	Comify($intTrainingCost);
		$strTrainingCostPShow	=	$intTrainingCost*1.0275;
		$intTrainingCostAmount	=	$intTrainingCost*1.0275;
		$strTrainingCostP1Show	=	$intTrainingCost*0.0275;
		$strTransactionNo		=	GenTransactionNo($CODE);
		$strTransactionBarCode	=	GenBarcode($CODE);
		$strTrainingCostPText	=	num2thai($intTrainingCost*1.0275);
		$strTrainingCostText	=	num2thai($intTrainingCost);
		$user_id_for_barcode	=	sprintf("%09d",$s_user_id);
		$order_no				=	sprintf("%06d",$intNewRecord);
		$strPaySbuyDisabled		=	"";
		if ($intTrainingCost == 0) { 
			$strPaySbuyDisabled = "disabled";
		}


		$template = $tp_training_register_complete;
		$fp		=	fopen($template,"r"); 
		$HTML	=	fread($fp,filesize($template)); fclose($fp); 
		$HTML	=	preg_replace("/\\$(\w+)/e","$$1",$HTML); 
		echo $HTML;
		ob_end_flush();
		exit;
	}
}

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


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


?>
<?

function Rand_Code () {
	$str_rand	=	"";
	$input		=	array ("A","B","C","D","E","F","G","H","I","J","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
	$rand_keys	=	array_rand ($input, 5);
	for ($i=0;$i<=3;$i++) {
		$str_rand .= $input[$rand_keys[$i]];
	}
	return $str_rand;
}

?>