<?php
require $_SERVER["DOCUMENT_ROOT"] . "/world_config.php";
require $_SERVER["DOCUMENT_ROOT"] . "/datamart/geoFunctions.php";
header("Content-type: text/plain");

$station_id=strtoupper($_REQUEST["station_id"]);
$db=_open_mysql("windData");

/* format of temporary table */
$tableFormat[]="packet_date datetime";
$tableFormat[]="packet_time int";

$tableFormat[]="ws0Average double";
$tableFormat[]="wc0Sum int";
$tableFormat[]="wg0Average double";

$tableFormat[]="ws1Average double";
$tableFormat[]="wg1Average double";
$tableFormat[]="wc1Sum int";

$tableFormat[]="ws2Average double";
$tableFormat[]="wg2Average double";
$tableFormat[]="wc2Sum int";

$tableFormat[]="adc0Average int";
$tableFormat[]="adc1Average int";
$tableFormat[]="adc2Average int";
$tableFormat[]="adc3Average int";
$tableFormat[]="adc4Average int";
$tableFormat[]="adc5Average int";
$tableFormat[]="adc6Average int";
$tableFormat[]="adc7Average int";

/* create our temporary table */
$tname=uniqid("tempData_");
$csql=sprintf("CREATE TABLE windDataTemp.%s (",$tname);
$csql.=implode(", ",$tableFormat);
$csql.=")";
mysql_query($csql,$db);

echo $csql;


$sql="";
$sql=sprintf("INSERT INTO windDataTemp.%s ",$tname);
$sql.=sprintf("SELECT LEFT(packet_date,16) AS dayHourMinute,UNIX_TIMESTAMP(LEFT(packet_date,16)) AS dayHourMinuteTime, ");


/* wind / counter channels */
for ( $i=0 ; $i<3 ; $i++ ) {
	$sql.=sprintf("ROUND(AVG(ws%d),1) AS ws%dAverage, ",$i,$i);
	$sql.=sprintf("ROUND(AVG(wg%d),1) AS wg%dAverage, ",$i,$i);
	$sql.=sprintf("ROUND(AVG(wc%d),0) AS wc%dAverage, ",$i,$i);
}

/* analog channels */
for ( $i=0 ; $i<8 ; $i++ ) {
	$sql.=sprintf("ROUND(AVG(adc%d),0) AS adc%dAverage, ",$i,$i);
}
/* get rid of the last comma */
$sql=substr($sql,0,strlen($sql)-2);

$sql.=sprintf(" FROM data WHERE station_id='%s' AND packet_date >= DATE_SUB(now(),INTERVAL 1 DAY) GROUP BY LEFT(packet_date,16) ORDER BY dayHourMinute",$station_id);
//echo($sql);
$query=mysql_query($sql,$db);

while ( $r=mysql_fetch_array($query) ) {
	print_r($r);
}

?>