<?php



require("config.php");

class Meteo {
      public $winDayGustMin = null;
	  public $uv = null;
	  public $TempInMin = null;
	  public $cloud_base_altitude = null;
	  public $PressureMax = null;
	  public $UmOutMin = null;
	  public $wind_dir_ave = null;
	  public $hum_in = null;
	  public $temp_out = null;
	  public $winDayMin = null;
	  public $wind_chill = null;
	  public $UmOutMax = null;
	  public $temp_in = null;
	  public $illuminance = null;
	  public $abs_pressure = null;
	  public $rain_rate_24h = null;
	  public $winDayGustMax = null;
	  public $dew_point = null;
	  public $TempOutMin = null;
	  public $UmInMin = null;
	  public $winDayMax = null;
	  public $UmInMax = null;
	  public $rain_rate = null;
	  public $wind_ave = null;
	  public $rain = null;
	  public $rel_pressure = null;
	  public $last_measure_time = "";
	  public $wind_dir = null;
	  public $wind_dir_code = "";
	  public $hum_out = null;
	  public $wind_gust = null;
	  public $idx = "";
	  public $temp_apparent = null;
	  public $rain_rate_1h = null;
	  public $PressureMin = null;
	  public $TempInMax = null;
	  public $TempOutMax = null;
   }


$swpipwd1 = $_POST['pwd'];

if ($swpipwd1 != $swpipwd)
{
  die('Wrong password ');
}

//carica i valori nella classe Meteo.
$e = new Meteo(); 
$e->last_measure_time = $_POST['last_measure_time'];
$e->idx = $_POST['idx'];
$e->wind_dir_code = $_POST['wind_dir_code'];
$e->wind_dir = $_POST['wind_dir'];
$e->wind_ave = $_POST['wind_ave'];
$e->wind_gust = $_POST['wind_gust'];
$e->temp_out = $_POST['temp_out'];
$e->hum_out = $_POST['hum_out'];
$e->rel_pressure = $_POST['rel_pressure'];
$e->rain = $_POST['rain'];
$e->rain_rate = $_POST['rain_rate'];
$e->temp_in = $_POST['temp_in'];
$e->hum_in = $_POST['hum_in'];
$e->wind_chill = $_POST['wind_chill'];
$e->temp_apparent = $_POST['temp_apparent'];
$e->dew_point = $_POST['dew_point'];
$e->uv = $_POST['uv'];
$e->illuminance = $_POST['illuminance'];
$e->winDayMin = $_POST['winDayMin'];
$e->winDayMax = $_POST['winDayMax'];

$e->winDayGustMin  = $_POST['winDayGustMin'];  
$e->winDayGustMax = $_POST['winDayGustMax'];  
$e->TempOutMin = $_POST['TempOutMin'];  
$e->TempOutMax = $_POST['TempOutMax'];  
$e->TempInMin = $_POST['TempInMin'];  
$e->TempInMax = $_POST['TempInMax'];  
$e->UmOutMin = $_POST['UmOutMin'];  
$e->UmOutMax = $_POST['UmOutMax'];  
$e->UmInMin = $_POST['UmInMin'];  
$e->UmInMax = $_POST['UmInMax'];  
$e->PressureMin = $_POST['PressureMin'];  
$e->PressureMax = $_POST['PressureMax'];  
$e->wind_dir_ave = $_POST['wind_dir_ave'];  



// -- --------------------------------------------------------

// --
// -- Table structure for table `meteo`
// --

// CREATE TABLE IF NOT EXISTS `METEO` (
  // `TIMESTAMP_LOCAL` datetime NOT NULL,
  // `TIMESTAMP_IDX` datetime default NULL,
  // `WINDIR_CODE` text,
  // `WIND_DIR` smallint(6) default NULL,
  // `WIND_AVE` double default NULL,
  // `WIND_GUST` double default NULL,
  // `TEMP` double default NULL,
  // `PRESSURE` double default NULL,
  // `HUM` double default NULL,
  // `RAIN` double default NULL,
  // `RAIN_RATE` double default NULL,
  // `TEMPINT` double default NULL,
  // `HUMINT` double default NULL,
  // `WIND_CHILL` double default NULL,
  // `TEMP_APPARENT` double default NULL,
  // `DEW_POINT` double default NULL,
  // `UV_INDEX` double default NULL,
  // `SOLAR_RAD` double default NULL,
  // `WIND_DAY_MIN` double default NULL,
  // `WIND_DAY_MAX` double default NULL,
  // `WIND_DAY_GUST_MIN` double default NULL,
  // `WIND_DAY_GUST_MAX` double default NULL,
  // `TEMP_OUT_DAY_MIN` double default NULL,
  // `TEMP_OUT_DAY_MAX` double default NULL,
  // `TEMP_IN_DAY_MIN` double default NULL,
  // `TEMP_IN_DAY_MAX` double default NULL,
  // `HUM_OUT_DAY_MIN` double default NULL,
  // `HUM_OUT_DAY_MAX` double default NULL,
  // `HUM_IN_DAY_MIN` double default NULL,
  // `HUM_IN_DAY_MAX` double default NULL,
  // `PRESSURE_DAY_MIN` double default NULL,
  // `PRESSURE_DAY_MAX` double default NULL,
  // `WIND_DIR_AVE` double default NULL
// ) ENGINE=MyISAM DEFAULT CHARSET=latin1;


