Waterloo Atmospheric Observatory
\n";
# Date Selector
print "\nDate Range: | \n";
print "\n";
# Use yesterday as default date
if ( !isset($_POST[e_date_yy]) ) {
$today = getdate( strtotime("Yesterday") );
$_POST[s_date_yy] = sprintf( "%4d", $today['year']);
$_POST[s_date_mm] = sprintf( "%02d", $today['mon']);
$_POST[s_date_dd] = sprintf( "%02d", $today['mday']);
$_POST[s_time] = "00:00:00";
$today = getdate( strtotime("Today") );
$_POST[e_date_yy] = sprintf( "%4d", $today['year']);
$_POST[e_date_mm] = sprintf( "%02d", $today['mon']);
$_POST[e_date_dd] = sprintf( "%02d", $today['mday']);
$_POST[e_time] = "00:00:00";
}
print "-\n";
print "-\n";
print "\n";
print "\n";
print " through ";
print "-\n";
print "-\n";
print "\n";
print "\n";
#print " (YYYY-MM-DD [HH:MM:SS])\n";
print " |
\n";
print "\n";
print " | \n";
print " |
\n";
if ( isset($_POST["submit"]) ) {
$SQL_S_DATE = "$_POST[s_date_yy]-$_POST[s_date_mm]-$_POST[s_date_dd] $_POST[s_time]";
$SQL_E_DATE = "$_POST[e_date_yy]-$_POST[e_date_mm]-$_POST[e_date_dd] $_POST[e_time]";
$sql_query = "SELECT date, temp, humidity, wind_speed, wind_direction, barometric_pressure, solar_radiation FROM hourly_data WHERE date BETWEEN '$SQL_S_DATE' AND '$SQL_E_DATE';";
//print $sql_query;
$result = pg_Exec($conn, $sql_query);
$date = [];
$temp = [];
$humidity = [];
$wind_sp = [];
$wind_dir = [];
$bar_pres = [];
$solar_rad = [];
while ($row = pg_fetch_row($result)) {
array_push($date,$row[0]);
array_push($temp,$row[1]);
array_push($humidity,$row[2]);
array_push($wind_sp,$row[3]);
array_push($wind_dir,$row[4]);
array_push($bar_pres,$row[5]);
array_push($solar_rad,$row[6]);
}
echo "\n";
//print_r($temp);
echo exec("/home/sjones/weather_station/weather_plot_select.py '".$SQL_S_DATE."' '".$SQL_E_DATE."' '".json_encode($temp)."' '".json_encode($humidity)."' '".json_encode($wind_sp)."' '".json_encode($wind_dir)."' '".json_encode($bar_pres)."' '".json_encode($solar_rad)."' 2>&1\n", $output, $ret );
//var_dump($output,$ret);
echo "
\n";
echo "";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
} else {
echo "\n";
echo exec("/home/sjones/weather_station/weather_plot.py 2>&1\n", $output, $ret);
//var_dump($output,$ret);
echo "
\n";
echo "";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
}
pg_close($conn);
?>