<?php
/////////////////////////////////////////////////////////////////////////////////////	
//最新データのパス(DBへINSERT用)

$HOST = "192.168.100.153";
$DB = "shimooguni";
$USER = "postgres";
$PASS = "postgres";

$DATA_TABLE = "weather.data_log";
$DATA_TABLE_1H = "weather.data_log_1h";
$DATA_TABLE_DAY = "weather.data_log_day";
$DATA_TABLE_WEEK = "weather.data_log_week";
$DATA_TABLE_MONTH = "weather.data_log_month";
$DATA_TABLE_NEW = "weather.data_log_new";

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2013/03/12 KMK-Yokosuka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");


//////////////最新データの出力
$now_date = time();
$date_sel_start  = date("Y-m-d",$now_date-600);
$time_sel_start  = date("H:i:s",$now_date-600);


//風速
//最大瞬間風速(日)
$sel_wv_max = "SELECT * FROM " .$DATA_TABLE_DAY ." WHERE data7=(SELECT max(data7) FROM " .$DATA_TABLE_DAY .") ORDER BY data1 limit 1";
$res_wv_max = pg_query($conn,$sel_wv_max);
$row_wv_max = pg_fetch_array($res_wv_max,0);
$wv_max = number_format($row_wv_max[7],1,".","");
$wv_max_time = $row_wv_max[1];

//10分間平均風速(移動平均)
$sel_wv_avg = "SELECT avg(data7) FROM ".$DATA_TABLE ." WHERE date >= '" .$date_sel_start ."' AND data1 >= '" .$time_sel_start ."'";
$res_wv_avg = pg_query($conn,$sel_wv_avg);
$row_wv_avg = pg_fetch_array($res_wv_avg,0);
$wv_avg = number_format($row_wv_avg[0],1,".","");


//降雨量関係
$sel_1h = "SELECT sum(data9) FROM " .$DATA_TABLE_1H;
$sel_day = "SELECT sum(data9) FROM " .$DATA_TABLE_DAY;
$sel_month = "SELECT sum(data9) FROM " .$DATA_TABLE_MONTH;
$sel_all = "SELECT sum(data9) FROM " .$DATA_TABLE;

$res_1h = pg_query($conn,$sel_1h);
$res_day = pg_query($conn,$sel_day);
$res_month = pg_query($conn,$sel_month);
$res_all = pg_query($conn,$sel_all);

$row_1h = pg_fetch_array($res_1h,0);
$row_day = pg_fetch_array($res_day,0);
$row_month = pg_fetch_array($res_month,0);
$row_all = pg_fetch_array($res_all,0);

$rain_1h = number_format($row_1h[0],2,".","");
$rain_day = number_format($row_day[0],2,".","");
$rain_month = number_format($row_month[0],2,".","");
$rain_all = number_format($row_all[0],2,".","");

$fp_wv_data = fopen("/www/shimooguni/recv/new_wv_data.txt", "w");
$fp_rain_data = fopen("/www/shimooguni/recv/new_rain_data.txt", "w");


fwrite($fp_wv_data,$wv_max_time ."," .$wv_max ."," .$wv_avg);
fwrite($fp_rain_data,$rain_1h ."," .$rain_day ."," .$rain_month ."," .$rain_all);


fclose($fp_wv_data);
fclose($fp_rain_data);


?>