$con = mysql_connect($server,$user,$pwd);
mysql_select_db($db); 


if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("test", $con);


$sql1 = "INSERT INTO " . $dbprefix . "METEO (TIMESTAMP_LOCAL, TIMESTAMP_IDX, WINDIR_CODE, WIND_DIR, WIND_AVE, WIND_GUST, TEMP, PRESSURE, HUM, RAIN, RAIN_RATE, TEMPINT, HUMINT, WIND_CHILL, TEMP_APPARENT, DEW_POINT, UV_INDEX, SOLAR_RAD, WIND_DAY_MIN, WIND_DAY_MAX,WIND_DAY_GUST_MIN ,WIND_DAY_GUST_MAX ,TEMP_OUT_DAY_MIN ,TEMP_OUT_DAY_MAX,TEMP_IN_DAY_MIN ,TEMP_IN_DAY_MAX ,HUM_OUT_DAY_MIN ,HUM_OUT_DAY_MAX ,HUM_IN_DAY_MIN ,HUM_IN_DAY_MAX ,PRESSURE_DAY_MIN ,PRESSURE_DAY_MAX,WIND_DIR_AVE) VALUES ('".$e->last_measure_time."','".$e->idx."','".$e->wind_dir_code."',".$e->wind_dir.",".$e->wind_ave.",".$e->wind_gust.",".$e->temp_out.",".$e->rel_pressure.",".$e->hum_out.",".$e->rain.",".$e->rain_rate.",".$e->temp_in.",".$e->hum_in.",".$e->wind_chill.",".$e->temp_apparent.",".$e->dew_point.",".$e->uv.",".$e->illuminance.",".$e->winDayMin.",".$e->winDayMax.",".$e->winDayGustMin.",".$e->winDayGustMax.",".$e->TempOutMin.",".$e->TempOutMax.",".$e->TempInMin.",".$e->TempInMax.",".$e->UmOutMin.",".$e->UmOutMax.",".$e->UmInMin.",".$e->UmInMax.",".$e->PressureMin.",".$e->PressureMax.",".$e->wind_dir_ave." )";


$result1 = mysql_query($sql1) ; 

if (!$result1) {
	die("Errore nella query $query: " . mysql_error());
	//die("Errore nella query $query: " . $sql);

	}


mysql_close($con);

//codifica la classe in json.
$testo = json_encode($e);

//crea il file meteo.txt
try{
		$fp = fopen('meteo.txt', 'w'); 
		fwrite($fp, $testo); 
		fflush($fp); 
		fclose($fp); 
   }
	catch(Exception $var){
   }

echo 'OK';


class wugraphs {
	  public $uv = null;
	  public $hum_in = null;
	  public $temp_out = null;
	  public $temp_in = null;
	  public $illuminance = null;
	  public $winDayGustMax = null;
	  public $dew_point = null;
	  public $rain_rate = null;
	  public $wind_ave = null;
	  public $rain = null;
	  public $rel_pressure = null;
	  public $last_measure_time = "";
	  public $wind_dir = null;
	  public $hum_out = null;
	  public $wind_gust = null;
	  public $TempOutMin = null;
	  public $TempOutMax = null;
   }

$swpipwd1 = $_POST['pwd'];

if ($swpipwd1 != $swpipwd)
{
  die('Wrong password ');
}

//carica i valori nella classe wugraphs.
$e = new wugraphs(); 
$e->last_measure_time = $_POST['last_measure_time'];
$e->wind_dir = $_POST['wind_dir'];
$e->wind_ave = $_POST['wind_ave'];
$e->wind_gust = $_POST['wind_gust'];
$e->temp_out = $_POST['temp_out'];
$e->hum_out = $_POST['hum_out'];
$e->rel_pressure = $_POST['rel_pressure'];
$e->rain = $_POST['rain'];
$e->rain_rate = $_POST['rain_rate'];
$e->temp_in = $_POST['temp_in'];
$e->hum_in = $_POST['hum_in'];
$e->dew_point = $_POST['dew_point'];
$e->uv = $_POST['uv'];
$e->illuminance = $_POST['illuminance'];
 
$e->winDayGustMax = $_POST['winDayGustMax'];  
$e->TempOutMin = $_POST['TempOutMin'];  
$e->TempOutMax = $_POST['TempOutMax'];  

$con = mysql_connect($server,$user,$pwd);
mysql_select_db($db); 


if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("test", $con);

$sql2 = "INSERT INTO " . $dbprefix . "wugraphs (average_windspeed, wind_direction, gust_windspeed, temperature, outdoor_humidity, barometer, daily_rainfall, rain_rate, indoor_temperature, indoor_humidity, actual_solar_reading, max_daily_temperature, min_daily_temperature, max_gust_current_day, dew_point_temperature, datetime, davis_vp_uv) VALUES (".$e->wind_ave.",".$e->wind_dir.",".$e->wind_gust.",".$e->temp_out.",".$e->hum_out.",".$e->rel_pressure.",".$e->rain.",".$e->rain_rate.",".$e->temp_in.",".$e->illuminance.",".$e->TempOutMax.",".$e->TempOutMin.",".$e->winDayGustMax.",".$e->dew_point.",'".$e->last_measure_time."',".$e->uv." )";


$result2 = mysql_query($sql2) ; 

if (!$result2) {
	die("Errore nella query $query: " . mysql_error());
	//die("Errore nella query $query: " . $sql);

	}

mysql_close($con);

?>