<?php
//===============================================
//	CommonUtilities
//	備考		：	
//	更新		：	2012/11/29 KMK-Teraoka
//===============================================
$SCRIPT_TITLE = "運行管理システム　新門司";
$PENTA_OCEAN = "五洋建設株式会社";
$TAIL_PENTA_OCEAN = "penta-ocean";

$HOST = "192.168.100.153";
$DB = "cnbs";
$USER = "postgres";
$PASS = "am#71ZJ*";

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2012/11/29 KMK-Teraoka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");
if (!$conn)
{
	throw new Exception("データベースへの接続に失敗しました");
}

extract($_GET);

$Range_ = $_GET['range'];



$time_ = time();
//$time_ = strtotime("2015-02-10 05:00:00");
$start_date = date("Y-m-d H:i:s",$time_ - $Range_);
$end_date = date("Y-m-d H:i:s",$time_);


//$sql = "SELECT * FROM shinmoji.wg_avg WHERE regdate < '" .$test_date ."'" ." ORDER BY regdate desc limit 1;";
$sql = "SELECT * FROM shinmoji.wg_avg2 WHERE regdate > '" .$start_date ."' AND regdate <= '" .$end_date ."' ORDER BY regdate;";
$res = pg_query($conn,$sql)or die("SQL ERROR!!<br />". $sql.pg_last_error());
$DataCt = pg_num_rows($res);
$WriteData = "";

//print $sql ."<BR>";
//print $DataCt ."<BR>";

for($i = 0;$i < $DataCt;$i++)
{
	$row = pg_fetch_array($res,$i);
	
	$UnixTime = strtotime($row[7]);
	$WriteData .= $row[1] ."," .$row[2] ."," .$row[3] ."," .$row[4] ."," .$row[5] ."," .$row[6] ."," .$UnixTime .",";
}

print $WriteData ;

//$fp = fopen("/www/shinmoji/wg/graph/data.csv","w");
//fwrite($fp,  $WriteData);
//fclose($fp);



/*
$row = pg_fetch_array($res,0);
//$Data = number_format($row['avg_3s'], 2, '.', '');
$Data = ($row['avg_3s'] -1000-200) / 2;
$Data = number_format($Data, 2, '.', '');
$Date_ = $row['regdate'];
*/








//===============================================
//	Postgresql終了処理
//	備考		：	
//	更新		：	2012/10/19 KMK-Teraoka
//===============================================
pg_close($conn);

//===============================================
//	HTML終了処理
//	備考		：	
//	更新		：	2012/10/18 KMK-Teraoka
//===============================================
//print "</body>";
//print "</html>";

?>
