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

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/SiXhEaD.Template.php";
require_once "../../../module/SiXhEaD.SplitPage.php";

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

$tp_debenture_info	=	"_tp_debenture_info.html";

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

$strCurrentLangauge	=	"Th";
$Menu		=	4;
$SubMenu	=	5;

/*------------------------------------------------------------------*/
/*- Request --------------------------------------------------------*/
$ReqDebentureId	=	$_REQUEST[DebentureId];


/*------------------------------------------------------------------*/
/*- Program --------------------------------------------------------*/
if(!$ReqDebentureId){exit();}
$tp = new Template($tp_debenture_info);

$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");

//-- แสดงรายการ Debenture Quotation
$strSql = "SELECT * FROM $strCfgDbTableDebenture WHERE DebentureId = $ReqDebentureId AND GroupId = 1 AND Active='Y' LIMIT 1";
$objResult = mysql_query($strSql);
if (!$objResult) { echo "$strSqlChangeMe"; die("Invalid query: " . "" /*mysql_error()*/); }

while($row = mysql_fetch_array($objResult)) {
		$DebentureId						=	$row[DebentureId];
		$GroupId								=	$row[GroupId];
		$DueYear								=	$row[DueYear];

		$IssueDate							=	$row[IssueDate];
		$Bd										=	getDay($IssueDate); 
		$Bm										=	monthName(getMonth($IssueDate),$strLang="TH",$strShortFormat="N");
		$By										=	getYear($IssueDate);
		$ShowIssueDate					=	$Bm." ".$Bd.",".$By;

		$ShowDebentureName			=	$row[Debenture.$strCurrentLangauge];
		$ShowDebentureNo				=	$row[DebentureNo.$strCurrentLangauge];
		$ShowSecurity						=	$row[Security.$strCurrentLangauge];
		$ShowMarturity						=	$row[Marturity.$strCurrentLangauge];
		$ShowOfferPrice						=	$row[OfferPrice.$strCurrentLangauge];
		$ShowInterestPrice				=	$row[InterestPrice.$strCurrentLangauge];
		$ShowInterestPaymentDate	=	$row[InterestPaymentDate.$strCurrentLangauge];
		$ShowTypeOfIssue					=	$row[TypeOfIssue.$strCurrentLangauge];
		$ShowTotalIssueAmount			=	$row[TotalIssueAmount.$strCurrentLangauge];
		$ShowJointLeadManager			=	$row[JointLeadManager.$strCurrentLangauge];
		$ShowDebReg						=	$row[DebReg.$strCurrentLangauge];
		$ShowDebHolRep					=	$row[DebHolRep.$strCurrentLangauge];
}


$tp->Display();
exit;

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