<?php

ini_set('display_errors', '0');     # don't show any errors...
error_reporting(E_ALL | E_STRICT);

require_once 'MDB2.php';

$dsn = array(
	'phptype'  => 'pgsql',
	'username' => 'postgres',
	'password' => '',
	'hostspec' => 'localhost',
	'database' => 'exparo',
	'port'	   => '5432'
);

$options = array(
	'debug'       => 2,
	'portability' => MDB2_PORTABILITY_ALL,
);

$mdb2 =& MDB2::connect($dsn, $options);
if (PEAR::isError($mdb2)) {
	die($mdb2->getMessage());
}

$sql = 'SELECT * FROM exchange_rate ORDER BY register_date DESC LIMIT 1';
$rs  = $mdb2->query($sql);
$mdb2->disconnect();

$row = $rs->fetchRow(MDB2_FETCHMODE_OBJECT);

$ttb_rate = number_format((1+($row->standard_rate-$row->exch_rate)/$row->exch_rate)*$row->standard_rate,2);
$ttb_won = number_format(10000/((1+($row->standard_rate-$row->exch_rate)/$row->exch_rate)*$row->standard_rate),2);
$tts_won = number_format(10000/$row->exch_rate,2);
$tts_rate = number_format($row->exch_rate,2);
$exparo_rate = number_format($row->exparo_rate,2);
$exparo_won = number_format(10000/$row->exparo_rate,2);

$date = $row->register_date;

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Exparo Rate</title>
<style type="text/css">
.mdExRateBox01 {
	border: 1px solid #999;
	width: 180px;
}
.mdExRateTime01 {
	background-color:#282828;
	font-family: Arial;
	font-size:11px;
	color:#FFFFFF;
	text-align:right;
	padding: 2px 4px;
}
.mdExRateBox02 {
	font-family:Arial;
	font-size:11px;
	color:#000;
	background-color:#fbfaef;
	text-align:center;
}
.mdExRateBox03 {
	font-family:Arial;
	font-size:12px;
	color:#000;
}
.mdExRateBox03 td {
	padding: 3px 0;
}

.mdExRateTitleTTbTTs {
	font-family:Arial;
	font-size:12px;
	color:#000;
	font-weight:bold;
	text-align:right;
	width:54px;
}
.mdExRateTitleExparo {
	font-family:Arial;
	font-size:12px;
	color:#0b6b9e;
	font-weight:bold;
	text-align:right;
}
.mdExRateTTbTTs {
	font-family:Arial;
	font-size:12px;
	color:#000;
	text-align:center;
	background-color:#FFF;
	border: 1px solid #8b8a86;
	width: 55px;
}
.mdExRateExparo {
	font-family:Arial;
	font-size:12px;
	color:#000;
	text-align:center;
	background-color:#f2fefb;
	border: 1px solid #8b8a86;
	width: 55px;
}
.mdExRateExparoLogo {
	padding: 0 0 4px;
	vertical-align: middle;
	border: 0px;
}
</style>
</head>

<body>
<table border="0" cellspacing="0" cellpadding="0" class="mdExRateBox01">
  <tr>
    <td><img src="todayExRateTitle.gif" width="178" height="29" /></td>
  </tr>
  <tr>
    <td class="mdExRateTime01"><?php echo substr($date,0,4).'/'.substr($date,4,2).'/'.substr($date,6,2).' '.substr($date,8,2).':'.substr($date,10,2); ?></td>
  </tr>
  <tr>
    <td class="mdExRateBox02"><table border="0" cellspacing="2" cellpadding="0" class="mdExRateBox03">
      <tr>
        <td>&nbsp;</td>
        <td><b>100</b> <span style="font-size:10px;">WON</span></td>
        <td><b>100</b> <span style="font-size:10px;">YEN</span></td>
      </tr>
      <tr>
        <td class="mdExRateTitleTTbTTs">TTB</td>
        <td class="mdExRateTTbTTs"><?php echo $ttb_won; ?></td>
        <td class="mdExRateTTbTTs"><?php echo $ttb_rate; ?></td>
      </tr>
      <tr>
        <td class="mdExRateTitleTTbTTs">TTS</td>
        <td class="mdExRateTTbTTs"><?php echo $tts_won; ?></td>
        <td class="mdExRateTTbTTs"><?php echo $tts_rate; ?></td>
      </tr>
      <tr>
        <td class="mdExRateTitleExparo">EXPARO</td>
        <td class="mdExRateExparo"><?php echo $exparo_won; ?></td>
        <td class="mdExRateExparo"><?php echo $exparo_rate; ?></td>
      </tr>
    </table></td>
  </tr>
  <tr>
  <td class="mdExRateBox02">提供：韓国送金<a href="http://www.exparo.com/" target="_blank"><img src="todayExRateEXPAROlogo.gif" width="95" height="20" class="mdExRateExparoLogo" /></a></td>
</tr>
</table>


</body>
</html>
