<?
/*------------------------------------------------------------------*/
/*------------------------------------------------------------------*/
/*------------------------------------------------------------------*/
/*

Program     : 
Description : 
Programmer  : ไชยรัตน์  สุนทรวิภาต

Individual
Email       : pipo@sixhead.com
Website     : http://www.sixhead.com
            : http://www.todaysoftware.com

Office
Email       : pipo@digithais.com
Website     : http://www.digithais.com

Date        : 
Modify log  : 

*/
/*------------------------------------------------------------------*/
/*- Require --------------------------------------------------------*/

require_once "../module/_config.php";
require_once "../module/_module.php";
require_once "../module/_module_control.php";
require_once "../module/SiXhEaD.Template.php";
require_once "../module/SiXhEaD.SplitPage.php";

/*------------------------------------------------------------------*/
/*- Template -------------------------------------------------------*/

$tp_index		=	"_tp_index.html";

/*------------------------------------------------------------------*/
/*- Config & Misc --------------------------------------------------*/


/*------------------------------------------------------------------*/
/*- Request --------------------------------------------------------*/

$cDefaultTabMenu	=	$_COOKIE[cDefaultTabMenu];
$strCurrentLangauge	=	"En";

/*------------------------------------------------------------------*/
/*- Program --------------------------------------------------------*/


if (!$cDefaultTabMenu) { 
	$cDefaultTabMenu	=	"m01";
}

if ($cDefaultTabMenu == "m01") { 
	$strDefaultTab1		=	"m01_b.gif";
	$strDefaultTab2		=	"m02.gif";
}
else if ($cDefaultTabMenu == "m02") { 
	$strDefaultTab1		=	"m01.gif";
	$strDefaultTab2		=	"m02_b.gif";
}


$tp = new Template($tp_index);


$objDb = mysql_connect($strCfgDbHost,$strCfgDbUser,$strCfgDbPass); 
mysql_select_db($strCfgDbName);
if (!$objDb) { die('Could not connect: ' . mysql_error()); }
mysql_query("SET NAMES TIS620");
mysql_query("SET character_set_results=tis620");


$NewsTypes = array("News","IrNews");
foreach ($NewsTypes as $NewsType) { 
	$NewsTypeLower	=	strtolower($NewsType);
	$strCurrentLangaugeLower	=	strtolower($strCurrentLangauge);

	#if ($NewsType == "News") { 
	#	$strNewsUrlMain	=	"$strCfgMainUrl/$strCurrentLangaugeLower/08news_release/01_news/detail.php?ContentId=";
	#}
	#else if ($NewsType == "IrNews") { 
	#	$strNewsUrlMain	=	"$strCfgMainUrl/$strCurrentLangaugeLower/04investor_governance/03_investors_news/detail.php?ContentId=";
	#}

	$tp->Block("$NewsType");
	$strSql = "SELECT ContentId,UrlEn,TitleTh,TitleEn,DetailTh,DetailEn,ContentDate FROM $strCfgDbTable$NewsTypeLower WHERE IsLocal = 'N' AND Active = 'Y' AND IsHighLight ='Y' AND  Title$strCurrentLangauge != '' ORDER BY ContentDate DESC, ContentId DESC LIMIT 0,4";
	$objResult = mysql_query($strSql);
	if (!$objResult) { echo "$strSql"; die("\n Invalid query: " . mysql_error()); }
	while($row = mysql_fetch_array($objResult)) {
		$ContentId			=	$row[ContentId];
		$Title				=	$row["Title$strCurrentLangauge"];
		$Detail				=	$row["Detail$strCurrentLangauge"];
		$ContentDate		=	$row[ContentDate];

		$UrlEn				=	$row["UrlEn"];

		//-- Create Link
		if ($UrlEn) { 
			$LinkIrNews=$UrlEn;
		}
		else {
			$LinkIrNews="04investor_governance/03_investors_news/detail.php?ContentId=$ContentId";
		}

		$ContentDateShow	=	formatDateTimeString($ContentDate,$strCurrentLangauge);
		$tp->Apply();
	}
	mysql_free_result($objResult);
}


mysql_close($objDb);


$tp->Display();
exit;

/*------------------------------------------------------------------*/
?>